EDB Postgres Advanced Server Features
Database Features (7)
-
Storage
-
Availability
-
Stability
-
Scalability
-
Security
-
Data Manipulation
-
Query Language
Configuration (5)
-
Application Performance
Functions when integrated with multiple forms of external applications.
-
Orchestration
Allows admisistrators to manage and organize storage, networks, and datacenters.
-
Database Monitoring
Monitors performance and statistics related to memory, caches and connections.
-
Anomaly Detection
Alerts users when unauthorized parties or malware is detected allowing administrators to remedy the issue.
-
Network Security
Secures data at rest and in transit from unauthorized access.
Database Administration (3)
-
Provisioning
Allows administrators to organize components of the database to maintain instance efficiency.
-
Governance
Allows the creating and relinquishing of database access credentials.
-
Auditing
Documents access and alterations of the database for analytics and reporting.
Availability (4)
-
Scalability
Expands functionality while maintaining balanced loads. Serves growing demand without reducing functionality.
-
Backup
The abillity to restore files to its original loacation or alternative sources on-demand.
-
Archiving
Stores historical records of information for reverting or reference.
-
Indexing
Helps users navigate databases by labeling and organizing datasets.
Functionality (19)
-
Data Backup
Copies and backs up data from a database.
-
Backup Automation
Controls and schedule automated backups, as well as backup extensiveness (incremental, differential, or full).
-
Integration
Integrates database backups with other IT infrastructure management solutions.
-
Diverse Database Handling
Allows users to back up databases of different structures and data types.
Cloud Backup
Process of backing up of files and applications to cloud-based remote servers for protection of data
Continuous Backup
Backup of computer data automatically saving a copy of every change made to that data
-
Monitoring
Monitors database functionality to verify baselines are maintained or exceeded.
-
Alerting
Sends alerts via email, text, phone, and more when an incident or issue occcurs.
-
Logging
Captures logs for all database functions to garner greater information around issues or failures.
-
Response Time
Monitors database query time for unusual execution times
-
Reporting
Manually and/or automatically generates reports covering database performance
-
Data Visualization
Follows database monitoring live information through graphical dashboards
Performance Monitoring
Monitoring and measurement of relevant metrics to assess the performance of IT resources
Real-Time Monitoring
Active monitoring of systems, applications, or networks
Server Monitoring
Continuously scan servers on a designated network to monitor health and search for any irregularities or failures
Real-Time Reporting
Active reporting of data and metrics
Uptime Reporting
Track the availability time for a designated network or website over a given period of time
Transaction Monitoring
Monitor or audit historical and current transactions to analyze customer account activities
Real-Time Data
Receive data and information in real time
Admin (9)
-
Backup Management
Manages database backup access, frequency, alloted storage, and more.
Resource Management
Process of planning, scheduling and executing the optimal and effective use of human capital across projects
File Management
Create, save, and store files
Policy Management
Create, manage, and track policies and procedures within an organization
Compliance Management
Track and manage adherence to policies for any service, product, process, or supplier
Incremental Backup
Copy only the new data that has been changed or created since the previous backup
Remote Monitoring & Management
Remotely monitor and manage client networks, endpoints, systems, and devices via locally installed applications
Data Storage Management
Manage and store data in a database
Audit Management
Plan, schedule, and execute organization's accounts and assets to ensure compliance with policies and laws
Security (7)
-
Data Masking
Data masking provides an additional layer of access control that can be applied to tables and views.
-
Authentication And Single Sign-On
Verifies identity of database users.
-
Data Anonymization
Allows users to gain statistically valid insights from their data while protecting the privacy of individuals.
-
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.
Data Management (2)
-
Data Replication
Helps in improving the availability of data.
-
Advanced Data Analytics
Uses machine learning algorithms to gain actionable insights.
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 (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.
Agentic AI - Database Backup (6)
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
Proactive Assistance
Anticipates needs and offers suggestions without prompting
Decision Making
Makes informed choices based on available data and objectives
Agentic AI - Database Monitoring (9)
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
Natural Language Interaction
Engages in human-like conversation for task delegation
Proactive Assistance
Anticipates needs and offers suggestions without prompting
Decision Making
Makes informed choices based on available data and objectives
Third-Party Integrations
Set up connections to third-party platforms to improve business processes
Capacity Planning
Determine and plan production capacity based on changing demands
Additional Functionality (81)
Resource Management
Process of planning, scheduling and executing the optimal and effective use of human capital across projects
Anomaly Detection
Automatically identify unusual behavior
Visual Analytics
Interact with data visualization elements, such as charts and graphs, to drill down into data
Remote Monitoring & Management
Remotely monitor and manage client networks, endpoints, systems, and devices via locally installed applications
Secure Data Storage
Securely stores data to prevent data loss or breaches
Dashboard
Assembly of graphs and charts for visualizing and tracking statistics/metrics
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
API
Application programming interface that allows for integration with other systems/databases
User Management
Manage user accounts, profiles, roles, permissions, and other details across applications, devices or networks
Capacity Management
Monitor service demand and performance to plan for adequate resources that meet business needs
Diagnostic Tools
Access client's system information, including hardware and software configuration, to perform diagnostics
Dependency Tracking
Track and manage task relationships and dependencies
Troubleshooting
Take actions to troubleshoot issues for networks, devices, etc.
Reporting & Statistics
Collection, analysis, and representation of numerical data and generation of reports to understand various patterns
Reporting/Analytics
View and track pertinent metrics to find patterns and gain insights from data
Predictive Analytics
Predict future data based on historical data sets
Audit Management
Plan, schedule, and execute organization's accounts and assets to ensure compliance with policies and laws
Real-Time Notifications
Notifications that are delivered to users as soon as an event occurs
Application Management
Track, manage and store the applications of potential future members, customers or candidates
Data Storage Management
Manage and store data in a database
Application-Level Analysis
Track, monitor and analyse information pertaining to specific applications
Multitenancy
Operate multiple applications in a shared environment
Query Analysis
View and analyze individual requests received by a database
Performance Management
Organize and manage the accomplishments and development of employees or performance of applications or systems
Access Controls/Permissions
Define levels of authorization for access to specific files or systems
Compliance Management
Track and manage adherence to policies for any service, product, process, or supplier
Historical Trend Analysis
Review data from past periods to reveal recurring tendencies
Alerts/Notifications
Alerts or notifications of various types such as pop-up messages, sounds, banners, or badges
Summary Reports
AI Copilot
A virtual assistant that uses AI to pursue goals and complete tasks on behalf of users
Event Logs
A chronological record of actions or occurrences within a network, software, or process
Dashboard Creation
Creation and customization of dashboards
Automated Discovery
Automatically identify systems to be monitored
Prioritization
Arrange tasks based on the level of priority or urgency
Issue Tracking
Record and follow the progress of every issue
Activity Dashboard
Dashboard to view the status of ongoing processes, identify current incidents and track past activities
Performance Metrics
A set of indicators that tracks the performance of networks, applications, systems, teams, etc.
Resource Optimization
Reallocate existing resources to better utilize capacity
Real-Time Analytics
Analyze and gain insights into data in real-time
Status Tracking
Track the status over time for a request, process, asset, or transaction
Access Controls/Permissions
Define levels of authorization for access to specific files or systems
Disaster Recovery
Plan and implement business continuity measures in case of unforeseen events
HIPAA Compliant
Compliant with HIPAA, which sets standards for sensitive patient data protection
Data Recovery
Ability to restore deleted, hidden, or lost data from an email server/system
AI Copilot
A virtual assistant that uses AI to pursue goals and complete tasks on behalf of users
Two-Factor Authentication
Extra layer of security that requires not only a password and username but also something specific to that user
Data Visualization
Graphical representation of data
Remote Access/Control
Access work applications remotely, for when working away from the office and/or traveling
Scheduled/Automated Reports
Set a time to generate routine reports automatically
Alerts/Notifications
Alerts or notifications of various types such as pop-up messages, sounds, banners, or badges
Backup Scheduling
Schedule automatic backups by selecting the frequency of data backup jobs
Archiving & Retention
Moving and separately storing data that is not actively used or continuous storage of data for compliance purposes
SSL Security
Security protocol that ensures secure, encrypted communication over the internet, safeguarding sensitive data from unauthorized access
Version Control
Track revisions and updates made to files and navigate between different versions
Duplicate Detection
Compare new data with existing records to detect duplicate entries
Data Migration
Move from one database to another, or upgrade the version of database software being used
Data Replication
Process of copying and storing data in more than one site or node
Local Server Options
Document Storage
Store and organize documents in a centralized system
Compression
Reduction in the number of bits needed to represent data
Status Tracking
Track the status over time for a request, process, asset, or transaction
Secure Data Storage
Securely stores data to prevent data loss or breaches
Backup Log
Records the events that occur during a backup process
Role-Based Permissions
Set & manage permission levels based on user roles and restrict access to only authorized individuals
Generative AI
Use AI to generate content in the form of text, images, videos, etc.
Reporting & Statistics
Collection, analysis, and representation of numerical data and generation of reports to understand various patterns
API
Application programming interface that allows for integration with other systems/databases
Alerts/Escalation
System alerts about the need to escalate an issue or request
Backup and Recovery
Create backups and provide methods to recover deleted/lost data
Remote Server Options
Activity Dashboard
Dashboard to view the status of ongoing processes, identify current incidents and track past activities
Email Alerts
Receive and/or send email notifications for urgent updates, requests, or other information
Web Access/Restoration
Web Access/Restoration
Activity Tracking
Track and document all activities across devices, networks, and other systems
Encryption
Convert data into a code for security
Monitoring
Observe and track the demand, usage, progress or quality of a system, product, or user
Automated Scheduling
Automatically create schedules based on business needs or employee availability and qualifications
Self Service Portal
Online portal through which end users can access the system, manage tasks, or obtain information
Data Synchronization
Synchronizing data between two or more devices/systems and automatically updating changes to maintain consistency
Task Scheduling
Track and manage the scheduling of tasks


