Object Oriented Database Learning Center

Objectivity Home - Government - Objectivity/DB - Webinars - Download Software

Download a PDF version of this Article

Learning Center Home

Table of contents:

Building High-perfomance Object Oriented Databases

• The Problem
• High ingest rates
• High delete/archival rates
• Complex relationships
• Flexibility
• Performance Optimization
• Very Large Cardinalities
• A Solution
• Persistence
• The Hierarchical Solution
• The Relational Solution
• An Object-oriented approach to persistence
• Query/Retrieval
• Query by Attribute
• Query by Traversal
• Cache
• Concurrency
• Schema Control and Data Migration
• Transactions (Commit / Rollback)
• Single, Consistent View of Data
• A Practical Example
• Logical Schema
• Message Class
• Attachments and Relationships
• Sender, Recipients, CC Lists and Addresses
• Physical Data Placement
• Using Databases and Containers for Fast Archival and Deletes
• Using Databases and Containers for Fast Queries
• Using Databases, Containers and Range Lists for Parallel Queries
• Hardware Architecture Design and Sizing
• Objectivity/DB Terminology

Using Databases, Containers and Range Lists for Parallel Queries: As described in the section titled “Query by Attribute”, Objectivity/DB allows users and applications the ability to scope queries within databases and containers.

In our system, if a query has a time constraint – i.e., we’re looking for objects that were received within a given time period – we can choose to perform the query only on the databases and containers that fall within or overlap that time range, using the range lists to quickly discover the appropriate “candidate” containers.

We can also use the range lists to provide acceleration to other attributes that may be used as query constraints.

Not only does this greatly reduce the amount of data that needs to be searched, it also provides a simple, but extremely effective, opportunity for performing the query across parallel threads, as shown in Figure 13.