In Computer Science, a data warehouse or enterprise data warehouse (i.e., DW or EDW) is a database utilized for reporting and data analysis. This is a central repository of data which is formed by integrating data from one or many disparate sources. The Data warehouses store current and also historical data and are employed for creating trending reports for senior management reporting like annual and quarterly comparisons.
The data warehouse is an integrated, time-variant, non-volatile, and subject-oriented collection of data in support of management's decision making procedure.
Subject-Oriented:
A data warehouse can be utilized to analyze a specific subject region. For illustration, "sales" can be a specific subject.
Integrated:
Data warehouse integrates data from numerous data sources. For illustration, source A and source B might have different manners of identifying a product, however in a data warehouse; there will be a single manner of identifying a product.
Time-Variant:
The historical data is kept in a data warehouse. For illustration, one can retrieve data from 3 months, 6 months, 12 months, or even previous data from a data warehouse. This contradicts with a transactions system, where frequently the most recent data is kept. For illustration, a transaction system might hold the latest address of a customer, where a data warehouse can kept all addresses related with a customer.
Non-volatile:
Once a data is in the data warehouse, it will not transform. Therefore, historical data in a data warehouse must not be altered.
Data Warehouse is the main seat of Computer Science. The virtual classroom that is Computer Homework Help is a place where the students can interrelate with online professionals for computer assignments and problems and students can get various types of help in different subjects and be benefited by enhancing corresponding grades.
Comments
Post a Comment