CN107644382A - Policy information statistical method and device - Google Patents
Policy information statistical method and device Download PDFInfo
- Publication number
- CN107644382A CN107644382A CN201610586676.2A CN201610586676A CN107644382A CN 107644382 A CN107644382 A CN 107644382A CN 201610586676 A CN201610586676 A CN 201610586676A CN 107644382 A CN107644382 A CN 107644382A
- Authority
- CN
- China
- Prior art keywords
- database
- statistical
- declaration form
- policy information
- statistics
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The present invention relates to a kind of policy information statistical method and device, methods described to include：Declaration form to be counted is captured in database according to predeterminated frequency；Statistical dimension is obtained, the policy information according to corresponding to the statistical dimension extracts the declaration form to be counted；Declaration form structure table is generated according to the policy information；Statistics task corresponding to being performed to the declaration form structure table, the policy information after being counted.The declaration form statistical information degree of accuracy can be effectively improved using this method.
Description
Technical field
The present invention relates to field of computer technology, more particularly to a kind of policy information statistical method and device.
Background technology
With the development of society, insurance has been deep into the life of people.The type of insurance is also more and more.Each class
Requirement of the insurance of type to information accuracy is all very high, therefore the calculating logic when backstage counts to policy information is all
Can be very complicated.Traditional mode, it is by submitting pin after carrying out manual modification to policy information when being counted to policy information
This program performs statistical operation, but manual modification policy information error-prone, causes the degree of accuracy of statistical result to decline.
The content of the invention
Based on this, it is necessary to for above-mentioned technical problem, there is provided one kind can effectively improve the declaration form statistical information degree of accuracy
Policy information statistical method and device.
A kind of policy information statistical method, methods described include：
Declaration form to be counted is captured in database according to predeterminated frequency；
Statistical dimension is obtained, the policy information according to corresponding to the statistical dimension extracts the declaration form to be counted；
Declaration form structure table is generated according to the policy information；
Statistics task corresponding to being performed to the declaration form structure table, the policy information after being counted.
In one of the embodiments, methods described also includes：
Batch processing practice condition in database in first time period and resource consumption situation are monitored, obtained
The execution time and resource consumption time of batch processing in one period；
The execution time and resource consumption time of batch processing in first time period are compared, obtain the free time of database
Time；
It is described that statistics task corresponding to declaration form structure table execution is included：Database free time to the guarantor
Statistics task corresponding to the execution of single structure table.
In one of the embodiments, it is described the declaration form structure table is performed corresponding to after statistics task, also wrap
Include：
Statistical log is called, statistics task practice condition is have recorded in the statistical log；
Breakpoint task is searched according to the statistical log, statistical operation is continued executing with since the breakpoint task.
In one of the embodiments, it is described that statistics task corresponding to declaration form structure table execution is included：
Statistics task is obtained using multiple threads concurrently to perform；
After a statistics task has performed, thread obtains next statistics task to perform at random；Or in a system
After meter tasks carrying is complete, thread, which is fixed, obtains next statistics task to perform.
In one of the embodiments, the database is database corresponding to big data platform, described in the basis
Statistical dimension is to statistics task corresponding to declaration form structure table execution, after the policy information after being counted, in addition to：
The inquiry request that receiving terminal is sent, the inquiry request is sent to JDBC interfaces；
Judge whether include authority keyword in the inquiry request by JDBC interfaces；
If so, the inquiry request then is imported into relevant database, retrieval and authority are crucial in relevant database
The user right mark of word matching；
Declaration form after statistics corresponding to being obtained in the database according to corresponding to user right mark in big data platform
Information.
A kind of policy information statistic device, described device include：
Acquisition module, for capturing declaration form to be counted in database according to predeterminated frequency；Statistical dimension is obtained, according to
The statistical dimension extracts policy information corresponding to the declaration form to be counted；
Generation module, for generating declaration form structure table according to the policy information；
Statistical module, for statistics task, the policy information after being counted corresponding to declaration form structure table execution.
In one of the embodiments, described device also includes：
Monitoring module, for the batch processing practice condition in database in first time period and the progress of resource consumption situation
Monitoring, obtains the execution time and resource consumption time of the batch processing in first time period；
Comparing module, it is compared, obtains for the execution time to batch processing in first time period and resource consumption time
To the free time of database；
The statistical module is additionally operable to perform the declaration form structure table corresponding statistics times in the free time of database
Business.
In one of the embodiments, the acquisition module is additionally operable to call statistical log, is recorded in the statistical log
Statistics task practice condition；The statistical module is additionally operable to search breakpoint task according to the statistical log, from the breakpoint
Task starts to continue executing with statistical operation.
In one of the embodiments, the statistical module is additionally operable to concurrently hold using multiple threads acquisition statistics task
OK；After a statistics task has performed, thread obtains next statistics task to perform at random；Or in a statistics task
After having performed, thread, which is fixed, obtains next statistics task to perform.
In one of the embodiments, the database is that database, described device corresponding to big data platform also include：
Receiving module, the inquiry request sent for receiving terminal, the inquiry request is sent to JDBC interfaces；
Judge module, for judging whether include authority keyword in the inquiry request by JDBC interfaces；
Enquiry module, if including authority keyword for the inquiry request, the inquiry request is imported into relation
Type database, retrieval and the user right of authority keyword match identify in relevant database；According to the user right
Identify the policy information after being counted corresponding to being obtained in database corresponding to big data platform；
Sending module, for the policy information after the statistics to be back into terminal.
Above-mentioned policy information statistical method and device, by capturing guarantor to be counted in database according to predeterminated frequency
It is single, statistical dimension is obtained, so as to extract policy information corresponding to declaration form to be counted according to statistical dimension.Different statistics purposes
There can be different statistical dimensions, different statistical dimensions can extract different policy informations.By according to policy information
Declaration form structure table is generated, to statistics task, the policy information after thus being counted corresponding to the execution of declaration form structure table.Whole
During, can be according to predeterminated frequency and the statistics of statistical dimension progress policy information, without manual operation, so as to realize system
The degree of accuracy of declaration form statistical information is effectively increased while counting purpose.
Brief description of the drawings
Fig. 1 is the flow chart of policy information statistical method in one embodiment；
Fig. 2 is the structural representation of server in one embodiment；
Fig. 3 is the structural representation of policy information statistic device in one embodiment；
Fig. 4 is the structural representation of policy information statistic device in another embodiment；
Fig. 5 is the structural representation of policy information statistic device in a still further embodiment.
Embodiment
In order to make the purpose , technical scheme and advantage of the present invention be clearer, it is right below in conjunction with drawings and Examples
The present invention is further elaborated.It should be appreciated that specific embodiment described herein is only to explain the present invention, not
For limiting the present invention.
In one embodiment, as shown in Figure 1, there is provided a kind of policy information statistical method, be applied to clothes in this way
Illustrate, specifically include exemplified by business device：
102, declaration form to be counted is captured in database according to predeterminated frequency.
Job has been run in server, has captured declaration form to be counted in database by job.Declaration form to be counted can be with
It is whole declaration forms or part declaration form.It is different according to statistics purpose, the declaration form of different range can be configured as to be counted
Declaration form.Declaration form scope to be counted includes declaration form in all declaration forms and preset time period etc., wherein all declaration forms are indexes
According to the declaration form stored in storehouse, including to the declaration form stored when running job crawl declaration forms in database since first declaration form.
Declaration form in preset time period refers to the declaration form stored in some period in database.Declaration form to be counted can be institute
There is declaration form in declaration form or preset time period etc..Job is configured for predeterminated frequency and declaration form scope to be counted, root
Declaration form to be counted is captured in database according to predeterminated frequency.Predeterminated frequency can be monthly, quarterly once, every half a year
It is once and annual etc..According to the difference of statistics purpose, different predeterminated frequencies can be selected.Database can be relation
Type database, for example, SQL Server (a Relational DBMS that Microsoft releases) database.Data
Storehouse can also be database corresponding to big data platform, and for example, HDFS (Hadoop Distributed File System, one
Kind distributed file system) distributed file system.
104, statistical dimension is obtained, policy information corresponding to declaration form to be counted is extracted according to statistical dimension.
Server obtains statistical dimension, and policy information corresponding to declaration form to be counted is extracted according to statistical dimension.Statistics
Dimension can be set according to statistics purpose.Different statistics purposes, can set different statistical dimensions.Server root
Different policy informations can be extracted according to different statistical dimensions.For example, working as needs to count corresponding to the declaration form of multiple insurance kinds
When continuing rate, statistical dimension includes the time and declaration form renews, and policy information includes number of policy, first insurance kind, insured time, continuation of insurance
Time and renewal premium etc..
106, declaration form structure table is generated according to policy information.
Server declaration form structure table according to corresponding to the policy information generation got.Declaration form structure table can be two-dimemsional number
According to table.For example, declaration form structure table can be the interim table that server generates in SQL Servers databases.Server will be protected
Single structure table is split as multiple packets to be counted.Wherein, the declaration form amount of packet can be an empirical value or according to
The getable estimate of property of database.Declaration form structure table can be split as multiple different to be counted by server according to insurance kind
Packet.Specifically, server obtains insurance kind corresponding to declaration form, the index of declaration form structure table is created according to insurance kind；According to index
Declaration form corresponding to multiple insurance kinds is split as multiple packets to be counted according to the declaration form amount of packet.
108, to statistics task, the policy information after being counted corresponding to the execution of declaration form structure table.
Server can generate multiple statistics tasks in database according to the policy information in packet to be counted.Service
Device can obtain the number of policy mantissa of number of policy in packet to be counted in database, by the identical declaration form life of number of policy mantissa
Into a statistics task, so as to obtain multiple statistics tasks.Wherein, number of policy mantissa can be one, end or end multidigit.
Server can also be to declaration form amount corresponding to the configuration of each statistics task, and the declaration form amount being configured according to statistics task will be to be counted
Packet generate multiple statistics tasks.Multiple threads have been run on server, packet to be counted has been performed using multiple threads
Corresponding statistics task, the policy information after being counted.Due to concurrently performing statistics task using multiple threads, so as to effectively
Improve statistical efficiency.
In the present embodiment, by capturing declaration form to be counted in database according to predeterminated frequency, statistical dimension is obtained, from
And policy information corresponding to declaration form to be counted is extracted according to statistical dimension.Different statistics purposes can have different statistics dimensions
Degree, different statistical dimensions can extract different policy informations.By generating declaration form structure table according to policy information, to protecting
Statistics task corresponding to the execution of single structure table, the policy information after thus being counted., can be according to default in whole process
Frequency and statistical dimension carry out the statistics of policy information, without manual operation, so as to effectively be carried while realizing and counting purpose
The high degree of accuracy of declaration form statistical information.
In one embodiment, this method also includes：To the batch processing practice condition in database in first time period and
Resource consumption situation is monitored, and obtains the execution time and resource consumption time of the batch processing in first time period；To first
The execution time and resource consumption time of batch processing in period are compared, and obtain the free time of database；To declaration form knot
Statistics task corresponding to the execution of structure table includes：According to statistics task corresponding to free time execution of the statistical dimension in database.
In the present embodiment, the free time of database refers to time when database performance is optimal.Run on server
Monitoring script, multiple databases are monitored using monitoring script, the free time of database is obtained according to monitoring information.
Specifically, monitoring script is run on server, by monitoring script to batch in database in first time period
Processing tasks carrying situation and resource consumption situation are monitored, and obtain the execution time of the batch processing task in first time period
With the resource consumption time.Batch processing task saves clearing and the refreshing of declaration form snapshot etc. from damage including declaration form.
In order to fully alleviate the pressure of database resource consumption, first time period can be arranged to whole inoperative
The period of time or the period of part non-working time.For example, the evening 8 in one month:00~morning 5:00 when
Between section.Further, first time period can also be the period of the part non-working time in first time period.For example, one
The evening 8 of No. 1~No. 5 in individual month:00~morning 5:00 period.Server will in first time period resource elapsed time
Counted, obtain resource consumption statistical form.Server extracts resource consumption time and multiple batches in resource consumption statistical form
The execution time of processing task is compared, when filtering out the resource consumption that can avoid multiple batch processing tasks execution times
Between.More database resource can be consumed when being performed due to batch processing task, therefore avoids multiple batch processing tasks and performs the time
The resource consumption time, can be as the free time of database.Because the free time of database is in first time period
, first time period can be the period of non-working time, therefore the free time of the database obtained through the above way
Database performance optimal free time can be considered as.
By being monitored to the batch processing task practice condition in database in first time period and resource consumption situation,
So as to be automatically analyzed to obtain the free time of database according to monitored results.Whole process need not be participated in manually, effectively
Reduce human cost.Server database free time to declaration form structure table perform corresponding to statistics task.Due to being
Statistics task is performed in the free time of database, therefore can effectively alleviate the pressure of database resource consumption.
In one embodiment, after statistics task corresponding to being performed to declaration form structure table, in addition to：Call statistics day
Will, statistics task practice condition is have recorded in statistical log；According to statistical log search breakpoint task, since breakpoint task after
It is continuous to perform statistical operation.
In the present embodiment, server records statistical log, have recorded in statistical log during policy information counts
The practice condition of statistics task.The statistics of policy information is monitored by statistical log.Once in policy information statistics
During go wrong, server can by call statistical log fast positioning to error position.
When multiple threads are sometime exiting from database, may all statistics tasks be also not carried out
Finish.Need to carry out concurrent operations to the statistics task having not carried out in an active thread.Specifically, when multiple threads are in data
It is corresponding when being exited before going out multiple threads according to the content search recorded in statistical log in database when being run again in storehouse
Breakpoint task.Breakpoint task refers to have started to perform and has not carried out the statistics task that finishes.It is multiple since breakpoint task
Thread is again continued to perform concurrent operations, and policy information is counted according to default logic.
When operation performs statistics task again after being exited due to multiple threads, it is not necessary to which all statistics tasks are held again
OK.Multiple thread corresponding breakpoint tasks when exiting can be searched according to the practice condition of statistics task so that multiple threads
Concurrent operations are continued executing with since breakpoint task.The time for carrying out full dose to statistics task and mending execution is this saved, and
By searching breakpoint task, start to continue executing with breakpoint task, effectively prevent the leakage of statistics task from performing and missing execution etc., have
Effect improves the efficiency of policy information statistics.
Further, multiple threads can concurrently perform statistics task in the free time of database.It is non-when database
At the end of between idle, multiple threads exit from database.When arriving again at the free time of database, server is in number
According to running multiple threads in storehouse, when being exited before going out multiple threads according to the content search recorded in statistical log in database
Corresponding breakpoint task.Since breakpoint task, multiple threads again continue to perform concurrent operations, according to default logic to protecting
Single information is counted.Performed during due to statistics task in the free time of database, therefore can effectively alleviate data
The pressure of resource consumption.
In one embodiment, statistics task corresponding to being performed to declaration form structure table includes：Obtained and united using multiple threads
Meter task concurrently performs；After a statistics task has performed, thread obtains next statistics task to perform at random；Or
After one statistics task has performed, thread, which is fixed, obtains next statistics task to perform.
In the present embodiment, in order to effectively improve the statistical efficiency of policy information, server runs multiple threads and concurrently performed
Statistics task.The quantity of thread is less than the quantity of statistics task.Wherein, thread, which can be fixed, performs some statistics tasks, also may be used
To obtain some statistics task at random to perform.Thread can obtain statistics task according to insurance kind, can also be according to number of policy
Mantissa obtains statistics task.
Thread can be configured as the fixed statistics task for performing a certain insurance kind, or the fixed a certain number of policy mantissa of execution
Statistics task.Fixed due to thread and perform some statistics task, therefore, easily find to go out during statistics task is performed
Existing exception, maintenance cost are relatively low.
Thread can be additionally configured to perform the statistics task of a certain insurance kind at random, or perform a certain number of policy tail at random
Several statistics tasks, because policy information amount is huge, statistics task is obtained with number of policy mantissa, enables to each thread to hold
The quantity of row statistics task tends to be balanced, so as to effectively increase the efficiency that multiple threads concurrently perform statistics task.
In one embodiment, database is database corresponding to big data platform, according to statistical dimension to declaration form knot
Structure table perform corresponding to statistics task, after the policy information after being counted, in addition to：The inquiry that receiving terminal is sent please
Ask, inquiry request is sent to JDBC interfaces；Judge whether include authority keyword in inquiry request by JDBC interfaces；If
It is that inquiry request is then imported into relevant database, retrieval and the user of authority keyword match weigh in relevant database
Limit mark；Policy information after statistics corresponding to being obtained in the database according to corresponding to user right mark in big data platform；
Policy information after statistics is back to terminal.
In the present embodiment, the data for storing policy information are database corresponding to big data platform.Pass through big data platform
Corresponding database can carry out the inquiry of mass data.Server receives the inquiry request that more station terminals are sent.Server with
By JDBC, (Java DataBase Connectivity, Java database connect database corresponding to big data platform, by one
Group is formed with the class that Java language is write and interface) interface connects.Shell script is configured with JDBC interfaces, passes through the script journey
Sequence enables to JDBC interfaces to judge whether include authority keyword in inquiry request.Authority keyword refers to that report query is weighed
The keyword of limit, including region, mechanism and service grade etc..
If inquiry request includes authority keyword, inquiry request is imported relationship type by server by JDBC interfaces
Database.Authority keyword of the server in inquiry request is retrieved in authority list, is obtained and authority keyword match
User right.Authority list is stored in relevant database.Authority list includes user right mark and closed with corresponding authority
Key word.Authority list is the permissions data set organized in terms of rows and columns.In relevant database, a table is exactly
One relation, multiple relations can be included in a relevant database.Authority list i.e. one of relation.In relation
In type database, the authority keyword in inquiry request utilizes SQL (Structured Query Language, Yi Zhongjie
Structure query language) inquiry mode, matched user right mark is retrieved in authority list.Server according to
Family capability identification is inquired about in database corresponding to big data platform, obtains corresponding Query Result, that is, the guarantor after counting
Single information.If not including authority keyword in inquiry request, server is directly according to inquiry request in big data platform pair
Inquired about in the database answered, obtain corresponding Query Result, that is, the policy information after counting.Server is by the guarantor after statistics
Single information is back to terminal.Policy information after statistics is shown by terminal by browser.
Due to relational data be applied to small amount of data inquiry, therefore in relevant database can quick-searching arrive
Identified with the user right of authority keyword match.The number according to corresponding to user right mark and inquiry request in big data platform
According to being inquired about in storehouse, corresponding Query Result can be quickly obtained.If JDBC interfaces judge that not including authority in inquiry request closes
Key word, then it can directly be inquired about according to inquiry request in big data platform, thus quickly obtain corresponding Query Result.Work as sea
When inquiring about and deposit with carrying the small amount of data of authority information when measuring data query, it is not necessary in database corresponding to big data platform
In identified to inquire about with the user right of authority keyword match, but by being retrieved in relevant database and authority is crucial
The user right mark of word matching, so as to effectively increase the search efficiency in big data platform.
In one embodiment, as shown in Figure 2, there is provided a kind of server, including the processing connected by system bus
Device, built-in storage, non-volatile memory medium and network interface.Wherein, stored in the non-volatile memory medium of the server
There are operating system and policy information statistic device, policy information statistic device is used to realize a kind of policy information statistical method.Clothes
The processor of business device is used to provide calculating and control ability, is configured as performing a kind of policy information statistical method.
In one embodiment, as shown in Figure 3, there is provided a kind of policy information statistic device, including：Acquisition module 302,
Generation module 304 and statistical module 306, wherein：
Acquisition module 302, for capturing declaration form to be counted in database according to predeterminated frequency；Obtain statistical dimension,
Policy information corresponding to declaration form to be counted is extracted according to statistical dimension.
Generation module 304, for generating declaration form structure table according to policy information.
Statistical module 306, for statistics task, the policy information after being counted corresponding to the execution of declaration form structure table.
In one embodiment, as shown in figure 4, the device also includes：Monitoring module 308 and comparing module 310, wherein：
Monitoring module 308, for the batch processing practice condition and resource consumption situation in database in first time period
It is monitored, obtains the execution time and resource consumption time of the batch processing in first time period.
Comparing module 310, it is compared for the execution time to batch processing in first time period and resource consumption time,
Obtain the free time of database.
Statistical module 306 is additionally operable to the free time in database to statistics task corresponding to the execution of declaration form structure table.
In one embodiment, acquisition module 302 is additionally operable to call statistical log, and statistics task is have recorded in statistical log
Practice condition；Statistical module 306 is additionally operable to search breakpoint task according to statistical log, and statistics is continued executing with since breakpoint task
Operation.
In one embodiment, statistical module 306 is additionally operable to concurrently perform using multiple threads acquisition statistics task；One
After individual statistics task has performed, thread obtains next statistics task to perform at random；Or performed in a statistics task
Afterwards, thread, which is fixed, obtains next statistics task to perform.
In one embodiment, database is database corresponding to big data platform, as shown in figure 5, the device also includes：
Receiving module 312, judge module 314, enquiry module 316 and sending module 318, wherein：
Receiving module 312, the inquiry request sent for receiving terminal, inquiry request is sent to JDBC interfaces.
Judge module 314, for judging whether include authority keyword in inquiry request by JDBC interfaces.
Enquiry module 316, if including authority keyword for inquiry request, inquiry request is imported into relational data
Storehouse, retrieval and the user right of authority keyword match identify in relevant database；Counted greatly according to user right mark
According to the policy information after being counted corresponding to acquisition in database corresponding to platform.
Sending module 318, for the policy information after statistics to be back into terminal.
Each technical characteristic of above example can be combined arbitrarily, to make description succinct, not to above-described embodiment
In each technical characteristic it is all possible combination be all described, as long as however, lance is not present in the combination of these technical characteristics
Shield, all it is considered to be the scope of this specification record.
Above example only expresses the several embodiments of the present invention, and its description is more specific and detailed, but can not
Therefore it is construed as limiting the scope of the patent.It should be pointed out that for the person of ordinary skill of the art,
On the premise of not departing from present inventive concept, various modifications and improvements can be made, these belong to protection scope of the present invention.
Therefore, the protection domain of patent of the present invention should be determined by the appended claims.
Claims (10)
1. a kind of policy information statistical method, methods described include：
Declaration form to be counted is captured in database according to predeterminated frequency；
Statistical dimension is obtained, the policy information according to corresponding to the statistical dimension extracts the declaration form to be counted；
Declaration form structure table is generated according to the policy information；
Statistics task corresponding to being performed to the declaration form structure table, the policy information after being counted.
2. according to the method for claim 1, it is characterised in that methods described also includes：
Batch processing practice condition in database in first time period and resource consumption situation are monitored, obtained at first
Between in section batch processing execution time and resource consumption time；
The execution time and resource consumption time of batch processing in first time period are compared, when obtaining the free time of database
Between；
It is described that statistics task corresponding to declaration form structure table execution is included：Database free time to the declaration form knot
Statistics task corresponding to the execution of structure table.
3. according to the method for claim 1, it is characterised in that corresponding count is performed to the declaration form structure table described
After task, in addition to：
Statistical log is called, statistics task practice condition is have recorded in the statistical log；
Breakpoint task is searched according to the statistical log, statistical operation is continued executing with since the breakpoint task.
4. according to the method for claim 1, it is characterised in that described that corresponding statistics times is performed to the declaration form structure table
Business includes：
Statistics task is obtained using multiple threads concurrently to perform；
After a statistics task has performed, thread obtains next statistics task to perform at random；Or appoint in a statistics
After business has performed, thread, which is fixed, obtains next statistics task to perform.
5. according to the method for claim 1, it is characterised in that the database is database corresponding to big data platform,
It is described according to the statistical dimension to the declaration form structure table perform corresponding to statistics task, the policy information after being counted
Afterwards, in addition to：
The inquiry request that receiving terminal is sent, the inquiry request is sent to JDBC interfaces；
Judge whether include authority keyword in the inquiry request by JDBC interfaces；
If so, the inquiry request is then imported into relevant database, retrieval and authority keyword in relevant database
The user right mark matched somebody with somebody；
Policy information after statistics corresponding to being obtained in the database according to corresponding to user right mark in big data platform.
6. a kind of policy information statistic device, it is characterised in that described device includes：
Acquisition module, for capturing declaration form to be counted in database according to predeterminated frequency；Statistical dimension is obtained, according to described
Statistical dimension extracts policy information corresponding to the declaration form to be counted；
Generation module, for generating declaration form structure table according to the policy information；
Statistical module, for statistics task, the policy information after being counted corresponding to declaration form structure table execution.
7. device according to claim 6, it is characterised in that described device also includes：
Monitoring module, for being supervised to the batch processing practice condition in database in first time period and resource consumption situation
Control, obtains the execution time and resource consumption time of the batch processing in first time period；
Comparing module, it is compared, is counted for the execution time to batch processing in first time period and resource consumption time
According to the free time in storehouse；
The statistical module is additionally operable to the free time in database to statistics task corresponding to declaration form structure table execution.
8. device according to claim 6, it is characterised in that the acquisition module is additionally operable to call statistical log, described
Statistics task practice condition is have recorded in statistical log；The statistical module is additionally operable to search breakpoint times according to the statistical log
Business, statistical operation is continued executing with since the breakpoint task.
9. device according to claim 6, it is characterised in that the statistical module is additionally operable to obtain system using multiple threads
Meter task concurrently performs；After a statistics task has performed, thread obtains next statistics task to perform at random；Or
After one statistics task has performed, thread, which is fixed, obtains next statistics task to perform.
10. device according to claim 6, it is characterised in that the database is database corresponding to big data platform,
Described device also includes：
Receiving module, the inquiry request sent for receiving terminal, the inquiry request is sent to JDBC interfaces；
Judge module, for judging whether include authority keyword in the inquiry request by JDBC interfaces；
Enquiry module, if including authority keyword for the inquiry request, the inquiry request is imported into relationship type number
According to storehouse, retrieval and the user right of authority keyword match identify in relevant database；Identified according to the user right
Policy information after being counted corresponding to being obtained in database corresponding to big data platform；
Sending module, for the policy information after the statistics to be back into terminal.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201610586676.2A CN107644382A (en) | 2016-07-22 | 2016-07-22 | Policy information statistical method and device |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201610586676.2A CN107644382A (en) | 2016-07-22 | 2016-07-22 | Policy information statistical method and device |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN107644382A true CN107644382A (en) | 2018-01-30 |
Family
ID=61109635
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201610586676.2A Pending CN107644382A (en) | 2016-07-22 | 2016-07-22 | Policy information statistical method and device |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN107644382A (en) |
Cited By (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109299875A (en) * | 2018-09-26 | 2019-02-01 | 中国平安财产保险股份有限公司 | Data tracking processing method, device, computer equipment and storage medium |
| CN109325058A (en) * | 2018-09-03 | 2019-02-12 | 中国平安人寿保险股份有限公司 | Regular batch comparison method, device, computer equipment and storage medium |
| WO2019136855A1 (en) * | 2018-01-12 | 2019-07-18 | 平安科技（深圳）有限公司 | Method and apparatus for implementing multidimensional analysis on insurance policy, terminal device, and storage medium |
| CN111402067A (en) * | 2020-02-22 | 2020-07-10 | 中国平安财产保险股份有限公司 | Method for tracking list to be renewed, server and computer readable storage medium |
| CN112364004A (en) * | 2020-11-10 | 2021-02-12 | 中国平安人寿保险股份有限公司 | Policy data processing method and device based on data warehouse and storage medium |
Citations (10)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1299097A (en) * | 1999-12-03 | 2001-06-13 | 国际商业机器公司 | Balanced access for data roll with dundant copies in data storage base |
| US20030083907A1 (en) * | 2001-10-30 | 2003-05-01 | Fujitsu Limited | Insurance system, insurance server, insurance system operation method, and insurance server program storage medium |
| CN101211429A (en) * | 2006-12-27 | 2008-07-02 | 厦门雅迅网络股份有限公司 | Vehicle usage statistical method |
| CN101354767A (en) * | 2007-07-27 | 2009-01-28 | 周家民 | Safety network selling system |
| CN101795213A (en) * | 2010-02-10 | 2010-08-04 | 徐泽勇 | Agricultural insurance-dedicated wireless intelligent management platform |
| CN102385536A (en) * | 2010-08-27 | 2012-03-21 | 中兴通讯股份有限公司 | Method and system for realization of parallel computing |
| CN102592196A (en) * | 2011-12-29 | 2012-07-18 | 深圳市酷开网络科技有限公司 | Method and system for managing electronic insurance policy |
| CN103473342A (en) * | 2013-09-23 | 2013-12-25 | 北京久其软件股份有限公司 | Report data generating method and system |
| CN104268178A (en) * | 2014-09-16 | 2015-01-07 | 积成电子股份有限公司 | Electric energy database writing method for power consumer electricity utilization information acquisition system |
| CN204695407U (en) * | 2015-06-25 | 2015-10-07 | 南京特嗨网络科技有限公司 | Car insurance charge system |
-
2016
- 2016-07-22 CN CN201610586676.2A patent/CN107644382A/en active Pending
Patent Citations (10)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1299097A (en) * | 1999-12-03 | 2001-06-13 | 国际商业机器公司 | Balanced access for data roll with dundant copies in data storage base |
| US20030083907A1 (en) * | 2001-10-30 | 2003-05-01 | Fujitsu Limited | Insurance system, insurance server, insurance system operation method, and insurance server program storage medium |
| CN101211429A (en) * | 2006-12-27 | 2008-07-02 | 厦门雅迅网络股份有限公司 | Vehicle usage statistical method |
| CN101354767A (en) * | 2007-07-27 | 2009-01-28 | 周家民 | Safety network selling system |
| CN101795213A (en) * | 2010-02-10 | 2010-08-04 | 徐泽勇 | Agricultural insurance-dedicated wireless intelligent management platform |
| CN102385536A (en) * | 2010-08-27 | 2012-03-21 | 中兴通讯股份有限公司 | Method and system for realization of parallel computing |
| CN102592196A (en) * | 2011-12-29 | 2012-07-18 | 深圳市酷开网络科技有限公司 | Method and system for managing electronic insurance policy |
| CN103473342A (en) * | 2013-09-23 | 2013-12-25 | 北京久其软件股份有限公司 | Report data generating method and system |
| CN104268178A (en) * | 2014-09-16 | 2015-01-07 | 积成电子股份有限公司 | Electric energy database writing method for power consumer electricity utilization information acquisition system |
| CN204695407U (en) * | 2015-06-25 | 2015-10-07 | 南京特嗨网络科技有限公司 | Car insurance charge system |
Cited By (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| WO2019136855A1 (en) * | 2018-01-12 | 2019-07-18 | 平安科技（深圳）有限公司 | Method and apparatus for implementing multidimensional analysis on insurance policy, terminal device, and storage medium |
| CN109325058A (en) * | 2018-09-03 | 2019-02-12 | 中国平安人寿保险股份有限公司 | Regular batch comparison method, device, computer equipment and storage medium |
| CN109325058B (en) * | 2018-09-03 | 2023-09-01 | 中国平安人寿保险股份有限公司 | Rule batch comparison method, device, computer equipment and storage medium |
| CN109299875A (en) * | 2018-09-26 | 2019-02-01 | 中国平安财产保险股份有限公司 | Data tracking processing method, device, computer equipment and storage medium |
| CN111402067A (en) * | 2020-02-22 | 2020-07-10 | 中国平安财产保险股份有限公司 | Method for tracking list to be renewed, server and computer readable storage medium |
| CN111402067B (en) * | 2020-02-22 | 2023-08-29 | 中国平安财产保险股份有限公司 | Method for tracking follow-up list, server and computer readable storage medium |
| CN112364004A (en) * | 2020-11-10 | 2021-02-12 | 中国平安人寿保险股份有限公司 | Policy data processing method and device based on data warehouse and storage medium |
| CN112364004B (en) * | 2020-11-10 | 2023-09-26 | 中国平安人寿保险股份有限公司 | Data warehouse-based policy data processing method, device and storage medium |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN109033123B (en) | Big data-based query method and device, computer equipment and storage medium | |
| CN107644382A (en) | Policy information statistical method and device | |
| CN106980636B (en) | Policy data processing method and device | |
| US20170169253A1 (en) | Privacy-aware query management system | |
| US8239369B2 (en) | Method and apparatus for enhancing performance of database and environment thereof | |
| US10083208B2 (en) | Query modification in a database management system | |
| US20080065588A1 (en) | Selectively Logging Query Data Based On Cost | |
| US20050060285A1 (en) | Query optimization via a partitioned environment | |
| US20210287298A1 (en) | Actuarial processing method and device | |
| US9235608B2 (en) | Database performance analysis | |
| CN111881011A (en) | Log management method, platform, server and storage medium | |
| CN106293891B (en) | Multidimensional investment index monitoring method | |
| EP3039574A1 (en) | Queries involving multiple databases and execution engines | |
| US20170169111A1 (en) | Search query task management for search system tuning | |
| US20050055672A1 (en) | Time model | |
| Roschke et al. | A flexible and efficient alert correlation platform for distributed ids | |
| WO2019085307A1 (en) | Data sampling method, terminal, and device, and computer readable storage medium | |
| US20150067646A1 (en) | System and Method to Predict Elapsed Response Time for a Query during Application Development Stage | |
| CN108920523B (en) | Method, device, equipment, system and medium for querying data on block chain | |
| US10176231B2 (en) | Estimating most frequent values for a data set | |
| CN110637292A (en) | System and method for querying a resource cache | |
| CN113158233A (en) | Data preprocessing method and device and computer storage medium | |
| US11182386B2 (en) | Offloading statistics collection | |
| CN110362607A (en) | Abnormal number identification method, device, computer equipment and storage medium | |
| CN107644041A (en) | Declaration form settlement processing method and device |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20180130 |
|
| RJ01 | Rejection of invention patent application after publication |