O'Reilly logo

Data Warehousing For Dummies®, 2nd Edition by Thomas C. Hammergren

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 5. Relational Databases and Data Warehousing

In This Chapter

  • Using relational databases, past and present

  • Making relational databases work well for data warehousing

  • Checking out relational database products for your data warehousing project

You don't, strictly speaking, have to store the contents of a data warehouse in a relational database. However, in nearly all situations, your project benefits significantly from the use of a relational database management system (RDBMS).

This chapter explains the use of relational database technology (today's overwhelmingly dominant database technology) for your data warehouse, including its benefits and challenges. Chapter 6 discusses alternative technologies that you can use to store and manage your data warehouse.

The 1990s generation of data warehousing implementations grew up on multidimensional databases, but the current marketplace is experiencing a clear-cut trend toward using relational databases, particularly for large-volume data warehouses (more than about 250 gigabytes of data). Multidimensional databases aren't dead — they can still provide value to smaller-scale environments (data warehouse lite systems or data marts, as discussed in Chapters 3 and 4, respectively).

The Old Way of Thinking

Jump back to 1995. The data warehousing revolution was picking up steam, and companies all over the U.S. (yours was probably one of them) and around the world were captivated by not only the concept of data warehousing, but also the principles ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required