What is ODS?

The full name of ODS is Operational Data Store, which is a system for storing business data from multiple data sources, and its data is used to support business processes or input into data warehouse for analysis.

It is an operable data storage, which is a collection of "subject-oriented, integrated and variable, reflecting current data values and detailed data". ODS is an optional part of data warehouse architecture, which has some characteristics of data warehouse and OLTP system.

Extended data:

The emergence of ODS:

In system application integration, the data in each system are generally divided into two categories: business data, which has the characteristics of detail and dispersion; Decision data is comprehensive and comprehensive.

The concept of data warehouse also divides data processing into two different types: operation processing and analysis processing, thus establishing a two-tier architecture of DB-DW. However, in many cases, the two-tier architecture of DB-DW can not cover all the data processing needs of enterprises, such as some real-time decision-making problems, which require that the data collection period should not be too long and a certain degree of summary is needed.

The multi-level demand of information processing leads to the emergence of a new data environment-ODS (Operational Data Storage), which is the middle layer of DB-DW. Like DW, it is a subject-oriented integrated data environment, and like operational DB, it contains globally consistent and detailed current data. This constitutes a three-tier architecture of DB-ODS-DW about enterprise data.

Baidu encyclopedia-operation data warehouse