Features Summary

JAVA

  • 100% Java
  • Support JDK 1.1.x, 1.2.x, 1.3.x, 1.4.x, 1.5.x, 1.6.x
  • Extensive JDBC interface support with batch statement and scrollable ResultSet functionality
  • Full JDBC DatabaseMetaData and ResultSetMetaData support
  • Java stored procedures and functions
  • Full support for PreparedStatement objects to speed up query processing

SQL

  • Relational Database Management System, with the object capabilities of Java
  • Very extensive support for SQL:2003 Standard syntax, including most optional features
  • Supports all base data types of the SQL Standard, including BINARY, BIT, BOOLEAN, date-time, INTERVAL, BLOB, CLOB
  • Supports user-defined DOMAIN types, including type constraints
  • Fast SELECT, INSERT, DELETE, UPDATE and MERGE operations
  • INNER, LEFT OUTER, RIGHT OUTER and FULL joins
  • UNION, EXCEPT, INTERSECT, including use of parentheses, limits and offsets
  • Scalar (single value) SELECTS, row and correlated subqueries including IN, EXISTS, ANY, ALL
  • Views, Temp tables and sequences
  • Primary key, unique and check constraints on single or multiple columns
  • Referential Integrity (foreign keys) on multiple columns with full cascading options (delete, update, set null, set default)
  • ORDER BY, GROUP BY and HAVING
  • COUNT, SUM, MIN, MAX, AVG and statistical aggregate functions
  • Full support for SQL expressions such as CASE .. WHEN .. ELSE .. , NULLIF etc.
  • SQL standard autoincrement column support plus sequences
  • Transaction COMMIT, ROLLBACK and SAVEPOINT support
  • Multiple schemata per database
  • Triggers, implemented as Java classes, or as SQL statements
  • Database security with passwords, user rights and roles with GRANT and REVOKE
  • Extensive set of ALTER TABLE commands, including change of table column type

Persistence

  • In-memory tables for fastest operation
  • Disk based tables for large data sets
  • Text tables with external file data sources such as CSV files
  • Disk tables (CACHED TABLE) up to 8GB and text tables up to 2GB each
  • Size of each string or binary item only limited by memory
  • Database dump as SQL script with or without data

Deployment

  • Embedded (into Java applications) and Client-Server operating modes
  • Three client server protocols: HSQL, HTTP and HSQL-BER – can run as an HTTP web server – all with SSL option
  • Can be used in applets, read-only media (CD), inside jars, webstart and embedded applications
  • Multiple databases per JVM

Utilities

  • Powerful and compact java command line and GUI tools for database management
  • Tranfer tool for conversion of databases to / from other popular database managment systems

SourceForge Logo

This page last updated 20 April 2008

Link: http://hsqldb.org/web/hsqlFeatures.html

Post a Comment

Required fields are marked *

*
*

%d bloggers like this: