Problem solve Get help with specific problems with your technologies, process and projects.

Schematics of data warehouse infrastructure

Do have any schematics of an Oracle data warehouse and its infrastructure? Any examples of frozen, archived or...

historical files and how the infrastructure should look for individual data marts? Any help with this would be greatly appreciated, or a resource site that I can look at... Entire books have been written on this topic. Generally a data warehouse will utilize a star schema. A star schema consists of centralized fact tables and outlying dimension tables the dimension tables are usually only a couple of columns while the fact tables may contain hundreds. The dimension tables relate back tom the facts through one-to-many relationships. A single warehouse can have many of these star schemas. Generally the dimension table will contain the columns you use to slice the data in the fact table with. You search on the dimension tables and then move in to the fact tables. In 9i and later releases the indexes on the fact table are bitmap indexes to allow the optimal bitmap merge resolution of the star join. Oracle also provides the concept of dimension objects. A dimension object is a description of the hierarchies inherent in the fact table and is used by Oracle to optimize execution plans. Oracle also provides for materialized views (also called summaries).

This was last published in July 2004

Dig Deeper on Oracle data warehousing

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Please create a username to comment.