CN106250501A - Report processing method and reporting system - Google Patents
Report processing method and reporting system Download PDFInfo
- Publication number
- CN106250501A CN106250501A CN201610625033.4A CN201610625033A CN106250501A CN 106250501 A CN106250501 A CN 106250501A CN 201610625033 A CN201610625033 A CN 201610625033A CN 106250501 A CN106250501 A CN 106250501A
- Authority
- CN
- China
- Prior art keywords
- time point
- query result
- query
- search server
- query information
- 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
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/245—Query processing
Abstract
The embodiment of the present invention provides a kind of report processing method and reporting system.A kind of report processing method includes: obtain the Query Information of user's input;According to described Query Information, obtain the Query Result mated with described Query Information from search server;Form is generated according to described Query Result.The present invention improves the speed of report generation.
Description
Technical field
The present invention relates to data processing field, particularly relate to a kind of report processing method and reporting system.
Background technology
Form is basic measures and the approach of business administration, is the basic service requirement of enterprise.Form can by data with
Reliable and safe mode presents to user.Such as, for sale enterprise, manager can pass through form firm sale personnel
The call itemization conversed is carried out by the telephone traffic center of this enterprise.
In prior art, all it is saved in data base for generating the data of form.When needs generate form, need basis
The querying condition of user input inquires about data corresponding with this querying condition in data base, the data found further according to inquiry
Generate form.General large enterprise has substantial amounts of data to need to be updated to data base every day, the data volume of storage in data base
Bigger.And data base supports poor for big data quantity, after data volume is more than ten million rank, search efficiency is decreased obviously.
Therefore, in prior art, there is the slow problem of report generation.
Summary of the invention
The present invention provides a kind of report processing method and reporting system, in order to solve in prior art report generation speed relatively
Slow problem.
First aspect, the present invention provides a kind of report processing method, including:
Obtain the Query Information of user's input;
According to described Query Information, obtain the Query Result mated with described Query Information from search server;
Form is generated according to described Query Result.
In a kind of possible design, described Query Information includes the first start time point and the first end time point.
In a kind of possible design, described first start time point and described first end time put all early than time default
Between point;
Described according to described Query Information, the Query Result mated with described Query Information, bag is obtained from search server
Include:
According to described first start time point, described first the end time point and described Preset Time point, determine needs from
Described search server obtains the first Query Result mated with described Query Information;
According to described Query Information, from described search server, obtain described first Query Result;
Accordingly, described according to described Query Result generate form, including:
Form is generated according to described first Query Result.
In a kind of possible design, described first start time point is early than Preset Time point, described first end time
Point is later than described Preset Time point;
Described according to described Query Information, the Query Result mated with described Query Information, bag is obtained from search server
Include:
According to described first start time point, described first the end time point and described Preset Time point, determine needs from
Described search server obtains the first Query Result mated with described Query Information and it needs to obtain from described data base
The second Query Result mated with described Query Information;
According to described Query Information, from described search server, obtain described first Query Result, and from described data
Storehouse obtains described second Query Result;
Accordingly, described according to described Query Result generate form, including:
Form is generated according to described first Query Result and described second Query Result.
In a kind of possible design, described according to described Query Information, from described search server, obtain described
One Query Result, and from described data base, obtain described second Query Result, including:
Generate the first sub-information of inquiry and second according to described Query Information and inquire about sub-information;Wherein, second is included described in
Start time point and the second end time point, described second start time point be equal to described first start time point, described second
End time, point was equal to described Preset Time point;At the end of the described second sub-information of inquiry includes the 3rd start time point and the 3rd
Between point, described 3rd start time point be equal to described Preset Time point, described 3rd the end time point equal to described first terminate
Time point;
Described first Query Result mated with described first Query Information is obtained from described search server;
Described second Query Result mated with described second Query Information is obtained from described data base.
In a kind of possible design, described method also includes:
When arriving described Preset Time point, the data syn-chronization that will generate before Preset Time point described in described data base
To described search server, and the data deletion that will generate before Preset Time point described in described data base.
In a kind of possible design, described method also includes: when arriving described Preset Time point, will be synchronized to described
The data of search server back up in distributed file system.
In a kind of possible design, described method also includes: to the previous existence of preset time period in described search server
The data become are deleted.
Second aspect, the present invention provides a kind of reporting system, including:
Acquisition module, for obtaining the Query Information of user's input;
Enquiry module, for according to described Query Information, obtaining and looking into that described Query Information mates from search server
Ask result;
Generation module, for generating form according to described Query Result.
In a kind of possible design, described Query Information includes the first start time point and the first end time point.
In a kind of possible design, described first start time point and described first end time put all early than time default
Between point;
Described enquiry module, specifically for:
According to described first start time point, described first the end time point and described Preset Time point, determine needs from
Described search server obtains the first Query Result mated with described Query Information;
According to described Query Information, from described search server, obtain described first Query Result;
Accordingly, described generation module, specifically for generating form according to described first Query Result.
In a kind of possible design, described first start time point is early than Preset Time point, described first end time
Point is later than described Preset Time point;
Described enquiry module, specifically for:
According to described first start time point, described first the end time point and described Preset Time point, determine needs from
Described search server obtains the first Query Result mated with described Query Information and it needs to obtain from described data base
The second Query Result mated with described Query Information;
According to described Query Information, from described search server, obtain described first Query Result, and from described data
Storehouse obtains described second Query Result;
Accordingly, described generation module, specifically for raw according to described first Query Result and described second Query Result
Become form.
In a kind of possible design, described enquiry module, specifically for:
Generate the first sub-information of inquiry and second according to described Query Information and inquire about sub-information;Wherein, second is included described in
Start time point and the second end time point, described second start time point be equal to described first start time point, described second
End time, point was equal to described Preset Time point;At the end of the described second sub-information of inquiry includes the 3rd start time point and the 3rd
Between point, described 3rd start time point be equal to described Preset Time point, described 3rd the end time point equal to described first terminate
Time point;
Described first Query Result mated with described first Query Information is obtained from described search server;
Described second Query Result mated with described second Query Information is obtained from described data base.
In a kind of possible design, described system also includes: the first synchronization module;
Described first synchronization module, for when arriving described Preset Time point, by when presetting described in described data base
Between the data syn-chronization that generates before point to described search server, and will generate before Preset Time point described in described data base
Data deletion.
In a kind of possible design, described system also includes: the second synchronization module;
Described second synchronization module, for when arriving described Preset Time point, being synchronized to described search server
Data back up in distributed file system.
In a kind of possible design, described system also includes: removing module, for presetting in described search server
The data generated before time period are deleted.
The report processing method of present invention offer and reporting system, by the Query Information inputted according to user, from search
Server obtains the Query Result mated with this Query Information, and generates form according to this Query Result, it is achieved that from search clothes
Business device obtains the Query Result mated with Query Information, the Query Result phase mated with Query Information with acquisition from data base
Ratio, obtains the in hgher efficiency of Query Result from search server, therefore improves the efficiency obtaining Query Result, thus improve
The speed of report generation.
Accompanying drawing explanation
In order to be illustrated more clearly that the embodiment of the present invention or technical scheme of the prior art, below will be to embodiment or existing
In having technology to describe, the required accompanying drawing used is briefly described, it should be apparent that, the accompanying drawing in describing below is this
Some bright embodiments, for those of ordinary skill in the art, on the premise of not paying creative work, it is also possible to
Other accompanying drawing is obtained according to these accompanying drawings.
Fig. 1 is the application scenarios schematic diagram of report processing method of the present invention;
Fig. 2 is the flow chart of report processing method embodiment one of the present invention;
Fig. 3 is the flow chart of report processing method embodiment two of the present invention;
Fig. 4 is the flow chart of report processing method embodiment three of the present invention;
Fig. 5 is the mutual schematic diagram of the present invention;
Fig. 6 is the structural representation of reporting system embodiment of the present invention.
Detailed description of the invention
For making the purpose of the embodiment of the present invention, technical scheme and advantage clearer, below in conjunction with the embodiment of the present invention
In accompanying drawing, the technical scheme in the embodiment of the present invention is clearly and completely described, it is clear that described embodiment is
The a part of embodiment of the present invention rather than whole embodiments.Based on the embodiment in the present invention, those of ordinary skill in the art
The every other embodiment obtained under not making creative work premise, broadly falls into the scope of protection of the invention.
Fig. 1 is the application scenarios schematic diagram of report processing method of the present invention, as it is shown in figure 1, the application scenarios of the present invention can
To include: reporting system 11, search server 12.Wherein, reporting system 11, for obtaining the Query Information of user's input, is searched for
Server 12 is for obtaining the Query Result corresponding with Query Information, and reporting system 11 is additionally operable to generate report according to Query Result
Table.Optionally, search server 12 can only store the number generated before the data of a part, such as storage Preset Time point
According to;Accordingly, the application scenarios of the present invention can also include data base 13, stores the data of other parts, example in data base 13
As stored the data generated after Preset Time point.It should be noted that the data generated for Preset Time point, can store
Can also be stored in data base in search server, the present invention is not restricted.It is whole when search server stores
During data, reporting system can directly obtain Query Result from search server, when the data storing part in search server
Time, reporting system needs to obtain Query Result from search server and data base respectively.Further alternative, the application of the present invention
Scene can also include: distributed file system 14, for backing up the data in search server, reliable to improve
Property.Optionally, the application scenarios of the present invention can also include: data generating apparatus 15, for the generation of enterprise real-time data, and
Produced data are stored to data base 13.
Fig. 2 is the flow chart of report processing method embodiment one of the present invention, and the method for the present embodiment can apply to any
The Query Information according to user's input is needed to generate in the reporting system of corresponding form.As in figure 2 it is shown, the method for the present embodiment can
To include:
Step 201, the Query Information of acquisition user's input.
In this step, the inputting interface of Query Information can be provided a user with, from inputting interface, obtain the inquiry of user
Information;Or, this Query Information can be obtained from the report generation request message that the subscriber equipment that user uses sends.Its
In, for subscriber equipment, it is also possible to provide the user the inputting interface of Query Information, and obtain user from inputting interface
Query Information.Above-mentioned Query Information can include report generation rule, key word of the inquiry and/or time period information etc..Its
In, report generation rule be primarily referred to as generate report the information such as tableau format, type, such as report form type can be conventional statement,
Detailed form, packet form, nested report, Cross Report, icon form, consolidated statement etc..Time period information is primarily referred to as using
Family needs the date of formation of the data extracted.Key word of the inquiry is primarily referred to as user needs the content etc. of the data extracted.Such as,
User needs to generate about in May, 2016 duration of call about the form of data, then time period information is specifically as follows 2016
In on May 31, on May 1, to 2016, key word of the inquiry is specifically as follows the duration of call.
Step 202, according to described Query Information, obtain the inquiry mated with described Query Information from search server and tie
Really.
In this step, concrete, this Query Information can be sent to search server, search server look into according to this
Ask the Query Result that information inquiry is mated with this Query Information, and receive this Query Result that search server returns.This search
Server can be such as elastic search (ES, ElasticSearch), wherein, ES be one based on full-text search engine
The search server of Lucene.It should be noted that the management for data realizes based on index in search server,
And management for data realizes with form in data base.Search server obtains inquiry by the inquiry of index
As a result, and being to obtain Query Result by enquiry form in data base, the search efficiency of search server relatively data base exceed
A lot.Therefore, in the embodiment of the present invention, determined the Query Result mated with Query Information by search server, with existing
Technology obtains from data base compared with the Query Result of Query Information coupling, improve the efficiency obtaining Query Result.
Wherein, the Query Result that above-mentioned and described Query Information mates is construed as meeting described Query Information indication
The data of the condition shown.
For example, it is assumed that save 10 data in search server, numbering is respectively record 1-record 10 (specifically can be as
Shown in table 1 below), the time period information that the Query Information of user's input includes is on May 31,1 day to 2016 May in 2016, looks into
Inquiry keyword is the duration of call, then the Query Result mated with this Query Information be 2 points 20 seconds, 3 points 30 seconds, 4 points 40 seconds, 5 points
50 seconds, 6 points 00 second, 7 points 10 seconds, 8 points 20 seconds and 9 points 30 seconds.
Table 1
Numbering | Date of formation | Call sponsor | Receiving talking people | The duration of call |
Record 1 | On December 2nd, 2015 | Little a | Little c | 0 point 00 second |
Record 2 | On March 10th, 2016 | Little b | Little c | 1 point 10 seconds |
Record 3 | On May 14th, 2016 | Little a | Little c | 2 points 20 seconds |
Record 4 | On May 15th, 2016 | Little a | Little d | 3 points 30 seconds |
Record 5 | On May 16th, 2016 | Little a | Little d | 4 points 40 seconds |
Record 6 | On May 17th, 2016 | Little b | Little e | 5 points 50 seconds |
Record 7 | On May 18th, 2016 | Little b | Little f | 6 points 00 second |
Record 8 | On May 19th, 2016 | Little b | Little c | 7 points 10 seconds |
Record 9 | On May 30th, 2016 | Little a | Little c | 8 points 20 seconds |
Record 10 | On May 31st, 2016 | Little b | Little e | 9 points 30 seconds |
Step 203, according to described Query Result generate form.
In this step, when including report generation rule in Query Information, it is right to generate according to report generation rule
The form answered.When Query Information does not includes report generation rule, correspondence can be generated according to the report generation rule of acquiescence
Form.It should be noted that the concrete mode for generation form does not limit in the present embodiment.
In the present embodiment, by the Query Information inputted according to user, obtain and this Query Information from search server
The Query Result joined, and generate form according to this Query Result, it is achieved that mate with Query Information from search server acquisition
Query Result, with obtain from data base with Query Information coupling Query Result compared with, from search server obtain inquiry knot
Really in hgher efficiency, therefore improves the efficiency obtaining Query Result, thus improves the speed of report generation.
Fig. 3 is the flow chart of report processing method embodiment two of the present invention, and the present embodiment is on the basis of embodiment illustrated in fig. 2
On, essentially describe the specific implementation obtaining Query Result according to Query Information.As it is shown on figure 3, the method for the present embodiment
May include that
Step 301, reporting system obtain the Query Information of user's input, and described Query Information includes the first start time point
With the first end time point.
In this step, such as, above-mentioned time period information be in December, 2015 so far, the most described first start time point is permissible
Being December in 2015 0: 0: 0 on the 1st, described first end time point can be current time.The most such as, time period information is
In on January 30,1 day to 2016 January in 2016, the most described first start time point can be 0: 0: 0 on the 1st January in 2016,
Described first end time point when can be 30 days 23 January in 2016 59 minutes and 59 seconds.
Step 302, described reporting system judge whether described first start time point is later than or equal to Preset Time point.
In this step, when described first start time point is later than or is equal to Preset Time point, perform step 303.Work as institute
When stating the first start time point early than described Preset Time, perform step 304.Optionally, described Preset Time point can be exhausted
To a fixing time point, such as 2016 on May 1,0 point;Or described Preset Time point can also be for when relative in the day before yesterday
A fixing time point, such as, when the day before yesterday zero point, when the morning day before yesterday a little etc..Preset Time point typically can select insulting
In morning, now the load of search server is relatively low.In this step, when described reporting system determines that described first start time point is later than
Or during equal to Preset Time point, i.e. may determine that and need to obtain the second inquiry knot mated with described Query Information from data base
Really.
Step 303, described reporting system, according to described Query Information, mate with described Query Information from data base's acquisition
Second Query Result.
In this step, concrete, the query statement corresponding with described data base can be generated according to described Query Information, and
Described query statement is used to obtain the second Query Result mated with described Query Information from described data base.Described data base
Can be such as my SQL (MYSQL, My Structured Query Language) data base, it be corresponding
Query statement can be such as MYSQL statement.
It should be noted that after performing step 303, perform step 307.
Step 304, described reporting system judge that whether described first end time puts early than described Preset Time point.
In this step, when described first end time point is early than described Preset Time point, step 305 is performed.Work as institute
State first the end time point be later than or equal to described Preset Time point time, perform step 306.In this step, when described form system
System determine described first the end time point early than described Preset Time point time, i.e. may determine that needs from search server obtain with
First Query Result of described Query Information coupling.When described reporting system determines that described first end time point is later than or is equal to
During described Preset Time point, i.e. may determine that and need from search server, obtain the first inquiry mated with described Query Information
Result and it needs to obtain the second Query Result mated with described Query Information from data base.
Step 305, described reporting system, according to described Query Information, obtain and described Query Information from search server
The first Query Result joined.
In this step, concrete, described Query Information can be sent to search server, so that described search server
Carry out inquiring about and determining the first Query Result according to described Query Information, and receive this first inquiry knot that search server returns
Really.
It should be noted that after performing step 305, perform step 307.
Step 306, described reporting system, according to described Query Information, obtains and described Query Information from search server
First Query Result of coupling, and from data base, obtain the second Query Result mated with described Query Information.
In this step, permissible for the first Query Result before described first start time point to described Preset Time point
Obtaining from described search server, the second Query Result for described Preset Time point to described first end time point can
To obtain from described data base.Specifically may include that generating the first inquiry sub-information and second according to described Query Information looks into
Ask sub-information;Wherein, generate the first sub-information of inquiry and second according to described Query Information and inquire about sub-information;Wherein, described bag
Including the second start time point and the second end time point, described second start time point is equal to described first start time point, institute
State the second end time point equal to described Preset Time point;Described second inquires about sub-information includes the 3rd start time point and the 3rd
End time point, described 3rd start time point is equal to described Preset Time point, and described 3rd end time point is equal to described the
End time point;Described first Query Result mated with described first Query Information is obtained from described search server;
Described second Query Result mated with described second Query Information is obtained from described data base.For example, it is assumed that user's input
Query Information include in December, 2015 so far and the duration of call, Preset Time point for when the some day before yesterday 0, then first inquires about sub-information
Can include that in December, 2015 worked as the previous day of the day before yesterday, the duration of call to 2016;Second inquires about sub-information may include that currently
It 0 is to when the current time of the day before yesterday, the duration of call.
Step 307, described reporting system generate form according to the Query Result obtained.
It should be noted that for step 303, this Query Result is specially second to be looked into from what described data base obtained
Ask result;For step 305, this Query Result is specially the first Query Result obtained from described search server;Right
For step 306, this Query Result is specially the first Query Result obtained from described search server and from described data
The second Query Result that storehouse obtains.
It should be noted that the present embodiment is be stored in data base with the data of described Preset Time point generation to be
Example.
Optionally, the present embodiment can also comprise the steps 308-step 309, come generation real-time to enterprise for
The data generating form store.
The data produced in real time are stored to described data base by step 308, data generating apparatus.
Step 309, arrive described Preset Time point time, described reporting system is by Preset Time described in described data base
The data syn-chronization generated before Dian extremely described search server, and by generation before Preset Time point described in described data base
Data deletion.
Optionally, when arriving described Preset Time point, it is also possible to the data being synchronized to described search server are being divided
Cloth file system backs up.This distributed file system can be such as Hadoop distributed file system (HDFS,
Hadoop Distributed File System), wherein Hadoop is distributed by the exploitation of Apache fund club
System infrastructure.In the present embodiment, by when arriving described Preset Time point, the number of described search server will be synchronized to
Back up according in distributed file system, it is possible to achieve distributed file system is to data stored in search server
Backup, thus improve the safety of data.
Optionally, 310 can also be comprised the steps after step 309.
The data generated before preset time period in described search server are deleted by step 310, described reporting system
Remove.
In this step, owing to usual user is the data of nearest a period of time for the data generating form, such as,
Nearly 1 year, nearest 3 months etc.;Therefore, by the data generated before preset time period in search server in the present embodiment
Delete, it is possible to reduce the data volume in search server, save the memory space of search server.
It should be noted that do not have the restriction of sequencing between step 308-step 310.
The present embodiment, by when determining that the first start time point is later than or is equal to Preset Time point, obtaining from data base
Take the first Query Result that Query Information is corresponding;Determining that the first start time point is early than Preset Time point and the first end time
When point is later than or is equal to described Preset Time point, from data base, obtain first Query Result corresponding with Query Information and from searching
Rope server obtains the second Query Result that Query Information is corresponding;Determining that the first end time point is later than Preset Time point
Time, obtain first Query Result corresponding with Query Information from search server;Achieve obtain from search server early than
The Query Result of Preset Time point, and from data base, obtain the issuer of the Query Result being later than or equal to Preset Time point
Formula, obtains from data base with all needs and improves the effect obtaining Query Result compared with the Query Result of Query Information coupling
Rate, avoiding search server compared with the Query Result that all needs obtain from search server with Query Information mates needs
The problem wanting frequent updating data and affect search efficiency.
Fig. 4 is the flow chart of report processing method embodiment three of the present invention, and Fig. 5 is the mutual schematic diagram of the present invention;This reality
Execute example on the basis of embodiment illustrated in fig. 3, be when the zero point of the day before yesterday, the data traffic number as call center with Preset Time point
It is specifically described as a example by according to.As shown in Figure 4 and Figure 5, the method for the present embodiment may include that
The traffic data that call center is produced by step 401, the message-oriented middleware of call center is written to MYSQL in real time.
It should be noted that the call center in this step is above-mentioned data generating apparatus.
The data of the previous day in MYSQL, at 0 point of every day, are updated in HDFS by step 402, reporting system.
In this step, concrete, the data of the previous day in MYSQL can be updated to by reporting system by HADOOP task
In HDFS.Wherein, store in HDFS is the data (being properly termed as historical data) in non-present sky.Optionally, the number in HDFS
According to carrying out subregion by the date of formation of data, to facilitate management.
Step 403, described reporting system will be deleted except the data before the same day in MYSQL.
In this step, MYSQL only preserves the data (being properly termed as real time data) when the day before yesterday.
The data being updated to described HDFS are write to ES by step 404, described reporting system.
In this step, concrete, described reporting system can pass through HADOOP task, will be updated to the number in described HDFS
According in (that is, the data of the previous day described in step 402) write to ES.Wherein, this ES is specifically as follows ES cluster, and ES is permissible
To index for data creation according to the querying condition that can be used by a user.
It should be noted that do not have the restriction of sequencing between step 401-step 404.
Step 405, described reporting system receive the Query Information of user's input, and obtain inquiry knot according to Query Information
Really.
In this step, concrete, may include steps of 4051,4052,4053.
Step 4051, when described Query Information instruction inquiry when the data of the day before yesterday time, directly according to described Query Information from
MYSQL obtains real time data.
Step 4052, when described Query Information instruction inquiry do not comprise when the data of the day before yesterday time, directly according to search inquiry
Information obtains historical data from ES.
Step 4053, when the instruction inquiry of described Query Information is when the data of the day before yesterday to history some day, look into according to described
Inquiry information obtains from MYSQL real time data, and from ES, obtains historical data according to search inquiry information.
Can also include after step 405: the Query Result according to getting (that is, obtains real time data from MYSQL
And/or from ES, obtain historical data) generate form.
The present embodiment, is stored to MYSQL by the data when the day before yesterday, and other data store to ES;When looking into of user's input
The instruction inquiry of inquiry information, when the data of the day before yesterday, directly obtains real time data according to described Query Information from MYSQL;When described
Query Information instruction inquiry does not comprise when the data of the day before yesterday, directly obtains historical data from ES according to search inquiry information;
When the instruction inquiry of described Query Information is when the data of the day before yesterday to history some day, according in described Query Information from MYSQL
Obtain real time data, and from ES, obtain historical data according to search inquiry information;Thus improve the effect obtaining Query Result
Rate.
Fig. 6 is the structural representation of reporting system embodiment of the present invention, and the reporting system that the present embodiment provides can be applied
In the method for Fig. 2-Fig. 4 embodiment, it is achieved the function of its reporting system.As shown in Figure 6, the reporting system of the present embodiment is permissible
Including: acquisition module 601, enquiry module 602 and generation module 603.Wherein, acquisition module 601, for obtaining user's input
Query Information;Enquiry module 602, for according to acquisition module 601 obtain described Query Information, from search server obtain with
The Query Result of described Query Information coupling;Generation module 603, for the described Query Result obtained according to enquiry module 602
Generate form.
Optionally, described Query Information includes the first start time point and the first end time point.
Optionally, described first start time point and described first end time put all early than Preset Time point;
Enquiry module 602, specifically for: put and described according to described first start time point, described first end time
Preset Time point, determines and needs to obtain the first Query Result mated with described Query Information from described search server;Root
According to described Query Information, from described search server, obtain described first Query Result;
Accordingly, generation module 603, specifically for generating form according to described first Query Result.
Optionally, described first start time point is early than Preset Time point, and described first end time point is later than described pre-
If time point;
Enquiry module 602, specifically for: put and described according to described first start time point, described first end time
Preset Time point, determines and needs to obtain the first Query Result mated with described Query Information from described search server, and
Need from described data base, obtain the second Query Result mated with described Query Information;According to described Query Information, from institute
State and search server obtains described first Query Result, and from described data base, obtain described second Query Result;
Accordingly, generation module 603, specifically for generating according to described first Query Result and described second Query Result
Form.
Optionally, enquiry module 602, specifically for:
Generate the first sub-information of inquiry and second according to described Query Information and inquire about sub-information;Wherein, second is included described in
Start time point and the second end time point, described second start time point be equal to described first start time point, described second
End time, point was equal to described Preset Time point;At the end of the described second sub-information of inquiry includes the 3rd start time point and the 3rd
Between point, described 3rd start time point be equal to described Preset Time point, described 3rd the end time point equal to described first terminate
Time point;
Described first Query Result mated with described first Query Information is obtained from described search server;
Described second Query Result mated with described second Query Information is obtained from described data base.
Optionally, the reporting system of the present embodiment also includes: the first synchronization module;
Described first synchronization module, for when arriving described Preset Time point, by when presetting described in described data base
Between the data syn-chronization that generates before point to described search server, and will generate before Preset Time point described in described data base
Data deletion.
Optionally, the reporting system of the present embodiment also includes: the second synchronization module;
Described second synchronization module, for when arriving described Preset Time point, being synchronized to described search server
Data back up in distributed file system.
Optionally, the reporting system of the present embodiment also includes: removing module;
Described removing module, for deleting the data generated before preset time period in described search server.
The reporting system of the present embodiment, may be used for performing the technical scheme of embodiment of the method shown in Fig. 2-Fig. 4, and it realizes
Principle is similar with technique effect, and here is omitted.
One of ordinary skill in the art will appreciate that: all or part of step realizing above-mentioned each method embodiment can be led to
The hardware crossing programmed instruction relevant completes.Aforesaid program can be stored in a computer read/write memory medium.This journey
Sequence upon execution, performs to include the step of above-mentioned each method embodiment;And aforesaid storage medium includes: ROM, RAM, magnetic disc or
The various media that can store program code such as person's CD.
Last it is noted that various embodiments above is only in order to illustrate technical scheme, it is not intended to limit;To the greatest extent
The present invention has been described in detail by pipe with reference to foregoing embodiments, it will be understood by those within the art that: it depends on
So the technical scheme described in foregoing embodiments can be modified, or the most some or all of technical characteristic is entered
Row equivalent;And these amendments or replacement, do not make the essence of appropriate technical solution depart from various embodiments of the present invention technology
The scope of scheme.
Claims (16)
1. a report processing method, it is characterised in that including:
Obtain the Query Information of user's input;
According to described Query Information, obtain the Query Result mated with described Query Information from search server;
Form is generated according to described Query Result.
Method the most according to claim 1, it is characterised in that described Query Information includes the first start time point and first
End time point.
Method the most according to claim 2, it is characterised in that described first start time point and described first end time
Point is all early than Preset Time point;
Described according to described Query Information, the Query Result mated with described Query Information is obtained from search server, including:
According to described first start time point, described first end time point and described Preset Time point, determine that needs are from described
Search server obtains the first Query Result mated with described Query Information;
According to described Query Information, from described search server, obtain described first Query Result;
Accordingly, described according to described Query Result generate form, including:
Form is generated according to described first Query Result.
Method the most according to claim 2, it is characterised in that described first start time point is early than Preset Time point, institute
State the first end time point and be later than described Preset Time point;
Described according to described Query Information, the Query Result mated with described Query Information is obtained from search server, including:
According to described first start time point, described first end time point and described Preset Time point, determine that needs are from described
Search server obtains the first Query Result mated with described Query Information and it needs to obtain and institute from described data base
State the second Query Result of Query Information coupling;
According to described Query Information, from described search server, obtain described first Query Result, and from described data base
Obtain described second Query Result;
Accordingly, described according to described Query Result generate form, including:
Form is generated according to described first Query Result and described second Query Result.
Method the most according to claim 4, it is characterised in that described according to described Query Information, from described search service
Device obtains described first Query Result, and from described data base, obtains described second Query Result, including:
Generate the first sub-information of inquiry and second according to described Query Information and inquire about sub-information;Wherein, include described in that second initiates
Time point and the second end time point, described second start time point is equal to described first start time point, and described second terminates
Time point is equal to described Preset Time point;Described second inquires about sub-information includes the 3rd start time point and the 3rd end time
Point, described 3rd start time point is equal to described Preset Time point, at the end of described 3rd end time point is equal to described first
Between point;
Described first Query Result mated with described first Query Information is obtained from described search server;
Described second Query Result mated with described second Query Information is obtained from described data base.
6. according to the method described in claim 4 or 5, it is characterised in that described method also includes:
When arriving described Preset Time point, by the data syn-chronization of generation before Preset Time point described in described data base to institute
State search server, and the data deletion that will generate before Preset Time point described in described data base.
Method the most according to claim 6, it is characterised in that described method also includes: arrive described Preset Time point
Time, the data being synchronized to described search server are backed up in distributed file system.
Method the most according to claim 6, it is characterised in that described method also includes: to pre-in described search server
If the data generated before the time period are deleted.
9. a reporting system, it is characterised in that including:
Acquisition module, for obtaining the Query Information of user's input;
Enquiry module, for according to described Query Information, obtaining the inquiry knot mated with described Query Information from search server
Really;
Generation module, for generating form according to described Query Result.
Reporting system the most according to claim 9, it is characterised in that described Query Information includes the first start time point
With the first end time point.
11. reporting systems according to claim 10, it is characterised in that described first start time point and described first knot
Bundle time point is all early than Preset Time point;
Described enquiry module, specifically for:
According to described first start time point, described first end time point and described Preset Time point, determine that needs are from described
Search server obtains the first Query Result mated with described Query Information;
According to described Query Information, from described search server, obtain described first Query Result;
Accordingly, described generation module, specifically for generating form according to described first Query Result.
12. reporting systems according to claim 10, it is characterised in that described first start time point is early than Preset Time
Point, described first end time point is later than described Preset Time point;
Described enquiry module, specifically for:
According to described first start time point, described first end time point and described Preset Time point, determine that needs are from described
Search server obtains the first Query Result mated with described Query Information and it needs to obtain and institute from described data base
State the second Query Result of Query Information coupling;
According to described Query Information, from described search server, obtain described first Query Result, and from described data base
Obtain described second Query Result;
Accordingly, described generation module, specifically for generating report according to described first Query Result and described second Query Result
Table.
13. reporting systems according to claim 12, it is characterised in that described enquiry module, specifically for:
Generate the first sub-information of inquiry and second according to described Query Information and inquire about sub-information;Wherein, include described in that second initiates
Time point and the second end time point, described second start time point is equal to described first start time point, and described second terminates
Time point is equal to described Preset Time point;Described second inquires about sub-information includes the 3rd start time point and the 3rd end time
Point, described 3rd start time point is equal to described Preset Time point, at the end of described 3rd end time point is equal to described first
Between point;
Described first Query Result mated with described first Query Information is obtained from described search server;
Described second Query Result mated with described second Query Information is obtained from described data base.
14. according to the reporting system described in claim 12 or 13, it is characterised in that described system also includes: first synchronizes mould
Block;
Described first synchronization module, for when arriving described Preset Time point, by Preset Time point described in described data base
The data syn-chronization before generated is to described search server, and the number that will generate before Preset Time point described in described data base
According to deletion.
15. reporting systems according to claim 14, it is characterised in that described reporting system also includes: second synchronizes mould
Block;
Described second synchronization module, for when arriving described Preset Time point, being synchronized to the data of described search server
Distributed file system backs up.
16. reporting systems according to claim 14, it is characterised in that described system also includes: removing module, for right
The data generated before preset time period in described search server are deleted.
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201610625033.4A CN106250501B (en) | 2016-07-28 | 2016-07-28 | Report processing method and reporting system |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201610625033.4A CN106250501B (en) | 2016-07-28 | 2016-07-28 | Report processing method and reporting system |
Publications (2)
Publication Number | Publication Date |
---|---|
CN106250501A true CN106250501A (en) | 2016-12-21 |
CN106250501B CN106250501B (en) | 2019-11-01 |
Family
ID=57606330
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN201610625033.4A Active CN106250501B (en) | 2016-07-28 | 2016-07-28 | Report processing method and reporting system |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN106250501B (en) |
Cited By (4)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN108536761A (en) * | 2018-03-21 | 2018-09-14 | 平安科技(深圳)有限公司 | Report data querying method and server |
CN108572945A (en) * | 2018-03-09 | 2018-09-25 | 吉贝克信息技术(北京)有限公司 | Create method, system, storage medium and the electronic equipment of report |
CN109063077A (en) * | 2018-07-24 | 2018-12-21 | 新华三大数据技术有限公司 | A kind of data access method and device based on elasticity search |
CN109241094A (en) * | 2017-07-10 | 2019-01-18 | 大唐移动通信设备有限公司 | A kind of data query method and device |
Citations (6)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN1874254A (en) * | 2005-06-02 | 2006-12-06 | 华为技术有限公司 | Method for browsing data based on structure of client end / server end |
CN1897629A (en) * | 2006-06-30 | 2007-01-17 | 南京联创科技股份有限公司 | Mass toll-ticket fast cross rearrangement based on memory |
CN101815261A (en) * | 2010-02-23 | 2010-08-25 | 深圳市五巨科技有限公司 | Method and device for generating mobile terminal report forms |
WO2010133052A1 (en) * | 2009-05-20 | 2010-11-25 | 中兴通讯股份有限公司 | Method and system for processing telephone bill |
CN102081625A (en) * | 2009-11-30 | 2011-06-01 | 中国移动通信集团北京有限公司 | Data query method and query server |
CN105279143A (en) * | 2015-10-17 | 2016-01-27 | 浙江宇视科技有限公司 | Periodic report system |
-
2016
- 2016-07-28 CN CN201610625033.4A patent/CN106250501B/en active Active
Patent Citations (6)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN1874254A (en) * | 2005-06-02 | 2006-12-06 | 华为技术有限公司 | Method for browsing data based on structure of client end / server end |
CN1897629A (en) * | 2006-06-30 | 2007-01-17 | 南京联创科技股份有限公司 | Mass toll-ticket fast cross rearrangement based on memory |
WO2010133052A1 (en) * | 2009-05-20 | 2010-11-25 | 中兴通讯股份有限公司 | Method and system for processing telephone bill |
CN102081625A (en) * | 2009-11-30 | 2011-06-01 | 中国移动通信集团北京有限公司 | Data query method and query server |
CN101815261A (en) * | 2010-02-23 | 2010-08-25 | 深圳市五巨科技有限公司 | Method and device for generating mobile terminal report forms |
CN105279143A (en) * | 2015-10-17 | 2016-01-27 | 浙江宇视科技有限公司 | Periodic report system |
Cited By (6)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN109241094A (en) * | 2017-07-10 | 2019-01-18 | 大唐移动通信设备有限公司 | A kind of data query method and device |
CN108572945A (en) * | 2018-03-09 | 2018-09-25 | 吉贝克信息技术(北京)有限公司 | Create method, system, storage medium and the electronic equipment of report |
CN108536761A (en) * | 2018-03-21 | 2018-09-14 | 平安科技(深圳)有限公司 | Report data querying method and server |
WO2019178979A1 (en) * | 2018-03-21 | 2019-09-26 | 平安科技(深圳)有限公司 | Method for querying report data, apparatus, storage medium and server |
CN109063077A (en) * | 2018-07-24 | 2018-12-21 | 新华三大数据技术有限公司 | A kind of data access method and device based on elasticity search |
CN109063077B (en) * | 2018-07-24 | 2020-12-08 | 新华三大数据技术有限公司 | Data access method and device based on elastic search |
Also Published As
Publication number | Publication date |
---|---|
CN106250501B (en) | 2019-11-01 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
CN108536761B (en) | Report data query method and server | |
CN105373448B (en) | The restoration methods and system of fault data in database | |
KR102072726B1 (en) | Systems and methods for supporting inline delegation of middle-tier transaction logs to database | |
CN102521712B (en) | A kind of process instance data processing method and device | |
CN110674154B (en) | Spark-based method for inserting, updating and deleting data in Hive | |
CN103631924B (en) | A kind of application process and system of distributive database platform | |
CN105930387A (en) | Data operation system and method based on data routing and sharding | |
CN106250501A (en) | Report processing method and reporting system | |
CN104239443B (en) | A kind of storage method of serialized data operation log | |
CN109144785A (en) | Method and apparatus for Backup Data | |
US20140156603A1 (en) | Method and an apparatus for splitting and recovering data in a power system | |
CN110019469B (en) | Distributed database data processing method and device, storage medium and electronic device | |
CN105530272A (en) | Method and device for application data synchronization | |
CN110597835B (en) | Transaction data deleting method and device based on blockchain | |
CN102685018A (en) | Method and system for processing network instant messaging message and instant massaging equipment | |
CN103235811A (en) | Data storage method and device | |
CN109241067A (en) | transaction data management method and device | |
JP2013530449A (en) | How to improve queries for searching databases | |
CN104423982A (en) | Request processing method and device | |
CN107273449B (en) | Breakpoint processing method and system based on memory database | |
CN106874343B (en) | Data deletion method and system for time sequence database | |
CN101833585A (en) | Database server operation control system, method and device | |
CN107122362A (en) | Cloud database resource extends the method and system with service extension | |
CN110032664A (en) | A method of quickly establishing the full node address index of bit coin block chain | |
US10360234B2 (en) | Recursive extractor framework for forensics and electronic discovery |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
C06 | Publication | ||
PB01 | Publication | ||
C10 | Entry into substantive examination | ||
SE01 | Entry into force of request for substantive examination | ||
GR01 | Patent grant | ||
GR01 | Patent grant |