CN101192976A - Automatic generation method for standard report of value-added service - Google Patents

Abstract

The invention relates to a method for automatically generating a value-added service standard statement, which uses a database stored in a value-added service analysis system. The method comprises the following steps: statement requirements are proposed and preset in the system according to industrial standards; the statement guidelines are corresponded to fields of a plurality of forms in the database; calculating the smallest time granularity related to the database record receiving scene requirements and generating the corresponding standard statement. The invention provides a standard statement automatic generation method based on the overall database and achieves unified supervision and management of value-added service.

Description

Automatic generation method for standard report of value-added service

Technical field

The present invention relates to communication network management, be specifically related to a kind of value-added service analysis and method thereof, more particularly, relate to a kind of automatic generation method for standard report of value-added service.

Background technology

Value-added service has at present become a main business and the important revenue source of each big operator of China, and the various value-added services that are based upon on the note basis emerge in an endless stream especially, and development is very swift and violent.SMS platform is built by province basically at present, the SMS platform of each province comprises: sms center, dream net/believing note treatment facilities such as gateway, Interworking gateway, SP turnkey console, CRBT, multimedia message, WAP, these note treatment facilities are provided by a plurality of manufacturers, basically be the management of branch producer and subsystem, and because the original value-added service ticket of each producer's equipment is widely different on format content, therefore can't directly gather further value-added service is carried out unified monitoring and generated form, and can only separately monitor and manage with regard to distinct device.

Go up on the other hand, operator needs the value-added service consolidated statement to help its Analysis of Policy Making of 1. carrying on the work, 2. be lifted at supervision, the managerial ability of value-added service aspect, be particularly conducive to attendant's discovery apace, fixer network and traffic failure point and fault face, the fast online business of quick-recovery, raising system running quality is for market management work provides strong background support.These consolidated statements generally can be divided into three types of standard forms, OLAP form and self-defined reports.Standard forms is meant the form that requirement must provide according to industry standard; The OLAP form is meant that the client is by the manual form that drills through cube (CUBE) generation; Self-defined report then is the form of client according to own characteristic requirement customization.

Summary of the invention

The technical issues that need to address of the present invention are at present value-added service platform network presence, and a kind of automatic generation method for standard report of value-added service is provided, and help centralized management and the monitoring of operator's realization to value-added service platform.

Above-mentioned first technical problem of the present invention solves like this, and a kind of automatic generation method for standard report of value-added service is provided, and uses the database that is stored in the value-added service analysis, may further comprise the steps:

1.1) user proposes the form demand according to industry standard and be preset in the system;

1.2) report form index is corresponded to corresponding field in a plurality of tables in the described database;

1.3) data-base recording that relates to is gathered calculating by the minimum time granularity of application scenarios needs, and generate the corresponding standard form.

According to generation method provided by the invention, described standard forms comprises daily sheet, finishes daily sheet by scheduler module by the scheduling of sky time scheduling strategy and generates task.

According to generation method provided by the invention, described standard forms comprises moon form or quarterly report table, by scheduler module monthly or season time scheduling strategy scheduling is finished month or quarterly account generates task.

According to generation method provided by the invention, this method also comprises described daily paper is imported in the corresponding day table of described database.

According to generation method provided by the invention, this method also comprises based on the Sino-Japan table record of described database, by scheduler module monthly or season time scheduling strategy scheduling is finished month or quarterly account.

According to generation method provided by the invention, this method comprises that also the user shows or the described standard forms of printout.

According to generation method provided by the invention, described form demand can increase, revises or cancel.

According to generation method provided by the invention, the initial data that is used to generate standard forms in the described database is obtained and be may further comprise the steps:

8.1) the original business datum of each note treatment facility in the collection network;

8.2) each described original business datum converted to the business datum of consolidation form;

8.3) be aggregated into database.

