CN109977317B - Data query method and device - Google Patents
Data query method and device Download PDFInfo
- Publication number
- CN109977317B CN109977317B CN201910265505.3A CN201910265505A CN109977317B CN 109977317 B CN109977317 B CN 109977317B CN 201910265505 A CN201910265505 A CN 201910265505A CN 109977317 B CN109977317 B CN 109977317B
- Authority
- CN
- China
- Prior art keywords
- query
- target
- template
- query template
- configuration scheme
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Active
Links
Images
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention discloses a data query method and a device, wherein different query requests sent by a client terminal are different in carried target query template identification, different target query templates and target configuration schemes can be determined according to different target query template identifications, different query results can be generated according to different target query templates and different target configuration schemes, and finally different business query list pages are generated. Based on the method and the device, the requirements of different business operators in different enterprises or the same enterprise on different query results can be met without modifying the source file corresponding to the business query function for many times.
Description
Technical Field
The invention relates to the technical field of databases, in particular to a data query method and a data query device.
Background
With the rapid development of social economy, enterprise-level application software development has become one of the main fields of information-based construction in China. The enterprise-level application software is suitable for the application requirements of the whole system, and compared with general application software, the enterprise-level application software is large in scale and complex in structure.
Currently, developing business query functions of enterprise-level application software requires creating or modifying a series of source files. However, for the same business table, different business operators in different enterprises or in the same enterprise may want to query different fields, and in this case, when developing the business query function of the enterprise-level application software, the source file corresponding to the business query function needs to be modified many times, so as to implement multiple business query functions capable of generating different query results, so as to meet the requirements of different business operators in different enterprises or in the same enterprise on different query results.
However, in the development mode of the business query function of the enterprise-level application software in the prior art, the source file corresponding to the business query function needs to be modified for many times, which increases the workload of developers and increases the risk of introducing defects into the source file.
Disclosure of Invention
In view of the above, the present invention is proposed to provide a data query method and apparatus that overcomes or at least partially solves the above problems. The specific scheme is as follows:
a method of data query, the method comprising:
receiving a query request sent by a user through a client, wherein the query request comprises a target query template identifier;
determining a target query template and a candidate configuration scheme corresponding to the target query template identifier;
determining a target configuration scheme corresponding to the query request from the candidate configuration schemes;
performing data query according to the target query template and the target configuration scheme to generate a query result;
and generating a service query list page according to the target query template, the target configuration scheme and the query result.
Optionally, if the query request further includes the role identifier of the user, the determining a target configuration scheme corresponding to the query request from the candidate configuration schemes includes:
and determining a configuration scheme matched with the role identification of the user from the candidate configuration schemes as a target configuration scheme.
Optionally, if the target query template corresponding to the target query template identifier includes a name of a target data table to be queried, performing data query according to the target query template and the target configuration scheme to generate a query result, including:
determining a query statement according to the target query template and the target configuration scheme;
and executing the query statement to access the target data table to generate a query result.
Optionally, before the obtaining of the candidate configuration solution corresponding to the target query template identifier, the method further includes:
receiving a personalized configuration request sent by a manager through a client configuration page;
configuring the metadata according to the personalized configuration request to generate a candidate configuration scheme;
and storing the candidate configuration scheme, wherein the candidate configuration scheme corresponds to the target query template identification.
Optionally, before the determining the metadata of the target query template corresponding to the target query template identification, the method further comprises:
receiving all query templates sent by developers through a client development page, wherein each query template comprises a plurality of metadata;
generating query template identifications corresponding to the query templates one by one;
and storing each query template identification and the metadata of the query template corresponding to each query template identification one by one.
A data query device, the device comprising:
the system comprises a receiving unit, a query unit and a processing unit, wherein the receiving unit is used for receiving a query request sent by a user through a client, and the query request comprises a target query template identifier;
a candidate configuration scheme determining unit, configured to determine a target query template and a candidate configuration scheme corresponding to the target query template identifier;
a target candidate configuration scheme determining unit, configured to determine a target configuration scheme corresponding to the query request from the candidate configuration schemes;
the query unit is used for carrying out data query according to the target query template and the target configuration scheme to generate a query result;
and the service query list page generating unit is used for generating a service query list page according to the target query template, the target configuration scheme and the query result.
Optionally, if the query request further includes the role identifier of the user, the target configuration scheme determining unit is specifically configured to:
and determining a configuration scheme matched with the role identification of the user from the candidate configuration schemes as a target configuration scheme.
Optionally, if the target query template corresponding to the target query template identifier includes a name of a target data table to be queried, the querying unit is specifically configured to:
determining a query statement according to the target query template and the target configuration scheme;
and executing the query statement to access the target data table to generate a query result.
Optionally, the apparatus further includes a candidate configuration scheme generating unit, configured to receive, before the obtaining of the candidate configuration scheme corresponding to the target query template identifier, a personalized configuration request sent by a manager through a client configuration page; configuring the metadata according to the personalized configuration request to generate a candidate configuration scheme; and storing the candidate configuration scheme, wherein the candidate configuration scheme corresponds to the target query template identification.
Optionally, the apparatus further includes a query template generating unit, configured to receive, before the determining the metadata of the target query template corresponding to the target query template identifier, each query template sent by a developer through a client development page, where each query template includes a plurality of metadata; generating query template identifications corresponding to the query templates one by one; and storing each query template identification and the metadata of the query template corresponding to each query template identification one by one.
A storage medium on which a program is stored, which when executed by a processor implements the data query method as described above.
An electronic device comprising a memory for storing a program and a processor for executing the program, wherein the program executes to perform the data query method as described above.
By means of the technical scheme, the data query method and the data query device provided by the invention have the advantages that different target query template identifications are different from one another when a user sends different query requests through the client, different target query templates and target configuration schemes can be determined according to the different target query template identifications, different query results can be generated according to the different target query templates and the different target configuration schemes, and finally different service query list pages are generated. Based on the method and the device, the requirements of different business operators in different enterprises or the same enterprise on different query results can be met without modifying the source file corresponding to the business query function for many times.
The foregoing description is only an overview of the technical solutions of the present invention, and the embodiments of the present invention are described below in order to make the technical means of the present invention more clearly understood and to make the above and other objects, features, and advantages of the present invention more clearly understandable.
Drawings
Various other advantages and benefits will become apparent to those of ordinary skill in the art upon reading the following detailed description of the preferred embodiments. The drawings are only for purposes of illustrating the preferred embodiments and are not to be construed as limiting the invention. Also, like reference numerals are used to refer to like parts throughout the drawings. In the drawings:
FIG. 1 is a schematic flow chart of a data query method according to an embodiment of the present invention;
FIG. 2 is a schematic flow chart illustrating a query template generating method according to an embodiment of the present invention;
FIG. 3 is a schematic flow chart illustrating a method for generating a candidate configuration scenario according to an embodiment of the present invention;
fig. 4 is a schematic structural diagram of a data query device according to an embodiment of the present invention.
Detailed Description
Exemplary embodiments of the present disclosure will be described in more detail below with reference to the accompanying drawings. While exemplary embodiments of the present disclosure are shown in the drawings, it should be understood that the present disclosure may be embodied in various forms and should not be limited to the embodiments set forth herein. Rather, these embodiments are provided so that this disclosure will be thorough and complete, and will fully convey the scope of the disclosure to those skilled in the art.
Referring to fig. 1, fig. 1 is a schematic flowchart of a data query method according to an embodiment of the present invention, where the method is applied to a background server of a query component, and the method includes:
step S101: receiving a query request sent by a user through a client, wherein the query request comprises a target query template identifier;
as an implementable mode, a user can view a query template list containing at least one query template identifier (biz _ code) through a query page, select one query template identifier from the query template list as a target query template identifier, and also can quote the target query template identifier in a hyperlink mode at any position of the query page, generate a query request containing the target query template identifier and send the query request to a query component. In this step, the user may specifically be a different business operator in a different enterprise or in the same enterprise. The query page may specifically be a background management page provided by the query component and displayed at the client. The generated query request may be a query session.
Step S102: determining a candidate configuration scheme corresponding to the target query template identifier;
as an implementation manner, after receiving the query request, the query component obtains the target query template identifier from the query request, and determines the target query template and the candidate configuration scheme corresponding to the target query template identifier from the database.
Step S103: determining a target query template and a target configuration scheme corresponding to the query request from the candidate configuration schemes;
as an example, the query request includes user information, and the query component can determine a target configuration solution from the candidate configuration solutions according to the user information.
As an implementable embodiment, if the query request further includes the role identifier of the user, the determining, from the candidate configuration solutions, a target configuration solution corresponding to the query request includes:
and determining a configuration scheme matched with the role identification of the user from the candidate configuration schemes as a target configuration scheme.
Step S104: performing data query according to the target query template and the target configuration scheme to generate a query result;
as an implementable manner, if the target query template corresponding to the target query template identifier includes a name of a target data table to be queried, performing data query according to the target query template and the target configuration scheme to generate a query result, including:
determining a query statement according to the target query template and the target configuration scheme;
and executing the query statement to access the target data table to generate a query result.
Step S105: and generating a service query list page according to the target query template, the target configuration scheme and the query result.
As an implementable manner, the target query template, the target configuration scheme, and the query result may be sent to a presentation layer, so that the presentation layer renders the query page according to the target query template, the target configuration scheme, and the query result to generate a business query list page.
In the data query method provided by this embodiment, a user sends different query requests through a client, the target query template identifiers carried by the user are different, different target query templates and target configuration schemes can be determined according to the different target query template identifiers, different query results can be generated according to the different target query templates and the different target configuration schemes, and finally different service query list pages are generated. Based on the method, the requirements of different enterprises or different business operators in the same enterprise on different query results can be met without modifying the source file corresponding to the business query function for many times.
As a preferred embodiment, before the data query method is executed, a background server of the query component needs to generate a query template in advance, please refer to fig. 2, where fig. 2 is a schematic flow diagram of a query template generation method disclosed in an embodiment of the present invention, and the flow specifically includes:
step S201: receiving all query templates sent by developers through a client development page, wherein each query template comprises a plurality of metadata;
as an implementation, a developer may input a plurality of metadata including metadata of a target query template through a client development page and generate a plurality of query templates including the target query template. The metadata of each query template comprises template metadata and attribute metadata, wherein the template metadata at least comprises the name of a target data list to be queried and can also comprise the name of the target query template, a CSS (Cascading Style Sheets) address, a JS script address, an operation bar control and the like; the attribute metadata comprises visibility, retrievability, formatting and other information of fields in the target data table to be queried, wherein each attribute metadata corresponds to one field, and the number of the attribute metadata can be the same as or less than the number of the fields in the target data table to be queried.
Step S202: generating query template identifications corresponding to the query templates one by one;
step S203: and storing each query template identification and the metadata of the query template corresponding to each query template identification one by one.
In one possible embodiment, each query template identification and the metadata of the query template corresponding one-to-one to each query template identification may be stored in a database.
As a preferred embodiment, before the candidate configuration solution corresponding to the target query template identifier is obtained, the background server of the query component needs to generate the candidate configuration solution in advance, please refer to fig. 3, where fig. 3 is a schematic flow diagram of a candidate configuration solution generation method disclosed in an embodiment of the present invention, and the method includes the following steps:
step S301: receiving a personalized configuration request sent by a manager through a client configuration page;
as an implementation mode, the manager can look up the metadata of the target query template through the configuration page, and generate different personalized configuration requests through different combinations and configurations of the attribute metadata, wherein the metadata of the target query template is kept unchanged.
Step S302: configuring the metadata according to the personalized configuration request to generate a candidate configuration scheme;
and different personalized configuration requests are obtained, the metadata are configured differently, and the generated candidate configuration schemes are different.
Step S303: and storing the candidate configuration scheme, wherein the candidate configuration scheme corresponds to the target query template identification.
The candidate configuration may be stored in a database.
Referring to fig. 4, fig. 4 is a schematic structural diagram of a data query device according to an embodiment of the present invention, where the data query device includes:
a receiving unit 41, configured to receive an inquiry request sent by a user through a client, where the inquiry request includes a target inquiry template identifier;
a candidate configuration scheme determining unit 42, configured to determine a target query template corresponding to the target query template identifier and a candidate configuration scheme;
a target candidate configuration scheme determining unit 43, configured to determine a target configuration scheme corresponding to the query request from the candidate configuration schemes;
the query unit 44 is configured to perform data query according to the target query template and the target configuration scheme, and generate a query result;
and a service query list page generating unit 45, configured to generate a service query list page according to the target query template, the target configuration scheme, and the query result.
Optionally, if the query request further includes the role identifier of the user, the target configuration scheme determining unit is specifically configured to:
and determining a configuration scheme matched with the role identification of the user from the candidate configuration schemes as a target configuration scheme.
Optionally, if the target query template corresponding to the target query template identifier includes a name of a target data table to be queried, the querying unit is specifically configured to:
determining a query statement according to the target query template and the target configuration scheme;
and executing the query statement to access the target data table to generate a query result.
Optionally, the apparatus further includes a candidate configuration scheme generating unit, configured to receive, before the obtaining of the candidate configuration scheme corresponding to the target query template identifier, a personalized configuration request sent by a manager through a client configuration page; configuring the metadata according to the personalized configuration request to generate a candidate configuration scheme; and storing the candidate configuration scheme, wherein the candidate configuration scheme corresponds to the target query template identification.
Optionally, the apparatus further includes a query template generating unit, configured to receive, before the determining the metadata of the target query template corresponding to the target query template identifier, each query template sent by a developer through a client development page, where each query template includes a plurality of metadata; generating query template identifications corresponding to the query templates one by one; and storing each query template identification and the metadata of the query template corresponding to each query template identification one by one.
It should be noted that specific function implementation of each unit is already described in detail in the method embodiment, and this embodiment is not described again.
The data inquiry device comprises a processor and a memory, wherein the units are stored in the memory as program units, and the processor executes the program units stored in the memory to realize corresponding functions.
The processor comprises a kernel, and the kernel calls the corresponding program unit from the memory. The kernel can be set to be one or more than one, and the requirement of different business operators in different enterprises or the same enterprise on different query results can be met by adjusting the kernel parameters without modifying the source file corresponding to the business query function for many times.
The memory may include volatile memory in a computer readable medium, Random Access Memory (RAM) and/or nonvolatile memory such as Read Only Memory (ROM) or flash memory (flash RAM), and the memory includes at least one memory chip.
An embodiment of the present invention provides a storage medium on which a program is stored, the program implementing the data query method when executed by a processor.
The embodiment of the invention provides a processor, which is used for running a program, wherein the data query method is executed when the program runs.
The embodiment of the invention provides electronic equipment, which comprises a processor, a memory and a program which is stored on the memory and can be operated on the processor, wherein the processor executes the program and realizes the following steps:
receiving a query request sent by a user through a client, wherein the query request comprises a target query template identifier;
determining a target query template and a candidate configuration scheme corresponding to the target query template identifier;
determining a target configuration scheme corresponding to the query request from the candidate configuration schemes;
performing data query according to the target query template and the target configuration scheme to generate a query result;
and generating a service query list page according to the target query template, the target configuration scheme and the query result.
Optionally, if the query request further includes the role identifier of the user, the determining a target configuration scheme corresponding to the query request from the candidate configuration schemes includes:
and determining a configuration scheme matched with the role identification of the user from the candidate configuration schemes as a target configuration scheme.
Optionally, if the target query template corresponding to the target query template identifier includes a name of a target data table to be queried, performing data query according to the target query template and the target configuration scheme to generate a query result, including:
determining a query statement according to the target query template and the target configuration scheme;
and executing the query statement to access the target data table to generate a query result.
Optionally, before the obtaining of the candidate configuration solution corresponding to the target query template identifier, the method further includes:
receiving a personalized configuration request sent by a manager through a client configuration page;
configuring the metadata according to the personalized configuration request to generate a candidate configuration scheme;
and storing the candidate configuration scheme, wherein the candidate configuration scheme corresponds to the target query template identification.
Optionally, before the determining the metadata of the target query template corresponding to the target query template identification, the method further comprises:
receiving all query templates sent by developers through a client development page, wherein each query template comprises a plurality of metadata;
generating query template identifications corresponding to the query templates one by one;
and storing each query template identification and the metadata of the query template corresponding to each query template identification one by one.
The electronic device herein may be a server, a PC, a PAD, a mobile phone, etc.
The present application further provides a computer program product adapted to perform a program for initializing the following method steps when executed on a data processing device:
receiving a query request sent by a user through a client, wherein the query request comprises a target query template identifier;
determining a target query template and a candidate configuration scheme corresponding to the target query template identifier;
determining a target configuration scheme corresponding to the query request from the candidate configuration schemes;
performing data query according to the target query template and the target configuration scheme to generate a query result;
and generating a service query list page according to the target query template, the target configuration scheme and the query result.
Optionally, if the query request further includes the role identifier of the user, the determining a target configuration scheme corresponding to the query request from the candidate configuration schemes includes:
and determining a configuration scheme matched with the role identification of the user from the candidate configuration schemes as a target configuration scheme.
Optionally, if the target query template corresponding to the target query template identifier includes a name of a target data table to be queried, performing data query according to the target query template and the target configuration scheme to generate a query result, including:
determining a query statement according to the target query template and the target configuration scheme;
and executing the query statement to access the target data table to generate a query result.
Optionally, before the obtaining of the candidate configuration solution corresponding to the target query template identifier, the method further includes:
receiving a personalized configuration request sent by a manager through a client configuration page;
configuring the metadata according to the personalized configuration request to generate a candidate configuration scheme;
and storing the candidate configuration scheme, wherein the candidate configuration scheme corresponds to the target query template identification.
Optionally, before the determining the metadata of the target query template corresponding to the target query template identification, the method further comprises:
receiving all query templates sent by developers through a client development page, wherein each query template comprises a plurality of metadata;
generating query template identifications corresponding to the query templates one by one;
and storing each query template identification and the metadata of the query template corresponding to each query template identification one by one.
As will be appreciated by one skilled in the art, embodiments of the present application may be provided as a method, system, or computer program product. Accordingly, the present application may take the form of an entirely hardware embodiment, an entirely software embodiment or an embodiment combining software and hardware aspects. Furthermore, the present application may take the form of a computer program product embodied on one or more computer-usable storage media (including, but not limited to, disk storage, CD-ROM, optical storage, and the like) having computer-usable program code embodied therein.
The present application is described with reference to flowchart illustrations and/or block diagrams of methods, apparatus (systems), and computer program products according to embodiments of the application. It will be understood that each flow and/or block of the flow diagrams and/or block diagrams, and combinations of flows and/or blocks in the flow diagrams and/or block diagrams, can be implemented by computer program instructions. These computer program instructions may be provided to a processor of a general purpose computer, special purpose computer, embedded processor, or other programmable data processing apparatus to produce a machine, such that the instructions, which execute via the processor of the computer or other programmable data processing apparatus, create means for implementing the functions specified in the flowchart flow or flows and/or block diagram block or blocks.
These computer program instructions may also be stored in a computer-readable memory that can direct a computer or other programmable data processing apparatus to function in a particular manner, such that the instructions stored in the computer-readable memory produce an article of manufacture including instruction means which implement the function specified in the flowchart flow or flows and/or block diagram block or blocks.
These computer program instructions may also be loaded onto a computer or other programmable data processing apparatus to cause a series of operational steps to be performed on the computer or other programmable apparatus to produce a computer implemented process such that the instructions which execute on the computer or other programmable apparatus provide steps for implementing the functions specified in the flowchart flow or flows and/or block diagram block or blocks.
In a typical configuration, a computing device includes one or more processors (CPUs), input/output interfaces, network interfaces, and memory.
The memory may include forms of volatile memory in a computer readable medium, Random Access Memory (RAM) and/or non-volatile memory, such as Read Only Memory (ROM) or flash memory (flash RAM). The memory is an example of a computer-readable medium.
Computer-readable media, including both non-transitory and non-transitory, removable and non-removable media, may implement information storage by any method or technology. The information may be computer readable instructions, data structures, modules of a program, or other data. Examples of computer storage media include, but are not limited to, phase change memory (PRAM), Static Random Access Memory (SRAM), Dynamic Random Access Memory (DRAM), other types of Random Access Memory (RAM), Read Only Memory (ROM), Electrically Erasable Programmable Read Only Memory (EEPROM), flash memory or other memory technology, compact disc read only memory (CD-ROM), Digital Versatile Discs (DVD) or other optical storage, magnetic cassettes, magnetic tape magnetic disk storage or other magnetic storage devices, or any other non-transmission medium that can be used to store information that can be accessed by a computing device. As defined herein, a computer readable medium does not include a transitory computer readable medium such as a modulated data signal and a carrier wave.
It should also be noted that the terms "comprises," "comprising," or any other variation thereof, are intended to cover a non-exclusive inclusion, such that a process, method, article, or apparatus that comprises a list of elements does not include only those elements but may include other elements not expressly listed or inherent to such process, method, article, or apparatus. Without further limitation, an element defined by the phrase "comprising an … …" does not exclude the presence of other identical elements in the process, method, article, or apparatus that comprises the element.
As will be appreciated by one skilled in the art, embodiments of the present application may be provided as a method, system, or computer program product. Accordingly, the present application may take the form of an entirely hardware embodiment, an entirely software embodiment or an embodiment combining software and hardware aspects. Furthermore, the present application may take the form of a computer program product embodied on one or more computer-usable storage media (including, but not limited to, disk storage, CD-ROM, optical storage, and the like) having computer-usable program code embodied therein.
The above are merely examples of the present application and are not intended to limit the present application. Various modifications and changes may occur to those skilled in the art. Any modification, equivalent replacement, improvement, etc. made within the spirit and principle of the present application should be included in the scope of the claims of the present application.
Claims (10)
1. A method for data query, the method comprising:
receiving a query request sent by a user through a client, wherein the query request comprises a target query template identifier;
determining a target query template and a candidate configuration scheme corresponding to the target query template identifier;
determining a target configuration scheme corresponding to the query request from the candidate configuration schemes;
performing data query according to the target query template and the target configuration scheme to generate a query result;
generating a service query list page according to the target query template, the target configuration scheme and the query result;
prior to determining the candidate configuration scenario corresponding to the target query template identification, the method further comprises:
receiving a personalized configuration request sent by a manager through a client configuration page, wherein the personalized configuration request comprises the following steps: receiving a personalized configuration request which is sent through a client configuration page and generated through the combination and configuration of attribute metadata of a target query template;
configuring metadata according to the personalized configuration request to generate a candidate configuration scheme, wherein the metadata comprises template metadata and attribute metadata;
storing the candidate configuration scheme, wherein the candidate configuration scheme corresponds to the target query template identifier;
the attribute metadata comprises visibility, retrievability and/or formatting information of fields in a target data table to be queried, wherein each attribute metadata corresponds to one field, and the number of the attribute metadata is the same as or less than the number of the fields in the target data table to be queried.
2. The method according to claim 1, wherein the query request further includes a role identifier of the user, and the determining a target configuration scheme corresponding to the query request from the candidate configuration schemes includes:
and determining a configuration scheme matched with the role identification of the user from the candidate configuration schemes as a target configuration scheme.
3. The method according to claim 1, wherein the target query template corresponding to the target query template identifier includes a name of a target data table to be queried, and the performing data query according to the target query template and the target configuration scheme to generate a query result includes:
determining a query statement according to the target query template and the target configuration scheme;
and executing the query statement to access the target data table to generate a query result.
4. The method of claim 1, wherein prior to said determining metadata for a target query template corresponding to said target query template identification, said method further comprises:
receiving all query templates sent by developers through a client development page, wherein each query template comprises a plurality of metadata;
generating query template identifications corresponding to the query templates one by one;
and storing each query template identification and the metadata of the query template corresponding to each query template identification one by one.
5. A data query apparatus, characterized in that the apparatus comprises:
the system comprises a receiving unit, a query unit and a processing unit, wherein the receiving unit is used for receiving a query request sent by a user through a client, and the query request comprises a target query template identifier;
a candidate configuration scheme determining unit, configured to determine a target query template and a candidate configuration scheme corresponding to the target query template identifier;
a target candidate configuration scheme determining unit, configured to determine a target configuration scheme corresponding to the query request from the candidate configuration schemes;
the query unit is used for carrying out data query according to the target query template and the target configuration scheme to generate a query result;
a service query list page generating unit, configured to generate a service query list page according to the target query template, the target configuration scheme, and the query result;
the device further comprises a candidate configuration scheme generation unit, configured to receive, before determining a candidate configuration scheme corresponding to the target query template identifier, a personalized configuration request sent by a manager through a client configuration page, where the candidate configuration scheme generation unit is configured to receive, by a manager, a personalized configuration request that includes: receiving a personalized configuration request which is sent through a client configuration page and generated through the combination and configuration of attribute metadata of a target query template; configuring metadata according to the personalized configuration request to generate a candidate configuration scheme, wherein the metadata comprises template metadata and attribute metadata; storing the candidate configuration scheme, wherein the candidate configuration scheme corresponds to the target query template identifier; the attribute metadata comprises visibility, retrievability and/or formatting information of fields in a target data table to be queried, wherein each attribute metadata corresponds to one field, and the number of the attribute metadata is the same as or less than the number of the fields in the target data table to be queried.
6. The apparatus according to claim 5, wherein the query request further includes a role identifier of the user, and the target configuration scheme determining unit is specifically configured to:
and determining a configuration scheme matched with the role identification of the user from the candidate configuration schemes as a target configuration scheme.
7. The apparatus according to claim 5, wherein the target query template corresponding to the target query template identifier includes a name of a target data table to be queried, and the query unit is specifically configured to:
determining a query statement according to the target query template and the target configuration scheme;
and executing the query statement to access the target data table to generate a query result.
8. The apparatus according to claim 5, further comprising a query template generating unit, configured to receive respective query templates sent by developers through a client development page before the determining metadata of a target query template corresponding to the target query template identifier, each query template including a plurality of metadata; generating query template identifications corresponding to the query templates one by one; and storing each query template identification and the metadata of the query template corresponding to each query template identification one by one.
9. A storage medium on which a program is stored, the program implementing the data query method according to any one of claims 1 to 4 when executed by a processor.
10. An electronic device comprising a memory for storing a program and a processor for executing the program, wherein the program when executed performs the data query method of any one of claims 1 to 4.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910265505.3A CN109977317B (en) | 2019-04-03 | 2019-04-03 | Data query method and device |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910265505.3A CN109977317B (en) | 2019-04-03 | 2019-04-03 | Data query method and device |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN109977317A CN109977317A (en) | 2019-07-05 |
| CN109977317B true CN109977317B (en) | 2021-04-27 |
Family
ID=67082661
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201910265505.3A Active CN109977317B (en) | 2019-04-03 | 2019-04-03 | Data query method and device |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN109977317B (en) |
Families Citing this family (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110941657B (en) * | 2019-11-08 | 2023-03-31 | 支付宝(杭州)信息技术有限公司 | Service data processing method and device |
| CN112182349B (en) * | 2020-09-14 | 2024-06-11 | 支付宝(杭州)信息技术有限公司 | Query method, device and system for compliance files |
| CN114064733B (en) * | 2021-11-29 | 2024-07-30 | 中国平安财产保险股份有限公司 | Database query method, device, equipment and medium suitable for local client |
Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN106649638A (en) * | 2016-12-08 | 2017-05-10 | 贵州数据宝网络科技有限公司 | Big data acquisition method |
| CN106775770A (en) * | 2017-01-16 | 2017-05-31 | 兴唐通信科技有限公司 | The lookup method of query statement is built based on category information |
| CN108132987A (en) * | 2017-12-14 | 2018-06-08 | 浙江航天恒嘉数据科技有限公司 | A kind of data query system and method |
| CN109413203A (en) * | 2018-11-29 | 2019-03-01 | 平安科技（深圳）有限公司 | A kind of transaction data acquisition methods and device |
| CN109524065A (en) * | 2018-11-07 | 2019-03-26 | 平安医疗健康管理股份有限公司 | Medical data querying method, medical data platform and relevant apparatus |
| CN109522357A (en) * | 2018-11-28 | 2019-03-26 | 北京锐安科技有限公司 | A kind of data processing method, device, server and storage medium |
Family Cites Families (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN108446286B (en) * | 2017-02-16 | 2023-04-25 | 阿里巴巴集团控股有限公司 | Method, device and server for generating natural language question answers |
| US10733189B2 (en) * | 2017-04-07 | 2020-08-04 | Microsoft Technology Licensing, Llc | Error message redaction in query processing |
| CN108664638B (en) * | 2018-05-15 | 2019-12-10 | 口碑(上海)信息技术有限公司 | report generation method and device based on index system |
| CN109272991B (en) * | 2018-09-29 | 2021-11-02 | 阿波罗智联(北京)科技有限公司 | Voice interaction method, device, equipment and computer-readable storage medium |
| CN109542635A (en) * | 2018-10-17 | 2019-03-29 | 深圳壹账通智能科技有限公司 | Configuration information update method, apparatus, computer equipment and storage medium |
-
2019
- 2019-04-03 CN CN201910265505.3A patent/CN109977317B/en active Active
Patent Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN106649638A (en) * | 2016-12-08 | 2017-05-10 | 贵州数据宝网络科技有限公司 | Big data acquisition method |
| CN106775770A (en) * | 2017-01-16 | 2017-05-31 | 兴唐通信科技有限公司 | The lookup method of query statement is built based on category information |
| CN108132987A (en) * | 2017-12-14 | 2018-06-08 | 浙江航天恒嘉数据科技有限公司 | A kind of data query system and method |
| CN109524065A (en) * | 2018-11-07 | 2019-03-26 | 平安医疗健康管理股份有限公司 | Medical data querying method, medical data platform and relevant apparatus |
| CN109522357A (en) * | 2018-11-28 | 2019-03-26 | 北京锐安科技有限公司 | A kind of data processing method, device, server and storage medium |
| CN109413203A (en) * | 2018-11-29 | 2019-03-01 | 平安科技（深圳）有限公司 | A kind of transaction data acquisition methods and device |
Also Published As
| Publication number | Publication date |
|---|---|
| CN109977317A (en) | 2019-07-05 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US9069788B2 (en) | Truncating data associated with objects in a multi-tenant database | |
| CN107070858B (en) | Service processing method and device | |
| CN111443912B (en) | Component-based page rendering method, device, computer equipment and storage medium | |
| CN107943465B (en) | Method and device for generating HTML (Hypertext markup language) form | |
| CN108268609B (en) | File path establishing and accessing method and device | |
| CN109977317B (en) | Data query method and device | |
| CN110020353B (en) | Method and device for constructing webpage form | |
| CN110895544B (en) | Interface data processing method, device, system and storage medium | |
| CN104462127A (en) | Recorded data updating method and device | |
| CN112346717A (en) | Micro service system creating method, device, equipment, medium and micro service system | |
| CN106919620B (en) | Single page processing method and device | |
| CN110765151A (en) | Calculation formula processing method and device | |
| CN106648567B (en) | Data acquisition method and device | |
| CN110825764B (en) | SQL script generation method, system, storage medium and processor | |
| CN113569257B (en) | User authority management method and device in gray level release | |
| US12118188B2 (en) | Automation tool for generating web pages and links | |
| CN112597105A (en) | Processing method of file associated object, server side equipment and storage medium | |
| CN110019357B (en) | Database query script generation method and device | |
| CN111125087A (en) | Data storage method and device | |
| CN112579308A (en) | Task processing method and system | |
| CN105653566A (en) | Method and apparatus realizing database writing and visiting | |
| CN111221817B (en) | Service information data storage method, device, computer equipment and storage medium | |
| CN115599787A (en) | Level sub-metering method and device, electronic equipment and storage medium | |
| CN110175036B (en) | Upgrading method and device for soft lock permission | |
| CN111090825A (en) | Dynamic customization method for webpage content |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |