Skip to main content

Introduction: OLTP v/s OLAP

OLTP (Online Transaction Processing):

 

  • ·         Fresh Data
  • ·         Read (20%) and write (80%)
  • ·         Small Data (500GB)
  • ·         Normalized Data
  • ·         More Users
  • ·         Less Indexes

 

OLAP/DWH (Online Analytical Processing):

 

  • ·         Historical Data
  • ·         Read only Data
  • ·         Large Data (TB)
  • ·         De-Normalized Data
  • ·         Less Users
  • ·         More Indexes

 

SNO

OLTP (Operational Data)

OLAP (Analytical Data)

1

Designed for Transactions purpose (Business Purpose)

Designed for Analysis & Reporting purpose

2

Data modifications are frequent

Data modifications are not frequent

3

Has Normalized Tables

Has De-Normalized Table

4

Indexes Not recommended

Indexes are recommended

5

Maintains Small Data

Maintains Large Data

6

More Users

Less Users

7

Read\Write Data

Read Only Data

8

Fresh Data

Historical Data

Labels:

Popular posts from this blog

DBMS

Database : database can be defined as a collection of information stored at a particular place written in a predetermined manner, belongs to a particular topic.  DBMS: (DATA BASE MANAGEMENT SYSTEM):  it is defined as software which is present inside the database which is used o maintain or manage the data within the database .                                 In the above diagram, if the user needs any info from the database. He has to contact with  dbms , then the dbms goes to the database, takes the information from the  database and gives it back to the user. Database models :  these models are broadly divided into the following types: 1.         FMS/FDMS 2.         HMS/HDMS 3.         NDBMS 4.         RDBMS 5.      ...
Read more

Introduction to Datawarehouse

In shot what is DWH (Data warehouse)? A DWH is a Large Database which consists of Dimension and Fact tables. Or Collection of DataMart is called as a DWH. Father of Data Warehouse: Dr. William H. Inmon Dr. Ralph Kimball -Introduced Dimension Modelling to design DWH in 1990. What is Data Warehouse? As per Dr. William Inmon, Data Warehouse is a -       Subject Oriented (Loans, Mutual Funds etc.) -       Integrated (Get data from various sources) -       Time Variant (Different time period data)   ·          *Datamart is Subject Oriented ·          *DWH is a collection of Datamart ·          *DWH is a superset of Datamart ·          *Datamart is also another database. Top-down Approach: (DWH->Datamarts)   ...
Read more

Different Schemas in DWH

  SCHEMAS:   Star Schema: -       Star Schema means Dimension Tables are directly linked to the Fact Table. Snow Flake Schema: -       Dimension Tables are indirectly linked to the Fact Table OR -       Dimension table is linking to another dimension table .       Star Schema   Snow Flake Schema 1 Has redundant data and hence tough to maintain/change 1 No redundancy and hence more easy to maintain/change 2 Less complex queries and hence easy to understand 2 More complex queries and hence less easy to understand 3 Less foreign keys so faster execution time of cube. 3 More foreign keys so take more execution of cube 4 Has De-Normalized Tables 4 Has Normalized Tabl...
Read more