Home | Previous Page | Next Page

Design Decisions

In This Chapter

Storing Data in Shared Memory

Functions that Allocate and Free Memory

Memory-Duration Options

Persistent User Data

Accessing Database and System Catalog Tables

Executing a UDR Across Databases of the Same Database Server Instance

Handling the Unexpected

Using Callback Functions

Using Error Messages

Supporting Data Definition Statements

Interpreting the Table Descriptor

Managing Storage Spaces

Choosing DataBlade API Functions

Setting the am_sptype Value

Creating a Default Storage Space

Ensuring Data Integrity

Checking Storage-Space Type

Supporting Fragmentation

Providing Configuration Keywords

Building New Indexes Efficiently

Enabling Alternative Indexes

Supporting Multiple-Column Index Keys

Obtaining the Routine Identifier

Reusing the Function Descriptor

Processing Queries

Interpreting the Scan Descriptor

Interpreting the Qualification Descriptor

Simple Functions

Runtime Values as Arguments

Complex Boolean Expressions

Qualifying Data

Supporting Query Plan Evaluation

Enhancing Performance

Executing in Parallel

Bypassing Table Scans

Buffering Multiple Results

Supporting Data Retrieval, Manipulation, and Return

Enforcing Unique-Index Constraints

Checking Isolation Levels

Converting to and from Row Format

Determining Transaction Success or Failure

Supplying Error Messages and a User Guide

Avoiding Database Server Exceptions

Statements That the Access Method Does Not Support

Keywords That the Access Method Does Not Support

Storage Spaces and Fragmentation

Features That the VII Does Not Support

Notifying the User About Access-Method Constraints

Data Integrity Limitations

WHERE Clause Limitations

Documenting Nonstandard Features

Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]