CN101098495A - System and method for improving intelligent business on-line statistical task performance - Google Patents
System and method for improving intelligent business on-line statistical task performance Download PDFInfo
- Publication number
- CN101098495A CN101098495A CNA2007101084644A CN200710108464A CN101098495A CN 101098495 A CN101098495 A CN 101098495A CN A2007101084644 A CNA2007101084644 A CN A2007101084644A CN 200710108464 A CN200710108464 A CN 200710108464A CN 101098495 A CN101098495 A CN 101098495A
- Authority
- CN
- China
- Prior art keywords
- data
- statistics
- file
- statistical
- service database
- 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
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention discloses a system for improving the online statistic mission property of intelligent service, and a relative method, wherein the system comprises an intelligent service database, a data lead-out module connected a data processing module to lead out needed source data from the intelligent service database to a document, a data processing module connected with a data lead-in module for processing the leaded-out document to generate a statistic result document according to each statistic demand, and a data lead-in module connected with the intelligent service database for leading the statistic result document into a relative statistic list in the intelligent service database. The invention can confirm the accuracy of statistic result without additional hardware, improve statistic efficiency, improve system usability, improve system stability, and reduce the effect on call process.
Description
Technical field
The present invention relates to the intelligent business on-line statistical field, relate in particular to a kind of system and method that improves intelligent business on-line statistical task performance.
Background technology
Develop rapidly along with IN service, each operator is more and more higher to the requirement of IN service statistical function, in time and accurately statistics can assist operator to analyze each stage operation situation, determine next step market orientation and popularization plan, promptly to runing strategy adjustment, to obtain maximum value.
Present stage, each IN service management system is to guarantee the accuracy of statistics, all is online execution statistics task, generally is regularly to call storing process every day, generates statistics, is saved in the statistical form.In the storing process to call out relevant table and scan repeatedly, in the hope of obtaining the statistics of different visual angles, it is long that this class is added up generally all the time of implementation, takies a large amount of system resource, usually can influence the regular traffic call flow, causes problems such as call completing rate is low.How to utilize existing resource, the problem that improves statistic property just is placed in front of us.
Be briefly described below in conjunction with 1 pair of existing intelligent business on-line statistical processing procedure of accompanying drawing.
101: provide the data that need statistics by IN service statistical function demand file, the statistics that need provide wherein has been described, comprise the specific definition of each statistical items, information such as data format and unit.
102: the statistics of database storing process is a storing process of realizing statistics task, and system calls these storing process every day automatically and the table of needs statistics is scanned and sorts out, and statistics is saved in the statistical form to finish statistics.
103: the IN service database is the database of storage statistics data, for the IN service of supporting online statistics, also is the Service Database of stored calls class data simultaneously.
In a word, existing method is to realize statistics task by the storing process in the database, because the difference at statistics visual angle, to repeatedly scan the source table relevant with normal call, system configuration is required high, take a large amount of system resource, influence normal call flow, reduced the availability and the stability of system.
Summary of the invention
Technical problem to be solved by this invention is to be to provide a kind of not increase hardware facility, guarantees simultaneously under the situation of statistics accuracy, can reduce consumption and use to system resource, improves the system and method for intelligent business on-line statistical task performance.
In order to solve the problems of the technologies described above, the invention provides a kind of system that improves intelligent business on-line statistical task performance, its technical scheme is as follows:
A kind of system that improves intelligent business on-line statistical task performance provided by the invention comprises IN service database 204, it is characterized in that, comprises that also data derive module 201, data processing module 202 and data importing module 203, wherein:
Data derive module 201: link to each other with described data processing module 202, be used for the source data of statistics needs is exported to file from the IN service database;
Data processing module 202: link to each other with described data importing module 203, be used to handle the file of derivation,, generate statistical result file according to each statistical items requirement;
Data importing module 203: link to each other with described IN service database 204, be used for statistical result file is imported in the IN service database 204 corresponding statistical forms.
According to above-mentioned a kind of system that improves intelligent business on-line statistical task performance, described data processing module 202 is realized statistics task by the outer program/instrument of data base management system.
According to above-mentioned a kind of system that improves intelligent business on-line statistical task performance, described data processing module 202 is by the classification/merging to source data, and single pass just generates a plurality of statistics files, finishes multinomial statistics task.
According to above-mentioned a kind of system that improves intelligent business on-line statistical task performance, the statistical result file in the imported to IN service database of described data processing module 202 direct generation certain format, statistical result file comprises one or more files.
The present invention and then proposed a kind of method that improves intelligent business on-line statistical task performance is applied to the intelligent business on-line statistical processing procedure, it is characterized in that, comprises following steps:
(1) according to the requirement of each statistical items of IN service, required source data is exported in the file;
(2) data file that derives by analysis and arrangement is carried out statistic of classification to data, merges statistics, and statistics is saved in file according to the format classification that imports in the database, and the time of implementation and the implementation status of record statistics;
(3) each file that will generate by the derived data file of analysis and arrangement imports in the IN service database, finishes statistics task.
According to above-mentioned a kind of method that improves intelligent business on-line statistical task performance, described step (2) realizes statistics task by the outer program/instrument of data base management system.
According to above-mentioned a kind of method that improves intelligent business on-line statistical task performance, described step (2) is by the classification/merging to source data, and single pass just generates a plurality of statistics files, finishes multinomial statistics task.
According to above-mentioned a kind of method that improves intelligent business on-line statistical task performance, described step (2) directly generates the statistical result file in the imported to IN service database of certain format, and statistical result file comprises one or more files.
The method that the present invention mentioned is that statistics task is separated from Database Systems, the source data that statistics is needed exports to file, utilize other instruments to finish statistics, obtain statistics, at last the result is imported in the statistical form in the database,, avoided the table contention owing to only when derived data, operate the table relevant with calling, reduced influence widely, alleviated the pressure of Database Systems call flow.And just can obtain all statisticses to the file single pass, also greatly improved online statistical efficiency.
Compare with existing system and method, adopt system and method for the present invention, when not increasing hardware facility, improved statistical efficiency, when guaranteeing the statistics accuracy, reduced influence to call flow, improved the availability and the stability of system.
Description of drawings
Fig. 1 is existing method processing procedure schematic diagram;
Fig. 2 is a system configuration schematic diagram of the present invention;
Fig. 3 is the inventive method processing procedure schematic diagram.
Embodiment
The present invention is described in further detail below in conjunction with the drawings and specific embodiments.
In the application of reality, each IN service management system is to guarantee the accuracy of statistics, all is online execution statistics task, generally is regularly to call storing process every day, generates statistics, is saved in the statistical form.In the storing process to call out relevant table and scan repeatedly, in the hope of obtaining the statistics of different visual angles, it is long that this class is added up generally all the time of implementation, takies a large amount of system resource, usually can influence the regular traffic call flow, causes problems such as call completing rate is low.How utilizing existing resource, improve the problem of statistic property, is exactly technical problem to be solved by this invention.
Show the system configuration schematic diagram that the present invention improves intelligent business on-line statistical task performance as Fig. 2, this system comprises with lower module: data derive module 201, data processing module 202, data importing module 203 and IN service database 204, wherein:
Data derive module 201: link to each other with data processing module 202, the main responsible source data that needs of will adding up exports to file.
Further, data derive the requirement of module 201 according to each statistical items of IN service, can be by creating view or temporary table, and the source data that statistics is needed exports to file.
Data processing module 202: link to each other with data importing module 203, main being responsible for handled the file of deriving, and according to each statistical items requirement, generates statistical result file.
Further, data processing module 202 can be realized the sort merge of derived data file is sued for peace by shell program under the unix or c program, obtains final statistics, and statistics is saved in the different files according to the certain format classification.
Data importing module 203: link to each other with IN service database 204, main being responsible for imports to statistical result file in the IN service database 204 in the corresponding statistical form.
Instruments such as bcp that data importing module further, 203 can provide by data base management system or sqlldr realize that statistical result file imports.
Show the method processing procedure schematic diagram that the present invention improves intelligent business on-line statistical task performance as Fig. 3, the method includes the steps of:
301: the demand according to the statistical function of IN service derives the needed source data of statistics to file.
Further, according to the requirement of each statistical items of IN service, can be by creating view or temporary table, the source data that statistics is needed exports to file.File can be a plurality of, generally is table one file, and record of each row of data file separates with specific separator between each data element, is beneficial to the data processing of back.
302: according to the statistical function demand file of IN service and the source data file of step 301 generation, the sort merge summation obtains final statistics, and statistics is saved in the different files according to the certain format classification.
Further, demand according to business is carried out each data file that derives of analysis and arrangement by instruments such as shell program under the unix or c programs, data are carried out statistic of classification, merge statistics, statistics is saved in file according to the form that can import in the database, and the time of implementation and the implementation status of record statistics.
303: each file that step 302 is generated imports in the database, finishes statistics task.
Further, instruments such as bcp that provides by the IN service data base management system or sqlldr will be handled the statistical result file that generates by data processing module and import in the database, and statistics task is finished.
Claims (8)
1, a kind of system that improves intelligent business on-line statistical task performance comprises IN service database (204), it is characterized in that, comprises that also data derive module (201), data processing module (202) and data importing module (203), wherein:
Data derive module (201): link to each other with described data processing module (202), be used for the source data of statistics needs is exported to file from the IN service database;
Data processing module (202): link to each other with described data importing module (203), be used to handle the file of derivation,, generate statistical result file according to each statistical items requirement;
Data importing module (203): link to each other with described IN service database (204), be used for statistical result file is imported in the corresponding statistical form of IN service database (204).
2, system according to claim 1 is characterized in that, described data processing module (202) is realized statistics task by the outer program/instrument of data base management system.
3, system according to claim 1 is characterized in that, described data processing module (202) is by the classification/merging to source data, and single pass just generates a plurality of statistics files, finishes multinomial statistics task.
4, system according to claim 1 is characterized in that, described data processing module (202) directly generates the statistical result file in the imported to IN service database of certain format, and statistical result file comprises one or more files.
5, a kind of method that improves intelligent business on-line statistical task performance is applied to the intelligent business on-line statistical processing procedure, it is characterized in that, comprises following steps:
(1) according to the requirement of each statistical items of IN service, required source data is exported in the file;
(2) data file that derives by analysis and arrangement is carried out statistic of classification to data, merges statistics, and statistics is saved in file according to the format classification that imports in the database, and the time of implementation and the implementation status of record statistics;
(3) each file that will generate by the derived data file of analysis and arrangement imports in the IN service database, finishes statistics task.
As method as described in the claim 5, it is characterized in that 6, described step (2) realizes statistics task by the outer program/instrument of data base management system.
As method as described in the claim 5, it is characterized in that 7, described step (2) is by the classification/merging to source data, single pass just generates a plurality of statistics files, finishes multinomial statistics task.
As method as described in the claim 5, it is characterized in that 8, described step (2) directly generates the statistical result file in the imported to IN service database of certain format, statistical result file comprises one or more files.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CNA2007101084644A CN101098495A (en) | 2007-06-14 | 2007-06-14 | System and method for improving intelligent business on-line statistical task performance |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CNA2007101084644A CN101098495A (en) | 2007-06-14 | 2007-06-14 | System and method for improving intelligent business on-line statistical task performance |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN101098495A true CN101098495A (en) | 2008-01-02 |
Family
ID=39011950
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CNA2007101084644A Pending CN101098495A (en) | 2007-06-14 | 2007-06-14 | System and method for improving intelligent business on-line statistical task performance |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN101098495A (en) |
Cited By (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| WO2010130116A1 (en) * | 2009-05-15 | 2010-11-18 | 中兴通讯股份有限公司 | System and method for realizing the serial task |
| WO2011012010A1 (en) * | 2009-07-29 | 2011-02-03 | 中兴通讯股份有限公司 | Device and method for data statistics |
| CN102769532A (en) * | 2011-05-03 | 2012-11-07 | 中兴通讯股份有限公司 | Network management server and method for exporting query result to Excel file |
| CN103810256A (en) * | 2014-01-24 | 2014-05-21 | 武汉虹翼信息有限公司 | Method for distributing data rapidly in large data network optimization platform on basis of partition technology |
| CN109460439A (en) * | 2018-11-14 | 2019-03-12 | 泰康保险集团股份有限公司 | A kind of data processing method, device, medium and electronic equipment |
-
2007
- 2007-06-14 CN CNA2007101084644A patent/CN101098495A/en active Pending
Cited By (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| WO2010130116A1 (en) * | 2009-05-15 | 2010-11-18 | 中兴通讯股份有限公司 | System and method for realizing the serial task |
| WO2011012010A1 (en) * | 2009-07-29 | 2011-02-03 | 中兴通讯股份有限公司 | Device and method for data statistics |
| CN102769532A (en) * | 2011-05-03 | 2012-11-07 | 中兴通讯股份有限公司 | Network management server and method for exporting query result to Excel file |
| CN102769532B (en) * | 2011-05-03 | 2017-03-15 | 中兴通讯股份有限公司 | NM server and its method that Query Result is exported to Excel file |
| CN103810256A (en) * | 2014-01-24 | 2014-05-21 | 武汉虹翼信息有限公司 | Method for distributing data rapidly in large data network optimization platform on basis of partition technology |
| CN103810256B (en) * | 2014-01-24 | 2017-09-26 | 武汉虹翼信息有限公司 | Method based on partitioning technique quick distribution data in big data network optimization platform |
| CN109460439A (en) * | 2018-11-14 | 2019-03-12 | 泰康保险集团股份有限公司 | A kind of data processing method, device, medium and electronic equipment |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN102831052B (en) | Test exemple automation generating apparatus and method | |
| CN110413634B (en) | Data query method, system, device and computer readable storage medium | |
| CN103927338A (en) | Log information storage processing method and log information storage processing device | |
| CN102236672A (en) | Method and device for importing data | |
| US9374475B1 (en) | System for processing customer records | |
| CN101833738A (en) | Data processing method and system between domestic custodian bank and overseas custodian agent bank | |
| CN107220376B (en) | Data query method and device | |
| CN109213758B (en) | Data access method, device, equipment and computer readable storage medium | |
| CN101098495A (en) | System and method for improving intelligent business on-line statistical task performance | |
| CN106484624A (en) | The method of testing of interface automatic test | |
| CN102467525A (en) | Document associating method and system | |
| US20150227577A1 (en) | Method and device for guaranteeing consistency of planning data | |
| CN104536998A (en) | Data import method and device | |
| CN109446386B (en) | Data query method and device | |
| CN105933396B (en) | A kind of each canalization interface of collaboration realizes the method and system of long flow | |
| CN101645073A (en) | Method for guiding prior database file into embedded type database | |
| CN110569237A (en) | System and method for realizing real-time data cleaning processing | |
| CN114398365A (en) | Method for realizing intelligent financial statement EXCEL intelligent conversion financial industry credit customer statement system | |
| CN105589900A (en) | Data mining method based on multi-dimensional analysis | |
| CN112214473B (en) | Data migration method and system between databases | |
| CN1567829A (en) | General purpose data file conversion method | |
| CN105930323A (en) | File generating method and apparatus | |
| CN112162951A (en) | Information retrieval method, server and storage medium | |
| CN104216986B (en) | The device and method of pre-operation raising efficiency data query is carried out with the data update cycle | |
| CN103631951A (en) | Batch access function merging method and device based on metadata |
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: 20080102 |