JP2017033595A - Family relationship presumption device and method and program for family relationship presumption - Google Patents

Abstract

PROBLEM TO BE SOLVED: To presume that a plurality of clients are in a same family even when households are different.SOLUTION: A family relationship presumption device includes: a storage unit for storing first client household identification information for identifying a household of a first client who is an existing client and first client information including information from which age of the first client can be specified; second client household identification information for identifying a household of a second client who is not the existing clients; a first acquiring unit for acquiring second client information including information from which age of the second client can be specified; and a first presumption unit for presuming a family relationship between the first client and the second client based on the information from which age can be specified when the second client household identification information included in the second client information acquired by the first acquirement unit and the first client household identification information included in the first client information stored to the storage unit are the same.SELECTED DRAWING: Figure 4

Description

  The present invention relates to a family relationship estimation device, a family relationship estimation method, and a program.

When providing various services (for example, financial services) to an individual customer, various services are provided not only to existing customers but also to their families. In this case, it is necessary to know who the family of the existing customer is. When grasping the family relationship of an existing customer, for example, by performing so-called “household name collation” in which if there are multiple existing customers with the same address and the same surname registered, they are considered to be customers of the same household It is conceivable to use a customer management system that can manage customers for each household.
For example, the information collation apparatus described in Patent Document 1 collates a plurality of records in a customer database, determines the identity, similarity, and relationship between records, and supports the realization of appropriate name identification settings.

Japanese Patent No. 5764942

  The conventional customer management system as described above manages the relationship between customers based on whether or not they are in the same household. For example, part of the name is collected for reasons such as living alone or getting married. If the customer's address is changed due to a new customer moving, the household name separation is canceled (they are not considered to be customers of the same household). As a result, the conventional customer management system, when the address changes due to separation, is managed as another unrelated household even though there is a parent-child relationship or sibling relationship, providing various services based on existing customers Cannot be targeted.

  The present invention has been made in view of the above points, and includes a family relationship estimation device, a family relationship estimation method, and a program capable of estimating that a plurality of customers in different households are the same family. provide.

(1) The present invention has been made to solve the above problems, and as one aspect of the present invention, first customer household identification information for identifying a household of a first customer who is an existing customer; A storage unit for storing first customer information including information capable of specifying the age of one customer; second customer household identification information for identifying a household of a second customer different from the existing customer; and the age of the second customer A first acquisition unit for acquiring second customer information including information capable of specifying the second customer household identification information and the storage unit included in the second customer information acquired by the first acquisition unit If the first customer household identification information included in the first customer information stored in is the same, the family relationship between the first customer and the second customer based on the information that can specify the age A first estimating unit for estimating Is a family relationship estimating device.

(2) Moreover, as 1 aspect of this invention, it is the family relationship estimation apparatus as described in (1), Comprising: Based on the said family relationship estimated by the said 1st estimation part, the said 1st customer and the said An update unit that adds family relationship information indicating the family relationship with a second customer to the first customer information or the second customer information and stores the information in the storage unit is provided.

(3) Moreover, as one aspect of the present invention, the family relationship estimation apparatus according to (2), wherein the prospective customer household identification for identifying a household of a prospective customer different from the first customer and the second customer A second acquisition unit for acquiring prospective customer information including information and family relation information indicating the family relation between the first customer and the prospective customer, and the updating unit includes the second acquisition unit The first customer household identification information or the second customer included in the first customer information or the second customer information stored in the storage unit and the first customer information stored in the storage unit When the household identification information is the same, the prospective customer information is stored in the storage unit.

(4) Moreover, as 1 aspect of this invention, it is the family relationship estimation apparatus as described in (3), Comprising: The said update part is contained in the said prospective customer information acquired by the said 2nd acquisition part. When the expected customer household identification information and the first customer household identification information included in the first customer information stored in the storage unit are the same, based on the family relationship information included in the expected customer information, The family relationship information indicating the family relationship between the prospective customer and the first customer is added to the first customer information or the prospective customer information and stored in the storage unit.

(5) Moreover, as 1 aspect of this invention, it is the family relationship estimation apparatus as described in (3) or (4), Comprising: From the family relationship information contained in the said 1st customer information, said 1st customer's The update unit includes a second estimation unit that estimates a family structure, and the update unit generates the expected customer information based on the family structure of the first customer estimated by the second estimation unit, Expected customer information is stored in the storage unit.

(6) Moreover, as 1 aspect of this invention, it is the family relationship estimation apparatus as described in any one of (2) to (5), Comprising: Said 1st estimation part or said 2nd estimation part An output unit that displays a result estimated by the display device.

(7) Moreover, as one aspect of the present invention, the family relationship estimation device according to any one of (2) to (6), wherein the first information is based on the family relationship indicated by the family relationship information. A family tree information generating unit that generates family tree information indicating a family tree including at least one of one customer, the second customer, or the prospective customer.

