JP2003030415A - System, method and program for managing customer database - Google Patents

Abstract

PROBLEM TO BE SOLVED: To allow a store side to dispense with a large scale management system construction and system operating personnel and also to allow a customer to dispense with carrying several membership cards with himself/herself. SOLUTION: The customer 1 registers personal information with a user terminal 10 and transmits the personal information to a management center server 20. The management center server 20 generates a barcode ID and transmits the barcode ID to the user terminal 10. A barcode ID common to a plurality of member systems is used for the same customer 1. The customer 1 displays the barcode ID on a displaying part 12 in doing shopping at an affiliated store, and a store terminal 30 reads the barcode ID with a barcode reader 33 and transmits the barcode ID together with member data to the management center server 20. The management center server 20 manages member data of a plurality of member systems in a customer multidatabase 25. The customer 1 can receive the member data of the plurality of member systems joined by the customer 1 from the management center server 20 with the user terminal 10 to display the member data in a list.

Description

Detailed Description of the Invention

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a customer database management system, a customer database management method, and a customer database management program, and more particularly to a customer database management system for managing member data of customers who are members of a member system such as a store. The present invention relates to a database management method and a customer database management program.

[0002]

2. Description of the Related Art When renting at a store, or
When shopping at a store that employs a membership system to give points, most of the time, personal information is first registered and a membership card is issued. Using this membership card, the store manages membership data. In the current card society, many personal membership cards contain credit card, cash card of financial institution, medical examination ticket of medical institution, and store membership card.

[0003]

However, this conventional system has the following problems.

It is assumed that personal information must be registered for each store where a membership card is issued and that a database is held, a server for backing up the information is stored, and there is a virus or sudden failure. I have to manage it. In other words, there is a problem in that it is necessary for the store side to construct a large-scale management system, which requires personnel for operating the system.

Further, the customer also has the inconvenience of having to carry many similar cards by himself.

An object of the present invention is to eliminate the need for a large-scale management system construction and system operation personnel on the side of a store, and for the customer not to carry many cards, a customer database management method, and a customer database management method. To provide a database management program.

[0007]

A customer database management system according to the present invention comprises a management center server for operating a customer data sharing management business, a store terminal used by a member store for the customer data sharing management business, and the member store. A customer database management system in which a user terminal used by a customer who subscribes to an operating member system is mutually connected via a network, wherein the management center server is a customer database storing personal information of a plurality of member systems. A means for setting a user ID common to a plurality of the member systems to the customer; a means for generating a code pattern ID obtained by converting the set user ID into a code pattern and transmitting the code pattern ID to the user terminal;
Means for receiving the member data of the customer from the store terminal and updating the customer database, the user terminal including means for displaying the code pattern ID on a screen, and the store terminal for the user terminal It is characterized by including means for reading the code pattern ID displayed on the screen and transmitting the code pattern ID to the management center server and transmitting the member data of the customer in the member store to the management center server.

The customer database management system of the present invention is characterized in that the user terminal includes means for receiving personal information of a plurality of member systems to which the customer subscribes from the management center server and displaying the list. Good.

The customer database management system of the present invention may be characterized in that the code pattern ID is a bar code ID.

The customer database management system of the present invention may be characterized in that the member data includes point data.

The customer database management method of the present invention includes a management center server for operating a customer data sharing management business having a customer database storing personal information of a plurality of member systems, and a member store for the customer data sharing management business. Is a customer database management method in which a store terminal used by a customer and a user terminal used by a customer who subscribes to a member system operated by the member store are mutually connected via a network, wherein the management center server is the customer. A step of setting a user ID common to a plurality of the member systems, generating a code pattern ID obtained by converting the user ID into a code pattern and transmitting the code pattern ID to the user terminal; and the user terminal displaying the code pattern ID on the screen. The step of displaying, Wherein the code pattern ID that surface display
Reading and transmitting to the management center server and transmitting the member data of the customer in the member store to the management center server, the management center server receiving the member data of the customer from the store terminal, and Updating the customer database.

[0012] The customer database management method of the present invention may also include a step in which the user terminal receives personal information of a plurality of member systems to which the customer subscribes from the management center server and displays a list. Good.

The customer database management method of the present invention may be characterized in that the code pattern ID is a bar code ID.

The customer database management method of the present invention may be characterized in that the member data includes point data.

The management center server of the present invention mutually connects a store terminal used by a member store for a customer data sharing management business and a user terminal used by a customer who subscribes to a member system operated by the member store via a network. Is a management center server that operates a customer data sharing management business, and sets a customer database that stores personal information of a plurality of member systems and a user ID that is common to the plurality of member systems to the customer. Means, means for generating a code pattern ID obtained by converting the set user ID into a code pattern, and transmitting the code pattern ID to the user terminal; data for reading the customer code pattern ID from the store terminal; and member data for the customer. Means for receiving and updating the customer database. .

