CN116955314A - Unified database maintenance and control methods, devices, equipment and storage media - Google Patents

Abstract

The application discloses a method, a device, equipment and a storage medium for unified maintenance and control of a database, which relate to the technical field of databases and comprise the following steps: configuring a mapping relation between metadata, storing the mapping relation into a metadata base, and synchronizing the mapping relation to a computing node; inputting SQL sentences; the computing node analyzes metadata information in the SQL sentence, generates a grammar tree, updates the grammar tree according to the locally stored metadata mapping relation, generates an execution tree according to the grammar tree, and executes the SQL sentence according to the execution tree. According to the method, the mapping relation is added to metadata information in tenants to achieve logical unification of metadata, then the syntax analysis module is used for analyzing the metadata information in SQL sentences, metadata information conversion is completed according to the mapping relation, and finally the syntax execution module is used for completing execution of the SQL sentences, so that the problem of metadata compatibility after upgrading of a database version can be solved, and the practicability is improved while the compatibility cost is reduced.

Description

Unified database maintenance and control methods, devices, equipment and storage media

Technical field

The present invention relates to the field of database technology, and in particular to a method, device, equipment and storage medium for unified maintenance and control of a database.

Background technique

The database system contains multiple tenants, and each tenant contains multiple database tables. As the database version is updated iteratively, the original database table structure in each tenant needs to be modified to achieve compatibility. At the same time, the SQL statements within the tenant are complex and are not limited to single-table operations, but also include a large number of related table operations. At present, the industry is basically transforming its business, which will lead to high business transformation costs.

Contents of the invention

The technical problem to be solved by the present invention is to overcome the shortcomings of the existing technology and provide a unified maintenance and control method, device, equipment and storage medium for a database.

In order to solve the above technical problems, the technical solutions of the present invention are as follows:

The present invention provides a method for unified maintenance and control of a database, which includes:

Configure the mapping relationship between metadata, save it in the metadata database, and synchronize it to the computing node;

Enter the SQL statement;

The computing node parses the metadata information in the SQL statement, generates a syntax tree, updates the syntax tree based on the locally stored metadata mapping relationship, then generates an execution tree based on the syntax tree, and executes the SQL statement based on the execution tree.

The invention also provides a unified database maintenance and control device, which includes:

The unified maintenance module is used to configure the mapping relationship between metadata and save it to the metadata management module;

The metadata management module is used to save all metadata information in the database and synchronize the mapping relationships between metadata in the metadata database to the computing nodes;

The computing node module is used to parse the metadata information in the SQL statement, generate a syntax tree, update the syntax tree based on the locally stored metadata mapping relationship, then generate an execution tree based on the syntax tree, and execute the SQL statement based on the execution tree.

The present invention also provides a computer device, including a memory, a processor and a computer program stored in the memory and executable on the processor. When the processor executes the program, the above-mentioned database unification is realized. Methods of maintenance and control.

The present invention also provides a computer-readable storage medium on which a computer program is stored. When the program is executed by a processor, the above-mentioned method for unified maintenance and control of the database is implemented.

The beneficial effects of the present invention are:

This invention first realizes the logical unification of metadata by adding a mapping relationship to the metadata information in the tenant, and then parses the metadata information in the SQL statement through the grammar parsing module, and then completes the metadata information conversion according to the mapping relationship, and finally uses the grammar The execution module completes the execution of SQL statements, which can solve the problem of metadata compatibility after database version upgrade. Users are not aware of it during the entire implementation process, and it does not affect the normal execution of the business. It reduces compatibility costs while improving practicality.

Description of the drawings

In order to explain the technical solutions of the embodiments of the present invention more clearly, the drawings needed to be used in the description of the embodiments will be briefly introduced below. Obviously, the drawings in the following description are only some embodiments of the present invention. Those of ordinary skill in the art can also obtain other drawings based on these drawings without exerting any creative effort.

Figure 1 is a schematic flow chart of the unified database maintenance and control method provided by the present invention;

Figure 2 is a schematic structural diagram of the unified database maintenance and control device provided by the present invention;

