CN110990284A - Database standard checking method and device - Google Patents
Database standard checking method and device Download PDFInfo
- Publication number
- CN110990284A CN110990284A CN201911248386.7A CN201911248386A CN110990284A CN 110990284 A CN110990284 A CN 110990284A CN 201911248386 A CN201911248386 A CN 201911248386A CN 110990284 A CN110990284 A CN 110990284A
- Authority
- CN
- China
- Prior art keywords
- database
- checking
- checked
- check
- standard
- 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
- 238000000034 method Methods 0.000 title claims abstract description 46
- 238000013515 script Methods 0.000 claims description 32
- 238000005457 optimization Methods 0.000 claims description 25
- 238000004590 computer program Methods 0.000 claims description 18
- 238000003860 storage Methods 0.000 claims description 15
- 238000010586 diagram Methods 0.000 description 18
- 230000006870 function Effects 0.000 description 12
- 238000011161 development Methods 0.000 description 7
- 238000004891 communication Methods 0.000 description 6
- 238000007689 inspection Methods 0.000 description 6
- 238000004519 manufacturing process Methods 0.000 description 6
- 238000012545 processing Methods 0.000 description 6
- 238000012360 testing method Methods 0.000 description 6
- 230000001960 triggered effect Effects 0.000 description 4
- 230000008569 process Effects 0.000 description 3
- 230000006399 behavior Effects 0.000 description 2
- 238000012937 correction Methods 0.000 description 2
- 230000003287 optical effect Effects 0.000 description 2
- 238000009825 accumulation Methods 0.000 description 1
- 238000010276 construction Methods 0.000 description 1
- 238000005516 engineering process Methods 0.000 description 1
- 238000012423 maintenance Methods 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 238000006467 substitution reaction Methods 0.000 description 1
- 238000012549 training Methods 0.000 description 1
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F11/00—Error detection; Error correction; Monitoring
- G06F11/36—Preventing errors by testing or debugging software
- G06F11/3604—Software analysis for verifying properties of programs
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Software Systems (AREA)
- Computer Hardware Design (AREA)
- Quality & Reliability (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Stored Programmes (AREA)
Abstract
The invention provides a database specification checking method and a device, wherein the method comprises the following steps: executing a database standard checking task to perform standard checking on a database to be checked to obtain a checking result of the database to be checked; and storing the checking result of the database to be checked. The device is used for executing the method. The database specification checking method and device provided by the embodiment of the invention can automatically check the database, and improve the efficiency of checking the database.
Description
Technical Field
The invention relates to the technical field of computers, in particular to a database standard checking method and device.
Background
Database products play an indispensable role in the current information technology system, and have rich and various functional characteristics. With the development of the network era, higher and higher requirements are put forward on the reliability of the database.
With the accumulation of the use experience of the database and the construction of the expert ability of the database, in the process of using various database products for a long time by enterprises, the use rules of each database function point are summarized according to the characteristics, operation and maintenance fault processing experience and the like of each database, the detailed use rules are made, the database specifications are accumulated continuously and formed, developers can use the database correctly according to the database specifications, the operation faults of the database can be reduced, and the best performance of the database can be exerted. In the using process of the database, developers who are used as the main force of the database use the database can not understand the database deeply and can not use the database completely according to the database specification, so that the performance of the database is reduced, and even the database can not provide services. In the prior art, in order to standardize the use of a database, the method of training and the like is adopted to improve the understanding of developers on the use standard of the database, and the source codes operated by the database are subjected to spot check and assessment manually, but the checking efficiency is low, and the condition that the use of the database is not in accordance with the standard still exists, so that the database has the risk of failure caused by the use of the database which is not in accordance with the standard.
Disclosure of Invention
To solve the problems in the prior art, embodiments of the present invention provide a database specification checking method and apparatus, which can at least partially solve the problems in the prior art.
In one aspect, the present invention provides a database specification checking method, including:
executing a database standard checking task to perform standard checking on a database to be checked to obtain a checking result of the database to be checked;
and storing the checking result of the database to be checked.
In another aspect, the present invention provides a database specification checking apparatus, including:
the execution unit is used for executing a database standard check task to perform standard check on a database to be checked to obtain a check result of the database to be checked;
and the storage unit is used for storing the checking result of the database to be checked.
In another aspect, the present invention provides an electronic device, which includes a memory, a processor, and a computer program stored in the memory and executable on the processor, where the processor executes the computer program to implement the steps of the database specification checking method according to any of the above embodiments.
In yet another aspect, the present invention provides a computer-readable storage medium, on which a computer program is stored, which, when being executed by a processor, implements the steps of the database specification checking method according to any one of the above embodiments.
According to the database standard checking method and device provided by the embodiment of the invention, the database standard checking task is executed to carry out standard checking on the database to be checked, the checking result of the database to be checked is obtained, and then the checking result of the database to be checked is stored, so that the database can be automatically checked, and the database checking efficiency is improved.
Drawings
In order to more clearly illustrate the embodiments of the present invention or the technical solutions in the prior art, the drawings used in the description of the embodiments or the prior art will be briefly described below, it is obvious that the drawings in the following description are only some embodiments of the present invention, and for those skilled in the art, other drawings can be obtained according to the drawings without creative efforts. In the drawings:
fig. 1 is a schematic flowchart of a database specification checking method according to an embodiment of the present invention.
Fig. 2 is a schematic flowchart of a database specification checking method according to another embodiment of the present invention.
Fig. 3 is a flowchart illustrating a database specification checking method according to another embodiment of the present invention.
Fig. 4 is a schematic structural diagram of a database specification checking apparatus according to an embodiment of the present invention.
Fig. 5 is a schematic structural diagram of a database specification checking apparatus according to another embodiment of the present invention.
Fig. 6 is a schematic structural diagram of a database specification checking apparatus according to yet another embodiment of the present invention.
Fig. 7 is a schematic structural diagram of a database specification checking apparatus according to still another embodiment of the present invention.
Fig. 8 is a schematic physical structure diagram of an electronic device according to an embodiment of the present invention.
Detailed Description
In order to make the objects, technical solutions and advantages of the embodiments of the present invention more apparent, the embodiments of the present invention are further described in detail below with reference to the accompanying drawings. The exemplary embodiments and descriptions of the present invention are provided to explain the present invention, but not to limit the present invention. It should be noted that the embodiments and features of the embodiments in the present application may be arbitrarily combined with each other without conflict.
The operating environment of the database includes a development environment, a test environment, and a production environment. For a development environment and a test environment, the database can be directly connected for performing standard database check, and for a production environment, a check script for performing standard database check is generally required to be deployed when the database is on line, the check script is automatically executed through timing task configuration, a check result is stored, and the stored check result is uploaded. In the production environment, the timing task of the check script can be configured in the idle period of the system, so as to avoid influencing the normal service of the system. For convenience of explaining the technical solution of the present application, the following describes the database specification checking method provided in the embodiment of the present invention with a server as an execution subject. It can be understood that the execution subject of the database specification checking method provided by the embodiment of the present invention includes, but is not limited to, a server.
Fig. 1 is a schematic flow chart of a database specification checking method according to an embodiment of the present invention, and as shown in fig. 1, the database specification checking method according to the embodiment of the present invention includes:
s101, executing a database standard checking task to perform standard checking on a database to be checked to obtain a checking result of the database to be checked;
specifically, in order to perform standard check on the database to be checked, the database standard check task may be triggered manually or triggered automatically at regular time, and the server may perform the database standard check task to perform standard check on the database to be checked, so as to obtain a check result of the database to be checked.
For example, the server may obtain at least one item of canonical check item information from a canonical check item table, where the canonical check item information includes a check item number and a corresponding check script, and then execute the check scripts corresponding to the check item number one by one, thereby implementing canonical check on the database to be checked. Wherein the specification check item table is preset.
And S102, storing the checking result of the database to be checked.
Specifically, after the server obtains the check result of the database to be checked, the server can store the check result of the database to be checked for checking by a manager of the database.
The database standard checking method provided by the embodiment of the invention can perform the database standard checking task to carry out the standard checking on the database to be checked to obtain the checking result of the database to be checked, then stores the checking result of the database to be checked, can automatically check the database, and improves the efficiency of checking the database. In addition, through automatic checking of the database, the problem that the database is not in accordance with the standard can be found in time, the risk of running faults of the database is reduced, and the reliability of the database is improved.
Fig. 2 is a schematic flow chart of a database specification checking method according to another embodiment of the present invention, and as shown in fig. 2, on the basis of the foregoing embodiments, further performing a database specification checking task to perform specification checking on a database to be checked includes:
s1011, acquiring at least one item of standard checking item information from the standard checking item table, wherein the item information of the standard checking item comprises a checking item number and a corresponding checking script; wherein the specification check item table is preset;
specifically, a specification check item table may be preset, and the specification check item table may include a check item number, a check item name, a check item script, an optimization suggestion, and the like. The inspection item number is used to associate the inspection script, the inspection result, and the optimization suggestion. The name of the check item can be derived from a database specification, the database specification is a text description and comprises detailed use rules of the database, and the function of the check item is convenient to understand through the name of the check item. A checking script, i.e. an application developed from the textual description of the database specification, is used to check whether there is a usage behavior violating the database specification. The optimization suggestion is that after a problem is checked, a countermeasure is suggested to be taken, and the setting is performed according to actual experience, and the embodiment of the invention is not limited. When the server executes a database specification checking task, at least one item of specification checking item information is acquired from the specification checking item table so as to acquire a checking script to be executed. The standard checking item information includes a checking item number and a corresponding checking script, which are set according to actual needs.
And S1012, executing the checking scripts corresponding to the checking item numbers one by one.
Specifically, after the server obtains the standard check item information, the server executes the check scripts corresponding to the check item numbers of the standard check information one by one, and after the execution of the check script corresponding to each check item number is completed, the server can obtain the check result corresponding to each check item number, and the check result corresponding to each check item number constitutes the check result of the database to be checked.
For example, table 1 is a canonical check item table, which is checked against the Oracle database, and includes a check item number, a check item name, a check script, and an optimization suggestion. The check item number corresponds to a check item name, a check script, and an optimization suggestion. The Oracle database specification comprises a specification of 'parallelism of tables and indexes can not be set when tables are built', the Oracle database uses a default field of a user _ tables and a user _ indexes system table to respectively record whether the parallelism of the user table or the index is started, therefore, the related fields of the user _ tables and the user _ indexes system table can be inquired to judge which tables and indexes start the parallelism, if the parallelism is started, the Oracle database specification is not met, and if the parallelism is not started, the Oracle database specification is met. The check script corresponding to the check item number 1001 is a check script developed in a standardized manner, that is, the parallelism of a table and an index must not be set at the time of creating the table. The optimization suggestion corresponding to the check item number 1001 is to close the parallelism, that is, modify the table and index with the parallelism opened to close the parallelism, and develop the corresponding optimization script.
Table 1 specification examination item table
Code 1: SELECT '1001' ITEM _ ID, TABLE _ NAME, "INDEX _ NAME," TABLE ' OBJECT _ TYPE, depth FROM USER _ blocks WHERE TRIM (depth) < > '1' UNION ALL SELECT '1001' ITEM _ ID, TABLE _ NAME, INDEX _ NAME, ' INDEX ' OBJECT _ TYPE, depth FROM USER _ entries WHERE TRIM (depth) < > '1' AND INDEX _ NAME NOT ' SYS _ IL% "or BY ' 2, 3;
code 2: SELECT ' ALTER TABLE ' | TABLE _ NAME | | ' nonparamale; 'FROM USER _ TABLESSWHERE TRIM (DEGRE) < >'1'UNION ALL SELECT' ALTER INDEX '| INDEX _ NAME |' NOPARALLEL; ' FROM USER _ INDEXES WHERE TRIM (DEGRE) < > '1' AND INDEX _ NAME NOT LIKE ' SYS _ IL% '.
Fig. 3 is a schematic flow chart of a database specification checking method according to another embodiment of the present invention, as shown in fig. 3, further, on the basis of the foregoing embodiments, before performing a database specification checking task to perform specification checking on a database to be checked and obtaining a checking result of the database to be checked, the method further includes:
s301, acquiring connection information of the database to be checked from a database information table; wherein the database information table is preset;
specifically, for a development environment and a test environment, the database standard checking of the to-be-checked database can be directly connected, and before the to-be-checked database is connected, the connection information of the to-be-checked database needs to be acquired. The server can obtain the connection information of the database to be checked from a database information table. The database information table is preset and stores the connection information of the database to be checked. The connection information of the database may include an IP address and a port number, which are set according to actual needs, and the embodiment of the present invention is not limited.
And S302, connecting the database to be checked according to the connection information.
Specifically, after the server obtains the connection information of the database to be checked, the server can establish connection with the database to be checked according to the connection information of the database to be checked, and then perform database standard checking on the database to be checked. It can be understood that after the database standard check is completed on the database to be checked, the connection with the database to be checked is disconnected.
On the basis of the foregoing embodiments, further, the database specification checking method provided in the embodiment of the present invention further includes:
and outputting the checking result of the database to be checked and the corresponding optimization suggestion.
Specifically, the server can output the checking result of the database to be checked and the corresponding optimization suggestion, and the manager of the database to be checked can check the checking result of the database to be checked and the corresponding optimization suggestion through the server. And for the data which does not conform to the database standard and appears in the checking result of the database to be checked, the manager of the database to be checked can inform related developers to carry out rectification according to optimization suggestions. The manager of the database to be checked can also compare checking results of the database to be checked at different times, and can check the correction condition of developers. Meanwhile, checking results of different operation environments of the same database can be compared, functions of the newly-on-line database can be generally executed through a development environment and a test environment, the functions of the newly-on-line database can be checked and optimized through comparison, problems can be found early and rectified, and hidden dangers are eliminated. The checking of the production environment is to check the existing hidden danger which does not accord with the database standard, and can be rectified according to the optimization suggestion to eliminate the hidden danger. The output of the checking result of the database to be checked and the corresponding optimization suggestion can be realized in a WEB application mode.
For example, table 2 is a checking result of the database to be checked, and as shown in table 2, the checking result includes a checking item number and details. The optimization suggestion corresponding to the check item number can be obtained by querying the check item number from table 1.
TABLE 2 examination of the results
Fig. 4 is a schematic structural diagram of a database specification checking apparatus according to an embodiment of the present invention, and as shown in fig. 4, the database specification checking apparatus according to the embodiment of the present invention includes an execution unit 401 and a storage unit 402, where:
the execution unit 401 is configured to perform a database standard check task to perform standard check on a database to be checked, and obtain a check result of the database to be checked; the storage unit 402 is configured to store a checking result of the database to be checked.
Specifically, in order to perform standard check on the database to be checked, the database standard check task may be triggered manually or triggered automatically at regular time, and the execution unit 401 may perform the database standard check task to perform standard check on the database to be checked, so as to obtain a check result of the database to be checked.
Specifically, after obtaining the check result of the database to be checked, the storage unit 402 may store the check result of the database to be checked for the administrator of the database to view.
The database standard checking device provided by the embodiment of the invention can perform the database standard checking task to carry out standard checking on the database to be checked to obtain the checking result of the database to be checked, then store the checking result of the database to be checked, can automatically check the database and improve the efficiency of checking the database. In addition, through automatic checking of the database, the problem that the database is not in accordance with the standard can be found in time, the risk of running faults of the database is reduced, and the reliability of the database is improved.
Fig. 5 is a schematic structural diagram of a database specification checking apparatus according to another embodiment of the present invention, and as shown in fig. 5, on the basis of the foregoing embodiments, the execution unit 401 further includes an obtaining sub-unit 4011 and an execution sub-unit 4012, where:
the obtaining sub-unit 4011 is configured to obtain at least one item of canonical check item information from the canonical check item table, where the canonical check item information includes a check item number and a corresponding check script; wherein the specification check item table is preset; the execution sub-unit 4012 is configured to execute the check scripts corresponding to the check item numbers one by one.
Specifically, a specification check item table may be preset, and the specification check item table may include a check item number, a check item name, a check item script, an optimization suggestion, and the like. The inspection item number is used to associate the inspection script, the inspection result, and the optimization suggestion. The name of the check item can be derived from a database specification, the database specification is a text description and comprises detailed use rules of the database, and the function of the check item is convenient to understand through the name of the check item. A checking script, i.e. an application developed from the textual description of the database specification, is used to check whether there is a usage behavior violating the database specification. The optimization suggestion is that after a problem is checked, a countermeasure is suggested to be taken, and the setting is performed according to actual experience, and the embodiment of the invention is not limited. When executing a database specification check task, the obtaining sub-unit 4011 obtains at least one item of specification check item information from the specification check item table, so as to obtain a check script to be executed. The standard checking item information includes a checking item number and a corresponding checking script, which are set according to actual needs.
Specifically, after the standard check item information is obtained, the execution sub-unit 4012 executes the check scripts corresponding to the check item numbers of the standard check information one by one, and after the execution of the check script corresponding to each check item number is completed, the check result corresponding to each check item number can be obtained, and the check result corresponding to each check item number constitutes the check result of the to-be-checked database.
Fig. 6 is a schematic structural diagram of a database specification checking apparatus according to yet another embodiment of the present invention, and as shown in fig. 6, on the basis of the foregoing embodiments, further, the database specification checking apparatus according to the embodiment of the present invention further includes an obtaining unit 403 and a connecting unit 404, where:
the obtaining unit 403 is configured to obtain connection information of the database to be checked from a database information table; wherein the database information table is preset; the connection unit 404 is configured to connect the database to be checked according to the connection information.
Specifically, for a development environment and a test environment, the database standard checking of the to-be-checked database can be directly connected, and before the to-be-checked database is connected, the connection information of the to-be-checked database needs to be acquired. The obtaining unit 403 may obtain connection information of the database to be checked from a database information table. The database information table is preset and stores the connection information of the database to be checked. The connection information of the database may include an IP address and a port number, which are set according to actual needs, and the embodiment of the present invention is not limited.
Specifically, after obtaining the connection information of the database to be checked, the connection unit 404 may establish a connection with the database to be checked according to the connection information of the database to be checked, and then perform database specification checking on the database to be checked. It can be understood that after the database standard check is completed on the database to be checked, the connection with the database to be checked is disconnected.
Fig. 7 is a schematic structural diagram of a database specification checking apparatus according to yet another embodiment of the present invention, and as shown in fig. 7, on the basis of the foregoing embodiments, further, the database specification checking apparatus according to the embodiment of the present invention further includes an output unit 405, where:
the output unit 405 is configured to output the checking result of the database to be checked and the corresponding optimization suggestion.
Specifically, the output unit 405 may output the checking result of the database to be checked and the corresponding optimization suggestion, and the administrator of the database to be checked may view the checking result of the database to be checked and the corresponding optimization suggestion through the output unit 405. And for the data which does not conform to the database standard and appears in the checking result of the database to be checked, the manager of the database to be checked can inform related developers to carry out rectification according to optimization suggestions. The manager of the database to be checked can also compare checking results of the database to be checked at different times, and can check the correction condition of developers. Meanwhile, checking results of different operation environments of the same database can be compared, functions of the newly-on-line database can be generally executed through a development environment and a test environment, the functions of the newly-on-line database can be checked and optimized through comparison, problems can be found early and rectified, and hidden dangers are eliminated. The checking of the production environment is to check the existing hidden danger which does not accord with the database standard, and can be rectified according to the optimization suggestion to eliminate the hidden danger. The output of the checking result of the database to be checked and the corresponding optimization suggestion can be realized in a WEB application mode.
The embodiment of the apparatus provided in the embodiment of the present invention may be specifically configured to execute the processing flows of the above method embodiments, and the functions of the apparatus are not described herein again, and refer to the detailed description of the above method embodiments.
Fig. 8 is a schematic physical structure diagram of an electronic device according to an embodiment of the present invention, and as shown in fig. 8, the electronic device may include: a processor (processor)801, a communication Interface (Communications Interface)802, a memory (memory)803 and a communication bus 804, wherein the processor 801, the communication Interface 802 and the memory 803 complete communication with each other through the communication bus 804. The processor 801 may call logic instructions in the memory 803 to perform the following method: executing a database standard checking task to perform standard checking on a database to be checked to obtain a checking result of the database to be checked; and storing the checking result of the database to be checked.
In addition, the logic instructions in the memory 803 may be implemented in the form of software functional units and stored in a computer readable storage medium when the logic instructions are sold or used as independent products. 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: a U-disk, a removable hard disk, a Read-Only Memory (ROM), a Random Access Memory (RAM), a magnetic disk or an optical disk, and other various media capable of storing program codes.
The present embodiment discloses a computer program product comprising a computer program stored on a non-transitory computer readable storage medium, the computer program comprising program instructions which, when executed by a computer, enable the computer to perform the method provided by the above-mentioned method embodiments, for example, comprising: executing a database standard checking task to perform standard checking on a database to be checked to obtain a checking result of the database to be checked; and storing the checking result of the database to be checked.
The present embodiment provides a computer-readable storage medium, which stores a computer program, where the computer program causes the computer to execute the method provided by the above method embodiments, for example, the method includes: executing a database standard checking task to perform standard checking on a database to be checked to obtain a checking result of the database to be checked; and storing the checking result of the database to be checked.
As will be appreciated by one skilled in the art, embodiments of the present invention may be provided as a method, system, or computer program product. Accordingly, the present invention may take the form of an entirely hardware embodiment, an entirely software embodiment or an embodiment combining software and hardware aspects. Furthermore, the present invention may take the form of a computer program product embodied on one or more computer-usable storage media (including, but not limited to, disk storage, CD-ROM, optical storage, and the like) having computer-usable program code embodied therein.
The present invention is described with reference to flowchart illustrations and/or block diagrams of methods, apparatus (systems), and computer program products according to embodiments of the invention. It will be understood that each flow and/or block of the flow diagrams and/or block diagrams, and combinations of flows and/or blocks in the flow diagrams and/or block diagrams, can be implemented by computer program instructions. These computer program instructions may be provided to a processor of a general purpose computer, special purpose computer, embedded processor, or other programmable data processing apparatus to produce a machine, such that the instructions, which execute via the processor of the computer or other programmable data processing apparatus, create means for implementing the functions specified in the flowchart flow or flows and/or block diagram block or blocks.
These computer program instructions may also be stored in a computer-readable memory that can direct a computer or other programmable data processing apparatus to function in a particular manner, such that the instructions stored in the computer-readable memory produce an article of manufacture including instruction means which implement the function specified in the flowchart flow or flows and/or block diagram block or blocks.
These computer program instructions may also be loaded onto a computer or other programmable data processing apparatus to cause a series of operational steps to be performed on the computer or other programmable apparatus to produce a computer implemented process such that the instructions which execute on the computer or other programmable apparatus provide steps for implementing the functions specified in the flowchart flow or flows and/or block diagram block or blocks.
In the description herein, reference to the description of the terms "one embodiment," "a particular embodiment," "some embodiments," "for example," "an example," "a particular example," or "some examples," etc., means that a particular feature, structure, material, or characteristic described in connection with the embodiment or example is included in at least one embodiment or example of the invention. In this specification, the schematic representations of the terms used above do not necessarily refer to the same embodiment or example. Furthermore, the particular features, structures, materials, or characteristics described may be combined in any suitable manner in any one or more embodiments or examples.
The above-mentioned embodiments are intended to illustrate the objects, technical solutions and advantages of the present invention in further detail, and it should be understood that the above-mentioned embodiments are only exemplary embodiments of the present invention, and are not intended to limit the scope of the present invention, and any modifications, equivalent substitutions, improvements and the like made within the spirit and principle of the present invention should be included in the scope of the present invention.
Claims (10)
1. A database specification checking method is characterized by comprising the following steps:
executing a database standard checking task to perform standard checking on a database to be checked to obtain a checking result of the database to be checked;
and storing the checking result of the database to be checked.
2. The method of claim 1, wherein the performing the database canonical check task to perform canonical check on the database to be checked comprises:
acquiring at least one item of standard checking item information from a standard checking item table, wherein the standard checking item information comprises a checking item number and a corresponding checking script; wherein the specification check item table is preset;
and executing the checking scripts corresponding to the checking item numbers one by one.
3. The method according to claim 1, wherein before performing the database canonical check task to perform canonical check on the database to be checked, and obtaining the check result of the database to be checked, the method further comprises:
acquiring connection information of the database to be checked from a database information table; wherein the database information table is preset;
and connecting the database to be checked according to the connection information.
4. The method of any of claims 1 to 3, further comprising:
and outputting the checking result of the database to be checked and the corresponding optimization suggestion.
5. A database specification checking apparatus, comprising:
the execution unit is used for executing a database standard check task to perform standard check on a database to be checked to obtain a check result of the database to be checked;
and the storage unit is used for storing the checking result of the database to be checked.
6. The apparatus of claim 5, wherein the execution unit comprises:
the acquisition subunit is used for acquiring at least one item of standard check item information from a standard check item table, wherein the standard check item information comprises a check item number and a corresponding check script; wherein the specification check item table is preset;
and the execution subunit is used for executing the checking scripts corresponding to the checking item numbers one by one.
7. The apparatus of claim 5, further comprising:
the acquisition unit is used for acquiring the connection information of the database to be checked from a database information table; wherein the database information table is preset;
and the connecting unit is used for connecting the database to be checked according to the connecting information.
8. The apparatus of any one of claims 5 to 7, further comprising:
and the output unit is used for outputting the checking result of the database to be checked and the corresponding optimization suggestion.
9. An electronic device comprising a memory, a processor and a computer program stored on the memory and executable on the processor, characterized in that the steps of the method of any of claims 1 to 4 are implemented when the computer program is executed by the processor.
10. A computer-readable storage medium, on which a computer program is stored, which, when being executed by a processor, carries out the steps of the method of any one of claims 1 to 4.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201911248386.7A CN110990284A (en) | 2019-12-09 | 2019-12-09 | Database standard checking method and device |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201911248386.7A CN110990284A (en) | 2019-12-09 | 2019-12-09 | Database standard checking method and device |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN110990284A true CN110990284A (en) | 2020-04-10 |
Family
ID=70091104
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201911248386.7A Pending CN110990284A (en) | 2019-12-09 | 2019-12-09 | Database standard checking method and device |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN110990284A (en) |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20170329582A1 (en) * | 2016-05-15 | 2017-11-16 | Synopsys, Inc. | Systems and Methods for Model-Based Analysis of Software |
| CN107844425A (en) * | 2017-11-16 | 2018-03-27 | 中国银行股份有限公司 | A kind of database statement inspection method and device |
| CN109002472A (en) * | 2018-06-13 | 2018-12-14 | 平安科技（深圳）有限公司 | A kind of recognition methods of database difference and device |
| CN110096625A (en) * | 2019-05-14 | 2019-08-06 | 中国联合网络通信集团有限公司 | Data close rule inspection method and device |
| CN110543483A (en) * | 2019-08-30 | 2019-12-06 | 北京百分点信息科技有限公司 | Data auditing method and device and electronic equipment |
-
2019
- 2019-12-09 CN CN201911248386.7A patent/CN110990284A/en active Pending
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20170329582A1 (en) * | 2016-05-15 | 2017-11-16 | Synopsys, Inc. | Systems and Methods for Model-Based Analysis of Software |
| CN107844425A (en) * | 2017-11-16 | 2018-03-27 | 中国银行股份有限公司 | A kind of database statement inspection method and device |
| CN109002472A (en) * | 2018-06-13 | 2018-12-14 | 平安科技（深圳）有限公司 | A kind of recognition methods of database difference and device |
| CN110096625A (en) * | 2019-05-14 | 2019-08-06 | 中国联合网络通信集团有限公司 | Data close rule inspection method and device |
| CN110543483A (en) * | 2019-08-30 | 2019-12-06 | 北京百分点信息科技有限公司 | Data auditing method and device and electronic equipment |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US9459995B2 (en) | Compliance testing engine for integrated computing system | |
| CN107145437B (en) | Java annotation test method and device | |
| CN102222042B (en) | Automatic software testing method based on cloud computing | |
| CN110134659B (en) | Log monitoring system, method, medium, and apparatus for running program | |
| CN110955409B (en) | Method and device for creating resources on cloud platform | |
| CN108459850B (en) | Method, device and system for generating test script | |
| CN109522181B (en) | Performance test method, device and equipment of distributed storage system | |
| CN106713011B (en) | Method and system for obtaining test data | |
| CN105426544B (en) | Method and device for monitoring database state | |
| WO2016165461A1 (en) | Automated testing method and apparatus for network management system software of telecommunications network | |
| CN110096305A (en) | Gray scale dissemination method, device, equipment and storage medium | |
| CN106681852B (en) | A kind of method of adjustment and device of browser compatibility | |
| CN112817883A (en) | Method, device and system for adapting interface platform and computer readable storage medium | |
| CN112883088B (en) | Data processing method, device, equipment and storage medium | |
| CN115276844B (en) | Communication module testing method and device, storage medium and electronic equipment | |
| CN110990284A (en) | Database standard checking method and device | |
| CN112596750B (en) | Application testing method and device, electronic equipment and computer readable storage medium | |
| CN114201293A (en) | Kafka middleware cluster parameter modification method and device and storage medium | |
| CN114328196A (en) | Method, device and equipment for testing data leakage prevention system and storage medium | |
| CN113342647A (en) | Test data generation method and device | |
| CN113297149A (en) | Method and device for monitoring data processing request | |
| CN111178044B (en) | Method and device for determining target text elements | |
| CN117234623B (en) | Page theme changing method and device of application program and electronic equipment | |
| CN116893978B (en) | Test plan generation method, system and storage medium based on PTCRB authentication | |
| CN112468358B (en) | Protocol detection method, system, equipment and computer readable 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 | ||
| TA01 | Transfer of patent application right | ||
| TA01 | Transfer of patent application right |
Effective date of registration: 20221010 Address after: 12 / F, 15 / F, 99 Yincheng Road, Pudong New Area pilot Free Trade Zone, Shanghai, 200120 Applicant after: Jianxin Financial Science and Technology Co.,Ltd. Address before: 25 Financial Street, Xicheng District, Beijing 100033 Applicant before: CHINA CONSTRUCTION BANK Corp. Applicant before: Jianxin Financial Science and Technology Co.,Ltd. |
|
| RJ01 | Rejection of invention patent application after publication | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20200410 |