Jump to main content
Product Documentation
Customer Support
HCL OneDB 2.0.1
What's new in
HCL OneDB™
2.0.1
Getting Started
Installing
Administering
Migrating and upgrading
Data warehousing
Security
Client APIs and tools
SQL programming
JSON compatibility
Extending
HCL OneDB™
Designing databases
Embedding
HCL OneDB™
Release information
Troubleshooting
HCL OneDB™
Search
Home
Extending
HCL OneDB™
Beyond standard relational database objects,
HCL OneDB™
can be extended to handle specialized data types, access methods, routines, and other objects.
HCL OneDB™
includes many built-in extensions that are fully integrated in the database server.
HCL OneDB™
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
HCL OneDB™
.
HCL OneDB™
extensions and
DataBlade®
modules
These topics describe how to use built-in database extensions and separately installed
DataBlade®
modules.
Excalibur Text Search
DataBlade®
Module User's Guide
These topics describe the module and how to access and use its components.
Administration
The purpose of this section is to make database administrators aware of configuration and performance issues related to the features of the module.
Configure your database server
This section describes the database server administration topics.
Extending
HCL OneDB™
Beyond standard relational database objects,
HCL OneDB™
can be extended to handle specialized data types, access methods, routines, and other objects.
HCL OneDB™
includes many built-in extensions that are fully integrated in the database server.
HCL OneDB™
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
HCL OneDB™
.
HCL OneDB™
extensions and
DataBlade®
modules
These topics describe how to use built-in database extensions and separately installed
DataBlade®
modules.
Database Extensions User's Guide
The
HCL OneDB™
Database Extensions User's Guide
explains how to use the database extensions that come with
HCL OneDB™
: Large Object Locator, MQ messaging, binary data types, basic text search, node data type,
HCL OneDB™
web feature service for Geospatial Data,
and SQL packages.
Performing XML Publishing
The
HCL OneDB™
XML User's Guide
includes information about using built-in functions for XML publishing with
HCL® OneDB®
.
Excalibur Text Search
DataBlade®
Module User's Guide
These topics describe the module and how to access and use its components.
Overview
This section provides an overview of the module.
Concepts
This section describes the different types of searches you can perform with the module and characterizes how the text search engine assigns word scores and document scores.
Tutorial
This section provides a step-by-step procedure for setting up and performing text searches by using the module.
Data types
This section describes the data types that come with the module.
Routines
This section provides you with reference information about the
etx_contains()
operator and other routines defined for the
DataBlade®
module.
The etx index parameters
This section describes the index parameters that can be used to customize an
etx
index. You specify index parameters in the USING clause of the CREATE INDEX statement.
Administration
The purpose of this section is to make database administrators aware of configuration and performance issues related to the features of the module.
Retrieve
DataBlade®
module version information
This section shows how to obtain precise version information that you might need to fully understand dependency and compatibility requirements or to identify problems to technical support staff.
Configure your database server
This section describes the database server administration topics.
Create and configure sbspaces
The module uses sbspaces in various ways. This section covers the minimum you must know about sbspaces to correctly register and use the
DataBlade®
module.
Set ONCONFIG tuning parameters
Configure your database server for filtering
This section describes steps you complete before you create an index with the FILTER parameter.
Refine etx indexes
This section describes ways you can refine your
etx
index to improve the performance of searches.
Choose the appropriate storage data type
You can improve performance by choosing the appropriate storage data type for your data. This section describes the advantages and disadvantages of storing text documents in the following supported data types: BLOB, CLOB, LVARCHAR, IfxDocDesc, and IfxMRData.
Load data
You can expedite indexing by the way you load your data into the table.
Handling deadlocks
Program your application or instruct your users to retry data loading statements that encounter a deadlock error.
Renaming two database names that have etx indexes
You cannot rename two databases with
etx
indexes to the other names of a database even if you drop the indexes, unless you follow a procedure that includes restarting the server. Each database maintains in-memory cached data that includes the database name.
Refine queries
You might have to refine some of the SQL syntax you are used to using to take advantage of the features of the module
Appendixes
This section contains additional reference information.
Spatial Data User's Guide
The
HCL OneDB™ Spatial Data User's Guide
contains information to assist you in using the
HCL® OneDB®
spatial extension. The
HCL® OneDB®
spatial extension adds custom data types and supporting routines to the server.
Spatiotemporal Search for Moving Objects User's Guide
The
HCL OneDB™ Spatiotemporal Search for Moving Objects User's Guide
describes how to program applications to search data from moving objects in
HCL OneDB™
databases using the spatiotemporal search extension.
TimeSeries Data User's Guide
The
HCL OneDB™ TimeSeries Data User's Guide
contains information to assist you in using the TimeSeries extension with
HCL OneDB™
.
Creating extensions
You 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
HCL OneDB™
databases.
Configure your database server
This section describes the database server administration topics.
Create and configure sbspaces
The module uses sbspaces in various ways. This section covers the minimum you must know about sbspaces to correctly register and use the
DataBlade®
module.
Set ONCONFIG tuning parameters
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.