CN115794774A

CN115794774A - Database operation rule generation method and device and electronic equipment

Info

Publication number: CN115794774A
Application number: CN202211511587.3A
Authority: CN
Inventors: 刘桢立; 张海军; 李甲长; 熊文杰
Original assignee: Industrial and Commercial Bank of China Ltd ICBC
Current assignee: Industrial and Commercial Bank of China Ltd ICBC
Priority date: 2022-11-29
Filing date: 2022-11-29
Publication date: 2023-03-14

Abstract

The application discloses a method and a device for generating database operation rules and electronic equipment, and relates to the technical field of databases. Wherein, the method comprises the following steps: acquiring an operation text of a target database, wherein the operation text is used for recording operation description information of the target database; identifying a target keyword in an operation text, and determining a first text fragment and a second text fragment in the operation instruction information according to the target keyword, wherein the first text fragment is used for representing a plurality of operation triggering conditions specified in the operation instruction information, and the second text fragment is used for representing a plurality of triggering operations specified in the operation instruction information; and generating a plurality of database operation rules according to the first text segment and the second text segment, wherein each database operation rule is composed of at least one operation triggering condition and at least one triggering operation. The method and the device solve the technical problem that the database operation rule generation efficiency is low in the prior art.

Description

Database operation rule generation method and device and electronic equipment

Technical Field

The application relates to the technical field of databases, in particular to a method and a device for generating database operation rules and electronic equipment.

Background

A DDL is a database operation rule that must be compiled by computer software and translated for computer storage, querying, and manipulation. Generally, a developer needs to manually check the operation instruction information corresponding to each database, and then compile the DDL according to the operation instruction information.

However, since there is a large difference in the operation specification information corresponding to databases of different manufacturers, and even in databases of the same manufacturer, the operation specification information is constantly changing even when the database technology is constantly updated. Therefore, for the developer, when manually checking and compiling a large amount of operation specification information, a large amount of labor cost is wasted, resulting in a low efficiency of generating the DDL. In addition, if the DDL compiling is not reasonable due to errors in manual checking, the problem of poor database running condition can be caused, so that developers can only recompile the DDL, and the problem of low DDL generation efficiency is further aggravated.

In view of the above problems, no effective solution has been proposed.

Disclosure of Invention

The embodiment of the application provides a method and a device for generating database operation rules and electronic equipment, and aims to at least solve the technical problem that the database operation rule generation efficiency is low in the prior art.

According to an aspect of the embodiments of the present application, there is provided a method for generating database operation rules, including: acquiring an operation text of a target database, wherein the operation text is used for recording operation description information of the target database; identifying a target keyword in an operation text, and determining a first text fragment and a second text fragment in the operation instruction information according to the target keyword, wherein the first text fragment is used for representing a plurality of operation triggering conditions specified in the operation instruction information, and the second text fragment is used for representing a plurality of triggering operations specified in the operation instruction information; and generating a plurality of database operation rules according to the first text segment and the second text segment, wherein each database operation rule comprises at least one operation trigger condition and at least one trigger operation, and the database operation rules are used for updating a target table in a target database.

Further, the method for generating the database operation rule further comprises the following steps: identifying a first target keyword in the operation text, wherein the first target keyword is used for describing attribute information of a target database; determining a first text segment in the operation instruction information according to the first target keyword; identifying a second target keyword and a third target keyword in the operation text, wherein the second target keyword is used for describing a plurality of operation instructions of the target database, and the third target keyword is used for describing an operation sequence among the plurality of operation instructions; and determining a second text fragment in the operation instruction information according to the second target keyword and the third target keyword.

Further, the method for generating the database operation rule further comprises the following steps: before generating a plurality of database operation rules according to the first text segment and the second text segment, identifying a fourth target keyword in the operation text, wherein the fourth target keyword is used for describing operation suggestion information provided by the target object, and the operation suggestion information is operation suggestions related to the target database under each operation trigger condition.

Further, the method for generating the database operation rule further comprises the following steps: determining a plurality of operation triggering conditions and three-element information of each operation triggering condition according to the first text segment, wherein the three-element information at least comprises a judgment main body, a judgment logic and a judgment content of the operation triggering conditions; determining a plurality of trigger operations according to the second text fragment; determining a target trigger operation corresponding to each operation trigger condition from a plurality of trigger operations according to the three-factor information and the fourth target keyword, wherein the target trigger operation at least comprises at least one operation instruction which needs to be executed by the target database under each operation trigger condition and an execution sequence of each operation instruction; and generating a plurality of database operation rules according to each operation trigger condition and the target trigger operation corresponding to each operation trigger condition.

Further, the method for generating the database operation rule further comprises the following steps: generating a condition set according to a plurality of operation triggering conditions; performing a first preset operation according to the condition set, wherein the first preset operation is used for generating a first database operation rule, and the first database operation rule consists of one operation trigger condition in the condition set and a target trigger operation corresponding to the operation trigger condition; and executing the first preset operation for multiple times until a first database operation rule corresponding to each operation trigger condition is generated to obtain multiple first database operation rules.

Further, the first preset operation includes the following processes: determining any one operation triggering condition from the condition set as a first operation triggering condition; determining a target trigger operation corresponding to the first operation trigger condition as a first trigger operation; and generating a first database operation rule according to the first operation trigger condition and the first trigger operation, and deleting the first operation trigger condition from the condition set. Further, the method for generating the database operation rule further comprises the following steps: after a condition set is generated according to a plurality of operation triggering conditions, whether the number of the operation triggering conditions contained in the condition set is larger than a preset threshold value or not is detected; under the condition that the number is larger than a preset threshold value, dividing a condition set into a plurality of subsets, wherein each subset comprises at least two operation triggering conditions; generating a second database operation rule according to each subset; and when the target database meets all the operation triggering conditions in the subset, controlling the target database to execute a second database rule corresponding to the subset.

Further, the method for generating the database operation rule further comprises the following steps: generating a set sequence from the plurality of subsets; performing second preset operation according to the set sequence, wherein the second preset operation is used for generating a second database operation rule, and the second database operation rule is composed of at least two operation trigger conditions in one subset and target trigger operations corresponding to the at least two operation trigger conditions; and executing the second preset operation for multiple times until a second database operation rule corresponding to each subset is generated, so as to obtain multiple second database operation rules.

Further, the second preset operation includes the following processes: determining any subset from the set sequence as a target subset; determining each operation triggering condition in the target subset as a second operation triggering condition; determining that the target trigger operation corresponding to the second operation trigger condition is a second trigger operation; and generating a second database operation rule corresponding to the target subset according to the second operation trigger condition and the second trigger operation, and deleting the target subset from the set sequence.

Further, the method for generating the database operation rule further comprises the following steps: after a plurality of database operation rules are generated according to the first text segment and the second text segment, a rule query instruction sent by a client is received, wherein the rule query instruction at least comprises a rule identifier; determining a target database operation rule from a plurality of database operation rules according to the rule identifier; and returning the target database operation rule to the client.

Further, the method for generating the database operation rule further comprises the following steps: after a plurality of database operation rules are generated according to the first text segment and the second text segment, detecting the condition number of operation triggering conditions corresponding to each database operation rule; and determining the priority corresponding to each database operation rule according to the condition number, wherein the priority is used for representing the execution sequence of the target database to the at least two database operation rules when the target database simultaneously meets the operation triggering conditions corresponding to the at least two database operation rules.

According to another aspect of the embodiments of the present application, there is also provided an apparatus for generating database operation rules, including: the acquisition module is used for acquiring an operation text of the target database, wherein the operation text is used for recording operation description information of the target database; the determining module is used for identifying a target keyword in the operation text and determining a first text fragment and a second text fragment in the operation instruction information according to the target keyword, wherein the first text fragment is used for representing a plurality of operation triggering conditions specified in the operation instruction information, and the second text fragment is used for representing a plurality of triggering operations specified in the operation instruction information; and the generating module is used for generating a plurality of database operation rules according to the first text segment and the second text segment, wherein each database operation rule comprises at least one operation triggering condition and at least one triggering operation, and the database operation rules are used for updating a target table in a target database.

According to another aspect of embodiments of the present application, there is also provided an electronic device, including one or more processors and a memory, where the memory is used to store one or more programs, and when the one or more programs are executed by the one or more processors, the one or more processors are caused to implement the method for generating the database operation rule described above.

In the application, a mode of identifying target keywords and generating database operation rules according to a first text segment and a second text segment is adopted, firstly, an operation text of a target database is obtained, wherein the operation text is used for recording operation description information of the target database, then, the target keywords in the operation text are identified, the first text segment and the second text segment in the operation description information are determined according to the target keywords, and finally, a plurality of database operation rules are generated according to the first text segment and the second text segment. The first text segment is used for representing a plurality of operation triggering conditions specified in the operation description information, the second text segment is used for representing a plurality of triggering operations specified in the operation description information, each database operation rule is composed of at least one operation triggering condition and at least one triggering operation, and the database operation rule is used for updating a target table in a target database.

According to the method and the device, the target keywords in the operation text are identified, and the first text segment and the second text segment in the operation description information are determined according to the target keywords, so that the operation triggering conditions and triggering operations for generating the database operation rules are automatically extracted from the operation description information, a large amount of manual checking cost is saved, the problem that manual checking is prone to errors is solved, and the effect of improving the generation efficiency of the database operation rules is achieved.

Therefore, the technical scheme of the application achieves the purpose of automatically generating the database operation rule, so that the technical effect of reducing the checking cost when the operation description information is manually checked is achieved, and the technical problem of low database operation rule generation efficiency in the prior art is solved.

Drawings

The accompanying drawings, which are included to provide a further understanding of the application and are incorporated in and constitute a part of this application, illustrate embodiment(s) of the application and together with the description serve to explain the application and not to limit the application. In the drawings:

FIG. 1 is a flow chart of an alternative database operation rule generation method according to an embodiment of the present application;

FIG. 2 is a flow chart illustrating the generation of an alternative first database operation rule according to an embodiment of the application;

FIG. 3 is a flow diagram of an alternative method of generating database operation rules according to an embodiment of the present application;

FIG. 4 is a flow chart illustrating the generation of an alternative second database operation rule according to an embodiment of the present application;

FIG. 5 is a schematic diagram of an alternative database operation rule generation apparatus according to an embodiment of the present application;

FIG. 6 is a schematic diagram of an alternative electronic device according to an embodiment of the present application.

Detailed Description

In order to make the technical solutions better understood by those skilled in the art, the technical solutions in the embodiments of the present application will be clearly and completely described below with reference to the drawings in the embodiments of the present application, and it is obvious that the described embodiments are only partial embodiments of the present application, but not all embodiments. All other embodiments obtained by a person of ordinary skill in the art based on the embodiments in the present application without making any creative effort shall fall within the protection scope of the present application.

It should be noted that the terms "first," "second," and the like in the description and claims of this application and in the drawings described above are used for distinguishing between similar elements and not necessarily for describing a particular sequential or chronological order. It is to be understood that the data so used is interchangeable under appropriate circumstances such that the embodiments of the application described herein are capable of operation in sequences other than those illustrated or described herein. Furthermore, the terms "comprises," "comprising," and "having," and any variations thereof, are intended to cover a non-exclusive inclusion, such that a process, method, system, article, or apparatus that comprises a list of steps or elements is not necessarily limited to those steps or elements expressly listed, but may include other steps or elements not expressly listed or inherent to such process, method, article, or apparatus.

Example 1

