CN103823670B - 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
- CN103823670B CN103823670B CN201310614756.0A CN201310614756A CN103823670B CN 103823670 B CN103823670 B CN 103823670B CN 201310614756 A CN201310614756 A CN 201310614756A CN 103823670 B CN103823670 B CN 103823670B
- Authority
- CN
- China
- Prior art keywords
- module
- time zone
- time
- data
- factory
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Active
Links
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.It is related to multitask
Coordinate operation technology, object reflection generation technique, clocked flip start-up technique, automatic running technology, remote configuration technology.
Background technology
With scientific and technical development, increasing enterprise adopts intellectualized management system to replace old manual record
Mode.Along with increasing of enterprise demand and business, a lot of enterprises are increasing in the demand of data, when per, daily produce
Data volume Japanese TV play increase；More there are much demands to real time data for the high-grade, precision and advanced enterprise increase, consequent historical data is more
It is magnanimity, because increasing data storage is in data base, the access to data of the data management system of enterprise-level application
Speed is day by day slow.Enterprise Data management system is observer, keeper and the analyst of an enterprise development, towards enterprise
Development enterprise required report data is provided：A certain product sales volume when form, daily sheet, moon sheet, year form, city
To a certain product consumption when form, daily sheet, moon sheet, year form, and various forms such as Employee development situation,
Policymaker's decision-making enterprise development direction for enterprise provides the track of enterprise development under foundation and reference, and real time record.But,
The data increasing with the running of system gets more and more, and the access of magnanimity DBMS causes system data to obtain slowly, various reports
Table data is difficult to stand the time observer is potential（The waiting time that normal person represents in data-oriented is 8 seconds）Inside open, be
The effectiveness of system will reduce, and policymaker can not the various data sheets that provide of friendly acquisition system support, may be in very little
Probable range enemy intrusion or invasion's making policy decision failure mistake, lead to enterprise to move towards the direction of unhealthy development, so that enterprise is suffered unnecessary
Economic asset loss.
Increase with application time to solve Enterprise Data management system, mass data causes data sheet reaction speed
Spend slow problem, at this stage increasing Enterprise Data management system all the method obtaining report data is carried out excellent
Changing, make acquisition speed as far as possible fast, reducing because obtaining the data method problem causing data access slow lack of standardization.But, that is,
Make access speed reach maximization, magnanimity DBMS is searched the problem of inevitable generation time delay, cause to look forward to simultaneously
It is slow that industry DBMS management system loads report data.
Content of the invention
A kind of multitask based on data base, configurable, programming count data method are in order to solve Enterprise Data management
System increases with application time, and mass data causes the slow problem of data sheet response speed, many based on data base
Business, configurable, programming count data method touch by using multi-task coordination operating techniques, object reflection generation technique, timing
Send out start-up technique, automatic running technology, remote configuration technology provide a kind of direct-connected reporting data table access method, substantivity is gone
Fall the time that association in multiple tables of data obtains data, simplified the time period obtaining report data, only remain data and pass
The defeated time, maximize and shorten data obtaining time.
By the present invention in that with multi-task coordination operating techniques, object reflection generation technique, clocked flip start-up technique, from
Dynamic running technology, remote configuration technology provide a kind of direct-connected reporting data table access method, and substantivity is removed in multiple data
In table, association obtains the time of data, has simplified the time period obtaining report data, has only remained data transmission period, maximizes
Shorten data obtaining time.Solving Enterprise Data management system increases with application time, and mass data causes data
The slow problem of form response speed.
The present invention is achieved by the following technical solution.
A kind of multitask based on data base, configurable, programming count data method, the invention is characterised in that, by counting
Result storage module, form configuration module, Time Triggered performing module and method factory module composition；Its attachment structure is：System
Meter result storage module be connected with Time Triggered performing module, Time Triggered performing module respectively with form configuration module and method
Factory module connects, and form configuration module is also connected with method factory module；
Wherein method factory module is by NONE time zone module, MINITE time zone module, HOUR time zone module, DAY
Time zone module, MONTH time zone module, YEAR time zone module, Combination of Methods performing module composition；Its attachment structure is：
Combination of Methods performing module respectively with NONE time zone module, MINITE time zone module, HOUR time zone module, DAY time
Area's module, MONTH time zone module, YEAR time zone module connect.
The present invention is configured using the data sheet that form configuration module is concerned about to enterprise.Form configuration module belongs to remote
Journey configuration module, the form that Anywhere can be carried out that may be coupled to target database in network configures.Form configuration letter
Breath is to be combined according to the method under each time zone in method factory module, and each method can calculate a data knot
Really, form needs how many information and needs that what information can carry out flexible configuration according to methodological function, each report
Table configuration information can independently form a report form statistics task.Form configuration module when receiving the report messages of configuration, meeting
Form configuration information is stored in specific report messages table, and sets up the particular data table of form needs in data base,
So that system directly accesses data.
Method factory module in the present invention comprises NONE time zone module, MINITE time zone module, HOUR time zone
Module, DAY time zone module, MONTH time zone module, the big time zone of YEAR time zone module six, each of which time zone
Respective time zone statistical method is included below, each method, can be by the statistical result side of being sent to time point as trigger point
Method combines performing module.When Combination of Methods performing module receives time point, ask association this time to form configuration module
All report form statistics tasks of point, report form statistics task is selected from the method base of corresponding time zone according to specific configuration information
Selection method executes, and waits all methods to be finished and returns the result to Time Triggered performing module.
The maincenter that the present invention is whole method with Time Triggered performing module, and the time is tracked with reference to whole second, whole
Point, whole when, all day, the whole month, the whole year carries out time Point matching, and time point is delivered to method factory module, by method factory
Combination of Methods performing module in module executes all report form statistics tasks being related to such time point automatically according to time point,
And Time Triggered performing module is passed back to according to the result that each statistics task returns, Time Triggered performing module will count knot
Fruit is sent to statistical result storage module, by statistical result storage module by corresponding for statistical result data Cun Chudao tables of data
In, complete once statistics action.
The invention has the beneficial effects as follows, there is provided a kind of direct-connected reporting data table access method, substantivity is removed multiple
In tables of data, association obtains the time of data, has simplified the time period obtaining report data, has only remained data transmission period,
Bigization shortens data obtaining time.
Present invention is expanded on further below in conjunction with the accompanying drawings.
Brief description
Fig. 1 is the structural representation of the inventive method.
Specific embodiment
See Fig. 1, a kind of multitask based on data base, configurable, programming count data method, the invention is characterised in that,
It is made up of statistical result storage module 1, form configuration module 2, Time Triggered performing module 3 and method factory module 4；It connects
Structure is：Statistical result storage module 1 is connected with Time Triggered performing module 3, and Time Triggered performing module 3 is joined with form respectively
Put module 2 and method factory module 4 connects, form configuration module 2 is also connected with method factory module 4；
Wherein method factory module is by NONE time zone module 41, MINITE time zone module 42, HOUR time zone module
43rd, DAY time zone module 44, MONTH time zone module 45, YEAR time zone module 46, Combination of Methods performing module 47 form；
Its attachment structure is：Combination of Methods performing module 47 respectively with NONE time zone module 41, MINITE time zone module 42, HOUR
Time zone module 43, DAY time zone module 44, MONTH time zone module 45, YEAR time zone module 46 connect.
The present invention is configured using the data sheet that form configuration module 2 is concerned about to enterprise.Form configuration module 2 belongs to
Remote configuration module, the form that Anywhere can be carried out that may be coupled to target database in network configures.Form configures
Information is to be combined according to the method under each time zone in method factory module 4, and each method can calculate a number
According to result, form needs how many information and needs that what information can carry out flexible configuration according to methodological function, each
Individual form configuration information can independently form a report form statistics task.Form configuration module 2 is receiving the report messages of configuration
When, form configuration information can be stored in specific report messages table, and set up the certain number of form needs in data base
According to table, so that system directly accesses data.
When method factory module 4 in the present invention comprises NONE time zone module 41, MINITE time zone module 42, HOUR
Between area's module 43, DAY time zone module 44, MONTH time zone module 45, the big time zone of YEAR time zone module 46 6, wherein
Each time zone is included below respective time zone statistical method, and each method, with time point as trigger point, can will count
Result is sent to Combination of Methods performing module.When Combination of Methods performing module 47 receives time point, to form configuration module 2
All report form statistics tasks of request association this time point, report form statistics task is according to specific configuration information from the corresponding time
In the method base in area, system of selection execution, waits all methods to be finished and returns the result to Time Triggered performing module 3.
The present invention is with Time Triggered performing module 3 for the maincenter of whole method, and the time is tracked with reference to whole second, whole
Point, whole when, all day, the whole month, the whole year carries out time Point matching, and time point is delivered to method factory module 4, by method factory
Combination of Methods performing module 47 in module 4 automatically executes all report form statistics being related to such time point according to time point and appoints
Business, and Time Triggered performing module 3 is passed back to according to the result that each statistics task returns, Time Triggered performing module 3 will
Statistical result is sent to statistical result storage module 1, will be corresponding for statistical result data Cun Chudao by statistical result storage module 1
In tables of data, complete once statistics action.
Claims (1)
1. a kind of multitask based on data base, configurable, programming count data method are it is characterised in that stored up by statistical result
Storing module (1), form configuration module (2), Time Triggered performing module (3) and method factory module (4) composition；Its attachment structure
For：Statistical result storage module (1) is connected with Time Triggered performing module (3), Time Triggered performing module (3) respectively with form
Configuration module (2) and method factory module (4) connect, and form configuration module (2) is also connected with method factory module (4)；
Wherein method factory module (4) comprises NONE time zone module (41), MINITE time zone module (42), HOUR time zone
Module (43), DAY time zone module (44), MONTH time zone module (45), the big time zone of YEAR time zone module (46) six and
Combination of Methods performing module (47), each of which time zone is included below respective time zone statistical method, each method
With time point as trigger point, statistical result can be sent to Combination of Methods performing module；When Combination of Methods performing module (47) connects
All report form statistics tasks of association this time point, report form statistics task during time of receipt (T of R) point, is asked to form configuration module (2)
According to specific configuration information, system of selection execution from the method base of corresponding time zone, waits all methods to be finished and will tie
Fruit returns to Time Triggered performing module (3)；Its attachment structure is：Combination of Methods performing module (47) respectively with NONE time zone
Module (41), MINITE time zone module (42), HOUR time zone module (43), DAY time zone module (44), MONTH time
Area's module (45), YEAR time zone module (46) connect.
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 CN103823670A (en) | 2014-05-28 |
| CN103823670B true 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) |
Families Citing this family (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 (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| 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 |
Family Cites Families (1)
| 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 |
-
2013
- 2013-11-28 CN CN201310614756.0A patent/CN103823670B/en active Active
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| 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 |
Also Published As
| Publication number | Publication date |
|---|---|
| CN103823670A (en) | 2014-05-28 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| Piprani et al. | Multi-dimensional supply chain flexibility and supply chain resilience: the role of supply chain risks exposure | |
| Oya | The Land Rush and Classic Agrarian Questions of Capital and Labour: a systematic scoping review of the socioeconomic impact of land grabs in Africa | |
| CN106372975B (en) | Invoice management system based on SOAP technology and ActiveX control technology | |
| WO2007064690A3 (en) | Systems, program product, and methods for organization realignment | |
| CN104680356A (en) | Middle and small-sized enterprise cooperative service platform of novel cloud architecture of novel technology | |
| Haddara et al. | ERP lifecycle: When to retire your ERP system? | |
| Khan et al. | Communication risks in GSD during RCM: Results from SLR | |
| CN104700177A (en) | Collaborative work platform | |
| CN103823670B (en) | Multi-task configurable automatic data statistics method based on database | |
| Rafiq et al. | Innovative trends in knowledge management: A cloud computing perspective | |
| Dikhanbayeva et al. | Analysis of textile manufacturing SMEs in Kazakhstan for industry 4.0 | |
| CN102254096A (en) | Electronic intelligent examination system | |
| Otieno | Enterprise Resource Planning (ERP) systems implementation challenges: A Kenyan case study | |
| Gabriele | Science and technology policies, industrial reform and technical progress in China | |
| Nwokoye et al. | Business Mentoring and Domestic Entrepreneurship in Nigeria's Manufacturing Sub-sector: The Place of Foreign Direct Investment Inflows | |
| McIntyre | Marxian Labor Process Theory Since Braverman 1 | |
| CN110276669A (en) | Have furniture made to order production tracing and system for tracing and managing based on Distributed Multi-tier Structure | |
| Ola-David et al. | Can FDI foster inclusive innovation and technology development in Africa | |
| Xiong et al. | The framework of information collection and data management for mass customization furniture | |
| Eltgen et al. | Malaysia: Attracting superstar firms in the electrical and electronics industry through investment promotion | |
| Tan et al. | A service-oriented virtual enterprise architecture and its applications in Chinese tobacco industrial sector | |
| Strelnik et al. | Relationship between financial indicators of a company and the ERP-system implementation costs | |
| Miletic et al. | Holistic marketing approach in innovation activity infrastructure institutions | |
| Kumar et al. | Total quality management in business process reengineering | |
| Jia et al. | Project Governance Framework for Mega Construction Projects (MCPs) in China: Lessons from SHITH and SHCBD projects |
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 |