September 25, 2002 07:25 PM

A Business Metadata Repository

Extended properties guarantee easy access to company data
Rating: (0)
SQL Server Magazine
InstantDoc ID #26273
Imagine this scenario: You're the DBA for your company's transactional production database, and you're preparing to extract data from the database so that you can create a report for one of your company's project managers. However, you can't decide whether you should use the data from table PMBPMSRC or from table PMBPMSTRT because they contain the same two fields: OBJT and STRN. When you ask the manager who requisitioned the report which table to use, she doesn't know, either. But in the end, kn...

...This article is for paid Professional Members only.

Already a Professional Member? Please log in now:

NOT A PROFESSIONAL MEMBER? YOU CHOOSE:

Professional Membership

Monthly

Annual

VIP Membership

Monthly

Annual

Add a Comment

This article is great for getting the extended property value holders set up in the DB and for populating them. However, how do you address the problem of allowing non developers to access the metadata? Business Analysts need to be able to access the metadata too. Perhaps linking a named range in Excel to a stored proc call or the equivalent in Word to pipe up-to-date metadata into user friendly apps.

Peter Ellis 8/2/2004 1:04:43 AM


You must log on before posting a comment.

Are you a new visitor? Register Here