Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Theoretical definition for the number of unique values?

Re: Theoretical definition for the number of unique values?

From: Gord <gdt_at_kingston.net>
Date: 12 Apr 2007 15:12:20 -0700
Message-ID: <1176415940.474928.102980@y5g2000hsa.googlegroups.com>


On Apr 12, 4:14 pm, David Kerber
<ns_dkerber_at_ns_WarrenRogersAssociates.com> wrote:
> In article <461e877b$0$328$e4fe5..._at_news.xs4all.nl>,
> use..._at_No.Spam.Please.invalid says...
>
>
>
> > sqlservernew..._at_yahoo.com wrote:
> > > Hi Everyone,
>
> > > Here is a theoretical, and definition question for you.
>
> > > In databases, we have:
>
> > > Relation
> > > a table with columns and rows
>
> > > Attribute
> > > a named column/field of a relation
>
> > > Domain
> > > a set of allowable values for one or more attributes
>
> > > Tuple
> > > a row of a relation
>
> > > Degree
> > > the number of attributes a relation contains
> > > Number of fields in a table
>
> > > Cardinality
> > > the number of tuples/rows a relation contains
>
> > > But!
>
> > > What is the definition for the number of unique values in a field?
>
> > > So, if you have 100 rows in a table, and the field is
> > > the gender field, with only values of: M, F.
> > > The result is 2 unique values.
>
> > > What do we call this concept?
> > > "the number of unique values in a column?"
>
> > > Is there one?
>
> > > Thanks a lot!
>
> > (Column) Cardinality = number of distinct column/attribute values.
> > Table Cardinality = number of rows in a table.
>
> Shouldn't that be *distinct* (non-duplicate) rows in the table?

I believe that one of the cardinal rules (pun intended) of RDBMS theory is that a table can never have duplicate rows.

> --
> Remove the ns_ from if replying by e-mail (but keep posts in the
> newsgroups if possible).
Received on Thu Apr 12 2007 - 17:12:20 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US