Free Trial

Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.

  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 15. The Data Warehouse > Simplified Dimensional Models

Simplified Dimensional Models

At the beginning of this chapter, we mentioned that the arduous process of creating a data warehouse can be simplified and still prove to be an advantageous endeavor. In this chapter, we created a data warehouse that was more complex than would normally be attempted with Access. Simpler variants of the process we followed can certainly be utilized. For example, one might want to create a small data set for a narrow period of time, with just orders, customers, and product information. By ignoring returns, one can streamline the process and create everything with just one or two queries. With smaller amounts of data, it may not even be necessary to store data within Access. Because Access is able to turn any table into a query, most data can be defined via a Select query.

Additionally, the concept of a dimensional model can be stretched to cover other types of structures. We’ll illustrate this notion with a brief example. Working from the production tables seen in this chapter, let’s say we want to create a summary of customer buying habits, focusing on whether or not each customer has ever made purchases from each of the three product categories: coffee, tea, and spices. To accomplish this, we’ll create a single Select query that captures this information. Figures 15.30 and 15.31 show the design of such a query and a few rows of data.


  

You are currently reading a PREVIEW of this book.

                                                                                                                    

Get instant access to over $1 million worth of books and videos.

  

Start a Free 10-Day Trial


  
  • Safari Books Online
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint