PostgreSQL

The World’s Most Advanced Open Source Relational Database

Clear Data Science Limited (CDS) is a data science company familiar with different relational databases for data warehousing, NoSQL databases on IoT and Hadoop on unstructured data. With our expertise in data management and data architecture, we are confidence to build all types of data platform with our clients.

About PostgreSQL

PostgreSQL is an open-source relational database management system emphasizing extensibility and standards compliance. It can handle workloads ranging from single-machine applications to Web services or data warehousing with many concurrent users. This database engine can be compared to any enterprise class database engine without significant license investment.

Enterprise-Class Features

  • Multi-version concurrency control (MVCC)
  •  Tablespaces
  •  Point-in-time recovery
  •  Sophisticated locking mechanism
  •  Table inheritance
  •  User-defined types
  •  Foreign key referential integrity
  •  Views, rules, subquery
  •  Nested Transactions (savepoints)
  •  Asynchronous replication
  •  Clustering, Load-balancing
  •  High Availability (HA)
  •  Multi-platform support (AIX, HP/UX, Solaris, FreeBSD, Mac OS-X, Linux (all distros), Windows, etc.)

Professional Service

A number of database experts are available in handling different RDBMS including EnterpriseDB PostgreSQL, MariaDB, MySQL, IBM DB2, IBM Informix, Microsoft SQL Server, Oracle, Sybase ASE and Sybase IQ.

Installation and Configuration

Help clients to install and configure PostgreSQL environment including clusters, load-balancing and high availability in both on-premises and cloud environment with partners. All installation and configuration is based on the best practice suggested in the PostgreSQL official website.

Oracle Replacement

Help clients to build data warehouse with the power of open source PostgreSQL. Well experienced to migrate Oracle Enterprise database to open source platform including the migration of Oracle with Schema conversion and Oracle PL/SQL to PostgreSQL PL/pgSQL migration.

Database Performance Tuning

To tune a database performance, it is basically related to the optimization of the usage of available system resource such as CPU, Memory and I/O. In order to enhance the performances, there are a number of activities being carried and they are:

  • Analyze PostgreSQL for system configuration and usage information
  • Update Database parameter tuning
  • Rewrite / tune slow SQL statements
  • Reduce lock waiting time by detailed investigation

Training Service

We would like to share our experiences on database management including on different usages – OLTP and OLAP. There are different training classes available:

  • PostgreSQL Fundamental
  • PostgreSQL Administration & Performance Tuning
  • PostgreSQL Replication & Recovery