Summary of the invention
The objective of the invention is to propose a kind of TV user data management method, can realize the unified management of simulated television user and digital cable customers, adapt to the development trend of integration of three networks management.
For reaching this purpose, the present invention by the following technical solutions:
A kind of TV user data management method may further comprise the steps:
A, set up simulated television user and unified user model, product model and the account model of digital cable customers, form the TV user management system;
B, simulated television user data and digital cable customers data are input in the database of TV user management system;
C, finish the conversion of simulated television user to the conversion of digital cable customers or digital cable customers to the simulated television user, and the data of simulated television user's data and digital cable customers in the renewal TV user data management system.
Further comprising the steps of:
For the simulated television user, simulated television user worker list in the call center management system and the simulated television user worker in the operation support system singly carry out bi-directional synchronization.
Described user model comprise user, analog/digital, signal condition, turn over sign, town and country attribute, arrearage type, discount type, credit rating grade, account, user's major types, user's subtype, service, Domain Properties and sub-headend attribute.
Described product model comprise product, analog/digital, turn over sign, user, user type, Domain Properties, first product, product line, tariff policy and basic/optional attribute.
Described account model comprises subscriber's account, analog/digital, rent machine expense, simulation system arrearage, removal cost, license fee, program request expense, machine card selling charges, spare and accessory parts expense, VOD expense, intermediary service expense, reports the loss expense, terminal expense, depreciation cost, newspaper are opened expense, transfer fee, cash pledge, set-top box occupancy and network operation and taken attribute.
The database that the simulated television user data is input to the TV user management system further may further comprise the steps:
From the database of simulated television Subscriber Management System, extract the data that need, export as txt format text file according to described user model, product model and account model;
By FTP described txt file is loaded under the assigned catalogue of database place server of described TV user management system;
Described txt file is mapped as the database external table of described TV user management system;
Read the simulated television user data one by one from described external table, import to the database of described TV user management system;
After importing was finished, described TV user management system was reached the standard grade, and described simulated television Subscriber Management System life cycle finishes.
After reading described simulated television user data one by one from described external table, carry out Data Audit;
Audit is not passed through, the record problem data, and read the simulated television user data again, audit is passed through, whether the database of judging described TV user management system has existed described simulated television user data, if exist, then upgrades described simulated television user data, if there is no, then import to the database of described TV user management system.
The management that the simulated television user is converted to digital cable customers further may further comprise the steps:
Judge simulated television user's signal condition;
If newspaper stops, then handle newspaper and stop logical;
If defaulting subscriber is then handled arrearage and is led to, examines group's list again, constructs, and finishes receipt;
If not enabled is then handled open-minded;
If normal, then judge whether arrearage, if arrearage, then finish and pay dues and close account, if not arrearage, then carry out equipment dispensing and user type conversion, if success, if then basic service change unsuccessful, then returned the last page and is provided information.
The management that digital cable customers is converted to the simulated television user further may further comprise the steps:
Judge whether digital television service stops,, then stop digital television service,, then judge whether arrearage of digital cable customers,,, then return the machine card, collect depreciation cost if there is not arrearage if arrearage is then paid up in arrearage if stop if do not stop;
Judge whether cancellation of digital cable customers, if cancellation then settle accounts and cancellation, if not cancellation is then carried out the user type conversion, is carried out service change, adjusts rate and account clearing according to product model.
Adopt the http protocol mode to carry out simulated television user worker list synchronously between call center management system and the operation support system.
Adopt technical scheme of the present invention, had following beneficial effect:
1, simulated television user and digital cable customers unified management adapt to the development trend that the integration of three networks is managed.Set up the unified bottom data model of simulated television user and digital cable customers, former simulation TV user complete information and former digital cable customers are imported in the new TV user management system, carry out unified management, use same set of mechanism, personnel and facility, be convenient to statistic of classification and unified management financially, charging and clearing, get rid of account disunity, clearing and operational inconvenient problem, simultaneously database table has been expanded integration of three networks business fields such as can extending to broadband and IP charging easily a little.
2, turn over is carried out in digital cable customers and simulated television user's mutual conversion in same system, realize the seamless cutover of simulated television user and digital cable customers, and classification is chargeed according to translation type, and the account structure is distinct, does not disturb mutually.
3, the data sync of realization and call center, standardized customer service is provided, by with the Data synchronization interface of call center, the customer service of conformance to standard externally is provided, help increasing customer satisfaction degree, also network, monitor and follow-up innovative approach is provided convenience from netted condition, to improve the whole conversion ratio of Digital Television for analysis user.
Embodiment
Further specify technical scheme of the present invention below in conjunction with accompanying drawing and by embodiment.
The main thought of technical solution of the present invention is at the similarities and differences of simulated television user and digital cable customers, bottom data model such as unified user, product, account and service management, charging, financial management framework are proposed, for digital cable customers and simulated television user's unified network registration, inquiry, statistics, data change, customer service, adapter former simulation TV user account balance and historical arrearage bill provides may.
Solve the synchronous and transplanting problem of former simulation TV user Management System Data simultaneously, former arrearage or advance deposit need not to move back earlier family clearing, reimbursement, step such as open an account again when turn over, can finish identity conversion, charging regulation adjustment, service change between simulated television user and the digital cable customers in a cover system.
Newspaper to former simulation TV user management system stops, report open, business such as defaulting subscriber management, subscriber signal state recording, the management of worker's single current provides comprehensive support; unified all kinds of intermediary services are taken account management, solve the problem of detached island of information that exists between the call center (customer service department) and the sales department Room (market department) by management of worker's single current and the single simultaneous techniques of worker.
Wherein highly abstract and uniform data model is the basis, level and smooth the commentaries on classics mutually between the data sync of simulated television Subscriber Management System and transplanting, simulated television user and the digital cable customers is means, further embodied the value of thought customer-centric synchronously with the data double-way of client service center.
Fig. 1 is the process flow diagram of TV user data management in the specific embodiment of the invention.As shown in Figure 1, this TV user data management process may further comprise the steps:
Step 101, set up simulated television user and unified user model, product model and the account model of digital cable customers, form the TV user management system.
For simulated television user and the unified user model of digital cable customers, owing to there are some differences between simulated television user and the digital cable customers:
The difference of fees policy, national and local relevant policies have been formulated different expenses standards to digital cable customers with the simulated television user, the simulated television user charge of turn over area also is different from the not expenses standard in turn over area, while needs to distinguish the town and country attribute owing to tax revenue standard and rate rate is different.
Difference on the user property, for supporting above-mentioned expenses standard, whether the turn over state need be distinguished by special sign.Be used for designation number TV user, simulated television user and digital revolving die according to the corresponding increase attribute of expenses standard and intend TV user, report and stop not moving back the machine user, in order to distinguish charging regulation.
Difference on the business form, digital cable customers turns on and off by Entitlement Management Message control user TV signal, and can operate at the single terminal in a plurality of terminals that it had; And the simulated television user need turn on and off by the unification that indoor terminal is carried out in the construction of outdoor incoming end.Indicate that by signal condition signal condition is at the user, rather than at terminal.According to the business form, with signal condition be divided into that newspaper stops, several classes such as defaulting subscriber, not enabled, normal, cancellation.
Therefore user model comprise user, analog/digital, signal condition, turn over sign, town and country attribute, arrearage type, discount type, credit rating grade, account, user's major types, user's subtype, service, Domain Properties and sub-headend attribute attribute.
For simulated television user and the unified product model of digital cable customers, for the simulated television service is provided, product model comprise product, analog/digital, turn over sign, user, user type, Domain Properties, first product, product line, tariff policy and basic/optional attribute.Wherein the analog/digital attribute has comprised in netting index word TV user, net simulated television user, simulated television user, the newspaper in turn over area stop not moving back the machine user, by related with the mapping of product model, make the user of different regions, different attribute, different user types present corresponding service at the service order interface, be unlikely to cause and obscure, enter an item of expenditure in the accounts according to charging regulation simultaneously on schedule.
The user region is a tree-like hierarchical structure, and the management granularity can be disposed by the user.The turn over sign hangs on certain one-level leaf node of attribute structure, can be related with which rank of according to the scale decision of a turn over, and as hanging on the nodes such as optical node, sub-headend or sub-district.
For simulated television user and the unified account model of digital cable customers,, increased the big class of intermediary service account for the subscriber arrearage information of the former simulation of transplanting system and continuing smoothly of original payment relation smoothly.Principle is general license fee, machine card selling charges, spare and accessory parts expense, vod license fee, program request expense and the rare change of the expense of handing in retroactively thereof, can be used as standard configuration manages, and intermediary service expense going deep into along with operation, expansion with channel, possible alters a great deal, and therefore lists a big class separately and is managed.It is the relation of one-to-many with the relation of hanging sub-account down, be convenient to the newly-increased account type of business (is comprised that terminal mounting cost, newspaper stop newspaper and open expense, machine card depreciation cost, the arrearage of former simulation system etc., but be not limited only to illustrated type) unified management, and support other possible in the future professional newly-increased intermediary service account management.Intermediary service account type can be disposed voluntarily, increase or be deleted by the user under the prerequisite of not changing database structure, has improved professional expandability.Therefore the account model comprises subscriber's account, analog/digital, rent machine expense, simulation system arrearage, removal cost, license fee, program request expense, machine card selling charges, spare and accessory parts expense, VOD expense, intermediary service expense, reports the loss expense, terminal expense, depreciation cost, newspaper open expense, transfer fee, cash pledge, set-top box occupancy and network operation and take attribute.
Step 102, simulated television user data and digital cable customers data are input in the database of TV user management system.
The rule that the simulated television user data is input to the database of TV user management system is: derive client, user, account, business and account information from former simulation TV user management system, import the TV user management system.The pass of two cover system cutovers is S-F (beginning-ending a relatiohship).With cutover zero point be cut off.
System's cutover has two kinds of situations, a kind of is during new system trial run, two cover systems may be according to delineation of activities parallel running a period of time, general user's service management such as open an account is still normally carried out at the simulated television Subscriber Management System, the TV user management system is only carried out the management (irrelevant with simulation system) of set-top box and card related service, and the increment that need regularly carry out data this moment is synchronous; Second kind is that two systems successively move, and the time of no cross-coincidence, be loaded into file target database place server assigned catalogue under by FTP by the file that is txt from the disposable derived data form of original system this moment.TV user Management System Data storehouse guarantees that the targeted customer has and has access limit to changing catalogue.Txt file is mapped as TV user Management System Data storehouse external table, and storing process is disposable to import in the empty target database by writing.Detailed process is: extract the data that need according to user model, product model and account model from the database of simulated television Subscriber Management System, export as txt file; By FTP described txt file is loaded under the assigned catalogue of database place server of TV user management system; Txt file is mapped as the database external table of TV user management system; Read the simulated television user data one by one from external table, import to the database of TV user management system; After importing was finished, the TV user management system was reached the standard grade, and simulated television Subscriber Management System life cycle finishes.
The key of data input is integrality, accuracy, consistance and the uniqueness of data.Integrality is based upon on the three family models, is guidance with the data model, is that criterion is audited to the input data with TV user management system demand.As former simulation TV user management system the partial data of disappearance is arranged, according to actual conditions by in advance through the default value polishing of authorization, and be that unique benchmark carries out increment and transplants with time on date of opening an account of system log (SYSLOG); Guarantee the accuracy of data by general knowledge and regular verification; As find when transplanting, there has been this user data in the TV user management system, then be as the criterion with nearest data, revise TV user management system system related data according to nearest derived data, guarantee the consistance and the uniqueness of data.The detailed process of data sync is: after reading the simulated television user data one by one from described external table, carry out Data Audit; Audit is not passed through, the record problem data, and read the simulated television user data again, audit is passed through, whether the database of judging the TV user management system has existed described simulated television user data, if exist, then upgrades the simulated television user data, if there is no, then import to the database of TV user management system.
Step 103, when changing between simulated television user and the digital cable customers, to finish the conversion of simulated television user earlier, upgrade the data of simulated television user's data and digital cable customers in the TV user data management system again to the conversion of digital cable customers or digital cable customers to the simulated television user.
Wherein the simulated television user be converted to the rule of digital cable customers be divided into new digital cable customers open an account and former simulation TV user transfer two kinds of situations of digital cable customers to, original when net simulated television user is converted to digital cable customers for system, still pressed the mock standard charge this month; Digital cable customers to new networking, can charge according to waning moon when digital services is opened and (before 15 days every month, change, then of that month by digital expenses standard charging, 16 days and after before 25 days turn over press first quarter moon and charge, turn over was still charged by analogue television standards this month after reaching in 26th, and waning moon cut-off date point is configurable).Turn over was all pressed the Digital Television expenses standard in inferior month and is chargeed.
The flow process that the simulated television user is converted to digital cable customers is:
Judge simulated television user's signal condition;
If newspaper stops, then handle newspaper and stop logical;
If defaulting subscriber is then handled arrearage and is led to, examines group's list again, constructs, and finishes receipt;
If not enabled is then handled open-minded;
If normal, then judge whether arrearage, if arrearage, then finish and pay dues and close account, if not arrearage, then carry out equipment dispensing and user type conversion, if success, if then basic service change unsuccessful, then returned the last page and is provided information.
The rule that digital cable customers is converted to the simulated television user is that execution machine card return of goods rule is checked, as whether not stopping digital services, if any the bill of not paying, then expense is paid up in prompting earlier.Service stopped immediately when the numeral revolving die was intended, but simulating signal do not turn-off, still need to collect the network operation expense, user type is converted to the simulated television user simultaneously.For this type of user,, can only watch limited several covers simulation television channels, so rate are different with the latter owing to compare with the area of turn over not user.
The flow process that digital cable customers is converted to the simulated television user is:
Judge whether digital television service stops,, then stop digital television service,, then judge whether arrearage of digital cable customers,,, then return the machine card, collect depreciation cost if there is not arrearage if arrearage is then paid up in arrearage if stop if do not stop;
Judge whether cancellation of digital cable customers, if cancellation then settle accounts and cancellation, if not cancellation is then carried out the user type conversion, is carried out service change, adjusts rate and account clearing according to product model.
Step 104, for the simulated television user, the simulated television user worker in the single and operation support system of simulated television user worker in the call center management system singly carries out bi-directional synchronization.Adopt the http protocol mode to carry out simulated television user worker list synchronously between call center management system and the operation support system.
Another difference part of simulated television user and digital cable customers management is: digital cable customers carries out subscriber authorisation by conditional access system, comprise open, issuing all by the Cable Network network of Entitlement Management Message such as shutoff directly be issued to set-top box in the user family, set-top box receives the instruction back and carries out corresponding actions.But the simulated television user does not have two-way return path, complain the newspaper barrier the most efficiently means be by the customer service phone, its signal open, turn-off all needs to distribute the worker single, could realize after constructing.The single business department that is correlated with that handles of worker comprises market department, Customer Service Department, engineering department etc., the inlet of the single input of worker has business hall, Customer Service Department call center, need to realize worker's list registration, remove list, examine, cancel the order, send a series of management processes such as list, clearing, receipt.
The worker singly has two inlets: i.e. call center and business hall, overlapping independently by call center management system and operation support system two respectively, system manages.Wherein professional worker singly handles in each link in customer service and generates automatically.If both do not keep synchronously, then business hall operator and call center operator can only see the worker's list and the state thereof of we's registration, and can't see the worker's list and the state of the other side's registration.For this reason, need to increase the synchronous device between call center and the business hall infosystem, i.e. the single synchronous gateway of worker, worker's single-passes of different inlet registrations are crossed sign and are distinguished, the unified subsequent treatment of carrying out.State synchronization such as this synchronous device can be realized registration single or in batches user worker's list and group list, receipt, removes list, cancels the order, settles accounts, audit.Be to improve single efficient and the performance of group in batches, adopt http protocol to carry out the bi-directional synchronization of worker's list, the additions and deletions that comprise data are looked into and operation such as are changed.
The above; only for the preferable embodiment of the present invention, but protection scope of the present invention is not limited thereto, and anyly is familiar with the people of this technology in the disclosed technical scope of the present invention; the variation that can expect easily or replacement all should be encompassed within protection scope of the present invention.Therefore, protection scope of the present invention should be as the criterion with the protection domain of claim.