Automatic generation method for standard report of value-added service provided by the invention, use the data pre-processor combined data, automatically generate standard on this basis and further generate self-defined report help user and find the service feature bottleneck fast, thereby propose dilatation and improvement project targetedly; Further improve the management and monitoring ability of operator to value-added service.In addition, 1. the corresponding system of the inventive method is by the multidimensional inquiring module, system is had drill through the ability that maximum magnitude is contained the multidimensional business datum collection generation self-defined report of concrete professional critical data, thereby make the system can tackle the demand of self-defined report fast, greatly reduced the workload that the user develops self-defined report; 2. the inventive method makes when generating monthly magazine, quarterly report, annual report owing to the technology that has adopted daily sheet to go back to the deposit data storehouse, has significantly reduced the data that need processing; 3. the corresponding system of the inventive method adopts more new database of incremental mode, has effectively avoided system faults such as the machine of delaying, data processing failure to occur under the heavy load situation, has strengthened the robustness of system.

Description of drawings

Fig. 1 is value-added service analysis overall structure figure of the present invention.

Fig. 2 is a value-added service analysis business diagnosis subsystem software Organization Chart of the present invention.

Fig. 3 is that the inventive method business diagnosis subsystem standard forms is handled schematic diagram.

Fig. 4 is that business diagnosis subsystem self-defined report of the present invention is handled schematic diagram.

Embodiment

At first, a kind of concrete structure of automatic generation method for standard report of value-added service of the present invention is described, as shown in Figure 1, comprise and be distributed in network some note treatment facilities 1 (comprising sms center SMSC, USSD center, business/Interworking gateway, SP turnkey console etc.), business diagnosis subsystem server 3 and some business diagnosis subsystem client terminals 4 everywhere.

Secondly, key technology of the present invention is described:

(1) incremental build cube:

Because number of short is huge,, that is to say that be inserted into data centralization with newly-increased business datum every day so the structure of multidimensional business datum collection must take the mode of increment to make up, rather than data set for reconstruction all each time.The data that incremental update must guarantee to make up data set also are increments, otherwise data might repeatedly enter cube.The concrete processing method that system of the present invention takes can be at first to set up a view of this table, utilizes condition restriction some periods to be processed of WHERE, and this period can be one day or several hrs according to the difference of application scenarios.For example: under normal circumstances, gathering with one day automatically is a collection period; Under the festivals or holidays patterns, gather automatically and be one with 4/2 hours and gather the period.By for the different view masterplate of different table definition,, just can realize the data adaptive collection under the different scenes in conjunction with following (three) bar described festivals or holidays of pattern.

(2) the daily paper data are returned and are deposited:

According to the SMSC of China Mobile demand data standard V2.0.0, note treatment facility/sms center SMSC need provide tens forms such as note treatment facility/sms center system performance index, short message signaling load index, international short message service index to office side user.Except the needs daily paper, also need monthly magazine, quarterly report, annual report etc. for each form office side., each index all comes from one or more field in the raw data table in the middle database that sms center provides in the form, record in these tables is generally one minute record, one day was 1440 records, one month is 43200 records, is about 518400 records in 1 year.

With regard to daily report processing, the data record that need handle every day is about about 150,000, and this quantity is not big.But when making monthly magazine, the data record that needs to handle is exactly about 4,500,000; When making quarterly report, the data record that needs to handle is exactly 1350 intact bars; When making annual report, the right record of demand side will be up to 1.6 hundred million about because system also has a large amount of routine works to finish every day, this will influence the disposal ability of system undoubtedly greatly.

Statistical indicator in monthly magazine/quarterly report/annual report is consistent with daily paper, and unique difference is: the time granularity in the daily paper is thinner, for example, hour or 15 minutes be a statistics granularity, and in monthly magazine/quarterly report/annual report, be the statistics granularity basically with the sky.At this situation, every day daily paper generate finish after, call daily paper automatically and return and deposit processing module daily paper is imported in the database in corresponding day table.When every month finished, the basis that is recorded as with in the day table generated a moon form.In this case, even if generate annual report, the record number that needs to handle be several ten thousand only, in this case, monthly magazine quarterly report the timing generation of annual report the disposal ability of system is not had impact basically.

