CN101710320A - Statistical index data processing method and device - Google Patents
Statistical index data processing method and device Download PDFInfo
- Publication number
- CN101710320A CN101710320A CN200910110277A CN200910110277A CN101710320A CN 101710320 A CN101710320 A CN 101710320A CN 200910110277 A CN200910110277 A CN 200910110277A CN 200910110277 A CN200910110277 A CN 200910110277A CN 101710320 A CN101710320 A CN 101710320A
- Authority
- CN
- China
- Prior art keywords
- statistics
- unit
- statistical
- statistical indicator
- task
- 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
Images
Abstract
The invention relates to the field of data processing technology and discloses a statistical index data processing method and a device; the method comprises the following steps: statistical results are calculated in advance aiming at different organization units and statistical indexes and are stored; when a statistical statement is needed to be viewed, the corresponding data is extracted from the stored statistical results; the statistical statement is generated according to the extracted data; the generated statistical statement is shown. By adopting the invention, the showing speed of the statistical statement can be effectively improved.
Description
Technical field
The present invention relates to data processing technique, be specifically related to a kind of statistical index data processing method and device.
Background technology
In enterprise operation, add up various data through regular meeting, form statistical report form.According to the difference of objects of statistics, the information that described statistical report form comprised is also different, and many levels can be arranged.Such as the occurrences in human life statistical report form, can comprise a plurality of traffic table: office worker's information table, organization unit information table, tenure information table, employee hold a post history lists, registration information table, resignation information table, unusual action information table, retired information table, temporarily transfer information table, may also to comprise multiple information for each traffic table, such as comprising following information: the total number of persons of each organization unit, month separation rate, unusual fluctuation number, month number of trainees etc. for the organization unit information table.
In the prior art, when needs are checked specific statistical content, need to select corresponding organization unit, input statistical indicator item, statistics time and/or during etc., utilize the data set that storing process filters out to be needed from the database that stores Back ground Information, then the data set that obtains is showed on the interface.
In realizing process of the present invention, the inventor finds that there is following problem at least in prior art:
The data volume of the Back ground Information in database concurrency big or statistical operation is big or need the organization unit of statistics and statistical indicator more for a long time, performance bottleneck can appear, timing statistics is longer, makes that report form showing speed is slower, has influenced the availability of product.
Summary of the invention
The embodiment of the invention provides a kind of statistical index data processing method and device, to improve the speed that represents of statistical report form.
The embodiment of the invention provides following technical scheme:
A kind of statistical index data processing method comprises:
When needs are checked statistical report form, from the data that generate in advance at extraction correspondence the statistics of different tissues unit and statistical indicator;
Generate statistical report form according to the data of extracting;
The statistical report form that represents generation.
Preferably, described method also comprises:
Utilize the statistics of storing process generation in advance at different tissues unit and statistical indicator.
Alternatively, the described statistics of utilizing storing process to generate at different tissues unit and statistical indicator in advance comprises:
Set organization unit and statistical indicator;
The organization unit set and statistical indicator as input parameter, are called storing process and calculated, generate statistics at described organization unit and statistical indicator.
Alternatively, the described statistics of utilizing storing process to generate at different tissues unit and statistical indicator in advance comprises:
The background task table is set, and described background task table comprises the computing time of one or more statistics task and these statistics tasks at different tissues unit and statistical indicator;
Each statistics task in the described background task table of poll after arriving the computing time that detects this statistics task, calls storing process and calculates, and generates the statistics at this statistics task.
Alternatively, described statistics comprises: index sign, organization unit sign, statistics start time, statistics concluding time, computing time and result of calculation.
Alternatively, described statistical indicator comprises following any one or multinomial: total number of persons, month separation rate, unusual fluctuation number, month number of trainees.
A kind of statistical index data treating apparatus comprises:
Storage unit is used to preserve the statistics at different tissues unit and statistical indicator that generates in advance;
Query unit is used to obtain the user and checks the statistical report form request, and extracts corresponding data according to described request from the statistics of preserving;
The report generation unit, the data that are used for extracting according to described query unit generate statistical report form;
Represent the unit, be used to represent the statistical report form that described report generation unit generates.
Preferably, described device also comprises:
Computing unit is used to utilize storing process counting statistics result;
The statistics generation unit is used to call the statistics of described computing unit generation at different tissues unit and statistical indicator, and the statistics that generates is saved in the described storage unit.
Alternatively, described device also comprises:
The parameter setting unit is used to set organization unit and statistical indicator;
Described statistics generation unit specifically is used for the organization unit that will set and statistical indicator as input parameter, calls described computing unit and calculates, and generates the statistics at described organization unit and statistical indicator.
Alternatively, described device also comprises:
Task is provided with the unit, is used to be provided with the background task table, and described background task table comprises the computing time of one or more statistics task and these statistics tasks at different tissues unit and statistical indicator;
Described statistics generation unit specifically is used for each statistics task of the described background task table of poll, after arriving the computing time that detects this statistics task, calls described computing unit and calculates, and generates the statistics at this statistics task.
Statistical index data processing method that the embodiment of the invention provides and device calculate the statistics at different tissues unit and statistical indicator in advance, and preserve described statistics; When needs are checked statistical report form, from the statistics of preserving, extract corresponding data; Generate statistical report form according to the data of extracting; The statistical report form that represents generation, thus the displaying speed of form can be promoted greatly.
Description of drawings
Fig. 1 is the process flow diagram of embodiment of the invention statistical index data processing method;
Fig. 2 is a kind of structural representation of embodiment of the invention statistical index data treating apparatus;
Fig. 3 is a kind of concrete structure synoptic diagram of embodiment of the invention statistical index data treating apparatus;
Fig. 4 is the another kind of concrete structure synoptic diagram of embodiment of the invention statistical index data treating apparatus.
Embodiment
Embodiment of the invention statistical index data processing method, big or need the organization unit of statistics and statistical indicator more for a long time at the data volume of the Back ground Information in the database in prior art concurrency big or statistical operation, the performance bottleneck that timing statistics is long, the statistical computation process is shifted, by setting the backstage statistics task, carry out automatic statistical computation by the backstage in the time of setting, perhaps the leisure, manually go index is carried out statistical computation, result calculated is stored by the business personnel.Like this, when the user when needs are checked statistical report form, need not to calculate the generation statistical report form according to basic data in real time again, but directly generate and represent statistical report form, thereby can promote the displaying speed of form greatly according to the statistics that calculates in advance.
In order to make those skilled in the art person understand the scheme of the embodiment of the invention better, the embodiment of the invention is described in further detail below in conjunction with drawings and embodiments.
As shown in Figure 1, be the process flow diagram of embodiment of the invention statistical index data processing method, may further comprise the steps:
Step 101 is when needs are checked statistical report form, from the data at extraction correspondence the statistics of different tissues unit and statistical indicator that generate in advance.
In actual applications, some Back ground Informations at different administrative authoritys and system can be stored in the corresponding database, form information data at the different tissues unit, such as, at Human Resource Department, production management door, sales department etc.And different statistical indicators is set, such as for human resource management, statistical indicator commonly used can have with the next item down or multinomial: total number of persons, month separation rate, unusual fluctuation number, month number of trainees etc.
When the statistics that generates in advance at different tissues unit and statistical indicator, can utilize existing storing process to generate statistics at different tissues unit and statistical indicator.
Utilize existing storing process generation to be briefly described as follows at the process of the statistics of different tissues unit and statistical indicator:
Described storing process need be set three parameters: statistics start time, statistics concluding time, statistical indicator item ID;
Concrete computation process needs three variablees:
The code of variable 1:@TargetCode task according to transmitting the parametric statistics index item ID of coming in, finds out Code field assignment and gives the @TargetCode variable.
Variable 2:@strCode organization unit code
Variable 3:@Unit_ID organization unit ID
Be example with the statistics number of being employed at the end of month below, described computation process is carried out simple declaration, this computation process is as follows:
(1) the organization unit code value of Gen Ju @strCode variable and office worker hold a post " be employed the date " in the history lists<cut-off date two condition queries go out two fields, construct a temporary table #tempEmpInfoDetail.Certain organization unit of record and this organization unit subordinate's all companies, the corresponding office worker's number of department in this temporary table.
(2) from temporary table, deduct the number that those have been left office, whether be used as qualifications less than the concluding time of statistical indicator by judging leaving date.
(3) information with statistics is inserted in the statistical indicator statistics table, and the information of statistics comes from temporary table #tempEmpInfoDetail, counts the on-the-job number below certain organization unit.
Certainly, the embodiment of the invention is not limited in utilizes the statistics of storing process generation at different tissues unit and statistical indicator, can also adopt other modes, such as, can be calculative the time, in application program, utilize program code dynamically to splice SQL (the Structured Query Language) statement of inquiry, connect data base querying then, return Query Result.
The concrete generative process of described statistics will describe in detail in the back.
Step 102 generates statistical report form according to the data of extracting.
Step 103 represents the statistical report form of generation.
As seen, utilize embodiment of the invention statistical index data processing method, when the user when needs are checked statistical report form, need not to calculate the generation statistical report form according to basic data in real time again, but directly generate and represent statistical report form, thereby can promote the displaying speed of form greatly according to the statistics that calculates in advance.
In embodiments of the present invention, can generate statistics in several ways in advance, the explanation of knowing clearly for example respectively below at different tissues unit and statistical indicator.
(1) statistical indicator is set and calculates the interface
Can import organization unit and the statistical indicator that needs statistics by this interface, certainly, also can on this interface, list corresponding statistical indicator, when needed, directly choose the statistical indicator that needs and get final product.Then with the organization unit of input and statistical indicator as input parameter, call storing process and calculate, generate statistics at described organization unit and statistical indicator.Described statistics comprises: index sign, organization unit sign, statistics start time, statistics concluding time, computing time and result of calculation.
Said process can manually be finished in spare time by the business personnel.
(2) the background task table is set
Described background task table comprises the computing time of one or more statistics task and these statistics tasks at different tissues unit and statistical indicator.Particularly, can be at daily required various statistical report forms, generate corresponding statistics task, and set computing time at each statistics task (as some or every labourer hired by the month of every day which).Certainly,, different task items can be arranged according to the difference of applied environment, and, can set identical or different computing time to different task.Such as, can be arranged on every month the statistics of calculating last month the beginning of the month.
When system moved, the service by the backstage came each statistics task in the described background task table of poll, after arriving the computing time that detects this statistics task, called storing process and calculated, and generated the statistics at this statistics task.
Certainly, in the embodiment of the invention, when generating the statistics at different tissues unit and statistical indicator in advance, be not limited in above-mentioned this dual mode, other implementations can also be arranged, enumerate no longer one by one at this.
As seen, embodiment of the invention statistical index data processing method, shifted the opportunity that statistical report form consuming time calculates, the data source of inquiry form is changed, finish the statistical computation of form and represent two processes in the different time, thereby improved the speed that represents of form, promoted user's experience effect.
One of ordinary skill in the art will appreciate that all or part of step that realizes in the foregoing description method is to instruct relevant hardware to finish by program, described program can be stored in the computer read/write memory medium, described storage medium, as: ROM/RAM, magnetic disc, CD etc.
Correspondingly, the embodiment of the invention also provides a kind of statistical index data treating apparatus, as shown in Figure 2, is a kind of structural representation of this device.
In this embodiment, described device comprises:
Represent unit 204, be used to represent the statistical report form that described report generation unit generates.
In embodiments of the present invention, also can further comprise:
Certainly, in the embodiment of the invention, described statistics generation unit 206 is not limited in and utilizes the statistics of storing process generation at different tissues unit and statistical indicator, can also adopt other modes, as the description in the embodiment of the invention statistical index data processing method of front.
As seen, utilize embodiment of the invention statistical index data treating apparatus, when the user when needs are checked statistical report form, need not to calculate the generation statistical report form according to basic data in real time again, but directly generate and represent statistical report form, thereby can promote the displaying speed of form greatly according to the statistics that calculates in advance.
In embodiments of the present invention, can generate statistics in several ways in advance, the explanation of knowing clearly for example respectively below at different tissues unit and statistical indicator.
As shown in Figure 3, be a kind of concrete structure synoptic diagram of embodiment of the invention statistical index data treating apparatus.
Be with difference embodiment illustrated in fig. 2, in this embodiment, also comprise: parameter setting unit 301 is used to set organization unit and statistical indicator.
Described statistics generation unit 206, specifically be used for organization unit that described parameter setting unit 301 is set and statistical indicator as input parameter, call described computing unit 205 and calculate, generate statistics at described organization unit and statistical indicator.
In actual applications, described parameter setting unit 301 can be set to, statistical indicator is calculated the interface, the organization unit and the statistical indicator that need statistics by this interface input, certainly, also can on this interface, list corresponding statistical indicator, when needed, directly choose the statistical indicator that needs and get final product.Then with the organization unit of input and statistical indicator as input parameter, call storing process and calculate, generate statistics at described organization unit and statistical indicator.Described statistics comprises: index sign, organization unit sign, statistics start time, statistics concluding time, computing time and result of calculation.
As shown in Figure 4, be the another kind of concrete structure synoptic diagram of embodiment of the invention statistical index data treating apparatus.
Be with difference embodiment illustrated in fig. 2, in this embodiment, also comprise: task is provided with unit 401, is used to be provided with the background task table, and described background task table comprises the computing time of one or more statistics task and these statistics tasks at different tissues unit and statistical indicator.
Described statistics generation unit 206 specifically is used for each statistics task of the described background task table of poll, after arriving the computing time that detects this statistics task, calls described computing unit 205 and calculates, and generates the statistics at this statistics task.
In actual applications, described statistics generation unit 206 can be realized by software, such as the poll of realizing by the service processes of Windows described background task table.
Certainly, embodiment of the invention embodiment statistical index data treating apparatus is not limited in these structures, and other malformations can also be arranged, and enumerates no longer one by one at this.
As seen, embodiment of the invention statistical index data treating apparatus, shifted the opportunity that statistical report form consuming time calculates, the data source of inquiry form is changed, finish the statistical computation of form and represent two processes in the different time, thereby improved the speed that represents of form, promoted user's experience effect.
More than the embodiment of the invention is described in detail, used embodiment herein the present invention set forth, the explanation of above embodiment just is used for help understanding method and apparatus of the present invention; Simultaneously, for one of ordinary skill in the art, according to thought of the present invention, the part that all can change in specific embodiments and applications, in sum, this description should not be construed as limitation of the present invention.
Claims (10)
1. a statistical index data processing method is characterized in that, comprising:
When needs are checked statistical report form, from the data that generate in advance at extraction correspondence the statistics of different tissues unit and statistical indicator;
Generate statistical report form according to the data of extracting;
The statistical report form that represents generation.
2. method according to claim 1 is characterized in that, described method also comprises:
Utilize the statistics of storing process generation in advance at different tissues unit and statistical indicator.
3. method according to claim 2 is characterized in that, the described statistics of utilizing storing process to generate at different tissues unit and statistical indicator in advance comprises:
Set organization unit and statistical indicator;
The organization unit set and statistical indicator as input parameter, are called storing process and calculated, generate statistics at described organization unit and statistical indicator.
4. method according to claim 2 is characterized in that, the described statistics of utilizing storing process to generate at different tissues unit and statistical indicator in advance comprises:
The background task table is set, and described background task table comprises the computing time of one or more statistics task and these statistics tasks at different tissues unit and statistical indicator;
Each statistics task in the described background task table of poll after arriving the computing time that detects this statistics task, calls storing process and calculates, and generates the statistics at this statistics task.
5. according to each described method of claim 1 to 4, it is characterized in that described statistics comprises: index sign, organization unit sign, statistics start time, statistics concluding time, computing time and result of calculation.
6. according to each described method of claim 1 to 4, it is characterized in that described statistical indicator comprises following any one or multinomial:
Total number of persons, month separation rate, unusual fluctuation number, month number of trainees.
7. a statistical index data treating apparatus is characterized in that, comprising:
Storage unit is used to preserve the statistics at different tissues unit and statistical indicator that generates in advance;
Query unit is used to obtain the user and checks the statistical report form request, and extracts corresponding data according to described request from the statistics of preserving;
The report generation unit, the data that are used for extracting according to described query unit generate statistical report form;
Represent the unit, be used to represent the statistical report form that described report generation unit generates.
8. device according to claim 7 is characterized in that, described device also comprises:
Computing unit is used to utilize storing process counting statistics result;
The statistics generation unit is used to call the statistics of described computing unit generation at different tissues unit and statistical indicator, and the statistics that generates is saved in the described storage unit.
9. device according to claim 8 is characterized in that, described device also comprises:
The parameter setting unit is used to set organization unit and statistical indicator;
Described statistics generation unit specifically is used for the organization unit that will set and statistical indicator as input parameter, calls described computing unit and calculates, and generates the statistics at described organization unit and statistical indicator.
10. device according to claim 8 is characterized in that, described device also comprises:
Task is provided with the unit, is used to be provided with the background task table, and described background task table comprises the computing time of one or more statistics task and these statistics tasks at different tissues unit and statistical indicator;
Described statistics generation unit specifically is used for each statistics task of the described background task table of poll, after arriving the computing time that detects this statistics task, calls described computing unit and calculates, and generates the statistics at this statistics task.
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN200910110277A CN101710320A (en) | 2009-10-28 | 2009-10-28 | Statistical index data processing method and device |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN200910110277A CN101710320A (en) | 2009-10-28 | 2009-10-28 | Statistical index data processing method and device |
Publications (1)
Publication Number | Publication Date |
---|---|
CN101710320A true CN101710320A (en) | 2010-05-19 |
Family
ID=42403112
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN200910110277A Pending CN101710320A (en) | 2009-10-28 | 2009-10-28 | Statistical index data processing method and device |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN101710320A (en) |
Cited By (10)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN102855300A (en) * | 2012-08-16 | 2013-01-02 | 华为技术有限公司 | Method and device for quick viewing of report |
CN103679320A (en) * | 2012-09-26 | 2014-03-26 | 金蝶软件(中国)有限公司 | Report counting method and report counting device based on multiple latitudes |
CN103714409A (en) * | 2012-09-29 | 2014-04-09 | 金蝶软件(中国)有限公司 | Information processing method and device for multi-business organization |
CN104915378A (en) * | 2015-05-08 | 2015-09-16 | 珠海世纪鼎利通信科技股份有限公司 | Rapid statistics task generation system and method suitable for big data |
CN107562797A (en) * | 2017-08-02 | 2018-01-09 | 贵州工程应用技术学院 | A kind of universal intelligent design method based on data target statistics |
WO2018233308A1 (en) * | 2017-06-21 | 2018-12-27 | 平安科技(深圳)有限公司 | Statistical index processing method and apparatus, terminal device and readable storage medium |
CN109241140A (en) * | 2018-09-03 | 2019-01-18 | 北京旷视科技有限公司 | Data statistical approach, device and electronic equipment |
CN110046440A (en) * | 2019-04-22 | 2019-07-23 | 国电联合动力技术有限公司 | Flow field simulation calculation method and device based on CFD database |
CN110083624A (en) * | 2019-03-18 | 2019-08-02 | 北京奇艺世纪科技有限公司 | Stream data processing method, equipment, data processing equipment, computer media |
CN111121683A (en) * | 2019-12-05 | 2020-05-08 | 山西裕鼎精密科技有限公司 | Data processing apparatus, method and computer storage medium |
-
2009
- 2009-10-28 CN CN200910110277A patent/CN101710320A/en active Pending
Cited By (12)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN102855300A (en) * | 2012-08-16 | 2013-01-02 | 华为技术有限公司 | Method and device for quick viewing of report |
CN103679320A (en) * | 2012-09-26 | 2014-03-26 | 金蝶软件(中国)有限公司 | Report counting method and report counting device based on multiple latitudes |
CN103714409A (en) * | 2012-09-29 | 2014-04-09 | 金蝶软件(中国)有限公司 | Information processing method and device for multi-business organization |
CN104915378A (en) * | 2015-05-08 | 2015-09-16 | 珠海世纪鼎利通信科技股份有限公司 | Rapid statistics task generation system and method suitable for big data |
CN104915378B (en) * | 2015-05-08 | 2018-11-13 | 珠海世纪鼎利科技股份有限公司 | A kind of statistics task quick-speed generation system and method suitable for big data |
WO2018233308A1 (en) * | 2017-06-21 | 2018-12-27 | 平安科技(深圳)有限公司 | Statistical index processing method and apparatus, terminal device and readable storage medium |
CN107562797A (en) * | 2017-08-02 | 2018-01-09 | 贵州工程应用技术学院 | A kind of universal intelligent design method based on data target statistics |
CN109241140A (en) * | 2018-09-03 | 2019-01-18 | 北京旷视科技有限公司 | Data statistical approach, device and electronic equipment |
CN110083624A (en) * | 2019-03-18 | 2019-08-02 | 北京奇艺世纪科技有限公司 | Stream data processing method, equipment, data processing equipment, computer media |
CN110083624B (en) * | 2019-03-18 | 2021-11-12 | 北京奇艺世纪科技有限公司 | Stream data processing method, stream data processing apparatus, and computer medium |
CN110046440A (en) * | 2019-04-22 | 2019-07-23 | 国电联合动力技术有限公司 | Flow field simulation calculation method and device based on CFD database |
CN111121683A (en) * | 2019-12-05 | 2020-05-08 | 山西裕鼎精密科技有限公司 | Data processing apparatus, method and computer storage medium |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
CN101710320A (en) | Statistical index data processing method and device | |
CN109508344B (en) | Service data query method and device, electronic equipment and storage medium | |
Whitt | Predicting queueing delays | |
CN110750650A (en) | Construction method and device of enterprise knowledge graph | |
CN102214187A (en) | Complex event processing method and device | |
CN106933836B (en) | Data storage method and system based on sub-tables | |
JP5600185B2 (en) | Method for accessing a large collection object table in a database | |
CN101997894A (en) | Information pushing method, system and network system thereof | |
CN108269107B (en) | User information processing method and device | |
CN102467525A (en) | Document associating method and system | |
CN111178952A (en) | System, method and medium for sales lead follow-up and processing for the automotive industry | |
CN101452556A (en) | Customer information processing system and method | |
CN109063066A (en) | Data query method and device, data management system | |
CN111539852A (en) | Patent transaction system based on SaaS mode | |
CN111752944A (en) | Data allocation method and device, computer equipment and storage medium | |
CN102347851B (en) | Event processing method and server thereof | |
CN102081644A (en) | Data storage method for storing data and data meanings separately | |
CN108537577B (en) | Data validity query method and device, storage medium and server | |
CN114022188A (en) | Target crowd circling method, device, equipment and storage medium | |
CN109359132A (en) | A kind of method of data processing, device and system | |
CN114155037A (en) | Work result visualization method and system | |
CN114490137A (en) | Service data real-time statistical method and device, electronic equipment and readable storage medium | |
CN114153860A (en) | Business data management method and device, electronic equipment and storage medium | |
CN114722789A (en) | Data report integration method and device, electronic equipment and storage medium | |
CN112052282A (en) | Automatic modeling method and device, electronic equipment and readable storage medium |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
C06 | Publication | ||
PB01 | Publication | ||
C10 | Entry into substantive examination | ||
SE01 | Entry into force of request for substantive examination | ||
C12 | Rejection of a patent application after its publication | ||
RJ01 | Rejection of invention patent application after publication |
Application publication date: 20100519 |