Characteristics and Functions of Data warehouseauto_adminComments off.
A data warehouse can be controlled when the user has a shared way of explaining the trends that are introduced as a specific subject. Below are major characteristics of a data warehouse:
A data warehouse is always a subject-oriented as it delivers information about a theme instead of the organization’s current operations. It can be achieved on a specific theme. That means the data warehousing process is proposed to handle with a specific theme which is more defined. These themes can be sales, distributions, marketing etc.
A data warehouse never put emphasis on only current operations. Instead, it focuses on demonstrating and analysis of data to make various decisions. It also delivers an easy and precise demonstration around a particular theme by eliminating data which is not required to make the decisions.
It is somewhere the same as subject orientation which is made in a reliable format. Integration means founding a shared entity to scale all similar data from the different databases. The data also required to be resided into the various data warehouse in shared and generally granted manner.
A data warehouse is built by integrating data from various sources of data such that a mainframe and a relational database. In addition, it must have reliable naming conventions, format and codes. Integration of data warehouse benefits in effective analysis of data. Reliability in naming conventions, column scaling, encoding structure etc. should be confirmed. Integration of data warehouse handles various subject related warehouse.
In this data is maintained via different intervals of time such as weekly, monthly, or annually etc. It founds various time limits which are structured between the large datasets and are held in an online transaction process (OLTP). The time limits for the data warehouse is wide-ranged than that of operational systems. The data resided in the data warehouse is predictable with a specific interval of time and delivers information from the historical perspective. It comprises elements of time explicitly or implicitly. Another feature of time-variance is that once data is stored in the data warehouse then it cannot be modified, alter, or updated.
As the name defines the data resided in the data warehouse is permanent. It also means that data is not erased or deleted when new data is inserted. It includes the mammoth quantity of data that is inserted into modification between the selected quantities on logical business. It evaluates the analysis within the technologies of a warehouse.
In this, data is read-only and refreshed at particular intervals. This is beneficial in analyzing historical data and incomprehension the functionality. It does not need the transaction process, recapture and concurrency control mechanism. Functionalities such as delete, update, and insert that is done in an operational application are lost in the data warehouse environment. Two types of data operations done in the data warehouse are Data Loading and Data Access
Functions of Data warehouse:
It works as a collection of data and here is organized by various communities that endure the features to recover the data functions. It has stocked facts about the tables which have high transaction levels which are observed so as to define the data warehousing techniques and major functions which are involved in this are Data consolidation, Data Cleaning and Data Integration
Posted in: news