Re: Latest version of glossary

"dawn" <dawnwolthuis@xxxxxxxxx> wrote:

entity: a thing of interest

No one really seems to know. It's commonly claimed that an "entity"
corresponds to some object or event. That's the common parlance. And
so any number of tables/relations could describe this, entity. But in
other contexts, entity could refer to something else. You suggested
modelling. In ER a record/row might be called a "specific entity", the
PK the "entity identifier", and so on.

dimension:
1) A relation R is of dimension n if each tuple in R is an n-tuple

More typically called, degree.

2) An n-dimensional data structure, S, is one where each element of S
can be uniquely addressed as S[i1][i2]...[in]

Depends. Is the "data structure" a table which roughly represents a
"relation"? Is it a network or tree of tables? Might the dimension
also mean the scale of measurement which is applied? Anyway.

If an n-tuple, again, it's generally referred to as, degree. The
number of tuples/rows would be its cardinality.

If a named table, then it could trivially be addressed in order, if I
understand your use of brackets, but only because the foreign keys
create that fixed hierarchy.


flat: an object which by any definition could be considered as 2
dimensional might informally be called flat.

I would think so. It poses certain problems, which may not seem so
great to those in the flat-land. But they could not be flat, at all,
with less than two dimensions.


Note: any use of the term flat tends to be seen as inflammatory by
someone

It's a lot for a flatlander to consider redesigning his own scheme and
place in it if he is given the option of a third dimension. It's a lot
of work, at the least.
.

Relevant Pages

  • Re: Simple question
    ... but it's sufficiently flat for me to ignore the variations. ... As for the variations along the Y dimension, ...
    (sci.stat.math)
  • Re: Database design
    ... I don't know your "definition of being flat". ... Actually we can continue to different depth along different dimension - any dimension may have its own depth. ... can continue this space hierarchy in the opposite direction. ... A relation is not equivalent to a n-dimensional space. ...
    (comp.databases.theory)
  • Latest version of glossary
    ... We could maybe add dimension, entity, flat, ... such as "XML entity" to distinquish it from the more ... any use of the term flat tends to be seen as inflammatory by ...
    (comp.databases.theory)
  • Re: table structure for olap
    ... You can either use star schema (every dimension links to the fact) or ... Which one you would state as flat I' not sure.... ... helper" tables to make a hierachy of parents with the same children - and to ... OLAP performs best with hierachies - not so good with large flat dimensions. ...
    (microsoft.public.sqlserver.olap)
  • Re: Latest version of glossary
    ... We could maybe add dimension, entity, flat, ... Uniqueness is a property of the representation mechanism - it is not a dimensionality issue. ... I find it very important to separate these two concerns: how dimensions are defined and how tuples are represented/accessed. ...
    (comp.databases.theory)