CN110083655A - Querying method, device, computer equipment and the storage medium of merchant data - Google Patents
Querying method, device, computer equipment and the storage medium of merchant data Download PDFInfo
- Publication number
- CN110083655A CN110083655A CN201811647853.9A CN201811647853A CN110083655A CN 110083655 A CN110083655 A CN 110083655A CN 201811647853 A CN201811647853 A CN 201811647853A CN 110083655 A CN110083655 A CN 110083655A
- Authority
- CN
- China
- Prior art keywords
- merchant data
- inquiry request
- query task
- report
- data
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The present invention relates to a kind of querying method of merchant data, device, computer equipment and storage mediums, by obtaining the corresponding inquiry request of merchant data；According to the corresponding inquiry request of merchant data, the corresponding query task of inquiry request is determined；According to the corresponding query task of inquiry request, each back end obtains the corresponding merchant data of query task from cluster；The merchant data obtained from each back end is summarized.Realize it is quick, accurate, easily search merchant data corresponding with inquiry request.
Description
Technical field
The present invention relates to field of computer technology, especially a kind of querying method of merchant data, device, computer are set
Standby and storage medium.
Background technique
Trade company's management software is to guarantee that enterprise operation works normally essential operation platform, utilizes present information skill
Art and network communications technology carry out comprehensive management to links such as prediction, plan, control, supervision in management.
Trade company's management software is integrated with operation function to realize resource most by being intended to, organizing, controlling, coordinating
Excellent configuration improves the service efficiency of trade company's economic resources, provides the foundation of science for trade company's optimum management and business decision.
With the increase of merchant data amount, querying method in the traditional technology technical problem slow there are inquiry velocity.
Summary of the invention
Based on this, it is necessary to for the technical problem that inquiry velocity existing for the querying method in traditional technology is slow, provide
A kind of querying method of merchant data, device, computer equipment and storage medium.
A kind of querying method of merchant data, which comprises
Obtain the corresponding inquiry request of merchant data；
According to the corresponding inquiry request of the merchant data, the corresponding query task of the inquiry request is determined；
According to the corresponding query task of the inquiry request, each back end obtains the query task from cluster
Corresponding merchant data；
The merchant data obtained from each back end is summarized.
The method also includes merchant datas after summarizing described in return in one of the embodiments,.
The inquiry request includes searching keyword in one of the embodiments,；It is described according to the merchant data pair
The inquiry request answered determines the corresponding query task of the inquiry request, comprising: according to the searching keyword, described in generation
The corresponding query task of inquiry request.
The inquiry request is report query request in one of the embodiments, and the report query request includes report
Table name；It is described that the corresponding query task of the inquiry request is generated according to the corresponding inquiry request of the merchant data, packet
It includes:
It is inquired according to the report name, according to the corresponding relationship of the report name and query task that prestore, is obtained
Query task corresponding with the report name；
It is described according to the corresponding query task of the inquiry request, each back end obtains the inquiry from cluster
The corresponding merchant data of task, comprising:
According to the corresponding query task of the report name, it is corresponding to obtain the report for each back end from cluster
Merchant data.
The merchant data obtained from each back end is converged described in one of the embodiments,
After in a word, the method also includes: corresponding report is generated according to the corresponding merchant data of the report, returns to the report.
In one of the embodiments, before the inquiry request for obtaining merchant data, which comprises will
Merchant data real-time synchronization in relevant database is to each back end.
In one of the embodiments, in the merchant data real-time synchronization by relevant database to described each
Before a back end, which comprises obtain the incremental data of merchant data；The incremental data includes newly-increased quotient
The merchant data of user data and update.
A kind of inquiry unit of merchant data, described device include:
Inquiry request obtains module, for obtaining the corresponding inquiry request of merchant data；
Query task determining module, for determining the inquiry request according to the corresponding inquiry request of the merchant data
Corresponding query task；
Merchant data obtains module, is used for according to the corresponding query task of the inquiry request, each data from cluster
Node obtains the corresponding merchant data of the query task；
Summarizing module, for summarizing the merchant data obtained from each back end.
A kind of computer equipment can be run on a memory and on a processor including memory, processor and storage
The step of computer program, the processor realizes method described in any of the above-described embodiment when executing the computer program.
A kind of computer readable storage medium, is stored thereon with computer program, and the computer program is held by processor
The step of method described in any of the above-described embodiment is realized when row.
Querying method, device, computer equipment and the storage medium of above-mentioned merchant data, by obtaining merchant data pair
The inquiry request answered；According to the corresponding inquiry request of merchant data, the corresponding query task of inquiry request is determined；According to inquiry
Corresponding query task is requested, each back end obtains the corresponding merchant data of query task from cluster；It will be from each number
Summarized according to the merchant data obtained in node.Realize it is quick, accurate, easily search it is corresponding with inquiry request
Merchant data.
Detailed description of the invention
Fig. 1 is the applied environment figure of the querying method of merchant data in one embodiment；
Fig. 2 is the flow diagram of the querying method of merchant data in one embodiment；
Fig. 3 is the flow diagram of the querying method of merchant data in one embodiment；
Fig. 4 is the flow diagram of the querying method of merchant data in one embodiment；
Fig. 5 is the flow diagram of the querying method of merchant data in one embodiment；
Fig. 6 is the applied environment figure of the querying method of merchant data in one embodiment；
Fig. 7 is the flow diagram of the querying method of merchant data in one embodiment；
Fig. 8 is the flow diagram of the querying method of merchant data in one embodiment；
Fig. 9 is the structural block diagram of the inquiry unit of merchant data in one embodiment；
Figure 10 is the structural block diagram of the inquiry unit of merchant data in one embodiment；
Figure 11 is the structural block diagram of the inquiry unit of merchant data in one embodiment；
Figure 12 is the internal structure chart of computer equipment in one embodiment.
Specific embodiment
In order to make the objectives, technical solutions, and advantages of the present invention clearer, with reference to the accompanying drawings and embodiments,
The present invention will be described in further detail.It should be appreciated that specific embodiment described herein is only used to explain this hair
It is bright, it is not intended to limit the present invention.
The application provides a kind of querying method of merchant data, can be applied in application environment shown in FIG. 1.Wherein,
Terminal 110 carries out data interaction or terminal 110 and server 120 in same intelligent terminal by network and server 120
On, data interaction is carried out by inter-thread communication mode, the application to the data interactive mode of terminal 110 and server 120 not
It is limited.Server 120 carries out data interaction by network and back end 130.
Terminal 110 is displayed for the interface of management software, and interface can be each management function in management software
Display interface is also possible to the set interface of management software, can be with the letter such as display data report or business diary record
Breath, terminal 110 can be also used for issuing to server 120 and request, for example the newly-built request of configuring request, document, document are looked into
See request, the edit requests of document and inquiry request etc..Terminal 110 receives the inquiry content of user's input, and triggers trade company's number
According to corresponding inquiry request, the corresponding inquiry request of merchant data is sent to server 120 by network by terminal 110.Service
Device 120 obtains the corresponding inquiry request of merchant data by terminal 110, and according to the corresponding inquiry request of merchant data,
Determine the corresponding query task of inquiry request.Query task is issued in each back end 130 by server 120, data
Node 130 is inquired according to the corresponding query task of inquiry request, and the merchant data inquired is returned to server
120.Then server 120 obtains the corresponding merchant data of query task from each back end 130, and server 120 will
The merchant data obtained from each back end is summarized.
Wherein, terminal 110 can be, but not limited to be various personal computers, laptop, smart phone, plate electricity
Brain and portable wearable device, server 120 or back end 130 can use independent server either multiple clothes
The server cluster of business device composition is realized.
In one embodiment, as shown in Fig. 2, providing a kind of querying method of merchant data, it is applied in this way
It is illustrated in the server of Fig. 1, comprising the following steps:
S210, the corresponding inquiry request of merchant data is obtained.
Wherein, inquiry request can be the solicited message of the inquiry merchant data of terminal to server transmission.Specifically,
When user needs to inquire corresponding merchant data, user can pass through the application program or webpage input needs in terminal
The content of inquiry triggers corresponding inquiry request, which is sent to server by terminal, and server gets this and looks into
Ask request.
S220, according to the corresponding inquiry request of merchant data, determine the corresponding query task of inquiry request.
Wherein, query task can be server and be handed down to the sentence that back end in cluster carries out merchant data inquiry,
Such as SQL statement.Specifically, user can trigger corresponding inquiry request by terminal, and server receives merchant data pair
The inquiry request answered, and according to the corresponding inquiry request of merchant data, determine the corresponding query statement of inquiry request.
S230, according to the corresponding query task of inquiry request, it is corresponding to obtain query task for each back end from cluster
Merchant data.
Wherein, cluster refers to the service entities of one group of collaborative work, to provide with scalability and high availability
Service platform.The feature of cluster includes communicating often between single cluster address (being also single image), each entity of cluster.Than
Such as, cluster can be Hive cluster, and Hive is a Tool for Data Warehouse based on Hadoop, can be by the data of structuring
File Mapping is a database table, and provides complete SQL query function, and class SQL statement is converted to MapReduce and is appointed
Business.Specifically, the corresponding query statement of inquiry request is issued to each back end, back end in middle cluster by server
It is inquired according to the query statement received, finds corresponding merchant data, the merchant data found is sent to clothes
Business device, i.e. server each back end from cluster obtain the corresponding merchant data of query task.
S240, the merchant data obtained from each back end is summarized.
Specifically, server each back end from cluster obtains the corresponding merchant data of query task, will acquire
Merchant data summarized, obtain the corresponding whole merchant datas of inquiry request.
In the present embodiment, by obtaining the corresponding inquiry request of merchant data；It is asked according to the corresponding inquiry of merchant data
It asks, determines the corresponding query task of inquiry request；According to the corresponding query task of inquiry request, each data section from cluster
Point obtains the corresponding merchant data of query task；The merchant data obtained from each back end is summarized.It realizes
Quickly, merchant data corresponding with inquiry request precisely, is easily searched.
In one embodiment, as shown in figure 3, this method further include:
S310, the merchant data after summarizing is returned.
In the present embodiment, the content that user can need to inquire by application program in terminal or webpage input, touching
Send out inquiry request corresponding, which is sent to server by terminal, and server gets the inquiry request, and according to
The corresponding inquiry request of merchant data determines the corresponding query task of inquiry request.Query task is issued to middle collection by server
Each back end in group, back end are inquired according to the query task received, find corresponding merchant data,
The merchant data found is sent to server, it is corresponding that server each back end from cluster obtains query task
Merchant data, and summarized.Finally, whole merchant datas after summarizing return to terminal.
In one embodiment, inquiry request includes searching keyword.According to the corresponding inquiry request of merchant data, really
Determine the corresponding query task of inquiry request, comprising: according to searching keyword, generate the corresponding query task of inquiry request.
Wherein, searching keyword can be word involved in trade company's operation process, for example, can with the date, supplier, adopt
Any of purchase personnel title, administrative staff's title, the amount of money, document odd numbers etc. or a combination thereof.Specifically, it is needed in user
When inquiring corresponding merchant data, user can be touched by the application program or webpage input inquiry keyword in terminal
Send out inquiry request corresponding, terminal will include that the inquiry request of searching keyword is sent to server, and server gets this and looks into
Ask request.Server generates the corresponding query task of inquiry request according to the searching keyword in inquiry request.Query task
It can be fuzzy query sentence, be also possible to accurate query statement.Server is by fuzzy query sentence or accurate query statement
The each back end being issued in cluster, each back end are carried out according to fuzzy query sentence or accurate query statement
Inquiry, and the merchant data found is sent to server, the merchant data that server finds each back end
Summarized, and is back to terminal.
In the present embodiment, fuzzy query or accurate inquiry are carried out to merchant data according to searching keyword, it is comprehensive and
Rapidly meet the query demand of trade company.
In one embodiment, inquiry request is report query request, and report query request includes report name.Such as Fig. 4
It is shown, according to the corresponding inquiry request of merchant data, generate the corresponding query task of inquiry request, comprising:
S410, it is inquired according to report name, according to the corresponding relationship of the report name and query task that prestore, is obtained
To query task corresponding with report name.
According to the corresponding query task of inquiry request, each back end obtains the corresponding quotient of query task from cluster
User data, comprising:
S420, according to the corresponding query task of report name, each back end obtains the corresponding quotient of report from cluster
User data.
Wherein, report is the mode for showing trade company's statistical data.Report can be with formats such as table, charts and show
Merchant data.Report name can quickly know that report includes the quotient of which aspect by report name for identifying a report
User data.The formation of report needs corresponding merchant data, and merchant data needs corresponding query statement with from each data section
It is searched in point, has then been previously stored report name and query task corresponding relationship in server.
Specifically, user can pass through the application program or webpage selection report query request in terminal.Report query
Request includes report name.Server is inquired according to report name, according to pair of the report name and query task that prestore
It should be related to, obtain query task corresponding with report name, the corresponding query task of report name is issued to each in cluster
A back end, each back end carry out the inquiry of merchant data, the trade company's number that will be found according to respective query task
According to server is sent to, server each back end from cluster obtains the corresponding merchant data of report.It is understood that
Be, the corresponding merchant data amount of report may be it is huge, then query statement may be complicated, the corresponding query task of report
The script represenation including query statement can be passed through.
Further, Fig. 5 is referred to, after it will be summarized from the merchant data obtained in each back end, side
Method further include:
S510, corresponding report is generated according to the corresponding merchant data of report, returns to report.
Specifically, server each back end from cluster obtains the corresponding merchant data of report, the quotient that will acquire
User data is summarized, and generates corresponding report according to the corresponding merchant data of report, and return to report.
In the present embodiment, by obtaining report query request, report query request includes report name, according to report name
Title is inquired, and each back end obtains the corresponding merchant data of the corresponding query task report of inquiry request from cluster,
And corresponding report is generated according to the corresponding merchant data of the corresponding query task report of inquiry request, return to inquiry request pair
The query task report answered.Quick search merchant data in the form of statements is realized, and by report intuitively to trade company's exhibition
Show merchant data.
In one embodiment, as shown in fig. 6, the querying method of merchant data provided in this embodiment, can be applied to
In application environment as shown in FIG. 6.Comprising: terminal 110, server 120, back end 130 and relevant database service
Device 610.Wherein, terminal 110 is communicated with server 120 by network, and server 120 and back end 130 pass through network
It is communicated, back end 130 is communicated with relational database server 610 by network.Relevant database service
Device 610 is communicated with terminal 110 by network.
Specifically, terminal 110, which is equipped with corresponding application program or opens, corresponding webpage, and user passes through terminal
When application program or webpage on 110 create a document, the data inserted in document can be stored in relevant database clothes
Business device 610.When user is updated the data in a document by application program in terminal 110 or webpage, update
Data afterwards can be stored in relational database server 610.Then relational database server 610 is stored with passes through with trade company
Seek related relationship type merchant data.When merchant data changes, relational database server 610 is according to trade company's number
According to variation generate incremental data, incremental data includes the merchant data of newly-increased merchant data and update.Work as relational data
It, will be in the merchant data real-time synchronization in relevant database to each back end 130 when library server 610 changes.
Illustratively, back end 130 can be Hive data warehouse, by the relationship type number in relational database server 610
Hive data warehouse is synchronized to when factually.It is looked into when user carries out merchant data by application program in terminal 110 or webpage
When inquiry, server 120 obtains the corresponding inquiry request of merchant data；According to the corresponding inquiry request of merchant data, inquiry is determined
Request corresponding query task；According to the corresponding query task of inquiry request, each acquisition of back end 130 is looked into from cluster
The corresponding merchant data of inquiry task；The merchant data obtained from each back end 130 is summarized, and is back to end
End 110.
In one embodiment, before the inquiry request for obtaining merchant data, this method comprises: by relational data
Merchant data real-time synchronization in library is to each back end.
Further, before by the merchant data real-time synchronization in relevant database to each back end,
This method comprises: obtaining the incremental data of merchant data；Incremental data includes trade company's number of newly-increased merchant data and update
According to.
Specifically, relational database server generates incremental data according to the variation of merchant data, and incremental data includes
The merchant data of newly-increased merchant data and update.For example, the data inserted in document can deposit when trade company creates a document
Storage is in relational database server；Or when trade company's one document of update, relationship can be stored in the updated data of document
Type database server.It is when relational database server changes, the merchant data in relevant database is real-time
It synchronizes in each back end.
Illustratively, relational database can be MySQL database, and back end can be Hive back end.User is new
When increasing document or updating data in document, the data in MySQL database change, by Canal by MySQL data
Incremental data in library is synchronized to Hive back end.
In one embodiment, as shown in fig. 7, the application provides a kind of querying method of merchant data, this method is also wrapped
Include following steps:
S710, the incremental data for obtaining merchant data.
S720, by the merchant data real-time synchronization in relevant database to each back end.
S730, the corresponding inquiry request of merchant data is obtained, inquiry request includes searching keyword.
S740, according to searching keyword, generate the corresponding query task of inquiry request.
S750, according to the corresponding query task of inquiry request, it is corresponding to obtain query task for each back end from cluster
Merchant data.
S760, the merchant data obtained from each back end is summarized.
S770, the merchant data after summarizing is returned.
In one embodiment, as shown in figure 8, the application provides a kind of querying method of merchant data, this method is also wrapped
Include following steps:
S810, the incremental data for obtaining merchant data.
S820, by the merchant data real-time synchronization in relevant database to each back end.
S830, report query request is obtained, report query request includes report name.
S840, it is inquired according to report name, according to the corresponding relationship of the report name and query task that prestore, is obtained
To query task corresponding with report name.
S850, according to the corresponding query task of report name, each back end obtains the corresponding quotient of report from cluster
User data.
S860, the merchant data obtained from each back end is summarized.
S870, corresponding report is generated according to the corresponding merchant data of report, returns to report.
It should be understood that although each step in the flow chart of Fig. 2-8 is successively shown according to the instruction of arrow,
It is these steps is not that the inevitable sequence according to arrow instruction successively executes.Unless expressly stating otherwise herein, these steps
There is no stringent sequences to limit for rapid execution, these steps can execute in other order.Moreover, in Fig. 2-8 at least
A part of step may include that perhaps these sub-steps of multiple stages or stage are not necessarily same to multiple sub-steps
Moment executes completion, but can execute at different times, and the execution sequence in these sub-steps or stage is also not necessarily
Successively carry out, but can at least part of the sub-step or stage of other steps or other steps in turn or
Alternately execute.
In one embodiment, as shown in figure 9, providing a kind of inquiry unit of merchant data.The inquiry unit 900
Module 910, query task determining module 920, merchant data, which are obtained, including inquiry request obtains module 930 and summarizing module
940.Wherein:
Inquiry request obtains module 910, for obtaining the corresponding inquiry request of merchant data.
Query task determining module 920, for determining that inquiry request is corresponding according to the corresponding inquiry request of merchant data
Query task.
Merchant data obtains module 930, is used for according to the corresponding query task of inquiry request, each data from cluster
Node obtains the corresponding merchant data of query task.
Summarizing module 940, for summarizing the merchant data obtained from each back end.
In one embodiment, as shown in Figure 10, which further includes return module 1010, is converged for returning
The merchant data of the General Logistics Department.
In one embodiment, inquiry request includes searching keyword.Query task determining module 920, is also used to basis
Searching keyword generates the corresponding query task of inquiry request.
In one embodiment, inquiry request is report query request, and report query request includes report name.Inquiry
Task determining module 920 is also used to be inquired according to report name, according to pair of the report name and query task that prestore
It should be related to, obtain query task corresponding with report name.
Merchant data obtains module 930, is also used to according to the corresponding query task of report name, each number from cluster
The corresponding merchant data of report is obtained according to node.
In one embodiment, as shown in figure 11, which further includes report generation module 1110, is used for root
Corresponding report is generated according to the corresponding merchant data of report, returns to report.
In one embodiment, which further includes data simultaneous module, and being used for will be in relevant database
Merchant data real-time synchronization to each back end.
In one embodiment, which further includes that incremental data obtains module, for obtaining merchant data
Incremental data；Incremental data includes the merchant data of newly-increased merchant data and update.
The specific of inquiry unit about merchant data limits the querying method that may refer to above for merchant data
Restriction, details are not described herein.Modules in the inquiry unit of above-mentioned merchant data can fully or partially through software,
Hardware and combinations thereof is realized.Above-mentioned each module can be embedded in the form of hardware or independently of the processor in computer equipment
In, it can also be stored in a software form in the memory in computer equipment, in order to which processor calls execution above each
The corresponding operation of module.
In one embodiment, a kind of computer equipment is provided, which can be terminal, internal junction
Composition is shown in Fig.12.The computer equipment include by system bus connect processor, memory, network interface,
Display screen and input unit.Wherein, the processor of the computer equipment is for providing calculating and control ability.The computer is set
Standby memory includes non-volatile memory medium, built-in storage.The non-volatile memory medium is stored with operating system and meter
Calculation machine program.The built-in storage provides environment for the operation of operating system and computer program in non-volatile memory medium.
The network interface of the computer equipment is used to communicate with external terminal by network connection.The computer program is by processor
A kind of querying method of merchant data is realized when execution.The display screen of the computer equipment can be liquid crystal display or
Electric ink display screen, the input unit of the computer equipment can be the touch layer covered on display screen, be also possible to count
Key, trace ball or the Trackpad being arranged on machine equipment shell are calculated, can also be external keyboard, Trackpad or mouse etc..
It will be understood by those skilled in the art that structure shown in Figure 12, only part relevant to application scheme
The block diagram of structure, does not constitute the restriction for the computer equipment being applied thereon to application scheme, and specific computer is set
Standby may include perhaps combining certain components or with different component cloth than more or fewer components as shown in the figure
It sets.
In one embodiment, it provides a kind of computer equipment, including memory, processor and is stored in memory
Computer program that is upper and can running on a processor, processor realize method in above-described embodiment when executing computer program
Step.
In one embodiment, a kind of computer readable storage medium is provided, computer program is stored thereon with, is counted
Calculation machine program realizes the method and step in above-described embodiment when being executed by processor.
Those of ordinary skill in the art will appreciate that realizing all or part of the process in above-described embodiment method, being can
It is completed with instructing relevant hardware by computer program, the computer program can be stored in a non-volatile meter
In calculation machine read/write memory medium, the computer program is when being executed, it may include such as the process of the embodiment of above-mentioned each method.
Wherein, any of memory, storage, database or other media is drawn used in each embodiment provided herein
With may each comprise non-volatile and/or volatile memory.Nonvolatile memory may include read-only memory (ROM), can
Programming ROM (PROM), electrically programmable ROM (EPROM), electrically erasable ROM (EEPROM) or flash memory.Volatile storage
Device may include random access memory (RAM) or external cache.By way of illustration and not limitation, RAM is with a variety of
Form can obtain, such as static state RAM (SRAM), dynamic ram (DRAM), synchronous dram (SDRAM), double data rate sdram
(DDRSDRAM), enhanced SDRAM (ESDRAM), synchronization link (Synchlink) DRAM (SLDRAM), memory bus
(Rambus) direct RAM (RDRAM), direct memory bus dynamic ram (DRDRAM) and memory bus dynamic ram
(RDRAM) etc..
Each technical characteristic of embodiment described above can be combined arbitrarily, for simplicity of description, not to above-mentioned reality
It applies all possible combination of each technical characteristic in example to be all described, as long as however, the combination of these technical characteristics is not deposited
In contradiction, all should be considered as described in this specification.
The embodiments described above only express several embodiments of the present invention, and the description thereof is more specific and detailed, but simultaneously
It cannot therefore be construed as limiting the scope of the patent.It should be pointed out that coming for those of ordinary skill in the art
It says, without departing from the inventive concept of the premise, various modifications and improvements can be made, these belong to guarantor of the invention
Protect range.Therefore, the scope of protection of the patent of the invention shall be subject to the appended claims.
Claims (10)
1. a kind of querying method of merchant data, which is characterized in that the described method includes:
Obtain the corresponding inquiry request of merchant data；
According to the corresponding inquiry request of the merchant data, the corresponding query task of the inquiry request is determined；
According to the corresponding query task of the inquiry request, it is corresponding to obtain the query task for each back end from cluster
Merchant data；
The merchant data obtained from each back end is summarized.
2. querying method according to claim 1, which is characterized in that the method also includes:
Merchant data after summarizing described in return.
3. querying method according to claim 2, which is characterized in that the inquiry request includes searching keyword；It is described
According to the corresponding inquiry request of the merchant data, the corresponding query task of the inquiry request is determined, comprising:
According to the searching keyword, the corresponding query task of the inquiry request is generated.
4. querying method according to claim 1, which is characterized in that the inquiry request is report query request, described
Report query request includes report name；It is described according to the corresponding inquiry request of the merchant data, generate the inquiry request
Corresponding query task, comprising:
It is inquired according to the report name, according to the corresponding relationship of the report name and query task that prestore, is obtained and institute
State the corresponding query task of report name；
It is described according to the corresponding query task of the inquiry request, each back end obtains the query task pair from cluster
The merchant data answered, comprising:
According to the corresponding query task of the report name, each back end obtains the corresponding trade company of the report from cluster
Data.
5. querying method according to claim 4, which is characterized in that will be obtained from each back end described
Merchant data summarized after, the method also includes:
Corresponding report is generated according to the corresponding merchant data of the report, returns to the report.
6. querying method according to claim 1, which is characterized in that it is described obtain merchant data inquiry request it
Before, which comprises
By the merchant data real-time synchronization in relevant database to each back end.
7. querying method according to claim 1, which is characterized in that in the merchant data by relevant database
Before real-time synchronization to each back end, which comprises
Obtain the incremental data of merchant data；The incremental data includes the merchant data of newly-increased merchant data and update.
8. a kind of inquiry unit of merchant data, which is characterized in that described device includes:
Inquiry request obtains module, for obtaining the corresponding inquiry request of merchant data；
Query task determining module, for determining that the inquiry request is corresponding according to the corresponding inquiry request of the merchant data
Query task；
Merchant data obtains module, is used for according to the corresponding query task of the inquiry request, each back end from cluster
Obtain the corresponding merchant data of the query task；
Summarizing module, for summarizing the merchant data obtained from each back end.
9. a kind of computer equipment including memory, processor and stores the meter that can be run on a memory and on a processor
Calculation machine program, which is characterized in that the processor realizes any one of claims 1 to 7 institute when executing the computer program
The step of stating method.
10. a kind of computer readable storage medium, is stored thereon with computer program, which is characterized in that the computer program
The step of method described in any one of claims 1 to 7 is realized when being executed by processor.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201811647853.9A CN110083655A (en) | 2018-12-29 | 2018-12-29 | Querying method, device, computer equipment and the storage medium of merchant data |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201811647853.9A CN110083655A (en) | 2018-12-29 | 2018-12-29 | Querying method, device, computer equipment and the storage medium of merchant data |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN110083655A true CN110083655A (en) | 2019-08-02 |
Family
ID=67412912
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201811647853.9A Pending CN110083655A (en) | 2018-12-29 | 2018-12-29 | Querying method, device, computer equipment and the storage medium of merchant data |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN110083655A (en) |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105426481A (en) * | 2015-11-19 | 2016-03-23 | 北京京东尚科信息技术有限公司 | Data processing method and device |
| US20160179857A1 (en) * | 2014-12-18 | 2016-06-23 | International Business Machines Corporation | Database joins using uncertain criteria |
| CN105989150A (en) * | 2015-03-02 | 2016-10-05 | 中国移动通信集团四川有限公司 | Data query method and device based on big data environment |
| CN109033123A (en) * | 2018-05-31 | 2018-12-18 | 康键信息技术（深圳）有限公司 | Querying method, device, computer equipment and storage medium based on big data |
-
2018
- 2018-12-29 CN CN201811647853.9A patent/CN110083655A/en active Pending
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20160179857A1 (en) * | 2014-12-18 | 2016-06-23 | International Business Machines Corporation | Database joins using uncertain criteria |
| CN105989150A (en) * | 2015-03-02 | 2016-10-05 | 中国移动通信集团四川有限公司 | Data query method and device based on big data environment |
| CN105426481A (en) * | 2015-11-19 | 2016-03-23 | 北京京东尚科信息技术有限公司 | Data processing method and device |
| CN109033123A (en) * | 2018-05-31 | 2018-12-18 | 康键信息技术（深圳）有限公司 | Querying method, device, computer equipment and storage medium based on big data |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| Mwilu et al. | Design science research contribution to business intelligence in the cloud—A systematic literature review | |
| US20220215125A1 (en) | Viewing, selecting, and triggering a data pipeline to derive a collaborative dataset | |
| CN112287015B (en) | Image generation system, image generation method, electronic device, and storage medium | |
| CN110795509A (en) | Method and device for constructing index blood relationship graph of data warehouse and electronic equipment | |
| US9152998B2 (en) | Investor relations systems and methods | |
| US20190073610A1 (en) | Query-based identifiers for cross-session response tracking | |
| US20100211862A1 (en) | Facilitating spreadsheet and database views on common data store | |
| CN110266752A (en) | Block chain information method for pushing, device, computer equipment and storage medium | |
| CN108664582A (en) | Querying method, device, computer equipment and the storage medium of business connection | |
| CN111046237A (en) | User behavior data processing method and device, electronic equipment and readable medium | |
| US20190050435A1 (en) | Object data association index system and methods for the construction and applications thereof | |
| US20090287675A1 (en) | Extending OLAP Navigation Employing Analytic Workflows | |
| CN112632025A (en) | Power grid enterprise management decision support application system based on PAAS platform | |
| CN109767098A (en) | Processing method, device, computer equipment and the storage medium of product attribute | |
| CN110213071A (en) | Verification of data method, apparatus, system, computer equipment and storage medium | |
| Vithayathil et al. | Organizational Structure for the IT Department: Profit Center or Cost Center? | |
| Mohamadina et al. | Business intelligence: concepts, issues and current systems | |
| Mishra et al. | Challenges in big data application: a review | |
| US8417594B2 (en) | Dimension-based financial reporting using multiple combinations of dimensions | |
| CN110083655A (en) | Querying method, device, computer equipment and the storage medium of merchant data | |
| CN110275798A (en) | Block chain data processing method, device, server and storage medium | |
| CN111522840B (en) | Label configuration method, device, equipment and computer readable storage medium | |
| CN108831531A (en) | A kind of long-range processing method of adaptive medical image and application system based on cloud computing | |
| CN108170718A (en) | A kind for the treatment of method and apparatus of achievement data | |
| CN115017185A (en) | Data processing method, device and storage medium |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| RJ01 | Rejection of invention patent application after publication | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20190802 |