CN106250501B - Report processing method and reporting system - Google Patents
Report processing method and reporting system Download PDFInfo
- Publication number
- CN106250501B CN106250501B CN201610625033.4A CN201610625033A CN106250501B CN 106250501 B CN106250501 B CN 106250501B CN 201610625033 A CN201610625033 A CN 201610625033A CN 106250501 B CN106250501 B CN 106250501B
- Authority
- CN
- China
- Prior art keywords
- time point
- query
- information
- query result
- search server
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Active
Links
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: the query information of acquisition user's input；According to the query information, obtained and the matched query result of the query information from search server；Report is generated according to the query result.The present invention improves the speed of report generation.
Description
Technical field
The present invention relates to data processing field more particularly to a kind of report processing methods and reporting system.
Background technique
Report is the basic measures and approach of business administration, is the basic service requirement of enterprise.Report can by data with
Reliable and safety mode is presented to user.For example, manager can pass through report firm sale personnel for sale enterprise
The call itemization conversed by the telephone traffic center of the enterprise.
In the prior art, it is all saved in the database for generating the data of report.When needing to generate report, basis is needed
The querying condition of user's input inquires data corresponding with the querying condition in the database, the data found further according to inquiry
Generate report.General large enterprise has a large amount of data to need to be updated to database, the data volume stored in database daily
It is larger.And database supports big data quantity poor, after data volume is more than ten million rank, search efficiency is decreased obviously.
Therefore, in the prior art, there are the slow problems of report generation.
Summary of the invention
The present invention provides a kind of report processing method and reporting system, to solve in the prior art report generation speed compared with
Slow problem.
In a first aspect, the present invention provides a kind of report processing method, comprising:
Obtain the query information of user's input；
According to the query information, obtained and the matched query result of the query information from search server；
Report is generated according to the query result.
In a kind of possible design, the query information includes the first start time point and the first end time point.
In a kind of possible design, first start time point and the first end time point all earlier than it is default when
Between point；
It is described to be wrapped according to the query information from search server acquisition and the matched query result of the query information
It includes:
According to first start time point, the first end time point and preset time point, determine need from
It is obtained and matched first query result of the query information in described search server；
According to the query information, first query result is obtained from described search server；
Correspondingly, described generate report according to the query result, comprising:
Report is generated according to first query result.
In a kind of possible design, first start time point is earlier than preset time point, first end time
Point is later than the preset time point；
It is described to be wrapped according to the query information from search server acquisition and the matched query result of the query information
It includes:
According to first start time point, the first end time point and preset time point, determine need from
Acquisition and matched first query result of the query information in described search server, and need to obtain from the database
With matched second query result of the query information；
According to the query information, first query result is obtained from described search server, and from the data
Second query result is obtained in library；
Correspondingly, described generate report according to the query result, comprising:
Report is generated according to first query result and second query result.
It is described according to the query information in a kind of possible design, described is obtained from described search server
One query result, and second query result is obtained from the database, comprising:
The first inquiry sub-information and the second inquiry sub-information are generated according to the query information；Wherein, described includes second
Start time point and the second end time point, second start time point be equal to first start time point, described second
End time point is equal to the preset time point；At the end of the second inquiry sub-information includes third start time point and third
Between point, the third start time point be equal to the preset time point, the third end time point be equal to it is described first terminate
Time point；
It is obtained and matched first query result of first query information from described search server；
It obtains and matched second query result of second query information from the database.
In a kind of possible design, the method also includes:
It is when reaching the preset time point, the data generated before the point of preset time described in the database are synchronous
It is deleted to described search server, and by the data generated before the point of preset time described in the database.
In a kind of possible design, the method also includes: when reaching the preset time point, will be synchronized to described
The data of search server are backed up in distributed file system.
In a kind of possible design, the method also includes: to the previous existence of preset time period in described search server
At data deleted.
Second aspect, the present invention provide a kind of reporting system, comprising:
Module is obtained, for obtaining the query information of user's input；
Enquiry module is obtained and the query information is matched looks into from search server for according to the query information
Ask result；
Generation module, for generating report according to the query result.
In a kind of possible design, the query information includes the first start time point and the first end time point.
In a kind of possible design, first start time point and the first end time point all earlier than it is default when
Between point；
The enquiry module, is specifically used for:
According to first start time point, the first end time point and preset time point, determine need from
It is obtained and matched first query result of the query information in described search server；
According to the query information, first query result is obtained from described search server；
Correspondingly, the generation module, is specifically used for generating report according to first query result.
In a kind of possible design, first start time point is earlier than preset time point, first end time
Point is later than the preset time point；
The enquiry module, is specifically used for:
According to first start time point, the first end time point and preset time point, determine need from
Acquisition and matched first query result of the query information in described search server, and need to obtain from the database
With matched second query result of the query information；
According to the query information, first query result is obtained from described search server, and from the data
Second query result is obtained in library；
Correspondingly, the generation module, is specifically used for raw according to first query result and second query result
At report.
In a kind of possible design, the enquiry module is specifically used for:
The first inquiry sub-information and the second inquiry sub-information are generated according to the query information；Wherein, described includes second
Start time point and the second end time point, second start time point be equal to first start time point, described second
End time point is equal to the preset time point；At the end of the second inquiry sub-information includes third start time point and third
Between point, the third start time point be equal to the preset time point, the third end time point be equal to it is described first terminate
Time point；
It is obtained and matched first query result of first query information from described search server；
It obtains and matched second query result of second query information from the database.
In a kind of possible design, the system also includes: the first synchronization module；
First synchronization module is used for when reaching the preset time point, when will preset described in the database
Between the data that generate before point be synchronized to described search server, and will be generated before the point of preset time described in the database
Data delete.
In a kind of possible design, the system also includes: the second synchronization module；
Second synchronization module, for described search server will to be synchronized to when reaching the preset time point
Data are backed up in distributed file system.
In a kind of possible design, the system also includes: removing module, for being preset in described search server
The data generated before period are deleted.
Report processing method and reporting system provided by the invention, by the query information inputted according to user, from search
Server obtains and the matched query result of the query information, and generates report according to the query result, realizes and takes from search
Business device obtains and the matched query result of query information, obtains and the matched query result phase of query information with from database
Than the more efficient of query result being obtained from search server, therefore improve the efficiency for obtaining query result, to improve
The speed of report generation.
Detailed description of the invention
In order to more clearly explain the embodiment of the invention or the technical proposal in the existing technology, to embodiment or will show below
There is attached drawing needed in technical description to be briefly described, it should be apparent that, the accompanying drawings in the following description is this hair
Bright some embodiments for those of ordinary skill in the art without any creative labor, can be with
It obtains other drawings based on these 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 interaction schematic diagram of the invention；
Fig. 6 is the structural schematic diagram of reporting system embodiment of the present invention.
Specific embodiment
In order to make the object, technical scheme and advantages of the embodiment of the invention clearer, below in conjunction with the embodiment of the present invention
In attached drawing, technical scheme in the embodiment of the invention is clearly and completely described, it is clear that described embodiment is
A part of the embodiment of the present invention, instead of all the embodiments.Based on the embodiments of the present invention, those of ordinary skill in the art
Every other embodiment obtained without creative efforts, shall fall within the protection scope of the present invention.
Fig. 1 is the application scenarios schematic diagram of report processing method of the present invention, as shown in Figure 1, application scenarios of the invention can
To include: reporting system 11, search server 12.Wherein, reporting system 11 is used to obtain the query information of user's input, search
Server 12 is also used to be generated according to query result and report for obtaining query result corresponding with query information, reporting system 11
Table.Optionally, the number generated before the data of a part, such as storage preset time point can be only stored in search server 12
According to；Correspondingly, application scenarios of the invention can also include database 13, the data of other parts, example are stored in database 13
Such as store the data generated after preset time point.It should be noted that can store for the data that preset time point generates
It also can store in search server in the database, the present invention and with no restriction.When storage whole in search server
When data, reporting system can directly acquire query result from search server, when the data of storage section in search server
When, reporting system needs obtain query result from search server and database respectively.Further alternative, of the invention application
Scene can also include: distributed file system 14, reliable to improve for backing up to the data in search server
Property.Optionally, application scenarios of the invention can also include: data generating apparatus 15, for the generation of enterprise real-time data, and
Generated data are stored to database 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 be applied to any
In the reporting system for needing to generate corresponding report according to the query information that user inputs.As shown in Fig. 2, the method for the present embodiment can
To include:
Step 201, the query information for obtaining user's input.
In this step, the input interface of query information can be provided a user, the inquiry of user is obtained from input interface
Information；Alternatively, the query information can be obtained from the report generation request message that the user equipment that user uses is sent.Its
In, for user equipment, or user provides the input interface of query information, and obtains user from input interface
Query information.Above-mentioned query information may include report generation rule, key word of the inquiry, and/or time segment information etc..Its
In, report generation rule is primarily referred to as generating report tableau format, the information such as type, such as report form type can for conventional statement,
Detail report, grouping report, nested report, Cross Report, icon report, consolidated statement etc..Time segment information is primarily referred to as using
The date of formation for the data that family needs to extract.Key word of the inquiry is primarily referred to as the content etc. for the data that user needs to extract.For example,
User needs to generate in relation in May, 2016 report of the duration of call in relation to data, then time segment 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 the query information, obtained and the matched inquiry knot of the query information from search server
Fruit.
In this step, specifically, the query information can be sent to search server, looked by search server according to this
Information inquiry and the matched query result of the query information are ask, and receives the query result of search server return.The search
Server can be for example elasticity search (ES, ElasticSearch), wherein ES is one based on full-text search engine
The search server of Lucene.It should be noted that the management in search server for data is realized based on index,
And the database of management in to(for) data is realized with table.It is inquired in search server by the inquiry of index
As a result, and be that query result is obtained by enquiry form in database, the search efficiency of search server is higher by compared with database
Very much.Therefore, in the embodiment of the present invention, determined by search server with the matched query result of query information, and it is existing
It is obtained compared with the matched query result of query information from database in technology, improves the efficiency for obtaining query result.
Wherein, above-mentioned to be construed as meeting the query information meaning with the matched query result of the query information
The data for the condition shown.
For example, it is assumed that save 10 datas in search server, number is respectively that record 1- record 10 (specifically can be as
Shown in the following table 1), the time segment 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 be the duration of call, then with the matched query result of the 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
| Number | Date of formation | Converse promoter | Receiving talking people | The duration of call |
| Record 1 | On December 2nd, 2015 | Small a | Small c | 0 point 00 second |
| Record 2 | On March 10th, 2016 | Small b | Small c | 1 point 10 seconds |
| Record 3 | On May 14th, 2016 | Small a | Small c | 2 points 20 seconds |
| Record 4 | On May 15th, 2016 | Small a | Small d | 3 points 30 seconds |
| Record 5 | On May 16th, 2016 | Small a | Small d | 4 points 40 seconds |
| Record 6 | On May 17th, 2016 | Small b | Small e | 5 points 50 seconds |
| Record 7 | On May 18th, 2016 | Small b | Small f | 6 points 00 second |
| Record 8 | On May 19th, 2016 | Small b | Small c | 7 points 10 seconds |
| Record 9 | On May 30th, 2016 | Small a | Small c | 8 points 20 seconds |
| Record 10 | On May 31st, 2016 | Small b | Small e | 9 points 30 seconds |
Step 203 generates report according to the query result.
It, can be according to the generation pair of report generation rule when in query information including report generation rule in this step
The report answered.When not including report generation rule in query information, it can be generated and be corresponded to according to the report generation rule of default
Report.It should be noted that for generating the concrete mode and with no restrictions of report in the present embodiment.
In the present embodiment, by the query information inputted according to user, obtained and the query information from search server
The query result matched, and report is generated according to the query result, it realizes matched with query information from search server acquisition
Query result obtains inquiry knot from search server with obtaining compared with the matched query result of query information from database
Fruit it is more efficient, therefore improve obtain query result efficiency, to improve the speed of report generation.
Fig. 3 is the flow chart of report processing method embodiment two of the present invention, the basis of the present embodiment embodiment shown in Fig. 2
On, essentially describe the specific implementation that query result is obtained according to query information.As shown in figure 3, the method for the present embodiment
May include:
Step 301, reporting system obtain the query information of user's input, and the query information includes the first start time point
With the first end time point.
In this step, for example, above-mentioned time segment information be in December, 2015 so far, then first start time point can be with
For 0 minute and 0 second 0 point of on December 1st, 2015, the first end time point can be current time.In another example time segment information is
On January 30,1 day to 2016 January in 2016, then first start time point can be 0 minute and 0 second for 0 point of on January 1st, 2016,
59 minutes and 59 seconds when the first end time point can be 30 days 23 January in 2016.
Step 302, the reporting system judge whether first start time point is later than or is equal to preset time point.
In this step, when first start time point is later than or is equal to preset time point, step 303 is executed.Work as institute
When stating the first start time point earlier than the preset time, step 304 is executed.Optionally, the preset time point can be exhausted
To a fixed time point, such as 0 point of May 1 in 2016；Or the preset time point may be when opposite in the day before yesterday
A fixed time point, for example, when day before yesterday zero point, when the morning day before yesterday a little etc..Preset time point, which generally can choose, is insulting
In morning, the load of search server is lower at this time.In this step, when the reporting system determines that first start time point is later than
Or when being equal to preset time point, it can determine to need to obtain from database and be tied with matched second inquiry of the query information
Fruit.
Step 303, the reporting system obtain matched with the query information according to the query information from database
Second query result.
In this step, specifically, query statement corresponding with the database can be generated according to the query information, and
It is obtained from the database using the query statement and matched second query result of the query information.The database
Such as can be my structured query language (MYSQL, My Structured Query Language) database, it corresponds to
Query statement for example can be MYSQL sentence.
It should be noted that executing step 307 after executing step 303.
Whether step 304, the reporting system judge the first end time point earlier than the preset time point.
In this step, when the first end time point is earlier than the preset time point, step 305 is executed.Work as institute
State the first end time point be later than or be equal to the preset time point when, execute step 306.In this step, when the report system
When system determines the first end time point earlier than the preset time point, it can determine need to obtain from search server with
Matched first query result of query information.When the reporting system determines that the first end time point is later than or is equal to
When the preset time point, it can determine and need to obtain from search server and matched first inquiry of the query information
As a result, and needing to obtain and matched second query result of the query information from database.
Step 305, the reporting system obtain and the query information according to the query information from search server
The first query result matched.
In this step, specifically, the query information can be sent to search server, so that described search server
Inquire according to the query information and determine the first query result, and receives the first inquiry knot of search server return
Fruit.
It should be noted that executing step 307 after executing step 305.
Step 306, the reporting system obtains and the query information from search server according to the query information
Matched first query result, and obtained and matched second query result of the query information from database.
It, can be with for the first query result before first start time point to the preset time point in this step
It is obtained from described search server, it can for the second query result of the preset time point to the first end time point
To obtain from the database.It can specifically include: the first inquiry sub-information and second being generated according to the query information and is looked into
Ask sub-information；Wherein, the first inquiry sub-information and the second inquiry sub-information are generated according to the query information；Wherein, the packet
The second start time point and the second end time point are included, second start time point is equal to first start time point, institute
The second end time point is stated equal to the preset time point；The second inquiry sub-information includes third start time point and third
End time point, the third start time point are equal to the preset time point, and the third end time point is equal to described the
End time point；It is obtained and matched first query result of first query information from described search server；
It obtains and matched second query result of second query information from the database.For example, it is assumed that user inputs
Query information include in December, 2015 so far and the duration of call, preset time point is then the first inquiry sub-information when 0 point of the day before yesterday
It may include the previous day, the duration of call for working as the day before yesterday to 2016 in December, 2015；Second inquiry sub-information may include: current
It 0 point is extremely when the current time of the day before yesterday, the duration of call.
Step 307, the reporting system generate report according to the query result of acquisition.
It should be noted that the query result is specially that second obtained from the database is looked into for step 303
Ask result；For step 305, which is specially the first query result obtained from described search server；It is right
For step 306, which is specially the first query result for obtaining from described search server and from the data
The second query result that library obtains.
It should be noted that being that the data storage generated with the preset time point is in the database in the present embodiment
Example.
Optionally, 308- step 309 can also be included the following steps in the present embodiment, is used for come what is generated in real time to enterprise
The data for generating report are stored.
Step 308, data generating apparatus store the data generated in real time into the database.
Step 309, when reaching the preset time point, the reporting system is by preset time described in the database
The data generated before point are synchronized to described search server, and the point of preset time described in the database is generated before
Data are deleted.
Optionally, when reaching the preset time point, the data for being synchronized to described search server can also divided
It is backed up in cloth file system.The distributed file system for example can for Hadoop distributed file system (HDFS,
Hadoop Distributed File System), wherein Hadoop is a distribution developed by apache foundation
System infrastructure.In the present embodiment, by the way that the number of described search server will be synchronized to when reaching the preset time point
It is backed up according in distributed file system, distributed file system may be implemented to institute's storing data in search server
Backup, to improve the safety of data.
Optionally, 310 can also be included the following steps after step 309.
Step 310, the reporting system delete the data generated before preset time period in described search server
It removes.
In this step, since the data that usual user is used to generate report are all the data of nearest a period of time, for example, most
Nearly 1 year, nearest 3 months etc.；Therefore, by the data generated before preset time period in search server in the present embodiment
It is deleted, it is possible to reduce the data volume in search server saves the memory space of search server.
It should be noted that there is no the limitations of sequencing between step 308- step 310.
The present embodiment, by being obtained from database when determining that the first start time point is later than or is equal to preset time point
Take corresponding first query result of query information；Determining the first start time point earlier than preset time point and the first end time
When point is later than or is equal to the preset time point, corresponding with query information the first query result is obtained from database and from searching
Corresponding second query result of query information is obtained in rope server；Determining that the first end time point is later than preset time point
When, the first query result corresponding with query information is obtained from search server；Realize from search server obtain earlier than
The query result of preset time point, and obtain and be later than or the issuer of the query result equal to preset time point from database
Formula improves the effect for obtaining query result with all needing to obtain from database compared with the matched query result of query information
Rate needs the acquisition from search server to avoid search server need compared with the matched query result of query information with whole
The problem of wanting frequent updating data and influencing search efficiency.
Fig. 4 is the flow chart of report processing method embodiment three of the present invention, and Fig. 5 is interaction schematic diagram of the invention；This reality
It is the zero point for working as the day before yesterday, data as the traffic number of call center using preset time point on the basis of applying example embodiment shown in Fig. 3
It is specifically described for.As shown in Figure 4 and Figure 5, the method for the present embodiment may include:
Step 401, call center message-oriented middleware the traffic data that call center generates 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 are updated in HDFS by step 402, reporting system at daily 0 point.
In this step, specifically, the data of the previous day in MYSQL can be updated to by reporting system by HADOOP task
In HDFS.Wherein, what is stored in HDFS is the data (being properly termed as historical data) in non-present day.Optionally, the number in HDFS
According to subregion can be carried out by the date of formation of data, to facilitate management.
Step 403, the reporting system delete the data before removing the same day in MYSQL.
The data (being properly termed as real time data) when the day before yesterday are only saved in this step, in MYSQL.
The data for being updated to the HDFS are written into ES for step 404, the reporting system.
In this step, specifically, the reporting system can will be updated to the number in the HDFS by HADOOP task
According to (that is, data of the previous day described in step 402) write-in into ES.Wherein, which is specifically as follows ES cluster, and ES can be with
It is indexed according to the querying condition that can be used by a user for data creation.
It should be noted that there is no the limitations of sequencing between step 401- step 404.
Step 405, the reporting system receive the query information of user's input, and obtain inquiry knot according to query information
Fruit.
In this step, specifically, may include steps of 4051,4052,4053.
Step 4051, when the query information instruction inquiry when the data of the day before yesterday, directly according to the query information from
Real time data is obtained in MYSQL.
Step 4052 does not include when the query information indicates to inquire when the data of the day before yesterday, directly according to search inquiry
Information obtains historical data from ES.
Step 4053, when query information instruction inquiry is when the data of the day before yesterday to history some day, looked into according to described
It askes in information and obtains real time data from MYSQL, and historical data is obtained from ES according to search inquiry information.
It can also include: according to the query result got after step 405 (that is, obtaining real time data from MYSQL
And/or historical data is obtained from ES) generate report.
The present embodiment is stored by the data when the day before yesterday to MYSQL, other data are stored to ES；When looking into for user's input
Information instruction inquiry is ask when the data of the day before yesterday, real time data is directly obtained from MYSQL according to the query information；When described
Query information instruction inquiry does not include when the data of the day before yesterday, and historical data is directly obtained from ES according to search inquiry information；
When query information instruction inquiry is when the data of the day before yesterday to history some day, according in the query information from MYSQL
Real time data is obtained, and historical data is obtained from ES according to search inquiry information；To improve the effect for obtaining query result
Rate.
Fig. 6 is the structural schematic diagram of reporting system embodiment of the present invention, and reporting system provided in this embodiment can be applied
In the method for Fig. 2-Fig. 4 embodiment, the function of its reporting system is realized.As shown in fig. 6, the reporting system of the present embodiment can be with
It include: to obtain module 601, enquiry module 602 and generation module 603.Wherein, module 601 is obtained, for obtaining user's input
Query information；Enquiry module 602, for according to obtain module 601 obtain the query information, from search server obtain with
The matched query result of query information；Generation module 603, the query result for being obtained according to enquiry module 602
Generate report.
Optionally, the query information includes the first start time point and the first end time point.
Optionally, first start time point and the first end time point are all earlier than preset time point；
Enquiry module 602, is specifically used for: according to first start time point, the first end time point and described
Preset time point determines and needs to obtain and matched first query result of the query information from described search server；Root
According to the query information, first query result is obtained from described search server；
Correspondingly, generation module 603, is specifically used for generating report according to first query result.
Optionally, first start time point is later than described pre- earlier than preset time point, the first end time point
If time point；
Enquiry module 602, is specifically used for: according to first start time point, the first end time point and described
Preset time point determines needs acquisition and matched first query result of the query information from described search server, and
It needs to obtain from the database and matched second query result of the query information；According to the query information, from institute
It states and obtains first query result in search server, and obtain second query result from the database；
Correspondingly, generation module 603, is specifically used for being generated according to first query result and second query result
Report.
Optionally, enquiry module 602 are specifically used for:
The first inquiry sub-information and the second inquiry sub-information are generated according to the query information；Wherein, described includes second
Start time point and the second end time point, second start time point be equal to first start time point, described second
End time point is equal to the preset time point；At the end of the second inquiry sub-information includes third start time point and third
Between point, the third start time point be equal to the preset time point, the third end time point be equal to it is described first terminate
Time point；
It is obtained and matched first query result of first query information from described search server；
It obtains and matched second query result of second query information from the database.
Optionally, the reporting system of the present embodiment further include: the first synchronization module；
First synchronization module is used for when reaching the preset time point, when will preset described in the database
Between the data that generate before point be synchronized to described search server, and will be generated before the point of preset time described in the database
Data delete.
Optionally, the reporting system of the present embodiment further include: the second synchronization module；
Second synchronization module, for described search server will to be synchronized to when reaching the preset time point
Data are backed up in distributed file system.
Optionally, the reporting system of the present embodiment further include: removing module；
The removing module, for deleting the data generated before preset time period in described search server.
The reporting system of the present embodiment can be used for executing the technical solution of embodiment of the method shown in Fig. 2-Fig. 4, realize
Principle is similar with technical effect, and details are not described herein again.
Those of ordinary skill in the art will appreciate that: realize that all or part of the steps of above-mentioned each method embodiment can lead to
The relevant hardware of program instruction is crossed to complete.Program above-mentioned can be stored in a computer readable storage medium.The journey
When being executed, execution includes the steps that above-mentioned each method embodiment to sequence；And storage medium above-mentioned include: ROM, RAM, magnetic disk or
The various media that can store program code such as person's CD.
Finally, it should be noted that the above embodiments are only used to illustrate the technical solution of the present invention., rather than its limitations；To the greatest extent
Pipe present invention has been described in detail with reference to the aforementioned embodiments, those skilled in the art should understand that: its according to
So be possible to modify the technical solutions described in the foregoing embodiments, or to some or all of the technical features into
Row equivalent replacement；And these are modified or replaceed, various embodiments of the present invention technology that it does not separate the essence of the corresponding technical solution
The range of scheme.
Claims (10)
1. a kind of report processing method characterized by comprising
Obtain the query information of user's input；Wherein, the query information includes the first start time point and the first end time
Point；
According to the query information, obtained and the matched query result of the query information from search server；
Report is generated according to the query result；
Wherein, first start time point is later than the preset time earlier than preset time point, the first end time point
Point；
It is described according to the query information, obtained and the matched query result of the query information from search server, comprising:
According to first start time point, the first end time point and preset time point, determines and need from described
Acquisition and matched first query result of the query information in search server, and need to obtain from database to look into described
Ask the second query result of information matches；
According to the query information, first query result is obtained from described search server, and from the database
Obtain second query result；
Correspondingly, described generate report according to the query result, comprising:
Report is generated according to first query result and second query result.
2. the method according to claim 1, wherein described according to the query information, from described search service
First query result is obtained in device, and obtains second query result from the database, comprising:
The first inquiry sub-information and the second inquiry sub-information are generated according to the query information；Wherein, the first inquiry son letter
Breath includes the second start time point and the second end time point, and second start time point is equal to first initial time
Point, the second end time point are equal to the preset time point；The second inquiry sub-information includes third start time point
With third end time point, the third start time point is equal to the preset time point, and the third end time point is equal to
The first end time point；
It is obtained and matched first query result of first query information from described search server；
It obtains and matched second query result of second query information from the database.
3. method according to claim 1 or 2, which is characterized in that the method also includes:
When reaching the preset time point, the data generated before the point of preset time described in the database are synchronized to institute
Search server is stated, and the data generated before the point of preset time described in the database are deleted.
4. according to the method described in claim 3, it is characterized in that, the method also includes: reach the preset time point
When, the data for being synchronized to described search server are backed up in distributed file system.
5. according to the method described in claim 3, it is characterized in that, the method also includes: to pre- in described search server
If the data generated before the period are deleted.
6. a kind of reporting system characterized by comprising
Module is obtained, for obtaining the query information of user's input；Wherein, the query information include the first start time point and
First end time point；
Enquiry module, for obtaining from search server and being tied with the matched inquiry of the query information according to the query information
Fruit；
Generation module, for generating report according to the query result；
Wherein, first start time point is later than the preset time earlier than preset time point, the first end time point
Point；
The enquiry module, is specifically used for:
According to first start time point, the first end time point and preset time point, determines and need from described
Acquisition and matched first query result of the query information in search server, and need to obtain from database to look into described
Ask the second query result of information matches；
According to the query information, first query result is obtained from described search server, and from the database
Obtain second query result；
Correspondingly, the generation module, is specifically used for generating report according to first query result and second query result
Table.
7. reporting system according to claim 6, which is characterized in that the enquiry module is specifically used for:
The first inquiry sub-information and the second inquiry sub-information are generated according to the query information；Wherein, the first inquiry son letter
Breath includes the second start time point and the second end time point, and second start time point is equal to first initial time
Point, the second end time point are equal to the preset time point；The second inquiry sub-information includes third start time point
With third end time point, the third start time point is equal to the preset time point, and the third end time point is equal to
The first end time point；
It is obtained and matched first query result of first query information from described search server；
It obtains and matched second query result of second query information from the database.
8. reporting system according to claim 6 or 7, which is characterized in that the system also includes: the first synchronization module；
First synchronization module is used for when reaching the preset time point, by the point of preset time described in the database
The data generated before are synchronized to described search server, and the number that will be generated before the point of preset time described in the database
According to deletion.
9. reporting system according to claim 8, which is characterized in that the reporting system further include: the second synchronization module；
Second synchronization module, for the data of described search server will to be synchronized to when reaching the preset time point
It is backed up in distributed file system.
10. reporting system according to claim 8, which is characterized in that the system also includes removing module, for pair
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 CN106250501A (en) | 2016-12-21 |
| CN106250501B true 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) |
Families Citing this family (4)
| 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 |
| CN108536761B (en) * | 2018-03-21 | 2022-03-04 | 平安科技（深圳）有限公司 | Report data query method and server |
| CN109063077B (en) * | 2018-07-24 | 2020-12-08 | 新华三大数据技术有限公司 | Data access method and device based on elastic search |
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 |
Also Published As
| Publication number | Publication date |
|---|---|
| CN106250501A (en) | 2016-12-21 |
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 | |
| US20190005025A1 (en) | Performing semantic graph search | |
| CN106250501B (en) | Report processing method and reporting system | |
| US20180113771A1 (en) | Transaction consistency query support for replicated data from recovery log to external data stores | |
| CN105677250B (en) | The update method and updating device of object data in object storage system | |
| CN110674154B (en) | Spark-based method for inserting, updating and deleting data in Hive | |
| CN102521712B (en) | A kind of process instance data processing method and device | |
| US8620946B2 (en) | Storage and searching of temporal entity information | |
| US20140156849A1 (en) | Map-reduce workflow processing apparatus and method, and storage media storing the same | |
| CN110175239A (en) | A kind of construction method and system of knowledge mapping | |
| EP2526479A1 (en) | Accessing large collection object tables in a database | |
| CN109271561B (en) | Map information retrieval method and device | |
| CN103235811A (en) | Data storage method and device | |
| CN113157947A (en) | Knowledge graph construction method, tool, device and server | |
| CN113282611B (en) | Method, device, computer equipment and storage medium for synchronizing stream data | |
| CN111046041A (en) | Data processing method and device, storage medium and processor | |
| CN106802928B (en) | Power grid historical data management method and system | |
| CN110019200A (en) | A kind of foundation of index, application method and device | |
| CN111177244A (en) | Data association analysis method for multiple heterogeneous databases | |
| CN102932416A (en) | Intermediate data storage method, processing method and device in information flow task | |
| CN112860412A (en) | Service data processing method and device, electronic equipment and storage medium | |
| US10360234B2 (en) | Recursive extractor framework for forensics and electronic discovery | |
| US10296589B2 (en) | Grouping content based upon user activity | |
| CN115858486A (en) | Data processing method and related equipment |
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 |