1. Home
  2. Flashcards
  3. Preview

Relational algebra

  1. Types of query language
    • Procedural
    • Declarative
  2. What are procedural query languages
    Step-by-step operations to obtain an answer
  3. What are declarative query languages?
    Statements that specify what to retrieve
  4. What kind of query language is relational algebra
    Procedural
  5. 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
  6. What uses relational algebra
    The query processor
  7. Relational algebra operations
    • Select
    • Project
    • Join
    • Union
    • Intersection
    • Set difference (minus)
    • Divide
    • Aggregation
  8. Aggregation operators
    • sum
    • count
    • avg
    • min
    • max
Author
Ant
ID
357113
Card Set
Relational algebra
Description
Updated

  1. Home
  2. Flashcards
  3. Preview