JP2021174075A - Matching method of application data and written investigation data - Google Patents

Abstract

To reduce business hours of a teacher related to examination business in an alma mater side in an Internet application of various examinations such as an entrance examination and a licensing examination.SOLUTION: A method includes an application data detection step in which a Web server detects presence or absence of application data in which birth date information is in agreement with name Furigana information from a database 71 of a down school for examination inside a database server 7, among the application data in which an alma mater identifier is in agreement with an alma mater identifier which written investigation provisional registration data has. Encrypted again and registered provisionally written investigation data which is written investigation data for submission which is encrypted and inputted from an alma mater terminal and decrypted inside the Web server is matched with the application data inputted from an applicant terminal.SELECTED DRAWING: Figure 10

Description

The present invention relates to a matching method and a matching system for application data and search report data in an Internet application for various examinations such as high school entrance examinations and the like, which accept applications on the Internet.

There is an increasing social demand for work style reforms toward the realization of a 100 million active society. In line with this, the working hours legislation is being reviewed as part of work style reforms.

On the other hand, looking at the environment surrounding schools, according to a survey of working conditions at public junior high schools in Japan released by the Ministry of Education, Culture, Sports, Science and Technology in 2016, about 60% of junior high school teachers worked overtime above the so-called overtime death line. It has been revealed that he is doing it on a daily basis. Therefore, in January 2019, the Central Council for Education reported on various measures, including regulations on overtime hours, regarding work style reforms in schools.

In order to reduce overtime hours for teachers, it is important to reduce the work other than class hours, which is the original work of teachers. Among them, reducing the work related to entrance examinations, which requires a large amount of paperwork in a short period of time, is beneficial to both the school that sends out the students and the school that accepts them.

The Internet application system is becoming widespread as a means of reducing entrance examination work. However, in the Internet application system, the instructor of the school that sends out the students (hereinafter referred to as the "school of origin") prepares a separate paper for the survey form that inputs the application data and describes the grade information, which is advanced personal information. However, it is tightly sealed and sent to the school that accepts the students (hereinafter referred to as the "examination school"). In the process of exchanging the paper of this survey report, confirmation work is required many times, and a huge amount of time is spent. The current situation is that there is. Furthermore, a huge amount of time is still spent on linking the application data input via the Internet application system with the survey report data created by the teacher of the school from which the student is sent.

As a means to solve this situation, in the entrance examination for high school, create survey report data using spreadsheet software such as Excel (registered trademark), and use USB to the high school of the examination school on the side that accepts students. There is an example of mailing, but it has been abandoned due to the risk of confidentiality due to theft of USB and the risk of virus infection via USB. In addition, data transmission using e-mail has been abandoned because handling advanced personal information by e-mail involves a great risk. When submitting the survey form data as a table calculation data file via USB, the order of the survey form data is the same as the order of the paper application from the junior high school where the applicant is from to the high school where the applicant is taking the examination, that is, the examination school. Is submitted, the examination number is printed on the paper application form (with the examination card) at the examination school by numbering, and the examination number at the beginning of each school (junior high school) is written at the beginning of the survey form data. The examination number was included in the survey form data. In other words, this also used the examination number to link the survey form and the application form.

In addition, there is an example in which the teacher of the school from which the student is sent creates and operates the survey report data using the mark sheet, but while the marking process spends a huge amount of time, the integrity due to work mistakes. The risk and the integrity risk of reading defects cannot be dispelled. In addition, since it is necessary to work with a dedicated device in order to operate the mark sheet, a large amount of work time is required, and it cannot be said that this is a simple method. In addition, in the method of filling out the survey form on the mark sheet form, the paper survey form written on the mark sheet is submitted together with the paper application, but the application form (with the admission ticket) and the survey form are arranged in the same order. , The same examination number is printed on the application form and the survey form of the same applicant by numbering, and the printed examination number is read by OCR with a mark sheet reader. In other words, the examination form and the application form are linked by the examination number.

Conventionally, there is a system for electronically receiving a search report from a school of origin and an application of an examinee (see, for example, Patent Document 1).

Japanese Unexamined Patent Publication No. 2002-31298

However, the system described in Patent Document 1 has a problem that the application registration number of the examinee is required when registering the search document. In addition, the above-mentioned method of submitting a USB or a method of submitting a mark sheet has a problem that the work becomes enormous depending on the number of applicants, and all the subsequent numbers are shifted even if one numbering is skipped.

The present invention has been made in view of such circumstances, and an object of the present invention is to reduce the working hours of teachers involved in examination affairs on the side of the school of origin.

In order to achieve the above object, the inventor of the present application has invented a matching method and a matching system for application data and search documents in an Internet application for entrance examinations through trial and error. The present invention does not match by examination number or matching by application number (application identifier), but automatically matches by originally possessed data. In the matching by the examination number, the registration of the survey form data can be accepted only after the examination number is decided, and the teacher of the school of origin can register the survey form data only after the application of the examinee. Therefore, in matching by examination number, the application must be closed early, and in this case, there is a concern that the number of examinees will decrease. There is also a request to arrange the examination numbers for each school of origin, and if this is done, the examination numbers cannot be assigned until the application is completed, and the registration of the survey data will be further delayed. If the registration period for survey data is shortened, it will be extremely difficult for teachers at the busy school (junior high school for high school entrance exams). In addition, in matching by application number (application identifier), the search report data can be registered even before the examination number is assigned, but the situation remains that the examinee must apply. Moreover, the teacher at the school from which he was born needs to add some identifier information such as the application number to the survey data, and there is a risk of work mistakes for the teacher to enter, so even if you download a series of information, your survey We face the problem that it is very difficult to edit the written data and secure the means to prevent human error such as whether it is mistaken for other people's data. The inventor of the present application tried and errored the present invention based on the idea that "it should be automatically matched with the data originally possessed instead of some special data (examination number, etc.)". It was invented.

The first aspect of the present invention is in filing an application via the Internet.
One or more Web servers connected to the applicant terminal and the terminal of the school of origin via a network,
With one or more database servers interconnected to the Web server,
A group of servers that have the functions of multiple types of servers, including
It is a matching method that matches the application data input from the applicant terminal with the search report data input from the home school terminal.
The Web server displays the upload acceptance screen of the submission survey data including one or more survey data for one or more applicants on the home school terminal received by the login ID for each school. The submission survey data reception process for displaying and accepting the upload of the submission survey data from the home school terminal,
The Web server detects whether there is any omission or mistake in the date of birth information, the pseudonym information of the name, and the internal statement data in the submitted survey data, and if there is no omission or mistake, the submitted survey data. Temporary registration acceptance process and temporary registration acceptance process
The Web server associates the home school identifier associated with the login ID and the same registration number for each of the submitted survey data for which provisional registration has been received with each survey data as survey report temporary registration data. A registration number issuance process that adds the registration number to the database of the school to be examined in the database server and displays the registration number on the terminal of the school of origin.
The Web server receives application data including date of birth information, name signature information, and school identifier to be submitted to the examination school from the applicant terminal, and adds the application data to the database of the examination school in the database server. Application acceptance process and
The survey report confirmation acceptance process in which the Web server accepts the input of the registration number from the origin school terminal accepted by the login ID for each school of origin.
The process of reading the temporary registration data, in which the Web server reads the temporary registration data of the survey report associated with the registration number from the database of the examination school in the database server.
Among the application data whose home school identifier matches the home school identifier associated with the login ID, the Web server checks in the database server whether or not there is application data in which the date of birth information and the pseudonym information of the name match. Application data detection process to be detected from the database of
For the search report data for which the application data was not detected by the Web server in the application data detection step, the search report provisional registration data associated with the registration number is used, including that the application has not been registered. The matching result display process to be displayed on the home school terminal and
Provided is a matching method characterized by including. The "server group" includes not only a combination of a plurality of servers but also one server having a plurality of types of server functions. Each server may be a physically independent server, a plurality of types of servers may be physically the same server, or one server may be physically composed of a plurality of servers. The database may be in one of the servers, may be in an independent server, or may be distributed among a plurality of servers. In addition, the applicant may be an entrance examination examinee or a certification examination examinee. The furigana information may be written in hiragana, katakana, or alphabet.

In the present invention, the registration number is preferably a unique registration number in the database of the examination school. "Unique" includes the meaning of unique and unique. The "unique registration number" includes, for example, a different identifier for each survey report provisional registration data. The "identifier" includes various types of identifiers, and may be, for example, any of alphabets and other characters, symbols, alphanumeric characters, etc., and a plurality of types thereof may be combined. The character length of the identifier is not particularly limited. The survey report data for submission may be data expressed in a tabular format such as CSV, Excel (registered trademark), tab delimited, or XML, JSON data, and the type of data is not limited. Further, the survey report data for submission may be encrypted at the time of creation and then uploaded, and the survey report data may be encrypted by the Web server when stored in the database.

According to the first aspect of the present invention, the application information submitted to the examination school by the applicant applying for the Internet and the search report information submitted by the school of origin to the examination school are simplified while considering the completeness and confidentiality of the information. In addition, a large amount of matching can be done in a short period of time. In addition, this makes it possible to reduce the working hours of teachers involved in examination affairs on the side of the school from which they were born. Furthermore, it is possible to reduce the working hours of teachers involved in examination affairs on the examination school side.

In addition, since it is not necessary to enter the examination number and application identifier at the time of matching, the teachers of the school of origin (junior high school in the high school entrance examination) will temporarily register the survey form even before the examination number is assigned or before the student completes the examination procedure. It is possible to avoid an increase in confirmation work / correction work due to an input error of the application identifier. Therefore, the time to perform the work can be dispersed, and the burden on the teacher is reduced. In addition, the examination school (high school in the case of high school entrance examinations) will not have to close the application early.

In the process of receiving survey report data for submission,
The survey report data for submission shall be encrypted using a public key or a common key.
In the temporary registration acceptance process
It is preferable that the Web server decrypts the submitted survey report data using a private key or a common key corresponding to the public key. Since the survey report data for submission including the highly confidential survey report data is uploaded in an encrypted state, it is possible to prevent information leakage of the survey report data and enhance security.

In the temporary registration acceptance process
The Web server detects from the database of the test school in the database server whether or not there is application data in which the home school identifier, the date of birth information, and the pseudonym information of the name match, and if there is application data, the application has been registered. The information that the data is not registered if there is no application data is included in each search report data, and the list of the search report data for submission is displayed on the home school terminal.
as well as,
In the temporary registration acceptance process
If the Web server detects omissions or mistakes in either the date of birth information, the pseudonym information of the name, or the internal report data in the survey report data for submission, the provisional registration will not be accepted and there will be omissions or mistakes. It is preferable to include the error display at each location in each survey report data and display the list of survey report data for submission on the home school terminal. It can be understood at the school of origin that the applicant has not completed the application procedure, and an error in the search report data is displayed even before the application procedure, so it is possible to confirm the deficiency of the search report even before the application deadline. It is possible to ease the concentration of work.

If there are multiple applicants matched to one search report data, information included in the application data such as the kanji of the name, part of the address (city, ward, town, village), class, number in the class (attendance number, etc.) May be displayed and selected. The class and the number in the class are not included in the application data in this embodiment, but it is desirable to include them in the application data. It can be used to distinguish when there are multiple applicants matched with the survey data, and it makes it easier for teachers at the school of origin to check the application status.

In the application acceptance process
The Web server adds a unique application identifier to the received application data.
as well as,
In the matching result display step,
The Web server detects whether the application identifier is included in the search document provisional registration data in which the application data is detected in the application data detection process.
When the application identifier is detected, it is more preferable to display the search report provisional registration data associated with the registration number on the home school terminal, including that the search report data has already been confirmed. .. It is possible to prevent double submission of a survey report that has already been finalized.

In the present invention, the "unique application identifier" includes, for example, a different identifier for each application. The "identifier" includes various types of identifiers, and may be, for example, any of alphabets and other characters, symbols, alphanumeric characters, etc., and a plurality of types thereof may be combined. The character length of the identifier is not particularly limited.

