|
|
|
|
|
|
  |
|
Question : What is an Information Catalogue ?
An Information Catalogue can play a very important role in Data Integration.
It can also be called a Data Dictionary or an Information Repository.
Wikipedia has an entry for a Data Dictionary that is worth checking out.
Wikipedia also has an entry for Information Repository which describes something different.
An Information Catalogue can be used to record every activity and decision of importance relating to Data Integration at each Stage.
It can play a role from the beginning, by recording Data Owners and Data Sources.
Then during the Data Integration Stage, it can record details of Tables, Fields, Rules for Validation, Mapping and Translation.
In the Reporting Stage, it can be used to record definitions of Report Templates and specific variations of the Templates for specific Projects.
In the Data Governance Stage, it can be used to record decisions and agreements reached in critical aspects of Data Management.
The best use of the Information is to be deployed over an Intranet and/or in the Clouds so that individuals throughout an organization
can share the Information, comment on issues and so on.
Some commercial products are available, listed here alphabetically :-
� ASG Rochade �The world�s leading Metadata Repository� �
� Computer Associates Repository for Distributed Systems
� IBM Repository
� IBM SOA Repository
� Oracle Enterprise Repository
� Unisys used to market a product called Universal Repository but a search of their Web Site revealed nothing, except that
Sybase acquired the rights to it back in 1998.
The selection of a commercial product should include the ability to exchange data and metadata.
This can be achieved by XMI or by the SQL that creates the Tables.
Click to go back to the Home Page.
 
|
|
|
© Database Answers Ltd. 2010
|
|