(8) According to another aspect of the present invention, there is provided (a family relationship estimation method using a computer, wherein the storage unit identifies first customer household identification information for identifying a household of a first customer who is an existing customer; A storing step of storing first customer information including information capable of specifying the age of one customer; and second customer household identification information for identifying a household of a second customer different from the existing customer by the first acquisition unit; The first acquisition step of acquiring second customer information including information capable of specifying the age of the second customer, and the second customer information acquired by the first acquiring unit by the first estimating unit If the second customer household identification information included in the first customer household identification information included in the first customer information stored in the storage unit is the same, based on information that can specify the age The family of the first customer and the second customer A first estimation step of estimating the engagement, a family relationship estimating method characterized by having a.

(9) As an aspect of the present invention, the computer includes first customer household identification information for identifying a household of a first customer who is an existing customer, and information that can specify the age of the first customer. Storage step for storing one customer information, second customer household identification information for identifying a household of a second customer different from the existing customer, and second customer information including information capable of specifying the age of the second customer Included in the first acquisition step to be acquired, the second customer household identification information included in the second customer information acquired in the first acquisition step, and the first customer information stored in the storage step A first estimation step of estimating a family relationship between the first customer and the second customer based on the information capable of specifying the age, To execute A gram.

  According to the present invention, even if a plurality of customers are in different households, it can be estimated that they are the same family.

It is the schematic which shows the outline | summary of a structure of the family relationship estimation system which concerns on one Embodiment of this invention. It is a figure which shows an example of the presentation screen shown by the family relationship estimation system which concerns on one Embodiment of this invention. It is a figure which shows an example of the presentation screen shown by the family relationship estimation system which concerns on one Embodiment of this invention. It is a block diagram which shows the function structure of the family relationship estimation apparatus which concerns on one Embodiment of this invention. It is a figure which shows the structure of the customer information which the family relationship estimation apparatus which concerns on one Embodiment of this invention acquires. It is a figure which shows the structure of the prospective customer information which the family relationship estimation apparatus which concerns on one Embodiment of this invention acquires. It is a figure which shows the structure of the family relationship information which the family relationship estimation apparatus which concerns on one Embodiment of this invention memorize | stores. It is the schematic which shows the outline | summary of the family tree information which the family relationship estimation apparatus which concerns on one Embodiment of this invention manages. It is a figure which shows an example of the family tree information which the family relationship estimation apparatus which concerns on one Embodiment of this invention produces | generates. It is a flowchart which shows operation | movement of the family relationship estimation apparatus which concerns on one Embodiment of this invention. It is a flowchart which shows operation | movement of the family relationship estimation apparatus which concerns on one Embodiment of this invention. It is a flowchart which shows operation | movement of the family relationship estimation apparatus which concerns on one Embodiment of this invention.

<Embodiment>
Hereinafter, an embodiment of the present invention will be described with reference to the drawings.

[Configuration of family relationship estimation system]
FIG. 1 is a schematic diagram showing an outline of a configuration of a family relationship estimation system according to an embodiment of the present invention. The family relationship estimation system 1 shown in the figure includes a family relationship estimation device 10 having a family relationship information database 100, a family relationship presentation device 20 (sales support terminal), a customer information management server 30 having a customer information database 300, And a prospective customer information input terminal 40 for inputting prospective customer information.

The family relationship estimation device 10 and the family relationship presentation device 20 and the family relationship estimation device 10 and the customer information management server 30 are communicatively connected by a communication network so that data can be transmitted and received. The communication network includes, for example, the Internet, a WAN (Wide Area Network), a LAN (Local Area Network), or any combination of these communication networks.
The family relationship estimation device 10 and the customer information management server 30 are configured to include a computer device such as a general-purpose computer or a personal computer. The family relationship presentation device 20 is a portable small information terminal such as a tablet terminal, a smartphone, or a notebook personal computer.

  The family relationship estimation system 1 is configured such that a plurality of existing customers of a company that uses the family relationship estimation system 1 (hereinafter referred to as company A) are family relationships (family relationship), and the existing customer of company A and the company A It is a system that acquires or estimates and manages family relationship information indicating that a person who is not an existing customer has a family relationship. The family relationship estimation system 1 is a system capable of presenting managed family relationship information to a sales support terminal used by employees of the sales staff of the company A.

  With the family relationship estimation system 1, for example, an employee in a sales position of the company A can perform a sales activity on another existing customer who is in a family relationship with the existing customer based on information on the existing customer. For example, in the family relationship estimation system 1, when information indicating that two existing customers are in a parent-child relationship is managed, the employee in the sales position of the company A is a life event of the existing customer who is a child. Products related to (for example, employment, marriage, etc.) can be introduced to existing customers who are parents.

  Further, with the family relationship estimation system 1, for example, an employee in a sales position of the company A is estimated based on information of a person who is a family relationship with an existing customer and is not an existing customer of the company A (hereinafter referred to as a potential customer). It becomes possible to conduct sales activities for customers. For example, a sales employee of Company A opens a new bank account while offering an incentive to preferentially pay a remittance fee between parents and children to prospective customers who are parent-child relationships of children of good existing customers. It is possible to provide various services by making sales activities to make the family of a good existing customer a customer.

  As described above, the company A can manage the family of existing customers as a whole by managing family relationship information including not only existing customers but also prospective customers by the family relationship estimation system 1.

  The family relationship estimation device 10 acquires customer information stored in the customer information database 300 of the customer information management server 30 and stores it in the family relationship information database 100 of its own family relationship estimation device 10. The customer information is information relating to the existing customer of the company A, and is information including, for example, the name, address, gender, age of the existing customer and identification information for identifying the existing customer. An example of the customer information table configuration will be described later.

Moreover, the family relationship estimation apparatus 10 acquires the prospective customer information input by the operator etc. in the prospective customer information input terminal 40, and memorize | stores it in the family relation information database 100 of its own family relation estimation apparatus 10. FIG. The prospective customer information is information on a person who is not an existing customer of the company A (expected customer), and is information on a person who is estimated to have a family relationship with the existing customer of the company A. The prospective customer information is information including, for example, the name, address, gender, age of the prospective customer, and information indicating the family relationship with the existing customer. An example of the table configuration of expected customer information will be described later.
In addition, about the transmission of prospective customer information from the prospective customer information input terminal 40 to the family relationship estimation apparatus 10, when prospective customer information is input by manual input by an operator etc. in the prospective customer information input terminal 40, it transmits each time. The configuration may be such that a plurality of prospective customer information stored in the prospective customer information input terminal 40 is collectively transmitted by batch processing.

  Expected customer information is, for example, information about the family of the existing customer who is listed in the claim beneficiary column of the application form for an existing customer who applied for life insurance, or a joint guarantor of an application form for an existing customer who applied for mortgage loan Information on the family of the existing customer described in the column and information on the family of the existing customer listed in the heir column of the application form by the existing customer who applied for the will trust.

[Example of a presentation screen by the family relationship estimation system]
Hereinafter, an example of a screen displayed on the family relationship presentation device 20 (sales support terminal) of the family relationship estimation system 1 will be described with reference to the drawings.
2 and 3 are diagrams illustrating an example of a presentation screen presented by the family relationship estimation system according to an embodiment of the present invention.

  The presentation screen p1 shown in FIG. 2 is a screen displayed on the family relationship presentation device 20 when the family relationship estimation device 10 estimates that a new customer and an existing customer are family relationships, and the estimated result is shown in FIG. This is a screen on which information to be displayed is displayed. Further, on this presentation screen p <b> 1, the sales staff of the company A select whether to register information indicating the estimated family relationship in the family relationship information database 100 of the family relationship estimation apparatus 10.

  As shown in FIG. 2, in the display area ar11, which is the upper display area of the presentation screen p1, there is a phrase “There is existing customer data that seems to be a family. Do you want to register family relationships?” It is displayed. This wording conveys to the sales staff of company A that there is a new customer who seems to have a family relationship with an existing customer, and the family relationship information of the family relationship estimation apparatus 10 is transmitted to the family relationship information. This is a notification text for prompting an operation for designating whether or not to register in the information database 100.

  Further, as shown in FIG. 2, the display area ar11, which is the upper display area of the presentation screen p1, has “107” in the “ID” column, “Sakiko Suzuki” in the “Name” column, and “Age” columns. The table shows “42 years old” and “female” in the “sex” column, and an image showing a button “show details”. This table is a table that presents information (identification information (ID), name, age, and gender) related to a new customer who is considered to be in a family relationship with an existing customer to the sales staff of Company A. is there. The portion of the image showing the button “show details” displayed on the right side of this table is touched on the display unit (not shown) of the family relationship presentation device 20 which is a touch panel type liquid crystal display, for example. Then, more detailed information of the customer is displayed.

  As shown in FIG. 2, in the display area ar12 which is the middle display area of the presentation screen p1, the word “family candidate”, the word “candidate (1) Taro Suzuki ’s son” and the corresponding word An image showing a button labeled “Register” displayed on the right side of the text, a word “Candidate (2) Taro Suzuki ’s spouse”, and “Register” displayed on the right side of the text And an image showing a button labeled “or” and an image showing a button “not registered” displayed on the right side of the word. In the display area ar12, candidates (1), candidates (2),... Are displayed in the order in which the family relationships estimated by the family relationship presentation device 20 are likely to be high. That is, in the display area ar12 shown in FIG. 2, a new customer (“Saki Suzuki”) described in the table displayed in the display area ar11 may be a child of “Taro Suzuki” who is an existing customer. This means that the family relationship presentation device 20 estimates that the sex is the highest, and the family relationship presentation device 20 estimates that the possibility of being a spouse of the existing customer “Taro Suzuki” is the next highest.

  The employee of the sales staff of company A makes a judgment based on the information displayed in the display area ar13, which will be described later, so that “Sakiko Suzuki” becomes “Taro Suzuki” as shown as “candidate (1)”. Register family relationship information in the family relationship information database 100 as being a child of “Sama”, or “Sakiko Suzuki” is a spouse of “Taro Suzuki” as shown as “Candidate (2)” Select whether to register family relationship information in the family relationship information database 100 or whether to register family relationship information in the family relationship information database 100 as “Sakiko Suzuki” is not a family relationship with any existing customer. .

  When the employee of the sales staff of the company A registers the family relationship information indicating the family relationship indicated as the candidate (1) in the family relationship information database 100, “candidate (1) ˜” is described. The part of the image showing the button “Register” displayed on the right side of the wording is touched on a display unit (not shown) of the family relationship presentation device 20 which is a touch panel type liquid crystal display, for example. Similarly, the employees of the sales staff of the company A, when registering the family relationship information indicating the family relationship indicated as the candidate (2) in the family relationship information database 100, “candidate (2) ˜”. Touch the part of the image showing the button labeled “Register” displayed on the right side of the written word. In addition, in the case of not registering the family relationship information in the family relationship information database 100, the employee of the sales staff of the company A touches the part of the image showing the button “not registered”.

  As shown in FIG. 2, an image representing a family tree is displayed in a display area ar13 which is a lower display area of the presentation screen p1. The names displayed in the solid rectangular frame, that is, the persons named “Taro Suzuki”, “Jiro Suzuki”, and “Nanami Suzuki” represent an existing customer of Company A. And as this family tree shows, “Taro Suzuki” and “Jiro Suzuki” have a parent-child relationship (parent-child relationship), and “Jiro Suzuki” and “Nanami Suzuki” have a husband It is a wife (couple relationship).

  In addition, information indicating the age and gender is displayed below the full name displayed in the solid rectangular frame, and further below that, an image showing a button labeled “View details” is displayed. ing. When the part of the image showing the button is touched on a display unit (not shown) of the family relationship presentation device 20 which is a touch panel type liquid crystal display by, for example, a salesperson of the company A, the solid line More detailed information about the existing customer displayed in the rectangular frame is displayed.

  In addition, as shown in FIG. 2, two dotted rectangles are displayed. This portion indicated by the dotted rectangle is a person who is not a customer of the company A but is a family relationship. This means that the family relationship presentation device 20 has estimated that there is a person (probable customer). That is, it is expressed that the family relationship presentation device 20 estimates that “Taro Suzuki” has a prospective customer who is a spouse and “Jiro Suzuki” has a potential customer who is an older brother or older sister. .

"(1)" and "(2)" are respectively displayed in the dotted rectangular frames. The family relationships corresponding to the dotted rectangles displayed as “(1)” and “(2)” are the family relationships of “candidate (1)” and “candidate (2)” displayed in the display area ar12. It corresponds to.
The employees of the sales position of the company A are estimated and displayed in the display area ar12 by referring to the name, age, gender of the existing customer, more detailed information of the existing customer, and the family tree. It is determined whether or not information indicating the family relationship is registered in the family relationship information database 100 of the family relationship estimation apparatus 10.

  The presentation screen p2 shown in FIG. 3 is displayed on the family relationship presentation device 20 when the family relationship estimation device 10 estimates that the new customer and the prospective customer registered in the family relationship information database are the same person. This is a screen on which information indicating the estimated result is displayed. Further, in this presentation screen p2, the sales staff of the company A integrates the customer information of the new customer and the expected customer information of the expected family relationship customer in the family relationship information database 100 of the family relationship estimation device 10. Select whether or not to do.

  As shown in FIG. 3, in the display area ar21, which is the upper display area of the presentation screen p2, the word “Probable customer data that seems to be the same person exists. Do you want to integrate the data?” Is displayed. Has been. This wording tells the sales staff of company A that there is a new customer who seems to be the same person as the prospective customer registered in the family relationship information database 100. This is a notification text for prompting an operation for designating whether or not to integrate customer customer information and prospective customer information in the family relation information database 100 of the family relation estimation apparatus 10.

  As shown in FIG. 3, the display area ar22, which is the middle display area of the presentation screen p2, has the word “new customer data”, “41” in the “customer number” field, and “Suzuki” in the “name” field. An image showing a table with “Sakiko-sama”, “42 years old” in the “age” column, and “female” in the “sex” column, and a button with “show details” on the right side of this table And are displayed. In the display area ar22, the word “expected customer data”, “107” in the “ID” column, “Sakiko Suzuki” in the “name” column, “42 years old” in the “age” column, and “ A table in which “female” is described in the “sex” column and an image showing a button in which “view details” is displayed are displayed on the right side of the table. In addition, on the right side of the image indicating the button described as “view details”, the image indicating the button described as “to be integrated”, the word “or”, and “not to be integrated” are described. And an image showing the selected button.

  The information displayed in the display area ar22 is the customer information of the new customer and the expected customer information acquired from the expected customer information input terminal 40, and the family relationship presentation device 20 is the same person as the new customer. This is a display area for presenting prospective customer information indicating the prospective customer estimated to the sales staff of the company A. The family where the part of the image showing the button “show details” displayed on the right side of the table showing the customer information of the new customer or on the right side of the table showing the prospective customer information is a touch panel type liquid crystal display, for example When touched on a display unit (not shown) of the relationship presentation device 20, more detailed information of a new customer or a prospective customer is displayed.

Based on the information displayed in the display area ar23, which will be described later, the sales staff of Company A, for example, “Sakiko Suzuki” who is a new customer and “Sakiko Suzuki” who is already registered as a prospective customer. By selecting whether or not the customer information of the new customer and the prospective customer information of the prospective customer are integrated in the family relation information database 100 of the family relation estimation apparatus 10.
When an employee of a sales staff of company A integrates customer information of a new customer and prospective customer information in the family relationship information database 100, an image portion indicating a button described as “integrate” is displayed. For example, a touch is made on a display unit (not shown) of the family relationship presentation device 20 which is a touch panel type liquid crystal display. Similarly, the employee of the sales staff of the company A, when not integrating the customer information of the new customer and the prospective customer information in the family relationship information database 100, an image showing a button described as “not registered” Touch the part.

  As illustrated in FIG. 3, an image representing a family tree is displayed in the display area ar <b> 13 which is the lower display area of the presentation screen p <b> 2. Similarly to the family tree displayed in the display area ar13 of the presentation screen p1 shown in FIG. 2, the person displayed in the solid rectangular frame is an existing customer of the company A, “Taro Suzuki” and “Suzuki” “Jiro-sama” is a relationship between parents and children, and “Jiro Suzuki” and “Nanami Suzuki” are shown to be a couple relationship.

In addition, as shown in FIG. 3, two dotted quadrilaterals are displayed, which are present by the family relationship presentation device 20 as in the family tree displayed in the display area ar13 of FIG. Represents an estimated prospective customer.
The family tree displayed in the display area ar23 in FIG. 3 is different from the family tree displayed in the display area ar13 in FIG. 2, and a dotted rectangular frame indicating a prospective customer who is a spouse of “Taro Suzuki” Nothing is displayed on the inside, while a dotted-line square frame indicating a prospective customer who is an older brother or older sister of “Jiro Suzuki” shows a name, age, and gender “ An image showing a button with the words “Sakiko Suzuki”, “42 years old”, and “female” and a button that reads “See details” is displayed. When the part of the image showing the button is touched on a display unit (not shown) of the family relationship presentation device 20 which is a touch panel type liquid crystal display, for example, more detailed information of the prospective customer is displayed.

The person indicated by the dotted rectangle with the “★” mark displayed in the frame corresponds to the prospective customer displayed in the display area ar22 described above.
Personnel engaged in sales positions of company A are displayed in the new customer's name, age, gender, more detailed information on the customer displayed in the display area ar22, in the family tree of the display area ar22 and display area ar23 The customer of the new customer estimated to be the same person displayed in the display area ar12 by referring to the name, age, gender of the prospective customer, the detailed information of the prospective customer, and the family tree It is determined whether or not information and prospective customer information are integrated in the family relationship information database 100 of the family relationship estimation apparatus 10.

[Functional structure of family relationship estimation device]
The functional configuration of the family relationship estimation apparatus 10 will be described below with reference to the drawings.
FIG. 4 is a block diagram showing a functional configuration of the family relationship estimation apparatus according to an embodiment of the present invention. As illustrated, the family relationship estimation apparatus 10 includes a family relationship information database 100, a control unit 101, a customer information acquisition unit 102, a prospective customer information acquisition unit 103, a family relationship estimation unit 104, and a family structure estimation unit. 105, a family tree information generation unit 106, a family relationship information presentation unit 107, and a selection information acquisition unit 108.

The family relationship information database 100 (storage unit) is information (first customer household identification information) for identifying a household of an existing customer, for example, an address, a telephone number of a fixed telephone, or a household ID, and the age of an existing customer. Stores customer information (first customer information) including information that can identify the gender of an existing customer.
The family relationship information database 100 is a storage medium, for example, HDD (Hard Disk Drive), flash memory, EEPROM (Electrically Erasable Programmable Read Only Memory), RAM (Random Access read / write Memory; Read / write memory), ROM (Read Only Memory), or any combination of these storage media.

  Based on the family relationship estimated by the family relationship estimation unit 104 (first estimation unit), which will be described later, the control unit 101 (update unit) displays the family relationship information indicating the family relationship between the new customer and the existing customer. In addition to the information (first customer information), it is stored in the family relationship information database 100 (storage unit). In addition, the control unit 101 (update unit) acquires new customer information (second acquisition) acquired by a customer information acquisition unit 102 (first acquisition unit), which will be described later, family relationship information indicating the family relationship between an existing customer and a new customer. In addition to (customer information), it is stored in the family relationship information database 100 (storage unit) as customer information (first customer information).

  The control unit 101 (update unit) also includes information for identifying the household of the prospective customer (expected customer household identification) included in the prospective customer information acquired by the prospective customer information acquiring unit 103 (second acquisition unit) described later. Information), for example, an address or a telephone number of a fixed telephone, and the existing customer household identification information included in the customer information (first customer information) stored in the family relationship information database 100 (storage unit) are the same. In this case, the prospective customer information is stored in the family relationship information database 100 (storage unit).

  Moreover, the control part 101 (update part) is the prospective customer household identification information contained in the prospective customer information acquired by the prospective customer information acquisition part 103 (2nd acquisition part) mentioned later, and the family relationship information database 100 (memory | storage) If the existing customer household identification information included in the customer information (first customer information) stored in the (part)) is the same, based on the family relationship information included in the expected customer information, the prospective customer and the existing customer Family relationship information indicating the family relationship is added to the customer information (first customer information) and stored in the family relationship information database 100 (storage unit).

