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™
.
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.
User-Defined Routines and Data Types Developer's Guide
The
HCL OneDB™ User-Defined Routines and Data Types Developer's Guide
describes how to define new data types and enable user-defined routines (UDRs) to extend
HCL OneDB™
.
Improve UDR performance
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.
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.
DataBlade® API
Function Reference
The
HCL OneDB™ DataBlade® API Function Reference
describes the
DataBlade® API
functions and the subset of functions that the
DataBlade® API
supports.
DataBlade®
Developers Kit
The
DataBlade®
Developers Kit (DBDK) guides contain information about the tools you can use to develop and package
DataBlade®
modules, which extend the functionality of
HCL OneDB™
databases.
J/Foundation Developer's Guide
The
HCL® J/Foundation Developer's Guide
describes how to write user-defined routines (UDRs) in the Java™ programming language for
HCL OneDB™
.
User-Defined Routines and Data Types Developer's Guide
The
HCL OneDB™ User-Defined Routines and Data Types Developer's Guide
describes how to define new data types and enable user-defined routines (UDRs) to extend
HCL OneDB™
.
Extend the database server
A user-defined routine
Run a user-defined routine
Develop a user-defined routine
Extend data types
Extend operators and built-in functions
Create user-defined casts
Create user-defined aggregates
Create an opaque data type
Write support functions
Extend an operator class
Manage a user-defined routine
Improve UDR performance
Improve performance of C user-defined routines
Optimize a user-defined routine
Optimize functions in SQL statements
Extend UPDATE STATISTICS
Negator functions
A virtual-processor class
Parallel UDRs
Memory considerations
I/O considerations
Improve UDR performance
These topics describe performance considerations for UDRs.
Improve performance of C user-defined routines
Optimize a user-defined routine
Optimize functions in SQL statements
Extend UPDATE STATISTICS
Negator functions
A virtual-processor class
Parallel UDRs
Memory considerations
I/O considerations