The management center server of the present invention may be characterized in that it includes means for transmitting personal information of a plurality of member systems to which the customer subscribes to the user terminal for displaying a list.

The management center server of the present invention may be characterized in that the code pattern ID is a bar code ID.

The management center server of the present invention may be characterized in that the member data includes point data.

The program of the present invention interconnects a store terminal used by a member store for a customer data sharing management business and a user terminal used by a customer who subscribes to a member system operated by the member store via a network. And a process of setting a user ID common to a plurality of the member systems to the customer in a management center server that operates a customer data sharing management business having a customer database storing personal information of the plurality of member systems. A process of generating a code pattern ID obtained by converting the set user ID into a code pattern and transmitting the code pattern ID to the user terminal, receiving data obtained by reading the code pattern ID of the customer from the store terminal, and receiving member data of the customer Then, the processing for updating the customer database is executed.

The program of the present invention may execute a process of transmitting personal information of a plurality of member systems to which the customer subscribes to the user terminal to display a list.

[0021]

BEST MODE FOR CARRYING OUT THE INVENTION Embodiments of the present invention will be described in detail with reference to the drawings. FIG. 1 is a block diagram showing the configuration of the first embodiment.

Referring to FIG. 1, the first embodiment is as follows.
A user terminal 10 used by a customer 1, a management center server 20 installed in a management center 2 that operates a customer data sharing management business, a store terminal 30 used by a member store 3 for the customer data sharing management business, and these. And a network 100 such as the Internet that connects the two to each other.

The user terminal 10 is a portable terminal device capable of sending and receiving electronic mail. PDA (personal digit
al assistants) terminals, personal digital assistants, mobile phones, PH
S (personal handy phone system) or the like is used.
It has an input unit 11 for inputting data, a display unit 12 for displaying data, and a storage unit (not shown) for temporarily storing data. The user terminal 10 has a function of accessing the database registration information provided by the management center server 20 on the network 100 and displaying the personal information registration screen on the display unit 12. The personal information is, for example, information about a name, contact information, e-mail address, password, member data (points for each store, return period of rental exhibition, etc.), and includes information such as an access method. The user terminal 10 further has a function of allowing the customer 1 to send personal information to the management center server 20 via the network 100.

The management center server 20 is an information processing device such as a workstation server used by the management center 2. It has a customer multi-database 25 in its internal or external storage device 24. The customer multi-database 25 is used by the customer 1 who is determined for each area. Take backups at regular intervals so that you don't have to worry about losing the contents. The management center server 20 further includes an input unit for inputting data and a display unit for displaying the data, if necessary. The management center server 20 operates the bar code reader 33 to read the bar code ID (identification) displayed on the user terminal 10 by the bar code reader 33, and gives points and lends when shopping at the member store 3. When the history is input at the store terminal 30, the data is obtained via the network 100, the customer 1 is identified from the barcode ID, the member data of the customer in the customer multi-database 25 is updated, and the update information is further updated. Network 100
It has a function of sending to the store terminal 30 via the. This barcode ID is used by the customer 1 and the customer multi-database 25.
This is information for managing users, and is generated as unique information for each customer, and is common to different member systems.

The store terminal 30 is a terminal device provided in the member store 3 having a register function, and has a bar code reader 33. The store terminal 30 further includes an input unit 31 for inputting data, a display unit 32 for displaying data, and a storage unit (not shown) for temporarily storing data.
Have and. The customer 1 is recognized by collating with the personal information of the customer multi-database 25 from the bar code ID read by the bar code reader 33. further,
Network 10 for customer multi-database 25
The number of points and the loan history can be registered, updated, and read via 0.

Next, the operation will be described. Figure 1 is the first
3 is a flowchart showing the operation of the embodiment of FIG. In the following description, the network 100 is the Internet.

The management center 2 is the management center server 2
Use 0 to run a customer data management business. The member store 3 operates a member system, but outsources customer data management to the management center 2.

The customer 1 who wants to join the member system is
The management center 2 accesses the homepage established on the Internet 100 via his / her user terminal 10 (step A1).

In response to this, the management center server 2
0 transmits the personal information input screen to the user terminal 10 (step A2).

On the display unit 12 of the user terminal 10, first, various personal information input screens as shown in FIG. 3 are displayed (step A3).

The customer 1 has the display unit 12 of the user terminal 10.
Seeing the personal information input screen displayed on the screen, the user is registered and the personal information is registered on the screen using the input unit 11 (step A4). The personal information registered in this way is temporarily stored in the user terminal 10.

The personal information stored in the user terminal 10 is transmitted to the management center server 20 via the Internet 100 according to an instruction from the customer 1 (for example, clicking the "register" button in FIG. 3 with a mouse) (step A).
5). The transmission of personal information is not from the user terminal 10,
It may be from the store terminal 30.

