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 ...

Get Database Systems: Concepts, Design and Applications 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.