Content deleted Content added
No edit summary |
Adding local short description: "Type of operational reporting database", overriding Wikidata description "database used for operational reporting and incoming data source for the Enterprise Data Warehouse" |
||
(35 intermediate revisions by 23 users not shown) | |||
Line 1:
{{Short description|Type of operational reporting database}}
{{No footnotes|date=April 2023}}
An '''operational data store''' ('''ODS''') is used for operational reporting and as a source of data for the [[enterprise data warehouse]] (EDW). It is a complementary element to an EDW in a [[decision support]]
An
An operational data store should not be confused with an enterprise data hub (EDH). An operational data store will take transactional data from one or more production system and loosely integrate it, in some respects it is still subject oriented, integrated and time variant, but without the volatility constraints. This integration is mainly achieved through the use of EDW structures and content.▼
▲An
An ODS is not an intrinsic part of an Enterprise Data Hub solution, although an EDH may be used to subsume some of the processing performed by an ODS and the Enterprise Data Warehouse. An EDH is a broker of data. An ODS is certainly not.▼
▲An ODS is not an intrinsic part of an
▲An '''operational data store''' (or "'''ODS'''") is a [[database]] designed to [[data integration|integrate data]] from multiple sources for additional operations on the data, for reporting, controls and operational decision support. Unlike a production master data store, the data is not passed back to [[operational system]]s. It may be passed for further operations and to the [[data warehouse]] for reporting.
Because the [[data]]
==General use==
Line 16 ⟶ 17:
==See also==
* Some examples of ODS
▲* Some examples of ODS Architecture Patterns can be found in the article [[Architectural pattern (computer science)#Examples|Architecture Patterns]].
* [[Enterprise architecture]]
* [[Third normal form]] (3NF)
==Further reading==▼
* {{cite book |last1=Inmon |first1=William |author1-link=Bill Inmon |title=Building the Operational Data Store |edition=2nd |location=New York |publisher=[[John Wiley & Sons]] |year=1999 |isbn=0-471-32888-X}}▼
==External links==
* [http://www.information-management.com/issues/20000101/1749-1.html Bill Inmon Information Management article on the five classes of ODS]
* {{cite web |url=https://www.intelsols.com/documents/Imhoff_10-02.pdf |author=Claudia Imhoff |title=
▲==Further reading==
▲* {{cite book |last1=Inmon |first1=William |author1-link=Bill Inmon |title=Building the Operational Data Store |edition=2nd |location=New York |publisher=[[John Wiley & Sons]] |year=1999 |isbn=0-471-32888-X}}
{{Data warehouse}}
{{DEFAULTSORT:Operational Data Store}}
[[Category:Data management]]
[[Category:Data warehousing]]
[[Category:Management cybernetics]]
|