PostgreSQL 10; Long Awaited Enterprise Solutions

PostgreSQL 10 Long Awaited Enterprise Solutions Plasa Semanggi 9 Fl. Unit 9 Jl. Jend Sudirman Kav. 50 Jakarta - Indonesia 12930

ENTERPRISE CLASS DATABASE SERVER Maintenance Services – Enterprise PostgreSQL Installation, Tuning / optimization, monitoring, maintenance, and managed services

The Trilogy of RAS Reliability Availability Scalability What is New in PostgreSQL 10?

Strong Password (SHA-256) Implemented Uses SCAM-SHA-256 (Based on SASL RFC-7677) SHA-256 know as the strongest HASH up to now. Implemented in newest Intel Processors SERVER CLIENT Send User Name Send SALT Send PASSWORD Hash_SHA256 with SALT

TPC-B Read Only Test For POWER8 10 Cores

Client-side Automatic Failover LIBPQ Drivers Replication

Logical Replication Database in Jakarta Database in Surabaya Database in Medan CONSOLIDATED in Head Office

Table Replication (Realtime) DATABASE AGGREGATION Head Office TABLE A (Subscriber) DATABASE Medan TABLE A (Publisher) DATABASE Bandung TABLE A (Publisher) TABLE C (Subscriber) TABLE D (Subscriber) TABLE B (Subscriber) DATABASE Surabaya TABLE A (Publisher) DATABAS E Jakarta TABLE A (Publisher)

High Availability Hot-Standby Replication Only 10 seconds to Failover Replica promoted to Master when Real Master down

Native Partitioning (Automatic)

Scalability - Multi-Master Multi-Master Replication (MMR) Replication with Master on every nodes Best for distributed Data on different location with required integrated synchronization seamlessly.

Parallel Query (The Real One) 1. Not only aggregates, includes: INDEX SCAN, BITMAP HEAD SCAN. 2. Oracle only support FULL TABLE SCAN and INDEX BUILDING. 3. Parallel JOIN supported. 4. OLAP Friendly.

XMLTABLE 1. It turns XML data format into Table mode. (seamlessly) 2. Provides application to access XML data using SQL Query. (without hassle describing XML format) 3. Only use single Query to access both XML and Table data format. XML Structure and Table Structure cross interchange XMLTABLE

XMLTABLE <ROWS> <ROW id="1"> <COUNTRY_ID>AU</COUNTRY_ID> <COUNTRY_NAME>Australia</COUNTRY_NAME> </ROW> <ROW id="5"> <COUNTRY_ID>JP</COUNTRY_ID> <COUNTRY_NAME>Japan</COUNTRY_NAME> <PREMIER_NAME>Shinzo Abe</PREMIER_NAME> <SIZE unit="sq_mi">145935</SIZE> </ROW> <ROW id="6"> <COUNTRY_ID>SG</COUNTRY_ID> <COUNTRY_NAME>Singapore</COUNTRY_NAME> <SIZE unit="sq_km">697</SIZE> </ROW> </ROWS> ID COUNTRY ID COUNTRY NAME PREMIER NAME SIZE

More About PostgreSQL As Open Source Project As a Miracle that change the World

The History of PostgreSQL 1977-1985: INGRES, began as the academic research in UCB by Prof Michael STONEBRAKER, implementing Whitepaper from Edgar. F. Codd. 1986-1994: POSTGRES began development from 1986-1994, as continuation of INGRES with object relational technology. POSTGRES commercialize as ILLUSTRA, later become INFORMIX, and purchased by IBM 1 billion dollars. 1994-1995: Became Postgres95, because POSTQUEL replaced by SQL Languages 1996-Present: PostgreSQL as new career in Open Source. PostgreSQL has actively Maintained, Develops, QC by PosgreSQL Global Development Group consists Hackers, Academics, Professionals all around the World. At Present, Many organizations, government agencies and companies use PostgreSQL. You will find installations in ADP, CISCO, NTT Data, NOAA, Research In Motion, The US Forestry Service and The American Chemical Society. Today, it's rare to find a large corporation or government agency which isn't using PostgreSQL in at least one department.

