狠狠撸

狠狠撸Share a Scribd company logo

DataEng Mad - 03.03.2020 - Tibero 30-min Presentation.pdf

?
?
Miguel Angel Fajardo
Miguel Angel Fajardo

The document compares various database companies and their products. It provides details on TmaxSoft, including its employee headcount, main products which include databases and middleware, and key technologies. It then discusses Tibero database specifically and how it compares to Oracle, including features, licensing model, compatibility, and security. Examples are also provided showing capabilities of Tibero compared to Oracle.

1 of 20
Download to read offline
1
2 Company name Headcount % Developers (source = LinkedIn Premium) Software Developed MariaDB ~210 50 ● MariaDB Enterprise EDB (PostgreSQL) ~400 30 ● EDB Postgres Advanced Server ○ Several extensions adding enterprise functionalities to OSS PostgreSQL 2nd Quadrant (PostgreSQL) >100 70 ● 2ndQ PostgreSQL ○ Several extensions adding enterprise functionalities to OSS PostgreSQL TmaxSoft ~1300 80 ● OpenFrame (Mainframe Rehosting) ● JEUS (Application Server - Weblogic alternative) ● WebtoB (Enterprise Scalable Apache) ● Tmax (Middleware Transaction Manager) ● Tibero (RDBMS - Oracle DB Alternative, Native PL/SQL = PSM) ○ HyperData: ELT Flow designer with Graphs/Dashboards for BI or Data Virtualization ○ SysMaster for Tibero: Monitoring Tool for Tibero. ● ProSync (GoldenGate Alternative) ● AnyLink (Messaging Software, Queueing) ● SysMaster (Enterprise Monitoring) ● Cloud Stack (Private Cloud, Focused on Security, targeted to Government) ● ProLinux (Enterprise Linux for Production environments) ● TmaxOS (End-User Linux, Windows friendly + own Office Suite + own Cloud Collab.) ● TOP (TmaxSoft One Platform = Develop 1 App for any Platform = similar JVM) ● TmaxCDS ("Tmax Cloud Desktop Service" = Virtualized End-User Distributed Comp.) Companies always avoided to deal with small companies because of low reliability. MariaDB, EDB or 2nd Q. could have 2 problems, either they are not re-investing their money into R&D (greediness) or either the Open Source model is not bene?cial for them. Comparing CompaniesUpdated FEB-2020
3
4 Tibero Database ● Designed for Security against any foreign attacks from North Korea, China, Russia and US ● All inclusive licensing model => Higher quality application development ● Lift and Shift => In 90% cases; No need to face a migration. No need to change your PL/SQL. ● Direct replacement for Oracle EE + Exadata => At better cost than Open Source Support fees ● Flexibility => Easy to use with any Cloud, any Virtualization or Containers.
5 Cost Functional Area Availability Often used for Oracle RAC (only EE) $$ High Availability Tibero Active Cluster ? Horizontal Scaling Active Data Guard $$ Disaster Recovery Hot Standby (read-only) ? Advanced Security $$ Security Data Encryption + Network Encryption ? GDPR --- -- Security Protection against Data Tampering ? GDPR Diagnostic Pack $$ Performance Tibero Performance Repository ? Diagnose performance Tuning Pack $$ Performance Tibero Performance Repository ? Tune queries or the database instance Partitioning $$ Performance + DWH Hash, Range, List, Interval or Composite Partitioning ? Advanced Compression $$ DWH + Storage savings Compression FOR OLTP = Default. ? Hybrid Columnar Compression (HCC only with Exadata) $$$$ DWH + Storage savings Columnar Compression ? Oracle Exadata + HW $$$$ Performance + DWH Predicate Filtering ? DB Gateways (5) + Big Data connectors $$ Data connectivity Heterogeneous DB Links + HDFS/HBase data connectors ? Data Virtualization OLAP $$ DWH OLAP ? Multi-Tenant $$ Manageability Virtual Database ? Larger concept than Multi Tenancy In-Memory $$$ Performance In-Memory ? Costs or Functionality?
6 Example Oracle Exadata HCC Fail => No HA Segment Operations CREATE TABLE ROLI_TEST ( SEV_ID NUMBER NOT NULL, SEV_GPR_ID NUMBER NOT NULL, SEV_POSTTAG_DAT_ID NUMBER NOT NULL) TABLESPACE USERS PARTITION BY RANGE (SEV_POSTTAG_DAT_ID) ( PARTITION DWH_ROLI_2015M01 VALUES LESS THAN (20150201) TABLESPACE USERS, PARTITION DWH_ROLI_2015M02 VALUES LESS THAN (20150301) TABLESPACE USERS, PARTITION DWH_ROLI_2015M03 VALUES LESS THAN (20150401) TABLESPACE USERS); CREATE BITMAP INDEX ROLI_SEV_FK_I ON ROLI_TEST (SEV_ID) LOCAL ( PARTITION DWH_ROLI_2015M01 TABLESPACE USERS, PARTITION DWH_ROLI_2015M02 TABLESPACE USERS, PARTITION DWH_ROLI_2015M03 TABLESPACE USERS); ALTER TABLE ROLI_TEST MOVE PARTITION DWH_ROLI_2015M01 COMPRESS FOR ARCHIVE HIGH TABLESPACE USERS; -- Does it work or fail for you? alter index ROLI_SEV_FK_I MODIFY PARTITION DWH_ROLI_2015M01 unusable; ALTER TABLE ROLI_TEST MOVE PARTITION DWH_ROLI_2015M01 COMPRESS FOR ARCHIVE HIGH TABLESPACE USERS; -- and now? Does it work? alter index ROLI_SEV_FK_I MODIFY PARTITION DWH_ROLI_2015M02 unusable; alter index ROLI_SEV_FK_I MODIFY PARTITION DWH_ROLI_2015M03 unusable; ALTER TABLE ROLI_TEST MOVE PARTITION DWH_ROLI_2015M01 COMPRESS FOR ARCHIVE HIGH TABLESPACE USERS; -- and now? Does it work? alter index ROLI_SEV_FK_I rebuild partition DWH_ROLI_2015M01; alter index ROLI_SEV_FK_I rebuild partition DWH_ROLI_2015M02; alter index ROLI_SEV_FK_I rebuild partition DWH_ROLI_2015M03; alter index ROLI_SEV_FK_I MODIFY PARTITION DWH_ROLI_2015M02 unusable; ALTER TABLE ROLI_TEST MOVE PARTITION DWH_ROLI_2015M02 COMPRESS FOR ARCHIVE HIGH TABLESPACE USERS; -- and now? Does it work? DROP TABLE ROLI_TEST purge;
7 Exadata X7 Oracle 19c APR19 "Latest Patch"
8 Tibero Zeta any Cloud AUG 2018 Patch Due to this di?erence, the customer that spent a lot of money with Exadata, they had to schedule a maintenance window to compress the database but not allowing the operations to continue the same over the a?ected segments. This problem is not a?ecting Tibero Database
9 3 Highly-Available Architecture Types in Tibero DB Shared-Disk Shared-Nothing 2-Tier ● On-Prem ● Disk can be the bottleneck ● Cloud / On-Prem ● Maximum budget savings ● Cloud / On-Prem ● Maximum Elasticity DB Node stands for Read-Write DB Node. Disaster Recovery not included as HA in the architecture diagram above, DR can be 1 or more DB Nodes Read-Only, additional to the nodes above. DB Node DB Node Disk DB Node Disk DB Node Disk DB Node Storage Node DB Node Storage Node Storage Node DB Node Disk
10 Main architectural improvements ● Scalability ● Re-use of threads and resources ● Resource Ef?ciency (+50%) ○ Lightweight + Powerful ● Healthier Non-destructive DB Instance behaviour ● Short Access Time to Clients ● Stable and Robust Performance
11 How is the security without TDE in Oracle Database? Security Tibero uses stronger encryption algorithms since 2016, at no additional cost. SMS4 is the standard mobile encryption in China. Tibero Database helps you comply for GDPR. Encryption Algorithm Tibero 6 Oracle 12c Transparent Data Encryption (TDE) ARIA128 Oracle 18c ARIA192 ARIA256 SEED SMS4 DES 3DES168 AES128 AES192 AES256 SHA-1 MD5 MD4 Image Source: Oracle Security White paper ARIA: Invented by the Korean National Security Research Institute Tibero uses digital signature to strictly detect and block any data manipulation attempts in the TDE (TmaxSoft Patent). Example
12 T-Up “BIGFILE” tablespaces are not supported. Tablespaces should be pre-created before the migration starts, only for this case.
13 Use Cases
14 Flexibility Which Cloud you prefer ? And Containerization tech. ? … Virtualization system ? HP IA64 VM
15 Data Federation >= Data Virtualization Use Cases ● Data Consolidation ● Build a DWH ● Performing a company-wide Data Transformation. ● Tibero includes: ○ Data Modeler Tool ○ Flow Designer ○ Monitoring
16 EDW Reducing ETL Complexity (Staging DB) Sources ETL Tools EDW Staging Configure Maintain Troubleshoot Without Tibero With Tibero Sources ?
17 Building a / Data Lake / EDW + Merging with Big Data Without Tibero Date: 2013-2014 (1 year duration) Budget: 12M EUR in HW (OES = locked-in) + 3M EUR in Services (Oracle) 6 men + LICENSING Costs. + 1 Year contract with Dimensigon (1-man = OES Instructor) With Tibero Date: Now Budget: Not comparable…. Under 500K. + Own HW Duration: Less than few months. 1-2 people involved. Open Source No ETL Tools required ($$) No Big Data Connectors required ($) No Additional Gateway Software to connect to Mainframe required ($$$) OES = Oracle Engineered Systems HW = Hardware
18
19 Some references Worldwide
20 Founded in South Korea, Headquartered in USA, Globally Installed Established 1997 Global Footprint 20 Locations Chicago, IL—HQ Technology Focused +1300 employees (over 80% R&D/technical) Founder Dr. Daeyeon Park US/Global CEO KV Suresh R&D Investment 50%+ of Sales Revenue References +5000 Case Studies