Figure 3 is a work flow chart of the syntax parsing module in the unified database maintenance and control device provided by the present invention;

Figure 4 is a work flow chart of the syntax execution module in the unified database maintenance and control device provided by the present invention;

Figure 5 is a schematic diagram of the computer equipment provided by the present invention.

Detailed ways

In order to make the content of the present invention easier to understand clearly, the present invention will be described in further detail below based on specific embodiments and in conjunction with the accompanying drawings.

The invention provides a method, device, equipment and storage medium for unified maintenance and control of a database. By adding mapping relationships to the metadata information (table names, field names) within the tenant, the metadata is logically unified. Secondly, the metadata information in the SQL statement is parsed through the syntax parsing module, and then the metadata information is converted according to the mapping relationship. Finally, the execution of the SQL statement is completed through the syntax execution module. Therefore, the technical solutions of the embodiments of the present invention can solve the problem of metadata compatibility after database version upgrade. Users are not aware of the problem during the entire implementation process, and do not affect the normal execution of the business, thereby reducing compatibility costs while improving practicability.

The present invention will be further described below in conjunction with the accompanying drawings.

Referring to Figure 1, the embodiment of the present application provides a method for unified maintenance and control of a database. The method includes steps S101 to S103. The specific steps are described as follows:

Step S101: Configure the mapping relationship between metadata, save it in the metadata database, and synchronize it to the computing node.

Specifically, first, configure the mapping relationship between metadata through the unified maintenance module, and then save it to the metadata database. If the save fails, a warehousing exception will be reported. If the save is successful, the mapping relationship between metadata will be synchronized to each computing node. After receiving the mapping relationship between metadata, each computing node saves the mapping relationship in local metadata.

Step S102: Enter the SQL statement.

It can be understood that the above input SQL statement is to input the SQL statement to the database backend.

Step S103: The computing node parses the metadata information in the SQL statement, generates a syntax tree, updates the syntax tree based on the locally stored metadata mapping relationship, then generates an execution tree based on the syntax tree, and executes the SQL statement based on the execution tree.

Specifically, after the database backend receives the input SQL statement, first, each computing node will parse the SQL statement and generate the corresponding syntax tree.

It should be noted that if the entered SQL statement is incorrect, or the entered SQL statement is an unsupported statement, parsing cannot be performed and the metadata information in the SQL cannot be obtained. In this case, a parsing failure will be reported. If parsed successfully, the metadata information in SQL can be obtained and the mapping relationship between the corresponding field names and table names can be generated.

After completing the parsing of the SQL statement and the generation of the syntax tree, each computing node will search for the locally stored metadata mapping relationship to determine whether there is a corresponding mapping relationship between table names and field names. If so, it will use the locally stored metadata mapping relationship. The relationship generates a new syntax tree, and then generates an execution tree based on the new syntax tree; if not, the corresponding execution tree is directly generated based on the previously generated syntax tree.

After generating the execution tree, each computing node executes the SQL statement.

Therefore, the above method can achieve logically unified new table names and new field names for the original table names and field names in the tenant without changing the library table structure, thereby greatly reducing compatibility costs.

In order to implement the methods of the embodiments of the present application, based on the unified inventive concept, the embodiments of the present application also provide a unified database maintenance and control device. Figure 2 is a schematic structural diagram of a unified database maintenance and control device in an embodiment of the present application.

As shown in 2, the unified database maintenance and control device specifically includes a unified maintenance module 201, a metadata management module 202, and a computing node module 203.

The unified maintenance module 201 is used to configure the mapping relationship between metadata and save it to the metadata management module. In this embodiment, the unified maintenance module 201 is a web-side management platform that is responsible for registering the mapping relationship between configuration metadata.

The metadata management module 202 is used to save all metadata information in the database and synchronize the mapping relationships between metadata in the metadata database to the computing nodes.

The computing node module 203 is used to parse the metadata information in the SQL statement, generate a syntax tree, update the syntax tree according to the locally stored metadata mapping relationship, then generate an execution tree based on the syntax tree, and execute the SQL statement based on the execution tree.