Name Vendor License Availability Notes AgensGraph Bitnine Apache2 2016- PostgreSQL + Graph Model features (Support graph storage and Cypher query language) Aster Data Teradata Proprietary 2005-.... PostgreSQL + Map/Reduce BDR 2ndQuadrant BSD 2014- PostgreSQL Multi Master, contributed actively back to Core PG Bizgres Greenplum BSD 2005-2007 PostgreSQL + BI features Citus Citus Data AGPL-3.0 2012- Sharding and replication across many servers with MPP [1] Cybercluster Cybertec BSD 2007-2010 Clustering (pgCluster fork) Greenplum Database Greenplum Apache2 2005-.... PostgreSQL + BI features (formerly known as "Bizgres MPP") [2] ExtenDB ExtenDB Proprietary 2003-2007 PostgreSQL + BI Features [3] FUJITSU Enterprise Postgres Fujitsu proprietary 2006-.... Full PostgreSQL compatibility with additional functionality [4] GresCube NTT DATA Proprietary 2012-.... Database appliance solution based on PostgreSQL [5] GridSQL EnterpriseDB GPL 2007-2010 PostgreSQL + BI Features (formerly ExtenDB) [6] Great Bridge PostgreSQL Great Bridge LLC BSD 1999-2001 PostgreSQL re-distribution PostgreSQL Forks - it is been 21 years

Name Vendor License Availabilit y Notes HadoopDB Yale University Apache License V2.0 2009-.... PostgreSQL + shared-nothing cluster + Hadoop [7] Hadapt Teradata Proprietary 2011-.... HadoopDB fork Mammoth Command Prompt BSD 2005-2010 PostgreSQL + proprietary replication + extensions Netezza IBM proprietary 2002-.... Appliance based on PostgreSQL SQL engine NuSphere UltraSQL NuSphere proprietary 2002-2003 Native Win32 port of PostgreSQL ParAccel Actian proprietary 2005-.... PostgreSQL + BI features [8] pgCluster-II SRA BSD 2006-2007 Clustering (Shared Disk) pgPool-II pgPool GDG BSD 2006-.... Clustering (Connection Pooling / Replication / Load-Balancing) PipelineDB PipelineDB GPL v3 2015-.... Streaming SQL PostgresForest NTT DATA BSD 2006-2010 Clustering / PostgresForest is a fork of the JDBC driver, not from the backend code. EDB Postgres Advanced Server EnterpriseDB proprietary 2008-.... PostgreSQL + Oracle compatibility + security + performance tools + developer tools + DBA tools, formally Postgres Plus Advanced Server / EnterpriseDB AS [9] PostgreSQL Forks - it is been 21 years

Name Vendor License Availability Notes Postgres Pro Enterprise Postgres Professional proprietary 2016-... PostgreSQL + enterprise features [10] Postgres-R PGDG BSD 2006-2010 Clustering Postgres-X2 PGX2DG BSD 2015- Clustering (formerly Postgres-XC) Postgres-XL PGXLDG BSD 2014-.... Clustering PowerGres SRA OSS proprietary 2003-.... Native Win32 port of PostgreSQL and Linux RPM PowerGres Plus SRA OSS proprietary 2003-.... PostgreSQL + custom storage engine, redundant WAL, encrypted database [12] RecDB umn.edu BSD 2013-.... Recommendation Engine [13] Redshift Amazon Private/Clou d-based 2013-.... Data Warehouse on AWS (based on ParACCEL) [14] [15] Stado Stado GDG GPL 2011-2011 PostgreSQL + BI Features (fork of GridSQL) [16] TelegraphCQ UC Berkeley BSD 2000-2008 Data Stream oriented fork of PostgreSQL PostgreSQL Forks - it is been 21 years

Name Vendor License Availabili ty Notes ToroDB 8Kdata AGPLv3 2015-... Turns PostgreSQL into a NoSQL database compatible with MongoDB. It can work as a standalone database or a secondary node of a MongoDB replicaset. TruCQ Truviso proprietary 2008-201 2 Fork of TelegraphCQ Vertica HP proprietary 2005-.... Column-oriented DataWarehouse (created by Stonebraker), may only be forking the psql client library. Yahoo! Everest Yahoo! private 2008-.... multi-petabyte database / MPP [17] PostgreSQL Forks - it is been 21 years

