Differences between systems(OLTP,OLAP,ODS,DWH,DSS)

The below are the differences between systems. Please go through them.

.             OLTP                                                                       OLAP

    1. It is dynamic.                                                1. It is static [unchanged].

    2. It follows normalization.                              2. It follows denormalization.

    3. It contains current data.                                3. It contains historical data.

    4. It is designed to support transactional          4. It is designed to support decision  

        process                                                              making process   

    5. It contains detailed data.                               5. It contains summarized information.

                       

                 ODS                                                                        DWH

   1. It is designed to support operational             1. It is designed to support decision  

      process                                                              making process   

   Similarities:-

    2. Integrated database.                                     2. Integrated database.

    3. Enterprise data.                                            3. Enterprise data.

    4. Subject oriented database.                           4. Subject oriented database.

    Differences:-

    5. Contains current information.                      5. Contains historical information.

    6. Data is volatile.                                            6. Data is non-volatile.

    7. Contains detail information.                        7 . Contains summary information.

   

                ODS                                                            OLTP

    1. Subject oriented database.                         1. Application oriented database.

           

                   OLTP                                                        DWH

    1. Data is volatile.                                            1. Data is non-volatile.

    2. It contains current data.                               2. It contains historical data.

    3. It is application oriented database.              3. It is subject oriented database.

    4. It is not flexible.                                          4. It is flexible.

    5. It stored all data.                                          5. It stores relevant data.

   

             OLTP                                                                                 DSS

    1. It is designed to support operational            1. It is designed to support decision  

        process                                                              making process   

    2. Data is volatile.                                          2. Data is non-volatile.

    3. Data is in inconsistency form.                      3. It is in consistent form.

    4. It stores recent data for approximately         4. It stores One year data.

       4 to 6 months data.

    5. It follows normalized schema.                      5. It follows star schema.

   

                      DWH                                                                                   DM

    1. It is about entire organization.                       1. It is about individual department in                                                                                    

                                                                                    Organization           
    2. It is created on RDBMS.                               2. It is created on RDBMS & MDDB.

    3. It follows integrated schema design.             3. It follows star schema design.

    4. It is integrated database.                                4 . Subject oriented databases.