CN101242299A - Networking method for data hinge-service supporting system - Google Patents

Abstract

The invention provides a data hub-business support system networked method, which has an N+1 architecture, comprising: firstly, storing subscriber data of each presidial city in N node databases, incrementally copying the subscriber data list and client data distributed in N node databases to a hub database by database technology every fifteen minutes, establishing a global subscriber data list and client data map, and storing the cross-area service data in a hub database; secondly, rapidly and linearly increasing node dilatancy by configuration control by a function actualization system for transferring the hub database of a net copy relation to a simple star relation; and thirdly, establishing a uniform client data management platform and a data supply center by a hub database, and actualizing a foreign subscribe and issuance according to need by a uniform interface of the hub database.

Description

Data hinge-business support system networking method

Technical field

The invention belongs to the Information System configuration field of common carrier.What relate to is the technology implementation method of a kind of architecture that adopts in Information System configuration and data management, with the level and smooth autgmentability of raising system, reliability, data sharing and SM.These innovation and creation can directly apply to the construction field of each common carrier to its business operation support system, also can further be generalized to the construction field of the large-scale IT system of industries such as bank, electric power, insurance.

Background technology

1, the BOSS of China Mobile Jiangsu company (business operation support system) system support 3,000 ten thousand mobile subscribers, 20,000 salesperson terminals, 2800 self-service printers and self-recharging terminal, day is handled 3.5 hundred million of tickets, accept professional 4,000,000 day, be the important assurance of the service of producing, become one of core competence of enterprises.Present subdivision city of BOSS system is deployed in the architecture of 4 databases, when the follow-up business amount increases, is about to reach the capacity support bottle footpath in each storehouse, can't support by the equipment dilatation, needs the innovation of other means to promote enabling capabilities.

2, phenomenon that stability reduces day by day appears progressively also that single storehouse supporting user amount arrives that bottle footpath and single storehouse traffic carrying capacity increase and in the business support system of other province companies such as China Mobile Guangdong, Zhejiang, presses for solution.

3, because the Chinese population radix is huge, mobile phone user's number of a province just surpasses mobile phone user's number of most external countries, and China Mobile has mobile phone user 300,000,000, has been the telecom operators of global userbase maximum.So the business operation support system of external telecom operators mostly adopts single library structure, its scale and complexity will need domestic telecommunication operator to make positive exploration and innovation far below the business operation support system of China Mobile.

Summary of the invention

In order to remedy the deficiencies in the prior art, the present invention proposes " data hinge--business support system networking method ", may further comprise the steps:

Step 1, all data such as Subscriber Number, bill information, tariff package, business function are left in respectively in the individual node database of N (N＞=2) according to different cities under the user;

Step 2, set up 1 hinge database;

Step 3, will be dispersed in N user information table, the customer data table in the node database and copy in the hinge database, set up user information table, the customer data table view of the overall situation by database technology;

Step 4, transregional business datums such as transregional card even numbers, a transregional group, transregional Familiarity Number are left in the hinge database;

Step 5: connect N node database and 1 hinge database in application server deploy intermediate application program; The intermediate application program that externally provides on the access server on the access service of the final service program connection application server is provided;

Step 6, when the user handles the transregional complicated business that is not to comprise in the step 4, behind the input handset number (or passport NO.), routing selecting module is the subscriber data (or customer data) of this locality of inquiry local node database earlier, as inquires and then return the home node database and be numbered the local node database; As local search less than, then be connected to the hinge data base querying more automatically and duplicate the overall subscriber data of forming (or customer data) by each node database, and return phone number (or passport NO.) real correspondence deposit home node database numbering.Forward step 8 to.

Step 7, in the user handles be the transregional complicated business that comprises in the step 4 time, then hinge database numbering is returned as home node database numbering.

Step 8, the home node database numbering of returning according to step 6, mid-tier application is routed automatically to corresponding node database and carries out the data modification operation according to the service logic of user applies, finishes the opening an account of user applies, supplements with money, business such as business change; Or the home node database that returns according to step 7 numbering, mid-tier application is routed automatically to the hinge database, finishes the data modification work of transregional complicated business.

Above-mentioned " data hinge one business support system networking method ", it is further characterized in that the N+1 architecture:

1, passes through the use of N node database, make the reliability of system improve greatly, factor is according to dividing on N node database by districts and cities, so single node handling property height, guarantee simultaneously when hardware and software failure and System Expansion adjustment appear in a certain node, can not have influence on the business of districts and cities that other nodes are born.Schematic diagram is seen Fig. 1.

