InterSystems IRIS Features
Database Features (7)
-
Storage
-
Availability
-
Stability
-
Scalability
-
Security
-
Data Manipulation
-
Query Language
Data Management (11)
Data Integration
Consolidate data from various disparate sources in a single unified view
Data Discovery
Understand the state of data, applications, systems and services
Multi - Platform
Manage data across environments (on-premises cloud, hybrid, and multi-cloud)
Metadata
Provides metadata management and lineage capabilities
Data Model
Stores data as key-value pairs where key is a unique identifier.
Data Types
Supports multiple data types like lists, sets, hashes (similar to map), sorted sets etc.
Data Model
Stores and queries data as JSON-like documents.
Data Types
Supports multiple data types like lists, sets, hashes (similar to map), sorted sets etc.
Built - In Search
Allows users to index at ingest and query endlessly across data.
Event Triggers
Notifies specific events like document inserts, updates, replaces, deletes etc and responds in real-time.
Semantic Search
Analytics (1)
Data Analytics
Supports advanced analytics solutions for better business decision making
Security (17)
Compliance
Rules and regulations inherited from source systems or defined to secure sensitive data
Governance
Grant or restrict data access and control
Data Protection
Built - In Backup and Disaster Recovery
-
Data Encryption
Encrypts and transforms data at the database from a readable state into a ciphertext of unreadable characters.
-
User Access Control
Allows restricted user acess to modify depending on the access level.
Mobile Access
Access software remotely via mobile devices
-
Database Locking
Prevents other users and applications from accessing data while it is being updated to avoid data loss or update.
-
Access Control
Allows permissions to be granted or revoked in the database, schema or table levels.
-
Encryption
Built-in native encryption with enterprise key management.
-
Authentication
Provides multi-factor authentication with certificates.
Role-Based Authorization
Provides predefined system roles, privileges, and user-defined roles to users.
Authentication
Allows integration with external security mechanisms like Kerberos, LDAP authentication etc.
Encryption
Provides encryption capability for all the data at rest using encryption keys.
Role-Based Authorization
Provides predefined system roles, privileges, and user-defined roles to users.
Authentication
Allows integration with external security mechanisms like Kerberos, LDAP authentication etc.
Audit Logs
Provides an audit log to track access and operations performed on databases for regulatory compliance.
Encryption
Provides encryption capability for all the data at rest using encryption keys.
Maintenance (5)
-
Data Migration
Allows data movement from one database to another.
-
Backup and Recovery
Provides data backup and recovery functionality to protect and restore a database.
-
Multi-User Environment
Allows users to access and work on data concurrently, supporting several views of the data.
Automatic Backup
Data is backed up automatically to prevent data loss
Database Conversion
Transformation of data from one format to another
Management (8)
-
Data dictionary
Stores the database metadata, that is the definitions of data elements, types, relationships etc.
-
Data Replication
Creates a copy of the database to maintain consistency and integrity.
-
Query Language
Allows users to create, update and retrieve data in a database.
-
Data Modeling
Defines the logical design of the data before building the schemas.
-
Performance Analysis
Monitors and analyzes critical database attributes like query performance, user sessions, dead lock detail, system errors etc and visualize them on a custom dashboard.
Data Synchronization
Synchronizing data between two or more devices/systems and automatically updating changes to maintain consistency
Real-Time Data
Receive data and information in real time
Data Storage Management
Manage and store data in a database
Support (4)
-
Text Search
Provides support for international character sets and full text search.
-
Data Types
Supports multiple data types like primitive, structured, document etc.
-
Languages
Supports multiple procedural programming languages like PL/PGSQL, Perl, Python etc.
-
Operating Systems
Available on multiple operating systems like Linux, Windows, MacOS etc.
Performance (6)
-
Disaster Recovery
Provides data recovery functionality to protect and restore data in a database.
-
Data Concurrency
Allows multi-version concurrency control.
-
Workload Management
Handles workloads, from single machines to data warehouses or web services with many concurrent users.
-
Advanced Indexing
Allows users to quickly retrieve data through various types of indexing like B-tree, hash table etc.
-
Query Optimizer
Helps interpret SQL queries and determine the fastest method of execution.
Integrated Cache
Stores frequently-used data in system memory quickly.
Management (4)
-
Data Schema
Data is organized as a set of tables with columns and rows like a table structure.
-
Query Language
Allows users to create, update and retrieve data in a database.
-
ACID - Complaint
Adheres to ACID (atomicity, consistency, isolation, durability), a set of database transaction properties.
-
Data Replication
Provides log-based or/and trigger-based replication.
Availability (8)
Auto Sharding
Implements auto horizontal data partitioning that allows storing data on more than one node to scale out.
Auto Recovery
Restores a database to a correct (consistent) state in the event of a failure.
Data Replication
Copy data across multiple servers through master-slave, peer-to-peer replication architecture etc.
Auto Sharding
Implements auto horizontal data partitioning that allows storing data on more than one node to scale out.
Auto Recovery
Restores a database to a correct(consistent) state in the event of a failure.
Data Replication
Copy data across multiple servers through master-slave, peer-to-peer replication architecture etc.
Backup and Recovery
Create backups and provide methods to recover deleted/lost data
Real-Time Data
Receive data and information in real time
Support (5)
Operating Systems
Available on multiple operating systems like Linux, Windows, MacOS etc.
Multi-Model
Provides support to handle structured, semi-structured, and unstructured data with equal effect.
Operating Systems
Available on multiple operating systems like Linux, Windows, MacOS etc.
BI Connectors
Allows users to connect business intelligence tools to the database.
Data Connectors
Connect to big data sources
Performance (2)
Query Optimization
Helps interpret SQL queries and determine the fastest method of execution
Ad hoc Query
One-off queries made on an as-needed basis
Generative AI (2)
AI Text Generation
Allows users to generate text based on a text prompt.
AI Text Summarization
Condenses long documents or text into a brief summary.
Agentic AI - Data Fabric (5)
Autonomous Task Execution
Capability to perform complex tasks without constant human input
Multi-step Planning
Ability to break down and plan multi-step processes
Cross-system Integration
Works across multiple software systems or databases
Adaptive Learning
Improves performance based on feedback and experience
Decision Making
Makes informed choices based on available data and objectives
Additional Functionality (66)
Database Conversion
Transformation of data from one format to another
Monitoring
Observe and track the demand, usage, progress or quality of a system, product, or user
Activity Dashboard
Dashboard to view the status of ongoing processes, identify current incidents and track past activities
Data Extraction
Automatically retrieve and pull information from documents, websites, images, data sets, and other sources
Reporting/Analytics
View and track pertinent metrics to find patterns and gain insights from data
Automatic Backup
Data is backed up automatically to prevent data loss
Real-Time Monitoring
Active monitoring of systems, applications, or networks
Audit Management
Plan, schedule, and execute organization's accounts and assets to ensure compliance with policies and laws
Data Visualization
Graphical representation of data
Ad hoc Reporting
Generate one-off reports that meet information requirements
Compliance Management
Track and manage adherence to policies for any service, product, process, or supplier
Indexing
Compile and organize data into specific metrics
Search/Filter
Search and filter data across systems to locate required information by entering keywords or certain criteria
Alerts/Notifications
Alerts or notifications of various types such as pop-up messages, sounds, banners, or badges
Data Verification
Process of checking different types of data for accuracy to avoid errors or inconsistencies
Performance Testing
Allows developers to check if their applications/web browsers are running as expected.
Data Capture and Transfer
Import, collect, and capture data from multiple sources
Security Auditing
Systematic evaluation of the security of a company's overall security system and situation
Access Controls/Permissions
Define levels of authorization for access to specific files or systems
Role-Based Permissions
Set & manage permission levels based on user roles and restrict access to only authorized individuals
Data Mapping
Track the management and flow of data throughout the organization
Data Retrieval
Search and find data in a structured format
AI Copilot
A virtual assistant that uses AI to pursue goals and complete tasks on behalf of users
Third-Party Integrations
Set up connections to third-party platforms to improve business processes
Generative AI
Use AI to generate content in the form of text, images, videos, etc.
Configuration Management
Identify component attributes like servers, hardware, software, and manage relationships across all services
Audit Trail
A record of all activities within the system, including user access, changes made, etc.
For NoSQL Databases
Specific for use in NoSQL Databases
Data Import/Export
Import and export data to and from software applications
Data Migration
Move from one database to another, or upgrade the version of database software being used
Data Synchronization
Synchronizing data between two or more devices/systems and automatically updating changes to maintain consistency
API
Application programming interface that allows for integration with other systems/databases
Serverless Accessibility
Compatible with serverless backends
Multiple Data Sources
Allows users to manage data from a number of sources
Workflow Management
Create, design and manage workflows for repetitive tasks
Third-Party Integrations
Set up connections to third-party platforms to improve business processes
Data Extraction
Automatically retrieve and pull information from documents, websites, images, data sets, and other sources
Relational Database Management
Database management based on relationships between data
SSL Security
Security protocol that ensures secure, encrypted communication over the internet, safeguarding sensitive data from unauthorized access
API
Application programming interface that allows for integration with other systems/databases
Data Connectors
Connect to big data sources
Search/Filter
Search and filter data across systems to locate required information by entering keywords or certain criteria
Reporting & Statistics
Collection, analysis, and representation of numerical data and generation of reports to understand various patterns
Customizable Templates
Pre-designed layouts that can be customized to match preferences and requirements
AI Copilot
A virtual assistant that uses AI to pursue goals and complete tasks on behalf of users
Full Text Search
Search for specific words or phrases within a document or database
Data Virtualization
Retrieve and use data without requiring technical details about the data
Data Import/Export
Import and export data to and from software applications
Generative AI
Use AI to generate content in the form of text, images, videos, etc.
Drag & Drop
Assemble applications and processes by dragging over and arranging pre-built components
Customizable Fields
Customize data fields to support various needs and use cases
Authentication
Verify the identity of users/devices to enable secure access
Data Visualization
Graphical representation of data
Secure Data Storage
Securely stores data to prevent data loss or breaches
Activity Dashboard
Dashboard to view the status of ongoing processes, identify current incidents and track past activities
Data Mapping
Track the management and flow of data throughout the organization
Multiple Programming Languages Supported
Run stored procedures and queries in multiple programming languages, such as JSON, Java, Python, Ruby, Perl, and SQL
Data Capture and Transfer
Import, collect, and capture data from multiple sources
User Management
Manage user accounts, profiles, roles, permissions, and other details across applications, devices or networks
NOSQL Database Management
Database management based on customization, fluidity, and document relations
Access Controls/Permissions
Define levels of authorization for access to specific files or systems
Calendar Management
Track and manage schedules and meetings via an integrated calendar
Real-Time Monitoring
Active monitoring of systems, applications, or networks
Document Storage
Store and organize documents in a centralized system
Audit Management
Plan, schedule, and execute organization's accounts and assets to ensure compliance with policies and laws
Charting
Manage patient documentation describing all clinical interactions, diagnoses, procedures, medications, etc.
Top-Rated Alternatives
Technology Glossary Features
View definitions of the features and discover new technology terms.
Data manipulation is the process of organizing, modifying, and transforming data to improve accuracy, usability, and analysis across systems and workflows.
Data modeling is the process of creating visual representations of information systems to better communicate the connections between data points and structures. Learn more about data modeling in this G2 guide.



