
|
 |
 |
|
 |
 |
| |
 |
 |
The diagram on the left shows our six Stages in our Framework for Data Management.
This page takes a closer look at the requirements for software support and what some suppliers have to offer.
For this analysis the four Stages of interest are :-
Data Governance
Data Integration
Data Sources
Information Catalogue
The process can be summarised in the following terms :-
Step 1. Identify the Data Sources and store details in the Information Catalogue.
Step 2. Identify the Data Targets.
This will involve storing details in the Information Catalogue and creating a Generic Target Data Model.
Step 3. Define the validation, clean-up and transformation from Data Sources to Data Targets.
The table below shows how Oracle meets the requirements defined by the Generic Features.
|
|
 |
|
 |
 |
| |
 |
 |
 |
|
 |
| |
STAGE |
GENERIC FEATURES |
ORACLE |
Data Governance |
User roles, responsibilities and permissions help Governance |
  |
Data Governance |
Generate Data Governance Services at runtime |
  |
Data Integration |
Specifications for Mapping between Sources and Targets |
  |
Data Integration |
Rules for Data Validation, Clean-up and Transformation |
  |
Data Integration |
Data Models for Sources and Targets |
  |
Data Sources |
Inventory of Systems, Owners, Databases, Tables and so on |
|
Information Catalogue |
Record all details - Glossary of Terms, Data Sources, Mappings and so on |
  |
Other |
Compliant with
OMG standards, including
BPMN,
SBVR,
UML
and
XML.
|
|
|
|
|
|