Additionally, it includes tools such as a minimal Web server, command line and GUI management tools (can be run as applets), and a number of demonstration examples. It can run on Java runtimes from version 1.1 upwards, including free Java implementations such as Kaffe.
HSQLDB is available under a BSD license. It is used as a database and persistence engine in many open source software projects, such as descendants of OpenOffice.org Base (i.e., Apache OpenOffice Base, LibreOffice Base, etc.), and the Jitsi VoIP and video-conference client since version 2.6.[4] It is also used in commercial products, such as Mathematica and InstallAnywhere (starting with version 8.0).[5]
HSQLDB version 2.0 has three transaction control modes. It supports read committed and serializable transaction isolation levels with table level locks or with multiversion concurrency control (MVCC), or a combination of locks and MVCC. Version 1.8.1 supports transaction isolation level 0 (read uncommitted) only.[6]
Data storageedit
HSQLDB has two main table types used for durable read-write data storage, i.e., if a transaction has been successfully committed, it is guaranteed that the data will survive system failure and will keep their integrity.
The default MEMORY type stores all data changes to the disk in the form of a SQL script. During engine start-up, these commands are executed and data are reconstructed into the memory.
Another table type is CACHED, which allows one to store more data, at the cost of the slower performance. The HSQLDB engine loads them only partially and synchronizes the data to the disk on transaction commits. However, the engine always loads all rows affected during an update into the memory. This renders very large updates impossible without splitting the work into smaller parts.[7]
Other table types allow access to comma-separated values (CSV) files. These tables can participate, for example, in queries with JOINs and simplify spreadsheet processing and read-write non-durable in-memory data storage.
SQL featuresedit
HSQLDB 2.0 supports all the core features and many optional features of SQL:2008. Advanced features include user-defined SQL procedures and functions, schemas, datetime intervals, updatable views, arrays, lobs, full and lateral joins and set operations. Many non-standard functions such as TO_CHAR and DECODE are also supported. Extensions to standard SQL include user-defined aggregate functions.
Releasesedit
Several versions of HSQLDB have been released since 2001. Early versions were based on the discontinued HypersonicSQL database engine. Version 2.0, released in 2010, is mostly new code, written to conform to Standard SQL and JDBC 4 Specification.[8]
hsqldb, this, article, multiple, issues, please, help, improve, discuss, these, issues, talk, page, learn, when, remove, these, template, messages, this, article, needs, additional, citations, verification, please, help, improve, this, article, adding, citatio. This article has multiple issues Please help improve it or discuss these issues on the talk page Learn how and when to remove these template messages This article needs additional citations for verification Please help improve this article by adding citations to reliable sources Unsourced material may be challenged and removed Find sources HSQLDB news newspapers books scholar JSTOR February 2008 Learn how and when to remove this template message This article relies excessively on references to primary sources Please improve this article by adding secondary or tertiary sources Find sources HSQLDB news newspapers books scholar JSTOR February 2008 Learn how and when to remove this template message Learn how and when to remove this template message HSQLDB Hyper SQL Database is a relational database management system written in Java It has a JDBC driver and supports a large subset of SQL 92 SQL 2008 SQL 2011 and SQL 2016 standards 2 It offers a fast 3 small around 1300 kilobytes in version 2 2 database engine which offers both in memory and disk based tables Both embedded and server modes are available HSQLDB HyperSQL DataBase HSQL Database ManagerInitial release2001 23 years ago 2001 Stable release2 7 2 1 June 2023 10 months ago 1 June 2023 Repositorysvn wbr code wbr sf wbr net wbr p wbr hsqldb wbr svn wbr Written inJavaOperating systemCross platformSize10 8 MB 2 6 0 ZIP file 1 TypeRDBMSLicenseBSDWebsitehsqldb wbr org Additionally it includes tools such as a minimal Web server command line and GUI management tools can be run as applets and a number of demonstration examples It can run on Java runtimes from version 1 1 upwards including free Java implementations such as Kaffe HSQLDB is available under a BSD license It is used as a database and persistence engine in many open source software projects such as descendants of OpenOffice org Base i e Apache OpenOffice Base LibreOffice Base etc and the Jitsi VoIP and video conference client since version 2 6 4 It is also used in commercial products such as Mathematica and InstallAnywhere starting with version 8 0 5 Contents 1 Transaction support 2 Data storage 3 SQL features 4 Releases 5 See also 6 References 7 External linksTransaction support editHSQLDB version 2 0 has three transaction control modes It supports read committed and serializable transaction isolation levels with table level locks or with multiversion concurrency control MVCC or a combination of locks and MVCC Version 1 8 1 supports transaction isolation level 0 read uncommitted only 6 Data storage editHSQLDB has two main table types used for durable read write data storage i e if a transaction has been successfully committed it is guaranteed that the data will survive system failure and will keep their integrity The default MEMORY type stores all data changes to the disk in the form of a SQL script During engine start up these commands are executed and data are reconstructed into the memory Another table type is CACHED which allows one to store more data at the cost of the slower performance The HSQLDB engine loads them only partially and synchronizes the data to the disk on transaction commits However the engine always loads all rows affected during an update into the memory This renders very large updates impossible without splitting the work into smaller parts 7 Other table types allow access to comma separated values CSV files These tables can participate for example in queries with JOINs and simplify spreadsheet processing and read write non durable in memory data storage SQL features editHSQLDB 2 0 supports all the core features and many optional features of SQL 2008 Advanced features include user defined SQL procedures and functions schemas datetime intervals updatable views arrays lobs full and lateral joins and set operations Many non standard functions such as TO CHAR and DECODE are also supported Extensions to standard SQL include user defined aggregate functions Releases editSeveral versions of HSQLDB have been released since 2001 Early versions were based on the discontinued HypersonicSQL database engine Version 2 0 released in 2010 is mostly new code written to conform to Standard SQL and JDBC 4 Specification 8 Version 2 3 2 released in 2014 is fully multi threaded and supports high performance two phase locking and MVCC multiversion concurrency control transaction control models See also edit nbsp Free and open source software portalList of relational database management systems Comparison of relational database management systems Apache Derby H2References edit Home hsqldb hsqldb 2 6 HyperSQL Database Engine HSQLDB SourceForge 21 March 2021 Retrieved 1 April 2021 HSQLDB SQL Syntax hsqldb org PolePosition Performance Comparison polepos org Jitsi build 5390 release notes Jitsi org Archived from the original on 2015 02 02 Retrieved 2015 02 01 Software using HSQLDB hsqldb org HSQLDB Documentation hsqldb org HSQLDB Documentation hsqldb org Archived from the original on 2015 05 02 Retrieved 2007 11 11 The new HSQLDB hsqldb org External links editOfficial website nbsp Retrieved from https en wikipedia org w index php title HSQLDB amp oldid 1215639219, wikipedia, wiki, book, books, library,