Moreover, the control part 101 (update part) produces | generates prospective customer information based on the family structure of the existing customer estimated by the family structure estimation part 105 (2nd estimation part) mentioned later, and produces | generates prospective customer information produced | generated. The information is stored in the family relationship information database 100 (storage unit).
The control unit 101 includes, for example, a CPU (Central Processing Unit).

  The customer information acquisition unit 102 (first acquisition unit) includes information for identifying a new customer's household (second customer household identification information), for example, an address, a telephone number of a fixed telephone, a household ID, etc. New customer information (second customer information) including age and gender of the new customer is acquired.

  The prospective customer information acquisition unit 103 (second acquisition part) is information (a prospective customer household identification information) for identifying the prospective customer's household, for example, an address or a telephone number of a fixed telephone, and the existing customer and the prospective customer. And prospective customer information including family relation information indicating a family relation.

  The family relationship estimation unit 104 (first estimation unit) includes new customer household identification information and family relationship included in the new customer information (second customer information) acquired by the customer information acquisition unit 102 (first acquisition unit). When the existing customer household identification information included in the customer information (first customer information) stored in the information database 100 (storage unit) is the same, the age and existing customer included in the new customer information (second customer information) Based on the age difference from the age included in the information and the gender included in the new customer information (second customer information), the family relationship between the existing customer and the new customer is estimated. An example of the determination logic used for this estimation will be described later.

  The family structure estimation unit 105 (second estimation unit) estimates the family structure of an existing customer from the family relationship information included in the customer information (first customer information).

  The family tree information generation unit 106 generates family tree information indicating the family tree based on the family relationship indicated by the family relationship information included in the customer information (first customer information).

  The family relationship information presentation unit 107 (output unit) displays the results estimated by the family relationship estimation unit 104 (first estimation unit) and the family structure estimation unit 105 (second estimation unit) as a family relationship presentation device 20 (display device). ).

  The selection information acquisition unit 108 acquires information selected by the user (employee of sales staff, etc.) from the family relationship presentation device 20 based on the information presented by the family relationship information presentation unit 107 (output unit). Here, the selected information is, for example, information indicating the family relationship selected by the user from a plurality of family relationship candidates presented by the family relationship information presentation unit 107 (output unit), family relationship information Information selected by the user as to whether or not the family relationship presented by the presenting unit 107 (output unit) is registered in the family relationship information database 100 and the new customer presented by the family relationship information presenting unit 107 (output unit) Information indicating that the user has selected whether or not to integrate customer information and prospective customer information registered in the family relationship information database 100 in the family relationship information database 100.

[Table structure of customer information]
Next, an example of a customer information table transmitted from the customer information database 300 of the customer information management server 30 to the family relationship estimation device 10 and stored in the family relationship information database 100 of the family relationship estimation device 10 will be described with reference to the drawings. While explaining.
FIG. 5 is a diagram showing a configuration of customer information acquired by the family relationship estimation apparatus according to an embodiment of the present invention.

As shown in the figure, the customer information table includes, for example, a column of seven items of “customer number”, “name”, “address”, “phone number”, “household ID”, “age”, and “gender”. It is configured two-dimensional tabular data.
In the column of the item “customer number”, a value indicating identification information for uniquely identifying an existing customer is stored. The identification information for uniquely identifying an existing customer is, for example, a CIF (Customers' Information Files) number used in a financial institution.
The "Name", "Address", "Telephone Number", "Age", and "Gender" columns contain values that indicate the name, address, phone number, age, and gender of existing customers, respectively. Yes.

In the column of “household ID”, identification information for uniquely identifying an existing customer's household is stored. For example, in the customer information table shown in FIG. 5, the “household ID” of an existing customer whose name is “Jiro Suzuki” is “H002”, and the “household ID” of an existing customer whose name is “Nanami Suzuki” is also the same. “H002”. That is, the existing customer whose name is “Jiro Suzuki” and the existing customer whose name is “Nanami Suzuki” are existing customers of the same household.
As the value of the item “household ID”, for example, in the customer information management server 30, the same value of the item “household ID” is assigned to a plurality of existing customers having the same address or telephone number of a fixed telephone. It is generated by the so-called household name identification process.

[Table structure of prospective customer information]
Next, an example of a table of prospective customer information input by an operator or the like at the prospective customer information input terminal 40, transmitted to the family relation estimation apparatus 10, and stored in the family relation information database 100 of the family relation estimation apparatus 10 will be described. Will be described with reference to FIG.
FIG. 6 is a diagram illustrating a configuration of prospective customer information acquired by the family relationship estimation apparatus according to the embodiment of the present invention.

As shown in the figure, the prospective customer information table is, for example, two-dimensional tabular data composed of four columns of “name”, “address”, “age”, and “gender”. The “Name”, “Address”, “Telephone Number”, “Age”, and “Gender” columns contain values for the prospect ’s name, address, phone number, age, and gender, respectively. Yes.
Here, it is assumed that the prospective customer information, which is tabular data including information about a plurality of prospective customers, is transmitted from the prospective customer information input terminal 40 to the family relationship estimation device 10, but the present invention is not limited to this. Absent. For example, each time an input is made by an operator or the like at the prospective customer information input terminal 40, the prospective customer information is individually transmitted from the prospective customer information input terminal 40 to the family relationship estimation apparatus 10 for each prospective customer. It may be a configuration.

  In addition, as described above, the prospective customer information includes, for example, information described in the insurance beneficiary column of the life insurance application form, information described in the joint guarantor column of the mortgage loan application form, or It may be information obtained from different information sources, such as information described in the heirs column of the will trust application. Therefore, the information included in each prospective customer information may be different. For example, certain prospective customer information may not include information indicating an address, but may include information indicating a telephone number of a fixed telephone. Further, for example, in certain prospective customer information (eg, prospective customer information as described in the heirs column), information indicating a family relationship with an existing customer (eg, a spouse or an actual child) , Etc.) may be included.

