sekhar

• Sep 15th, 2005

 

that which is volatile is ODS and the data which is nonvolatile and historical and time varient data is DWh data.in simple terms ods is dynamic data.

obula reddy

• Dec 26th, 2005

 

            A dataware house is a decision support database for organisational needs.It is subject oriented,non volatile,integrated ,time varient collect of data.

               ODS(Operational Data Source) is a integrated collection of related information . it contains maximum 90 days information.

bhaskar

• Jan 16th, 2006

 

ods is nothing but operational data store is the part of transactional database. this db keeps integrated data from different tdb and allow common operations across organisation. eg: banking transaction.

kmalla

 Profile Answers by kmalla 

• Jun 29th, 2006

 

I think guys it is Operation DataSource rather than Operational data stage

Dharmendra

• Sep 22nd, 2006

 

An operational data store (or "ODS") is a database designed to integrate data from multiple sources to facilitate operations, analysis and reporting. Because the data originates from multiple sources, the integration often involves cleaning, redundancy resolution and business rule enforcement. An ODS is usually designed to contain low level or atomic (indivisible) data such as transactions and prices as opposed to aggregated or summarized data such as net contributions. Aggregated data is usually stored in the Data warehouse.

Ramyapriya Sudhakar

• Jul 9th, 2014

 

operational data store :
It is unlike real EDW ,data is refreshed near real time and used for routine business activity.
It is used as an interim logical area for data warehouse.
This is the place where most of the data used for current operations is housed before transferring it into the data warehouse for longer storage.


Data warehouse :
Data warehouse is a subject oriented, time variant, integrated, non volatile collection of data for business decision making.
data warehouse is not a single software or hardware product to provide strategic information.
It is rather a computing environment where users can find strategic information and put directly in touch with data to make better decisions.
It is a user centric environment
In this you integrate and transform enterprise data into information suitable for strategic decision making.