Re: Attribute-value approach for table design

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

"Jeff Boyce" <nonsense@xxxxxxxxxxxx> wrote in
news:e0UivvCCHHA.1012@xxxxxxxxxxxxxxxxxxxx:

It's just that I haven't been able to determine yet whether this
is a topic that I should file under "best practices" or under
"religious wars" <g!>.

Why worry about what other people think?

Try it and if you can make it work for you and it saves time, then
use it.

I find it extremely easy to drop the lookup table and form into new
apps and then I often write queries return the individual lookup
types. I even do the sacreligious and name the queries things like
tblMyLookupValues, so that in SQL it looks like a dedicated lookup
table. I do this because it makes it easier for me conceptually, but
I can see how it could seem like a nightmare of inconsistency to an
outside programmer try to figure out what the hell was going on.

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/
.

Relevant Pages

  • Re: adding data to data base
    ... duplicates an "Indexed - no duplicates" index in the table, ... The table's error message should give you some idea ... you use the Lookup to show a person's name when ... data - when in actuality their queries are looking for the wrong data. ...
    (microsoft.public.access.tablesdbdesign)
  • Re: 10g - Need advise on large lookup table and optimizing io
    ... > I inherited an application that has 1 very large lookup table. ... Only the indexes in place are used to satisfy all queries. ... > above SELECT query like many typical queries on our system pulls lots ... > I've been doing some testing with a single table hash cluster, ...
    (comp.databases.oracle.server)
  • Re: 10g - Need advise on large lookup table and optimizing io
    ... I inherited an application that has 1 very large lookup table. ... The other type of query executed is a SELECT where this table is ... Only the indexes in place are used to satisfy all queries. ... I've been doing some testing with a single table hash cluster, ...
    (comp.databases.oracle.server)
  • 10g - Need advise on large lookup table and optimizing io
    ... I inherited an application that has 1 very large lookup table. ... Only the indexes in place are used to satisfy all queries. ... an INDEX RANGE SCAN on the index columns I just described ..and so ... I've been doing some testing with a single table hash cluster, ...
    (comp.databases.oracle.server)
  • Re: Structural Dillema
    ... Referential integrity is not quite so tight. ... because the combos and NotInList usually ... More queries to manage. ... My personal preference is to create seprate tables for each lookup. ...
    (microsoft.public.access.tablesdbdesign)