Oracle and Metadata Management

Gartner defines Metadata Management is all about the organization's management of its data and information assets. Metadata describes various facets of an information asset to improve its usability throughout its life cycle. Enterprise metadata management (EMM) encompasses the roles, responsibilities, processes, organization and technology necessary to ensure that the metadata across the enterprise adds value to an enterprise's data and information.


Reducing Risk and Increasing Trust in Data
Enterprise Metadata Management reduces the risk inherent in making any changes to the data in the organization, be it from the source to the final report. Where many business applications and decision systems rely on the same set of data, it is important to be able to authoritatively determine the impact that a change can affect to upstream and downstream applications. By providing in depth, easy to read and interpret lineage reports, Enterprise Metadata Management reduces these risks by identifying affected components. Combined with the use of the business glossary and transparency that Enterprise Metadata Management provides, trust in data within the organization is increased.


The Common Warehouse Metamodel (CWM) defines a specification for modeling metadata for relational, non-relational, multi-dimensional, and most other objects found in a data warehousing environment. The specification is released and owned by the Object Management Group (OMG).
The Common Warehouse Metamodel (CWM) specifies interfaces that can be used to enable interchange of warehouse and business intelligence metadata between warehouse tools, warehouse platforms and warehouse metadata repositories in distributed heterogeneous environments. CWM is based on three standards:
1. UML - Unified Modeling Language, an OMG modeling standard
2. MOF - Meta Object Facility, an OMG metamodeling and metadata repository standard
3. XMI - XML Metadata Interchange, an OMG metadata interchange standard
CWM models enable users to trace the lineage of data – CWM provides objects that describe where the data came from and when and how the data was created. Instances of the metamodel are exchanged via XML Metadata Interchange (XMI) documents.

Oracle claims to have implemented CWM model.
The Oracle Metadata Management (OMM) solutions include two products:
1. Oracle Metadata Management for Oracle Business Intelligence (OMM4OBI)
Oracle Metadata Management for Oracle Business Intelligence is a software package for metadata management of Oracle environments (Oracle database schemas, ODI, OBIEE). Oracle Metadata Management for Oracle Business Intelligence includes the following metadata management features:
    Metadata Harvesting
    Metadata Configuration and Stitching
    Metadata Browsing, Search and Reporting
    Metadata Collaboration (external URL, tagging, comments and review)
    Data Flow Lineage & Impact Analysis
    Metadata Explorer (simplified metadata user interface for business users)


2. Oracle Enterprise Metadata Management (OEMM)
Oracle Enterprise Metadata Management for is a software package for metadata management of multi-vendor environments and support for data governance. Oracle Enterprise Metadata Management includes all features of Oracle Metadata Management for Oracle Business Intelligence with the following extra metadata management features:
    Metadata Harvesting from multi-vendor technologies
    Metadata Version and Configuration Management
    Data Model Diagram Visualizer and Navigator
    Business Glossary for Data Governance
    Semantic Lineage & Impact Analysis
    Semantic Mapping Editor
    Data Flow Mapping Specifications Editor

Oracle Enterprise Metadata Management (OEMM)
The key features of Oracle Enterprise Metadata Management includes:
- Report to Source Lineage
- Impact Analysis
- Model Versioning
- Annotations and Tagging
- Supports Metadata Standards
- Build and maintain Business Glossary
- Import 3rd party Business Intelligence Metadata
- Import 3rd party ETL Metadata
- Import 3rd party Database Metadata
- Big Data Enabled
The installation of Oracle Enterprise Metadata Management (OEMM) is straight forward.
Even though the product is newly released (October 2014), the product has a lot of potential & fills a big gap in Metadata Management area.

The views and information shared here is solely owned by me.
For any further details please contact me.

Comments

Post a Comment

Popular posts from this blog

OBIEE RPD - Physical Layer design standards

OBIEE RPD consists of three layers - Physical, Business Model & Mapping (BMM), and Presentation. Physical layer is where information about physical data sources are stored. BMM layer is where measurements and terms used in business are mapped to physical sources. Presentation layer is where business model is customized for end users. As per Oracle standards/recommendation we use Import Wizard for creating a new repository file and import metadata. Connection Type used in Import Wizards: Connection type is nothing but drivers/native Application Programming Interface (API) used for accessing different databases. Some databases may be accessed using native APIs, some using ODBC. Database Object - Connection Pool Connection pool regulate access to data source. Every data source must have at least one connection pool. Connection pool provide connections to multiple concurrent queries (data source requests) immediately because of enable connection pooling. This featu...
Read more
Information on Oracle Business Intelligence Cloud Services (BICS) After Oracle Open world the buzzword is Oracle BI Cloud Services (BICS). Stoppage of further Informatica version of Oracle BI Applications 7964 (OBIA) and focus on Oracle Data Integrator is talking point. Customers are worried about the direction taken by Oracle as they invested a lot and suddenly Oracle changed its focus. For Service providers it's a challenge as well because on behalf of Oracle we have to convince our Customers how smoothly we can move them to this new world without impacting their business. Oracle BI Cloud Service is bundled with 2 products: 1. Oracle BI 2. Oracle Database Oracle BI Cloud Service is one of the Platform as a Service (PaaS) that is provided by Oracle Cloud. In a nutshell we can define BICS in 4 steps: 1. Load Your Data - In present BICS for all kind of reporting we need to upload data to Cloud Oracle database. Sources can be files, on premise systems (local sy...
Read more