Database Answers  
You are not logged in: login | why register ?
Home Ask a Question Careers Clients Community Data Models Search Site Map Contact Us
Data Governance
BI+Performance Rpts
Data Marts
Data Integration
Data Sources
Information Catalogue


Architecture
 
    If you have a Question that is not addressed here, please feel free to email us your Question.
    
    What is an Information Catalog (or Catalogue) ?
    
  • An Information Catalog is a common Repository for all data and information related to Enteprise Data Management.
  • As a result, it can play a very important role in Data Integration.
  • The design will usually reflect the Project and the culture wihtint the organisation and change from time-to-time.
  • Initial format will often include Word documents and Spreadsheets, and these might migrate to a Database..
  • Therefore a flexible approach is required, which will usually be based on Extendable Tables.
  • The contents will include Applications, Databases, Details of People, Roles and Repsonsibilities, Mapping Specigications for Data Integration and so on
  • It will usually be published over the corporate Intranet with clearly-defined privileges for who can create, update, access and provide feedback on the content.
  • n Information Catalogue 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. Why is this Stage important ?
  • It provides a single point of access to details of all progress, objectives, milestones and so on.
  • It contains the details necessary to support Data Lineage by tracking each data item from origin to destination. How do we get started ? Step 1. Agree the format for the initial Information Catalogue. For example, start with Spreadsheet, migrate to Access then online Database and finally �In the Clouds�. Step 2. Agree initial content and update procedures. Step 3. Agree Publish and Subscribe procedures. Step 4. Identify the individuals responsible for data gathering and dissemination.
  • An excellent way to help you get started by clarifying your requirments is to evaluate some commercial products.
  • A number of products are available, and we have listed some here alphabetically :-
  • 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.
  •  

    © Database Answers Ltd. 2010

    Home Ask a Question Careers Clients Community Data Models Search Site Map Contact Us