際際滷

際際滷Share a Scribd company logo

[Pgday.Seoul 2018] replacing oracle with edb postgres

PgDay.Seoul
PgDay.Seoul

[Pgday.Seoul 2018] replacing oracle with edb postgres - EDB 蟾讌 伎 from oracle to edb postgres 蟠: 覲蟆 蠍讌, 襴 覈 蠍讌

1 of 21
Downloaded 35 times
息 Copyright EnterpriseDB Corporation, 2018. All rights reserved. REPLACING ORACLE with EDB Postgres 蟾讌 伎, APAC Solution Architect 2018-11-03
息 Copyright EnterpriseDB Corporation, 2018. All rights reserved.2 OPEN SOURCE IS THE NEW DATA CENTER STANDARD! 2009 Figure 1 Relational Open-Source DBMS Maturity Evaluation, 2015 Source: Gartner (April 2015) Figure 2 Relational Open-Source DBMS Maturity Evaluation,2015 Source: Gartner (April 2015) 2015 Open-Source DBMS Commercial Non-Mission Critical Applications Non-Mission Critical Applications Mission Critical Applications Mission Critical Applications Total Cost of Ownership Total Cost of Ownership DBMS Functionality DBMS Functionality DBA Tools DBA Tools Availability of DBA Resources Availability of DBA Resources 螳碁, ろ RDBMS 譯殊, 2015
息 Copyright EnterpriseDB Corporation, 2018. All rights reserved. 2022蟾讌 蠏 螳 覦 襴 貅 70% DB襯 蠍 覦 襦 螳 覦 蟆願, 蠍 譟 DB 50% DB襦 蟲 豌 蟇 蠏 螻 蟆企. Gartner, State of the Open-Source DBMS Market, Merv Adrian, Donald Feinberg, February 28, 2018 3
息 Copyright EnterpriseDB Corporation, 2018. All rights reserved. POSTGRES: 2017 伎 DBMS! 4
息 Copyright EnterpriseDB Corporation, 2018. All rights reserved. GARTNER MQ 狩 ろ RDBMS 2013覿 5 一 Gartners Magic Quadrant 5
息 Copyright EnterpriseDB Corporation, 2018. All rights reserved. EDB POSTGRES PLATFORM 6
息 Copyright EnterpriseDB Corporation, 2018. All rights reserved. DATABASE COMPATIBILITY FOR ORACLE速 蠏 螳覦 る狩伎 豌企 EDB Postgres 螳 Oracle DBAs developers 讌 螳 PL/SQL 覦 Pro*C, OCI 讌 一危 蠍壱襯 覲旧 蠍磯 螻 EDB POSTGRES ADVANCED SERVER ORACLE COMPATIBILITY る狩 螳覦 る狩 危襴貅伎 觜 覦 覩殊鴬 讀 觜讀れ危襴貅伎襴 る狩 蠍一 牛 覓 一 覦 一 讀! 7
息 Copyright EnterpriseDB Corporation, 2018. All rights reserved. EDB POSTGRES ADVANCED SERVER ORACLE COMPATIBILITY SQL extension support Decode, NVL, Substr, NVL2, Date/time functions DDL syntax support PL/SQL support direct execution in EDB Postgres Advanced Server REF Cursors, Implicit and explicit cursors Looping, variable declarations, conditional statements Collections: Associative Arrays, Varrays, Nested tables Pragmas Named parameters User Defined Exceptions Explicit Transaction Control(within sp) Tools EDB*Plus SQL*Plus look-a-like EDB*Loader SQL*Loader equivalent Oracle-like Data Dictionary ALL_, DBA_, USER_ views Wait Events System and session waits Statspack-like reporting Features Packages Stored procedures Functions Triggers Hints Hierarchical Queries Synonyms Public and Private Sequences Rownum Users/Roles Dynamic SQL Materialized Views Partitioning PL/SQL supplied packages 14 DBMS 6 UTL Data types Blobs, Clobs, XMLTYPE, VARCHAR2, NUMBER, CHAR, Integer8
息 Copyright EnterpriseDB Corporation, 2018. All rights reserved.9 EDB MIGRATION PORTAL: 殊 蠍磯 誤 蟆讀 蟲 Oracle EDB Postgres 誤 讌 讌 覓企 殊 蟆讀 蟲 襾語 牛 觜誤 蟲覓語 讌 蠍磯 螳 觜誤 蟲覓 譟壱 覦 誤 蟲覓 蟆讀 襭 ろる襯 EDB Postgres 襦 豢 豢
息 Copyright EnterpriseDB Corporation, 2018. All rights reserved. , 觜一危, 襾狩 一危一 EDB POSTGRES Foreign Data Wrapper SQL/MED 蠍磯 MySQL, MongoDB & Hadoop FDW 觚 襴曙 蠍磯蓋 貉るる磯ゼ 牛 蠍壱 FDWs 讌 10 R R / W R / W File / CSVODBC/J DBC MySQL MongoDB Twitter / FB Hadoop LDAP Others
息 Copyright EnterpriseDB Corporation, 2018. All rights reserved. NOSQL & RDBMS襯 ? SQL螻 NoSQL 蟆曙 覲 襦蠏碁 襦讌 覿 Postgres does it all! 11 SELECT DISTINCT product_type, data->>'brand' as Brand, data->>'available' as Availability FROMjson_data JOIN products ON (products.product_type=json_data.data- >>'name') WHERE json_data.data->>'available'=true; product_type | brand | availability ---------------------------+-----------+-------------- AC3 Phone | ACME | true ANSI SQL J SON
息 Copyright EnterpriseDB Corporation, 2018. All rights reserved.12 EDB POSTGRES ARK ON AZURE Azure 豕 EDB Postgres DBaaS 蟯襴 貊 觜 DBaaS 覩殊鴬 DevOps 讌 螻螳 蠍磯 レ 一 磯伎 語ろ伎 覦壱 Production Clusters Development instances
息 Copyright EnterpriseDB Corporation, 2018. All rights reserved.13 EDB POSTGRES ARK CONSOLE 讌蟯企 螻 DBaaS 蟯襴 - ろ 襷 - ろ れ朱 - 螻螳 - DevOps - 覦煙 1 Scale replicas in or out manually 2 Clone cluster for new app development 3 Upgrade Postgres version on your schedule 4 Scale server class up or down manually 5 Transaction or Recovery preferred failover 6 Multi-node clusters with automatic replication, connection pooling and load balancing 7 User controlled auto-scaling thresholds 8 Auto-backup policies including PITR 9 Monitoring and Events panels 1 Scale replicas in or out manually 2 Clone cluster for new app development 3 Upgrade Postgres version on your schedule 4 Scale server class up or down manually 5 Transaction or Recovery preferred failover 6 Multi-node clusters with automatic replication, connection pooling and load balancing 7 User controlled auto-scaling thresholds 8 Auto-backup policies including PITR 9 Monitoring and Events panels 1 2 3 4 5 9 7 8 6 Console
息 Copyright EnterpriseDB Corporation, 2018. All rights reserved. 蟲 襦 14 KT 2012 譴 DB Mission Critical 覓伎 れ る狩 襷願係伎 / 蠏 KT uCloud 襷貅伎 焔 螻伎襦 觜襯願 一 P 譟一 2015 譴 DB 蟯 蠏 襦 譯朱 譴 蠍 覓企 一 る狩 襷願係伎 襦 讌 S 譟一 2016 譴 DB る る狩 襷願係伎 讌譴 (MIS 覓 譯) れ 蟯 蠏 襦 讌譴 螻伎襦 觜襯願 一 H 譟一 2017 譴 DB 螻螳 觜 覓伎 蠏 襦 譯朱 蟲, , 碁 讌 覦壱 る狩 襷願係伎 襦 讌
息 Copyright EnterpriseDB Corporation, 2018. All rights reserved. ろ SW襦 5螳 2000 觜螳 15 語SW 譬 覓語 企 螳ろ 5覿螳 80襷 蟇伎 豌襴ルリ骸 覓伎レ襯 蠍磯. る DBMS 觜 20旧 螳 EPAS ろ 磯ジ 豈 覈 譴. 語SW 譬 磯ジ 伎 觜 讀螳 殊伎 螳 願屋 螳 KT 語ろ 譯殊 30螳 覲 ろ る狩 DBMS襯 れ EPAS襦 蟲豌 ろDB襦 讌觜 80% 螳 る狩 譟企襯 譴企 蠏碁 讌覲伎觜 譴企 蟲DBMS 螳蟆 危讌襷 譴リ鍵朱 覺れ 轟 蠍一 譬 豕譬朱 ろ る 蟆一 ろ 朱 朱 る狩 DBMS 觜 豕 80% 觜 螳 螻 覓 : http://www.dt.co.kr/contents.htm?article_no=2014030702010860746001 覓 : http://www.etnews.com/20150625000271 麹 KTDS IT觜ろ狩一 危語 KT ろSW
息 Copyright EnterpriseDB Corporation, 2018. All rights reserved. EDB POSTGRES 覓 16 1. 蠏 螳覦 危襴貅伎 DevOps, schema-less 螳覦, れ 襦蠏碁覦 語 讌 2. 危襴貅伎 螻 壱 Multi-model 讌 覦 れ 一危 れ 郁 讌 3. 蠍一ヾ DBMS る狩 誤 蠍磯レ 牛 DBA 螳覦 ろ 螳 4. 企殊磯 願 れ 覦壱 旧螻 企殊磯 願 磯ジ 壱 觚ろ襴曙 豈
息 Copyright EnterpriseDB Corporation, 2018. All rights reserved. 1. MISSION CRITICAL & OLTP 殊燕 蟆一襯 覦伎 語 觜 蠏 蟲豢 襦 螻殊 24/7 覓伎 觜 螻 17 蟲覲伎語 - 覦伎 語 觜 蠏 2豌襷 碁 豌襴, 狩 蠍一 1500TPS 豌襴 pgpool-II 襯 牛 襷ろ レ 10豐 企 殊る 襤一煙 覦朱 覓伎 觜 螻
息 Copyright EnterpriseDB Corporation, 2018. All rights reserved. 2. INFORMATION LIFECYCLE MANAGEMENT Exadata ル 覲 譴 2 讌 一 磯 ろ襴讌 觜 螳 EPAS襦 豺伎企 螻殊 6~7TB 覦 一危一 觜襯 願 譟壱 焔 讌 200TB 伎 一危 蠍一ヾ 危襴貅伎螻 覯渚 誤 螻 一危 讀 觜 螳 一危 蠍磯 ろ 一危 蟆暑襯 牛 觜 & 讀 18 S 譟一 - 企レ 一危 覦 譟壱 EPAS ETL ETL
息 Copyright EnterpriseDB Corporation, 2018. All rights reserved. 3. MISSION CRITICAL & OLTP KT 襷 危 5 襷 螳 ろ ろ SW襦 蟲豢 螻殊 蠍郁 襷願係伎 蟆郁骸 19 KT - 危 5 螳ろ 豕 TPS : 6,200 TPS ( 襷 5覿 80襷 蟇伎 谿 覦蠍 螳) Legacy 讀る觜 觜 旧 螳 (H/W, S/W 殊伎) PPAS DBMS 覦 焔 蟆讀, 蠍磯 襷
息 Copyright EnterpriseDB Corporation, 2018. All rights reserved. 4. 企殊磯 願 & NOSQL 郁 覦 螳譬 殊 讌 覲 蠍磯 螳 誤 觜 螻殊 On-premise 蟆曙 AWS EC2襦 願 螻螳 覲 豺伎磯殊 ル 殊 覲伎 觜 覃 覲 磯 螻 20 S 譟一 - IoT 觜 EDB Failover Manager襯 牛 VIP 覦 殊る襦 螻螳 覲 Cassandra FDW襯 牛 豢螳 螳覦 螻旧 豕 覦 觜 覲 EPAS DB Tables CassandraCassandra FDW Public Cloud
The Most Complete Open Source Database Platform 息 Copyright EnterpriseDB Corporation, 2018. All rights reserved. THANK YOU sales-kr@enterprisedb.com www.enterprisedb.com

