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.
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.
No comments:
Post a Comment