In accordance with an embodiment of the present application, there is provided an embodiment of a method for generating database operation rules, it should be noted that the steps illustrated in the flowchart of the drawings may be performed in a computer system such as a set of computer executable instructions, and that although a logical order is illustrated in the flowchart, in some cases the steps illustrated or described may be performed in an order different than that herein.

In addition, in order to better understand the scheme of the embodiments of the present application, the following terms used in the present application are explained:

data Definition Language (DDL) is a Language responsible for database Data structure Definition and database object Definition, and generally consists of grammars such as create, alter, and Drop. A DDL may also be understood as a database of operational rules that must be compiled by computer software and converted into a form convenient for computer storage, querying and manipulation.

Data Manipulation Language (DML), which is a programming statement that runs access work on objects and Data in a database, usually takes the instructions of Select, insert, update, delete as the core, and represents the operations of Data query, insert, update (modify), and Delete, respectively.

NLP: natural Language processing (Natural Language processing) is an important direction in the fields of computer science and artificial intelligence, and is mainly applied to the aspects of machine translation, public opinion monitoring, automatic summarization, viewpoint extraction, text classification and text semantic comparison, question answering, voice Recognition, OCR (Optical Character Recognition) Character Recognition and the like.

Fig. 1 is a flowchart of an alternative database operation rule generation method according to an embodiment of the present application, and as shown in fig. 1, the method includes the following steps:

and step S101, acquiring an operation text of the target database.

In step S101, the operation text is used to record the operation specification information of the target database. Specifically, the target database may be any one of versions of databases from different vendors. For example, the target database may be a database of the A1 version of the a vendor, or a database of the B1 version of the B vendor. The operation file includes, but is not limited to, a technical instruction file, a technical description file, and a technical specification file of the target database, and the operation file has recorded therein operation description information of the target database, for example, how to operate on the target of the target database, and how to operate on the table under each directory.

Step S102, identifying target keywords in the operation text, and determining a first text segment and a second text segment in the operation instruction information according to the target keywords.

In step S102, the first text segment is used to represent a plurality of operation trigger conditions specified in the operation specification information, and the second text segment is used to represent a plurality of trigger operations specified in the operation specification information.

Optionally, a rule generating system for a database operation rule may be used as an execution subject of the generating method for the database operation rule. After obtaining the operation text of the target database, the rule generation system may use artificial intelligence techniques such as NLP natural language processing to determine the first text segment and the second text segment in the operation instruction information by identifying the target keyword in the operation text.

For example, the target keywords include keywords such as "tablespace", "space size", "data size", "view", "snapshot", "offset rate", "set required", "easy to use", "recommendation", "certain", "first", "then", "second", "last", and the like. Suppose the operation instruction information recorded in the operation text is "for a table with table space existence, space size greater than 0 and data size greater than1000000, it is preferable to add non-empty fields in a manner that DDL adds new empty fields first, then batch DML update fill is completed, and then DDL alter adds non-empty fields. Through the target keyword, the rule generation system may determine that the first text segment includes: "tablespace exists", "space size is greater than 0" and "data volume is greater than 1000000". In addition, through the target keyword, the rule generating system may further include: "DDL newly added nullable field", "DML update fill value", and "DDL alter is not null". It is easy to note that the first text segment actually represents a plurality of operation trigger conditions specified in the operation specification information, and the second text segment actually represents a plurality of trigger operations specified in the operation specification information.

Step S103, generating a plurality of database operation rules according to the first text segment and the second text segment.

In step S103, each database operation rule is composed of at least one operation trigger condition and at least one trigger operation, and the database operation rule is used for performing an update operation on a target table in a target database.

Optionally, the database operation rule in the present application is a DDL rule. When the rule generating system extracts a plurality of operation triggering conditions according to the first text segment and a plurality of triggering operations according to the second text segment, the rule generating system can generate the database operation rule according to each operation triggering condition and the triggering operation corresponding to the operation triggering condition. For example, the above-mentioned "table space exists" is an operation trigger condition, and the corresponding trigger operation is "DDL newly added nullable field", that is, "credit table column value". On the basis, the rule generating system can generate a database operation rule "meeting the triggering condition 1: tableSpace is exists; execution of trigger operation 1: a credit table column value ", where table space is exists in the database.

It should be noted that a database operation rule may also be composed of a plurality of operation trigger conditions and a plurality of trigger operations. For example, one database operation rule may be "trigger condition 1 is satisfied simultaneously: tableSpace is exists, trigger condition 2: sapceSize lager than 0, trigger condition 3: columNumberlarger bean 1000000; then, the triggering operation 1 is executed successively: creat table column value, trigger operation 2: DML update table, trigger operation 3: DDL alter tablecolumn not null ", where in the database," SapceSize great than 0 "means" spatial size is greater than 0"," columnumberlarger this 1000000 "means" data amount is greater than1000000 "," DML update table "means" DML update fill value ", and" DDL alter tablecolumn not null "means" DDL alter is not empty ".

It should be noted that, because the operation instruction information corresponding to the databases of different manufacturers is different, and even if the database of the same manufacturer is updated, the operation instruction information is changed continuously in the case of continuous database technology update. Therefore, when a developer checks a large amount of operation instruction information manually, the problem of low efficiency of generating the DDL rule is not only caused by consuming a large amount of labor cost, but also the problem of unreasonable compilation of the DDL rule often occurs because the developer relies too much on the historical experience of the personnel during manual checking, so that the database cannot be operated according to the optimal configuration in the operation instruction information, and the problem of low operation efficiency of the database is caused. For example, for recommended information such as "easy-to-use" in the operation instruction information, some technicians often ignore the recommended information, and compile conventional DDL generation rules according to their own historical experiences, so that the database does not follow the most reasonable DDL rules to run during the use process, thereby greatly affecting the use efficiency of the database. For example, for the above specification, "for a table with a table space, a space size greater than 0, and a data size greater than1000000, it is preferable to use" add a non-empty field in a manner that a DDL newly adds an empty field, then a DML update fill value in batches is completed, and then a DDL alter is non-empty ", if the DDL rule is configured without using the recommended operation information, the problem of unordered expansion of the table space of the database is finally easily caused, and the problem of a large number of page fragments occurs.

