OLAP Database and Data Warehousing
2 posters
Page 1 of 1
OLAP Database and Data Warehousing
Hi,
I'm new to database design. Recently, I've been working on expanding my knowledge of OLAP and Data warehousing. With that said, I'm a bit confused on the two terminologies. It seems everyone has their own definition and it's conflicting.
For example, I have a test database that has dimension tables and fact tables structured in a snowflake schema. I assumed this was an example data warehouse. However, I was told it's actually an OLAP database and NOT a data warehouse.
To me, OLAP refers to data in a multidimensional cube where end users can query. It's the last layer that comes after the data warehouse. So, in the bigger picture, you have your OLTP database feeding data to a data warehouse via ETL systems. Then you have data warehouse data feeding OLAP cubes via another ETL system. The end user is querying the cube and not the warehouse or the OLTP.
So, is it possible to have a OLAP database with dim/fact tables and not be a data warehouse? Or am I confusing something here?
Thanks for any help on the question. I'm looking forward to reading more on the subject from Kimbel group's books when they get here on Monday!
I'm new to database design. Recently, I've been working on expanding my knowledge of OLAP and Data warehousing. With that said, I'm a bit confused on the two terminologies. It seems everyone has their own definition and it's conflicting.
For example, I have a test database that has dimension tables and fact tables structured in a snowflake schema. I assumed this was an example data warehouse. However, I was told it's actually an OLAP database and NOT a data warehouse.
To me, OLAP refers to data in a multidimensional cube where end users can query. It's the last layer that comes after the data warehouse. So, in the bigger picture, you have your OLTP database feeding data to a data warehouse via ETL systems. Then you have data warehouse data feeding OLAP cubes via another ETL system. The end user is querying the cube and not the warehouse or the OLTP.
So, is it possible to have a OLAP database with dim/fact tables and not be a data warehouse? Or am I confusing something here?
Thanks for any help on the question. I'm looking forward to reading more on the subject from Kimbel group's books when they get here on Monday!
Vale- Posts : 1
Join date : 2013-10-27
Re: OLAP Database and Data Warehousing
The term OLAP was coined by Edgar Codd. He used it to refer to on-line interactive analytics by any means. So, even an Excel spreadsheet can be considered an OLAP environment. There is no requirement as to how it is implemented.
Similar topics
» data warehouse or not ? when is it okay to use OLAP without a data warehouse database
» indexes used in data warehousing?
» How to implement a data warehousing solution for Google Analytics data?
» New to Data warehousing
» SOA and Data Warehousing
» indexes used in data warehousing?
» How to implement a data warehousing solution for Google Analytics data?
» New to Data warehousing
» SOA and Data Warehousing
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum