You are previewing XML Data Management: Native XML and XML-Enabled Database Systems.
O'Reilly logo
XML Data Management: Native XML and XML-Enabled Database Systems

Book Description

"This is an excellent book that combines a practical and analytical look at the subject."

—Leo Korman, Principal Software Engineer, KANA Software

As organizations begin to employ XML within their information-management and exchange strategies, data management issues pertaining to storage, retrieval, querying, indexing, and manipulation increasingly arise. Moreover, new information-modeling challenges also appear. XML Data Management—with its contributions from experts at the forefront of the XML field—addresses these key issues and challenges, offering insights into the advantages and drawbacks of various XML solutions, best practices for modeling information with XML, and developing custom, in-house solutions.

In this book, you will find discussions on the newest native XML databases, along with information on working with XML-enabled relational database systems. In addition, XML Data Management thoroughly examines benchmarks and analysis techniques for performance of XML databases.

Topics covered include:

  • The power of good grammar and style in modeling information to alleviate the need for redundant domain knowledge

  • Tamino's XML storage, indexing, querying, and data access features

  • The features and APIs of open source eXist

  • Berkeley DB XML's ability to store XML documents natively

  • IBM's DB2 Universal Database and its support for XML applications

  • Xperanto's method of addressing information integration requirements

  • Oracle's XMLType for managing document centric XML documents

  • Microsoft SQL Server 2000's support for exporting and importing XML data

  • A generic architecture for storing XML documents in a relational database

  • X007, XMach-1, XMark, and other benchmarks for evaluating XML database performance

Numerous case studies demonstrate real-world problems, industry-tested solutions, and creative applications of XML data management solutions.

Written for both XML and relational database professionals, XML Data Management provides a promising new approach to data management, one that is sure to positively impact the way organizations manage and exchange information.



0201844524B01302003