According to the method and the device, the target keywords in the operation text are identified, the first text fragment and the second text fragment in the technical clause are determined according to the target keywords, so that the operation triggering conditions and triggering operations for generating the DDL rule are automatically extracted from the technical clause, a large amount of manual checking cost is saved, the generation efficiency of the operation rule of the database is improved, the generation of the most reasonable DDL rule can be ensured, the problem of low operation efficiency of the database caused by unreasonable generation of the DDL rule is solved, and the operation and maintenance cost of the database is reduced.

In an optional embodiment, the rule generating system may further obtain a change instruction for the target table in the target database, where the change instruction includes corresponding change information, then the rule generating system generates a DDL script according to the generated multiple database operation rules, the target table in the target database, and the change information, and finally the rule generating system automatically calls and executes the DDL script to update the target table in the target database.

It is understood that the rule generation system makes changes to the target table in the target database, including: at least one of the new addition table, the modification table and the deletion table. The new table addition means that a user registers modification information of a target table on a table registration system, and the specific registration content is as follows: at least one of table basic information, field information, index information, and constraint information. In addition, the modification table refers to modification of table basic information, field information, index information, and constraint information. The delete table refers to direct registry deletion.

Further, the DDL script includes: and the incremental DDL script is the content of the current change, and the issued DDL script is all the change information of the table under the current version. The method and the device have the advantages that the form change script is automatically generated by the registered form change information, so that the accuracy of the form change script is guaranteed, the operation is simple, the usability is high, and the popularization is strong.

It should be noted that the target table in the database includes: incremental baseline version information and release baseline version information. The baseline version information includes: the method comprises the following steps of base line, field, constraint, index and table space attribute, wherein the table space attribute refers to the type of a table, and the base line comprises: incremental baseline and release baseline. The increment baseline is the last table changed, and the release baseline is the last version of the table. Finally, the DDL script is called automatically to replace manual submission of the form change file, so that the condition that the form change file is not submitted is avoided, the consistency of each environment form is ensured, and the data management and maintenance difficulty is reduced.

Based on the contents of the above steps S101 to S103, in the present application, a method of identifying a target keyword and generating a database operation rule according to a first text segment and a second text segment is adopted, an operation text of a target database is first obtained, where the operation text is used to record operation description information of the target database, then the target keyword in the operation text is identified, a first text segment and a second text segment in the operation description information are determined according to the target keyword, and finally a plurality of database operation rules are generated according to the first text segment and the second text segment. The first text segment is used for representing a plurality of operation triggering conditions specified in the operation description information, the second text segment is used for representing a plurality of triggering operations specified in the operation description information, each database operation rule is composed of at least one operation triggering condition and at least one triggering operation, and the database operation rule is used for updating a target table in a target database.

In an alternative embodiment, in order to accurately determine the first text segment and the second text segment in the operation instruction information, the rule generation system first identifies a first target keyword in the operation text, wherein the first target keyword is used for describing attribute information of the target database. Then, the rule generating system determines a first text fragment in the operation instruction information according to the first target keyword. In addition, the rule generation system can also identify a second target keyword and a third target keyword in the operation text, wherein the second target keyword is used for describing a plurality of operation instructions of the target database, and the third target keyword is used for describing an operation sequence among the plurality of operation instructions. Then, the rule generation system determines a second text segment in the operation instruction information according to the second target keyword and the third target keyword.

Optionally, the first target keyword includes, but is not limited to, a series of fields for describing attribute information of the target database, such as "tablespace", "space size", "data size", "view", "snapshot", "offset rate", and the like, where the first target keyword may also be understood as a property dictionary of the database, and the first target keyword may be set by a technician in a customized manner. The second target key includes, but is not limited to, fields of vinyl type for describing operation instructions of the target database, such as "DDL new nullable field", "batch DML update fill value", "DDL alter is non-null", and the like, wherein the second target key may also be set by a technician in a customized manner. Finally, the third target key includes, but is not limited to, "first," "then," "last," etc. a series of fields that characterize the sequence of operations.

It is easy to note that for a database, the trigger condition is usually constructed based on the related attribute information of the database, so that, through the first target keyword, the rule generation system can extract various trigger conditions from the operation instruction information, that is, determine the first text segment. In addition, the triggering operation of the database is actually the result of executing various operation instructions according to various operation sequences, so that the rule generation system can extract various triggering operations from the operation instruction information through the second target keyword and the third target keyword, namely determine the second text segment.

In addition, before generating a plurality of database operation rules according to the first text segment and the second text segment, the rule generation system further identifies a fourth target keyword in the operation text, wherein the fourth target keyword is used for describing operation suggestion information provided by the target object, and the operation suggestion information is operation suggestions related to the target database under each operation trigger condition.

The fourth target keywords include, but are not limited to, keywords such as "setup needed", "use eligible", "recommended", "certain", and the like.

It should be noted that, with the continuous development of database technology, the operation specification information of various databases is very complex, and the DDL statement generation rules under different situations are specially described and recommended. For example, the following description is given in the operation description information of the Oracle database: for the table with existing data, if a non-empty field is added, a default value needs to be set; or the data is firstly set to be null field, and then is set to be non-null after the data is updated. For tables with table spaces larger than 0 and data size larger than1000000, it is preferable to add non-empty fields in a manner of "adding new nullable fields to DDL first, then adding DDL alter to non-empty after completing the filling value of DML update batch".

