OceanBase Database allows you to insert data into a database by using direct load. In other words, OceanBase Database can directly write data to data files. Direct load allows you to bypass SQL layer interfaces and directly allocate space and insert data into data files, thereby improving data import efficiency.
Scenarios
You can use direct load in the following scenarios:
Data migration and synchronization. When you migrate and synchronize a large amount of data of various formats from different data sources to OceanBase Database, the performance of traditional SQL interfaces may not meet the requirements in terms of timeliness.
Traditional ETL. After data is extracted and transformed in the source, a large amount of data needs to be loaded to the destination within a short time. Direct load can improve data import performance. In the data loading process of ETL, direct load can also improve efficiency.
Load data from text files or other data sources to OceanBase Database. Direct load can improve data loading efficiency.
Supported statements
OceanBase Database allows you to use the following statements for direct load:
Considerations
Direct load writes all existing data. If the original table contains a large amount of data, but only a small amount of data is to be imported, direct load may not be suitable.