Chapter Notes

The literature on data warehousing and OLAP is substantial. Date (2000, Chapter 21) provides a clear overview of decision support. Inmon (1993), Kimball (1996) and Silverston et al. (1997) provide practical advice on data warehousing. Jukik (2006) provides a useful overview of alternative strategies for modeling data warehouses. The gendercode example of data cleansing was suggested by Scot Becker—thanks Scot! Thomsen et al. (1999) provide a thorough discussion of OLAP for SQL Server, including a detailed coverage of MDX.

A brief review of conceptual query prototypes, such as ERQL, Super, Hybris, and CBQL, is given in Bloesch and Halpin (1997). Some other graphical database query languages are surveyed in Ozsoyoglu and Wang (

Get Information Modeling and Relational Databases, 2nd Edition 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.