Skip site navigation (1) Skip section navigation (2)

Re: What is this thing that is called a "Data Dictionary?"

From: "Jasbinder Singh Bali" <jsbali(at)gmail(dot)com>
To: "Jim Stalewski" <JStalewski(at)visalighting(dot)com>
Cc: "Richard Broersma Jr" <rabroersma(at)yahoo(dot)com>, "Novice Postgresql-list" <pgsql-novice(at)postgresql(dot)org>
Subject: Re: What is this thing that is called a "Data Dictionary?"
Date: 2007-05-02 21:00:02
Message-ID: a47902760705021400u404a264ek4f4065a98ccf12a4@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-novice
I think data dictionary is automatically build by the DB.
Don't think that its a manual task.
Meta data is always build up automatically by the system intelligently.
Correct me if I'm wrong.

~Jas

On 5/2/07, Jim Stalewski <JStalewski(at)visalighting(dot)com> wrote:
>
> I just went to wikipedia.  That's what they say - a data dictionary is
> metadata, and they say that within a DBMS it's represented as a set of
> read-only tables and views.
> http://en.wikipedia.org/wiki/Data_dictionary
>
> They seem to indicate it's something that you build, though, not
> something generated by the RDBMS.
>
> Innnteresting...
>
> -----Original Message-----
> From: pgsql-novice-owner(at)postgresql(dot)org
> [mailto:pgsql-novice-owner(at)postgresql(dot)org] On Behalf Of Richard Broersma
> Jr
> Sent: Wednesday, May 02, 2007 3:29 PM
> To: Jasbinder Singh Bali
> Cc: Novice Postgresql-list
> Subject: Re: [NOVICE] What is this thing that is called a "Data
> Dictionary?"
>
> Thanks Jas for the description,  it is very helpful.
>
> Regards,
> Richard Broersma Jr.
>
> --- Jasbinder Singh Bali <jsbali(at)gmail(dot)com> wrote:
>
> > AFAIK, data dictionary is just the metadata (read only set) that
> > contains the definitions of data elements like tables, views,
> > trigggers, SPs, roles, general DB structuring, space allocation
> > methodology of the DB etc (i mean any data element inside the DB).
> >
> > It can be viewed as a simple read only file defining the basic
> > structure of the database actually, in lay men terms.
> >
> > Also most of the times, i've observed that its hidden from the users
> > even though its read only. Only DBA should have access to such kind of
>
> > file in secured systems. Thats how we implement it in our projects out
> here.
> >
> > Bookkeeping is just synonymous to a data dictionary that would not
> > contain the actual data but would essentially explain the way data
> > would be managed and how.
> >
> > I hope this helps.
> >
> > Thanks,
> > ~Jas
> >
> > On 5/2/07, Richard Broersma Jr <rabroersma(at)yahoo(dot)com> wrote:
> > >
> > > Many of the ERD and SQL books that have have read refer to a data
> > > dictionary.  However, I seem to be missing the point of what it
> > > acuatally is.  IIRC, some books refer to it as a kind of document
> > > created by a DB designer, and other suggest that it is a kind of
> > > RBDMS created metadata.
> > >
> > > Can anyone please offer a consise description or provide a link to
> > > that describes what it is?
> > > Also, how is this information useful to a DBA?
> > >
> > > Thanks for the help!
> > >
> > > Regards,
> > > Richard Broersma Jr.
> > >
> > > ---------------------------(end of
> > > broadcast)---------------------------
> > > TIP 3: Have you checked our extensive FAQ?
> > >
> > >                http://www.postgresql.org/docs/faq
> > >
> >
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: explain analyze is your friend
>
>
> This email and any files transmitted with it are confidential and intended
> solely for the use of the individual or entity to whom they are addressed.
> If you have received this email in error please notify the sender and delete
> it. Please note that any views or opinions presented in this email are
> solely those of the author and do not necessarily represent those of the
> company.
> No employee or agent is authorized to conclude any binding agreement on
> behalf of Visa Lighting with another party by email without express written
> confirmation by an authorized representative of the Company.
> Finally, the recipient should check this email and any attachments for the
> presence of viruses. The company accepts no liability for any damage caused
> by any virus transmitted by this email.
>
>
>
>

In response to

Responses

pgsql-novice by date

Next:From: Jim StalewskiDate: 2007-05-02 21:13:24
Subject: Re: What is this thing that is called a "Data Dictionary?"
Previous:From: Jim StalewskiDate: 2007-05-02 20:57:27
Subject: Re: What is this thing that is called a "Data Dictionary?"

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group