InterSystems Caché Features

Provides support for international character sets and full text search.

Supports multiple data types like primitive, structured, document etc.

Supports multiple procedural programming languages like PL/PGSQL, Perl, Python etc.

Available on multiple operating systems like Linux, Windows, MacOS etc.

Prevents other users and applications from accessing data while it is being updated to avoid data loss or update.

Allows permissions to be granted or revoked in the database, schema or table levels.

Built-in native encryption with enterprise key management.

Provides multi-factor authentication with certificates.

Provides predefined system roles, privileges, and user-defined roles to users.

Allows integration with external security mechanisms like Kerberos, LDAP authentication etc.

Provides encryption capability for all the data at rest using encryption keys.

Provides predefined system roles, privileges, and user-defined roles to users.

Allows integration with external security mechanisms like Kerberos, LDAP authentication etc.

Provides an audit log to track access and operations performed on databases for regulatory compliance.

Provides encryption capability for all the data at rest using encryption keys.

Provides data recovery functionality to protect and restore data in a database.

Allows multi-version concurrency control.

Handles workloads, from single machines to data warehouses or web services with many concurrent users.

Allows users to quickly retrieve data through various types of indexing like B-tree, hash table etc.

Helps interpret SQL queries and determine the fastest method of execution.

Stores frequently-used data in system memory quickly.

Data is organized as a set of tables with columns and rows like a table structure.

Allows users to create, update and retrieve data in a database.

Adheres to ACID (atomicity, consistency, isolation, durability), a set of database transaction properties.

Provides log-based or/and trigger-based replication.

Stores data as key-value pairs where key is a unique identifier.

Supports multiple data types like lists, sets, hashes (similar to map), sorted sets etc.

Stores and queries data as JSON-like documents.

Supports multiple data types like lists, sets, hashes (similar to map), sorted sets etc.

Allows users to index at ingest and query endlessly across data.

Notifies specific events like document inserts, updates, replaces, deletes etc and responds in real-time.

Implements auto horizontal data partitioning that allows storing data on more than one node to scale out.

Restores a database to a correct (consistent) state in the event of a failure.

Copy data across multiple servers through master-slave, peer-to-peer replication architecture etc.

Implements auto horizontal data partitioning that allows storing data on more than one node to scale out.

Restores a database to a correct(consistent) state in the event of a failure.

Copy data across multiple servers through master-slave, peer-to-peer replication architecture etc.

Available on multiple operating systems like Linux, Windows, MacOS etc.

Provides support to handle structured, semi-structured, and unstructured data with equal effect.

Available on multiple operating systems like Linux, Windows, MacOS etc.

Allows users to connect business intelligence tools to the database.

Helps interpret SQL queries and determine the fastest method of execution