Relational Products and Data Warehousing - dummies

Relational Products and Data Warehousing

By Thomas C. Hammergren

Here are some leading relational database products that you might want to use for your data warehouse. Almost all these vendors have, during the past few years, acquired additional products, including OLAP or multidimensional-oriented technology and other RDBMSs to support very diversified platforms and integrate into their product lines and architectures.

You might want to keep an eye on the whole picture because a data warehousing environment might well have both relational and multidimensional servers. In such an environment, you need integration that’s as seamless as possible.

IBM Data Management family

The IBM Data Management family is an outgrowth of the IBM flagship DB2 relational DBMS product for MVS/ESA mainframes, as well as a number of acquisitions, including Informix. Many organizations that have corporate standards and mandates, such as “Thou shalt do all large database processing on the mainframe,” deploy data warehousing by using a version of DB2 for this platform.

Microsoft SQL Server

Microsoft initially targeted SQL Server technology for many departmental applications in which Microsoft products are dominant. Over the years, Microsoft has added features to enable organizations to expand capacity for data warehousing, changes which have made SQL Server the preferred platform for data marts.


Oracle, a leading RDBMS vendor, has been a mainstay in the areas of data warehousing and data marts since the mid-1990s. In the early years, Oracle was the alternative to IBM, and it was a dominate factor in the non-mainframe data warehousing and data mart environments. Oracle has continued to innovate its database platform to address needs for data warehousing.