KR20030003402A - A subscriber information management method using Telco user information - Google Patents

Abstract

1. TECHNICAL FIELD OF THE INVENTION

The present invention relates to a method for managing subscriber information of another operator using subscriber information of a telecommunication company and a computer-readable recording medium having recorded thereon a program for realizing the method.

2. The technical problem to be solved by the invention

The present invention is to use subscriber information of a telecommunication company to accurately maintain subscriber information of another operator or to notify other operators of subscriber information inaccuracy, thereby minimizing the loss of costs incurred from incorrect information. To provide a method of managing information and a computer-readable recording medium having recorded thereon a program for realizing the method.

3. Summary of Solution to Invention

The present invention provides a method for managing subscriber information of another operator in a database management system, comprising: comparing subscriber information of a telecommunication company and subscriber information of a management object (company or individual) to establish a matching subscriber information database to establish a management subscriber information database; step; When a change is made to the record included in the management subscriber information database, the management subscriber information database is found and the subscriber information change record is compared with the subscriber information record matching the subscriber information change record in the management subscriber information database. To update the changes; And a third step of delivering to the management object a management subscriber information database created through the updating process of the second step.

4. Important uses of the invention

The present invention is used for managing other subscribers information.

Description

A subscriber information management method using Telco user information}

The present invention uses subscriber information of a telecommunication company to accurately maintain subscriber information of another operator or to inform other operators of subscriber information inaccuracy, thereby minimizing the loss of costs incurred from incorrect information. A method and a computer readable recording medium having recorded thereon a program for realizing the method.

Currently, companies or individuals mostly use telephone or mail as a means of marketing for their marketing activities (delivering product information, issuing billing receipts, birthday telegrams, etc.). In this case, if you do not have accurate subscriber information (phone number and address, etc.), you will send the information to the wrong place and pay the wrong cost. This results in a loss of revenue opportunities. In addition, unlike in the past, the sales portion of the telecom sales is increasing in sales techniques, and telephone or mail are important marketing tools such as credit card companies, insurance companies, mail service companies, department stores, sports centers, car dealers, and insurance workers. As more companies and individuals are using it, it is very important to maintain accurate subscriber information. However, as mentioned above, companies and individuals do not have a systematic method for accurately maintaining their subscriber information. It is a reality to manage subscriber information using.

Conventional methods used to accurately maintain subscriber information include first calling a different contact number in the subscriber information, such as a company phone number or a mobile phone number, to confirm the address, telephone number, or the like. If you can't find it, you can find out how the old phone number was changed through the new and old number service of 114, or check the address transfer record of the office if the old and new number service is not possible.

However, these methods require extra time and money to check through different phone numbers to determine whether the information is accurate for the first method, and the time for using the 114 new number service for the second method. The cost is added to the first method (especially the old and new number service has a 6 month period, and there is an attribute that may not be able to find accurate information after 6 months or if it has changed several times within 6 months). In the case of using a realistic and difficult to use even if you use too much cost and time is a problem.

In addition, one of the most important problems is that one must send a call or mail once because the subscriber information is not known in advance or incorrect. In other words, there is no way to pre-filter out things that are likely to have changed or were originally recorded incorrectly (e.g., when a subscriber recorded their information incorrectly). It is likely that you will send the wrong message. Another problem is that in the case of mail, even if the address is incorrectly described, if the return is not possible, that is, the information mismatch is not known for a long time unless the registration or confirmation of the recipient is performed.

Therefore, it is essential to use the subscriber information of the telecommunication company to accurately maintain the subscriber information of other operators or to inform other operators of the fact that the subscriber information is inaccurate, thereby minimizing the loss of costs incurred from the inaccurate information. Required.

The present invention has been proposed in order to meet the above-described demands, and accurately maintains subscriber information of another operator using subscriber information of a telecommunication company, or informs another operator of the fact that subscriber information is inaccurate, and incorrect information. It is an object of the present invention to provide a method for managing subscriber information of a third-party company for minimizing a loss incurred from a computer and a computer-readable recording medium for recording a program for realizing the method.

