Comparison of database operations-related capabilities

Consider these operations-related capabilities when analyzing the feasibility of your migration.

High availability

Mission-critical workloads must remain operational at all times and have little tolerance for even planned downtime for maintenance. This demand for high availability requires solutions that provide:

• High-speed replication and redundancy to eliminate single points of failure in the system
• Failure detection and automated failover to ensure systems continue to function in case of a breakdown in the system
• Data and system recovery to assist DBAs following failure events

Performance and scalability

You can optimize database operations through various means to deliver higher performance. Connection pooling, for example, refers to a common way of maintaining open connections to the database for applications that repeatedly make requests as opposed to having to create new connections each time. Data replication can increase performance by making information simultaneously available to multiple end-user applications. You can achieve these performance enhancements through database enhancements and various external complementary solutions.

Security

Database security consists of many dimensions, including secure connections, password management, access control, physical data encryption, auditing, and more. Among open source and commercial databases, EDB Postgres Advanced Server is one of the most secure and contains extensive support for PCI DSS.

Data encryption options

The following data encryption options offer different levels and granularity of protection depending on the needs of the application.

Using pgcrypto:

• Postgres contrib module.
• Applied to selected table columns.
• Can't search or index encrypted fields.
• Encryption must be applied at table creation, so advance planning is required.
• The application must handle the encryption/decryption so that exchanges with the database remain encrypted.
• DBAs can't see data in clear.

Using DBMS_CRYPTO:

• Oracle-compatible wrapper around pgcrypto with same features and limitations.
• Supports multiple cipher algorithms.
• DES, 3DES, AES, and AES128.
• MD4, MD5, and SHA-1 hash functions.
• Generate cryptographically strong random values.

Using EDB Transparent Data Encryption:

• Encrypts all Postgres user data stored on disk.
• Prevents unauthorized viewing of data in operating system files on the database server and on backup storage
• No application changes or updated client drivers.
• Flexible Key Management architecture.

Using disk partition encryption:

• File system disk partition is encrypted/decrypted by the OS.
• Protects all files in the database partition, including temporary files.
• Data is decrypted when read from the filesystem. This allows DBAs to see the data so they have roles and permissions locked down.
• Transparent to application developers, e.g., Red Hat Enterprise Linux supports Linux Unified Key Setupon-disk-format (LUKS).

Using file system level:

• Individual files or directories are encrypted by the file system.
• Requires file-based key management.
• Individual management of encrypted files, e.g., incremental backups even in encrypted form.
• Access control can be enforced by use of public-key cryptography.
• Cryptographic keys are held in memory only while the file that is decrypted by them is held open.
• Transparent to application developers, e.g., eCryptfs for Linux.

Using Thales CipherTrust Transparent Encryption:

• Secures data at-rest for EPAS databases and backups.
• File system-level encryption backed by centralized key management.
• Privileged user access controls.
• Detailed data access audit logging.

Integration

Today’s data centers commonly consist of one or more relational and many nonrelational database solutions deployed to handle specific workloads based on data type and application. Relational databases use a range of mechanisms for connecting to other like and dissimilar database solutions across the infrastructure to connect data from multiple sources and create a cohesive data fabric. In some cases, the database is engineered with specific capabilities that enhance data integration. Database vendors also develop adaptors that enable their database to connect with other vendor solutions.

*It's possible, and often useful, to have some transactions commit synchronously and others asynchronously depending on the session connected to the database.

Management

Large enterprises have large database deployments often into the hundreds and beyond. DBAs require tools for maintaining these data farms easily and quickly and for performing operations in bulk across multiple databases. Customizable graphical consoles with complete features for monitoring, tuning, managing, and alerting are critical to DBAs performing the basics of their responsibilities. Management encompasses both the capabilities in the database that support the DBA in their operational tasks and tools external to the database.

EDB Postgres Advanced Server-compatible catalog views

EDB Postgres Advanced Server provides over 90 Oracle catalog views that provide information about database objects in a manner compatible with the Oracle data dictionary views.

In addition to the views listed in the table, the following views are also provided:

• DBMS_AQ_STAT_DATABASES
• DBMS_AQ_STAT_MESSAGES
• DBMS_AQ_STAT_QUEUES
• DBMS_AQ_STAT_WAITERS
• PRODUCT_COMPONENT_VERSION
• V$VERSION

Deployment options

With the advance of public and private clouds and virtualization, the range of database deployment options has increased for end users. The following is a snapshot of the available deployment options for Oracle Enterprise and EDB Postgres Advanced Server.

• On this page
• High availability
• Performance and scalability
• Security
• Integration
• Management
• Deployment options