CN100426301C - Portal analysis system and method for implementing portal analysis service - Google Patents
Portal analysis system and method for implementing portal analysis service Download PDFInfo
- Publication number
- CN100426301C CN100426301C CNB2006101564651A CN200610156465A CN100426301C CN 100426301 C CN100426301 C CN 100426301C CN B2006101564651 A CNB2006101564651 A CN B2006101564651A CN 200610156465 A CN200610156465 A CN 200610156465A CN 100426301 C CN100426301 C CN 100426301C
- Authority
- CN
- China
- Prior art keywords
- business
- analysis
- resource
- data
- module
- 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.)
- Expired - Fee Related
Links
- 238000000034 method Methods 0.000 title claims abstract description 49
- 238000004458 analytical method Methods 0.000 title claims description 203
- 230000005540 biological transmission Effects 0.000 claims description 7
- 238000004321 preservation Methods 0.000 claims description 5
- 238000010586 diagram Methods 0.000 description 10
- 230000008569 process Effects 0.000 description 10
- 230000008520 organization Effects 0.000 description 8
- 238000007418 data mining Methods 0.000 description 7
- 238000012098 association analyses Methods 0.000 description 4
- 230000000694 effects Effects 0.000 description 4
- 238000013459 approach Methods 0.000 description 3
- 238000003556 assay Methods 0.000 description 2
- 238000004891 communication Methods 0.000 description 2
- 238000007405 data analysis Methods 0.000 description 2
- 238000012217 deletion Methods 0.000 description 2
- 230000037430 deletion Effects 0.000 description 2
- 238000013461 design Methods 0.000 description 2
- 238000012545 processing Methods 0.000 description 2
- 208000024780 Urticaria Diseases 0.000 description 1
- 230000008859 change Effects 0.000 description 1
- 238000006243 chemical reaction Methods 0.000 description 1
- 238000010276 construction Methods 0.000 description 1
- 238000013075 data extraction Methods 0.000 description 1
- 238000013501 data transformation Methods 0.000 description 1
- 238000011161 development Methods 0.000 description 1
- 238000003745 diagnosis Methods 0.000 description 1
- 238000005516 engineering process Methods 0.000 description 1
- 230000006872 improvement Effects 0.000 description 1
- 230000010354 integration Effects 0.000 description 1
- 238000013507 mapping Methods 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 230000000630 rising effect Effects 0.000 description 1
Images
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The analytical entrance system comprises customer operation interface module, control module and database storage module, with the said customer operation interface module used to receive necessary analytical operation, sending to the control module, receiving and displaying the data for operations from the control module, the said operation data composed of operation analytical resources, the said control module used for receiving operation, the said data base storage module is used for storing data sheet composed with data, sending the searched out data to the control module. It also relates to a realization method of analytical entrance operation with the analysts getting all the related data from an uniform operation entrance to improve the analytical efficiency.
Description
Technical field
The present invention relates to data analysis technique, be specifically related to the implementation method of a kind of portal analysis system and portal analysis business.
Background technology
Data warehouse is a kind of database of rising in recent years, is subject-oriented, data acquisition integrated, nonupdatable, that constantly change in time, in order to support the decision-making process in the operation control.Along with the development of data warehouse foundation in recent years is perfect, the focus of all trades and professions operation analysis system has also been transferred to the application of data warehouse by the construction of data warehouse, i.e. the application of operation analysis system comes up.
Fig. 1 is the logical organization synoptic diagram of the operation analysis system of prior art, referring to Fig. 1, this system comprises that analysis resource, data warehouse, data pick-up conversion load (ETL, Data Extraction, DataTransformation, Data Load) instrument and source data system.
Wherein, analyze resource is carried out data analysis for the analyst inlet, comprise KPI Key Performance Indicator (KPI, Key performance Index), form, intellectual search, on-line analytical processing (OLAP, OnlineAnalytical Processing) and data mining etc.When the analyst will analyze the data of a certain business, from data warehouse, search corresponding data by analyzing resource, and present to the analyst by the data organization mode of analyzing resource self.
Preserve the data of integrating through the ETL instrument in the data warehouse; At first to take out business model when building data warehouse, business model is meant the logical model that will analyze, just to preserve any data in the data warehouse, whether these data can be got, and extract corresponding data according to the definition of this logical model by the ETL instrument from the source data system and be stored in the data warehouse.For example, data warehouse is preserved the data of human resources and market department in certain enterprise, human resource data can be obtained from the human resources system, the form that the data of market department can provide from each marketing personnel, and data that various consulting firms provide or the like obtain.Then, set up physical model, the data in the data warehouse are according to this physical model storage.Set up physical model and be meant the relation that designs between each business datum table and the business datum table, simultaneously the mapping relations of specified data from the source data system to data warehouse.
The ETL process is to use the ETL instrument that the source data of all separate sources design proposal according to requirement of enterprise and data warehouse is incorporated in the data warehouse.This process comprises steps such as data pick-up, data-switching and data load.In the process of data integration, relate to the consistance of data, as coding, tolerance or the like.For example, the monetary unit of Human Resources is a dollar in the source data system, and the monetary unit of marketing data part is Euro in the source data system, and monetary unit is a Renminbi in the data warehouse, the ETL process is unified for behind the Renminbi with these monetary units so, is stored in the data warehouse again.
The source data system has preserved all crude raw data of enterprise demand, and the data in data warehouse derive from a plurality of different source data systems usually.
Because it is to divide from the angle of analyzing resource function that data warehouse, present operation analysis system offer the interface of analyst's use.Have the application process of operation analysis system below now with the explanation of telecommunications industry operation analysis system.
For example, the marketing personal will analyze Ring Back Tone service from operation analysis system, at first will be from analyzing resource, i.e. and KPI, form, intelligence inquire, OLAP and data mining analysiss of starting with is as data such as the number of users of the present CRBT of acquisition from KPI, incomes; Seek the form relevant again in the form, after obtaining relevant form,, then forward the analysis data relevant in olap analysis resource and the data mining again to CRBT if also do not reach the purpose of analysis with CRBT.As seen, the marketing personal is in order to analyze a Ring Back Tone service, navigate to each and analyze in resource and analyze, and seeks related data, analyzes data volume in resource when big when each, can make to be positioned to the relevant analysis comparison difficulty that becomes.
As seen, existing operation analysis system is from analyzing the structure of resource function angular divisions, make the business personnel when checking current business, can not obtain all data of same business, also be difficult to find the data of other theme relevant with this business, cause analyst's work efficiency low, thereby influenced the result of use of operation analysis system.
Summary of the invention
In view of this, the embodiment of the invention provides a kind of portal analysis system, improves operation analysis system user of service's work efficiency.
The embodiment of the invention provides a kind of implementation method of portal analysis business, improves operation analysis system user of service's work efficiency.
For achieving the above object, the technical scheme of the embodiment of the invention is achieved in that
A kind of portal analysis system, this system comprises user traffic interfaces module, control module and database storing module,
The user traffic interfaces module is used to receive the business that needs are analyzed, and is transferred to control module; Reception is from the data and the demonstration of the described business of control module; The data of described business comprise the analysis resource of described business; Receive professional analysis resource, be transferred to control module, and receive content from the analysis resource system of described control module;
Control module is used to receive the business of analyzing from the needs of user traffic interfaces module, finds these professional data and be transferred to the user traffic interfaces module in the database storing module; Reception is searched the storing path of the analysis resource of described business from the analysis resource of the business of described user traffic interfaces module in the database storing module, call the content of described analysis resource system according to the storing path of described analysis resource;
The database storing module is used to preserve the database table that comprises professional data; And the storing path of the analysis resource of preservation business; The data transmission of the business that control module is found is to control module.
A kind of implementation method of portal analysis business, this method comprises:
Receive the business that needs analysis; Search the data of described business in database table, the data of described business comprise the analysis resource of described business; The data that show described business; Receive the analysis resource of described business, in described database table, search the storing path of described analysis resource, call described analysis resource service and show according to the storing path of described analysis resource.
Compared with prior art, the portal analysis system that the embodiment of the invention provided and the implementation method of portal analysis business, the analysis resource of the operation analysis system that will divide by function reorganizes, and divide by business, set up the portal analysis of operation analysis system, make the analyst when analyzing data, can obtain all data of this business easily, thereby improve the user of service's of operation analysis system work efficiency.
Description of drawings
Fig. 1 is the logical organization synoptic diagram of the operation analysis system of prior art;
Fig. 2 is the structural representation of the portal analysis system in the embodiment of the invention;
Fig. 3 is the logical schematic of the annexation of portal analysis system in the embodiment of the invention and operation analysis system;
Fig. 4 is the application example with portal analysis system embodiment shown in Figure 3;
Fig. 5 is the method to set up process flow diagram of database table in the portal analysis system in the embodiment of the invention;
Fig. 6 is the method to set up process flow diagram of database table in the telecommunications industry portal analysis system in the embodiment of the invention;
Fig. 7 is the sorting technique of the telecommunication service analytic target in the embodiment of the invention;
Fig. 8 is the sorting technique of the telecommunication service analysis indexes in the embodiment of the invention;
Fig. 9 is the data organization mode synoptic diagram of the analytic target in the embodiment of the invention;
Figure 10 is the application synoptic diagram of portal analysis system in telecommunications industry in the embodiment of the invention.
Embodiment
The present invention is described in detail below in conjunction with drawings and the specific embodiments.
The portal analysis system that the embodiment of the invention provides reorganizes the analysis resource of existing operation analysis system by business, foundation is with the portal analysis system (Portal) of delineation of activities, make the operation analysis system user of service when analyzing business, can obtain all data of this business.
Fig. 2 is the structural representation of the portal analysis system in the embodiment of the invention, and referring to Fig. 2, this system comprises user traffic interfaces module, control module and database storing module.
Wherein, the user traffic interfaces module is used to receive the business that needs are analyzed, and is transferred to control module; Reception is from the data and the demonstration of the described business of control module.The data of described business comprise the analysis resource of described business.
Control module is used to receive the business of analyzing from the needs of user traffic interfaces module, finds these professional data and be transferred to the user traffic interfaces module in the database storing module.
The database storing module is used to preserve the database table that comprises professional data; The data transmission of the business that control module is found is to control module.
The database storing module is further used for preserving professional analysis resource and corresponding storing path, and these professional data comprise the analysis resource of this business, and the user traffic interfaces module is further used for receiving the analysis resource of this business, is transferred to control module; Reception is from the content of this analysis resource system of control module; Control module is further used for receiving the analysis resource from this business of user traffic interfaces module, searches the storing path of this analysis resource in the database storing module, is positioned to this analysis resource system according to the storing path of this analysis resource.
Control module is further used for searching all business in the database storing module, and the business that finds is transferred to the user traffic interfaces module; The user traffic interfaces module is further used for receiving the business that control module finds, and the business that finds is shown, need to select the business of analysis to make things convenient for the user when entering the portal analysis system.
Control module is further used for the described business that needs to analyze is input in the database storing module as restrictive condition, searches the title of the database table of the business that comprises described needs analysis, is transferred to the user traffic interfaces module; The user traffic interfaces module be further used for receiving from comprising of control module the business that described needs are analyzed database table title and show.
Control module is further used for preserving all business of analyzing of user traffic interfaces module transmission, it is analyst's analysis path, receive user traffic interfaces module transmission retreat instruction after, last professional data with the business of the analysis of preserving, promptly the data transmission of last business analyzed in the analysis path of Bao Cuning is shown by the user traffic interfaces module to the user traffic interfaces module.
Figure 3 shows that the logical schematic of the annexation of portal analysis system in the embodiment of the invention and operation analysis system, referring to Fig. 3, analysis Portal in the embodiment of the invention is based upon existing comprising on the operation analysis system of analyzing resource, data warehouse, ETL instrument and source data system, the content of analyzing in resource KPI, form, intelligence inquire, OLAP and the data mining is organized by business, thereby provided the inlet of a unification for the analyst from professional access analysis resource.
When the analyst chooses the business that needs analysis on the interface of analysis Portal, and when clicking this business, the user traffic interfaces module of analyzing Portal is transferred to control module with this business, in the database storing module, search these professional data by control module, be transferred to the user traffic interfaces module and be shown to the user.
Also preserved in the database storing module of analysis Portal and analyzed the path that resource is preserved in whole operation analysis system,, analyzed Portal and just can go in the system that analyzes resource by this path.
When the analyst clicks need analyze professional, analyze data show that Portal should business to the analyst, simultaneously, the analysis resource of this business correspondence is also shown on the interface, when the analysis resource that need enter this business correspondence the analyst is further analyzed this business, by clicking this analysis resource, promptly the storing path of this analysis resource that can preserve by the database storing module enters in the analytic system of this analysis resource.
Analyze Portal and the business relevant with the business of needs analysis can also be presented at adjacent or close zone, make things convenient for the analyst to analyze the data of the business relevant when needed with this business.
For example, when the analyst analyzes professionally 1 the time, the user traffic interfaces module of analyzing Portal is transferred to control module with business 1, by the data of the control module business of searching in the database storing module 1; After the database storing module receives this look-up command, find professional 1 related data and analyze resource, this analysis resource comprises the analysis resource of various data organization modes, as KPI, form, intelligence inquire, OLAP and data mining; And with the related data that finds with analyze resource transmission, be transferred to the demonstration of user traffic interfaces module by control module to control module; When the analyst need analyze the analysis resource of this business, control module is searched the storing path of analyzing resource in the database storing module, and fixed to this analysis resource system, this content delivery of analyzing resource system to the user traffic interfaces module, is shown to the analyst.In addition, analyze the incidence relation between the business that Portal also can preserve correlationship, as analyze at professional 1 o'clock the analyst, also the business 2 that will be relevant with professional 1 and the related content of business 3 offer the analyst.After the business personnel finished business 1 analysis, if when also needing to analyze the business 3 relevant with professional 1, the analyst entered professional 3 assay surface, and on professional 3 assay surface, analysis Portal also offers the analyst with the professional n relevant with business 3.
By the above as can be known, analyze data that Portal will analyze resource by work organization, each is professional descends can provide the analysis content of different analytical approach correspondence, can also provide the analysis between the business of incidence relation, therefore, the analyst can carry out various analyses easily.
Below to be example with the operation analysis system of telecommunications industry describe in detail to the using method of the analysis Portal in the embodiment of the invention.
Fig. 4 is the application example with portal analysis system shown in Figure 3, and referring to Fig. 4, the analysis path that the analyst uses the portal analysis system in the embodiment of the invention to analyze can comprise:
The first, the analyst pays close attention to the situation of recent national distance, shown among the figure 1.Analysis Portal shows common long-distance, 12593 and 17951 these three business functions that are subordinated to national distance under the national distance simultaneously;
Second, after the basic condition of having understood national distance, the analyst can analyze common long-distance, 12593 and 17951 these three business functions that are subordinated to national distance, the analyst selects long-distancely to analyze especially common, shown among the figure 2, analyze Portal and show common long-distance every analysis indexes, as common long-distance service class analysis indexes, comprise communication time, number of communications, charging duration, telephone traffic etc., reach common long-distance income, client etc.;
The 3rd, the analyst can understand common long-distance every analysis indexes, finds out and uses common long-distance customers, further these customers is analyzed, shown among the figure 3.At this moment, analyze the service satisfactory situation that Portal shows client's total amount, newly-increased/customer revenue, client's behavior and customers; Analyze the contents such as data service operating position that Portal also shows customers;
The 4th, in customer analysis, the analyst can carry out client's macroanalysis, newly-increased/customer revenue analysis and customer behavior analysis; Then, the analyst need check the service satisfactory situation of these customers, and the analyst can further carry out service analysis, shown among the figure 4;
The 5th, after service analysis finished, the analyst can also find out the data service operating position of these customers in the table of client territory, shown among the figure 5.
Therefore, analysis path shown in Figure 4 is: 1 long-distance service-＞2 common long-distance service-＞3 client-＞4 customer service-＞5 client uses data service.
The implementation method of the portal analysis business in the embodiment of the invention comprises:
Receive the business that needs analysis, search the data of described business in database table, the data of described business comprise the analysis resource of described business;
The data that show described business.
Receive before the business that needs to analyze, database table can also be set.Figure 5 shows that the method to set up process flow diagram of database table in the portal analysis system in the embodiment of the invention, referring to Fig. 5, this method may further comprise the steps:
Step 500: business is classified.
Step 501: database table is set, classification results is mapped in the database table, preserve this database table.
Step 502: resource is unified numbers analyzing, and preserves the storing path that each analyzes resource corresponding to this numbering.
In this step, each storing path of analyzing resource is meant the path that each analysis resource is preserved in operation analysis system.
Step 503: analyze resource be saved in step 502 in analyze in the corresponding database table of storing path of resource.
After step 501, or after the step 502, or after the step 503, this method can also comprise searches professional and demonstrations all in the database table.In the business that shows, need to select the business of analysis for the analyst.
This method can also receive the analysis resource of this business, searches the storing path of this analysis resource in database table, calls the content and the demonstration of this analysis resource system according to the storing path of this analysis resource.
After searching the data and demonstration of the current business that need analyze, this method can also be searched other business relevant with this business in database table, this business of being about to is input in the database table as restrictive condition, searches the title that comprises this professional database table, and shows.
After searching the data of the current business of need analyzing and showing, this method can also be preserved all business of analyzing, receive retreat instruction after, last professional data of the business of the analysis of demonstration preservation.
Below to be example with the telecommunications industry operation analysis system be elaborated to the implementation method of the analysis Portal database storing module in the embodiment of the invention.Fig. 6 is the method to set up process flow diagram of database table in the telecommunications industry portal analysis system, and referring to Fig. 6, this method may further comprise the steps:
Step 600: telecommunication service is classified.
Described herein telecommunication service is made up of two parts, analytic target and analysis indexes.
Wherein, the sorting technique of telecommunication service analytic target as shown in Figure 7, the telecommunication service analytic target can be divided into product territory, client territory and services channels territory.
Wherein, the product territory can be divided into analysis objects such as function, product, brand and number/terminal/card resource.The analytic target function comprises the service that present telecommunications industry provides, and analyzes subobject as speech business, value-added service, data service etc.Speech business can be further divided into local call, toll message, procotol (IP, Internet Protocol) conversation, roaming conversation etc. again and analyze subobject.Value-added service comprises analysis subobjects such as caller identification, CRBT.Data service comprises analysis subobjects such as note, multimedia message, GPRS (GPRS, General Packet Radio Service), WAP (wireless application protocol) (WAP, WirelessApplication Protocol).Product is an entity of in the telecommunications industry service being packed independent sale, also is the sub-brand name under each famous brand.
The services channels territory can be divided into own channel, cooperation channel and online business hall etc. and analyze object.
The client territory can be divided into from the netter family, network re-entry client, the client that takes pictures, high value client and the client that hives off immediately etc. analyze object.
The sorting technique of telecommunication service analysis indexes as shown in Figure 8, the analysis indexes that telecommunications industry is analyzed content is divided into increment and storage two classes.On the basis of increment and storage, also be divided into user class, income class, customer service class and service class four class indexs.
Wherein, the user class index can have the user to arrive number, number, loss number of users etc. Add User.
Income class index can have gross income, reduce income, portfolio income etc.
Portfolio class index can have duration, number of times, flow etc.
Other class index can have telephone traffic, resource utilization, customer service class index etc.
Usually the analyst can analyze every index that each analyzes subobject, promptly carries out self and analyzes; Also can analyze adjacent analytic target in these three territories, be horizontal analysis or vertical analysis, for example, after horizontal analysis is meant a certain analysis subobject in the analytic product, in the analytic product another analyzed subobject again, vertical analysis goes to a certain analysis subobject in the analytic function after being meant a certain analysis subobject in the analytic product; Also can analyze the analytic target in other territory related, promptly cross-domain object association analysis with the analytic target in certain territory.Common analysis path is: product-＞channel-＞client, or channel-＞product-＞client.
Step 601: database table is set, each of step 600 telecommunication operation classification result analyze subobject with a recorded and stored in database table.
Analytic target in product territory, services channels territory and the client territory is saved in respectively in portfolio subject heading list, service and channel table and the customers' table.Related content in the analysis indexes is saved in the index table.
After database table was set, control module was searched all business in database table, and promptly the title of all database tables is transferred to the user traffic interfaces module with the business that finds, and was shown by the user traffic interfaces module.
Step 602:, and preserve each and analyze the path of resource in operation analysis system the unified numbering of the analysis resource in the telecommunication service.
These analyze the unified numbering of resource to this step KPI, form, OLAP, intelligence inquire and data mining, then all are analyzed resource and be stored as a database table corresponding to this numbering, it is resource table, comprise the resource identifier (ID corresponding in this resource table with this numbering, Identification), analyze resource name, the path of preservation analysis resource in operation analysis system in this database table simultaneously.So that analyzing the control module of Portal navigates in the corresponding analysis resource fast by this analysis path.
After the database table setting is finished, utilize the main external key method in the database well known to those skilled in the art that set database table is organized.
Control module is searched the business relevant with the business that needs to analyze in database table method comprises:
Product territory to services channels territory or services channels territory are that the resource ID field is carried out association to the product territory by analyzing the resource number.For example, if the analyst will analyze the related data of a certain product, the content delivery of then analyzing the services channels territory that the control module of Portal will be identical with the resource ID in this product is to the user traffic interfaces module, show by the user traffic interfaces module, further analyze the service relevant in the time of need analyzing for the analyst with this product.In the practical application, also can be undertaken by other total field of product territory table and services channels territory table related, with the relevant business of business that finds and need analysis.
Product territory to client territory: the control module analysis subobject that the analyst is current of analyzing Portal, input in the interface of customer grouping table, automatically generate the client's list that satisfies current restrictive condition, and this customer name patrilineal line of descent with only one son in each generation is passed to the user traffic interfaces module, be presented at zone adjacent or close on the interface by the user traffic interfaces module,, further carry out the analysis of other business, or directly client's list is carried out marketing activity at client's list for the analyst.
Client territory to product territory or services channels territory: the database table of preserving all fields in the product territory in the customer grouping table, the analyst is when analyzing the client, control module all is transferred to the user traffic interfaces module with related content in the customer grouping table and shows, therefore the analyst can directly carry out product analysis in client's table, obtains the employed product situation of current customers.If obtain a certain product among the current client, or certain services channels, then analyze the control module of Portal this product or services channels are used as the input of restrictive condition as product territory and services channels territory table, be positioned to corresponding product or services channels, be transferred to the user traffic interfaces module and show, further analyze for the analyst.
Fig. 9 is the data organization mode synoptic diagram of the analytic target in the embodiment of the invention, referring to Fig. 9, suppose that the data organization function of telecommunications industry analytic target mainly is made up of 5 tables: table 1 portfolio subject heading list, table 2 service and channel table, table 3 are analyzed resource table, table 4 index table and table 5 customer grouping table.
Wherein, table 1 portfolio subject heading list is mainly by following field: time, region, brand, function, index and analysis resource, traffic ID field are major key, the external key business or the service ID of corresponding tables 4 index tables.The resource ID field is an external key, and corresponding tables 3 is analyzed the major key resource ID of resource table.
As shown in table 11 for the national distance being the professional subject heading list that example is preserved.
| Time | The region | Brand | Product | Function | Traffic ID | Resource ID |
| 200607 | The xx district | Brand 1 | Product 2 | National distance | I | 1 |
| 200607 | The xx district | Brand 2 | Product 1 | National distance | II | 1 |
| 200607 | The xx district | Brand 3 | Product 1 | National distance | III | 2 |
Table 11 portfolio subject heading list
Table 2 service and channel table mainly contain following field: time, region, channel, service ID and resource ID.Wherein, the service ID field is a major key, external key business or service ID in the corresponding tables 4 index tables, and resource ID is an external key, the major key resource ID in corresponding tables 3 resource tables.
Shown in table 21 for the national distance being service and the channel table that example is preserved.
| Time | The region | Channel | Service and channel ID | Resource ID |
| 200607 | The xx district | Self-built business hall, xx district | X | 1 |
| 200607 | The xx district | Xx district XX commission merchant | y | 2 |
Table 21 service and channel table
What preserve in the table 3 analysis resource table is numbering, resource name, resource class and the resource location of analyzing resource.Wherein, resource ID is a major key.
Shown in table 31 for being the analysis resource table that example is preserved with the national distance, comprise resource ID, resource name and resource location.
| Resource ID | Resource name | The resource location |
| 1 | OLAP multidimensional analysis (long-distance service) | // multidimensional analysis/OLAP1 |
| 2 | Form (long-distance service) | // form/report1 |
Table 31 is analyzed resource table
What preserve in the table 4 index table is business or service ID, index ID, index name and index classification, and the index classification comprises income class, customer class, portfolio class and other class etc.Business in the index table or service ID are external keys, the major key in difference corresponding tables 1 and the table 2, and it constitutes major key together business or service ID and index ID.
As table 41 is to be the index table that example is preserved with the national distance.
| Business or service ID | Index ID | Index name | The index classification | Desired value |
| I | 1 | The duration of call (second) | Portfolio | 5000 |
| II | 2 | Talk times | Portfolio | 4000 |
| III | 3 | Add User | Customer volume | 3000 |
| x | 4 | From network users | Customer volume | 2000 |
| y | 5 | Income number | The volume of receipts | 10000 |
Table 41 index table
What preserve in the table 5 customer grouping table is Customer ID, client's basic document and client traffic operating position.
As table 51 is to be the customer grouping table that example is preserved with the national distance.
| Customer ID | Customer name | Client's call rate | The region | … | Transacting business I | Transacting business II | Channel | Resource ID | Services channels x | Services channels y |
| 135xxxx1324 | Xxx | 30 | … | … | Be | Not | … | 1 | Be | Not |
| 135xxxx1362 | Yyy | 40 | … | … | Be | Be | … | 1 | Be | Be |
| 135xxxx1344 | Zzz | 50 | … | … | Be | Not | … | 2 | Be | Not |
Table 51 customer grouping table
Product territory and services channels territory, promptly table 11 and the analysis content in the table 21 can be undertaken relatedly by the resource ID field, also can pass through region field association.As, resource ID is 1 national distance, can be that 1 self-built business hall, xx district, service and channel ID are that the services channels of x are related with resource ID.
The product territory is to the client territory, promptly table 11 and the analysis content in the table 51 undertaken by current analysis content related, i.e. the national distance of the professional I of present analysis, then analyze Portal with professional I as the restrictive condition in the customer grouping table, search and use this professional client's list, offer the analyst.
Client territory to product territory or services channels territory, promptly table 51 carries out association to the analysis content of table 11 or table 21 by all fields in product territory or the services channels territory are preserved in the database table in client territory.Promptly preserve all fields of table 11 and table 21 in the table 51, made the analyst in the table of client territory, can directly analyze the product or the service of client's correspondence.
Step 603: will analyze resource be saved in step 602 in analyze in the corresponding database table in path that resource preserves in system.
If after analyzing Portal foundation, or use after a period of time, need in the index table, add new index or delete a part of index, or in analyzing resource table, add new analysis resource or delete a part of no analysis resource, then can in index territory table, add or deletion index record, or in analyzing resource table, add or the record of resource is analyzed in deletion.
Figure 10 is the application synoptic diagram of portal analysis system in telecommunications industry in the embodiment of the invention, referring to Figure 10, any one analysis subobject of analytic target can be as the analysis inlet that provides for the analyst among Figure 10, for example, can be the brand 1 in the brand, also can be product 1 in the product.The analyst is when carrying out analytic activity, any one analyzes subobject in analyzing Portal, can analyze its corresponding index, also can analyze its adjacent analytic target, promptly behind the analysis subobject in analyzing brand, the analysis subobject in can also analytic product.In analyzing any territory, in the analytic target, can be associated to the analytic target in any two territories, promptly in the analytic target in the analytic product territory, also can be associated to analytic target relevant in client territory or the services channels territory with this analytic target.
Analytical approach can have: self analyzes, horizontal analysis, vertical analysis, cross-domain object association analysis, and the combination of above several analytical approachs.
For example, the local call of analyzing speech business:
Self analyzes: can check every index of local call, as income, call volume, number of users etc.; When carrying out self analyzing, can on region and time two dimensions, analyze.As after checking the whole province's local call of this month, can following local call situation of boring this month of checking prefectures and cities.
Horizontal analysis: other in can the analytic function analytic target analyzed subobject, as the income of national distance, international long-distance, call volume, number of users etc.
Vertical analysis: can analyze analytic target with the relevant relation of present analysis object.As the present analysis object is local call, and next analytic target is each product that contains the local call function, shown in the arrow among Figure 10.If, have only product 1 and product 2 these two products to contain the function of local call, then can in local call, find product 1 and product 2 these two products, and go to other analysis of these two products by linking relationship.
Cross-domain object association analysis: can go to the channel or the customer analysis of analytic product 1 by the local call function in product territory, because channel and client have not belonged to the product territory, so be called cross-domain object association analysis.
By the above as can be seen, the portal analysis system that the embodiment of the invention provided and the implementation method of portal analysis business, to analyze resource KPI, OLAP, form and data mining reorganize and are the organizational form with delineation of activities, for the analyst provides a unified business diagnosis inlet, make the analyst when using operation analysis system, can obtain all data of certain business from an inlet, can also obtain the data relevant with this business, thereby made things convenient for analyst's use, improved the efficient that the analyst uses operation analysis system.
The above is preferred embodiment of the present invention only, is not to be used to limit protection scope of the present invention.Within the spirit and principles in the present invention all, any modification of being done, be equal to replacement, improvement etc., all should be included within protection scope of the present invention.
Claims (8)
1, a kind of portal analysis system is characterized in that this system comprises user traffic interfaces module, control module and database storing module,
The user traffic interfaces module is used to receive the business that needs are analyzed, and is transferred to control module; Reception is from the data and the demonstration of the described business of control module; The data of described business comprise the analysis resource of described business; Receive professional analysis resource, be transferred to control module, and receive content from the analysis resource system of described control module;
Control module is used to receive the business of analyzing from the needs of user traffic interfaces module, finds these professional data and be transferred to the user traffic interfaces module in the database storing module; Reception is searched the storing path of the analysis resource of described business from the analysis resource of the business of described user traffic interfaces module in the database storing module, call the content of described analysis resource system according to the storing path of described analysis resource;
The database storing module is used to preserve the database table that comprises professional data; And the storing path of the analysis resource of preservation business; The data transmission of the business that control module is found is to control module.
2, the system as claimed in claim 1 is characterized in that, described control module is further used for searching all business in described database storing module, and the business that finds is transferred to described user traffic interfaces module;
Described user traffic interfaces module is further used for receiving all the professional and demonstrations from described control module.
3, the system as claimed in claim 1, it is characterized in that, described control module, be further used for the described business that needs to analyze is input in the described database storing module as restrictive condition, search the title of the database table of the business that comprises described needs analysis, be transferred to described user traffic interfaces module;
Described user traffic interfaces module, be further used for receiving from comprising of control module the business that described needs are analyzed database table title and show.
4, a kind of implementation method of portal analysis business is characterized in that, this method comprises:
Receive the business that needs analysis; Search the data of described business in database table, the data of described business comprise the analysis resource of described business; The data that show described business; Receive the analysis resource of described business, in described database table, search the storing path of described analysis resource, call described analysis resource service and show according to the storing path of described analysis resource.
5, method as claimed in claim 4 is characterized in that, before the business that described reception need be analyzed, this method further comprises:
Business is classified;
Database table is set, described classification map in database table, is preserved described database table;
To analyze the unified numbering of resource, preserve the storing path that each analyzes resource corresponding to described numbering;
To analyze resource is saved in the described storing path.
6, method as claimed in claim 5, it is characterized in that, after the described preservation database table, or describedly preserve after each storing path of analyzing resource corresponding to described numbering, or the described resource of will analyzing is saved in corresponding to after in the database table of described storing path, and this method further comprises: search in the database table all professional and show.
7, method as claimed in claim 5 is characterized in that, this method further comprises:
In described database table, search the professional and demonstration relevant with described business.
8, method as claimed in claim 7, it is characterized in that, described method of searching the business relevant with described business in database table is: described business is input in the described database table as restrictive condition, searches the title of the database table that comprises described business.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CNB2006101564651A CN100426301C (en) | 2006-12-31 | 2006-12-31 | Portal analysis system and method for implementing portal analysis service |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CNB2006101564651A CN100426301C (en) | 2006-12-31 | 2006-12-31 | Portal analysis system and method for implementing portal analysis service |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN1996293A CN1996293A (en) | 2007-07-11 |
| CN100426301C true CN100426301C (en) | 2008-10-15 |
Family
ID=38251387
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CNB2006101564651A Expired - Fee Related CN100426301C (en) | 2006-12-31 | 2006-12-31 | Portal analysis system and method for implementing portal analysis service |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN100426301C (en) |
Families Citing this family (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103814389B (en) * | 2011-05-10 | 2018-03-09 | Ims保健公司 | Analysis Service door |
| CN108268565B (en) * | 2017-01-04 | 2020-11-03 | 北京京东尚科信息技术有限公司 | Method and system for processing user browsing behavior data based on data warehouse |
| CN107368523B (en) * | 2017-06-07 | 2020-05-12 | 武汉斗鱼网络科技有限公司 | Data processing method and system |
Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1459747A (en) * | 2002-05-20 | 2003-12-03 | 鸿富锦精密工业（深圳）有限公司 | Patent information excavating and analyzing system and method |
| CN1750038A (en) * | 2005-09-06 | 2006-03-22 | 上海理想信息产业（集团）有限公司 | Computer managing system for large scale telecommunication enterprise |
-
2006
- 2006-12-31 CN CNB2006101564651A patent/CN100426301C/en not_active Expired - Fee Related
Patent Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1459747A (en) * | 2002-05-20 | 2003-12-03 | 鸿富锦精密工业（深圳）有限公司 | Patent information excavating and analyzing system and method |
| CN1750038A (en) * | 2005-09-06 | 2006-03-22 | 上海理想信息产业（集团）有限公司 | Computer managing system for large scale telecommunication enterprise |
Also Published As
| Publication number | Publication date |
|---|---|
| CN1996293A (en) | 2007-07-11 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US10546057B2 (en) | Spreadsheet program-based data classification for source target mapping | |
| CN109978608A (en) | The marketing label analysis extracting method and system of target user's portrait | |
| US20100039495A1 (en) | Method to populate contact list from recent call log | |
| CN103729478B (en) | LBS interest point discovery method based on MapReduce | |
| US20090007263A1 (en) | Method and Apparatus for Combining Traffic Analysis and Monitoring Center in Lawful Interception | |
| CN110532309B (en) | Generation method of college library user portrait system | |
| CN1859505B (en) | Bill checking system and method | |
| CN103150696A (en) | Method and device for selecting potential customer of target value-added service | |
| CN109087132B (en) | Knowledge graph-based user question pushing method and device | |
| US20190149344A1 (en) | Intelligent search system for service cost and method thereof | |
| CN101377768A (en) | Method and system for calculating salary | |
| CN104077407A (en) | System and method for intelligent data searching | |
| CN102547554B (en) | Mobile service recommendation method based on mobile user behavior | |
| CN103189885A (en) | Server, information-management method, information-management program, and computer-readable recording medium with said program recorded thereon | |
| CN103853838A (en) | Data processing method and device | |
| CN105160546A (en) | Method and system for constructing and analyzing social network | |
| CN100426301C (en) | Portal analysis system and method for implementing portal analysis service | |
| CN113850630B (en) | Satisfaction prediction method and device, storage medium and electronic equipment | |
| CN104574159A (en) | Data storage and query method and device | |
| CN104618881B (en) | A kind of generation of multimedia message bill and transmission method | |
| CN101179625A (en) | Voice number inquiry action based data analysis method and system | |
| CN105721289A (en) | Display method of function module in message communication accessory column | |
| CN106125956A (en) | A kind of information-pushing method based on input method and system | |
| Trisolini et al. | Data integration and warehousing in Telecom Italia | |
| CN101383872B (en) | Airplane passenger selecting method based on data bank for communication industry |
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 | ||
| TR01 | Transfer of patent right | ||
| TR01 | Transfer of patent right |
Effective date of registration: 20170927 Address after: 253600, Dezhou City, Shandong province Leling City North jujube Street 94 Patentee after: Zhao Yuhui Address before: 518129 Bantian HUAWEI headquarters office building, Longgang District, Guangdong, Shenzhen Patentee before: Huawei Technologies Co., Ltd. |
|
| TR01 | Transfer of patent right | ||
| TR01 | Transfer of patent right |
Effective date of registration: 20180206 Address after: Lake Anxi County of Quanzhou City, Fujian province 362411 Zhen Dong Pu Cun Gou Wei No. 30-1 Patentee after: Li Youli Address before: 253600, Dezhou City, Shandong province Leling City North jujube Street 94 Patentee before: Zhao Yuhui |
|
| CF01 | Termination of patent right due to non-payment of annual fee | ||
| CF01 | Termination of patent right due to non-payment of annual fee |
Granted publication date: 20081015 Termination date: 20171231 |