Home > Store

Object-Relational Database Development: A Plumber's Guide

Register your product to gain access to bonus material or receive a coupon.

Object-Relational Database Development: A Plumber's Guide

Book

  • Sorry, this book is no longer in print.
Not for Sale

Description

  • Copyright 2001
  • Edition: 1st
  • Book
  • ISBN-10: 0-13-019460-3
  • ISBN-13: 978-0-13-019460-2

Leverage state-of-the-art object-relational database technology—today!

  • A complete step-by-step roadmap and methodology for ORDBMS database development
  • Object-Relational data models, query languages, Java, DataBlade modules, middleware applications, and more
  • Includes a start-to-finish e-commerce case study
  • By one of the world's leading object-relational database architects
  • CD-ROM contains all source code, including complete database examples

Foreword by Professor Michael Stonebraker

Object-Relational Databases (ORDBMS) are the "next great wave" of database technology, offering powerful opportunities to enhance flexibility, functionality, performance, and enterprise integration. In this book, Informix database architect Paul Brown explains ORDBMS technology in depth, and introduces a start-to-finish design and implementation methodology for ORDBMS development. Brown covers all this, and more:

  • Key features and characteristics of today's leading object-relational databases
  • ORDBMS data models, schema, queries, data types, functions, and routines
  • The ORDBMS as middleware: integrating the entire enterprise
  • DataBlade modules: extending ORDBMS functionality creatively
  • Using Java to create UDTs and UDRs

Object-Relational Database Development brings key features, techniques, and methodologies to life through a start-to-finish e-commerce case study that demonstrates the compelling advantages of ORDBMS technology. Whether you're a database programmer or decision-maker, you won't find a more realistic, insightful guide to ORDBMS development.

CD-ROM INCLUDED

The accompanying CD-ROM contains complete, ready-to-run source code, including a start-to-finish object-relational database application.

Sample Content

Downloadable Sample Chapter

Click here for a sample chapter for this book: 0130194603.pdf

Table of Contents



1. Introduction to Object-Relational Database Development.

Overview. Evolution of Database Management Systems. ORDBMS Concepts and Terminology. ORDBMS Advantages. ORDBMS Engineering. Development Example. Structure of this Book. Chapter Summary.



2. Facts, Tables, and Schema: The Object-Relational Data Model.

Introduction: Data Models. The Object-Relational Data Model. The Object Data Model. Object-Relational Structured Query Language (OR-SQL). Object-Relational Schema Definition. Creating Tables. Constraining Table Data. Referential Integrity Constraints. Data Inheritance. Non-Traditional Table Storage. Modifying Tables. Views. Physical Database Design. Database Security and Access Privileges. Chapter Summary.



Tutorial 1. Physical Data Organization.

Table Data: Pages, Heaps and Table Spaces. Large Object Management. Memory Caching. Indices: B-Trees and R-Trees. Tools, Utilities, and Techniques.



3. Object-Relational Queries.

Manipulating Object-Relational Data. Relational Manipulation Operations. Basic SELECT Queries. Object-Relational Structural Features and SELECT Queries. Changing Data Using OR-SQL. UPDATE Statement. DELETE Statement. General Note on Correlated Queries. Advanced SQL. Chapter Summary.



Tutorial 2. The Transaction Concept and its Applications.

Transactions. Implementing Transactions. ORDBMSs and Transaction.



4. Data Type and Function Extensibility.

Introduction to ORDBMS Data Type Extensibility. Overview of Object-Oriented Software Development Concepts. ORDBMS Data Types. Built-In Data Types. COLLECTION Data Types. CAST: Converting Between Data Types. User Defined Types (UDT). DISTINCT TYPES. ROW TYPE. OPAQUE TYPE. Administration of User-Defined Types. Chapter Summary.



Tutorial 3. A Tour of the Available DataBlade Products.

Categories of DataBlade Products. Other DataBlade Approaches.



5. Object Behavior and User-Defined Functions.

Introduction to Extending the ORDBMS with User-Defined Routines. User-Defined Routine Architecture. Creating User-Defined Functions. Function Body. Using User-Defined Functions. Advanced User-Defined Functions. Administering User-Defined Functions. Chapter Summary.



Tutorial 4. Using Java(tm) to Create UDTs and UDRs.

