SharePoint Mirror » Alle Tags » Oracle (RSS)

Nach Markierungen suchen

Blogs

SharePoint Mirror

Home

Syndication

RSS
Atom
Kommentar-RSS
E-Mail-Aktualisierungen empfangen
Abonnieren

Archives

Migrating from Windows to Linux with Active Duplicate for standby – problem with 11.2.0.4

Recently I was working on migrating Oracle 11.2.0.4 database running on Windows, to new hardware infrastructure on Linux. This Oracle version is with us for quite a long time, plus migration from Windows to Linux is quite common (fortunately in that direction…;...

Veröffentlicht 11 Okt 2018 8:30 von triBLOG

Gespeichert unter: Windows, linux, Migration, Oracle, Troubleshooting, Data Guard, RMAN, active duplicate, standby
Regular Expressions in SQL by Examples

Are you reluctant to use regular expressions in SQL? Then continue reading. Examples helped me to understand regular expressions years ago. Thus I hope this collection […] The post Regular Expressions in SQL by Examples appeared first on Philipp Salvisberg's...

Veröffentlicht 28 Sep 2018 16:28 von triBLOG

Gespeichert unter: SQL, Oracle
Star Schema Optimization in Autonomous Data Warehouse Cloud

Oracle Autonomous Data Warehouse Cloud does not allow to create indexes. Is this a problem for star schemas because no Star Transformation can be used? Or are the required bitmap indexes automatically created? A look under the hood of ADWC. … Continue...

Veröffentlicht 13 Sep 2018 18:03 von triBLOG

Gespeichert unter: Oracle, Cloud, Performance, in-memory, Dimensional Modeling, ADWC
SmartDB as of 2018-08-21

Introduction This is a transcription of the recorded Ask TOM #SmartDB Office Hours from August, 21 2018, where Bryn Llewellyn presented an updated, narrow definition of […] The post SmartDB as of 2018-08-21 appeared first on Philipp Salvisberg's...

Veröffentlicht 28 Aug 2018 22:36 von triBLOG

Gespeichert unter: Oracle, SmartDB
SmartDB as of 2018-06-12

This is a transcription of Bryn Llewellyn’s talk Guarding Your Data Behind a Hard Shell PL/SQL API—the Detail recorded at Kscope18. It covers the time between 08:06 to […] The post SmartDB as of 2018-06-12 appeared first on Philipp Salvisberg's...

Veröffentlicht 28 Aug 2018 22:35 von triBLOG

Gespeichert unter: Oracle, SmartDB
Use Database as Persistence Layer Only

Using the database as persistence layer only is an anti-pattern. Praful Todkar applies this anti-pattern in How to extract a data-rich service from a monolith. Martin […] The post Use Database as Persistence Layer Only appeared first on Philipp Salvisberg's...

Veröffentlicht 25 Aug 2018 16:57 von triBLOG

Gespeichert unter: SQL, Oracle, SmartDB, PinkDB
Polymorphic Table Functions (PTF) , Part 1 – Basics

I have already posted some examples on Polymorphic Table Functions in Oracle 18c in the last months. I quickly realized how difficult it is to explain completely new feature using advanced examples and wanted to write a series of posts starting from very...

Veröffentlicht 19 Aug 2018 23:28 von triBLOG

Gespeichert unter: SQL, Oracle, Trivadis, PL/SQL, PTF, 18c, polymorphic table function
View-API for JOOQ Application

In this blog post I show how to build a read-only view-API for Oracle’s HR sample schema. And I will use this view-API in a JOOQ application. This […] The post View-API for JOOQ Application appeared first on Philipp Salvisberg's Blog . ...read...

Veröffentlicht 5 Aug 2018 22:34 von triBLOG

Gespeichert unter: Oracle, PL/SQL, Oracle 12c, jOOQ, oddgen, PinkDB
Why Pink?

PinkDB is an acronym for “processing in knowing database”. In this blog post I tell you how I came up with the acronym and its meaning. […] The post Why Pink? appeared first on Philipp Salvisberg's Blog . ...read more...( read more )...

Veröffentlicht 23 Jul 2018 1:11 von triBLOG

Gespeichert unter: Oracle, PinkDB
10 Tips to Improve ETL Performance – Revised for ADWC

The Autonomous Data Warehouse Cloud (ADWC) is a self-configuring, fast, secure and scalable platform for data warehouses. Does this mean we don’t have to take care anymore about performance of our ETL processes? Which performance tips are still important...

Veröffentlicht 20 Jul 2018 15:29 von triBLOG

Gespeichert unter: SQL, Oracle, Cloud, Performance, ETL, ADWC
The Pink Database Paradigm (PinkDB)

1. Introduction The Pink Database paradigm (PinkDB) is an application architecture for database centric applications. It is focusing on relational database systems and is vendor neutral. […] The post The Pink Database Paradigm (PinkDB) appeared first...

Veröffentlicht 18 Jul 2018 19:53 von triBLOG

Gespeichert unter: SQL Server, SQL, Oracle, PL/SQL, MySQL, postgresql, Oracle 18c, SmartDB, PinkDB, Teradata, HSQL, EnterpriseDB, MariaDB, Db2
Is Your Application SmartDB?

I had recently a few discussions regarding the Smart Database Paradigm (SmartDB) with long-standing customers, new customers, partners, competitors and colleagues. Some people think that using […] ...read more...( read more ) Mehr…

Veröffentlicht 18 Jul 2018 19:52 von triBLOG

Gespeichert unter: SQL, Oracle, PL/SQL, Oracle 12cR2, SmartDB, phs
Gathering Statistics in the Autonomous Data Warehouse Cloud

Optimizer statistics are essential for good execution plans and fast performance of the SQL queries. Of course, this is also the case in the Autonomous Data Warehouse Cloud. But the handling of gathering statistics is slightly different from what we …...

Veröffentlicht 11 Jul 2018 17:46 von triBLOG

Gespeichert unter: Oracle, Cloud, Performance, ETL, ADWC
Bloom filters and parallel execution

Today I want to share with you another interesting example of solving performance problem which happened in the database used for Business Intelligence purposes. Users were complaining that the performance in kind of staging database (STGDB) was much...

Veröffentlicht 5 Jul 2018 15:10 von triBLOG

Gespeichert unter: Oracle, Troubleshooting, Performance, optimizer, statistics, Parallel Processing, dynamic sampling, parsing, bloom filter
External Tables in Autonomous Data Warehouse Cloud

In Oracle Autonomous Data Warehouse Cloud, External Tables can be used to read files from the cloud-based Object Storage. But take care to do it the official way, otherwise you will see a surprise, but no data. Together with my … Continue reading...

Veröffentlicht 4 Jul 2018 23:29 von triBLOG

Gespeichert unter: Oracle, Cloud, ETL, Oracle 18c, ADWC

1 2 3 4 5 Weiter > ... Letzte »

CC BY-NC-ND - Michael Greth

Mit Community Server (Commercial Edition), von Telligent Systems

3DZL:andrewbelon.com

Datenschutzerklärung

Nach Markierungen suchen

Blogs

Sponsored by

Syndication

Recent Posts

Tags

Archives

Migrating from Windows to Linux with Active Duplicate for standby – problem with 11.2.0.4

Regular Expressions in SQL by Examples

Star Schema Optimization in Autonomous Data Warehouse Cloud

SmartDB as of 2018-08-21

SmartDB as of 2018-06-12

Use Database as Persistence Layer Only

Polymorphic Table Functions (PTF) , Part 1 – Basics

View-API for JOOQ Application

Why Pink?

10 Tips to Improve ETL Performance – Revised for ADWC

The Pink Database Paradigm (PinkDB)

Is Your Application SmartDB?

Gathering Statistics in the Autonomous Data Warehouse Cloud

Bloom filters and parallel execution

External Tables in Autonomous Data Warehouse Cloud