solidDB

Features.

Request a demo

Persistent, in-memory relational database

  • SQL-92 entry-level support, with selected features of SQL-98 and SQL 2003
  • Full ACID support
  • Multiple table types: persistent, transient, temporary; disk-based and in-memory
  • Concurrency control with multiple transaction isolation levels
  • Snapshot-consistent checkpointing, transaction logging and automatic roll-forward recovery
  • Advanced, cost-based query optimizer
  • Multithreaded database engine that leverages multiprocessor and multi-core architectures
  • Tables, views, indices and sequences
  • Dynamically controlled integrity constraints including primary and foreign keys
  • Programmable through SQL and C-language–based stored procedures, triggers and user configurable events
  • Configurable security through user and role privileges
  • Full Unicode support for all character data, with external encoding separately selectable for each application
  • Tools for diagnostics and performance monitoring
  • Tools for bulk-loading and exporting data
  • Transaction log reader
  • Persistent audit trail functionality
  • Database compression

High availability and load balancing

  • HotStandby configuration with configurable replication and logging settings
  • Transparent connectivity that allows applications to maintain one logical connection to both primary and HotStandby instances and configurable load-balancing of read operations across primary and HotStandby solidDB instances
  • High-availability controller that monitors health and state of solidDB instances and performs failovers
  • Built-in, dynamically queryable and programmatically configurable high-availability state machine that simplifies integration with third-party high-availability managers

Flexible deployment models

  • Small footprint and hybrid in-memory disk solution
  • Ability to be deployed as a server process to enable access by applications over the network
  • Ability to be linked with Java or C/C++ applications that are deployed on the same server as solidDB to boost performance and to make solidDB invisible for embedded deployments
  • Shared memory access for co-located applications

Synchronous and asynchronous replication

  • Advanced replication: Built-in, bidirectional, publish- and subscribe–based asynchronous replication between solidDB instances with data consistency; supports replication of full databases or replication by tables or columns or rows
  • solidDB high availability (HotStandby): Push-based synchronous or asynchronous replication to propagate all data changes in the primary to the secondary