CN112162982A - Data query method, device, equipment and medium - Google Patents

Data query method, device, equipment and medium Download PDF

Info

Publication number
CN112162982A
CN112162982A CN202010974487.9A CN202010974487A CN112162982A CN 112162982 A CN112162982 A CN 112162982A CN 202010974487 A CN202010974487 A CN 202010974487A CN 112162982 A CN112162982 A CN 112162982A
Authority
CN
China
Prior art keywords
search key
data
target
query
construction scheme
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Pending
Application number
CN202010974487.9A
Other languages
Chinese (zh)
Inventor
孙健
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
China Construction Bank Corp
Original Assignee
China Construction Bank Corp
Priority date (The priority date 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 date listed.)
Filing date
Publication date
Application filed by China Construction Bank Corp filed Critical China Construction Bank Corp
Priority to CN202010974487.9A priority Critical patent/CN112162982A/en
Publication of CN112162982A publication Critical patent/CN112162982A/en
Pending legal-status Critical Current

Links

Images

Classifications

    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/22—Indexing; Data structures therefor; Storage structures
    • G06F16/2228—Indexing structures
    • G06F16/2272—Management thereof
    • 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/22—Indexing; Data structures therefor; Storage structures
    • G06F16/2228—Indexing structures
    • G06F16/2255—Hash tables
    • 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)
  • Data Mining & Analysis (AREA)
  • Databases & Information Systems (AREA)
  • Physics & Mathematics (AREA)
  • General Engineering & Computer Science (AREA)
  • General Physics & Mathematics (AREA)
  • Software Systems (AREA)
  • Computational Linguistics (AREA)
  • 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 data query medium. The method comprises the following steps: acquiring query conditions of target parameter data; querying a data structure table of the target parameter data, and determining target structure data matched with the query condition in the data structure table, wherein the target structure data comprises at least one target search key construction scheme predefined according to an index of the target parameter data; and respectively constructing target search keys by adopting the at least one target search key construction scheme, and performing data query according to the target search keys until a data query result corresponding to the data query condition is obtained, or until all predefined search key construction schemes are adopted. The technical scheme meets the high concurrency requirement during data query, backtracking query is supported, and the data query efficiency is improved.

Description

Data query method, device, equipment and medium
Technical Field
The embodiment of the invention relates to the technical field of databases, in particular to a data query method, a data query device, data query equipment and a data query medium.
Background
In order to simplify the data query operation process, appropriate index items are set, and the query process of the data meets high concurrency requirements and supports backtracking query is always an important issue of data query.
At present, as financial parameter data is commonly used in a plurality of scenes, and each scene corresponds to a plurality of different characteristics, it generally means that more index items need to be created to meet the data query requirement; when data query needs to meet the requirement of high concurrent retrieval, the data query is usually realized by setting enough index items, so that the data query efficiency is undoubtedly reduced, and the data query efficiency and the writing efficiency are influenced by excessive index items which conflict with the high concurrent requirement. In the query process of financial parameters, backtracking needs to be supported, if data cannot be accurately obtained, a data set is obtained by simply reducing index items, although the data query range can be expanded, specific information meanings contained in the index items are not considered, and data query logic cannot be converted, so that data with the highest correlation with query conditions cannot be obtained. Therefore, how to meet the high concurrency requirement in data query and support backtracking query to improve data query efficiency is an urgent problem to be solved.
Disclosure of Invention
Embodiments of the present invention provide a data query method, apparatus, device, and medium, so as to meet high concurrency requirements during data query, support backtracking query, and improve data query efficiency.
In a first aspect, an embodiment of the present invention provides a data query method, including:
acquiring query conditions of target parameter data;
querying a data structure table of the target parameter data, and determining target structure data matched with the query condition in the data structure table, wherein the target structure data comprises at least one target search key construction scheme predefined according to an index of the target parameter data;
and respectively constructing target search keys by adopting the at least one target search key construction scheme, and performing data query according to the target search keys until a data query result corresponding to the data query condition is obtained, or until all predefined search key construction schemes are adopted.
In a second aspect, an embodiment of the present invention further provides a data query apparatus, including:
the query condition acquisition module is set to acquire the query conditions of the target parameter data;
a search key construction scheme query module configured to query a data structure table of the target parameter data, and determine target structure data in the data structure table that matches the query condition, where the target structure data includes at least one target search key construction scheme predefined according to an index of the target parameter data;
and the search key construction and data query module is set to respectively construct target search keys by adopting the at least one target search key construction scheme and carry out data query according to the target search keys until a data query result corresponding to the data query condition is obtained or until all predefined search key construction schemes are adopted.
In a third aspect, an embodiment of the present invention further provides a computer device, including a memory, a processor, and a computer program stored in the memory and executable on the processor, where the processor executes the computer program to implement the data query method according to any embodiment of the present invention.
In a fourth aspect, the embodiment of the present invention further provides a computer-readable storage medium, on which a computer program is stored, where the computer program, when executed by a processor, implements the data query method according to any embodiment of the present invention.
In the technical scheme provided by the embodiment of the invention, when the query condition of the target parameter data is obtained, the data structure table of the target parameter data is queried, the target structure data matched with the query condition in the data structure table is determined, then at least one target search key construction scheme predefined according to the index of the target parameter data is adopted to respectively construct target search keys, and data query is sequentially carried out according to the target search keys until a data query result corresponding to the target parameter data query condition is obtained, or until all predefined search key construction schemes are adopted. By the technical scheme, the defect that data query is carried out by adding the index items to meet high concurrency retrieval requirements in the prior art is overcome, the high concurrency requirements during data query are met, backtracking query is supported, and data query efficiency is improved.
Drawings
FIG. 1 is a flow chart of a data query method according to a first embodiment of the present invention;
FIG. 2 is a diagram illustrating index integration according to a first embodiment of the present invention;
FIG. 3 is a flowchart illustrating a data query method according to a second embodiment of the present invention;
FIG. 4 is a diagram illustrating index integration according to a second embodiment of the present invention;
FIG. 5 is a schematic structural diagram of a data query device in a third embodiment of the present invention;
fig. 6 is a schematic hardware configuration diagram of a computer device in the fourth 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.
Before discussing exemplary embodiments in more detail, it should be noted that some exemplary embodiments are described as processes or methods depicted as flowcharts. Although a flowchart may describe the operations (or steps) as a sequential process, many of the operations can be performed in parallel, concurrently or simultaneously. In addition, the order of the operations may be re-arranged. The process may be terminated when its operations are completed, but may have additional steps not included in the figure. The processes may correspond to methods, functions, procedures, subroutines, and the like.
For ease of understanding, the main inventive concepts of the embodiments of the present invention are briefly described.
After receiving the query condition of the target parameter, querying a pre-designed data structure table corresponding to the target parameter, and constructing a target search key to perform data query according to the target search key.
The target search key may be composed of a head index of target parameter data, a common search key and a difference search key, the head index and the common search key are corresponding to a non-difference index of the target parameter and are respectively used for realizing range query and parameter query, and the difference search key is corresponding to a difference index of the target parameter and is also used for parameter query.
Before that, the indexes of the target parameter data are classified, and can be divided into two main categories, namely non-differential indexes and differential indexes, and the non-differential indexes can be further divided into two categories according to the data query requirement: first-class non-differential indexes, which may be used in the function of data-scope queries and are prevalent in most parametric data indexes, and second-class non-differential indexes, which are less used in the function of data-scope queries but are also prevalent in most parametric data indexes. The query fineness of the first type of non-differential index is smaller than that of the second type of non-differential index, and the first type of non-differential index and the second type of non-differential index may have an intersection, that is, the same index may exist. Differential indexing is often applied to range queries of single parameter data, it may not be widely present in parameter data but only in part of parameter data, and there may be different types of differential indexing for different parameter data. The head index of the target parameter data can be directly determined according to the first type of non-differential index of the target parameter data;
the public search key and the difference search key are constructed according to a construction scheme in a public search key construction scheme set in a data structure table which is designed in advance and corresponds to the target parameter and a difference search key construction scheme. The public search key construction scheme is a scheme for constructing a public search key according to a second-class non-differential index of target parameter data.
The difference search key construction scheme is a scheme for constructing difference search keys according to difference indexes of target parameter data. When the data query result matched with the data query condition cannot be obtained according to the currently constructed target search key, the common search key can be sequentially reconstructed according to other construction schemes in the common search key construction scheme set, so that the target search key is reconstructed, and data query is carried out again according to the reconstructed target search key, so that the data query supporting backtracking is realized.
Example one
Fig. 1 is a flowchart of a data query method according to an embodiment of the present invention, which is applicable to how to implement a data backtracking query on a target parameter, for example, a financial parameter, and the method may be executed by a data query apparatus according to an embodiment of the present invention, where the apparatus may be implemented in software and/or hardware, and may be generally integrated in a computer device.
As shown in fig. 1, the data query method provided in this embodiment specifically includes:
and S110, acquiring query conditions of the target parameter data.
The target parameter data may be parameter data that can be commonly used in a plurality of application scenarios, each of which corresponds to a plurality of different characteristics, and may be, for example, financial parameter data. When data query is performed on such parameter data, data query is generally performed by creating more indexes.
S120, inquiring a data structure table of the target parameter data, and determining target structure data matched with the inquiry conditions in the data structure table, wherein the target structure data comprises at least one target search key construction scheme predefined according to the index of the target parameter data.
The index is a storage structure which is independent and physical and sorts values of one or more columns in the database table, can provide pointers to data values stored in a specified column of the database table, and then sorts the pointers according to a specified sorting order, which is equivalent to a directory part of a book, and can quickly query required contents according to page numbers in the directory. In the embodiment of the invention, the meaning of the index is expanded to be a marking tool for acquiring the parameter data information, and a user can acquire the specific parameter data information through marking.
And the data structure table is used for determining target structure data matched with the query condition of the target parameter data, and comprises at least one piece of target structure data.
In this embodiment, the target structure data may include a first type of non-differential index of the target parameter data, a common search key construction scheme set predefined according to a second type of non-differential index of the target parameter data, and a differential search key construction scheme predefined according to a differential index of the target parameter data;
the non-differential index comprises a first type of non-differential index and a second type of non-differential index, the first type of non-differential index is used for data range query, the query fineness of the first type of non-differential index is smaller than that of the second type of non-differential index, and an intersection can exist between the first type of non-differential index and the second type of non-differential index data;
the target search key construction scheme is determined according to at least one index in the first type of non-differential indexes, the common search key construction scheme in the common search key construction scheme set, and the differential search key construction scheme.
The indexes of the target parameter data can be divided into two categories, namely non-differential indexes and differential indexes, and the non-differential indexes can be divided into two categories according to the data query requirement: first-class non-differential indexes, which may be used in the function of data-scope queries and are prevalent in most parametric data indexes, and second-class non-differential indexes, which are less used in the function of data-scope queries but are also prevalent in most parametric data indexes. The query fineness of the first type of non-differential index is smaller than that of the second type of non-differential index, and the first type of non-differential index and the second type of non-differential index may have an intersection, that is, the same index may exist. Differential indexing is often applied to range queries of single parameter data, it may not be widely present in parameter data but only in part of parameter data, and there may be different types of differential indexing for different parameter data.
For example, when the target parameter data is financial parameter data, the first type of non-differential index may include: parameter name, multi-legal organization number, first-level branch name, effective time and the like; the second type of non-differential index may include: first-level branch names, second-level branch names, net point numbers, currency types and the like; the differential index may include: product code, service center code, service personnel number, etc.
Fig. 2 is a schematic diagram of index integration according to an embodiment of the present invention. As shown in fig. 2, at least one index in the first non-differential indexes may be used as a head index of the target parameter data, a common search key construction scheme set is predefined based on the second non-differential indexes, a common search key is constructed according to a common search key construction scheme in the common search key construction scheme set, a differential search key construction scheme is predefined based on the differential indexes, a differential search key is constructed according to the differential search key construction scheme, and then the head index, the common search key, and the differential search key are combined to construct the target search key. The public search key construction scheme set and the difference search key construction scheme can be determined according to the data structure table, and a public search key construction scheme can be determined in the public search key construction scheme set according to the public search key construction scheme number in the data information table.
The common search key construction scheme set refers to a scheme set for constructing common search keys defined in advance according to second-class non-differential indexes of target parameter data, and comprises at least two common search key construction schemes, wherein each common search key construction scheme refers to which second-class non-differential indexes are utilized to construct common search keys. Taking financial parameter data as an example, the public search key construction scheme can be that a public search key is constructed according to a first-level branch line name, a second-level branch line name and a currency type, and can also be constructed according to the currency type and a website number.
The difference search key construction scheme refers to a scheme for constructing difference search keys defined in advance according to difference indexes of target parameter data, and can be adjusted in advance according to actual application requirements.
The target search key construction scheme is specifically determined by at least one index in the first type of non-differential indexes, a common search key construction scheme in the common search key construction scheme set, and a differential search key construction scheme. One common search key construction scheme corresponds to one target search key construction scheme, a plurality of common search key construction schemes correspond to a plurality of target search key construction schemes, and one target search key can be constructed according to one target search key construction scheme.
Illustratively, one piece of structure data in the data structure table corresponds to a set of target parameter data with the same index value of the plurality of first-type non-differential indexes. One piece of target structure data in the data structure table corresponds to a set of target parameter data, wherein index values of a plurality of first-type non-differential indexes of the set of target parameter data are the same.
Taking financial parameters as an example, a piece of target structure data can be constructed for a group of financial parameter data with the same index value of parameter name, multi-legal organization number and first-level branch name, and the target structure data is stored in a data structure table. Furthermore, after the query condition of the target parameter data is obtained, the data structure table of the target parameter data is queried, and the target structure data matched with the query condition of the target parameter data in the data structure table can be determined according to the index value of the first-class non-differential index of the target parameter data.
S130, respectively constructing target search keys by adopting at least one target search key construction scheme, and carrying out data query according to the target search keys until a data query result corresponding to the data query condition is obtained, or until all predefined search key construction schemes are adopted.
And the target search key is constructed by at least one target search key construction scheme matched with the query conditions of the target parameter data to form the target search key, and is used for querying the target parameter data. And after a target search key is constructed, inquiring the target parameter data according to the target search key, stopping data inquiry if a data inquiry result corresponding to the inquiry condition of the target parameter data is obtained, reconstructing a target search key if the data inquiry result corresponding to the inquiry condition of the target parameter data cannot be obtained, inquiring the target parameter data according to the reconstructed target search key, and repeating the steps until a data inquiry result corresponding to the inquiry condition is obtained, or adopting all predefined target search key construction schemes, and failing to construct a new target search key.
Illustratively, constructing the target search key by using a target search key construction scheme may include:
taking the first type of non-differential indexes as head indexes; constructing a public search key according to a public search key construction scheme in the public search key construction scheme set; constructing a difference search key according to the difference search key construction scheme; the head index, the common search key, and the difference search key are combined as a target search key.
When a target search key is constructed by adopting a target search key construction scheme in target structure data, the head index of the target parameter data, a common search key constructed by a common search key construction scheme in a common search key construction scheme set and a difference search key constructed by a difference search key construction scheme can be combined, the combined character string content is used as the target search key adopted by the current query target parameter data, and at the moment, the head index is a first-type non-difference index of the target parameter data.
Optionally, the data query according to the target search key may include: and combining the index values of the head index, the public search key and the difference search key into a data character string, and performing data query in a hash index mode.
Hash indexing is implemented based on a hash table, and only queries that exactly match all columns of the index are valid. Combining the index values of the head index, the common search key and the difference search key into a data string, and introducing a Remote Dictionary service (Redis) cache when querying target parameter data in a hash index mode.
The Redis cache is an open source log-type and Key-Value database which is written by using ANSIC language, supports network, can be based on memory and can also be persistent, and provides API (Application Program Interface) of multiple languages. Redis cache is introduced, when target parameter data are inquired in a hash index mode, the connection time of the target parameter data and a database can be shortened, and the data inquiry efficiency is improved.
Optionally, the data query is performed according to the target search key, and the method may further include: and performing data query according to the target search key, the first-class non-differential index and the differential search key.
On the basis of the target search key, the data query is carried out by combining the first type of non-difference index and the difference search key, so that the accuracy of the data query is further improved, at the moment, the data information body is still positioned by a small number of indexes, so that the query operation of the data is completed, the data query operation process is simplified, the query efficiency is improved, and the high concurrent query requirement of the data is also met.
Further, step S130 may specifically include:
determining a public search key construction scheme in the public search key construction scheme set according to the public search key construction scheme number in the data information table, wherein the public search key construction scheme is used as the current public search key construction scheme;
constructing a target search key according to the first-class non-differential index, the current public search key construction scheme and the differential search key, and performing data query according to the target search key;
if the data query result corresponding to the data query condition cannot be obtained, sequentially selecting a public search key construction scheme from the public search key construction scheme set, and updating the current public search key construction scheme;
and returning to execute the operation of constructing a target search key according to the first-class non-differential index, the current public search key construction scheme and the differential search key, and performing data query operation according to the target search key until a data query result corresponding to the data query condition is obtained, or until all public search key construction schemes are selected.
Wherein, the data information table is the main carrier of the target parameter data. The public search key construction scheme number is the number of the public search key construction scheme, and can be used for determining which scheme is specifically used as the currently adopted public search key construction scheme in the public search key construction scheme set, and the public search key construction scheme number and the public search key construction scheme set together determine the corresponding target parameter data query mode.
Specifically, the data information table may include: the method comprises the steps that a first-type non-differential index, a public search key, a differential search key and a public search key are used for constructing scheme numbers, and a data information body of target parameter data is obtained;
the data information body exists in a json format character string format.
The data information body of the target parameter data refers to the target parameter data itself and is used for describing the specific content of the target parameter data, and the data information body exists in a json format character string format. The json format character string format is a mode for data retention and transmission, and is a relatively mature prior art means when the data is stored in the json format character string format, which is not described in detail in the embodiment of the invention.
After a current public search key construction scheme is determined according to the public search key construction scheme number in the data information table, the first-class non-differential index, the current public search key construction scheme and the differential search key are constructed into a target search key, and target parameter data are inquired according to the target search key. Stopping data query when a data query result corresponding to the query condition of the target parameter data is obtained; and when the data query result corresponding to the query condition of the target parameter data cannot be obtained, backtracking to the public search key construction scheme set, selecting the next public search key construction scheme in the public search key construction scheme set as the current public search key construction scheme according to the sequence, then reconstructing the target search key according to the first non-differential index, the current public search key construction scheme and the differential search key, querying the target parameter data according to the reconstructed target search key, and stopping data query when the data query result corresponding to the query condition is obtained or all the public search key construction schemes are selected.
For example, when a query condition of certain target parameter data is acquired, a data structure table of the target parameter data is queried and target structure data matched with the query condition is determined; if the public search key construction scheme set field of the target parameter data is as follows: "Method 1, Method2, Method3, Method 4", when the number of the public search key construction scheme is 1, preferentially using the public search key construction scheme corresponding to Method1 in the public search key construction scheme set as the current public search key construction scheme, and then constructing the first-type non-differential index of the target parameter data, the current public search key construction scheme, and the differential search key as the target search key; using the target search key to perform data query; stopping data query when a data query result corresponding to the query condition of the target parameter data is obtained; and when the data query result corresponding to the query condition of the target parameter data cannot be obtained, backtracking to a public search key construction scheme set, sequentially selecting the public search key construction schemes as the current public search key construction scheme according to the sequence of Method2, Method3 and Method4, reconstructing the target search key according to the first non-differential index, the current public search key construction scheme and the differential search key, performing data query according to the reconstructed target search key, and stopping the data query when the data query result corresponding to the query condition is obtained or all the public search key construction schemes are selected.
As an optional implementation manner, the target structure data further includes a difference search key length; after constructing the target difference search key according to the difference search key construction scheme, the method further comprises the following steps: the length of the target difference search key is verified using the difference search key length.
The length of the difference search key refers to the length of the difference search key, and the length of the difference search key in the target structure data is used for checking the length of the target difference search key. When the target search key is used for data query, the target difference search key in the target search key can be subjected to difference check according to the length of the difference search key, if the length of the difference search key is not matched with the length of the target difference search key, data query is directly ended to avoid carrying out data query according to the target search key which is constructed in error to obtain incorrect results, if the length of the difference search key is matched with the length of the target difference search key, the target search key is continuously constructed, whether query results matched with query conditions are obtained or not is further determined, if the query results matched with the query conditions are not obtained, the target search key is traced back to be reconstructed, and data query is carried out again.
As an alternative embodiment, a default value use setting switch field is further included in the target structure data, and the default value use setting switch field is used to indicate whether to use a default value instead of the default value.
The default value corresponds to an empty or invalid field in the common search key construction scheme in the target structure data. The target structure data comprises a default value use setting switch field, when the corresponding default value use setting switch field corresponds to an open state, when a corresponding public search key construction scheme in the target structure data is called, if the called public search key construction scheme contains the default field, the default value can be replaced by the default value; when the corresponding default value corresponds to the closed state using the setting switch field, when the corresponding public search key construction scheme in the target structure data is called, if the called public search key construction scheme contains the default field, the default field is left empty and then data query is continued, a manual filling of the default value may be prompted, or a subsequent data query cannot be performed by an instruction, and the like. The default value may be, for example, "0" or "1", and corresponds to an off state when the default value uses the value of the setting switch field to be "0", and corresponds to an on state when the default value uses the value of the setting switch field to be "1". The default value may be a numerical value configured in advance by a user, or may be a value given by default by a system when the user is not configured, which is not specifically limited in this embodiment.
According to the technical scheme provided by the embodiment of the invention, when the query condition of the target parameter data is obtained, the data structure table of the target parameter data is queried, the target structure data matched with the query condition is determined, then the target search keys are respectively constructed according to at least one target search key construction scheme in the target structure data, and the target search keys are utilized for data query until the data query result corresponding to the query condition is obtained or all predefined search key construction schemes are adopted. The method overcomes the defect that data query is carried out by adding index items in the prior art, meets the high concurrency requirement during data query, supports backtracking query, and improves the data query efficiency.
Example two
Fig. 3 is a flowchart of another data query method according to the second embodiment of the present invention. The present embodiment is embodied on the basis of the above-mentioned embodiment, wherein the target parameter data is embodied as financial parameter data.
As shown in fig. 3, the data query method provided in this embodiment specifically includes:
s210, acquiring query conditions of the financial parameter data.
Financial parameters, which refer to data available for reference in the financial industry, may be certain constant values assigned for certain financial scenarios, such as a calendar, etc.; the financial parameter may also be a variable, such as interest rate, etc., and when the financial parameter is a variable, the variable is used to control the change of the whole financial service, and the embodiment is not limited to the financial parameter.
The financial scenario refers to a broad scenario defined in scenario finance, including a life scenario, a business scenario, and the like, and the financial scenario is not specifically limited in this embodiment. In the financial industry, scene finance refers to integrating financial requirements into daily life scenes, and providing financial services for users by taking scenes as a core.
S220, inquiring a data structure table of the target parameter data, and determining target structure data matched with the inquiry conditions in the data structure table, wherein the target structure data comprises at least one target search key construction scheme predefined according to the index of the financial parameter data.
For example, the first type of non-differential index may include at least: parameter name, multi-legal organization number, first-level branch name, effective time and the like;
the second type of non-differential index may include at least: first-level branch names, second-level branch names, net point numbers, currency types and the like;
the differential indexing may include at least: product code, service center code, service personnel number, etc.
The above is merely an example of the first-type non-differential indexes, the second-type non-differential indexes, and the differential indexes, and is not particularly limited. In addition, the second type of non-differential indexes and differential indexes may also include other indexes, which is not illustrated herein.
When the target parameter data is financial parameter data, a scheme set can be constructed according to a second non-differential index, namely a first-class branch name, a second-class branch name, a network point number and a currency predefined public search key; the difference search key construction scheme can be predefined according to the difference index, namely the product code, the service center code and the service personnel number.
Fig. 4 is a schematic diagram of index integration according to a second embodiment of the present invention. As shown in fig. 4, at least one of the indexes such as the parameter name, the multi-legal organization number, the primary branch name, the valid time, etc. may be used as a head index of the financial parameter data, a public search key construction scheme set may be predefined according to the indexes based on the primary branch name, the secondary branch name, the website number, the currency, etc., a public search key construction scheme may be constructed according to the public search key construction scheme in the public search key construction scheme set, a differential search key construction scheme may be predefined according to the indexes such as the product code, the service center code, the service staff number, etc., a differential search key may be constructed according to the differential search key construction scheme, and then the head index, the public search key, and the differential search key may be combined to construct a target search key. The public search key construction scheme set and the difference search key construction scheme can be determined according to the data structure table, and a public search key construction scheme can be determined in the public search key construction scheme set according to the public search key construction scheme number in the data information table.
Illustratively, one piece of structure data in the data structure table corresponds to a set of financial parameter data having the same parameter name, the same multi-legal organization number, and the same first-level branch name.
S230, determining a public search key construction scheme in the public search key construction scheme set as the current public search key construction scheme.
When a public search key construction scheme is determined for the first time, a public search key construction scheme corresponding to the number in a public search key construction scheme set can be called preferentially according to the public search key construction scheme number in the data information table, a target search key is constructed by using the public search key construction scheme to perform parameter data query, when a data result corresponding to the target search key cannot be queried according to the target search key constructed by using the public search key construction scheme, the next public search key construction scheme in the public search key construction scheme set is called as a current public search key construction scheme in sequence, and the target search key is reconstructed to perform data query.
For example, when a query condition of certain financial parameter data is acquired, querying a data structure table of the financial parameter data and determining target structure data matched with the query condition; if the public search key construction scheme set field of the financial parameter data is as follows: "Method 1, Method2, Method3, Method 4", when the number of the public search key construction scheme is 1, preferentially using the public search key construction scheme corresponding to Method1 in the public search key construction scheme set as the current public search key construction scheme, and then constructing the first-type non-differential index of the target parameter data, the current public search key construction scheme, and the differential search key as the target search key; using the target search key to perform data query; if the data query result corresponding to the query condition of the financial parameter data cannot be obtained, backtracking to the public search key construction scheme set, sequentially selecting the public search key construction schemes as the current public search key construction scheme according to the sequence of Method2, Method3 and Method4, then reconstructing the target search key, and performing data query according to the reconstructed target search key.
S240, judging whether the current public search key construction scheme contains a default value, if so, executing S250, and if not, executing S270.
The default value refers to a field corresponding to an empty or invalid field in the common search key construction scheme in the target structure data.
And S250, judging whether the default value using setting switch field corresponds to an opening state, if so, executing S260, and if not, executing S270.
Judging whether the default value use setting switch field corresponds to an on state or not based on the default value use setting switch field in the target structure data matched with the query condition in the data structure table, wherein the value of the default value use setting switch field can be '0' or '1', and if the value of the default value use setting switch field is '1', corresponding to the on state, executing step S260; when the default value using setting switch field is "0", which corresponds to the off state, step S270 is executed.
When the default value corresponds to the off state using the field of the setting switch, if an empty field occurs in the public search key construction scheme, the field may also be set to be empty to continue the data query operation, that is, to continue to execute step S270.
And S260, replacing the default value with the default value.
If the public search key construction scheme contains a default value and the default value uses the on state corresponding to the setting switch field, the default value can be given to the empty field in the public search key construction scheme. The default value may be a value configured in advance by a user, or may be a value given by default by a system under a condition that the user is not configured, for example, when a first-level branch field is missing or invalid, the default value "DF", that is, the default branch, may be used to assign a value to the default value field, and then the assigned public search key construction scheme is used to perform data query again.
S270, taking the first-type non-differential index as a head index; constructing a public search key according to the current public search key construction scheme determined in the public search key construction scheme set; and constructing the difference search key according to the difference search key construction scheme.
And S280, judging whether the length of the difference search key is consistent with that of the target difference search key, if so, executing S290, and otherwise, executing S2120.
And judging whether the length of the difference search key is consistent with that of the target difference search key in the target search key or not, and performing difference verification on the target difference search key. If the length of the difference search key is not matched with the length of the target difference search key value, directly finishing data query so as to avoid carrying out data query according to the target search key which is constructed by mistake to obtain incorrect results, and if the length of the difference search key is matched with the length of the target difference search key, continuously constructing the target search key to carry out data query.
And S290, combining the head index, the public search key and the difference search key to serve as a target search key, and performing data query according to the target search key.
In an optional implementation manner, performing a data query according to the target search key may further include:
and carrying out data query according to the target search key, the parameter name, the legal organization number, the first-level branch name, the effective time and the difference search key.
The index of six financial parameter data of the target search key, the parameter name, the legal organization number, the first-level branch name, the effective time and the difference search key is used for data query, so that the data query speed is ensured, the data query efficiency is improved, the high concurrent query requirement during the financial parameter data query is met, and the accuracy of the data query result is further improved.
When data query is carried out according to the target search key, the parameter name, the legal organization number, the first-level branch name, the effective time and the difference search key, the data information body can be positioned only according to the index number not more than six, the data query efficiency can be improved, the small number of six index values can be combined into one data character string, the data is queried by introducing a Hash index mode of Redis cache, the connection time with a database can be reduced, and the data query efficiency is further improved.
S2100 determines whether a data query result corresponding to the data query condition is obtained, if so, executes S2120, and if not, executes S2110.
When the length of the difference search key is consistent with that of the difference search key, whether the obtained data query result corresponds to the query condition or not is judged, and when the data query result corresponding to the data query condition is not obtained, a common search key construction scheme can be selected from the common search key construction scheme set in sequence by backtracking, and data query is carried out again.
In this embodiment, the default data backtracking query function is turned on, and if the data backtracking query function is turned off, the data query process is ended after the execution of S280 is completed.
And S2110, judging whether all predefined search key construction schemes are adopted or not, if so, executing S2120, and if not, returning to execute S230.
When the data result corresponding to the financial parameter data cannot be inquired according to the inquiry condition of the financial parameter data, backtracking to the public search key construction scheme set, selecting a next public search key construction scheme in the public search key construction scheme set as a current public search key construction scheme according to the sequence, reconstructing a target search key, inquiring the financial parameter data according to the reconstructed target search key, and when the data inquiry result corresponding to the inquiry condition is obtained or all predefined search key construction schemes are adopted, finishing the data inquiry, so that the data result closest to the inquiry condition can be obtained when the data inquiry result corresponding to the data inquiry condition cannot be obtained.
For example, when a financial parameter data is predefined to construct a public search key construction scheme according to three indexes of a first-level branch name, a second-level branch name and currency, and query data cannot be acquired after a target search key is constructed by using the public search key construction scheme, a next predefined public search key construction scheme containing two indexes of a website number and the currency is selected to reconstruct a target search key for data query in a backtracking mode until a corresponding data query result is obtained, or until all predefined search key construction schemes are adopted. Further, when data query is performed according to the target search key, the parameter name, the corporate institution number, the first-level branch name, the effective time and the difference search key, if a common search key construction scheme set needs to be traced back, a date closest to the current date can be preferentially selected according to the effective time list to determine the common search key construction scheme, and data query is performed again, if a data result cannot be queried, the date is backed to determine the common search key construction scheme again until a data result corresponding to the data query condition is queried, or until the date query cycle is finished.
The valid time may refer to the valid time of the financial parameter data, or may be a combination of the valid time and the invalid time. The valid time list may be a list storing valid times of all financial parameter data.
S2120, finishing the data query.
For those parts of this embodiment that are not explained in detail, reference is made to the aforementioned embodiments, which are not repeated herein.
According to the technical scheme, when financial parameter data is inquired, when a specific piece of data cannot be matched according to the acquired financial parameter data inquiry condition, the next public search key construction scheme can be obtained in the data structure table in a backtracking mode, the target search key is reconstructed, data inquiry is performed again, multi-strategy inquiry of financial parameter data is achieved, backtracking inquiry is supported, flexibility of data inquiry and data inquiry efficiency are improved, data inquiry can be performed through six indexes of the target search key, the parameter name, the legal organization number, the first-level branch name, the effective time and the difference search key, and the high concurrent inquiry requirement of the financial parameter data is met.
EXAMPLE III
Fig. 5 is a schematic structural diagram of a data query apparatus according to a third embodiment of the present invention, which is applicable to how to implement data backtracking query on a target parameter, for example, a financial parameter, and the apparatus may be implemented in software and/or hardware, and may be generally integrated in a computer device.
As shown in fig. 5, the data query apparatus specifically includes: a query condition obtaining module 310, an access right search key construction scheme query module 320 and a search key construction and data query module 330. Wherein the content of the first and second substances,
a query condition obtaining module 310 configured to obtain a query condition of the target parameter data;
a search key construction scheme query module 320 configured to query a data structure table of the target parameter data, and determine target structure data in the data structure table matching the query condition, where the target structure data includes at least one target search key construction scheme predefined according to an index of the target parameter data;
the search key construction and data query module 330 is configured to respectively construct target search keys by using the at least one target search key construction scheme, and perform data query according to the target search keys until a data query result corresponding to the data query condition is obtained, or until all predefined search key construction schemes have been adopted.
The data query device provided by the embodiment of the invention can overcome the defect that data query is carried out by adding index items in the prior art, meets the high concurrency requirement during data query, supports backtracking query and improves the data query efficiency.
Optionally, the target structure data includes a first type of non-differential index of the target parameter data, a common search key construction scheme set predefined according to a second type of non-differential index of the target parameter data, and a differential search key construction scheme predefined according to a differential index of the target parameter data;
the non-differential index comprises a first type of non-differential index and a second type of non-differential index, the first type of non-differential index is used for data range query, the query fineness of the first type of non-differential index is smaller than that of the second type of non-differential index, and an intersection exists between the first type of non-differential index and the second type of non-differential index data;
the target search key construction scheme is determined according to at least one index in the first class of non-differential indexes, a common search key construction scheme in the common search key construction scheme set, and the differential search key construction scheme.
Optionally, one piece of structure data in the data structure table corresponds to a set of target parameter data with the same index value of the plurality of first-type non-differential indexes.
Optionally, the search key construction and data query module is specifically configured to:
taking the first type of non-differential index as a head index; constructing a public search key according to one public search key construction scheme in the public search key construction scheme set; constructing a difference search key according to the difference search key construction scheme; combining the head index, the common search key, and the difference search key as the target search key.
Optionally, the search key construction and data query module is specifically configured to: and combining the head index, the public search key and the index value of the difference search key into a data character string, and performing data query in a hash index mode.
Optionally, the target structure data further includes a difference search key length; correspondingly, the search key construction and data query module is further specifically configured to: and after constructing a target difference search key according to the difference search key construction scheme, verifying the length of the target difference search key by using the length of the difference search key.
Optionally, the target structure data further includes a default value use setting switch field, where the default value use setting switch field is used to indicate whether to use a default value instead of the default value.
Optionally, the search key construction and data query module is specifically configured to: determining a public search key construction scheme in the public search key construction scheme set according to the public search key construction scheme number in the data information table, wherein the public search key construction scheme is used as the current public search key construction scheme;
constructing a target search key according to the first-class non-differential index, the current public search key construction scheme and the differential search key, and performing data query according to the target search key;
if the data query result corresponding to the data query condition cannot be obtained, sequentially selecting a public search key construction scheme from the public search key construction scheme set, and updating the current public search key construction scheme;
and returning to execute the construction of a target search key according to the first-class non-differential index, the current public search key construction scheme and the differential search key, and performing data query operation according to the target search key until a data query result corresponding to the data query condition is obtained, or until all public search key construction schemes are selected.
Optionally, the data information table includes: the first type of non-differential index, the public search key, the differential search key, the public search key construction scheme number, and the data information body of the target parameter data;
and the data information body exists in a json format character string format.
Optionally, the search key construction and data query module is specifically configured to: and performing data query according to the target search key, the first type of non-differential index and the differential search key.
Optionally, the target parameter data includes: financial parameter data.
Optionally, the first type of non-differential index at least includes: parameter name, multi-legal organization number, first-level branch name and effective time; the second type of non-differential index includes at least: first-level branch names, second-level branch names, net point numbers and currency types; the differential index at least comprises: product code, service center code, and service personnel number.
Optionally, one piece of structure data in the data structure table corresponds to a group of financial parameter data with the same parameter name, the same multi-legal organization number and the same first-level branch name.
Optionally, the search key construction and data query module is specifically configured to: and performing data query according to the target search key, the parameter name, the legal organization number, the first-level branch name, the effective time and the difference search key.
The data query device can execute the data query method provided by any embodiment of the invention, and has the corresponding functional module and the beneficial effect of executing the data query method.
Example four
Fig. 6 is a schematic diagram of a hardware structure of a computer device according to a fourth embodiment of the present invention. FIG. 6 illustrates a block diagram of an exemplary computer device 12 suitable for use in implementing embodiments of the present invention. The computer device 12 shown in FIG. 6 is only an example and should not bring any limitations to the functionality or scope of use of embodiments of the present invention.
As shown in FIG. 6, computer device 12 is in the form of a general purpose computing device. The components of computer device 12 may include, but are not limited to: one or more processors or processing units 16, a system memory 28, and a bus 18 that couples various system components including the system memory 28 and the processing unit 16.
Bus 18 represents one or more of any of several types of bus structures, including a memory bus or memory controller, a peripheral bus, an accelerated graphics port, and a processor or local bus using any of a variety of bus architectures. By way of example, such architectures include, but are not limited to, Industry Standard Architecture (ISA) bus, micro-channel architecture (MAC) bus, enhanced ISA bus, Video Electronics Standards Association (VESA) local bus, and Peripheral Component Interconnect (PCI) bus.
Computer device 12 typically includes a variety of computer system readable media. Such media may be any available media that is accessible by computer device 12 and includes both volatile and nonvolatile media, removable and non-removable media.
The system memory 28 may include computer system readable media in the form of volatile memory, such as Random Access Memory (RAM)30 and/or cache memory 32. Computer device 12 may further include other removable/non-removable, volatile/nonvolatile computer system storage media. By way of example only, storage system 34 may be used to read from and write to non-removable, nonvolatile magnetic media (not shown in FIG. 6, and commonly referred to as a "hard drive"). Although not shown in FIG. 6, a magnetic disk drive for reading from and writing to a removable, nonvolatile magnetic disk (e.g., a "floppy disk") and an optical disk drive for reading from or writing to a removable, nonvolatile optical disk (e.g., a CD-ROM, DVD-ROM, or other optical media) may be provided. In these cases, each drive may be connected to bus 18 by one or more data media interfaces. System memory 28 may include at least one program product having a set (e.g., at least one) of program modules that are configured to carry out the functions of embodiments of the invention.
A program/utility 40 having a set (at least one) of program modules 42 may be stored, for example, in system memory 28, such program modules 42 including, but not limited to, an operating system, one or more application programs, other program modules, and program data, each of which examples or some combination thereof may comprise an implementation of a network environment. Program modules 42 generally carry out the functions and/or methodologies of the described embodiments of the invention.
Computer device 12 may also communicate with one or more external devices 14 (e.g., keyboard, pointing device, display 24, etc.), with one or more devices that enable a user to interact with computer device 12, and/or with any devices (e.g., network card, modem, etc.) that enable computer device 12 to communicate with one or more other computing devices. Such communication may be through an input/output (I/O) interface 22. Also, computer device 12 may communicate with one or more networks (e.g., a Local Area Network (LAN), a Wide Area Network (WAN), and/or a public network such as the Internet) via network adapter 20. As shown, network adapter 20 communicates with the other modules of computer device 12 via bus 18. It should be appreciated that although not shown in FIG. 6, other hardware and/or software modules may be used in conjunction with computer device 12, including but not limited to: microcode, device drivers, redundant processing units, external disk drive arrays, RAID systems, tape drives, and data backup storage systems, among others.
The processing unit 16 executes various functional applications and data processing by executing programs stored in the system memory 28, for example, to implement a data query method provided by an embodiment of the present invention. That is, the processing unit implements, when executing the program:
acquiring query conditions of target parameter data; querying a data structure table of the target parameter data, and determining target structure data matched with the query condition in the data structure table, wherein the target structure data comprises at least one target search key construction scheme predefined according to an index of the target parameter data; and respectively constructing target search keys by adopting the at least one target search key construction scheme, and performing data query according to the target search keys until a data query result corresponding to the data query condition is obtained, or until all predefined search key construction schemes are adopted.
EXAMPLE five
An embodiment five of the present invention provides a computer-readable storage medium, on which a computer program is stored, where the computer program, when executed by a processor, implements a data query method as provided in all inventive embodiments of this application: that is, the program when executed by the processor implements:
acquiring query conditions of target parameter data; querying a data structure table of the target parameter data, and determining target structure data matched with the query condition in the data structure table, wherein the target structure data comprises at least one target search key construction scheme predefined according to an index of the target parameter data; and respectively constructing target search keys by adopting the at least one target search key construction scheme, and performing data query according to the target search keys until a data query result corresponding to the data query condition is obtained, or until all predefined search key construction schemes are adopted.
Any combination of one or more computer-readable media may be employed. The computer readable medium may be a computer readable signal medium or a computer readable storage medium. A computer readable storage medium may be, for example, but not limited to, an electronic, magnetic, optical, electromagnetic, infrared, or semiconductor system, apparatus, or device, or any combination of the foregoing. More specific examples (a non-exhaustive list) of the computer readable storage medium would include the following: an electrical connection having one or more wires, a portable computer diskette, a hard disk, a Random Access Memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM or flash memory), an optical fiber, a portable compact disc read-only memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination of the foregoing. In the context of this document, a computer readable storage medium may be any tangible medium that can contain, or store a program for use by or in connection with an instruction execution system, apparatus, or device.
A computer readable signal medium may include a propagated data signal with computer readable program code embodied therein, for example, in baseband or as part of a carrier wave. Such a propagated data signal may take many forms, including, but not limited to, electro-magnetic, optical, or any suitable combination thereof. A computer readable signal medium may also be any computer readable medium that is not a computer readable storage medium and that can communicate, propagate, or transport a program for use by or in connection with an instruction execution system, apparatus, or device.
Program code embodied on a computer readable medium may be transmitted using any appropriate medium, including but not limited to wireless, wireline, optical fiber cable, RF, etc., or any suitable combination of the foregoing.
Computer program code for carrying out operations for aspects of the present invention may be written in any combination of one or more programming languages, including an object oriented programming language such as Java, Smalltalk, C + +, or the like, as well as conventional procedural programming languages, such as the "C" programming language or similar programming languages. The program code may execute entirely on the user's computer, partly on the user's computer, as a stand-alone software package, partly on the user's computer and partly on a remote computer or entirely on the remote computer or server. In the case of a remote computer, the remote computer may be connected to the user's computer through any type of network, including a Local Area Network (LAN) or a Wide Area Network (WAN), or the connection may be made to an external computer (for example, through the Internet using an Internet service provider).
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 described 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 (17)