Further, the Web server is connected to the system of the payment company, and the Web server is connected to the system of the payment company.
The Web server includes a payment status update process in which the examination fee payment information for each application data is received and the examination fee payment information is added to the application data.
In the matching result display step,
When the Web server does not detect the application identifier in the search document provisional registration data in which the application data is detected in the application data detection process.
Detects the presence or absence of examination fee payment information in the corresponding application data,
If the examination fee payment information is not detected, the survey form data associated with the registration number is displayed on the screen of the school terminal, including the fact that it has not been paid.
When the examination fee payment information is detected, the survey form data associated with the registration number is displayed on the screen of the school terminal from which the student was born, including the area where payment has been made and the content can be confirmed. To accept the selection of content confirmation,
Moreover,
The Web server adds the application identifier included in the application data to the search report data whose content has been selected to be finalized in the matching result display process, and adds the application identifier included in the application data to the database of the examination school in the database as finalized search report data. It is more preferable to include a confirmed survey report storage step of storing the survey report provisionally registered data in association with the data. It is possible to know at the school of origin that the applicant has not completed the examination fee payment procedure, and the applicant can temporarily register the survey data even before the examination fee payment procedure, so the concentration of work of the teachers of the school of origin is eased. can do.

In addition, in the application acceptance process,
The Web server adds the applicant identifier to the application data.
In the confirmed survey report storage process
The Web server adds the applicant identifier to the confirmed search report data and adds the search report confirmation flag to the application data.
as well as,
In the matching result display step,
The Web server detects whether the application data detected in the application data detection step includes the search report confirmation flag.
When the survey report confirmation flag is detected, the survey report provisional registration data associated with the registration number may be displayed on the home school terminal, including that the survey report data has already been confirmed. preferable. It is possible to prevent double submission of a survey report that has already been finalized.

Further, the application data includes individual examination data having an application identifier, an examination number information, an application type information, and an applicant identifier, and applicant data having an applicant identifier, a date of birth information, a pseudonym information, and a school identifier. And, it is preferable to have. This is convenient when applicants apply to the same examination school with multiple application types.

Further, the Web server is further connected to the examination school terminal via a network.
The Web server accepts the finalized survey data request from the examination school terminal,
It is preferable that the Web server includes a survey report output step of displaying and downloading the survey report data stored in the database of the examination school in the database server. The search report data to be displayed is included in the finalized search report data stored in the database of the examination school in the database server and the application data associated with the finalized search report data. On the examination school side, it is not necessary to match the search form with the application data, and at the same time, the numbering is not required, and the application acceptance work is dramatically reduced. Therefore, it is possible to easily link the application data created by a large amount of Internet application system and the search report data in a short period of time while considering the integrity and confidentiality of the information. It is possible to reduce the working hours of all faculty members.

In the database server, the common key for the survey report that encrypts and decrypts the survey report data is encrypted using the passphrase for the school of origin and stored as the common key for the encrypted survey report (for the school of origin).
In addition, the common key for the survey form is encrypted using the passphrase for the examination school and stored as the common key for the encrypted survey form (for the examination school).
In the process of receiving survey report data for submission,
The WEB server accepts the passphrase for the school from which the student was born.
In the registration number issuing process
The Web server decrypts the common key for the survey report from the common key for the encrypted survey (for the school of origin) using the passphrase for the school of origin, and uses the decrypted common key for the survey report. Each survey report data is encrypted, and the school identifier and the registration number are associated with the encrypted survey report data to be temporary survey report registration data.
In the temporary registration data reading process,
The Web server decrypts the common key for the survey report from the encrypted common key for the survey report (for the school of origin) using the passphrase for the school of origin, and uses the decrypted common key for the survey report. , Decrypting each survey report data,
In the survey report output process
The Web server accepts the passphrase for the examination school from the examination school terminal,
The Web server decrypts the common key for the survey report from the common key for the encrypted survey (for the test school) using the passphrase for the test school, and decrypts each survey report data. It is preferable to decrypt, display and download using the common writing key. For submission, the survey report data including highly confidential survey report data is accepted for uploading in an encrypted state, decrypted, and the survey report data is encrypted with the survey report common key and stored in the database for submission. After creating the survey report data, information leakage of the survey report data can be prevented at any stage, and security can be strengthened. Furthermore, information leakage can be further prevented by combining the encryption and decryption of the common key for the survey report. In addition, in order to display the survey report data on the terminal of the examination school, the common key for decrypting the survey report data is decrypted using a passphrase different from that of the school from which the student was born. Excellent.

Moreover, the second aspect of the present invention is in the application via the Internet.
One or more Web servers connected to the applicant terminal and the terminal of the school of origin via a network,
With one or more database servers interconnected to the Web server,
It has a group of servers that have the functions of multiple types of servers, including
It is a matching system that matches the application data input from the applicant terminal with the search report data input from the home school terminal.
The Web server
The upload acceptance screen of the submission survey data including one or more survey data for one or more applicants is displayed on the home school terminal received by the login ID for each home school, and the home school terminal is displayed. The means for receiving the submitted survey data from the school terminal, which accepts the upload of the submitted survey data, and the means for receiving the submitted survey data.
Detects whether there are any omissions or mistakes in the date of birth information, furigana information of name, and internal report data in the survey form data for submission, and if there are no omissions or mistakes, accepts provisional registration of the survey form data for submission. Temporary registration reception means and
The home school identifier associated with the login ID and the same registration number for each of the submitted survey data for which provisional registration has been accepted are associated with each survey data and taken as survey report temporary registration data in the database server. A registration number issuing means that is added to the school database and the registration number is displayed on the terminal of the school from which the student was born.
From the applicant terminal, the application data including the date of birth information, the pseudonym information of the name, and the identifier of the school of origin to be submitted to the examination school is received, and the application acceptance means to be added to the database of the examination school in the database server, and the application acceptance means.
A survey form confirmation reception means that accepts the input of the registration number from the above-mentioned home school terminal received by the login ID for each home school,
Temporary registration data reading means for reading the survey report temporary registration data associated with the registration number from the database of the examination school in the database server.
Among the application data whose home school identifier matches the home school identifier associated with the login ID, the presence or absence of application data in which the date of birth information and the pseudonym information of the name match is detected from the database of the examination school in the database server. Application data detection means and
For the search report data for which the application data was not detected by the application data detection means, the search report provisional registration data associated with the registration number is sent to the terminal of the school of origin, including the fact that the application has not been registered. Matching result display means to be displayed and
To provide a matching system characterized by having.

According to the second aspect of the present invention, it is possible to easily link the application data created by a large amount of Internet application system in a short period of time with the search report data while considering the integrity and confidentiality of the information. It is possible to reduce the working hours of teachers involved in examination affairs on the school side. In addition, since it is not necessary to enter the examination number and application identifier at the time of matching, the teachers of the school of origin (junior high school in the high school entrance examination) will temporarily register the survey form even before the examination number is assigned or before the student completes the examination procedure. It is possible to avoid an increase in confirmation work / correction work due to an input error of the application identifier. Therefore, the time to perform the work can be dispersed, and the burden on the teacher is reduced. In addition, the examination school (high school in the case of high school entrance examinations) will not have to close the application early.

The Web server is connected to the payment company's system and the examination school terminal.
The Web server
A means for updating the payment status, which receives the examination fee payment information for each application data and adds the examination fee payment information to the application data.
For the search report data whose content has been selected by the matching result display means, the application identifier included in the application data is added and the search report is provisionally registered in the database of the examination school in the database as confirmed search report data. Confirmed survey report storage means to store in association with data,
Accepts the finalized survey data request from the test school terminal, displays and downloads the finalized survey data stored in the test school database and the application data associated with the finalized survey data in the database server. Survey report output means and
It is preferable to have. It is possible to know at the school of origin that the applicant has not completed the examination fee payment procedure, and the applicant can temporarily register the survey data even before the examination fee payment procedure, so the concentration of work of the teachers of the school of origin is eased. can do. On the examination school side, it is not necessary to match the search form with the application data, and at the same time, the numbering is not required, and the application acceptance work is dramatically reduced.

In addition, the Web server is connected to the system of the payment company and the terminal of the examination school.
The database server encrypts and stores a common key for the survey report that encrypts and decrypts the survey report data.
The submitted survey report data for which the Web server accepts uploads is encrypted using a key different from the survey report common key.
The temporary registration reception means
Decrypting the submitted survey data from the encrypted submitted survey data,
The registration number issuing means
The common key for the survey report is decrypted from the encrypted common key for the survey report.
Encrypt each survey report data using the decrypted common key for the survey report.
The temporary registration data reading means
Decrypting the survey report common key, and using the decrypted survey report common key, the Web server decrypts each survey report data.
as well as,
The Web server
A means for updating the payment status, which receives the examination fee payment information for each application data and adds the examination fee payment information to the application data.
The search report data whose content has been selected to be finalized by the matching result display means is encrypted, the application identifier included in the application data is added, and the search report is stored in the database of the examination school in the database as the finalized search report data. Confirmed survey report storage means to store in association with temporary registration data,
Each search receives the finalized search report data request from the test school terminal, and searches the finalized search report data stored in the test school database in the database server and the application data associated with the finalized search report data. A survey report output means that decrypts, displays, and downloads the document data,
It is preferable to have. The survey report data for submission, including the highly confidential survey report data, is uploaded in an encrypted state, encrypted by the encrypted common key, and stored in the database, so even the operator who operates the server can use the survey report. Since the data cannot be viewed, it is possible to further prevent information leakage of the survey report data and enhance security.

According to the present invention, it is possible to reduce the working hours of teachers involved in examination affairs on the side of the school from which they were born.

It is a figure which shows the configuration example of the matching system of Example 1 and Example 2. FIG. It is a figure which shows the server configuration of the matching system of Example 1 and Example 2. FIG. It is a figure which shows the whole flow of Example 1 and Example 2 of the matching method of this invention. It is a conceptual diagram (school side from home) which shows the flow of Example 1 and Example 2 of the matching method of this invention. It is a conceptual diagram (applicant side) which shows the flow of Example 1 and Example 2 of the matching method of this invention. It is an example of the download reception screen of the spreadsheet file in Example 1 and Example 2 of the matching method of the present invention. It is an example of a predetermined spreadsheet file in Example 1 and Example 2 of the matching method of the present invention. This is an example of transition from the upload acceptance screen of the survey report data for submission to the registration number issuance screen in Examples 1 and 2 of the matching method of the present invention. It is a transition example from the investigation report confirmation screen to the matching result display screen in Example 1 and Example 2 of the matching method of the present invention. It is a flow chart of the matching process in Example 1 and Example 2 of the matching method of this invention. It is a figure which shows an example of the home school table in Example 2 of the matching method of this invention. It is a figure which shows an example of the administrator table and the common key management table in Example 2 of the matching method of this invention. It is a figure which shows an example of the investigation report provisional registration table in Example 2 of the matching method of this invention.

The matching system of the present invention realizes its processing on a computer terminal (including a server) having an arithmetic processing unit such as a CPU and a storage device such as a RAM or a hard disk. The program that realizes the matching system of this embodiment is stored in the hard disk of the computer terminal, and the program is read into RAM or the like by performing a predetermined operation, and its function (means) is arithmetically processed. It is executed by the device, and a predetermined process is performed. The information stored as the storage means used for such processing is stored in a storage device such as a RAM or a hard disk in various file storage formats such as a database and a data file, and is appropriately read out during the processing. A predetermined process is performed. The processed result is also written to a storage device such as a RAM or a hard disk and stored as appropriate. Each means in the present invention merely logically distinguishes its functions, and may physically or substantially constitute the same region.

Hereinafter, preferred embodiments of the present invention will be specifically described with reference to the accompanying drawings with respect to the matching method and matching system of the present invention, but the present invention is not limited thereto. ..

In this example, the application registration information of one or more examinees who apply for the entrance examination to the examination school and the survey report data of each examinee submitted by the examinee's school to the examination school are pretended to be the name of the examinee. By matching with the date of birth data, it is possible to reduce the working hours of teachers at the school of origin regarding entrance examinations.

