Home > Computing and Information Technology > Databases > Object-Relational Database Development: A Plumber's Guide
Object-Relational Database Development: A Plumber's Guide

Object-Relational Database Development: A Plumber's Guide

          
5
4
3
2
1

Out of Stock


Premium quality
Premium quality
Bookswagon upholds the quality by delivering untarnished books. Quality, services and satisfaction are everything for us!
Easy Return
Easy return
Not satisfied with this product! Keep it in original condition and packaging to avail easy return policy.
Certified product
Certified product
First impression is the last impression! Address the book’s certification page, ISBN, publisher’s name, copyright page and print quality.
Secure Checkout
Secure checkout
Security at its finest! Login, browse, purchase and pay, every step is safe and secured.
Money back guarantee
Money-back guarantee:
It’s all about customers! For any kind of bad experience with the product, get your actual amount back after returning the product.
On time delivery
On-time delivery
At your doorstep on time! Get this book delivered without any delay.
Notify me when this book is in stock
Add to Wishlist

About the Book

Object-Relational Databases (ORDBMS) are the "next great wave" of database technology, offering powerful opportunities to enhance flexibility, functionality, and performance. This book explains ORDBMS technology in depth, and presents a start-to-finish design and implementation methodology for ORDBMS development. In Part I, Paul Brown reviews the key features and functionality built into today's object-relational databases. Brown introduces the ORDBMS data model, query language, the basics of ORDBMS extensibility, relationships between the ORDBMS and middleware, and, finally, key APIs used to integrate an ORDBMS with other components of an enterprise information system. In Part II, Brown shows how to use these features and concepts to build a complete, working system. Using a complete e-commerce case study, he describes a semi-formal methodological road map for optimizing the effectiveness of ORDBMS systems. Along the way, Brown also covers database extensibility, DataBlades, and a variety of crucial related issues, including physical data management in ORDBMS environments; using Java to create UDTs and UDRs; ORDBMS system catalogs; and more. All sample code is included on the accompanying CD-ROM.

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.


Best Sellers


Product Details
  • ISBN-13: 9780130194602
  • Publisher: Pearson Education (US)
  • Publisher Imprint: Prentice Hall
  • Height: 234 mm
  • No of Pages: 832
  • Sub Title: A Plumber's Guide
  • Width: 179 mm
  • ISBN-10: 0130194603
  • Publisher Date: 09 Jan 2001
  • Binding: SA
  • Language: English
  • Spine Width: 28 mm
  • Weight: 1178 gr


Similar Products

How would you rate your experience shopping for books on Bookswagon?

Add Photo
Add Photo

Customer Reviews

REVIEWS           
Click Here To Be The First to Review this Product
Object-Relational Database Development: A Plumber's Guide
Pearson Education (US) -
Object-Relational Database Development: A Plumber's Guide
Writing guidlines
We want to publish your review, so please:
  • keep your review on the product. Review's that defame author's character will be rejected.
  • Keep your review focused on the product.
  • Avoid writing about customer service. contact us instead if you have issue requiring immediate attention.
  • Refrain from mentioning competitors or the specific price you paid for the product.
  • Do not include any personally identifiable information, such as full names.

Object-Relational Database Development: A Plumber's Guide

Required fields are marked with *

Review Title*
Review
    Add Photo Add up to 6 photos
    Would you recommend this product to a friend?
    Tag this Book
    Read more
    Does your review contain spoilers?
    What type of reader best describes you?
    I agree to the terms & conditions
    You may receive emails regarding this submission. Any emails will include the ability to opt-out of future communications.

    CUSTOMER RATINGS AND REVIEWS AND QUESTIONS AND ANSWERS TERMS OF USE

    These Terms of Use govern your conduct associated with the Customer Ratings and Reviews and/or Questions and Answers service offered by Bookswagon (the "CRR Service").


    By submitting any content to Bookswagon, you guarantee that:
    • You are the sole author and owner of the intellectual property rights in the content;
    • All "moral rights" that you may have in such content have been voluntarily waived by you;
    • All content that you post is accurate;
    • You are at least 13 years old;
    • Use of the content you supply does not violate these Terms of Use and will not cause injury to any person or entity.
    You further agree that you may not submit any content:
    • That is known by you to be false, inaccurate or misleading;
    • That infringes any third party's copyright, patent, trademark, trade secret or other proprietary rights or rights of publicity or privacy;
    • That violates any law, statute, ordinance or regulation (including, but not limited to, those governing, consumer protection, unfair competition, anti-discrimination or false advertising);
    • That is, or may reasonably be considered to be, defamatory, libelous, hateful, racially or religiously biased or offensive, unlawfully threatening or unlawfully harassing to any individual, partnership or corporation;
    • For which you were compensated or granted any consideration by any unapproved third party;
    • That includes any information that references other websites, addresses, email addresses, contact information or phone numbers;
    • That contains any computer viruses, worms or other potentially damaging computer programs or files.
    You agree to indemnify and hold Bookswagon (and its officers, directors, agents, subsidiaries, joint ventures, employees and third-party service providers, including but not limited to Bazaarvoice, Inc.), harmless from all claims, demands, and damages (actual and consequential) of every kind and nature, known and unknown including reasonable attorneys' fees, arising out of a breach of your representations and warranties set forth above, or your violation of any law or the rights of a third party.


    For any content that you submit, you grant Bookswagon a perpetual, irrevocable, royalty-free, transferable right and license to use, copy, modify, delete in its entirety, adapt, publish, translate, create derivative works from and/or sell, transfer, and/or distribute such content and/or incorporate such content into any form, medium or technology throughout the world without compensation to you. Additionally,  Bookswagon may transfer or share any personal information that you submit with its third-party service providers, including but not limited to Bazaarvoice, Inc. in accordance with  Privacy Policy


    All content that you submit may be used at Bookswagon's sole discretion. Bookswagon reserves the right to change, condense, withhold publication, remove or delete any content on Bookswagon's website that Bookswagon deems, in its sole discretion, to violate the content guidelines or any other provision of these Terms of Use.  Bookswagon does not guarantee that you will have any recourse through Bookswagon to edit or delete any content you have submitted. Ratings and written comments are generally posted within two to four business days. However, Bookswagon reserves the right to remove or to refuse to post any submission to the extent authorized by law. You acknowledge that you, not Bookswagon, are responsible for the contents of your submission. None of the content that you submit shall be subject to any obligation of confidence on the part of Bookswagon, its agents, subsidiaries, affiliates, partners or third party service providers (including but not limited to Bazaarvoice, Inc.)and their respective directors, officers and employees.

    Accept

    New Arrivals


    Inspired by your browsing history


    Your review has been submitted!

    You've already reviewed this product!
    ASK VIDYA