Among them, the computing node module 203 includes a grammar parsing module and a grammar execution module. After receiving the SQL statement at the database backend, the syntax parsing module obtains the metadata information (table name, field name) in the SQL statement, generates a syntax tree, and then converts it into a new syntax tree based on the locally stored mapping relationship. See Figure 3 for the workflow diagram of the syntax parsing module. The syntax execution module is responsible for generating execution trees and executing SQL statements according to the mapping relationship. The workflow diagram of the syntax execution module is shown in Figure 4.

Referring to Figure 5, this embodiment also provides a computer device. The components of the computer device may include but are not limited to: one or more processors or processing units, system memory, connecting different system components (including system memory and processing units) bus.

A bus represents one or more of several types of bus structures, including a memory bus or memory controller, a peripheral bus, a graphics acceleration port, a processor, or a local bus using any of a variety of bus structures. For example, these architectures include, but are not limited to, the Industry Standard Architecture (ISA) bus, the Micro Channel Architecture (MAC) bus, the Enhanced ISA bus, the Video Electronics Standards Association (VESA) local bus, and the Peripheral Component Interconnect ( PCI) bus.

Computer systems/servers typically include a variety of computer system readable media. These media can be any available media that can be accessed by the computer system/server, including volatile and non-volatile media, removable and non-removable media.

System memory may include computer system readable media in the form of volatile memory, such as random access memory (RAM) and/or cache memory. Computer equipment may further include other removable/non-removable, volatile/non-volatile computer system storage media. By way of example only, the storage system may be used to read and write non-removable, non-volatile magnetic media. Disk drives may be provided for reading and writing from removable non-volatile disks (such as "floppy disks") and for reading and writing from removable non-volatile optical disks (such as CD-ROM, DVD-ROM or other optical media) CD-ROM drive. In these cases, each drive can be connected to the bus through one or more data media interfaces. The memory may include at least one program product having a set of (eg, at least one) program modules configured to perform the functions of embodiments of the invention.

A program/utility having a set of (at least one) program modules, which may be stored, for example, in memory, such program modules including but not limited to an operating system, one or more application programs, other program modules, and program data , each of these examples or some combination may include the implementation of a network environment. Program modules generally perform functions and/or methods in the described embodiments of the invention.

The computer device may also communicate with one or more external devices (eg, keyboard, pointing device, display, etc.). This communication can occur through input/output (I/O) interfaces. Furthermore, the computer device may also communicate with one or more networks (eg, a local area network (LAN), a wide area network (WAN), and/or a public network, such as the Internet) through a network adapter.

The processing unit executes the functions and/or methods in the described embodiments of the present invention by running programs stored in the system memory.

The above-mentioned computer program can be provided in a computer storage medium, that is, the computer storage medium is encoded with a computer program. When the program is executed by one or more computers, it causes one or more computers to execute what is shown in the above-mentioned embodiments of the present invention. method flow and/or device operation.

With the development of time and technology, the meaning of media has become more and more extensive. The spread of computer programs is no longer limited to tangible media, and can also be downloaded directly from the Internet. Any combination of one or more computer-readable media may be employed. The computer-readable medium may be a computer-readable signal medium or a computer-readable storage medium. The computer-readable storage medium may be, for example, but is not limited to, an electrical, magnetic, optical, electromagnetic, infrared, or semiconductor system, apparatus or device, or any combination thereof. More specific examples (non-exhaustive list) of computer readable storage media include: electrical connections having one or more conductors, portable computer disks, hard drives, random access memory (RAM), read only memory (ROM), Erasable programmable read-only memory (EPROM or flash memory), optical fiber, portable compact disk read-only memory (CD-ROM), optical storage device, magnetic storage device, or any suitable combination of the above. As used herein, a computer-readable storage medium may be any tangible medium that contains or stores a program for use by or in connection with an instruction execution system, apparatus, or device.

