JP2006344116A - Database managing method using cellular phone and qr code - Google Patents

Abstract

<P>PROBLEM TO BE SOLVED: To provide a method for inexpensively and easily managing personnel constituting a group without using a large scale server or the like, for example, a method for managing passengers of a sightseeing bus. <P>SOLUTION: At least an accessing means such as a cellular phone and person himself/herself confirmation data are encrypted as attribute data for personnel constituting a population having events of assembling and breakup, and a QR code is generated from the attribute data. The QR code is printed on a portable medium such as a card to enable portable medium display. When the population breaks up and reassembles, a camera of a cellular phone with a camera different from the cellular phone reads the QR code displayed on the portable media carried by each personnel. Furthermore, the cellular phone with a camera displays a list of data obtained by decoding the encryption and the attribute data generated when the population breaks up and reassembles. <P>COPYRIGHT: (C)2007,JPO&INPIT

Description

  The present invention relates to a method for managing a database easily and inexpensively using a mobile phone with a camera and a QR code.

  For example, when traveling on a sightseeing bus, if you get off at a tourist spot and take a break, the driver or bus guide will check the number of people before you get off, and when you return to the bus after the break, count the number again. To see if everyone has boarded. Here, the number of people before getting off should match the number of people who re- boarded, but if there are not enough people, it is difficult to check who has not returned. In such a case, for example, before getting off using an IC card, the contents of each person's IC card can be read to create a list, or a bar code with personal data linked in advance can be simplified with a bar code reader. A method of reading is proposed.

  For example, attendance management includes, for example, an IC card having storage means storing student ID information for identifying a student, a card insertion slot for inserting the IC card into the holder case body, and a card insertion slot. An IC card remote control holder having conversion means for converting student ID information of the IC card into information for transmission, transmission means for transmitting the converted information for transmission, and information transmitted from the IC card re-common holder. An attendance management computer having a receiving device for receiving and storage means for storing attendance information for a student's class based on information received by the receiving device is known. (Patent Document 1)

  In addition, as a cram school management system, an IC card in which the phone numbers of the cram school and home phones are registered, and the cram and home phones having a display function, as well as reading and automatically transmitting the phone numbers of the IC card, There is also known a system that includes a database server that manages data related to cram school students connected to the side telephone. (Patent Document 2)

  Furthermore, as a method of using the QR code, the business card information is encoded and embedded in a QR code as a two-dimensional code recorded on the business card, the business card on which the QR code is printed is taken into a central processing unit by a scanner, and the QR code is Also disclosed is a technique for facilitating registration in a database by decrypting it, converting it to an ASCII code and digitizing it. (Patent Document 3)

JP2002-140668 JP 2002-261969 JP 2003-154774 A

  The problem to be solved is to provide a group member management method, such as a tourist bus passenger management method, at low cost and easily without using a large server.

  In Patent Document 1, an IC card is used as a means for storing student ID information. However, if an IC card is used, the cost of the IC card (about 1000 yen including the issuance process) is high, and if an IC card remote control holder is required, it becomes a fairly expensive system, and eventually these costs are added to the tuition fee. It will be. However, since this type of application has not been widely evaluated in terms of cost effectiveness, IC cards in this field are not popular.

  According to Patent Document 2, the IC card to be given to the cram school students is not so high-functioning and is considered to be an inexpensive IC card in terms of price. Because it cannot be used unless a device that automatically sends data to the database or a database server is prepared, the system becomes expensive. There is also a proposal to use a mobile phone instead of an IC card. However, even if an application is installed on the SIM card of the mobile phone, the automatic transmission device and the database server are still required, so the system is expensive. Absent.

  In Patent Document 3, the business card information is converted into a QR code, printed on the business card, the QR code is read by a scanner connected to the PC, and the business card information can be taken into the PC etc. when the code is converted. Compared to barcodes, the amount of data only increases, and there is no convenience that can be used for managing the number of tourist buses.

  In view of the above, the present invention provides a method that can be easily and inexpensively managed by a group member by combining a mobile phone with a camera, which has become popular and inexpensive, and a QR code.

  In the invention according to claim 1, a QR code having at least access means such as a mobile phone and personal identification data of the member as basic attribute data is generated for a member of the population having an event of set and dissolution. The QR code can be displayed on a portable medium, and the QR code is used in the database management method using the camera-equipped mobile phone and the QR code that reads the QR code at the generation timing of the population. The code is encrypted so that it cannot be decrypted without using the specific data of the mobile phone with a camera connected to it, and the access means data of the member is included in the QR code. Whenever the camera-equipped mobile phone reads a QR code, the QR code data reads Both were in to add a new attribute data.

  As a result, even if a portable medium that can display a QR code and a mobile phone with a camera that can read the QR code are available without having to prepare a large system, it is easy to make a quick call when the members of a specific population are gathered or dissolved. It becomes possible to take. In addition, since the camera-equipped mobile phone used for reading is specified, even if the QR code is read by another camera-equipped mobile phone, personal information does not leak out. For example, a sightseeing bus for a tour trip, a kindergarten attendance bus, a school excursion such as elementary and junior high school, and the like are suitable usage opportunities.

  The encryption key used for the encryption may be embedded in a non-display format (for example, compiled) in the application of the camera-equipped mobile phone that reads the QR code, or the specific unique data or processed data of the camera-equipped cellular phone is used. You can use it.

  In the invention according to claim 2, the population is composed of a plurality of small groups having a structure of two or more layers, and attribute data of the small group is included in the QR code written in the portable medium. .

  This is because, for example, when traveling on several buses, when there is a member on a bus that is different from the predetermined car when a break is reassembled at a sightseeing spot and reassembled, The bus number is generated in the camera-equipped mobile phone as new attribute data. Also, when re-assembling, another attribute data is generated. When the data linked by these QR codes is totaled by the camera-equipped mobile phone, it is possible to easily check the call of individual members and the entire members by using the hierarchical attributes.

  Furthermore, in the invention according to claim 3, when a plurality of camera-equipped cellular phones are used and the database stored in the camera-equipped cellular phone is transmitted from the camera-equipped cellular phone to a center computer, the camera-equipped cellular phone It was sent after encrypting using specific specific data. In this case as well, the QR code is decoded and attributes are added using a mobile phone with a camera, so the kindergarten server placed in the kindergarten or the like only needs to have at least the database function. Is enough.

  As a result, even if personal information is included in the QR code, data communication can be performed with confidence, so the range of data usage is expanded. For example, when traveling around a kindergarten bus routed by a kindergarten bus, the QR code can be displayed from a portable medium that can display the QR code containing the child's attribute data using a mobile phone with a camera. By reading it and transferring it to the kindergarten, it is possible to know the current boarding situation in the kindergarten, and it is possible to quickly answer inquiries from parents, etc., and from the portable medium with the camera mobile phone when getting off By reading the QR code, it becomes possible to generate data of evidence that the kindergarten has arrived at the kindergarten.

  The database management method using the mobile phone and the QR code according to the present invention links at least access means such as a mobile phone and identification data as attribute data to members of a population having an event of aggregation and dissolution. By using the QR code, it is possible to manage the population of the population only with the camera-equipped mobile phone, and when there are insufficient personnel at the time of reassembly, the camera-equipped cellular phone can easily perform a call verification. Thus, it is possible to immediately contact the shortage member using a calling means such as a mobile phone recorded as attribute data.

  Similar uses of QR codes and camera-equipped mobile phones are not limited to sightseeing buses, kindergarten pick-up buses, school excursions, etc. Day work workers on the spot, etc., staff attendance including part-time work at the entertainment-related shooting site, companion attendance at the event venue, attendance at various restaurants, etc., and QR at the event booth of event attendees are also possible. Code utilization is also possible.

  A first embodiment of the present invention is shown in FIGS. Fig. 1 shows the QR code on the sightseeing bus and the usage protocol of the mobile phone with camera. Fig. 2 shows the screen immediately after reading the QR code with the mobile phone with camera and the screen after decoding through the application. Fig. 3 shows a break. FIG. 4 shows a QR code read at the time of reassembling after a break. FIG. 5 shows attributes 2 and 3 generated by the QR code read at the time of dissolution before the break and at the time of reassembling. The figure of the collation by the list of is shown.

  In FIG. 1, a tour of a sightseeing bus will be described as an example. First, when a tourist gets on a sightseeing bus, in the “reading when boarding” step 1, the bus guide reads the QR code of the ticket including the QR code given to each person with the camera-equipped mobile phone. Next, in the “generation of attribute 1” step 2, apart from the read QR code data, the attribute 1 is generated together with the reading time by an application installed inside the camera-equipped cellular phone, and the camera-equipped cellular phone Accumulate inside. Further, in “matching with reservation list” step 3, the stored data is checked against the reservation person list received in advance on the Internet or the like to confirm attendance. Here, if a prospective participant whose name is on the reservation list does not board the sightseeing bus, a report determined in the business rules is made in Step 4 of “Contacting the head office”. Next, when the participants of the day are confirmed, the sightseeing tour is started in the “bus departure” step 5.

  When there is a break at a sightseeing spot on the way in this sightseeing tour, the QR code is read from the portable media of all the participants who get off at “Intermediate break reading” step 6 before each participant gets off. From the read data, in “Generate attribute 2” step 7, attribute 2 is generated together with the reading time inside the camera-equipped mobile phone. Here, by reading the QR codes of the participants remaining on the sightseeing bus, attribute 2 (participants who got off and participants remaining on the bus) for all members is generated, and for confirmation, “attribute 1 and Attribute 2 comparison "Step 8 confirms that there is no omission, and if there is an attribute 1 for some reason but no attribute 2, ie there is an unknown participant who has not read the QR code in step 6 In such a case, a report determined in the business rules is made in Step 4 of “Contacting the head office”. After all the attributes 1 and 2 were confirmed in the “Comparison of attribute 1 and attribute 2” step 8, when the rest time was over and the participants who got off returned to the sightseeing bus, The QR code of the participant who re-rides at step 9 is read, and attribute 3 which means that he / she has returned to the sightseeing bus is generated at “generation of attribute 3” step 10.

  Here, “Comparison between attribute 2 and attribute 3” step 11 is carried out using the camera-equipped mobile phone, and if the attribute 2 has the attribute of a stopover on the way, the participant who has no attribute 3 record, that is, at break If there is a participant who has not got back after getting off, it can be called using the mobile phone number included in the basic attribute data generated in the step 2 of “Generate attribute 2”. If there is no response even if calling using a mobile phone, there is a possibility of an accident, so contact the nearest police in "Request for search to the police" step 13 to request a search. However, if the return of all the passengers can be confirmed, the bus is operated again in the “bus transmission” step 14. When there are a plurality of break places on the way, the process returns from the “bus transmission” step 14 to the “intermediate break reading” step 6 and the process up to the “bus transmission” step 14 is repeated.

  Further, when the bus arrives at the final location, the QR code is read when the participant gets off at step 15 "Read when final location arrives and gets off". When the reading is completed, in “Generate attribute 4” step 16, the mobile phone with camera generates attribute 4 which is an attribute of the last disembarkation.

  Finally, in “End of business by final confirmation” step 17, it is confirmed that all participants have entered the attribute 4 data generated together with the reading time with the camera-equipped mobile phone into the list. End bus participant management.

  FIG. 2 is a diagram for explaining generation of attribute data using the camera-equipped mobile phone. A QR code 19 is printed on an ID card 18 on which a QR code that is a portable medium is printed. When the QR code 19 is photographed by a camera 21 provided on the camera-equipped mobile phone 20, a QR code 23 is displayed on the display screen 22 of the camera-equipped mobile phone 20, and is further incorporated in the camera-equipped mobile phone 20. The application 24 decodes the QR code. At this time, the application 24 decrypts the encryption using the specific unique data 20a of the camera-equipped mobile phone 20, in this example, the phone number 080-654321, and is encrypted in the display unit 22 of the camera-equipped mobile phone. QR code decryption data and attribute data 25 added by the camera-equipped mobile phone are displayed together with the previous basic attribute data and newly generated attribute data.

  FIG. 3 is a detailed explanatory diagram of the “intermediate break reading” step 6 of FIG. Here, before the bus passenger 26 gets off the bus with a break, the bus crew or the bus guide is a portable medium with the QR code printed on the camera-equipped mobile phone 20, and the ID card 18 with the QR code printed thereon. FIG. 3A shows a state where the QR code is taken. At this time, first, an application installed in the camera-equipped mobile phone 20 is activated, and then the camera-equipped mobile phone 20 captures a QR code as shown in FIG. The QR code shown in FIG. 3B is displayed on the screen and a mark for notifying normal processing appears on the screen. When the QR code is photographed one after another and the mode of the application is changed from the photographing mode to the data display mode when the photographing for all the members is completed, the identification of the camera-equipped mobile phone 20 is identified from the QR code of FIG. The private data 20a is used to decrypt the cipher, and as shown in FIG. 3C, the basic attribute read from the QR code is the name data 28 read from the QR code, and the mobile phone number data 29 read from the QR code. In addition, a list generated by the camera-equipped mobile phone 20 and added with attribute 2 data 30 at the time of break dissolution generated by the camera-equipped cellular phone is displayed on the screen of the camera-equipped cellular phone 20. Is done.

  Here, in the continuous shooting of the QR code in FIG. 3A, if the CPU speed of the mobile phone is sufficiently high, the QR code may be sequentially decrypted, but in order to reduce the overall processing speed. , QR code decoding (conversion to ASCII data as encrypted) and later encryption processing, or QR code as visual data (photo) one after another imported to mobile phone with camera A method of performing QR code decoding and encryption processing later is also conceivable.

  FIG. 4 is a detailed view of the “read at reassembly” step 9 in FIG. Here, when the passenger 26 of the bus who got off the bus at the resting place returns from the rest, the bus crew or the bus guide photographs the QR code of the ID card 18 printed with the camera-equipped mobile phone 20. FIG. 4A shows how this is done. At this time, first, an application installed in the camera-equipped mobile phone 20 is started, and then a QR code as shown in FIG. The QR code of FIG. 4B is displayed on the screen and a mark for notifying normal processing appears on the screen. When the QR code is photographed one after another and the mode of the application is changed from the photographing mode to the data display mode when the photographing for all the members is completed, the camera-equipped mobile phone 20 is identified from the QR code of FIG. Using the unique data 20a, the cipher is decrypted and added to the name data 28 read from the QR code 23, the mobile phone number data 29 read from the QR code 29, read from the QR code 23, as shown in FIG. Then, a list to which the verification data 34 that is attribute 3 at the end of the break generated by the camera-equipped mobile phone is added is displayed on the screen of the camera-equipped mobile phone 20.

  Here, in the continuous shooting of the QR code in FIG. 4 (a), since it is shooting at the timing of getting on the bus, it is not necessary to shoot as soon as the resting time of getting off as in FIG. 3 (a). So, you can decrypt the QR code sequentially to generate the attribute data one by one, but in order to shorten the overall processing speed, decode the QR code (convert it to ASCII data as encrypted) A method of performing encryption processing collectively later, a method of taking QR codes as visual data (photographs) one after another in a camera-equipped mobile phone, and performing QR code decoding and encryption processing later are also conceivable.

  FIG. 5 is a diagram for explaining the “comparison of attribute 2 and attribute 3” step 11 of FIG. As shown in FIG. 5A, when all the passengers 26 on the sightseeing bus gather, the application 24 is switched to the “list generation” mode. In this mode, the attributes 2 and 3 that were separately displayed in FIGS. 3C and 4C are displayed together with basic attributes as a list. That is, QR code decoding data at the time of boarding in FIG. 3C, attribute 2 data 30 at break dissolution generated by the camera-equipped mobile phone in the attribute 27 list 27, and attribute 1 in FIG. 4C 3 and the table 31 of the matching result are displayed as one table as shown in FIG. The list 33 for comparing the attribute 2 data and the attribute 3 data is added to the name data 28 and the mobile phone number data 29 read as the attribute 1 from the QR code 23, and is generated by the camera-equipped mobile phone when taking a break. The attribute 2 data 30, the attribute 3 data 32 generated at the end of the break, and the collation data 34 are added and displayed in a list on the display unit 22 of the camera-equipped cellular phone of the camera-equipped cellular phone 20.

  Among the passengers marked with ◎ in the attribute 2 data 30 generated at the time of dissolution by the list 33 that matches the attribute 2 data with the attribute 3 data, Taro Yamada, Suzume Misora, Hanako Aozora, Yuzo Ishihara The four of these are also marked with ◎ in the attribute 3 data 32 generated at the time of re-aggregation, so it is confirmed that they returned to the sightseeing bus after a break, but Suehiro Koizumi was generated at the time of dissolution While the attribute 2 data 30 is marked with 再, the attribute 3 data 32 generated at the time of reassembly is not marked with ◎. Therefore, Suehiro Koizumi can confirm that he has not returned to the sightseeing bus by the re-assembling time. In this case, as in the “calling by mobile phone” step 12 in FIG. 1, Mr. Sueo Koizumi using the mobile phone number data 29 read from the QR code as personal attribute data read from the QR code as the basic attribute data. Can be called. However, if there is no response to the call by the mobile phone number data 29, the police or the head office is contacted as shown in the "request for investigation to the police" step 13 in FIG. You can report this.

  FIG. 6 is a second embodiment of the present invention, which is an embodiment in a kindergarten shuttle bus. In the second embodiment of the present invention, an embodiment using a QR code and a camera-equipped mobile phone for a shuttle bus at a kindergarten will be described. Even in the second embodiment, even if personal information is included in the QR code, information that can be specified as personal information cannot be recognized in the data read by decoding the QR code, and the specific characteristics of the pre-registered camera-equipped mobile phone 20 are not recognized. Since the original information cannot be decoded without using the data 20a, even if a malicious third party uses a camera-equipped mobile phone that can read a general QR code, the child's personal data cannot be read, and the pick-up bus 35 or Since encryption is also performed when data is sent from the return bus 39 to the database 36 of the kindergarten server using the camera-equipped mobile phone 20, a malicious third party cannot listen to the data.

  The pick-up bus 35 departs kindergarten for pick-up in the morning and picks up the kindergarten taken by the guardians at a plurality of stops 1, 2, 3,. When the kindergarten gets on the pick-up bus 35, a nurse mother in charge picks up the QR code 19 printed on the ID card 18 on which the QR code of the kindergarten is printed by the camera-equipped mobile phone 20. The camera-equipped cellular phone 20 records the captured QR code 23 along with the time of removal, and sequentially transmits the captured data to the database 36 of the kindergarten server. The kindergarten side can grasp the pick-up situation of the kindergarten at a close timing.

  When the pick-up bus 35 arrives at the kindergarten, in the database 36 of the kindergarten server, the kindergarten server or the like creates a list of the attendance database generated in the “Generate attendance database” step 37 and distributes it to each classroom. "Verification by attendance confirmation" step 38 is performed. When confirming absence, do not wait for this “verification by attendance confirmation” step 38, and call the child who was not picked up at the pre-registered stop at the stage of “Generate attendance database” step 37. You can confirm the absence of a kindergarten by contact.

  When it is time for the kindergarten to leave, a return bus 39 is prepared and each kindergarten is on the way down. In this case, the QR code 19 printed on the ID card 18 of the child is photographed by the camera-equipped mobile phone 20 when the child gets on the return bus 39. This corresponds to “Generate attribute 1” step 2 in FIG. 1, and is an operation of generating a basic attribute list to be generated in the camera-equipped mobile phone 20. The camera-equipped mobile phone 20 records the captured QR code 23 together with the reading time.

  Furthermore, when the child gets off at each stop, the QR code 19 printed on the ID card 18 on which the QR code of the child is printed is photographed by the mobile phone with camera 20. Thereby, the attribute which got off at each stop with the time when each kindergarten got off the return bus 39 is generated. These data are transmitted from the camera-equipped mobile phone 20 to the database 36 of the kindergarten server, and the “generation of the park database” step 40 allows confirmation of delivery to the parents of the children in almost real time.

  Furthermore, after the return bus 39 returns to the kindergarten, the kindergarten server database 36 performs the “verification check of the admission database and the admission database” step 41, so that the kindergarten child can Make sure that the park has been delivered to the parent.

  Group management can be performed safely and easily just by preparing a portable medium that can display QR codes and a pre-registered camera phone that can decode QR codes. Since it is not necessary to prepare a base server, it is possible to manage the personnel of passengers safely and simply with reduced infrastructure costs. For example, it is possible to provide inexpensive sightseeing tours for sightseeing tours, and it is expected that demand will be excavated in the tourism industry. If encrypted data is received and managed in kindergartens, personal information can be managed safely. However, a system that can respond immediately to administrative inquiries from parents can be easily constructed.

Flowchart in the first embodiment Example of QR code reading and decoding in the first embodiment QR code reading at the time of dissolution in Example 1 QR code reading during reassembly in the first embodiment Comparison of attributes 2 and 3 in Example 1 Flow of data generation in the second embodiment

Explanation of symbols

  1 ... Reading when boarding, 2 ... Generation of attribute 1 by mobile phone with camera, 3 ... Comparison of reservation list with actual passengers, 4 ... Reporting to headquarters etc. when verification result does not match, 5 ... Verification 6 ... Read QR code before getting off when taking a break at a sightseeing spot, etc. 7 ... Generate attribute 2 using camera phone, 8 ... Attribute 1 and attribute using camera phone Comparison of 2; 9 ... QR code reading at the end of a break; 10 ... Generation of attribute 3 using a mobile phone with camera; 11 ... Comparison of attribute 2 and attribute 3 using a mobile phone with camera; Call unoccupied passengers by phone, 13 ... Request police to search if call cannot be made by mobile phone, 14: Bus departs when verification is confirmed, 15 ... Final destination QR code reading after arrival, 16 ... generation of attribute 4 by camera mobile phone, 17 ... reconfirmation of all attributes by camera mobile phone, 18 ... ID card with QR code printed, 19 ... ID information and mobile phone number 20 as a mobile phone with camera, 20a as specific data, 21 as a camera part of a mobile phone with camera, 22 as a display part of a mobile phone with a camera, 23 as a display part of a mobile phone with a camera Displayed QR code, 24 ... QR code conversion application of camera mobile phone, 25 ... Decoding data of QR code and attribute data added by mobile phone with camera, 26 ... Passenger of bus, 27 ... QR code when boarding Decoding data and attribute 3 list, 28 ... Name data read from QR code, 2 ... mobile phone number data read from QR code, 30 ... attribute 2 data at break break generated by camera-equipped mobile phone, 31 ... attribute 1 to 3 and collation result table, 32 ... attribute 3 data, 33 ... attribute Table for comparing 2 data and attribute 3 data, 34 ... Verification data, 35 ... Pick-up bus, 36 ... Kindergarten server database, 37 ... Attendance database generation, 37 ... Verification by attendance confirmation of preschoolers, 38 ... Return bus, 39 ... Reading QR code when getting off the return bus to generate park database, 40 ... Verification of park database and park database.

Claims (3)

A QR code having at least access means such as a mobile phone and personal identification data of the member as basic attribute data is generated for the constituent members of the population having the gathering and dissolution events, and the QR code is used as a portable medium. In the database management method using a mobile phone with a camera and a QR code that can read the QR code at an occurrence timing of the population event, the QR code is encrypted. It cannot be decrypted without using specific data of the linked mobile phone with a camera for reading, the access means data of the constituent personnel is included in the QR code, the mobile phone with camera is a QR code Each time reading, new attribute data is added to the QR code data along with the reading time. Database management method using a camera-equipped mobile phone mobile phone and a QR code, characterized in that. A mobile phone and a QR code, wherein the population is composed of a plurality of small groups having a structure of two or more layers, and attribute data of the small group is included in a QR code written on the portable medium. The database management method used. When a plurality of camera-equipped mobile phones are used and the database stored in these camera-equipped mobile phones is transmitted from the camera-equipped mobile phone to the center computer, encryption is performed using specific specific data of the camera-equipped mobile phone. 3. The database management method using a mobile phone and a QR code according to claim 1 or 2, wherein the data is transmitted after being converted.