CN1750038A - Computer managing system for large scale telecommunication enterprise - Google Patents
Computer managing system for large scale telecommunication enterprise Download PDFInfo
- Publication number
- CN1750038A CN1750038A CNA2005100294260A CN200510029426A CN1750038A CN 1750038 A CN1750038 A CN 1750038A CN A2005100294260 A CNA2005100294260 A CN A2005100294260A CN 200510029426 A CN200510029426 A CN 200510029426A CN 1750038 A CN1750038 A CN 1750038A
- Authority
- CN
- China
- Prior art keywords
- data
- analysis
- server
- business
- customer
- 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
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The present invention relates to computerized managing system for large scale telecom enterprise. It backs up the business analysis by adopting data warehouse technology. The data warehouse is shared in multidimensional database server for business activity analysis and multidimensional database server for client behavior analysis. The computerized management system of the present invention adopts Ethernet as central LAN connected to the main servers of the system, and Internet as WAN interconnected with other remote systems. The computerized management system of the present invention integrates the available business systems and is one computerized management system covering various kinds of business, possessing analysis and decision ability and providing clients with high quality, convenient and efficient service.
Description
Technical field
The present invention relates to computer management system, the invention particularly relates to the computer management system of large scale telecommunication enterprise.
Background technology
It has been the well-known fact that enterprise adopts computer management can improve its efficient greatly.Large enterprise more need a unified management, can carry out the overall situation and the profound computer management system of analyzing and making decisions is controlled its operation and development.
Imagining a large scale telecommunication enterprise has set up such as business application systems such as local call business account system, telecommunication business account system, suburbs and counties under the jurisdiction of a large city's business account system, website business account systems.These systems increase work efficiency and work quality aspect brought into play important effect really, for the normal operation of enterprise provides important assurance.But these systems also exist certain limitation, are in particular in: emphasize business processing, do not analyze and the decision support function system; Be dispersed in all departments, do not accomplish complete information sharing; The customer data disunity lacks complete big customer's data; For all clients provide equal service, the big customer can not enjoy privileges and serve efficiently.
Therefore, for with the competition of other telecom operators in and under the impact of new technology and new business, establish oneself in an unassailable position, a large scale telecommunication enterprise is necessary existing systems is integrated, set up a unification, cover computer management system miscellaneous service, that the analysis and decision ability is arranged.
Summary of the invention
The present invention relates to a kind of computer management system that is used for large scale telecommunication enterprise, it is characterized in that the business analysis multidimensional database server of the activity analysis of carrying on the work and the customer behavior analysis multidimensional database server shared data warehouse that carries out customer behavior analysis.
The hardware of computer management system of the present invention comprises also that except data warehouse server, customer behavior analysis multidimensional database server, business analysis multidimensional database server multidimensional analysis Web server, big customer's Service Management server, big customer serve Web/COM+ group of server and big customer's services streaming server group.
The network that connects each operation system of each server of computer management system of the present invention and managed system management mainly comprises center LAN (Local Area Network) and wide area network, the former adopts Fast Ethernet, its equipment is a switched LAN switch, be used for linking to each other with the main servers and the account system of system, the latter adopts the Internet, its equipment is a router, is used for and other remote systems interconnection except that account system.
Description of drawings
Fig. 1 illustrates the implementation procedure of data warehouse.
Fig. 2 illustrates the shared data warehouse scheme of computer management system of the present invention.
Fig. 3 illustrates the hardware block diagram of computer management system of the present invention.
Fig. 4 illustrates the software function Organization Chart of computer management system of the present invention.
Embodiment
I. the key idea and the technology that are adopted of design structure computer management system of the present invention
1. data warehouse (Data Warehouse) technology
Current data handling system can be divided into two big classes: Transaction Processing (OLTP, OnlineTransaction Process) system and on-line analytical processing (OLAP, Online Analysis Process) system.The OLTP system emphasizes the in-line processing to affairs, normally to the inquiry and the modification of one or a group record, is mainly the specific business service of enterprise, and people are concerned about is the integrality of response time, data and security etc.Present business system and account system or the like system all belongs to the OLTP system.The OLAP system emphasizes analyzing and processing, be used to support complicated analysis operation, lay particular emphasis on to managerial personnel decision support is provided, can handle according to analyst's the complex query that requires fast and flexible ground to carry out big data quantity, and analysis result is offered the decision-maker in a kind of mode intuitively, so that they understand the management state of client, market and company timely and accurately, formulate correct scheme, improve the benefit of enterprise.The OLTP system is not suitable for doing complicated analyzing and processing, and decision support can not be provided, and mainly contain following reason: a) the OLTP system can not provide needed history of complex analyses and data of overall importance.B) carrying out complex analyses in the OLTP system will inevitably the traffic affecting normal process.C) principle of OLTP system organization data is to reduce data redundancy, improve treatment effeciency, and the purpose of complex analyses is to obtain needed analysis result fast, usually improves data access efficiency by increasing methods such as redundancy, contrary normal form.
The OLAP system in order to solve the problem that the OLTP system is not suitable for the complex analyses processing of decision support, to develop, wherein use the data warehouse technology.
Data warehouse is to support data acquisition management decision, subject-oriented, complete, different time.Support decision-making: decision support is the purpose of data warehouse.Subject-oriented: the data in the data warehouse are theme (as product, client, sales volume etc.) tissues of being concerned about according to enterprise.Complete data: the data integration in the data warehouse data in all operation systems, rather than the local data of some systems.The data of different time: deposited the data of different time in the data warehouse, comprised a large amount of historical datas.
Data warehouse technology is a complex art, and it comprises: database technology, data on-line analysis processing, data mining technology, visual information processing/display technique.
The implementation procedure of data warehouse generally comprises following steps as shown in Figure 1:
I) data acquisition, transmission, conversion (Extraction, Transformation, Transportation, ETT)
From having OLTP system acquisition data, translation data now and transmitting data to the data warehouse.These processing are bases of setting up satisfactory quality data in data warehouse.
Gather: from different OLTP operation systems, gather the data that need.
Conversion: with the data of gathering check, verification, purification and integration, form same data layout and stamp time mark.The data of mistake turn back to be corrected in the OLTP system and handles.
The transmission: with data transmission in data warehouse.
Ii) data storage management
All data that storage administration is used to analyze comprise the raw data, combined data and the ephemeral data that collect.Data storage management is the core of data warehouse.Data storage management generally adopts the relevant database server.But the tissue of data capacity, data is different with the relational database among the OLTP, and is higher to the requirement of database.
Iii) on-line analytical processing
On-line analytical processing comprises: set up the multidimensional data model and store data in the mode of multi-dimensional database, the data that enterprise is concerned about are analyzed from a plurality of angles at the problem that enterprise is concerned about, be particularly suitable for on-line analytical processing.Multi-dimensional database can be described with cube (Cube).Each cube has a plurality of dimensions, and the point of crossing of all dimensions is data.Dimension and index amount are two key concepts of multi-dimensional database.Dimension: the angle of observed data, for example time, geographic distribution etc.Index amount: the data that the user was concerned about, for example client's quantity of telecommunications enterprise's care, the traffic etc.
Adopt data exhibiting instrument or business intelligence tools that analysis result is presented to the final user with multiple manifestation mode as required.The data manifestation mode has form, pie chart, histogram, curve map etc.
Iv) data mining
Adopt artificial intelligence technology and Principle of Statistics to excavate profound valuable information.
2. customer relation management (Customer Relationship Management, CRM) thought
CRM helps the business administration customer relationship, give enterprise perfect with ability customer communication, promptly from potential customers identification, generate demand is arranged the client to the marketing, sale and customer service support, the automatic management of overall process and better coordination are provided.
CRM is a kind of technology, also is a kind of management method.Its objective is: improve the ability to exchange between enterprise and the client; Improve the relation between enterprise and the client; Improve service quality and efficiency of service; Increase customer satisfaction degree and customer loyalty; And the increase market opportunity and profit on sales.
CRM should be able to provide: customer information management; Customer support services; Market administration; And sales management
The advantage of CRM is: improve the understanding to the client; Increase work efficiency by robotization, to the customer requirement rapid reaction; Obtain more markets and sales opportunnities; Accept user feedback, improve the quality of products and service quality; The client of identification most worthy; And market one to one.
The key request of implementing CRM is: customer-centric; The customer information centralized management; Business intelligence and analysis ability; The customer communication channel of digesting (face-to-face talk, communication on telephone, EMAIL service, WEB service); To tenability based on the function of WEB; And integrated with existing system.
3. internet/World Wide Web (Internet/Web) technology
In recent years, Internet is fast development in the world, and it has been deep into the various aspects of human society, and particularly the ecommerce based on Internet brings huge business opportunity to enterprise.
The advantage of Internet technology is: improve service quality; Simple to operate; Management is simple; Reduce cost.
II. the shared data warehouse scheme of computer management system of the present invention
Computer management system has business analysis function and customer behavior analysis function.Both difference are mainly reflected on the systemic-function.Business analysis lays particular emphasis on from macroscopic perspective business activities is analyzed, and makes administrative authority in time grasp production and management, for administrative authority's macro-level policy-making provides foundation.Customer behavior analysis lays particular emphasis on the behavior of analyzing the client, and fundamental purpose is the understanding of promoting the client, improves client's service quality particularly to big customer's service quality, and the client is carried out the specific aim marketing activity decision support is provided.Yet customer behavior analysis function and business analysis function also have a lot of something in commons: the data to the existing business system are analyzed; Gather the existing system data; Adopt data warehouse technology; And employing olap analysis instrument.
Consider that business analysis and customer behavior analysis have bigger common ground, from saving investment, avoid overlapping development, conveniently managing equal angles, when system design, business analysis system and customer behavior analysis system are merged into a system, make both shared data warehouse servers, database software and the network platform and programming tool, and accomplish data sharing.
Fig. 2 illustrates the shared data warehouse scheme of computer management system.Among the figure, main hardware equipment has data warehouse server, business analysis multidimensional database server and customer behavior analysis multidimensional database server.Data warehouse server is shared by business analysis and customer behavior analysis.Because the theme or the content of business analysis and customer behavior analysis are different, and the data in the multi-dimensional database are deposited by theme, it is diverse therefore leaving two data in the multi-dimensional database in.Therefore multi-dimensional database can not be shared.
Adopt the advantage in shared data warehouse to be:
I) save investment: both shared data warehouse server hardware, database server software, the network platform, analysis tool, can save great amount of investment.
Ii) simplify interface: if develop two independently systems, two the two is irrelevant mutually, then needs to develop the interface at existing each system respectively, not only makes interface very complicated, and needs a large amount of co-ordinations, increases development difficulty.And if adopt the scheme in shared data warehouse, then only need a socket between two subsystems and the existing systems, improve the efficient and the interface ability of maintenance of interface exploitation greatly.
Iii) maintain easily management: after adopting shared data warehouse scheme, only need to safeguard a sets of data warehouse server, significantly reduced the workload of maintenance management.
Iv) reduce the influence to existing system: present business analysis system need carry out a large amount of statistical works in the existing business system, take system resources such as certain CPU, internal memory, will influence the particularly operation of account system of existing system.Adopt after this programme, needed detailed data is gathered from existing system come, statistical summaries is operated in the data warehouse carries out, and will significantly reduce the influence of existing system.
V) improve the dirigibility of system: according to present mode, the business analysis system lacks dirigibility.Because the present method of business analysis system is from professional system acquisition combined data according to current demand, in case demand changes, need to gather again, this will face two problems: at first the data holding time of operation system limited, if so behind the overtime demand change and will be difficult to collect needed data; Repeated acquisition class likelihood data need be revised interface in addition, and has more increased the burden of operation system.And after adopting shared data warehouse scheme,,, do not have the problem of image data difficulty because data warehouse is deposited a large amount of detailed history data if after demand changes; It is just passable only need to set up new model on raw data, has greatly increased the dirigibility of system.
Vi) convenient the use: adopt identical analysis tool, not only can save investment, and can conveniently use, the user can use identical instrument access customer behavioural analysis and business analysis subsystem on PC.
Vii) data consistent: because the data source of analyzing all is stored in the same data warehouse, the result of analysis contradictory phenomena can not occur.
III. the structure of computer management system of the present invention
3.1 hardware
Fig. 3 provides the hardware block diagram of computer management system of the present invention.As can be seen from the figure, the hardware of this computer management system mainly comprises: data warehouse server 1, customer behavior analysis multidimensional database server 2, business analysis multidimensional database server 3, multidimensional analysis Web server 4, big customer's Service Management server 5, big customer serve Web/COM+ group of server 6, big customer's services streaming server group 7.
Data warehouse server 1 is used for depositing the mass data of gathering, changing from each existing system, and these data are bases of customer behavior analysis.Because data warehouse server 1 is deposited a large amount of historical datas, so the performance requirement of 1 pair of memory capacity of data warehouse server and server is higher.
Customer behavior analysis multidimensional database server 2 is deposited the result of customer behavior analysis with the multi-dimensional database form, can apace analysis result be represented to the user so that information represents instrument.
Business analysis multidimensional database server 3 is deposited the result of business analysis with the multi-dimensional database form, can apace analysis result be represented to the user so that information represents instrument.
Multidimensional analysis Intranet Web server 4 is used for the decision maker of enterprises employee and all departments with browser mode access analysis data and big customer's information.This server can be considered to share same hardware platform with business analysis multidimensional database server or customer behavior analysis multidimensional database server.
Big customer's Service Management server 5 is used for depositing big customer's information, big customer's Service Management information, big customer's accounting management information.Big customer's Service Management server 5 is directly for the big customer provides service, and therefore the Performance And Reliability to server all has higher requirement.In order to improve the reliability of system, system adopts two-server shared disk array group (Cluster) structure that becomes to troop, and two-server backups each other, in case wherein a station server breaks down, another takes over its task immediately, and the assurance system continuously moves.
The big customer serves Web/COM+ group of server 6 can carry out IIS 5.0Web service and COM+ service, and by the troop extendability of raising system performance of configuration.
Big customer's workflow server 7 can drive a workflow trace daemon, as document check and approve, pay wages form and payment, order etc.
3.2 network
System network architecture comprises center LAN (Local Area Network) and wide area network.The center LAN (Local Area Network) links to each other with the main servers equipment of system, needs the transmission lot of data, and therefore adopting switch type Fast Ethernet, the network equipment mainly is a switched LAN switch.Router and remote system interconnection are crossed by center local Netcom.System all links to each other by wide area network with other system except with account system directly is connected by Ethernet.
3.3 interface
Therefore computer management system of the present invention is set up on the existing system basis, must seamlessly integrate with existing system, could play a role veritably, just can accomplish the integrated and professional integrated of data.Therefore there is interface between computer management system of the present invention and the existing system.
The interface of computer management system of the present invention and existing system is mainly realized following function: on the one hand, from the existing system image data, comprise customer information, billing information, business information or the like; On the other hand, by some data of the generation of computer management system of the present invention, for example data such as service handling data, client's account favor information, the mode of entering an item of expenditure in the accounts, charge method all must be sent to existing account system.
3.4 software
The software function framework of computer management system of the present invention as shown in Figure 4.By this figure as can be seen, system is by data pick-up, conversion, loading (Extract, Transform, Load, ETL) set up the mapping of the data model of origin system and data warehouse goal systems, and by the data source image data, by cleaning, change, being loaded in the data warehouse.
Data Mart, also can be born by ETL to the data handling procedure of Data Mart by data warehouse by the data warehouse image data according to dissimilar application demands; ETL also can bear the collection work of data carrying and small amount of data; System provides performance analysis functions such as real-time statistic analysis, subject analysis, specific analysis by OLAP, extemporaneous inquiry, fixedly form, data mining, and represents by door inlet or client; Other application system is obtained data by unified data-interface by data warehouse.
Metadata management comprises the management of technical element data, service metadata, inline mapping metadata.The job scheduling function is finished the automatic scheduling and the monitoring of system job.The maintenance management work of data comprises index management etc. in the data maintenance management realization system.System management realizes functions such as system maintenance, systematic parameter configuration management, System Privileges management, system security management, system monitoring management, system backup management, Operation Log Management, version management.
Multidimensional analysis represents, CRM theory and business data flow be to the transformation that the customization data support, and obtains effective support of system aspects for telecommunications company's new customer service theory customer-centric.Rise in the recent period, all using this theory to implement project both at home and abroad at present.
Combining closely of excavation and data warehouse, a large amount of business data is explored and analyzed, that disclose to hide, unknown or verify known regularity, and further with its modelling, system has realized market analyses such as database marketing, customer group's division, context analyzer, cross-selling, and analysis such as customer churn, client's credit rating are kept the score, customer value, Customer Fraud.
System has three important composition parts that complete commerce is supported decision system: these three kinds of data analysis means of enterprise's form, on-line analysis and data mining have really been contained in data integration, storage administration and access analysis, adopted the most outstanding product of different manufacturers advantage respectively, and they can be integrated well, the system that makes like this has excellent dirigibility and extendability, total system can be deployed on NT or the unix server, make full use of existing investment, can control the scale of the every part of system.
Adopted international advanced person's business data warehouse framework, made client's embodiment forward-looking.It not only is easy to quick deployment, extendability is strong, also reduced customer's risk, can make the client reduce TCO, obtain maximum investment repayment, adopt the data warehouse engine that gets leading in the world, have extraordinary data analysis capabilities, it can adapt to the raw data input of data storage units up to a hundred (TB), and high query performance is provided.
The various aspects that are used for the computer management system of large scale telecommunication enterprise of the present invention have summarily been described above.Obviously, those skilled in the art can be under the prerequisite that does not depart from spirit of the present invention make amendment aspect concrete and change of the present invention, but they still drop in the scope that is limited by the accompanying claims.
Claims (3)
1. computer management system that is used for large scale telecommunication enterprise is characterized in that: its hardware comprises business analysis multidimensional database server, customer behavior analysis multidimensional database server and the data warehouse of being shared by above-mentioned two multi-dimensional databases.
2. the computer management system that is used for large scale telecommunication enterprise as claimed in claim 1 is characterized in that: its hardware comprises that also multidimensional analysis Web server, big customer's Service Management server, big customer serve Web/COM+ group of server and big customer's services streaming server group.
3. the computer management system that is used for large scale telecommunication enterprise as claimed in claim 1, it is characterized in that: the network that connects each hardware of described management system and each operation system mainly comprises center LAN (Local Area Network) and wide area network, the former adopts Fast Ethernet, its equipment is LAN switch, be used for linking to each other with each server and the account system of system, the latter adopts the Internet, and its equipment is router, is used for and other teleaction service system interconnections except that account system.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CNA2005100294260A CN1750038A (en) | 2005-09-06 | 2005-09-06 | Computer managing system for large scale telecommunication enterprise |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CNA2005100294260A CN1750038A (en) | 2005-09-06 | 2005-09-06 | Computer managing system for large scale telecommunication enterprise |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN1750038A true CN1750038A (en) | 2006-03-22 |
Family
ID=36605470
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CNA2005100294260A Pending CN1750038A (en) | 2005-09-06 | 2005-09-06 | Computer managing system for large scale telecommunication enterprise |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN1750038A (en) |
Cited By (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN100426301C (en) * | 2006-12-31 | 2008-10-15 | 华为技术有限公司 | Portal analysis system and method for implementing portal analysis service |
| CN101355471B (en) * | 2007-07-27 | 2011-05-11 | 中国电信股份有限公司 | Method and system for forming user database of telecom wideband application |
| CN102622552A (en) * | 2012-04-12 | 2012-08-01 | 焦点科技股份有限公司 | Detection method and detection system for fraud access to business to business (B2B) platform based on data mining |
| CN102693307A (en) * | 2012-05-24 | 2012-09-26 | 上海克而瑞信息技术有限公司 | Website user access behavior recording and analyzing system |
| CN106874353A (en) * | 2016-12-28 | 2017-06-20 | 合肥智畅信息科技有限公司 | A kind of manipulation type business intelligence application system |
| CN107679917A (en) * | 2017-10-17 | 2018-02-09 | 京北方信息技术股份有限公司 | Precision Marketing Method, device, equipment and storage medium based on data processing |
-
2005
- 2005-09-06 CN CNA2005100294260A patent/CN1750038A/en active Pending
Cited By (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN100426301C (en) * | 2006-12-31 | 2008-10-15 | 华为技术有限公司 | Portal analysis system and method for implementing portal analysis service |
| CN101355471B (en) * | 2007-07-27 | 2011-05-11 | 中国电信股份有限公司 | Method and system for forming user database of telecom wideband application |
| CN102622552A (en) * | 2012-04-12 | 2012-08-01 | 焦点科技股份有限公司 | Detection method and detection system for fraud access to business to business (B2B) platform based on data mining |
| CN102693307A (en) * | 2012-05-24 | 2012-09-26 | 上海克而瑞信息技术有限公司 | Website user access behavior recording and analyzing system |
| CN106874353A (en) * | 2016-12-28 | 2017-06-20 | 合肥智畅信息科技有限公司 | A kind of manipulation type business intelligence application system |
| CN107679917A (en) * | 2017-10-17 | 2018-02-09 | 京北方信息技术股份有限公司 | Precision Marketing Method, device, equipment and storage medium based on data processing |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| Yeoh et al. | Critical success factors for business intelligence systems | |
| US20130346146A1 (en) | Universal Customer Based Information and Ontology Platform for Business Information and Innovation Management | |
| CN1347529A (en) | Method for visualizing information in data warehousing environment | |
| CN108764610B (en) | Standard process engineering project construction management method based on big data and storage medium | |
| CN1967579A (en) | Aid excavating analysis system of financial risk management | |
| CN1750038A (en) | Computer managing system for large scale telecommunication enterprise | |
| CN108763490A (en) | A kind of patent information management analysis system | |
| CN110765248A (en) | Intelligent consulting service platform for small and medium-sized enterprises based on cloud computing | |
| CN106874373A (en) | A kind of implementation method of the electric network data asset management platform based on SOA | |
| CN1751288A (en) | Horizontal enterprise planning in accordance with an enterprise planning model | |
| CN107123047A (en) | The data collecting system and its collecting method merchandised based on bond | |
| CN1918590A (en) | Using technical performance metrics for business and usage analysis and cost allocation | |
| CN116089495A (en) | Self-service analysis platform based on big data | |
| CN1777901A (en) | Cascaded planning of an enterprise planning model | |
| US20070239587A1 (en) | System and Method For Dynamically Utilizing and Managing Financial, Operational, and Compliance Data | |
| CN1932868A (en) | Postal intelligent moving marketing system | |
| CN1889488A (en) | Intraconnection network structure and method for establishing intraconnection network | |
| CN103455556B (en) | Memory cell data method of cutting out | |
| CN113094621B (en) | Internet public opinion cloud platform | |
| CN1588405A (en) | Data processing device and method for risk control system | |
| Kong et al. | An analytical CRM based on customer knowledge | |
| TW201947492A (en) | System and method for operational data convergence | |
| CN1534523A (en) | Integrated selling system and its method | |
| CN1601538A (en) | Prodn plan management method and prodn, plan mangement programme | |
| CN1617146A (en) | Deparatment personal work attendance checking system and method |
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 |
Open date: 20060322 |