Here, the prospective customer information transmitted from the prospective customer information input terminal 40 to the family relationship estimation apparatus 10 is the prospective customer household identification information (information for identifying the prospective customer's household, for example, an address or a fixed telephone). Information including the telephone number).
Further, among the expected customer information transmitted in the above, existing customer household identification information identical to the expected customer information household identification information included in the expected customer information (information identifying the household of the existing customer, for example, address, fixed telephone Customer information including the telephone number or household ID of the customer) is stored in the family relationship information database 100 (storage unit), or, among the expected customer information transmitted above, the existing customer is included in the expected customer information. Is included in the family relationship information database 100 (storage unit).

  That is, it is clear that one of the existing customers stored in the family relationship information database 100 (storage unit) is in a family relationship, or because the household is the same, the existing customer is in a family relationship. When it is estimated, the family relationship estimation apparatus 10 stores the expected customer information acquired from the expected customer information input terminal 40 in the family relationship information database 100 (storage unit).

[Table structure of family relationship information]
Next, an example of a table of family relationship information stored in the family relationship information database 100 of the family relationship estimation apparatus 10 will be described with reference to the drawings. The family relationship information table is a table in which customer information and prospective customer information are integrated, and the family relationship estimation apparatus 10 can manage family relationships including existing customers and prospective customers by the family relationship information table. .
FIG. 7 is a diagram illustrating a configuration of family relationship information stored in the family relationship estimation apparatus according to an embodiment of the present invention.

As illustrated, the family relationship information table includes, for example, “ID”, “customer number”, “name”, “address”, “phone number”, “household ID”, “age”, “gender”, “father” This is two-dimensional tabular data composed of a column of 13 items of “ID”, “Mother ID”, “Child ID”, “Spouse ID”, and “Family ID”.
In the column of the “ID” item, values of identification information for uniquely identifying individuals including existing customers and prospective customers are stored. The value of the item “ID” is assigned by the family relationship estimation apparatus 10.
In the column of the item “customer number”, a value acquired from the expected customer information described above is stored.
In the columns of the “address”, “age”, and “gender” items, values acquired from the above-described customer information or prospective customer information are stored.
In the columns of “phone number” and “household ID”, values acquired from the customer information described above are stored.

In the columns of the items “Father ID”, “Mother ID”, “Child ID”, and “Spouse ID”, the family relationship estimation apparatus 10 estimates, and the family relationship is presented by the employee of the sales staff of company A, etc. The value of the item “ID” of other existing customers or prospective customers linked based on the family relationship information registered in the device 20 is stored.
Note that the values of the items “Father ID”, “Mother ID”, “Child ID”, and “Spouse ID” are the values of existing customers and others by using the family relationship estimation logic described later by the family relationship estimation apparatus 10. Is generated based on information indicating the result of estimating the family relationship with the existing customer or the prospective customer, prospective customer information including information indicating the family relationship, and the like.

  For example, in the family relation information table shown in FIG. 7, the values of the “child ID” items of existing customers whose “ID” item value is “101” are “103, 104”. In addition, the value of the item “Father ID” of the existing customers whose values of the item “ID” are “103” and “104” are both “101”. By storing the family relationship information in this way, the family relationship estimation device 10 can use the existing customer whose “ID” item value is “101” and the existing customer whose “ID” item value is “103”. It can be managed that the family relationship between the customer and the existing customer who is “104” is a father-child relationship.

  For example, in the family relationship information table shown in FIG. 7, the value of the “spouse ID” item of an existing customer whose “ID” item value is “101” is “102”. Further, the value of the item “spouse ID” of the prospective customer whose value of the item “ID” is “102” is “101”. By storing the family relationship information in this manner, the family relationship estimation apparatus 10 expects the existing customer whose “ID” item value is “101” and the “ID” item value to be “102”. It is possible to manage that the family relationship with the customer is a couple relationship.

  In the column of the “family ID” item, identification information for uniquely identifying the same family is stored. For example, in the family relationship information table shown in FIG. 7, the existing customer whose “ID” item value is “104” and “105”, and the prospective customer whose “ID” item value is “106” and “ The value of the item “family ID” of the prospective customer “107” is “F002”. That is, the existing customers whose “ID” item values are “104” and “105” and the prospective customers whose “ID” item values are “106” and “107” are the same family. Show.

  Note that the value of the item “family ID” is, for example, “father ID”, “mother ID”, “child ID” generated by the family relationship estimation device 10 using the family relationship determination logic described below, and It is generated based on the value of the item of “spouse ID”, expected customer information including information indicating family relations, and the like.

[Management of family tree information]
As described above, the family relationship estimation device 10 uses the customer information acquired from the customer information management server 30 (for example, the information in the customer information table shown in FIG. 5) and the expected customer information acquired from the expected customer information input terminal 40 ( For example, family relationship information (for example, information in the family relationship information table shown in FIG. 7) is generated and updated based on the information of the prospective customer information table shown in FIG. Then, the family relationship estimation device 10 uses the values of the items “Father ID”, “Mother ID”, “Child ID”, and “Spouse ID” included in the generated / updated family relationship information, etc. Generating and updating genealogical information.

FIG. 8 is a schematic diagram showing an outline of family tree information managed by the family relationship estimation apparatus according to an embodiment of the present invention.
The family tree information shown in FIG. 8 is information representing the family tree generated based on the information shown in the family relationship information table shown in FIG. In the family relationship information, existing customers are represented by solid rectangles and prospective customers are represented by dotted rectangles. In the family relationship information, the marital relationship is represented by a double line connecting right and left quadrilaterals, and the parent-child relationship is represented by a solid line connecting adjacent quadrilaterals up and down. In the case of a couple relationship, the square indicating the wife is arranged on the right side of the square indicating the husband. In the case of a parent-child relationship, the quadrangle indicating the child is arranged below the quadrangle indicating the parent. In addition, when there are a plurality of children, squares indicating the children are arranged from left to right in descending order of age.

  In the family relationship information table of FIG. 7, the value of the “spouse ID” item of the existing customer whose “ID” item value is “101” is “102”. Therefore, as illustrated in FIG. 8, the family relationship estimation apparatus 10 has a solid-line rectangle Sa1 representing an existing customer whose “ID” item value is “101”, and the “ID” item value is “102”. And the double line Lw1 connecting the quadrilateral Sa1 and the quadrangle Sb1 to the existing customer whose value of the item “ID” is “101” and the item of the item “ID” Generating family tree information indicating a family tree indicating that the prospective customer whose value is “102” has a marital relationship.

  In the family relationship information table of FIG. 7, the values of the “child ID” items of existing customers whose “ID” item value is “101” are “103, 104”. Therefore, as illustrated in FIG. 8, the family relationship estimation apparatus 10 has a solid line rectangle Sa1 representing an existing customer whose value of the item “ID” is “101” and the value of the item “ID” is “103”. The dotted line Sb2 representing the prospective customer and the solid line Sa2 representing the existing customer whose value of the item of “ID” is “104”, and the solid line Ls1 connecting the square Sa1, the square Sb2 and the square Sa2, respectively. To the existing customer whose “ID” item value is “101”, the prospective customer whose “ID” item value is “103”, and the existing customer whose “ID” item value is “104”. Generate genealogy information indicating a genealogy diagram indicating that the parent-child relationship is.

  In the family relationship information table of FIG. 7, the value of the “age” item of the prospective customer whose value of the “ID” item is “103” is “33”, and the value of the “ID” item is The value of the item “age” of the existing customer “104” is “30” years old. From this, it can be seen that the prospective customer whose value of the item “ID” is “103” is older than the existing customer whose value of the item “ID” is “104”. In addition, the family relationship estimation apparatus 10 represents an existing customer whose value of the item “ID” is “104” on the right side of the dotted rectangle Sb2 representing the prospective customer whose value of the item “ID” is “103”. Generating family tree information indicating a family tree in which the solid quadrilaterals Sa2 are arranged.

  In addition, when it is clear that the prospective customer exists based on the family relation information included in the family relation information table, the family relation estimation device 10 regardless of the prospective customer information acquired from the prospective customer information input terminal 40, Information indicating a new prospective customer may be automatically added to the family relationship information table.

  For example, the prospective customer information acquired from the prospective customer information input terminal 40 does not include information on the prospective customer whose value of the item “ID” corresponding to the dotted rectangle Sb1 shown in FIG. 8 is “102”. Suppose. Even in that case, the family relationship estimation apparatus 10 uses the “child ID” item of the existing customer whose “ID” item value is “101” in the family relationship information included in the family relationship information table shown in FIG. Since the values “103, 104” are stored in the existing customer, it can be recognized that the existing customer whose “ID” item value is “101” has a child. As a result, the family relationship estimation apparatus 10 has a child for an existing customer whose value of the item “ID” is “101”, and therefore the existing customer whose value of the item “ID” is “101”. Recognize that a spouse is likely to exist. The family relationship estimation apparatus 10 automatically generates information on a prospective customer indicating a spouse of an existing customer whose value of the item “ID” is “101”, adds the information to the family relationship information table, and adds the prospective customer added. The family tree information is updated based on the information.

  In addition, in the family relationship information indicated by the family relationship information table, when customer information indicating parents or prospective customer information indicating parents is not registered for a certain existing customer, customer information indicating the second child or the second child is indicated. When the customer information indicating the first child or the expected customer information indicating the first child is not registered even though the expected customer information is registered, the family relationship estimation apparatus 10 is used as the expected customer information input terminal. Regardless of the prospective customer information acquired from 40, information indicating a new prospective customer is automatically added to the family relation information table.

  Based on the generated family tree information, the family relationship estimation apparatus 10 displays a display unit (not shown) of the family relationship presentation apparatus 20 such as the presentation screen p1 illustrated in FIG. 2 and the presentation screen p2 illustrated in FIG. )) Display part of the family tree as appropriate. The family tree is used when, for example, an employee in a sales position of company A who uses the family relationship presentation device 20 determines whether family relationship information is registered in the family relationship information database 100 or not.

[Family relationship determination logic]
Hereinafter, the family relationship determination logic when the family relationship estimation apparatus 10 estimates the family relationship based on the customer information acquired from the customer information management server 30 and the expected customer information acquired from the expected customer information input terminal 40 will be described. .

For example, when the system of the family relationship estimation system 1 is operated, the initial transfer of customer information data from the customer information database 300 of the customer information management server 30 to the family relationship information database 100 of the family relationship estimation apparatus 10 is performed. Or when customer information of a new customer is added to the family relationship information database 100 during system operation, or customer information of an existing customer registered in the family relationship information database 100 is updated during system operation. Is called.
Examples of cases where customer information of a new customer is added include a case where a new customer opens a bank account at a financial institution. In addition, the customer information of an existing customer may be updated, for example, when an existing customer moves due to advancement or marriage, or divorces a spouse.

Below, the case where the initial transfer of the data of customer information is performed from the customer information database 300 of the customer information management server 30 to the family relationship information database 100 of the family relationship estimation apparatus 10 will be described.
First, in the customer information management server 30, customer information data of some customers is extracted from the customer information database 300 and transferred to the family relationship information database 100 of the family relationship estimation apparatus 10. It should be noted that the customer information data of some customers is sufficient to satisfy that the estimation results are statistically reliable in the family relationship estimation logic described below. It is data of the number of cases.

  In the family relationship estimation apparatus 10 in which the customer information data of some of the customers described above has been transferred, for example, between a plurality of customers included in the transferred customer information by a manual operation or the like by an administrator of the family relationship estimation apparatus 10 Information indicating the family relationship is registered in the family relationship information table. For example, the administrator of the family relationship estimation apparatus 10 has the same value of the item “household ID” included in the customer information, the “address” included in the customer information, the “phone number” of the fixed telephone, etc. It is estimated that a plurality of customers are the same family based on the fact that the value of the information item that can identify each household is the same. Then, the administrator of the family relationship estimation apparatus 10 uses a family relationship (for example, parent-child relationship, marital relationship) of a plurality of existing customers estimated to be a family based on the values of items such as “sex” and “age”. Or brother-sister relationship etc.) and information indicating the estimated family relationship is registered in the family relationship information table.

  When the registration of the information indicating the family relationship in the family relationship information table by the administrator of the family relationship estimation device 10 is completed, the family relationship estimation unit 104 of the family relationship estimation device 10 displays the “age” included in the updated family relationship information. The upper limit value, the lower limit value, and the median value under the following conditions (1) to (5) are calculated and stored temporarily in a parameter storage area (not shown).

(1) Median age difference between existing customers registered as parent-child relationship (2) Upper limit and lower limit of age difference between existing customers registered as marital relationship (3) The value of the item of “Gender” is Median age difference between existing customers who are “male” and existing customers registered as children of the existing customer (4) Existing customers whose “gender” item is “female” and the existing customers Median age difference between existing customers registered as children of (5) Upper and lower limits of age difference between existing customers registered as siblings

  For example, in the case of (1) above, assuming that there are a total of 5 existing customer groups registered as parent-child relationships in the family relationship information, the age difference between the parent and child of each group is “25”, “27”, respectively. It is assumed that the age is “28”, “32”, and “36”. In this case, the median value of “28” is temporarily stored in the parameter storage area (not shown) described above. An average value may be used instead of the median value.

  Next, the customer information management server 30 extracts all the remaining data from the customer information database 300 excluding the customer information data of some of the customers extracted above, and the family of the family relationship estimation apparatus 10 The relation information database 100 is migrated.

  In the family relationship estimation apparatus 10 that has migrated all the remaining data described above, the family relationship estimation unit 104 of the family relationship estimation apparatus 10 displays the family relationship information included in the migrated customer information as a family relationship. Registered in the information table. For example, the family relationship estimation unit 104 identifies the household value such as “address” or “phone number” of the fixed phone included in the customer information that the value of the item “household ID” included in the customer information is the same. It is estimated that a plurality of customers are the same family based on the fact that the values of the items of information that can be made are the same. Then, the family relationship estimation unit 104 is based on the values such as “sex” and “age” items, and the upper limit value, lower limit value, and median value stored in the parameter storage area (not shown). Then, the family relationship of a plurality of existing customers estimated to be a family is estimated by the following family relationship determination logic, and information indicating the estimated family relationship is registered in the family relationship information table.

  The “age difference n” described below indicates a value obtained by subtracting the age of an existing customer (hereinafter also referred to as a family customer) from the age of the existing customer, which may be a family relationship of the existing customer. Shall. For example, if the value of the item “age” in the customer information of the existing customer is “30” and the value of the item “age” in the customer information of the family customer is “65”, the age difference n is "-35" years old.

