No matter how well planned and executed, the data structures of any data warehouse oft times eventually land up resembling something out of a Dr. Seuss book. In this presentation we shall be looking at and discussing a few of the “perfect” data structures (that I have inherited) and discussing the flaws that have only recently surfaced. We shall be looking at the ‘before’, discussing a few alternatives to make these structure more efficient and effective, then we shall then look at final “production structure” and the resulting improvement metrics; all of which help us to help our clients’ make better decisions in a timely manner.
Steve Simon is a senior BI engineer with MyWebGrocer. He has been involved with database design and analysis for over 20 years. Steve has presented papers at eight PASS Summits and two at PASS Europe. He has just recently presented a Business Intelligence paper at Oracle World in San Francisco . Steve has also presented 5 papers at the Information Builders’ (IBI) International Summits. He is a PASS regional mentor & chair of the Oracle/SQL Server VC.