JP2005122241A - Customer database diagnostic device and program - Google Patents

Abstract

<P>PROBLEM TO BE SOLVED: To provide a customer database diagnostic device allowing efficient diagnosis of validity of customer data. <P>SOLUTION: A diagnosis program and data obtained by encrypting diagnosing customer data 45 inside a storage device 5 of a computer 3 are installed to computers 7-1 to 7-n with MO11-1 to 11-n as media. The computer 7-1 to 7-n have customer databases including telephone numbers, names, and addresses or the like, inside storage devices 9-1 to 9-n. The diagnosis program installed to the computers 7-1 to 7-n diagnoses the customer databases inside the storage devices 9-1 to 9-n by use of the diagnosing customer data 45' obtained by encrypting the diagnosing customer data 45 to decide the validity of the telephone number, the name, and the address or the like. The diagnosing customer data 45' is periodically updated. <P>COPYRIGHT: (C)2005,JPO&NCIPI

Description

  The present invention relates to diagnosis of a database or the like, and more particularly, to a customer database diagnosis apparatus that creates a diagnosis result such as a telephone number, a name, and an address by comparing a customer database with a prepared customer database for diagnosis.

In general, a company has a database including a customer's name, address, telephone number, etc. in order to solicit and guide customers by telephone or mail.
However, if the customer has not notified the company of the move, the customer data registered in the customer database becomes invalid, and the customer data must be updated or deleted. In order to delete the invalid customer data from the customer database in this way, a bar code display for identifying the customer is attached to the mail and shipped, and the bar code display of the mail that has been returned as non-delivery is used. There is a method of deleting the corresponding customer data and updating the customer database. (For example, refer to Patent Document 1.)

  Alternatively, there is a method of inputting customer information such as a customer's address and name using a customer verification device via a network and verifying whether or not the customer actually exists. (For example, see Patent Document 2.)

JP 7-44621 A JP 2001-325438 A

  However, in the first method, it is necessary to send mail to a non-existing customer, which requires a great deal of cost and labor.

  In the second method, since it is necessary to input customer information for each customer and to check whether or not the customer actually exists, it is inefficient to check a large amount of customer data.

  The present invention has been made in view of such problems, and an object of the present invention is to provide a customer database diagnostic apparatus capable of efficiently diagnosing the effectiveness of customer data.

  In order to achieve the above-mentioned object, the present invention provides a customer database storing information about customers, a diagnostic customer database storing information about customers updated regularly, and information about customers stored in the customer database. A customer database diagnosis apparatus having means for comparing with information about a customer stored in a diagnosis customer database and means for generating a diagnosis result file by the comparison means.

  The customer-related information stored in the customer database and the diagnostic customer database includes a telephone number, whether or not the telephone number is posted on a hello page, a name, an address, a mail non-delivery degree at the address, a FAX number, an Internet address, and the like.

The diagnostic customer database is encrypted and can be read only by the customer database diagnostic program. The diagnostic customer database is periodically updated, for example, every month or every two months.

The customer database diagnosis device compares the customer information stored in the customer database and the customer database for diagnosis, uses the phone number stored in the customer database, whether the phone number is listed on the hello page, whether the name matches, The match status, the update status of the address, the mail non-delivery degree to the address, and the presence / absence of update / supplementary data are determined and output to a CSV diagnostic result file.

  A company that uses a customer database extracts information about valid customers from the customer database by using a diagnosis result file, and efficiently solicits and guides customers by telephone or mail.

  According to this embodiment, it is possible to provide a customer database diagnostic apparatus that can efficiently diagnose the validity of customer data.

  Hereinafter, embodiments of the present invention will be described in detail with reference to the drawings. FIG. 1 is a schematic configuration diagram of a customer database diagnostic apparatus 1 according to an embodiment of the present invention, FIG. 2 is a diagram illustrating an example of a hardware configuration of a computer 3, and FIG. 3 is a storage device 5 of the computer 3. 4 is a diagram illustrating an example of the diagnostic customer data 45, FIG. 5 is a diagram illustrating an example of the hardware configuration of the computer 7, and FIG. 6 is a diagram of the storage device 9 of the computer 7. It is a figure which shows a detail.

