EDB for PostgreSQL Features
Database Features (7)
-
Storage
-
Availability
-
Stability
-
Scalability
-
Security
-
Data Manipulation
-
Query Language
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.
Security (4)
-
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.
Performance (5)
-
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.
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.