{composition}
In this embodiment, as an example, matching of application data and survey documents in high school entrance examinations that accept applications on the Internet will be described, but it is not limited to high school entrance examinations, such as university entrance examinations and junior high school entrance examinations. It may be an entrance examination of, or various certification examinations. Applicants may be candidates for the entrance examination as well as candidates for the certification examination.

FIG. 1 is a diagram showing a configuration example of the matching system of the first and second embodiments. In this embodiment, the matching system has a server group 5 composed of one or a plurality of servers, and the server group 5 has one or a plurality of Web servers 6 and one or a plurality of servers connected to each other. Has a database server 7 of. Each server may be physically composed of one or a plurality of servers to function as one type of server, and the functions of a plurality of types of servers may be physically composed of one server. It may have been done. For example, the database server may be in the Web server. Further, the database may be in one database server, or may be distributed in a plurality of database servers. In this embodiment, the Web server and the database server are physically connected to each other, but they may be in the same server, or they may be connected via a network and accessible to each other. good.

The matching system of this embodiment includes (A) one or more Web servers 6 connected to the applicant terminal 1, the home school terminal 2, and the test school terminal 3 via the network 4 in the Internet application for the entrance examination. It has a server group 5 having functions of a plurality of types of servers including one or a plurality of database servers 7 interconnected to a Web server 6, and (B) application data input from an applicant terminal 1 and a school of origin. It is a matching system that matches the survey report data input from the terminal 2. In the matching system of this embodiment, the Web server 6 (C) displays the upload acceptance screen of the survey report data for submission including one or more survey report data for one or more applicants for each school of origin. The date of birth is displayed on the home school terminal 2 received by the login ID, and the submission survey data reception means for accepting the upload of the submission survey data from the home school terminal 2 and (D) the submission survey data. (E) The home school identifier associated with the login ID and the same registration number for each submitted survey form data for which provisional registration has been accepted are associated with each survey form data and used as survey report temporary registration data for the examination school in the database server 7. Includes registration number issuing means to add to the database and display the registration number on the home school terminal 2, and (F) date of birth information, name signature information, and home school identifier to be submitted to the examination school from the applicant terminal 1. The application data is accepted and added to the database of the examination school in the database server 7. The registration number is input from the application acceptance means (G) the home school terminal 2 received by the login ID for each home school. The survey report confirmation reception means, (H) the temporary registration data reading means for reading the survey report temporary registration data associated with the registration number from the database of the examination school in the database server 7, and (I) the school identifier from which the student was born are logged in. Among the application data that matches the home school identifier associated with the ID, the application data detection means that detects the presence or absence of application data that matches the date of birth information and the pseudonym information of the name from the database of the examination school in the database server 7. (J) For the search report data for which the application data was not detected by the application data detection means, the search report provisional registration data associated with the registration number, including the fact that the application has not been registered, is included in the home school terminal 2 It has a matching result display means to be displayed on the screen.

Further, the Web server 6 is connected to the system of the settlement company via a dedicated line or a network such as the Internet, and (K) receives the examination fee payment information for each application data, and the examination fee has been paid to the application data. For the search report data for which the content confirmation has been selected by the payment status update means for adding information and the matching result display means (L), the application identifier included in the application data is added and the finalized search report data is stored in the database. Confirmed survey report storage means to store in the database of the test school in association with the temporary registration data of the survey report, and (M) Accept the confirmed survey report data request from the test school terminal 3 and store the test report data in the database server 7 It has a search report output means for displaying and downloading the finalized search report data stored in the data and the application data associated with the finalized search report data. In this embodiment, the communication means, the input means, and the display means are in the applicant terminal 1, the home school terminal 2, and the examination school terminal 3. The Web server 6 is a control means that is a control device composed of a storage (hardware) that is a secondary storage such as a memory, a CPU, and a magnetic disk, an operating system, and a device driver, and a communication that is a communication control device such as a LAN board. It has means, stores matching programs and various Web page contents on a magnetic disk, and the control unit executes various program processing. It has local connection means with the database server 7, and is from the applicant terminal 1. Information can be temporarily stored in the non-volatile memory in order to communicate with the school terminal 2 and the examination school terminal 3 many times, and may further have an input means, a display, and other output means. The database server 7 has a memory, a CPU, a storage (hardware), and a local connection means with the Web server 6, but may also have a communication means, an input means, a display, and other output means. The Web server 6 and the database server 7 cooperate with each other to perform the matching process of the present invention based on the operation command from the Web server 6. The Web server 6 and the database server 7 have a clock function and the like that a normal server has.

FIG. 2 is a diagram showing a server configuration of the matching system of the first and second embodiments. In this embodiment, the Web server 6 will be described with an example in which the function of the a-Web server 61 for the applicant and the function of the b-Web server 62 for the school of origin are one server. It may be a Web server in which the function for the purpose and the function for the school of origin are integrated, or in order to cope with the concentration of access, there may be a plurality of Web servers and a load balancer may be provided. Further, one or a plurality of Web servers may be cloud servers on the cloud. The cloud server is virtual, and in reality, a plurality of servers may be physically used as one cloud server. In that case, the memory and CPU (number of cores) can be expanded / reduced instantly.

In addition, the Web server 6 includes a survey report registration screen including an upload acceptance screen for submission survey report data for the school of origin, an application form screen for applicants, and data on an application & survey form management screen for the examination school. It has spreadsheet format data. In the database server 7, the ID (login ID) assigned for login for each school of origin is stored in association with the password, URL, and identifier of the school of origin, and the database 71 of the examination school is stored for each examination school. Has been done. The survey form registration screen for the school of origin and the application form screen for applicants are classified by the examination school. , You can apply for the application on the application form screen dedicated to each examination school. The explanations displayed on each screen are common to each school, and the same explanations are displayed on the screens of multiple schools of origin. As the data displayed on each screen, the data in the database of the examination school is dynamically displayed.

Application data, search report data, and session information are stored as databases in the database 71 of the examination school. The survey report data includes the survey report provisional registration data and the confirmed survey report data. The application database has an application data table, and the search report data table has a search report data table.

The database 71 of the examination school contains a list that associates the name of the school of origin and the identifier of the school of origin, a list that associates the application type name and the application type identifier, a list of input rules for internal report data, and a hiragana / katakana conversion program. It is remembered. The application type is, for example, a special advance course, an ordinary course, or the like.

The furigana information is hiragana in this embodiment, but may be katakana or alphabet. Data input in katakana may be converted to hiragana by a hiragana / katakana conversion program and unified into hiragana notation when displayed. Such a conversion program may be a conversion program from alphabet to hiragana, or may convert these notations to each other.

In this example, the survey report provisional registration data, the confirmed survey report data, and the survey report data include the survey report score, the number of days absent, and other special notes (committee activities, club activities, etc.). And. The database server 7 has a table definition file.

In this embodiment, the database server 7 is a dedicated server and exists in the data center together with the Web server 6, but both may be in the examination school. In this embodiment, the database server 7 is a dedicated server, and since the physical server is used exclusively (independently), the IO processing of the database is fast. In that case, the terminal of the examination school and the Web server will be connected by the campus LAN without going through the Internet. In this embodiment, the database server 7 holds a mirrored database for system availability, that is, so that even if it goes down, important confidential information is not lost and can be recovered immediately. The original database is the master database and the mirroring side is the slave database. The slave database cannot be written, it can only be read. When the system writes, it is written to the master database. When the slave database is written to the master database, the data is instantly mirrored and written to the slave database as well.

In the Web server 6, a search report data receiving means for submission, a temporary registration receiving means, a registration number issuing means, an application receiving means, a search form confirmation receiving means, a temporary registration data reading means, an application data detecting means, and a matching result display means. It has a payment status update means, a confirmed survey report storage means, and a survey report output means. Both the Web server 6 and the database server 7 may go through their respective front units in order not to be aware of which server the control unit exists on. Each front unit has a program to be executed in each server and cooperates in processing. In this embodiment, each means is controlled by the front portion of both the Web server 6 and the database server 7.

The applicant terminal 1, the home school terminal 2, and the examination school terminal 3 are accessed by indicating one URL (Uniform Resource Locator) as a connection destination, the load balancer receives the access to the URL, and the load balancer is connected to the load balancer. By distributing the access to a plurality of Web servers 6, the load on each Web server can be distributed. Further, as another method for avoiding the concentration of Web access, there is a system using round robin in DNS (Domain Name System). The connection destination URL created by the Web server 6 is a Web page in the virtual Web server. Further, in order to display a specific Web page of the virtual server, a URL including a virtual directory may be used as a connection destination URL. When creating a predetermined access Web page, an existing access Web page may be duplicated.

The server group 5 can send and receive information to and from the applicant terminal 1, the home school terminal 2, and the examination school terminal 3 via a communication network such as the Internet, LAN, and WAN. The applicant terminal 1 may be, for example, a personal computer (PC) including a notebook PC or a tablet PC, a mobile phone including a smartphone, a PDA, or the like. The home school terminal 2 and the examination school terminal 3 may be, for example, a personal computer (PC) including a notebook PC or a tablet PC.

The registration number issuing means uses the clock function of the Web server 6 to create a unique registration number based on the system time. The registration number is preferably a unique registration number for each examination school. "Unique" includes the meaning of unique and unique. The "unique registration number" includes, for example, a different identifier for each survey report provisional registration data. The "identifier" includes various types of identifiers, and may be, for example, any of alphabets and other characters, symbols, alphanumeric characters, etc., and a plurality of types thereof may be combined. The character length of the identifier is not particularly limited. For example, create with a combination of symbols and alphanumeric characters such as "zR5ArC". By combining the date data and the unique key generated based on the system time of the Web server 6, it does not overlap with other registration numbers stored in the examination school database for each examination school in the database server 7. It is automatically created in.

The matching program installed in the Web server 6 displays on the computer (a) an upload reception screen for submission survey data including one or more survey data for each applicant, for one or more applicants. Displayed on the home school terminal 2 received by each login ID, and the submission survey data reception function that accepts the upload of the submission survey data from the home school terminal 2, and (a) the submission survey data A temporary registration reception function that detects whether there are any omissions or mistakes in the date of birth information, name signature information, and internal report data, and accepts temporary registration of the survey report data for submission if there are no omissions or mistakes. C) Take the test in the database server 7 as the survey report temporary registration data by associating the home school identifier associated with the login ID and the same registration number for each survey report data for submission that received the provisional registration with each survey report data. A registration number issuance function that adds the registration number to the school database and displays the registration number on the home school terminal 2. The application acceptance function that accepts application data including the above and adds it to the database of the examination school in the database server 7 and (e) input the registration number from the home school terminal 2 that was accepted by the login ID for each home school. The survey report confirmation reception function to be accepted, (f) the temporary registration data reading function to read the survey report temporary registration data associated with the registration number from the database of the examination school in the database server 7, and (g) the school identifier of the school of origin. The application data detection function that detects the presence or absence of application data that matches the date of birth information and the pseudonym information of the name from the database of the examination school in the database server 7 among the application data that matches the origin school identifier associated with the login ID. (H) For the search report data for which the application data was not detected by the application data detection function, the search report provisional registration data associated with the registration number, including the fact that the application has not been registered, is the school of origin. Matching result display function to be displayed on terminal 2, (k) payment status update function to receive examination fee payment information for each application data and add examination fee payment information to application data, and (co) matching result display For the search report data whose content has been selected by the function, the application identifier included in the application data is added and stored as confirmed search report data in the database of the examination school in association with the search report provisional registration data. Completed survey report memory function and (sa) examination A search that accepts a finalized survey data request from the school terminal 3 and displays and downloads the finalized survey data stored in the database of the test school and the application data associated with the finalized survey data in the database server 7. This is a program for realizing the write output function.

The Web server 6 realizes the function of a computer capable of the matching process of the present invention by the CPU of the Web server 6 loading the matching program of the Web server 6 into the memory of the Web server 6 and executing the matching program. The CPUs of the Web server 6 and the database server 7 are arithmetic processing units mounted on a normal computer, and can execute various programs and perform various controls and the like.

In this embodiment, the Web server 6 functions as each of the above-mentioned means (C) to (M) by the above-mentioned hardware configuration and the matching program.

