Advertisement

Slides: The Death of the Star Schema

By on

To view the on-demand recording from this presentation, click HERE>>

This webinar is sponsored by:

About the Webinar

Learn about the three advances in database technologies that eliminate the need for star schemas and the resulting maintenance nightmare.

Relational databases in the 1980s were typically designed using the Codd-Date rules for data normalization. It was the most efficient way to store data used in operations. As BI and multi-dimensional analysis became popular, the relational databases began to have performance issues when multiple joins were requested. The development of the star schema was a clever way to get around performance issues and ensure that multi-dimensional queries could be resolved quickly. But this design came with its own set of problems.

Unfortunately, the analytic process is never simple. Business users always think up unimaginable ways to query the data. And the data itself often changes in unpredictable ways. These result in the need for new dimensions, new and mostly redundant star schemas and their indexes, maintenance difficulties in handling slowly changing dimensions, and other problems causing the analytical environment to become overly complex, very difficult to maintain, long delays in new capabilities, resulting in an unsatisfactory environment for both the users and those maintaining it.

There must be a better way!

Watch this webinar to learn:

  • The three technological advances in data storage that eliminate star schemas
  • How these innovations benefit analytical environments
  • The steps you will need to take to reap the benefits of being star schema-free

About the Speaker

Claudia Imhoff

President of Intelligent Solutions and Founder of Boulder BI Brain Trust (BBBT)

Claudia Imhoff is an internationally recognized expert on analytics, business intelligence, and corresponding architectures. Dr. Imhoff has co-authored five books and more than 150 articles for technical and business magazines. She is also the Founder of the Boulder BI Brain Trust, a consortium (kuhn·sor·shm) of internationally recognized independent analysts and experts.

Pallavi Mishra

Sales Engineer at Incorta

Pallavi has 3 years of professional consulting and project management experience in strategizing and leading enterprise solution implementation, building prototypes and providing software solution demo to potential clients to drive sales, business process optimization and automation, robotic process automation, and IT risk management.

Nick Jewell

Senior Director of Product Marketing at Incorta

Nick has previously held roles across Product, Architecture and Delivery in a number of startups and leading Financial Services firms; acting as a technology evangelist with analytics communities, data leaders and the wider public.

Nick holds a Ph.D in Information Science from the University of Sheffield, featured in dataIQ’s Top 100 list in 2018, 2020 and 2021 and was recognised as one of Corinium’s Top 50 Innovators in Data and Analytics in 2019.

Leave a Reply