Here are 9 key features of FUJITSU Enterprise Postgres, the open source based database system designed to deliver the Quality of Service (QoS) that enterprises demand of their databases in the digital world, while supporting the openness and extensibility expected of open source platforms, all at a lower cost than traditional enterprise databases.
It is an enhanced distribution of PostgreSQL, the open source database platform, with improvements to support enterprise-level workloads and provide improved Deployment and Management, Availability, Performance, Data Governance and Security, above and beyond the standard community edition of PostgreSQL.
FUJITSU Enterprise Postgres provides dedicated audit logs that are compliant with all PCI DSS (Payment Card Industry Data Security Standard) requirements. Audit logs can be used to counter security threats such as spoofing, unauthorized access to the database, application manipulation, and misuse of privileges.
PostgreSQL outputs audit log records to the server log only, which makes operation and analysis complex (since some logs, such as SQL runtime logs, do not output the schema name) and time-consuming (because output criteria cannot be specified, and since log volumes can be large, performance will deteriorate). On the other hand, FUJITSU Enterprise Postgres audit logs allow a flexible and efficient way to accurately monitor logs.
The backup/recovery utility now enables backup/recovery of clusters and selected tablespaces using any copy method specified by the user, to replace the conventional, file-level copy process and allow TB-scale operations.
The pgx_dmpall command and the pgx_rcvall command can now perform backup/recovery using user exits, which can redirect the process to use high-speed copy technology.
FUJITSU Enterprise Postgres offers the ability to load large volumes of data using as many parallel processes as possible, given the number of cores and CPU availability. Data load features of other database systems can only use a fixed number of parallel process, regardless of CPU availability.
In an era of mission-critical systems that are able to take advantage of multi-core technology, this is not the optimal solution. FUJITSU Enterprise Postgres high-speed data load sends data from the input file to several parallel workers, each of which will simultaneously perform data conversion, table creation, and index creation.
Data professionals are under pressure to adopt NoSQL-only solutions to cater for Big Data. No need. FUJITSU Enterprise Postgres lets you have the best of both worlds by supporting a wide range of unstructured and semi-structured data to power even all types of applications across your business.
Data integrity and operational continuity are paramount for any organisation. FUJITSU Enterprise Postgres mitigates the risk through data redundancy across physical hardware and reliably coordinates this distributed data during automated failover and recovery.
Organisations are finding it increasingly difficult to respond to business analytics requirements while maintaining operational performance. This issue exists because most data architecture is built with online transaction processing (OTP) in mind, which is not suitable for efficient online analytical processing (OAP).
The result is enhanced speed in one type of processing at the expense of the other. FUJITSU Enterprise Postgres has solved this dilemma with its implementation of In-Memory Columnar Index.
When access to data is business-critical, put our highly skilled software support engineers on your side with a subscription to the Fujitsu PostgreSQL 24/7 Support Plan.
With the advent of open source technology, there are now viable, high-performance alternatives to proprietary databases. The decision to change platforms presents an exciting opportunity to reduce the total cost of ownership (TCO).
Subscription-based pricing models offer a flat rate over the life of an Agreement, with minimal installation costs. Compare that with a proprietary model and the savings are astonishing, freeing up your budget for other resources.