1 is an exemplary configuration diagram of a hardware system to which the present invention is applied.

FIG. 2 is a detailed flowchart of an embodiment of an initial construction process of a management subscriber information DB for managing other subscriber information according to the present invention. FIG.

3 is a detailed flowchart illustrating an update process of a management subscriber DB for managing subscriber information of another operator according to the present invention;

4 is a detailed flowchart illustrating a delivery process of a subscriber information DB for management through an update process for managing subscriber information of another operator according to the present invention;

* Explanation of symbols for the main parts of the drawings

11: central processing unit 12: main memory unit

13: auxiliary memory device 14: input device

15: output device 16: peripheral device

In order to achieve the above object, the present invention provides a method for managing subscriber information of another operator in a database management system, wherein the subscriber information of a communication company is compared with the subscriber information of a management object (company or individual) to check whether there is a match, and to check the subscriber information for management. A first step in building a database; When a change is made to the record included in the management subscriber information database, the management subscriber information database is found and the subscriber information change record is compared with the subscriber information record matching the subscriber information change record in the management subscriber information database. To update the changes; And a third step of delivering the management subscriber information database created through the update process of the second step to the management object.

In addition, the present invention provides a database management system having a processor, comprising: a first function of comparing subscriber information of a telecommunication company and subscriber information of a management object (company or individual) to confirm whether there is a match and to construct a management subscriber information database; When a change is made to the record included in the management subscriber information database, the management subscriber information database is found and the subscriber information change record is compared with the subscriber information record matching the subscriber information change record in the management subscriber information database. A second function of updating the changes; And a computer-readable recording medium having recorded thereon a program for realizing a third function of delivering the management subscriber information database created through the updating of the second function to the management object.

The present invention has a large number of subscribers and must continuously deliver information to the subscribers by mail or telephone, but misses information delivery time or tracks subscriber information due to inaccurate subscriber information (address, telephone number, etc.). To companies or individuals who have to pay a lot of money to do so, the subscriber's information before the data is sent, using the subscriber's information of the telecommunications company, which can always maintain the accuracy of the information due to the habit of the subscriber notifying most of his or her change of information. By determining the accuracy in advance and maintaining the subscriber information accurately and consistently, it is intended to drastically reduce the cost loss and marketing opportunity caused by the inaccurate subscriber information, and to reduce the cost and effort to maintain the subscriber information.

To this end, the present invention compares the subscriber information of the telecommunication company and the subscriber information of the company or individual to build an initial subscriber information database (DB), and using the change data when the subscriber change information of the telecommunication company or management company occurs The company's or individual's database of subscriber information can be updated, and the updated information can be communicated to the management company in a variety of ways to minimize the cost of inaccurate information.

The above objects, features and advantages will become more apparent from the following detailed description taken in conjunction with the accompanying drawings. Hereinafter, exemplary embodiments of the present invention will be described in detail with reference to the accompanying drawings.

1 is an exemplary configuration diagram of a hardware system to which the present invention is applied.

As shown in FIG. 1, the hardware system to which the present invention is applied includes a central processing unit 11, a main memory device 12 connected to the central processing device 11, and an auxiliary memory device connected to the main memory device 12. 13, the input / output devices 14 and 15 connected to the central processing unit 11 and the peripheral device 16 connected to the main memory device 12 are provided.

Here, the hardware system, the central processing unit 11 for controlling and managing the overall operation of the computer, the program stored in the central processing unit 11 and stores a variety of data used during or during operation The main memory device 12 and the auxiliary memory device 13 to store, the input and output devices 14 and 15 for input and output data to and from the user, and the peripheral device 16 for a communication interface and the like.

The auxiliary memory device 13 stores a large amount of data, and the input / output devices 14 and 15 include a general keyboard, a display device, and a printer.

