KR100901624B1 - Method for Automaic Updating of Telephone Number and Address in Web Site Directory Service - Google Patents

Abstract

1. TECHNICAL FIELD OF THE INVENTION

The present invention relates to a method for automatically updating a telephone number and address in a website directory service system 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 provides an automatic updating method for automatically updating telephone numbers and addresses using a telephone number database already existing in a website directory service system, and a computer-readable recording medium having recorded thereon a program for realizing the method. The purpose is to provide.

3. Summary of the Solution of the Invention

The present invention relates to a telephone number in a website directory service system including a log database that records update contents of a telephone number or address in a website database, and a registrant confirmation list that records a list of websites for which a confirmation mail needs to be sent. And an automatic address update method, comprising: extracting a phone number field value and an address field value for a web site from the web site database, and using the extracted phone number field value as a search key for an external phone number guide 114; A first step of checking the telephone number database to confirm the existence of the telephone number; A second step of extracting an address field value of a corresponding telephone number from the telephone number database and comparing it with an address field value extracted from the web site database as the existence of the telephone number is confirmed in the first step; And updating the address field value of the web site database with the address field value of the telephone number database, and inserting the update contents into the log database and the registrant check list as the two address field values do not match in the second step. Includes 3 levels.

4. Important uses of the invention

The present invention is used for web site directory services and the like.

Web site directory service system, web site, phone number database, address database, automatic renewal

Description

Method for Automaic Updating of Telephone Number and Address in Web Site Directory Service             

1 is a configuration diagram of an embodiment of a web site directory service system to which the present invention is applied.

2 is an embodiment structural diagram of a telephone number database, a website database, and a log database used in the present invention.

3 is a flowchart illustrating a method for automatically updating a phone number and address in a web site directory service system according to an embodiment of the present invention.

* Explanation of symbols on the main parts of the drawing

10: Web site directory service system

11: directory service processing unit 12: Web site management unit

13: website database 14: log database

15: phone number database

The present invention relates to a computer-readable recording medium recording a telephone number and address automatic updating method in a website directory service system and a program for realizing the method, and more particularly, already exists in the website directory service system. A telephone number and address automatic updating method for automatically updating a telephone number and address of a web site using a telephone number database, and a computer-readable recording medium having recorded thereon a program for realizing the method.

The website directory service provides a list of sites that users want by providing a summary of information such as an Internet address (URL: Uniform Resource Locator), title, description, contents, telephone number, address, and rating level for the homepage on the Internet. It is a service that allows you to find information about the site without visiting the site.

However, the number of web sites registered on the portal site is usually hundreds of thousands, and thousands of homepage registration requests come in each day. Due to the nature of the flexible web site, many sites are created, removed, moved and modified every day. Therefore, it is difficult to manually update the information of the web site where such a lot of changes occur.

In general, a method of updating information on a web site is to physically check using a computer whether a registered site currently exists. That is, if the web server returns 400 errors, it means that the site does not exist now. If it returns 200, it means that the current site exists and is operating normally. As described above, the physical change can be automatically updated, but there is a problem that the change of logical information about the content of the site is difficult to update automatically.

In addition, the web site directory service provides information such as a telephone number or address as well as an Internet address (URL) for the web site. The information such as a phone number or address is very important to the user or the business operator. . Therefore, you should check and update your changes daily to maintain accurate information. However, it is very difficult to manually update the information of hundreds of thousands of web sites where changes frequently occur.

The present invention has been proposed to solve the above problems, and the method for automatically updating the telephone number and address for automatically updating the telephone number and address using a telephone number database that already exists in the web site directory service system. It is an object of the present invention to provide a computer-readable recording medium having recorded thereon a program for realizing the method.

In order to achieve the above object, the present invention provides a web site including a log database that records the update of a telephone number or address in a web site database, and a registrant check list that records a list of web sites that need to send a confirmation mail. A method for automatically updating a phone number and address in a directory service system, comprising extracting a phone number field value and an address field value for a web site from the web site database, and using the search key to retrieve the phone number field value. A first step of verifying the existence of a telephone number by searching an external telephone number database established for the third party; A second step of extracting an address field value of a corresponding telephone number from the telephone number database and comparing it with an address field value extracted from the web site database as the existence of the telephone number is confirmed in the first step; And updating the address field value of the web site database with the address field value of the telephone number database, and inserting the update contents into the log database and the registrant check list as the two address field values do not match in the second step. Includes three steps.

