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

New “Sales History” Sample Schema in Oracle 23c

Posted on 18. May 2023 by Dani Schnider
3

The newest version of the Oracle sample schema “Sales History” (SH) finally contains current data again and is easier to install than the previous versions. If you work with star schemas, the SH schema is a must.

Continue reading →

Posted in Dimensional Modeling, Oracle, Oracle 23c, SQL | 3 Replies

SQL Performance Tips in Execution Plans of Oracle 23c

Posted on 24. April 2023 by Dani Schnider
1

Oracle 23c is like Christmas for me. There are many surprises to be found. This weekend I discovered another nice little enhancement.

Continue reading →

Posted in Oracle, Oracle 23c, Performance | 1 Reply

Enhanced Partitioning Metadata in Oracle 23c

Posted on 16. April 2023 by Dani Schnider
3

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.

Continue reading →

Posted in Oracle, Oracle 23c, Partitioning, SQL | 3 Replies

GROUP BY Extensions in Oracle 23c

Posted on 7. April 2023 by Dani Schnider
3

Since a few days, Oracle Database 23c Free Developer Release is available. It contains many new features that are interesting for developers, especially some nice little extensions in SQL that we missed since years. Let’s start with an easy one in this blog post.

Continue reading →

Posted in Oracle, Oracle 23c, SQL | 3 Replies

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
4

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 | 4 Replies

Post navigation

← Older posts

Categories

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

Archives

  • May 2023
  • April 2023
  • 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 130 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...