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