h2database/h2database

Features

• Database Record Querying - Provides a full SQL engine for retrieving records using filters, grouping, window functions, and sorting.
• Embedded Database Runtimes - Functions as an embeddable database engine that runs directly within the host application process.
• Embedded Database Servers - Functions as a lightweight database engine that runs in-process within a Java application.
• Relational Data Storage - Provides a full relational database engine with SQL support, ACID transactions, and multi-version concurrency control.
• ACID Transactional Cores - Implements a core transactional engine supporting ACID compliance and multi-version concurrency control for data consistency.
• Aggregate Calculations - Computes standard aggregate values such as sum, average, minimum, maximum, and count across rows.
• Transaction Lifecycle Control - Provides standard transaction management including commit, rollback, and savepoint operations to ensure data atomicity.
• Database File Locking - Ensures data integrity by preventing multiple concurrent processes from writing to the same database file.
• Local File Storage - Provides structured data storage on local disk or in-memory for desktop applications and development environments.
• Database Initializations - Initializes new databases via connection URLs, shell tools, or the web console.
• Database User Privilege Management - Implements granular access control by granting and revoking operation rights on database schemas and tables.
• Embeddable Databases - Operates as an embeddable SQL database engine that runs within the application process.
• Embedded Database Integrations - Integrates directly into Java application processes to eliminate network latency and deployment complexity.
• In-Memory Databases - Provides an in-memory storage mode for high-performance, volatile data processing.
• Indexes and Constraints - Provides full management of database indexes and integrity constraints, including unique and spatial types.
• Multi-Version Concurrency Control - Implements multi-version concurrency control to allow simultaneous non-blocking reads and writes via data snapshots.
• Numeric Precision Management - Provides precise decimal types to ensure accurate floating point and currency calculations.
• Pluggable Storage Engines - Features a pluggable storage architecture allowing switches between in-memory, disk, and compressed zip backends.
• Cost-Based Optimizers - Uses table statistics to determine the most efficient physical execution path for SQL statements.
• Relational Database Management Systems - Provides a full JDBC-compliant relational database management system written in Java.
• SQL Dialect Adapters - Implements a dialect emulation layer to maintain compatibility with various other relational database systems.
• B-Tree - Uses a B-Tree page storage architecture to optimize disk-based data retrieval and updates.
• Transaction Demarcation & Isolation - Prevents data anomalies by supporting standard SQL transaction isolation levels.
• Transaction Recovery Logs - Prevents data loss by re-applying committed changes from transaction logs after a system failure.
• JDBC Driver Implementations - Integrates with Java applications using standard JDBC drivers and connection URLs.
• Write-Ahead Logging - Implements write-ahead logging with undo and redo logs to ensure transactional atomicity and recovery.
• Remote Server Connectivity - Enables remote data management by connecting to a standalone server via TCP/IP.
• Database Server-Client Models - Supports a server-client model allowing remote applications to access data via TCP/IP sockets.
• User Role Management - Manages the lifecycle of database users and security roles, including creation and modification.
• Password Hashing Utilities - Protects user credentials by storing them as secure, irreversible cryptographic hashes.
• Database Connectivity Drivers - Provides standard JDBC drivers and connection URLs to link Java applications to the database.
• Window Ranking Functions - Provides window ranking functions to assign row numbers, ranks, and percentiles based on ordering and partitioning.
• Online Backups - Performs online backups by copying persisted data files while write operations are ongoing.
• Change Data Capture - Retrieves the old, new, and final state of rows to capture data changes for external streaming or auditing.
• Complex Data Types - Supports non-scalar data structures including JSON, UUIDs, and enumerated types.
• SQL Exports - Converts database content into SQL scripts to facilitate data migration and restoration.
• Backup Compression - Creates transactionally consistent compressed zip files of database files for efficient backup and recovery.
• Data Integrity Constraints - Ensures data consistency through the enforcement of primary keys, foreign keys, and check constraints.
• Geospatial Data Types - Provides support for coordinate-based data structures and geometry objects using OGC formats.
• Versioned Dataset Snapshots - Creates copy-on-write snapshots of the data state to enable versioned reads and store rollbacks.
• JSON Persistence - Stores RFC-compliant JSON text as byte arrays while preserving member order and structural integrity.
• Database Buffer Pool Management - Adjusts memory allocated for frequently used data to optimize speed and resource consumption.
• Table Lifecycle Management - Provides full lifecycle management for tables, including creation, renaming, alteration, and deletion.
• Relational Database Metadata Inspectors - Implements standard-compliant schema queries to retrieve information about tables, columns, and indexes.
• Execution Plan Analysis - Inspects internal execution plans and scan counts to optimize index usage and query performance.
• Corruption Recovery Utilities - Offers utilities to extract data and transaction logs from corrupted files into SQL scripts for restoration.
• Windowed Row Accessors - Retrieves values from preceding or following rows within a partition using window offsets.
• Database Triggers - Provides database triggers to execute automated logic in response to data modifications on tables.
• Database Emulators - Mimics the behavior and syntax of other database engines to maintain compatibility with existing applications.
• Embedded Database Server Modes - Supports a mixed mode that allows simultaneous local in-process access and remote network access.
• Page-Based Storage - Utilizes a page-based storage architecture with B-tree structures to optimize disk access and allocation.
• Full Text Search - Provides keyword searching across large volumes of text using native storage or Lucene indexing.
• Connection Pooling - Maintains a pool of reusable database connections to reduce the overhead of session establishment.
• Identity Column Generation - Automatically generates unique row identifiers using identity columns and sequences.
• Virtual View Management - Supports the creation and recompilation of both virtual tables and materialized views.
• Binary Object Storage - Supports the storage and retrieval of large binary data objects using BLOB types.
• ORM Integrations - Facilitates the connection of object-relational mapping frameworks to the database using native dialects.
• Pluggable Storage Backends - Supports pluggable storage backends allowing data to be persisted in memory, on disk, or within compressed zip files.
• Persistent Storage Engines - Includes a low-level persistent storage engine with capabilities for checkpoints and database compaction.
• Row Deletions - Allows the removal of specific records from tables using conditional filters and limits.
• Bucket-Based Distribution - Divides rows into equal-sized buckets and returns the group number for each row via window functions.
• Row Insertions - Enables the addition of new records to tables, including the ability to pipe results from other queries.
• Row Update Operations - Provides the capability to modify existing values within a table based on specified criteria.
• Database Memory Indexing - Employs hash-based memory structures to speed up direct lookups for both persistent and volatile tables.
• Spatial Aggregation Functions - Computes the minimum bounding box that encloses a collection of geometry values using spatial aggregation.
• Spatial Indexing - Provides spatial indexing capabilities to efficiently query geometric data using R-tree implementations.
• SQL Script Execution - Restores database schemas and data by executing SQL scripts from files or URLs.
• Binary Data Streaming - Implements binary data streaming by splitting large objects into blocks for random access.
• Storage Abstractions - Provides a unified interface to manage data across diverse media such as memory, disk, and zip files.
• Stored Procedures - Implements stored procedures to execute user-defined logic directly within the database engine.
• Upsert Operations - Provides atomic upsert operations that either insert a new record or update an existing one based on a key.
• User-Defined Functions - Provides the ability to implement custom logic as functions that can be called within SQL queries.
• Web-Based Database Clients - Includes a browser-based management console for executing SQL commands and administering database schemas.
• Web-Based SQL Consoles - Provides a browser-based GUI for executing SQL queries and managing database schemas.
• Window Functions - Implements SQL window functions for performing calculations across sets of rows related to the current row.
• Database Operational Settings - Provides global configuration settings for database engine behavior, including cache size, lock timeouts, and isolation levels.
• Off-Heap Memory Managers - Manages large datasets in off-heap memory to reduce Java garbage collection pause times.
• Database Function Registrations - Allows registering Java methods as stored procedures to execute complex logic within SQL statements.
• Spatial Geometry Types - Provides native geometry types for points, lines, and polygons with spatial reference identifiers.
• Data Encryption - Secures stored information using AES encryption to ensure data confidentiality.
• Database Page Encryption - Protects data at rest by encrypting database pages using AES-128 and SHA-256.
• SSL/TLS Connection Security - Encrypts network traffic between clients and the server using SSL/TLS sockets.
• Compatibility Mode Parsing - Adjusts the SQL parser to support legacy syntax or vendor-specific behaviors through compatibility modes.
• SQL Dialect Emulation Testing - Emulates various database dialects and syntax behaviors to test application compatibility across different RDBMS vendors.

Star history