Database Answers Bienecke Reference Library, Yale University

Home About Us Ask a Question Careers Clients Contact Us Data Models Tutorials Site Map
MetaData Notes on Getting Started 
  MetaData Notes on Getting Started

To Establish the MetaData Requirements :-
1) Document the data warehouse.  
2) Show the business significance of the data to the users.
3) Help our users understand the data that we extract from our legacy systems.  

We are looking for a tool that will:-
a)  enable us to construct a meta data repository from our SQL Server Database.
b)  enable us to create models/schema of the data warehouse and update
    this schema whenever necessary
c)  enable us to present business knowledge and information about our data
    to our users so that they can be able to use this information in a way
    that is beneficial to them.

One suitable Tool is from CA called Advantage Repository.

A Do-It-Yourself' approach is to define and build a Data Dictionary in Access and
populate it using SQL and/or Spreadsheets.

ERWin is quite useful and has facilities for forward and reverse engineering
for Oracle, SQL Server, DB2 and others. 

Some Warehouse-type products, such as Cognos have their own repositories, 
eg Architect which can be populated with data in various formats,e.g.Excel,DDE
and RTF.
One useful feature of ERWin is the User Defined Properties. 
These allow you extend the information, e.g. information about Data Owners, 
Known Values, Testing Requirements, etc. 
These can be defined for a wide range of 'components', including Entity, 
Attribute, Relationship, Table, etc..

We would like to hear from you if you have any Comments or Questions
Database Stuff  
Database Trends and Applications Broad Comments on the Database Scene
DB Debunk Invariably thought-provoking - "where database fallacies are debunked",
- features Chris Date and Fabian Pascal.
DBA Click A good site for Oracle DBAs
DB Forums Recommended for Discussion Groups covering a range of Topics and a range of DBMSs
Lazy DBA A Support Group for DBAs of all persuasions.
High Performance Database Engineering Provide consulting to maximize performance for Oracle, Microsoft SQL Server, Sybase and Informix.
TUSC Probably the most highly respected Oracle consultancy.


Home About Us Ask a Question Careers Clients Contact Us Data Models Tutorials Site Map