In the prior art, technicians need to manually judge relevant attributes and information of tables in a database, especially in the case of recommendations, the technicians often ignore technical terms and use conventional DDL generation rules, so that the most recommended DDL rules of manufacturers cannot be generated, and further, the use efficiency of the database may be greatly influenced. For example, for the above specification, "for a table with a table space, a space size greater than 0, and a data size greater than1000000, it is preferable to add a non-empty field in a manner of" adding a new nullable field to DDL first, then completing a batch DML update fill value, and then adding a non-empty field to DDL alter as non-empty ", if the database is managed without using a DDL rule recommended by a manufacturer, the probability of unordered expansion of the table space of the database is greatly increased, page fragments are increased, and the number of times and cost of technical maintenance such as table reorganization or deletion and reconstruction are also increased. In a word, in the prior art, the table change file needs to be judged and regenerated manually according to information such as specifications and table attributes, so that the version release rate is greatly reduced, judgment or operation errors are easy to occur in the manual operation process, statement errors and production faults are caused, and the subsequent data management and maintenance difficulty is increased.

According to the method and the device, the operation suggestion information provided by the target object can be accurately determined from the operation description information by independently identifying the fourth target keyword, and then the most reasonable DDL rule is generated according to the operation suggestion information, so that the database can be guaranteed to operate under the best configuration, the use efficiency of the database is improved, and the operation and maintenance cost of the database can be greatly reduced. The target object is a developer of the target database.

In an alternative embodiment, the rule generating system may determine a plurality of operation triggering conditions and three-factor information of each operation triggering condition according to the first text segment, where the three-factor information includes at least a judgment subject, a judgment logic, and a judgment content of the operation triggering condition. The rule generation system then determines a plurality of trigger actions based on the second segment of text. And finally, the rule generating system determines a target trigger operation corresponding to each operation trigger condition from the multiple trigger operations according to the three-factor information and the fourth target keyword, and generates multiple database operation rules according to each operation trigger condition and the target trigger operation corresponding to each operation trigger condition. The target trigger operation at least comprises at least one operation instruction which needs to be executed by the target database under each operation trigger condition and an execution sequence of each operation instruction,

Optionally, the rule generating system determines a plurality of operation triggering conditions according to the first text segment, where each triggering condition includes three-factor information, that is, a judging main body, a logical judgment, and a judgment content. The rule generation system also determines a plurality of trigger operations based on the second text segment. Finally, since the three-factor information and the fourth target keyword are equivalent to constraints on which trigger operation each trigger condition corresponds to, the rule generation system determines the target trigger operation corresponding to each trigger condition through the three-factor information and the fourth target keyword of each trigger condition, and generates the DDL rule according to each trigger condition and the target trigger operation corresponding to each trigger condition. It should be noted that if the rule generation system cannot determine which trigger action a trigger condition corresponds to, the rule generation system may discard the trigger condition. Similarly, if the rule generation system cannot determine which trigger condition corresponds to a trigger operation, the rule generation system will discard the trigger operation.

In an alternative embodiment, the rule generation system may generate a database operation rule based on each operation trigger. Specifically, the rule generating system first generates a condition set according to a plurality of operation triggering conditions, and then performs a first preset operation according to the condition set, where the first preset operation is used to generate a first database operation rule, and the first database operation rule is composed of one operation triggering condition in the condition set and a target triggering operation corresponding to the operation triggering condition. And finally, the rule generating system executes the first preset operation for multiple times until the first database operation rule corresponding to each operation triggering condition is generated to obtain a plurality of first database operation rules.

The first preset operation comprises the following processes: determining any one operation triggering condition from the condition set as a first operation triggering condition; determining a target trigger operation corresponding to the first operation trigger condition as a first trigger operation; and generating a first database operation rule according to the first operation trigger condition and the first trigger operation, and deleting the first operation trigger condition from the condition set.

FIG. 2 is an alternative flow diagram for generating a first database operation rule based on a trigger condition and a target trigger operation. As shown in fig. 2, the method comprises the following steps:

step 1, generating a condition set according to a plurality of operation triggering conditions;

step 2, determining any one operation triggering condition from the condition set as a first operation triggering condition;

step 3, determining a target trigger operation corresponding to the first operation trigger condition as a first trigger operation;

step 4, generating a first database operation rule according to the first operation trigger condition and the first trigger operation, and deleting the first operation trigger condition from the condition set;

and 5, repeatedly executing the processes from the step 2 to the step 4 until a first database operation rule corresponding to each operation triggering condition is generated to obtain a plurality of first database operation rules.

Specifically, each of the first database operation rules described above is composed of a trigger condition and a trigger operation, for example, as shown in table 1:

TABLE 1

In table 1, a total of 3 first database operation rules are shown, where each first database operation rule corresponds to one operation trigger condition and one trigger operation.

In addition, the rule generating system can also generate a database operation rule based on at least two operation triggering condition compositions. Specifically, fig. 3 shows another alternative flowchart for generating a plurality of database operation rules according to the trigger condition and the target trigger operation, as shown in fig. 3, including the following steps:

step S301, after a condition set is generated according to a plurality of operation trigger conditions, detecting whether the number of the operation trigger conditions contained in the condition set is greater than a preset threshold value;

step S302, under the condition that the number is larger than a preset threshold value, dividing a condition set into a plurality of subsets, wherein each subset comprises at least two operation triggering conditions;

step S303, generating a second database operation rule according to each subset;

and step S304, when the target database meets all the operation triggering conditions in the subset, controlling the target database to execute a second database rule corresponding to the subset.

Optionally, in step S303, the rule generating system first generates a set sequence according to the plurality of subsets, and then performs a second preset operation according to the set sequence, where the second preset operation is used to generate a second database operation rule, and the second database operation rule is composed of at least two operation trigger conditions in one subset and target trigger operations corresponding to the at least two operation trigger conditions. And finally, the rule generating system executes a second preset operation for multiple times until a second database operation rule corresponding to each subset is generated, so that a plurality of second database operation rules are obtained.