2, owing to increased by 1 hinge storehouse, the netted data of N node are duplicated the interactive relation deletion, becoming N node only exchanges with the hinge storehouse, when traffic carrying capacity increases from now on, only need to be deployed in intermediate application program on the application server and to increase newly and be connected to new node database and get final product by adjusting configuration (not needing update routine), can in a week, finish the increase of new node database and the application work of reaching the standard grade, solve the great difficult problem of the linear fast lifting difficulty of support capacity that present each operator generally runs into.Schematic diagram is seen Fig. 2, Fig. 3 and Fig. 5.

3, expand the hinge database function, make it become unified customer information management platform and the exchanges data and the supply center of the overall situation, realize in time comprehensive and accurate the subscription as required and issue as required, and to what platform of each information source of external shield, physical structure how, deposit position etc.Schematic diagram is seen Fig. 4 and Fig. 6.Concrete steps are as follows:

A) by the hinge database, realize customer data (comprising customer data, bill information, inventory information, dream net order relations, historical act information etc.) global view, set up unified customer information management platform;

Other systems such as b) performance analysis, 10086 customer services can be subscribed to by the unified subscribing interface that the hinge database provides;

C) the hinge database extracts and combined information according to the subscription demand of peripheral system from each node database and other database roots by self unifying extraction module;

D) the hinge database satisfies the subscription demand by the information of extraction of system's issue to the periphery of unified issuing interface and combination.

Beneficial effect of the present invention:

" data hinge--the business support system networking method " of the invention has following four beneficial effects:

1, the N+1 data base architecture of Chuan Xin large-scale IT system, effectively solved the difficult problem of linear lifting of large-scale IT system capacity and high stability, but guaranteed the high stability and the linear smoothing dilatation of system, and extended to the large-scale IT system of other industries such as other province exempted dealerses, the tax in the group.

2, set up unified customer information management platform, realize subscribing to as required.Realize the customer data global view, other system can simply, accurately, in time extract information needed by the hinge storehouse, need not to know be thereafter what platform, physical structure how, deposit position etc., guaranteed comprehensive, consistency, promptness and the fail safe of data consumption.

3, fast and flexible supports trans-city inside the province and domestic complicated business transprovincially.To stride complicated business such as ground Familiarity Number, cornet group, deposit on the hinge storehouse as the whole province's shared data; The hinge storehouse is as external unified interface, and the service request of transprovincially handling such as card of paying the fees, change all unify to be submitted to the hinge storehouse, is distributed to the database of target province or this province correspondence by it.

4, pass through the use of N+1 architecture, for the IT support system provides strong guarantee to carrier class and web development.

The use of this technology makes and can improve greatly by configuration adjustment increase node quick and smooth dilatation and business support system stability, the mean failure rate duration was reduced to annual 0.6 hour by original every month 1 hour, and further save equipment investment, the direct and indirect economic effect that brings is about annual 1003 ten thousand yuan; And the fast and flexible that can support transregional business is released, the unified safety management of BOSS data, guaranteed professional and served to take the lead, in the client, further set up simultaneously the image of China Mobile's good service, more improved users' satisfaction and loyalty, further made the leading superiority of business supporting network become one of core competitiveness of China Mobile.

Description of drawings

Fig. 1 develops progressive figure for business support system architecture in the embodiment of the invention;

Fig. 2 is the system assumption diagram of N+1 in the embodiment of the invention;

Fig. 3 is system linear quick and smooth dilatation figure in the embodiment of the invention;

Fig. 4 is a unified customer data platform schematic diagram in the embodiment of the invention;

Fig. 5 is a business support system intermediate application layer schematic diagram in the embodiment of the invention;

Fig. 6 orders and data issue flow chart as required for data in the embodiment of the invention.

Embodiment

Below in conjunction with drawings and Examples the present invention is further described.

1, the physical Design of hinge database

Database name: hubdb

Instance Name: hubdb1/hubdb2

Memory space: 300G

Memory parameters

Physical memory: 42G, database SGA and PGA parameter are provided with as follows:

Parameter name	Memory size (M)
		?sga_max_size	?24576
?shared_pool_size	?1536
		?db_cache_size	?20480
?db_keep_cache_size	?2048
		?large_pool_size	?256
?java_pool_size	?32
		?log_buffer	?16
?pga_aggregate_target	?2048
		?db_block_size	?8192
?Processes	?2000
		?job_queue_processes	?30
?db_files	?2000

2, two example hinge databases shares policy selection

The hinge database is a self contained data base, uses ORACLE RAC technology, sets up two examples, can take over mutually, and the responsibility of each example is by the decision of hinge database usage policy, and usage policy is for pressing function sharing.The usage policy of two examples of hinge database has following two kinds:

A. but districts and cities share strategy

The production system types of applications is used two examples of hinge database simultaneously, and according to the present districts and cities of BOSS system database division principle, the example in hinge storehouse is following districts and cities: Nantong, Yangzhou, Taizhou, Yancheng, Nanjing, Xuzhou, Lianyun Harbour; No. two examples in hinge storehouse are following districts and cities: Zhenjiang, Changzhou, Wuxi, Suqian, Huaian, Suzhou.

B. share strategy by responsibility

According to the production system application type, use different hinges storehouse example respectively: OLTP on-line Application such as all middleware servers, Web server are all used the example in hinge storehouse; The process, data synchronized process, database data of entering an item of expenditure in the accounts duplicated, data are subscribed to and BATCH such as issue uses and uses No. two examples in hinge storehouse.

Consider to isolate to the influence of production system OLTP online transaction and the simplicity of application deployment, adopt the strategy of sharing by responsibility.

3, with the irrelevant underlying database reproduction technology of program

Each node database copies to the hinge database with user information table (is keyword with the phone number) and customer data table (is keyword with the passport NO.), by the synthetic unified global view of hinge set of databases, for online professional real time access of OLTP such as opening an account, supplement with money, also the other system for the periphery provides unified visit view.Because what adopt is and underlying database reproduction technology (Materialized View of ORACLE) that program is irrelevant, and make system simple, efficient and stable, and have bigger transportable property and promotional value.

The analysis on Necessity of 4, duplicating

Because the user has jurisdiction over city's transacting business to arbitrary node database, must inquire this user's subscriber data data at any point; When opening an account, need to check whether its identity card is opening an account in other storehouses; Inquire its ownership place when pay the fees in the strange land earlier, the operation of just will inquiring about and pay the fees then is routed to the ownership storehouse

5, with how many irrelevant intermediate application layer automatic routing technologies of node

When the mobile subscriber handle be not transregional complicated business such as card even numbers, a transregional group, transregional Familiarity Number the time, behind the input handset number (or passport NO.), routing selecting module is the subscriber data (or customer data) of this locality of inquiry local node database earlier, as inquires and then return the home node database and be numbered the local node database; As local search less than, then be connected to the hinge data base querying more automatically and duplicate the overall subscriber data of forming (or customer data) by each node database, and return phone number (or passport NO.) real correspondence deposit home node database numbering.

In the user handles be transregional complicated business such as card even numbers, a transregional group, transregional Familiarity Number in this way the time,, then hinge database numbering is returned as home node database numbering.

The intermediate application layer is provided with automatic routing function, and the home node database numbering according to routing selecting module returns is routed to service request corresponding database automatically, finishes accordingly and opens an account, supplements with money or transregional business operation.

6, with the irrelevant fast linear smooth expansion technology of application

Owing to automatically select possessing of routing function, when subsequent user amount and professional quantitative change are big, increase node database and do not need to revise and use; Owing to increased by 1 hinge storehouse, the netted data of N node are duplicated the interactive relation deletion, become N node and only exchange with the hinge storehouse, greatly reduce the complexity of system, become netted interactive relation and be star-like relation.More than two advantages concrete, make when subsequent user amount and traffic carrying capacity increase, only need to be deployed in intermediate application program on the application server and to increase newly and be connected to new node database and get final product by adjusting configuration (not needing update routine), can in a week, finish the increase of new node database and the application work of reaching the standard grade, solve the great difficult problem of the linear fast lifting difficulty of support capacity that present each operator generally runs into

6, set up unified customer data platform technology

By setting up the hinge storehouse, realize customer data (comprising customer data, bill information, dream net order relations etc.) global view, other system can simply, accurately, in time extract information needed by the hinge storehouse, need not know be thereafter what platform, physical structure how, deposit position etc.

7, subscription and distribution technology as required as required

Through minute, other system such as customer service as required, can be by unified interface and uniform data bus subscription data, by unified customer data platform according to system resource by in real time, mode such as timing issues as required, assurance promptness and fail safe also effectively reduce system load.

8, the quick support technology of transregional business

Support trans-city inside the province complicated business, support inside the province complicated business such as strange land Familiarity Number, trans-city cornet group, it is deposited on the hinge storehouse as the whole province's shared data; The trans-city business such as paying the fees, change card of handling is pleaded and is all unified to submit to pivot pivot storehouse, is distributed to object library by the hinge storehouse, and system configuration is simply clear.

Support domestic complicated business transprovincially, with trans-city business is the same inside the province, the data of complicated business such as group are transprovincially all left on the hinge storehouse; The hinge storehouse is as external unified interface, and the service request of transprovincially handling such as card of paying the fees, change all unify to be submitted to the hinge storehouse, is distributed to the storehouse of target province or this province correspondence by it.

" a bit release the whole network operation ", by the support in hinge storehouse, the new business that districts and cities (province) release, the whole province (state) all can use convenient

Though the present invention with preferred embodiment openly as above; but they are not to be used for limiting the present invention; anyly have the knack of this skill person; without departing from the spirit and scope of the invention; from when can doing various variations or retouching, so being as the criterion of should being defined with the application's claim protection range of protection scope of the present invention.

Claims (5)

1, a kind of data hinge--the business support system networking method may further comprise the steps:

Step 1, all data such as Subscriber Number, bill information, tariff package, business function are left in respectively in the individual node database of N (N＞=2) according to different cities under the user;

Step 2, set up 1 hinge database;

Step 3, will be dispersed in N user information table, the customer data table in the node database and copy in the hinge database, set up user information table, the customer data table view of the overall situation by database technology;

Step 4, transregional business datums such as transregional card even numbers, a transregional group, transregional Familiarity Number are left in the hinge database;

Step 5: connect N node database and 1 hinge database in application server deploy intermediate application program; The intermediate application program that externally provides on the access server on the access service of the final service program connection application server is provided;

Step 6, when the user handles the transregional complicated business that is not to comprise in the step 4, behind the input handset number (or passport NO.), routing selecting module is the subscriber data (or customer data) of this locality of inquiry local node database earlier, as inquires and then return the home node database and be numbered the local node database; As local search less than, then be connected to the hinge data base querying more automatically and duplicate the overall subscriber data of forming (or customer data) by each node database, and return phone number (or passport NO.) real correspondence deposit home node database numbering; Forward step 8 to;

Step 7, in the user handles be the transregional complicated business that comprises in the step 4 time, then hinge database numbering is returned as home node database numbering.

Step 8, the home node database numbering of returning according to step 6, mid-tier application is routed automatically to corresponding node database and carries out the data modification operation according to the service logic of user applies, finishes the opening an account of user applies, supplements with money, business such as business change; Or the home node database that returns according to step 7 numbering, mid-tier application is routed automatically to the hinge database, finishes the data modification work of transregional complicated business.

2, according to the described data hinge of claim 1--business support system networking method, it is characterized in that, the general architecture of business support system is the N+1 architecture, make system reliability significantly improve an order of magnitude, the fault duration was reduced to annual 0.6 hour by average every month 1 hour, was specially:

Use by N node database, make the reliability of system improve greatly, factor is according to dividing on N node database by districts and cities, so single node handling property height, guarantee simultaneously when hardware and software failure and System Expansion adjustment appear in a certain node, can not have influence on the business of districts and cities that other nodes are born.

3, according to the described data hinge of claim 2--business support system networking method, it is characterized in that it also provides a kind of fast linear smooth expansion method, particularly, owing to increased by 1 hinge storehouse, the netted data of N node are duplicated the interactive relation deletion, becoming N node only exchanges with the hinge storehouse, when traffic carrying capacity increases, by adjusting configuration, be connected to new node database with the intermediate application program on the application server of being deployed in is newly-increased, in the increase of new node database and the application work of reaching the standard grade.

4, according to the described data hinge of claim 1--business support system networking method, it is characterized in that, it comprises that also a kind of unified customer information management and data are subscribed to as required and dissemination method as required, promptly by expanding the hinge database function, make it become unified customer information management platform and the exchanges data and the supply center of the overall situation, realize in time comprehensive and accurate the subscription as required and issue as required, and to what platform of each information source of external shield, physical structure how, deposit position etc., idiographic flow is as follows:

A) by the hinge database, realize customer data (comprising customer data, bill information, inventory information, dream net order relations, historical act information etc.) global view, set up unified customer information management platform;

Other systems such as b) performance analysis, 10086 customer services can be subscribed to by the unified subscribing interface that the hinge database provides;

C) the hinge database extracts and combined information according to the subscription demand of peripheral system from each node database and other database roots by self unifying extraction module;

D) the hinge database satisfies the subscription demand by the information of extraction of system's issue to the periphery of unified issuing interface and combination.

5, according to the described data hinge of claim 1--business support system networking method, it is characterized in that, the fast and flexible professional to trans-city (province) supports, support trans-city inside the province complicated business, support inside the province complicated business such as strange land Familiarity Number, trans-city cornet group, it is deposited on the hinge storehouse as the whole province's shared data; The trans-city business such as paying the fees, change card of handling is pleaded and is all unified to submit to the hinge storehouse, is distributed to object library by the hinge storehouse;

Support domestic complicated business transprovincially, with trans-city business is the same inside the province, the data of complicated business such as group are transprovincially all left on the hinge storehouse; The hinge storehouse is as external unified interface, and the service request of transprovincially handling such as card of paying the fees, change all unify to be submitted to the hinge storehouse, is distributed to the storehouse of target province or this province correspondence by it.

Images