In addition to the matching program, the Web server 6 is equipped with an examination number issuing program and other programs that perform an examination number issuing process, which will be described later.

FIG. 3 is a diagram showing the overall flow of Examples 1 and 2 of the matching method of the present invention. The examination school distributes the information on the screen of the school of origin (Web page created for each school of origin) to each school of origin in advance. In addition, a predetermined spreadsheet file including a macro created by spreadsheet software is distributed or downloaded. The faculty member of the school of origin inputs the contents of the survey form of the applicant who will take the examination at the above-mentioned spreadsheet file, creates the survey form data for submission with a macro, and saves (outputs) it on the desktop. The applicant creates an account on the application form screen displayed by the matching system of this embodiment, inputs predetermined items, and registers the application. Applicants can print a preview of the application form and pay the examination fee by a method such as online payment by credit card. When the teacher of the school of origin uploads the survey report data for submission on the survey report registration screen including the upload reception screen displayed by the matching system of this example, the matching result with the progress of the applicant's procedure will be obtained. It is possible to display, regardless of the progress of the applicant's procedure, the validity of the data is checked, the survey report Web temporary registration can be performed, and a registration number can be given for each temporary registration. .. Temporary registration can be redone as many times as you like. Once the registration number is assigned, the applicant can later accumulate the finalized search report data in the matching system of this example after the application registration and examination fee payment are completed (search report registration confirmed). Once confirmed, the applicant's survey data cannot be changed. The finalized survey report data can be displayed and confirmed by the teachers of the examination school by the matching system of this embodiment. The unconfirmed survey form data at the stage of provisional registration cannot be viewed by the examination school.

{Processing process}
The matching method of this embodiment is as follows: (A) One or more Web servers 6 connected to the applicant terminal 1 and the home school terminal 2 via the network 4 and the Web server 6 in the Internet application for the entrance examination or the test. It has one or a plurality of database servers 7 interconnected to each other, and a server group 5 having a function of a plurality of types of servers including (B) application data input from the applicant terminal 1 and from the home school terminal 2. This is a matching method that matches the input survey report data. In the matching method of this embodiment, the (Step 10) Web server 6 displays the upload acceptance screen of the survey report data for submission including one or more survey report data for one or more applicants for each school of origin. The submission survey data reception process, which is displayed on the home school terminal 2 received by the login ID and accepts the upload of the submission survey data from the home school terminal 2, and the (Step 20) Web server 6 perform the submission survey. Temporary registration acceptance process that detects whether there are any omissions or mistakes in the date of birth information, name signature information, and internal report data in the written data, and accepts temporary registration of the survey report data for submission if there are no omissions or mistakes. And (Step30), the Web server associates the school identifier associated with the login ID and the same registration number for each submitted survey data for which provisional registration has been accepted as survey report temporary registration data. , The registration number issuance process of adding to the database of the examination school in the database server 7 and displaying the registration number on the home school terminal 2, and the year of birth that the (Step 40) Web server 6 submits to the examination school from the applicant terminal 1. The application acceptance process that accepts application data including date information, name assignment information, and school identifier and adds it to the database of the examination school in the database server 7, and the (Step 50) Web server 6 for each school of origin. The survey report confirmation reception process that accepts the input of the registration number from the home school terminal 2 received by the login ID and the (Step60) Web server 6 are associated with the registration number from the database of the examination school in the database server 7. Of the application data in which the temporary registration data reading process for reading the temporary registration data of the survey report and the application data in which the (Step70) Web server 6 matches the home school identifier associated with the login ID with the home school identifier of the survey report temporary registration data. , The application data detection process that detects the presence or absence of application data in which the date of birth information and the name signature information match from the database of the examination school in the database server 7, and the (Step80) Web server 6 applies in the application data detection process. For the search report data for which no data was detected, a matching result display process for displaying the search report provisional registration data associated with the registration number on the home school terminal 2 including the fact that the application has not been registered, and Is included.

In this embodiment, the Web server is further connected to the system of the settlement company, and after the application acceptance process, the (Step 41) Web server 6 receives the examination fee payment information for each application data and takes the examination in the application data. The application data includes the search report data in which the (Step90) Web server 6 has selected the content determination in the matching result display process after the matching result display process, which includes the payment status update process for adding the fee payment information. It includes a finalized search report storage process in which the application identifier is added and stored as confirmed search report data in the database of the examination school in association with the search report provisional registration data.

Further, in this embodiment, the Web server is further connected to the examination school terminal 3 via the network, and after the finalized survey report storage process, the (Step100) Web server is connected to the examination school terminal 3 from the examination school terminal 3. Includes a survey report output process that accepts the finalized survey report data request, displays and downloads the finalized survey report data stored in the database of the test school in the database server 7 and the application data associated with the finalized survey report data. ..

In this embodiment, the matching program causes a computer to perform the following steps.

FIG. 4 is a conceptual diagram (on the side of the school of origin) showing the flow of Example 1 and Example 2 of the matching method of the present invention. In FIG. 4, the contents in parentheses are additional contents in the second embodiment described later, and are omitted in the first embodiment. Further, FIG. 5 is a conceptual diagram (applicant side) showing the flow of Example 1 and Example 2 of the matching method of the present invention.

The processing process of the matching method of this embodiment will be described in more detail. The Web server 6 is controlled by the front unit to execute each of the following steps.

(Step1)
The Web server 6 accepts login with an ID and password from the home school terminal 2 that has accessed the URL of the home school screen described in the home school screen information distributed to the home school. The identifier of the school of origin specified by the ID logged in to the screen of the school of origin is stored in the database 71 of the examination school in the database server 7. The logged-in account information, that is, the login ID is stored in association with the school identifier.

(Step2)
The Web server 6 accepts download of a predetermined spreadsheet file format including a macro created by spreadsheet software from the spreadsheet terminal 2 logged in to the spreadsheet screen. FIG. 6 is an example of a spreadsheet file download reception screen in the first and second embodiments of the matching method of the present invention. In FIG. 6, the passphrase and its frame are additional contents in the screen example in the second embodiment described later, and are not displayed in the first embodiment. As shown in FIG. 6, on the screen of the school from which the student was born, the format can be clicked and downloaded, and the download is accepted. The teacher of the school of origin who downloaded the spreadsheet file inputs one or more survey report data for one or more applicants into the spreadsheet file described above. You may copy and paste from an existing file. FIG. 7 is an example of a predetermined spreadsheet file in Examples 1 and 2 of the matching method of the present invention. The spreadsheet file described above is provided with a file export switch for submission, and a macro is started by clicking, and the survey report data for submission is automatically created on the desktop.

(Step 10) Submission Survey Report Data Reception Process FIG. 8 is an example of transition from the submission survey report data upload reception screen to the registration number issuance screen in Examples 1 and 2 of the matching method of the present invention. For example, in FIG. 7, the leftmost group number and number are not used for matching. The second and third gender information from the left may be used for matching. The furigana of the fourth name from the left is used for matching. The fifth name and kanji from the left may be used for matching. The 6th to 8th dates of birth from the left are used for matching. The 9th to 18th internal report data from the left is not used for matching. The 19th school code from the left is a code that identifies the school to be examined and is not used for matching. The school identifier identified by the account information logged in to the school screen is used for matching. A series of screens displayed on the terminal of the school of origin, from the upload acceptance screen of the survey form data for submission to the registration number issuance screen, the matching result display screen, and the registration confirmation screen, are collectively called the survey form registration screen. In FIG. 8, the passphrase and its frame are additional contents in the screen example in the second embodiment described later, and are not displayed in the first embodiment.

As shown in the upper left of FIG. 8, the Web server 6 displays the upload acceptance screen of the survey report data for submission, which includes one or more survey report data for one or more applicants, by the login ID for each school of origin. It is displayed on the received home school terminal 2, and the upload of the survey report data for submission is accepted from the home school terminal 2. On the upload reception screen, as shown in the upper right of FIG. 8, the name of the teacher of the school of origin is entered.

(Step 20) Temporary registration acceptance process When the Web server 6 detects whether there is any omission or mistake in the date of birth information, name signature information and internal report data in the survey form data for submission, and if there is no omission or mistake, We accept temporary registration of survey form data for submission. As shown in the lower left of FIG. 8, the input contents are displayed as a table on the home school screen.

The Web server 6 detects from the database of the test school in the database server 7 whether or not there is application data in which the date of birth information and the pseudonym information of the name match, and if there is application data, the application has been registered. The information, that is, the information that the application data is not registered when there is no application data, is included in each search report data, and the list of the search report data for submission is displayed on the home school terminal 2.

When the Web server 6 detects omissions or mistakes in any of the date of birth information, the pseudonym information of the name, and the internal report data in the survey report data for submission, the provisional registration is not accepted and there is a omission or mistake. The error display of the location is included in each survey report data, and a list of survey report data for submission is displayed on the home school terminal 2. For example, if the date of birth is missing or the furigana is missing, when displaying the table as shown in the lower left of Fig. 8, the cell with the error is colored and the error is displayed, and the temporary registration is performed. Do not display the button. In that case, return to the upload screen and try again. Regarding the internal report data, regarding the input of numbers, the input of alphabets, the range of numbers, etc., if they match the input rule list of the internal report data, there is no error display, but if they do not match, the input part of that part is displayed as an error.

In this embodiment, even if the characters are input in katakana, they are automatically converted to hiragana, and the phonetic spelling to be displayed may be unified in katakana instead of hiragana, or displayed in alphabetical characters. You may.

In the provisional registration acceptance process, if there is no blank entry for all uploaded applicants in the uploaded submission survey data and the internal application data is in accordance with the input rules, even if the applicant's application data is not detected, it is provisional. A registration button is displayed, and temporary registration is possible. Temporary registration can be redone as many times as you like.

(Step30) Registration number issuance process The Web server associates the school identifier associated with the login ID and the same registration number information for each submitted survey data that has received provisional registration with each survey data, and provisionally surveys. As the registration data, it is added to the survey report temporary registration table of the database of the examination school in the database server 7, and the registration number is displayed on the home school terminal 2 as shown in the lower right of FIG. Therefore, in this embodiment, provisional registration can be accepted even if the corresponding application data is not in the database server 7. The survey report provisional registration data has records (elements) of each attribute (column) of the registration number, date of birth, name syllabary, name kanji, internal report data, home school identifier, and survey report registration number. , Does not have an application identifier. In addition, the search report provisional registration data may have records (elements) of each attribute (column) of gender and application type. The home school terminal 2 may log out after the registration number issuance process and log in again in the survey report confirmation reception process (Step 50) described later.

(Step 40) Application acceptance process The Web server 6 receives the application data including the date of birth information, the pseudonym information of the name, and the identifier of the school of origin to be submitted to the examination school from the applicant terminal 1, and takes the examination in the database server 7. Add to the application data table in the school database. The application acceptance process may be prior to the submission search report data acceptance process. If the completed survey report storage process has been completed before the finalized survey report storage process, the applicant's survey report data can proceed to the finalized survey report storage process. The screen displayed on the applicant terminal 1 in the application acceptance process is the application form screen, and on the application form screen, the date of birth, the kanji of the name, the pseudonym of the name, and the identifier of the school of origin (automatic input by selection by the name of the school of origin may be used). ), Class, number in class, address, gender, application type, telephone number, guardian name, etc. may be entered.

The application data may include kanji information for the name and the class of the school of origin and the number within the class. In that case, in the above-mentioned temporary registration acceptance process (Step 20), the Web server 6 adds the date of birth information, the name syllabary information, and the internal report data to the survey report data for submission, as well as the kanji information of the name and the school of origin. It also detects whether there are any omissions or mistakes in the class and the numbers in the class, and if there is any omission or mistake in any of them, temporary registration will not be accepted. Further, in the application data detection step (Step 70) described later, the Web server 6 uses the date of birth information and the name of the pseudonym information among the application data whose home school identifier matches the home school identifier of the search report provisional registration data. In addition, the presence or absence of application data that matches the class of the school of origin and the number in the class is detected from the database of the examination school in the database server 7.