(3) festivals or holidays pattern

Special circumstances that face in the short message O﹠M system are exactly: festivals or holidays (comprise the Spring Festival, May Day, 11, New Year's Day, Christmas Day, April Fool's Day and Saturday, Sunday) at ordinary times, the note flow is often big than usual a lot, for example: the front during the Spring Festival several days, note flow are at ordinary times six times.Under this scene, be that the acquisition granularity makes up the multidimensional data fairground and just seems too big at ordinary times with the sky, not only can cause database performance to descend, and data loading also can often be failed.And if, then increased work of maintenance personnel amount and work difficulty greatly each time all by operator on duty's manual setting the acquisition granularity.For this reason, native system has proposed the festivals or holidays patterns and has handled this situation, and in the festivals or holidays patterns, the user can specify the size (4 hours, 2 hours, 1 hour, 15 minutes etc.) of the acquisition granularity; According to convection current quantitative statistics in the past, the attendant can define and need be included into the date range that festivals or holidays, pattern was handled, and native system has also segmented 1～6 (kind quantity is not limit) spermotype.Be exactly certain province's defined file festivals or holidays below by festivals or holidays, instrument produced:

<project?name＝″Definition?of?Feaset?and?Holiday″basedir＝″.″default＝″main″>

<taskdef?name＝″Short?Message?System″/>

<BusinessCalendar>

<Feast>

＜!--New Year's Day--〉

<include?month＝″1″fromDay＝″1″toDay＝″1″ mode＝″1″/>

＜!--Spring Festival--〉

<include?month＝″1″fromDay＝″27″toDay＝″31″ mode＝″1″/>

<include?month＝″2″fromDay＝″1″toDay＝″6″ mode＝″2″/>

＜!--Labor Day--〉

<include?month＝″5″fromDay＝″1″toDay＝″3″ mode＝″1″/>

<include?month＝″5″fromDay＝″4″toDay＝″7″ mode＝″2″/>

＜!--11 National Day--〉

<include?month＝″10″fromDay＝″1″toDay＝″3″ mode＝″2″/>

<include?month＝″10″fromDay＝″4″toDay＝″7″ mode＝″2″/>

＜!--Id al-fitr--〉

<include?month＝″11″fromDay＝″14″toDay＝″14″?mode＝″3″/>

…………

</Feast>

<Holiday>

<weekDay>

<include?name＝″sat″mode＝″4″/>

<include?name＝″sun″mode＝″4″/>

<weekDay>

</Holiday>

</BusinessCalendar>

</project>

In this document, the user not only can define legal red-letter day, can also (for example: Id al-fitr) define region red-letter days according to actual conditions.

The report form generation method of business diagnosis subsystem is described at last:

Business diagnosis subsystem 2, framework comprise that cube module, scheduler module 22, report form processing module 23, multidimensional inquiring module 24, daily paper return to deposit processing module 25 and data pre-processor 26 as shown in Figure 2.Wherein, the cube module is configured to cube 21 with data-base recording; Scheduler module 22 is dispatched corresponding standard forms task according to the time scheduling strategy; Report form processing module 23 is finished various standard forms tasks; Multidimensional inquiring module 24 reads cube and generates the form that the user needs according to query-defined; Daily paper returns deposits processing module 25 with in showing day accordingly in the data importing database in the daily sheet; The form of data pre-processor 26 unified original business datums.Concrete report form generation method comprises standard forms and self-defined report generation method, wherein:

1. standard forms generates, and as shown in Figure 3, under this processing mode, the intersection that field is formed in the intermediate database summary sheet contains all standard forms indexs.Dispatch triggering report form processing module 23 automatic daily paper that generates on the intermediate database basis 22 every days by scheduler module, return by daily paper again and deposit processing module 25 in showing day accordingly in the data importing database in the daily sheet; Trigger report form processing module 23 by the scheduling of 22 every month/seasons of scheduler module and on the basis of day table, generate monthly magazine/quarterly report automatically.

