Building and managing the Meta Data Repository: A Full Life-Cycle Guide
Building and managing the Meta Data Repository: A Full Life-Cycle Guide
Data Warehousing in the Real World: A Practical Guide for Building Decision Support Systems
Data Warehousing in the Real World: A Practical Guide for Building Decision Support Systems
ORM and MDM/MMS: integration in an enterprise level conceptual data model
OTM'10 Proceedings of the 2010 international conference on On the move to meaningful internet systems
Enterprise data architecture: development scenarios using ORM
OTM'11 Proceedings of the 2011th Confederated international conference on On the move to meaningful internet systems
Hi-index | 0.00 |
The classic definition of metadata is simply stated as data about data. Straightforward as it may be, this data can be very powerful. In this paper we will explore the possibility of how we can leverage metadata in a typical enterprise environment to produce efficiencies, increase data quality/confidence and improve business decision making. To set the stage we will briefly describe the environment depicted in the diagram below. Transactional systems will act as the source of data. As data flows down stream it often resides in a data warehouse, which supports Decision Support Systems (DSS). A data warehouse provides an analytical environment and acts as a repository for an organization's historical data. From the warehouse the data lineage is continued as data marts are created down stream for specific reporting areas and as integration is built among the different analytical environments. The collection of data lineages, we will refer to as the Information Supply Chain (ISC). Metadata is the key enabler binding together the web of data in the ISC. This type of environment often presents a challenge - business users and system analysts struggle trying to fully understand the business rules, data lineage and business definitions of data terminologies. We propose using Object Role Modeling (ORM) to design and build a central metadata repository that supports the retention of data definitions and data lineage of the ISC plus other metadata properties required in a repository system to play an active role throughout the lifecycle of data from source to BI reporting. The metadata repository will hold the knowledge of the enterprise shareable systems and data and make it available at the conceptual level. We will leverage ORM and the centralized repository to produce the following key features: • Model and build a metadata management system • Extract metadata from ORM into the metadata repository • Explore metadata based automation of data mart schemas and ETL specifications • Automate the code generation of stored procedures and class objects based on metadata