JPH09311856A - Auxiliary system for production of data base - Google Patents

Abstract

PROBLEM TO BE SOLVED: To provide an auxiliary system for production of an address data base in order to reduce the time and labor needed for registry of data by using telephone numbers as the input keys to input and register the data on the zip codes, addresses, etc. SOLUTION: This system includes a dictionary storage part 12 which stores the correspondence set between the telephone numbers and their relative addresses and the prescribed information and also stores the telephone numbers and addresses which are retrieved with the telephone numbers used as the retrieval keys, and a dictionary retrieval part 3 which retrieves the part 12 by using the telephone numbers inputted by users as the retrieval keys and registers the detected data into a data base in every prescribed item. Then, a series of data associated at the part 12 are acquired and registered into an address data base 20 without inputting directly the data on the addresses, etc., via a keyboard and by inputting the telephone numbers. Thereby, the time and labor needed for registry of data stored in the base 20 can be reduced.

Description

Detailed Description of the Invention

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a database creation assisting system used for creating a database, and in particular, a database creating assisting system for managing data such as postal codes and addresses used for managing personal information and company information. Regarding

[0002]

2. Description of the Related Art Conventionally, a method of registering data into a database (hereinafter referred to as an address database) that stores data such as postal codes and addresses used for managing personal information and company information is input by a keyboard or the like. It was a method of directly inputting a desired zip code or address using a device. That is, for each item such as zip code, address, name, telephone number, etc. set on the address database, data was individually input by software such as an editor or a Japanese word processor.

[0003]

The conventional address database registration method described above has a problem that it takes time and labor to register the data. The reason is that data such as postal codes and addresses were directly input from an input device such as a keyboard using software such as an editor and a Japanese word processor. Especially, when inputting an address, processing such as kana-kanji conversion is performed. Because it needed execution.

The present invention solves the above-mentioned conventional problems, and by inputting and registering data such as a postal code and an address by using a telephone number as an input key, the time required for data registration and time and labor can be reduced. The purpose is to provide a database creation assistance system for address databases.

[0005]

In order to achieve the above object, the database creation assistance system of the present invention stores a telephone number, an address and predetermined information associated with the telephone number in association with each other, and stores the telephone number. And a phone number / address dictionary means configured to search with the phone number entered by the user as a search key.
Search and registration means for searching the address dictionary means and registering the detected data in the database for each predetermined item.

According to the database creation assistance system of the present invention in claim 2, the telephone number / address dictionary means stores only the area code as the telephone number, and stores the area code corresponding to the area code. When the address is stored in association with the area code, and the search registration means finds no corresponding data as a result of searching the telephone number / address dictionary means with the telephone number input by the user as a search key. In addition, the area code of the input telephone number is used as a new search key to search the telephone number / address dictionary means again, and the detected data is registered in the database for each predetermined item.

According to the third aspect of the database creation assisting system of the present invention, the telephone number / address is configured to retrieve the address and predetermined information using the telephone number as a search key based on the regulated telephone number / address data. It is characterized by further comprising a dictionary creating means for creating a dictionary.

According to another aspect of the database creation assisting system of the present invention, the user interface for displaying the search result by the search / registration means and causing the search / registration means to register the data as the search result in the database according to an instruction from the user. It further comprises means, and the search registration means registers the detected data in the database after waiting for an instruction from the user obtained via the user interface means.

[0009]

BEST MODE FOR CARRYING OUT THE INVENTION Embodiments of the present invention will be described below in detail with reference to the drawings.

FIG. 1 is a block diagram showing the configuration of a database creation assistance system for an address database according to an embodiment of the present invention.

As shown in the figure, the database creation assistance system 10 of this embodiment is created with a dictionary creation unit 11 for creating a telephone number / address dictionary in which a postal code and an address are paired and sorted by telephone number. A dictionary storage unit 12 for storing a phone number / address dictionary and a dictionary search unit 1 for searching desired data from the phone number / address dictionary using the phone number as a search key.
3 and a console 14 for inputting a search key and outputting a search result. Further, the dictionary search unit 13 is connected to the address database 20 and registers the searched data. It should be noted that only the characteristic configuration of the present embodiment is shown in the drawing, and the description of other configurations is omitted.

The dictionary creating unit 11 is realized by a program-controlled CPU or the like, and creates a telephone number / address dictionary based on existing telephone number / address data. As the ready-made telephone number / address data, for example, the data for the telephone directory of the telephone company can be used. Also, regulated telephone numbers
Whenever the address data is changed, a new telephone number / address dictionary corresponding to the changed contents is newly created and updated.

The dictionary storage unit 12 is realized by a storage device such as a magnetic disk device or an optical disk device, and the dictionary creation unit 11 is used.
Stores the telephone number / address dictionary created in. As illustrated in FIG. 3, the telephone number / address dictionary is a dictionary base that includes at least a zip code and an address, and sorts these pieces of information using the telephone number as a key.

The telephone number / address dictionary stored in the dictionary storage section 12 stores data corresponding to the area code. In this case, the stored address is up to the prefecture name or the municipality name corresponding to the division of the area code. As a result, as will be described later, even if the search using the telephone number, which is the search key, fails, it is possible to identify at least the prefecture or municipality level address.

The dictionary search unit 13 is realized by a program-controlled CPU or the like, and includes a zip code and an address from a zip code / dictionary address stored in the dictionary storage unit 12 using a telephone number as a search key. Search for data. The detected data is output to the console 14 and registered in the address database 20. Data search method by dictionary search unit 13 and address database 20 of detected data
The method of registration in will be described later.

The console 14 includes an input device such as a keyboard and a display device such as a CRT display, and inputs a telephone number which is a search key for a telephone number / dictionary address and a zip code which is a search result by the dictionary search unit 13. It displays the data paired with the address. In addition, when the user decides to register the displayed data in the address database 20, the user also inputs a registration command for executing the registration process. Further, when the data related to the input search key is not detected, a message such as "search not possible" is displayed.

The dictionary database 20 is realized by a storage device such as a magnetic disk device, and registers the data selected by the user among the data searched by the dictionary search unit 13. As a result, when registering at least the data including the telephone number, zip code, and address in the dictionary database 20, it is not necessary to directly input each item, but only by inputting the telephone number and the registration command from the console 14. Is possible.

Next, the operation of the dictionary retrieval unit 13 of this embodiment will be described with reference to the flowchart of FIG.

As shown in FIG. 4, the telephone directory data of the telephone company are stored in the order of Japanese syllabary names. As an initial setting, the dictionary creation unit 11 rearranges the telephone directory data in order of telephone numbers to create a telephone number / address dictionary, and the dictionary storage unit 12
To be stored.

When the user inputs the telephone number of the data to be registered in the address database 20 from the console 14 (step 201), the telephone number is the dictionary retrieval unit 1.
3, and the dictionary retrieval unit 13 retrieves the data including the postal code and the address by using the telephone number as a retrieval key (step 202).

If data having the same telephone number as the search key is stored in the telephone number / address dictionary of the dictionary storage unit 12, the data associated with the telephone number is read and output to the console 14. (Step 20
3, 204), each item in the address database 20 (address,
The data is stored in correspondence with the postal code, telephone number, etc. (step 205).

On the other hand, if data having the same telephone number as the search key is not stored in the telephone number / address dictionary of the dictionary storage unit 12, data retrieval by the area code is performed (step 206). That is, the area code part of the telephone number input in step 201 is newly used as a search key.
Search for data associated only with the same area code. If such data is stored, the data is read out and output to the console 14 (steps 207 and 204), and the data is stored in association with the corresponding item in the address database 20 (step 20).
5). In this case, since the data associated only with the area code is only the address at the prefecture or municipal level as described above, only this data will be registered in the address database 20. The area code part of the telephone number is extracted by, for example, recognizing up to the first delimiter "-(hyphen)" of the phone number as the area code.

If the corresponding data is not detected from the telephone number / address dictionary stored in the dictionary storage unit 12 by the area code search, a message indicating that the search is impossible is output and displayed on the console 14 (step 208). .

Next, a specific operation example will be described with reference to the flowchart of FIG. 2 and the telephone number / address dictionary of FIG.

