
f320a9b052fd064f90b2fc6530a444d9.ppt
- Количество слайдов: 54
1
Introduction 2
Relational Database 3
CSE 232 A and the rest of UCSD’s database course program 4
CSE 232 A and the rest of UCSD’s database course program 5
Data Structure: Relational Model Review Slide from Victor Vianu’s 132 A
Relational Model: Primary and Foreign Keys 7
Programming Interface: JDBC/ODBC 8
Access (Query) & Modification Language: SQL
Basic Relational Algebra Operators
Basic Relational Algebra Operators
Basic Relational Algebra Operations
SQL Queries: The Basic From
Duplicates and Nulls
SQL Queries: Aliases
Example on Aliases and Long Primary/Foreign Key Join Chains 16
17
SQL Queries: Nesting
Another Form of the “Long Join” Query 19
Query Expressing Negation with NOT IN Find the contact names of customers who do not have orders of products also ordered by London customers 20
Nested Queries: Existential and Universal Quantification
SQL: Union, Intersection, Difference
SQL Queries: Aggregation and Grouping
SQL Grouping: Conditions that Apply on Groups
Transaction Management 28
Example Concurrency & Failure Problems 29
Example Failure Problem & Recovery Module’s Goal 30
Example Concurrency Problem & Concurrency Control Module’s Goals 31
Example Concurrency Problem & Concurrency Control Module’s Goals 32
Example Concurrency Problem & Concurrency Control Module’s Goals 33
Introduction 34
Introducing the Database Management System 35
Megatron 3000 Implementation Details . . . 36
Megatron 3000 Sample Sessions . . . 37
Megatron 3000 Sample Sessions 38
Megatron 3000 Sample Sessions 39
Megatron 3000 Sample Sessions Result sent to LPR (printer). 40
Megatron 3000 Sample Sessions New relation T created. 41
Megatron 3000 42
Megatron 3000 43
What’s wrong with the Megatron 3000 DBMS? 44
What’s wrong with the Megatron 3000 DBMS? 45
What’s wrong with the Megatron 3000 DBMS? 46
What’s wrong with the Megatron 3000 DBMS? 47
What’s wrong with the Megatron 3000 DBMS? 48
Course Topics 49
Course Topics 50
Database System Architecture
The Journey of a Query (Example)
The Journey of a Query (cont’d)
The Journey of a Query (cont’d)
f320a9b052fd064f90b2fc6530a444d9.ppt