Wherein the second preset operation comprises the following processes: determining any subset from the set sequence as a target subset; determining each operation triggering condition in the target subset as a second operation triggering condition; determining a target trigger operation corresponding to the second operation trigger condition as a second trigger operation; and generating a second database operation rule corresponding to the target subset according to the second operation trigger condition and the second trigger operation, and deleting the target subset from the set sequence.

Fig. 4 is a specific flowchart for generating the second database operation rule provided by the present application.

Step one, generating a set sequence according to a plurality of subsets;

step two, determining any subset from the set sequence as a target subset;

step three, determining that the operation triggering condition in the target subset is a second operation triggering condition;

step four, determining that the target trigger operation corresponding to the second operation trigger condition is a second trigger operation;

step five, generating a second database operation rule corresponding to the target subset according to the second operation trigger condition and the second trigger operation, and deleting the target subset from the set sequence;

and step six, repeatedly executing the processes from the step two to the step five until a second database operation rule corresponding to each subset is generated, and obtaining a plurality of second database operation rules.

Optionally, each second database operation rule is composed of a plurality of operation trigger conditions and a plurality of trigger operations, as shown in table 2:

TABLE 2

In table 2, a total of 2 second database operation rules are shown, where the second database operation rule with sequence number 1 corresponds to 2 operation trigger conditions and 2 trigger operations, and the second database operation rule with sequence number 2 corresponds to 3 operation trigger conditions and 3 trigger operations.

In an optional embodiment, after generating the plurality of database operation rules according to the first text segment and the second text segment, the rule generation system further detects a condition number of an operation trigger condition corresponding to each database operation rule, and determines a priority corresponding to each database operation rule according to the condition number, where the priority is used to represent an execution order of the target database on the at least two database operation rules when the target database simultaneously satisfies the operation trigger conditions corresponding to the at least two database operation rules.

Optionally, when one database operation rule includes multiple trigger conditions, the multiple trigger conditions are in a logical relationship of "and", and different database operation rules are in a parallel relationship. When the target database simultaneously meets the operation triggering conditions corresponding to at least two database operation rules, the rule generation system determines which database operation rule is executed according to the priority corresponding to each database operation rule, and the priority is related to the number of conditions in the database operation rules. For example, when the target database is in a state of "under a table having a space size greater than 0 and a data amount greater than100 ten thousand for the table space", the target database simultaneously satisfies the two second database operation rules in table 2, but in table 2, the second database operation rule of sequence number 2 includes 3 operation trigger conditions, and the second database operation rule of sequence number 1 includes only 2 operation trigger conditions, so the rule generation system will update the target table in the target database according to the second database operation rule of sequence number 2.

Further, after generating a plurality of database operation rules according to the first text segment and the second text segment, the rule generating system may further receive a rule query instruction sent by the client, where the rule query instruction at least includes a rule identifier. Then, the rule generation system determines a target database operation rule from the plurality of database operation rules according to the rule identifier, and returns the target database operation rule to the client.

Optionally, the client includes, but is not limited to, a smart phone, a smart tablet, a desktop computer, a notebook computer, and the like. When a technician needs to query a certain database operation rule, the technician can send a rule query instruction to the rule generation system through the client, and after receiving the rule query instruction, the rule generation system returns the target database operation rule which the technician wants to view to the client according to the rule identifier in the rule query instruction.

Example 2

According to an embodiment of the present application, there is further provided an embodiment of an apparatus for generating database operation rules, as shown in fig. 5, the apparatus includes: an obtaining module 501, configured to obtain an operation text of a target database, where the operation text is used to record operation instruction information of the target database; a determining module 502, configured to identify a target keyword in an operation text, and determine, according to the target keyword, a first text fragment and a second text fragment in the operation instruction information, where the first text fragment is used to represent multiple operation trigger conditions specified in the operation instruction information, and the second text fragment is used to represent multiple trigger operations specified in the operation instruction information; a generating module 503, configured to generate a plurality of database operation rules according to the first text segment and the second text segment, where each database operation rule is composed of at least one operation trigger condition and at least one trigger operation, and the database operation rule is used to perform an update operation on a target table in a target database.

Optionally, the determining module further includes: the device comprises a first identification unit, a first determination unit, a second identification unit and a second determination unit. The first identification unit is used for identifying a first target keyword in the operation text, wherein the first target keyword is used for describing attribute information of a target database; a first determination unit, configured to determine a first text segment in the operation instruction information according to the first target keyword; the second identification unit is used for identifying a second target keyword and a third target keyword in the operation text, wherein the second target keyword is used for describing a plurality of operation instructions of the target database, and the third target keyword is used for describing an operation sequence among the operation instructions; and the second determining unit is used for determining a second text fragment in the operation instruction information according to the second target keyword and the third target keyword.

Optionally, the apparatus for generating the database operation rule further includes: and the identification module is used for identifying a fourth target keyword in the operation text, wherein the fourth target keyword is used for describing operation suggestion information provided by the target object, and the operation suggestion information is operation suggestions related to the target database under each operation trigger condition.

Optionally, the generating module further includes: a third determining unit, a fourth determining unit, a fifth determining unit and a generating unit. The third determining unit is used for determining a plurality of operation triggering conditions and three-element information of each operation triggering condition according to the first text segment, wherein the three-element information at least comprises a judging main body, a judging logic and a judging content of the operation triggering conditions; a fourth determining unit, configured to determine a plurality of trigger operations according to the second text segment; a fifth determining unit, configured to determine, according to the three-factor information and the fourth target keyword, a target trigger operation corresponding to each operation trigger condition from multiple trigger operations, where the target trigger operation at least includes at least one operation instruction that needs to be executed by the target database under each operation trigger condition and an execution order of each operation instruction; and the generating unit is used for generating a plurality of database operation rules according to each operation trigger condition and the target trigger operation corresponding to each operation trigger condition.

