July 2010
Intermediate to advanced
976 pages
30h 19m
English
Content preview from Information Modeling and Relational Databases, 2nd Edition
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
Start your free trial
12.2. Relational Database Systems
We may now define a relational DBMS as a DBMS that has the relational table as its only essential data structure and supports the selection, projection, and join operations without needing specification of physical access paths. A relational system that supports all eight table operations of the relational algebra is said to be relationally complete. This doesn’t entail eight distinct operators for these tasks; rather, the eight operations must be expressible in terms of the table operations provided by the system.
The two main relational languages are SQL and QBE, with SQL being the most important. Most SQL systems are relationally complete. A system that supports all aspects of the relational model, including ...