Further, the Web server 6 may add a unique application identifier to the received application data. In that case, in the matching result display step (Step 80) described later, the Web server 6 detects whether the application identifier is included in the search document provisional registration data in which the application data is detected in the application data detection step, and the application identifier is detected. If so, the survey report provisional registration data associated with the registration number is displayed on the home school terminal 2 including that the survey report data has already been confirmed. The “unique application identifier” includes, for example, a different identifier for each application. The "identifier" includes various types of identifiers, and may be, for example, any of alphabets and other characters, symbols, alphanumeric characters, etc., and a plurality of types thereof may be combined. The character length of the identifier is not particularly limited.

In addition, the Web server may add the applicant identifier to the application data. In that case, in the finalized search report storage step (Step 90) described later, the Web server 6 adds the applicant identifier to the finalized search report data and adds the search report finalization flag to the application data. Further, in the matching result display step (Step 80) described later, the Web server detects whether the application data detected in the application data detection step includes the search document confirmation flag, and if the search document confirmation flag is detected, The temporary registration data of the survey report associated with the registration number is displayed on the terminal of the school of origin, including that the survey report data has already been confirmed.

In this embodiment, the application data includes individual examination data and applicant data. The individual examination data has a record (element) of each attribute (column) of the application identifier and the examination number, and the application type and the applicant identifier. The applicant data has a record (element) of each attribute (column) of the applicant identifier, the date of birth information, the pseudonym information, the Chinese character information, and the school identifier. The individual examination data does not physically have the origin school identifier, but the applicant data has the origin school identifier, and the individual examination data and the applicant data can be virtually treated as the same table. Therefore, it is possible to virtually make it appear that the individual examination data has the identifier of the school of origin.

(Step 41) Payment Status Update Process The Web server 6 receives the examination fee payment information for each application data, and adds the examination fee payment information to the application data. In this embodiment, the Web server 6 accepts the payment of the examination fee from the applicant terminal 1. In the case of immediate settlement, the examination fee payment information is added to the application data of the database 71 of the examination school in the base server 7 when the payment acceptance is completed by the interface with the system of the settlement company. If the payment is not immediate, the payment ID will be obtained through the interface with the payment company's system and added to the application data. If payments other than credit card payments such as convenience store payments are confirmed through the interface with the payment company's system, the examination fee will be paid. The completed information is added to the application data. The information of the settlement company is automatically updated by the matching system of this embodiment. When paying at a convenience store or ATM, the payment company's system obtains information from the payment company's system to the server of the matching system of this example using PUSH, or the PULL type obtains information through regular inquiries and updates the examination fee payment information. ..

(Step43) Examination number issuance process This process is based on the examination number issuance program, not the matching program. As shown in the lower part of FIG. 5, at the time of application data creation, the Web server 6 searches for the examination fee paid information and the existence of the examination number, and the examination fee has been paid and the examination number has not been issued. If there is, an examination number is issued and added to the application data of the database 71 of the examination school in the database server 7. When the search report data (confirmed search report data or search report provisional registration data) is associated with the application data, the Web server 6 searches for the examination fee payment information and the existence of the examination number, and the examination fee payment is completed. If the examination number has not been issued, the examination number is issued and added to the application data of the database 71 of the examination school in the database server 7. Alternatively, when the date specified in advance arrives after the examination fee payment information is associated with the application data, the Web server 6 issues an examination number and adds it to the application data of the database 71 of the examination school in the database server 7. It may be what is done. When the examination number is issued, the examination number can be confirmed from the examination school terminal 3. When the examination number is issued, the examination voucher can be issued, and the Web server 6 receives the examination voucher issuance request from the applicant terminal 1, displays the examination voucher on the applicant terminal 1, and makes it downloadable.

(Step 50) Survey Report Confirmation Accepting Process FIG. 9 is a transition example from the survey report confirmation screen to the matching result display screen in Examples 1 and 2 of the matching method of the present invention. In FIG. 9, the passphrase and its frame are additional contents in the screen example in the second embodiment described later, and are not displayed in the first embodiment. FIG. 10 is a flow chart of matching processing in Examples 1 and 2 of the matching method of the present invention. When logging out and logging in again in the registration number issuing process (Step 30), the Web server 6 uses the ID from the home school terminal 2 that has accessed the URL of the home school screen described in the home school screen information distributed to the home school. And accept the login with the password. The identifier of the school of origin specified by the account information specified by the ID logged in to the screen of the school of origin is stored in the database 71 of the examination school in the database server 7. When the confirmation / registration confirmation button is clicked on the home school screen as shown in the upper left of FIG. 9, the registration number input screen is displayed as shown in the upper right of FIG. The Web server 6 accepts the input of the registration number from the home school terminal 2 received by the login ID for each home school.

(Step 60) Temporary registration data reading process The Web server 6 reads the survey report temporary registration data associated with the registration number from the database of the examination school in the database server 7.

(Step70) Application data detection process The Web server 6 databases the existence of application data in which the date of birth information and the pseudonym information of the name match among the application data whose home school identifier matches the home school identifier associated with the login ID. It is detected from the database 71 of the examination school in the server 7. In this embodiment, even if it is input in katakana, it is automatically unified and matched with hiragana, but it may be unified with katakana or it may be matched with alphabet.

(Step80) Matching result display process For the search report data for which the application data was not detected in the application data detection step, the application is not registered in the search report provisional registration data associated with the registration number. Including that, it is displayed on the home school terminal 2.

When the application identifier is not detected in the search document data in which the application data is detected in the application data detection process, the Web server 6 detects the presence or absence of the examination fee paid information in the corresponding application data. At that time, if the examination fee payment information is not detected, the Web server 6 displays the survey report data associated with the registration number on the home school terminal 2, including the fact that it has not been paid. .. At that time, if the examination fee payment information is detected, the Web server 6 includes the area where the survey report data associated with the registration number can be selected to be paid and the content confirmed. Then, it is displayed on the screen of the home school terminal 2, and as shown in the lower left of FIG. 9, the selection of the content confirmation is accepted. When the confirmed search report data is already associated with the application data, the Web server 6 causes the home school terminal to display the fact that "confirmed with another registration number". On the screen of the school of origin shown in the lower left of Fig. 9, select one or more of the checkable lines and click "Confirm the checked survey form" at the bottom to see the person in charge and name of the confirmed person. The screen for accepting phone number input appears. Pressing the confirm button on such a screen replaces stamping the principal's settlement on a paper survey report.

In the matching result display step, the Web server 6 displays the matching result on the screen and adds the session result as session information to the database 71 of the examination school in the database server 7 in association with the survey report data. The session information is a record (element) of each attribute (column) of the time session deadline, whether the application registration / unregistration, examination fee payment / unpaid, and confirmed search report data are associated with the application data at the time of matching. Has.

(Step 90) Confirmed search report storage process The Web server 6 adds the application identifier included in the application data to the finalized search report data for which the content has been selected to be finalized in the matching result display process, and the database 7 is used as the finalized search report data. It is stored in the database 71 of the examination school in association with the temporary registration data of the survey report. The finalized search report data has a record (element) of each attribute (column) of the registration number, the search report registration number, the application identifier, and the applicant identifier. The finalized survey data does not have a physical copy of the date of birth, the pseudonym of the name, the kanji of the name, the internal report data, and the identifier of the school of origin, and these elements are physically copied. , The survey report provisional registration data associated with the confirmed survey report data has. Gender and application type may be included as other factors that the provisional search report data has and are associated with the finalized search report data. One applicant may apply for multiple exams at the same time. If there is no finalized search report data for the application identifier, the search report data for the applicant identifier may be used. The search report confirmation flag is set for the application data associated with the finalized search report data.

When the confirm button is clicked within the time session deadline on the home school screen shown in the lower right of FIG. 9, the Web server 6 displays the selectable area on the screen shown in the lower left of FIG. 9 and the selected application data is displayed. Stores the registration designation number indicating the number from the top, that is, the number of lines in the list with the same registration number in the session information. The registration designation number is a number attached only to those for which the selectable area (check box) is checked. When the session information associated with the search report provisional registration data stored associated with the relevant application data is read again and the registration designation number is not associated, that is, the determinable search report provisional registration data is If it is not found in the database 71 of the test school in the database server 7, an error is displayed, and if it is found, the application identifier for the registration designation number and the search report provisional registration data are used as the confirmed search report data in the database server 7. It is stored in the database 71 of the examination school. The finalized search report data is the search report data for each applicant (and for each application type) after completing the application procedure including payment of the examination fee and confirming the search report information. The finalized survey report table has all the finalized survey report data. The survey report provisional registration table and the confirmed survey report table are collectively called the survey report table.

(Step100) Survey report output process The Web server 6 receives the finalized survey report data request from the test school terminal 3, and the finalized survey report data and the finalized survey stored in the database 71 of the test school in the database server 7. Display and download the application data associated with the document data. In the search report output process, the screen displayed on the examination school terminal 3 is the application & search report management screen, and on the application & search report management screen, the finalized search report data and the application data associated with the finalized search report data are applied. It is possible to arrange each data in one line and display it in a table format for printing, or to display the finalized search report data and the application data associated with the finalized search report data on one sheet for each application data. Can also be printed. Each survey report data is included in the finalized survey report data in the database 71 of the examination school. In the survey report output process, the finalized survey report data displayed in response to the finalized survey report data request includes the survey report data of each student.

{effect}
According to this embodiment, the application information submitted by the applicant who applies for the Internet to the examination school and the search report information submitted by the school of origin to the examination school can be easily and for a short period of time while considering the integrity and confidentiality of the information. Can be matched in large numbers. In addition, this makes it possible to reduce the working hours of teachers involved in examination affairs on the side of the school from which they were born. Furthermore, it is possible to reduce the working hours of teachers involved in examination affairs on the examination school side.

In this embodiment, the application data created by the Internet application system and the search report data can be linked, and the working hours of all the teachers involved in the examination affairs on the home school side and the examination school side can be reduced. In this embodiment, since it is not necessary to enter the examination number and the application identifier at the time of matching, the teacher of the school of origin (junior high school in the high school entrance examination) even before the examination number is given or before the student performs the examination procedure. The search report can be provisionally registered, and it is possible to avoid an increase in confirmation work / correction work due to an input error in the application identifier. Therefore, the time to perform the work can be dispersed, and the burden on the teacher is reduced. In addition, the examination school (high school in the case of high school entrance examinations) will not have to close the application early.

In addition, according to this embodiment, it can be understood at the school of origin that the applicant has not completed the application procedure, and even before the application procedure, an error in the search report data is displayed, so that the application deadline is not reached. However, it is possible to confirm the inadequacies of the survey report and ease the concentration of work.

In this embodiment, when matching is performed using the school identifier, date of birth and furigana, and the Chinese characters of gender and name, or the class and the number in the class, the probability of strict matching can be increased. Further, when there are a plurality of applicants who are matched to one search report data by matching the date of birth and furigana, the Chinese characters of the name may be displayed and selected. Further, when the application data includes the class and the number in the class, the class and the number in the class may be displayed and selected.

In addition, according to this embodiment, it is possible to prevent double submission of a survey report that has already been finalized.

Furthermore, according to this embodiment, it can be understood at the school of origin that the applicant has not completed the examination fee payment procedure, and the applicant can temporarily register the survey data even before the examination fee payment procedure. It is possible to ease the work concentration of teachers at the school of origin. In addition, it is highly convenient for applicants to apply to the same examination school with a plurality of application types.

Further, according to this embodiment, on the examination school side, it is not necessary to match the search report with the application data, and at the same time, the numbering is not required, and the application acceptance work is dramatically reduced.

Since it is possible to match using the applicant information originally held by the school of origin, such as the date of birth and furigana, instead of the information such as the examination number newly given to the applicant for each applicant's examination from the examination school. It is possible to reduce the burden on teachers at the school of origin and prevent number deviations due to input errors.

The steps after the survey confirmation acceptance process can also be performed before the examination number is assigned. As a result, the faculty member of the school from which he / she is from can register the survey form with a margin, and the examination school can delay the issuance of the examination number to the very limit. Since the issuance of the examination number can be delayed, the applicants who are added later can also arrange the examination numbers for each school of origin in the same way as other applicants.

