Data Warehouse Tutorial

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…

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,…

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 Database Parallelism Parallelism is used to support speedup, where queries are executed faster because more resources, such as processors and…