However, since the computer hardware environment having the configuration as described above is only a technique well known in the art, detailed description thereof will be omitted herein. However, in the main memory device 12 of the hardware system as described above, the subscriber information of the communication company is compared with the subscriber information of the corresponding company or individual, and an initial management subscriber information database (DB) is constructed, and the subscriber of the communication company or the management company is constructed. When the change information occurs, it updates the subscriber information database for management of the company or individual established by using the change data, and informs the management company of the updated information in various ways, thereby minimizing the loss of costs incurred from inaccurate information. A program (a management subscriber information DB initial construction program, a management subscriber information DB update program, an update information transmission program, etc.) is stored and is performed under the control of the central processing unit 11.

That is, the main memory 12 compares the subscriber information of the telecommunication company and the subscriber information of the company or individual to be managed and checks for a match to create an initial management subscriber information DB. When a change occurs in the record included in the initial management subscriber information DB, the change is updated. Subsequently, the management subscriber information DB, the change history list, and the subscriber non-identification list generated through the updating process are delivered to the management target company.

FIG. 2 is a detailed flowchart illustrating an initial generation process of an administrative subscriber information DB for managing another operator's subscriber information according to an embodiment of the present invention. The subscriber information DB (A) of the company and the subscriber information DB (B) of the communication company are compared to show the process of creating the subscriber information DB (C) for initial management.

First, the subscriber records of the subscriber information DB (B) of the telecommunications company are compared with the telephone number as a key value for each subscriber record of the initial subscriber information DB (A) of the management target company (201). If a record with the same number is found, the name and address of each record of the matching subscriber's initial subscriber information DB (A) and the telecommunication company's subscriber information DB (B) are compared (202).

As a result of the comparison, if the name and address of each record are the same, the matched subscriber information record is stored in the management subscriber information DB (C) (203).

As a result of the comparison, if the name and address of each record do not match, confirmation is required, so the subscriber information record of the initial subscriber information DB (A) of the managed company and the subscriber information DB (B) of the telecommunication company is checked. After storing (204), subscriber confirmation over the telephone (205), if confirmed (206), the record matching the telephone number of the initial subscriber information DB (A) of the confirmed managed company, the subscriber of the communication company It finds in the information DB (B), and puts it into management subscriber information DB (C) (203).

On the other hand, if the comparison result 201, if no match is found, after storing the subscriber information record of the initial subscriber information DB (A) of the management company in the mail list (208), the mail Through the confirmation of the subscriber information through 209, and if it is confirmed (206), the record matching the telephone number of the initial subscriber information DB (A) of the confirmed managed company is found and managed in the subscriber information DB (B) of the communication company. To the subscriber information DB (C) (203).

However, if the subscriber information is not confirmed (206), the subscriber information record of the initial subscriber information DB (A) of the unmanaged management target company cannot be confirmed because it cannot be put in the management subscriber information DB (C). (210).

Through this process, the initial management subscriber information DB (C) is completed from the initial subscriber information DB (A) of the company to be managed and compared with the subscriber information DB (B) of the telecommunication company.

Next, when a change occurs in a record included in the initial management subscriber information DB (C), an update process for the change will be described in more detail with reference to FIG. 3.

FIG. 3 is a detailed flowchart illustrating an update process of a management subscriber information DB for managing another subscriber's subscriber information according to the present invention, in which the initial management subscriber information DB (C) generated in FIG. 2 is included. When a change is made to a record, the procedure for updating the change is shown.

If the subscriber of the telecommunications company changes the phone number, address or personal identification information, and notifies the telecommunications company, the telecommunications company detects the change of the information of the subscriber. In this case, after determining which management target company's subscriber information DB should be updated among the targets managed by the telecommunication company itself, the DB is updated.

First, when a record (b) with a change in subscriber information is received from a subscriber information record registered in the subscriber information DB (B) of the carrier (301), the subscriber information for management to which the subscriber information change record (b) belongs. DB (C) is selected (302).

