Programming Languages White Papers
Building a Hybrid Data Warehouse Model
Overview This paper discusses the hybrid design and provides a fully functional reference implementation. The system runs on Oracle Database 10g. It contains all code needed to build the database schemas, generate sample data, load it into the schemas, build the indexes and materialized views, run the sample queries, capture the runtimes, and provide statistics on the runtimes. The hybrid model is not a one-size-fits-all solution. Many projects are best served by either using only one of the traditional models or using both models separately with a feed between them. But if the objective is to create a single database that can both store data in its properly normalized form and run aggregation queries with good performance, the hybrid model is a design pattern to consider.
| Publisher | Oracle | File Format | HTML |
|---|---|---|---|
| Date Published | April 2007 | Downloads | 270 |
| Format | White Papers | ||
| Topics | |||
-
Did you find this white paper useful? 26 out of 50 users found this white paper useful
White Paper RSS
Download
Register
