Document Type | Technical Information
Category | Interface/Integration
Applicable Product Version | 7FS02PS
Document Number | TIITI069
Overview
This document serves as a reference for comparing the major functionality support of TIBERO7 and CUBRID11 based on Oracle 23c.
The comparison items include key features necessary for DBMS operation review such as transactions, SQL extensions, high performance, high availability, large data processing, security, maintenance efficiency, integration/interoperability, reliability, and scalability.
For each item, Oracle 23c is set as the baseline, and the support status of TIBERO7 and CUBRID11 is categorized as O / △ / X / -.
This can be used as a reference for product adoption review, heterogeneous DBMS comparison, feature gap analysis, and integration feasibility evaluation.
Method
Function Comparison Table
DBMS Technical Comparison Table (Maximized Column Spacing)
| Number | Check Item | Technical Description | Technology Name | ORACLE 23 | TIBERO 7 | CUBRID 11 |
|---|---|---|---|---|---|---|
| 1 | 1. Complex Transaction Support Capability | Transaction support capability based on relational model | Acid Support | O | O | O |
| 2 | Row-Level Locking | O | O | O | ||
| 3 | MVCC Support | O | O | O | ||
| 4 | Relational Data Types and Data Type Support | Multi Model database (RDB, Image, Text, Spatial, Graph, JSON, Blockchain, etc.) | O | △ | △ | |
| 5 | 2. SQL Language Extensions | SQL language extension programming | PL/SQL | O | O | X |
| 6 | Java Stored Procedure | O | O | O | ||
| 7 | C Stored Procedure | O | O | X | ||
| 8 | 3. High Performance | Comparison of various analytic functions and SQL support capability | Analytics / Window SQL | O | O | O |
| 9 | Real-time analysis and mixed workload performance improvement with In-Memory DB | In-Memory Column Store (Dual format provided for single object) | O | O | X | |
| 10 | High performance support using latest persistent memory such as Intel Optane Persistent Memory (PMEM) | Use of PMEM in In Memory Store | O | X | X | |
| 11 | PMEM Filestore (data file storage) | O | X | X | ||
| 12 | Optimized hardware support for large-scale, high-performance data processing | Oracle Exadata | O | O | X | |
| 13 | 4. High Availability | Support for own cluster software | Oracle Clusterware | O | O | X |
| 14 | Active-Active cluster support | Oracle Real Application Clusters | O | O | X | |
| 15 | DB HA configuration capability | Application Continuity (Recovers DML operations running in RAC, ADG environments on unplanned server failures to prevent application interruption) | O | X | X | |
| 16 | Oracle RAC One Node | O | O | X | ||
| 17 | DB DR configuration capability | Oracle Data Guard (Sync, Async block replication, automated Switch Over provided) | O | O | O | |
| 18 | Active Data Guard (Operate standby DB for queries/statistics, 19c supports DML – Primary Redirection) | O | △ | O | ||
| 19 | Service continuity 365*24 without restart | 24*365 service support (Add/remove nodes without downtime) | O | O | O | |
| 20 | 5. Large Data Processing | Parallel processing technology for large data and performance improvement | Parallel query/DML | O | O | X |
| 21 | Parallel statistics gathering | O | O | O | ||
| 22 | Parallel Index build/scans | O | O | X | ||
| 23 | Partitioning technology for large data management and performance improvement | Range Partition | O | O | O | |
| 24 | List Partition | O | O | O | ||
| 25 | Hash Partition | O | O | O | ||
| 26 | Composite partition | O | O | X | ||
| 27 | Interval Partition | O | O | X | ||
| 28 | REF partition | O | △ | X | ||
| 29 | Partition pruning | O | O | O | ||
| 30 | Partition wise join (automatic) | O | O | X | ||
| 31 | Local partitioned Index | O | O | O | ||
| 32 | Global partitioned Index | O | O | O | ||
| 33 | Global Non-partitioned Index | O | O | X | ||
| 34 | ILM technology for large data management and performance improvement | Heat Map | O | X | X | |
| 35 | Automatic Data Optimization (automates compression and movement between different storage tiers within the database) | O | X | X | ||
| 36 | Compression technology for big data management and performance improvement | Basic Table Compression | O | O | O | |
| 37 | Oracle Advanced Compression | O | O | X | ||
| 38 | 6. Security | Access audit functionality for information | Fine-grained Auditing | O | O | X |
| 39 | Security policies controlling database access at row and column levels | Virtual Private Database | O | O | X | |
| 40 | DBMS native data encryption capability | Transparent Data Encryption (TDE) (ASO feature) | O | O | O | |
| 41 | DBMS native data access control capability | Oracle Database Vault | O | △ | X | |
| 42 | DBMS native dynamic data masking capability | Data Redaction (ASO feature) | O | O | X | |
| 43 | DBMS native data masking capability | Data Masking | O | O | X | |
| 44 | Sensitive information native access control capability | Oracle Label Security | O | O | X | |
| 45 | Self database security assessment and reporting | DB Assessment Tool (DBSAT) | O | X | X | |
| 46 | 7. DB Maintenance Efficiency | Logical volume manager for storage on data repositories, universal shared file system provision, and automated management | Automatic Storage Management (ASM) | O | O | X |
| 47 | ASM Cluster File System | O | X | X | ||
| 48 | Automatic Segment space management | O | O | O | ||
| 49 | Logical database consolidation capability for multiple databases and efficient resource control among multiple instances | Multitenant | O | X | X | |
| 50 | Database Resource Manager | O | △ | X | ||
| 51 | IO Resource Manager (*Exadata) | O | △ | X | ||
| 52 | Automated management for data indexing | Automatic Indexing | O | X | X | |
| 53 | Automated management for DB Undo | Automatic Undo Management | O | O | O | |
| 54 | Online management for data indexing | Oracle Index rebuild | O | O | X | |
| 55 | Online management for data structures | Oracle table redefinition | O | △ | X | |
| 56 | DB performance and issue diagnostics | Oracle Diagnostic Pack - ADDM | O | X | X | |
| 57 | Oracle Diagnostic Pack - AWR | O | O | X | ||
| 58 | Oracle Diagnostic Pack - ASH | O | O | X | ||
| 59 | Oracle Tuning Pack - SQL Tuning Advisor | O | △ | X | ||
| 60 | Oracle Tuning Pack - SQL Profiles | O | O | O | ||
| 61 | Oracle Tuning Pack - SQL Access Advisor | O | X | X | ||
| 62 | SQL Plan Manager | O | O | O | ||
| 63 | Pre-impact diagnosis function during DB integration | O | O | O | ||
| 64 | Possession of GUI management tools | O | O | O | ||
| 65 | DB backup time reduction technology | O | O | O | ||
| 66 | Technology for fast DB recovery | Block-level media recovery | O | O | O | |
| 67 | Tablespace point-in-time recovery | O | O | O | ||
| 68 | Table-level point-in-time recovery | O | X | X | ||
| 69 | Trial Recovery | O | X | X | ||
| 70 | 8. H/W Compatibility | Support for various H/W vendors and robust cluster environment configuration and support capability | Oracle RAC implementation examples from various H/W vendors | O | O | X |
| 71 | 9. Integration/Interoperability | Support for latest international standards for external institution integration and advanced technology application | Latest (SQL 201x) international standard support | O | - | △ |
| 72 | SQL-2016 : Oracle 12cR2 ~ 19c | O | △ | △ | ||
| 73 | SQL-2011 : Oracle 12cR1 | O | △ | △ | ||
| 74 | SQL-2008 : Oracle 11gR2 | O | △ | △ | ||
| 75 | SQL-2023 : Oracle 23c | O | X | △ | ||
| 76 | Necessary technology for internal and external services and integration | Graph store/Index support | O | X | X | |
| 77 | JSON / Index support | O | O | △ | ||
| 78 | XML DB model and Index support | O | O | X | ||
| 79 | REST API support (Oracle REST Data Services) | O | X | X | ||
| 80 | Support for data linkage between internal DBs | DB Link / ODBC | O | O | O | |
| 81 | Support for data linkage between heterogeneous DBMS | DB Gateway / OGG | O | O | X | |
| 82 | 10. Technical Support | Product technical support by specialized partners and manufacturers | Oracle ACS and specialized partners | - | - | - |
| 83 | Completeness of product manuals and Internet web surfing, user community support | Oracle Manual, Oracle User Group, etc. | - | - | - | |
| 84 | 11. 3rd Party Support Capability | Support for domestic and international DBMS and related 3rd party products | Provides many domestic and international ISV solutions and mutual product certification matrix | - | - | - |
| 85 | Information system market (development) preference comparison | Possession of preference evaluation data and excellence in evaluation | - | - | - | |
| 86 | 12. Reliability and Protection Capability | Data recovery technology against user/administrator errors | Flashback query | O | O | O |
| 87 | Table-level data recovery technology against user/administrator errors | Flashback Table | O | O | X | |
| 88 | Instance-level data recovery technology against user/administrator errors | Flashback database | O | O | X | |
| 89 | Data recovery/tracking technology against user/administrator errors or malicious manipulation | Flashback Transaction | O | X | X | |
| 90 | Flashback Transaction query | O | X | X | ||
| 91 | 13. 4th Industrial Revolution Technology Support and Scalability | AI/ML platform support for integration of 4th industrial revolution innovative technologies | In-DB Machine learning | O | X | X |
| 92 | In-DB R analytics | O | X | X | ||
| 93 | Column store-based analytics support (In-memory option) | O | O | X | ||
| 94 | IoT data collection capability for integration of 4th industrial revolution innovative technologies | Memoptimized Rowstore | O | X | X | |
| 95 | Blockchain technology-based data management capability for 4th industrial revolution innovative technologies (MSA) | Blockchain storage dedicated table | O | X | X | |
| 96 | Multi-tenant | O | X | △ | ||
| 97 | Support capability for infrastructure construction based on cloud technology | Database management API provision (Schema, PDB) | O | X | X | |
| 98 | Fleet Patching & Provisioning (Lifecycle management of large-scale database deployment) | O | X | X | ||
| 99 | Enterprise Manager Cloud Control | O | △ | X | ||
| 100 | Blockchain type technology support for 4th industrial revolution innovative technology integration | Blockchain Table (tamper-proof table for transactions, tracking functionality) | O | X | X | |
| 101 | Support for location and geographic information analysis platform for 4th industrial revolution innovative technology integration | Spatial (2D, 3D) analytics and CityGML support | O | △ | X | |
| 102 | GeoRaster (3D, 2D) processing (orthorectification, band merge, mosaic, etc.) | O | X | X | ||
| 103 | Intuitive data correlation and information analysis platform support for 4th industrial revolution innovative technology integration | Graph store/Index support | O | X | X | |
| 104 | Big data integration platform (data virtualization) support | Big Data SQL | O | △ | X |
Summary of Entire Document
This document is a technical information document comparing the major functionality support of TIBERO7 and CUBRID11 based on Oracle 23c.
Support levels are organized based on major items such as transactions, SQL extensions, performance, availability, large data processing, security, maintenance, interoperability, recovery, and scalability, and it is structured to allow comparison of support, partial support, and non-support for each function.