August 2009
Intermediate to advanced
893 pages
26h 48m
English
Content preview from Database Systems: Concepts, Design and Applications
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
5.1. Introduction
In Chapter 4, we have discussed the relational query based on relational algebra and relational calculus. The relational algebra and calculus provide a powerful set of operations to specify queries. This forms the basis for the data manipulation (query) language component of the DBMS. But, such languages can be expensive to implement and use. In reality, data manipulation languages generally have capabilities beyond those of relational algebra and calculus. All data manipulation languages include capabilities such as insertion, deletion, modification of commands, arithmetic capability, assignment and print command, aggregate functions and so on, which are not part of relational algebra or calculus.
Queries in a relational language ...