HyperXtremeSQL

HyperXtremeSQL is a super-fast SQL database system. It support SQL and JDBC in J2SE and J2EE Java contexts. In-memory column store for compact storage of data with optional persistence. Far more advanced and faster than object stores, no-SQL databases, and most SQL databases. Can be deployed on cloud or local network within or outside the applicati... on. Very high throughputs of OLTP transactional queries and updates with microsecond latency. Optimized fast ETL operations with data load and save running concurrently with OLTP and OLAP. The latest version of 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 user application code. Supported by many third party frameworks and applications, it has all the advantages of HyperSQL including MVCC and lock-based transactional modes and database management features such as hot backup. HyperXtremeSQL capabilities go way beyond HSQLDB by supporting: CUBE, ROLLUP and GROUPING SETS together with a full range of aggregate functions for linear regression, correlation, percentile etc. with WITHIN GROUP clause and super-aggregate. PL/HXSQL language, similar to PL/SQL dialect, for procedures, functions and triggers inside or outside PACKAGE declarations. Up to 8 times more data in the same amount of memory. High-performance query optimiser and query processor. 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.Read More