Optionally, the generating unit further includes: the device comprises a first generation subunit, a first preset operation subunit and a cyclic operation subunit. The first generating subunit is used for generating a condition set according to a plurality of operation triggering conditions; the system comprises a first preset operation subunit, a second preset operation subunit and a third preset operation subunit, wherein the first preset operation is used for generating a first database operation rule, and the first database operation rule consists of one operation trigger condition in a condition set and a target trigger operation corresponding to the operation trigger condition; and the cyclic operation subunit is used for executing the first preset operation for multiple times until the first database operation rule corresponding to each operation trigger condition is generated to obtain multiple first database operation rules.

Optionally, the first preset operation includes the following processes: determining any one operation triggering condition from the condition set as a first operation triggering condition; determining a target trigger operation corresponding to the first operation trigger condition as a first trigger operation; and generating a first database operation rule according to the first operation trigger condition and the first trigger operation, and deleting the first operation trigger condition from the condition set.

Optionally, the apparatus for generating the database operation rule further includes: the device comprises a detection module, a dividing module, a first generation module and a control module. The detection module is used for detecting whether the number of the operation triggering conditions contained in the condition set is greater than a preset threshold value or not; the dividing module is used for dividing the condition set into a plurality of subsets under the condition that the number is larger than a preset threshold value, wherein each subset comprises at least two operation triggering conditions; the first generation module is used for generating a second database operation rule according to each subset; and the control module is used for controlling the target database to execute the second database rule corresponding to the subset when the target database meets all the operation triggering conditions in the subset.

Optionally, the first generating module further includes: the device comprises a first generating unit, a second preset operating unit and a circulating operating unit. The first generating unit is used for generating a set sequence according to the plurality of subsets; the second preset operation unit is used for performing second preset operation according to the set sequence, wherein the second preset operation is used for generating a second database operation rule, and the second database operation rule consists of at least two operation trigger conditions in one subset and target trigger operations corresponding to the at least two operation trigger conditions; and the cyclic operation unit is used for executing second preset operation for multiple times until second database operation rules corresponding to each subset are generated to obtain a plurality of second database operation rules.

Optionally, the apparatus for generating the database operation rule further includes: the device comprises a receiving module, a first determining module and a returning module. The system comprises a receiving module, a rule query module and a processing module, wherein the receiving module is used for receiving a rule query instruction sent by a client, and the rule query instruction at least comprises a rule identifier; the first determining module is used for determining a target database operation rule from a plurality of database operation rules according to the rule identifier; and the return module is used for returning the target database operation rule to the client.

Optionally, the apparatus for generating the database operation rule further includes: the database operation system comprises a first detection module and a second determination module, wherein the first detection module is used for detecting the condition number of operation triggering conditions corresponding to each database operation rule; and the second determining module is used for determining the priority corresponding to each database operation rule according to the condition number, wherein the priority is used for representing the execution sequence of the target database to the at least two database operation rules when the target database simultaneously meets the operation triggering conditions corresponding to the at least two database operation rules.

Example 3

According to another aspect of the embodiments of the present application, there is also provided an electronic device. As shown in fig. 6, the electronic device includes one or more processors; a storage device for storing one or more programs which, when executed by one or more processors, cause the one or more processors to implement a method for running the programs, wherein the programs are arranged to perform the method for generating database operation rules in the above-described embodiments when run.

The above-mentioned serial numbers of the embodiments of the present application are merely for description and do not represent the merits of the embodiments.

In the above embodiments of the present application, the descriptions of the respective embodiments have respective emphasis, and for parts that are not described in detail in a certain embodiment, reference may be made to related descriptions of other embodiments.

In the embodiments provided in the present application, it should be understood that the disclosed technology can be implemented in other ways. The above-described embodiments of the apparatus are merely illustrative, and for example, a division of a unit may be a division of a logic function, and an actual implementation may have another division, for example, a plurality of units or components may be combined or may be integrated into another system, or some features may be omitted, or may not be executed. In addition, the shown or discussed coupling or direct coupling or communication connection between each other may be an indirect coupling or communication connection through some interfaces, units or modules, and may be electrical or in other forms.

The units described as separate parts may or may not be physically separate, and parts displayed as units may or may not be physical units, may be located in one place, or may be distributed on a plurality of units. Some or all of the units can be selected according to actual needs to achieve the purpose of the solution of the embodiment.

In addition, functional units in the embodiments of the present application may be integrated into one processing unit, or each unit may exist alone physically, or two or more units are integrated into one unit. The integrated unit may be implemented in the form of hardware, or may also be implemented in the form of a software functional unit.

The integrated unit, if implemented in the form of a software functional unit and sold or used as a stand-alone product, may be stored in a computer readable storage medium. Based on such understanding, the technical solution of the present application may be substantially implemented or contributed to by the prior art, or all or part of the technical solution may be embodied in a software product, which is stored in a storage medium and includes instructions for causing a computer device (which may be a personal computer, a server, or a network device) to execute all or part of the steps of the method according to the embodiments of the present application. And the aforementioned storage medium includes: a U-disk, a Read-Only Memory (ROM), a Random Access Memory (RAM), a removable hard disk, a magnetic disk, or an optical disk, and various media capable of storing program codes.

The foregoing is only a preferred embodiment of the present application and it should be noted that those skilled in the art can make several improvements and modifications without departing from the principle of the present application, and these improvements and modifications should also be considered as the protection scope of the present application.

Claims

1. A method for generating database operation rules is characterized by comprising the following steps:

acquiring an operation text of a target database, wherein the operation text is used for recording operation description information of the target database;

identifying a target keyword in the operation text, and determining a first text fragment and a second text fragment in the operation instruction information according to the target keyword, wherein the first text fragment is used for representing a plurality of operation triggering conditions specified in the operation instruction information, and the second text fragment is used for representing a plurality of triggering operations specified in the operation instruction information;

