What is the difference between ODS and OLTP

Questions by stalin.thangaraj

Showing Answers 1 - 18 of 18 Answers

mamatha

  • Aug 4th, 2006
 

ODS:- It is nothing but a collection of tables created in the Datawarehouse that maintains only current data

where as OLTP maintains the data only for transactions, these are designed for recording daily operations and transactions of a business

  Was this answer useful?  Yes

senthil

  • Aug 8th, 2006
 

any exapmles... both ODS and OLTP having the current data.. then what is the difference

  Was this answer useful?  Yes

shobhit

  • Aug 11th, 2006
 

ODS :Having data with Datwarehouse that will be stand alone. No further transaction will take place for current data which is part of the data ware house. Current data will be change once you upload throgh ETL on schedule basis. 

OLTP : Having data with on line system which connected to network and all update on transaction hppened in seconds. Every second data summrasied value will get changed.

  Was this answer useful?  Yes

sindhu

  • Jan 5th, 2007
 

HI,

Though Both ODS and OLTP has current data, ODS may  contain normalized or Denormalized data. OLTP contains only normalized data.  ODS used for some of calculations and to get instant reports.OLTP used for only Transactional data.

Cheers

Navs

  • Jul 19th, 2007
 

ODS is an Operational Data System, which contains the snapshot of currently loaded data for clerical day to day analysis and includes a little history, 30-60 days of historical data in addition to the current data.

OLTP is Online Transaction Processing System, which contains only the current data and keeps changing, not suitable for analysis due to temporal inconsistency unlike ODS which contains consistent data.

  Was this answer useful?  Yes

njvijay

  • May 12th, 2008
 

1. ODS  - It is a decision support system which contains snapshot of current data for day to day analysis. This may include little history data also
   OLTP - It is a trasaction system though it contains current data it keeps changing due to lot of transaction. This does not have history data

2. ODS - It is data integrated, subject oriented, time variant and non volatile enterprise wide data for analysis
   OLTP - It is just transactional to support particular business process. It is not data integrated on different business process across organization

3. ODS - Denormalized data may contain normalized data also
   OLTP - Highly Normalized to reduce data redunduncy

dave

  • Aug 6th, 2011
 

ODS is a datastore that contains wide breath of data but not very deep(aggregated not atomic levels), OLTP is used to describe the transaction profile that will access the ODS, small predictable transactions that can do updates or deletes to the ODS. Update and delete processing in a database are heavy consumers of processing power (locking, I/O etc) over a normal read operation

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions