Modeling a faster data warehouse
Joseph H. Hanson, Mary Jane Willshire · 2002
One key area involved in implementing the data warehouse is the transfer of information from the Source Databases (SDBs) into the data warehouse and making it available to the user. In looking at the overall intent of the data warehouse as a repository for vast amounts of diverse information, changes made to the SDBs, can be critical to the correctness of the query responses provided by the warehouse. The paper presents an alternative to the state of the art data warehouse environment by providing an auxiliary structure to accept these updates and store them until the data warehouse has available cycle time to incorporate the new data and update the necessary views. Using the Integrated Definition (IDEF) modeling process, we have created models of both the state of the art and alternative data warehouse structures to validate our design and performance characteristics.