CN111078675B - Multidimensional comprehensive database SQL (structured query language) auditing and optimizing method and system - Google Patents
Multidimensional comprehensive database SQL (structured query language) auditing and optimizing method and system Download PDFInfo
- Publication number
- CN111078675B CN111078675B CN202010205035.4A CN202010205035A CN111078675B CN 111078675 B CN111078675 B CN 111078675B CN 202010205035 A CN202010205035 A CN 202010205035A CN 111078675 B CN111078675 B CN 111078675B
- Authority
- CN
- China
- Prior art keywords
- module
- sql
- auditing
- audit
- optimization
- 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.)
- Active
Links
- 238000000034 method Methods 0.000 title claims abstract description 27
- 238000005457 optimization Methods 0.000 claims abstract description 42
- 238000012800 visualization Methods 0.000 claims abstract description 14
- 238000012360 testing method Methods 0.000 claims abstract description 10
- 238000012550 audit Methods 0.000 claims description 65
- 238000007726 management method Methods 0.000 claims description 15
- 230000008569 process Effects 0.000 claims description 13
- 230000006872 improvement Effects 0.000 claims description 7
- 238000004458 analytical method Methods 0.000 claims description 4
- 230000000977 initiatory effect Effects 0.000 claims description 4
- 238000013507 mapping Methods 0.000 claims description 4
- 230000005540 biological transmission Effects 0.000 claims description 3
- 238000010276 construction Methods 0.000 claims description 3
- 238000012545 processing Methods 0.000 claims description 3
- 238000011161 development Methods 0.000 description 3
- 238000013461 design Methods 0.000 description 2
- 238000010586 diagram Methods 0.000 description 2
- 238000011160 research Methods 0.000 description 2
- 238000012827 research and development Methods 0.000 description 2
- 230000004075 alteration Effects 0.000 description 1
- 230000009286 beneficial effect Effects 0.000 description 1
- 230000008859 change Effects 0.000 description 1
- 238000005516 engineering process Methods 0.000 description 1
- 230000010354 integration Effects 0.000 description 1
- 239000000203 mixture Substances 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 238000010606 normalization Methods 0.000 description 1
- 230000002085 persistent effect Effects 0.000 description 1
- 238000013439 planning Methods 0.000 description 1
- 238000012552 review Methods 0.000 description 1
- 238000006467 substitution reaction 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
-
- 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/217—Database tuning
Landscapes
- Engineering & Computer Science (AREA)
- Databases & Information Systems (AREA)
- Theoretical Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Debugging And Monitoring (AREA)
Abstract
The invention relates to the technical field of SQL databases, in particular to a multidimensional comprehensive database SQL examination and optimization method and a multidimensional comprehensive database SQL examination and optimization system, which comprise a WEB front end, a service background and a database, wherein the WEB front end comprises a work order submitting module, a work order examination module, an optimization recording module, a standard configuration module and a quality visualization module, the service background comprises an API service module, a data acquisition module, an SQL management module, an examination engine module, an optimization engine module and a task scheduling module, and the database comprises an examination intermediate library module, a test database module and an on-line database module.
Description
Technical Field
The invention relates to the technical field of SQL databases, in particular to a multidimensional SQL examination and optimization method and system for a comprehensive database.
Background
The SQL statement audit of the database is also the standardized management of SQL in practice, and is an important ring in the software development process. There are some automatic and manual auditing methods and systems, such as "an SQL auditing method and system" of patent No. CN108415991A, but the following problems and disadvantages still exist:
the automatic check is only the check on the aspect of grammar normalization, and the quality of the SQL cannot be completely controlled;
the workload of manual auditing is large, and the standard landing and supervision constraint aspects are difficult to control, and the level of an auditor is often determined;
SQL performance hidden dangers can bring great influence to the online environment, but are difficult to simulate and find in the prior auditing stage;
the standard is not supported by a digital visualization mode, and the standards are difficult to solidify by means of documents and brain-shooting bags.
Disclosure of Invention
The invention aims to provide a multidimensional comprehensive database SQL (structured query language) auditing and optimizing method and system, which are used for solving the problems that in the prior art, SQL database statements are difficult to audit and bring great influence on the environment on lines.
In order to achieve the purpose, the invention provides the following technical scheme: a multidimensional comprehensive database SQL checking system comprises a WEB front end, a service background and a database,
the WEB front end comprises a work order submitting module, a work order auditing module, an optimized recording module, a standard configuration module and a quality visualization module,
a submit work order module used for creating an SQL check work order;
the work order auditing module is used for auditing the created SQL auditing work order;
the optimization recording module is used for storing audit records and optimization records in work order audit;
the standard configuration module is used for carrying out standard standardized setting on the SQL auditing standard;
the quality visualization module is used for visualizing the SQL examination quality;
the service background comprises an API service module, a data acquisition module, an SQL management module, an auditing engine module, an optimizing engine module and a task scheduling module,
API service module, which is used to manage the data transmission interface between modules;
the data acquisition module is used for capturing basic data required by examination from a data source;
the SQL management module is used for completing the full life cycle management of the checked object;
the auditing engine module is used for finishing the definition and configuration work of the rule specification;
the optimization engine module is used for completing analysis of SQL execution characteristics, execution plans and operation efficiency and providing optimization suggestions;
the task scheduling module is used for scheduling the auditing tasks of a plurality of work orders;
the database comprises an auditing intermediate base module, a testing database module and an on-line database module,
the auditing intermediate library module is used for storing the acquired data and intermediate data and result data in the processing process;
the test database module is used for storing the test data of the SQL;
and the online database module is used for storing data in the SQL formal operation process.
Preferably, the core data stored in the database building module in the audit is an object class and an SQL class.
Preferably, the quality visualization module is used for digitizing the quality of the SQL examination by the scoring system and visualizing the examination quality by a billboard mode.
Preferably, the audit engine module is an audit execution part for completing the specific rule.
In order to achieve the above purpose, the invention also provides the following technical scheme: a multidimensional SQL (structured query language) auditing and optimizing method for an integrated database is based on an SQL auditing system and comprises the following specific steps:
(1) filling SQL check work orders through a work order submitting module of the WEB front end;
(2) sending the filled SQL audit work order to a construction site audit module to form an audit request;
(3) sending the request to a service background through an API service module to carry out SQL examination;
(4) scheduling the requested SQL by a task scheduling module, and then auditing and outputting optimization suggestions to the audited object by an SQL management module, an auditing engine module and an optimization engine module;
(5) the auditing and optimizing suggestions are fed back to the work order auditing module through the API service module;
(6) simultaneously storing the optimization suggestion into an optimization recording module;
(7) performing data display on the checked SQL correspondingly through a quality visualization module;
(8) in the SQL operation process needing to be checked, SQL basic data acquisition is carried out through a data acquisition module;
(9) matching the current CMDB information to the slave library according to the metadata mapping relation, and initiating an audit requirement to the slave library;
(10) after the audit of the audit service, pushing an audit result to an API service module;
(11) the auditing and optimizing suggestions are fed back to the work order auditing module through the API service module;
(12) and then storing the optimization suggestion into an optimization recording module.
Preferably, grammar meaning audit rules are set from the library according to step (9).
Preferably, according to steps (9) and (10), the audit service includes inclusion audit tool audits and targeted audit logic customization.
Preferably, the targeted audit logic customization includes the customization of audit information and the customization of audit logic.
Preferably, the audit information includes three types,
the first type of information is suggested information that is either significantly wrong or itself violates the basic specification,
the second category of information is a potential problem,
the third type of information is improvement suggestion type information.
Compared with the prior art, the invention has the beneficial effects that: the method and the system can greatly accelerate the speed of SQL examination, database structure optimization and SQL optimization, reduce the daily working pressure of the database DBA and effectively prevent the influence of SQL performance hidden danger on the online environment.
For research personnel, the problem can be conveniently positioned and timely modified; in addition, by mastering the rule specification, the SQL development experience can be improved by guiding the rule specification to design and develop work.
For the DBA, auditing can be performed visually and quickly, inefficient SQL can be screened in batches, and general problems can be diagnosed quickly through information provided by the system.
For research and development management personnel, the SQL quality of each project and each individual can be tracked, quality problems can be found in time, and supervision and improvement are facilitated.
Drawings
FIG. 1 is a schematic block diagram of the system of the present invention;
FIG. 2 is a main flow diagram of SQL review of the present invention.
Detailed Description
The technical solutions in the embodiments of the present invention will be clearly and completely described below with reference to the drawings in the embodiments of the present invention, and it is obvious that the described embodiments are only a part of the embodiments of the present invention, and not all of the embodiments. 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.
Referring to fig. 1, the present invention provides a technical solution: a multidimensional comprehensive database SQL checking system comprises a WEB front end, a service background and a database,
the WEB front end comprises a work order submitting module, a work order auditing module, an optimized recording module, a standard configuration module and a quality visualization module,
a submit work order module used for creating an SQL check work order;
the work order auditing module is used for auditing the created SQL auditing work order;
the optimization recording module is used for storing audit records and optimization records in work order audit;
the standard configuration module is used for carrying out standard standardized setting on the SQL auditing standard;
the quality visualization module is used for visualizing the SQL examination quality;
the service background comprises an API service module, a data acquisition module, an SQL management module, an auditing engine module, an optimizing engine module and a task scheduling module,
API service module, which is used to manage the data transmission interface between modules;
the data acquisition module is used for capturing basic data required by examination from a data source;
the SQL management module is used for completing the full life cycle management of the checked object;
the auditing engine module is used for finishing the definition and configuration work of the rule specification;
the optimization engine module is used for completing analysis of SQL execution characteristics, execution plans and operation efficiency and providing optimization suggestions;
the task scheduling module is used for scheduling the auditing tasks of a plurality of work orders;
the database comprises an auditing intermediate base module, a testing database module and an on-line database module,
the auditing intermediate library module is used for storing the acquired data and intermediate data and result data in the processing process;
the test database module is used for storing the test data of the SQL;
and the online database module is used for storing data in the SQL formal operation process.
And the core data stored in the database building module in the auditing process are an object class and an SQL class.
The quality visualization module is used for digitizing the quality of the SQL examination through the scoring system and visualizing the examination quality through a board watching mode.
The auditing engine module is an auditing execution part for completing specific rules.
A multidimensional SQL (structured query language) auditing and optimizing method for an integrated database is based on an SQL auditing system and comprises the following specific steps:
(1) filling SQL check work orders through a work order submitting module of the WEB front end;
(2) sending the filled SQL audit work order to a construction site audit module to form an audit request;
(3) sending the request to a service background through an API service module to carry out SQL examination;
(4) scheduling the requested SQL by a task scheduling module, and then auditing and outputting optimization suggestions to the audited object by an SQL management module, an auditing engine module and an optimization engine module;
(5) the auditing and optimizing suggestions are fed back to the work order auditing module through the API service module;
(6) simultaneously storing the optimization suggestion into an optimization recording module;
(7) performing data display on the checked SQL correspondingly through a quality visualization module;
(8) in the SQL operation process needing to be checked, SQL basic data acquisition is carried out through a data acquisition module;
(9) matching the current CMDB information to the slave library according to the metadata mapping relation, and initiating an audit requirement to the slave library;
(10) after the audit of the audit service, pushing an audit result to an API service module;
(11) the auditing and optimizing suggestions are fed back to the work order auditing module through the API service module;
(12) and then storing the optimization suggestion into an optimization recording module.
And (9) setting a grammar meaning auditing rule from the library.
According to steps (9) and (10), the audit service includes inclusion audit tool audits and targeted audit logic customization.
Targeted audit logic customization includes customization of audit information and customization of audit logic.
The audit information includes three types of information,
the first type of information is suggested information that is either significantly wrong or itself violates the basic specification,
the second category of information is a potential problem,
the third type of information is improvement suggestion type information.
By the technical scheme, aiming at the problems in the background technology, the multi-dimensional SQL examination and optimization method and the system for the comprehensive database are provided, and the method comprises 3 statement dimensions: DDL, DML, DQL, 2 time dimensions: and (5) auditing in advance and optimizing after the fact.
For the examination of the DDL, the basic requirements of the business are that the object change requirements are generated only when the business changes, such examination is mainly performed in advance, and the important attention is paid to the control of the DBA.
The DML auditing is based on SQL performance or influence range, and also includes DML flashback (i.e. backup is first obtained), and is also pre-auditing.
The DQL query statement is the requirement of another dimension, more is considered in the aspects of performance and safety, and the result is given through automatic analysis of SQL execution characteristics and SQL execution planning, mainly the operation optimization after the fact;
as shown in fig. 2, firstly, the front end fills in an SQL audit work order, or shows SQL to be optimized from data acquisition, and after submitting a request, the API service is used to interface with the service and result callback of the back end.
And 3-5, matching the existing CMDB information to the slave library according to the metadata mapping relation, initiating a checking requirement to the slave library, and checking syntax semantics at the slave library end.
After the audit of the audit service, the audit result is pushed to the API server, which is the core of the audit service and is to be completely logically controllable, and this can be divided into two levels of work:
one is to fully absorb the advantages of existing auditing tools, such as integration;
and the other is to carry out targeted customization on the auditing logic, wherein the customization is divided into two parts, namely the customization of the auditing information and the customization of the auditing logic.
Then, the audit information is classified into three types:
the first category of information is suggestions that are clearly erroneous or that themselves violate the basic specification, indicating that these suggestions are, for example, that the character set of the table does not meet the criteria, that the table name is a mixture of cases, etc., that the field name is a keyword, etc. This category must be modified to screen out the emphasis cues.
The second kind of information is potential problems, such as the use of an unresuggested data type (lob), the range of a timestamp type is limited, and the like, and the significance of the information is greater, so that the potential problems can be avoided as much as possible.
The third type of information is improvement suggestion type information, such as comments on table fields, and we may have no way to require comments on all fields submitted by development, or to set default values, but we can come up as improvements and suggestions.
The three types of information are configured and made into a scoring system, so that the whole process is more transparent;
the use of the scoring system is more friendly to the business, and the following points are designed for the scoring part:
the auditing suggestions are divided into three levels of 'must improve', 'potential problem' and 'suggested improve', the number of the deduction points appearing in one level is respectively 5,2 and 1, and the fraction ratio of each level is 50,30 and 20;
the total score was 100 points, and the lowest score was 10 points, i.e., <10 points was set to 10 points.
And finally, according to the recommendation information of the audit, making the calling information persistent, including SQL and the audit recommendation, and then comparing and following within a certain time range to see which recommendations are not good enough and which can be continuously improved.
The method and the system can greatly accelerate the speed of SQL examination, database structure optimization and SQL optimization, reduce the daily working pressure of the database DBA and effectively prevent the influence of SQL performance hidden danger on the online environment.
For research personnel, the problem can be conveniently positioned and timely modified; in addition, by mastering the rule specification, the SQL development experience can be improved by guiding the rule specification to design and develop work.
For the DBA, auditing can be performed visually and quickly, inefficient SQL can be screened in batches, and general problems can be diagnosed quickly through information provided by the system.
For research and development management personnel, the SQL quality of each project and each individual can be tracked, quality problems can be found in time, and supervision and improvement are facilitated.
Although embodiments of the present invention have been shown and described, it will be appreciated by those skilled in the art that changes, modifications, substitutions and alterations can be made in these embodiments without departing from the principles and spirit of the invention, the scope of which is defined in the appended claims and their equivalents.
Claims (1)
1. A multidimensional SQL (structured query language) auditing system of an integrated database is characterized in that: comprises a WEB front end, a service background and a database,
the WEB front end comprises a work order submitting module, a work order auditing module, an optimized recording module, a standard configuration module and a quality visualization module,
a submit work order module used for creating an SQL check work order;
the work order auditing module is used for auditing the created SQL auditing work order;
the optimization recording module is used for storing audit records and optimization records in work order audit;
the standard configuration module is used for carrying out standard standardized setting on the SQL auditing standard;
the quality visualization module is used for visualizing the SQL examination quality;
the service background comprises an API service module, a data acquisition module, an SQL management module, an auditing engine module, an optimizing engine module and a task scheduling module,
API service module, which is used to manage the data transmission interface between modules;
the data acquisition module is used for capturing basic data required by examination from a data source;
the SQL management module is used for completing the full life cycle management of the checked object;
the auditing engine module is used for finishing the definition and configuration work of the rule specification;
the optimization engine module is used for completing analysis of SQL execution characteristics, execution plans and operation efficiency and providing optimization suggestions;
the task scheduling module is used for scheduling the auditing tasks of a plurality of work orders;
the database comprises an auditing intermediate base module, a testing database module and an on-line database module,
the auditing intermediate library module is used for storing the acquired data and intermediate data and result data in the processing process;
the test database module is used for storing the test data of the SQL;
the on-line database module is used for storing data in the SQL formal operation process,
a multidimensional comprehensive database SQL examination and optimization method based on an SQL examination system comprises the following specific steps:
(1) filling SQL check work orders through a work order submitting module of the WEB front end;
(2) sending the filled SQL audit work order to a construction site audit module to form an audit request;
(3) sending the request to a service background through an API service module to carry out SQL examination;
(4) scheduling the requested SQL by a task scheduling module, and then auditing and outputting optimization suggestions to the audited object by an SQL management module, an auditing engine module and an optimization engine module;
(5) the auditing and optimizing suggestions are fed back to the work order auditing module through the API service module;
(6) simultaneously storing the optimization suggestion into an optimization recording module;
(7) performing data display on the checked SQL correspondingly through a quality visualization module;
(8) in the SQL operation process needing to be checked, SQL basic data acquisition is carried out through a data acquisition module;
(9) matching the current CMDB information to the slave library according to the metadata mapping relation, and initiating an audit requirement to the slave library;
(10) after the audit of the audit service, pushing an audit result to an API service module;
(11) the auditing and optimizing suggestions are fed back to the work order auditing module through the API service module;
(12) the optimization suggestion is stored in an optimization recording module,
according to the step (9), grammar implication auditing rules are set in the slave library,
according to steps (9) and (10), the audit service comprises an inclusion audit tool audit and targeted audit logic customization is carried out, the targeted audit logic customization comprises the customization of audit information and the customization of audit logic,
the audit information includes three types of information,
the first type of information is suggested information that is either significantly wrong or itself violates the basic specification,
the second category of information is a potential problem,
the third type of information is the improvement suggestion type information,
the core data stored by the database building module in the auditing process are an object class and an SQL class,
the quality visualization module is used for digitizing the quality of the SQL examination by the scoring system and visualizing the examination quality by the way of a billboard,
the auditing engine module is an auditing execution part for completing specific rules.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010205035.4A CN111078675B (en) | 2020-03-23 | 2020-03-23 | Multidimensional comprehensive database SQL (structured query language) auditing and optimizing method and system |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010205035.4A CN111078675B (en) | 2020-03-23 | 2020-03-23 | Multidimensional comprehensive database SQL (structured query language) auditing and optimizing method and system |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN111078675A CN111078675A (en) | 2020-04-28 |
| CN111078675B true CN111078675B (en) | 2021-08-10 |
Family
ID=70324659
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202010205035.4A Active CN111078675B (en) | 2020-03-23 | 2020-03-23 | Multidimensional comprehensive database SQL (structured query language) auditing and optimizing method and system |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN111078675B (en) |
Families Citing this family (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111651431B (en) * | 2020-06-09 | 2023-06-27 | 中国雄安集团数字城市科技有限公司 | Database service-oriented management flow standardization method |
| CN112348395A (en) * | 2020-11-20 | 2021-02-09 | 浙江百应科技有限公司 | Data quality visual detection system and method |
| CN112783917A (en) * | 2021-01-04 | 2021-05-11 | 广州海量数据库技术有限公司 | Work order auditing method and device, storage medium and electronic equipment |
| CN112783916A (en) * | 2021-01-04 | 2021-05-11 | 广州海量数据库技术有限公司 | SQL statement auditing method and device, storage medium and electronic equipment |
| CN113821497B (en) * | 2021-11-24 | 2022-02-18 | 深圳市佑荣信息科技有限公司 | Data maintenance method based on SQL automatic analysis and detection |
Family Cites Families (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US8510263B2 (en) * | 2009-06-15 | 2013-08-13 | Verisign, Inc. | Method and system for auditing transaction data from database operations |
| CN108509530A (en) * | 2018-03-14 | 2018-09-07 | 武汉斗鱼网络科技有限公司 | A kind of slow query statement automatic optimization method of MySQL, computer equipment and storage medium |
| CN110263054B (en) * | 2019-05-30 | 2021-11-09 | 世纪龙信息网络有限责任公司 | SQL work order auditing system, method and device and computer equipment |
| CN110413638A (en) * | 2019-08-27 | 2019-11-05 | 中信百信银行股份有限公司 | A kind of SQL detection device and method |
| CN110674161A (en) * | 2019-09-20 | 2020-01-10 | 上海擎感智能科技有限公司 | Method, system, storage medium and SQL operation platform for online SQL |
-
2020
- 2020-03-23 CN CN202010205035.4A patent/CN111078675B/en active Active
Also Published As
| Publication number | Publication date |
|---|---|
| CN111078675A (en) | 2020-04-28 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN111078675B (en) | Multidimensional comprehensive database SQL (structured query language) auditing and optimizing method and system | |
| US11436213B1 (en) | Analysis of database query logs | |
| CN112395325A (en) | Data management method, system, terminal equipment and storage medium | |
| US8849840B2 (en) | Quick find for data fields | |
| US8943059B2 (en) | Systems and methods for merging source records in accordance with survivorship rules | |
| US11294869B1 (en) | Expressing complexity of migration to a database candidate | |
| US11663239B2 (en) | Database systems and user interfaces for interactive data association, analysis, and presentation | |
| CN106445536B (en) | Automatic business design management system | |
| CN110442620B (en) | Big data exploration and cognition method, device, equipment and computer storage medium | |
| CN112527774A (en) | Data center building method and system and storage medium | |
| CN111984709A (en) | Visual big data middle station-resource calling and algorithm | |
| CN104715347A (en) | Comprehensive data processing system for debugging work of nuclear power station | |
| EP2830010A2 (en) | Methods and systems for providing intuitive direction for populating complex model content into a database | |
| Dakrory et al. | Automated ETL testing on the data quality of a data warehouse | |
| CN112231380A (en) | Method and system for comprehensively processing acquired data, storage medium and electronic equipment | |
| CN112445867A (en) | Intelligent analysis method and system for data relationship | |
| CN115982213A (en) | BI data analysis method, system and storage medium | |
| CN116010439A (en) | Visual Chinese SQL system and query construction method | |
| CN106909691A (en) | A kind of efficient revenue data analysis method based on caching | |
| CN113886465A (en) | Big data analysis platform for automobile logistics | |
| CN111143406A (en) | Database data comparison method and database data comparison system | |
| Rong et al. | DBinsight: A Tool for Interactively Understanding the Query Processing Pipeline in RDBMSs | |
| Lin et al. | OREO: Detection of cherry-picked generalizations | |
| US20160217190A1 (en) | System for extracting records from a non-relational database based on one or more relational database management system (rdbms) language statements | |
| CN114756583A (en) | Business data verification method based on business data standard table |
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: 20210630 Address after: 10 / F, building 1, 258 Xiqin street, Wuchang Street, Yuhang District, Hangzhou City, Zhejiang Province 310000 Applicant after: Green City Technology Industry Service Group Co.,Ltd. Address before: Room 1507, 15th floor, block a, Huaxing Times Square, 478 Wensan Road, Xihu District, Hangzhou City, Zhejiang Province, 310000 Applicant before: Green Man Technology Co.,Ltd. |
|
| GR01 | Patent grant | ||
| GR01 | Patent grant | ||
| PE01 | Entry into force of the registration of the contract for pledge of patent right | ||
| PE01 | Entry into force of the registration of the contract for pledge of patent right |
Denomination of invention: A Multidimensional Comprehensive Database SQL Audit and Optimization Method and System Granted publication date: 20210810 Pledgee: Guotou Taikang Trust Co.,Ltd. Pledgor: Green City Technology Industry Service Group Co.,Ltd. Registration number: Y2024980011350 |