ch22-Object-Relational and Extended-Relational Systems

ch22-Object-Relational and Extended-Relational Systems -...

Info iconThis preview shows pages 1–12. Sign up to view the full content.

View Full Document Right Arrow Icon
Slide 22- 1 Copyright © 2007 Ramez Elmasri and Shamkant B. Navathe
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Copyright © 2007 Ramez Elmasri and Shamkant B. Navathe Chapter 22 Object-Relational and Extended-Relational Systems
Background image of page 2
Slide 22- 3 Copyright © 2007 Ramez Elmasri and Shamkant B. Navathe Chapter Outline 22.1 Overview of Object-Relational Features of SQL 22.2 Evolution and Current Trends 22.3 The Informix Server 22.4 Object-Relational Features of Oracle 22.5 Implementation and Related Issues for Extended Type Systems 22.6 The Nested Relational Model 22.7 Summary
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Slide 22- 4 Copyright © 2007 Ramez Elmasri and Shamkant B. Navathe Chapter Objectives To address the following questions: What are the shortcoming of the current DBMSs? What has led to these shortcomings? Identify new challenges How Informix Universal Server and Oracle have addressed some of the challenges
Background image of page 4
Slide 22- 5 Copyright © 2007 Ramez Elmasri and Shamkant B. Navathe Section 22.1 SQL’s Object-Relational Features SQL was specified in 1970s SQL was enhanced substantially in 1989 and 1992 A new standard called SQL3 added object- oriented features A subset of SQL3 standard, now known as SQL- 99 has been approved
Background image of page 5

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Slide 22- 6 Copyright © 2007 Ramez Elmasri and Shamkant B. Navathe Component of the SQL Standard SQL/Framework, SQL/Foundation, SQL/Bindings, SQL/Object New parts addressing temporal, transaction aspects of SQL SQL/CLI (Call Level Interface) SQL/PSM (Persistent Stored Modules)
Background image of page 6
Slide 22- 7 Copyright © 2007 Ramez Elmasri and Shamkant B. Navathe SQL/Foundation New types New predicates Relational operators Rules and triggers User defined types Transaction capabilities Stored routines
Background image of page 7

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Slide 22- 8 Copyright © 2007 Ramez Elmasri and Shamkant B. Navathe SQL/CLI SQL/CLI stands for SQL Call Level Interface SQL/CLI provides rules that allow execution of application code without providing source code Avoids the need for preprocessing Contains about 50 routines for tasks such as connection to the SQL server
Background image of page 8
Slide 22- 9 Copyright © 2007 Ramez Elmasri and Shamkant B. Navathe SQL/PSM PSM = Persistent Stored Modules Specifies facilities for partitioning an application between a client and a server Enhances performance by minimizing network traffic SQL Bindings included Embedded SQL SQL/Temporal deals with historical data
Background image of page 9

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Slide 22- 10 Copyright © 2007 Ramez Elmasri and Shamkant B. Navathe Object-Relational Support in SQL-99 Type constructors to specify complex objects Mechanism to specify object-identity Mechanism for encapsulation of operations Mechanism to support inheritance I.e., specify specialization and generalization
Background image of page 10
Copyright © 2007 Ramez Elmasri and Shamkant B. Navathe Type Constructors (1) Two types: row and array Known as user-defined types (UDTs) Syntax for a row type CREATE TYPE row_type_name AS [ROW] (<component decln>)
Background image of page 11

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 12
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 02/23/2012 for the course CS 348 taught by Professor Staff during the Fall '08 term at Purdue University.

Page1 / 40

ch22-Object-Relational and Extended-Relational Systems -...

This preview shows document pages 1 - 12. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online