Overview of Java Technology. Java and the ORDBMS. Step 1: Compiling Java Source. Step 2: Combine Class Files into a Java Archive (jar) File. Step 3: Load Archive into ORDBMS. Step 4: Define User-Defined Functions Using the Archive. Java User-Defined Routines. Java Environment Inside the ORDBMS. Embedding Java Classes into the ORDBMS. Design Alternatives for Java Class Storage. Using Java Classes Within the ORDBMS.



6. The ORDBMS and Data Processing.

Data Processing Within Information Systems. Database Stored Procedures. Creating Stored Procedures. Stored Procedure Language (SPL). Administration and Management of Stored Procedures. Active Database Features. OR-SQL TRIGGER. Working with TRIGGERs. Applications of Database Procedures and Triggers. Distributed Data Management. INFORMIX-Star. Replication. RDBMS Gateways. Architectural Implications. Chapter Summary.



7. Client Interfaces to ORDBMSs.

Client Programs and DBMSs. Information System Architectures. Embedding OR-SQL in C - ESQL/C. Managing Result Data. Error and Exception Handling. Communications Layer. Embedded OR-SQL and Application Development. Java Database Connectivity (JDBC). JDBC Queries. Managing Result Data. Java, JDBC and ORDBMS Development. Markup Languages. Web Blade Architecture. Chapter Summary.



8. Object-Relational Database Development.

Introduction to Object-Relational Database Analysis and Design. Database Development Objectives. The ANSI Three-Tier Database Model. ORDBMS Development Methodology Steps. Part 1: Conceptual Modeling. Entity-Relationship Data Modeling. Describing the Entities in the Problem Domain. Describing Relationships Between Entities. Working an Example. E-ER Modeling Summary. Conceptual Object Modeling. Background to Object Analysis. Object Analysis with an ORDBMS. Interface Modeling. Working an Example. Minimize the Set of Object Classes. Conceptual Modeling for Type System Summary. Data Processing and Workload Analysis. Data Processing Operations. Business Rules. Chapter Summary.



9. Object-Relational Database Design.

Design and Implementation of Object-Relational Databases. Implementing the User-Defined Data Types. Implementing User-Defined Functions. Overview of Schema Design. Transformation Procedure. Logical Schema Modeling. Miscellaneous Design Decisions. Testing Techniques. Chapter Summary.



Tutorial 5. Several Examples of Interesting Extensions.

Node Data Type for Hierarchical Management. Ranking User-Defined Aggregates. Dynamic OR-SQL in the Stored Procedure Language.



10. Forging the Perfect DataBlade.

Database Extensibility. How the ORDBMS Uses C UDFs. ORDBMS Programming Environment. SAPI and User-Defined Functions. Argument Handling. MI_FPARAM Argument: Structure and Uses. Coding Guidelines for EXTERNAL UDFs. Large Objects. Top Six Rules for Writing External User-Defined Functions. Chapter Summary.



Tutorial 6. Virtual Table Interface.

Overview of Tutorial. How VTI Works. How the ORDBMS Uses VTI Interfaces. Implementing a New VTI Storage Manager. VTI User-Defined Functions. VTI Memory Structures. Creating VTI User-Defined Functions. Creating a New Access Method. Creating a Table Using the New Access Method. Writeable VTI Interfaces. Applications of VTI. Value Tables. Custom Gateways. Summary.



Glossary.


References.


Index.


About the CD.

Preface

Preface

New technologies are useful to the extent that they enhance some human ability. Simple machines like levers, pulleys, and inclined planes are useful because they make us stronger: that is, they increase the amount of mass that an individual can lift. Information technology—computer hardware and the software running on it—makes us smarter by enhancing our abilities to remember, reason, and communicate.

Computer hardware and software enhances mental abilities because they do the following things extremely well.

  • Store information. Computers can record enormous amounts of data, far more than a single person can remember. And a computer's powers of recall are quicker and more accurate than our own.
  • Process information. Computers can make a tremendous number of simple deductions quickly and without mistakes. This allows them to process large amounts of raw data to create new knowledge: to produce an analytic summary or to extract a subset of information from it.
  • Communicate. Computer networks are very efficient at making information available to widely distributed community of user. And computers can be used to create flexible, intuitive interfaces, helping users comprehend and manipulate information.

