Re: id record for each table

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: --CELKO-- (jcelko212_at_earthlink.net)
Date: 07/15/04 

Date: 14 Jul 2004 18:38:52 -0700

>> If I've got a table which not own identity field [sic] how can I
look up a record [sic] based in their natural order [sic]. Something
like that: "I am looking for record [sic] number 1123" <<

You have completely missed the **entire foundations** of the
relational model.

Let's get back to the basics of an RDBMS. Rows are not records; fields
are not columns; tables are not files; there is no sequential access
or ordering in an RDBMS, so "first", "next", "last" and "natural
order" are **totally meaningless**. Tables model sets; sets are
completed wholes, not a sequence.

You have no idea what a LOGICAL key is. For some reason, you think
that a particular PHYSICAL implementation IS the logical model (not
all SQL product use physically contigous storage).

Please get any basic intro book on RDBMS and read it.

Relevant Pages

  • Re: Need advice w/ table design
    ... >> I'm thinking about defining all business objects in one table i.e. ... Relational Model; we have entities, relationships, attributes and ... Let's get back to the basics of an RDBMS. ... Read a book on basics; your entire approach is totally wrong. ...
    (microsoft.public.sqlserver.programming)
  • Re: No knowledge of the database?
    ... don't have a clue about DBMS and Codd's relational model? ... >>The fact is that you're talking about decoupling the logical data model ... usually because so many legacy applications directly depends on ... RDBMS are (more or less, ...
    (comp.object)
  • Re: How to find first not null value in column
    ... Let's get back to the basics of an RDBMS. ... Next, you are talking about SQL as if you were in a file system, where ... WHERE klugger IS NULL ...
    (comp.databases.ms-sqlserver)
  • Re: Data Layer architecture
    ... Also it doesn't have to conflict with my relational model. ... RDBMS is correct", then it's "everthing below the BL tier ... to enforce certain behavior. ... "Customer C is a gold customer if customer C has purchased at least n ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: history of RDBMS
    ... successful RDBMS supporting stored procedures and triggers, ... Some people would say that there has never been a "true" RDBMS ... implementation as a commercial product. ... Codd's relational model completely. ...
    (comp.databases)