Skip to primary content
Skip to secondary content

Data Warehousing with Oracle

Dani Schnider's Blog

Data Warehousing with Oracle

Main menu

  • Home
  • Contact
  • About
  • Publications
  • Presentations

Post navigation

← Older posts

Star Schema Design in Oracle: Partitioning

Posted on 9. January 2023 by Dani Schnider
1

Partitioning is one of the most powerful features for data warehouses in Oracle databases. In this blog post, I explain how it can be used for the physical design of star schemas. What is the recommended partitioning strategy for a star schema, and what are the advantages of partitioning?

Continue reading →

Posted in Dimensional Modeling, Oracle, Partitioning, Performance | 1 Reply

2022: Live again at Conferences

Posted on 31. December 2022 by Dani Schnider
Reply

It has become almost a tradition for me to write an annual review of my conferences and presentations. The good news: In 2022, most of the conferences were on-site again. Additionally, there was another important event for me in 2022: I changed my job and work now for Callista.

Continue reading →

Posted in Conferences, Oracle | Leave a reply

Star Schema Design in Oracle: Fundamentals

Posted on 10. November 2022 by Dani Schnider
Reply

What are the design rules for good performance in a star schema in an Oracle database? This blog post series introduces some recommendations for the physical database design. This first post is about constraints and indexes.

Continue reading →

Posted in Dimensional Modeling, Oracle, Performance | Leave a reply

Bye Bye Trivadis

Posted on 27. October 2022 by Dani Schnider
23

Today is my last day at Trivadis. I worked for this company more than 23 years, and most of the time, I loved my job. To conclude my time as a consultant and trainer, here are three funny stories that happened to me over the years.

Continue reading →

Posted in Oracle | 23 Replies

Book Review: “Faster: How to Optimize a System” by Cary Millsap

Posted on 12. August 2022 by Dani Schnider
Reply

There are many books on performance optimization, but this one differs in a few ways. It is more of an entertaining collection of short stories, but with many educational messages.

Continue reading →

Posted in Books, Oracle, Performance | Leave a reply

Housekeeping in Oracle: How to Get Rid of Old Data

Posted on 2. July 2022 by Dani Schnider
3

Have you ever tried to delete a few million rows from a table with several hundred milllions of rows with a DELETE statement? If yes, then you know that this is a very bad idea. With Oracle Partitioning you can do this more elegant and much faster.

Continue reading →

Posted in DWH Architecture, Oracle, Partitioning, Performance, PL/SQL, SQL | 3 Replies

Data Vault versus Database Vault

Posted on 12. June 2022 by Dani Schnider
Reply

In the Oracle community, the terms “Data Vault” and “Database Vault” are often confused, although they have nothing to do with each other. A short clarification.

Continue reading →

Posted in Data Vault Modeling, Oracle | Leave a reply

Performance Tips: PL/SQL Functions in SQL Queries

Posted on 15. May 2022 by Dani Schnider
5

PL/SQL functions in SQL statements may cause major performance problems. If it is not possible to avoid these calls, there are several solutions to improve the performance. But not for all situations.

Continue reading →

Posted in Oracle, Performance, PL/SQL, SQL | 5 Replies

Performance Tips: Function Calls in WHERE Conditions

Posted on 28. February 2022 by Dani Schnider
1

A typical reason of many performance issues with SQL are function calls in the WHERE condition. They make it difficult for the query optimizer to determine the cardinality. Fortunately, there are several ways to solve this problem.

Continue reading →

Posted in Oracle, Performance, SQL | 1 Reply

2021: Another Year at Home

Posted on 31. December 2021 by Dani Schnider
1

I never wrote so few blog posts like in 2021. There are several reasons for this. But there are also good news: I was able to attend at least a few conferences this year.

Continue reading →

Posted in Conferences, Oracle | 1 Reply

Post navigation

← Older posts

Categories

  • ADWC (6)
  • Books (8)
  • Cloud (6)
  • Conferences (20)
  • Data Vault Modeling (20)
  • Dimensional Modeling (13)
  • DWH Architecture (16)
  • DWH Automation (4)
  • ETL (27)
  • In-Memory (5)
  • Materialized Views (6)
  • Oracle (82)
  • Oracle 12c (27)
  • Oracle 19c (3)
  • Oracle 20c (1)
  • Oracle Data Integrator (1)
  • Oracle OpenWorld (8)
  • Oracle Warehouse Builder (7)
  • Partitioning (20)
  • Performance (50)
  • PL/SQL (9)
  • Relational Modeling (3)
  • Snowflake (1)
  • SQL (45)

Archives

  • January 2023
  • December 2022
  • November 2022
  • October 2022
  • August 2022
  • July 2022
  • June 2022
  • May 2022
  • February 2022
  • December 2021
  • January 2021
  • December 2020
  • November 2020
  • June 2020
  • April 2020
  • February 2020
  • December 2019
  • October 2019
  • July 2019
  • June 2019
  • April 2019
  • March 2019
  • February 2019
  • December 2018
  • September 2018
  • July 2018
  • June 2018
  • May 2018
  • April 2018
  • February 2018
  • January 2018
  • December 2017
  • November 2017
  • October 2017
  • September 2017
  • July 2017
  • June 2017
  • May 2017
  • April 2017
  • February 2017
  • January 2017
  • December 2016
  • November 2016
  • October 2016
  • September 2016
  • July 2016
  • June 2016
  • April 2016
  • February 2016
  • January 2016
  • December 2015
  • November 2015
  • September 2015
  • August 2015
  • July 2015
  • June 2015
  • April 2015
  • March 2015
  • January 2015
  • December 2014
  • October 2014
  • August 2014
  • July 2014
  • June 2014
  • October 2013
  • July 2013
  • June 2013
  • April 2013
  • March 2013
  • June 2012
  • May 2012
  • January 2012
  • October 2011
  • September 2011
  • August 2011
  • July 2011
  • June 2011
  • April 2011
Blog at WordPress.com.
Data Warehousing with Oracle
Blog at WordPress.com.
  • Follow Following
    • Data Warehousing with Oracle
    • Join 126 other followers
    • Already have a WordPress.com account? Log in now.
    • Data Warehousing with Oracle
    • Customize
    • Follow Following
    • Sign up
    • Log in
    • Report this content
    • View site in Reader
    • Manage subscriptions
    • Collapse this bar
 

Loading Comments...