Jump to main content
Product Documentation
Customer Support
HCL OneDB V 1.0.1.0
What's new in
HCL OneDB™
1.0.1.0
Getting Started
Installing
Administering
Security
Client APIs and tools
SQL programming
JSON compatibility
Extending
HCL OneDB™
Designing databases
Embedding
HCL OneDB™
Release information
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.
Appendixes
This section contains additional reference information.
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.
Appendixes
This section contains additional reference information.
Character sets
When you create an
etx
index, you specify the character set the search engine uses by setting the CHAR_SET index parameter. The value you specify determines which characters in your text data are indexed and which are treated as white space.
Document formats you can filter
uses Oracle Outside-In Content Access, Version 8.4.0 filtering libraries. You can use filter the following document formats and versions.
The etx_lists table
This section describes the
etx_lists
table, a system table that contains information about stopword lists, synonym lists, and user-defined character sets. Each time you create or drop one of these objects, an entry for the object is inserted or deleted in the table.
Glossary
Error messages
This section lists all the module errors, the error text, a brief description of the error, and corrective action to take if you encounter the error.
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.
Appendixes
This section contains additional reference information.
Character sets
When you create an
etx
index, you specify the character set the search engine uses by setting the CHAR_SET index parameter. The value you specify determines which characters in your text data are indexed and which are treated as white space.
Document formats you can filter
uses Oracle Outside-In Content Access, Version 8.4.0 filtering libraries. You can use filter the following document formats and versions.
The etx_lists table
This section describes the
etx_lists
table, a system table that contains information about stopword lists, synonym lists, and user-defined character sets. Each time you create or drop one of these objects, an entry for the object is inserted or deleted in the table.
Glossary
Error messages
This section lists all the module errors, the error text, a brief description of the error, and corrective action to take if you encounter the error.