CN110096683A - Report form generation method, system, computer installation and computer readable storage medium - Google Patents
Report form generation method, system, computer installation and computer readable storage medium Download PDFInfo
- Publication number
- CN110096683A CN110096683A CN201910199218.7A CN201910199218A CN110096683A CN 110096683 A CN110096683 A CN 110096683A CN 201910199218 A CN201910199218 A CN 201910199218A CN 110096683 A CN110096683 A CN 110096683A
- Authority
- CN
- China
- Prior art keywords
- report
- data
- template
- target
- generation
- 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
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/25—Integrating or interfacing systems involving database management systems
- G06F16/254—Extract, transform and load [ETL] procedures, e.g. ETL data flows in data warehouses
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/166—Editing, e.g. inserting or deleting
- G06F40/177—Editing, e.g. inserting or deleting of tables; using ruled lines
- G06F40/18—Editing, e.g. inserting or deleting of tables; using ruled lines of spreadsheets
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q40/00—Finance; Insurance; Tax strategies; Processing of corporate or income taxes
- G06Q40/08—Insurance
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- Business, Economics & Management (AREA)
- Finance (AREA)
- Databases & Information Systems (AREA)
- General Engineering & Computer Science (AREA)
- Accounting & Taxation (AREA)
- Development Economics (AREA)
- Data Mining & Analysis (AREA)
- Economics (AREA)
- Marketing (AREA)
- Strategic Management (AREA)
- Technology Law (AREA)
- General Business, Economics & Management (AREA)
- Health & Medical Sciences (AREA)
- Artificial Intelligence (AREA)
- Audiology, Speech & Language Pathology (AREA)
- Computational Linguistics (AREA)
- General Health & Medical Sciences (AREA)
- Financial Or Insurance-Related Operations Such As Payment And Settlement (AREA)
Abstract
The present invention provides a kind of report form generation method, system, computer installation and computer readable storage medium.The report form generation method includes: to be extracted, screened and conversion processing to default insurance kind data, and will treated that data are stored into presetting database；Report generation instruction is received, and extracts the template identification in the report generation instruction；The time attribute of each report generation request is obtained, and is configured to generate the system resource of target report according to the time attribute；Each report generation request is successively responded according to the export deadline of each target report sequence；Report data is extracted from the presetting database according to the template identification that the report generation request currently responded and the request are included, and is filled into report template corresponding with institute's template identification.It realizes the present invention is based on data display technique and is made rational planning for system resource allocation according to the export timeliness of each report, system resource heavy-duty service situation can be reduced.
Description
Technical field
The present invention relates to technical field of data processing more particularly to a kind of report form generation method, system, computer installation and
Computer readable storage medium.
Background technique
With the increasingly developed maturation of network technology, the quantity of the application system of various network services is increasing, and insurance is answered
It is also developed rapidly with system.Existing insurance system application is usually that multiple insurance kinds are all disposed in one big cluster,
Entire big cluster running will likely be influenced when wherein an insurance system is abnormal.Insurance system is in operation process simultaneously
In can generate a large amount of data, how to be the cumbersome thing of a complexity by convenient intuitively shown by report of these data
Feelings can largely occupy server resource during carrying out derived from report, have in multiple report export process when simultaneously, may
It can be because resource anxiety causes to run slack-off false alarm.
Summary of the invention
In view of above-mentioned, the present invention provides a kind of report form generation method, system, computer installation and computer-readable storage medium
Matter can be reduced in report export process because system resource anxiety causes to run slack-off false alarm.
One embodiment of the application provides a kind of report form generation method, which comprises
Default insurance kind data are extracted, are screened and conversion processing, and will treated that data are stored to preset data
In library；
Report generation instruction is received, and extracts the template identification in the report generation instruction, wherein the report generation
Instruction includes that multiple report generations are requested, and each report generation request packet contains a template identification；
The time attribute of each report generation request is obtained, and is configured to generate target according to the time attribute
The system resource of report, wherein the time attribute includes export deadline；
Each report generation request is successively responded according to the export deadline of each target report sequence；And
According to the report generation request currently responded and the currently report generation that responds request included template identification from
Report data is extracted in the presetting database, and the report data is filled to report mould corresponding with the template identification
In plate, to generate the target report.
Preferably, described pair of default insurance kind data are extracted, are screened and the step of conversion processing includes:
An ETL cluster is established, and default insurance kind data are extracted using the ETL cluster, are screened and conversion processing.
Preferably, described that default insurance kind data are extracted using the ETL cluster, are screened and the step of conversion processing
Include:
Default insurance kind data are extracted using the cluster ETL；
Screening operation is carried out to the obtained default insurance kind data of extraction, with filter out do not meet preset rules, it is imperfect and
Duplicate data；And
Default insurance kind data Jing Guo Screening Treatment are formatted.
Preferably, the report template has unique template identification.
Preferably, described that the report data is filled to the step packet into report template corresponding with the template identification
It includes:
Obtain the report data fill rule of the corresponding report template of the template identification；And
The report data is filled into the report template according to the report data fill rule.
Preferably, described to fill the report data into report template corresponding with the template identification, to generate
After the step of target report further include:
Monitor whether each target report abnormal case occurs in generating process；And
When there is abnormal case in generating process in the presence of one or more target reports, advised according to default alarm
Then output abnormality warning information.
Preferably, the default alarm regulation are as follows: different when occurring in generating process in the presence of one or more target reports
When reason shape, judge whether abnormal time of origin is in the period that can be alerted, if exporting different in the period that can be alerted
Normal warning information, recording exceptional situation but not output abnormality warning information if being not at the period that can be alerted.
One embodiment of the application provides a kind of report generating system, the system comprises:
Processing module, for being extracted, being screened to default insurance kind data and conversion processing, and will treated that data are deposited
Storage is into presetting database；
Receiving module for receiving report generation instruction, and extracts the template identification in the report generation instruction, wherein
The report generation instruction includes that multiple report generations are requested, and each report generation request packet contains a template identification；
Configuration module for obtaining the time attribute of each report generation request, and is matched according to the time attribute
The system resource for generating target report is set, wherein the time attribute includes export deadline；
Respond module, for successively responding each report according to the export deadline sequence of each target report
Table generates request；And
Generation module, for being included according to the report generation request currently responded and the report generation request currently responded
Template identification extract report data from the presetting database, and by the report data fill to the template identification
In corresponding report template, to generate the target report.
One embodiment of the application provides a kind of computer installation, and the computer installation includes processor and memory,
Several computer programs are stored on the memory, the processor is for when executing the computer program stored in memory
The step of realizing report form generation method as elucidated before.
One embodiment of the application provides a kind of computer readable storage medium, is stored thereon with computer program, described
The step of report form generation method as elucidated before is realized when computer program is executed by processor.
Above-mentioned report form generation method, system, computer installation and computer readable storage medium, by specified insurance kind data from
Insure and be stripped out in big cluster, realization and other serial insurance kinds are completely isolated, avoid the performance of other serial insurance kind systems different
The performance of the specified insurance kind is often influenced, and when needing to export multiple reports, is made rational planning for according to the export timeliness of each report
System resource allocation reduces system resource heavy-duty service situation, reduces the wrong report slack-off because of resource operation caused by nervous
It is alert, customized abnormality alarming rule, so that alarming processing is more humane.
Detailed description of the invention
It, below will be to required in embodiment description in order to illustrate more clearly of the technical solution of embodiment of the present invention
The attached drawing used is briefly described, it should be apparent that, the accompanying drawings in the following description is some embodiments of the present invention, for
For those of ordinary skill in the art, without creative efforts, it can also be obtained according to these attached drawings other
Attached drawing.
Fig. 1 is the step flow chart of report form generation method in one embodiment of the invention.
Fig. 2 is the step flow chart of report form generation method in another embodiment of the present invention.
Fig. 3 is the functional block diagram of report generating system in one embodiment of the invention.
Fig. 4 is computer schematic device in one embodiment of the invention.
Specific embodiment
To better understand the objects, features and advantages of the present invention, with reference to the accompanying drawing and specific real
Applying mode, the present invention will be described in detail.It should be noted that in the absence of conflict, presently filed embodiment and reality
The feature applied in mode can be combined with each other.
In the following description, numerous specific details are set forth in order to facilitate a full understanding of the present invention, described embodiment
Only some embodiments of the invention, rather than whole embodiments.Based on the embodiment in the present invention, this field
Those of ordinary skill's every other embodiment obtained without making creative work, belongs to guarantor of the present invention
The range of shield.
Unless otherwise defined, all technical and scientific terms used herein and belong to technical field of the invention
The normally understood meaning of technical staff is identical.Term as used herein in the specification of the present invention is intended merely to description tool
The purpose of the embodiment of body, it is not intended that in the limitation present invention.
Preferably, report form generation method of the invention is applied in one or more computer installation.The computer
Device is that one kind can be according to the instruction for being previously set or storing, the automatic equipment for carrying out numerical value calculating and/or information processing,
Hardware includes but is not limited to microprocessor, specific integrated circuit (Application Specific Integrated
Circuit, ASIC), programmable gate array (Field-Programmable Gate Array, FPGA), digital processing unit
(Digital Signal Processor, DSP), embedded device etc..
The computer installation can be the calculating such as desktop PC, laptop, tablet computer, server and set
It is standby.The computer installation can carry out people by modes such as keyboard, mouse, remote controler, touch tablet or voice-operated devices with user
Machine interaction.
Embodiment one:
Fig. 1 is the step flow chart of report form generation method preferred embodiment of the present invention.The process according to different requirements,
The sequence of step can change in figure, and certain steps can be omitted.
As shown in fig.1, the report form generation method specifically includes following steps.
Step S11, default insurance kind data extracted, are screened and conversion processing, and will treated data store to
In presetting database.
In one embodiment, can be by establishing an ETL (Extract Transform Load) cluster, and utilize institute
ETL cluster is stated to extract default insurance kind data, screen and conversion processing.The default insurance kind can be life insurance.At this
In the other embodiments of invention, the default insurance kind is also possible to other specified insurance kinds, such as property insurance, medical insurance etc..With
Under be illustrated so that default insurance kind is life insurance as an example.The ETL cluster and other insurance kind data decouplers, i.e., the described ETL cluster
For the dedicated ETL of the life insurance, so that life insurance is migrated out from the big cluster of insurance business realizes that resource is independent, it is real
Now with other insurance kind isolation of system, the abnormal performance of other insurance kind systems is avoided to influence the abnormal performance of life insurance.It is described default
Database can be ETL database.
In one embodiment, it can be provided by MIS-LIFE system (system may operate in a server)
Life insurance related service, the MIS-LIFE system are stored with the life insurance data of insurer.The ELT cluster includes that data are taken out
Modulus block, data cleansing module, data conversion module and ETL database.The data extraction module can pass through ETL cluster
Data-interface is communicated with the database of MIS-LIFE system, and then extracts the life insurance data of insurer.The life insurance
Dangerous data may include basic document information, payment information, insured information and the reimbursement historical information of insurer.The data are clear
Mold cleaning block receives the data that send of data extraction module, it is carried out screening and filtering fall not meeting it is preset rules, endless
Whole and duplicate data.The data conversion module is for formatting the processed data of data cleansing module
(can be converted preset one or more of data formats), and statistics calculating is carried out, and by the data after conversion and calculate knot
Fruit is stored in the ETL database.The algorithm of calculation and utilization that the statistics calculates can be according to subsequent report number
According to being set, such as derived report includes average age, the average insured amount of insured people, insured people of insured people
Male to female ratio, statistics calculating at this time is the average age for acquiring insured people, the average insured amount for acquiring insured people
And statistics obtains the male to female ratio of insured people.
Step S12, report generation instruction is received, and extracts the template identification in the report generation instruction, wherein described
Report generation instruction includes that multiple report generations are requested, and each report generation request packet contains a template identification.
In one embodiment, it can be instructed by a client to generating and send the report generation.The visitor
Family end can be mobile phone, tablet computer, PC apparatus such as computer, can be raw from the report when receiving report generation instruction
At extracting template identification in instruction.Such as user issues export A group in the life insurance sales data in July by client
Report generation instruction, report generation instruction can include template identification, and the template identification is for indicating which kind of format generated
Report, by extract report generation instruction in template identification can determine report template.Template identification uniquely indicates
The specific format of one report template, report template is determined that the content of configuration file can be modified by its configuration file, when weight
The report template can be modified after newly loading modified configuration file.The format of report template, which can be, specifically includes report
In need comprising which table entries, what the content of table entries is, what kind of etc. the Show Styles of those table entries be.Report
The format of template mainly includes both sides content, on the one hand refers to the structure of report, on the other hand refers to the business number for including in table
According to.
In one embodiment, the report generation instruction may include the generation request of one or more report, often
One report generation request includes a template identification, to determine the report for needing to generate which kind of pattern.
Step S13, obtains the time attribute of each report generation request, and is configured to according to the time attribute
The system resource of target report is generated, wherein the time attribute includes export deadline.
In one embodiment, for generating a target report, each report is raw for each report generation request
There is a time attribute at request, the time attribute can be used to characterize report export deadline, and each report is raw
It can have identical or different time attribute at request.For example, the report generation instruction is comprising there are three report lifes
It is the generation request of D10 report, the generation request of D14 report and the generation of D24 report request respectively at request.The D10 report
Table indicates that 10 points of the same day needs derived report before, and the D14 report indicates to need derived report, institute before 14 points of the same day
Stating D24 report indicates to need derived report before 24 points of the same day.Since the export of each report requires occupying system resources,
It carries out report data to arrange with export process, be preferentially arranged in order system resource according to report deadline.For example it can incite somebody to action
0 point to 10 points of system resource of period is tilted to the export of D10 report, and system resource is inclined again after D10 report generation is complete
The export for tiltedly giving D14 report, again tilts system resource to the export of D24 report after D14 report generation is complete.
In one embodiment, the system resource can refer to the system resource and ETL cluster of MIS-LIFE system
System resource.
Step S14, each report life is successively responded according to the export deadline of each target report sequence
At request.
In one embodiment, when needing to export multiple target reports, when can be ended according to derived from target report
Between sequentially successively respond each report generation request, and then system resource allocation of making rational planning for may be implemented, reduces system
System resource high load capacity situation is reduced because system resource anxiety causes system to run slack-off situation.
Step S15, included mould is requested according to the report generation request currently responded and the report generation currently responded
Panel sign extracts report data from the presetting database, and the report data is filled to corresponding with the template identification
Report template in, to generate the target report.
In one embodiment, each report template all has the report data fill rule of its own, the fill rule
For indicating how report data to be filled into report.For example, the content needs for name of insuring are filled into this structure of name of insuring
Under, insurer's gender need to be filled under this structure item of gender.Detailed process to report template filling data can be with
It is: extracts report data from ETL database, and the report data extracted is filled under corresponding structure item.
In one embodiment, the statistical result in each target report may further include time range (for example, nearest one
The life insurance in week is insured report, and nearest one month life insurance is insured report), inquiring report data from ETL database at this time needs
If the data within the range time.It for example, is that the 20th week 2018 life insurance is insured report derived from the needs, then
The report data grabbed from ETL database needs to be the 20th week 2018 life insurance data.
Please refer to Fig. 2, compared with report form generation method shown in fig. 1, Fig. 2 shows that the report form generation method at place further includes
Step S16 and step S17.
Step S16, monitor whether each target report abnormal case occurs in generating process.
Step S17, when there is abnormal case in generating process in the presence of one or more target reports, according to pre-
If alarm regulation output abnormality warning information.
In one embodiment, there is mistake and causes report raw during can referring to report generation in the abnormal case
At the situation of interruption.The default alarm regulation may is that when target report abnormal case occurs in generating process, judge
Whether in the period that can be alerted, the output abnormality warning information if in the period that can be alerted, if being not at can alert
Then output abnormality warning information, recording exceptional alarm situations are not consulted for subsequent period.For example, may be used
To set the exception for only alerting D10 report between 0 point~10 points of the same day, and D14 report and the alarm of D24 report may be set in and work as
It 9 points~24 points, and then may be implemented to reduce the number of operation personnel's morning progress abnormality processing.In other implementations of the invention
In mode, it also can be set and exported abnormality alarming without any report between 0 point~6 points of the same day.
In one embodiment, the modes output abnormality warning information such as mail, short message, APP push can be passed through.
Specified insurance kind data are stripped out from the big cluster of insurance, realize and other series by above-mentioned report form generation method
Insurance kind is completely isolated, avoids the abnormal performance of other serial insurance kind systems from influencing the performance of the specified insurance kind, and needing to export
It when multiple reports, is made rational planning for system resource allocation according to the export timeliness of each report, reduces system resource heavy-duty service
Situation runs slack-off false alarm, customized abnormality alarming rule, so that alarming processing is more caused by reducing because resource is nervous
Hommization.
Embodiment two:
Fig. 3 is the functional block diagram of report generating system preferred embodiment of the present invention.
As shown in fig.3, the report generating system 10 may include processing module 101, receiving module 102, configuration mould
Block 103, respond module 104, generation module 105, monitoring modular 106 and output module 107.
The processing module 101, and will treated for being extracted, being screened and conversion processing to default insurance kind data
Data are stored into presetting database.
In one embodiment, the processing module 101 can be by establishing an ETL (Extract Transform
Load) cluster, and using the ETL cluster default insurance kind data extracted, screened and conversion processing.The default insurance kind
It can be life insurance.In other embodiments of the invention, the default insurance kind is also possible to other specified insurance kinds, such as wealth
Produce danger, medical insurance etc..It is illustrated so that default insurance kind is life insurance as an example below.The ETL cluster and other insurance kind data solutions
Coupling, i.e., the described ETL cluster is the dedicated ETL of the life insurance, so that life insurance is migrated out from the big cluster of insurance business
Realize resource independence, realize with other insurance kind isolation of system, avoid the abnormal performance of other insurance kind systems from influencing life insurance
Abnormal performance.The presetting database can be ETL database.
In one embodiment, it can be provided by MIS-LIFE system (system may operate in a server)
Life insurance related service, the MIS-LIFE system are stored with the life insurance data of insurer.The ELT cluster includes that data are taken out
Modulus block, data cleansing module, data conversion module and ETL database.The data extraction module can pass through ETL cluster
Data-interface is communicated with the database of MIS-LIFE system, and then extracts the life insurance data of insurer.The life insurance
Dangerous data may include basic document information, payment information, insured information and the reimbursement historical information of insurer.The data are clear
Mold cleaning block receives the data that send of data extraction module, it is carried out screening and filtering fall not meeting it is preset rules, endless
Whole and duplicate data.The data conversion module is for formatting the processed data of data cleansing module
(can be converted preset one or more of data formats), and statistics calculating is carried out, and by the data after conversion and calculate knot
Fruit is stored in the ETL database.The algorithm of calculation and utilization that the statistics calculates can be according to subsequent report number
According to being set, such as derived report includes average age, the average insured amount of insured people, insured people of insured people
Male to female ratio, statistics calculating at this time is the average age for acquiring insured people, the average insured amount for acquiring insured people
And statistics obtains the male to female ratio of insured people.
The receiving module 102 extracts the template mark in the report generation instruction for receiving report generation instruction
Know, wherein report generation instruction includes that multiple report generations are requested, each report generation request packet contains a template
Mark.
In one embodiment, it can be instructed by a client to generating and send the report generation.The visitor
Family end can be mobile phone, tablet computer, PC apparatus such as computer, and when receiving report generation instruction, the receiving module 102 can
To extract template identification from report generation instruction.Such as user issues export A group in the people in July by client
The report generation of life insurance sales data instructs, and report generation instruction can include template identification, and the template identification is used for table
Show the report for generating which kind of format, can determine report template by extracting the template identification in report generation instruction.Template mark
Knowing uniquely indicates that a report template, the specific format of report template are determined by its configuration file, the content of configuration file
It can be modified, the report template can be modified after reloading modified configuration file.The format of report template can
To be to specifically include to be needed in report comprising which table entries, what the content of table entries is, the Show Styles of those table entries
It is what kind of etc..The format of report template mainly includes both sides content, on the one hand refers to the structure of report, on the other hand refers to
The business datum for including in table.
In one embodiment, the report generation instruction may include the generation request of one or more report, often
One report generation request includes a template identification, to determine the report for needing to generate which kind of pattern.
The configuration module 103 is used to obtain the time attribute of each report generation request, and according to the time
Attribute configuration is used to generate the system resource of target report, wherein the time attribute includes export deadline.
In one embodiment, for generating a target report, each report is raw for each report generation request
There is a time attribute at request, the time attribute can be used to characterize report export deadline, and each report is raw
It can have identical or different time attribute at request.For example, the report generation instruction is comprising there are three report lifes
It is the generation request of D10 report, the generation request of D14 report and the generation of D24 report request respectively at request.The D10 report
Table indicates that 10 points of the same day needs derived report before, and the D14 report indicates to need derived report, institute before 14 points of the same day
Stating D24 report indicates to need derived report before 24 points of the same day.Since the export of each report requires occupying system resources,
It carries out report data to arrange with export process, be preferentially arranged in order system resource according to report deadline.For example it can incite somebody to action
0 point to 10 points of system resource of period is tilted to the export of D10 report, and system resource is inclined again after D10 report generation is complete
The export for tiltedly giving D14 report, again tilts system resource to the export of D24 report after D14 report generation is complete.
In one embodiment, the system resource can refer to the system resource and ETL cluster of MIS-LIFE system
System resource.
The respond module 104 is used to successively be responded according to the export deadline sequence of each target report each
The report generation request.
In one embodiment, when needing to export multiple target reports, the respond module 104 can be according to target report
The sequence of deadline derived from table is requested successively to respond each report generation, and then system money of making rational planning for may be implemented
Source distribution, reduces system resource high load capacity situation, reduces because system resource anxiety causes system to run slack-off situation.
The generation module 105 is used for according to the report generation request currently responded and the report generation request currently responded
The template identification for being included extracts report data from the presetting database, and by the report data fill to the mould
In the corresponding report template of panel sign, to generate the target report.
In one embodiment, each report template all has the report data fill rule of its own, the fill rule
For indicating how report data to be filled into report.For example, the content needs for name of insuring are filled into this structure of name of insuring
Under, insurer's gender need to be filled under this structure item of gender.The generation module 105 fills data to report template
Detailed process may is that and extract report data from ETL database, and the report data extracted is filled into corresponding
Under structure item.
In one embodiment, the statistical result in each target report may further include time range (for example, nearest one
The life insurance in week is insured report, and nearest one month life insurance is insured report), inquiring report data from ETL database at this time needs
If the data within the range time.It for example, is that the 20th week 2018 life insurance is insured report derived from the needs, then
The report data grabbed from ETL database needs to be the 20th week 2018 life insurance data.
The monitoring modular 106 is for monitoring whether each target report abnormal case occurs in generating process.
The output module 107 is used to occur abnormal feelings in generating process in the presence of one or more target reports
When shape, according to default alarm regulation output abnormality warning information.
In one embodiment, there is mistake and causes report raw during can referring to report generation in the abnormal case
At the situation of interruption.The default alarm regulation may is that when the monitoring modular 106 monitors target report in generating process
In when there is abnormal case, the output module 107 judged whether in the period that can be alerted, if in the time that can be alerted
Section then output abnormality warning information, output abnormality warning information, recording exceptional are not accused if being not at the period that can be alerted
Alert shape is consulted for subsequent.For example, it can set and only alert the different of D10 report between 0 point~10 points of the same day
Often, it and 9 points~24 points on the day of D14 report and the alarm of D24 report may be set in, and then may be implemented to reduce operation personnel's morning
Carry out the number of abnormality processing.In other embodiments of the invention, also can be set the same day 0 point~6 points between without
Any report exports abnormality alarming.
In one embodiment, the output module 107 can pass through the modes output abnormalities such as mail, short message, APP push
Warning information.
Specified insurance kind data are stripped out from the big cluster of insurance, realize and other series by above-mentioned report generating system
Insurance kind is completely isolated, avoids the abnormal performance of other serial insurance kind systems from influencing the performance of the specified insurance kind, and needing to export
It when multiple reports, is made rational planning for system resource allocation according to the export timeliness of each report, reduces system resource heavy-duty service
Situation runs slack-off false alarm, customized abnormality alarming rule, so that alarming processing is more caused by reducing because resource is nervous
Hommization.
Fig. 4 is the schematic diagram of computer installation preferred embodiment of the present invention.
The computer installation 1 includes memory 20, processor 30 and is stored in the memory 20 and can be in institute
State the computer program 40 run on processor 30, such as report generator.The processor 30 executes the computer journey
The step in above-mentioned report form generation method embodiment, such as step S11~S15 shown in FIG. 1 are realized when sequence 40, it is shown in Fig. 2
Step S11~S17.Alternatively, the processor 30 realizes that above-mentioned report generating system is implemented when executing the computer program 40
The function of each module in example, such as the module 101~107 in Fig. 3.
Illustratively, the computer program 40 can be divided into one or more module/units, it is one or
Multiple module/units are stored in the memory 20, and are executed by the processor 30, to complete the present invention.Described one
A or multiple module/units can be the series of computation machine program instruction section that can complete specific function, and described instruction section is used
In implementation procedure of the description computer program 40 in the computer installation 1.For example, the computer program 40 can be with
Processing module 101, receiving module 102, configuration module 103, the respond module 104, generation module 105, prison being divided into Fig. 3
Survey module 106 and output module 107.Each module concrete function is referring to embodiment two.
The computer installation 1 can be the calculating such as desktop PC, notebook, palm PC and cloud server and set
It is standby.It will be understood by those skilled in the art that the schematic diagram is only the example of computer installation 1, do not constitute to computer
The restriction of device 1 may include perhaps combining certain components or different components, example than illustrating more or fewer components
Such as described computer installation 1 can also include input-output equipment, network access equipment, bus.
Alleged processor 30 can be central processing unit (Central Processing Unit, CPU), can also be
Other general processors, digital signal processor (Digital Signal Processor, DSP), specific integrated circuit
(Application Specific Integrated Circuit, ASIC), ready-made programmable gate array (Field-
Programmable Gate Array, FPGA) either other programmable logic device, discrete gate or transistor logic,
Discrete hardware components etc..General processor can be microprocessor or the processor 30 is also possible to any conventional processing
Device etc., the processor 30 are the control centres of the computer installation 1, utilize various interfaces and the entire computer of connection
The various pieces of device 1.
The memory 20 can be used for storing the computer program 40 and/or module/unit, and the processor 30 passes through
Operation executes the computer program and/or module/unit being stored in the memory 20, and calls and be stored in memory
Data in 20 realize the various functions of the computer installation 1.The memory 20 can mainly include storing program area and deposit
Store up data field, wherein storing program area can application program needed for storage program area, at least one function (for example sound is broadcast
Playing function, image player function etc.) etc.；Storage data area, which can be stored, uses created data (ratio according to computer installation 1
Such as audio data, phone directory) etc..In addition, memory 20 may include high-speed random access memory, it can also include non-easy
The property lost memory, such as hard disk, memory, plug-in type hard disk, intelligent memory card (Smart Media Card, SMC), secure digital
(Secure Digital, SD) card, flash card (Flash Card), at least one disk memory, flush memory device or other
Volatile solid-state part.
If the integrated module/unit of the computer installation 1 is realized in the form of SFU software functional unit and as independence
Product when selling or using, can store in a computer readable storage medium.Based on this understanding, of the invention
It realizes all or part of the process in above-described embodiment method, can also instruct relevant hardware come complete by computer program
At the computer program can be stored in a computer readable storage medium, and the computer program is held by processor
When row, it can be achieved that the step of above-mentioned each embodiment of the method.Wherein, the computer program includes computer program code, institute
Stating computer program code can be source code form, object identification code form, executable file or certain intermediate forms etc..It is described
Computer-readable medium may include: any entity or device, recording medium, U that can carry the computer program code
Disk, mobile hard disk, magnetic disk, CD, computer storage, read-only memory (ROM, Read-Only Memory), arbitrary access
Memory (RAM, Random Access Memory), electric carrier signal, telecommunication signal and software distribution medium etc..It needs
It is bright, the content that the computer-readable medium includes can according in jurisdiction make laws and patent practice requirement into
Row increase and decrease appropriate, such as do not include electric load according to legislation and patent practice, computer-readable medium in certain jurisdictions
Wave signal and telecommunication signal.
In several embodiments provided by the present invention, it should be understood that disclosed computer installation and method, it can be with
It realizes by another way.For example, computer installation embodiment described above is only schematical, for example, described
The division of unit, only a kind of logical function partition, there may be another division manner in actual implementation.
It, can also be in addition, each functional unit in each embodiment of the present invention can integrate in same treatment unit
It is that each unit physically exists alone, can also be integrated in same unit with two or more units.Above-mentioned integrated list
Member both can take the form of hardware realization, can also realize in the form of hardware adds software function module.
It is obvious to a person skilled in the art that invention is not limited to the details of the above exemplary embodiments, Er Qie
In the case where without departing substantially from spirit or essential attributes of the invention, the present invention can be realized in other specific forms.Therefore, no matter
From the point of view of which point, the present embodiments are to be considered as illustrative and not restrictive, and the scope of the present invention is by appended power
Benefit requires rather than above description limits, it is intended that all by what is fallen within the meaning and scope of the equivalent elements of the claims
Variation is included in the present invention.Any reference signs in the claims should not be construed as limiting the involved claims.This
Outside, it is clear that one word of " comprising " does not exclude other units or steps, and odd number is not excluded for plural number.It is stated in computer installation claim
Multiple units or computer installation can also be implemented through software or hardware by the same unit or computer installation.The
One, the second equal words are used to indicate names, and are not indicated any particular order.
Finally it should be noted that the above examples are only used to illustrate the technical scheme of the present invention and are not limiting, although reference
Preferred embodiment describes the invention in detail, those skilled in the art should understand that, it can be to of the invention
Technical solution is modified or equivalent replacement, without departing from the spirit and scope of the technical solution of the present invention.
Claims (10)
1. a kind of report form generation method, which is characterized in that the described method includes:
Default insurance kind data are extracted, are screened and conversion processing, and will treated that data are stored into presetting database；
Report generation instruction is received, and extracts the template identification in the report generation instruction, wherein the report generation instructs
It is requested including multiple report generations, each report generation request packet contains a template identification；
The time attribute of each report generation request is obtained, and is configured to generate target report according to the time attribute
System resource, wherein the time attribute include export deadline；
Each report generation request is successively responded according to the export deadline of each target report sequence；And
Request included template identification from described according to the report generation request currently responded and the currently report generation that responds
Report data is extracted in presetting database, and the report data is filled to report template corresponding with the template identification
In, to generate the target report.
2. report form generation method as described in claim 1, which is characterized in that described pair of default insurance kind data are extracted, sieved
Choosing and the step of conversion processing include:
An ETL cluster is established, and default insurance kind data are extracted using the ETL cluster, are screened and conversion processing.
3. report form generation method as claimed in claim 2, which is characterized in that described to utilize the ETL cluster to default insurance kind
Data are extracted, screen and the step of conversion processing includes:
Default insurance kind data are extracted using the cluster ETL；
Screening operation is carried out to the default insurance kind data that extraction obtains, does not meet preset rules, imperfect and repetition to filter out
Data；And
Default insurance kind data Jing Guo Screening Treatment are formatted.
4. report form generation method as claimed in any one of claims 1-3, which is characterized in that the report template has unique
Template identification.
5. report form generation method as claimed in any one of claims 1-3, which is characterized in that described to fill out the report data
The step being charged in report template corresponding with the template identification includes:
Obtain the report data fill rule of the corresponding report template of the template identification；And
The report data is filled into the report template according to the report data fill rule.
6. report form generation method as claimed in any one of claims 1-3, which is characterized in that described to fill out the report data
Be charged in report template corresponding with the template identification, the step of to generate the target report after further include:
Monitor whether each target report abnormal case occurs in generating process；And
It is defeated according to default alarm regulation when there is abnormal case in generating process in the presence of one or more target reports
Abnormality alarming information out.
7. report form generation method as claimed in claim 6, which is characterized in that the default alarm regulation are as follows: when there are one
Or multiple target reports judge whether abnormal time of origin is in the time that can be alerted when occurring abnormal case in generating process
Section, if in the period that can be alerted, output abnormality warning information, the recording exceptional feelings if being not at the period that can be alerted
Shape but not output abnormality warning information.
8. a kind of report generating system, which is characterized in that the system comprises:
Processing module, for being extracted, being screened to default insurance kind data and conversion processing, and will treated data store to
In presetting database；
Receiving module for receiving report generation instruction, and extracts the template identification in the report generation instruction, wherein described
Report generation instruction includes that multiple report generations are requested, and each report generation request packet contains a template identification；
Configuration module for obtaining the time attribute of each report generation request, and is configured according to the time attribute and is used
In the system resource for generating target report, wherein the time attribute includes export deadline；
It is raw successively to respond each report for the export deadline sequence according to each target report for respond module
At request；And
Generation module, for requesting included mould according to the report generation request currently responded and the report generation currently responded
Panel sign extracts report data from the presetting database, and the report data is filled to corresponding with the template identification
Report template in, to generate the target report.
9. a kind of computer installation, the computer installation includes processor and memory, is stored on the memory several
Computer program, which is characterized in that such as right is realized when the processor is for executing the computer program stored in memory
It is required that the step of report form generation method described in any one of 1-7.
10. a kind of computer readable storage medium, is stored thereon with computer program, which is characterized in that the computer program
The step of report form generation method as described in any one of claim 1-7 is realized when being executed by processor.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910199218.7A CN110096683A (en) | 2019-03-15 | 2019-03-15 | Report form generation method, system, computer installation and computer readable storage medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910199218.7A CN110096683A (en) | 2019-03-15 | 2019-03-15 | Report form generation method, system, computer installation and computer readable storage medium |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN110096683A true CN110096683A (en) | 2019-08-06 |
Family
ID=67443331
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201910199218.7A Pending CN110096683A (en) | 2019-03-15 | 2019-03-15 | Report form generation method, system, computer installation and computer readable storage medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN110096683A (en) |
Cited By (9)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110516217A (en) * | 2019-08-09 | 2019-11-29 | 济南浪潮数据技术有限公司 | Report automatic generation method and device |
| CN110728128A (en) * | 2019-08-30 | 2020-01-24 | 平安证券股份有限公司 | Data report generation method, device, medium and electronic equipment |
| CN111090974A (en) * | 2019-12-27 | 2020-05-01 | 中国银行股份有限公司 | Report generation method, device and equipment |
| CN111144083A (en) * | 2019-12-20 | 2020-05-12 | 腾讯科技（深圳）有限公司 | Report generation method, device, equipment and computer readable storage medium |
| CN111158650A (en) * | 2019-12-25 | 2020-05-15 | 中国建设银行股份有限公司 | Report template, report template and report generation method and device |
| CN111581066A (en) * | 2020-04-21 | 2020-08-25 | 北京龙云科技有限公司 | Real-time report statistical analysis method and device |
| CN113158633A (en) * | 2021-04-16 | 2021-07-23 | 浙江鸿程计算机系统有限公司 | Statistical report processing method and device |
| CN113626194A (en) * | 2021-08-10 | 2021-11-09 | 上海微盟企业发展有限公司 | Report file generation method, device, equipment and readable storage medium |
| CN117875285A (en) * | 2023-12-20 | 2024-04-12 | 河北先见软件科技股份有限公司 | Report generation method and device based on template, electronic equipment and storage medium |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101111839A (en) * | 2004-11-30 | 2008-01-23 | 科格洛斯公司 | Reporting model generation within a multidimensional enterprise software system |
| CN105426465A (en) * | 2015-11-13 | 2016-03-23 | 中国建设银行股份有限公司 | Method and device for online exporting statements |
| CN105446948A (en) * | 2015-11-13 | 2016-03-30 | 武汉鸿图节能技术有限公司 | Report automatic generation method and system |
| CN107885709A (en) * | 2017-09-29 | 2018-04-06 | 深圳市共济科技股份有限公司 | A kind of report form generation method, system and storage medium |
| CN109189865A (en) * | 2018-08-09 | 2019-01-11 | 广东电网有限责任公司 | The overall analysis system and method for project data |
-
2019
- 2019-03-15 CN CN201910199218.7A patent/CN110096683A/en active Pending
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101111839A (en) * | 2004-11-30 | 2008-01-23 | 科格洛斯公司 | Reporting model generation within a multidimensional enterprise software system |
| CN105426465A (en) * | 2015-11-13 | 2016-03-23 | 中国建设银行股份有限公司 | Method and device for online exporting statements |
| CN105446948A (en) * | 2015-11-13 | 2016-03-30 | 武汉鸿图节能技术有限公司 | Report automatic generation method and system |
| CN107885709A (en) * | 2017-09-29 | 2018-04-06 | 深圳市共济科技股份有限公司 | A kind of report form generation method, system and storage medium |
| CN109189865A (en) * | 2018-08-09 | 2019-01-11 | 广东电网有限责任公司 | The overall analysis system and method for project data |
Cited By (12)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110516217A (en) * | 2019-08-09 | 2019-11-29 | 济南浪潮数据技术有限公司 | Report automatic generation method and device |
| CN110728128A (en) * | 2019-08-30 | 2020-01-24 | 平安证券股份有限公司 | Data report generation method, device, medium and electronic equipment |
| CN111144083A (en) * | 2019-12-20 | 2020-05-12 | 腾讯科技（深圳）有限公司 | Report generation method, device, equipment and computer readable storage medium |
| CN111144083B (en) * | 2019-12-20 | 2023-11-03 | 腾讯科技（深圳）有限公司 | Report generation method, device, equipment and computer readable storage medium |
| CN111158650A (en) * | 2019-12-25 | 2020-05-15 | 中国建设银行股份有限公司 | Report template, report template and report generation method and device |
| CN111090974A (en) * | 2019-12-27 | 2020-05-01 | 中国银行股份有限公司 | Report generation method, device and equipment |
| CN111090974B (en) * | 2019-12-27 | 2023-10-24 | 中国银行股份有限公司 | Report generation method, device and equipment |
| CN111581066A (en) * | 2020-04-21 | 2020-08-25 | 北京龙云科技有限公司 | Real-time report statistical analysis method and device |
| CN113158633A (en) * | 2021-04-16 | 2021-07-23 | 浙江鸿程计算机系统有限公司 | Statistical report processing method and device |
| CN113626194A (en) * | 2021-08-10 | 2021-11-09 | 上海微盟企业发展有限公司 | Report file generation method, device, equipment and readable storage medium |
| CN117875285A (en) * | 2023-12-20 | 2024-04-12 | 河北先见软件科技股份有限公司 | Report generation method and device based on template, electronic equipment and storage medium |
| CN117875285B (en) * | 2023-12-20 | 2024-07-26 | 河北先见软件科技股份有限公司 | Report generation method and device based on template, electronic equipment and storage medium |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN110096683A (en) | Report form generation method, system, computer installation and computer readable storage medium | |
| CN105095056B (en) | A kind of method of data warehouse data monitoring | |
| CN113595761B (en) | Micro-service component optimization method and medium of power system information communication integrated scheduling platform | |
| CN110096408A (en) | Alarm-monitor method, apparatus, electronic equipment and computer readable storage medium | |
| CN113176978A (en) | Monitoring method, system and device based on log file and readable storage medium | |
| CN109828960A (en) | Log library expansion method, system, computer installation and readable storage medium storing program for executing | |
| CN110046070A (en) | Monitoring method, device, electronic equipment and the storage medium of server cluster system | |
| CN107993004A (en) | A kind of power information processing system and method | |
| CN110796341B (en) | Distributed batch processing method and device for collecting cases and electronic equipment | |
| CN108304293A (en) | A kind of software systems monitoring method based on big data technology | |
| CN101196901A (en) | Database query optimizer that takes network choice into consideration | |
| CN115796844A (en) | Dynamic updating method of alarm threshold, terminal equipment and system | |
| CN114676205A (en) | Event information processing method and device | |
| WO2024164730A1 (en) | Anomaly real-time reporting method and system for hybrid cloud management, device and medium | |
| WO2024082861A1 (en) | Cloud storage scheduling system applied to video monitoring | |
| CN111752541A (en) | Pay routing method based on Rete algorithm | |
| CN116795631A (en) | Service system monitoring alarm method, device, equipment and medium | |
| CN110069553A (en) | A kind of the data acquisition and processing method, equipment of public health emergency | |
| CN109144838A (en) | Method for monitoring application program and device, computer installation and computer storage medium | |
| CN107957942B (en) | SQL script fault repairing method and terminal thereof | |
| CN114490137A (en) | Service data real-time statistical method and device, electronic equipment and readable storage medium | |
| CN109766238B (en) | Session number-based operation and maintenance platform performance monitoring method and device and related equipment | |
| CN112966051A (en) | Distributed data exchange system and method | |
| CN110716726A (en) | Client updating method and device, electronic equipment and computer readable storage medium | |
| CN111935289A (en) | Dynamic monitoring method and device based on block chain |
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 |