On the other hand, the present invention provides a web site directory having a processor database including a log database which records update contents of a phone number or address in a web site database, and a registrant check list which records a list of web sites which need to send a confirmation mail. In the service system, the telephone number field value and the address field value of the web site are extracted from the web site database, and the external telephone number database constructed for the telephone number guide 114 is searched using the extracted telephone number field value. A first function of retrieving the presence of a telephone number by searching; A second function of extracting an address field value of a corresponding telephone number from the telephone number database and comparing it with an address field value extracted from the web site database when the existence of the telephone number is confirmed in the first function; And updating the address field value of the web site database to the address field value of the telephone number database, and inserting the update contents into the log database and the registrant confirmation list, as the two address field values do not match in the second function. A computer readable recording medium having recorded thereon a program for realizing the function is provided.

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 a configuration diagram of an embodiment of a web site directory service system to which the present invention is applied.

As shown in FIG. 1, the web site directory service system 10 according to an embodiment of the present invention provides a web site directory service by searching a web site database 13 by a request from a service user. The directory service processing unit 11 registers a web site in the web site database 13 by a request from a web site registrant, and manages the information stored in the web site database 13. ), A web site database 13 for storing information on web sites under the control of the web site manager 12, and a change of the web site database 13 under the control of the web site manager 12. A log database 14 for storing matters. At this time, the web site manager 12 and the phone number database 15 are interoperated with each other in order to automatically update the phone number and address of the web site by using the already existing phone number database 15. Detailed operation thereof will be described later in detail with reference to FIG. 3.

2 is a schematic diagram of a telephone number database, a website database, and a log database in a website directory service system according to an exemplary embodiment of the present invention.

As shown in Fig. 2, the telephone number database 15 is a database already established for guiding the telephone number 114. The telephone number database 15 includes a telephone number field 151 and an address field 152, which are primary keys. The changes are updated daily. In addition, the web site database 13 is a database for a web directory service. The primary key is a Uniform Resource Locator (URL) field 131, a telephone number field 132, and an address field 133. , And a mail address field 134.

Meanwhile, the log database 14 records the contents of the web site database 13 whenever the phone number or address is changed and updated. The log database 14 can track the history of any web site, and the Internet address. (URL: Uniform Resource Locator) field 141, telephone number field 142, address field 143, e-mail address field 144, date field 145, and processing content field 146.

3 is a flowchart illustrating a method for automatically updating a phone number and address in a web site directory service system according to an exemplary embodiment of the present invention.

