CN109977317A - Data query method and device - Google Patents
Data query method and device Download PDFInfo
- Publication number
- CN109977317A CN109977317A CN201910265505.3A CN201910265505A CN109977317A CN 109977317 A CN109977317 A CN 109977317A CN 201910265505 A CN201910265505 A CN 201910265505A CN 109977317 A CN109977317 A CN 109977317A
- Authority
- CN
- China
- Prior art keywords
- target
- query
- allocation plan
- query template
- template
- 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.)
- Granted
Links
Abstract
The invention discloses a kind of data query method and devices, the different inquiry requests that user is sent by client, the target query template identification of carrying is different, it can determine different target query template and target allocation plan according to different target query template identifications, different query results is produced according to different target query templates and different target allocation plans, ultimately generates different service inquiry original lists.Based on the above method and device, it is not necessary to repeatedly be modified the corresponding source file of service inquiry function, the demand of different enterprises or the different traffic operation staff of same enterprises to different query results can be met.
Description
Technical field
The present invention relates to database technical fields, and more specifically, it relates to a kind of data query method and devices.
Background technique
As the rapid development of sociaty and economy, enterprise-level application software exploitation has become the main of China's informatization
One of field.Enterprise-level application software is suitable for the application demand of whole system, and compared to general application software, scale is more
Greatly, structure is more complicated.
Currently, the service inquiry function of exploitation enterprise-level application software, needs newly-built or modifies a series of source files.But
It is that, for the same traffic table, different enterprises or the different traffic operation staff of same enterprises may wish to inquire
Field it is different, in this case, develop enterprise-level application software service inquiry function when, it is necessary to service inquiry
The corresponding source file of function is repeatedly modified, and realizes the multiple business query function that can generate different query results, with full
The demand of foot difference enterprises or the different traffic operation staff of same enterprises to different query results.
But the development scheme of the service inquiry function of enterprise-level application software is due to needing to look into business in the prior art
It askes the corresponding source file of function repeatedly to be modified, increase the workload of developer and increases introducing defect to source document
The risk of part.
Summary of the invention
In view of the above problems, it proposes on the present invention overcomes the above problem or at least be partially solved in order to provide one kind
State the data query method and device of problem.Concrete scheme is as follows:
A kind of data query method, which comprises
The inquiry request that user is sent by client is received, includes target query template identification in the inquiry request；
Determine target query template corresponding with the target query template identification and candidate allocation plan；
Target allocation plan corresponding with the inquiry request is determined from the candidate allocation plan；
Data query is carried out according to the target query template and the target allocation plan, generates query result；
Service inquiry list is generated according to the target query template, the target allocation plan and the query result
The page.
It optionally, further include the role identification of the user in the inquiry request, then it is described from the candidate configuration side
Target allocation plan corresponding with the inquiry request is determined in case, comprising:
It determines from the candidate allocation plan and matches with the matched allocation plan of role identification of the user as target
Set scheme.
It optionally, include target matrix to be checked in the corresponding target query template of the target query template identification
Title, then it is described that data query is carried out according to the target query template and the target allocation plan, generate query result,
Include:
Query statement is determined according to the target query template and the target allocation plan；
It executes the query statement to access to the target matrix, generates query result.
Optionally, before the acquisition candidate allocation plan corresponding with the target query template identification, the side
Method further include:
It receives administrative staff and the individual cultivation request that the page is sent is configured by client；
Configuration is carried out to the metadata according to individual cultivation request and generates candidate allocation plan；
The candidate allocation plan is stored, candidate's allocation plan is corresponding with the target query template identification.
Optionally, the metadata of determination target query template corresponding with the target query template identification it
Before, the method also includes:
It receives developer and each query template that the page is sent is developed by client, each query template includes multiple
Metadata；
It generates and is identified with the one-to-one query template of each query template；
It stores each query template mark and identifies the metadata of one-to-one query template with each query template.
A kind of data query device, described device include:
Receiving unit, the inquiry request sent for receiving user by client include target in the inquiry request
Query template mark；
Candidate allocation plan determination unit, for determining target query template corresponding with the target query template identification
And candidate allocation plan；
Target candidate allocation plan determination unit, for the determining and inquiry request pair from the candidate allocation plan
The target allocation plan answered；
Query unit is generated for carrying out data query according to the target query template and the target allocation plan
Query result；
Service inquiry original list generation unit, for according to the target query template, the target allocation plan with
And the query result generates service inquiry original list.
It optionally, further include the role identification of the user in the inquiry request, then the target allocation plan determines
Unit is specifically used for:
It determines from the candidate allocation plan and matches with the matched allocation plan of role identification of the user as target
Set scheme.
It optionally, include target matrix to be checked in the corresponding target query template of the target query template identification
Title, then the query unit is specifically used for:
Query statement is determined according to the target query template and the target allocation plan；
It executes the query statement to access to the target matrix, generates query result.
Optionally, described device further includes candidate allocation plan generation unit, for looking into the acquisition with the target
Before asking the corresponding candidate allocation plan of template identification, receives administrative staff and matched by the personalization that client configures page transmission
Set request；Configuration is carried out to the metadata according to individual cultivation request and generates candidate allocation plan；Store the time
Arrangement scheme, candidate's allocation plan are corresponding with the target query template identification.
Optionally, described device further includes query template generation unit, in the determination and the target query mould
Before the metadata of the corresponding target query template of panel sign, developer is received by client and develops each of page transmission
Query template, each query template include multiple metadata；It generates and is identified with the one-to-one query template of each query template；
It stores each query template mark and identifies the metadata of one-to-one query template with each query template.
A kind of storage medium, is stored thereon with program, which realizes that data as described above are looked into when being executed by processor
Inquiry method.
A kind of electronic equipment, the electronic equipment include memory and processor, and the memory is for storing program, institute
Processor is stated for running program, wherein described program executes data query method as described above when running.
By above-mentioned technical proposal, data query method and device provided by the invention, user is sent by client
The target query template identification of different inquiry requests, carrying is different, can determine difference according to different target query template identifications
Target query template and target allocation plan, produced according to different target query templates and different target allocation plans
Different query results ultimately generates different service inquiry original lists.Based on the above method and device, it is not necessary to look into business
It askes the corresponding source file of function repeatedly to be modified, different enterprises or the different business operation of same enterprises can be met
Demand of the personnel to different query results.
The above description is only an overview of the technical scheme of the present invention, in order to better understand the technical means of the present invention,
And it can be implemented in accordance with the contents of the specification, and in order to allow above and other objects of the present invention, feature and advantage can
It is clearer and more comprehensible, the followings are specific embodiments of the present invention.
Detailed description of the invention
By reading the following detailed description of the preferred embodiment, various other advantages and benefits are common for this field
Technical staff will become clear.The drawings are only for the purpose of illustrating a preferred embodiment, and is not considered as to the present invention
Limitation.And throughout the drawings, the same reference numbers will be used to refer to the same parts.In the accompanying drawings:
Fig. 1 is a kind of flow diagram of data query method disclosed by the embodiments of the present invention；
Fig. 2 is a kind of flow diagram of query template generation method disclosed by the embodiments of the present invention；
Fig. 3 is a kind of flow diagram of candidate allocation plan generation method disclosed by the embodiments of the present invention；
Fig. 4 is a kind of structural schematic diagram of data query device disclosed by the embodiments of the present invention.
Specific embodiment
Exemplary embodiments of the present disclosure are described in more detail below with reference to accompanying drawings.Although showing the disclosure in attached drawing
Exemplary embodiment, it being understood, however, that may be realized in various forms the disclosure without should be by embodiments set forth here
It is limited.On the contrary, these embodiments are provided to facilitate a more thoroughly understanding of the present invention, and can be by the scope of the present disclosure
It is fully disclosed to those skilled in the art.
Attached drawing 1 is please referred to, Fig. 1 is a kind of flow diagram of data query method disclosed by the embodiments of the present invention, the party
Method is applied to the background server of enquiring component, this method comprises:
Step S101: receiving the inquiry request that user is sent by client, includes target query in the inquiry request
Template identification；
As an embodiment, user can check to include at least one query template mark by query page
(biz_code) query template list, and therefrom select a query template mark as target query template identification, it can also
By in query page any position, REFER object query template is identified in the form of hyperlink, generating includes target query template mark
The inquiry request of knowledge, and the inquiry request is sent to enquiring component.In this step, user be specifically as follows different enterprises or
The different traffic operation staff of same enterprises.Query page be specifically as follows enquiring component offer be shown in client
The back-stage management page.The inquiry request of generation can be an inquiry session.
Step S102: candidate allocation plan corresponding with the target query template identification is determined；
As an embodiment, enquiring component obtains target after receiving inquiry request from inquiry request
Query template mark, and target query template corresponding with the target query template identification and candidate are determined from database
Allocation plan.
Step S103: determined from the candidate allocation plan target query template corresponding with the inquiry request and
Target allocation plan；
It as an embodiment, include user information in inquiry request, enquiring component can be according to user information from time
Target allocation plan is determined in arrangement scheme.
It as an embodiment, further include the role identification of the user in the inquiry request, then it is described from institute
It states and determines target allocation plan corresponding with the inquiry request in candidate allocation plan, comprising:
It determines from the candidate allocation plan and matches with the matched allocation plan of role identification of the user as target
Set scheme.
Step S104: data query is carried out according to the target query template and the target allocation plan, generates inquiry
As a result；
It as an embodiment, include to be checked in the corresponding target query template of the target query template identification
Target matrix title, then it is described that data query is carried out according to the target query template and the target allocation plan,
Generate query result, comprising:
Query statement is determined according to the target query template and the target allocation plan；
It executes the query statement to access to the target matrix, generates query result.
Step S105: industry is generated according to the target query template, the target allocation plan and the query result
Business inquiry original list.
It as an embodiment, can be by the target query template, the target allocation plan and the inquiry
As a result be sent to represent layer, with by the represent layer according to the target query template, the target allocation plan and described
Query result renders the query page and generates service inquiry original list.
Data query method provided in this embodiment, the different inquiry requests that user is sent by client, the mesh of carrying
It is different to mark query template mark, can determine that different target query template and target are matched according to different target query template identifications
Scheme is set, different query results is produced according to different target query templates and different target allocation plans, most throughout one's life
At different service inquiry original lists.Based on the above method, it is not necessary to be carried out to the corresponding source file of service inquiry function multiple
Modification can meet the demand of different enterprises or the different traffic operation staff of same enterprises to different query results.
As a preferred implementation manner, before the execution of above-mentioned data query method, the backstage of the enquiring component is taken
Business device needs pre-generated query template, please refers to attached drawing 2, and Fig. 2 is that a kind of query template disclosed by the embodiments of the present invention generates
The flow diagram of method, the process specifically include:
Step S201: developer is received by client and develops each query template that the page is sent, each inquiry mould
Plate includes multiple metadata；
As an embodiment, it includes target query template that developer can develop page input by client
Multiple metadata including metadata, and generate comprising the multiple queries template including target query template.Each query template
Metadata include template metadata and attribute metadata, the template metadata includes at least target matrix to be checked
Title may also include the title of target query template, CSS (Cascading Style Sheets, cascading style sheets) address, JS
Script address, action bar control etc.；The attribute metadata includes the visual of the field in the target matrix to be checked
Property, and/or, can accessibility, and/or, the information such as format, wherein the corresponding field of each attribute metadata, property metadata
According to number can be identical as the field number in the target matrix to be checked, also than the target data to be checked
Field number in table is few.
Step S202: it generates and is identified with the one-to-one query template of each query template；
Step S203: storing each query template mark and identifies one-to-one query template with each query template
Metadata.
In a kind of embodiment, each query template is identified and is looked into correspondingly with each query template mark
The metadata for asking template can be stored into database.
As a preferred implementation manner, in above-mentioned acquisition candidate configuration side corresponding with the target query template identification
Before case, the background server of the enquiring component needs pre-generated candidate allocation plan, please refers to attached drawing 3, and Fig. 3 is this hair
A kind of flow diagram of candidate's allocation plan generation method disclosed in bright embodiment, method includes the following steps:
Step S301: administrative staff are received by client and configure the individual cultivation request that the page is sent；
As an embodiment, administrative staff can view the metadata of target query template by configuring the page,
And passes through the various combination of attribute metadata and configure and generate different individual cultivation requests, the metadata of target query template
It remains unchanged.
Step S302: configuration is carried out to the metadata according to individual cultivation request and generates candidate allocation plan；
Individual cultivation request is different, and the configuration carried out to the metadata is just different, the candidate allocation plan of generation
It is different.
Step S303: the storage candidate allocation plan, candidate's allocation plan and the target query template identification
It is corresponding.
Candidate's allocation plan can be stored into database.
Attached drawing 4 is please referred to, Fig. 4 is a kind of structural schematic diagram of data query device disclosed by the embodiments of the present invention, the dress
It sets and includes:
Receiving unit 41, the inquiry request sent for receiving user by client include mesh in the inquiry request
Mark query template mark；
Candidate allocation plan determination unit 42, for determining target query mould corresponding with the target query template identification
Plate and candidate allocation plan；
Target candidate allocation plan determination unit 43, for the determining and inquiry request from the candidate allocation plan
Corresponding target allocation plan；
Query unit 44, it is raw for carrying out data query according to the target query template and the target allocation plan
At query result；
Service inquiry original list generation unit 45, for according to the target query template, the target allocation plan
And the query result generates service inquiry original list.
It optionally, further include the role identification of the user in the inquiry request, then the target allocation plan determines
Unit is specifically used for:
It determines from the candidate allocation plan and matches with the matched allocation plan of role identification of the user as target
Set scheme.
It optionally, include target matrix to be checked in the corresponding target query template of the target query template identification
Title, then the query unit is specifically used for:
Query statement is determined according to the target query template and the target allocation plan；
It executes the query statement to access to the target matrix, generates query result.
Optionally, described device further includes candidate allocation plan generation unit, for looking into the acquisition with the target
Before asking the corresponding candidate allocation plan of template identification, receives administrative staff and matched by the personalization that client configures page transmission
Set request；Configuration is carried out to the metadata according to individual cultivation request and generates candidate allocation plan；Store the time
Arrangement scheme, candidate's allocation plan are corresponding with the target query template identification.
Optionally, described device further includes query template generation unit, in the determination and the target query mould
Before the metadata of the corresponding target query template of panel sign, developer is received by client and develops each of page transmission
Query template, each query template include multiple metadata；It generates and is identified with the one-to-one query template of each query template；
It stores each query template mark and identifies the metadata of one-to-one query template with each query template.
It should be noted that the concrete function realization of above-mentioned each unit is described in detail in embodiment of the method, this reality
Example is applied to repeat no more.
The data query device includes processor and memory, and above-mentioned each unit is used as program unit to be stored in and deposits
In reservoir, above procedure unit stored in memory is executed by processor to realize corresponding function.
Include kernel in processor, is gone in memory to transfer corresponding program unit by kernel.Kernel can be set one
Or more, the corresponding source file of service inquiry function need not repeatedly be modified by adjusting kernel parameter to realize
Meet the demand of different enterprises or the different traffic operation staff of same enterprises to different query results.
Memory may include the non-volatile memory in computer-readable medium, random access memory (RAM) and/
Or the forms such as Nonvolatile memory, if read-only memory (ROM) or flash memory (flash RAM), memory include that at least one is deposited
Store up chip.
The embodiment of the invention provides a kind of storage mediums, are stored thereon with program, real when which is executed by processor
The existing data query method.
The embodiment of the invention provides a kind of processor, the processor is for running program, wherein described program operation
Data query method described in Shi Zhihang.
The embodiment of the invention provides a kind of electronic equipment, electronic equipment includes processor, memory and is stored in storage
On device and the program that can run on a processor, processor perform the steps of when executing program
The inquiry request that user is sent by client is received, includes target query template identification in the inquiry request；
Determine target query template corresponding with the target query template identification and candidate allocation plan；
Target allocation plan corresponding with the inquiry request is determined from the candidate allocation plan；
Data query is carried out according to the target query template and the target allocation plan, generates query result；
Service inquiry list is generated according to the target query template, the target allocation plan and the query result
The page.
It optionally, further include the role identification of the user in the inquiry request, then it is described from the candidate configuration side
Target allocation plan corresponding with the inquiry request is determined in case, comprising:
It determines from the candidate allocation plan and matches with the matched allocation plan of role identification of the user as target
Set scheme.
It optionally, include target matrix to be checked in the corresponding target query template of the target query template identification
Title, then it is described that data query is carried out according to the target query template and the target allocation plan, generate query result,
Include:
Query statement is determined according to the target query template and the target allocation plan；
It executes the query statement to access to the target matrix, generates query result.
Optionally, before the acquisition candidate allocation plan corresponding with the target query template identification, the side
Method further include:
It receives administrative staff and the individual cultivation request that the page is sent is configured by client；
Configuration is carried out to the metadata according to individual cultivation request and generates candidate allocation plan；
The candidate allocation plan is stored, candidate's allocation plan is corresponding with the target query template identification.
Optionally, the metadata of determination target query template corresponding with the target query template identification it
Before, the method also includes:
It receives developer and each query template that the page is sent is developed by client, each query template includes multiple
Metadata；
It generates and is identified with the one-to-one query template of each query template；
It stores each query template mark and identifies the metadata of one-to-one query template with each query template.
Electronic equipment herein can be server, PC, PAD, mobile phone etc..
Present invention also provides a kind of computer program products, when executing on data processing equipment, are adapted for carrying out just
The program of beginningization there are as below methods step:
The inquiry request that user is sent by client is received, includes target query template identification in the inquiry request；
Determine target query template corresponding with the target query template identification and candidate allocation plan；
Target allocation plan corresponding with the inquiry request is determined from the candidate allocation plan；
Data query is carried out according to the target query template and the target allocation plan, generates query result；
Service inquiry list is generated according to the target query template, the target allocation plan and the query result
The page.
It optionally, further include the role identification of the user in the inquiry request, then it is described from the candidate configuration side
Target allocation plan corresponding with the inquiry request is determined in case, comprising:
It determines from the candidate allocation plan and matches with the matched allocation plan of role identification of the user as target
Set scheme.
It optionally, include target matrix to be checked in the corresponding target query template of the target query template identification
Title, then it is described that data query is carried out according to the target query template and the target allocation plan, generate query result,
Include:
Query statement is determined according to the target query template and the target allocation plan；
It executes the query statement to access to the target matrix, generates query result.
Optionally, before the acquisition candidate allocation plan corresponding with the target query template identification, the side
Method further include:
It receives administrative staff and the individual cultivation request that the page is sent is configured by client；
Configuration is carried out to the metadata according to individual cultivation request and generates candidate allocation plan；
The candidate allocation plan is stored, candidate's allocation plan is corresponding with the target query template identification.
Optionally, the metadata of determination target query template corresponding with the target query template identification it
Before, the method also includes:
It receives developer and each query template that the page is sent is developed by client, each query template includes multiple
Metadata；
It generates and is identified with the one-to-one query template of each query template；
It stores each query template mark and identifies the metadata of one-to-one query template with each query template.
It should be understood by those skilled in the art that, embodiments herein can provide as method, system or computer program
Product.Therefore, complete hardware embodiment, complete software embodiment or reality combining software and hardware aspects can be used in the application
Apply the form of example.Moreover, it wherein includes the computer of computer usable program code that the application, which can be used in one or more,
The computer program implemented in usable storage medium (including but not limited to magnetic disk storage, CD-ROM, optical memory etc.) produces
The form of product.
The application is referring to method, the process of equipment (system) and computer program product according to the embodiment of the present application
Figure and/or block diagram describe.It should be understood that every one stream in flowchart and/or the block diagram can be realized by computer program instructions
The combination of process and/or box in journey and/or box and flowchart and/or the block diagram.It can provide these computer programs
Instruct the processor of general purpose computer, special purpose computer, Embedded Processor or other programmable data processing devices to produce
A raw machine, so that being generated by the instruction that computer or the processor of other programmable data processing devices execute for real
The device for the function of being specified in present one or more flows of the flowchart and/or one or more blocks of the block diagram.
These computer program instructions, which may also be stored in, is able to guide computer or other programmable data processing devices with spy
Determine in the computer-readable memory that mode works, so that it includes referring to that instruction stored in the computer readable memory, which generates,
Enable the manufacture of device, the command device realize in one box of one or more flows of the flowchart and/or block diagram or
The function of being specified in multiple boxes.
These computer program instructions also can be loaded onto a computer or other programmable data processing device, so that counting
Series of operation steps are executed on calculation machine or other programmable devices to generate computer implemented processing, thus in computer or
The instruction executed on other programmable devices is provided for realizing in one or more flows of the flowchart and/or block diagram one
The step of function of being specified in a box or multiple boxes.
In a typical configuration, calculating equipment includes one or more processors (CPU), input/output interface, net
Network interface and memory.
Memory may include the non-volatile memory in computer-readable medium, random access memory (RAM) and/
Or the forms such as Nonvolatile memory, such as read-only memory (ROM) or flash memory (flash RAM).Memory is computer-readable Jie
The example of matter.
Computer-readable medium includes permanent and non-permanent, removable and non-removable media can be by any method
Or technology come realize information store.Information can be computer readable instructions, data structure, the module of program or other data.
The example of the storage medium of computer includes, but are not limited to phase change memory (PRAM), static random access memory (SRAM), moves
State random access memory (DRAM), other kinds of random access memory (RAM), read-only memory (ROM), electric erasable
Programmable read only memory (EEPROM), flash memory or other memory techniques, read-only disc read only memory (CD-ROM) (CD-ROM),
Digital versatile disc (DVD) or other optical storage, magnetic cassettes, tape magnetic disk storage or other magnetic storage devices
Or any other non-transmission medium, can be used for storage can be accessed by a computing device information.As defined in this article, it calculates
Machine readable medium does not include temporary computer readable media (transitory media), such as the data-signal and carrier wave of modulation.
It should also be noted that, the terms "include", "comprise" or its any other variant are intended to nonexcludability
It include so that the process, method, commodity or the equipment that include a series of elements not only include those elements, but also to wrap
Include other elements that are not explicitly listed, or further include for this process, method, commodity or equipment intrinsic want
Element.In the absence of more restrictions, the element limited by sentence "including a ...", it is not excluded that including element
There is also other identical elements in process, method, commodity or equipment.
It will be understood by those skilled in the art that embodiments herein can provide as method, system or computer program product.
Therefore, complete hardware embodiment, complete software embodiment or embodiment combining software and hardware aspects can be used in the application
Form.It is deposited moreover, the application can be used to can be used in the computer that one or more wherein includes computer usable program code
The shape for the computer program product implemented on storage media (including but not limited to magnetic disk storage, CD-ROM, optical memory etc.)
Formula.
The above is only embodiments herein, are not intended to limit this application.To those skilled in the art,
Various changes and changes are possible in this application.It is all within the spirit and principles of the present application made by any modification, equivalent replacement,
Improve etc., it should be included within the scope of the claims of this application.
Claims (10)
1. a kind of data query method, which is characterized in that the described method includes:
The inquiry request that user is sent by client is received, includes target query template identification in the inquiry request；
Determine target query template corresponding with the target query template identification and candidate allocation plan；
Target allocation plan corresponding with the inquiry request is determined from the candidate allocation plan；
Data query is carried out according to the target query template and the target allocation plan, generates query result；
Service inquiry list page is generated according to the target query template, the target allocation plan and the query result
Face.
2. the method according to claim 1, wherein further including role's mark of the user in the inquiry request
Know, then it is described to determine target allocation plan corresponding with the inquiry request from the candidate allocation plan, comprising:
Determining and the user the matched allocation plan of role identification is as target configuration side from the candidate allocation plan
Case.
3. the method according to claim 1, wherein the corresponding target query mould of the target query template identification
It include the title of target matrix to be checked in plate, then it is described according to the target query template and the target allocation plan
Data query is carried out, query result is generated, comprising:
Query statement is determined according to the target query template and the target allocation plan；
It executes the query statement to access to the target matrix, generates query result.
4. the method according to claim 1, wherein corresponding with the target query template identification in the acquisition
Candidate allocation plan before, the method also includes:
It receives administrative staff and the individual cultivation request that the page is sent is configured by client；
Configuration is carried out to the metadata according to individual cultivation request and generates candidate allocation plan；
The candidate allocation plan is stored, candidate's allocation plan is corresponding with the target query template identification.
5. according to the method described in claim 4, it is characterized in that, corresponding with the target query template identification in the determination
Target query template metadata before, the method also includes:
It receives developer and each query template that the page is sent is developed by client, each query template includes multiple first numbers
According to；
It generates and is identified with the one-to-one query template of each query template；
It stores each query template mark and identifies the metadata of one-to-one query template with each query template.
6. a kind of data query device, which is characterized in that described device includes:
Receiving unit, the inquiry request sent for receiving user by client include target query in the inquiry request
Template identification；
Candidate allocation plan determination unit, for determine corresponding with target query template identification target query template and
Candidate allocation plan；
Target candidate allocation plan determination unit, for determining corresponding with the inquiry request from the candidate allocation plan
Target allocation plan；
Query unit generates inquiry for carrying out data query according to the target query template and the target allocation plan
As a result；
Service inquiry original list generation unit, for according to the target query template, the target allocation plan and institute
It states query result and generates service inquiry original list.
7. device according to claim 6, which is characterized in that further include role's mark of the user in the inquiry request
Know, then the target allocation plan determination unit, be specifically used for:
Determining and the user the matched allocation plan of role identification is as target configuration side from the candidate allocation plan
Case.
8. device according to claim 6, which is characterized in that the corresponding target query mould of the target query template identification
Include the title of target matrix to be checked in plate, then the query unit is specifically used for:
Query statement is determined according to the target query template and the target allocation plan；
It executes the query statement to access to the target matrix, generates query result.
9. a kind of storage medium, is stored thereon with program, realized when which is executed by processor as appointed in claim 1 to 5
Data query method described in one.
10. a kind of electronic equipment, the electronic equipment includes memory and processor, and the memory is for storing program, institute
Processor is stated for running program, wherein the data as described in any one of claims 1 to 5 are executed when described program is run
Querying method.
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 true CN109977317A (en) | 2019-07-05 |
| CN109977317B 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) |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110941657A (en) * | 2019-11-08 | 2020-03-31 | 支付宝(杭州)信息技术有限公司 | Service data processing method and device |
| CN112182349A (en) * | 2020-09-14 | 2021-01-05 | 支付宝(杭州)信息技术有限公司 | Method, device and system for querying compliance file |
Citations (11)
| 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 |
| CN108446286A (en) * | 2017-02-16 | 2018-08-24 | 阿里巴巴集团控股有限公司 | A kind of generation method, device and the server of the answer of natural language question sentence |
| US20180293238A1 (en) * | 2017-04-07 | 2018-10-11 | Microsoft Technology Licensing, Llc | Error message redaction in query processing |
| CN108664638A (en) * | 2018-05-15 | 2018-10-16 | 口碑(上海)信息技术有限公司 | Report form generation method based on index system and device |
| CN109272991A (en) * | 2018-09-29 | 2019-01-25 | 百度在线网络技术（北京）有限公司 | Method, apparatus, equipment and the computer readable storage medium of interactive voice |
| CN109413203A (en) * | 2018-11-29 | 2019-03-01 | 平安科技（深圳）有限公司 | A kind of transaction data acquisition methods and device |
| CN109522357A (en) * | 2018-11-28 | 2019-03-26 | 北京锐安科技有限公司 | A kind of data processing method, device, server and storage medium |
| CN109524065A (en) * | 2018-11-07 | 2019-03-26 | 平安医疗健康管理股份有限公司 | Medical data querying method, medical data platform and relevant apparatus |
| 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 (11)
| 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 |
| CN108446286A (en) * | 2017-02-16 | 2018-08-24 | 阿里巴巴集团控股有限公司 | A kind of generation method, device and the server of the answer of natural language question sentence |
| US20180293238A1 (en) * | 2017-04-07 | 2018-10-11 | Microsoft Technology Licensing, Llc | Error message redaction in query processing |
| CN108132987A (en) * | 2017-12-14 | 2018-06-08 | 浙江航天恒嘉数据科技有限公司 | A kind of data query system and method |
| CN108664638A (en) * | 2018-05-15 | 2018-10-16 | 口碑(上海)信息技术有限公司 | Report form generation method based on index system and device |
| CN109272991A (en) * | 2018-09-29 | 2019-01-25 | 百度在线网络技术（北京）有限公司 | Method, apparatus, equipment and the computer readable storage medium of interactive voice |
| CN109542635A (en) * | 2018-10-17 | 2019-03-29 | 深圳壹账通智能科技有限公司 | Configuration information update method, apparatus, computer equipment and storage medium |
| 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 |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110941657A (en) * | 2019-11-08 | 2020-03-31 | 支付宝(杭州)信息技术有限公司 | Service data processing method and device |
| CN110941657B (en) * | 2019-11-08 | 2023-03-31 | 支付宝(杭州)信息技术有限公司 | Service data processing method and device |
| CN112182349A (en) * | 2020-09-14 | 2021-01-05 | 支付宝(杭州)信息技术有限公司 | Method, device and system for querying compliance file |
Also Published As
| Publication number | Publication date |
|---|---|
| CN109977317B (en) | 2021-04-27 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US10740093B2 (en) | Advanced packaging techniques for improving work flows | |
| CN110058856A (en) | Page configuration method and device | |
| CN105426223B (en) | Using loading method and device | |
| Lampa et al. | SciPipe: A workflow library for agile development of complex and dynamic bioinformatics pipelines | |
| CN103150145B (en) | The parallel processing of semantic grouped data in data warehouse environment | |
| CN109657427A (en) | The method and device of permission control | |
| CN110019111A (en) | Data processing method, device, storage medium and processor | |
| CN112346717A (en) | Micro service system creating method, device, equipment, medium and micro service system | |
| CN110069487A (en) | A kind of data processing method, apparatus and system | |
| CN109977317A (en) | Data query method and device | |
| CN114331428A (en) | Non-homogeneous evidence-based distribution method and device | |
| CN113569257B (en) | User authority management method and device in gray level release | |
| CN109684381A (en) | Data hot statistics method and device | |
| CN110069488A (en) | A kind of date storage method, method for reading data and its device | |
| CN109492349A (en) | A kind of method and apparatus with management document distribution channel for identification | |
| CN116450107B (en) | Method and device for secondary development of software by low-code platform and electronic equipment | |
| CN109388644A (en) | A kind of data-updating method and device | |
| CN110069453A (en) | Operation/maintenance data treating method and apparatus | |
| CN109471901A (en) | A kind of method of data synchronization and device | |
| CN106603727A (en) | Method and device for integrating and accessing system data | |
| CN111131474A (en) | Method, device and medium for managing user protocol based on block chain | |
| CN109582476A (en) | Data processing method, apparatus and system | |
| CN109101514A (en) | Data lead-in method and device | |
| CN110175036B (en) | Upgrading method and device for soft lock permission | |
| CN110019508A (en) | A kind of method of data synchronization, apparatus and system |
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 |