Thereafter, the telephone number field of each management subscriber information DB (C) is compared with the telephone number of the subscriber information change record (b) (303) to find a record (a) having the same telephone number. That is, by comparing the phone numbers of subscribers of the management subscriber information DB (C) with the phone numbers of the subscriber information change record (b) (303), the subscriber information change record (b) in the management subscriber information DB (C) Find a subscriber information record (a) that matches the telephone number of < RTI ID = 0.0 >

As a result of the comparison, if there is a subscriber information record (a) that matches the telephone number of the subscriber information change record (b) in the management subscriber information DB (C), the subscriber information change record before updating the subscriber information change record (b). The change code of (b) is checked (304).

If the result of the inspection is a simple change such as an address or a telephone number, the record of the management subscriber information DB (C) is changed (C ') to the change record value (305), and the change is stored in the change history list (List). (306). That is, the subscriber information record (a) that matches the telephone number of the subscriber information change record (b) in the management subscriber information DB (C) is updated according to the change of the subscriber information change record (b) to manage the subscriber information DB. After (C ') is made (305), the pre-change record and the post-change record are stored in the change history list (306).

As a result of the inspection, if the change code of the subscriber information change record (b) is a change in which the owner changes, such as a termination or a change of name, it is not possible to simply reflect the change history, so that the two records to be compared, that is, the subscriber information change record (b) ) And the subscriber information record (a) that matches the telephone number of the subscriber information change record (b) in the management subscriber information DB (C) in the change confirmation need list (307) (307), and the subscriber information change record ( b) and in the subscriber information DB (C) for management through the subscriber information confirmation (308) through the phone number of the subscriber information record (a) that matches the telephone number of the subscriber information change record (b) (309), and confirmed (309). ) The record of the management subscriber information DB (C) is changed (C ') to the change record value (305), and the change is stored in the change history list (306).

However, if the subscriber information is not confirmed (309), since it cannot be put in the updated management subscriber information DB (C '), the management subscriber information DB (C) matches the telephone number of the subscriber information change record (b). The subscriber information record (a) is stored in the subscriber information non-confirmation list (310) (310).

On the other hand, there may be a variety of ways to deliver the updated management subscriber information DB (C '), the change history list, the subscriber information check impossible list made through the update process to the management target company. That is, according to the method selected by the management company as shown in Figure 4 (401) the output (updated subscriber information DB and change history list, subscriber confirmation list) can be delivered in various ways, the change file ( File can be sent by e-mail (402), can be sent by mail after printing (403), and can be easily viewed on the Internet after making a web page (404, 405). Of course, when viewing on the Internet, it is necessary to manage authentication so that only users with valid IDs can see them.

In addition to these methods, when the management company requests to convert the file into a format suitable for sending an Excel file or a database marketing (DM), it can be sent in various ways and in various forms, such as by converting the request into a request format. .

The method of the present invention as described above may be implemented as a program and stored in a computer-readable recording medium (CD-ROM, RAM, ROM, floppy disk, hard disk, magneto-optical disk, etc.).

The present invention described above is not limited to the above-described embodiments and the accompanying drawings, and various substitutions, modifications, and changes are possible in the art without departing from the technical spirit of the present invention. It will be apparent to those of ordinary knowledge.

As described above, the present invention provides a systematic and accurate method for the time and material cost incurred due to the waste of costs resulting from the inaccuracy of conventional subscriber information and the absence of an effective way to accurately generate subscriber information. Not only can dramatically reduce the marketing cost through, but also has the effect of preventing the loss of missing marketing time through accurate subscriber information.

In addition, the present invention provides the subscriber (management company) by changing the information in various forms so that the subscriber can easily use the information, and by providing an envelope or the like necessary for Excel or DM, the subscriber of the next step for marketing In doing the job, it saves you money by saving you the trouble of dealing with changes once again.

In addition, the present invention has the effect of increasing the marketing efficiency at the time when the e-mail marketing is spread by applying the same method to the e-mail as well as the phone number or address.

Claims (5)

In the method of managing subscriber information of another operator in a database management system, A first step of comparing the subscriber information of the telecommunication company and the subscriber information of the management object (company or individual) and confirming a match to establish a management subscriber information database; When a change is made to the record included in the management subscriber information database, the management subscriber information database is found and the subscriber information change record is compared with the subscriber information record matching the subscriber information change record in the management subscriber information database. To update the changes; And A third step of delivering the management subscriber information database created through the updating of the second step to the management object; How to manage subscriber information of other operators using the carrier information. The method of claim 1, The first step is, Comparing each subscriber record in the subscriber information database of the telecommunication company with a telephone number as a key value for each subscriber record in the initial subscriber information database of the management object; A fifth step of comparing a name and an address of each record of the matching subscriber's initial subscriber information database and the telecommunication company's subscriber information database if a record having the same telephone number is found as a result of the comparison of the fourth step; A sixth step of storing a matched subscriber information record in the management subscriber information database if the name and address of each record are the same as a result of the comparison in the fifth step; As a result of the comparison in the sixth step, if the name and address of each record do not match, confirmation is required, so that the subscriber information record of the initial subscriber information database of the management object and the subscriber information database of the telecommunication company is checked. After storing in the subscriber, through the subscriber confirmation through the phone, a record matching the telephone number of the initial subscriber information database of the management object, if confirmed, is found in the subscriber information database of the telecommunication company and put into the management subscriber information database. Seventh step; As a result of the comparison of the fourth step, if a matched record is not found, the subscriber information record of the initial subscriber information database of the management object is stored in a confirmation list through the mail, and then the subscriber information is confirmed through the mail. An eighth step of finding a record in the subscriber information database of the telecommunication company that matches the telephone number of the initial subscriber information database of the management object if it is confirmed; And In the seventh and eighth steps, if the subscriber information is not confirmed, the ninth step of storing the unidentified subscriber information record of the initial subscriber information database of the management object in the unconfirmable list. How to manage subscriber information of other operators using the carrier information. The method according to claim 1 or 2, The second step, A tenth step of selecting a management subscriber information database to which the subscriber information change record belongs, if a record with the subscriber information change is received from the subscriber information record registered in the subscriber information database of the telecommunication company; An eleventh step of finding a record having the same telephone number by comparing the telephone number of the subscriber information change record with respect to each telephone number field of the management subscriber information database; A twelveth step of checking a change code of the subscriber information change record if there is a subscriber information record matching the telephone number of the subscriber information change record in the management subscriber information database as a result of the comparison in the eleventh step; A thirteenth step of changing the record of the management subscriber information database into a change record value and storing the change in a change history list if the check result of the twelfth step is a simple change of an address or telephone number; As a result of the inspection of the twelfth step, if the change code of the change record is a change in which the owner changes, such as termination or change of name, two records to be compared, namely, a subscriber information change record and a subscriber information change record in the management subscriber information database A fourteenth step of storing the subscriber information record corresponding to the telephone number of the user in a change confirmation required list and confirming the subscriber information through the telephone numbers of the two records; And As a result of the checking in step 14, if the subscriber information is confirmed, the process goes to step 13; if not, the subscriber information record corresponding to the telephone number of the subscriber information change record is not found in the management subscriber information database. 15 steps to save on How to manage subscriber information of other operators using the carrier information. The method of claim 3, wherein The third step, Management of subscriber information of other carriers using subscriber information of a communication company, wherein the updated management subscriber information database, change history list, and subscriber confirmation list are transmitted in a form desired by the management object (e-mail, mail, web page). Way. In a database management system having a processor, A first function of comparing the subscriber information of the telecommunication company and the subscriber information of the management object (company or individual) and confirming a match to establish a management subscriber information database; When a change is made to the record included in the management subscriber information database, the management subscriber information database is found and the subscriber information change record is compared with the subscriber information record matching the subscriber information change record in the management subscriber information database. A second function of updating the changes; And A third function for delivering to the management object a management subscriber information database created through the updating of the second function A computer-readable recording medium having recorded thereon a program for realizing this.