2. self-defined report generates, as shown in Figure 4, in this mode, as long as business datum is present in the multidimensional data services sets 21, user 5 just can drill through multidimensional data services sets 21 by the multi-dimensional query expression formula in the multidimensional inquiring module 24 and generate self-defined report 6; Multidimensional data services sets 21 is designed to maximum magnitude ground and contains key business data, therefore can find the related service data basically in multidimensional data services sets 21, and these business datums all are not present in the middle summary sheet.In Fig. 4, for the situation that can't directly satisfy user's form demand by the multidimensional inquiring definition, can earlier the query-defined Data View that obtains be saved in the respective table of intermediate database, the final User Defined form 6 that generates in back is calculated in field processing in the report tool his-and-hers watches that provide by report form processing module 23 again, and this processing procedure is shown in the dotted line among Fig. 4.

Multidimensional inquiring defined file in the multidimensional inquiring module 24 has defined and drilled through the needed full detail of form from multidimensional data services sets 21, comprise: the mode of the catalogue at source cube place, name, inquiry, query-defined (comprising character string, matching way, dimension name of inquiry etc.), and the information such as position in the Query Result insertion form, illustrate as follows:

<？xml?version＝″1.0″encoding＝″GB2312″？>

＜job name=" cubeToReport " cubeName=" analysis of dream net note "

cubePath＝″$run.cube.dir″>

＜ReportQueries add=" 3 "〉// represent the advanced inquiry pattern

＜objFind Name=" SP flow analysis " searchText=" 903 " pattern=" 2 "

Dimension=" SP code " searchShortName=" False "/〉

<AddToReport?insertItem＝″1″insertPoint＝″1″

levelAction＝″3″/>

<ReportQueries>

<publish?outputDir＝″$run.report.dir″interactive＝″flase″

allLayers＝″true″format＝″xls″/>

</job>

SearchText=" 903 ", the representative inquiry comprises 903 SP code; Pattern=" 2 " expression is that the character string beginning comprises mode; The dimension name of dimension=" SP code " expression inquiry; The name of theme is analyzed in cubeName=" analysis of dream net note " expression; The outputDir=" $run.report.dir " path of expression report output.

Claims (8)

1. an automatic generation method for standard report of value-added service is characterized in that, uses the database that is stored in the value-added service analysis, may further comprise the steps:

1.1) user proposes the form demand according to industry standard and be preset in the system;

1.2) report form index is corresponded to corresponding field in a plurality of tables in the described database;

1.3) data-base recording that relates to is gathered calculating by the minimum time granularity of application scenarios needs, and generate the corresponding standard form.

2. according to the described generation method of claim 1, it is characterized in that described standard forms comprises daily sheet, finish daily sheet by scheduler module (22) by the scheduling of sky time scheduling strategy and generate task.

3. according to the described generation method of claim 1, it is characterized in that described standard forms comprises moon form or quarterly report table, monthly or season time scheduling strategy scheduling is finished month or quarterly account generates task by scheduler module (22).

4. according to the described generation method of claim 1, it is characterized in that this method also comprises described daily paper is imported in the corresponding day table of described database.

5. according to the described generation method of claim 4, it is characterized in that this method also comprises based on the Sino-Japan table record of described database, monthly or season time scheduling strategy scheduling is finished month or quarterly account by scheduler module (22).

6. according to the described generation method of claim 1, it is characterized in that this method comprises that also the user shows or the described standard forms of printout.

7. according to the described generation method of claim 1, it is characterized in that described form demand can increase, revises or cancel.

8. according to the described generation method of claim 1, it is characterized in that the initial data that is used to generate standard forms in the described database is obtained and be may further comprise the steps:

8.1) the original business datum of each note treatment facility (1) in the collection network;

8.2) each described original business datum converted to the business datum of consolidation form;

8.3) be aggregated into database.

Images