The storage data structure of OceanBase is made depending on LSM-Tree, which is analogous into the solution of LevelDB. The information modification is very first recorded in MemTable (dynamic information in memory) utilizing joined listing, and the head is connected to the corresponding block in block cache.
It's designed and optimized for OLTP apps on relational structured info, nevertheless its shared-nothing at all structure also supports OLAP apps.
With the standpoint of resource administration, Just about every databases occasion is regarded as a tenant in OceanBase. Each tenant is allotted that has a device pool that contains models. Every unit is a group of computation and storage resource on ObServers. Just about every tenant has at most just one device on one particular ObServer.
OceanBase supports overseas crucial to constrain info consistency, which is an important edge as compared to all kinds of other dispersed DBMS. Overseas critical reference is outlined when building new table schema.
The online DDL element presents help for instant As well as in-position desk alterations and concurrent DML. Advantages of this attribute consist of:
OceanBase supports standard SQL query interface, while you can find slight distinctions in OceanBase implementation.
Immediately after compaction the merged Zone warms the cache. When being forced to merge details through peak period, OceanBase adopts this algorithm. This algorithm is orthogonal to slight compaction and main compaction and will be used in combination with one of these.
Renaming a desk can be performed immediately or set up. MySQL renames data files that correspond on the desk tbl_name
OceanBase supports typical SQL query interface, however you will find slight distinctions in OceanBase implementation.
It is actually designed and optimized for OLTP applications on relational structured data, nevertheless its shared-practically nothing structure also supports OLAP programs.
OceanBase is actually a higher-effectiveness database compatible with both of those MySQL and Oracle protocols. This repository provides the following plugins to help you builders address prevalent compatibility concerns in serious-planet applications:
Do options that enhance Velocity utilize retroactively when attaining a new Distinctive Speed? extra scorching thoughts
Operate: A Dify plugin for connecting to and querying OceanBase databases. This challenge continues to be migrated to a different repository.
OceanBase implements block cache for Micro Block to accelerate big scan question. It also implements a row cache for rows 金融行业SQL方言转换方案 in block cache to accelerate little get question.