Overview

HyperXtremeSQL™ shares HSQLDB's interface and most of the query-processing classes, so it is fully compatible at the application level with the latest release version of HSQLDB.

HyperXtreme X Server Additional SQL Features

Extensive analytics support conforming to advanced OLAP level of SQL:2023 Standard. Supports ALL of the OLAP features of the SQL:2023, more than what the top RDBMS systems support.  Including hypothetical set functions, aggregates with WITHIN GROUP, window queries with OVER ( PARTITION .. GROUP BY ... RANG | ROWS | GROUPS ...)  and fully compatible with major database systems that provide the same functionality. Extended grouping capabilities including CUBE, ROLLUP, GROUPING SETS and the related functions.

PL/HXSQL language for SQL triggers, procedures and functions. Includes support for packages of procedures, functions and variables. The SQL procedural language dialect is similar to PL/SQL.

HyperXtreme Performance and Reliability Features

More efficient memory use for all-in-memory tables.

The new COMPACT table column store supports both transactional and analytic use. Stores up to 8 times more data in the same memory footprint. Fast load and save as multi-gigabyte compact memory tables are loaded and saved in seconds (X server).

Huge speed improvement over HSQLDB with large data sets stored on disk. Two to 8 times the speed depending on the operation.

Better management of disk space with minimum need to defragment the data file.

Versioned secondary persistence allows recreation of database to any point in time. Damaged database file can be recovered / recreated to the latest point.

Creation of indexes, unique and foreign key constraints is much faster than HSQLDB. Dropping indexes and constraints is almost instant.

Improved cost-based query optimisation and processing. Supports query hints.

Very fast bulk data load from CSV files and SQL scripts. Very fast data export export.

Additional SQL syntax compatibility features.

HyperXtremeSQL is supplied in binary format only. Compatible with JDK 8 and later.

Additional documentation on specific aspects of HXSQL (configuration, new SQL and management features) is supplied with the software.

Drop-in Replacement for HSQLDB

Shared features are covered extensively on the HSQLDB WEB SITE. Some important common features are listed below:

• Fully multi-threaded with MVCC and two-phase lock transaction models
• Full support for SQL:2023 core features and around 150 optional features
• Embedded (in-process) and client-server modes of operation
• ACID compliance and full support for transactions
• Extensive syntax compatibility modes for several popular database systems

Migration from HSQLDB

The HyperXtremeSQL jar is a drop-in replacement for the HSQLDB jar. Important improvements and differences are listed below:

• When an existing HSQLDB database is opened, the files are converted to the HXSQL format
• MEMORY tables use less memory than HSQLDB
  
• Large MEMORY tables can be converted to COMPACT table, which use much less memory than HSQLDB (X Server only)
  
• Fast load of file-based COMPACT tables (X Server only)
  
• CACHED tables performance is 2 to 8 times faster for large data sets with the same amount of computer memory
  
• Better performance in multi-threaded database access on client side