Database field dynamic extension method and device, equipment and storage medium

Abstract

The invention relates to the field of cloud storage, and discloses a database field dynamic extension method and device, equipment and a storage medium. The method comprises the following steps: analyzing a data table of a relational database associated with a target system by utilizing a machine learning model so as to determine a to-be-expanded data table in the data table of the relational database; obtaining a primary key of the to-be-expanded data table; obtaining a demand document of the extension component; determining a field name of a target field to be expanded according to the content of the demand document; and by taking the primary key as a unique field, creating an extended data table corresponding to the target field in the relational database based on the field name of thetarget field so as to store data corresponding to the target field. The invention also relates to the field of blockchains, and the demand document can be stored in the blockchain. According to the method, efficient extension of the fields of the relational database is achieved, so the efficient dynamic field extension capacity required by large projects is provided.

Description

technical field [0001] The present disclosure relates to the technical field of cloud storage, and in particular to a method, device, device and storage medium for dynamically expanding database fields. Background technique [0002] Relational databases such as Mysql are widely used in a large number of projects due to their advantages of safety, reliability, excellent performance, and stable service. However, relational databases generally have a fixed table structure, and it is not easy to expand fields when using relational databases. In particular, it is even more difficult to expand fields while avoiding a decline in database usage efficiency. At present, large-scale and complex projects often have multiple businesses and often require field expansion. Therefore, traditional relational databases are inconvenient to expand fields, and cannot efficiently and quickly expand fields to meet the needs of large-scale projects. Contents of the invention [0003] In the techn...

AI Technical Summary

Problems solved by technology

However, relational databases generally have a fixed table structure, and it is not easy to expand fields when using relational databases, especially when expanding fields while avoiding the decline in database usage efficiency.

At present, large and complex projects often have multiple businesses and often have the need to expand fields. Therefore, traditional relational databases are inconvenient to expand fields, and cannot efficiently and quickly expand fields to meet the needs of large projects.

Images