As shown in FIG. 1, a customer database diagnostic apparatus 1 according to the present invention includes a computer 3 installed on the database providing side, computers 7-1 to 7-n installed on the client side, and computer 3 to computer 7. -1 to 7-n include magneto-optical disks MO (magneto optical) 11-1 to 11-n serving as media for transferring programs, data, and the like.
As a medium for transferring programs and data from the computer 3 to the computers 7-1 to 7-n, not only the MO but also a CD-ROM (compact disc read only memory), a flexible disk, or the like may be used.

  The computer 3 has a storage device 5, and the computers 7-1 to 7-n have storage devices 9-1 to 9-n, respectively, and store programs, data, and the like necessary for operation.

The storage device 5 of the computer 3 has diagnostic customer data 45 for diagnosing customer data of the computers 7-1 to 7-n on the client side.
The diagnostic customer data 45 is a customer database created by the computer 3 and updates information such as the customer's name, address, and telephone number as needed based on the telephone line survey results and the like. The computer 3 writes the diagnostic customer data 45 encrypted and the diagnostic program 43 in the MOs 11-1 to 11-n, and periodically provides them to the computers 7-1 to 7-n on the client side.

  The computers 7-1 to 7-n on the client side use the MOs 11-1 to 11-n provided from the computer 3 to install the diagnostic program 43, and for diagnosis in the storage devices 9-1 to 9-n Customer data 45 'is updated. The diagnosis program 43 diagnoses customer data 75 included in the computers 7-1 to 7-n based on the diagnosis customer data 45 'in the storage devices 9-1 to 9-n.

  As shown in FIG. 2, the computer 3 includes a control unit 21, a storage device 5, a media input / output unit 23, an input unit 25, a printing unit 27, and a display unit 29 that are interconnected by a bus 31.

  The control unit 21 includes a CPU (central processing unit) that executes a program, and a memory such as a ROM (read only memory) and a RAM (random access memory) for storing program instructions or data. The control unit 21 controls the operation of the entire computer 3.

The media input / output unit 23 is a drive of a medium such as a CD-ROM or CD-RW (CD-ReWritable), flexible disk, or MO, and reads data from the medium and writes data to the medium. The media input / output unit 23 writes the diagnostic program 43 or the diagnostic customer data 45 in the MOs 11-1 to 11-n.

  The input unit 25 is an input device such as a keyboard and a mouse. The printing unit 27 is a printer, and prints necessary information and the like according to a request from a user. The display unit 29 is a display device such as a CRT (cathode-ray tube) or LCD (liquid crystal display).

  The storage device 5 stores programs and data necessary for the operation of the computer 3. As shown in FIG. 3, the storage device 5 includes an OS (Operating system) 41, a diagnostic program 43, and diagnostic customer data 45. The diagnosis program 43 is a program for diagnosing the customer database of the computers 7-1 to 7-n.

  As shown in FIG. 4, the diagnostic customer data 45 includes a telephone number 103, a telephone number status 105, a hello page status 107, a name 109, an address 111, an address non-delivery status 113, a FAX number status 115, an Internet address status 117, and the like.

The telephone number 103 is numeric character data and represents the customer's telephone number. The telephone number status 105 indicates whether the telephone number 103 is usable or unusable. For example, “1” is set if it can be used, and “9” is set if it cannot be used.
The hello page status 107 indicates whether the telephone number 103 is posted on the latest version of the hello page. For example, “1” is set if the phone number 103 is posted, and “2” is set if the phone number 103 is not posted.

  The name 109 and the address 111 are character data representing the name and address of the customer and have a fixed length. The address non-delivery status 113 indicates whether or not a direct mail is returned to the customer with the name 109 and the address 111. For example, if the direct mail is not returned, “1” is indicated. If the direct mail is not returned, “9” is indicated. Is set.

The diagnostic customer data 45 includes alphanumeric character data FAX number status 115 and Internet address status 117 as additional data.
For example, when the client side needs FAX number or Internet address data, the computer 3 sends the FAX number or Internet address data to the computers 7-1 to 7-n in a form different from the MO 11-1 to 11-n. To provide.

  As shown in FIG. 5, the computer 7 includes a control unit 51, a storage device 9, a media input / output unit 53, an input unit 55, a printing unit 57, and a display unit 59 that are interconnected by a bus 61.

  The control unit 51 includes a CPU that executes a program and a memory such as a ROM and a RAM that store program instructions or data. The control unit 51 controls the overall operation of the computer 7.

The media input / output unit 53 is a medium drive such as a CD-ROM or CD-RW, a flexible disk, or an MO, and reads data from the medium and writes data to the medium. The media input / output unit 53 reads the MOs 11-1 to 11-n created by the computer 3 and writes the diagnostic program 43 or the diagnostic customer data 45 ′ in the storage device 9.

  The input unit 55 is an input device such as a keyboard and a mouse. The printing unit 57 is a printer, and prints necessary information and the like according to a request from the user. The display unit 59 is a display device such as a CRT or LCD.

  The storage device 9 stores programs and data necessary for the operation of the computer 7. As shown in FIG. 6, the storage device 9 includes an OS 71, a diagnostic program 43, customer data 75, diagnostic customer data 45 ′, and a diagnostic result file 79.

  The customer data 75 is a customer database uniquely constructed by the computers 7-1 to 7-n, and has different data in different file formats for the computers 7-1 to 7-n.

The diagnostic customer data 45 ′ is obtained by encrypting the diagnostic customer data 45 of the computer 3 and installing it in the computer 7 via the MOs 11-1 to 11-n. The encrypted diagnostic customer data 45 ′ can be read only by the diagnostic program 43, and cannot be referred to by other programs in the computer 7.
The diagnostic customer data 45 ′ is periodically updated by the MOs 11-1 to 11-n provided from the computer 3.

  The diagnostic program 43 is obtained by installing the diagnostic program 43 of the computer 3 into the computer 7 via the MOs 11-1 to 11-n. The diagnosis program 43 diagnoses the customer data 75 using the diagnosis customer data 45 ′ and outputs the diagnosis result to the diagnosis result file 79.

The diagnosis result file 79 is a CSV (Comma Separated Values) format file. The computer 7 extracts necessary data from the diagnosis result file 79, for example, deletes customer data whose telephone number is unusable, or a customer having an address where there is a high possibility that the mail will not arrive. The customer data 75 is updated by deleting the data.

  Next, the operation of the customer database diagnosis apparatus 1 according to the present invention will be described with reference to FIGS. FIG. 7 is a flowchart showing the operation of the control unit 51 diagnosing the customer data 75 according to the diagnosis program 43 of the customer database diagnosis apparatus 1 according to the present invention. FIG. FIG. 9 is a diagram illustrating an example of the diagnosis result data 200 to be output as a result, FIG. 9 is a diagram illustrating an example of values of the data items 203 to 229 of the diagnosis result data 200, and FIG. 10 is customer data. It is a figure which shows an example of 75 diagnostic results.

  When a client-side user who wants to diagnose customer data 75 starts up the diagnostic program 43 on the computer 7, the control unit 51 starts executing the diagnostic program 43. In accordance with the diagnosis program 43, the control unit 51 diagnoses the customer data 75, creates the diagnosis result data 200 shown in FIG. 8, and writes it in the diagnosis result file 45 '.

The control unit 51 requests the user to input a file name of customer data 75 to be diagnosed from the input unit 55 such as a keyboard via the user interface displayed on the display unit 59, and the user inputs the file name. (Step 301).

  The control unit 51 requests the user to input the item number of the telephone number, name, and address in the customer data 75 to be diagnosed from the input unit 55 via the user interface displayed on the display unit 59, and the user Inputs the item number (step 302).

  When the user inputs an item number, the control unit 51 starts diagnosis of the customer data 75 according to the diagnosis program 43, and reads one piece of customer data from the customer data 75 having the file name input by the user in step 301 (step 303).

  The control unit 51 uses the item number of the telephone number input in step 302 to extract the telephone number from the read customer data and write it in the telephone number 203 of the diagnosis result data 200. If no telephone number is given to the read customer data, the telephone number 203 is a space.

When a telephone number is given to the read customer data, the control unit 51 searches whether there is diagnostic customer data 45 having a telephone number that matches the telephone number 203 in the diagnostic customer data 45 ′. When there is diagnostic customer data 45 having a matching telephone number, the control unit 51 reads the diagnostic customer data 45 and sets the value of the telephone number status 105 to the telephone number status 205.
As shown in FIG. 9, the telephone number status 205 includes, for example, “1” when the telephone number 203 is usable, and “2” when the telephone number 203 is not registered in the diagnostic customer data 45 ′. "Is set to" 9 "if the telephone number 203 is unusable (step 304).

The control unit 51 sets a hello page status 107 indicating whether the telephone number 203 is posted on the latest version of the hello page.
As shown in FIG. 9, for example, when the telephone number 203 is posted on the latest version of the hello page, “1” is set in the hello page status 207, and when it is not posted, “2” is set in the hello page status 207. (Step 305).