These properties account for the way computer systems, and particularly information management systems, have become an indispensable part of modern corporate life. In today's knowledge-based economy, companies are organized into networks of cooperating employees. Each interconnected employee's work assignment is a subtask of what the company as a whole is trying to accomplish. What ties employees together is the information they share. So coordinating employee efforts requires an effective and efficient information management system.

Taking this idea one step further, it is becoming increasingly common to consider your customers and partners as part of the network too. Over the next few years economic transactions between businesses will increasingly be handed electronically. Achieving this requires that businesses make internal information systems available to outside agencies.

The intent of this book is to describe a new information management technology, Object-Relational Database Management Systems software, and explain how to use it. Although most DBMS vendors lay claim to selling object-relational databases, Informix's Dynamic Server product possesses the most complete set of features combined with exceptional performance, scalability, and reliability.

Most readers will come to this book with a familiarity with Informix's earlier products. Some may be anxious about the changes the new technology brings, but hopefully, this book will convince them that everything they know is still valid and useful. For other readers, this will be their first exposure to both INFORMIX and to extensible DBMS technology. Many of these readers will be building information systems that make specific use of the new features.

At this time, most of the features and functionality described in this book are scheduled for inclusion in all mainstream DBMS products. Implementation details vary, but the idea that a database's data model can include more semantic information than is captured with a VARCHAR() has become mainstream. It is enshrined in the SQL-3 standard, and as we shall see it is supported by several open language standards.

Updates

Submit Errata

More Information

InformIT Promotional Mailings & Special Offers

I would like to receive exclusive offers and hear about products from InformIT and its family of brands. I can unsubscribe at any time.

Overview


Pearson Education, Inc., 221 River Street, Hoboken, New Jersey 07030, (Pearson) presents this site to provide information about products and services that can be purchased through this site.

This privacy notice provides an overview of our commitment to privacy and describes how we collect, protect, use and share personal information collected through this site. Please note that other Pearson websites and online products and services have their own separate privacy policies.

Collection and Use of Information


To conduct business and deliver products and services, Pearson collects and uses personal information in several ways in connection with this site, including:

Questions and Inquiries

For inquiries and questions, we collect the inquiry or question, together with name, contact details (email address, phone number and mailing address) and any other additional information voluntarily submitted to us through a Contact Us form or an email. We use this information to address the inquiry and respond to the question.

Online Store

For orders and purchases placed through our online store on this site, we collect order details, name, institution name and address (if applicable), email address, phone number, shipping and billing addresses, credit/debit card information, shipping options and any instructions. We use this information to complete transactions, fulfill orders, communicate with individuals placing orders or visiting the online store, and for related purposes.

Surveys

Pearson may offer opportunities to provide feedback or participate in surveys, including surveys evaluating Pearson products, services or sites. Participation is voluntary. Pearson collects information requested in the survey questions and uses the information to evaluate, support, maintain and improve products, services or sites, develop new products and services, conduct educational research and for other purposes specified in the survey.

Contests and Drawings

Occasionally, we may sponsor a contest or drawing. Participation is optional. Pearson collects name, contact information and other information specified on the entry form for the contest or drawing to conduct the contest or drawing. Pearson may collect additional personal information from the winners of a contest or drawing in order to award the prize and for tax reporting purposes, as required by law.

Newsletters

If you have elected to receive email newsletters or promotional mailings and special offers but want to unsubscribe, simply email information@informit.com.

Service Announcements

On rare occasions it is necessary to send out a strictly service related announcement. For instance, if our service is temporarily suspended for maintenance we might send users an email. Generally, users may not opt-out of these communications, though they can deactivate their account information. However, these communications are not promotional in nature.

Customer Service

We communicate with users on a regular basis to provide requested services and in regard to issues relating to their account we reply via email or phone in accordance with the users' wishes when a user submits their information through our Contact Us form.

Other Collection and Use of Information


Application and System Logs

Pearson automatically collects log data to help ensure the delivery, availability and security of this site. Log data may include technical information about how a user or visitor connected to this site, such as browser type, type of computer/device, operating system, internet service provider and IP address. We use this information for support purposes and to monitor the health of the site, identify problems, improve service, detect unauthorized access and fraudulent activity, prevent and respond to security incidents and appropriately scale computing resources.

Web Analytics

