CN111651758B - Method for auditing result set of relational database of operation and maintenance auditing system - Google Patents
Method for auditing result set of relational database of operation and maintenance auditing system Download PDFInfo
- Publication number
- CN111651758B CN111651758B CN202010514711.6A CN202010514711A CN111651758B CN 111651758 B CN111651758 B CN 111651758B CN 202010514711 A CN202010514711 A CN 202010514711A CN 111651758 B CN111651758 B CN 111651758B
- Authority
- CN
- China
- Prior art keywords
- sql
- result set
- sql request
- data
- maintenance
- 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
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F21/00—Security arrangements for protecting computers, components thereof, programs or data against unauthorised activity
- G06F21/50—Monitoring users, programs or devices to maintain the integrity of platforms, e.g. of processors, firmware or operating systems
- G06F21/55—Detecting local intrusion or implementing counter-measures
- G06F21/552—Detecting local intrusion or implementing counter-measures involving long-term monitoring or reporting
-
- 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
- G06F16/2448—Query languages for particular applications; for extensibility, e.g. user defined types
-
- 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/245—Query processing
- G06F16/2455—Query execution
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Databases & Information Systems (AREA)
- Data Mining & Analysis (AREA)
- Computational Linguistics (AREA)
- Computer Security & Cryptography (AREA)
- Software Systems (AREA)
- Mathematical Physics (AREA)
- Computer Hardware Design (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention discloses a method for auditing a relational database result set of an operation and maintenance auditing system, which comprises the following steps: 1) After an SQL request statement is input into an operation and maintenance auditing system, an SQL request event is operated, a unique non-repetitive ID is generated, the ID is used as a cursor to be bound with the current SQL request statement, and then the ID and the current SQL request statement are stored in an auditing SQL request table; 2) Returning related binary stream data from a server of the operation and maintenance asset according to the SQL request statement, operating a result set event by the operation and maintenance auditing system, obtaining at least one compatibility result set, binding each compatibility result set with the ID bound with the current SQL request statement, and storing the compatibility result sets in a result set table; 3) The SQL request table and the result set table are associated by using the ID. The invention provides byte stream storage table data with self-description capability, can fill the problem that the current operation and maintenance auditing effect cannot audit the SQL query result set according to the storage form of table structure dynamic extension, and can better cope with the scenario of SQL batch query multi-result set.
Description
Technical Field
The invention relates to the technical field of technical network information, in particular to a method for auditing a relational database result set of an operation and maintenance auditing system.
Background
The operation and maintenance auditing system is a new generation of operation and maintenance safety auditing product, can carry out fine-grained authorization, operation record and control of the whole process, omnibearing operation auditing and support the function of replaying the operation process afterwards on the access process of operation and maintenance personnel, realizes 'precaution, control in the process and audit afterwards' in the operation and maintenance process, simplifies operation and maintenance operation, comprehensively solves the operation and maintenance safety problems in various complex environments and improves the IT operation and maintenance management level of enterprises. The current operation and maintenance auditing system supports the operation and maintenance auditing characteristics of a database, and is convenient for an administrator to record all SQL requests of the operator, thereby facilitating the audit afterwards. However, the current operation and maintenance auditing system only audits the requests of the SQL, and does not audit the data (result set) obtained by the SQL query, so that pain points that an auditing manager cannot know which data in the database are obtained by an operator are generated.
Disclosure of Invention
Aiming at the defects of the prior art, the invention aims to provide a method for auditing the result set of the relational database of the operation and maintenance auditing system, which records all related result sets of SQL while recording the SQL request and is convenient for auditing after the fact.
In order to achieve the purpose, the invention is realized by the following technical scheme: a method for auditing a relational database result set of an operation and maintenance auditing system comprises the following steps:
(1) After the operation and maintenance person inputs the SQL request statement in the operation and maintenance auditing system, the operation and maintenance auditing system operates the SQL request event, generates a unique non-repeated ID for each current SQL request statement in the SQL request event, the ID is used as a cursor to be bound with the current SQL request statement, and then stores the SQL request statement data and the bound ID into an auditing SQL request table;
(2) According to a current SQL request statement in the SQL request event, the server of the operation and maintenance asset returns relevant binary stream data to the operation and maintenance auditing system, the operation and maintenance auditing system runs a result set event, the returned binary stream data generates at least one compatibility result set relevant to the current SQL request statement, each compatibility result set is bound with an ID bound with the current SQL request statement, and each compatibility result set is sequentially and independently stored in a result set table;
(3) And the ID is used for associating the SQL request table and the result set table, so that all related compatibility result sets of the SQL are recorded at the same time when the SQL request is recorded, and the related compatibility result sets can be associated by inquiring the SQL request table.
In order to better implement the method of the present invention, further, in step (1), the unique non-repeating ID bound to the SQL request statement is generated by the snowfall ID generation module according to the at least one influence factor. Snowflake is a set of incremental ID generation algorithms designed by Twitter at first, in order to be able to generate thousands of unique and non-repeating IDs in every second or every millisecond. The Snowflakeid is sorted according to time increase on the whole, because the ID is integrated with the machine Mac, the ID collision cannot be generated in the whole distributed system, the efficiency is high, and tests show that the SnowFlake can generate about 26 thousands of IDs per second.
In order to better implement the method of the present invention, further, the influence factor that influences the snowfall ID generation module to generate the unique non-repetitive ID includes the time of the current operation and maintenance auditing system or the machine Mac address of the loading operation and maintenance auditing system.
In order to better implement the method of the present invention, further, in step (1), the specific process of the operation and maintenance auditing system running the SQL request event includes:
(1.1) detecting that an SQL request statement arrives by an auditing engine of the operation and maintenance auditing system;
(1.2) sending the data with the detected SQL request statement to an SQL extraction module, wherein the SQL extraction module extracts SQL key information in the SQL request statement and transmits the SQL key information to an SQL transcoding module;
and (1.3) transcoding the fields in the SQL request statement by the SQL transcoding module to generate human-readable plaintext characters, binding the human-readable plaintext characters with the unique non-repetitive ID, and storing the human-readable plaintext characters in an audit SQL request table.
According to the working principle of the technical scheme, the ID is used for associating SQL query request statements and a result set, different relational database protocol packets are returned, analyzed and purified into TLV internal format for dumping, and the auditing and the SQL association display are performed. The key point is that the uid is used for correlating SQL with a result set, and an incompatible protocol result set is purified into a unified TLV format for storage and display.
In order to better implement the method of the present invention, further, in step (1.2), the SQL key information extracted from the SQL request statement by the SQL extraction module includes the content of the SQL request statement and the attribute related to the content of the SQL request statement.
In order to better implement the method of the present invention, further, in the step (2), the specific process of the operation and maintenance auditing system running the result set event is as follows:
(2.1) an auditing engine of the operation and maintenance auditing system detects the arrival of a binary data stream related to an SQL request statement returned from a server of the operation and maintenance asset;
(2.2) transmitting all the binary data streams and the related protocol transmission types to a result set parser in the compatibility processing module, and parsing the binary data streams by the result set parser according to the protocol transmission types of the binary data streams;
(2.3) converting or transcoding the analyzed data into compatible pure character type data through a compatibility processing module;
(2.4) sequentially recombining the compatible pure character type data, and simultaneously generating a human-readable plaintext character line, thereby obtaining single-line data in a single result set;
(2.5) repeating the processing of the single row of data until a single compatibility result set is generated;
(2.6) repeating the generation process of the single compatibility result set until all the binary data streams are processed to obtain the whole result set.
In order to better implement the method of the present invention, further, in step (2.2), the process of parsing the binary data stream by the result set parser is as follows:
(2.2.1) initializing an analysis environment according to the transmission protocol type, calling an analysis function to specially process the binary data stream of the protocol type after initialization is finished, and splitting the binary data stream into a table structure segment and a table data segment;
(2.2.2) extracting relevant constraints for the table structure segment, the relevant constraints including a table field name, and a field data type; splitting the data stream boundary according to the protocol transmission type aiming at the table data segment part, and counting the line count by the data stream boundary;
in order to better implement the method of the present invention, further, in the step (2.3), a specific process of converting or transcoding the parsed data into compatible pure character type data by the compatibility processing module is as follows: and the compatibility processing module converts or transcodes all the identified boundary data into compatible pure character type data according to the protocol transmission type of the current binary data stream, and if the field is empty, the field is marked with an empty lattice.
In order to better implement the method of the present invention, further, the compatibility processing module needs to add an agreed type and length information of row data.
In order to better implement the method of the present invention, further, in step (3), the SQL request table and the result set table are both stored in the audit data storage module.
Compared with the prior art, the invention has the following advantages and beneficial effects:
(1) The method provided by the invention solves the difference of the result sets transmitted by each relational database, and audits the differentiated result sets in a compatible mode, thereby overcoming the defects that the returned result sets have differences caused by various forms or conventions and the like due to different transmission protocols of each relational database, and the operation and maintenance auditing system cannot directly audit;
(2) The method realizes a conversion module of a compatible layer, converts and transcodes the data types in each database transmission protocol to make the data types become a common known format so as to meet the compliance requirements of daily audit, avoids the large data difference caused by different relational database transmission protocols, and then carries out serialization and recombination on the data so as to restore the data to the original sequence structure in the data stream, thereby ensuring that the audited effect is the same as the view of an operator.
(3) The byte stream storage table data with the self-description capability can dynamically expand table fields and row data by using type + len + value definition according to the storage form of the dynamic expansion of the table structure, the problem that the current operation and maintenance auditing effect cannot audit the result set returned by SQL query is solved, the situation that a plurality of result sets are returned by SQL batch query can be better dealt with, and the technical problem that the data cannot be stored in a traditional fixed distribution mode due to the uncertainty of the data types, various field constraint lengths, row numbers and column numbers in the result set differentiation table in the database is solved.
Drawings
Other features, objects and advantages of the invention will become more apparent upon reading of the detailed description of non-limiting embodiments with reference to the following drawings:
FIG. 1 is a flow chart of the method of the present invention;
FIG. 2 is a flow chart of a result set in the present invention;
FIG. 3 is a storage structure diagram of an audit data storage module according to the present invention.
Detailed Description
Reference will now be made in detail to embodiments of the present invention, examples of which are illustrated in the accompanying drawings, wherein like reference numerals refer to the same or similar elements or elements having the same or similar functions throughout. The embodiments described below with reference to the accompanying drawings are illustrative only for the purpose of explaining the present invention, and are not to be construed as limiting the present invention.
For the purpose of making the objects, conditions and advantages of the present invention more apparent, the present invention will be further described in detail with reference to the following examples, but the embodiments of the present invention are not limited thereto, and various substitutions and alterations can be made without departing from the above technical idea of the present invention based on the common technical knowledge and the conventional means in the field, and the specific examples described herein are only for explaining the present invention, and are not intended to limit the present invention.
Some module names and definitions are as follows:
SQL: structured Query Language (SQL), a special purpose programming Language, is a database Query and programming Language for accessing data and querying, updating, and managing relational database systems.
Structured query languages are high-level, non-procedural programming languages that allow users to work on high-level data structures. The method does not require a user to specify a data storage method, and does not require the user to know a specific data storage mode, so that different database systems with completely different underlying structures can use the same structured query language as an interface for data input and management. The structured query language statements can be nested, which makes it extremely flexible and powerful
And (4) result set: it is the set of all rows that an object contains that meet the conditions in the SQL statement. It provides access to the data in these rows by a set of get methods that can access different columns in the current row. The result set is typically a table in which column headers and corresponding values are returned by the query.
Operation and maintenance auditing system: the new generation of operation and maintenance safety audit product can carry out fine-grained authorization, operation recording and control in the whole process, omnibearing operation audit and support the function of replaying the operation process afterwards on the access process of operation and maintenance personnel, realizes 'precaution, control in the process and audit afterwards' in the operation and maintenance process, comprehensively solves the operation and maintenance safety problems in various complex environments while simplifying operation and maintenance operation, and improves the IT operation and maintenance management level of enterprises.
Snowflake: is a self-incrementing ID generation algorithm designed by Twitter in the first place, in order to be able to generate thousands of unique non-repeating IDs in every second or every millisecond. The Snowflakeid is sorted according to time increase on the whole, because the ID is integrated with the machine Mac, the ID collision cannot be generated in the whole distributed system, the efficiency is high, and tests show that the SnowFlake can generate about 26 thousands of IDs per second.
Example 1:
as shown in fig. 1, the main workflow of this embodiment includes the following steps:
(1) After the operation and maintenance person inputs the SQL request statement in the operation and maintenance auditing system, the operation and maintenance auditing system operates the SQL request event, generates a unique non-repeated ID for each current SQL request statement in the SQL request event, the ID is used as a cursor to be bound with the current SQL request statement, and then stores the SQL request statement data and the bound ID into an auditing SQL request table;
(2) According to the current SQL request statement in the SQL request event, the server of the operation and maintenance asset returns relevant binary stream data to the operation and maintenance auditing system, the operation and maintenance auditing system runs a result set event, the returned binary stream data generates at least one compatibility result set relevant to the current SQL request statement, each compatibility result set is bound with the ID bound with the current SQL request statement, and each compatibility result set is sequentially and independently stored in a result set table;
(3) And the ID is used for associating the SQL request table and the result set table, so that all related compatibility result sets of the SQL are recorded at the same time when the SQL request is recorded, and the related compatibility result sets can be associated by inquiring the SQL request table.
In the step (1), the unique non-repetitive ID bound with the SQL request statement is generated by the snowfall ID generation module according to the current time of the operation and maintenance auditing system or other influence factors such as a machine Mac address for loading the operation and maintenance auditing system.
During specific query, only the operation and maintenance manager needs to query the SQL request statement in the recorded SQL request table, and the result set returned by the operation and maintenance asset server and requested by the SQL request statement can be associated through the unique ID, so that the audit is convenient.
Example 2:
on the basis of the above embodiment, the embodiment further defines a specific process of the operation and maintenance auditing system for running the SQL request event, which is specifically as follows:
SQL request event:
1. the auditing engine detects that SQL sentences arrive
2. Sending the data with the detected SQL statement to an SQL extraction module for extracting the content of the SQL statement, and simultaneously extracting the related attributes of the SQL statement
3. Transcoding the SQL content extracted in the last step according to the fields in the SQL attributes to generate final plaintext characters for temporary storage
4. Generating a unique ID by using snowflakeID according to factors such as current system time, machine Mac address and the like, and binding the ID with the current SQL statement
5. And storing the SQL statement and the unique ID into an audit SQL request table.
Other parts of this embodiment are the same as those of the above embodiment, and are not described again here.
Example 3:
on the basis of the foregoing embodiment, the embodiment further defines a specific process of the operation and maintenance auditing system running result set event, as shown in fig. 2, specifically as follows:
result set events:
1. the audit engine detects that multiple result sets are returned from the relational database server
2. All result set related data are sent to the result set compatibility processing module through the local socket to execute processing, and the current protocol transmission type is transmitted at the same time
3. The result set compatibility processing module initializes the analysis environment according to the transmission protocol type, calls a special item of an analysis function to process the result set of the protocol type after initialization is completed, and splits the result set into a table structure section and a table data section. The table field names, field data types, and other relevant constraints are then extracted for the table structure field. The table data segment part starts to split the data stream boundary according to the protocol data type and counts the line number by the boundary.
4. And after the previous step of processing is completely finished, the compatible layer processing module starts to work. Depending on the protocol, all data stream fields with identified boundaries are initially converted/transcoded into compatible pure character type data, and if the field is empty, a space mark is used. After the single-row data stream is processed, all the pure character data processed by the compatible layer are sequentially recombined according to the sequence defined by the analytic data stream, a human-readable plaintext character line is generated at the same time, finally, the type data is stored by using a dynamic data stream structure, and the compatible layer also needs to add the appointed type and the length information of the row data. And then completing the processing of single-row data of the returned result set data stream of the differential database.
5. And after all the data streams of the single result set are processed completely, binding the audit data of the result set with the current unique ID, and then storing the audit data in the result set list. Then, the processing flow of the next result set is carried out, and the step 3 is returned.
The difference of the transmission protocols of various relational databases causes large data difference, and because the difference of the transmission protocols of various relational databases causes the difference of returned result sets caused by various forms or appointments and the like, the operation and maintenance auditing system can not directly audit. Therefore, a technology is urgently needed to solve the difference of the result sets transmitted by the relational databases and audit the difference result sets in a compatible manner.
The conversion module of a compatible layer is realized, the data types in each database transmission protocol are converted and transcoded to form a common known format so as to meet the compliance requirements of daily audit, and then the data are serialized and recombined to restore the original sequence structure in the data stream, so that the audited effect is the same as that of an operator view.
Because of the uncertainty of the data type, the constraint length of various fields, the uncertainty of the number of rows and the uncertainty of the number of columns in the result set differentiation table in the database, the data can not be stored in a traditional fixed distribution mode. There is therefore a need for a storage form that can be dynamically expanded according to the table structure.
Aiming at the problems, the scheme uses byte stream storage table data with self-description capability, and uses type + len + value definition to dynamically expand table fields and row data.
Other parts of this embodiment are the same as those of the above embodiment, and are not described again here.
Example 4:
in this embodiment, based on the above embodiment, the storage structures of the SQL request table and the result set request table are further defined, as shown in fig. 3, both the SQL request table and the result set table are stored in the audit data storage module. The key point of the invention is to realize a universal compatible processing module of the database analysis module, bind the SQL statement request and the database return result set by using the global unique ID as the state for coping with the differentiation of different relational database tables, and solve the correlation problem of inquiry after audit. The problem that the result set returned by the SQL query cannot be audited by the current operation and maintenance auditing effect is solved, and the scenario that a plurality of result sets are returned by the SQL batch query can be well dealt with. Other parts of this embodiment are the same as those of the above embodiment, and are not described again here.
While embodiments of the invention have been shown and described, it will be understood by those of ordinary skill in the art that: various changes, modifications, substitutions and alterations can be made to these embodiments without departing from the principles and spirit of the invention, the scope of which is defined by the claims and their equivalents.
Claims (6)
1. A method for auditing a relational database result set of an operation and maintenance auditing system is characterized by comprising the following steps:
(1) After the operation and maintenance person inputs the SQL request statement in the operation and maintenance auditing system, the operation and maintenance auditing system operates the SQL request event, generates a unique non-repeated ID for each current SQL request statement in the SQL request event, the ID is used as a cursor to be bound with the current SQL request statement, and then stores the SQL request statement data and the bound ID into an auditing SQL request table;
(2) According to the current SQL request statement in the SQL request event, the server of the operation and maintenance asset returns relevant binary stream data to the operation and maintenance auditing system, the operation and maintenance auditing system runs a result set event, the returned binary stream data generates at least one compatibility result set relevant to the current SQL request statement, each compatibility result set is bound with the ID bound with the current SQL request statement, and each compatibility result set is sequentially and independently stored in a result set table; the specific process of the operation result set event of the operation and maintenance auditing system is as follows:
(2.1) an auditing engine of the operation and maintenance auditing system detects the arrival of a binary data stream related to an SQL request statement returned from a server of the operation and maintenance asset;
(2.2) transmitting all the binary data streams and the related protocol transmission types to a result set parser in the compatibility processing module, and parsing the binary data streams by the result set parser according to the protocol transmission types of the binary data streams; the process of analyzing the binary data stream by the result set analyzer is as follows:
(2.2.1) initializing an analysis environment according to the transmission protocol type, calling an analysis function to specially process the binary data stream of the protocol type after initialization is finished, and splitting the binary data stream into a table structure segment and a table data segment;
(2.2.2) extracting relevant constraints for the table structure segment, the relevant constraints including a table field name, and a field data type; splitting the data stream boundary according to the protocol transmission type aiming at the table data segment part, and counting the line count by the data stream boundary;
(2.3) converting or transcoding the analyzed data into compatible pure character type data through a compatibility processing module; the specific process of converting or transcoding the analyzed data into compatible pure character type data by the compatibility processing module is as follows: the compatibility processing module converts or transcodes all the identified boundary data into compatible pure character type data according to the protocol transmission type of the current binary data stream, and if the field is empty, the field is marked by an empty lattice;
(2.4) sequentially recombining the compatible pure character type data, and simultaneously generating a human-readable plaintext character line, thereby obtaining single-line data in a single result set;
(2.5) repeating the processing of the single row of data until a single compatibility result set is generated;
(2.6) repeating the generation process of the single compatibility result set until all binary data streams are processed to obtain all result sets; the compatibility processing module also needs to add appointed type and length information of row data;
(3) And the ID is used for associating the SQL request table and the result set table, so that all related compatibility result sets of the SQL are recorded at the same time when the SQL request is recorded, and the related compatibility result sets can be associated by inquiring the SQL request table.
2. The method according to claim 1, wherein in step (1), the unique non-repeating ID bound to the SQL request statement is generated by a snowflow ID generation module according to at least one influence factor.
3. The method of claim 2, wherein the influence factors that influence the snowfall ID generation module to generate the unique non-repetitive ID include a time of a current operation and maintenance auditing system or a machine Mac address of a machine on which the operation and maintenance auditing system is loaded.
4. The method for auditing the relational database result set of the operation and maintenance auditing system according to any one of claims 1 to 3, wherein in the step (1), the specific process of the operation and maintenance auditing system for running the SQL request event is as follows:
(1.1) detecting that an SQL request statement arrives by an auditing engine of the operation and maintenance auditing system;
(1.2) sending the data with the detected SQL request statement to an SQL extraction module, wherein the SQL extraction module extracts the SQL key information in the SQL request statement and transmits the SQL key information to an SQL transcoding module;
and (1.3) transcoding the fields in the SQL request statement by the SQL transcoding module to generate human-readable plaintext characters, binding the human-readable plaintext characters with the unique non-repetitive ID, and storing the human-readable plaintext characters in an audit SQL request table.
5. The method according to claim 4, wherein in step (1.2), the SQL key information extracted from the SQL request statement by the SQL extraction module includes the content of the SQL request statement and the attribute related to the content of the SQL request statement.
6. The method for auditing the result set of the relational database of the operation and maintenance auditing system according to any one of claims 1 to 3, wherein in the step (3), the SQL request table and the result set table are both stored in an auditing data storage module.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010514711.6A CN111651758B (en) | 2020-06-08 | 2020-06-08 | Method for auditing result set of relational database of operation and maintenance auditing system |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010514711.6A CN111651758B (en) | 2020-06-08 | 2020-06-08 | Method for auditing result set of relational database of operation and maintenance auditing system |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN111651758A CN111651758A (en) | 2020-09-11 |
| CN111651758B true CN111651758B (en) | 2022-11-22 |
Family
ID=72343441
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202010514711.6A Active CN111651758B (en) | 2020-06-08 | 2020-06-08 | Method for auditing result set of relational database of operation and maintenance auditing system |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN111651758B (en) |
Families Citing this family (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110287308A (en) * | 2019-06-13 | 2019-09-27 | 薛映杜 | A kind of computer data formula statistical method |
| CN114157501B (en) * | 2021-12-08 | 2024-01-23 | 北京天融信网络安全技术有限公司 | Parameter analysis method and device based on TianRui database |
Citations (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1904885A (en) * | 2005-07-29 | 2007-01-31 | 北京航空航天大学 | Database adapter |
| CN102184222A (en) * | 2011-05-05 | 2011-09-14 | 杭州安恒信息技术有限公司 | Quick searching method in large data volume storage |
| CN103488797A (en) * | 2013-10-14 | 2014-01-01 | 德讯科技股份有限公司 | MYSQL database-based SQL information acquisition and audit system |
| CN103678354A (en) * | 2012-09-11 | 2014-03-26 | 中国移动通信集团公司 | Local relation type database node scheduling method and device based on cloud computing platform |
| CN106021071A (en) * | 2016-05-04 | 2016-10-12 | 北京思特奇信息技术股份有限公司 | Method and system for monitoring SQL operation process |
| CN106156168A (en) * | 2015-04-16 | 2016-11-23 | 华为技术有限公司 | The method of data is being inquired about and across subregion inquiry unit in partitioned data base |
| US10545957B1 (en) * | 2016-07-08 | 2020-01-28 | Jpmorgan Chase Bank, N.A. | Method and system for implementing a batch stored procedure testing tool |
| CN110941632A (en) * | 2019-11-19 | 2020-03-31 | 杭州迪普科技股份有限公司 | Database auditing method, device and equipment |
Family Cites Families (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104794247B (en) * | 2015-05-14 | 2018-01-05 | 东南大学 | A kind of more structural databases integrate querying method |
| CN105912594B (en) * | 2016-04-05 | 2020-01-07 | 深信服科技股份有限公司 | SQL statement processing method and system |
| CN110851461A (en) * | 2019-10-31 | 2020-02-28 | 深信服科技股份有限公司 | Method and device for auditing non-relational database and storage medium |
-
2020
- 2020-06-08 CN CN202010514711.6A patent/CN111651758B/en active Active
Patent Citations (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1904885A (en) * | 2005-07-29 | 2007-01-31 | 北京航空航天大学 | Database adapter |
| CN102184222A (en) * | 2011-05-05 | 2011-09-14 | 杭州安恒信息技术有限公司 | Quick searching method in large data volume storage |
| CN103678354A (en) * | 2012-09-11 | 2014-03-26 | 中国移动通信集团公司 | Local relation type database node scheduling method and device based on cloud computing platform |
| CN103488797A (en) * | 2013-10-14 | 2014-01-01 | 德讯科技股份有限公司 | MYSQL database-based SQL information acquisition and audit system |
| CN106156168A (en) * | 2015-04-16 | 2016-11-23 | 华为技术有限公司 | The method of data is being inquired about and across subregion inquiry unit in partitioned data base |
| CN106021071A (en) * | 2016-05-04 | 2016-10-12 | 北京思特奇信息技术股份有限公司 | Method and system for monitoring SQL operation process |
| US10545957B1 (en) * | 2016-07-08 | 2020-01-28 | Jpmorgan Chase Bank, N.A. | Method and system for implementing a batch stored procedure testing tool |
| CN110941632A (en) * | 2019-11-19 | 2020-03-31 | 杭州迪普科技股份有限公司 | Database auditing method, device and equipment |
Non-Patent Citations (4)
| Title |
|---|
| FUG BASED INTELLIGENT QUERY FOR AUDIT DATABASE;LI-XIA XIE 等;《2008 International Conference on Machine Learning and Cybernetics》;20080905;第2546-2550页 * |
| 企业分布式数据库访问系统的设计与实现;王珂琦;《中国优秀博硕士学位论文全文数据库(硕士) 信息科技辑》;20041215(第04期);第I138-564页 * |
| 基于后关系型数据库审计的安全解决方案;韩向非 等;《中国数字医学》;20161115;第11卷(第11期);第71-73+110页 * |
| 数据库审计系统中MySQL协议的研究与解析;安延文;《中国优秀博硕士学位论文全文数据库(硕士) 信息科技辑》;20170215(第02期);第I138-2358页 * |
Also Published As
| Publication number | Publication date |
|---|---|
| CN111651758A (en) | 2020-09-11 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US7155641B2 (en) | System and method for monitoring the performance of a server | |
| US6691101B2 (en) | Database system providing optimization of group by operator over a union all | |
| US7805341B2 (en) | Extraction, transformation and loading designer module of a computerized financial system | |
| CN100401288C (en) | Distributed data source data integration system and method | |
| US6728727B2 (en) | Data management apparatus storing uncomplex data and data elements of complex data in different tables in data storing system | |
| CN103455540B (en) | The system and method for generating memory model from data warehouse model | |
| US6760732B2 (en) | Method and system for viewing a record of an organization having a hierarchy of departments | |
| CN105005618A (en) | Data synchronization method and system among heterogeneous databases | |
| US7925002B2 (en) | Administering multiple target ACD systems | |
| US20090299987A1 (en) | Methods and systems for metadata driven data capture for a temporal data warehouse | |
| EP1457878B1 (en) | Automatic generation of an object model from a dimensional model | |
| CN111651758B (en) | Method for auditing result set of relational database of operation and maintenance auditing system | |
| CN101901242A (en) | Federated configuration data management | |
| CN102081661A (en) | Data integration method and system of heterogeneous relational database based on XML (Extensive Makeup Language) | |
| US8913264B2 (en) | Method and system for storing and retrieving data | |
| US20060294076A1 (en) | System and method for query planning and execution | |
| CN101405728A (en) | Relational database architecture with dynamic load capability | |
| CN111177244A (en) | Data association analysis method for multiple heterogeneous databases | |
| CN104392123A (en) | CDA (Clinical Document Architecture) engine system and implementation method | |
| US7844601B2 (en) | Quality of service feedback for technology-neutral data reporting | |
| US7475088B2 (en) | Systems and methods of providing data from a data source to a data sink | |
| US20090313644A1 (en) | Method and system for providing access to adapters | |
| CN111611222A (en) | Data dynamic processing method based on distributed storage | |
| CN105809577B (en) | Power plant informatization data classification processing method based on rules and components | |
| CN116644039B (en) | Automatic acquisition and analysis method for online capacity operation log based on big data |
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 | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |