CN103823670A - Multi-task configurable automatic data statistics method based on database - Google Patents
Multi-task configurable automatic data statistics method based on database Download PDFInfo
- Publication number
- CN103823670A CN103823670A CN201310614756.0A CN201310614756A CN103823670A CN 103823670 A CN103823670 A CN 103823670A CN 201310614756 A CN201310614756 A CN 201310614756A CN 103823670 A CN103823670 A CN 103823670A
- Authority
- CN
- China
- Prior art keywords
- module
- time
- data
- district
- statistics
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Granted
Links
Landscapes
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
Disclosed is a multi-task configurable automatic data statistics method based on a database. A statistical result storing module (1), a statement configuration module (2), a time trigger execution module (3) and a method factory module (4) are adopted. The statistical result storing module (1) is connected with the time trigger execution module (3) which is connected with the statement configuration module (2) and the method factory module (4), and the statement configuration module (2) is connected with the method factory module (4). The multi-task configurable automatic data statistics method has the advantages that a direct connection statement data accessing method is provided, time for relevantly acquiring data in multiple databases is directly omitted, a time period for acquiring the statement data is saved, only data transmission time is cost, and data acquiring time is shortened maximally.
Description
Technical field
The invention belongs to Enterprise Data computer management system mass data processing method technical field.Relate to multi-task coordination operating techniques, object reflection generation technique, clocked flip start-up technique, automatic running technology, remote configuration technology.
Background technology
Along with scientific and technical development, increasing enterprise adopts intellectualized management system to replace old manual record mode.Be accompanied by increasing of enterprise demand and business, a lot of enterprises are increasing in the demand of data, when per, every day the data volume Japanese TV play that produces increase; More there are a lot of high-grade, precision and advanced enterprises to increase the demand to real time data, consequent historical data magnanimity especially, because increasing data storing is in database, the data management system of enterprise-level application is day by day slow to the access speed of data.Enterprise Data management system is observer, keeper and the analyst of an enterprise development, enterprise-oriented development provides enterprise required report data: time form, daily sheet, month form, year form of a certain product sales volume, time form, daily sheet, month form, year form of market to a certain product consumption, and the various forms such as Employee development situation, for decision maker's decision-making enterprise development direction of enterprise provides foundation and reference, and the track of enterprise development under real time record.But, along with the data that the running of system increases are more and more, the access of magnanimity DBMS causes system data to obtain slowly, various report datas are difficult to stand the time in (stand-by period that normal person represents at data-oriented is 8 seconds) and open observer is potential, the effectiveness of system will reduce, decision maker can not friendly obtain the various data sheet supports that system provides, may be in the mistake of very little probable range enemy intrusion or invasion's making policy decision failure, cause enterprise to move towards the direction of unhealthy development, make enterprise suffer unnecessary economic asset loss.
In order to solve Enterprise Data management system along with Applicative time increases, mass data causes data sheet reaction velocity problem slowly, present stage, increasing Enterprise Data management system was all optimized the method for obtaining report data, make acquisition speed as far as possible the fastest, reduce because obtain the data method slow problem of data access that causes lack of standardization.But, even if access speed reaches maximization, in magnanimity DBMS, search the problem that inevitable generation time is incured loss through delay, cause Enterprise Data management system to load report data slow simultaneously.
Summary of the invention
A kind of multitask based on database, configurable, automatically statistics method is in order to solve Enterprise Data management system along with Applicative time increases, mass data causes data sheet reaction velocity problem slowly, based on the multitask of database, configurable, automatically statistics method is by being used multi-task coordination operating techniques, object reflection generation technique, clocked flip start-up technique, automatically running technology, remote configuration technology provides a kind of direct-connected report data table access method, substantivity is removed the associated time of obtaining data in multiple tables of data, simplify the time period of obtaining report data, only retain data transmission period, the data acquisition time has been shortened in maximization.
The present invention is by using multi-task coordination operating techniques, object reflection generation technique, clocked flip start-up technique, automatic running technology, remote configuration technology that a kind of direct-connected report data table access method is provided, substantivity is removed the associated time of obtaining data in multiple tables of data, simplify the time period of obtaining report data, only retain data transmission period, maximized and shortened the data acquisition time.Solved Enterprise Data management system along with Applicative time increases, mass data causes data sheet reaction velocity problem slowly.
The present invention is achieved by the following technical solution.
Multitask based on database, configurable, an automatic statistics method, the present invention is characterised in that, is made up of statistics storage module, form configuration module, time triggering execution module and method factory module; Its syndeton is: statistics storage module and time trigger execution module and is connected, and time triggering execution module is connected with form configuration module and method factory module respectively, and form configuration module is also connected with method factory module;
Wherein method factory module is made up of NONE time district module, MINITE time district module, HOUR time district module, DAY time district module, MONTH time district module, YEAR time district module, Combination of Methods execution module; Its syndeton is: Combination of Methods execution module is connected with NONE time district module, MINITE time district module, HOUR time district module, DAY time district module, MONTH time district module, YEAR time district module respectively.
The data sheet that the present invention uses form configuration module to be concerned about enterprise is configured.Form configuration module belongs to Remote configuration module, and what can be connected to target database at network can carry out form configuration Anywhere.Form configuration information is to combine according to the method for each in method factory module under district time, each method can calculate a data result, form needs how many information and needs what information to carry out flexible configuration according to methodological function, and each form configuration information can form separately a report form statistics task.Form configuration module, in the time receiving the report messages of configuration, can be stored in form configuration information in specific report messages table, and in database, sets up the particular data table that form needs, so that the direct visit data of system.
Method factory module in the present invention comprises NONE time district module, MINITE time district module, HOUR time district module, DAY time district module, MONTH time district module, six large time of YEAR time district module district, wherein below each district, comprise time district's statistical method separately time, each method, take time point as trigger point, can be sent to statistics Combination of Methods execution module.In the time that Combination of Methods execution module receives time point, to all report form statistics tasks of associated this time point of form configuration module request, report form statistics task according to concrete configuration information system of selection from the method base in district of corresponding time carry out, wait all methods to be finished result is turned back to the time and trigger execution module.
The maincenter of the present invention take time triggering execution module as whole method, and the time is followed the trail of in conjunction with whole second, whole point, when whole, all day, the whole month, carry out time point coupling the whole year, and time point is delivered to method factory module, automatically perform all report form statistics tasks that relate to this type of time point by the Combination of Methods execution module in method factory module according to time point, and the result of returning according to each statistics task passes back to time triggering execution module, time triggers execution module statistics is sent to statistics storage module, by statistics storage module, statistics data are stored in corresponding tables of data, complete once statistics action.
The invention has the beneficial effects as follows, a kind of direct-connected report data table access method is provided, and substantivity is removed the associated time of obtaining data in multiple tables of data, has simplified the time period of obtaining report data, only retain data transmission period, maximized and shortened the data acquisition time.
Further set forth content of the present invention below in conjunction with accompanying drawing.
Accompanying drawing explanation
Fig. 1 is the structural representation of the inventive method.
Embodiment
See Fig. 1, a kind of multitask, configurable, automatic statistics method based on database, the present invention is characterised in that, is made up of statistics storage module 1, form configuration module 2, time triggering execution module 3 and method factory module 4; Its syndeton is: statistics storage module 1 and time trigger execution module 3 and is connected, and the time triggers execution module 3 and is connected with form configuration module 2 and method factory module 4 respectively, and form configuration module 2 is also connected with method factory module 4;
Wherein method factory module is made up of NONE time district module 41, MINITE time district module 42, HOUR time district module 43, DAY time district module 44, MONTH time district module 45, YEAR time district module 46, Combination of Methods execution module 47; Its syndeton is: Combination of Methods execution module 47 is connected with NONE time district module 41, MINITE time district module 42, HOUR time district module 43, DAY time district module 44, MONTH time district module 45, YEAR time district module 46 respectively.
The data sheet that the present invention uses form configuration module 2 to be concerned about enterprise is configured.Form configuration module 2 belongs to Remote configuration module, and what can be connected to target database at network can carry out form configuration Anywhere.Form configuration information is to combine according to the method for each in method factory module 4 under district time, each method can calculate a data result, form needs how many information and needs what information to carry out flexible configuration according to methodological function, and each form configuration information can form separately a report form statistics task.Form configuration module 2, in the time receiving the report messages of configuration, can be stored in form configuration information in specific report messages table, and in database, sets up the particular data table that form needs, so that the direct visit data of system.
Method factory module 4 in the present invention comprises NONE time district module 41, MINITE time district module 42, HOUR time district module 43, DAY time district module 44, MONTH time district module 45,46 6 large time of YEAR time district module district, wherein below each district, comprise time district's statistical method separately time, each method, take time point as trigger point, can be sent to statistics Combination of Methods execution module.In the time that Combination of Methods execution module 47 receives time point, to all report form statistics tasks of associated this time point of form configuration module 2 request, report form statistics task according to concrete configuration information system of selection from the method base in district of corresponding time carry out, wait all methods to be finished result is turned back to the time and trigger execution module 3.
The maincenter of the present invention take time triggering execution module 3 as whole method, and the time is followed the trail of in conjunction with whole second, whole point, when whole, all day, the whole month, carry out time point coupling the whole year, and time point is delivered to method factory module 4, automatically perform all report form statistics tasks that relate to this type of time point by the Combination of Methods execution module 47 in method factory module 4 according to time point, and the result of returning according to each statistics task passes back to time triggering execution module 3, time triggers execution module 3 statistics is sent to statistics storage module 1, by statistics storage module 1, statistics data are stored in corresponding tables of data, complete once statistics action.
Claims (1)
1. the multitask based on database, configurable, an automatic statistics method, is characterized in that, is made up of statistics storage module (1), form configuration module (2), time triggering execution module (3) and method factory module (4); Its syndeton is: statistics storage module (1) triggers execution module (3) with the time and is connected, time triggers execution module (3) and is connected with form configuration module (2) and method factory module (4) respectively, and form configuration module (2) is also connected with method factory module (4);
Wherein method factory module (4) is made up of NONE time district module (41), MINITE time district module (42), HOUR time district module (43), DAY time district module (44), MONTH time district module (45), YEAR time district module (46), Combination of Methods execution module (47); Its syndeton is: Combination of Methods execution module (47) is connected with NONE time district module (41), MINITE time district module (42), HOUR time district module (43), DAY time district module (44), MONTH time district module (45), YEAR time district module (46) respectively.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201310614756.0A CN103823670B (en) | 2013-11-28 | 2013-11-28 | Multi-task configurable automatic data statistics method based on database |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201310614756.0A CN103823670B (en) | 2013-11-28 | 2013-11-28 | Multi-task configurable automatic data statistics method based on database |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN103823670A true CN103823670A (en) | 2014-05-28 |
| CN103823670B CN103823670B (en) | 2017-02-22 |
Family
ID=50758756
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201310614756.0A Active CN103823670B (en) | 2013-11-28 | 2013-11-28 | Multi-task configurable automatic data statistics method based on database |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN103823670B (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN107330628A (en) * | 2017-07-06 | 2017-11-07 | 云南电网有限责任公司 | A kind of construction method and device of auditing risk management information bank |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20040217987A1 (en) * | 2003-05-01 | 2004-11-04 | Solomo Aran | Method and system for intercepting and processing data during GUI session |
| CN101937334A (en) * | 2009-06-29 | 2011-01-05 | 北京庚顿数据科技有限公司 | Calculation support method and system |
| CN102262678A (en) * | 2011-08-16 | 2011-11-30 | 郑毅 | System for sampling mass data and managing sampled data |
| CN102346671A (en) * | 2011-09-29 | 2012-02-08 | 南京国电南自轨道交通工程有限公司 | Calculation method based on expansible script language |
| CN102739692A (en) * | 2011-03-31 | 2012-10-17 | 新奥特（北京）视频技术有限公司 | Method and apparatus for uploading reports used in sports event information system |
-
2013
- 2013-11-28 CN CN201310614756.0A patent/CN103823670B/en active Active
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20040217987A1 (en) * | 2003-05-01 | 2004-11-04 | Solomo Aran | Method and system for intercepting and processing data during GUI session |
| CN101937334A (en) * | 2009-06-29 | 2011-01-05 | 北京庚顿数据科技有限公司 | Calculation support method and system |
| CN102739692A (en) * | 2011-03-31 | 2012-10-17 | 新奥特（北京）视频技术有限公司 | Method and apparatus for uploading reports used in sports event information system |
| CN102262678A (en) * | 2011-08-16 | 2011-11-30 | 郑毅 | System for sampling mass data and managing sampled data |
| CN102346671A (en) * | 2011-09-29 | 2012-02-08 | 南京国电南自轨道交通工程有限公司 | Calculation method based on expansible script language |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN107330628A (en) * | 2017-07-06 | 2017-11-07 | 云南电网有限责任公司 | A kind of construction method and device of auditing risk management information bank |
Also Published As
| Publication number | Publication date |
|---|---|
| CN103823670B (en) | 2017-02-22 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN104036025A (en) | Distribution-base mass log collection system | |
| Gamlen | The new migration and development optimism: A review of the 2009 Human Development Report | |
| CN106126641A (en) | A kind of real-time recommendation system and method based on Spark | |
| CN106131203A (en) | A kind of automatic customer service system for electronic commerce | |
| CN102479223A (en) | Data query method and system | |
| CN104182846A (en) | Client management system | |
| CN103235811A (en) | Data storage method and device | |
| Cimino et al. | Sensor data management to achieve information superiority in maritime situational awareness | |
| Tiwari | Looking Back to Move Forward: The MDGS and the Road to Post‐2015: Introduction to Journal of International Development Special Issue on Reflections on the Post‐2015 Debate | |
| Fragkias et al. | The rise and rise of urban expansion | |
| CN103823670A (en) | Multi-task configurable automatic data statistics method based on database | |
| CN102447620A (en) | Real-time exchange management method, device and system for associated database | |
| CN112579567A (en) | MinIO-based industrial quality inspection file distributed storage system and method | |
| CN102194156A (en) | Method and system for sci-tech novelty retrieval | |
| CN104166878A (en) | Intelligent room control hotel booking system | |
| Gomes et al. | Long-term bat study on an island in the southeastern Brazilian coast with comparison of richness and composition of species among sites | |
| Kalantari et al. | An interoperability toolkit for e-Land administration | |
| Weber et al. | Transitions on the horizon: Perspectives for the European Union's future research and innovation policies | |
| CN112417074A (en) | WebGIS (Web geographic information System) -based information management system and implementation method | |
| Abdel-Fattah et al. | A strategic roadmap for maximizing big data return | |
| Yeung | End of a chapter?: Hong Kong manufacturers in the Pearl River Delta | |
| Ahmad et al. | Big Data Manipulation-A new concern to the ICT world (A massive Survey/statistics along with the necessity) | |
| Bonomi et al. | LESS THAN ZERO | |
| Yeung | End of a Chapter? | |
| Schrier | How Web 2.0 will transform local government |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| C14 | Grant of patent or utility model | ||
| GR01 | Patent grant |