GTM-MQNC2Z4
Skip to main content

Features and Benefits


Open Source Based Management System

FUJITSU Enterprise Postgres is strongly ANSI SQL:2011 compliant. Features include: Full ACID compliance, inheritance, database server clustering, Unicode, MVCC, point in time recovery, asynchronous replication, locale-aware, nested transactions, and is compatible with all major operating systems.

FUJITSU Enterprise Postgres extends those features with the following:

check Secure 256-bit transparent data encryption (PCI-DSS compliant)
check Data masking
check Vertical Clustered Index (VCI)*
check High-speed data load
check High-speed backup/recovery
check Dedicated audit log
check One-click backup/recovery
check DB mirroring controller
check WAL duplication
check Enhanced GUI for cluster management
check System usage statistics

*: VCI is a technology of Fujitsu Laboratories Ltd. that implements In-Memory Column Store

High performance is synonymous with enterprise solutions; FUJITSU Enterprise Postgres leverages as many technological advances as possible to deliver enterprise quality performance.

Easy and cost-effective migration

 

FUJITSU Enterprise Postgres has been designed to be fully compatible with the Open Source PostgreSQL database, and also offers enhanced compatibility when migrating from existing DBMS systems.

Previously, migration has proved problematic and in many cases been avoided due to the high workload and expenditure required. This problem is resolved by significantly reducing migration time so that budget restraints and business disruption are no longer a concern; the migration process has now become much more streamlined.

Database Migration Assessment is the first step for migration. The service provides a clear picture of what is required to migrate your database to FUJITSU Enterprise Postgres. You’ll also find out how much you can save by migrating to FUJITSU Enterprise Postgres.

The Database Migration Assessment consists of three simple steps:
1. The customer provides the database schema files and the application source code.
2. Fujitsu performs the migration analysis.
3. A database migration assessment report will be produced.

Enhanced system integration

 

The utilization of PostgreSQL technology enables integration with a wide range of software bundles, information utilization systems, development tools, and application runtime environments. Meaning that investing in additional software systems in addition to any migration costs is no longer a consideration. User disruption is also avoided due to the ability to retain software products that users are already familiar with.

High Reliability and Security

 

Smart recovery

 

If a database problem occurs or if data is accidentally deleted, recovery can be performed with a single click, so there is no need for technical user intervention.  

High-speed backup/recovery

 

FUJITSU Enterprise Postgres extends the backup/recovery utility by allowing user exits which can use any high-speed copy technology. The scope of both operations can be configured, as well as the storage location to be used.

 High-speed backup/recovery 

Redundancy and secure data encryption

 

Redundancy and secure data encryption (PCI-DSS compliant 256-bit encryption) are available for achieving high reliability and asset protection that is synchronous with your data management strategy.

FUJITSU Enterprise Postgres comes with Transparent Data Encryption out of the box; you are not required to purchase additional products to gain this functionality like some other proprietary DBMS products.  

 Secure data encryption 

Data masking and dedicated audit log

 

Data masking helps protect sensitive data by giving administrators greater control over who can access data, and how it is presented. Based on user-created rules, data from queries can be completely obscured or partially obscured.

Masking data in development environment:

 Masking data in production environment 

Masking data in production environment:

Masking data in development environment

To further help your organization prevent unauthorized access, FUJITSU Enterprise Postgres provides a dedicated audit log that can be used to counter security threats such as spoofing, unauthorized access to the database, application manipulation, and misuse of privileges. Administrators can configure the types of operation that are logged to the dedicated log file, which allows for more efficient and accurate operation monitoring.
  
 

High Availability Options

 

High availability (HA) is not just about keeping a server up and running. High Availability requirements can be different from organization to organization or even system to system. Some organizations put a high emphasis on data durability, some on system reliability, and others on performance stability.

FUJITSU Enterprise Postgres has the flexibility to be configured to meet all of the different HA requirements that an organization might have. An organization can utilize the many open source and third party products available for Open Source PostgreSQL with FUJITSU Enterprise Postgres, maintaining that flexibility to modify storage architecture without being “Locked-in”.

Mirroring Controller and data integrity

 

FUJITSU Enterprise Postgres provides features that automate actions when a heartbeat abnormality is detected, ensuring that uptime and continuity are maintained while preserving data integrity across the system.

An "arbitration server" is added to evaluate heartbeat abnormalities reported by either primary or standby server; if the failure is confirmed, the arbitration server fences the malfunctioning server and the reporting server becomes the primary. 

 Mirroring Controller 

Reduction of database design and implementation expenditure

 

FUJITSU Enterprise Postgres employs a minimal setup process based on optimized resource deployment. The setup process performs dynamic hardware resource detection during installation and the software is automatically tuned with the customer’s server configuration. Using this method the parameter and backup settings are all completed during the deployment of the system.

This simplified installation and setup process allows FUJITSU Enterprise Postgres to be implemented within a very efficient time frame.

Fujitsu Support


Fujitsu provides 24x7 support to FUJITSU Enterprise Postgres for 7 years after general availability of each version. Every technical query is examined directly by our expert support engineers, whose experience comes to the fore when they quickly identify and resolve incidents for you.

Extended support after the end of initial support is also available. Please contact your sales representative for details.

 

Performance

 

Vertical Clustered Index (VCI)


VCI is Fujitsu's implementation of In-Memory Column Store, which allows queries to run up to 46 times faster by storing table data in columnar format and using it for analytical queries. Because the columnar representation of table data is updated asynchronously, OLTP performance is not affected. 

Additionally, since columnar data is stored not only in memory, but also on disk, data does not need to be aggregated again after disk failure or system restart.

Vertical Clustered Index