In this example, in consideration of the risk of information leakage from the information environment in the school from which the student was born, such as the terminal of the school from which the student was born, in addition to reducing the working hours of the teachers involved in the examination work on the school side from which the school is from, information leakage can be prevented. be.

In this embodiment, the survey report data for submission is further encrypted and created, the upload is accepted in the encrypted state, decrypted to check for omissions and mistakes, and another encryption is performed at the time of temporary registration. The survey report data is encrypted by decrypting the survey report common key, and the encryption and decryption of the survey report common key is performed by different paths for the school of origin, the test school, and the system administrator. Since it is done by a phrase, it is possible to prevent the data of the survey report for submission from being saved in the unencrypted state on the terminal of the school from which the student was born, and the contents of the survey report will be leaked to the outside and information will be leaked. It can be prevented, and it is possible to prevent everyone who uses the system from knowing the common key for the survey report. That is, in this embodiment, in addition to the effects of Example 1 described above, information leakage of the survey report is prevented and security is strengthened.

In addition, this embodiment can be used by a plurality of schools of origin and a plurality of examination schools, and may be, for example, an application portal site common to a plurality of examination schools in the same district. Each school of origin selects the school to be examined on the portal site, downloads the survey report creation sheet, which is a spreadsheet file format for creating survey report data for submission, and encrypts it on the upload reception screen for each exam school. Upload the submitted survey report data. Therefore, convenience is further improved.

Each decrypted survey report data is data temporarily created in the memory of the server, and is preferably stored in the database server in an encrypted state. It is preferable that the decrypted survey report data for submission is deleted after each of the survey report data included is encrypted to create the survey report provisional registration data.

The configuration, program, and processing process of the matching system of this embodiment are the same as those of the first embodiment except for the points described later.

The matching system of this embodiment includes (A) one or more Web servers 6 connected to the applicant terminal 1, the home school terminal 2, and the test school terminal 3 via the network 4 in the Internet application for the entrance examination. It has a server group 5 having functions of a plurality of types of servers including one or a plurality of database servers 7 interconnected to a Web server 6, and (B) application data input from an applicant terminal 1 and a school of origin. It is a matching system that matches the survey report data input from the terminal 2. In the matching system of this embodiment, (C) the upload acceptance screen of the submission survey data including one or more survey data for one or more applicants is accepted by the login ID for each school of origin. Display on the home school terminal 2 and accept the input of the home school passphrase and the upload of the encrypted submission survey data (survey data first encrypted file) from the home school terminal 2. Data reception means and (D Deletion of the submitted survey report data from the encrypted submitted survey report data (survey report data 1st encrypted file), and the date of birth information and name in the submitted survey report data Temporary registration acceptance means that detects whether there are any omissions or mistakes in the pseudonym information and the internal report data, and accepts provisional registration of the survey report data for submission if there are no omissions or mistakes, and (E) a common key for the survey report. Was decrypted from the encrypted common key for the survey (encrypted common key for the survey (for the school of origin)), and each survey data was encrypted and encrypted using the decrypted common key for the survey. Regarding the survey report data (survey report data second encrypted file), the school identifier associated with the login ID and the same registration number for each submission survey report data for which provisional registration was accepted are associated with each survey report data. As the survey report provisional registration data, add it to the database of the examination school in the database server 7 and submit it to the examination school from the registration number issuing means for displaying the registration number on the home school terminal 2 and (F) the applicant terminal 1. Accepts application data including date of birth information, name signature information and school of origin identifier, and adds it to the database of the examination school in the database server 7 Application acceptance means and (G) Accept by login ID for each school of origin The survey report confirmation reception means that accepts the input of the registration number from the home school terminal 2 that was created, and (H) the common key for the survey report that is encrypted, the common key for the survey report (common key for the encrypted survey report (origin) Decrypted from (for school)) using the passphrase of the school of origin, the Web server decrypts each survey form data using the decrypted common key for the survey form, and the registration number is displayed in the database server 7 from the database of the test school. Of the application data in which the temporary registration data reading means for reading the temporary registration data associated with the (I) home school identifier matches the home school identifier associated with the login ID, the date of birth information and the pseudonym of the name The application data detection means that detects the presence or absence of application data with matching information from the database of the examination school in the database server 7, and (J) the application data detection means on the application date. For the search report data for which data was not detected, a matching result display means for displaying the search report provisional registration data associated with the registration number on the home school terminal 2 including the fact that the application has not been registered, and (K) A survey report in which the payment status update means for receiving the examination fee payment information for each application data and adding the examination fee payment information to the application data, and (L) the matching result display means for which the content is confirmed are selected. The confirmed search report storage means that encrypts the data, adds the application identifier included in the application data, and stores it in the database of the examination school as confirmed search report data in association with the search report provisional registration data, and (M. ) Accepting the finalized search report data request from the test school terminal, the finalized search report data stored in the test school database in the database server and the application data associated with the finalized survey form data are stored in each search form data. Has a survey report output means for decoding, displaying and downloading. In this embodiment, the Web server 6 functions as each of the above-mentioned means (C) to (M) by the above-mentioned hardware configuration and the matching program. Other points are the same as in Example 1 described above.

The matching program installed in the Web server 6 displays on the computer (a) an upload reception screen for submission survey data including one or more survey data for each applicant, for one or more applicants. It is displayed on the home school terminal 2 received by each login ID, and the home school passphrase is input and the encrypted submission survey data (survey report data 1st encrypted file) is uploaded from the home school terminal 2. Submission survey data reception function and (a) Submission survey data are decrypted from the encrypted submission survey data (survey data first encrypted file) and submitted survey data. Detects whether there are any omissions or mistakes in the date of birth information, name signature information, and internal report data, and if there are no omissions or mistakes, a temporary registration reception function that accepts temporary registration of survey report data for submission. (C) Decrypt the common key for the survey report from the encrypted common key for the survey report (common key for the encrypted survey report (for the school of origin)), and use the decrypted common key for the survey report for each survey report. For the survey report data (survey report data second encrypted file) that is encrypted by encrypting the data, the school identifier associated with the login ID and the same registration number for each submission survey report data that has received provisional registration, Is associated with each survey report data and added to the database of the test school in the database server 7 as survey report temporary registration data, and the registration number issuance function to display the registration number on the home school terminal 2 and (d) Applicant terminal From 1, the application acceptance function that accepts the application data including the date of birth information, the pseudonym information of the name and the identifier of the school of origin to be submitted to the examination school and adds it to the database of the examination school in the database server 7 and (e) The survey report confirmation reception function that accepts the input of the registration number from the home school terminal 2 received by the login ID for each school of origin, and (f) the common key for the survey report that is encrypted and the common key for the survey report (encryption) Decrypt from the common key for the chemical survey (for the school of origin) using the passphrase of the school of origin, and the Web server decrypts each survey data using the decrypted common key for the survey, and in the database server 7. Of the application data that matches the temporary registration data reading function that reads the survey report temporary registration data associated with the registration number from the database of the examination school, and (g) the home school identifier that matches the home school identifier associated with the login ID. Application data detection function that detects the presence or absence of application data in which the date of birth information and the pseudonym information of the name match from the database of the examination school in the database server 7. (H) For the search report data for which the application data was not detected by the application data detection function, the search report provisional registration data associated with the registration number, including the fact that the application has not been registered, is the school of origin. Matching result display function to be displayed on terminal 2, (k) payment status update function to receive examination fee payment information for each application data and add examination fee payment information to application data, and (co) matching result display The search report data whose content has been selected to be finalized by the function is encrypted, and the application identifier included in the application data is added and stored as finalized search report data in the database of the examination school in association with the search report provisional registration data. Confirmed survey report storage function to be performed, and (sa) Confirmed survey report data and confirmed survey report data stored in the test school database in the database server 7 after receiving the confirmed survey report data request from the test school terminal 3. This is a program for realizing a search report output function in which each search report data decodes, displays, and downloads the application data associated with the data.

{Processing process}
The matching method of this embodiment is as follows: (A) One or more Web servers 6 connected to the applicant terminal 1 and the home school terminal 2 via the network 4 and the Web server 6 in the Internet application for the entrance examination or the test. It has one or a plurality of database servers 7 interconnected to each other, and a server group 5 having a function of a plurality of types of servers including (B) application data input from the applicant terminal 1 and from the home school terminal 2. This is a matching method that matches the input survey report data. In the matching method of this embodiment, the (Step 10) Web server 6 displays the upload acceptance screen of the survey report data for submission including one or more survey report data for one or more applicants for each school of origin. Survey report data for submission (survey report data 1st encrypted file) that is displayed on the home school terminal 2 received by the login ID and encrypted using a key different from the common key for the survey report from the home school terminal 2. ) Submission survey data reception process that accepts uploads, and (Step 20) Web server 6 decodes the submission survey data, and the submission survey data includes date of birth information, name signature information, and internal report. The temporary registration acceptance process, which detects whether there are any data omissions or mistakes and accepts the temporary registration of the survey report data for submission when there are no omissions or mistakes, and the (Step 30) Web server provide the common key for the survey report. , From the encrypted common key for survey report (common key for encrypted survey report (for school)), decrypted using the passphrase of the school of origin, and use the decrypted common key for survey report to obtain each survey report data. Is encrypted, and the original school identifier associated with the login ID and the same registration number for each submitted survey data that has received provisional registration are encrypted in each survey data (survey data second encrypted file). The registration number issuance process, which is added to the database of the test school in the database server 7 as the temporary registration data of the survey report and the registration number is displayed on the home school terminal 2, and the (Step 40) Web server 6 are the applicant terminal 1. From, the application acceptance process including the date of birth information to be submitted to the examination school, the pseudonym information of the name, and the application data including the name of the school of origin, and the application data to be added to the database of the examination school in the database server 7 and (Step50) Web The survey report confirmation acceptance process in which the server 6 receives the registration number input and the home school passphrase from the home school terminal 2 received by the login ID for each home school, and the (Step60) Web server is for the survey report. The common key is decrypted from the encrypted common key for the survey report (the common key for the encrypted survey report (for the school of origin)) using the passphrase for the school of origin, and the decrypted common key for the survey report is used. A temporary registration data reading process in which each survey report data is decrypted and the web server 6 reads the survey report temporary registration data associated with the registration number from the database of the examination school in the database server 7, and the (Step 70) web server. 6 is application data in which the origin school identifier associated with the login ID matches the origin school identifier of the survey report provisional registration data. Among them, the application data detection step of detecting the presence or absence of application data in which the date of birth information and the name signature information match from the database of the examination school in the database server 7, and the application data detection step of (Step80) Web server 6. For the search report data for which the application data was not detected in, the matching result display step of displaying the search report provisional registration data associated with the registration number on the home school terminal 2 including the fact that the application has not been registered. And includes. Further, the Web server is connected to the examination school terminal 3 via a network, and after the finalized survey report storage process, the (Step100) Web server takes the finalized survey data request from the examination school terminal 3. Each search report data decodes and displays the finalized search report data and the application data associated with the finalized search report data stored in the database of the examination school in the database server 7 together with the school passphrase. Includes the survey report output process to be downloaded. Other steps are the same as in Example 1 described above except that encryption and decryption are performed.

In this embodiment, the matching program causes a computer to perform the following steps. In the flow shown in FIG. 4, the portion shown in parentheses is also performed in this embodiment.

The processing process of the matching method of this embodiment will be described in more detail. The Web server 6 is controlled by the front unit to execute each of the following steps.

In the second embodiment, the database server encrypts and stores the common key for the survey report that encrypts and decrypts the survey report data. Further, in the submission survey report data reception process, the submission survey report data for which the Web server accepts uploads is encrypted using a key different from the survey report common key. Further, in the temporary registration acceptance process, the Web server decodes the survey report data for submission. Further, in the registration number issuing process, the Web server decrypts the survey report common key from the encrypted survey report common key, and the Web server uses the decrypted survey report common key to obtain each survey report data. To encrypt. Further, in the temporary registration data reading process, the Web server decrypts the encrypted common key for the survey report, and the Web server decrypts the survey report data using the decrypted common key for the survey report.

