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

Data warehouse based on operational data model

When trying to design a data warehouse, we often try to model the database on the operational data model. Are there any guidelines in trying to create a data warehouse based on the operational data model?

When trying to design a data warehouse, we often try to model the database on the operational data model. Are there any guidelines in trying to create a data warehouse based on the operational data model?
The data warehouse environment should have multiple layers to support the many roles it is forced into playing.

The audit layer will be modeled very closely to the operational support systems that feed data into the data warehouse....

Use the Application Triage technique here. Touch an application, take the application. Do change data capture at this level and retain the history, thus you need to add the appropriate metadata to those tables.

The base/history layer should be modeled to reflect the business semantic. Subject-oriented, integrated, very 3NF in design, also some applicable use of Data Vault modeling components to isolate tracking history-sensitive columns and privacy/security-sensitive columns. Use the Table Triage technique here: touch a table, take the table.

The user access layer should be modeled to reflect how the business community uses the information. Lots of dimensional modeling to support functional and performance needs where analytics (score cards, dashboards, loading cubes, etc.) is the need. Also flat "profile" type data sets to support loading up data mining tools such as SAS enterprise miner. User requirements-driven triage here, pull in the data elements necessary to support the information delivery requirements documented.

So the short answer is yes, operational modeling is applicable for certain layers of data architecture within the data warehouse.

This was last published in October 2006

Dig Deeper on Oracle MDM and metadata

PRO+

Content

Find more PRO+ content and other member only offers, here.

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.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close