Tuesday, April 4, 2017
03:45 PM - 04:30 PM
A data warehouse is a database that is dedicated to data analysis and reporting. It combines data from multiple operational applications and restructures the data for ease of analysis. Warehouses can become large given the multiple feed sources. They can also evolve as business needs change over time.
A warehouse is more flexible and user friendly if views mediate access to tables. Views can paper over differences in jargon and separate data for different user groups.
Traditionally access views are created manually with data modeling tools. This presentation will discuss several other approaches (most notably recursive SQL) that can be used to generate access views.
This session will deliver the following benefits to participants:
- An explanation of access views and their importance to a data warehouse project
- Simple examples of access views
- Rules for constructing access views
- Four approaches for creating access views with trade-offs
- A sample recursive SQL query that generates access views
Michael Blaha is a consultant and trainer who specializes in conceiving, architecting, modeling, designing and tuning databases. He has worked with dozens of organizations around the world. Blaha has authored seven U.S. patents, seven books, many articles and two video courses. His most recent publication
is the Agile Data Warehouse Design video course from O'Reilly. He received his Doctorate from Washington University in St. Louis, and is an alumnus of GE Global Research in Schenectady, New York. He is a member of Chicago DAMA and has been blogging for Dataversity since 2014.