A predetermined telephone number address dictionary is stored in the dictionary storage unit 12. As shown in FIG. 3, the telephone number includes the area code "03" and the corresponding address "Tokyo". As the data and telephone number "03- ○○○○
-○○○○ ", the corresponding address" Shiba ○ Chome, Minato-ku, Tokyo ×-× ", the postal code" ○○○-○○ ", and the phone number" 03- ○○○○ " − ×××
× ”, as the corresponding address“ Shiba △ Chome, Minato-ku, Tokyo □ −
“X” and data including “XXXXX-XX” as a postal code are registered.

In this state, it is assumed that the telephone number "03- ○○○○-○○○○" is input from the console 14 (step 201). Then, the dictionary search unit 13 searches the telephone number / address dictionary of the dictionary storage unit 12 using the telephone number "03- ○○○○-○○○○" as a search key (step 20).
2), data including telephone number "03- ○○○○-○○○○", corresponding address "Shiba ○ Chome XX-X, Minato-ku, Tokyo", corresponding zip code "○○○-○○" Is detected (step 203). Then, the data is read and displayed on the console 14 (step 204), and the data is registered in the address database 20 for each corresponding item after waiting for an instruction from the user (step 205).

It is also assumed that the telephone number "03- ○○○○○ -ΔΔΔΔ" is input from the console 14 in the above state (step 201). Then, the dictionary search unit 13
The telephone number / address dictionary in the dictionary storage unit 12 is searched using the telephone number "03- ○○○○-△△△△" as a search key (step 202). Is not stored, the search fails (step 203). Therefore, the telephone number / address dictionary is searched again using the area code "03" as a new search key (step 206). By this search, phone number "0
3 "and the corresponding address" Tokyo "are detected (step 207). Then, read the data,
While displaying on the console 14 (step 204),
Waiting for an instruction from the user, the data is registered in the address database 20 for each applicable item (step 20).
5).

Although the present invention has been described with reference to the preferred embodiments, the present invention is not necessarily limited to the above embodiments. For example, in the present embodiment, when the regulated telephone number / address data is changed, a new telephone number / address dictionary is created and updated in accordance with the change.
It may be updated by acquiring the data of the changed portion and changing the corresponding portion in the telephone number / address dictionary stored in the dictionary storage unit 12 or adding or deleting the corresponding data.

[0029]

As described above, according to the database creation assisting system of the present invention, the telephone number / address dictionary can be handled by inputting the telephone number without directly inputting the data such as the address from the keyboard. Since a series of attached data can be acquired and registered in the address database, there is an effect that the time required for registering the data in the address database can be shortened and labor can be reduced.

[Brief description of drawings]

FIG. 1 is a block diagram showing the configuration of a database creation assistance system according to an embodiment of the present invention.

FIG. 2 is a flowchart showing a procedure for registering data in an address database according to this embodiment.

FIG. 3 is a diagram showing a configuration of a telephone number / address dictionary used in this embodiment.

FIG. 4 is a diagram showing a configuration example of regulated telephone directory data.

[Explanation of symbols]

 10 database creation assistance system 11 dictionary creation unit 12 dictionary storage unit 13 dictionary search unit 14 console 20 address database

Claims (4)

[Claims] 1. A telephone number / address dictionary means configured to store a telephone number, an address associated with the telephone number, and predetermined information in association with each other and to retrieve the telephone number by using a search key, and a user. A database creation assisting system, comprising: a search / registration means for searching the telephone number / address dictionary means using the input telephone number as a search key and registering detected data in the database for each predetermined item. 2. The telephone number / address dictionary means stores a telephone number consisting only of an area code, and stores an address of a region corresponding to the area code in association with the area code. As a result of searching the telephone number / address dictionary means with the telephone number input by the user as a search key, the search registration means finds the area code of the input telephone number when the corresponding data cannot be detected. 2. The database creation assistance system according to claim 1, wherein the data obtained by searching the telephone number / address dictionary means again as a new search key is registered in the database for each predetermined item. [Claim 3] Based on the regulated telephone number and address data,
The dictionary creation means for creating the phone number / address dictionary configured to search for an address and predetermined information using a phone number as a search key is further provided.
Alternatively, the database creation assistance system according to claim 2. 4. The search and registration means further comprises a user interface means for displaying the search result by the search and registration means and causing the search and registration means to register the data as the search result in the database in accordance with an instruction from a user. The database creation assistance system according to claim 1 or 2, wherein the detected data is registered in the database after waiting for an instruction from a user obtained via the user interface means.