More Related Content

DataEng Mad - 03.03.2020 - Tibero 30-min Presentation.pdf

  • 1. 1
  • 2. 2 Company name Headcount % Developers (source = LinkedIn Premium) Software Developed MariaDB ~210 50 ● MariaDB Enterprise EDB (PostgreSQL) ~400 30 ● EDB Postgres Advanced Server ○ Several extensions adding enterprise functionalities to OSS PostgreSQL 2nd Quadrant (PostgreSQL) >100 70 ● 2ndQ PostgreSQL ○ Several extensions adding enterprise functionalities to OSS PostgreSQL TmaxSoft ~1300 80 ● OpenFrame (Mainframe Rehosting) ● JEUS (Application Server - Weblogic alternative) ● WebtoB (Enterprise Scalable Apache) ● Tmax (Middleware Transaction Manager) ● Tibero (RDBMS - Oracle DB Alternative, Native PL/SQL = PSM) ○ HyperData: ELT Flow designer with Graphs/Dashboards for BI or Data Virtualization ○ SysMaster for Tibero: Monitoring Tool for Tibero. ● ProSync (GoldenGate Alternative) ● AnyLink (Messaging Software, Queueing) ● SysMaster (Enterprise Monitoring) ● Cloud Stack (Private Cloud, Focused on Security, targeted to Government) ● ProLinux (Enterprise Linux for Production environments) ● TmaxOS (End-User Linux, Windows friendly + own Office Suite + own Cloud Collab.) ● TOP (TmaxSoft One Platform = Develop 1 App for any Platform = similar JVM) ● TmaxCDS ("Tmax Cloud Desktop Service" = Virtualized End-User Distributed Comp.) Companies always avoided to deal with small companies because of low reliability. MariaDB, EDB or 2nd Q. could have 2 problems, either they are not re-investing their money into R&D (greediness) or either the Open Source model is not bene?cial for them. Comparing CompaniesUpdated FEB-2020
  • 3. 3
  • 4. 4 Tibero Database ● Designed for Security against any foreign attacks from North Korea, China, Russia and US ● All inclusive licensing model => Higher quality application development ● Lift and Shift => In 90% cases; No need to face a migration. No need to change your PL/SQL. ● Direct replacement for Oracle EE + Exadata => At better cost than Open Source Support fees ● Flexibility => Easy to use with any Cloud, any Virtualization or Containers.
  • 5. 5 Cost Functional Area Availability Often used for Oracle RAC (only EE) $$ High Availability Tibero Active Cluster ? Horizontal Scaling Active Data Guard $$ Disaster Recovery Hot Standby (read-only) ? Advanced Security $$ Security Data Encryption + Network Encryption ? GDPR --- -- Security Protection against Data Tampering ? GDPR Diagnostic Pack $$ Performance Tibero Performance Repository ? Diagnose performance Tuning Pack $$ Performance Tibero Performance Repository ? Tune queries or the database instance Partitioning $$ Performance + DWH Hash, Range, List, Interval or Composite Partitioning ? Advanced Compression $$ DWH + Storage savings Compression FOR OLTP = Default. ? Hybrid Columnar Compression (HCC only with Exadata) $$$$ DWH + Storage savings Columnar Compression ? Oracle Exadata + HW $$$$ Performance + DWH Predicate Filtering ? DB Gateways (5) + Big Data connectors $$ Data connectivity Heterogeneous DB Links + HDFS/HBase data connectors ? Data Virtualization OLAP $$ DWH OLAP ? Multi-Tenant $$ Manageability Virtual Database ? Larger concept than Multi Tenancy In-Memory $$$ Performance In-Memory ? Costs or Functionality?
  • 6. 6 Example Oracle Exadata HCC Fail => No HA Segment Operations CREATE TABLE ROLI_TEST ( SEV_ID NUMBER NOT NULL, SEV_GPR_ID NUMBER NOT NULL, SEV_POSTTAG_DAT_ID NUMBER NOT NULL) TABLESPACE USERS PARTITION BY RANGE (SEV_POSTTAG_DAT_ID) ( PARTITION DWH_ROLI_2015M01 VALUES LESS THAN (20150201) TABLESPACE USERS, PARTITION DWH_ROLI_2015M02 VALUES LESS THAN (20150301) TABLESPACE USERS, PARTITION DWH_ROLI_2015M03 VALUES LESS THAN (20150401) TABLESPACE USERS); CREATE BITMAP INDEX ROLI_SEV_FK_I ON ROLI_TEST (SEV_ID) LOCAL ( PARTITION DWH_ROLI_2015M01 TABLESPACE USERS, PARTITION DWH_ROLI_2015M02 TABLESPACE USERS, PARTITION DWH_ROLI_2015M03 TABLESPACE USERS); ALTER TABLE ROLI_TEST MOVE PARTITION DWH_ROLI_2015M01 COMPRESS FOR ARCHIVE HIGH TABLESPACE USERS; -- Does it work or fail for you? alter index ROLI_SEV_FK_I MODIFY PARTITION DWH_ROLI_2015M01 unusable; ALTER TABLE ROLI_TEST MOVE PARTITION DWH_ROLI_2015M01 COMPRESS FOR ARCHIVE HIGH TABLESPACE USERS; -- and now? Does it work? alter index ROLI_SEV_FK_I MODIFY PARTITION DWH_ROLI_2015M02 unusable; alter index ROLI_SEV_FK_I MODIFY PARTITION DWH_ROLI_2015M03 unusable; ALTER TABLE ROLI_TEST MOVE PARTITION DWH_ROLI_2015M01 COMPRESS FOR ARCHIVE HIGH TABLESPACE USERS; -- and now? Does it work? alter index ROLI_SEV_FK_I rebuild partition DWH_ROLI_2015M01; alter index ROLI_SEV_FK_I rebuild partition DWH_ROLI_2015M02; alter index ROLI_SEV_FK_I rebuild partition DWH_ROLI_2015M03; alter index ROLI_SEV_FK_I MODIFY PARTITION DWH_ROLI_2015M02 unusable; ALTER TABLE ROLI_TEST MOVE PARTITION DWH_ROLI_2015M02 COMPRESS FOR ARCHIVE HIGH TABLESPACE USERS; -- and now? Does it work? DROP TABLE ROLI_TEST purge;
  • 7. 7 Exadata X7 Oracle 19c APR19 "Latest Patch"
  • 8. 8 Tibero Zeta any Cloud AUG 2018 Patch Due to this di?erence, the customer that spent a lot of money with Exadata, they had to schedule a maintenance window to compress the database but not allowing the operations to continue the same over the a?ected segments. This problem is not a?ecting Tibero Database
  • 9. 9 3 Highly-Available Architecture Types in Tibero DB Shared-Disk Shared-Nothing 2-Tier ● On-Prem ● Disk can be the bottleneck ● Cloud / On-Prem ● Maximum budget savings ● Cloud / On-Prem ● Maximum Elasticity DB Node stands for Read-Write DB Node. Disaster Recovery not included as HA in the architecture diagram above, DR can be 1 or more DB Nodes Read-Only, additional to the nodes above. DB Node DB Node Disk DB Node Disk DB Node Disk DB Node Storage Node DB Node Storage Node Storage Node DB Node Disk
  • 10. 10 Main architectural improvements ● Scalability ● Re-use of threads and resources ● Resource Ef?ciency (+50%) ○ Lightweight + Powerful ● Healthier Non-destructive DB Instance behaviour ● Short Access Time to Clients ● Stable and Robust Performance
  • 11. 11 How is the security without TDE in Oracle Database? Security Tibero uses stronger encryption algorithms since 2016, at no additional cost. SMS4 is the standard mobile encryption in China. Tibero Database helps you comply for GDPR. Encryption Algorithm Tibero 6 Oracle 12c Transparent Data Encryption (TDE) ARIA128 Oracle 18c ARIA192 ARIA256 SEED SMS4 DES 3DES168 AES128 AES192 AES256 SHA-1 MD5 MD4 Image Source: Oracle Security White paper ARIA: Invented by the Korean National Security Research Institute Tibero uses digital signature to strictly detect and block any data manipulation attempts in the TDE (TmaxSoft Patent). Example
  • 12. 12 T-Up “BIGFILE” tablespaces are not supported. Tablespaces should be pre-created before the migration starts, only for this case.
  • 14. 14 Flexibility Which Cloud you prefer ? And Containerization tech. ? … Virtualization system ? HP IA64 VM
  • 15. 15 Data Federation >= Data Virtualization Use Cases ● Data Consolidation ● Build a DWH ● Performing a company-wide Data Transformation. ● Tibero includes: ○ Data Modeler Tool ○ Flow Designer ○ Monitoring
  • 16. 16 EDW Reducing ETL Complexity (Staging DB) Sources ETL Tools EDW Staging Configure Maintain Troubleshoot Without Tibero With Tibero Sources ?
  • 17. 17 Building a / Data Lake / EDW + Merging with Big Data Without Tibero Date: 2013-2014 (1 year duration) Budget: 12M EUR in HW (OES = locked-in) + 3M EUR in Services (Oracle) 6 men + LICENSING Costs. + 1 Year contract with Dimensigon (1-man = OES Instructor) With Tibero Date: Now Budget: Not comparable…. Under 500K. + Own HW Duration: Less than few months. 1-2 people involved. Open Source No ETL Tools required ($$) No Big Data Connectors required ($) No Additional Gateway Software to connect to Mainframe required ($$$) OES = Oracle Engineered Systems HW = Hardware
  • 18. 18
  • 20. 20 Founded in South Korea, Headquartered in USA, Globally Installed Established 1997 Global Footprint 20 Locations Chicago, IL—HQ Technology Focused +1300 employees (over 80% R&D/technical) Founder Dr. Daeyeon Park US/Global CEO KV Suresh R&D Investment 50%+ of Sales Revenue References +5000 Case Studies