A computer-readable signal medium may include a data signal propagated in baseband or as part of a carrier wave carrying computer-readable program code therein. Such propagated data signals may take a variety of forms, including - but not limited to - electromagnetic signals, optical signals, or any suitable combination of the above. A computer-readable signal medium may also be any computer-readable medium other than a computer-readable storage medium that can send, propagate, or transmit a program for use by or in connection with an instruction execution system, apparatus, or device .

Program code embodied on a computer-readable medium may be transmitted using any appropriate medium, including but not limited to wireless, wireline, optical fiber cable, RF, etc., or any suitable combination of the foregoing.

Computer program code for performing the operations of the present invention may be written in one or more programming languages, including object-oriented programming languages such as Java, Smalltalk, C++, and conventional Procedural programming language—such as "C" or a similar programming language. The program code may execute entirely on the user's computer, partly on the user's computer, as a stand-alone software package, partly on the user's computer and partly on a remote computer or entirely on the remote computer or server. In situations involving remote computers, the remote computer can be connected to the user's computer through any kind of network, including a local area network (LAN) or a wide area network (WAN), or it can be connected to an external computer (such as an Internet service provider through the Internet). connect).

In addition to the above-mentioned embodiments, the present invention can also have other implementations; any technical solutions formed by equivalent substitutions or equivalent transformations fall within the protection scope of the present invention.

Claims (9)

1. A method for unified database maintenance and control, which is characterized by: including: Configure the mapping relationship between metadata, save it in the metadata database, and synchronize it to the computing node; Enter the SQL statement; The computing node parses the metadata information in the SQL statement, generates a syntax tree, updates the syntax tree based on the locally stored metadata mapping relationship, then generates an execution tree based on the syntax tree, and executes the SQL statement based on the execution tree. 2. The unified database maintenance and control method according to claim 1, characterized in that: configuring the mapping relationship between metadata, saving it in the metadata database, and synchronizing it to the computing node includes: Configure the mapping relationship between metadata; Save the configured mapping relationship between metadata to the metadata database. If the saving fails, a storage exception will be reported. If the saving is successful, the mapping relationship between metadata will be synchronized to the computing node. 3. The unified database maintenance and control method according to claim 1, characterized in that: after the mapping relationship between the configuration metadata is saved in the metadata database and synchronized to the computing node, it also includes: The computing node loads the mapping relationship between metadata into local metadata information. 4. The unified database maintenance and control method according to claim 1, characterized in that: the computing node parses the metadata information in the SQL statement and generates a syntax tree including: The computing node parses the syntax of the SQL statement and obtains the metadata information in the SQL. If it fails, it reports a parsing failure. If it succeeds, it proceeds to the next step; The computing node generates the mapping relationship between the corresponding field names and table names based on the parsed metadata information. 5. The unified database maintenance and control method according to claim 4, characterized in that: the computing node updating the syntax tree according to the locally stored metadata mapping relationship includes: The calculation node searches for the mapping relationship between the corresponding field name and the table name in the locally stored metadata. If it exists, a new syntax tree is generated based on the locally stored metadata mapping relationship; if it does not exist, proceed to the next step. 6. A unified database maintenance and control device, characterized by: including: The unified maintenance module is used to configure the mapping relationship between metadata and save it to the metadata management module; The metadata management module is used to save all metadata information in the database and synchronize the mapping relationships between metadata in the metadata database to the computing nodes; The computing node module is used to parse the metadata information in the SQL statement, generate a syntax tree, update the syntax tree based on the locally stored metadata mapping relationship, then generate an execution tree based on the syntax tree, and execute the SQL statement based on the execution tree. 7. The unified database maintenance and control device according to claim 6, characterized in that: the computing node module includes a grammar parsing module and a grammar execution module; The syntax parsing module is used to parse the metadata information in the SQL statement and generate a syntax tree; The syntax execution module is used to generate an execution tree according to the syntax tree and execute the SQL statement according to the execution document. 8. A computer device, comprising a memory, a processor and a computer program stored on the memory and executable on the processor, characterized in that: when the processor executes the program, it implements claim 1 -The method described in any one of 5. 9. A computer-readable storage medium on which a computer program is stored, characterized in that: when the program is executed by a processor, the method according to any one of claims 1-5 is implemented.