Specific HXSQL Features
Extensive analytic query support with CUBE, ROLLUP, GROUPING
SETS, WITHIN GROUP, window queries with OVER ( PARTITION ..
GROUP BY ... RANG | ROWS ...) conforming to Standard SQL and
fully compatible with major database systems that provide the
PL/HXSQL language for SQL triggers, procedures and functions.
Similar dialect to PL/SQL.
More efficient memory use for all-in-memory tables.
The server X version has additional column store compact memory features supporting 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
HyperXtremeSQL is supplied in binary format only. Compatible
with JDK 6 and
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:2011 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