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

Data query method, device, equipment and medium Download PDF

Info

Publication number
CN115292322A
CN115292322A CN202210938997.XA CN202210938997A CN115292322A CN 115292322 A CN115292322 A CN 115292322A CN 202210938997 A CN202210938997 A CN 202210938997A CN 115292322 A CN115292322 A CN 115292322A
Authority
CN
China
Prior art keywords
target
index
character string
characters
data
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
CN202210938997.XA
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.)
Bank of China Ltd
Original Assignee
Bank of China Ltd
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 Bank of China Ltd filed Critical Bank of China Ltd
Priority to CN202210938997.XA priority Critical patent/CN115292322A/en
Publication of CN115292322A publication Critical patent/CN115292322A/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
    • 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/2453—Query optimisation
    • 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
    • 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/28—Databases characterised by their database models, e.g. relational or object models
    • G06F16/284—Relational databases

Landscapes

  • Engineering & Computer Science (AREA)
  • Theoretical Computer Science (AREA)
  • Databases & Information Systems (AREA)
  • Data Mining & Analysis (AREA)
  • Physics & Mathematics (AREA)
  • General Engineering & Computer Science (AREA)
  • General Physics & Mathematics (AREA)
  • Computational Linguistics (AREA)
  • Software Systems (AREA)
  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)

Abstract

The application discloses a data query method, a data query device, data query equipment and a data query medium, which can be applied to the field of big data or the field of finance. Establishing an index for at least one attribute in the data table; one attribute in the data table corresponds to at least one first character string; continuously cutting the first character string according to the number of characters to obtain a plurality of second character strings, wherein the index is established according to the second character strings; acquiring a query condition which is input by a user and comprises a target character string, and then finding a target index, wherein the target index stores a main key; and acquiring target data from the data sheet according to the main key so as to write the target data into the excel sheet. And establishing an index for the data table according to the character string obtained after cutting, searching a primary key of the data table through the target index, and obtaining complete record information from the relational database according to the primary key obtained by query. By establishing an index optimization data query mode, fuzzy matching is converted into accurate matching, full-table scanning of a relational database is avoided, and the data query speed is increased.

Description

Data query method, device, equipment and medium
Technical Field
The present application relates to the field of big data, and in particular, to a method, an apparatus, a device, and a medium for data query.
Background
The online service often has a certain requirement on the request time, and the background is required to return the request result within a certain time. For example, when an online transaction in a scene system needs to be exported as a report query, the specific function is to write query-related data (fuzzy query) into an excel according to query conditions and download an excel file. Due to the large data volume, the aspects of inquiring, writing in excel, downloading and the like are time-consuming, and the problem of system timeout is easy to occur. The report generation through the online request is time-consuming, and the report generation through the online request comprises two aspects, namely on one hand, data is inquired from a database and returned to a background, and on the other hand, the inquired data is written into an excel form and returned to a front end. In the prior art, the like keywords provided by the database are often used for fuzzy query to match database data, while the database does not need to carry out indexing when using the like, and needs to be subjected to full-table scanning query, so that the query efficiency is seriously influenced when the data size is large, and the query speed is slow.
Disclosure of Invention
In view of this, an object of the present application is to provide a data query method, apparatus, device and medium, which improve data query speed. The specific scheme is as follows:
in a first aspect, the present application provides a data query method, including:
establishing an index for at least one attribute in the data table; one attribute in the data table corresponds to at least one first character string; continuously cutting the first character string according to the number of characters to obtain a plurality of second character strings, wherein the index is established according to the second character strings;
acquiring a query condition input by a user, wherein the query condition comprises a target character string;
searching the index according to the number of the characters and the character content of the target character string to obtain a target index; the number and content of the second character string in the target index are the same as those of the target character string; the target index stores a main key;
and acquiring target data from the data table according to the primary key so as to write the target data into the excel table.
Optionally, the searching the index according to the number of characters of the target character string to obtain a target index includes:
and searching the index according to the number of the characters of the target character string by utilizing a binary search algorithm to obtain a target index.
Optionally, when the number of characters in the first character string is 3 and the type of the characters is 3, the number of the second character string is 6.
Optionally, the indexes are classified and stored according to the number of characters; the searching the index according to the number of the characters and the character content of the target character string to obtain a target index comprises:
searching a target index set according to the number of the characters of the target character string and the character content to obtain a target index; the target index set includes indexes having the same number of characters.
Optionally, the indexing at least one attribute in the data table includes:
an index is created for at least one attribute in the data table based on a full text search engine.
In a second aspect, an embodiment of the present application further provides a data query apparatus, including:
the establishing unit is used for establishing an index for at least one attribute in the data table; one attribute in the data table corresponds to at least one first character string; continuously cutting the first character string according to the number of characters to obtain a plurality of second character strings, wherein the index is established according to the second character strings;
the device comprises a first acquisition unit, a second acquisition unit and a third acquisition unit, wherein the first acquisition unit is used for acquiring a query condition input by a user, and the query condition comprises a target character string;
the searching unit is used for searching the index according to the number of the characters and the character content of the target character string to obtain a target index; the number and content of the second character string in the target index are the same as those of the target character string; the target index stores a main key;
and the second acquisition unit is used for acquiring target data from the data table according to the main key so as to write the target data into the excel table.
Optionally, the search unit is configured to:
and searching the index according to the number of the characters of the target character string by utilizing a binary search algorithm to obtain a target index.
Optionally, when the number of characters in the first character string is 3 and the type of the characters is 3, the number of the second character string is 6.
In a third aspect, an embodiment of the present application further provides a computer device, where the computer device includes a processor and a memory:
the memory is used for storing program codes and transmitting the program codes to the processor;
the processor is configured to perform the method according to instructions in the program code.
In a fourth aspect, the present application further provides a computer-readable storage medium for storing a computer program for executing the method.
The embodiment of the application provides a data query method, a data query device, data query equipment and a data query medium, wherein an index is established for at least one attribute in a data table; one attribute in the data table corresponds to at least one first character string; continuously cutting the first character string according to the number of characters to obtain a plurality of second character strings, wherein the index is established according to the second character strings; acquiring a query condition input by a user, wherein the query condition comprises a target character string; searching the index according to the number of the characters and the character content of the target character string to obtain a target index; the number of characters and the character content of a second character string in the target index are the same as those of the target character string; the target index stores a primary key; and acquiring target data from the data table according to the main key so as to write the target data into the excel table. It can be seen that, in the embodiment of the present application, the character strings are continuously cut according to the number of characters, an index is established for the data table according to the character strings obtained after cutting, the target index is found according to the query condition, the primary key of the data table is found according to the target index, and the complete record information, i.e., the target data, is found from the relational database by using the primary key.
Drawings
In order to more clearly illustrate the embodiments of the present application or the technical solutions in the prior art, the drawings used in the embodiments or the prior art descriptions will be briefly described below, and it is obvious that the drawings in the following descriptions are some embodiments of the present application, and other drawings can be obtained by those skilled in the art without creative efforts.
Fig. 1 is a schematic flowchart illustrating a data query method provided in an embodiment of the present application;
fig. 2 is a block diagram of a data query device according to an embodiment of the present application.
Detailed Description
In order to make the aforementioned objects, features and advantages of the present application more comprehensible, embodiments accompanying the present application are described in detail below with reference to the accompanying drawings.
In the following description, numerous specific details are set forth in order to provide a thorough understanding of the present application, but the present application may be practiced in other ways than those described herein, and it will be apparent to those of ordinary skill in the art that the present application is not limited by the specific embodiments disclosed below.
Based on the technical problems, the embodiment of the application provides a data query method, a device, equipment and a medium, wherein an index is established for at least one attribute in a data table; one attribute in the data table corresponds to at least one first character string; continuously cutting the first character string according to the number of characters to obtain a plurality of second character strings, wherein the index is established according to the second character strings; acquiring a query condition input by a user, wherein the query condition comprises a target character string; searching the index according to the number of the characters and the character content of the target character string to obtain a target index; the number of characters and the character content of a second character string in the target index are the same as those of the target character string; the target index stores a primary key; and acquiring target data from the data table according to the primary key so as to write the target data into the excel table. It can be seen that, in the embodiment of the present application, the character strings are continuously cut according to the number of characters, an index is established for the data table according to the character strings obtained after cutting, the target index is found according to the query condition, the primary key of the data table is found according to the target index, and the complete record information, i.e., the target data, is found from the relational database by using the primary key.
For convenience of understanding, a data query method, an apparatus, a device, and a medium provided by the embodiments of the present application are described in detail below with reference to the accompanying drawings.
Referring to fig. 1, a schematic flow chart of a data query method provided in an embodiment of the present application is shown, where the method may include the following steps.
S101, establishing an index for at least one attribute in a data table; and one attribute in the data table corresponds to at least one first character string, the first character string is continuously cut according to the number of characters to obtain a plurality of second character strings, and the index is established according to the second character strings.
In the embodiment of the application, the index can be established for the database after the data is loaded in batches every night. After the data is loaded in batches, the database is updated, and an index can be established for the updated database, that is, the index can be updated regularly every day.
The database is used for storing data, the database may be a relational database, the relational database may include a plurality of data tables, each data table includes at least one attribute, such as a name, one attribute corresponds to at least one first character string, for example, when the attribute is a name, an attribute value, that is, the first character string may be TOMMY or TOM, the attribute value is cut and recorded according to field data in the table, the first character string is continuously cut according to the number of characters to obtain a plurality of second character strings, and then an index is established according to the second character strings.
Specifically, text cutting is performed according to a certain column of data in the data table, and the cutting result is used as a key of the index, namely, the second character string as described above. For example, if the ID attribute (primary key) of a record in the student information table is 10, and the name attribute is "TOMMY" as the first string, the length of the first string TOMMY is x, and x =5 at this time, the string is cut into the second string with the number of characters of 1-5, and if the number of characters is 1, the second string may be "T", "O", "M", "Y"; when the number of characters is 2, the second string may be "TO", "OM", "MM", "MY"; when the number of characters is 3, the second string may be "TOM", "OMM", "MMY"; when the number of characters is 4, the second string may be "TOMM", "OMMY"; when the number of characters is 5, the second character string is "TOMMY". And establishing an index according to the second character string, wherein the index content is the key value of the primary key in the data table, such as 10.
In addition, if the same second character string is obtained by cutting different first character strings, the same character string may be subjected to index merging. For example, if the ID attribute (primary key) of a record in the student information table is 15, and the name attribute is "TOM", when the number of characters is 1, the second character string may be "T", "O", or "M", and it is found that character cutting is performed on "TOMMY" and TOM "to obtain the same character strings" T "," O ", or" M ", then index merging may be performed on the character string" T ", and the index content corresponding to the character string" T "includes 10 and 15, and similarly, the index content corresponding to the character string" O "also includes 10 and 15, and the index content corresponding to the character string" M "also includes 10 and 15. In the embodiment of the present application, when the number of characters of the first character string is 3 and the types of characters are 3, the number of the second character strings is 6. For example, if the first string is "TOM", the number of the second strings is 6, which are "T", "O", "M", "TO", "OM", and "TOM", respectively.
For example, when the first character string is "TOMMY", 4 kinds of cutting results, that is, 4 second character strings are obtained when the number of characters is 1 after the above-mentioned cutting; when the number of the characters is 2, obtaining 4 second character strings; when the number of the characters is 3, obtaining 3 second character strings; when the number of the characters is 4, obtaining 2 second character strings; when the number of characters is 5, 1 second character string is obtained, and 14 cutting results, namely 14 second character strings, can be obtained in total.
In the embodiment of the application, the indexes can be stored in a classified manner according to the number of characters, and can also be stored according to the types of the characters. When the indexes are classified and stored according to the number of characters, the step of searching the indexes according to the number of characters and the character content of the target character string to obtain the target index comprises the following steps: searching a target index set according to the number of the characters of the target character string and the character content to obtain a target index; the target index set includes indexes having the same number of characters.
Specifically, the indexes may be sorted and stored according to the number of characters, for example, in the first index set, all indexes with the number of characters of 1, indexes related to "T", "O", "M", and "Y" are included, in the second index set, all indexes with the number of characters of 4, and indexes related to "TOMM" and "OMMY" are included.
In an embodiment of the present application, the indexing at least one attribute in the data table includes: the index is built on the basis of a full-text search engine (Lucene), specifically, a set of indexes can be built on the basis of the Lucene, and the indexes are classified according to the number of characters.
In the embodiment of the present application, the index may be stored using a B + tree structure, the leaf node (the lowest layer) stores key information, i.e., attribute values, and corresponding all data records, i.e., target data, and the non-leaf node stores pointer information.
S102, obtaining a query condition input by a user, wherein the query condition comprises a target character string.
In the embodiment of the application, the query condition input by the user can be obtained, and the query condition comprises the target character string. Specifically, a user inputs a query condition, sends a request, and a background receives the request to obtain the length of a target character string in the query condition.
S103, searching the index according to the number of the characters and the character content of the target character string to obtain a target index; the target index stores a primary key.
In this embodiment of the present application, the number of characters and the character content of the second character string in the target index are the same as the number of characters and the character content of the target character string, and the target index stores a primary key. Specifically, an index set including the same number of characters is searched for according to the number of characters of the target character string, for example, if the target character string is "OMMY" and the number of characters is 4, the index set is determined to be a second index set, the second index set includes indexes related to "OMMY" and "TOMM", and then, if the content of the de-matching character in the second index set is "OMMY", the target index is determined to be an index related to "OMMY", and the corresponding primary key value is 10.
In this embodiment of the present application, the searching for the index according to the number of characters of the target character string to obtain the target index includes: and searching the index according to the number of the characters of the target character string by utilizing a binary search algorithm to obtain a target index. Specifically, during query, firstly, indexes of corresponding categories are selected for the length of the query field, index data are completely matched by using a binary search algorithm, and after a primary key is searched out, the primary key obtained by query is used as a query condition to search the database.
S104, acquiring target data from the database according to the primary key so as to write the target data into an excel table.
In the embodiment of the application, target data can be obtained from the data table according to the obtained record main key, and the target data is written into the excel table and then transmitted to the front end from the background to generate a report file. Specifically, a database query statement is generated according to the acquired main key, and target data is queried according to the main key of the data table.
In the embodiment of the application, the report data source is a certain data table in the relational database, and the related data in the data table can be exported to form a report according to the query condition of the user.
The embodiment of the application provides a data query method, which comprises the steps of establishing an index for at least one attribute in a data table; one attribute in the data table corresponds to at least one first character string; continuously cutting the first character string according to the number of characters to obtain a plurality of second character strings, wherein the index is established according to the second character strings; acquiring a query condition input by a user, wherein the query condition comprises a target character string; searching the index according to the number of the characters and the character content of the target character string to obtain a target index; the number of characters and the character content of a second character string in the target index are the same as those of the target character string; the target index stores a primary key; and acquiring target data from the data table according to the main key so as to write the target data into the excel table. It can be seen that, in the embodiment of the present application, the character strings are continuously cut according to the number of characters, an index is established for the data table according to the character strings obtained after cutting, the target index is found according to the query condition, the primary key of the data table is found according to the target index, and the complete record information, i.e., the target data, is found from the relational database by using the primary key.
Based on the foregoing data query method, an embodiment of the present application further provides a data query device, and referring to fig. 2, a block diagram of a data query device provided in an embodiment of the present application is shown, where the data query device may include:
an establishing unit 100, configured to establish an index for at least one attribute in a data table; one attribute in the data table corresponds to at least one first character string; continuously cutting the first character string according to the number of characters to obtain a plurality of second character strings, wherein the index is established according to the second character strings;
a first obtaining unit 200, configured to obtain a query condition input by a user, where the query condition includes a target character string;
the searching unit 300 is configured to search the index according to the number of characters and the content of the characters of the target character string to obtain a target index; the number of characters and the character content of a second character string in the target index are the same as those of the target character string; the target index stores a main key;
a second obtaining unit 400, configured to obtain target data from the data table according to the primary key, so as to write the target data into an excel table.
Optionally, the searching unit is configured to:
and searching the index according to the number of the characters of the target character string by utilizing a binary search algorithm to obtain a target index.
Optionally, when the number of characters in the first character string is 3 and the type of the characters is 3, the number of the second character string is 6.
The embodiment of the application provides a data query device, which comprises an establishing unit, a searching unit and a searching unit, wherein the establishing unit is used for establishing an index for at least one attribute in a data table; one attribute in the data table corresponds to at least one first character string; continuously cutting the first character string according to the number of characters to obtain a plurality of second character strings, wherein the index is established according to the second character strings; the device comprises a first acquisition unit, a second acquisition unit and a third acquisition unit, wherein the first acquisition unit is used for acquiring a query condition input by a user, and the query condition comprises a target character string; the searching unit is used for searching the index according to the character number and the character content of the target character string to obtain a target index; the number and content of the second character string in the target index are the same as those of the target character string; the target index stores a main key; and the second acquisition unit is used for acquiring target data from the data table according to the main key so as to write the target data into the excel table. It can be seen that, in the embodiment of the present application, the character strings are continuously cut according to the number of characters, an index is established for the data table according to the character strings obtained after cutting, the target index is found according to the query condition, the primary key of the data table is found according to the target index, and the complete record information, i.e., the target data, is found from the relational database by using the primary key.
In yet another aspect, an embodiment of the present application provides a computer device, including a processor and a memory:
the memory is used for storing program codes and transmitting the program codes to the processor;
the processor is configured to execute the data query method provided by the above embodiment according to the instructions in the program code.
The computer device may include a terminal device or a server, and the aforementioned data query device may be configured in the computer device.
In another aspect, an embodiment of the present application further provides a storage medium, where the storage medium is used to store a computer program, and the computer program is used to execute the data query method provided in the foregoing embodiment.
In addition, the embodiment of the present application further provides a computer program product including instructions, which when run on a computer, causes the computer to execute the data query method provided by the above embodiment.
Those of ordinary skill in the art will understand that: all or part of the steps for realizing the method embodiments can be completed by program instruction hardware, the program can be stored in a computer readable storage medium, and the program executes the steps comprising the method embodiments when executed; and the aforementioned storage medium may be at least one of the following media: various media that can store program codes, such as Read-only Memory (ROM), RAM, magnetic disk, or optical disk.
It should be noted that the data query method, device, equipment and medium provided by the invention can be used in the field of big data or the field of finance. The foregoing is merely an example, and does not limit the application fields of the data query method, apparatus, device and medium provided by the present invention.
The embodiments in the present specification are described in a progressive manner, and the same and similar parts among the embodiments are referred to each other, and each embodiment focuses on the differences from other embodiments. In particular, the apparatus embodiments are substantially similar to the method embodiments and therefore are described in a relatively simple manner, and reference may be made to some of the description of the method embodiments for relevant points.
The foregoing is merely a preferred embodiment of the present application and, although the present application has been described with reference to the preferred embodiments, it is not intended to limit the present application. Those skilled in the art can now make numerous possible variations and modifications to the disclosed embodiments, or modify equivalent embodiments, using the methods and techniques disclosed above, without departing from the scope of the claimed embodiments. Therefore, any simple modification, equivalent change and modification made to the above embodiments according to the technical essence of the present application are still within the protection scope of the technical solution of the present application without departing from the content of the technical solution of the present application.

