Postgres Soloxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx.pdf

1

1. © FUJITSU 2023
Fujitsu-Confidential-In-Trust
© FUJITSU 2023
Fujitsu-Confidential-In-Trust
Fujitsu Enterprise
Postgres

2. © FUJITSU 2023
Fujitsu-Confidential-In-Trust
Fujitsu at a glance
Headquarters
Tokyo, Japan
Established
1935
CEO
Takahito Tokita
Principal business areas
TechnologySolutions
UbiquitousSolutions
DeviceSolutions
Employees
124,200 worldwide
(As of March 2022)
R&D expenses
Almost 1 billion USD
(Approx. 2.9% of revenue)
Stock exchange listing
Tokyo (Code 6702)
Nagoya
© Fujitsu 2022© Fujitsu 2022

3. © FUJITSU 2023
Fujitsu-Confidential-In-Trust
Our products and services
Technology solutions
Solution/Services
⚫Cloud ServicesIaaS, PaaS, SaaS, etc.
⚫Network Services BusinessNetworks, etc.
⚫System Support Services
ICT System and Network Maintenance and Monitoring Services, etc.
⚫Security Solutions
⚫Software Middleware
⚫Systems Integration
System Implementation, Business Application Services, etc.
⚫Consulting
⚫Outsourcing Services
Data Center Services, ICT Managed Services,
Application Services, Business Process Outsourcing, etc.
Systems platform
⚫System products Mainframe, UNIX server, Mission-critical IA Server, PC server
⚫Storage
⚫Front End Technology ATM POS system, etc.
⚫Software OS
⚫Automotive Control Units and In-vehicle Information System
System products Network products
⚫Network Management Systems
⚫Optical Transmission
⚫Mobile Base Stations
Ubiquitous product solutions
⚫PCs ⚫LSI devices
Device solutions
⚫Electronic components
Semiconductor packages, batteries and others
© Fujitsu 2022© Fujitsu 2022
⚫Image Scanner ⚫Interactive Panel

4. © FUJITSU 2023
Fujitsu-Confidential-In-Trust
History of Fujitsu
Fujitsu was founded in 1935 as a
communication devices manufacturer.
Since then, Fujitsu has played a major role to
develop the Japanese communication
infrastructure.
Telecommunication equipment
1935
Computers
The appearance of computers accelerated progress in science and
technology, and industrial productivity increased dramatically after the
1950s.1950s to 1990s
After the 2010s, the ICT has been dramatically
changing and all manner of things became
connected to The Internet.
Fujitsu aims to deliver a safer, richer, and
more sustainable society
- a Human Centric Intelligent Society.
In 1954, we developed our first computer.
Fujitsu contributed to developing the
advanced systems in various fields, working
closely with customers.
2010s
Services
After the 1990s, the internet brought
changes to lifestyles and business models.
Fujitsu contributed to a ‘network centric’
era by providing various products and
services.
87 years of innovation
© Fujitsu 2022

5. © FUJITSU 2023
Fujitsu-Confidential-In-Trust
INFRASTRUCTURE FOR
THE DATA-DRIVEN WORLD
Fujitsu Servers
PRIMERGY
•German technology + Japan quality
•Leading efficiency of performance
and power consumption
•Complete portfolio
•Lowest failure rate in the market
Fujitsu Servers
PRIMEQUEST
•Highest RAS for x86 servers
•Mainframe availability
features
•Lowest TCO for such
availability features
•Flexible and future-proof
•Seamless data management
•Continuous availability
without compromise
•Maximize storage efficiency
Fujitsu Storage
ETERNUS
•Open-source based
•Enterprise features
•Agile
•Stable performance
•Rapid deployment and
support
•Excellent value
Fujitsu Enterprise
Postgres
© Fujitsu 2022

6. © FUJITSU 2023
Fujitsu-Confidential-In-Trust
DB Ranking
6

7. © FUJITSU 2023
Fujitsu-Confidential-In-Trust
Fujitsu and PostgreSQL
7
SupportingtheOSSPostgreSQLCommunitysince2004
PlatinumSponsorofPGConf.ASIA,pgDayAsia,andPGCon
Provides adviceforenterprisesusingPostgreSQL
Involvedindevelopmentaswellasadvocacy
Contributedseveralenterprisefeatures toPostgreSQL
+

8. © FUJITSU 2023
Fujitsu-Confidential-In-Trust
FUJITSU Enterprise Postgres
8
100%compatiblewithPostgreSQL
EnhancedcompatibilitywithproprietaryDBs
Security-256-bitencryption,DataMasking,
DedicatedAuditLogs, PCI-DSScompliant
Performance -High-performance queries (VCI), Global Meta Cache,
High-SpeedBackup/Recovery,High-SpeedDataLoad
Reliability-MirroringController,ConnectionManager,
WALduplication,high-speedrecovery
Easeofuse-easysetup,one-clickbackup
andrecovery,managementtoolsandenhancedGUI
Fujitsu'sproprietaryDBbasedonPostgreSQL
Opensource
value
+
Enterprise
quality

9. © FUJITSU 2023
Fujitsu-Confidential-In-Trust
Supported Operating System
9

10. © FUJITSU 2023
Fujitsu-Confidential-In-Trust
High Availability
10

11. © FUJITSU 2023
Fujitsu-Confidential-In-Trust
High Availability - Architecture
11
◼Mirroring Controller and Connection Manager

12. © FUJITSU 2023
Fujitsu-Confidential-In-Trust
High Availability - Architecture
12
◼pgpool

13. © FUJITSU 2023
Fujitsu-Confidential-In-Trust
Performance
13

14. © FUJITSU 2023
Fujitsu-Confidential-In-Trust
Vertical Clustered Index (VCI)
14
▪Integrated feature that greatly improves the
performance of queries performing aggregate
operations such as SUM, AVG, MIN, MAX on very
large tables.
▪VCI stores row-oriented data in columnar format in
memory, enabling quick aggregation to be performed
againts the data

15. © FUJITSU 2023
Fujitsu-Confidential-In-Trust
Global Meta Cache
15
Effective use of system resources by sharing definition information
▪System catalog information
*
cache deployed for each connection process is
deployed on shared memory to reduce overall system memory usage
* System catalogs store schema metadata, such as table and column information
PostgreSQL FUJITSU EnterprisePostgres
◼System catalog information (meta cache) required for each
process deployed in memory
◼Memory usage increases as the number of connections, tables
accessed, and columns increase
◼Reduce memory usage by deploying meta cache in GMC area on shared
memory and deploying only management information to each process
◼Less than 5% performance impact due to more efficient re-access

16. © FUJITSU 2023
Fujitsu-Confidential-In-Trust
Security
17

17. © FUJITSU 2023
Fujitsu-Confidential-In-Trust
Security – Transparent Data Encryption
19
Security technology
▪Storage 256-bit Transparent Data Encryption (TDE)
▪Storage data security utilizing the latest security standards
▪Changing encryption key without re-encrypting data
▪No need to modify existing business applications for migration
▪Payment Card Industry Data Security Standard (PCI DSS)
▪Confidential information can be made unrecognizable
▪Encryption key and data are managed separately
▪Encryption key can be replaced regularly

18. © FUJITSU 2023
Fujitsu-Confidential-In-Trust
Security – Data Masking
20
Policy-based Data Masking on returned queries
▪Masking the returned data for queries from applications based on policy makes it available for reference without
exposing the original data
▪Suitable for test or development environment while reducing risk of data information leakage
Data Masking in a production environment Data Masking in a test environment

19. © FUJITSU 2023
Fujitsu-Confidential-In-Trust
Security – Dedicated Audit Log
21
FUJITSU Enterprise Postgres Dedicated Audit Logs 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

20. © FUJITSU 2023
Fujitsu-Confidential-In-Trust
Security – Key Management for TDE
22
▪KMIP (Key Management Interoperability Protocol) is supported in FEP TDE
•Using KMIP allow to store master encryption key in Key Management Server,
such as IBM Security Guardian Key Lifecycle Manager, Oracle Key Vault or
increasingly in the Cloud
•TDE integrates with a growing number of HSMs to store the Master Key
•An Increasing # of Cloud-based Key Management Services are supported
▪This Facilitates
•Separation of Duties in the role of key management from DBA
•Centralised key management
•Additional security strength by integration with cloud services

21. © FUJITSU 2023
Fujitsu-Confidential-In-Trust
Reliability
23

22. © FUJITSU 2023
Fujitsu-Confidential-In-Trust
Reliability – Smart Setup (1)
24
Simplified installation and database management
Installation
Install (Execute
installation)
Create a
new instance
Launch
installer
Management
Check
status
Modify
settings
Monitor
operation
Ready for use
▪Easy 3-step setup and configuration
▪Dynamic hardware detection
▪Automatic tuning to the server configuration
▪Easy Operation with non-technical administration tool for
performing simple daily high level tasks
▪Start & Stop
▪Backup & Restore
▪Monitor disk usage
▪Manage instances

23. © FUJITSU 2023
Fujitsu-Confidential-In-Trust
Reliability – Easy Backup/Recovery
25
Easy Backup/Recovery
▪One-click recovery to the most recent point in time
▪Media recovery is executed using GUI or server commands
▪Recovers data by accumulating database transaction history as an update log
One-click recovery

24. © FUJITSU 2023
Fujitsu-Confidential-In-Trust
Reliability – Instance Configuration / Management
26
Instance Configuration/Management
WebAdmin (Web Client)
Sample Screenshot
Create an
instance
Select the instance to
be monitored
Configure the
instance

25. © FUJITSU 2023
Fujitsu-Confidential-In-Trust
Reliability – Easy Cluster Setup and Management
27
Simplified cluster setup and management
WebAdmin (Web Client)
Sample Screenshot
Select the instance
Setup Mirroring
Controller

26. © FUJITSU 2023
Fujitsu-Confidential-In-Trust
postgresql.fastware.com
28

27. © FUJITSU 2023
Fujitsu-Confidential-In-Trust
FEP Trial Version
29

28. Thank you
© FUJITSU 2021
Fujitsu-Confidential-In-Trust

29. © FUJITSU 2023
Fujitsu-Confidential-In-Trust
Help Us To Improve
31

30. © FUJITSU 2023
Fujitsu-Confidential-In-Trust
Lab Demo FEP
32