Here are some key events in evolution of Data Warehouse. However, Data Warehousing is a not a new thing. The need to warehouse data evolved as computer systems became more complex and needed to handle increasing amounts of Information. The Datawarehouse benefits users to understand and enhance their organization’s performance. A data warehouse provides a new design which can help to reduce the response time and helps to enhance the performance of queries for reports and analytics.ĭata warehouse system is also known by the following name: This can quickly slow down the response time of the query and report. For example, a report on current inventory information can include more than 12 joined conditions. You many know that a 3NF-designed database for an inventory system many have tables related to each other. It is an architectural construct of an information system which provides users with current and historical decision support information which is difficult to access or present in the traditional operational data store. However, the data warehouse is not a product but an environment. The decision support database (Data Warehouse) is maintained separately from the organization’s operational database.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |