Thinking in Sets

Thinking in Sets

Thinking in Sets is a great book by Joe Celko. This book tells us about concepts, how we need to think when we are working with databases.

Columns are not fields, rows are not records and tables are not files, hence SQL is declarative, not procedural. There is no sequential access or ordering in table, so “first,” “next,” and “last” rows are totally meaningless.
 
I agree when he writes “One of the first things that a newbie does is use a proprietary autonumbering feature in their SQL product as a PRIMARY KEY”. This is completely wrong, and it violates the definition of a relational key.
 
An attribute has to belong to an entity in the real world being modeled by the RDBMS. Autonumbering does not exist in an entity in the real world being modeled by the RDBMS. Thus, it is not an attribute and cannot be in a table, by definition.
 
That’s how I think and was totally wrong before.

See Also


Leave a Comment
  • Please add 2 and 4 and type the answer here:
  • Post
Wiki - Revision Comment List(Revision Comment)
Sort by: Published Date | Most Recent | Most Useful
Comments
  • Naomi  N edited Revision 2. Comment: Added See Also

  • Naomi  N edited Revision 1. Comment: Links

  • Naomi  N edited Original. Comment: Minor grammar corrections, title change

Page 1 of 1 (3 items)
Wikis - Comment List
Sort by: Published Date | Most Recent | Most Useful
Posting comments is temporarily disabled until 10:00am PST on Saturday, December 14th. Thank you for your patience.
Comments
  • Naomi  N edited Original. Comment: Minor grammar corrections, title change

  • Thanks Naomi for correction

  • Naomi  N edited Revision 1. Comment: Links

  • Naomi  N edited Revision 2. Comment: Added See Also

Page 1 of 1 (4 items)