Upon receiving the personal information (step A6), the management center server 20 secures the database 1 area for the customer in the customer multi-database 25 of the storage device 24 (step A7), and identifies the customer 1. A user ID is set (step A8). A barcode ID is generated by converting the set user ID into a barcode, and the barcode ID is transmitted to the user terminal 10 by e-mail together with information such as the date of start of use and the method of use (step A9). In addition to barcode ID, OCR (Optical Character Reade
Other code patterning methods such as r) numbers may be used.

The customer 1 has a contract with the management center 2 for the customer data sharing management business from a desired date and time after receiving the bar code ID (after the usage start date if the usage start date is set). Go to the member store 3, display the barcode ID notified to the user terminal 10 in advance on the display unit 12 (step A10), and have the barcode reader 33 read it. The information is sent from the shop terminal 30 to the management center server 20 via the Internet 100 (step A11).

The management center server 20 compares the bar code ID presented by the customer 1 with the bar code ID registered in advance in the management center server 20 (step A12). If these pieces of registrant identification information match, the member data (the number of points, rentals, etc.) of the customer 1 and the member store 3 stored in the customer multi-database 25 is sent to the store via the Internet 100. It is passed to the terminal 30. By inputting the information when the customer 1 makes a shopping or rental at the member store 3 into the store terminal 30, the shopping point and what is rented without issuing the membership card. Can be stored in the customer multi-database 25 (step A13).

When it is desired to confirm the number of points owned by the customer 1, the user terminal 10 can access the Internet 100.
The management center server 20 is accessed via, the password, etc. are transmitted, and a request for displaying points, lending history, etc. is made (step A14).

The management center server 20 extracts the points, lending history, etc. of the customer 1 from the customer multi-database 25 and sends them to the user terminal 10 (step A1).
5). FIG. 4 is a diagram showing an example of personal information included in the customer multi-database 25. If the customer 1 is “○ × Hanako”, the data of “No0002” in FIG. 4 is displayed as a list on the display unit 12 of the user terminal 10. As a result, the customer 1 can know the number of points held at the member store 3, the return deadline of the rental item, the expected finish date of the cleaning request item, and the like. Even if you have subscribed to multiple membership systems, you can list the membership data for all membership systems. If you display the expiration date of the points you have, you can use the points effectively without expiring.

Furthermore, it is convenient to send a warning e-mail from the management center server 20 to the user terminal 10 on the day before the rental item return deadline, or one month before the point expiration date. A method of changing the display color of the list display of the user terminal 10 or making it blink is also possible. It is advisable to make these detailed settings on the user terminal 10 side.

The management center server 20 calculates the entrustment fee by a predetermined formula and sends the billing contents to the store terminal 30 at regular intervals. The member store 3 is a store terminal 30
The payment processing of the commission fee is performed on the management center 2 by a method such as instructing the transfer to a financial institution.

As a member system applicable to this embodiment, there is a mile point system of an airline company in addition to the above-mentioned rental video store.

Further, if personal information is shared and security is further enhanced, if medical treatment tickets and mutual treatment histories and methods at medical institutions can be shared, treatments up to now can be performed anywhere in Japan. Can be received. Show your barcode ID at a convenience store / travel agency, and ticket / shinkansen /
Book a hotel and make payment. After that, go to the airport, station, hotel, etc. and have the bar code read,
You can board, board, and stay as is. It is also possible to use Don't forget to send a notice e-mail to them on the day before the examination and reservation.

Next, a second embodiment of the present invention will be described. FIG. 5 is a block diagram showing the configuration of the second embodiment. Referring to FIG. 5, the second embodiment is
A recording medium 50 is included in addition to the configuration of the first embodiment described in FIG. The recording medium 50 records the customer database management program. The recording medium 50 may be a magnetic disk, a semiconductor memory, an optical disk, or another recording medium.

The customer database management program is read from the recording medium 50 into the management center server 20, and causes the management center server 20 to perform the same processing as that in the first embodiment. The customer database management program may be read via a network such as the Internet instead of being read directly from the recording medium.

The customer database management program sets, in the management center server 20, a user ID common to a plurality of member systems for the customer 1 and a code pattern I that is a code pattern of the set user ID.
A process of generating D and transmitting it to the user terminal 10 and a process of receiving the data obtained by reading the code pattern ID of the customer 1 from the store terminal 30 and the member data of the customer 1 and updating the customer multi-database 25 are executed. Let

Further, the personal information of the plurality of member systems to which the customer 1 subscribes is transmitted to the user terminal 10 and displayed as a list.

[0046]

As described above, according to the present invention,
If personal information is registered once, it is said that the bar code ID issued at that time eliminates the need to register the same personal information every time when shopping or renting at a store contracted for a customer database management business. effective.

