Relational Datawarehouse

ManjulaSiva at 12h45
29
Apr
2010
Relational Datawarehouse

Hi,

I have always understood that a Datawarehouse uses a Dimentional Model. But then i hear that there are Datawarehouses using the Relational model. My question is if the OLTP system by itself falls under the relational model, then what would the difference between the models(Relational Datawarehouse and OLTP) , except that relational datawarehouse would have historical data also.

Sorry, if my question sounds silly.


Read more
Reply
About
This topic belongs to the forum

  • Data Warehousing and Business Intelligence based on dimensional modeling and the Kimball Lifecycle.

  • Numbers of topics : 1858
  • Numbers of messages : 8714
  • Numbers of users : 3801
  • Numbers of points : 1672
Similar topics
Data Warehouse Questions
This year, we’re planning on creating a data warehouse and implementing an OLAP solution. From what I’ve read on this site and others, I will be better off if the data warehouse is designed with a dimensional model. I have a few questions about the
DatawareHouse modeling (factless table)
Hi everyone ! (To begin, I want to apologize for the bad english i'm gone use cause im french canadian) system i'm using : Sql Server 2005 Ent SSAS 2005 (For cube) SSIS 2005 (For ETL) I'm in the process of building a datawarehouse for the
Customer looking for sub second performance in a relational implementation.
Customer is looking for a sub second performance on a query against a fact that is close to 0.7 TB. The query is running in 10 secs. I built an aggregate table on high level of granularity and met the expectation because the size of the aggregate table wa
Best Practices for SCD Dimension Tables for a Banking Data Warehouse
Hello, I am looking for a list of dimension tables to track historical changes on for a banking data warehouse, based on "best practices". Customer is a prime candidate. Are there others? Thanks, Ike
Data Warehouse - Indexes
Hi, I am currently at the point where I need to think about Indexes on my data warehouse. We are currently using SQL Server 2005. As a general rule of thumb would the following hold true (Please note that the reporting requirements are still
Forums from same category
See also
more_less
Informations

2 Replies For the topic :
"Relational Datawarehouse"

This topic has been viewed 1656 times.

Last message :
29/04/2010 at 12h45 by "ManjulaSiva"