Maintenance Services 1. Preventive Maintenance a. On-Site Standby Support by Appointment (migration, maintenance, etc.) b. Scheduled Maintenance, every 3 month. 2. Corrective Maintenance (Unlimited) a. On-Phone Support b. On-Remote Support (if available) c. On-Site Support, lead time maximum 4 hours

Managed Services (24/7) 1. All of the services delivered in Maintenance Services 2. System Monitoring (Performance, Alert, Slow queries, etc) 3. Security Check and penetration prevention. 4. Remote DBA 5. Security Tuning, Server Tuning, Query Tuning, etc

Equnix Trainings - Public and In House A. Software Development for Mission Critical System B. PostgreSQL Basic C. PostgreSQL Advanced and Customized D. OS Linux Administration Basic E. OS Linux Administration Advanced

Success Story about EDII 3 Servers SPARC using Oracle RAC Become Single Server PostgreSQL on INTEL Machine Oracle to PostgreSQL migration 1,5 Month for migrating 649 Tables, 137 Packages, 117 Procs with 10,300+ Line of code; Security, Data Structures, etc Only 4 People (2 Staff, 1 Senior and 1 Expert Consultant) All is done on our Expertise and Resources

Controlled and tightly monitored of System Versioning, versioning and progagation done is secure manner, no hassle maintaining more than 3400+ Terminal without hesitate having random version deployment caused by lack of strong versioning system. Realtime Transaction Monitoring system

Realtime Update, Data & Apps Ensure Data Integrity Between POS Server and Back End. Easy for HelpDesk to Monitor Data Integration between POS and Back end Application Include: Product Update, Promotion Update, Daily Sales Consolidation, Realtime Report, Etc. Helpdesk also able to recover Data Integrity using Tool Monitoring, so as to fix the issue quickly. Example: Missing Data, Data discrepancy, etc.

Realtime Monitoring: Store level, network healthy check, server performance, Data Synchronization/Integrity, Application Version System, Product and Promo latest update (versioning system) Realtime National Infrastructure Monitoring

PostgreSQL Conferences All around the World

PGDay ASIA in Singapore - 2017

PostgreSQL Conference ASIA - JAPAN

PostgreSQL World Conference - Ottawa

SMILE (Strong, Mature, Intelligent, Low profile and Expert)

We are young, brave heart, dare to challenge the World!

Singapore 8 Eu Tong Sen Street, #14-94 THE CENTRAL Singapore 059818 Donny Kurtiyono (+65 8200 1406) donny@equnix.asia Thailand Level 29, The Offices at Centralworld 999/9 Rama I Road, Pathumwan Bangkok 10330 Lilly (+662 207 2602) lilly@equnix.asia Philippines Left Wing, 2nd Floor Molave Building 2231 Don Chino Roces Avenue, Makati City, Philippines Carlo Magno Domingo (+63 917 154 1030) carlo@equnix.asia Vietnam Vincom Tower 72Le Thanh Ton street, Ben Nghe Ward, District 1, Ho Chi Minh City, Vietnam Bui Hung (+84 945913585) hung@equnix.asia Malaysia K10 Jalan GC14 Glomac Cyberjaya, Cyber 4 63000 Cyberjaya, Selangor, Malaysia Norazimah Othman (+603.8945 0069) nora@equnix.asia Myanmar UMG ICT Building, K.18 Nwetharki Street, Bayintnaung Pwalyon, Mayangone Township Yangon, Myanmar Suu Myat Khin (+95 942011 5959) suumyat@equnix.asia Our ASEAN Representatives

#1 PostgreSQL Expert In ASEAN We Are EQUNIX.ASIA, dare to be:

PostgreSQL 10; Long Awaited Enterprise Solutions

More Related Content

What's hot

Similar to PostgreSQL 10; Long Awaited Enterprise Solutions

Recently uploaded

PostgreSQL 10; Long Awaited Enterprise Solutions