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.
The R-tree secondary access method
Before you begin

Before you begin

You can create an R-tree index on a table after you create a table that contains a column that has an appropriate data type.

If you plan to implement a DataBlade® module, complete the following tasks before you create an R-tree index:

Install a DataBlade module on your database server that includes the following objects:
- A user-defined data type that can be indexed with an R-tree index
- An operator class that specifies the functions to be used with the R-tree index
- The support and strategy functions that are required by the operator class
Create a database.
Register the DataBlade module that is described in step 1 into your database with BladeManager.
Create a table that contains one or more columns of the user-defined data type that can be indexed with the R-tree access method.

Important: The examples in these topics use objects that are defined in the sample Shapes3 DataBlade module that Shapes3 sample DataBlade module describes. These objects include the data type MyShape and the operator class MyShape_ops. Columns of data type MyShape can store points, boxes, and circles.

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.