Integrated Data Warehouse

You're reading Integrated Data Warehouse, posted on Thursday, February 17th, 2011 at 7:59 am in Hardware, on BrainBloggers at the Computers blog. More after the jump.

Data Warehouse often is the common term used in order to refer to the accumulating of data inside an business. This information is usually comprising of transactional details like purchase records and similar items, that are collected from a single or several sources. Data Warehouse usually gets hold of facts from a transactional system comparable to a central data center where information is obtained and reported to the users inside the provider. Data Warehouses traditionally feature some sort of Data Modelling Tool, a Reporting Tool, a Database as well as other facilitating tools. Basically, a Data Warehouse is a collection of information which can be used for reporting.

The Data Warehouse is a vital element of a business as it is a major DSS or decision support system. DSS is seen as a technology used by many businesses so that they can display details, relationships along with developments designed to in turn assist them to develop practical marketing decisions, determine effective business tactics along with accomplish organizational aims.

Categories of Data

Data inside a Data Warehouse may be frequently raw or formatted due to its use. It can also contain a wide variety of kinds of information along the lines of an organization’s operational data, sales, copies of data, salaries, inventory, assets, external information and more. These sorts of information are essential to make appropriate examinations and simulations.


Data Warehouse comprises of a number of layers: Operational Database layer, Data Access layer, Metadata layer, Informational Access layer.

Operational Database layer

The Operational Database Layer is how Data Warehouse sources data. Organizations generally possess an Enterprise Resource Planning system where this layer is available.

Data Access layer

The Data Access layer is the interface where the Informational Access layer and Operational layer are situated. Tools in this layer range between extract, transform in addition to load. This is where data can be accessed inside the Data Warehouse.

Metadata Layer

This layer is frequently commonly referred to as the Data Dictionary. The Metadata layer is generally more advanced and in depth because it features dictionaries for the warehouse together with data. This is often accessed using special reporting and analysis tools.

Informational Access Layer

Through this layer records can be accessed for analyzing or reporting functions. The various tools for examining and reporting data also are found in this layer. It is also recognized as the data mart. Business Intelligence tools will also be contained in this layer.


There are lots of different types of Data Warehouses Models. Types cover anything from Offline Transaction Processing to Offline Analytical Processing. Some tend to be more challenging to manipulate than others mainly because they might demand added methods, greater power, or more data in order to analyze special queries.

Advantages and disadvantages

Each technology and principle contains both advantages and disadvantages. One main selling point of a Data Warehouse is so that staff and employers may observe and access any and all data in order to provide reports, analysis and create essential long term business decisions.

One problem will be a number of systems might be incompatible with collected data. Many organizations will have to buy and update their own equipment and software in order to have the highest level of compatibility together with the Data Warehouse.