Advertisement
Online Test Banks
Score higher
See Online Test Banks
eLearning
Learning anything is easy
Browse Online Courses
Mobile Apps
Learning on the go
Explore Mobile Apps
Dummies Store
Shop for books and more
Start Shopping

Relational Products and Data Warehousing

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

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.

  • Add a Comment
  • Print
  • Share
blog comments powered by Disqus
Advertisement
Advertisement

Inside Dummies.com

Dummies.com Sweepstakes

Win an iPad Mini. Enter to win now!