CN114637739A - Database management and control method, system, computer equipment and computer storage medium - Google Patents
Database management and control method, system, computer equipment and computer storage medium Download PDFInfo
- Publication number
- CN114637739A CN114637739A CN202210288651.XA CN202210288651A CN114637739A CN 114637739 A CN114637739 A CN 114637739A CN 202210288651 A CN202210288651 A CN 202210288651A CN 114637739 A CN114637739 A CN 114637739A
- Authority
- CN
- China
- Prior art keywords
- database
- target
- index data
- evaluation
- target database
- 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 37
- 238000011156 evaluation Methods 0.000 claims abstract description 154
- 230000014509 gene expression Effects 0.000 claims abstract description 46
- 238000007726 management method Methods 0.000 claims description 53
- 238000013515 script Methods 0.000 claims description 18
- 238000007689 inspection Methods 0.000 claims description 15
- 238000012545 processing Methods 0.000 claims description 13
- 238000004590 computer program Methods 0.000 claims description 10
- 238000004364 calculation method Methods 0.000 claims description 5
- 230000000694 effects Effects 0.000 abstract description 5
- 238000003908 quality control method Methods 0.000 description 19
- 238000011161 development Methods 0.000 description 11
- 238000013461 design Methods 0.000 description 8
- 238000012423 maintenance Methods 0.000 description 6
- 230000008569 process Effects 0.000 description 6
- 238000010586 diagram Methods 0.000 description 5
- 230000006870 function Effects 0.000 description 4
- 238000004891 communication Methods 0.000 description 3
- 238000011835 investigation Methods 0.000 description 3
- 238000012937 correction Methods 0.000 description 2
- 238000001514 detection method Methods 0.000 description 2
- 230000006872 improvement Effects 0.000 description 2
- 238000012986 modification Methods 0.000 description 2
- 230000004048 modification Effects 0.000 description 2
- 238000012544 monitoring process Methods 0.000 description 2
- 230000003287 optical effect Effects 0.000 description 2
- 230000003068 static effect Effects 0.000 description 2
- 230000009286 beneficial effect Effects 0.000 description 1
- 230000005540 biological transmission Effects 0.000 description 1
- 230000000903 blocking effect Effects 0.000 description 1
- 230000008094 contradictory effect Effects 0.000 description 1
- 238000001914 filtration Methods 0.000 description 1
- 230000010365 information processing Effects 0.000 description 1
- 230000003993 interaction Effects 0.000 description 1
- 238000004519 manufacturing process Methods 0.000 description 1
- 238000010295 mobile communication Methods 0.000 description 1
- 230000002035 prolonged effect Effects 0.000 description 1
- 238000011084 recovery Methods 0.000 description 1
- 239000013589 supplement Substances 0.000 description 1
- 238000012360 testing method Methods 0.000 description 1
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/24—Querying
- G06F16/242—Query formulation
- G06F16/2433—Query languages
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Databases & Information Systems (AREA)
- Physics & Mathematics (AREA)
- Data Mining & Analysis (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Mathematical Physics (AREA)
- Computational Linguistics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The embodiment of the invention provides a database management and control method, which comprises the following steps: determining a target database and a plurality of target index data corresponding to the target database according to project requirements; acquiring an index execution result corresponding to each target index data according to the project requirement; obtaining an evaluation expression corresponding to each target index data; calculating an index execution result corresponding to each target index data based on a plurality of evaluation expressions and the plurality of target index data to obtain a plurality of target database evaluation values corresponding to the target database; generating a target database check report corresponding to the target database according to the plurality of target database evaluation values; the embodiment of the invention calculates the index execution result through the evaluation expression so as to realize the management and control of the database, and the flexible setting of the evaluation expression can effectively improve the efficiency and the effect of the quality management and control of the database.
Description
Technical Field
The embodiment of the invention relates to the technical field of data processing, in particular to a database management and control method, a database management and control system, computer equipment and a computer storage medium.
Background
The existing database management and control method mainly comprises the following modes: (1) making and executing specifications such as database development design and the like; (2) on the premise of the specifications such as database development design and the like in step (1), the related specifications of SQL release pre-examination are increased; (3) filtering out risk SQL by using middleware according to a preset interception rule; (4) and setting monitoring rules to monitor and alarm indexes influencing the database performance, safety and resource use.
However, the above database management method has at least the following disadvantages: the database quality control is only carried out on the database at a certain stage, so that the overall quality control effect on the database is poor due to the fact that the problems of the operating state, the using state, possible bugs and the like of the database at multiple stages such as a database using stage, a database developing stage and an operation and maintenance stage are not combined easily, and the efficiency of database development, design, use and operation and maintenance is further influenced.
Disclosure of Invention
In view of the above, an object of the present invention is to provide a database management and control method, a database management and control system, a computer device and a computer-readable storage medium, which are used to solve the problem of poor database quality management and control effect of the existing database management and control method.
One aspect of an embodiment of the present invention provides a database management and control method, including:
determining a target database and a plurality of target index data corresponding to the target database according to project requirements;
acquiring an index execution result corresponding to each target index data according to the project requirement;
obtaining an evaluation expression corresponding to each target index data to obtain a plurality of evaluation expressions;
calculating an index execution result corresponding to each target index data based on the plurality of evaluation expressions and the plurality of target index data to obtain a plurality of target database evaluation values corresponding to the target database, wherein the plurality of target database evaluation values are used for representing the influence degree of the index execution result of the corresponding target index data on the quality of the target database; and
and generating a target database check report corresponding to the target database according to the plurality of target database evaluation values.
Optionally, the determining a target database and a plurality of target index data corresponding to the target database according to project requirements includes:
analyzing the project requirement, and extracting an environment keyword and a requirement keyword;
determining a target environment according to the environment keywords, and determining the target database according to the target environment; and
and determining a target evaluation category corresponding to the target database according to the requirement keyword, and acquiring the target index data from the target evaluation category.
Optionally, the calculating, based on the multiple evaluation expressions and the multiple target index data, an index execution result corresponding to each target index data to obtain multiple target database evaluation values corresponding to the target database includes:
analyzing the target index data to obtain the incidence relation between each target index data;
distributing each target index data, an index execution result corresponding to each target index data and an evaluation expression corresponding to each target index data to each node in a target processing chain according to the incidence relation among each target index data; and
and sequentially passing through each node in the target processing chain, and calculating each target index data and a corresponding index execution result according to an evaluation expression corresponding to each node to obtain the plurality of target database evaluation values corresponding to the target database.
Optionally, the method further includes a step of constructing a plurality of index data in advance:
constructing a plurality of evaluation categories and a plurality of index data according to preset database specifications and enterprise requirements;
configuring corresponding execution scripts and scheduling time of each execution script according to each index data; and
and classifying and arranging the plurality of index data, each execution script and the scheduling time of each execution script into corresponding assessment categories according to the index attributes of the plurality of index data.
Optionally, the method further includes the step of constructing a plurality of evaluation expressions in advance:
configuring a score weight for each evaluation category, wherein the score weight is used for representing the importance degree of the corresponding evaluation category in the execution of database evaluation;
configuring a scoring rule for each index data in each evaluation category; and
and combining the scoring rule corresponding to each index data and the score weight corresponding to each evaluation category to obtain an evaluation expression corresponding to each index data.
Optionally, after the generating of the target database check report corresponding to the target database according to the plurality of target database evaluation values, the method further includes:
determining a target enterprise department from a preset metadata database according to the target database;
acquiring a relevant database inspection report corresponding to the target enterprise department;
extracting a plurality of target database evaluation values from the target database check report and extracting associated database evaluation values from the associated database check report; and
and calculating the evaluation values of the plurality of target databases and the evaluation value of the associated database, and obtaining the database management and control score of the target enterprise department for the target database.
Optionally, the method further comprises the step of building a metadata base:
establishing a metadata base related to a plurality of databases, wherein the metadata base comprises: the system comprises a database host, a database, a business system and an enterprise department;
establishing the affiliation between the database host and each database, the affiliation between the database and each business system and the affiliation between the business system and each enterprise department; and
and storing the relationship between the database host and each database, the relationship between the database and each business system and the relationship between the business system and each enterprise department in the metadata database.
One aspect of the embodiments of the present invention further provides a database management and control system, including:
the system comprises a determining module, a judging module and a display module, wherein the determining module is used for determining a target database and a plurality of target index data corresponding to the target database according to project requirements;
the acquisition module is used for acquiring an index execution result corresponding to each target index data according to the project requirement;
the acquisition module is used for acquiring the evaluation expression corresponding to each target index data to obtain a plurality of evaluation expressions;
a calculation module, configured to calculate, based on the multiple evaluation expressions and the multiple target index data, an index execution result corresponding to each target index data to obtain multiple target database evaluation values corresponding to the target database, where the multiple target database evaluation values are used to indicate degrees of influence of the index execution results of the corresponding target index data on quality of the target database; and
and the generating module is used for generating a target database check report corresponding to the target database according to the plurality of target database evaluation values.
An aspect of the embodiments of the present invention further provides a computer device, which includes a memory, a processor, and a computer program stored in the memory and executable on the processor, wherein the processor implements the steps of the database management method as described above when executing the computer program.
An aspect of the embodiments of the present invention further provides a computer-readable storage medium, in which a computer program is stored, the computer program being executable by at least one processor to cause the at least one processor to perform the steps of the database management method as described above.
According to the database management and control method, the system, the computer equipment and the computer readable storage medium provided by the embodiment of the invention, a target database and a plurality of target index data corresponding to the target database are determined according to project requirements; acquiring an index execution result corresponding to each target index data according to the project requirement; obtaining an evaluation expression corresponding to each target index data; calculating an index execution result corresponding to each target index data based on a plurality of evaluation expressions and the plurality of target index data to obtain a plurality of target database evaluation values corresponding to the target database; generating a target database check report corresponding to the target database according to the plurality of target database evaluation values; according to the embodiment of the invention, the index execution result is calculated through the preset evaluation expression, so that the overall quality of the database in each stage of the whole life cycle of the database, such as the stages of design, development, operation and maintenance and the like, is controlled, and the flexible setting of the evaluation expression can effectively improve the efficiency and the effect of controlling the quality of the database.
The invention is described in detail below with reference to the drawings and specific examples, but the invention is not limited thereto.
Drawings
FIG. 1 schematically illustrates an example flow chart of a method of implementing database management in accordance with this invention;
FIG. 2 is a flow chart that schematically illustrates the steps of a method for database management, in accordance with the present invention;
FIG. 3 is a flow chart that schematically illustrates the steps of a method for database management, in accordance with the present invention;
FIG. 4 is a flow chart schematically illustrating the steps of implementing a database management method in accordance with the present invention;
FIG. 5 is a flow chart that schematically illustrates the steps of a method for database management, in accordance with the present invention;
FIG. 6 is a flow chart that schematically illustrates the steps of a method for database management, in accordance with the present invention;
FIG. 7 is a flow chart that schematically illustrates the steps of a method for database management, in accordance with the present invention;
FIG. 8 is a block diagram schematically illustrating a database management system according to a second embodiment of the present invention;
fig. 9 is a schematic diagram of a hardware structure of a computer device suitable for implementing the database management method according to a third embodiment of the present invention.
Detailed Description
In order to make the objects, technical solutions and advantages of the present invention more apparent, the present invention is described in further detail below with reference to the accompanying drawings and embodiments. It should be understood that the specific embodiments described herein are merely illustrative of the invention and are not intended to limit the invention. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present invention.
It should be noted that the descriptions relating to "first", "second", etc. in the embodiments of the present invention are only for descriptive purposes and are not to be construed as indicating or implying relative importance or implicitly indicating the number of technical features indicated. Thus, a feature defined as "first" or "second" may explicitly or implicitly include at least one such feature. In addition, technical solutions between various embodiments may be combined with each other, but must be realized by a person skilled in the art, and when the technical solutions are contradictory or cannot be realized, such a combination should not be considered to exist, and is not within the protection scope of the present invention.
In the description of the present invention, it should be understood that the numerical references before the steps do not identify the order of performing the steps, but merely serve to facilitate the description of the present invention and to distinguish each step, and thus should not be construed as limiting the present invention.
Example one
Referring to fig. 1, a flowchart illustrating steps of a database management method according to an embodiment of the invention is shown. It is to be understood that the flow charts in the embodiments of the present method are not intended to limit the order in which the steps are performed. The database management and control method provided by the embodiment is applied to each stage of design, development, operation and maintenance of each database of an enterprise. The following description is given by taking a computer device as an execution subject, specifically as follows:
as shown in fig. 1, the database management method may include steps S100 to S108, where:
step S100, determining a target database and a plurality of target index data corresponding to the target database according to project requirements.
Wherein, the project requirements include but are not limited to: database design, development phase code (e.g., SQL code) specification detection, enterprise focused core performance issues, security issues, or other issues of security or performance inspection. Wherein the database includes database objects including, but not limited to: tables, indices, views, charts, default values, rules, triggers, etc. The project requirements are set according to actual projects, and are not exhaustive here.
Wherein the target metric data includes, but is not limited to: table describes the completeness of information, field describes the completeness of information, etc. The target index data is different according to the project requirement and the target database related to the project requirement, and is not exhaustive here.
In order to improve the efficiency of acquiring target index data, referring to fig. 2, the step of determining a target database and a plurality of target index data corresponding to the target database according to project requirements further includes the following steps S200 to S204, where: step S200, analyzing the project requirement, and extracting an environment keyword and a requirement keyword; step S202, analyzing the project requirement, and extracting an environment keyword and a requirement keyword; and step S204, determining a target evaluation category corresponding to the target database according to the requirement keyword, and acquiring the target index data from the target evaluation category. In this embodiment, the environment keywords include, but are not limited to: development environment, production environment, test environment, release environment, etc. According to the environment keywords and the requirement keywords, a plurality of target index data and target evaluation categories related to the target database are quickly positioned, the acquisition efficiency of the target index data is effectively improved, and the improvement of the database quality control efficiency is facilitated.
In order to improve the normative and the accuracy of database quality control, the method further comprises the steps of constructing a plurality of index data in advance, setting related index data according to the actual conditions of enterprises and the actual demands of various projects, and effectively improving the efficiency of database quality control. Referring to fig. 4, the method further includes a step of pre-constructing a plurality of index data, wherein: step S400, constructing a plurality of evaluation categories and a plurality of index data according to preset database specifications and enterprise requirements; step S402, configuring corresponding execution scripts and scheduling time of each execution script according to each index data; and step S404, sorting the index data, the execution scripts and the scheduling time of the execution scripts into corresponding assessment categories according to the index attributes of the index data.
The method comprises the steps of disassembling relevant specifications of a database, collecting specific investigation indexes concerned by enterprises, forming a series of index data of the database which can be implemented, classifying and sorting the index data according to information such as attributes of the index data, and forming evaluation categories. For example, the database-related specification requires that each table and each field are annotated, and a "data dictionary" may be established as an evaluation category, in which two evaluation items are set: table comments, field comments; the corresponding index data may be: completeness of table comments, completeness of field comments.
In an exemplary embodiment, the evaluation categories may also include connection, authority, design, development, operation, etc., where each category contains several specific index data. For example, the evaluation category of "database development" may relate to problems such as TOP SQL, risky SQL, complex SQL, deadlock/blocking, uncommitted transactions, parallel dml (oltp), tablespace, triggers, cross-library access, binding variables, and the like, and therefore, all of them are used as evaluation items corresponding to the evaluation category of "database development", and specific index data is set corresponding to the evaluation items. For example: for the evaluation item of risk SQL, the corresponding index data may be whether risk SQL is included.
The evaluation categories and the corresponding index data are flexible in setting form, can be based on relevant specifications of a database, and/or can be based on specific investigation indexes concerned by enterprises, and evaluation categories, evaluation items and index data can be added or deleted subsequently according to actual conditions, which is not exhaustive.
And S102, acquiring an index execution result corresponding to each target index data according to the project requirement.
In this embodiment, the execution condition of each index data is monitored in real time through a log burying point, and the index execution result of each index data is stored in the log of the corresponding database. When database quality control is performed, according to project requirements, index execution results corresponding to each target index data are extracted from logs of the corresponding target database. The monitoring of the index execution condition and the storage of the index execution result can be used for subsequent operations such as enterprise department evaluation, feedback and the like.
Step S104, obtaining an evaluation expression corresponding to each target index data to obtain a plurality of evaluation expressions.
In order to ensure the evaluation specification of the database and ensure the effective performance of the quality control of the database, please refer to fig. 5, the method further includes a step of constructing a plurality of evaluation expressions in advance, wherein: step S500, configuring a score weight for each evaluation category, wherein the score weight is used for representing the importance degree of the corresponding evaluation category in the execution of database evaluation; step S502, configuring a scoring rule for each index data in each evaluation category; and step S504, combining the scoring rule corresponding to each index data and the score weight corresponding to each evaluation category to obtain an evaluation expression corresponding to each index data.
The scoring rules can be flexibly set according to the emphasis points of enterprise investigation. For example, in a certain period of time, an enterprise wants to emphasize the completeness of tables and field comments in the normalized database, and may increase the score weight of the evaluation category "data dictionary" (for example, the total score of the evaluation category "data dictionary" is set to 20, and the score weight is 20%); setting a deduction rule for the index data of the table annotation and the field annotation; for example, missing a field annotation deducts 2 points until the "data dictionary" evaluation category is totally deducted. Based on the above, after the evaluation categories and the index data are determined, the score weight of each evaluation category related to the target database and the specific score rule or the deduction rule of each index data in each evaluation category can be flexibly set according to the project requirements, so that a complete scoring system is formed. In order to make the quality control of the database better applied to practical use, the method further comprises the step of setting an additional rule based on a preset scene, wherein the additional rule is a supplement of the scoring rule. For example, in some preset scenarios, additional rules may be set to exempt (not to deduct points) specific index data. Exemplarily, additional rules are set for index data which is difficult to design and execute scripts and is not frequent; reward and punishment rules can also be set for certain index data, databases, business systems or enterprise departments which show bad or excellent performance. For example, in a certain period of time, operation and maintenance staff of a certain department mistakenly deletes a certain business table, which results in data recovery from backup, and thus causes the downtime of the database to be prolonged. The setting of the additional rules can better deal with the emergencies occurring in the development, use, operation and maintenance processes of the database, and can more comprehensively carry out quality control on the database.
Step S106, based on the multiple evaluation expressions and the multiple target index data, calculating an index execution result corresponding to each target index data to obtain multiple target database evaluation values corresponding to the target database, where the multiple target database evaluation values are used to indicate degrees of influence of the index execution results of the corresponding target index data on the quality of the target database.
In order to quickly calculate the evaluation value of the target database and further improve the efficiency of database quality control, please refer to fig. 3, where the calculation of the index execution result corresponding to each target index data based on the multiple evaluation expressions and the multiple target index data to obtain the multiple target database evaluation values corresponding to the target database may be further implemented by: step S300, analyzing the target index data to obtain the incidence relation between each target index data; step S302, according to the incidence relation among each target index data, distributing each target index data, the index execution result corresponding to each target index data and the evaluation expression corresponding to each target index data to each node in a target processing chain; and step S304, sequentially passing through each node in the target processing chain, and calculating each target index data and the corresponding index execution result according to the evaluation expression corresponding to each node to obtain the plurality of target database evaluation values corresponding to the target database. In this embodiment, in order to improve the rationality of database quality control, the control operations of different databases are processed through different processing chains, so that the control operations of multiple databases can be realized in parallel, the computational power of database control is reasonably distributed, the efficiency and the accuracy of database control are improved, and the loss of system resources is reduced.
And step S108, generating a target database check report corresponding to the target database according to the plurality of target database evaluation values.
In an exemplary embodiment, a corresponding target database inspection report is generated for each target database; the database inspection report includes detailed inspection results of the evaluation categories and the index data thereof, a score (score/discount) and a total score of each target database.
In order to form a closed loop process of database quality control, and effectively apply the database control result, referring to fig. 6, after the step of generating the target database check report corresponding to the target database according to the plurality of target database evaluation values, the method further includes the following steps: step S600, determining a target enterprise department from a preset metadata database according to the target database; step S602, obtaining a relevant database check report corresponding to the target enterprise department; step S604, extracting a plurality of target database evaluation values from the target database check report and extracting a relational database evaluation value from the relational database check report; and step S606, calculating the plurality of target database evaluation values and the associated database evaluation value, and obtaining the database quality control score of the target enterprise department for the target database. In this embodiment, the scores of all databases belonging to the business department are averaged according to the belonging relationship between the databases and the business system and the belonging relationship between the business system and the enterprise department to obtain the score of the enterprise department, which can be used for ranking the database quality control effect among the enterprise departments, and is convenient for effective modification of the subsequent databases.
In an exemplary embodiment, database inspection reports, collation situations are pre-published at each enterprise division. After receiving the information, the enterprise department can confirm the inspection result and the scoring condition in the report. It should be noted that, the enterprise department can locate the specific problems, bugs, security risks, etc. existing in the current database from the report, and make corresponding improvements accordingly. After the enterprise department carries out the correction of related database inspection items according to the content of the database inspection report, the enterprise department continues to carry out the inspection, the evaluation and the feedback of the database quality control in the next round, a complete closed-loop chain of the database quality control is formed, and the virtuous cycle of the inspection, the evaluation, the feedback, the adjustment, the reexamination and the correction of the database is realized; each managed and controlled database meets a series of database relevant specifications step by step, and potential hazards in aspects of performance, safety and the like are not easy to exist; and the accurate quality control of the database is effectively realized.
In order to clarify the object of database quality control, the method further includes constructing a metadata database, please refer to fig. 7, where the step of constructing the metadata database specifically includes: step S700, establishing a metadata database related to a plurality of databases, wherein the metadata database includes: the system comprises a database host, a database, a business system and an enterprise department; step S702, establishing the affiliation between the database host and each database, the affiliation between the database and each business system, and the affiliation between the business system and each enterprise department; and step S704, storing the affiliation between the database host and each database, the affiliation between the database and each business system, and the affiliation between the business system and each enterprise department in the metadata database.
The embodiment of the invention at least has the following beneficial effects:
(1) the database management and control method has flexibility and comprehensiveness in setting of the index data, and the configuration of the execution script of the index data and the setting of the scheduling time can better reflect the flexibility of the index data;
(2) the database management and control method can timely check the execution condition of the relevant database specifications and ensure the correct and effective execution of the relevant database specifications.
(3) The corresponding database can be rapidly and accurately controlled through the evaluation expression, and the efficiency and the accuracy of database quality control are guaranteed.
Example two
With continued reference to FIG. 8, a block diagram of a database management system 80 of the present invention is schematically illustrated. In this embodiment, the database management system 80 may include or be divided into one or more program modules, and the one or more program modules are stored in a storage medium and executed by one or more processors to implement the present invention and implement the above-mentioned database management method. The program module referred to in the embodiments of the present invention refers to a series of computer program instruction segments capable of performing specific functions, and is more suitable for describing the execution process of the database management and control system 80 in the storage medium than the program itself. The following description will specifically describe the functions of the program modules of the present embodiment.
As shown in fig. 8, the database management and control system 80 may include: the device comprises a determining module 800, an acquisition module 802, an acquisition module 804, a calculation module 806 and a generation module 808; wherein:
a determining module 800, configured to determine a target database and a plurality of target index data corresponding to the target database according to a project requirement;
the acquisition module 802 is configured to acquire an index execution result corresponding to each target index data according to the project requirement;
an obtaining module 804, configured to obtain an evaluation expression corresponding to each target index data to obtain multiple evaluation expressions;
a calculating module 806, configured to calculate, based on the multiple evaluation expressions and the multiple target index data, an index execution result corresponding to each target index data to obtain multiple target database evaluation values corresponding to the target database, where the multiple target database evaluation values are used to indicate degrees of influence of the index execution results of the corresponding target index data on quality of the target database; and
a generating module 808, configured to generate a target database check report corresponding to the target database according to the plurality of target database evaluation values, where:
in an exemplary embodiment, the determining module 800 is further configured to: analyzing the project requirement, and extracting an environment keyword and a requirement keyword; determining a target environment according to the environment keywords, and determining the target database according to the target environment; and determining a target evaluation category corresponding to the target database according to the requirement keyword, and acquiring the target index data from the target evaluation category.
In an exemplary embodiment, the calculating module 806 is further configured to: analyzing the target index data to obtain an incidence relation between each target index data; distributing each target index data, an index execution result corresponding to each target index data and an evaluation expression corresponding to each target index data to each node in a target processing chain according to the incidence relation among each target index data; and sequentially passing through each node in the target processing chain, and calculating each target index data and a corresponding index execution result according to an evaluation expression corresponding to each node to obtain the plurality of target database evaluation values corresponding to the target database.
In an exemplary embodiment, the system further comprises a first building module (not identified), wherein the first building module is configured to: a plurality of index data are previously constructed. The first building block is further configured to: constructing a plurality of evaluation categories and a plurality of index data according to preset database specifications and enterprise requirements; configuring corresponding execution scripts and scheduling time of each execution script according to each index data; and classifying and arranging the index data, the execution scripts and the scheduling time of the execution scripts into corresponding evaluation categories according to the index attributes of the index data.
In an exemplary embodiment, the system further comprises a second building module (not identified), wherein the second building module is configured to: a plurality of evaluation expressions are constructed in advance. The second building block is further configured to: configuring a score weight for each evaluation category, wherein the score weight is used for representing the importance degree of the corresponding evaluation category in the execution of database evaluation; configuring a scoring rule for each index data in each evaluation category; and combining the scoring rule corresponding to each index data and the score weight corresponding to each evaluation category to obtain an evaluation expression corresponding to each index data.
In an exemplary embodiment, the system further comprises an evaluation module (not identified), wherein the evaluation module is configured to: determining a target enterprise department from a preset metadata database according to the target database; acquiring a relevant database inspection report corresponding to the target enterprise department; extracting a plurality of target database evaluation values from the target database examination report and extracting a relational database evaluation value from the relational database examination report; and calculating the evaluation values of the plurality of target databases and the evaluation value of the associated database, and obtaining the database management and control score of the target enterprise department for the target database.
In an exemplary embodiment, the system further comprises a third building module (not identified), wherein the third building module is used to pre-build the metadata base. The third building block is further configured to: establishing a metadata base related to a plurality of databases, wherein the metadata base comprises: the system comprises a database host, a database, a business system and an enterprise department; establishing the affiliation between the database host and each database, the affiliation between the database and each business system and the affiliation between the business system and each enterprise department; and storing the relationship between the database host and each database, the relationship between the database and each business system and the relationship between the business system and each enterprise department in the metadata database.
EXAMPLE III
Fig. 9 is a schematic diagram of a hardware architecture of a computer device 10000 suitable for implementing a database management method according to a third embodiment of the present invention. In this embodiment, the computer device 10000 is a device capable of automatically performing numerical calculation and/or information processing according to a preset or stored instruction. The computer device 10000 can be a smart phone, a tablet computer, a notebook computer, a desktop computer, a rack server, a blade server, a tower server or a cabinet server (including an independent server or a server cluster composed of multiple servers), a gateway, or the like. As shown in fig. 9, the computer device 10000 includes, but is not limited to, at least a memory 10010, a processor 10020, and a network interface 10030, which are communicatively connected to each other through a system bus. Wherein:
in this embodiment, the memory 10010 includes at least one type of computer-readable storage medium including a flash memory, a hard disk, a multimedia card, a card-type memory (e.g., SD or DX memory, etc.), a Random Access Memory (RAM), a Static Random Access Memory (SRAM), a Read Only Memory (ROM), an Electrically Erasable Programmable Read Only Memory (EEPROM), a Programmable Read Only Memory (PROM), a magnetic memory, a magnetic disk, an optical disk, and the like. In some embodiments, the storage 10010 can be an internal storage unit of the computer device 10000, such as a hard disk or a memory of the computer device 10000. In other embodiments, the memory 10010 may also be an external storage device of the computer device 10000, such as a plug-in hard disk, a Smart Media Card (SMC), a Secure Digital (SD) Card, a Flash memory Card (Flash Card), or the like, provided on the computer device 10000. Of course, the memory 10010 may also include both internal and external storage devices of the computer device 10000. In this embodiment, the memory 10010 is generally used for storing an operating system and various application software installed on the computer device 10000, such as the program codes of the database management system 80 of the above embodiment. In addition, the memory 10010 may also be used to temporarily store various types of data that have been output or are to be output.
Processor 10020, in some embodiments, can be a Central Processing Unit (CPU), controller, microcontroller, microprocessor, or other data Processing chip. The processor 10020 is generally configured to control overall operations of the computer device 10000, such as performing control and processing related to data interaction or communication with the computer device 10000. In this embodiment, the processor 10020 is configured to run a program code stored in the memory 10010 or process data, for example, run the database management system 80, so as to implement the database management method according to the above embodiment.
The network interface 10030 may comprise a wireless network interface or a wired network interface, and the network interface 10030 is generally used for establishing a communication connection between the computer apparatus 10000 and other electronic devices. For example, the network interface 10030 is configured to connect the computer device 10000 to an external terminal through a network, establish a data transmission channel and a communication connection between the computer device 10000 and the external terminal, and the like. The network may be a wireless or wired network such as an Intranet (Intranet), the Internet (Internet), a Global System of Mobile communication (GSM for short), Wideband Code Division Multiple Access (WCDMA for short), a 4G network, a 5G network, Bluetooth (Bluetooth), Wi-Fi, and the like.
It is noted that fig. 9 only shows computer device 10000 having components 10010 and 10030, but it is to be understood that not all of the shown components are required and that more or less components may be implemented instead.
In this embodiment, the database management system 80 stored in the memory 10010 can be further divided into one or more program modules, and the one or more program modules are stored in the memory 10010 and executed by one or more processors (in this embodiment, the processor 10020) to complete the present invention.
For example, fig. 8 shows a schematic diagram of program modules of a second embodiment of implementing the database-based control system 80, in this embodiment, the database-based control system 80 may be divided into a determining module 800, an acquiring module 802, an obtaining module 804, a calculating module 806, and a generating module 808. The program module referred to in the present invention refers to a series of computer program instruction segments capable of performing specific functions, and is more suitable for describing the execution process of the database management and control system in the computer device 10000 than a program. The specific functions of the program modules 800 and 808 have been described in detail in the second embodiment, and are not described herein again.
Example four
The present embodiments also provide a computer-readable storage medium having stored thereon a computer program, which, when executed by at least one processor, performs the steps of the database management method in the embodiments.
In the present embodiment, the computer-readable storage medium includes a flash memory, a hard disk, a multimedia card, a card type memory (e.g., SD or DX memory, etc.), a Random Access Memory (RAM), a Static Random Access Memory (SRAM), a Read Only Memory (ROM), an Electrically Erasable Programmable Read Only Memory (EEPROM), a Programmable Read Only Memory (PROM), a magnetic memory, a magnetic disk, an optical disk, a server, an App application mall, and the like. In some embodiments, the computer readable storage medium may be an internal storage unit of the computer device, such as a hard disk or a memory of the computer device. In other embodiments, the computer-readable storage medium may be an external storage device of the computer device, such as a plug-in hard disk provided on the computer device, a Smart Media Card (SMC), a Secure Digital (SD) Card, a Flash memory Card (Flash Card), and the like. Of course, the computer-readable storage medium may also include both internal and external storage devices of the computer device. In this embodiment, the computer-readable storage medium is generally used for storing an operating system and various types of application software installed in the computer device, for example, the program code of the katon detection method in the embodiment, and the like. Further, the computer-readable storage medium may also be used to temporarily store various types of data that have been output or are to be output.
It will be apparent to those skilled in the art that the modules or steps of the embodiments of the invention described above may be implemented by a general purpose computing device, they may be centralized in a single computing device or distributed across a network of multiple computing devices, and alternatively, they may be implemented by program code executable by a computing device, such that it may be stored in a memory device and executed by a computing device, and in some cases, the steps shown or described may be executed out of order, or separately as individual integrated circuit modules, or multiple modules or steps may be implemented as a single integrated circuit module. Thus, embodiments of the invention are not limited to any specific combination of hardware and software.
The above-mentioned serial numbers of the embodiments of the present invention are merely for description and do not represent the merits of the embodiments.
The above description is only a preferred embodiment of the present invention, and not intended to limit the scope of the present invention, and all modifications of equivalent structures and equivalent processes, which are made by using the contents of the present specification and the accompanying drawings, or directly or indirectly applied to other related technical fields, are included in the scope of the present invention.
Claims (10)
1. A database management method, comprising:
determining a target database and a plurality of target index data corresponding to the target database according to project requirements;
acquiring an index execution result corresponding to each target index data according to the project requirement;
obtaining an evaluation expression corresponding to each target index data to obtain a plurality of evaluation expressions;
calculating an index execution result corresponding to each target index data based on the plurality of evaluation expressions and the plurality of target index data to obtain a plurality of target database evaluation values corresponding to the target database, wherein the plurality of target database evaluation values are used for representing the influence degree of the index execution result of the corresponding target index data on the quality of the target database; and
and generating a target database inspection report corresponding to the target database according to the plurality of target database evaluation values.
2. The database management method according to claim 1, wherein the determining a target database and a plurality of target index data corresponding to the target database according to project requirements comprises:
analyzing the project requirement, and extracting an environment keyword and a requirement keyword;
determining a target environment according to the environment keywords, and determining the target database according to the target environment; and
and determining a target evaluation category corresponding to the target database according to the requirement keyword, and acquiring the target index data from the target evaluation category.
3. The database management method according to claim 2, wherein the calculating, based on the plurality of evaluation expressions and the plurality of target index data, an index execution result corresponding to each target index data to obtain a plurality of target database evaluation values corresponding to the target database includes:
analyzing the target index data to obtain the incidence relation between each target index data;
distributing each target index data, an index execution result corresponding to each target index data and an evaluation expression corresponding to each target index data to each node in a target processing chain according to the incidence relation among each target index data; and
and sequentially passing through each node in the target processing chain, and calculating each target index data and a corresponding index execution result according to an evaluation expression corresponding to each node to obtain the plurality of target database evaluation values corresponding to the target database.
4. The database management method according to claim 2, further comprising a step of previously constructing a plurality of index data:
constructing a plurality of evaluation categories and a plurality of index data according to preset database specifications and enterprise requirements;
configuring corresponding execution scripts and scheduling time of each execution script according to each index data; and
and classifying and arranging the plurality of index data, each execution script and the scheduling time of each execution script into corresponding assessment categories according to the index attributes of the plurality of index data.
5. The database management method according to claim 3, further comprising a step of previously constructing a plurality of evaluation expressions:
configuring a score weight for each evaluation category, wherein the score weight is used for representing the importance degree of the corresponding evaluation category in the execution of database evaluation;
configuring a scoring rule for each index data in each evaluation category; and
and combining the scoring rule corresponding to each index data and the score weight corresponding to each evaluation category to obtain an evaluation expression corresponding to each index data.
6. The database management method according to claim 1, wherein after the generating of the target database inspection report corresponding to the target database from the plurality of target database evaluation values, the method further comprises:
determining a target enterprise department from a preset metadata database according to the target database;
acquiring a relevant database inspection report corresponding to the target enterprise department;
extracting a plurality of target database evaluation values from the target database examination report and extracting a relational database evaluation value from the relational database examination report; and
and calculating the plurality of target database evaluation values and the associated database evaluation value, and obtaining a database management and control value of the target enterprise department to the target database.
7. The database management method according to claim 6, further comprising the step of building a metadata base:
establishing a metadata base related to a plurality of databases, wherein the metadata base comprises: a database host, a database, a business system and an enterprise department;
establishing the affiliation between the database host and each database, the affiliation between the database and each business system and the affiliation between the business system and each enterprise department; and
and storing the relationship between the database host and each database, the relationship between the database and each business system and the relationship between the business system and each enterprise department in the metadata database.
8. A database management and control system, comprising:
the system comprises a determining module, a judging module and a display module, wherein the determining module is used for determining a target database and a plurality of target index data corresponding to the target database according to project requirements;
the acquisition module is used for acquiring an index execution result corresponding to each target index data according to the project requirement;
the acquisition module is used for acquiring the evaluation expression corresponding to each target index data to obtain a plurality of evaluation expressions;
a calculation module, configured to calculate, based on the multiple evaluation expressions and the multiple target index data, an index execution result corresponding to each target index data to obtain multiple target database evaluation values corresponding to the target database, where the multiple target database evaluation values are used to indicate degrees of influence of the index execution results of the corresponding target index data on quality of the target database; and
and the generating module is used for generating a target database check report corresponding to the target database according to the plurality of target database evaluation values.
9. A computer device comprising a memory, a processor and a computer program stored on the memory and executable on the processor, characterized in that the processor implements the steps of the database management method according to any of claims 1 to 7 when executing the computer program.
10. A computer-readable storage medium, having stored therein a computer program executable by at least one processor to cause the at least one processor to perform the steps of the database management method according to any one of claims 1 to 7.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202210288651.XA CN114637739A (en) | 2022-03-22 | 2022-03-22 | Database management and control method, system, computer equipment and computer storage medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202210288651.XA CN114637739A (en) | 2022-03-22 | 2022-03-22 | Database management and control method, system, computer equipment and computer storage medium |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN114637739A true CN114637739A (en) | 2022-06-17 |
Family
ID=81950624
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202210288651.XA Pending CN114637739A (en) | 2022-03-22 | 2022-03-22 | Database management and control method, system, computer equipment and computer storage medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN114637739A (en) |
Citations (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20180113898A1 (en) * | 2016-10-25 | 2018-04-26 | Mastercard International Incorporated | Systems and methods for assessing data quality |
| CN107992401A (en) * | 2017-11-29 | 2018-05-04 | 平安科技（深圳）有限公司 | Performance test evaluation method, device, terminal device and storage medium |
| CN111506484A (en) * | 2020-03-24 | 2020-08-07 | 北京极简智能科技有限公司 | Program performance evaluation method, system and equipment |
| CN112598308A (en) * | 2020-12-29 | 2021-04-02 | 北京百分点科技集团股份有限公司 | Method and device for evaluating value of media data |
| CN112749164A (en) * | 2020-12-30 | 2021-05-04 | 北京知因智慧科技有限公司 | Data quality analysis method and device and electronic equipment |
| CN113722370A (en) * | 2021-08-30 | 2021-11-30 | 康键信息技术（深圳）有限公司 | Data management method, device, equipment and medium based on index analysis |
| CN113886373A (en) * | 2021-09-09 | 2022-01-04 | 浙江大华技术股份有限公司 | Data processing method and device and electronic equipment |
| CN113918204A (en) * | 2021-09-03 | 2022-01-11 | 航天信息股份有限公司 | Metadata script management method and device, electronic equipment and storage medium |
-
2022
- 2022-03-22 CN CN202210288651.XA patent/CN114637739A/en active Pending
Patent Citations (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20180113898A1 (en) * | 2016-10-25 | 2018-04-26 | Mastercard International Incorporated | Systems and methods for assessing data quality |
| CN107992401A (en) * | 2017-11-29 | 2018-05-04 | 平安科技（深圳）有限公司 | Performance test evaluation method, device, terminal device and storage medium |
| CN111506484A (en) * | 2020-03-24 | 2020-08-07 | 北京极简智能科技有限公司 | Program performance evaluation method, system and equipment |
| CN112598308A (en) * | 2020-12-29 | 2021-04-02 | 北京百分点科技集团股份有限公司 | Method and device for evaluating value of media data |
| CN112749164A (en) * | 2020-12-30 | 2021-05-04 | 北京知因智慧科技有限公司 | Data quality analysis method and device and electronic equipment |
| CN113722370A (en) * | 2021-08-30 | 2021-11-30 | 康键信息技术（深圳）有限公司 | Data management method, device, equipment and medium based on index analysis |
| CN113918204A (en) * | 2021-09-03 | 2022-01-11 | 航天信息股份有限公司 | Metadata script management method and device, electronic equipment and storage medium |
| CN113886373A (en) * | 2021-09-09 | 2022-01-04 | 浙江大华技术股份有限公司 | Data processing method and device and electronic equipment |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN112052151B (en) | Fault root cause analysis method, device, equipment and storage medium | |
| CN112039900B (en) | Network security risk detection method, system, computer device and storage medium | |
| CN109543891B (en) | Method and apparatus for establishing capacity prediction model, and computer-readable storage medium | |
| CN110069925B (en) | Software monitoring method, system and computer readable storage medium | |
| CN113448862B (en) | Software version testing method and device and computer equipment | |
| CN114116496A (en) | Automatic testing method, device, equipment and medium | |
| WO2022012327A1 (en) | Code analysis method and system, and computing device | |
| CN112328805A (en) | Entity mapping method of vulnerability description information and database table based on NLP | |
| CN112328631A (en) | Production fault analysis method and device, electronic equipment and storage medium | |
| CN111506455B (en) | Checking method and device for service release result | |
| CN110866007B (en) | Information management method, system and computer equipment for big data application and table | |
| CN112256532A (en) | Test interface generation method and device, computer equipment and readable storage medium | |
| CN116860311A (en) | Script analysis method, script analysis device, computer equipment and storage medium | |
| CN110795308A (en) | Server inspection method, device, equipment and storage medium | |
| CN114637739A (en) | Database management and control method, system, computer equipment and computer storage medium | |
| CN115310011A (en) | Page display method and system and readable storage medium | |
| CN112561385A (en) | Risk monitoring method and system | |
| CN114281549A (en) | Data processing method and device | |
| CN113656318A (en) | Software version testing method and device and computer equipment | |
| CN108628909B (en) | Information pushing method and device | |
| CN115269879B (en) | Knowledge structure data generation method, data search method and risk warning method | |
| CN116010349B (en) | Metadata-based data checking method and device, electronic equipment and storage medium | |
| CN116955504B (en) | Data processing method and device, electronic equipment and storage medium | |
| CN114880306A (en) | Database management and control method and device, computer equipment and storage medium | |
| CN117112285A (en) | Data processing method, 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 |