Oracle’s new JOIN TO ONE syntax offers several benefits for queries in star schemas. Let’s take a look at some typical use cases involving facts and dimensions, and see how the new join option can …

The new JOIN TO ONE syntax extension seems to be very useful for queries on star schemas. But before we can use it, we have to prove how they can be combined with different types of constraint defi…

The new JOIN TO ONE syntax extension seems to be very useful for queries on star schemas. But before we can use it, we have to prove how they can be combined with different types of constraint defi…

In the latest version of the Oracle database, it is now possible to define the partition key of a partitioned table using an expression. This was already possible previously, but only with a small …

In the last part of this blog series, we will look at how to load Slowly Changing Dimension (type SCD1 and SCD2) from the Current Views we created in our multi-temporal Data Vault schema.

Loading multi-temporal data into Data Vault is quite simple, a explained in the previous blog post of this series. But how can we extract the current data in a simple and convenient way to populate…

Data change tracking is a key concept in any data warehouse and many other analytical systems. Rather than explaining the same concepts over and over again, I decided to write a blog series on this…

Oracle 23c has a lot of small, but useful enhancements that makes life of developers easier. For example two new columns in the data dictionary views for partition metadata.

Welcome to the POUG - a vibrant, one-of-a-kind community based in Poland that gathers people from all over the world. Once a POUGer, always a POUGer! ...

Filtering analytic functions was not straight-forward in Oracle and most other databases. Oracle 26ai now supports the QUALIFY clause in SQL. It works like a WHERE condition, but can be used for an…

Oracle AI Database 26ai Enterprise Edition is now generally available for Linux x86-64. You can download it from the usual places, such as the Oracle Database download page, Software Delivery Cloud (eDelivery), and My Oracle Support (the RU). Check out the Oracle AI Database New Features Guide to see all the new features that came in this release. …

For more information on what’s new in Oracle Database 23.9, see: What’s new for Developers in Oracle Database 23.9 Oracle AI Database 23.26.0 brings some fantastic new features to developers—again!…

The data type of primary key and foreign key columns has an impact on the query performance. This should be considered in the design decision of keys in a Data Vault schema.

Filtering analytic functions was not straight-forward in Oracle and most other databases. Oracle 26ai now supports the QUALIFY clause in SQL. It works like a WHERE condition, but can be used for an…