and generating a plurality of database operation rules according to the first text segment and the second text segment, wherein each database operation rule comprises at least one operation trigger condition and at least one trigger operation, and the database operation rules are used for updating a target table in the target database.

2. The method of claim 1, wherein identifying a target keyword in the operation text and determining a first text segment and a second text segment in the operation instruction information according to the target keyword comprises:

identifying a first target keyword in the operation text, wherein the first target keyword is used for describing attribute information of the target database;

determining a first text segment in the operation instruction information according to the first target keyword;

identifying a second target keyword and a third target keyword in the operation text, wherein the second target keyword is used for describing a plurality of operation instructions of the target database, and the third target keyword is used for describing an operation sequence among the plurality of operation instructions;

and determining a second text fragment in the operation instruction information according to the second target keyword and the third target keyword.

3. The method of claim 2, wherein prior to generating a plurality of database operation rules from the first text passage and the second text passage, the method further comprises:

identifying a fourth target keyword in the operation text, wherein the fourth target keyword is used for describing operation suggestion information provided by a target object, and the operation suggestion information is operation suggestions related to the target database under each operation trigger condition.

4. The method of claim 3, wherein generating a plurality of database operation rules from the first text passage and the second text passage comprises:

determining a plurality of operation triggering conditions and three-element information of each operation triggering condition according to the first text segment, wherein the three-element information at least comprises a judgment main body, a judgment logic and a judgment content of the operation triggering conditions;

determining a plurality of trigger operations according to the second text fragment;

determining a target trigger operation corresponding to each operation trigger condition from a plurality of trigger operations according to the three-factor information and the fourth target keyword, wherein the target trigger operation at least comprises at least one operation instruction which needs to be executed by the target database under each operation trigger condition and an execution sequence of each operation instruction;

and generating a plurality of database operation rules according to each operation trigger condition and the target trigger operation corresponding to each operation trigger condition.

5. The method of claim 4, wherein generating a plurality of database operation rules according to each of the operation trigger conditions and the target trigger operation corresponding to each of the operation trigger conditions comprises:

generating a condition set according to a plurality of the operation triggering conditions;

performing a first preset operation according to the condition set, wherein the first preset operation is used for generating a first database operation rule, and the first database operation rule is composed of one operation trigger condition in the condition set and a target trigger operation corresponding to the operation trigger condition;

and executing the first preset operation for multiple times until a first database operation rule corresponding to each operation trigger condition is generated to obtain multiple first database operation rules.

6. The method according to claim 5, characterized in that said first preset operation comprises the following procedure:

determining any one of the operation trigger conditions from the condition set as a first operation trigger condition;

determining that the target trigger operation corresponding to the first operation trigger condition is a first trigger operation;

and generating the first database operation rule according to the first operation trigger condition and the first trigger operation, and deleting the first operation trigger condition from the condition set.

7. The method of claim 5, wherein after generating a set of conditions based on a plurality of the operational trigger conditions, the method further comprises:

detecting whether the number of operation triggering conditions contained in the condition set is larger than a preset threshold value or not;

dividing the condition set into a plurality of subsets when the number is larger than the preset threshold, wherein each subset comprises at least two operation triggering conditions;

generating a second database operation rule according to each subset;

and when the target database meets all operation triggering conditions in the subset, controlling the target database to execute a second database rule corresponding to the subset.

8. The method of claim 7, wherein generating second database operation rules from each of the subsets comprises:

generating a set sequence from a plurality of said subsets;

performing a second preset operation according to the set sequence, wherein the second preset operation is used for generating a second database operation rule, and the second database operation rule consists of at least two operation trigger conditions in a subset and target trigger operations corresponding to the at least two operation trigger conditions;

and executing the second preset operation for multiple times until a second database operation rule corresponding to each subset is generated, so as to obtain multiple second database operation rules.

9. The method according to claim 8, characterized in that said second preset operation comprises the following procedure:

determining any one subset from the set sequence as a target subset;

determining each operation triggering condition in the target subset as a second operation triggering condition;

determining that the target trigger operation corresponding to the second operation trigger condition is a second trigger operation;

and generating a second database operation rule corresponding to the target subset according to the second operation trigger condition and the second trigger operation, and deleting the target subset from the set sequence.

10. The method of claim 1, wherein after generating a plurality of database operation rules based on the first text passage and the second text passage, the method further comprises:

receiving a rule query instruction sent by a client, wherein the rule query instruction at least comprises a rule identifier;

determining a target database operation rule from a plurality of database operation rules according to the rule identification;

and returning the target database operation rule to the client.

11. The method of claim 1, wherein after generating a plurality of database operation rules based on the first text passage and the second text passage, the method further comprises:

detecting the condition number of operation triggering conditions corresponding to each database operation rule;

and determining the priority corresponding to each database operation rule according to the condition number, wherein the priority is used for representing the execution sequence of the target database to the at least two database operation rules when the target database simultaneously meets the operation triggering conditions corresponding to the at least two database operation rules.

12. An apparatus for generating database operation rules, comprising:

the acquisition module is used for acquiring an operation text of the target database, wherein the operation text is used for recording operation description information of the target database;

a determining module, configured to identify a target keyword in the operation text, and determine a first text fragment and a second text fragment in the operation instruction information according to the target keyword, where the first text fragment is used to represent multiple operation trigger conditions specified in the operation instruction information, and the second text fragment is used to represent multiple trigger operations specified in the operation instruction information;

and the generating module is used for generating a plurality of database operation rules according to the first text segment and the second text segment, wherein each database operation rule comprises at least one operation triggering condition and at least one triggering operation, and the database operation rules are used for updating a target table in the target database.

13. An electronic device comprising one or more processors and memory for storing one or more programs, wherein the one or more programs, when executed by the one or more processors, cause the one or more processors to implement the method of generating database operation rules of any of claims 1-11.