Determination logic (1): If the condition of “age difference n <(median difference of parent-child relationship)” is satisfied, the family customer is estimated to be the parent of the existing customer.
Judgment logic (2): Family customer is a spouse of an existing customer if the condition of “lower limit of (married couple's age difference) <age difference n <upper limit of (married couple's age difference)” is met It is estimated that.
Determination logic (3): If the condition “17 <age difference n <(median difference of father-child relationship)” is satisfied, the family customer is estimated to be a child of the existing customer. Note that the parameter value of “17 years old” described above is due to the fact that the age of boys stipulated by Japanese law is 18 years old. Therefore, the parameter value of “17 years old” may be changed due to a law revision or the like.
Determination logic (4): If the condition of “15 <age difference n <(median difference of mother-child relationship)” is satisfied, the family customer is estimated to be a child of the existing customer. Note that the parameter value of “15” above is due to the fact that the age limit for girls, as stipulated in Japanese law, is 16. Therefore, the parameter value of “15 years old” may be changed due to a law revision or the like.
Judgment logic (5): If the condition of “lower limit of (sibling age difference) <age difference n <upper limit of age difference of sibling relationship” is met, the family customer presume.

  In addition, every time one registration of information indicating family relationships in the family relationship information table based on the above-described family relationship determination logic is completed, the family relationship estimation unit 104 of the family relationship estimation apparatus 10 updates the updated family relationship information. Recalculate the upper limit value, the lower limit value, and the median value included in the above conditions (1) to (5) in the entire value of the “age” item included, and a parameter storage area (not shown) The parameter information stored in is updated with the recalculated parameter value. Thus, each time customer information is newly added to the family relationship information database 100, the parameter values indicating the upper limit value, the lower limit value, and the median value included in the above-described conditions (1) to (5) are corrected. Is done.

  Even when the customer information of a new customer is added to the family relationship information database 100 or the customer information of an existing customer registered in the family relationship information database 100 is updated during the system operation of the family relationship estimation system 1, As in the initial transition, the family relationship estimation unit 104 sets values such as “sex” and “age” items, and upper and lower limits stored in a parameter storage area (not shown), and Based on the median, the following family relationship determination logic is used to estimate the family relationships of a plurality of existing customers who are estimated to be family members, and information indicating the estimated family relationships is registered in the family relationship information table. Each time customer information is newly added or updated in the family relationship information database 100, the family relationship estimation unit 104 calculates the upper limit value, the lower limit value, and the median value in the above conditions (1) to (5). Recalculate and correct the parameter value.

  When the family relationship between the family customer and the existing customer is estimated based on the above family relationship determination logic, it is determined that the relationship is family relationship in a plurality of determination logics among the determination logics (1) to (5). May be. For example, when the age of an existing customer is “65” and the gender is “male”, the age of the family customer is “46” and the gender is “female”, the customer information indicating the family customer is determined by the decision logic. There is a case where it is estimated that the relationship is a marital relationship by (2), the parent-child relationship is determined by the determination logic (3), and the brother-sister relationship is determined by the determination logic (5).

  In such a case, the family relationship estimation unit 104 determines that the family relationship is based on the degree of approximation between the value of the age difference n and the upper limit value, lower limit value, or median value used in each determination logic. For each of the determination logics, the possibility of family relation is calculated. Then, the family relationship estimation unit 104 ranks the estimated family relationship candidates in descending order of the calculated possibility.

Then, the family relationship information presentation unit 107 generates a presentation screen including information indicating the candidate order and causes the family relationship presentation device 20 to display the presentation screen. For example, as shown in FIG. 9, a presentation screen including a family tree showing the candidate order is displayed on the family relationship presentation device 20. FIG. 9 is generated by the family relationship estimation device according to an embodiment of the present invention. It is a figure which shows an example of family tree information.

  In the family tree shown in FIG. 9, in the above-described example, it is determined by the determination logic (2), the determination logic (3), and the determination logic (5) that the family customer and the existing customer are in a family relationship. A family tree when the family relationship estimation unit 104 estimates that the family customer is most likely a child of an existing customer, the next most likely to be a spouse, and the least likely to be a sister Show.

In FIG. 9, a solid quadrilateral Sa3 shaded is an existing customer in the above-described example. A solid rectangle Sa5 represents an existing customer corresponding to a child of the existing customer, and a character “1” indicating that the candidate rank is first is displayed in the frame of the rectangle Sa5. Similarly, a dotted line rectangle Sb3 and a solid line rectangle Sa4 represent a prospective customer corresponding to an existing customer's spouse and an existing customer corresponding to a sister of the existing customer, respectively, and are within the frame of the rectangle Sb3 and the rectangle Sa4. A character “2” indicating that the candidate rank is second and a character “3” indicating that the candidate rank is third are displayed.
In the presentation screen displayed on the family relationship presentation device 20, the family tree showing the candidate order is displayed in this manner, so that, for example, the sales staff of the company A can connect the existing customer and the family customer. Candidates for family relationships can be easily recognized, and family relationships can be easily selected.

[Operation of family relationship estimation device]
[Operation during initial migration of customer information]
Below, operation | movement of the family relationship estimation apparatus 10 is demonstrated, referring drawings.
10 to 12 are flowcharts showing the operation of the family relationship estimation apparatus according to an embodiment of the present invention.

The flowchart shown in FIG. 10 shows the initial transfer of customer information data from the customer information database 300 of the customer information management server 30 to the family relationship information database 100 of the family relationship estimation device 10 when the family relationship estimation system 1 is in operation. The operation | movement of the family relationship estimation apparatus 10 in the case where is performed is shown.
This flowchart is obtained when customer information of a part of existing customers is extracted from the customer information database 300 in the customer information management server 30 and the customer information is transmitted to the family relationship estimation device 10 of the customer information management server 30. Start. As described above, the customer information of some existing customers means that the calculated parameter values are statistical when the parameter values (upper limit value, lower limit value, and median value) are calculated based on the customer information. The number of data is sufficient to satisfy that the level is reliable.

(Step S 001) The family relationship estimation apparatus 10 acquires customer information of some existing customers transmitted from the customer information management server 30 and stores it in the family relationship information database 100. Thereafter, the process proceeds to step S002.

(Step S002) The family relationship estimation apparatus 10 indicates that the value of the item “household ID” included in the acquired customer information is the same, the “address” included in the customer information, the “phone number” of the fixed telephone, etc. Based on the fact that the value of the item of information that can identify the household of the same is the same, the value of the “family ID” that identifies the family is generated, and the family relationship generated based on the acquired customer information The value of “family ID” is registered in the information table. That is, the family relationship estimation apparatus 10 performs so-called household name identification based on information that can identify a household. Thereafter, the process proceeds to step S003.

(Step S003) The same “Family ID” value is stored for the customer information in which the “Family ID” value is registered in Step S002, for example, manually by the administrator of the family relationship estimation apparatus 10 Family relationships between a plurality of customers based on a plurality of customer information are estimated, and information indicating the estimated family relationships (for example, “father ID”, “mother ID”, “child ID”, or “spouse ID”) And the like are input to the family relationship estimation apparatus 10. The family relationship estimation device 10 registers information indicating the input family relationship in the family relationship information table. For customer information for which family relationships have not been estimated, information indicating family relationships is not registered in the family relationship information table. Thereafter, the process proceeds to step S004.

(Step S004) When the registration process of the information indicating the family relationship in Step S003 is completed for all the customer information in which the value of “Family ID” is stored, the process proceeds to Step S005. Otherwise, the process returns to step S003 and the process is continued.

(Step S005) The family relationship estimation unit 104 of the family relationship estimation device 10 described above (1) in the entire value of the item “age” included in the family relationship information in which the information indicating the family relationship is registered in Step S003. Through the conditions (5) to (5), an upper limit value, a lower limit value, and a median value (that is, a value that becomes a parameter value of the family relationship determination logic) are calculated. Thereafter, the process proceeds to step S006.

(Step S006) The family relationship estimation apparatus 10 acquires customer information of existing customers other than some of the existing customers acquired in step S001 (customer information of the remaining existing customers) and stores it in the family relationship information database 100. Thereafter, the process proceeds to step S007.

