HyperXtremeSQL

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:2011 Standard. Supports ALL the features of the SQL:2011, 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. Similar dialect to PL/SQL.

HyperXtreme X Performance and Reliability Features

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

The new 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.

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.

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: