CN110569268A - data query method, system and computer readable storage medium - Google Patents
data query method, system and computer readable storage medium Download PDFInfo
- Publication number
- CN110569268A CN110569268A CN201910875815.7A CN201910875815A CN110569268A CN 110569268 A CN110569268 A CN 110569268A CN 201910875815 A CN201910875815 A CN 201910875815A CN 110569268 A CN110569268 A CN 110569268A
- Authority
- CN
- China
- Prior art keywords
- service data
- server
- query
- word segmentation
- 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
Links
- 238000000034 method Methods 0.000 title claims abstract description 40
- 230000011218 segmentation Effects 0.000 claims description 94
- 238000004590 computer program Methods 0.000 claims description 24
- 238000012545 processing Methods 0.000 claims description 20
- 230000004044 response Effects 0.000 abstract description 10
- 238000010586 diagram Methods 0.000 description 9
- 238000012986 modification Methods 0.000 description 3
- 230000004048 modification Effects 0.000 description 3
- 238000004891 communication Methods 0.000 description 2
- 230000006870 function Effects 0.000 description 2
- 238000004458 analytical method Methods 0.000 description 1
- 238000003491 array Methods 0.000 description 1
- 238000013461 design Methods 0.000 description 1
- 238000001514 detection method Methods 0.000 description 1
- 238000005516 engineering process Methods 0.000 description 1
- 230000003287 optical effect Effects 0.000 description 1
- 238000005457 optimization Methods 0.000 description 1
- 238000006467 substitution reaction Methods 0.000 description 1
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/24—Querying
- G06F16/245—Query processing
- G06F16/2455—Query execution
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Computational Linguistics (AREA)
- Data Mining & Analysis (AREA)
- Databases & Information Systems (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The embodiment of the invention discloses a data query method, a data query system and a computer readable storage medium. The method comprises the following steps: if receiving the service data uploaded by the user side, the service system server sends the service data to the ES server; the ES server receives the service data and stores the service data into an ES database; if receiving the query request of the user side, the service system server sends the query request to the ES server; the ES server receives the query request, acquires corresponding service data from an ES database according to the query request, and sends the service data serving as a query result to the service system server; and the service system server receives the query result and sends the query result to the user side, so that the service data uploaded by the user can be stored in the Elastic Search, and the Elastic Search responds to the query request of the user. Compared with the traditional sql query, the response speed of the Elastic Search query is higher, so that the waiting time of a user can be greatly reduced, and the use experience of the user is improved.
Description
Technical Field
the present invention relates to the field of data processing technologies, and in particular, to a data query method, a data query system, and a computer-readable storage medium.
background
at this stage, a large amount of historical data exists in business systems of enterprises. According to the requirements of users, the users need to inquire partial historical data in real time. In the prior art, an sql database is usually used for storing data, when the stored data is more and the data structure storage is more complex, the maximum optimization time which can be supported by sql statements is in the level of 10 seconds, so that the query of a user needs longer waiting time, and poorer use experience is caused.
disclosure of Invention
the embodiment of the invention provides a data query method, a data query system and a computer readable storage medium, aiming at solving the problem of longer query response time in the prior art.
In a first aspect, an embodiment of the present invention provides a data query method, which includes:
if receiving the service data uploaded by the user side, the service system server sends the service data to the ES server;
The ES server receives the service data and stores the service data into an ES database;
if receiving a query request of a user side, the service system server sends the query request to the ES server;
The ES server receives the query request, acquires corresponding service data from the ES database according to the query request, and sends the corresponding service data serving as a query result to a service system server;
and the service system server receives the query result and sends the query result to the user side.
In a second aspect, an embodiment of the present invention further provides a data query system, where the data query system includes a service system server and an ES server, the service system server includes a first sending unit, a second sending unit, and a third sending unit, and the ES server includes a first storage unit and a query unit, where:
The first sending unit is used for sending the service data to the ES server if the service data uploaded by the user side is received;
The first storage unit is used for receiving the service data and storing the service data into an ES database;
The second sending unit is used for sending the query request to the ES server if the query request of the user side is received;
The query unit is used for receiving the query request, acquiring corresponding service data from the ES database according to the query request, and sending the service data serving as a query result to a service system server;
and the third sending unit is used for receiving the query result and sending the query result to the user side.
in a third aspect, an embodiment of the present invention further provides a data query system, where the data query system includes a service system server and an ES server, where the service system server and the ES server each include a memory, a processor, and a computer program stored in the memory and executable on the processor, and the processors of the service system server and the ES server implement the method according to the first aspect when executing the corresponding computer programs.
In a fourth aspect, an embodiment of the present invention further provides a computer-readable storage medium, where the storage medium stores a first computer program and a second computer program, and the first computer program and the second computer program, when executed by processors of a business system server and an ES server, respectively, can implement the method according to the first aspect.
According to the technical scheme of the embodiment of the invention, if the service data uploaded by the user side is received, the service system server sends the service data to the ES server; the ES server receives the service data and stores the service data into an ES database; if receiving a query request of a user side, the service system server sends the query request to the ES server; the ES server receives the query request, acquires corresponding service data from the ES database according to the query request, and sends the corresponding service data serving as a query result to a service system server; and the service system server receives the query result and sends the query result to the user side, so that the service data uploaded by the user can be stored in the Elastic Search, and the Elastic Search responds to the query request of the user. Compared with the traditional sql query, the response speed of the Elastic Search query is higher, so that the waiting time of a user can be greatly reduced, and the use experience of the user is improved.
Drawings
In order to more clearly illustrate the technical solutions of the embodiments of the present invention, the drawings needed to be used in the description of the embodiments are briefly introduced below, and it is obvious that the drawings in the following description are some embodiments of the present invention, and it is obvious for those skilled in the art to obtain other drawings based on these drawings without creative efforts.
fig. 1 is a schematic view of an application scenario of a data query method according to an embodiment of the present invention;
FIG. 2 is a schematic flow chart of a data query method according to an embodiment of the present invention;
FIG. 3 is a schematic sub-flow chart of a data query method according to an embodiment of the present invention;
FIG. 4 is a schematic sub-flow chart of a data query method according to an embodiment of the present invention;
FIG. 5 is a schematic block diagram of a data query system provided by an embodiment of the present invention;
FIG. 6 is a schematic block diagram of a first storage unit of an ES server of a data query system according to an embodiment of the present invention;
FIG. 7 is a schematic block diagram of a first segmentation unit of an ES server of a data query system according to an embodiment of the present invention;
FIG. 8 is a schematic block diagram of a first obtaining unit of an ES server of a data query system according to an embodiment of the present invention;
FIG. 9 is a schematic block diagram of a query unit of an ES server of a data query system according to an embodiment of the present invention; and
fig. 10 is a schematic block diagram of a computer device according to an embodiment of the present invention.
Detailed Description
The technical solutions in the embodiments of the present invention will be clearly and completely described below with reference to the drawings in the embodiments of the present invention, and it is obvious that the described embodiments are some, not all, embodiments of the present invention. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present invention.
it will be understood that the terms "comprises" and/or "comprising," when used in this specification and the appended claims, specify the presence of stated features, integers, steps, operations, elements, and/or components, but do not preclude the presence or addition of one or more other features, integers, steps, operations, elements, components, and/or groups thereof.
It is also to be understood that the terminology used in the description of the invention herein is for the purpose of describing particular embodiments only and is not intended to be limiting of the invention. As used in the specification of the present invention and the appended claims, the singular forms "a," "an," and "the" are intended to include the plural forms as well, unless the context clearly indicates otherwise.
It should be further understood that the term "and/or" as used in this specification and the appended claims refers to and includes any and all possible combinations of one or more of the associated listed items.
As used in this specification and the appended claims, the term "if" may be interpreted contextually as "when", "upon" or "in response to a determination" or "in response to a detection". Similarly, the phrase "if it is determined" or "if a [ described condition or event ] is detected" may be interpreted contextually to mean "upon determining" or "in response to determining" or "upon detecting [ described condition or event ]" or "in response to detecting [ described condition or event ]".
referring to fig. 1 and fig. 2, fig. 1 is a schematic view of an application scenario of a data query method according to an embodiment of the present invention. Fig. 2 is a schematic flow chart of a data query method according to an embodiment of the present invention. The data query method is applied to a data query system. The data query system includes a business system server 80 and an ES server 90. If receiving the service data uploaded by the user side, the service system server 80 sends the service data to the ES server 90; the ES server 90 receives the service data and stores the service data in an ES database; if receiving a query request from a user side, the service system server 80 sends the query request to the ES server 90; the ES server 90 receives the query request, acquires corresponding service data from the ES database according to the query request, and sends the service data as a query result to the service system server 80; the service system server 80 receives the query result and sends the query result to the user side.
Fig. 2 is a schematic flow chart of a data query method according to an embodiment of the present invention. As shown, the method includes the following steps S1-S5.
And S1, if the service data uploaded by the user side is received, the service system server sends the service data to the ES server.
In specific implementation, if the service data uploaded by the user side is received, the service system server sends the service data to the ES server, so that the ES server stores the service data. The business data is the text data left by business personnel in the working process. The business system server is a server in a business system of an enterprise.
Note that the ES (Elastic Search engine) server is a server of Elastic Search. The Elastic Search is a very powerful open source Search and analysis engine based on Lucene, and can quickly find out related data information from mass data.
S2, the ES server receives the service data and stores the service data in an ES database.
in a specific implementation, the ES server stores the service data into an ES database when receiving the service data. The ES database is the database used by Elastic Search to store data.
Referring to FIG. 3, in one embodiment, the above step S12 specifically includes the following steps S21-S23.
s21, the ES server carries out word segmentation processing on the service data to obtain word segmentation results of the service data.
In specific implementation, the ES server performs word segmentation processing on the service data to obtain a word segmentation result of the service data. Word segmentation is a process of recombining continuous word sequences into word sequences according to a certain specification.
in an embodiment, the step S21 specifically includes: and the ES server performs word segmentation processing on the service data according to a preset word segmentation controller to obtain a word segmentation result of the service data. In this embodiment, the ES server performs a word segmentation process on the service data through the word segmentation controller.
S22, the ES server obtains the weight of each word of the word segmentation result of the business data.
in a specific implementation, the ES server obtains the weight of each word of the segmentation result of the service data. The weight represents the importance of each word in the business data.
In an embodiment, the step S22 specifically includes: and the ES server acquires the weight of each word of the word segmentation result of the service data according to a preset word segmentation controller. The word segmentation controller can not only perform word segmentation processing on the service data, but also calculate the weight of each word obtained by the word segmentation processing. Specifically, the segmentation controller determines the weight of each word according to its frequency of occurrence in the traffic data. Words with higher frequency are weighted more heavily.
S23, the ES server stores the service data, the word segmentation result of the service data and the weight of each word of the word segmentation result of the service data in an ES database.
in specific implementation, the ES server stores the service data, the segmentation result of the service data, and the weight of each word of the segmentation result of the service data in an ES database.
S3, if receiving the inquiry request from the user end, the service system server sends the inquiry request to the ES server.
in a specific implementation, if a query request of a user side is received, the service system server sends the query request to the ES server. And the ES server acquires a corresponding query result according to the query request.
s4, the ES server receives the query request, and acquires the corresponding service data from the ES database according to the query request as the query result and sends the query result to the service system server.
In specific implementation, the ES server receives the query request, and obtains corresponding service data from the ES database according to the query request, and sends the service data as a query result to the service system server.
referring to fig. 4, in an embodiment, the query request includes keywords, and the step S4 specifically includes the following steps S41-S42.
s41, the ES server obtains the characteristic service data from the ES database, and the word segmentation result of the characteristic service data comprises the keyword.
In a specific implementation, the ES server obtains the feature service data from the ES database, and it should be noted that the word segmentation result of the feature service data includes the service data of the keyword.
S42, the ES server sorts each feature service data according to the order of the weight of the keyword in each feature service data from high to low to obtain the query result.
In specific implementation, the ES server ranks each of the feature service data according to the order of the weight of the keyword in each of the feature service data from high to low to obtain the query result, so that the feature service data with the high weight of the keyword can be ranked in front of the query result, and a user can conveniently and quickly find data to be queried.
And S5, the service system server receives the query result and sends the query result to the user side.
in specific implementation, the service system server receives the query result and sends the query result to the user side.
according to the technical scheme of the embodiment of the invention, if the service data uploaded by the user side is received, the service system server sends the service data to the ES server; the ES server receives the service data and stores the service data into an ES database; if receiving a query request of a user side, the service system server sends the query request to the ES server; the ES server receives the query request, acquires corresponding service data from the ES database according to the query request, and sends the corresponding service data serving as a query result to a service system server; and the service system server receives the query result and sends the query result to the user side, so that the service data uploaded by the user can be stored in the Elastic Search, and the Elastic Search responds to the query request of the user. Compared with the traditional sql query, the response speed of the Elastic Search query is higher (the response can be performed within 1s, and the response speed is greatly improved compared with that in the prior art of 10 s), so that the waiting time of a user can be greatly reduced, and the use experience of the user is improved.
FIG. 5 is a schematic block diagram of a data query system 100 provided by an embodiment of the present invention. As shown in fig. 5, the present invention also provides a data query system 100 corresponding to the above data query method. Specifically, the data query system 100 includes a service system server 80 and an ES server 90, the service system server 80 includes a first sending unit 81, a second sending unit 82, and a third sending unit 83, and the ES server 90 includes a first storage unit 91 and a query unit 92, where:
a first sending unit 81, configured to send service data to an ES server if the service data uploaded by a user side is received;
A first storage unit 91, configured to receive the service data and store the service data in an ES database;
A second sending unit 82, configured to send, if an inquiry request of a user side is received, the inquiry request to the ES server;
the query unit 92 is configured to receive the query request, acquire corresponding service data from the ES database according to the query request, and send the service data as a query result to the service system server;
and a third sending unit 83, configured to receive the query result, and send the query result to the user side.
in one embodiment, as shown in fig. 6, the first storage unit 91 includes a first word segmentation unit 911, a first obtaining unit 912 and a second storage unit 913.
A first word segmentation unit 911, configured to perform word segmentation processing on the service data to obtain a word segmentation result of the service data;
A first obtaining unit 912, configured to obtain weights of words of a word segmentation result of the service data;
A second storage unit 913, configured to store the service data, the segmentation result of the service data, and the weight of each word of the segmentation result of the service data in an ES database.
in one embodiment, as shown in fig. 7, the first word segmentation unit 911 comprises a second word segmentation unit 9111.
A second word segmentation unit 9111, configured to perform word segmentation processing on the service data according to a preset word segmentation controller to obtain a word segmentation result of the service data.
In one embodiment, as shown in fig. 8, the first obtaining unit 912 includes a second obtaining unit 9121.
A second obtaining unit 9121, configured to obtain, according to a preset word segmentation controller, weights of words of a word segmentation result of the service data.
In an embodiment, as shown in fig. 9, the query unit 92 includes a third obtaining unit 921 and a sorting unit 922.
A third obtaining unit 921, configured to obtain feature service data from the ES database, where a word segmentation result of the feature service data includes the keyword;
The ranking unit 922 is configured to rank, according to the order from high to low of the weight of the keyword in each feature service data, each feature service data to obtain the query result.
it should be noted that, as can be clearly understood by those skilled in the art, the specific implementation processes of the data query system 100 and the units may refer to the corresponding descriptions in the foregoing method embodiments, and for convenience and brevity of description, no further description is provided herein.
The embodiment of the invention also provides a data query system, which comprises at least two computer devices, wherein each computer device comprises a service system server and at least one ES server. Referring to fig. 10, fig. 10 is a schematic block diagram of a computer device according to an embodiment of the present application. The computer device 500 may be the file encryption server or the user terminal, and the terminal may be an electronic device with a communication function, such as a smart phone, a tablet computer, a notebook computer, and a desktop computer.
Referring to fig. 10, the computer device 500 includes a processor 502, memory, and a network interface 505 connected by a system bus 501, where the memory may include a non-volatile storage medium 503 and an internal memory 504.
The non-volatile storage medium 503 may store an operating system 5031 and a computer program 5032. The computer program 5032, when executed, causes the processor 502 to perform a method of benchmarking.
The processor 502 is used to provide computing and control capabilities to support the operation of the overall computer device 500.
The internal memory 504 provides an environment for the execution of the computer program 5032 in the non-volatile storage medium 503, and when the computer program 5032 is executed by the processor 502, the processor 502 may be caused to execute a data query method.
The network interface 505 is used for network communication with other devices. Those skilled in the art will appreciate that the configuration shown in fig. 10 is a block diagram of only a portion of the configuration relevant to the present teachings and is not intended to limit the computing device 500 to which the present teachings may be applied, and that a particular computing device 500 may include more or less components than those shown, or may combine certain components, or have a different arrangement of components.
The processor 502 of the business system server and the ES server is configured to run the computer program 5032 stored in the memory, so as to implement the following steps:
If receiving the service data uploaded by the user side, the service system server sends the service data to the ES server;
the ES server receives the service data and stores the service data into an ES database;
if receiving a query request of a user side, the service system server sends the query request to the ES server;
The ES server receives the query request, acquires corresponding service data from the ES database according to the query request, and sends the corresponding service data serving as a query result to a service system server;
And the service system server receives the query result and sends the query result to the user side.
In an embodiment, when the processor 502 of the ES server implements the step of storing the service data in the ES database, the following steps are specifically implemented:
The ES server carries out word segmentation processing on the service data to obtain word segmentation results of the service data;
The ES server acquires the weight of each word of the word segmentation result of the service data;
and the ES server stores the service data, the word segmentation result of the service data and the weight of each word of the word segmentation result of the service data in an ES database.
In an embodiment, when implementing the step of performing, by the processor 502 of the ES server, word segmentation processing on the service data by the ES server to obtain a word segmentation result of the service data, the following steps are specifically implemented:
And the ES server performs word segmentation processing on the service data according to a preset word segmentation controller to obtain a word segmentation result of the service data.
In an embodiment, when implementing the step of acquiring the weight of each word of the segmentation result of the service data by the ES server, the processor 502 of the ES server specifically implements the following steps:
And the ES server acquires the weight of each word of the word segmentation result of the service data according to a preset word segmentation controller.
In an embodiment, the query request includes a keyword, and when the processor 502 of the ES server implements the step of acquiring corresponding service data from the ES database according to the query request as a query result and sending the query result to the service system server, the following steps are specifically implemented:
The ES server acquires characteristic service data from the ES database, wherein word segmentation results of the characteristic service data comprise the keywords;
and the ES server sorts the characteristic service data according to the weight of the keyword in the characteristic service data from high to low to obtain the query result.
it should be understood that, in the embodiment of the present Application, the Processor 502 may be a Central Processing Unit (CPU), and the Processor 502 may also be other general purpose processors, Digital Signal Processors (DSPs), Application Specific Integrated Circuits (ASICs), Field-Programmable Gate arrays (FPGAs) or other Programmable logic devices, discrete Gate or transistor logic devices, discrete hardware components, and the like. Wherein a general purpose processor may be a microprocessor or the processor may be any conventional processor or the like.
it will be understood by those skilled in the art that all or part of the flow of the method implementing the above embodiments may be implemented by a computer program instructing associated hardware. The computer program may be stored in a storage medium, which is a computer-readable storage medium. The computer program is executed by at least one processor in the computer system to implement the flow steps of the embodiments of the method described above.
Accordingly, the present invention also provides a storage medium. The storage medium may be a computer-readable storage medium. The storage medium stores a first computer program and a second computer program which, when executed by a processor of a business system server and a processor of an ES server, respectively, may implement the steps of:
if receiving the service data uploaded by the user side, the service system server sends the service data to the ES server;
The ES server receives the service data and stores the service data into an ES database;
If receiving a query request of a user side, the service system server sends the query request to the ES server;
the ES server receives the query request, acquires corresponding service data from the ES database according to the query request, and sends the corresponding service data serving as a query result to a service system server;
And the service system server receives the query result and sends the query result to the user side.
In an embodiment, when the processor of the ES server executes the second computer program to implement the step of storing the service data in the ES database, the following steps are specifically implemented:
The ES server carries out word segmentation processing on the service data to obtain word segmentation results of the service data;
the ES server acquires the weight of each word of the word segmentation result of the service data;
And the ES server stores the service data, the word segmentation result of the service data and the weight of each word of the word segmentation result of the service data in an ES database.
in an embodiment, when the processor of the ES server executes the second computer program to implement the step of performing, by the ES server, the word segmentation processing on the service data to obtain the word segmentation result of the service data, the following steps are specifically implemented:
and the ES server performs word segmentation processing on the service data according to a preset word segmentation controller to obtain a word segmentation result of the service data.
in an embodiment, when the processor of the ES server executes the second computer program to implement the step of obtaining, by the ES server, the weight of each word of the segmentation result of the service data, the following steps are specifically implemented:
And the ES server acquires the weight of each word of the word segmentation result of the service data according to a preset word segmentation controller.
in an embodiment, the query request includes a keyword, and when the processor of the ES server executes the second computer program to implement the step of acquiring the corresponding service data from the ES database according to the query request as a query result and sending the query result to the service system server, the following steps are specifically implemented:
the ES server acquires characteristic service data from the ES database, wherein word segmentation results of the characteristic service data comprise the keywords;
And the ES server sorts the characteristic service data according to the weight of the keyword in the characteristic service data from high to low to obtain the query result.
The storage medium is an entity and non-transitory storage medium, and may be various entity storage media capable of storing program codes, such as a usb disk, a removable hard disk, a Read-only memory (ROM), a magnetic disk, or an optical disk.
Those of ordinary skill in the art will appreciate that the elements and algorithm steps of the examples described in connection with the embodiments disclosed herein may be embodied in electronic hardware, computer software, or combinations of both, and that the components and steps of the examples have been described in a functional general in the foregoing description for the purpose of illustrating clearly the interchangeability of hardware and software. Whether such functionality is implemented as hardware or software depends upon the particular application and design constraints imposed on the implementation. Skilled artisans may implement the described functionality in varying ways for each particular application, but such implementation decisions should not be interpreted as causing a departure from the scope of the present invention.
In the embodiments provided in the present invention, it should be understood that the disclosed apparatus and method may be implemented in other ways. For example, the above-described apparatus embodiments are merely illustrative. For example, the division of each unit is only one logic function division, and there may be another division manner in actual implementation. For example, various elements or components may be combined or may be integrated into another system, or some features may be omitted, or not implemented.
the steps in the method of the embodiment of the invention can be sequentially adjusted, combined and deleted according to actual needs. The units in the device of the embodiment of the invention can be merged, divided and deleted according to actual needs. In addition, functional units in the embodiments of the present invention may be integrated into one processing unit, or each unit may exist alone physically, or two or more units are integrated into one unit.
the integrated unit, if implemented in the form of a software functional unit and sold or used as a stand-alone product, may be stored in a storage medium. Based on such understanding, the technical solution of the present invention essentially or partially contributes to the prior art, or all or part of the technical solution can be embodied in the form of a software product, which is stored in a storage medium and includes instructions for causing a computer device (which may be a personal computer, a terminal, or a network device) to execute all or part of the steps of the method according to the embodiments of the present invention.
In the above embodiments, the descriptions of the respective embodiments have respective emphasis, and for parts that are not described in detail in a certain embodiment, reference may be made to related descriptions of other embodiments.
it will be apparent to those skilled in the art that various changes and modifications may be made in the present invention without departing from the spirit and scope of the invention. Thus, while the invention has been described with respect to the above-described embodiments, it will be understood that the invention is not limited thereto but may be embodied with various modifications and changes.
while the invention has been described with reference to specific embodiments, the invention is not limited thereto, and various equivalent modifications and substitutions can be easily made by those skilled in the art within the technical scope of the invention. Therefore, the protection scope of the present invention shall be subject to the protection scope of the claims.
Claims (10)
1. a method for querying data, comprising:
if receiving the service data uploaded by the user side, the service system server sends the service data to the ES server;
the ES server receives the service data and stores the service data into an ES database;
if receiving a query request of a user side, the service system server sends the query request to the ES server;
the ES server receives the query request, acquires corresponding service data from the ES database according to the query request, and sends the corresponding service data serving as a query result to a service system server;
And the service system server receives the query result and sends the query result to the user side.
2. The data query method of claim 1, wherein the storing the service data in an ES database comprises:
the ES server carries out word segmentation processing on the service data to obtain word segmentation results of the service data;
the ES server acquires the weight of each word of the word segmentation result of the service data;
And the ES server stores the service data, the word segmentation result of the service data and the weight of each word of the word segmentation result of the service data in an ES database.
3. the data query method of claim 2, wherein the ES server performs a word segmentation process on the service data to obtain a word segmentation result of the service data, and the method comprises:
And the ES server performs word segmentation processing on the service data according to a preset word segmentation controller to obtain a word segmentation result of the service data.
4. the data query method of claim 3, wherein the step of obtaining the weight of each word of the segmentation result of the service data by the ES server comprises:
And the ES server acquires the weight of each word of the word segmentation result of the service data according to a preset word segmentation controller.
5. The data query method of claim 2, wherein the query request includes a keyword, and the obtaining of the corresponding service data from the ES database according to the query request is sent to a service system server as a query result, including:
The ES server acquires characteristic service data from the ES database, wherein word segmentation results of the characteristic service data comprise the keywords;
And the ES server sorts the characteristic service data according to the weight of the keyword in the characteristic service data from high to low to obtain the query result.
6. The data query system is characterized by comprising a service system server and an ES server, wherein the service system server comprises a first sending unit, a second sending unit and a third sending unit, the ES server comprises a first storage unit and a query unit, and the data query system comprises:
The first sending unit is used for sending the service data to the ES server if the service data uploaded by the user side is received;
The first storage unit is used for receiving the service data and storing the service data into an ES database;
the second sending unit is used for sending the query request to the ES server if the query request of the user side is received;
the query unit is used for receiving the query request, acquiring corresponding service data from the ES database according to the query request, and sending the service data serving as a query result to a service system server;
And the third sending unit is used for receiving the query result and sending the query result to the user side.
7. The data query system of claim 6, wherein the first storage unit comprises:
the first word segmentation unit is used for carrying out word segmentation processing on the service data to obtain a word segmentation result of the service data;
the first acquisition unit is used for acquiring the weight of each word of the word segmentation result of the service data;
And the second storage unit is used for storing the service data, the word segmentation result of the service data and the weight of each word of the word segmentation result of the service data into an ES database.
8. the data query system of claim 7, wherein the first segmentation unit comprises:
and the second word segmentation unit is used for performing word segmentation processing on the service data according to a preset word segmentation controller so as to obtain a word segmentation result of the service data.
9. A data query system, comprising a business system server and an ES server, each comprising a memory, a processor and a computer program stored on the memory and executable on the processor, wherein the processors of the business system server and the ES server together implement the method of any one of claims 1-5 when the respective computer programs are executed.
10. A computer-readable storage medium, characterized in that the storage medium stores a first computer program and a second computer program which, when executed by processors of a business system server and an ES server, respectively, implement the method according to any one of claims 1-5.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910875815.7A CN110569268A (en) | 2019-09-17 | 2019-09-17 | data query method, system and computer readable storage medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910875815.7A CN110569268A (en) | 2019-09-17 | 2019-09-17 | data query method, system and computer readable storage medium |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN110569268A true CN110569268A (en) | 2019-12-13 |
Family
ID=68780596
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201910875815.7A Pending CN110569268A (en) | 2019-09-17 | 2019-09-17 | data query method, system and computer readable storage medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN110569268A (en) |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111159524A (en) * | 2019-12-30 | 2020-05-15 | 北京同邦卓益科技有限公司 | Monitoring method and system, and storage medium |
| CN111816287A (en) * | 2020-07-19 | 2020-10-23 | 贵州精准健康数据有限公司 | Regional ultrasonic dynamic consultation system |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| GB201416921D0 (en) * | 2014-09-25 | 2014-11-12 | Ibm | A method of processing a message received by a message server and a message server |
| CN107229714A (en) * | 2017-05-31 | 2017-10-03 | 杭州宇为科技有限公司 | A kind of full-text search engine based on distributed data base |
| CN108021688A (en) * | 2017-12-15 | 2018-05-11 | 北京明朝万达科技股份有限公司 | A kind of data processing method and device |
| CN110109948A (en) * | 2019-04-25 | 2019-08-09 | 数译(成都)信息技术有限公司 | Data query method, computer equipment and computer readable storage medium |
| CN110222252A (en) * | 2019-06-14 | 2019-09-10 | 宜春宜联科技有限公司 | Information retrieval method, device and equipment |
-
2019
- 2019-09-17 CN CN201910875815.7A patent/CN110569268A/en active Pending
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| GB201416921D0 (en) * | 2014-09-25 | 2014-11-12 | Ibm | A method of processing a message received by a message server and a message server |
| CN107229714A (en) * | 2017-05-31 | 2017-10-03 | 杭州宇为科技有限公司 | A kind of full-text search engine based on distributed data base |
| CN108021688A (en) * | 2017-12-15 | 2018-05-11 | 北京明朝万达科技股份有限公司 | A kind of data processing method and device |
| CN110109948A (en) * | 2019-04-25 | 2019-08-09 | 数译(成都)信息技术有限公司 | Data query method, computer equipment and computer readable storage medium |
| CN110222252A (en) * | 2019-06-14 | 2019-09-10 | 宜春宜联科技有限公司 | Information retrieval method, device and equipment |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111159524A (en) * | 2019-12-30 | 2020-05-15 | 北京同邦卓益科技有限公司 | Monitoring method and system, and storage medium |
| CN111816287A (en) * | 2020-07-19 | 2020-10-23 | 贵州精准健康数据有限公司 | Regional ultrasonic dynamic consultation system |
| CN111816287B (en) * | 2020-07-19 | 2023-12-15 | 贵州精准健康数据有限公司 | Regional ultrasonic dynamic consultation system |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN107679081B (en) | Information modification method and device, computer equipment and computer readable storage medium | |
| JP5575902B2 (en) | Information retrieval based on query semantic patterns | |
| US8725721B2 (en) | Personalizing scoping and ordering of object types for search | |
| CN109858528B (en) | Recommendation system training method and device, computer equipment and storage medium | |
| US20200110842A1 (en) | Techniques to process search queries and perform contextual searches | |
| US9116879B2 (en) | Dynamic rule reordering for message classification | |
| US10162868B1 (en) | Data mining system for assessing pairwise item similarity | |
| JP6929445B2 (en) | Evaluation device | |
| WO2018195105A1 (en) | Document similarity analysis | |
| CN110968765B (en) | Book searching method, computing device and computer storage medium | |
| US10509716B2 (en) | Automated recovery of flighted features based on service requests | |
| CN110705245A (en) | Method and device for acquiring reference processing scheme and storage medium | |
| CN109871368B (en) | Database detection method, database detection device, computer device and storage medium | |
| CN110569268A (en) | data query method, system and computer readable storage medium | |
| JP2017535866A (en) | Offline evaluation of ranking functions | |
| CN106874332B (en) | Database access method and device | |
| WO2019042165A1 (en) | Search result optimization method and apparatus, server, and readable storage medium | |
| JP2017219899A (en) | Knowledge search device, knowledge search method and knowledge search program | |
| CN103473290B (en) | The processing method and processing device of the attribute data of point of interest | |
| US20230205760A1 (en) | Multiple index scans | |
| US20180276294A1 (en) | Information processing apparatus, information processing system, and information processing method | |
| CN114020813A (en) | Data comparison method, device and equipment based on Hash algorithm and storage medium | |
| CN110515967B (en) | Spark calculation framework-based data analysis method and electronic equipment | |
| US8880546B1 (en) | System, method, and computer program for refining a set of keywords utilizing historical activity thresholds | |
| CN111159229A (en) | Data query method and device |
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 | ||
| RJ01 | Rejection of invention patent application after publication | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20191213 |