(Step1)
In this embodiment, the home school screen information distributed to the home school is the URL, ID, and password of the home school screen or the application portal site common to the region, and the home school passphrase. The Web server 6 accepts login with an ID and password from the home school terminal 2 that has accessed the home school screen based on the home school screen information distributed to the home school. The identifier of the school of origin specified by the ID logged in to the screen of the school of origin is stored in the database 71 of the examination school in the database server 7. The logged-in account information, that is, the login ID is stored in association with the school identifier. The school of origin screen may be a screen of the school of origin for each examination school in which an examination school is selected from an application portal site that can be used by a plurality of schools of origin and a plurality of examination schools (for example, common to all regions). Further, the home school screen may accept logins from a plurality of home schools with an ID and a password, and display each home school when the login is successful. In this embodiment, the passphrase of the school of origin is the passphrase of each school of origin, but it is preferable that the passphrase is also different for each school of examination.

In this embodiment, a common key for survey documents, which is a common key for encrypting and decrypting one or more survey report data included in the survey report data for submission, is generated in advance, and encrypted for each school of origin. It is stored in the database server as the common key for the survey report (common key for the encrypted survey report). The common key for the survey report may be common to all or a plurality of schools of origin, but is preferably for each school of origin. The same common key for the survey form is encrypted using the passphrase of the school of origin. The common key for the survey form (for the school of origin) and the common key for the encrypted survey form encrypted using the passphrase of the test school. A key (for the test school), a common key for the encryption survey form encrypted using the system administrator passphrase (for the system administrator), and three types of encryption information are generated. That is, the encrypted common key for the survey report includes the common key for the encrypted survey report (for the school of origin) encrypted using the passphrase of the school of origin and the encrypted survey encrypted using the passphrase of the school to be examined. Includes a common key for writing (for the test school) and a common key for encrypted survey documents (for the system administrator) encrypted using the system administrator passphrase.

FIG. 11 is a diagram showing an example of the home school table in the second embodiment of the matching method of the present invention. In the example of FIG. 11, the common key "iroha" for the survey report of the school name Iroha Junior High School (id1) uses the school passphrase "48924" described in the screen information of the school of origin distributed to Iroha Junior High School. The common key for the survey report encrypted by the common key method (common key for the encrypted survey report (for the school of origin)) "GRH (hereinafter omitted)" is linked to the database server and Iroha Junior High School (id1). It is attached and remembered. Similarly, in the case of Nihohe Junior High School (id2), the common key for the survey report "nihoe" is encrypted by the common key method using the passphrase "13902" of the school of origin, and the encrypted common key for the survey report (encryption). The common key for the Cryptographic Survey (for the school of origin) "9ga (abbreviated below)" is stored in association with Nihohe Junior High School (id2). Therefore, even if there is an unauthorized attack on the system, the common key for the survey report is not stored in the database, so the risk of leaking the survey report data can be suppressed and the security is strong.

FIG. 12 is a diagram showing an example of an administrator table and a common key management table in the second embodiment of the matching method of the present invention. In the example of FIG. 12, the common key "iroha" for the survey report of the school name Iroha Junior High School (id1) is encrypted by the common key method using the system administrator passphrase "sassoh", and the encrypted survey report is encrypted. Common key for encryption (common key for encryption survey (for system administrator)) "Jkn (omitted below)" is linked to the database server with the ID of Iroha Junior High School (1) and the ID of the system administrator (10). Is remembered. Similarly, in the case of Nihohe Junior High School (id2), the common key for the survey report "nihoe" is encrypted by the common key method using the system administrator passphrase described above, and the encrypted common key for the survey report (encryption). The common key for the encryption survey (for system administrator) "98F (hereinafter omitted)" is stored in association with the ID (2) of Nihohe Junior High School and the ID (10) of the system administrator. Furthermore, the common key "iroha" for the survey report of the school name Iroha Junior High School (id1) is encrypted by the common key method using the passphrase "juken" of the examination school, and the encrypted common key for the survey report (encryption). The common key for the Cryptographic Survey (for the examination school) "uoI (omitted below)" is stored in the database server in association with the ID (1) of the Iroha junior high school and the ID (11) of the examination school. In the case of Nihohe Junior High School (id2), the common key for the survey report "nihoe" is encrypted by the common key method using the above-mentioned examination school passphrase, and the encrypted common key for the survey report (for the encrypted survey report). The common key (for the examination school) "OLA (hereinafter omitted)" is stored in association with the ID (2) of the Nihohe Junior High School and the ID (11) of the examination school. Therefore, not only the school from which the student was born, but also the person involved in the server operation and the school taking the examination cannot directly know the common key for the survey report, and if the passphrase is not known, the common key for the survey report can be decrypted. Therefore, the risk of leaking survey report data can be suppressed, and security is strong. In addition, "iroha", "nihohe" and the like described here are shown in a simplified manner for illustration purposes, and are actually randomly generated character strings.

Since the Web server 6 randomly generates the common key for the survey form and the passphrase (for the school of origin, for the examination school, and for the system administrator) for each school of origin, it cannot be easily decrypted and is highly secure. ..

In the following, Iroha Junior High School will be explained as an example of the school from which he was born.

(Step2)
The Web server 6 accepts download of a predetermined spreadsheet file format including a macro created by spreadsheet software from the spreadsheet terminal 2 logged in to the spreadsheet screen. In such a spreadsheet file format, the public key C1 is embedded in a macro. The public key C1 and the corresponding private key H1 are stored in the database server. As shown in FIG. 6, the Web server 6 accepts downloads on the home school screen as in the first embodiment. As in Example 1, the teacher at the school of origin inputs the data into the above-mentioned table calculation file, and as shown in FIG. 7, the macro starts by clicking the file export switch for submission, and the survey report data for submission is temporarily displayed. The submission survey data created on the memory is encrypted by the public key method using the public key C1 embedded in the macro in the downloaded table calculation file, and the encrypted submission survey is encrypted. Document data (investigation report data first encrypted file) is automatically created on the desktop. Survey report data The first encrypted file is encrypted information. The user who operates the terminal of the school from which he / she is from is created encrypted submission survey data (survey data first encrypted file) without being aware of the existence of the public key. The encrypted submission survey data may be data expressed in a tabular format such as CSV, Excel (registered trademark), tab delimited, or XML, JSON data, and the type of data is not limited. According to this embodiment, since the unencrypted file is not saved in the terminal of the school from which the student was born, the risk of leaking the contents of the survey report to the outside can be suppressed. In this example, since the survey report data for submission is encrypted by the public key method, the risk of being decrypted by other than the matching system of this example having a private key is suppressed, and a password is set at the time of creation. It is very convenient without the hassle of doing it and without being aware of encryption. The encryption method is preferably the public key method, but the common key method may also be used. In the case of the common key method, the common key automatically generated by the matching system of the present invention may be encrypted by the common key method. If high security is not required, the survey report data 1st encrypted file (encrypted submission survey report data) created in Step 2 and accepted in Step 10 is not encrypted with the public key, but the terminal of the school of origin. The submission password set by the operating user may be encrypted by the common key method.

(Step 10) Submission Survey Report Data Acceptance Process As shown in FIG. 8, the Web server 6 accepts the upload of the submission survey report data as in the first embodiment. The information used for matching is the same as in the first embodiment.

As shown in the upper left of FIG. 8, the Web server 6 displays the upload acceptance screen of the survey report data for submission, which includes one or more survey report data for one or more applicants, by the login ID for each school of origin. It is displayed on the received home school terminal 2, and the uploaded survey report data for submission (survey report data first encrypted file) is accepted from the home school terminal 2. In this embodiment, the input of the passphrase of the school of origin is also accepted. If the survey report data 1st encrypted file is encrypted by the common key method with the submission password set by the user who operates the home school terminal, the submission password is also accepted. On the upload reception screen, as shown in the upper right of FIG. 8, the name of the teacher of the school of origin is entered. You may enter your school passphrase on the screen shown in the upper right of FIG.

(Step 20) Temporary registration acceptance process The Web server 6 stores the survey report data for submission from the survey report data first encrypted file (encrypted survey report data for submission) in the database server corresponding to the public key C1. Decryption is performed by the public key method using the private key H1. If the survey report data first encrypted file is encrypted using the submission password, it is decrypted by the common key method using the submission password entered from the terminal of the school of origin. When encrypted using the common key generated by the matching system of the present invention, the common key stored in the database is used for decryption by the common key method. If it cannot be decrypted, an error will occur and the first encrypted file of survey data will not be accepted.

As in Example 1, the decrypted survey report data for submission accepts provisional registration of the survey report data for submission when there are no omissions or mistakes in the date of birth information, furigana information of the name, and internal report data. .. As shown in the lower left of FIG. 8, on the screen of the school from which the student was born, the entered contents are displayed as a table, an error is displayed, and a temporary registration button is displayed if the predetermined requirements are satisfied. Registration is possible. Temporary registration can be redone as many times as you like.

(Step30) Registration number issuance process The Web server encrypts the common key for the survey report (for the school of origin) and the common key for the survey report (common key for the encrypted survey report (for the school of origin)) (in the case of Iroha Junior High School) Is decrypted from "GRH (hereinafter omitted)") by the common key method using the school passphrase input from the school terminal. If decryption is not possible, an error will occur and the registration number will not be issued and temporary registration will not be completed. The decrypted common key for the survey report (“iroha” in the case of Iroha Junior High School) is used for encryption and decryption of the survey report data.

The database server 7 associates the home school identifier associated with the login ID and the same registration number information for each submitted survey report data that has received provisional registration with each survey report data as survey report temporary registration data. Add it to the temporary registration table of the survey report in the database of the test school, and display the registration number on the home school terminal 2 as shown in the lower right of FIG. Therefore, in this embodiment, provisional registration can be accepted even if the corresponding application data is not in the database server 7.

The survey report provisional registration data is the same as in Example 1, such as registration number, date of birth, furigana of name, kanji of name, and internal report data. Each survey report data included in the survey report provisional registration data is encrypted by the common key method using the survey report common key (“iroha” in the case of Iroha junior high school) decrypted for each survey report by the Web server. Not only the survey report data as it is, but also the encrypted survey report data (survey report data second encrypted file) will be included in the survey report temporary registration data. Survey report data The second encrypted file is encrypted information.

FIG. 13 is a diagram showing an example of a search report provisional registration table in Example 2 of the matching method of the present invention. In the example of FIG. 13, the survey report data of the students of Iroha Junior High School is encrypted by the common key method using the common key "iroha" for the survey report. The encrypted survey report data (in the case of Mr. Takashi Ito, "Arp (hereinafter omitted)") is stored in the database as the survey report temporary registration data together with the date of birth and the like as described above. Different schools have different common keys for survey reports.

The home school terminal 2 may log out after the registration number issuance process and log in again in the survey report confirmation reception process (Step 50) described later. You may be asked to enter your school passphrase when you log in again. If the home school terminal has a cookie and the matching system has session data and the home school passphrase can be referred to, the entry of the home school passphrase can be omitted.

Steps 40, 41, and 43 of Example 2 are the same as those of Example 1 except that the survey report data is encrypted and stored in the database.

(Step50) Search report confirmation acceptance process When logging out in the registration number issuance process (Step30) and logging in again from the home school screen or the application portal site common to the region, login by ID is as shown in Fig. 9. The procedure is the same as that of the first embodiment except that the input of the passphrase of the school of origin is also accepted from the entry of the registration number to the reception of the input of the registration number. However, as described above, the input of the passphrase of the school of origin can be omitted in the predetermined case. In addition, if the survey report data is not displayed on the terminal of the school of origin and only the matching result is displayed, the input of the passphrase of the school of origin can be omitted.

(Step 60) Temporary registration data reading process The Web server 6 reads the survey report temporary registration data associated with the registration number from the database of the examination school in the database server 7. The Web server 6 has entered the common key for the survey form (for the school of origin) in the survey form confirmation reception process (if the input in the survey form confirmation reception process can be omitted, the survey form data reception process for submission). Using the passphrase of the school of origin, the common key for the encryption survey (for the school of origin) (“GRH (hereinafter omitted)” in the example of FIG. 11) is decrypted by the common key method. The Web server uses the decrypted common key for the survey report (“iroha” in the example of FIG. 11) to read each survey report data, and the encrypted survey of each student included in the survey report temporary registration data read. Decrypt from the document data (investigation report data second encrypted file). If the school passphrase is not entered, such decryption will not be performed.

