July 2010
Intermediate to advanced
976 pages
30h 19m
English
Content preview from Information Modeling and Relational Databases, 2nd Edition
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
Start your free trial
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 (