Recently, membership cards are issued at shops and rental stores as well, but if there is information in the customer multi-database, only one bar code ID is needed, so carry many membership cards. There is an effect that is unnecessary.

For the store side as well, each store had
The management of the server that stores personal information is transferred to the management center, which eliminates the need to build and maintain a management system, and the need to register personal information and issue multiple cards. There is.

[Brief description of drawings]

FIG. 1 is a block diagram showing a configuration of a first embodiment.

FIG. 2 is a flowchart showing the operation of the first embodiment.

FIG. 3 is a diagram showing an example of a personal information input screen.

FIG. 4 is a diagram showing an example of data included in a customer multi-database.

FIG. 5 is a block diagram showing a configuration of a second embodiment.

[Explanation of symbols]

1 customer 2 management center 3 member stores 10 user terminals 11 Input section 12 Display 20 Management Center server 24 storage 25 customer multi-database 30 store terminals 31 Input section 32 display 33 Bar Code Reader 50 recording media 100 networks

Claims (14)

[Claims] 1. A management center server for operating a customer data sharing management business, a store terminal used by a member store for the customer data sharing management business, and a user terminal used by a customer who subscribes to a member system operated by the member store. And a customer database management system interconnected via a network, wherein the management center server stores a customer database storing personal information of a plurality of member systems, And a code pattern I which is a code pattern of the set user ID.
The user terminal includes means for generating D and transmitting the code pattern ID to the user terminal, and means for receiving the customer member data from the store terminal to update the customer database. The user terminal displays the code pattern ID on the screen. The store terminal reads the code pattern ID displayed on the screen of the user terminal and transmits the code pattern ID to the management center server, and also transmits the member data of the customer in the member store to the management center server. A customer database management system comprising: 2. The customer according to claim 1, wherein the user terminal includes means for receiving personal information of a plurality of member systems to which the customer subscribes from the management center server and displaying the list. Database management system. 3. The code pattern ID is a bar code I.
The customer database management system according to claim 1 or 2, wherein the customer database management system is D. 4. The customer database management system according to claim 1, wherein the member data includes point data. 5. A management center server for operating a customer data sharing management business having a customer database for storing personal information of a plurality of member systems, a store terminal used by a member store for the customer data sharing management business, and A customer database management method for connecting a user terminal used by a customer who subscribes to a member system operated by a member store to each other via a network, wherein the management center server provides the customer with a plurality of the member systems. Setting a common user ID, generating a code pattern ID obtained by converting the user ID into a code pattern, and transmitting the code pattern ID to the user terminal; and the step of displaying the code pattern ID on the screen by the user terminal.
The store terminal reads the code pattern ID displayed on the screen of the user terminal and sends the code pattern ID to the management center server, and at the same time, sends the member data of the customer in the member store to the management center server; Receiving the member data of the customer from the store terminal and updating the customer database. 6. The customer database according to claim 5, further comprising a step in which the user terminal receives personal information of a plurality of member systems to which the customer subscribes from the management center server and displays a list of the personal information. Management method. 7. The code pattern ID is a bar code I.
7. The customer database management method according to claim 5, wherein D is D. 8. The customer database management method according to claim 5, wherein the member data includes point data. 9. A customer data sharing management business, a store terminal used by a member store and a user terminal used by a customer who subscribes to a member system operated by the member store are mutually connected via a network, and customer data is stored. A management center server for operating a shared management business, a customer database storing personal information of a plurality of member systems, a means for setting a user ID common to a plurality of the member systems to the customer, User I
Means for generating a code pattern ID obtained by converting D into a code pattern and transmitting the code pattern ID to the user terminal; data for reading the code pattern ID of the customer from the store terminal and the member data of the customer to receive the customer database And a means for updating the management center server. 10. The management center server according to claim 9, further comprising means for transmitting personal information of a plurality of member systems subscribed to by the customer to the user terminal to display a list of the personal information. 11. The management center server according to claim 9, wherein the code pattern ID is a bar code ID. 12. The management center server according to claim 9, 10 or 11, wherein the member data includes point data. 13. A store terminal used by a member store for a customer data sharing management business and a user terminal used by a customer who subscribes to a member system operated by the member store are mutually connected via a network, A process for setting a user ID common to a plurality of the member systems to the customer in a management center server that operates a customer data sharing management business having a customer database that stores personal information of the member system, and the setting User I
A process of generating a code pattern ID obtained by converting D into a code pattern and transmitting the code pattern ID to the user terminal, the data obtained by reading the code pattern ID of the customer from the store terminal, and the member data of the customer, and the customer database A program for executing the process of updating and. 14. The program according to claim 13, for executing a process of transmitting personal information of a plurality of member systems subscribed to by the customer to the user terminal to display a list.