Results 1 to 4 of 4

Thread: Difference between metadata and data dictionary

  1. 06-18-2008 #1
    Diamond Sowjanya
    Diamond Sowjanya is offline
    Junior Member
    Join Date
    Jun 2008
    Answers
    2

    Difference between metadata and data dictionary

    Can anyone tell the difference between Data Dictionary and Meta data?

    Reply With Quote Reply With Quote
  2. 06-22-2008 #2
    pradeepkumar.chnv81
    pradeepkumar.chnv81 is offline
    Junior Member
    Join Date
    Jun 2008
    Answers
    2

    Re: Difference between metadata and data dictionary

    Quote Originally Posted by Diamond Sowjanya View Post
    Can anyone tell the difference between Data Dictionary and Meta data?
    metadata: this is nothing but data about data.

    for example: in oracle

    desc
    then what it displays is nothing but metadata. it means it gives feilds information,i.e nothing but metadata

    but i donot know about data dictionary.can u gv wt it mean.

    Reply With Quote Reply With Quote
  3. 06-22-2008 #3
    pradeepkumar.chnv81
    pradeepkumar.chnv81 is offline
    Junior Member
    Join Date
    Jun 2008
    Answers
    2

    Re: Difference between metadata and data dictionary

    can u gv wt the diff b/w informatica 7 series and informatica 8 series

    Reply With Quote Reply With Quote
  4. 07-09-2008 #4
    sunsat007
    sunsat007 is offline
    Junior Member
    Join Date
    Jul 2008
    Answers
    1

    Re: Difference between metadata and data dictionary

    Metadata : Data about data is called matadata. Eg: Desc emp. The output is metadata. It has only the table structure description and constraints defined on it.Meta data is a subset of data dictionary.


    Data Dictionary: This typically includes the names and descriptions of various tables and fields in each database, plus additional details, like the type and length of each data element. Data dictionary contains information that the DBMS requires to perform its functions and support its particular implementation.
    NOTE: This is not universally defined.
    Items typically found in a DBMS data dictionary include:

    detailed descriptions of tables and fields
    indexing information
    referential integrity constraints
    database schema definitions
    stored procedures and database triggers
    access control information, such as usernames, roles, and privileges
    storage allocation parameters
    database usage statistics


    Regards,
    Sun

    Reply With Quote Reply With Quote
    5. « Previous Thread | Next Thread »

    Posting Permissions

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

    Forum Rules

    About us
    Applying for a job can be a stressful and frustrating experience, especially for someone who has never done it before. Considering that you are competing for the position with a at least a dozen other applicants, it is imperative that you thoroughly prepare for the job interview, in order to stand a good chance of getting hired. That's where GeekInterview can help.
    GeekInterview
    Interact