O'Reilly logo

Joe Celko's Trees and Hierarchies in SQL for Smarties, 2nd Edition by Joe Celko

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 10. Hierarchies in Data Modeling
Type hierarchies are useful when trying to model entities for a database. How this hierarchy is mapped into SQL DDL is another issue. Many years ago, at an ANSI X3H2 Database Standards Committee meeting in Rapid City, South Dakota, Bjarne Stroustrup gave a lecture on C++ and object-oriented (OO) programming research at Bell Labs. When asked about using OO concepts in databases, he replied that the people at Bell Labs had experimented with it, tried several approaches, and came to the conclusion that while OO was good for programming, it was a bad idea for data. The most recent model of OO also seems to have gone back to a separation of data and procedures.
Keywords: relational database, autonumbering, overlapping ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required