Database creation methods, devices, equipment and media

By using the automated database creation method of the ShardingSphere agent server, the problems of low resource cleanup efficiency and high manual costs in the ShardingSphere database creation process are solved, and the automation and consistency of database creation are achieved.

CN122086864APending Publication Date: 2026-05-26BEIJING KINGSOFT CLOUD NETWORK TECH CO LTD
View PDF 0 Cites 0 Cited by

Patent Information

Authority / Receiving Office
CN · China
Patent Type
Applications(China)
Current Assignee / Owner
BEIJING KINGSOFT CLOUD NETWORK TECH CO LTD
Filing Date
2026-02-06
Publication Date
2026-05-26

AI Technical Summary

Technical Problem

In the ShardingSphere database creation process, there is a lack of transaction guarantees between creating sub-databases, creating logical databases, and creating data sources. This results in resources not being automatically reclaimed when creation fails, requiring manual cleanup, which is costly, inefficient, and complicated for client operations.

Method used

The ShardingSphere agent server receives database creation commands, checks database status and residual information, automatically cleans up residual information before creating the database, and only performs the creation operation when the status is offline and there is no residual information, thus achieving automated database creation.

Benefits of technology

It improves the efficiency of database creation and cleanup, reduces labor costs, simplifies the operation process, and ensures the smoothness and consistency of database creation.

✦ Generated by Eureka AI based on patent content.

Smart Images

  • Figure CN122086864A_ABST
    Figure CN122086864A_ABST
Patent Text Reader

Abstract

This disclosure relates to a database creation method, apparatus, device, and medium. The database creation method is applied to a ShardingSphere agent server and includes: receiving a first database creation command sent by a client; if, based on the identifier of a first database to be created in the first database creation command, it is determined that no logical database corresponding to the first database to be created exists, and if the status information corresponding to the first database to be created is offline and residual information exists, performing a deletion operation on the residual information, and if the deletion of the residual information is successful, performing a creation operation on the first database to be created; or, if the status information corresponding to the first database to be created is not offline, marking the status information corresponding to the first database to be created as offline and performing a creation operation on the first database to be created. This automatically achieves resource cleanup and reclamation, improves cleanup efficiency, and reduces labor costs.
Need to check novelty before this filing date? Find Prior Art