The Death of the Star Schema
DATE: March 15, 2022
TIME: 2 PM Eastern / 11 AM Pacific
PRICE: Free to all attendees
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:
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.
By registering for this or any DATAVERSITY® event, as applicable by local privacy laws, you agree to receive marketing e-mail notifications from DATAVERSITY, sponsors, and partners from this event. Use of this contact data is governed by each individual entity’s Privacy Policy. Just click the “unsubscribe” or "Manage Your Email Subscriptions" link in any e-mail to unsubscribe.
For more information or to offer feedback, email: [email protected] | Advertise With Us
Copyright © 2011-2022 DATAVERSITY Education, LLC. All Rights Reserved.
13020 Dickens Street, Studio City, California 91604 | 1 (310) 337-2616
Terms | Privacy
Copyright © 2011-2022 DATAVERSITY Education, LLC. All Rights Reserved.
13020 Dickens Street, Studio City, California 91604 | 1 (310) 337-2616
Terms | Privacy