(Step S007) The family relationship estimation apparatus 10 indicates that the value of the item “household ID” included in the acquired customer information is the same, the “address” included in the customer information, the “phone number” of the fixed telephone, etc. Based on the fact that the value of the item of information that can identify the household of the same is the same, the value of the “family ID” that identifies the family is generated, and the family relationship generated based on the acquired customer information The value of “family ID” is registered in the information table. That is, the family relationship estimation apparatus 10 performs so-called household name identification based on information that can identify a household.
For the customer information in which the value of “family ID” is registered, the family relationship estimation device 10 determines the values of the items such as “sex” and “age” included in the customer information, and the upper limit value calculated in step S005 Based on the lower limit value and the median value, the family relationship determination logic described above estimates the family relationship among a plurality of customers based on the customer information in which the same “family ID” value is registered, and estimates Information indicating the family relationship is registered in the family relationship information table. Thereafter, the process proceeds to step S008.

(Step S008) The family relationship estimation unit 104 of the family relationship estimation apparatus includes the “age” included in the family relationship information table in the family relationship information table updated by registering the information indicating the family relationship in Step S007. The parameter values (upper limit value, lower limit value, and median value) based on the above-described conditions (1) to (5) in the entire value of the item are recalculated and updated. Thereafter, the process proceeds to step S009.

(Step S009) When the process of estimating the family relationship in step S007 is completed for all customer information in which the value of “family ID” is registered, the process of this flowchart ends. When that is not right, it returns to step S007 and the family relationship estimation apparatus 10 continues the said process.

[Operation when registering customer information of a new customer]
The flowchart shown in FIG. 11 shows the operation of the family relationship estimation device 10 when customer information of a new customer is registered in the family relationship information database 100 of the family relationship estimation device 10 when the family relationship estimation system 1 is operated. Show.
This flowchart is started when customer information of a new customer is transmitted from the customer information database 300 of the customer information management server 30 to the family relationship estimation apparatus 10.

(Step S <b> 101) The family relationship estimation apparatus 10 acquires customer information of an existing customer of a new customer transmitted from the customer information management server 30 and stores it in the family relationship information database 100. Thereafter, the process proceeds to step S002.

(Step S102) The family relationship estimation apparatus 10 stores the same value as the value of the item “household ID” included in the acquired customer information of the new customer, or the customer information of the new customer. The customer relationship information database 100 is searched for customer information in which the same value as the value of the information item that can identify the household such as “address” and “phone number” of the fixed telephone is included. That is, the family relationship estimation device 10 searches for an existing customer in the same household as the new customer. When the corresponding existing customer is searched, the family relationship estimation apparatus 10 generates a value of “family ID” for identifying the family, and based on the customer information of the new customer in the family relationship information table. The value of the same “family ID” item is registered in the family relationship information and the family relationship information based on the searched customer information of the existing customer. Thereafter, the process proceeds to step S103.

(Step S103) If there is an existing customer in the same household as the new customer in step S102, the process proceeds to step S104. Otherwise, the process of this flowchart ends.

(Step S104) The family relationship estimation apparatus 10 includes values such as “sex” and “age” items included in each customer information registered with the same “family ID” value in step S102, and a parameter storage area ( Based on parameter values (upper limit value, lower limit value, and median value) stored in (not shown) and based on customer information in which the same “family ID” value is registered by the family relationship determination logic described above. Estimate family relationships between customers. Thereafter, the process proceeds to step S105.

(Step S105) In step S104, when the family relationship estimation apparatus 10 estimates that a new customer and an existing customer corresponding to customer information each registered with the same “family ID” value are family relationships The process proceeds to step S106. Otherwise, the process of this flowchart ends.

(Step S106) The family relationship information presentation unit 107 of the family relationship estimation device 10 provides an existing customer to the user (sales worker, etc.) based on the information indicating the family relationship estimated by the family relationship estimation unit 104. A presentation screen for confirming (selecting) whether or not to register the family relationship information indicating the family relationship with the new customer in the family relationship information database 100. The information is displayed on the family relationship presentation device 20. Thereafter, the process proceeds to step S107.

(Step S <b> 107) The selection information acquisition unit 108 of the family relationship estimation device 10 indicates that the user has selected whether or not to register the family relationship information in the family relationship information database 100 from the family relationship presentation device 20. Get information. When the information is information for instructing to register the family relation information in the family relation information database 100, the process proceeds to step S108. Otherwise, the process of this flowchart ends.

(Step S108) Based on the information indicating the family relationship selected by the user, the family relationship estimation apparatus 10 creates a new customer and an existing customer based on the customer information in which the value of the same “family ID” item is registered in step S102. For each of these, information indicating the family relationship is registered in the family relationship information table. Thereafter, the process proceeds to step S109.

(Step S109) The family relationship estimation unit 104 of the family relationship estimation device includes the “age” included in the family relationship information table in the family relationship information table updated when the information indicating the family relationship is registered in step S108. The parameter values (upper limit value, lower limit value, and median value) based on the above-described conditions (1) to (5) in the entire value of the item are recalculated and updated.
Thus, the process of this flowchart is completed.

[Operation when registering prospective customer information]
In the flowchart shown in FIG. 12, during the system operation of the family relationship estimation system 1, expected customer information is transmitted from the expected customer information input terminal 40 to the family relationship estimation device 10, and the expected customer information is registered in the family relationship information database 100. The operation | movement of the family relationship estimation apparatus 10 in the case of being performed or not registered is shown.
This flowchart starts when the prospective customer information is input at the prospective customer information input terminal 40 and transmitted to the family relationship estimation apparatus 10.

(Step S <b> 201) The prospective customer information acquisition unit 103 of the family relationship estimation apparatus 10 acquires the prospective customer information transmitted from the prospective customer information input terminal 40 and stores it in the family relationship information database 100. Thereafter, the process proceeds to step S202.

(Step S <b> 202) The family relationship estimation apparatus 10 indicates that the prospective customer based on the prospective customer information acquired from the prospective customer information input terminal 40 is a family relation with the existing customer based on the existing customer information stored in the family relation information database 100. It is determined whether or not there is. For example, in the family relationship estimation device 10, information indicating the family relationship between the prospective customer and the existing customer is included in the prospective customer information, and customer information indicating the existing customer is stored in the family relationship information database 100. In this case, it is determined that the prospective customer and the existing customer have a family relationship. If the family relationship estimation apparatus 10 determines that the prospective customer and the existing customer are family relationships, the process proceeds to step S203. Otherwise, the family relationship estimation apparatus 10 ends the process of this flowchart without storing the expected customer information acquired from the expected customer information input terminal 40 in the family relationship information database 100.

(Step S <b> 203) The family relationship estimation apparatus 10 determines whether or not existing customer information indicating an existing customer who is considered to be the same person as the expected customer indicated by the expected customer information is registered in the family relationship information database 100. . For example, the family relationship estimation device 10 determines whether the prospective customer and the existing customer are based on information indicating the name, address, age, gender, and family relationship included in the prospective customer information and the customer information of the existing customer. It is determined whether or not they are the same person. If the family relationship estimation apparatus 10 determines that customer information indicating an existing customer who is considered to be the same person as the prospective customer is registered in the family relationship information database 100, the process proceeds to step S207. Otherwise, the process proceeds to step S204.

(Step S <b> 204) The family relationship estimation apparatus 10 registers the expected customer information acquired from the expected customer information input terminal 40 in the family relationship information database 100. Thereafter, the process proceeds to step S205.

(Step S205) The family relationship estimation apparatus 10 determines whether or not information indicating the age of the prospective customer is included in the prospective customer information acquired from the prospective customer information input terminal 40. If information indicating the age of the prospective customer is included, the process proceeds to step S206. Otherwise, the process of this flowchart ends.

(Step S206) The family relationship estimation unit 104 of the family relationship estimation device includes the “age” included in the family relationship information table in the family relationship information table updated when the information indicating the family relationship is registered in step S108. The parameter values (upper limit value, lower limit value, and median value) based on the above-described conditions (1) to (5) in the entire value of the item are recalculated and updated. Thus, the process of this flowchart is completed.

(Step S207) The family relationship information presentation unit 107 of the family relationship estimation apparatus 10 includes the expected customer information of the prospective customer and the customer information of the existing customer for the prospective customer and the existing customer estimated to be the same person. Based on this, information indicating that the prospective customer and the existing customer are considered to be the same person is presented to the user (employee of the sales staff, etc.), and the prospective customer information of the prospective customer and the customer of the existing customer The family relationship presentation apparatus 20 displays a presentation screen for the user to confirm (select) whether or not information is integrated in the family relationship information database 100. Thereafter, the process proceeds to step S208.

(Step S <b> 208) The selection information acquisition unit 108 of the family relationship estimation device 10 selects from the family relationship presentation device 20 whether or not to integrate prospective customer information and customer information of existing customers in the family relationship information database 100. Acquire information indicating that this has been done. When the information is information indicating that the prospective customer information and the customer information of the existing customer are integrated, the process proceeds to step S209. Otherwise, the process proceeds to step S204.

(Step S209) The family relationship estimation apparatus 10 includes prospective customer information transmitted from the prospective customer information input terminal 40, customer information indicating an existing customer estimated to be the same person as the prospective customer based on the prospective customer information, and Are integrated in the family relationship information database 100. That is, the family relationship estimation apparatus 10 includes information included in the prospective customer information indicating the prospective customer who is estimated to be the same person as the existing customer with respect to the customer information of the existing customer registered in the family relation information database 100. To update the family relationship information table.
Thus, the process of this flowchart is completed.

  As described above, according to the family relationship estimation system 1 according to an embodiment of the present invention, it is possible to estimate a family relationship even if a plurality of customers have different households.

  Further, in so-called conventional household name identification, when the address of a certain customer information is changed due to a move or the like in a plurality of customer information having the same identification information (for example, “household ID”) for identifying the household, Household name registration of customer information is canceled. As a result, in the conventional household name collation, family members who do not live together cannot be managed as families because their addresses are different. On the other hand, according to the family relationship estimation system 1 according to the embodiment of the present invention, identification information for identifying a family (for example, “family ID”) different from identification information for identifying a household (for example, “household ID”). ), The customer relationship based on the customer information can be managed as a family of other customers even if the address of the customer information is changed due to a move or the like.

  Moreover, according to the family relationship estimation system 1 according to an embodiment of the present invention, the family relationship is also determined using information (expected customer information) of a family (or a person who is assumed to be a family) of an existing customer who is not the customer of the company. Can be managed. Thereby, for example, a worker in a sales position can perform a sales activity on a family of an existing customer (or a person who is assumed to be a family) using the family relationship presentation device 20 (sales support terminal).

  Moreover, according to the family relationship estimation system 1 according to an embodiment of the present invention, information such as “age” and “gender” included in the customer information and prospective customer information of existing customers registered in the family relationship information database 100. Based on the above, it is possible to estimate the presence of a family member (of an existing customer) who is not registered in the family relationship information database 100. As a result, for example, a salesperson or the like can perform sales activities on a person who has neither customer information nor prospective customer information acquired and who is assumed to be a family of an existing customer or a family member. .