The control unit 51 writes the name of the read customer data in the name 209 of the diagnosis result data 200, and determines whether the name 209 matches the name of the read diagnosis customer data 45.
As shown in FIG. 9, for example, “1” is set in the name status 211 when they are completely matched, “2” is set when they are almost matched, and “9” is set when they are not matched (step 306).

The control unit 51 writes the address of the read customer data to the address 213 of the diagnosis result data 200, and determines whether the address 213 matches the address of the read diagnostic customer data 45.
As shown in FIG. 9, for example, “1” is set as the address status 215 when the addresses completely match, “2” when they substantially match, and “9” when they do not match.

  When the address 213 is an address with the correct notation, for example, the control unit 51 sets “1” to the address update status status 217. However, the address notation has been changed due to land readjustment or merger of municipalities. If the change is not reflected, “2” is set in the address update status 217. For example, when the address 213 is the address before the relocation, the control unit 51 is incomplete such as “3” in the address update status 217 and the address 213 lacking the address, the building name, or the like. If the address is “8”, “9” is set. If the address 213 is an invalid address, “9” is set.

Further, the control unit 51 considers the address update status 217 and the address non-delivery status 113 of the read diagnostic customer data 100, and when the mail is sent to the address 213 and the name 209 as the destination, The possibility of whether or not the delivery is correct is determined, and the postal matter non-delivery status 219 is set.
As shown in FIG. 9, for example, when the possibility of non-delivery is very low, “1” is set in the postage non-delivery degree status 219, and there is a possibility of non-delivery due to a part of the address 213 being wrong. Is set to “2”, and “9” is set when the address 213 is invalid and the possibility of non-delivery is high (step 307).

When the data is incorrect or there is no data regarding the telephone number, name, and address of the read customer data, the control unit 51 can provide a valid telephone number, name, and address from the computer 3 to the computer 7 when desired by the client. A telephone number update supplemental data status 221, a name update supplemental data status 223, and an address update supplemental data status 225 indicating whether data can be provided are set.
As shown in FIG. 9, for example, “1” is set when there is valid data that can be provided, and “2” is set when there is no valid data.

Further, as additional information, the control unit 51 indicates whether or not the client FAX number and the Internet address data corresponding to the read customer data can be provided from the computer 3 to the computer 7 when the client side desires. Number supplementary data status 227 and Internet address supplementary data status 229 are set.
As shown in FIG. 9, for example, “1” is set when there is data of a FAX number or Internet address that can be provided, and “2” is set when there is no data (step 308).

  The control unit 51 writes the diagnosis result data 200 to the diagnosis result file 79 (step 309).

  The control unit 51 determines whether or not all data in the customer data 75 has been diagnosed (step 310). If other data remains, the control unit 51 returns to step 303 to perform diagnosis processing on the next customer data. When the diagnosis of all data in the customer data 75 is completed, the control unit 51 ends the process of the diagnosis program 43 (step 311).

  As shown in FIG. 10, the customer data 75 includes two pieces of customer data 401 and 403, and the diagnostic customer data 100 ′ and 100 ″ whose telephone numbers coincide with the customer data 401 and 403 in the diagnostic customer data 45 ′. If there is, the control unit 51 outputs the diagnosis result data 200 ′ and 200 ″ to the diagnosis result file 79.

The telephone number statuses 105 ′ and 105 ″ of the diagnostic customer data 100 ′ and 100 ″ are used as they are, the telephone number status 205 ′ of the diagnostic result data 200 ′ and 200 ″ cannot be used, and “9” and 205 ″ are used. Possible to "1",
The hello page status 207 ′ is “2” and “207” is “1”.

  Since the name “Yomi Ota” of the customer data 401 is one character different from the name “Yomi Ota” of the customer data 100 ′ for diagnosis, the name status 211 ′ of the diagnosis result data 200 ′ is almost the same as “2”. However, since the name of the customer data 403 matches the name of the customer data for diagnosis 100 ″, the name status 211 ″ of the diagnosis result data 200 ″ matches “1”.

  Since the address of the customer data 401 is deficient in the room number “202” as compared with the address of the diagnostic customer data 100 ′, the address status 215 ′ of the diagnosis result data 200 ′ is almost the same “2”. Further, since the address of the customer data 401 is the old address before the merger, the address update status 217 'becomes the old address notation “2”. Considering the address status 215 ′ and the address update status 217 ′, the postal matter non-delivery status 219 ′ is set to “9” which has a high possibility of non-delivery.

  On the other hand, the address of the customer data 403 coincides with the address of the diagnostic customer data 100 ″, and the postal mail non-delivery status of the diagnostic customer data 100 ″ is “1”, which has a very low possibility of non-delivery. The address status 215 ″ of the diagnosis result data 200 ″ is a match “1”, the address update status 217 ″ is a correct notation “1”, and the postage non-delivery status 219 ″ is “1” with a very low possibility of non-delivery. To do.

