Results 1 to 5 of 5

Thread: What is a data dictionary?

  1. #1

    Thread Starter
    Addicted Member
    Join Date
    Nov 2007
    Posts
    134

    What is a data dictionary?

    What is a data dictionary?

  2. #2
    KrisSiegel.com Kasracer's Avatar
    Join Date
    Jul 2003
    Location
    USA, Maryland
    Posts
    4,985

    Re: What is a data dictionary?

    MyDictionary["Clock"] = "The time"

    Basically a list of items that allows you to use a "key" to access a specific value. The above is a simple example of a dictionary being used as.. well a dictionary, heh
    KrisSiegel.com - My Personal Website with my blog and portfolio
    Don't Forget to Rate Posts!

    Free Icons: FamFamFam, VBCorner, VBAccelerator
    Useful Links: System.Security.SecureString Managed DPAPI Overview Part 1 Managed DPAPI Overview Part 2 MSDN, MSDN2, Comparing the Timer Classes

  3. #3
    MS SQL Powerposter szlamany's Avatar
    Join Date
    Mar 2004
    Location
    Connecticut
    Posts
    18,263

    Re: What is a data dictionary?

    When I'm asked to produce a data dictionary it is a document - in WORD for instance - explaining all tables and field elements in those tables and how they relate and what values mean in those tables.

    Please be more specific.

    *** Read the sticky in the DB forum about how to get your question answered quickly!! ***

    Please remember to rate posts! Rate any post you find helpful - even in old threads! Use the link to the left - "Rate this Post".

    Some Informative Links:
    [ SQL Rules to Live By ] [ Reserved SQL keywords ] [ When to use INDEX HINTS! ] [ Passing Multi-item Parameters to STORED PROCEDURES ]
    [ Solution to non-domain Windows Authentication ] [ Crazy things we do to shrink log files ] [ SQL 2005 Features ] [ Loading Pictures from DB ]

    MS MVP 2006, 2007, 2008

  4. #4
    PowerPoster RhinoBull's Avatar
    Join Date
    Mar 2004
    Location
    New Amsterdam
    Posts
    24,132

    Re: What is a data dictionary?

    Data Dictionary can be used to "translate" meaningless data field names, table names, etc to the end user.
    For instance:

    in your table you may have fields such

    cid
    cfn
    cln

    ... and so on.

    If you have to build some search utility and you let people to select tables/fields then those names may need to be presented in more "human" language:

    Customer ID
    Customer First Name
    Customer Last Name

    Same basicaly goes for table names, views, etc...
    I ahve seen databases where tables/fields wree named using some numeric patterns like:

    tbl001 / fld001 / fld002

    Hope this makes some sense now.

  5. #5
    I'm about to be a PowerPoster! Hack's Avatar
    Join Date
    Aug 2001
    Location
    Searching for mendhak
    Posts
    58,333

    Re: What is a data dictionary?


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width