Relational algebra

Types of query language
- Procedural
- Declarative
What are procedural query languages

Step-by-step operations to obtain an answer
What are declarative query languages?

Statements that specify what to retrieve
What kind of query language is relational algebra

Procedural
What is relational algebra?
- Set of operators that are replied to relations in a sequence to obtain a result
- Not used directly by programmers or applications
What uses relational algebra

The query processor
Relational algebra operations
- Select
- Project
- Join
- Union
- Intersection
- Set difference (minus)
- Divide
- Aggregation
Aggregation operators
- sum
- count
- avg
- min
- max

Author

Ant

357113

Card Set

Relational algebra

Description

Updated

2021-12-08T03:56:23Z

Show Answers