Services

Professional Support for HyperSQL (HSQLDB)

HyperSQL (HSQLDB) and HyperXtremeSQL customisation

Java / Database Consulting

Products

2.x series Jan 2013

HyperXtreme S 2.2.9 server for JDK 1.5 or later

HyperXtreme W 2.2.9 workstation for JDK 1.5 or later

HyperXtreme E 2.2.9 embedded for JDK 1.5

1.8.x series July 2010

HyperXtreme G 1.8.1 for JDK 1.4 or later.

HyperXtreme PDA 1.8.1 for JDK 1.1 - 1.3.

HyperXtreme CDC 1.8.1 for embedded CDC

HyperXtreme speed, HyperXtreme power RDBMS

HyperXtremeSQL™ is a super-fast SQL database engine written in Java. It support SQL and JDBC in J2SE and J2EE contexts.

HyperXtremeSQL has been developed in parallel with the open-source HyperSQL (HSQLDB) engine.  Fully compatible at the application level, it can replace the HSQLDB jar in an existing application with no change to the code. It has all the advantages of HyperSQL, including MVCC and lock-based transactional modes and the highly advanced SQL and database management features.

HyperXtremeSQL is built around a new indexing and persistence core that breaks new ground as it lowers the code footprint, reduces memory use and at the same time significantly speeds up performance in all areas of SQL, all modes of database operation and all sizes of database.

Since its introduction in late 2004, HyperXtremeSQL has been in use on hundreds of servers, thousands of desktops and tens of thousands of embedded platforms. The new version 2.0 features major improvements over previous versions.
^ TOP

Speed

HyperXtremeSQL raises the SQL performance bar to such levels that allow existing applications to scale up beyond their original limits.

Data can be selected or inserted at rates of up to hundreds of thousand rows per second. By harnessing such phenomenal performance, HXSQL opens new horizons for all Java applications.

• Server High-performance server applications are no longer hampered by slow database layers. No need to implement complex proprietary data access and persistence schemes. Standard SQL and JDBC can be used in all areas.
• Desktop Data-intensive workstation applications can benefit from the power of relational queries and OLAP. With the use of SQL, development efforts can be channelled to the implementation of domain-specific features instead of data access and manipulation.
• Embedded Embedded devices with limited speed and memory will benefit from the speed increase and smaller memory footprint.

The SQL / JDBC interface is highly optimised and adds only a marginal overhead to data storage and retrieval. Applications that need fast indexed access to large amounts of data, whether in memory or on disk, can use HXSQL instead of bare indexed access solutions. The fully-featured SQL query engine offers additional query possibilities to simplify reporting and management.

Scalability

HyperXtremeSQL can scale up or down to suit the platform and data set. It can handle millions of rows of data with up to 2TB data storage and 64TB lob storage. Special versions scale down for use in embedded platforms (PDA and embedded applications), offering maximum speed in a small memory footprint.

Background

HyperXtremeSQL is a separate product from HSQLDB and has been developed by Fred Toussi, lead developer and maintainer of HSQLDB. Each version of HyperXtremeSQL is fully compatible with a release version of HSQLDB.