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 ...
Get Joe Celko's Trees and Hierarchies in SQL for Smarties, 2nd Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
