Home
Extending Informix®Beyond standard relational database objects, HCL Informix® can be extended to handle specialized data types, access methods, routines, and other objects. Informix® includes many built-in extensions that are fully integrated in the database server. Informix® also provides DataBlade® modules, which are packages of extended database objects for a particular purpose and that are installed separately from the database server. Alternatively, you can create your own user-defined objects for Informix®.
Creating extensionsYou can create user-defined data types, routines, access methods, and other database objects to suit your needs. You can use application programming interfaces to write user-defined routines and applications that access data in Informix® databases.
R-Tree Index User's GuideThe Informix® R-Tree Index User's Guide describes the HCL Informix® R-tree secondary access method and how to access and use its components.
Manage databases that use the R-tree secondary access method
R-tree index and logging

R-tree index and logging

The R-tree secondary access method uses the extensible log manager of the HCL Informix® database server to perform logical logging of its operations. These logical-log records can be used to recover an R-tree index after a database server failure or to abort the R-tree operations after a rollback.

The R-tree secondary access method creates its own logical-log records for only some of the R-tree index operations, in particular:

Insertion of an item into a leaf page
Deletion of an item from a leaf page

The R-tree secondary access method does not create its own logical-log records for the following operations; instead, the access method allows the extensible log manager to create the logical-log records:

Insertion of an item into or deletion from an internal branch page
Creation of a new page due to split of a page
Update of the bounding box or other metadata in a page
Update of the child page of an internal branch page
Update of the root page number in the root page when a new root page is created

The following R-tree operations are not logged at all:

CREATE INDEX statement to create an R-tree index
Any operation on an R-tree index of a temporary table

Rate this topic

5 stars 4 stars 3 stars 2 stars 1 star

Comment on this topic.

By clicking this box, you acknowledge that you are NOT a U.S. Federal Government employee or agency, nor are you submitting information with respect to or on behalf of one. HCL provides software and services to U.S. Federal Government customers through its partners immixGroup, Inc. Contact this team at https://hcltechsw.com/resources/us-government-contact. Do not include any personal data in this Comment box.