CN111159217A - Data query method, device, server and storage medium - Google Patents
Data query method, device, server and storage medium Download PDFInfo
- Publication number
- CN111159217A CN111159217A CN201911390200.1A CN201911390200A CN111159217A CN 111159217 A CN111159217 A CN 111159217A CN 201911390200 A CN201911390200 A CN 201911390200A CN 111159217 A CN111159217 A CN 111159217A
- Authority
- CN
- China
- Prior art keywords
- query
- field
- service
- dimensions
- inquiry
- 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 42
- 238000013507 mapping Methods 0.000 claims description 48
- 238000004590 computer program Methods 0.000 claims description 7
- 238000012163 sequencing technique Methods 0.000 claims description 4
- 238000012545 processing Methods 0.000 abstract description 6
- 239000002699 waste material Substances 0.000 abstract description 4
- 238000010586 diagram Methods 0.000 description 4
- 230000008878 coupling Effects 0.000 description 3
- 238000010168 coupling process Methods 0.000 description 3
- 238000005859 coupling reaction Methods 0.000 description 3
- 238000004891 communication Methods 0.000 description 2
- 230000000694 effects Effects 0.000 description 2
- 238000003491 array Methods 0.000 description 1
- 230000009286 beneficial effect Effects 0.000 description 1
- 235000019800 disodium phosphate Nutrition 0.000 description 1
- 238000005516 engineering process Methods 0.000 description 1
- 230000003287 optical effect Effects 0.000 description 1
- 238000012360 testing method Methods 0.000 description 1
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/24—Querying
- G06F16/242—Query formulation
- G06F16/2428—Query predicate definition using graphical user interfaces, including menus and forms
-
- 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/248—Presentation of query results
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- Computational Linguistics (AREA)
- Data Mining & Analysis (AREA)
- Databases & Information Systems (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Human Computer Interaction (AREA)
- Mathematical Physics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention provides a data query method, a data query device, a server and a storage medium, and relates to the technical field of data processing. The method comprises the following steps: receiving an inquiry request sent by a requester, wherein the inquiry request comprises: an identification and query field of a query service; determining a plurality of query dimensions corresponding to the query service according to the identifier of the query service; inquiring from the service data tables corresponding to the plurality of inquiry dimensions according to the inquiry fields to obtain inquiry results of the inquiry fields; and sending the query result of the query field to the requester. According to the query fields, the business data tables corresponding to the query dimensions are queried respectively to obtain query results of the query fields, so that the query duration is shortened, the query efficiency is improved, and unnecessary waste of human resources is reduced.
Description
Technical Field
The invention relates to the technical field of data processing, in particular to a data query method, a data query device, a server and a storage medium.
Background
With the advent of the information age, the data volume is becoming larger, a large amount of data can be stored in a plurality of devices through a data table, and it becomes necessary to query information in the devices to obtain required data from the large amount of data.
In the related technology, pre-query information is determined, information related to the pre-query information is searched from different files manually, and the same type of information is classified and sorted.
However, in the related art, unnecessary human resources are wasted by searching and sorting different files manually, the problem of too long query time also occurs, and the speed of searching related information is reduced.
Disclosure of Invention
The present invention aims to provide a data query method, device, server and storage medium to solve the problems of unnecessary human resources waste, too long query time and reduced speed in searching for relevant information in the related art by manually searching and sorting different files.
In order to achieve the above purpose, the embodiment of the present invention adopts the following technical solutions:
in a first aspect, an embodiment of the present invention provides a data query method, including:
receiving an inquiry request sent by a requester, wherein the inquiry request comprises: an identification and query field of a query service;
determining a plurality of query dimensions corresponding to the query service according to the identifier of the query service;
inquiring from a service data table corresponding to a plurality of inquiry dimensions according to the inquiry field to obtain an inquiry result of the inquiry field;
and sending the query result of the query field to the requester.
Further, before querying from the service data tables corresponding to the query dimensions according to the query field and obtaining a query result of the query field, the method further includes:
sending the information of the plurality of query dimensions to the requester so that the requester can display the information of the plurality of query dimensions;
receiving a query dimension selection message sent by the requester, wherein the query dimension selection message comprises: the requester selects a target query dimension from the plurality of query dimensions according to an input selection operation;
the querying from the service data table corresponding to the plurality of query dimensions according to the query field to obtain a query result of the query field includes:
and inquiring from a business data table corresponding to the target inquiry dimension according to the inquiry field to obtain an inquiry result of the inquiry field.
Further, the query result of the query field includes: the query dimension corresponding to the query field and the query data of the query field in the corresponding query dimension.
Further, before receiving the query request sent by the requester, the method further includes:
and configuring a plurality of query dimensions corresponding to the query service and at least one business data table corresponding to each query dimension according to preset query configuration parameters.
Further, before receiving the query request sent by the requester, the method further includes:
configuring a query mapping definition corresponding to the query service; the query field defines any type of field configured for the query mapping.
Further, the query mapping definition includes at least one of: index field mapping definition, time field mapping definition, description field mapping definition, position field mapping definition and sequencing field mapping definition;
correspondingly, the query field includes at least one of the following: index field, time field, description field, location field, sort field.
In a second aspect, an embodiment of the present invention further provides a data query apparatus, where the apparatus includes:
a first receiving module, configured to receive an inquiry request sent by a requester, where the inquiry request includes: an identification and query field of a query service;
the determining module is used for determining a plurality of query dimensions corresponding to the query service according to the identifier of the query service;
the query module is used for querying from the service data tables corresponding to the query dimensions according to the query fields to obtain query results of the query fields;
and the first sending module is used for sending the query result of the query field to the requester.
Further, the apparatus further comprises:
a second sending module, configured to send the information of the multiple query dimensions to the requestor, so that the requestor displays the information of the multiple query dimensions;
a second receiving module, configured to receive a query dimension selection message sent by the requestor, where the query dimension selection message includes: the requester selects a target query dimension from the plurality of query dimensions according to an input selection operation;
and the query module is also used for querying from the business data table corresponding to the target query dimension according to the query field to obtain a query result of the query field.
Further, the query result of the query field includes: the query dimension corresponding to the query field and the query data of the query field in the corresponding query dimension.
Further, the apparatus further comprises:
and the first configuration module is used for configuring a plurality of query dimensions corresponding to the query service and at least one business data table corresponding to each query dimension according to preset query configuration parameters.
Further, the apparatus further comprises:
the second configuration module is used for configuring the query mapping definition corresponding to the query service; the query field defines any type of field configured for the query mapping.
Further, the query mapping definition includes at least one of: index field mapping definition, time field mapping definition, description field mapping definition, position field mapping definition and sequencing field mapping definition;
correspondingly, the query field includes at least one of the following: index field, time field, description field, location field, sort field.
In a third aspect, an embodiment of the present invention further provides a server, including: a memory storing a computer program executable by the processor, and a processor implementing the method of any of the first aspects when executing the computer program.
In a fourth aspect, an embodiment of the present invention further provides a storage medium, where a computer program is stored on the storage medium, and when the computer program is read and executed, the method of any one of the above first aspects is implemented.
The invention has the beneficial effects that: the embodiment of the invention provides a data query method, which receives a query request sent by a requester, wherein the query request comprises the following steps: an identification and query field of a query service; determining a plurality of query dimensions corresponding to the query service according to the identifier of the query service; inquiring from the service data tables corresponding to the plurality of inquiry dimensions according to the inquiry fields to obtain inquiry results of the inquiry fields; and sending the query result of the query field to the requester. According to the query fields, the business data tables corresponding to the query dimensions are queried respectively to obtain query results of the query fields, so that the query duration is shortened, the query efficiency is improved, and unnecessary waste of human resources is reduced.
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 embodiments will be briefly described below, it should be understood that the following drawings only illustrate some embodiments of the present invention and therefore should not be considered as limiting the scope, and for those skilled in the art, other related drawings can be obtained according to the drawings without inventive efforts.
Fig. 1 is a schematic flowchart 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 structural diagram of a data query device according to an embodiment of the present invention;
fig. 4 is a schematic structural diagram of a server according to an embodiment of the present invention.
Detailed Description
In order to make the objects, technical solutions and advantages of the embodiments of the present invention clearer, 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, but not all, embodiments of the present invention.
According to the data query method provided by the embodiment of the invention, the execution main body can be a server.
Fig. 1 is a schematic flowchart of a data query method according to an embodiment of the present invention, as shown in fig. 1, the method may include:
s101, receiving an inquiry request sent by a requester.
Wherein, the query request may include: an identification of the query service and a query field.
In some embodiments, a user may perform an input operation on a requester, and the requester may determine a query request according to the input operation and send the query request to a server, and accordingly, the server may receive the query request through a preset service interface.
It should be noted that, the requesting party may present an input interface to the user, and the input interface may include: prompt information for prompting the user for the type of query field that should be entered. For example, the user may be prompted to enter an identification number or license plate number, etc.
In addition, the requesting party may be a terminal, and the terminal may be a computer device, for example, a mobile phone, a computer, a tablet computer, and other computer devices, which is not limited in this embodiment of the present invention.
S102, determining a plurality of query dimensions corresponding to the query service according to the identifier of the query service.
In the implementation of the present invention, the server may store a plurality of preset identifiers, each preset identifier has a plurality of corresponding dimensions, and the server may traverse the plurality of preset identifiers to determine the identifier of the query service from the plurality of preset identifiers, and then determine the plurality of dimensions corresponding to the query service.
For example, for an identifier of a query service, the corresponding multiple dimensions may be dimensions of a name, an educational experience, a work experience, and the like. Of course, dimensions of interest, specialties, asset condition, etc. may also be included.
In addition, for different query services, the corresponding people may be the same, but the dimensions may be different. For example, the dimensions of name, education experience, work experience and the like can belong to an identifier A of one query service, the dimensions of interest, speciality, asset condition and the like can belong to an identifier B of another query service, and the persons corresponding to A and B can be a1, a2 and a 3.
Of course, the corresponding personnel may be different for different query services, but the dimensions may be the same. For example, the identity of the query service, a, and the identity of the query service, B, may each include: the dimensions of name, educational experience, work experience, interest, speciality, asset condition and the like, the person corresponding to A can be a1, a2 and a3, and the person corresponding to B can be B1, B2 and B3.
S103, according to the query field, querying from the service data table corresponding to the plurality of query dimensions to obtain a query result of the query field.
Wherein, each query dimension can have at least one business data table, each business data table can include an index item, and the type of the index item can be the same as that of the query field.
In one possible implementation, the index entry in the business data table is traversed, the field which is the same as the query field is determined, and the information which is associated with the field and has the same type as the query dimension is searched for as the query result. The method is adopted to inquire at least one service data table corresponding to each inquiry dimension to obtain the inquiry result of the inquiry field.
For example, the type of the query field is an identity number, the query dimension may include a name, the business data table corresponding to the query dimension may be a household register table, the index entry of the business data table is the identity number, the index entry is traversed to determine a field identical to the query field, and the information associated with the field may include: name: x, native place: y, age: z, and the information with the same type as the query dimension is a name, x can be used as the query result of the household registration form.
And S104, sending the query result of the query field to the requester.
In the embodiment of the invention, the server can send the query result to the requester through the preset service interface, and correspondingly, the requester can receive the query result and display the query result so that the user can know the query result, thereby querying the information associated with the query field in different business data tables.
In summary, an embodiment of the present invention provides a data query method, which receives a query request sent by a requestor, where the query request includes: an identification and query field of a query service; determining a plurality of query dimensions corresponding to the query service according to the identifier of the query service; inquiring from the service data tables corresponding to the plurality of inquiry dimensions according to the inquiry fields to obtain inquiry results of the inquiry fields; and sending the query result of the query field to the requester. According to the query fields, the business data tables corresponding to the query dimensions are queried respectively to obtain query results of the query fields, so that the query duration is shortened, the query efficiency is improved, and unnecessary waste of human resources is reduced.
Optionally, the query result of the query field includes: the query dimension corresponding to the query field and the query data of the query field in the corresponding query dimension.
For at least one service data table of one query dimension, each service data table has a corresponding query result, and the server can establish a mapping relation between each query dimension and the query result of the corresponding at least one service data table.
Optionally, each service data table may have a corresponding query term, and the server may determine a query dimension, determine at least one query term of the query dimension, and then determine the service data table corresponding to each query term.
In addition, the server can package a plurality of query dimensions and the query result corresponding to each query dimension to obtain the query result of the query field.
Fig. 2 is a schematic flowchart of a data query method according to an embodiment of the present invention, as shown in fig. 2, optionally, before S103, the method may further include:
s201, sending information of a plurality of query dimensions to a requester so that the requester can display the information of the plurality of query dimensions.
The information of the plurality of query dimensions may include: a plurality of query dimensions, and specification information for each query dimension. The specification information of the query dimension may include: index object, index variable name and index content, etc.
For example, the identification of the query service may be: 168, the query service identifies a corresponding plurality of query dimensions, which may include dimensions such as "name", "education", "works", and the like. The description information 168 may include: "name", "reduction", and "works".
It should be noted that the description information corresponding to "name" may include: indexing the object: name, index variable name: sfzh, index content: identity card number. The description information corresponding to "education" may include: indexing the object: the study calendar, index variable name is: sfzh, index content: identity card number. The description information corresponding to "works" may include: indexing the object: work object, index variable name: sfzh, index content: identity card number.
In some embodiments, a user may input an identifier of a query service in a requestor, a server may determine a plurality of query dimensions corresponding to the query service according to the identifier of the query service, and send information of the plurality of query dimensions to the requestor, and the requestor may receive the information of the query dimensions and display the information of the query dimensions to the user.
S202, receiving a query dimension selection message sent by a requester.
Wherein querying the dimension selection message comprises: the requestor selects a target query dimension from the plurality of query dimensions according to the input selection operation.
In one possible implementation, a user may perform a selection operation from a plurality of query dimensions presented by a requestor to select a target query dimension and enter a query field. The number of target query dimensions is not specifically limited in the embodiments of the present invention. When the user selects each query dimension, the number of query dimensions is the same as the number of target query dimensions.
For example, when the query dimensions include dimensions such as "name", "education", "works", "interest", "Speciality", "assetstructs", etc., the target query dimensions selected by the user may be dimensions such as name, educational experience, work experience, etc.
The step S103 may further include:
s203, according to the query field, querying from the business data table corresponding to the target query dimension to obtain a query result of the query field.
In some embodiments, the server may determine at least one service data table corresponding to each target query dimension, query from the determined service data table according to the query field to obtain a query result of each service data table, and establish a mapping relationship between the target query dimension and the query result to obtain the query result of the query field.
For example, when the target query dimension is a dimension such as "name", "education", "works", and the like, the business data table corresponding to "name" may include: household register table, school register table and social security table. The service data table corresponding to "education" may include: the school address table, the business data table corresponding to "works" may include: social security record table.
The query field may be 1924 × 1561 (identity card number), and for the "name" dimension, the query result corresponding to the household table may be: the 'Li Shuaishui' can be obtained by the server, the query result corresponding to the school entry table can be 'Li Dashuai', the query result corresponding to the social security table can be 'Li Shuaishuai', and the server can establish mapping between 'name' and 'Li Shuai', 'Li Dashuai' and 'Li Shuaishuai'.
For the dimension of "education", the query results corresponding to the student status table can be "primary school", "junior middle school" and "high school", and the server can establish mapping between "education" and "primary school", "junior middle school" and "high school".
For the dimension of "works", the query result corresponding to the social security record table may be "enterprise 1" or "enterprise 2", and the server may establish a mapping between "works" and "enterprise 1" or "enterprise 2".
In summary, the query result of the query field may be: name ": "lituashuai", "lituashuai"; "education" and "elementary school", "junior middle school" and "senior middle school"; "works": "Enterprise 1" and "Enterprise 2".
In the embodiment of the present invention, when the identifier of the query service is 168, the query request may be represented as http: xxx: 8080/xxxxxx? query id 168. When the query service is identified as "168" and the query field is "1924 × 1561", the query request may be expressed as http: xxx: 8080/xxxxxx? query id 168& sfzh 1924 & 1561. Wherein, "xxx: 8080/xxxxxx "is the service name," query id "is the identifier of the query service, and" sfzh 1924 × 1561 "is the query field.
Optionally, before the step S101, the method may further include: and configuring a plurality of query dimensions corresponding to the query service and at least one business data table corresponding to each query dimension according to preset query configuration parameters.
In a possible implementation manner, each query service may have a corresponding identifier, and the server may configure a plurality of query dimensions for each query service according to preset query configuration parameters, configure at least one query term for each query dimension, and configure one service data table for each query term.
In addition, the server may also configure an index column, an index value, a query result column, and the like in each service data table. In one query dimension, the query result columns of different business data tables may be the same, i.e., the query result columns match the corresponding query dimension.
When the query dimension is a name, the query result column of each business data table in the query dimension is a name, when the query dimension is an education history, the query result column of each business data table in the query dimension is an academic calendar, and when the query dimension is a work, the query result column of each business data table in the query dimension is a company name.
For example, query terms configured by the query dimension "name" may include "query 1" (query), "query 2", and "query 3". The service data table configured by the query1 may be a "home table", the configured index column may be "sfzh" (identity card number), the configured index value is "sfzh", and the query result is "name". Query terms configured by the query dimension "education" may include "query 4". The service data table configured by the query4 may be a "school address table", the configured index column may be "sfzh" (identity card number), the configured index value is "sfzh", and the query result is "xl" (academic calendar). The service data table configured by the query5 may be a social security record table, the configured index column may be sfzh (identity number), the configured index value is sfzh, and the query result is company (company name).
It should be noted that, in one query dimension, the service data tables configured by different query terms may be different. The service data table configured by the query item can be the same between different query dimensions.
In summary, according to the preset query configuration parameters, a plurality of query dimensions corresponding to the query service and at least one service data table corresponding to each query dimension are configured, so that the server can perform query according to the identifier and the query field of the query service based on the query dimensions and the service data tables. The query dimensionality and the service data table are constructed in a configuration mode, processes such as codes and tests are not needed, and the efficiency of constructing the query dimensionality and the service data table is improved.
Optionally, before the step S101, the method may further include: and configuring a query mapping definition corresponding to the query service, wherein the query field can be any type of field configured by the query mapping definition.
Wherein, the index entry in the service data table may be the same as the type of the query field. The server can also determine the index item according to the query field after acquiring the query field.
In the embodiment of the present invention, each query term may have a corresponding database, the server may configure a query mapping definition for each query term, and the server may screen data in the database corresponding to the query term according to the query mapping definition corresponding to the query term, to obtain the service data table corresponding to the query term.
Optionally, the query mapping definition includes at least one of the following: an index field mapping definition, a time field mapping definition, a description field mapping definition, a location field mapping definition, an order field mapping definition. Correspondingly, the query field includes at least one of the following: index field, time field, description field, location field, sort field.
The location field may include, among other fields, longitude and latitude.
In the embodiment of the invention, the data in the database corresponding to the query item is screened according to the query mapping definition corresponding to the query item to obtain the business data table corresponding to the query item, so that the data in the business data table is more targeted.
Fig. 3 is a schematic structural diagram of a data query apparatus according to an embodiment of the present invention, and as shown in fig. 3, the apparatus may include:
a first receiving module 301, configured to receive an inquiry request sent by a requester, where the inquiry request includes: an identification and query field of a query service;
a determining module 302, configured to determine, according to the identifier of the query service, a plurality of query dimensions corresponding to the query service;
the query module 303 is configured to query the service data tables corresponding to the multiple query dimensions according to the query field to obtain a query result of the query field;
a first sending module 304, configured to send the query result of the query field to the requester.
Optionally, the apparatus further comprises:
the second sending module is used for sending the information of the plurality of query dimensions to the requester so that the requester can display the information of the plurality of query dimensions;
a second receiving module, configured to receive a query dimension selection message sent by a requestor, where the query dimension selection message includes: the requester selects a target query dimension from the plurality of query dimensions according to the input selection operation;
the query module 303 is further configured to query the service data table corresponding to the target query dimension according to the query field to obtain a query result of the query field.
Optionally, the query result of the query field includes: the query dimension corresponding to the query field and the query data of the query field in the corresponding query dimension.
Optionally, the apparatus further comprises:
the first configuration module is used for configuring a plurality of query dimensions corresponding to the query service and at least one service data table corresponding to each query dimension according to preset query configuration parameters.
Optionally, the apparatus further comprises:
the second configuration module is used for configuring the query mapping definition corresponding to the query service; the query field defines any type of field configured for the query mapping.
Optionally, the query mapping definition includes at least one of the following: index field mapping definition, time field mapping definition, description field mapping definition, position field mapping definition and sequencing field mapping definition;
correspondingly, the query field includes at least one of the following: index field, time field, description field, location field, sort field.
The above-mentioned apparatus is used for executing the method provided by the foregoing embodiment, and the implementation principle and technical effect are similar, which are not described herein again.
These above modules may be one or more integrated circuits configured to implement the above methods, such as: one or more Application Specific Integrated Circuits (ASICs), or one or more microprocessors (DSPs), or one or more Field Programmable Gate Arrays (FPGAs), among others. For another example, when one of the above modules is implemented in the form of a processing element scheduler code, the processing element may be a general-purpose processor, such as a Central Processing Unit (CPU) or other processor capable of calling program code. For another example, these modules may be integrated together and implemented in the form of a system-on-a-chip (SOC).
Fig. 4 is a schematic structural diagram of a server according to an embodiment of the present invention, where the server may include: a processor 401, a memory 402.
The memory 402 is used for storing programs, and the processor 401 calls the programs stored in the memory 402 to execute the above-mentioned method embodiments. The specific implementation and technical effects are similar, and are not described herein again.
Optionally, the invention also provides a program product, for example a computer-readable storage medium, comprising a program which, when being executed by a processor, is adapted to carry out the above-mentioned method embodiments.
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, and for example, the division of the units is only one logical division, and other divisions may be realized in practice, for example, a plurality of units or components may be combined or integrated into another system, or some features may be omitted, or not executed. In addition, the shown or discussed mutual coupling or direct coupling or communication connection may be an indirect coupling or communication connection through some interfaces, devices or units, and may be in an electrical, mechanical or other form.
The units described as separate parts may or may not be physically separate, and parts displayed as units may or may not be physical units, may be located in one place, or may be distributed on a plurality of network units. Some or all of the units can be selected according to actual needs to achieve the purpose of the solution of the embodiment.
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 can be realized in a form of hardware, or in a form of hardware plus a software functional unit.
The integrated unit implemented in the form of a software functional unit may be stored in a computer readable storage medium. The software functional unit is stored in a storage medium and includes several instructions to enable a computer device (which may be a personal computer, a server, or a network device) or a processor (processor) to execute some steps of the methods according to the embodiments of the present invention. And the aforementioned storage medium includes: a U disk, a removable hard disk, a Read-Only Memory (ROM), a Random Access Memory (RAM), a magnetic disk or an optical disk, and other various media capable of storing program codes.
Claims (10)
1. A method for querying data, comprising:
receiving an inquiry request sent by a requester, wherein the inquiry request comprises: an identification and query field of a query service;
determining a plurality of query dimensions corresponding to the query service according to the identifier of the query service;
inquiring from a service data table corresponding to a plurality of inquiry dimensions according to the inquiry field to obtain an inquiry result of the inquiry field;
and sending the query result of the query field to the requester.
2. The method of claim 1, wherein before the query is performed from the service data tables corresponding to the plurality of query dimensions according to the query field and the query result of the query field is obtained, the method further comprises:
sending the information of the plurality of query dimensions to the requester so that the requester can display the information of the plurality of query dimensions;
receiving a query dimension selection message sent by the requester, wherein the query dimension selection message comprises: the requester selects a target query dimension from the plurality of query dimensions according to an input selection operation;
the querying from the service data table corresponding to the plurality of query dimensions according to the query field to obtain a query result of the query field includes:
and inquiring from a business data table corresponding to the target inquiry dimension according to the inquiry field to obtain an inquiry result of the inquiry field.
3. The method of claim 1, wherein the query result for the query field comprises: the query dimension corresponding to the query field and the query data of the query field in the corresponding query dimension.
4. The method of claim 1, wherein prior to receiving the query request sent by the requestor, the method further comprises:
and configuring a plurality of query dimensions corresponding to the query service and at least one business data table corresponding to each query dimension according to preset query configuration parameters.
5. The method of any of claims 1-4, wherein prior to receiving the query request sent by the requestor, the method further comprises:
configuring a query mapping definition corresponding to the query service; the query field defines any type of field configured for the query mapping.
6. The method of claim 5, wherein the query mapping definition comprises at least one of: index field mapping definition, time field mapping definition, description field mapping definition, position field mapping definition and sequencing field mapping definition;
correspondingly, the query field includes at least one of the following: index field, time field, description field, location field, sort field.
7. A data query apparatus, characterized in that the apparatus comprises:
a first receiving module, configured to receive an inquiry request sent by a requester, where the inquiry request includes: an identification and query field of a query service;
the determining module is used for determining a plurality of query dimensions corresponding to the query service according to the identifier of the query service;
the query module is used for querying from the service data tables corresponding to the query dimensions according to the query fields to obtain query results of the query fields;
and the first sending module is used for sending the query result of the query field to the requester.
8. The apparatus of claim 7, wherein the apparatus further comprises:
a second sending module, configured to send the information of the multiple query dimensions to the requestor, so that the requestor displays the information of the multiple query dimensions;
a second receiving module, configured to receive a query dimension selection message sent by the requestor, where the query dimension selection message includes: the requester selects a target query dimension from the plurality of query dimensions according to an input selection operation;
and the query module is also used for querying from the business data table corresponding to the target query dimension according to the query field to obtain a query result of the query field.
9. A server, comprising: a memory storing a computer program executable by the processor, and a processor implementing the method of any of the preceding claims 1-6 when executing the computer program.
10. A storage medium having stored thereon a computer program which, when read and executed, implements the method of any of claims 1-6.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201911390200.1A CN111159217A (en) | 2019-12-27 | 2019-12-27 | Data query method, device, server and storage medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201911390200.1A CN111159217A (en) | 2019-12-27 | 2019-12-27 | Data query method, device, server and storage medium |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN111159217A true CN111159217A (en) | 2020-05-15 |
Family
ID=70559306
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201911390200.1A Pending CN111159217A (en) | 2019-12-27 | 2019-12-27 | Data query method, device, server and storage medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN111159217A (en) |
Cited By (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112434060A (en) * | 2020-12-09 | 2021-03-02 | 北京有竹居网络技术有限公司 | Data query method and system |
| CN113254547A (en) * | 2021-05-27 | 2021-08-13 | 北京达佳互联信息技术有限公司 | Data query method, device, server and storage medium |
| CN115314751A (en) * | 2022-08-08 | 2022-11-08 | 北京达佳互联信息技术有限公司 | Data processing method and device, electronic equipment and storage medium |
| US20220398244A1 (en) * | 2021-09-23 | 2022-12-15 | Beijing Baidu Netcom Science Technology Co., Ltd. | Query method and device and storage medium |
Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20110270867A1 (en) * | 2010-04-30 | 2011-11-03 | International Business Machines Corporation | Web service discovery via data abstraction model |
| CN106326428A (en) * | 2016-08-24 | 2017-01-11 | 华青融天（北京）技术股份有限公司 | Data processing method and device |
| CN107908657A (en) * | 2017-10-17 | 2018-04-13 | 平安科技（深圳）有限公司 | Querying method, device, computer equipment and the storage medium of bordereau |
| CN108804548A (en) * | 2018-05-21 | 2018-11-13 | 上海陆家嘴国际金融资产交易市场股份有限公司 | Test data querying method, device, computer equipment and storage medium |
| CN109299234A (en) * | 2018-09-19 | 2019-02-01 | 北京明略软件系统有限公司 | A kind of information query method, device and computer readable storage medium |
| CN109710655A (en) * | 2018-11-09 | 2019-05-03 | 中国平安人寿保险股份有限公司 | Data base query method, device, terminal device and storage medium |
| CN110609954A (en) * | 2019-08-30 | 2019-12-24 | 深圳壹账通智能科技有限公司 | Data acquisition method and device, computer equipment and storage medium |
-
2019
- 2019-12-27 CN CN201911390200.1A patent/CN111159217A/en active Pending
Patent Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20110270867A1 (en) * | 2010-04-30 | 2011-11-03 | International Business Machines Corporation | Web service discovery via data abstraction model |
| CN106326428A (en) * | 2016-08-24 | 2017-01-11 | 华青融天（北京）技术股份有限公司 | Data processing method and device |
| CN107908657A (en) * | 2017-10-17 | 2018-04-13 | 平安科技（深圳）有限公司 | Querying method, device, computer equipment and the storage medium of bordereau |
| CN108804548A (en) * | 2018-05-21 | 2018-11-13 | 上海陆家嘴国际金融资产交易市场股份有限公司 | Test data querying method, device, computer equipment and storage medium |
| CN109299234A (en) * | 2018-09-19 | 2019-02-01 | 北京明略软件系统有限公司 | A kind of information query method, device and computer readable storage medium |
| CN109710655A (en) * | 2018-11-09 | 2019-05-03 | 中国平安人寿保险股份有限公司 | Data base query method, device, terminal device and storage medium |
| CN110609954A (en) * | 2019-08-30 | 2019-12-24 | 深圳壹账通智能科技有限公司 | Data acquisition method and device, computer equipment and storage medium |
Cited By (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112434060A (en) * | 2020-12-09 | 2021-03-02 | 北京有竹居网络技术有限公司 | Data query method and system |
| CN113254547A (en) * | 2021-05-27 | 2021-08-13 | 北京达佳互联信息技术有限公司 | Data query method, device, server and storage medium |
| CN113254547B (en) * | 2021-05-27 | 2024-04-16 | 北京达佳互联信息技术有限公司 | Data query method, device, server and storage medium |
| US20220398244A1 (en) * | 2021-09-23 | 2022-12-15 | Beijing Baidu Netcom Science Technology Co., Ltd. | Query method and device and storage medium |
| CN115314751A (en) * | 2022-08-08 | 2022-11-08 | 北京达佳互联信息技术有限公司 | Data processing method and device, electronic equipment and storage medium |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN111159217A (en) | Data query method, device, server and storage medium | |
| TWI747911B (en) | Two-dimensional code information query method, server, client and system | |
| CN107833056B (en) | Client feedback information processing method and terminal thereof | |
| US7523133B2 (en) | Data model and applications | |
| CN107798038B (en) | Data response method and data response equipment | |
| CN110413634B (en) | Data query method, system, device and computer readable storage medium | |
| CN113364853B (en) | Business service system, business request method and gateway equipment | |
| US9218503B2 (en) | Collection and analysis of customer data from application programming interface usage | |
| CN106776973B (en) | Blacklist data generation method and apparatus | |
| CN110716951A (en) | Label configuration method, device and equipment convenient to configure and storage medium | |
| CN109657899B (en) | Item processing method, device, equipment and readable storage medium | |
| CN111460279A (en) | Information recommendation method and device, storage medium and computer equipment | |
| CN111753210B (en) | Resource pushing method and device, computer equipment and computer readable storage medium | |
| CN110737706A (en) | Data management method, device, equipment and computer readable storage medium | |
| CN110008211B (en) | Data query method and device, electronic equipment and storage medium | |
| CN112182174A (en) | Business question-answer knowledge query method and device, computer equipment and storage medium | |
| CN111586118A (en) | Data processing method and device and computer equipment | |
| TWI686750B (en) | Method and device for identifying user's potential knowledge points for help | |
| KR20150136338A (en) | Method of creating multi tenancy history, server performing the same and storage media storing the same | |
| CN116228374A (en) | Logistics industry market single data early warning method, device, equipment and storage medium | |
| CN113177694B (en) | Client allocation method, device, storage medium and computer equipment | |
| CN114254278A (en) | User account merging method and device, computer equipment and storage medium | |
| CN112237015B (en) | Methods, systems, and computer readable media for communicating information about an entity | |
| CN113157249A (en) | Identification number generation method and device, electronic equipment and storage medium | |
| CN107578297B (en) | Member information aggregation 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 | ||
| WD01 | Invention patent application deemed withdrawn after publication |
Application publication date: 20200515 |
|
| WD01 | Invention patent application deemed withdrawn after publication |