Difference between Snowflake schema and Star Schema

Posted on Posted in Datawarehousing

Snowflake Schema Star Schema Ease of maintenance / change No redundancy, so snowflake schemas are easier to maintain and change. Has redundant data and hence less easy to maintain/change Ease of Use More complex queries and hence less easy to understand Lower query complexity and easy to understand Query Performance More foreign keys and hence longer query […]

Online Analytical Processing Server (OLAP)

Posted on Posted in Datawarehousing

In this article, we will learn: What is OLAP? Types of OLAP Advantages and Disadvantages of OLAP OLAP operations What is OLAP and Types of OLAP? Online Analytical Processing Server (OLAP) is based on the multidimensional data model. There are 4 types of OLAP servers. Relational OLAP (ROLAP) Multidimensional OLAP (MOLAP) Hybrid OLAP (HOLAP) Specialized […]

Difference between Data Warehouse and Operational Database

Posted on Posted in Datawarehousing

Sr.No. Data Warehouse (OLAP) Operational Database(OLTP) 1 It involves historical processing of information. It involves day-to-day processing. 2 OLAP systems are used by knowledge workers such as executives, managers, and analysts. OLTP systems are used by clerks, DBAs, or database professionals. 3 It is used to analyze the business. It is used to run the […]

Datawarehouse Introduction

Posted on Posted in Datawarehousing

In this article, we will learn: What is Datawarehousing? Features of Datawarehouse Advantages of Datawarehousing Disadvantages of Datawarehousing What is Datawarehousing? A Data Warehouse is a central repository where consolidated data from multiple locations are stored. A data warehouses provides us generalized and consolidated data in multidimensional view It does not contain current data Data Warehouse is […]