Dani Schnider
@danischnider.bsky.social
Oracle Databases, Data Warehousing, SQL Performance Tuning, Oracle ACE Director. Craft Beer Brewing, Beer Sommelier.
If you want to know how the new JOIN TO ONE syntax can help to reduce complexity of SQL queries and avoid incorrect results in star schemas, read my lastest blog post: danischnider.wordpress.com/2026/07/18/j...
JOIN TO ONE and Star Schemas
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 …
danischnider.wordpress.com
Detect unwanted join duplicates in Oracle AI Database with t1 JOIN TO ONE ( t2 ) This uses foreign keys to define the join But what if the constraints are DISABLE or NOVALIDATE? @danischnider.bsky.social shows it runs but has performance implications
JOIN TO ONE and Constraints
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…
buff.ly
How the new JOIN TO ONE syntax extension of Oracle 26ai works with enabled and disabled constraints. Read my newest blog post: danischnider.wordpress.com/2026/06/30/j...
JOIN TO ONE and Constraints
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…
danischnider.wordpress.com
Oracle AI Database 23.26.1 added partition by expression support => you can use an expression directly instead of a column e.g. by email top-level domains with PARTITION BY LIST ( REGEXP_SUBSTR ( email_address, '[^.]+$' ) ) @danischnider.bsky.social demos
Partition by Expression
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 …
buff.ly
Last part of my blog series about Implementing Multi-Temporality with Data Vault danischnider.wordpress.com/2026/05/16/i...
Implementing Multi-Temporality with Data Vault (Part 3)
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.
danischnider.wordpress.com
Part 2 of my blog series about Implementing Multi-Temporality with Data Vault danischnider.wordpress.com/2026/05/08/i...
Implementing Multi-Temporality with Data Vault (Part 2)
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…
danischnider.wordpress.com
Part 1 of my new blog series: Implementing Multi-Temporality with Data Vault danischnider.wordpress.com/2026/05/05/i...
Implementing Multi-Temporality with Data Vault (Part 1)
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…
danischnider.wordpress.com
New blog post: Playing around with Calendar Functions in Oracle 26ai danischnider.wordpress.com/2026/04/12/p...
Sometimes its the small changes that make the big difference Oracle AI Database 26ai added HIGH_VALUE_CLOB HIGH_VALUE_JSON To the partitioning dictionary views => it's easier to query partition boundaries @danischnider.bsky.social discusses
Enhanced Partitioning Metadata in Oracle 23c
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.
buff.ly
#OracleBeerBern meetup in Berne. The speaker comes from far away, but the beer is local. Welcome in Switzerland, @connormcd.bsky.social 🇨🇭🍺
Just submitted a nerdy session for #POUG2026: How I build my own database system in my first job. Call for Speakers is still open for another 14 days: sessionize.com/poug-2026 Hope to see you in Krakow in September!
POUG 2026: Call for Speakers
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! ...
sessionize.com
The QUALIFY clause enables you to filter rows using window functions e.g. get the top ranked rows with SELECT ... FROM ... QUALIFY RANK () OVER ( ORDER BY ... ) = ... @danischnider.bsky.social looks at how it works in Oracle AI Database 26ai
QUALIFY: The WHERE Condition for Analytic Functions
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…
buff.ly
🎉 #Oracle #AI #Database 26ai Enterprise Edition is now generally available for Linux x86-64 on-prem!
Oracle AI Database 26ai Enterprise Edition now GA for on-premises Linux x86-64
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. …
geraldonit.com
Oracle AI Database 23.26.0 developer features include QUALIFY clause GraphQL Table Function for SQL SQL Objects and Collections in MLE JavaScript PL/SQL RESETTABLE clause to avoid ORA-04068: existing state of packages has been discarded @gvenzl.bsky.social
What’s new for Developers in Oracle AI Database 23.26.0
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!…
buff.ly
On the way home from #DOAG2025: We were too careful with the expected delay of Deutsche Bahn. So we habe 75 minutes to change in Munich. Time for a beer 😊
How do the data types of join columns affect query performance? @danischnider.bsky.social compares using Hashes as CHAR(32) and RAW(16) Sequences as NUMBER And finds in Oracle #SQL NUMBER is faster than RAW RAW is faster than CHAR
Data Types of Join Columns
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.
buff.ly
If you love your data then you have to love this feature. Presented by @toonkoppelaars.bsky.social who joined Oracle to make that happen. #DOAG2025
Coming in Oracle AI Database #SQL assertions These enable you to create cross row, cross table constraints with SQL standard syntax CREATE ASSERTION … CHECK ( [ NOT ] EXISTS ( <query> ) ) @toonkoppelaars.bsky.social explains at #DOAG2025
Learning from mistakes is important. Better: learn from others' mistakes. Even better: today we can learn from @danischnider.bsky.social 's ones #doag2025
🎤 Don’t miss DOAG Konferenz + Ausstellung 2025 — Nov 18–21, the premier event for database technologies in the German-speaking region! Join #OracleACE experts and industry leaders for in-depth sessions on Oracle tech, modern IT trends, open source, and more. 👉 anwenderkonferenz.doag.org/de/home/
Since last week, I can finally use the QUALIFY clause in Oracle. If you never heard of this SQL extension, read my newest blog post: danischnider.wordpress.com/2025/10/24/q...
QUALIFY: The WHERE Condition for Analytic Functions
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…
danischnider.wordpress.com
Exciting to see Oracle ACEs featured as speakers at SOUG Day Zurich 2025 on October 23! 🇨🇭✨ Get ready for a day full of expert insights and networking with the Swiss Oracle community. Discover more: 🔗 soug.ch/event/soug-day-zurich-2025/ @helifromfinland.bsky.social @danischnider.bsky.social
Basic knowhow that every Oracle developer and DBA should know: how do transactions work in an Oracle database. @martinklierdba.bsky.social explains it in detail at #HrOUG2025
