Concepts - what is the difference between ODS and OLTP

GeekInterview.com > Interview Questions > Data Warehousing > Concepts

Go To First | Previous Question | Next Question

Concepts | Question 14 of 29

what is the difference between ODS and OLTP

Total Answers and Comments: 7

Last Update: May 12, 2008 Asked by: stalin.thangaraj

Sponsored Links

Best Rated Answer

—

No best answer available. Please pick the good answer available or submit your answer.

August 04, 2006 14:51:56

mamatha

RE: what is the difference between ODS and OLTP

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

Is this answer useful? Yes | No

August 08, 2006 05:46:54

senthil

RE: what is the difference between ODS and OLTP

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

Is this answer useful? Yes | No

August 11, 2006 03:38:01

shobhit

RE: what is the difference between ODS and OLTP

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.

Is this answer useful? Yes | No

November 13, 2006 08:53:29

phanimv

Member Since: July 2006 Contribution: 40

RE: what is the difference between ODS and OLTP

ODS(Operational Data Sources) mainly it uses Operational Monitoring. Unlike OLTP, ODS are Integrated, Subject-Oriented and Enterprisewide data.

Is this answer useful? Yes | No

January 05, 2007 16:24:25

sindhu

RE: what is the difference between ODS and OLTP

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

Is this answer useful? Yes | No

July 19, 2007 15:11:53

Navs

RE: what is the difference between ODS and OLTP

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.

Is this answer useful? Yes | No

May 12, 2008 04:52:01

njvijay

Member Since: May 2007 Contribution: 10

RE: what is the difference between ODS and OLTP

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

Is this answer useful? Yes | No

Go To Top