What is ODS?

 

Abstract:

 

The multi-level requirements of information processing lead to a new data environment-DB-DW
Middle Layer ODS
(Operational data storage. ODS
Yes"
Theme-oriented, integrated, current or near, and constantly changing"
Data. Through unified planning, standardized framework and data, ODS
It can achieve operational data integration and data exchange between various systems, provide real-time operational reports, and reduce the burden on data warehouses,
Construction OD
S
You can also prepare for the later data warehouse construction.

 

What is ODS?

ODS
Operational data
Store
That is, operational data storage, is"
A topic-oriented, integrated, and variable set of data that reflects the current data value and detailed data to meet enterprises' comprehensive, integrated, and operational processing needs.
(Bill. inmon)
. ODS
Is an optional part of the data warehouse architecture, ODS
Some features of data warehouse and OLTP
Some features of the system. "

 

1.1
ODS
Appears

In System Application Integration, data in each system is generally divided into two types: operational data with details
Informatization
, The characteristics of decentralization; Decision-Making data, integration, integration
Informatization
.

The concept of Data Warehouse is also divided into two different types of data processing: Operational Processing and analytical processing, thus the DB-DW is established.
Two-tier architecture. But there are a lot of cases, DB-DW
The two-tier architecture does not cover all the data processing requirements of the enterprise,
For example, some real-time decision-making problems,
It requires that the data acquisition cycle cannot be too long,
It also needs to be summarized to a certain extent. The multi-level requirements of information processing lead to a new data environment-DB-DW
Middle Layer ODS
(Operational data storage. It is like DW
It is also a topic-oriented, integrated data environment, and similar to an operational dB.
It also contains the global consistent and detailed current data. This constitutes a DB-ODS-DW
The three-tier architecture of enterprise data.

 

1.2
Comparison with application systems and Data Warehouses

 

According to Bill. inmon, the father of the data warehouse
"Data Warehouse is subject-oriented, integrated, stable, and time-changing. It is mainly used for decision-making support of database systems ". Data warehouse and ODS
Comparison with databases: Comparison Projects

Data Warehouse

ODS

Application System

 

Purpose

Decision support

Real-time Monitoring

Business Operations

 

Target customers

Enterprise Management

Business Management

Production Layer

 

Storage Period

Long-term

Short-term

Instant

 

Processing frequency

Non-Real-Time

Quasi-Real-Time

Real-time

 

Main functions

Analysis Function

Transaction Processing and short-term analysis

Transaction Processing

 

Technical Implementation

OLAP

OLAP
OLTP

OLTP

 

Function Structure

Centralized

Relatively Concentrated

Scattered

 

Data Type

Detailed data,
Summary data

Detailed data

Detailed data

 

Data capacity

Very large

Small

Small

 

1.3

Application Integration solution comparison implementation solution

Implementation result

Advantages

Defects

 

Data Warehouse (DW)

Enterprises can analyze DW
For medium-and long-term planning.

It can meet enterprises' decision-making needs

Cannot meet enterprises' real-time monitoring and real-time business needs

 

Operational data storage (ODS)

Enterprises can grasp ODS
Current comprehensive data in to keep control of the enterprise's timely operation

It can meet enterprises' real-time monitoring and real-time business needs.

Unable to meet enterprises' medium-and long-term decision-making needs

 

DW + ODS

Enterprises can analyze ODS
Current comprehensive data in to control the current operation of the enterprise;
Able to analyze DW
To make reasonable plans for the future.

ODS
The introduction and application of technology enables enterprises to perform real-time OLAP in their daily operations
A solution is provided, so that enterprises do not need to build a "bloated" DW
In this way, you can make some non-strategic middle-level decisions to achieve daily management and control of the enterprise, and get a fast response speed.