DATABASE4

2020-03-01 149浏览

  • 1.DATABASE Principles, Programming, and Performance Patrick O’Neil and Elizabeth O’Neil Lectured by Dr. Lican HuangEmail:licanhuang@zist.edu.cn huang_lican@yahoo.co.ukhttp://virgo.sourceforge.net/licanhuang.htmlZhejiang Sci-Tech University Lican Huang 1
  • 2.4 Object-Relational SQL     4.1 Introduction an object holds together a bundle of related information. employee { name, id, address, …} document { title, author, length, date} -- similar Java class  Zhejiang Sci-Tech University Lican Huang 2
  • 3.4 Object-Relational SQL   4.1 Introduction object –relational database management systems ORDBMS RDBMS/ORDBMS all ORDBMS products will also run RDBMS SQL ORDBMS SQL - ORSQL  Zhejiang Sci-Tech University Lican Huang 3
  • 4.4 Object-Relational SQL  4.1 Introduction ORSQL dialects ORACLE object type INFORMIX row type DB2 UDB user-defined type UDT  Zhejiang Sci-Tech University Lican Huang 4
  • 5.4 Object-Relational SQL  4.1 Introduction Collection Types single column value can itself hold a table Break Rule 1 First Normal Form Rule  Zhejiang Sci-Tech University Lican Huang 5
  • 6.4 Object-Relational SQL  4.1 Introduction Figure 4.1 employees P 175  Zhejiang Sci-Tech University Lican Huang 6
  • 7.4 Object-Relational SQL  4.2 Objects and Tables Object type in ORACLE Example 4.2.1 pp 177 Like a C struct declaration or Java class declaration  Zhejiang Sci-Tech University Lican Huang 7
  • 8.4 Object-Relational SQL  4.2 Objects and Tables Example 4.2.2 pp 178 create table type as object type Insert statement Select statement Zhejiang Sci-Tech University Lican Huang 8
  • 9.4 Object-Relational SQL  4.2 Objects and Tables Example 4.2.3 pp 179 create type person_t containing object type pname Zhejiang Sci-Tech University Lican Huang 9
  • 10.4 Object-Relational SQL  4.2 Objects and Tables Example 4.2.4 pp 180 create object table Create table people of person_t(primary key(ssno)) Select value(p) from people p; Zhejiang Sci-Tech University Lican Huang 10
  • 11.4 Object-Relational SQL  4.2 Objects and Tables Example 4.2.5 pp 182 create object table Create table people of person_t(primar y key(ssno)) Zhejiang Sci-Tech University Lican Huang 11
  • 12.4 Object-Relational SQL  4.2 Objects and Tables Example 4.2.6 pp 183 Example 4.2.7 pp 183 Zhejiang Sci-Tech University Lican Huang 12
  • 13.4 Object-Relational SQL  4.2 Objects and Tables Example 4.2.8 pp 184 Figure 4.6 pp185 Zhejiang Sci-Tech University Lican Huang 13
  • 14.4 Object-Relational SQL  4.2 Objects and Tables Example 4.2.9 pp 185 Figure 4.6 pp185 Example 4.2.10 Example 4.2.11 Example 4.2.12 Zhejiang Sci-Tech University Lican Huang 14
  • 15.4 Object-Relational SQL 4.3 Collection Types Example 4.3.1 Example 4.3.2 Example 4.3.4 Example 4.3.5 pp200 pp202 pp203 pp203 Zhejiang Sci-Tech University Lican Huang 15