Pearson may use third party web trend analytical services, including Google Analytics, to collect visitor information, such as IP addresses, browser types, referring pages, pages visited and time spent on a particular site. While these analytical services collect and report information on an anonymous basis, they may use cookies to gather web trend information. The information gathered may enable Pearson (but not the third party web trend services) to link information with application and system log data. Pearson uses this information for system administration and to identify problems, improve service, detect unauthorized access and fraudulent activity, prevent and respond to security incidents, appropriately scale computing resources and otherwise support and deliver this site and its services.

Cookies and Related Technologies

This site uses cookies and similar technologies to personalize content, measure traffic patterns, control security, track use and access of information on this site, and provide interest-based messages and advertising. Users can manage and block the use of cookies through their browser. Disabling or blocking certain cookies may limit the functionality of this site.

Do Not Track

This site currently does not respond to Do Not Track signals.

Security


Pearson uses appropriate physical, administrative and technical security measures to protect personal information from unauthorized access, use and disclosure.

Children


This site is not directed to children under the age of 13.

Marketing


Pearson may send or direct marketing communications to users, provided that

  • Pearson will not use personal information collected or processed as a K-12 school service provider for the purpose of directed or targeted advertising.
  • Such marketing is consistent with applicable law and Pearson's legal obligations.
  • Pearson will not knowingly direct or send marketing communications to an individual who has expressed a preference not to receive marketing.
  • Where required by applicable law, express or implied consent to marketing exists and has not been withdrawn.

Pearson may provide personal information to a third party service provider on a restricted basis to provide marketing solely on behalf of Pearson or an affiliate or customer for whom Pearson is a service provider. Marketing preferences may be changed at any time.

Correcting/Updating Personal Information


If a user's personally identifiable information changes (such as your postal address or email address), we provide a way to correct or update that user's personal data provided to us. This can be done on the Account page. If a user no longer desires our service and desires to delete his or her account, please contact us at customer-service@informit.com and we will process the deletion of a user's account.

Choice/Opt-out


Users can always make an informed choice as to whether they should proceed with certain services offered by InformIT. If you choose to remove yourself from our mailing list(s) simply visit the following page and uncheck any communication you no longer want to receive: www.informit.com/u.aspx.

Sale of Personal Information


Pearson does not rent or sell personal information in exchange for any payment of money.

While Pearson does not sell personal information, as defined in Nevada law, Nevada residents may email a request for no sale of their personal information to NevadaDesignatedRequest@pearson.com.

Supplemental Privacy Statement for California Residents


California residents should read our Supplemental privacy statement for California residents in conjunction with this Privacy Notice. The Supplemental privacy statement for California residents explains Pearson's commitment to comply with California law and applies to personal information of California residents collected in connection with this site and the Services.

Sharing and Disclosure


Pearson may disclose personal information, as follows:

  • As required by law.
  • With the consent of the individual (or their parent, if the individual is a minor)
  • In response to a subpoena, court order or legal process, to the extent permitted or required by law
  • To protect the security and safety of individuals, data, assets and systems, consistent with applicable law
  • In connection the sale, joint venture or other transfer of some or all of its company or assets, subject to the provisions of this Privacy Notice
  • To investigate or address actual or suspected fraud or other illegal activities
  • To exercise its legal rights, including enforcement of the Terms of Use for this site or another contract
  • To affiliated Pearson companies and other companies and organizations who perform work for Pearson and are obligated to protect the privacy of personal information consistent with this Privacy Notice
  • To a school, organization, company or government agency, where Pearson collects or processes the personal information in a school setting or on behalf of such organization, company or government agency.

Links


This web site contains links to other sites. Please be aware that we are not responsible for the privacy practices of such other sites. We encourage our users to be aware when they leave our site and to read the privacy statements of each and every web site that collects Personal Information. This privacy statement applies solely to information collected by this web site.

Requests and Contact


Please contact us about this Privacy Notice or if you have any requests or questions relating to the privacy of your personal information.

Changes to this Privacy Notice


We may revise this Privacy Notice through an updated posting. We will identify the effective date of the revision in the posting. Often, updates are made to provide greater clarity or to comply with changes in regulatory requirements. If the updates involve material changes to the collection, protection, use or disclosure of Personal Information, Pearson will provide notice of the change through a conspicuous notice on this site or other appropriate way. Continued use of the site after the effective date of a posted revision evidences acceptance. Please contact us if you have questions or concerns about the Privacy Notice or any objection to any revisions.

Last Update: November 17, 2020