Publicação original = Fórum SBGC-TIC 28/1/2008 7:23 PM
Abaixo algumas referências de mercado sobre a construção e uso de ambientes de gestão corporativa, bem como suas interfaces com a WEB e demais ambientes de automação de processos de uma Organização. Considero o desenho abaixo um dos melhores painéis gerais de contexto técnico (TIC) para desenvolvimento de aplicações corporativas.
Corporate Information Factory ( http://www.inmoncif.com/cif/index.html )
EDW (enterprise data warehouse) - the EDW is the center of the
Corporate Information Factory. The EDW contains data that is:
granular,
integrated,
historical, and
corporate.
The data found in the EDW
feeds data marts, exploration warehouses, data mining warehouses, and class IV
ODS. In short the data found in the EDW serves as a foundation for all data
warehouse and DSS processing.
The data found in the EDW is sometimes
called the "single point of truth" for the corporation. The data is granular and
non redundant and is at the basis of reconciliation of disputes when two or more
people disagree as to a result obtained from analysis of the Corporate
Information Factory.
The EDW is stored on both primary storage and
alternative storage. The primary storage is almost always high performance disk
storage. Alternative storage is near line or secondary storage.
--------------------------------------------------------------------------------
For More Information - Browse the articles below
1.
Security Across The Corporate Information Factory by W. H. Inmon
2.
Meaning And Shades Of Meaning by W. H. Inmon
3. Data Warehouse and
Testing by W. H. Inmon
4. Data Warehouse Types by W. H. Inmon
5.
The Data Warehouse Foundation by W. H. Inmon
6. Deep History: What Good
Is It? by W. H. Inmon
7. Anatomy of a Data Warehouse Record by W. H.
Inmon.
8. What Happens When You Have Built the Data Mart First? by W. H.
Inmon.
9. Definition of a Data Warehouse by W. H. Inmon.
10. The
Data Warehouse Infrastructure by W. H. Inmon.
11. Monitoring the Data
Warehouse Environment by W. H. Inmon.
12. Referential Integrity for the
Data Warehouse Environment by W. H. Inmon.
13. Enterprise Data Warehouse
and Time by W. H. Inmon.
14. Enterprise Data Warehouse and Joins by W.
H. Inmon.
15. Enterprise Data Warehouse and Partitioning by W. H. Inmon.
16. Summary Data in the Enterprise Data Warehouse by W. H. Inmon.
17. Enterprise Data Warehouse Underlying Technology by W. H. Inmon.
18. Using the Enterprise Data by W. H. Inmon.
19. Enterprise
Data Warehouse by W. H. Inmon.
20. Multiple Data Warehouses in the Same
Company by W. H. Inmon.
21. Profile Records by W. H. Inmon.
22.
Reference Data by W. H. Inmon.
23. Rolling Summary Data by W. H. Inmon.
24. Time Variant Types by W. H. Inmon.
25. Data Velocity Through
The Corporate Information Factory by W. H. Inmon and R. H. Terdeman
26.
Closed-Loop/Open-Loop Architecture by W. H. Inmon.
27. Budgeting for the
Data Warehouse by W. H. Inmon
28. Data Warehouse: Where Technology and
Business Meet by W. H. Inmon
29. Iterative Development For The DSS Data
Warehouse Environment by W. H. Inmon
30. Data Warehouse and Iterative
Development by W. H. Inmon
31. Enhancing Data Warehouse Performance by
W. H. Inmon
32. Little White Lies by W. H.
Operational Data Store
The ODS is half
operational and half DSS
A Brief Description
The Operational Data
Store (ODS) is a hybrid structure that has characteristics of both the data
warehouse and operational systems. Because the ODS is a hybrid structure, it is
difficult to build and operate. The ODS allows the user to have:
· OLTP
response time (2/3 seconds),
· update capabilities
· DSS
capabilities
--------------------------------------------------------------------------------
For More Information - Browse the articles below
Introduction:
The Operational Data Store by W. H. Inmon.
Operational Data Store by W. H.
Inmon.
From Transactions to the ODS by W. H. Inmon.
Designing the ODS by
W. H. Inmon.
ODS Development by W. H. Inmon.
ODS Refreshment by W. H.
Inmon.
ODS Underlying Technology by W. H. Inmon.
Using the ODS by W. H.
Inmon.
ODS Workload by W. H. Inmon.
ODS Types by W. H. Inmon
ERP as
ODS by W. H. Inmon
Operational and Informational Reporting by W. H. Inmon.
An Early Article on The Operational Data Store by W. H. Inmon.
Internal
ODS/External ODS In The eBusiness Environment by W. H. Inmon.
--------------------------------------------------------------------------------
White Papers
The Operational Data Store - the operational
counterpoint of the data warehouse is the operational data store (the "ODS").
The ODS is defined and described in detail in this white paper.
Operational
and DSS Processing From a Single Data Base: Separating Fact and Fiction - an
early notion was that a single database should serve as the basis for both
operational processing and DSS analytical processing. This white paper explores
the issues and describes why data warehouse is the appropriate foundation for
DSS informational processing.
Accessing Data Warehouse Data From the
Operational Environment - most flow of data is from the operational environment
to the data warehouse environment, but not all. This white paper discusses the
"backward" flow of data.
Information Architecture for the 90's: Legacy
Systems, Operational Data Store and the Data Warehouse - describes the role of
operational data stores and a description of them, along with a description of
the architecture that results when you mix an operational data store and a data
warehouse.
Telling the Difference Between Operational and DSS - in every
shop the issue arises, what is operational and what is DSS. This white paper
tells you how to tell the difference between the two environments.
Summary
Data in the Data Warehouse/Operational Data Store - summary data has its own set
of unique considerations. There is, for example, dynamic summary data and static
summary data. Both types of summary data require very different treatment from
the designer and the end user. This white paper creates a taxonomy for summary
data and relates the different types of summary data to the data warehouse and
the operational data store.
--------------------------------------------------------------------------------
Books
Inmon, W H - BUILDING THE DATA WAREHOUSE, SECOND
EDITION, John Wiley, NY, NY 1996
Inmon, W H - BUILDING THE OPERATIONAL DATA
STORE, John Wiley, NY, NY 1995
Inmon, W H - CORPORATE INFORMATION FACTORY,
John Wiley, NY NY 1998
Nenhum comentário:
Postar um comentário