90 likes | 201 Views
The Role of a Directory/Catalog Chapter 12. By Nancy Sunarga CSSE 541. Enterprisewide Data Warehouse. Infrastructure Tools Technology As an environment for decision support. The Challenges. Support business user & decision maker’s needs Invest in a longer-term solution
E N D
The Role of a Directory/CatalogChapter 12 By Nancy Sunarga CSSE 541
Enterprisewide Data Warehouse • Infrastructure • Tools • Technology • As an environment for decision support
The Challenges • Support business user & decision maker’s needs • Invest in a longer-term solution • Keep up with competition • Make right decisions at the right time • Provide short-term solution w/o disabling broader long-term flexibility
Critical Success Factor • A robust infrastructure • Total enterprisewide data warehouse environment
Active Directory/Catalog • Physical data • Semantic data • Environmental data
Physical Layer: Physical Data Administrative Data Environmental Data Semantic Layer: Physical Metadata Logical Metadata Contextual Metadata Physical vs Semantic Layer
Components of Active Directory/ Catalog • Administration • Browser, Search, and Request • Metadata and Physical Data Movement • Event Management • Application Programming Interfaces
Conclusions • Active directory/catalog – fundamental vehicle to connect end users to the enterprise warehouse • Some advantages: • Understand data in the warehouse • Know where data was sourced from and who owns it • Track changes to the warehouse environment