KENNESAW STATE UNIVERSITY DEPARTMENT OF COMPUTER SCIENCE AND INFORMATION SYSTEMS MASTER OF SCIENCE IN APPLIED COMPUTER SCIENCE CS 8630 DATABASE ADMINISTRATION TERM PAPER Object Oriented Database and Object Relational Databases AUTHOR MAXWELL K NGANGA JULY 22 2004 TABLE OF CONTENTS PAGE PART 1 CHAPTER 24 2 1 1 ADVANCED DATABASE APPLICATIONS 2 Computer Aided Design CAD Computer Aided Manufacturing CAM Network Management System Office information System ois and Multimedia systems Digital Publishing Geographic information Systems GIS Interactive and Dynamic Web sites 1 2 WEAKNESSES OF RDBMSs 3 1 3 OBJECT ORIENTED CONCEPTS 3 Abstraction Encapsulation Information hiding Objects and Attributes Classes Polymorphism and Dynamic Binding 1 4 STORING OBJECTS IN A RELATIONAL DATABASE 5 Mapping Classes to Relations Accessing Objects in the Relational Database 1 5 NEXT GENERATION DATABASE SYSTEMS 5 Semantic Data Model Hammer and McLeod 1981 Functional Data Model Shipman 1981 Semantic Association Model Su 1983 PART 2 CHAPTER 6 OBJECT ORIENTED DBMSs 6 1 1 CONCEPTS AND DESIGN 6 Introduction to OO Data Models and OODBMSs Persistent programming Languages Data programming languages Alternative Strategies for Developing an OODBMS Extend an existing Object Oriented programming language with database capabilities Provide extensible object oriented DBMS libraries Embed Object Oriented Database language constructs in a conventional host language Extend an existing database language with Object Oriented capabilities Develop a novel database data model data language 1 2 OODBMS PERSPECTIVES 6 Point Swizzling techniques Accessing an Object 1 3 PERSISTENCE 7 Persistence schemes Checkpointing Serialization Explicit paging Orthogonal persistence Persistence independence Data type Orthogonality Transitive persistence Advantages and Disadvantages of Orthogonal Persistence What Objects do queries apply to What objects are part of transaction semantics 1 4 ISSUES IN OODBMS 11 Transactions Versions Schema evolution Architecture Clint Server object server page server Database server Storing and executing methods It eliminates redundant code It simplifies modifications Methods are more secure Improve integrity Benchmarking Wisconsin benchmark TPC A and TPC B benchmarks TPC C benchmark 001 benchmark 007 benchmark 1 5 OBJECT ORIENTED DATABASE SYSTEM MANIFESTO 12 1 6 ADVANTAGES AND DISADVANTAGES OF OODBMSs 14 1 7 OBJECT ORIENTED DATABASE DESIGN 15 Comparison of Object Oriented data modeling and Conceptual Data Modeling Relationships and Referential Integrity Behavioral Design PART 3 CHAPTER 26 16 OBJECT ORIENTED DBMSs STANDARDS AND SYSTEMS 1 1 OBJECT MANAGEMENT GROUP 16 Background Common object request Broker Architecture 1 2 OBJECT DATA STANDARD ODMG 3 0 1999 16 Object data Management Group Object Model Object Definition language Object Query language Other parts of the ODMG Standard Object Interchange Format ODMG language bindings 1 3 OBJECTSTORE 17 Architecture Data Definition in ObjectStore Data Manipulation in ObjectStore PART 4 CHAPTER 27 18 OBJECT RELATIONAL DBMSs 18 INTRODUCTION 18 1 2 THE THIRD GENERATION DATABASE MANIFESTOS The Third Manifesto 18 1 3 POSTGRES AN EARLY ORDBMS 19 1 4 SQL3 20 1 5 QUERY PROCESSING AND OPTIMIZATION 21 1 6 OBJECT ORIENTED EXTENSIONS IN ORACLE 22 1 7 COMPARISON OF ORDBMS AND OODBMS 22 Reference 22 PART 1 CHAPTER 24 INTRODUCTION TO OBJECT DBMS Object orientation is an approach to software construction that shows considerable promise for solving some of the classic problems of software development The underlying concept is that all software should be constructed out of standard reusable components wherever possible The emergences of Object Relational DBMS and objectRelational DBMS have been combined to allow the concurrent modeling of both data and the processes acting upon the data 1 1 ADVANCED DATABASE APPLICATIONS Computer Aided Design CAD A CAD database stores data relating to mechanical and electrical design covering for example buildings aircraft and integrated circuit chips Designs of this type have some common characteristics Computer Aided Manufacturing CAM Computer Aided Manufacturing CAM is the use of computers to assist the manufacturing process CAD and CAM are combined CAD CAM so that the output of the CAD module is fed to the CAM system The design can be converted into a sequence of processes drilling turning milling etc for manufacture on a Numerically Controlled NC milling machine for example Computer Aided Software Engineering CASE To speed up the software system building process a new concept of designing software was introduced in the 70s called Computer Aided Software Engineering CASE This term is used for a new generation of tools that applies rigorous engineering principles to the development and analysis of software specifications Simply computers develop software for other computers in a fast way by using specific tools Network Management System Enables network administrators to identify and resolve problems and performance bottlenecks before they impact network services ONMS is essential for maintaining user quality of experience in multi cast video IP Telephony and other business critical applications Office information System OIS and Multimedia systems An OIS database stores data relating to the computer control of information in a business including electronic mail documents and invoices and so on Digital Publishing Digital publishing is the digitization of the professional publishing process coupled with the commerce and distribution powers of the Internet Digital publishing takes place after the copy is written and includes the digital preparation and automated production delivery and distribution of your content By harnessing powerful XML technology each of these functions is tied together through a common infrastructure to facilitate the sharing of data and process information between and among them The result is a Webbased publishing solution that can economically produce one or thousands of copies as they are needed through an elegant publishing platform with zero inventory Geographic information Systems GIS to give you a better understanding of that place What layers of information you combine depends on your purpose finding the best location for a new store analyzing environmental damage viewing similar crimes in a city to detect a pattern and so on A GIS combines layers of information about a place Interactive and Dynamic Web sites Web sites that