TAILIEUCHUNG - Lecture Database system concepts (6/e): Chapter 6 - Silberschatz, Korth, Sudarshan

Chapter 6 - Formal relational query languages. In this chapter, we start by presenting the relational algebra, which forms the basis of the widely used SQL query language. We then cover the tuple relational calculus and the domain relational calculus, which are declarative query languages based on mathematical logic. | Chapter 6: Formal Relational Query Languages Database System Concepts, 6th Ed. ©Silberschatz, Korth and Sudarshan See for conditions on re-use Chapter 6: Formal Relational Query Languages Relational Algebra Tuple Relational Calculus Domain Relational Calculus Database System Concepts - 6th Edition ©Silberschatz, Korth and Sudarshan Relational Algebra Procedural language Six basic operators select: σ project: ∏ union: ∪ set difference: – Cartesian product: x rename: ρ The operators take one or two relations as inputs and produce a new relation as a result. Database System Concepts - 6th Edition ©Silberschatz, Korth and Sudarshan Select Operation – Example Relation r σA=B ^ D > 5 (r) Database System Concepts - 6th Edition ©Silberschatz, Korth and Sudarshan Select Operation Notation: σ p(r) p is called the selection predicate Defined as: σp(r) = {t

• Sáng kiến kinh nghiệm
• Database system
• Lecture Database system
• Relational databases
• Database design
• Relational algebra
• Tuple relational calculus
• Database system concepts
• Lecture Database system concepts
• Database systems
• Database languages
• Database system architectures
• Relational database design
• Database system architecture
• File based approach
• Data management systems framework
• Recovery system
• Lecture Database systems
• Database architecture
• Database approach
• Database design process
• Query optimization
• Transaction state
• Concurrency control
• Data analysis
• Information retrieval
• Parallel databases
• Distributed databases
• Advanced application development
• Advanced data types
• Advanced transaction processing
• Relational model
• Basic query structure
• Dynamic SQL
• Entity relationship model
• Application design
• Object­ based databases