First, the telephone number field 131 value and the address field 132 value are extracted from the website database 13, and then the telephone number database 15 is searched using the extracted telephone number field 131 value as a search key ( 301, it is checked whether a corresponding telephone number exists in the telephone number database 15 (302).

If the check result 302, if the telephone number does not exist is determined whether the telephone number is a telephone number subscribed to another telephone operator (307), if the determination result 307, the telephone number subscribed to another telephone operator Since it is not possible to manage the renewal of the telephone number and address, the process proceeds to "306" for the processing of the next web site. If the determination result 307 is not a telephone number subscribed to another telephone operator, the telephone number is changed. In this case, the web site is inserted into the registrant confirmation list and the respective field values are entered so that the web site registrant can be confirmed (308).

On the other hand, the verification result 302, if the telephone number exists, the address field extracted from the web site database 13 by extracting the value of the address field 152 corresponding to the telephone number from the telephone number database 15 ( 133) and the value (303). As a result of the comparison 303, if the address is the same, the process proceeds directly to "306". If the address is not the same, the value of the address field 133 of the website database 13 is changed to the value of the address field 152 of the telephone number database 15. In step 305, the data is automatically updated, and the updated contents are inserted into the log database 14 to input each field value. In addition, the update contents of the web site are inserted into the registrant check list, and each field value is input to allow the web site registrant to confirm the check. Thereafter, it checks whether all items of the web site database 13 have been processed, and terminates if all of them have been processed.

The registrant check list is a list of web sites that require a confirmation mail to be changed due to a change in the phone number or address as a result of searching the phone number database 15, and, like the log database 14, an Internet address (URL: Uniform Resource Locator) field, telephone number field, address field, mail address field, date field, processing content field. At this time, values of an Internet address (URL: Uniform Resource Locator) field, a telephone number field, an address field, and an e-mail address field are input from the web site database 13, and the date field indicates the date when the web site is inserted. The content indicating what kind of change has occurred is entered in the processing content field.

In addition, the administrator check list is for the web sites that need to be manually processed by the web directory service administrator for the reason that there is no reply for a predetermined period of time from the websites that send the confirmation mail using the registrant check list. The list includes, like the log database 14 or the registrant check list, an Internet address (URL: Uniform Resource Locator) field, a telephone number field, an address field, an e-mail address field, a date field, and a contents field. Each field value is input corresponding to each field of the registrant confirmation list.

Subsequently, by using the mail addresses of the web sites stored in the registrant check list, an e-mail confirming the change of the phone number and the address is sent to receive an answer. If the change is correct in the answer, delete the web site entry from the registrant check list. If the change is not correct, insert the web site into the administrator check list and enter each field value for manual processing by the web directory service administrator. do. In addition, even if a reply mail does not come for a predetermined period after sending the registrant confirmation mail, the corresponding website is inserted into the administrator confirmation list, and the website item is deleted from the registrant confirmation list.                     

The above process is performed for each of the web sites registered in the web site database. After the processing for one web site, the process proceeds to the next web site.

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

The present invention described above is capable of various substitutions, modifications, and changes without departing from the spirit of the present invention for those skilled in the art to which the present invention pertains. It is not limited by the drawings.

As described above, the present invention, by automatically updating the telephone number and address of the web site by using the telephone number database already existing in the web directory service system, it can greatly reduce the effort and processing time required to update the changes manually. And, there is an effect that can provide more accurate information.

In addition, the present invention can track the history of the web site by storing the automatic update of the phone number and address of the web site in a log database, which is convenient to manage the web directory service system.

Claims (8)

Automatic renewal of telephone numbers and addresses in the website directory service system, including a log database that records updates of telephone numbers or addresses in the website database, and a registrant confirmation list that lists the websites for which confirmation mail should be sent. In the method, The telephone number field value and the address field value of the website are extracted from the website database, and the telephone number is searched by searching the external telephone number database established for the telephone number guide 114 by using the extracted telephone number field value. A first step of confirming the presence of; A second step of extracting an address field value of a corresponding telephone number from the telephone number database and comparing it with an address field value extracted from the web site database as the existence of the telephone number is confirmed in the first step; And A third step of updating the address field value of the web site database with the address field value of the telephone number database and inserting the update contents into the log database and the registrant confirmation list as the two address field values do not match in the second step. step How to automatically renew the phone number and address in the web site directory service system comprising a. The method of claim 1, A fourth step of sending a mail for confirming the change of the telephone number and the address using the mail addresses of the web site items stored in the registrant confirmation list; A fifth step of confirming whether the change is correct from an answer to the mail confirming the change; As a result of the checking in the fifth step, if the change is correct, the web site item is deleted from the registrant check list. If the change is not correct, the web site item is inserted into an administrator check list and the respective field values are entered. Deleting the website item from the registrant check list; And A seventh step of checking a date field in order from the beginning to the end of the registrant check list and inserting the corresponding web site item into an administrator check list and deleting the web site item from the registrant check list if it is equal to or longer than a current date. step How to automatically renew the phone number and address in the website directory service system including more. The method according to claim 1 or 2, The telephone number database, A method of automatically renewing a telephone number and address in a website directory service system including a telephone number field and an address field which are primary keys, wherein changes are updated daily. The method according to claim 1 or 2, The web site database is a database for a web directory service. The web site database includes a Uniform Resource Locator (URL) field as a primary key, a telephone number field, an address field, and an e-mail address field. How to automatically renew your phone number and address in a web site directory service system. The method according to claim 1 or 2, The log database includes an Internet address (URL: Uniform Resource Locator) field, a telephone number field, an address field, an e-mail address field, a date field, a contents field, and when a telephone number or address is updated in the website database. A method of automatically updating a telephone number and address in a website directory service system, characterized in that the contents are recorded every time so that the history of an arbitrary website can be tracked. The method according to claim 1 or 2, The registrant check list is a list of web sites that need to send a confirmation mail when a phone number or address change occurs as a result of searching the telephone number database. An Internet address (URL: Uniform Resource Locator) field, A method for automatically updating a telephone number and address in a web site directory service system, comprising a number field, an address field, an e-mail address field, a date field, and a contents field. The method of claim 2, The administrator check list is a list of web sites where items that need to be manually handled by the web directory service administrator have not been returned for a predetermined period of time from web sites that have sent a confirmation mail using the registrant check list. And an Internet address (URL: Uniform Resource Locator) field, a telephone number field, an address field, an e-mail address field, a date field, and a contents field. A website directory service system having a processor including a log database that records updates of phone numbers or addresses in a website database, and a registrant check list that records a list of websites for which confirmation emails need to be sent. The telephone number field value and the address field value of the website are extracted from the website database, and the telephone number is searched by searching the external telephone number database established for the telephone number guide 114 by using the extracted telephone number field value. A first function of confirming the presence of; A second function of extracting an address field value of a corresponding telephone number from the telephone number database and comparing it with an address field value extracted from the web site database when the existence of the telephone number is confirmed in the first function; And A third step of updating the address field value of the web site database with the address field value of the telephone number database and inserting the update contents into the log database and the registrant confirmation list as the two address field values do not match in the second function. function A computer-readable recording medium having recorded thereon a program for realizing this.

Images