What is the difference between OLTP and ODS?

Question Posted / guest

4 Answers
27989 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

What is the difference between OLTP and ODS?..

Answer / mohit sondhi

OLTP is online transaction processing systems and ODS os
operational database system.
In OLTP we can save the current data, it depends on the day
to day transactions and it stores the day to day data.

In ODS we can store data for a month also and it is not
restricted to a specific day or transaction.

Is This Answer Correct ?

16 Yes

6 No

What is the difference between OLTP and ODS?..

Answer / himanshu

OLTP : Online Transaction Processing
The granularity of the data is Transaction i.e. stores each
transaction.

ODS: Operational Data Store
As dataware house contains summarized data
(Weekly/Monthly/Yearly). ODS may be used to maintain data
with lower granilarity (Hourly/Daily).

eg. Data for previous years may be summarized but sould not
be for the current year.

Is This Answer Correct ?

7 Yes

1 No

What is the difference between OLTP and ODS?..

Answer / edh

I've got a web application used for creating product orders
backed by an RDBMS.

The RDBMS contains the necessary tables to store the facts
(orders and orderlines) and reference data (product, vendor,
price, customer, ...).

The RDBMS is ever growing. That is, there's no cleanup of
"old" records (e.g. orders from x years back).

What kind of database is this and why ?
An OLTP, an OLAP, an ODS, ..., something else ?

Please advise.

EDH

Is This Answer Correct ?

1 Yes

3 No

What is the difference between OLTP and ODS?..

Answer / sri47

OLTP refers a transactional Data base.

ODS refers a data base which actually contains the Basic
data like the details of available Procts,and Branches of
Company etc.
Means It will be small in size and can be modified
daily.Most of the times Thos ODs is used for loading the
Dimensions.

Is This Answer Correct ?

1 Yes

5 No

Post New Answer