More Related Content

[Pgday.Seoul 2018] replacing oracle with edb postgres

  • 1. 息 Copyright EnterpriseDB Corporation, 2018. All rights reserved. REPLACING ORACLE with EDB Postgres 蟾讌 伎, APAC Solution Architect 2018-11-03
  • 2. 息 Copyright EnterpriseDB Corporation, 2018. All rights reserved.2 OPEN SOURCE IS THE NEW DATA CENTER STANDARD! 2009 Figure 1 Relational Open-Source DBMS Maturity Evaluation, 2015 Source: Gartner (April 2015) Figure 2 Relational Open-Source DBMS Maturity Evaluation,2015 Source: Gartner (April 2015) 2015 Open-Source DBMS Commercial Non-Mission Critical Applications Non-Mission Critical Applications Mission Critical Applications Mission Critical Applications Total Cost of Ownership Total Cost of Ownership DBMS Functionality DBMS Functionality DBA Tools DBA Tools Availability of DBA Resources Availability of DBA Resources 螳碁, ろ RDBMS 譯殊, 2015
  • 3. 息 Copyright EnterpriseDB Corporation, 2018. All rights reserved. 2022蟾讌 蠏 螳 覦 襴 貅 70% DB襯 蠍 覦 襦 螳 覦 蟆願, 蠍 譟 DB 50% DB襦 蟲 豌 蟇 蠏 螻 蟆企. Gartner, State of the Open-Source DBMS Market, Merv Adrian, Donald Feinberg, February 28, 2018 3
  • 4. 息 Copyright EnterpriseDB Corporation, 2018. All rights reserved. POSTGRES: 2017 伎 DBMS! 4
  • 5. 息 Copyright EnterpriseDB Corporation, 2018. All rights reserved. GARTNER MQ 狩 ろ RDBMS 2013覿 5 一 Gartners Magic Quadrant 5
  • 6. 息 Copyright EnterpriseDB Corporation, 2018. All rights reserved. EDB POSTGRES PLATFORM 6
  • 7. 息 Copyright EnterpriseDB Corporation, 2018. All rights reserved. DATABASE COMPATIBILITY FOR ORACLE速 蠏 螳覦 る狩伎 豌企 EDB Postgres 螳 Oracle DBAs developers 讌 螳 PL/SQL 覦 Pro*C, OCI 讌 一危 蠍壱襯 覲旧 蠍磯 螻 EDB POSTGRES ADVANCED SERVER ORACLE COMPATIBILITY る狩 螳覦 る狩 危襴貅伎 觜 覦 覩殊鴬 讀 觜讀れ危襴貅伎襴 る狩 蠍一 牛 覓 一 覦 一 讀! 7
  • 8. 息 Copyright EnterpriseDB Corporation, 2018. All rights reserved. EDB POSTGRES ADVANCED SERVER ORACLE COMPATIBILITY SQL extension support Decode, NVL, Substr, NVL2, Date/time functions DDL syntax support PL/SQL support direct execution in EDB Postgres Advanced Server REF Cursors, Implicit and explicit cursors Looping, variable declarations, conditional statements Collections: Associative Arrays, Varrays, Nested tables Pragmas Named parameters User Defined Exceptions Explicit Transaction Control(within sp) Tools EDB*Plus SQL*Plus look-a-like EDB*Loader SQL*Loader equivalent Oracle-like Data Dictionary ALL_, DBA_, USER_ views Wait Events System and session waits Statspack-like reporting Features Packages Stored procedures Functions Triggers Hints Hierarchical Queries Synonyms Public and Private Sequences Rownum Users/Roles Dynamic SQL Materialized Views Partitioning PL/SQL supplied packages 14 DBMS 6 UTL Data types Blobs, Clobs, XMLTYPE, VARCHAR2, NUMBER, CHAR, Integer8
  • 9. 息 Copyright EnterpriseDB Corporation, 2018. All rights reserved.9 EDB MIGRATION PORTAL: 殊 蠍磯 誤 蟆讀 蟲 Oracle EDB Postgres 誤 讌 讌 覓企 殊 蟆讀 蟲 襾語 牛 觜誤 蟲覓語 讌 蠍磯 螳 觜誤 蟲覓 譟壱 覦 誤 蟲覓 蟆讀 襭 ろる襯 EDB Postgres 襦 豢 豢
  • 10. 息 Copyright EnterpriseDB Corporation, 2018. All rights reserved. , 觜一危, 襾狩 一危一 EDB POSTGRES Foreign Data Wrapper SQL/MED 蠍磯 MySQL, MongoDB & Hadoop FDW 觚 襴曙 蠍磯蓋 貉るる磯ゼ 牛 蠍壱 FDWs 讌 10 R R / W R / W File / CSVODBC/J DBC MySQL MongoDB Twitter / FB Hadoop LDAP Others
  • 11. 息 Copyright EnterpriseDB Corporation, 2018. All rights reserved. NOSQL & RDBMS襯 ? SQL螻 NoSQL 蟆曙 覲 襦蠏碁 襦讌 覿 Postgres does it all! 11 SELECT DISTINCT product_type, data->>'brand' as Brand, data->>'available' as Availability FROMjson_data JOIN products ON (products.product_type=json_data.data- >>'name') WHERE json_data.data->>'available'=true; product_type | brand | availability ---------------------------+-----------+-------------- AC3 Phone | ACME | true ANSI SQL J SON
  • 12. 息 Copyright EnterpriseDB Corporation, 2018. All rights reserved.12 EDB POSTGRES ARK ON AZURE Azure 豕 EDB Postgres DBaaS 蟯襴 貊 觜 DBaaS 覩殊鴬 DevOps 讌 螻螳 蠍磯 レ 一 磯伎 語ろ伎 覦壱 Production Clusters Development instances
  • 13. 息 Copyright EnterpriseDB Corporation, 2018. All rights reserved.13 EDB POSTGRES ARK CONSOLE 讌蟯企 螻 DBaaS 蟯襴 - ろ 襷 - ろ れ朱 - 螻螳 - DevOps - 覦煙 1 Scale replicas in or out manually 2 Clone cluster for new app development 3 Upgrade Postgres version on your schedule 4 Scale server class up or down manually 5 Transaction or Recovery preferred failover 6 Multi-node clusters with automatic replication, connection pooling and load balancing 7 User controlled auto-scaling thresholds 8 Auto-backup policies including PITR 9 Monitoring and Events panels 1 Scale replicas in or out manually 2 Clone cluster for new app development 3 Upgrade Postgres version on your schedule 4 Scale server class up or down manually 5 Transaction or Recovery preferred failover 6 Multi-node clusters with automatic replication, connection pooling and load balancing 7 User controlled auto-scaling thresholds 8 Auto-backup policies including PITR 9 Monitoring and Events panels 1 2 3 4 5 9 7 8 6 Console
  • 14. 息 Copyright EnterpriseDB Corporation, 2018. All rights reserved. 蟲 襦 14 KT 2012 譴 DB Mission Critical 覓伎 れ る狩 襷願係伎 / 蠏 KT uCloud 襷貅伎 焔 螻伎襦 觜襯願 一 P 譟一 2015 譴 DB 蟯 蠏 襦 譯朱 譴 蠍 覓企 一 る狩 襷願係伎 襦 讌 S 譟一 2016 譴 DB る る狩 襷願係伎 讌譴 (MIS 覓 譯) れ 蟯 蠏 襦 讌譴 螻伎襦 觜襯願 一 H 譟一 2017 譴 DB 螻螳 觜 覓伎 蠏 襦 譯朱 蟲, , 碁 讌 覦壱 る狩 襷願係伎 襦 讌
  • 15. 息 Copyright EnterpriseDB Corporation, 2018. All rights reserved. ろ SW襦 5螳 2000 觜螳 15 語SW 譬 覓語 企 螳ろ 5覿螳 80襷 蟇伎 豌襴ルリ骸 覓伎レ襯 蠍磯. る DBMS 觜 20旧 螳 EPAS ろ 磯ジ 豈 覈 譴. 語SW 譬 磯ジ 伎 觜 讀螳 殊伎 螳 願屋 螳 KT 語ろ 譯殊 30螳 覲 ろ る狩 DBMS襯 れ EPAS襦 蟲豌 ろDB襦 讌觜 80% 螳 る狩 譟企襯 譴企 蠏碁 讌覲伎觜 譴企 蟲DBMS 螳蟆 危讌襷 譴リ鍵朱 覺れ 轟 蠍一 譬 豕譬朱 ろ る 蟆一 ろ 朱 朱 る狩 DBMS 觜 豕 80% 觜 螳 螻 覓 : http://www.dt.co.kr/contents.htm?article_no=2014030702010860746001 覓 : http://www.etnews.com/20150625000271 麹 KTDS IT觜ろ狩一 危語 KT ろSW
  • 16. 息 Copyright EnterpriseDB Corporation, 2018. All rights reserved. EDB POSTGRES 覓 16 1. 蠏 螳覦 危襴貅伎 DevOps, schema-less 螳覦, れ 襦蠏碁覦 語 讌 2. 危襴貅伎 螻 壱 Multi-model 讌 覦 れ 一危 れ 郁 讌 3. 蠍一ヾ DBMS る狩 誤 蠍磯レ 牛 DBA 螳覦 ろ 螳 4. 企殊磯 願 れ 覦壱 旧螻 企殊磯 願 磯ジ 壱 觚ろ襴曙 豈
  • 17. 息 Copyright EnterpriseDB Corporation, 2018. All rights reserved. 1. MISSION CRITICAL & OLTP 殊燕 蟆一襯 覦伎 語 觜 蠏 蟲豢 襦 螻殊 24/7 覓伎 觜 螻 17 蟲覲伎語 - 覦伎 語 觜 蠏 2豌襷 碁 豌襴, 狩 蠍一 1500TPS 豌襴 pgpool-II 襯 牛 襷ろ レ 10豐 企 殊る 襤一煙 覦朱 覓伎 觜 螻
  • 18. 息 Copyright EnterpriseDB Corporation, 2018. All rights reserved. 2. INFORMATION LIFECYCLE MANAGEMENT Exadata ル 覲 譴 2 讌 一 磯 ろ襴讌 觜 螳 EPAS襦 豺伎企 螻殊 6~7TB 覦 一危一 觜襯 願 譟壱 焔 讌 200TB 伎 一危 蠍一ヾ 危襴貅伎螻 覯渚 誤 螻 一危 讀 觜 螳 一危 蠍磯 ろ 一危 蟆暑襯 牛 觜 & 讀 18 S 譟一 - 企レ 一危 覦 譟壱 EPAS ETL ETL
  • 19. 息 Copyright EnterpriseDB Corporation, 2018. All rights reserved. 3. MISSION CRITICAL & OLTP KT 襷 危 5 襷 螳 ろ ろ SW襦 蟲豢 螻殊 蠍郁 襷願係伎 蟆郁骸 19 KT - 危 5 螳ろ 豕 TPS : 6,200 TPS ( 襷 5覿 80襷 蟇伎 谿 覦蠍 螳) Legacy 讀る觜 觜 旧 螳 (H/W, S/W 殊伎) PPAS DBMS 覦 焔 蟆讀, 蠍磯 襷
  • 20. 息 Copyright EnterpriseDB Corporation, 2018. All rights reserved. 4. 企殊磯 願 & NOSQL 郁 覦 螳譬 殊 讌 覲 蠍磯 螳 誤 觜 螻殊 On-premise 蟆曙 AWS EC2襦 願 螻螳 覲 豺伎磯殊 ル 殊 覲伎 觜 覃 覲 磯 螻 20 S 譟一 - IoT 觜 EDB Failover Manager襯 牛 VIP 覦 殊る襦 螻螳 覲 Cassandra FDW襯 牛 豢螳 螳覦 螻旧 豕 覦 觜 覲 EPAS DB Tables CassandraCassandra FDW Public Cloud
  • 21. The Most Complete Open Source Database Platform 息 Copyright EnterpriseDB Corporation, 2018. All rights reserved. THANK YOU sales-kr@enterprisedb.com www.enterprisedb.com