SPECIAL OFFERS
Keep up with new releases and promotions. Sign up to hear from us.
Register your product to gain access to bonus material or receive a coupon.
Leverage state-of-the-art object-relational database technologytoday!
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:
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 INCLUDEDThe accompanying CD-ROM contains complete, ready-to-run source code, including a start-to-finish object-relational database application.
Click here for a sample chapter for this book: 0130194603.pdf
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.
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.
Table Data: Pages, Heaps and Table Spaces. Large Object Management. Memory Caching. Indices: B-Trees and R-Trees. Tools, Utilities, and Techniques.
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.
Transactions. Implementing Transactions. ORDBMSs and Transaction.
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.
Categories of DataBlade Products. Other DataBlade Approaches.
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.
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.
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.
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.
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.
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.
Node Data Type for Hierarchical Management. Ranking User-Defined Aggregates. Dynamic OR-SQL in the Stored Procedure Language.
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.
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.
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 technologycomputer hardware and the software running on itmakes 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.
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.