What is the difference between Data Warehouse and Database?
-
If there are any, what is the difference between Data Warehouse and Database?
-
If there are any, what is the difference between Data Warehouse and Database?
It's a good question for Google. Hereafter try Google before posting simple questions like this. Database vs. Data Warehouse[^]
thatraja
-
If there are any, what is the difference between Data Warehouse and Database?
The purpose. A traditional transactional database is made for storing data. These databases are generally highly normalized to keep the referential integrity, but might be to slow for analytical queries. A data warehouse is optimized for analysis of the data. The data is therefore often stored in a denormalized and/or aggregated form. To make sure the referential integrity is kept intact they usually pull their data from a transactional database.
Wrong is evil and must be defeated. - Jeff Ello[^]
-
It's a good question for Google. Hereafter try Google before posting simple questions like this. Database vs. Data Warehouse[^]
thatraja
I don't want the answer of Google I would like the answer of developers. Google is an advertising and media company :wtf: .
-
I don't want the answer of Google I would like the answer of developers. Google is an advertising and media company :wtf: .
Google Search engines returns also articles, blog posts, etc., written by developers.
thatraja
-
It's a good question for Google. Hereafter try Google before posting simple questions like this. Database vs. Data Warehouse[^]
thatraja
There is not a straight answer to that question as there are many different forms of data warehouses. Also a data warehouse is a database so the question does not really make sense. The data warehouses I have worked with differ from non data warehouse databases in the following manner: A data warehouse keeps transactional data so that the state of a database at any point in time can be recreated. As a consequence data warehouses contain a lot of data as every single change, at the column level, illicits the creation of a new row. Data warehouses can contain raw, staging and warehouse schemas to enable the verifying of data before it is placed in the data warehouse. A data warehouse is generally used where one wants to be able to have an audit trail of the contents of the database. That's my t'penneth. Oops - replied on the wrong thread :rolleyes:
“That which can be asserted without evidence, can be dismissed without evidence.”
― Christopher Hitchens
-
If there are any, what is the difference between Data Warehouse and Database?
There is not a straight answer to that question as there are many different forms of data warehouses. Also a data warehouse is a database so the question does not really make sense. The data warehouses I have worked with differ from non data warehouse databases in the following manner: A data warehouse keeps transactional data so that the state of a database at any point in time can be recreated. As a consequence data warehouses contain a lot of data as every single change, at the column level, illicits the creation of a new row. Data warehouses can contain raw, staging and warehouse schemas to enable the verifying of data before it is placed in the data warehouse. A data warehouse is generally used where one wants to be able to have an audit trail of the contents of the database. That's my t'penneth.
“That which can be asserted without evidence, can be dismissed without evidence.”
― Christopher Hitchens
-
Google Search engines returns also articles, blog posts, etc., written by developers.
thatraja
Well... it's the same you know. For some reason I won't explain here it happens that companies or countries block some websites. Some companies block everything except professional website like this one (codeproject) or Microsoft or universities, ... But blogs are blocked. That the reason I don't like when people answer to go to check on Google or other search website.