Transcript Document

• Operational Data Store
https://store.theartofservice.com/the-operational-data-store-toolkit.html
Master data management Solutions
1
The tools include data networks, file
systems, a data warehouse, data
marts, an operational data store, data
mining, data analysis, data
virtualization, data federation and
data visualization. One of the newest
tools, virtual master data
management (also called virtual
mdm) utilizes data virtualization and
a persistent metadata server to
implement a multi-level automated
MDM hierarchy.
https://store.theartofservice.com/the-operational-data-store-toolkit.html
Operational data store
1
An operational data store (or "ODS") is
a database designed to integrate data
from multiple sources for additional
operations on the data. The data is
then passed back to operational
systems for further operations and to
the data warehouse for reporting.
https://store.theartofservice.com/the-operational-data-store-toolkit.html
Operational data store - Publications
Inmon, William (1999). Building the
Operational Data Store (2nd ed.). New
York: John Wiley & Sons. ISBN 0-47132888-X.
1
https://store.theartofservice.com/the-operational-data-store-toolkit.html
Extract, transform, load
1
Loads it into the end target (database,
more specifically, operational data store,
data mart, or data warehouse)
https://store.theartofservice.com/the-operational-data-store-toolkit.html
Data loading
1
* Loads it into the end target (database,
more specifically, operational data store,
data mart, or data warehouse)
https://store.theartofservice.com/the-operational-data-store-toolkit.html
Fact (data warehouse)
1
The data stored in the warehouse are
Uploading and downloading|uploaded
from the operational systems (such as
marketing, sales etc., shown in the
figure to the right). The data may pass
through an operational data store for
additional operations before they are
used in the DW for reporting.
https://store.theartofservice.com/the-operational-data-store-toolkit.html
Fact (data warehouse)
The integration layer integrates the
disparate data sets by transforming the
data from the staging layer often storing
this transformed data in an operational
data store (ODS) database
1
https://store.theartofservice.com/the-operational-data-store-toolkit.html
Fact (data warehouse)
The integrated data source systems
may be considered to be a part of a
distributed operational data store layer
1
https://store.theartofservice.com/the-operational-data-store-toolkit.html
Fact (data warehouse) - Top-down design
Gartner released a research note
confirming Inmon's definition in
2005Gartner, Of Data Warehouses,
Operational Data Stores, Data Marts and
Data Outhouses, Dec 2005 with additional
clarity plus they added one additional
attribute
1
https://store.theartofservice.com/the-operational-data-store-toolkit.html
Fact (data warehouse) - Top-down design
1
; No virtualization: A data warehouse
is a physical repository.Gartner, Of
Data Warehouses, Operational Data
Stores, Data Marts and Data
Outhouses, Dec 2005
https://store.theartofservice.com/the-operational-data-store-toolkit.html
Fact (data warehouse) - Hybrid design
1
To consolidate these various data
models, and facilitate the extract
transform load (ETL) process, DW
solutions often make use of an
operational data store (ODS)
https://store.theartofservice.com/the-operational-data-store-toolkit.html
Data warehouses
1
The data stored in the warehouse are
Uploading and downloading|uploaded
from the operational systems (such as
marketing, sales, etc., shown in the
figure to the right). The data may pass
through an operational data store for
additional operations before they are
used in the DW for reporting.
https://store.theartofservice.com/the-operational-data-store-toolkit.html
Data warehousing
The data stored in the warehouse is
Uploading and downloading|uploaded
from the operational systems (such as
marketing, sales, etc., shown in the figure
to the right). The data may pass through
an operational data store for additional
operations before it is used in the DW for
reporting.
1
https://store.theartofservice.com/the-operational-data-store-toolkit.html
Data warehousing
1
The integration layer integrates the
disparate data sets by transforming
the data from the staging layer often
storing this transformed data in an
operational data store (ODS) database
https://store.theartofservice.com/the-operational-data-store-toolkit.html
BusinessObjects Data Integrator
The Data Integrator product consists
primarily of a Data Integrator Job Server
and the Data Integrator Designer. It is
commonly used for building data marts,
Operational data store|ODS systems and
data warehouses, etc.
1
https://store.theartofservice.com/the-operational-data-store-toolkit.html
Semantic warehousing
In data management, 'semantic
warehousing' is a methodology of digitalized
text data using similar functions to Data
warehousing (DW), such as ETL(Extract,
transform, load), ODS(Operational data
store), and MODEL. Value (computer
science)|Key value operation is less useful
for the digitalized text. Semantic warehousing
is different from DW in that semantic
information base from text(semantic) data.
1
https://store.theartofservice.com/the-operational-data-store-toolkit.html
For More Information, Visit:
• https://store.theartofservice.co
m/the-operational-data-storetoolkit.html
The Art of Service
https://store.theartofservice.com