In addition, the family relationship estimation system 1 according to an embodiment of the present invention uses a determination logic that estimates whether each family relationship (parent, child, couple, sibling, etc.) is a family relationship. Is estimated. Furthermore, when it is estimated that the family relationship estimation system 1 corresponds to a plurality of family relationships, the family relationship estimation system 1 is more likely to be a family relationship based on the degree of approximation with the parameter values described above, and the like. And rank the candidates in the order of the estimated family relationships in descending order of possibility. The family relationship estimation system 1 presents a plurality of family relationship estimation results including the ranking results to the family relationship presentation device 20 (sales support terminal).
Thus, for example, an employee in a sales position refers to an estimation result indicating a plurality of family relationship candidates instead of a uniquely estimated family relationship estimation result. Since it is possible to determine whether to be registered in 100 including the judgment of the salesperson worker himself / herself, the family relationship information registered in the family relationship information database 100 becomes more accurate information.

  Moreover, according to the family relationship estimation system 1 according to an embodiment of the present invention, each time family relationship information is registered, the parameter value of the determination logic used for estimating the family relationship is corrected. As more people are registered, the accuracy of estimating family relationships increases.

  As described above, the embodiments of the present invention have been described in detail. However, the specific configuration is not limited to that described above, and various design changes and the like can be made without departing from the scope of the present invention. is there.

  In addition, you may make it implement | achieve part or all of the family relationship estimation apparatus 10 in embodiment mentioned above with a computer. In that case, the program for realizing the control function may be recorded on a computer-readable recording medium, and the program recorded on the recording medium may be read by the computer system and executed.

  Here, the “computer system” is a computer system built in the family relationship estimation apparatus 10 and includes an OS and hardware such as peripheral devices. The “computer-readable recording medium” refers to a storage device such as a flexible medium, a magneto-optical disk, a portable medium such as a ROM and a CD-ROM, and a hard disk incorporated in a computer system.

  Further, the “computer-readable recording medium” is a medium that dynamically holds a program for a short time, such as a communication line when transmitting a program via a network such as the Internet or a communication line such as a telephone line, In this case, a volatile memory inside a computer system that serves as a server or a client may be included that holds a program for a certain period of time. The program may be a program for realizing a part of the functions described above, and may be a program capable of realizing the functions described above in combination with a program already recorded in a computer system.

  Further, the family relationship estimation apparatus 10 in the above-described embodiment may be realized as an integrated circuit such as an LSI (Large Scale Integration). Each functional block of the family relationship estimation apparatus 10 may be individually made into a processor, or a part or all of them may be integrated into a processor. Further, the method of circuit integration is not limited to LSI, and may be realized by a dedicated circuit or a general-purpose processor. Further, in the case where an integrated circuit technology that replaces LSI appears due to progress in semiconductor technology, an integrated circuit based on the technology may be used.

DESCRIPTION OF SYMBOLS 1 ... Family relationship estimation system, 10 ... Family relationship estimation apparatus, 20 ... Family relationship presentation apparatus, 30 ... Customer information management server, 40 ... Expected customer information input terminal, 100 ... Family relationship information database (storage unit), 101 ... control unit (update unit), 102 ... customer information acquisition unit (first acquisition unit), 103 ... expected customer information acquisition unit (second acquisition) Part), 104 ... family relationship estimation part (first estimation part), 105 ... family structure estimation part (second estimation part), 106 ... family tree information generation part, 107 ... family Relation information presentation unit (output unit), 108 ... selection information acquisition unit, 300 ... customer information database

Claims (9)

A storage unit for storing first customer household identification information for identifying a household of a first customer who is an existing customer, and first customer information including information capable of specifying the age of the first customer;
A first acquisition unit for acquiring second customer household identification information for identifying a household of a second customer different from the existing customer, and second customer information including information capable of specifying the age of the second customer;
The second customer household identification information included in the second customer information acquired by the first acquisition unit and the first customer household identification information included in the first customer information stored in the storage unit. A first estimation unit that estimates a family relationship between the first customer and the second customer based on information that can specify the age when the age is the same;
A family relationship estimation device comprising: Based on the family relationship estimated by the first estimation unit, family relationship information indicating the family relationship between the first customer and the second customer is added to the first customer information or the second customer information. And an update unit to be stored in the storage unit,
The family relationship estimation apparatus according to claim 1, comprising: A prospective customer including prospective customer household identification information for identifying a household of an prospective customer different from the first customer and the second customer, and family relation information indicating the family relation between the first customer and the prospective customer A second acquisition unit for acquiring information;
The update unit includes the prospective customer household identification information included in the prospective customer information acquired by the second acquisition unit and the first customer information or the second customer information stored in the storage unit. The family relationship estimation apparatus according to claim 2, wherein when the first customer household identification information or the second customer household identification information is the same, the expected customer information is stored in the storage unit. The update unit includes the prospective customer household identification information included in the prospective customer information acquired by the second acquisition unit and the first customer household identification included in the first customer information stored in the storage unit. If the information is the same, based on the family relation information included in the prospective customer information, the family relation information indicating the family relation between the prospective customer and the first customer is the first customer information or the The family relationship estimation device according to claim 3, wherein the family relationship estimation device is stored in the storage unit in addition to the prospective customer information. A second estimation unit for estimating a family structure of the first customer from the family relation information included in the first customer information;
The update unit generates the expected customer information based on the family structure of the first customer estimated by the second estimation unit, and stores the generated expected customer information in the storage unit. The family relationship estimation device according to claim 3 or 4. An output unit that causes a display device to display a result estimated by the first estimation unit or the second estimation unit;
The family relationship estimation apparatus according to any one of claims 2 to 5, further comprising: A family tree information generating unit that generates family tree information indicating a family tree including at least one of the first customer, the second customer, or the prospective customer based on the family relationship indicated by the family relationship information;
The family relationship estimation device according to any one of claims 2 to 6, further comprising: A family relationship estimation method using a computer,
A storage step for storing first customer household identification information for identifying a household of a first customer who is an existing customer, and first customer information including information capable of specifying the age of the first customer;
The first acquisition unit acquires second customer information including second customer household identification information for identifying a household of a second customer different from the existing customer and information capable of specifying the age of the second customer. 1 acquisition step;
The first estimation unit includes the second customer household identification information included in the second customer information acquired by the first acquisition unit and the first customer information stored in the storage unit. When one customer household identification information is the same, a first estimation step of estimating a family relationship between the first customer and the second customer based on the information capable of specifying the age;
A family relationship estimation method characterized by comprising: On the computer,
Storing first customer household identification information for identifying a household of a first customer who is an existing customer, and first customer information including information capable of specifying the age of the first customer;
A first acquisition step of acquiring second customer household identification information for identifying a household of a second customer different from the existing customer, and second customer information including information capable of specifying the age of the second customer;
The second customer household identification information included in the second customer information acquired in the first acquisition step, and the first customer household identification information included in the first customer information stored in the storage step; Are the same, a first estimation step of estimating a family relationship between the first customer and the second customer based on the information capable of specifying the age;
A program for running

Images