Steps 70, 80, 90 of Example 2 are the same as those of Example 1. The survey report data is encrypted by the common key method using the survey report common key, and is stored in the database as encrypted survey report data (survey report data second encrypted file). The decrypted survey report data is displayed on the school terminal. For the finalized survey report data, as with the survey report temporary registration data, each student uses the survey report common key decrypted from the encrypted survey report common key using the home school passphrase using the common key method. The survey report data is encrypted by the common key method and included as the encrypted survey report data (survey report data second encrypted file). When displaying only the matching result, the survey report data is encrypted using the survey report common key decrypted by the common key method from the encrypted survey report common key using the passphrase of the school of origin. Since it is not necessary to obtain the survey report data by decrypting the data (survey report data second encrypted file) using the common key method, it is not necessary to enter the passphrase of the school of origin in the survey report confirmation reception process.

(Step 100) Search Report Output Process A case where it is desired to output a search report for an application from Iroha Junior High School to the examination school terminal 3 will be described. The Web server 6 accepts the finalized survey data request from the examination school terminal 3 together with the examination school passphrase (“juken” in the example of FIG. 12). The Web server 6 encrypts the common key for the survey report (in the example of FIG. 12, "iroha" for Iroha junior high school and "nihohe" for Nihohe junior high school) using the entered examination school passphrase. Decrypted by the common key method from the common key for the survey (for the examination school) (in the example of Fig. 12, "uoI (omitted below)" for Iroha junior high school and "OLA (omitted below)" for Nihohe junior high school) do. Confirmation that the Web server has read each survey report data using the decrypted common key for the survey report (in the example of FIG. 12, "iroha" for Iroha junior high school and "nihohe" for Nihohe junior high school). Decrypt from the encrypted survey report data (survey report data second encrypted file) of each student included in the completed survey report data. The school of origin to be output may be selected, and only the common key for the encryption survey document associated with the corresponding school of origin ID may be decrypted.

The finalized search report data stored in the database 71 of the examination school and the application data associated with the finalized search report data are displayed and downloaded in the database server 7. Each survey report data is decrypted using the decrypted common key for the survey report. The survey report data included in the finalized survey report data is decrypted, displayed and downloaded. In the search report output process, the screen displayed on the examination school terminal 3 is the application & search report management screen, and on the application & search report management screen, the finalized search report data and the application data associated with the finalized search report data are displayed. The search report data can be decoded, arranged in a single line for each application data, and displayed in a table format for printing. Also, the finalized search report data and the finalized search report data can be printed on one sheet for each application data. The application data associated with the search report data can be decoded, displayed, and printed. Each survey report data is encrypted and included in the finalized survey report data in the database 71 of the examination school. In the survey report output process, the finalized survey report data displayed in response to the finalized survey report data request includes the decrypted survey report data of each student.

The application data is the finalized search report data including each encrypted survey report data (in the example of FIG. 13, "Arp (hereinafter omitted)" in the case of Mr. Ito Takashi) in the database 71 of the examination school in the database server 7. It is associated with and remembered. In the search report output process, the Web server decodes the finalized search report data and the application data associated with the finalized search report data, displays and downloads each search report data.

{effect}
According to the present embodiment, in addition to the above-mentioned effects of the first embodiment of the present invention, information leakage can be further prevented and security can be enhanced. Since the survey report data for submission, including the highly confidential survey report data, is uploaded in an encrypted state, encrypted by the common key for the survey report, and stored in the database, it is a system environment even in the information environment of the school from which you were born. In this case as well, after the survey report data for submission is created, it is possible to prevent information leakage of the survey report at all times, both when uploading and when storing it on the server, and it is possible to enhance security.

According to this embodiment, since the survey report data for submission is encrypted at the same time as it is created, the risk of information leakage from the information environment in the school of origin such as the terminal of the school of origin can be suppressed, and the risk of information leakage during uploading and in the system can be suppressed. It is very convenient because it prevents information leakage in the processing process and can be encrypted without the operator of the terminal at the school from which he was born. Further, according to this embodiment, the key for encrypting and decrypting the survey report data for submission and the key for encrypting and decrypting the survey report data of each student are different, and the survey report data of each student is encrypted. The key to be encrypted and decrypted is encrypted, and the passphrase used to encrypt and decrypt the key to encrypt and decrypt the survey report data of each student is different for each school of origin and each school of examination. Is highly safe. Even those involved in server operation cannot decrypt the common key for survey documents without using the system administrator passphrase. The common key for the survey report may be the same for multiple schools.

When confirming the contents of the survey report data, the survey report data can be decrypted and displayed, and matching can be performed with the survey report data encrypted, so that both convenience and security can be achieved.

Since the common key for decrypting the survey report data is decrypted using different passphrases at the school of origin and the school taking the examination, it is superior in terms of security.

The present invention is not limited to the above-described embodiment, and various modifications can be made without departing from the spirit of the invention. In addition, the components of each of the above embodiments can be arbitrarily combined without departing from the spirit of the invention.

1 Applicant terminal 2 Home school terminal 3 Examination school terminal 4 Network 5 Server group 6 Web server 61 Web server A
62 Web server B
7 Database server 71 Database of the school

Claims (6)

In application via the Internet
One or more Web servers connected to the applicant terminal and the terminal of the school of origin via a network,
With one or more database servers interconnected to the Web server,
A group of servers that have the functions of multiple types of servers, including
It is a matching method that matches the application data input from the applicant terminal with the search report data input from the home school terminal.
The Web server displays the upload acceptance screen of the submission survey data including one or more survey data for one or more applicants on the home school terminal received by the login ID for each school. The submission survey data reception process for displaying and accepting the upload of the submission survey data from the home school terminal,
The Web server detects whether there is any omission or mistake in the date of birth information, the pseudonym information of the name, and the internal statement data in the submitted survey data, and if there is no omission or mistake, the submitted survey data. Temporary registration acceptance process and temporary registration acceptance process
The Web server associates the home school identifier associated with the login ID and the same registration number for each of the submitted survey data for which provisional registration has been received with each survey data as survey report temporary registration data. A registration number issuance process that adds the registration number to the database of the school to be examined in the database server and displays the registration number on the terminal of the school of origin.
The Web server receives application data including date of birth information, name signature information, and school identifier to be submitted to the examination school from the applicant terminal, and adds the application data to the database of the examination school in the database server. Application acceptance process and
The survey report confirmation acceptance process in which the Web server accepts the input of the registration number from the origin school terminal accepted by the login ID for each school of origin.
The process of reading the temporary registration data, in which the Web server reads the temporary registration data of the survey report associated with the registration number from the database of the examination school in the database server.
Among the application data whose home school identifier matches the home school identifier associated with the login ID, the Web server checks in the database server whether or not there is application data in which the date of birth information and the pseudonym information of the name match. Application data detection process to be detected from the database of
For the search report data for which the application data was not detected by the Web server in the application data detection step, the search report provisional registration data associated with the registration number is used, including that the application has not been registered. The matching result display process to be displayed on the home school terminal and
Matching method characterized by including In the process of receiving survey report data for submission,
The survey report data for submission shall be encrypted using a public key or a common key.
In the temporary registration acceptance process
The matching method according to claim 1, wherein the Web server decrypts the submitted survey report data using a private key or a common key corresponding to the public key. The Web server is further connected to the examination school terminal via a network.
The Web server accepts the finalized survey data request from the examination school terminal,
The matching method according to claim 1, wherein the Web server includes a survey report output step of displaying and downloading the survey report data stored in the database of the examination school in the database server. In the database server, the common key for the survey report that encrypts and decrypts the survey report data is encrypted using the passphrase for the school of origin and stored as the common key for the encrypted survey report (for the school of origin).
In addition, the common key for the survey form is encrypted using the passphrase for the examination school and stored as the common key for the encrypted survey form (for the examination school).
In the process of receiving survey report data for submission,
The WEB server accepts the passphrase for the school from which the student was born.
In the registration number issuing process
The Web server decrypts the common key for the survey report from the common key for the encrypted survey (for the school of origin) using the passphrase for the school of origin, and uses the decrypted common key for the survey report. Each survey report data is encrypted, and the school identifier and the registration number are associated with the encrypted survey report data to be temporary survey report registration data.
In the temporary registration data reading process,
The Web server decrypts the common key for the survey report from the encrypted common key for the survey report (for the school of origin) using the passphrase for the school of origin, and uses the decrypted common key for the survey report. , Decrypting each survey report data,
In the survey report output process
The Web server accepts the passphrase for the examination school from the examination school terminal,
The Web server decrypts the common key for the survey report from the common key for the encrypted survey (for the test school) using the passphrase for the test school, and decrypts each survey report data. The matching method according to claim 3, wherein the data is decrypted using a common writing key, displayed, and downloaded. In application via the Internet
One or more Web servers connected to the applicant terminal and the terminal of the school of origin via a network,
With one or more database servers interconnected to the Web server,
It has a group of servers that have the functions of multiple types of servers, including
It is a matching system that matches the application data input from the applicant terminal with the search report data input from the home school terminal.
The Web server
The upload acceptance screen of the submission survey data including one or more survey data for one or more applicants is displayed on the home school terminal received by the login ID for each home school, and the home school terminal is displayed. The means for receiving the submitted survey data from the school terminal, which accepts the upload of the submitted survey data, and the means for receiving the submitted survey data.
Detects whether there are any omissions or mistakes in the date of birth information, furigana information of name, and internal report data in the survey form data for submission, and if there are no omissions or mistakes, accepts provisional registration of the survey form data for submission. Temporary registration reception means and
The home school identifier associated with the login ID and the same registration number for each of the submitted survey data for which provisional registration has been accepted are associated with each survey data and taken as survey report temporary registration data in the database server. A registration number issuing means that is added to the school database and the registration number is displayed on the terminal of the school from which the student was born.
From the applicant terminal, the application data including the date of birth information, the pseudonym information of the name, and the identifier of the school of origin to be submitted to the examination school is received, and the application acceptance means to be added to the database of the examination school in the database server, and the application acceptance means.
A survey form confirmation reception means that accepts the input of the registration number from the above-mentioned home school terminal received by the login ID for each home school,
Temporary registration data reading means for reading the survey report temporary registration data associated with the registration number from the database of the examination school in the database server.
Among the application data whose home school identifier matches the home school identifier associated with the login ID, the presence or absence of application data in which the date of birth information and the pseudonym information of the name match is detected from the database of the examination school in the database server. Application data detection means and
For the search report data for which the application data was not detected by the application data detection means, the search report provisional registration data associated with the registration number is sent to the terminal of the school of origin, including the fact that the application has not been registered. Matching result display means to be displayed and
A matching system characterized by having. The Web server is connected to the payment company's system and the examination school terminal.
The database server encrypts and stores a common key for the survey report that encrypts and decrypts the survey report data.
The submitted survey report data for which the Web server accepts uploads is encrypted using a key different from the survey report common key.
The temporary registration reception means
Decrypting the submitted survey data from the encrypted submitted survey data,
The registration number issuing means
The common key for the survey report is decrypted from the encrypted common key for the survey report.
Encrypt each survey report data using the decrypted common key for the survey report.
The temporary registration data reading means
Decrypting the survey report common key, and using the decrypted survey report common key, the Web server decrypts each survey report data.
as well as,
The Web server
A means for updating the payment status, which receives the examination fee payment information for each application data and adds the examination fee payment information to the application data.
The search report data whose content has been selected to be finalized by the matching result display means is encrypted, the application identifier included in the application data is added, and the search report is stored in the database of the examination school in the database as the finalized search report data. Confirmed survey report storage means to store in association with temporary registration data,
Each search receives the finalized search report data request from the test school terminal, and searches the finalized search report data stored in the test school database in the database server and the application data associated with the finalized search report data. A survey report output means that decrypts, displays, and downloads the document data,
5. The matching system according to claim 5.

Images