data warehouse components

Data Warehouse Implementation There are various implementation in data warehouses which are as follows 1. Requirements analysis and capacity planning: The first…

What is Meta Data? Metadata is data about the data or documentation about the information which is required by the users. In…

Data Warehouse Tools The tools that allow sourcing of data contents and formats accurately and external data stores into the data warehouse…

Difference between OLTP and OLAP OLTP (On-Line Transaction Processing) is featured by a large number of short on-line transactions (INSERT, UPDATE, and…

Difference between Operational Database and Data Warehouse The Operational Database is the source of information for the data warehouse. It includes detailed…

Difference between ROLAP, MOLAP, and HOLAP ROLAP MOLAP HOLAP ROLAP stands for Relational Online Analytical Processing. MOLAP stands for Multidimensional Online Analytical…

Three-Tier Data Warehouse Architecture Data Warehouses usually have a three-level (tier) architecture that includes: Bottom Tier (Data Warehouse Server) Middle Tier (OLAP…

Types of Data Warehouses There are different types of data warehouses, which are as follows: Host-Based Data Warehouses There are two types…

What is OLAP (Online Analytical Processing)? OLAP stands for On-Line Analytical Processing. OLAP is a classification of software technology which authorizes analysts,…

What is Operational Data Stores? An ODS has been described by Inmon and Imhoff (1996) as a subject-oriented, integrated, volatile, current valued…