1. A method for querying data, comprising:
acquiring query conditions of target parameter data;
querying a data structure table of the target parameter data, and determining target structure data matched with the query condition in the data structure table, wherein the target structure data comprises at least one target search key construction scheme predefined according to an index of the target parameter data;
and respectively constructing target search keys by adopting the at least one target search key construction scheme, and performing data query according to the target search keys until a data query result corresponding to the data query condition is obtained, or until all predefined search key construction schemes are adopted.
2. The method according to claim 1, wherein the target structure data comprises a first type of non-differential index of the target parameter data, a set of common search key construction schemes predefined according to a second type of non-differential index of the target parameter data, and a differential search key construction scheme predefined according to a differential index of the target parameter data;
the non-differential index comprises a first type of non-differential index and a second type of non-differential index, the first type of non-differential index is used for data range query, the query fineness of the first type of non-differential index is smaller than that of the second type of non-differential index, and an intersection exists between the first type of non-differential index and the second type of non-differential index data;
the target search key construction scheme is determined according to at least one index in the first class of non-differential indexes, a common search key construction scheme in the common search key construction scheme set, and the differential search key construction scheme.
3. The method according to claim 2, wherein one piece of structure data in the data structure table corresponds to a set of target parameter data with the same index value of the plurality of first-type non-differential indexes.
4. The method of claim 2, wherein constructing the target search key using a target search key construction scheme comprises:
taking the first type of non-differential index as a head index;
constructing a public search key according to one public search key construction scheme in the public search key construction scheme set;
constructing a difference search key according to the difference search key construction scheme;
combining the head index, the common search key, and the difference search key as the target search key.
5. The method of claim 4, wherein querying data according to the target search key comprises:
and combining the head index, the public search key and the index value of the difference search key into a data character string, and performing data query in a hash index mode.
6. The method of claim 4, wherein the target structure data further comprises a difference search key length;
after constructing the target difference search key according to the difference search key construction scheme, the method further comprises:
and verifying the length of the target difference search key by using the length of the difference search key.
7. The method of claim 2, further comprising a default value use set switch field in the target structure data, the default value use set switch field indicating whether to use a default value in place of the default value.
8. The method according to claim 4, wherein the steps of respectively constructing target search keys by using the at least one target search key construction scheme, and performing data query according to the target search keys until a data query result corresponding to the data query condition is obtained, or until all predefined search key construction schemes have been adopted, comprise:
determining a public search key construction scheme in the public search key construction scheme set according to the public search key construction scheme number in the data information table, wherein the public search key construction scheme is used as the current public search key construction scheme;
constructing a target search key according to the first-class non-differential index, the current public search key construction scheme and the differential search key, and performing data query according to the target search key;
if the data query result corresponding to the data query condition cannot be obtained, sequentially selecting a public search key construction scheme from the public search key construction scheme set, and updating the current public search key construction scheme;
and returning to execute the construction of a target search key according to the first-class non-differential index, the current public search key construction scheme and the differential search key, and performing data query operation according to the target search key until a data query result corresponding to the data query condition is obtained, or until all public search key construction schemes are selected.
9. The method of claim 8, wherein the data information table comprises: the first type of non-differential index, the public search key, the differential search key, the public search key construction scheme number, and the data information body of the target parameter data;
and the data information body exists in a json format character string format.
10. The method of claim 4, wherein querying data according to the target search key comprises:
and performing data query according to the target search key, the first type of non-differential index and the differential search key.
11. The method according to any of claims 1-10, wherein the target parameter data comprises: financial parameter data.
12. The method of claim 11, wherein the first type of non-differential indices comprises at least: parameter name, multi-legal organization number, first-level branch name and effective time;
the second type of non-differential index includes at least: first-level branch names, second-level branch names, net point numbers and currency types;
the differential index at least comprises: product code, service center code, and service personnel number.
13. The method of claim 12, wherein one piece of configuration data in the data configuration table corresponds to a set of financial parameter data having the same parameter name, the same multi-legal organization number, and the same first-level branch name.
14. The method of claim 12, wherein querying data according to the target search key comprises:
and performing data query according to the target search key, the parameter name, the legal organization number, the first-level branch name, the effective time and the difference search key.
15. A data query apparatus, comprising:
the query condition acquisition module is set to acquire the query conditions of the target parameter data;
a search key construction scheme query module configured to query a data structure table of the target parameter data, and determine target structure data in the data structure table that matches the query condition, where the target structure data includes at least one target search key construction scheme predefined according to an index of the target parameter data;
and the search key construction and data query module is set to respectively construct target search keys by adopting the at least one target search key construction scheme and carry out data query according to the target search keys until a data query result corresponding to the data query condition is obtained or until all predefined search key construction schemes are adopted.
16. A computer device comprising a memory, a processor and a computer program stored on the memory and executable on the processor, characterized in that the processor implements the method according to any of claims 1-14 when executing the program.
17. A computer-readable storage medium, on which a computer program is stored which, when being executed by a processor, carries out the method according to any one of claims 1 to 14.
CN202010974487.9A 2020-09-16 2020-09-16 Data query method, device, equipment and medium Pending CN112162982A (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN202010974487.9A CN112162982A (en) 2020-09-16 2020-09-16 Data query method, device, equipment and medium

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN202010974487.9A CN112162982A (en) 2020-09-16 2020-09-16 Data query method, device, equipment and medium

Publications (1)

Publication Number Publication Date
CN112162982A true CN112162982A (en) 2021-01-01

Family

ID=73858119

Family Applications (1)

Application Number Title Priority Date Filing Date
CN202010974487.9A Pending CN112162982A (en) 2020-09-16 2020-09-16 Data query method, device, equipment and medium

Country Status (1)

Country Link
CN (1) CN112162982A (en)

Cited By (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN112860960A (en) * 2021-03-15 2021-05-28 北京达佳互联信息技术有限公司 Data query method and device
CN116737777A (en) * 2023-08-16 2023-09-12 北京壁仞科技开发有限公司 Method, computing device and computer readable storage medium for searching for target operators

Citations (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US20070174238A1 (en) * 2006-01-18 2007-07-26 Microsoft Corporation Indexing and searching numeric ranges
US20150169582A1 (en) * 2013-12-14 2015-06-18 Mirosoft Corporation Query techniques and ranking results for knowledge-based matching
CN105550225A (en) * 2015-12-07 2016-05-04 百度在线网络技术（北京）有限公司 Index construction method and query method and apparatus
CN110347722A (en) * 2019-07-11 2019-10-18 软通智慧科技有限公司 Data capture method, device, equipment and storage medium based on HBase

Patent Citations (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US20070174238A1 (en) * 2006-01-18 2007-07-26 Microsoft Corporation Indexing and searching numeric ranges
US20150169582A1 (en) * 2013-12-14 2015-06-18 Mirosoft Corporation Query techniques and ranking results for knowledge-based matching
CN105550225A (en) * 2015-12-07 2016-05-04 百度在线网络技术（北京）有限公司 Index construction method and query method and apparatus
CN110347722A (en) * 2019-07-11 2019-10-18 软通智慧科技有限公司 Data capture method, device, equipment and storage medium based on HBase

Cited By (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN112860960A (en) * 2021-03-15 2021-05-28 北京达佳互联信息技术有限公司 Data query method and device
CN112860960B (en) * 2021-03-15 2024-02-23 北京达佳互联信息技术有限公司 Data query method and device
CN116737777A (en) * 2023-08-16 2023-09-12 北京壁仞科技开发有限公司 Method, computing device and computer readable storage medium for searching for target operators
CN116737777B (en) * 2023-08-16 2023-11-28 北京壁仞科技开发有限公司 Method, computing device and computer readable storage medium for searching for target operators

Similar Documents

Publication Publication Date Title
US8108367B2 (en) Constraints with hidden rows in a database
US10866973B2 (en) Test data management
US10296497B2 (en) Storing a key value to a deleted row based on key range density
WO2021242435A1 (en) Automatic transformation of data by patterns
EP2889788A1 (en) Accessing information content in a database platform using metadata
CN110688544A (en) Method, device and storage medium for querying database
AU2015331030A1 (en) System generator module for electronic document and electronic file
CN106648569B (en) Target serialization realization method and device
US20060282470A1 (en) Determining compliance of a database architecture to an enterprise data standard
CN112162982A (en) Data query method, device, equipment and medium
US20210056219A1 (en) Automated sensitive data classification in computerized databases
CN108140022B (en) Data query method and database system
CN110990406B (en) Fuzzy query method, device, equipment and medium
CN116226166A (en) Data query method and system based on data source
CN110716960B (en) Database query method, device, equipment and storage medium
CN115237805A (en) Test case data preparation method and device
US20130041887A1 (en) Adding entries to an index based on use of the index
US8433729B2 (en) Method and system for automatically generating a communication interface
US9286349B2 (en) Dynamic search system
CN112989011B (en) Data query method, data query device and electronic equipment
CN108008947B (en) Intelligent prompting method and device for programming statement, server and storage medium
CN111858581B (en) Paging query method and device, storage medium and electronic equipment
CN111930313B (en) Method and device for data association access in host
CN117130937A (en) Test case processing method, device, electronic equipment and storage medium
RU2669143C1 (en) Method of data transformation of geoinformation systems (gis), system for its implementation and method of search for the data based on this method

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