Fundamentals of Database Systems - Object-Relational and Extended-Relational Systems

Fundamentals of Database Systems - Object-Relational and Extended-Relational Systems - Transcript

Copyright 2004 Pearson Education Inc

Chapter 22
Object Relational and Extended Relational Systems

Copyright 2004 Pearson Education Inc

Overview of SQL and Its Object Relational Features
The SQL Standard and Its Components Object Relational Support in SQL 99 Some New Operations and Features in SQL

Elmasri and Navathe Fundamentals of Database Systems Fourth Edition Copyright 2004 Pearson Education Inc

Slide 22 3

Evolution and Current Trends of Database Technology

Elmasri and Navathe Fundamentals of Database Systems Fourth Edition Copyright 2004 Pearson Education Inc

Slide 22 4

The Informix Universal Server
Extensible Data Types Support for User Defined Routines Support for Inheritance Support for Indexing Extensions Support for External Data Sources Support for Data Blades Application Programming Interface
Elmasri and Navathe Fundamentals of Database Systems Fourth Edition Copyright 2004 Pearson Education Inc

Slide 22 5

Object Relational Features of Oracle 8
Some Examples of Object Relational Features of Oracle Managing Large Objects and Other Storage Features

Elmasri and Navathe Fundamentals of Database Systems Fourth Edition Copyright 2004 Pearson Education Inc

Slide 22 6

Implementation and Related Issues for Extended Type Systems

Elmasri and Navathe Fundamentals of Database Systems Fourth Edition Copyright 2004 Pearson Education Inc

Slide 22 7

The Nested Relational Model

Elmasri and Navathe Fundamentals of Database Systems Fourth Edition Copyright 2004 Pearson Education Inc

Slide 22 8

Summary

Elmasri and Navathe Fundamentals of Database Systems Fourth Edition Copyright 2004 Pearson Education Inc

Slide 22 9