CN109783543B - Data query method, device, equipment and storage medium - Google Patents
Data query method, device, equipment and storage medium Download PDFInfo
- Publication number
- CN109783543B CN109783543B CN201910031419.6A CN201910031419A CN109783543B CN 109783543 B CN109783543 B CN 109783543B CN 201910031419 A CN201910031419 A CN 201910031419A CN 109783543 B CN109783543 B CN 109783543B
- Authority
- CN
- China
- Prior art keywords
- data
- query
- database
- information
- field
- 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
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The embodiment of the invention discloses a data query method, a data query device, data query equipment and a storage medium. The method comprises the following steps: acquiring data query information and at least one piece of data source information, wherein the data query information comprises: a field name, and a field value corresponding to the field name; performing data query on the data query information in at least one database which is stored in a server and matched with the data source information, and acquiring at least one data record matched with the data query information; and generating a feedback result of the data query information according to the data record. When the method is used for data query, the operation risk of a user on the database can be reduced, and the problem that the time consumption is too much when the data records are tracked only according to the field names and the corresponding field values can be solved.
Description
Technical Field
The embodiment of the invention relates to a database processing technology, in particular to a data query method, a data query device, data query equipment and a storage medium.
Background
A database is a repository that organizes and stores large amounts of data in a data structure, where a data structure refers to the organizational form of data or the relationship between data. The user can perform operations such as query, addition, interception, update, deletion and the like on the data in the database according to specific requirements.
When some data in the database need to be inquired, but only one or two field names and corresponding field values related to the data are needed, a user can search corresponding data records according to related inquiry codes, the inquiry time consumption is in direct proportion to the data storage amount of the database, and the user can directly search the data records according to the data storage information in the memory. However, both of the above query methods require the user to perform related operations on the server, which may cause the problems of reduced operating efficiency and even performance blocking of the server, and once the user performs an operation error, some database accidents may occur, such as data deletion by mistake or data modification by mistake.
Disclosure of Invention
Embodiments of the present invention provide a data query method, apparatus, device, and storage medium, so as to reduce user operation risk and solve the problem of too much time consumption for tracking data records according to a field name and a corresponding field value.
In a first aspect, an embodiment of the present invention provides a data query method, including:
acquiring data query information and at least one piece of data source information, wherein the data query information comprises: a field name, and a field value corresponding to the field name;
performing data query on the data query information in at least one database which is stored in a server and matched with the data source information, and acquiring at least one data record matched with the data query information;
and generating a feedback result of the data query information according to the data record.
In a second aspect, an embodiment of the present invention further provides a data query apparatus, where the apparatus includes:
an obtaining module, configured to obtain data query information and at least one piece of data source information, where the data query information includes: a field name, and a field value corresponding to the field name;
the query module is used for performing data query on the data query information in at least one database which is stored in the server and matched with the data source information to acquire at least one data record matched with the data query information;
and the feedback module is used for generating a feedback result of the data query information according to the data record.
In a third aspect, an embodiment of the present invention further provides a computer device, where the computer device includes:
one or more processors;
a memory for storing one or more programs,
when the one or more programs are executed by the one or more processors, the one or more processors implement the data query method of any embodiment.
In a fourth aspect, the present invention further provides a computer-readable storage medium, on which a computer program is stored, where the computer program is executed by a processor to implement the data query method according to any embodiment.
In the embodiment of the invention, the database to be accessed is limited to the database matched with the data source information according to the acquired data source information instead of all the databases stored on the server, so that the range of the database for carrying out data query on the data query information is reduced, and the query time is shortened; the technical means of remotely accessing at least one database which is stored in the server and matched with the data source information according to the data source information and carrying out data query on the data query information is adopted, only query permission is opened for a user, so that the user does not need to directly operate on the server, the operation efficiency and even the performance of the server are not affected, and the problem that database accidents are possibly caused due to the fact that the user inputs wrong codes on the server is avoided. Therefore, when the data query is carried out by the data query method provided by the embodiment of the invention, the operation risk of a user on the database can be reduced, and the problem that the time consumption is too much when the data records are tracked only according to the field names and the corresponding field values can be solved.
Drawings
FIG. 1 is a flowchart of a data query method according to an embodiment of the present invention;
fig. 2A is a flowchart of a data query method according to a second embodiment of the present invention;
fig. 2B is a schematic structural diagram of a database sub-table according to a second embodiment of the present invention;
fig. 2C is a schematic structural diagram of a database sub-table according to a second embodiment of the present invention;
fig. 3A is a flowchart of a data query method according to a third embodiment of the present invention;
fig. 3B is a schematic diagram of an application interface to which a data query method according to a third embodiment of the present invention is applied;
fig. 3C is a schematic diagram of an application interface to which a data query method according to a third embodiment of the present invention is applied;
fig. 4 is a schematic block diagram of a data query apparatus according to a fourth embodiment of the present invention;
fig. 5 is a schematic structural diagram of a computer device according to a fifth embodiment of the present invention.
Detailed Description
The present invention will be described in further detail with reference to the accompanying drawings and examples. It is to be understood that the specific embodiments described herein are merely illustrative of the invention and are not limiting of the invention. It should be further noted that, for the convenience of description, only some of the structures related to the present invention are shown in the drawings, not all of the structures.
Example one
Fig. 1 is a flowchart of a data query method according to an embodiment of the present invention, where this embodiment is applicable to a case where a database query is performed only on one or two field names and corresponding field values to obtain data records matching the field names and the corresponding field values, and the method may be performed by a data query apparatus according to any embodiment of the present invention, where the apparatus may be composed of hardware and/or software, and may be generally integrated in a processor of a computer device.
In the process of software development and/or operation, various problems inevitably occur, so that data related to the problems need to be positioned, and problem troubleshooting is performed after related data records are obtained, while only one or two field names and field values respectively corresponding to the field names may exist in a tracking log of the software, and at this time, the related data records can be inquired in a database only according to the one or two field names and the field values respectively corresponding to the field names. Taking the order payment problem as an example, the field name in the tracking log may be the order number, and the field value corresponds to xxxx (order number detail); taking account login problem as an example, the field name in the tracking log may be login account, and the field value corresponds to xxxx (login account details).
As shown in fig. 1, the data query method provided in this embodiment includes the following steps:
s110, data query information and at least one piece of data source information are obtained, wherein the data query information comprises field names and field values corresponding to the field names.
The data query information specifically refers to a field name obtained by the research and development staff in the log, and a field value corresponding to the field name, that is, the field name to be queried and a corresponding field value, for example, the field name — order number, the field value corresponding to the order number — xxxx, and further, for example, the field name — login account, and the field value corresponding to the login account — xxxx.
The data source information refers to information for connecting and accessing the relevant database, namely, the information can be connected and accessed to the database matched with the data source information according to the data source information. The information of the data source may specifically include a name of the data source, a uniform resource locator url, a port number of the database, a name of the database, a login user name, a login password, a location area, and the like.
In order to shorten the query time, the acquired data source information specifically refers to the data source information of each data source selected by the user and associated with the field name, but not the data source information of all the data sources.
As an optional implementation manner of this embodiment, before acquiring the data query information and the data source information, the method further includes:
acquiring at least one piece of data source information which is input by a user and is associated with a field name;
and testing the at least one piece of data source information according to the test request of the user.
Firstly, research and development personnel determine which databases have data records matched with the field names according to the field names acquired from the logs, and then respectively use data sources corresponding to the databases as data sources to be inquired. If the data source list has the data source to be inquired, the research and development personnel can directly select the data source list; if the data source list does not have the data source to be queried, research and development personnel need to input the data source information of the data source to be queried, that is, input basic information (a data source name, a uniform resource locator url, a port number, a database name, a login user name, a login password, a region where the data source is located and the like) corresponding to each data source to be queried. Wherein, a plurality of databases may be included under the same data source.
In order to ensure the accuracy of the data source information input by research personnel, the data source information can be tested. After a research and development staff initiates a test request for one piece of data source information, the system accesses the database corresponding to the connection according to the data source information, if the access connection is successful, the test success is prompted, if the access connection is failed, the test failure is prompted, and a failure reason is returned, such as a login password error.
And when the data source information is tested successfully, adding the data source information to a data source list so that research personnel can select the data source information as a data source to be queried. It is worth noting that each data source in the list of data sources can be deleted, modified, queried, and retested at any time.
After the research and development personnel select the data source to be queried in the data source list, data query information is input, namely the field name to be queried and the field value corresponding to the field name to be queried are input. When the field names are input by research personnel, a field name fuzzy reminding function can be provided for the research personnel so as to ensure the correctness of the field names input by the research personnel, and data query failure can be caused as long as a character error exists in the field names input by the research personnel. Moreover, different research and development personnel may have different field name english naming habits, so that the different research and development personnel also have different english naming for the same field, and the field name fuzzy prompting function can prompt the research and development personnel to name the correct field in the data source to be queried.
Typically, before obtaining the field names in the data query information, the method further includes:
acquiring at least one character input by a user aiming at a field name;
and generating a field name fuzzy reminder according to the field names in all the data tables in the at least one database matched with the data source information and at least one character input by the user aiming at the field names, so that the user can refer to or select the fuzzy reminder.
And when research personnel inputs a character aiming at the field name, all the field names in all the data tables in the data source to be inquired are subjected to fuzzy matching based on all the characters in the current field name, and the fuzzy matching result is used as the field name fuzzy prompt to be prompted to the research personnel for reference or selection. When the research and development personnel find that the field names which the field names want to input exist in the field name fuzzy reminding, the field names can be directly selected and do not need to be input by themselves. For example, the character input by the developer for the field name is "time", and the field name fuzzy reminder may include field names such as "testtime", "logintime", and the like.
As another optional implementation manner of this embodiment, the obtaining of the data query information and the at least one piece of data source information may specifically be:
acquiring data query information, wherein the data query information comprises a field name and a field value corresponding to the field name;
traversing all data table structures stored in the server according to the field names in the data query information, and determining at least one database matched with the field names;
and generating at least one piece of data source information according to the association information of the at least one database.
First, the research and development personnel input a field name and a corresponding field value acquired from a log. Secondly, the system accesses the server, traverses all data table structures stored in the server according to the field names input by the research and development personnel, determines which data table structures include the field names, and further determines databases matched with the field names according to the data table structures including the field names, namely, the determined databases include the field names input by the research and development personnel. Thirdly, the system acquires the associated information corresponding to the databases, such as database names, data source names corresponding to the databases, uniform resource locators url, port numbers, login user names, login passwords, areas where the databases are located, and the like, and further generates a piece of data source information according to the associated information of each database, so that the databases can be successfully accessed according to the data source information when data positioning is carried out according to the field names and the corresponding field values. And S120, performing data query on the data query information in at least one database which is stored in the server and matched with the data source information, and acquiring at least one data record matched with the data query information.
And accessing each database matched with each data source according to the information of each data source, traversing all data tables in the data source aiming at the field names and the corresponding field values in the data query information to perform data query on the data query information, and if a certain data record in a certain data table contains the field names and the corresponding field values in the data query information, taking the data record as the data record matched with the data query information.
After all data tables in all the data sources to be queried selected by research and development personnel are traversed, the data records matched with the data query information are obtained, and then the data positioning of the field names and the corresponding field values can be realized.
And S130, generating a feedback result of the data query information according to the data record.
And generating positioning information corresponding to the data query information according to the acquired data records matched with the data query information, and returning the positioning information to research personnel as a feedback result, so that the research personnel can acquire other data related to the data query information according to the positioning information.
Optionally, the information of the data table where each data record is located may be used as the positioning information corresponding to the data query information, specifically, the information of the data table where each data record is located may be stored through one query result mapping data structure, and the query result mapping data structure is used as a feedback result, so that the research and development staff can obtain the positioning information corresponding to the data query information according to the query result mapping structure, and further obtain other data related to the data query information according to the positioning information.
Typically, the form of the query result mapping data structure may be < data table name + database name, data source information >, where the data table name is a table name of a data table where the data record is located, the database name is a database name of a database where the data table is located, and the data source information is basic information of a data source corresponding to the database, and includes, for example, a data source name, a located area, a url, and the like.
As an optional implementation manner of this embodiment, a feedback result of the data query information may be generated according to at least one data record, specifically:
respectively taking the associated information of the data table where each data record is located as data record strips corresponding to the data query information, wherein each data record strip forms a feedback result;
generating field name character strings and field value character strings which are in one-to-one correspondence according to each data record, wherein special character intervals are adopted among different field names in the field name character strings, and special character intervals are adopted among different corresponding field values in the field value character strings;
and adding hyperlink record numbers in each data record strip so that a user can view a data table in one-to-one correspondence with the field names and the field values matched with each data record according to the hyperlink record numbers, wherein the data table is generated by cutting the field name character strings and the field value character strings respectively according to special characters.
The association information of the data table in which each data record is located may specifically be a table name of the data table in which each data record is located, a library name of the database in which the data table is located, and basic information of the data source corresponding to the database, including, for example, a data source name, a located area, a url, and the like.
The associated information is integrated into a data record strip corresponding to the data query information, and then each data record strip is combined to form a feedback result (for example, a data record table) to be provided for research personnel.
Furthermore, hyperlink record numbers are added in each data record strip, and the number of the hyperlink record numbers is the number of the data records matched with the data query information. When the research and development personnel clicks the hyperlink record number, the detailed data of the data record corresponding to the hyperlink number can be provided for the research and development personnel.
The detailed data corresponding to each data record is a plurality of groups of field names and corresponding field values which are acquired from a data table where the data record is located and are in one-to-one correspondence, specifically, the plurality of groups of field names and corresponding field values are constructed into field name character strings and field value character strings which are in one-to-one correspondence, special character intervals are adopted among different field names in the field name character strings, special character intervals are also adopted among different field values in the field value character strings, and by taking the two groups of field names and corresponding field values as examples, "name-zhang", "age-20", and the special symbol is "#", then the field name character strings are "name # age" and the field value character strings are "zhang san # 20". When research personnel click hyperlink record numbers to display the field name character strings and the field value character strings which are in one-to-one correspondence, the field name character strings and the field value character strings are respectively cut according to a special symbol "#", data tables in which the field names and the field values are in one-to-one correspondence are generated, and then the data tables in which the field names and the field values are in one-to-one correspondence are displayed to the research personnel, so that data positioning is achieved according to the field names and the corresponding field values, and relevant detailed data obtained after positioning are displayed.
In the above technical solution, first, a field name string and a field value string corresponding to each other are constructed, and the field name string and the field value string are cut according to special characters during display to generate a data table in which field names and field values correspond to each other one to one.
In the embodiment of the invention, the database to be accessed is limited to the database matched with the data source information according to the acquired data source information instead of all the databases stored on the server, so that the range of the database for carrying out data query on the data query information is reduced, and the query time is shortened; the technical means of remotely accessing at least one database which is stored in the server and matched with the data source information according to the data source information and carrying out data query on the data query information is adopted, only query permission is opened for a user, so that the user does not need to directly operate on the server, the operation efficiency and even the performance of the server are not affected, and the problem that database accidents are possibly caused due to the fact that the user inputs wrong codes on the server is avoided. Therefore, when the data query is carried out by the data query method provided by the embodiment of the invention, the operation risk of a user on the database can be reduced, and the problem that the time consumption is too much when the data records are tracked only according to the field names and the corresponding field values can be solved.
Example two
The present embodiment is embodied based on the above embodiment, wherein the specifically considering a situation that a data source has a database partitioning table, performing data query on the data query information in at least one database which is stored in a server and matched with the data source information specifically includes:
sequentially acquiring databases matched with the data source information, and performing data query on data query information in at least one data table included in the acquired databases; if the current acquired database and one queried database are mutually data subbases, determining a query strategy corresponding to the current acquired database to perform data query according to the hit condition of the queried database on the field name; and/or if the current query data table and one queried data table are data sub-tables, determining a query strategy corresponding to the current query data table for data query according to the hit condition of the queried data table on the field name.
As shown in fig. 2A, the data query method provided in this embodiment includes the following steps:
s210, data query information and at least one piece of data source information are obtained, wherein the data query information comprises a field name and a field value corresponding to the field name.
S220, sequentially acquiring databases matched with the data source information, and performing data query on data query information in at least one data table included in the acquired databases; if the current acquired database and one queried database are mutually data subbases, determining a query strategy corresponding to the current acquired database to perform data query according to the hit condition of the queried database on the field name; and/or if the current query data table and one queried data table are data sub-tables, determining a query strategy corresponding to the current query data table for data query according to the hit condition of the queried data table on the field name.
With the development of time and business, the data volume in the database is uncontrollable, the data in the database and the data table are larger and larger, which brings higher disk, input/output, system overhead, and even bottleneck in performance, while the resources of one service are limited, so the database and the data table need to be split to provide data service in the form of data sub-database and data sub-table.
The data sub-databases and the data sub-tables are obtained by splitting original databases and tables according to a certain rule, storing original data stored in one database in blocks into a plurality of databases, storing original data stored in one data table in blocks into a plurality of data tables, wherein the plurality of databases are a plurality of data sub-databases, and the plurality of data tables are the data sub-tables.
For example, as shown in fig. 2B, one data source may correspond to a plurality of databases, such as the database a, the database B _ C, and the database B _ D shown in fig. 2B, where the database B _ C and the database B _ D are data sub-databases, that is, the database B _ C and the database B _ D are formed by splitting an original database. If the database B _ C is the queried database, the query policy corresponding to the database B _ D may be determined to perform data query according to the hit condition of the database B _ C on the field name, that is, whether the database B _ D needs to be subjected to data query is determined according to the hit condition of the database B _ C on the field name.
One database includes a plurality of data tables, such as the data table a, the data table B _ c, and the data table B _ d shown in fig. 2B, where the data table B _ c and the data table B _ d are data sub-tables, that is, the data table B _ c and the data table B _ d are formed by splitting a certain data table. If the data table b _ c is the queried data table, the query strategy corresponding to the data table b _ d can be determined to perform data query according to the hit condition of the data table b _ c on the field name, that is, whether the data query needs to be performed on the data table b _ d is determined according to the hit condition of the data table b _ c on the field name.
It should be noted that there may be a plurality of databases that are data sub-databases, and there may also be a plurality of data tables that are data sub-tables, and fig. 2B shows two databases that are data sub-databases, and two data tables that are data sub-tables.
Specifically, in the data source, at least two databases with the same database name except the suffix name are mutually data subbases; in the same database in the data source, at least two data tables with the same data table name except the suffix name are data sub-tables.
Wherein, the removal rule of the suffix name is determined according to the fragmentation rule of the database item. For example, as shown in fig. 2C, taking monthly database splitting as an example, the data sources correspond to database nimo _ server, database nimo _ user _2018 and database nimo _ user _2019, and database nimo _ user _2018 includes data table jd _ pay, data table tb _ pay _201801 and data table tb _ pay _201802, where the database names of database nimo _ user _2018 and database nimo _ user _2019 after name removal are all nimo _ user, and then the two databases are reciprocal databases (the databases split by year), and the data table names of database tb _ pay _201801 and database tb _ pay _201802 after name removal are all tb _ pay, and then the two databases (the databases split by month).
Further, according to the hit situation of the field name of the queried database, determining a query strategy corresponding to the currently acquired database for data query, specifically comprising:
judging whether at least one target data table in the queried database hits the field name in the data query information;
if so, performing data query only in a data table with the same name as the target data table in the currently acquired database; otherwise, no data query is performed on the currently acquired database.
If the data source comprises two databases, namely a database nimo _ user _2018 and a database nimo _ user _2019, which are data sub-databases, after all data tables in the database nimo _ user _2018 are queried according to the data query information, determining a data query strategy of the database nimo _ user _2019, which are data sub-databases, according to the hit condition of all data tables in the database nimo _ user _2018 on field names in the data query information, and performing data query on the data query information.
Judging whether at least one data table in the queried database nimo _ user _2018 hits the field name in the data query information, if not, the field name does not exist in the database which is mutually a data sub-database, and further, when the field name is queried to the database nimo _ user _2019 which is mutually a data sub-database in the data source and the database nimo _ user _2018, the field name does not need to be queried in the database nimo _ user _2019, therefore, unnecessary query is eliminated, the query frequency is reduced, and the query efficiency is improved. If so, determining the table names of the data tables which can hit the field names, for example, the table a, the table B and the table C can hit the field names in the data query information, and when querying the database nimo _ user _2019 which is in the data source and mutually serves as a data branch with the database nimo _ user _2018, querying the data tables (namely, the table a, the table B and the table C) with the same field names as the data table names of the hit field names in the database nimo _ user _2019 according to the field names. That is, when the database nimo _ user _2018 only has the field names in the data query information in the three tables, namely table a, table B and table C, the field names in the data query information only exist in the three tables in the database nimo _ user _2019, and further the field names do not need to be queried in other data tables in the database nimo _ user _2019, so that unnecessary queries are removed, the query times are reduced, and the query efficiency is improved.
Further, according to the hit situation of the field name of the queried data table, determining a query strategy corresponding to the current query data table for data query, specifically comprising:
judging whether the queried data table hits the field name in the data query information;
if yes, performing data query on the current query data table; otherwise, no data query is carried out on the current query data table.
If the database includes data tables tb _ pay _201801 and tb _ pay _201802, the data tables tb _ pay _201802 are data tables, and the data query information is performed according to the hit of the data table tb _ pay _201801 on the field name in the data query information after the query is completed to the data table tb _ pay _201801 for the data query information.
Judging whether the searched data table tb _ pay _201801 hits the field name in the data query information, if not, it means that the field name does not exist in the data table tb _ pay _201802 which is a data sub-table with the data table, and when the data table tb _ pay _201802 is searched, it is not necessary to search in the data table tb _ pay _201802 for the field name, thereby eliminating unnecessary queries, reducing the number of queries, and improving the query efficiency. If yes, it means that there is no field name in data table tb _ pay _201802, and when querying to data table tb _ pay _201802, it still needs to query data table tb _ pay _201802 for the field name.
And S230, acquiring at least one data record matched with the data query information.
And taking the data records in the data table, which are consistent with the field names and the corresponding field values in the data query information, as the data records matched with the data query information.
And S240, generating a feedback result of the data query information according to the data record.
For details, please refer to the foregoing embodiments, which are not described herein.
In the embodiment of the invention, the data query strategies of the associated data sub-databases matched with the target data sub-databases are determined according to the hit conditions of the field names in the data query information of the data tables in the queried target data sub-databases, and the data query strategies of the associated data sub-tables matched with the target data sub-tables are determined according to the hit conditions of the field names in the data query information of the queried target data sub-tables, so that the duplicate data query of the data sub-databases and the data sub-tables is realized, the query times are reduced to the maximum extent, unnecessary queries are removed, the data query efficiency is greatly improved, and the item summarization is particularly obvious when the data volume is large and the sub-databases are more. Based on the technical scheme of duplicate removal query, the field names and the corresponding field values in the data query information are quickly positioned in the items of numerous data sources and sub-databases, so that research personnel can quickly acquire other data related to the data query information according to the positioning information.
EXAMPLE III
Fig. 3A is a flowchart of a data query method according to a third embodiment of the present invention. Based on the foregoing embodiment, the present embodiment provides a specific implementation manner, and still uses a data source to be queried as a data source for explanation, as shown in fig. 3A, the data querying method provided in the present embodiment includes the following steps:
s310, data query information and at least one piece of data source information are obtained, wherein the data query information comprises a field name and a field value corresponding to the field name.
And S320, accessing and connecting at least one database matched with the data source information according to the data source information.
S330, constructing a source database mapping data structure according to the data source name, wherein the form of the source database mapping data structure is < the data source name, a database name list >, and the initial value of the database name list is null.
The significance of constructing the source database mapping data structure is that whether the database to be queried is a database which is mutually a data sub-database with a certain queried database is judged according to the database name list stored by the source database mapping data structure. Because the database names with the removed suffix names are stored in the database name list, if the database name list comprises the database names with the removed suffix names of the database to be queried, the database to be queried and a certain queried database are mutually in a database branch.
S340, sequentially acquiring a database corresponding to the data source as a current acquired database according to the database traversal sequence.
The currently acquired database refers to the database to be queried, such as the database nimo _ user _ 2019.
S350, judging whether the database name of the currently acquired database without the suffix exists in a database name list in the source database mapping data structure, if not, executing S360, and if so, executing S3150.
And S360, adding the database name of the current acquired database without the suffix name in the database name list.
If the database name list does not include the database name nimo _ user of the currently acquired database nimo _ user _2019 without the suffix name, the currently acquired database nimo _ user _2019 is not a data sub-database corresponding to a certain queried database, that is, the currently acquired database nimo _ user _2019 needs to be queried.
It should be noted that if the database name of the currently-acquired database has no suffix (i.e., is not a sub-database), the database name of the currently-acquired database may be directly added to the database name list.
S370, according to the database name of the current acquired database without the suffix name, constructing a target base table mapping data structure matched with the database name of the current acquired database without the suffix name, wherein the form of the base table mapping data structure is < database name, data table name list >, and the initial value of the data table name list is null.
The significance of constructing the database table mapping data structure is that whether the data table to be queried and a certain queried data table are data sub-tables is judged according to the name list of the data table stored in the database table mapping data structure. Since the data table names with the removed suffix names are stored in the data table name list, if the data table name list comprises the data table names with the removed suffix names of the data table to be inquired, the data table to be inquired and a certain inquired data table are data sub-tables.
And constructing a base table mapping data structure (nimo _ user, null) matched with the nimo _ user according to the database name nimo _ user of the currently acquired database nimo _ user _2019 after the removal of the suffix name.
And S380, sequentially acquiring a data table corresponding to the currently acquired database as a current query data table according to the traversal sequence of the data table.
The current lookup data table refers to the data table to be queried, e.g., data table tb _ pay _ 201802.
And S390, judging whether the data table name list in the mapping data structure of the target base table has the data table name of the current query data table after removing the suffix name, if not, executing S3100, and if so, executing S3130.
And S3100, adding the data table name of the current query data table without the suffix name to the data table name list.
If the data table name list does not include the data table name tb _ pay of the current query data table tb _ pay _201802 without the suffix name, the current query data table tb _ pay _201802 is not a data sub-table with a queried data table, i.e., it is necessary to perform data query on the current query data table tb _ pay _ 201802.
S3110, inquiring the current query data table according to the field name, and using the inquiry result as a duplicate removal query reference corresponding to the data table name of the current query data table after removing the suffix name.
The query result specifically indicates whether the field name is included in the current query data table, and further, whether the field name is included in the current query data table is used as a deduplication query reference corresponding to tb _ pay. If yes, the duplicate elimination query reference corresponding to tb _ pay is the data table which needs to be queried and the data table which is the data sub table with the duplicate elimination query reference corresponding to tb _ pay is the data table which does not need to be queried.
S3120, if the current query data table includes the data records matched with the field names and the corresponding field values, acquiring and saving the data records, and executing S3140.
If the current query data table comprises data records matched with the field names and the corresponding field values, one-time data positioning of the field names and the corresponding field values can be realized.
S3130, performing or not performing a lookup operation on the current lookup data table according to the deduplicated lookup reference corresponding to the data table name of the current lookup data table from which the suffix name is removed.
If the data table name list includes the data table name tb _ pay of the current query data table tb _ pay _201802 without the suffix name, determining whether to perform the query operation on the current query data table tb _ pay _201802 according to the duplicate query removing reference corresponding to tb _ pay, if yes, querying the current query data table tb _ pay _201802, and if not, not querying the current query data table tb _ pay _ 201802.
S3140, returning and executing the step of sequentially acquiring one data table corresponding to the currently acquired database as the current query data table according to the traversal sequence of the data tables until all the data tables corresponding to the currently acquired database are traversed, taking the judgment result of whether the field name is contained in at least one data table corresponding to the currently acquired database as the duplicate query reference corresponding to the database name of the currently acquired database after the suffix name is removed, and executing the step S3160.
If all the data tables in the currently acquired database nimo _ user _2019 do not contain field names, the duplicate query removing reference corresponding to the nimo _ user is that repeated query does not need to be carried out on the database which is a database branch with the nimo _ user; if at least one data table in the currently acquired database nimo _ user _2019 contains a field name, the duplicate removal query reference corresponding to nimo _ user is the database which needs to be queried as the database which is a database branch with the nimo _ user.
S3150, executing or not executing query operation on the currently acquired database according to the duplicate removal query reference corresponding to the database name of the currently acquired database after the removal of the suffix name, and if executing, executing or not executing query operation on the matched data table according to the target base table mapping data structure matched with the database name of the currently acquired database after the removal of the suffix name and the duplicate removal query reference corresponding to the data table name of each data table after the removal of the suffix name.
If the database name list comprises the database name nimo _ user of the currently-acquired database nimo _ user _2019, after the removal of the suffix name, determining whether to perform query operation on the currently-acquired database nimo _ user _2019 according to a deduplication query reference corresponding to the nimo _ user, if not, not querying the currently-acquired database nimo _ user _2019, if so, querying the currently-acquired database nimo _ user _2019, and simultaneously, determining whether to perform query operation on each data table in the currently-acquired database nimo _ user _2019 according to a library table mapping data structure matched with the nimo _ user and a deduplication query reference (for example, the deduplication query reference corresponding to the tb _ pay) corresponding to the data table name of each data table in the library mapping data structure, after the removal of the suffix name, of each data table.
S3160, returning to the operation of sequentially acquiring one database corresponding to the data source as the current acquired database according to the database traversal sequence until all databases corresponding to the data source are traversed.
For details, please refer to the foregoing embodiments, which are not described herein.
Typically, the data query method provided by the embodiment of the present invention may be packaged as a data location tool, a developer inputs a field name busOrderId and a field value 201812071549051971465043662512 that need to perform data location at the field name value input area 31 in the interface shown in fig. 3B, and then clicks location to obtain a feedback result (associated information of a data table where the field name busOrderId and the field value 201812071549051971465043662512 are located) in the location display area 32 in the interface shown in fig. 3B, if the developer wants to view detailed data, the developer clicks a record number (hyperlink record number) 321 in the location display area 32, and may pop up a bullet box shown in fig. 3C, so that the developer may view details of data matching the field name busOrderId and the field value 201812071549051971465043662512 through the bullet box shown in fig. 3C. The data source detail list in the interface shown in fig. 3B is pre-selected and successfully tested, or is automatically generated after traversing all table structures in the server according to the field name busOrderId.
In the embodiment of the invention, the duplicate removal query of the databases which are in data sub-databases is realized through the source database mapping data structure, and the duplicate removal query of the data tables which are in data sub-tables is realized through the base table mapping data structure, so that the data query times are reduced to the maximum extent, unnecessary queries are removed, the query efficiency is greatly improved, the problem that the time consumption for tracking data records according to field names and corresponding field values is too much is solved, and then research and development personnel can quickly locate data in a testing link and a troubleshooting link, and the development efficiency is improved.
Example four
Fig. 4 is a schematic block diagram of a data query apparatus according to a fourth embodiment of the present invention, where this embodiment is applicable to a case where a database query is performed only on a field name and a corresponding field value to obtain a data record matching the field name and the corresponding field value, and the apparatus may be implemented in software and/or hardware, and may be generally integrated in a processor of a computer device. As shown in fig. 4, the apparatus includes: an acquisition module 410, a query module 420, and a feedback module 430, wherein,
an obtaining module 410, configured to obtain data query information and data source information, where the data query information includes: a field name, and a field value corresponding to the field name;
the query module 420 is configured to perform data query on the data query information in at least one database stored in the server and matched with the data source information, and acquire at least one data record matched with the data query information;
and a feedback module 430, configured to generate a feedback result of the data query information according to the at least one data record.
In the embodiment of the invention, the database to be accessed is limited to the database matched with the data source information according to the acquired data source information instead of all the databases stored on the server, so that the range of the database for carrying out data query on the data query information is reduced, and the query time is shortened; the technical means of remotely accessing at least one database which is stored in the server and matched with the data source information according to the data source information and carrying out data query on the data query information is adopted, only query permission is opened for a user, so that the user does not need to directly operate on the server, the operation efficiency and even the performance of the server are not affected, and the problem that database accidents are possibly caused due to the fact that the user inputs wrong codes on the server is avoided. Therefore, when the data query is carried out by the data query method provided by the embodiment of the invention, the operation risk of a user on the database can be reduced, and the problem that the time consumption is too much when the data records are tracked only according to the field names and the corresponding field values can be solved.
Further, the query module 420 comprises an obtaining unit, a first query unit and a second query unit, wherein,
the acquisition unit is used for sequentially acquiring databases matched with the data source information and performing data query on the data query information in at least one data table included in the acquired databases;
the first query unit is specifically used for determining a query strategy corresponding to the currently acquired database to perform data query according to the hit condition of the queried database on the field name if the currently acquired database and a queried database are mutually data subordinates;
and the second query unit is specifically used for determining a query strategy corresponding to the current query data table for data query according to the hit condition of the queried data table on the field name if the current query data table and a queried data table are data sub-tables.
Specifically, in the data source, at least two databases with the same database name except the suffix name are mutually data subbases; in the same database in the data source, at least two data tables with the same data table name except the suffix name are data sub-tables.
Further, the first query unit is specifically configured to determine whether at least one target data table in the queried database hits a field name in the data query information; if yes, data query is carried out only in a data table with the same name as the target data table in the current acquisition database; otherwise, no data query is carried out on the currently acquired database.
Further, the second querying unit is specifically configured to determine whether the queried data table hits a field name in the data query information; if yes, performing data query on the current query data table; otherwise, no data query is carried out on the current query data table.
In an alternative embodiment, the apparatus further comprises: the data source acquisition testing module is used for acquiring at least one piece of data source information which is input by a user and is associated with the field name; and testing the at least one piece of data source information according to the test request of the user.
Further, the apparatus further comprises: the field name fuzzy reminding module is used for acquiring at least one character input by a user aiming at the field name; and generating a field name fuzzy reminder for the user to refer to or select according to the field names in all the data tables in the at least one database matched with the data source information and at least one character input by the user aiming at the field names.
In another optional implementation manner, the obtaining module 410 specifically includes: a data query information acquisition unit, a database determination unit and a data source information generation unit, wherein,
a data query information acquisition unit for acquiring the data query information;
the database determining unit is used for traversing all data table structures stored in the server according to the field names in the data query information and determining at least one database matched with the field names;
and the data source information generating unit is used for generating at least one piece of data source information according to the associated information of the at least one database.
Further, the feedback module 430 is specifically configured to use the association information of the data table where each data record is located as a data record strip corresponding to the data query information, where each data record strip constitutes the feedback result;
generating field name character strings and field value character strings which are in one-to-one correspondence according to each data record, wherein special character intervals are adopted among different field names in the field name character strings, and the special character intervals are adopted among different corresponding field values in the field value character strings;
and adding a hyperlink record number in each data record strip so that a user can view a data table in one-to-one correspondence with the field name and the field value matched with each data record according to the hyperlink record number, wherein the data table is generated by cutting the field name character string and the field value character string respectively according to the special characters.
The data query device provided by the embodiment of the invention can execute the data query method provided by any embodiment of the invention, and has corresponding functional modules and beneficial effects of the execution method.
EXAMPLE five
Fig. 5 is a schematic structural diagram of a computer apparatus according to a fifth embodiment of the present invention, as shown in fig. 5, the computer apparatus includes a processor 50, a memory 51, an input device 52, and an output device 53; the number of processors 50 in the computer device may be one or more, and one processor 50 is taken as an example in fig. 5; the processor 50, the memory 51, the input device 52 and the output device 53 in the computer apparatus may be connected by a bus or other means, and the connection by the bus is exemplified in fig. 5.
The memory 51 is used as a computer-readable storage medium for storing software programs, computer-executable programs, and modules, such as program instructions/modules corresponding to the data query method in the embodiment of the present invention (for example, the obtaining module 410, the query module 420, and the feedback module 430 in the data query device). The processor 50 executes various functional applications of the computer device and data processing by executing software programs, instructions and modules stored in the memory 51, that is, implements the data query method described above.
The memory 51 may mainly include a storage program area and a storage data area, wherein the storage program area may store an operating system, an application program required for at least one function; the storage data area may store data created according to use of the computer device, and the like. Further, the memory 51 may include high speed random access memory, and may also include non-volatile memory, such as at least one magnetic disk storage device, flash memory device, or other non-volatile solid state storage device. In some examples, the memory 51 may further include memory located remotely from the processor 50, which may be connected to a computer device over a network. Examples of such networks include, but are not limited to, the internet, intranets, local area networks, mobile communication networks, and combinations thereof.
The input device 52 is operable to receive input numeric or character information and to generate key signal inputs relating to user settings and function controls of the computer apparatus. The output device 53 may include a display device such as a display screen.
EXAMPLE six
An embodiment of the present invention further provides a computer-readable storage medium storing a computer program, which when executed by a computer processor is configured to perform a data query method, the method including:
acquiring data query information and at least one piece of data source information, wherein the data query information comprises: a field name, and a field value corresponding to the field name;
performing data query on the data query information in at least one database which is stored in a server and matched with the data source information, and acquiring at least one data record matched with the data query information;
and generating a feedback result of the data query information according to the data record.
Of course, the computer program of the computer-readable storage medium storing the computer program provided in the embodiments of the present invention is not limited to the above method operations, and may also perform related operations in the data query method provided in any embodiments of the present invention.
From the above description of the embodiments, it is obvious for those skilled in the art that the present invention can be implemented by software and necessary general hardware, and certainly, can also be implemented by hardware, but the former is a better embodiment in many cases. Based on such understanding, the technical solutions of the present invention may be embodied in the form of a software product, which can be stored in a computer-readable storage medium, such as a floppy disk, a Read-Only Memory (ROM), a Random Access Memory (RAM), a FLASH Memory (FLASH), a hard disk or an optical disk of a computer, and includes several instructions for enabling a computer device (which may be a personal computer, a server, or a network device) to execute the methods of the embodiments of the present invention.
It should be noted that, in the embodiment of the data query apparatus, the included units and modules are only divided according to functional logic, but are not limited to the above division as long as the corresponding functions can be implemented; in addition, specific names of the functional units are only for convenience of distinguishing from each other, and are not used for limiting the protection scope of the present invention.
It is to be noted that the foregoing is only illustrative of the preferred embodiments of the present invention and the technical principles employed. It will be understood by those skilled in the art that the present invention is not limited to the particular embodiments illustrated herein, but is capable of various obvious changes, rearrangements and substitutions as will now become apparent to those skilled in the art without departing from the scope of the invention. Therefore, although the present invention has been described in greater detail by the above embodiments, the present invention is not limited to the above embodiments, and may include other equivalent embodiments without departing from the spirit of the present invention, and the scope of the present invention is determined by the scope of the appended claims.
Claims (11)
1. A method for querying data, comprising:
acquiring data query information and at least one piece of data source information, wherein the data query information comprises: a field name, and a field value corresponding to the field name;
sequentially acquiring databases matched with the data source information, and performing data query on the data query information in at least one data table included in the acquired databases to acquire at least one data record matched with the data query information;
if the current acquired database and one queried database are mutually data subbases, determining a query strategy corresponding to the current acquired database to perform data query according to the hit condition of the queried database on the field name; and/or
If the current query data table and one queried data table are data sub-tables, determining a query strategy corresponding to the current query data table for data query according to the hit condition of the queried data table on the field name;
and generating a feedback result of the data query information according to the data record.
2. The method of claim 1,
in the data source, at least two databases with the same database name except the suffix name are mutually data subbases; and/or
In the same database in the data source, at least two data tables with the same data table name except the suffix name are data sub-tables.
3. The method according to claim 1 or 2, wherein determining, according to the hit of the queried database on the field name, a query policy corresponding to the currently-obtained database for data query includes:
judging whether at least one target data table in the inquired database hits the field name in the data inquiry information;
if yes, data query is carried out only in a data table with the same name as the target data table in the current acquisition database; otherwise, no data query is carried out on the currently acquired database.
4. The method according to claim 1 or 2, wherein determining, according to a hit of the field name in the queried data table, a query policy corresponding to the current query data table for data query includes:
judging whether the queried data table hits the field name in the data query information;
if yes, performing data query on the current query data table; otherwise, no data query is carried out on the current query data table.
5. The method of claim 1, further comprising, prior to said obtaining data query information and data source information:
acquiring at least one piece of data source information which is input by a user and is associated with the field name;
and testing the at least one piece of data source information according to the test request of the user.
6. The method of claim 1, wherein the obtaining data query information and at least one piece of data source information comprises:
acquiring the data query information;
traversing all data table structures stored in a server according to the field names in the data query information, and determining at least one database matched with the field names;
and generating at least one piece of data source information according to the associated information of the at least one database.
7. The method of claim 1, wherein generating feedback results of the data query information based on the at least one data record comprises:
respectively taking the associated information of the data table where each data record is located as a data record strip corresponding to the data query information, wherein each data record strip forms the feedback result;
generating field name character strings and field value character strings which are in one-to-one correspondence according to each data record, wherein special character intervals are adopted among different field names in the field name character strings, and the special character intervals are adopted among different corresponding field values in the field value character strings;
and adding a hyperlink record number in each data record strip so that a user can view a data table in one-to-one correspondence with the field name and the field value matched with each data record according to the hyperlink record number, wherein the data table is generated by cutting the field name character string and the field value character string respectively according to the special characters.
8. The method of claim 5, further comprising, before obtaining the field names in the data query information:
acquiring at least one character input by a user aiming at a field name;
and generating a field name fuzzy reminder for the user to refer to or select according to the field names in all the data tables in the at least one database matched with the data source information and at least one character input by the user aiming at the field names.
9. A data query apparatus, comprising:
an obtaining module, configured to obtain data query information and at least one piece of data source information, where the data query information includes: a field name, and a field value corresponding to the field name;
the query module is used for performing data query on the data query information in at least one database which is stored in the server and matched with the data source information to acquire at least one data record matched with the data query information;
the feedback module is used for generating a feedback result of the data query information according to the data record;
the query module comprises: at least one of the first query unit and the second query unit, and an obtaining unit; wherein the content of the first and second substances,
the acquisition unit is used for sequentially acquiring databases matched with the data source information and performing data query on the data query information in at least one data table included in the acquired databases;
the first query unit is used for determining a query strategy corresponding to the currently acquired database to perform data query according to the hit condition of the queried database on the field name if the currently acquired database and a queried database are mutually data subordinates;
and the second query unit is used for determining a query strategy corresponding to the current query data table for data query according to the hit condition of the queried data table on the field name if the current query data table and a queried data table are data sub-tables.
10. A computer device, characterized in that the computer device comprises:
one or more processors;
a memory for storing one or more programs,
when executed by the one or more processors, cause the one or more processors to implement the data query method of any one of claims 1-8.
11. A computer-readable storage medium, on which a computer program is stored, which, when being executed by a processor, carries out the data query method according to any one of claims 1 to 8.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910031419.6A CN109783543B (en) | 2019-01-14 | 2019-01-14 | Data query method, device, equipment and storage medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910031419.6A CN109783543B (en) | 2019-01-14 | 2019-01-14 | Data query method, device, equipment and storage medium |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN109783543A CN109783543A (en) | 2019-05-21 |
| CN109783543B true CN109783543B (en) | 2021-07-02 |
Family
ID=66500443
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201910031419.6A Active CN109783543B (en) | 2019-01-14 | 2019-01-14 | Data query method, device, equipment and storage medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN109783543B (en) |
Families Citing this family (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110287346B (en) * | 2019-06-28 | 2021-11-30 | 深圳云天励飞技术有限公司 | Data storage method, device, server and storage medium |
| CN110457541B (en) * | 2019-06-28 | 2023-01-20 | 卓尔智联(武汉)研究院有限公司 | Data processing method, service platform, terminal device and storage medium |
| CN111223541A (en) * | 2020-01-10 | 2020-06-02 | 王利 | Newborn information matching method and device and terminal equipment |
| CN112069174A (en) * | 2020-08-25 | 2020-12-11 | 北京锐安科技有限公司 | Data extraction method, device, equipment and storage medium |
| CN112231541A (en) * | 2020-09-22 | 2021-01-15 | 苏州艾特律宝智能科技有限公司 | Data retrieval method, system, computer device and storage medium |
| CN112540995B (en) * | 2020-11-11 | 2022-12-02 | 上海赛美特软件科技有限公司 | Data updating method, electronic device and storage medium |
| CN114067851B (en) * | 2021-09-30 | 2023-07-21 | 高德软件有限公司 | Signal source processing method and device and nonvolatile storage medium |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN106372177A (en) * | 2016-08-30 | 2017-02-01 | 东华大学 | Query expansion method supporting correlated query and fuzzy grouping of mixed data type |
| CN106528579A (en) * | 2015-09-15 | 2017-03-22 | 阿里巴巴集团控股有限公司 | Search method, device and system based on sharding structure databases |
| CN107391739A (en) * | 2017-08-07 | 2017-11-24 | 北京奇艺世纪科技有限公司 | A kind of query statement generation method, device and electronic equipment |
| CN107798035A (en) * | 2017-04-10 | 2018-03-13 | 平安科技（深圳）有限公司 | A kind of data processing method and terminal |
| US10176259B1 (en) * | 2009-05-15 | 2019-01-08 | Donald Newton Cohen | Use of virtual database technology for internet search and data integration |
Family Cites Families (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN107368493A (en) * | 2016-05-12 | 2017-11-21 | 百度在线网络技术（北京）有限公司 | Data base query method and device |
| CN107818115B (en) * | 2016-09-14 | 2022-04-26 | 南京星云数字技术有限公司 | Method and device for processing data table |
| US10102229B2 (en) * | 2016-11-09 | 2018-10-16 | Palantir Technologies Inc. | Validating data integrations using a secondary data store |
-
2019
- 2019-01-14 CN CN201910031419.6A patent/CN109783543B/en active Active
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US10176259B1 (en) * | 2009-05-15 | 2019-01-08 | Donald Newton Cohen | Use of virtual database technology for internet search and data integration |
| CN106528579A (en) * | 2015-09-15 | 2017-03-22 | 阿里巴巴集团控股有限公司 | Search method, device and system based on sharding structure databases |
| CN106372177A (en) * | 2016-08-30 | 2017-02-01 | 东华大学 | Query expansion method supporting correlated query and fuzzy grouping of mixed data type |
| CN107798035A (en) * | 2017-04-10 | 2018-03-13 | 平安科技（深圳）有限公司 | A kind of data processing method and terminal |
| CN107391739A (en) * | 2017-08-07 | 2017-11-24 | 北京奇艺世纪科技有限公司 | A kind of query statement generation method, device and electronic equipment |
Also Published As
| Publication number | Publication date |
|---|---|
| CN109783543A (en) | 2019-05-21 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN109783543B (en) | Data query method, device, equipment and storage medium | |
| JP5575902B2 (en) | Information retrieval based on query semantic patterns | |
| US7631019B2 (en) | Distributing data across different backing data stores | |
| US8862566B2 (en) | Systems and methods for intelligent parallel searching | |
| CN112989412B (en) | Data desensitization method and device based on SQL statement analysis | |
| US8924373B2 (en) | Query plans with parameter markers in place of object identifiers | |
| US11093461B2 (en) | Method for computing distinct values in analytical databases | |
| US8849848B2 (en) | Associating security trimmers with documents in an enterprise search system | |
| CN110727663A (en) | Data cleaning method, device, equipment and medium | |
| US9563691B2 (en) | Providing search suggestions from user selected data sources for an input string | |
| US20150213272A1 (en) | Conjoint vulnerability identifiers | |
| CN111339171A (en) | Data query method, device and equipment | |
| US8966358B2 (en) | Document generation based on referral | |
| EP3480706A1 (en) | Automatic search dictionary and user interfaces | |
| CN113377876B (en) | Data database processing method, device and platform based on Domino platform | |
| CN105574010B (en) | Data query method and device | |
| CN110515979B (en) | Data query method, device, equipment and storage medium | |
| US20140114954A1 (en) | Incorporating related searches by other users in a social network in a search request | |
| US8498987B1 (en) | Snippet search | |
| US11023449B2 (en) | Method and system to search logs that contain a massive number of entries | |
| US11960470B2 (en) | Merging and unmerging entity representations via resolver trees | |
| CN117009430A (en) | Data management method, device, storage medium and electronic equipment | |
| US20210149866A1 (en) | Universal data index for rapid data exploration | |
| CN116305288B (en) | Method, device, equipment and storage medium for isolating database resources | |
| US20230315715A1 (en) | Utilizing a structured audit log for improving accuracy and efficiency of database auditing |
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 |