Nach Markierungen suchen

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

MemOptimized RowStore in Oracle Database 18c with OCI

On June, 10 2018 I blogged about the MemOptimized RowStore in Oracle Database 18c. If you haven’t read this post, it is a good idea to […] ...read more...( read more ) Mehr…

Veröffentlicht 19 Jun 2018 21:34 von triBLOG

Gespeichert unter: SQL, Oracle, java

Adaptive Plans at Kscope Community Service Day

Since Oracle 12c, the query optimizer is able to change execution plans at runtime. This feature is called “Adaptive Plans”. Something similar happened on the ODTUG Community Service Day at the Kscope conference in Orlando. The ODTUG Community Service...

Veröffentlicht 14 Jun 2018 22:51 von triBLOG

Gespeichert unter: Oracle, Performance, conferences, Oracle 12c

MemOptimized RowStore in Oracle Database 18c

The MemOptimized RowStore introduced in Oracle Database 18c is designed to improve performance of simple queries accessing data via primary key columns only. An example of […] ...read more...( read more ) Mehr…

Veröffentlicht 10 Jun 2018 1:40 von triBLOG

Gespeichert unter: SQL, Oracle, PL/SQL, Oracle 18c, SmartDB

Playing with statistics modification hints

How often did you have the situation when performance problem disappeared just after refreshing object statistics? Of course it is nice to solve the problem quickly and simply, but is always better to understand what has exactly happened. Recently I had...

Veröffentlicht 7 Jun 2018 9:00 von triBLOG

Gespeichert unter: Oracle, Performance, hints, optimizer, statistics, execution plan

Online Statistics Gathering for ETL – Part 2

In the first part we looked at general preconditions for online statistics gathering to work and some restrictions. In this part we’ll take a look at what happens with direct path loads into partitioned tables. Partitioning There are also some points...

Veröffentlicht 29 Mai 2018 21:28 von triBLOG

Gespeichert unter: Oracle, Trivadis, ETL, Partitioning, Data Warehouse, 12c, CBO, statistiken, bulk load

Online Statistics Gathering for ETL – Part 1

Online Statistics Gathering has been introduced in 12c and is a very handy feature for ETL and batch jobs developers. However the devil is in the detail. There are some points to remember. Let’s take a closer look. Introduction If you are not familiar...

Veröffentlicht 29 Mai 2018 21:27 von triBLOG

Gespeichert unter: Oracle, Trivadis, ETL, Data Warehouse, 12c, CBO, Merge, statistiken, on the fly, bulk insert

Using Temporary Tables for Complex Reports

Global temporary tables (or private temporary tables, if you use Oracle 18c) are a practical feature to be used for SQL queries with multiple steps, for example complex reports in a data warehouse. If you want to use them, some … Continue reading...

Veröffentlicht 15 Mai 2018 23:40 von triBLOG

Gespeichert unter: SQL, Oracle, Performance, ETL, DWH Architecture

Blogs

Sponsored by

Syndication

Recent Posts

Tags

Archives