Claims (10)

1. A method for querying data, comprising:
establishing an index for at least one attribute in the data table; one attribute in the data table corresponds to at least one first character string; continuously cutting the first character string according to the number of characters to obtain a plurality of second character strings, wherein the index is established according to the second character strings;
acquiring a query condition input by a user, wherein the query condition comprises a target character string;
searching the index according to the number of the characters and the character content of the target character string to obtain a target index; the number of characters and the character content of a second character string in the target index are the same as those of the target character string; the target index stores a main key;
and acquiring target data from the data table according to the primary key so as to write the target data into the excel table.
2. The method of claim 1, wherein the searching the index according to the number of characters of the target character string to obtain a target index comprises:
and searching the index according to the number of the characters of the target character string by utilizing a binary search algorithm to obtain a target index.
3. The method according to claim 1, wherein when the number of characters of the first character string is 3 and the kind of characters is 3, the number of the second character string is 6.
4. The method of claim 1, wherein the indexes are classified and stored according to the number of characters, and the searching the index according to the number of characters and the character content of the target character string to obtain the target index comprises:
searching a target index set according to the number of the characters of the target character string and the character content to obtain a target index; the target index set includes indexes having the same number of characters.
5. The method according to any one of claims 1-4, wherein indexing at least one attribute in the data table comprises:
an index is created for at least one attribute in the data table based on a full text search engine.
6. A data query apparatus, comprising:
the establishing unit is used for establishing an index for at least one attribute in the data table; one attribute in the data table corresponds to at least one first character string; continuously cutting the first character string according to the number of characters to obtain a plurality of second character strings, wherein the index is established according to the second character strings;
the device comprises a first acquisition unit, a second acquisition unit and a third acquisition unit, wherein the first acquisition unit is used for acquiring a query condition input by a user, and the query condition comprises a target character string;
the searching unit is used for searching the index according to the character number and the character content of the target character string to obtain a target index; the number and content of the second character string in the target index are the same as those of the target character string; the target index stores a main key;
and the second acquisition unit is used for acquiring target data from the data table according to the main key so as to write the target data into the excel table.
7. The apparatus of claim 6, wherein the lookup unit is configured to:
and searching the index according to the number of the characters of the target character string by utilizing a binary search algorithm to obtain a target index.
8. The apparatus according to claim 6, wherein when the number of characters of the first character string is 3 and the kind of characters is 3, the number of the second character string is 6.
9. A computer device, the computer device comprising a processor and a memory:
the memory is used for storing program codes and transmitting the program codes to the processor;
the processor is configured to perform the method of any one of claims 1-5 in accordance with instructions in the program code.
10. A computer-readable storage medium, characterized in that the computer-readable storage medium is used to store a computer program for performing the method of any of claims 1-5.
CN202210938997.XA 2022-08-05 2022-08-05 Data query method, device, equipment and medium Pending CN115292322A (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN202210938997.XA CN115292322A (en) 2022-08-05 2022-08-05 Data query method, device, equipment and medium

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN202210938997.XA CN115292322A (en) 2022-08-05 2022-08-05 Data query method, device, equipment and medium

Publications (1)

Publication Number Publication Date
CN115292322A true CN115292322A (en) 2022-11-04

Family

ID=83828629

Family Applications (1)

Application Number Title Priority Date Filing Date
CN202210938997.XA Pending CN115292322A (en) 2022-08-05 2022-08-05 Data query method, device, equipment and medium

Country Status (1)

Country Link
CN (1) CN115292322A (en)

Similar Documents

Publication Publication Date Title
US11907244B2 (en) Modifying field definitions to include post-processing instructions
US8161036B2 (en) Index optimization for ranking using a linear model
US7676453B2 (en) Partial query caching
US7827181B2 (en) Click distance determination
US8171031B2 (en) Index optimization for ranking using a linear model
US7769752B1 (en) Method and system for updating display of a hierarchy of categories for a document repository
US9594794B2 (en) Restoring records using a change transaction log
CN107729371B (en) Data indexing and querying method, device, equipment and storage medium of block chain
US10296622B1 (en) Item attribute generation using query and item data
JPH11212980A (en) Production of index and retrieval method
US20080215564A1 (en) Query rewrite
US8825665B2 (en) Database index and database for indexing text documents
CN110659282B (en) Data route construction method, device, computer equipment and storage medium
US20090210389A1 (en) System to support structured search over metadata on a web index
US9418154B2 (en) Push-model based index updating
CN109992603B (en) Data searching method and device, electronic equipment and computer readable medium
CN111506621A (en) Data statistical method and device
US9594784B2 (en) Push-model based index deletion
CN1601524A (en) Fuzzy inquiry system and method
CN111797095B (en) Index construction method and JSON data query method
CN115292322A (en) Data query method, device, equipment and medium
CN112597100B (en) File management method and device based on object proxy label
CN111858609A (en) Fuzzy query method and device for block chain
KR101299555B1 (en) Apparatus and method for text search using index based on hash function
CN112632087B (en) Ordered linked list quick query method and device based on range diagram

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