Table of Contents

  1. Copyright
  2. Preface
  3. Acknowledgments
  4. What Is XML?
    1. Information Modeling with XML
      1. Introduction
      2. XML as an Information Domain
      3. How XML Expresses Information
      4. Patterns in XML
      5. Common XML Information-Modeling Pitfalls
      6. A Very Simple Way to Design XML
      7. Conclusion
  5. Native XML Databases
    1. Tamino—Software AG's Native XML Server
      1. Introduction
      2. Tamino Architecture and APIs
      3. XML Storage
      4. Querying XML
      5. Tools
      6. Full Database Functionality
      7. Conclusion
    2. eXist Native XML Database
      1. Introduction
      2. Features
      3. System Architecture Overview
      4. Getting Started
      5. Query Language Extensions
      6. Application Development
      7. Technical Background
      8. Conclusion
    3. Embedded XML Databases
      1. Introduction
      2. A Primer on Embedded Databases
      3. Embedded XML Databases
      4. Building Applications for Embedded XML Databases
      5. Conclusion
  6. XML and Relational Databases
    1. IBM XML-Enabled Data Management Product Architecture and Technology
      1. Introduction
      2. Product and Technology Offering Summaries
      3. Current Architecture and Technology
      4. Future Architecture and Technology
      5. Conclusion
      6. Notices
    2. Supporting XML in Oracle9i
      1. Introduction
      2. Storing XML as CLOB
      3. XMLType
      4. Using XSU for Fine-Grained Storage
      5. Building XML Documents from Relational Data
      6. Web Access to the Database
      7. Special Oracle Features
      8. Conclusion
    3. XML Support in Microsoft SQL Server 2000
      1. Introduction
      2. XML and Relational Data
      3. XML Access to SQL Server
      4. Serializing SQL Query Results into XML
      5. Providing Relational Views over XML
      6. SQLXML Templates
      7. Providing XML Views over Relational Data
      8. Conclusion
    4. A Generic Architecture for Storing XML Documents in a Relational Database
      1. Introduction
      2. System Architecture
      3. The Data Model
      4. Creating the Database
      5. Connecting to the Repository
      6. Uploading XML Documents
      7. Querying the Repository
      8. Further Enhancements
      9. Conclusion
    5. An Object-Relational Approach to Building a High-Performance XML Repository
      1. Introduction
      2. Overview of XML Use-Case Scenario
      3. High-Level System Architecture
      4. Detailed Design Descriptions
      5. Conclusion
  7. Applications of XML
    1. Knowledge Management in Bioinformatics
      1. Introduction
      2. A Brief Molecular Biology Background
      3. Life Sciences Are Turning to XML to Model Their Information
      4. A Genetic Information Model
      5. NeoCore XMS*
      6. Integration of BLAST into NeoCore XMS
      7. Conclusion
    2. Case Studies of XML Used with IBM DB2 Universal Database
      1. Introduction
      2. Case Study 1: “Our Most Valued Customers Come First”
      3. Case Study 2: “Improve Cash Flow”
      4. Conclusion
      5. Notices
    3. The Design and Implementation of an Engineering Data Management System Using XML and J2EE
      1. Introduction
      2. Background and Requirements
      3. Overview
      4. Design Choices
      5. Future Directions
      6. Conclusion
    4. Geographical Data Interchange Using XML-Enabled Technology within the GIDB System
      1. Introduction
      2. GIDB METOC Data Integration
      3. GIDB Web Map Service Implementation
      4. GIDB GML Import and Export
      5. Conclusion
    5. Space Wide Web by Adapters in Distributed Systems Configuration from Reusable Components
      1. Introduction
      2. Advanced Concept Description: The Research Problem
      3. Integration of Components with Architecture
      4. Example
      5. Future Generation NASA Institute for Advanced Concepts, Space Wide Web Research, and Boundaries
      6. Advanced Concept Development
      7. Conclusion
    6. XML as a Unifying Framework for Inductive Databases
      1. Introduction
      2. Past Work
      3. The Proposed Data Model: XDM
      4. Benefits of XDM
      5. Toward Flexible and Open Systems
      6. Related Work
      7. Conclusion
    7. Designing and Managing an XML Warehouse
      1. Introduction
      2. Architecture
      3. Data Warehouse Specification
      4. Managing the Metadata
      5. Storage and Management of the Data Warehouse
      6. DAWAX: A Graphic Tool for the Specification and Management of a Data Warehouse
      7. Related Work
      8. Conclusion
  8. Performance and Benchmarks
    1. XML Management System Benchmarks
      1. Introduction
      2. Benchmark Specification
      3. Benchmark Data Set
      4. Existing Benchmarks for XML
      5. Conclusion
    2. The Michigan Benchmark: A Micro-Benchmark for XML Query Performance Diagnostics
      1. Introduction
      2. Related Work
      3. Benchmark Data Set
      4. Benchmark Queries
      5. Using the Benchmark
      6. Conclusion
    3. A Comparison of Database Approaches for Storing XML Documents
      1. Introduction
      2. Data Models for XML Documents
      3. Databases for Storing XML Documents
      4. Benchmarking Specification
      5. Test Results
      6. Related Work
      7. Summary
    4. Performance Analysis between an XML-Enabled Database and a Native XML Database
      1. Introduction
      2. Related Work
      3. Methodology
      4. Database Design
      5. Discussion
      6. Experiment Result
      7. Conclusion
    5. Conclusion
    6. References
    7. Contributors
      1. Editors
      2. Chapter 1: Information Modeling with XML
      3. Chapter 2: Tamino—Software AG's Native XML Server
      4. Chapter 3: eXist Native XML Database
      5. Chapter 4: Embedded XML Databases
      6. Chapter 5: IBM XML-Enabled Data Management Product Architecture and Technology
      7. Chapter 6: Supporting XML in Oracle9i
      8. Chapter 7: XML Support in Microsoft SQL Server 2000
      9. Chapter 8: A Generic Architecture for Storing XML Documents in a Relational Database
      10. Chapter 9: An Object-Relational Approach to Building a High-Performance XML Repository
      11. Chapter 10: Knowledge Management in Bioinformatics
      12. Chapter 11: Case Studies of XML Used with IBM DB2 Universal Database
      13. Chapter 12: The Design and Implementation of an Engineering Data Management System Using XML and J2EE
      14. Chapter 13: Geographical Data Interchange Using XML-Enabled Technology within the GIDB System
      15. Chapter 14: Space Wide Web by Adapters in Distributed Systems Configuration from Reusable Components
      16. Chapter 15: XML as a Unifying Framework for Inductive Databases
      17. Chapter 16: Designing and Managing an XML Warehouse
      18. Chapter 17: XML Management System Benchmarks
      19. Chapter 18: The Michigan Benchmark: A Micro-Benchmark for XML Query Performance Diagnostics
      20. Chapter 19: A Comparison of Database Approaches for Storing XML Documents
      21. Chapter 20: Performance Analysis between an XML-Enabled Database and a Native XML Database