CN111324593A - Data table detection method and device, electronic equipment and computer readable storage medium - Google Patents
Data table detection method and device, electronic equipment and computer readable storage medium Download PDFInfo
- Publication number
- CN111324593A CN111324593A CN202010097091.0A CN202010097091A CN111324593A CN 111324593 A CN111324593 A CN 111324593A CN 202010097091 A CN202010097091 A CN 202010097091A CN 111324593 A CN111324593 A CN 111324593A
- Authority
- CN
- China
- Prior art keywords
- detected
- optimized
- information
- display end
- entry
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/21—Design, administration or maintenance of databases
- G06F16/211—Schema design and management
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/22—Indexing; Data structures therefor; Storage structures
- G06F16/2282—Tablespace storage structures; Management thereof
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/28—Databases characterised by their database models, e.g. relational or object models
- G06F16/284—Relational databases
Landscapes
- Engineering & Computer Science (AREA)
- Databases & Information Systems (AREA)
- Theoretical Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Software Systems (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention provides a data table detection method, a data table detection device, electronic equipment and a computer readable storage medium, and relates to the field of data table processing. The method comprises the following steps: acquiring a first table to be detected from a table set to be detected; the first table to be detected is any table to be detected in the table set to be detected; judging whether the first table to be detected meets a preset rule or not; if not, determining at least one table entry to be optimized in the first table to be detected; and sending the list items to be optimized to a display end so that the display end displays the list items to be optimized. The machine is used for judging whether the table to be detected conforms to the preset rule or not, the table item to be optimized in the table to be detected is determined, the table item to be optimized is sent to the display end, and a user can see the table item information to be optimized of the table to be detected at the display end so as to optimize or perform other processing on the table to be detected, and the rationality and the high efficiency of the data table are maintained.
Description
Technical Field
The invention relates to the field of data table processing, in particular to a data table detection method, a data table detection device, electronic equipment and a computer readable storage medium.
Background
The relational database is a database type widely applied at present, the design of the relational database is a process of organizing and structuring data, and the core problem is the design of a relational model.
For the case of small database size, the server can easily process the table structure in the database. However, as the size of the project is continuously increased, the corresponding database becomes more complex, the table structure of the relational model is more complicated, and the Structured Query Language (SQL) statement of the relational model is clumsy and inefficient; in addition, the unreasonable definition of the table structure can cause the data to be incomplete when being updated; therefore, in addition to complying with the three general rules of standard design, it is necessary to make reasonable rules for table field type, index, data amount, etc. in combination with actual conditions.
The table structure design work is generally completed by research personnel, and the research personnel generally know little about the database principle and the design principle, so that the SQL of a plurality of business tables has performance problems after the data volume rises. The maintenance cost of a data table is increased along with the increase of data volume, and the normal operation of database business can be influenced in the changing process of the data table with large data volume, so that an unreasonable table structure is discovered and corrected in time, and the method has important significance for maintaining the high efficiency, stability and usability of the database.
Disclosure of Invention
In view of the above, the present invention provides a method, an apparatus, an electronic device and a computer-readable storage medium for detecting a data table.
In order to achieve the above purpose, the embodiment of the present invention adopts the following technical solutions:
in a first aspect, the present invention provides a method for detecting a data table, the method comprising: acquiring a first table to be detected from a table set to be detected; the first table to be detected is any table to be detected in the table set to be detected. Judging whether the first table to be detected meets a preset rule or not; if not, determining at least one to-be-optimized table entry in the first to-be-detected table; the table entry to be optimized is a table entry in the first table to be detected, which meets the table optimization rule. And sending the list item to be optimized to a display end so that the display end displays the list item to be optimized.
In an optional embodiment, after the determining, according to the preset rule, at least one entry to be optimized in the first table to be detected, the method further includes: and generating target table item information corresponding to the table item to be optimized according to the preset rule. And sending the target table item information to the table set to be detected so that the table set to be detected updates the first table to be detected according to the target table item information. Judging whether updating success information sent by the table set to be detected is received within a first time; and the update success information is used for indicating that the updated first table to be detected in the table set to be detected conforms to the preset rule. And if so, determining that the first table to be detected is updated successfully.
In an optional implementation manner, before the sending the target table entry information to the table set to be detected, so that the table set to be detected updates the first table to be detected according to the target table entry information, the method further includes: and judging whether an update consent instruction of a preset user is received within the second time. And if so, executing the step of sending the target table item information to the table set to be detected so that the table set to be detected updates the first table to be detected according to the target table item information.
In an optional embodiment, the determining whether the first table to be detected meets a preset rule includes: judging whether a storage engine of the first table to be detected is an InNODB engine or not; and if not, modifying the storage engine of the first table to be detected into the InNODB engine. And/or judging whether the total data amount of the first table to be detected is less than or equal to a first preset value; if not, sending the data quantity exceeding information of the first table to be detected to the display end so that the display end displays the data quantity exceeding information. And/or judging whether the index times of the first table to be detected is less than or equal to an index preset value; if not, sending the index overproof information of the first table to be detected to the display end so that the display end displays the index overproof information. And/or, judging whether the character set type of the first table to be detected is a preset character set type; if not, modifying the character set type of the first table to be detected into a preset character set type. And/or, judging whether the first table to be detected has a main key; if not, the information without the main key of the first table to be detected is sent to the display end, so that the display end displays the information without the main key.
In an optional embodiment, after the determining, according to the preset rule, at least one entry to be optimized in the first table to be detected, the method further includes: receiving a table modification instruction of a preset user; and sending a table updating instruction corresponding to the table modifying instruction to the table set to be detected so that the table set to be detected updates the first table to be detected according to the table updating instruction, wherein the updated first table to be detected conforms to the preset rule.
In a second aspect, the present invention provides a data table detection apparatus, the apparatus comprising: the device comprises an acquisition module, a judgment module, an execution module and a communication module. The acquisition module is used for acquiring a first table to be detected from the set of tables to be detected; the first table to be detected is any table to be detected in the table set to be detected. The judging module is used for judging whether the first table to be detected accords with a preset rule or not. The execution module is used for determining at least one to-be-optimized table entry in the first to-be-detected table when the first to-be-detected table does not accord with the preset rule; the table entry to be optimized is a table entry in the first table to be detected, which meets the table optimization rule. And the communication module is used for sending the item to be optimized to a display end so that the display end displays the item to be optimized.
In an optional embodiment, the execution module is further configured to generate target entry information corresponding to the entry to be optimized according to the preset rule. The communication module is further configured to send the target table item information to the set of tables to be detected, so that the set of tables to be detected updates the first table to be detected according to the target table item information. The judging module is also used for judging whether the updating success information sent by the table set to be detected is received in the first time; and the update success information is used for indicating that the updated first table to be detected in the table set to be detected conforms to the preset rule. The execution module is further configured to determine that the first table to be detected is updated successfully when the update success information is received in the first time.
In an optional embodiment, the determining module is further configured to determine whether an update approval instruction of a preset user is received within the second time. The execution module is further configured to send the target table entry information to the table set to be detected when the update approval instruction is received within the second time, so that the table set to be detected updates the first table to be detected according to the target table entry information.
In an optional embodiment, the determining module is further configured to determine whether a storage engine of the first table to be detected is an InnoDB engine; the execution module is further used for modifying the storage engine of the first table to be detected into the InNODB engine when the storage engine of the first table to be detected is not the InNODB engine. The judging module is also used for judging whether the total data amount of the first table to be detected is less than or equal to a first preset value; the execution module is further configured to send the data amount exceeding information of the first table to be detected to the display end when the total data amount of the first table to be detected is greater than the first preset value, so that the display end displays the data amount exceeding information. The judging module is also used for judging whether the index times of the first table to be detected is less than or equal to an index preset value; the execution module is further used for sending the index exceeding information of the first table to be detected to the display end when the index times of the first table to be detected are larger than the index preset value, so that the display end displays the index exceeding information. The judging module is also used for judging whether the character set type of the first table to be detected is a preset character set type; the execution module is further configured to modify the character set type of the first table to be detected into a preset character set type when the character set type of the first table to be detected is not the preset character set type. The judging module is also used for judging whether the first table to be detected has a main key; the execution module is further configured to send the information of no primary key of the first table to be detected to the display end when the first table to be detected does not have a primary key, so that the display end displays the information of no primary key.
In an optional embodiment, the communication module is further configured to receive a table modification instruction of a preset user. The communication module is further configured to send a table update instruction corresponding to the table modification instruction to the table set to be detected, so that the table set to be detected updates the first table to be detected according to the table update instruction, and the updated first table to be detected conforms to the preset rule.
In a third aspect, the present invention provides an electronic device comprising a processor and a memory, the memory storing machine executable instructions executable by the processor to implement the method of any one of the preceding embodiments.
In a fourth aspect, the present invention provides a computer readable storage medium having stored thereon a computer program which, when executed by a processor, implements a method according to any one of the preceding embodiments.
The invention provides a data table detection method, a data table detection device, electronic equipment and a computer readable storage medium, and relates to the field of data table processing. The method comprises the following steps: acquiring a first table to be detected from a table set to be detected; the first table to be detected is any table to be detected in the table set to be detected; judging whether the first table to be detected meets a preset rule or not; if not, determining at least one to-be-optimized table entry in the first to-be-detected table; the table entry to be optimized is a table entry in the first table to be detected, which meets the table optimization rule; and sending the list item to be optimized to a display end so that the display end displays the list item to be optimized. The machine is used for judging whether the table to be detected conforms to the preset rule or not, the table item to be optimized in the table to be detected is determined, the table item to be optimized is sent to the display end, and a user can see the table item information to be optimized of the table to be detected at the display end so as to optimize or perform other processing on the table to be detected, and the rationality and the high efficiency of the data table are maintained.
In order to make the aforementioned and other objects, features and advantages of the present invention comprehensible, preferred embodiments accompanied with figures are described in detail below.
Drawings
In order to more clearly illustrate the technical solutions of the embodiments of the present invention, the drawings needed to be used in the embodiments will be briefly described below, it should be understood that the following drawings only illustrate some embodiments of the present invention and therefore should not be considered as limiting the scope, and for those skilled in the art, other related drawings can be obtained according to the drawings without inventive efforts.
FIG. 1 is a schematic diagram of a data table detection system according to an embodiment of the present invention;
FIG. 2 is a schematic flow chart of a data table detection method according to an embodiment of the present invention;
FIG. 3 is a schematic flow chart of another data table detection method according to an embodiment of the present invention;
FIG. 4 is a schematic flow chart illustrating another exemplary method for detecting a data table according to an embodiment of the present invention;
FIG. 5(a) is a schematic flow chart of another data table detection method according to an embodiment of the present invention;
FIG. 5(a-1) is a schematic diagram of a table to be tested according to an embodiment of the present invention;
FIG. 5(b) is a schematic flow chart of another data table detection method according to an embodiment of the present invention;
FIG. 5(c) is a schematic flow chart of another data table detection method according to an embodiment of the present invention;
FIG. 5(d) is a schematic flow chart of another data table detection method according to an embodiment of the present invention;
FIG. 5(d-1) is a schematic diagram of another table to be detected according to an embodiment of the present invention;
FIG. 5(e) is a schematic flow chart of another data table detection method according to an embodiment of the present invention;
fig. 5(f) is a display interface diagram of a display end according to an embodiment of the present invention;
FIG. 6 is a flowchart illustrating another exemplary method for detecting a data table according to an embodiment of the present invention;
FIG. 7 is a block diagram of a data table detection apparatus according to an embodiment of the present invention;
fig. 8 is a block diagram of an electronic device according to an embodiment of the present invention.
Icon: 11-application system, 111-display end, 112-message pushing unit, 113-execution interface, 12-data storage module, 121-client end, 122-database, 40-data table detection device, 41-acquisition module, 42-judgment module, 43-execution module, 44-communication module, 60-electronic equipment, 61-memory, 62-processor and 63-communication interface.
Detailed Description
The technical solutions in the embodiments of the present invention will be clearly and completely described below with reference to the drawings in the embodiments of the present invention, and it is obvious that the described embodiments are only a part of the embodiments of the present invention, and not all of the embodiments. The components of embodiments of the present invention generally described and illustrated in the figures herein may be arranged and designed in a wide variety of different configurations.
Thus, the following detailed description of the embodiments of the present invention, presented in the figures, is not intended to limit the scope of the invention, as claimed, but is merely representative of selected embodiments of the invention. All other embodiments, which can be derived by a person skilled in the art from the embodiments of the present invention without making any creative effort, shall fall within the protection scope of the present invention.
It is noted that relational terms such as "first" and "second," and the like, may be used solely to distinguish one entity or action from another entity or action without necessarily requiring or implying any actual such relationship or order between such entities or actions. Also, the terms "comprises," "comprising," or any other variation thereof, are intended to cover a non-exclusive inclusion, such that a process, method, article, or apparatus that comprises a list of elements does not include only those elements but may include other elements not expressly listed or inherent to such process, method, article, or apparatus. Without further limitation, an element defined by the phrase "comprising an … …" does not exclude the presence of other identical elements in a process, method, article, or apparatus that comprises the element.
The table structure design work is generally completed by research personnel, and the research personnel generally know little about the database principle and the design principle, so that the SQL of a plurality of business tables has performance problems after the data volume rises. The maintenance cost of a data table is increased along with the increase of data volume, and the normal operation of database business can be influenced in the changing process of the data table with large data volume, so that an unreasonable table structure is discovered and corrected in time, and the method has important significance for maintaining the high efficiency, stability and usability of the database. To solve the problem of detecting the reasonableness of a data table and the disadvantages of the background art, an embodiment of the invention provides a data table detection system, please refer to fig. 1, and fig. 1 is a schematic diagram of a data table detection system provided by an embodiment of the invention. The data table detection system comprises an application system 11 and a data storage module 12; the application system 11 and the data storage module 12 are communicatively connected, wherein the application system 11 includes a display end 111, a message pushing unit 112 and an execution interface 113, and the data storage module 12 includes a plurality of clients 121 and a database 122.
It should be understood that the application system 11 and the data storage module 12 may be one electronic device or may be composed of a plurality of electronic devices, and the specific arrangement thereof is not limited by the present invention.
In addition, the application system 11 may be responsible for overall logic scheduling, which may be developed using flash; the client 121 may collect information of the data table, etc.; the display end 111 can be a Web framework designed based on a View User Interface (UI); the execution interface 113 may be an interface service of the operation and maintenance platform, which may change the online database 122; the message pushing unit 112 may send the operation information to the relevant person or electronic device, etc.
Referring to fig. 2, fig. 2 is a schematic flow chart of a data table detection method according to an embodiment of the present invention, which is provided in the present invention based on the application system 11 shown in fig. 1. The data table detection method comprises the following steps:
s301, acquiring a first table to be detected from the table set to be detected.
The first table to be detected is any table to be detected in the table set to be detected. It should be understood that the set of tables to be detected may be data in one database or data stored in a plurality of databases. It is foreseen that the first table to be detected may be obtained through the client, or may be directly obtained from the database.
S302, whether the first table to be detected meets a preset rule or not is judged.
The preset rules may include, but are not limited to, any one or a combination of the following rules: the data total amount of the table to be detected, the data character set type of the table to be detected, the storage engine type of the table to be detected, the main key of the table to be detected and the index rule of the table to be detected.
If yes, executing S303; if not, go to step S304.
S303, determining the first table to be detected as a standard data table.
It will be appreciated that the standard data table described above, which is in accordance with the predetermined rules, may also be referred to as a legitimate data table.
S304, at least one item to be optimized in the first table to be detected is determined.
The table entry to be optimized is the table entry in the first table to be detected, which meets the table optimization rule. It can be understood that the rule to be optimized may be other than a preset rule, or may be a specially set rule for optimizing the first table to be detected, so as to make the first table to be detected more meet the user requirement or improve the processing efficiency of the first table to be detected.
S305, the item to be optimized is sent to the display end, so that the display end displays the item to be optimized.
It will be appreciated that the display terminal may be used to display images, video, etc. The Display terminal may include a Display panel, and the Display panel may employ a Liquid Crystal Display (LCD), an Organic Light-Emitting Diode (OLED), an Active Matrix Organic Light-Emitting Diode or an Active Matrix Organic Light-Emitting Diode (AMOLED), a flexible Light-Emitting Diode (FLED), a Mini-LED, a Micro-OLED, a Quantum Dot Light-Emitting Diode (QLED), and the like. In some embodiments, the spreadsheet detection system may include 1 or N display terminals, where N is a positive integer greater than 1.
It is foreseen that the display end may display one or more entries to be optimized. For example, when only one to-be-optimized entry is in the first to-be-detected table, the display end may display only one to-be-optimized entry, and may also display other information of the first to-be-detected table on the basis of displaying the to-be-optimized entry, so that the user can more intuitively see the information of the unreasonable data table; when the first table to be detected has a plurality of items to be optimized, the display end can display part of the items to be optimized or all the items to be optimized in the plurality of items to be optimized, and can also display other information of the first table to be detected on the basis of displaying part of the items to be optimized or all the items to be optimized; the other information may be, but is not limited to, how many entries to be optimized are in total, attribute information of each entry to be optimized, and the like. It should be understood that the to-be-optimized entry displayed by the display end may be determined according to the display range of the display end, the user requirement or the screening requirement, and the above are only possible implementation manners given by the embodiment of the present invention, and should not be construed as limitations of the present invention.
It should be understood that, the machine is used for judging whether the table to be detected conforms to the preset rule, determining the table items to be optimized in the table to be detected, and sending the table items to be optimized to the display end, so that the user can see the table item information to be optimized of the table to be detected at the display end, thereby optimizing or performing other processing on the table to be detected, and maintaining the reasonability and the high efficiency of the data table is facilitated. Compared with the manual comparison of the rationality of the table to be detected, the time cost of data table detection can be effectively saved, and the processing efficiency is improved.
In an optional embodiment, after querying a first table to be detected that meets a rule to be optimized or does not meet a preset rule through a display terminal, in order to make the first table to be detected tend to be reasonable, in other words, in order to optimize the first table to be detected, a possible implementation manner is provided on the basis of fig. 2, please refer to fig. 3, and fig. 3 is a schematic flow diagram of another data table detection method provided by an embodiment of the present invention. After S304, the method may further include:
s306, generating target table item information corresponding to the table item to be optimized according to a preset rule.
For example, when the preset rule includes the data character set type of the table to be detected, because the non-UTF 8 type character set may cause chinese scrambling of the table to be detected, taking as an example that the character set type of the table to be detected is the UTF8 type character set as required in the preset rule, it can be found whether the table to be detected is the UTF8 type character set through "information dictionary" in the table set to be detected; if the table TO be detected is not a UTF 8-like character set, the instruction "ALTER tabellactive mq. active _ ACKS CONVERT TO CHARACTER SET UTF 8" may be generated, i.e., the target table entry information.
S309, sending the target table item information to the table set to be detected, so that the table set to be detected updates the first table to be detected according to the target table item information.
For example, the above-described instruction (target entry information): the 'ALTER TABLE activemq. ACTIVIEMQ _ ACKSCONVERT TO CHARACTER SET UTF 8' is sent TO the set of TABLEs TO be detected, so that the character set type of the first TABLE TO be detected is updated TO be a UTF8 type character set.
S310, judging whether the updating success information sent by the table set to be detected is received in the first time.
The successful updating information is used for indicating that the updated first table to be detected in the table set to be detected conforms to the preset rule. It is understood that after the update of the first table to be detected in the set to be detected is completed, a response (e.g., an update success message) may be sent to the application system.
The first time can be determined according to actual use requirements, and if the data volume of the first table to be detected is large and the required updating time is long, the first time can be properly increased; if the data size of the first table to be detected is small or the required updating time is short, the first time can be reduced properly.
If yes, go to S311; if not, go to S312.
S311, determining that the first table to be detected is updated successfully.
It can be understood that when the application system receives the update success information fed back by the set to be detected, it is determined that the first table to be detected is updated successfully, and the updated first table to be detected conforms to the preset rule.
And S312, determining that the first table to be detected fails to be updated.
It can be understood that when determining that the first table to be detected fails to be updated, the update success information may not be received within the first time, the update failure information may be received within the first time, and the like, and it is specifically determined that the update failure of the first table to be detected may be determined according to actual requirements.
For the process of updating the to-be-optimized table entry of the first to-be-detected table, it may be that an update success message is sent every time an to-be-optimized table entry is successfully updated, and the update success message may determine which to-be-optimized table entry is updated through an identifier or a field; or after the target table entry information is sent, waiting for receiving a response of the unified reply, wherein it should be understood that the response of the unified reply includes the update results of all the table entries to be optimized.
By optimizing the items to be optimized in the first table to be detected which do not accord with the preset rule or accord with the optimization rule, the working efficiency of the data table can be effectively improved, and the data redundancy is reduced.
In an alternative embodiment, the process of optimizing the table to be detected may affect the use of the table to be detected itself, and if the target table entry information is sent to the wrong execution process, the table to be detected may be disturbed, so as to avoid the above situation, a possible implementation manner is provided on the basis of fig. 3, please refer to fig. 4, and fig. 4 is a flowchart of another data table detection method provided in the embodiment of the present invention. The above data table detection method may further include:
and S307, judging whether an update consent instruction of a preset user is received in the second time.
The first time and the second time may be the same or different, and the specific setting may be determined according to the actual use requirement, which is not limited in the present invention.
If an update approval instruction of the preset user is received within the second time, executing the step S309; if the update approval command of the predetermined user is not received within the second time, S308 is executed.
And S308, not updating the first table to be detected.
It is understood that the preset user may be, but is not limited to, an initial designer of the data sheet, a developer, or an operation and maintenance person of the database, and may be a plurality of or any one of the update consent instructions sent above, and the specific requirement of the update consent instruction may be determined according to the situation of the actual table to be detected.
The operation agreed by the preset user is set for the generated target table item information (or the optimization scheme of the table to be detected), so that the change of the first table to be detected can be avoided in the service peak period, the preset user checks the target table item information corresponding to the table item to be optimized of the first table to be detected, and the condition that the table item to be optimized in the first table to be detected is updated to the wrong data table item can be effectively avoided.
For the preset rule, the design specification of the database by the industry authority may be adopted, and the preset rule may be adjusted according to the actual requirement, in an optional embodiment, on the basis of fig. 2, taking the storage engine in which the preset rule includes the table to be detected as an InnoDB storage engine as an example, please refer to fig. 5(a), and fig. 5(a) is a schematic flow diagram of another data table detection method provided by the embodiment of the present invention. The above S302 may include:
s302a-1, judging whether the storage engine of the first table to be detected is an InNODB engine.
For example, MySQL officially pushed the InnoDB engine, the security, concurrency support, and transaction support of MySQL officially pushed the InnoDB engine have obvious advantages over the MyIASM engine corresponding to the Index Sequential Access Method (ISAM) in MySQL; the data tables of the non-InnodB engine can be found by "information Schemabelles" in the system table.
If the storage engine of the first table to be detected is not the InNODB engine, executing S302 a-2; if the storage engine of the first table to be detected is the InNODB engine, S302a-3 is executed.
S302a-2, modifying the storage engine of the first table to be detected into an InNODB engine.
S302a-3, determining that the storage engine of the first table to be detected meets the preset rule.
The storage engine of the first table to be detected is judged according to the preset rules, so that the first table to be detected can be more reasonable and efficient.
To facilitate understanding of the above storage engine determination process, in the embodiment of the present invention, the storage engine required by the preset rule is an InnoDB engine as an example, please refer to fig. 5(a-1), and fig. 5(a-1) is a schematic diagram of a table to be detected according to the embodiment of the present invention. It can be seen that, the storage engine of the table to be detected shown in fig. 5(a-1) is a MyIASM engine, and when the storage engine of the table to be detected is detected to be the MyIASM engine, an optimization scheme (target table entry information) is generated: chan MultiConfig ENGINE to be set as the INNODB ENGINE so that the modified first table to be detected reviews the preset rule.
For the preset rule, a design specification of the database by an authority in the industry may be adopted, and the preset rule may be adjusted according to an actual requirement, in an optional embodiment, on the basis of fig. 2, taking the example that the preset rule includes that the total data amount of the table to be detected is less than or equal to a preset value, please refer to fig. 5(b), and fig. 5(b) is a schematic flow diagram of another data table detection method provided by the embodiment of the present invention. The above S302 may further include:
s302b-1, judging whether the total data amount of the first table to be detected is less than or equal to a first preset value.
For example, the first preset value may be set to "10 hundred million rows" or "10 GB" so as to control the total data size of the table to be detected, and avoid that the total data size of the table to be detected is too large, which affects the call of the table to be detected in the database.
If the total data amount of the first table to be detected is greater than the first preset value, executing S302 b-2; if the total data amount of the first table to be detected is less than or equal to the first preset value, S302b-3 is executed.
S302b-2, sending the data size exceeding information of the first table to be detected to the display end, so that the display end displays the data size exceeding information.
S302b-3, determining that the total data amount of the first table to be detected meets a preset rule.
To facilitate understanding of the above control process for the total amount of data of the first table to be detected, the embodiment of the present invention provides a possible example: the data table in MySQL is essentially a 'B + tree', the non-leaf nodes of the 'B + tree' only contain navigation information and do not contain actual values, and all the leaf nodes are connected with the connected nodes by using a linked list, so that interval searching and traversing are facilitated; when the height of the B + tree is 1-3 layers, the reading performance of the data table is relatively high, and each row occupies 500 bytes, and the B + tree of 3 layers can store about 5000 ten thousand rows of data; if a single data table is agreed to be larger than 5000 ten thousand lines or a file corresponding to the single data table is larger than 25GB (a first preset value), the data table (a first table to be detected) is regarded as a large table, and in the actual detection process, the total data amount of the first table to be detected can be determined through a tool 'information technology tables'.
It should be understood that by controlling the total data size of the first table to be detected, the usability of multiple data tables in the database is improved, and the data processing efficiency is improved.
In an optional embodiment, for the same index, a situation of repeated indexes may occur, and in order to avoid multiple indexes and improve the efficiency of data search, on the basis of fig. 2, taking an example that a preset rule includes an index rule of a table to be detected, please refer to fig. 5(c), where fig. 5(c) is a schematic flow diagram of another data table detection method provided in the embodiment of the present invention. The above S302 may further include:
s302c-1, judging whether the index times of the first table to be detected is less than or equal to the index preset value.
It should be understood that the index rule of the first table to be detected may be, but is not limited to: a single table index, a single index field, whether to repeat an index, etc. For example, if the number of times of indexing of the single table is set to be less than or equal to eight (index preset value), a single index field is less than or equal to six (index preset value), and any repeated index does not meet the preset rule, in the actual using process, the tool "information technology statistics" may be used to determine whether the number of times of indexing of the first table to be detected is less than or equal to the index preset value.
If the index times of the first table to be detected are larger than the index preset value, executing S302 c-2; if the index times of the first table to be detected is less than or equal to the index preset value, S302c-3 is executed.
S302c-2, sending the index superstandard information of the first table to be detected to the display end, so that the display end displays the index superstandard information.
S302c-3, determining that the index times of the first table to be detected meet a preset rule.
It should be understood that in the database and the data table, the index can increase the query speed, but too much index maintenance can also reduce the writing performance, and the setting of the index rule of the first table to be detected can effectively reduce the data processing amount when searching data, so as to improve the data processing efficiency of processing the first table to be detected.
In an alternative embodiment, the character set types of the data table include multiple types, such as a UTF8 character set, a HyperText Markup Language (HTML) character set, and the like, and on the basis of fig. 2, taking an example that a preset rule includes the character set type of the table to be detected, please refer to fig. 5(d), and fig. 5(d) is a flowchart of another data table detection method provided in the embodiment of the present invention. The above S302 may further include:
s302d-1, judging whether the character set type of the first table to be detected is a preset character set type.
For example, in the embodiment of the present invention, the preset character set type may be a UTF8 character set, the UTF8 character set has a good support for chinese, when chinese data needs to be used, a non-UTF 8 character set may cause a data table (a first table to be detected) to generate a chinese scrambling code, and in an actual use process, a tool "NFORMATIONSCHEMATABLES" may be used to determine whether the character set of the first table to be detected is a UTF8 type character set.
If the character set type of the first table to be detected is not the preset character set type, executing S302 d-2; if the character set type of the first table to be detected is the predetermined character set type, then step S302d-3 is executed.
S302d-2, the character set type of the first table to be detected is modified into a preset character set type.
S302d-3, determining that the character set type of the first table to be detected meets the preset rule.
It should be understood that, in the database and the data table, the data are displayed by using the Chinese language, so that the data reading by the user can be facilitated, the character set type of the first table to be detected is set, Chinese messy codes generated by the database corresponding to the non-UTF 8 type character set can be prevented, and the use experience of the user is improved.
TO facilitate understanding the above process of setting character set types, please refer TO fig. 5(d-1), and fig. 5(d-1) is a schematic diagram of another TABLE TO be detected according TO an embodiment of the present invention, it can be seen that the character set type of the first TABLE TO be detected is a "Latin" character set, and the character set type of the first TABLE TO be detected can be converted from the "Latin" character set TO a UTF8 type character set by instructing "ALTER TABLE active mq.
In an alternative embodiment, the inodb is an index organization table, the primary key is equivalent to a directory of the dictionary, and on the basis of fig. 2, taking an example that a preset rule includes the primary key of a table to be detected, please refer to fig. 5(e), where fig. 5(e) is a schematic flow chart of another data table detection method provided in the embodiment of the present invention. The above S302 may further include:
s302e-1, whether the first table to be detected has a main key is judged.
It should be understood that if the first table to be detected has a primary key, the data in the first table to be detected can be read and written more effectively; the actual read-write performance of the data table without the primary key (the first table to be detected) is poor, and the data processing efficiency is affected. For example, the tool "information method search result" may be used to determine whether the first table to be detected has a primary key.
If the first table to be detected does not have the primary key, go to S302 e-2; if the first table to be detected has the primary key, then execution proceeds to S302 e-3.
S302e-2, sending the information of the no main key of the first table to be detected to the display end, so that the display end displays the information of the no main key.
S302e-3, determining that the configuration of the primary key of the first table to be detected meets the preset rule.
It should be understood that the preset rule of the first table to be detected here is that the first table to be detected must have a primary key in order to improve the read/write performance of the first table to be detected.
By judging whether the first table to be detected has the main key or not, when the first table to be detected has the main key, the read-write performance of the first table to be detected is favorably improved, and the data processing efficiency is further improved.
It should be noted that the above-mentioned S302 a-S302 e may be performed in parallel, or may have a logical order; in addition, the data table inspection method provided in the embodiment of the present invention may include the step of any one of the determinations in S302a through S302e, and may further include a combination of the determinations in S302a through S302e, and a specific implementation manner and content of the combination may be determined according to a requirement of an actual table to be inspected, which is not limited herein.
For easy understanding of the preset rule, please refer to fig. 5(f), and fig. 5(f) is a display interface diagram of a display terminal according to an embodiment of the present invention. It can be understood that, the user may set fields such as service name and time at the display end to filter a plurality of entries to be optimized, and fig. 5(f) shows table information without a primary key; it should be understood that other conditions may also be filtered, such as storage engine, primary key, character set, index, and table size (i.e., the total amount of data size of the table), etc.
In an optional embodiment, in a case that the application system may automatically optimize the table to be detected, the preset user may also optimize the table to be detected, and a possible implementation manner is provided on the basis of fig. 2, please refer to fig. 6, and fig. 6 is a schematic flow diagram of another data table detection method provided in the embodiment of the present invention. After S304, the method may further include:
s313, receiving a table modification instruction of a preset user.
The table modification instruction may be to modify an index setting specifying the table to be detected, split the table to be detected, or the like.
S314, sending a table updating instruction corresponding to the table modifying instruction to the table set to be detected, so that the table set to be detected updates the first table to be detected according to the table updating instruction.
It should be understood that the updated first table to be detected meets the preset rule, that is, the table modification instruction of the preset user should meet the preset rule.
By receiving the table modification instruction of the preset user, even if the application system does not find the unreasonable table items or the table items to be optimized of the table to be detected in time, the table modification instruction can be sent through manual intervention, so that the table to be detected can be updated and optimized, and the working efficiency of using the data table is improved.
In order to implement any one of the above data table detection methods, an embodiment of the present invention provides a data table detection apparatus, please refer to fig. 7, and fig. 7 is a block diagram illustrating the data table detection apparatus according to the embodiment of the present invention. The data table detecting device 40 includes: an acquisition module 41, a determination module 42, an execution module 43, and a communication module 44.
The obtaining module 41 is configured to obtain a first table to be detected from a set of tables to be detected. The first table to be detected is any table to be detected in the table set to be detected.
The determining module 42 is configured to determine whether the first table to be detected meets a preset rule.
The executing module 43 is configured to determine at least one to-be-optimized entry in the first to-be-detected table when the first to-be-detected table does not meet the preset rule. The table entry to be optimized is the table entry in the first table to be detected, which meets the table optimization rule.
The communication module 44 is configured to send the entry to be optimized to the display end, so that the display end displays the entry to be optimized.
It should be understood that the obtaining module 41, the judging module 42, the executing module 43 and the communication module 44 may cooperatively implement the above-mentioned S301 to S305 and possible sub-steps thereof.
In an optional embodiment, the executing module 43 is further configured to generate target entry information corresponding to the entry to be optimized according to a preset rule. The communication module 44 is further configured to send the target table item information to the table set to be detected, so that the table set to be detected updates the first table to be detected according to the target table item information. The determining module 42 is further configured to determine whether the update success information sent by the table set to be detected is received within the first time. And the updating success information is used for indicating that the updated first table to be detected in the table set to be detected conforms to a preset rule. The executing module 43 is further configured to determine that the first table to be detected is updated successfully when the update success information is received within the first time.
It should be understood that the obtaining module 41, the judging module 42, the executing module 43 and the communication module 44 may cooperatively implement the above-mentioned S306 to S312 and possible sub-steps thereof.
In an alternative embodiment, the determining module 42 is further configured to determine whether an update approval instruction of the preset user is received within the second time. The execution module 43 is further configured to send the target table item information to the table set to be detected when receiving the update approval instruction within the second time, so that the table set to be detected updates the first table to be detected according to the target table item information.
It should be understood that the determining module 42 and the executing module 43 may cooperatively implement the above-mentioned S307 to S309 and possible sub-steps thereof.
In an alternative embodiment, the determining module 42 is further configured to determine whether the storage engine of the first table to be detected is an InnoDB engine; the execution module 43 is further configured to modify the storage engine of the first table to be detected into an InnoDB engine when the storage engine of the first table to be detected is not an InnoDB engine. The judging module 42 is further configured to judge whether the total data amount of the first table to be detected is less than or equal to a first preset value; the execution module 43 is further configured to send the data amount exceeding information of the first table to be detected to the display end when the total data amount of the first table to be detected is greater than the first preset value, so that the display end displays the data amount exceeding information. The judging module 42 is further configured to judge whether the index frequency of the first table to be detected is less than or equal to an index preset value; the execution module 43 is further configured to send the index exceeding information of the first table to be detected to the display end when the index frequency of the first table to be detected is greater than the index preset value, so that the display end displays the index exceeding information. The judging module 42 is further configured to judge whether the character set type of the first table to be detected is a preset character set type; the executing module 43 is further configured to modify the character set type of the first table to be detected to be the preset character set type when the character set type of the first table to be detected is not the preset character set type. The judging module 42 is further configured to judge whether the first table to be detected has a primary key; the executing module 43 is further configured to send information of no primary key of the first table to be detected to the display end when the first table to be detected does not have a primary key, so that the display end displays the information of no primary key.
It should be understood that the determination module 42 and the execution module 43 may cooperatively implement the above-mentioned S302 a-1-S302 a-3, S302 b-1-S302 b-3, S302 c-1-S302 c-3, S302 d-1-S302 d-3, S302 e-1-S302 e-3, and possible sub-steps thereof.
In an alternative embodiment, the communication module 44 is further configured to receive a table modification instruction of a preset user. The communication module 44 is further configured to send a table updating instruction corresponding to the table modifying instruction to the table set to be detected, so that the table set to be detected updates the first table to be detected according to the table updating instruction, and the updated first table to be detected meets the preset rule.
It should be understood that the communication module 44 may also implement the above-described S313 to S314 and possible sub-steps thereof.
An electronic device according to an embodiment of the present invention is provided, and fig. 8 is a block diagram of an electronic device according to an embodiment of the present invention. The electronic device 60 comprises a memory 61, a processor 62 and a communication interface 63. The memory 61, processor 62 and communication interface 63 are electrically connected to each other, directly or indirectly, to enable transmission or interaction of data. For example, the components may be electrically connected to each other via one or more communication buses or signal lines. The memory 61 may be used to store software programs and modules, such as program instructions/modules corresponding to the data table detection method provided in the embodiment of the present invention, and the processor 62 executes various functional applications and data processing by executing the software programs and modules stored in the memory 61. The communication interface 63 may be used for communicating signaling or data with other node devices. The electronic device 60 may have a plurality of communication interfaces 63 in the present invention.
The Memory 61 may be, but is not limited to, a Random Access Memory (RAM), a Read Only Memory (ROM), a Programmable Read-Only Memory (PROM), an Erasable Read-Only Memory (EPROM), an electrically Erasable Read-Only Memory (EEPROM), and the like.
The processor 62 may be an integrated circuit chip having signal processing capabilities. The processor may be a general-purpose processor including a Central Processing Unit (CPU), a Network Processor (NP), and the like; but may also be a Digital Signal Processor (DSP), an Application Specific Integrated Circuit (ASIC), a Field Programmable Gate Array (FPGA) or other Programmable logic device, discrete Gate or transistor logic, discrete hardware components, etc.
The electronic device 60 may implement any of the data table detection methods provided by the present invention. The electronic device 60 may be, but is not limited to, a cell phone, a tablet computer, a notebook computer, a server, or other electronic device with processing capabilities.
In the embodiments provided in the present invention, it should be understood that the disclosed apparatus and method can be implemented in other ways. The apparatus embodiments described above are merely illustrative, and for example, the flowchart and block diagrams in the figures illustrate the architecture, functionality, and operation of possible implementations of apparatus, methods and computer program products according to various embodiments of the present invention. In this regard, each block in the flowchart or block diagrams may represent a module, segment, or portion of code, which comprises one or more executable instructions for implementing the specified logical function(s). It should also be noted that, in some alternative implementations, the functions noted in the block may occur out of the order noted in the figures. For example, two blocks shown in succession may, in fact, be executed substantially concurrently, or the blocks may sometimes be executed in the reverse order, depending upon the functionality involved. It will also be noted that each block of the block diagrams and/or flowchart illustration, and combinations of blocks in the block diagrams and/or flowchart illustration, can be implemented by special purpose hardware-based systems which perform the specified functions or acts, or combinations of special purpose hardware and computer instructions.
In addition, the functional modules in the embodiments of the present invention may be integrated together to form an independent part, or each module may exist separately, or two or more modules may be integrated to form an independent part.
The functions of the present invention, if implemented in the form of software functional modules 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 invention may be embodied in the form of 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 invention. And the aforementioned storage medium includes: various media capable of storing program codes, such as a U disk, a removable hard disk, a RAM, a ROM, a magnetic disk, or an optical disk.
In summary, the present invention provides a method and an apparatus for detecting a data table, an electronic device and a computer-readable storage medium. The method comprises the following steps: acquiring a first table to be detected from a table set to be detected; the first table to be detected is any table to be detected in the table set to be detected; judging whether the first table to be detected meets a preset rule or not; if not, determining at least one table entry to be optimized in the first table to be detected; the table items to be optimized are table items in the first table to be detected, which accord with the table optimization rule; and sending the list items to be optimized to a display end so that the display end displays the list items to be optimized. The machine is used for judging whether the table to be detected conforms to the preset rule or not, the table item to be optimized in the table to be detected is determined, the table item to be optimized is sent to the display end, and a user can see the table item information to be optimized of the table to be detected at the display end so as to optimize or perform other processing on the table to be detected, and the rationality and the high efficiency of the data table are maintained.
The above description is only a preferred embodiment of the present invention and is not intended to limit the present invention, and various modifications and changes may be made by those skilled in the art. Any modification, equivalent replacement, or improvement made within the spirit and principle of the present invention should be included in the protection scope of the present invention.
Claims (10)
1. A method for data table detection, the method comprising:
acquiring a first table to be detected from a table set to be detected; the first table to be detected is any table to be detected in the table set to be detected;
judging whether the first table to be detected meets a preset rule or not;
if not, determining at least one to-be-optimized table entry in the first to-be-detected table;
the table entry to be optimized is a table entry in the first table to be detected, which meets the table optimization rule;
and sending the list item to be optimized to a display end so that the display end displays the list item to be optimized.
2. The method according to claim 1, wherein after said determining at least one to-be-optimized entry in the first to-be-detected table according to the preset rule, the method further comprises:
generating target table item information corresponding to the table item to be optimized according to the preset rule;
sending the target table item information to the table set to be detected so that the table set to be detected updates the first table to be detected according to the target table item information;
judging whether updating success information sent by the table set to be detected is received within a first time; the update success information is used for indicating that the updated first table to be detected in the table set to be detected conforms to the preset rule;
and if so, determining that the first table to be detected is updated successfully.
3. The method according to claim 2, wherein before the sending the target table entry information to the set of tables to be detected so that the set of tables to be detected updates the first table to be detected according to the target table entry information, the method further comprises:
judging whether an update consent instruction of a preset user is received within a second time;
and if so, executing the step of sending the target table item information to the table set to be detected so that the table set to be detected updates the first table to be detected according to the target table item information.
4. The method according to any one of claims 1 to 3, wherein the determining whether the first table to be detected meets a preset rule comprises:
judging whether a storage engine of the first table to be detected is an InNODB engine or not;
if not, modifying the storage engine of the first table to be detected into the InNODB engine;
and/or judging whether the total data amount of the first table to be detected is less than or equal to a first preset value;
if not, sending the data volume exceeding information of the first table to be detected to the display end so that the display end displays the data volume exceeding information;
and/or judging whether the index times of the first table to be detected is less than or equal to an index preset value;
if not, sending the index overproof information of the first table to be detected to the display end so that the display end displays the index overproof information;
and/or, judging whether the character set type of the first table to be detected is a preset character set type;
if not, modifying the character set type of the first table to be detected into a preset character set type;
and/or, judging whether the first table to be detected has a main key;
if not, the information without the main key of the first table to be detected is sent to the display end, so that the display end displays the information without the main key.
5. The method according to claim 1, wherein after said determining at least one to-be-optimized entry in the first to-be-detected table according to the preset rule, the method further comprises:
receiving a table modification instruction of a preset user;
and sending a table updating instruction corresponding to the table modifying instruction to the table set to be detected so that the table set to be detected updates the first table to be detected according to the table updating instruction, wherein the updated first table to be detected conforms to the preset rule.
6. A spreadsheet detection apparatus, said apparatus comprising: the device comprises an acquisition module, a judgment module, an execution module and a communication module;
the acquisition module is used for acquiring a first table to be detected from the set of tables to be detected; the first table to be detected is any table to be detected in the table set to be detected;
the judging module is used for judging whether the first table to be detected meets a preset rule or not;
the execution module is used for determining at least one to-be-optimized table entry in the first to-be-detected table when the first to-be-detected table does not accord with the preset rule;
the table entry to be optimized is a table entry in the first table to be detected, which meets the table optimization rule;
and the communication module is used for sending the item to be optimized to a display end so that the display end displays the item to be optimized.
7. The apparatus according to claim 6, wherein the execution module is further configured to generate target entry information corresponding to the entry to be optimized according to the preset rule;
the communication module is further configured to send the target table item information to the table set to be detected, so that the table set to be detected updates the first table to be detected according to the target table item information;
the judging module is also used for judging whether the updating success information sent by the table set to be detected is received in the first time; the update success information is used for indicating that the updated first table to be detected in the table set to be detected conforms to the preset rule;
the execution module is further configured to determine that the first table to be detected is updated successfully when the update success information is received in the first time.
8. The apparatus according to claim 7, wherein the determining module is further configured to determine whether an update approval command of a preset user is received within a second time;
the execution module is further configured to send the target table entry information to the table set to be detected when the update approval instruction is received within the second time, so that the table set to be detected updates the first table to be detected according to the target table entry information.
9. An electronic device comprising a processor and a memory, the memory storing machine executable instructions executable by the processor to perform the method of any one of claims 1 to 5.
10. A computer-readable storage medium, on which a computer program is stored, which, when being executed by a processor, is adapted to carry out the method of any one of claims 1 to 5.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010097091.0A CN111324593A (en) | 2020-02-17 | 2020-02-17 | Data table detection method and device, electronic equipment and computer readable storage medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010097091.0A CN111324593A (en) | 2020-02-17 | 2020-02-17 | Data table detection method and device, electronic equipment and computer readable storage medium |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN111324593A true CN111324593A (en) | 2020-06-23 |
Family
ID=71172783
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202010097091.0A Pending CN111324593A (en) | 2020-02-17 | 2020-02-17 | Data table detection method and device, electronic equipment and computer readable storage medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN111324593A (en) |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111773728A (en) * | 2020-07-09 | 2020-10-16 | 网易（杭州）网络有限公司 | Data table testing method, device, equipment and storage medium |
| CN112051985A (en) * | 2020-07-23 | 2020-12-08 | 北京奇艺世纪科技有限公司 | Event triggering method and device, electronic equipment and readable storage medium |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN108874644A (en) * | 2018-06-06 | 2018-11-23 | 平安科技（深圳）有限公司 | Data monitoring method, device, computer equipment and storage medium |
| CN109815094A (en) * | 2019-01-04 | 2019-05-28 | 平安科技（深圳）有限公司 | Monitoring method, device, equipment and the computer readable storage medium of tables of data |
| CN110297742A (en) * | 2019-07-04 | 2019-10-01 | 北京百佑科技有限公司 | Data monitoring system, method and server |
-
2020
- 2020-02-17 CN CN202010097091.0A patent/CN111324593A/en active Pending
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN108874644A (en) * | 2018-06-06 | 2018-11-23 | 平安科技（深圳）有限公司 | Data monitoring method, device, computer equipment and storage medium |
| CN109815094A (en) * | 2019-01-04 | 2019-05-28 | 平安科技（深圳）有限公司 | Monitoring method, device, equipment and the computer readable storage medium of tables of data |
| CN110297742A (en) * | 2019-07-04 | 2019-10-01 | 北京百佑科技有限公司 | Data monitoring system, method and server |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111773728A (en) * | 2020-07-09 | 2020-10-16 | 网易（杭州）网络有限公司 | Data table testing method, device, equipment and storage medium |
| CN112051985A (en) * | 2020-07-23 | 2020-12-08 | 北京奇艺世纪科技有限公司 | Event triggering method and device, electronic equipment and readable storage medium |
| CN112051985B (en) * | 2020-07-23 | 2023-07-25 | 北京奇艺世纪科技有限公司 | Event triggering method, device, electronic equipment and readable storage medium |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN108228817B (en) | Data processing method, device and system | |
| US9626368B2 (en) | Document merge based on knowledge of document schema | |
| US8108360B2 (en) | Database object update order determination | |
| CN112559554A (en) | Query statement optimization method and device | |
| CN111708805A (en) | Data query method and device, electronic equipment and storage medium | |
| CN111324593A (en) | Data table detection method and device, electronic equipment and computer readable storage medium | |
| US20210191921A1 (en) | Method, apparatus, device and storage medium for data aggregation | |
| JP2022548605A (en) | Spreadsheets with dynamic database queries | |
| CN112416991A (en) | Data processing method and device and storage medium | |
| CN115617888A (en) | Data import method, device, equipment, storage medium and product | |
| CN116701355A (en) | Data view processing method, device, computer equipment and readable storage medium | |
| CN116127047A (en) | Method and device for establishing enterprise information base | |
| CN112035566B (en) | Data calling method and device, electronic equipment and storage medium | |
| CN115328898A (en) | Data processing method and device, electronic equipment and medium | |
| CN113868138A (en) | Method, system, equipment and storage medium for acquiring test data | |
| RU2650032C1 (en) | Electronic database and method of its formation | |
| US11604629B1 (en) | Automatic workflow generation based on annotated code statements | |
| CN115981657A (en) | Code generation method and device, electronic equipment and readable medium | |
| CN115357628A (en) | Data report generation method and device, computer equipment and storage medium | |
| CN114443035A (en) | Code generation method for application program, code generator, electronic device, and medium | |
| CN117851239A (en) | Data generation method, device and equipment of test database and storage medium | |
| CN117609186A (en) | Database migration data comparison method, device, electronic equipment and storage medium | |
| CN115510068A (en) | Table space moving method, device, equipment and storage medium | |
| CN116737594A (en) | Test case conversion method and device | |
| CN115544995A (en) | Table information processing method and device, electronic equipment and storage medium |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination |