Chapter 6. Basic Dimensional Concepts
In Part I, we looked at the fundamental principles of traditional relational theory and the entity-relationship model. The majority of database applications are built using these principles, and for good reason. If applied consistently, they ensure data integrity, resilience, and scalability in applications that involve frequent changes to data.
But not all database applications involve frequent changes to the data. There exists another entire class of database applications with very different purposes and requirements. These applications must store large (sometimes vast) amounts of historical data, but that data, once loaded, is only rarely changed. These applications rarely support more than a few dozen users, ...
Get Designing Effective Database Systems now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