The telephone number update supplemental data status 221 ′ is “2” because the diagnostic customer data 100 ′ includes the data of the telephone number 103 ′ that cannot be used in the same way as the customer data 401.
Since the name and address have update supplementary data, the name update supplementary data status 223 ′ and the address update supplementary data status 225 ′ are “1”.

  Since the FAX number status 115 ′ and the Internet address status 117 ′ of the diagnosis customer data 100 ′ are “2”, the FAX number supplementary data status 227 ′ and the Internet address supplementary data status 229 ′ of the 200 ′ diagnosis result data are No "2".

  The telephone number update supplement data status 221 ", name update supplement data status 223", address update supplement data status 225 ", FAX number supplement status 227", and Internet address supplement data status 229 "of the diagnosis result data 200" of the customer data 403 are All are “1”.

  According to the present embodiment, the client computer diagnoses the customer database having the customer name, address, and telephone number using the diagnostic program, and deletes the customer data in which the telephone number is unavailable, or The customer database can be efficiently updated by deleting customer data having an address that is likely to be undeliverable.

  Moreover, since the incomplete part of the name, address, and telephone number data in the customer database can be recognized, the customer database can be easily corrected as necessary.

  The preferred embodiment of the customer database diagnosis apparatus according to the present invention has been described above with reference to the accompanying drawings, but the technical scope of the present invention is not limited to the above-described embodiment. It will be apparent to those skilled in the art that various changes and modifications can be made within the scope of the technical idea described in the claims, and these are naturally within the technical scope of the present invention. It is understood that it belongs.

  For example, the diagnostic program and the customer data for diagnosis may be updated by downloading via a network such as the Internet instead of the MO.

1 is a schematic configuration diagram of a customer database diagnosis apparatus 1 according to an embodiment of the present invention. The figure which shows one example of the hardware constitutions of the computer 3 The figure which shows the detail of the memory | storage device 5 of the computer 3 The figure which shows an example of the customer data 45 for a diagnosis The figure which shows one example of the hardware constitutions of the computer 7 The figure which shows the detail of the memory | storage device 9 of the computer 7 The flowchart which shows the operation | movement which the diagnosis program 43 of the customer database diagnosis apparatus 1 based on this invention diagnoses the customer data 75. FIG. The figure which shows an example of the diagnostic result data 200 of the diagnostic result file 79 which the diagnostic program 43 outputs as a diagnostic result of the customer data 75 The figure which shows an example of the value of each data item 203-229 of the diagnostic result data 200 The figure which shows an example of the diagnostic result of the customer data 75

Explanation of symbols

1 ……… Customer database diagnostic device 3 ……… Computer 5 ……… Storage device 7 ……… Computer 9 ……… Storage device 11 ……… MO
45 ……… Customer data for diagnosis

Claims (5)

A customer database that stores information about customers;
A diagnostic customer database that stores regularly updated customer information,
Means for comparing customer information stored in the customer database with customer information stored in the diagnostic customer database;
Means for generating a diagnostic result file by the comparing means;
A customer database diagnosis apparatus characterized by comprising: 2. The customer according to claim 1, wherein the customer information includes a telephone number, whether or not the telephone number is posted on a hello page, a name, an address, a mail non-delivery degree to the address, a FAX number, an Internet address, and the like. Database diagnostic device. The diagnosis result file includes the usage state of the telephone number, whether or not the telephone number is listed on the hello page, the matching state of the name, the matching state of the address, the updated state of the address, the non-delivery degree of mail to the address, The customer database diagnosis apparatus according to claim 1, further comprising presence / absence of supplementary data. A program for causing a computer to function as the customer database diagnosis apparatus according to claim 1. A recording medium recording a program for causing a computer to function as the customer database diagnosis apparatus according to claim 1.

Images