JP2013089152A - Information system, server device and program - Google Patents

Abstract

PROBLEM TO BE SOLVED: To ensure consistency of information in each server device so as to fit network environments in which a plurality of servers exist.SOLUTION: A server device comprises: a second instruction reception part 132 which receives an update instruction including an information identifier and information from a terminal device; a second update part 134 which updates information corresponding to the information identifier included in the update instruction to the information included in the update instruction; a second update information transmission part 135 which transmits update information including the information identifier and the information included in the update instruction to a first server device; an information acquisition part 133 which acquires the information and the information identifier included in the update instruction from the first server device; and a second processing part 136 which performs second processing using stored information. The second update part updates information corresponding to one or more of each information identifier acquired by the information acquisition part to one or more of each information acquired by the information acquisition part. By this way, consistency of the information is ensured even when network environments in which a plurality of server devices exist are different from each other.

Description

  The present invention relates to an information system or the like that ensures consistency of information in a plurality of server devices.

  Conventionally, when registration processing servers that accept registration requests for content information in the database are distributed on the network, database content information version management can be performed while maintaining consistency of the database in a relatively loose operation. There has been a database management system that can be appropriately and efficiently performed (see Patent Document 1).

  This system accepts a registration request for content information from a database server that manages a database in which content information including content and the version of the content is registered, and a client terminal device connected via a network, and connects to the database server via a network A database management system having a plurality of registration processing servers that request registration of content information received from the database server to the database, wherein each of the plurality of registration processing servers includes content information registered in the database server Content having the latest version is received from the database server, and information for editing the content information already registered in the database is generated using this content and transmitted to the client terminal device The checkout means and edit information indicating edit contents for the registered content information are received from the client terminal device, and the registered content information is edited based on the received edit information to generate content information to be registered. Editing means, time information giving means for giving time information indicating the current time to the content information to be registered edited by the editing means, and content information to be registered to which time information is given by the time information giving means A transfer means for transmitting to the database, a storage means for storing a database in which the content information is registered, a receiving means for receiving the content information to be registered to which time information is given from each of the plurality of registration processing servers, Among the content information already registered in the database, If there is registered content information whose search key is the same as the registration target content information received by the means and whose version is newer than the registration target content information, the version of the registration target content information and the registered content information exist. A database management system comprising: version update means for updating the version of information based on time information; and registration means for registering content information to be registered whose version has been updated by the version update means in a database.

Japanese Patent Laying-Open No. 2005-216167 (first page, FIG. 1 etc.)

  However, in the conventional information system, when it is necessary to guarantee the consistency of information managed by a plurality of server devices, each network device has a different network environment in which each server device exists. The consistency of information could not be guaranteed to suit the environment.

  In particular, in an environment where the first server device can be accessed from the second server device, but the second server device cannot be accessed from the first server device, the first server device and the second server are adapted to the environment. The consistency of information managed by the device could not be guaranteed.

  The information system of the first invention is an information system comprising a first server device and a second server device, wherein the first server device has one or more records having information and an information identifier for identifying information A first record storage unit that can store the information identifier, a first command receiving unit that receives an information update instruction including information to be updated from one or more terminal devices, and an information identifier and information to be updated The first information receiving unit that receives the update information from the second server device, and the information that corresponds to the information identifier included in the update command and that is stored in the first record storage unit is used as the information included in the update command. A first update unit that updates the information that corresponds to the information identifier included in the update information and that is stored in the first record storage unit to the information included in the update information; A first processing unit that performs a first process using information stored in the storage unit, and the second server device stores one or more records having information and an information identifier for identifying the information. A second record storage unit to be obtained, a second command receiving unit for receiving an information identifier and an update instruction for information including information to be updated from one or more terminal devices, and information corresponding to the information identifier included in the update command And update information having a second update unit that updates information stored in the second record storage unit to information included in the update command, an information identifier included in the update command, and information included in the update command 2nd update information transmission part which transmits to the 1st server apparatus, and information acquisition which performs processing which accesses the 1st server apparatus and acquires the information and information identifier which are contained in the update command which the 1st command receiving part received Part and second A second processing unit that performs a second process using information stored in the code storage unit, and the second update unit is information corresponding to each of one or more information identifiers acquired by the information acquisition unit. Yes, the information system updates the information stored in the second record storage unit to one or more pieces of information acquired by the information acquisition unit.

  With this configuration, it is possible to guarantee the consistency of information managed by a plurality of server devices even when the network environments in which the plurality of server devices exist are different.

  Further, in the information system of the second invention, the second update information transmission unit inspects whether or not the information stored in the second record storage unit is updated with respect to the first invention. Is an information system that transmits one or more pieces of update information having updated information and an information identifier for identifying the information to the first server device.

  With this configuration, it is possible to guarantee the consistency of information managed by a plurality of server devices even when the network environments in which the plurality of server devices exist are different.

  Further, in the information system of the third invention, the second update information transmission unit is information corresponding to the information identifier included in the update command, and is stored in the second record storage unit. The information system transmits the update information to the first server device each time the second update unit updates the information included in the update command.

  With this configuration, it is possible to guarantee the consistency of information managed by a plurality of server devices even when the network environments in which the plurality of server devices exist are different.

  Further, in the information system of the fourth invention, the information acquisition unit periodically accesses the first server device and receives information received by the first command receiving unit with respect to any one of the first to third inventions. And an information identifier.

  With this configuration, it is possible to guarantee the consistency of information managed by a plurality of server devices even when the network environments in which the plurality of server devices exist are different.

  Further, the information system of the fifth invention is an information system in which the information acquisition unit acquires only the information updated after the last access and the information identifier for identifying the information, as compared with the third invention. .

  With this configuration, it is possible to reduce the amount of data communication when ensuring consistency of the same information among a plurality of server devices.

  Further, in the information system of the sixth invention, the first server device is a server device on the public network, and the second server device is on the private network. It is an information system that is a server device.

  In addition, the information system of the seventh aspect of the invention relates to any one of the first to sixth aspects of the invention, information stored in the first record storage unit and information stored in the second record storage unit are An information system that is a password.

  The information system of the eighth invention is an information system in which the first process and the second process are the same process with respect to any one of the first to seventh inventions.

  With this configuration, the same operation can be reliably performed by a plurality of server devices.

  According to the information system of the present invention, it is possible to guarantee the consistency of information managed by a plurality of server devices even when the network environments in which the plurality of server devices exist are different.

Conceptual diagram of information system 1 according to Embodiment 1 Block diagram of the information system Flow chart for explaining the operation of the first server device Flow chart for explaining the operation of the second server device The figure which shows the example of the input screen of the attendance management system Diagram showing an example of the structure of attendance information for the same employee The figure which shows the example of the output screen of the same pay statement inquiry system Figure showing the same user management table Figure showing the same password update management table Diagram showing an example of the update information Figure showing the same user information management table Overview of the computer system Block diagram of the computer system

  Hereinafter, embodiments of an information system and the like will be described with reference to the drawings. In addition, since the component which attached | subjected the same code | symbol in embodiment performs the same operation | movement, description may be abbreviate | omitted again.

(Embodiment 1)
In the present embodiment, an information system that can guarantee consistency of information managed by two server devices (first server device and second server device) will be described.

  In the present embodiment, the first server device can be accessed from the second server device, but the first server device cannot be accessed from the first server device. An information system that can guarantee consistency of information managed by the server device and the second server device will be described. That is, in this embodiment, when there is a change in the information of the second server device, the first server device is notified. Also, the second server device inspects whether there is a change in information in the first server device, and if there is a change, obtains the changed information and reflects it in the information of the second server device. To do.

  FIG. 1 is a conceptual diagram of an information system 1 in the present embodiment. The information system 1 includes one or more terminal devices 11, a first server device 12, and a second server device 13. Two or more first server devices 12 and second server devices 13 may exist.

  Moreover, the terminal device 11 is a terminal normally used by the user, and is a so-called personal computer, portable terminal, or the like. Further, the terminal device 11 may have a function of reading a medium holding personal identification information (a kind of information identifier described later) such as an IC card. The IC card or the like is, for example, Suika (registered trademark), ICOCA (registered trademark), a basic resident register card, an employee ID card, or the like.

  Further, the networks in which the first server device 12 and the second server device 13 exist are usually different. The first server device 12 is, for example, a server that exists in a so-called public network (may be referred to as a cloud). The second server device 13 is, for example, a server that exists in a so-called private network (may be called on-premises).

  FIG. 2 is a block diagram of the information system 1 in the present embodiment.

  The terminal device 11 includes a reception unit 111, a transmission unit 112, a reception unit 113, and an output unit 114.

  The first server device 12 includes a first record storage unit 121, a first command reception unit 122, a first information reception unit 123, a first update unit 124, and a first processing unit 125.

  The second server device 13 includes a second record storage unit 131, a second command reception unit 132, an information acquisition unit 133, a second update unit 134, a second update information transmission unit 135, and a second processing unit 136.

  The receiving unit 111 configuring the terminal device 11 receives information and instructions. The accepting unit 111 usually accepts information and instructions that are user inputs. The instruction is, for example, an update instruction. The update command is a command for instructing update of information, and includes, for example, information to be updated and an information identifier for identifying the information. The information and command input means may be anything such as a keyboard, mouse, or menu screen. The accepting unit 111 can be realized by a device driver for input means such as a keyboard, control software for a menu screen, or the like. The receiving unit 111 may be an IC card reader or the like that realizes a reading function such as an IC card. When the reception unit 111 has a function of reading a medium such as an IC card, the reception unit 111 acquires an information identifier from the medium (IC card, IR tag, etc.) and obtains other information (for example, information to be updated). You may acquire by the input using a keyboard etc. by a user.

  The transmission unit 112 transmits information and instructions received by the reception unit 111 to an external device. Here, the external device is, for example, the first server device 12 or the second server device 13. The destination to which the transmission unit 112 transmits information or the like may be specified by the user, or may be determined in advance based on the input information or the like.

  The receiving unit 113 receives information from an external device. The external device is, for example, the first server device 12 or the second server device 13.

  The output unit 114 outputs information received by the receiving unit 113. Here, output refers to display on a display, projection using a projector, printing on a printer, sound output, transmission to an external device, storage in a recording medium, output to another processing device or other program, etc. It is a concept that includes delivery of processing results. The output unit 114 may or may not include an output device such as a display or a speaker. The output unit 114 may be implemented by output device driver software, or output device driver software and an output device.

  The first record storage unit 121 constituting the first server device 12 can store one or more records. The record has information and an information identifier for identifying the information. The structure of the record does not matter. The record may be an RDB record, but is not necessarily an RDB record. A record is one or more pieces of information and is widely understood. The information here is, for example, a password used for login. The information here is, for example, a login ID and a password used at the time of login. The information here may be, for example, information indicating attendance time and information indicating work leaving time, which are information necessary for attendance management. However, the information may be information other than a password or the like. Furthermore, the information identifier is, for example, an ID. The information identifier may be, for example, a schema name (may be referred to as a table name or DB name) and a record ID. Furthermore, it is preferable that the first record storage unit 121 also stores the time when the record was updated for each record.

  The first command receiving unit 122 receives an update command from any one or more terminal devices 11. The update command is usually information input by the user of the terminal device. Further, the first command receiving unit 122 may receive other commands and information from any one or more terminal devices 11. The other command is, for example, a command that prompts execution of the first process.

  The first information receiving unit 123 receives update information from the second server device 13. The update information is information to be updated and includes an information identifier and information. The update information may have the same structure as the update command or a different structure. The first information reception unit 123 may receive information including information that has not been updated (information that is not the latest) from the second server device 13. In such a case, the first update unit 124 described later determines whether or not the received information is the latest compared with the information in the first record storage unit 121, and updates the information only when it is the latest.

  The first updating unit 124 updates the information corresponding to the information identifier included in the update command received by the first command receiving unit 122 to the information included in the update command. Here, the information corresponding to the information identifier included in the update command is information stored in the first record storage unit 121.

  In addition, the first update unit 124 updates information corresponding to the information identifier included in the update information to information included in the update information. Here, the information corresponding to the information identifier included in the update information is information stored in the first record storage unit 121.

  The first processing unit 125 performs a first process using information stored in the first record storage unit 121. The first process may be anything. The first process is, for example, an authentication process for login. The first processing is, for example, processing for attendance management, and may be, for example, output of working hours, update of working hours, or the like. There is no limitation on how information is used in the first process. In addition, the 1st process part 125 may perform the process which does not use the information stored in the 1st record storage part 121, and processes other than a 1st process.

  The 2nd record storage part 131 which constitutes the 2nd server device 13 can store one or more records which have information and an information identifier which identifies information. One or more records in the second record storage unit 131 are usually the same as the one or more records stored in the first record storage unit 121. However, only a part of the records in the first record storage unit 121 and the records in the second record storage unit 131 may match.

  Further, only a part of the information included in the record of the second record storage unit 131 may be the same in the first record storage unit 121 and the second record storage unit 131. That is, the record in the first record storage unit 121 and the record in the second record storage unit 131 do not have to completely match.

  The second command receiving unit 132 receives an information update command from one or more terminal devices 11. The update command includes an information identifier and information to be updated. The update command is usually information input by the user of the terminal device 11. The terminal device 11 may be a terminal device 11 different from the terminal device 11 that has updated the information of the first server device 12. Further, the second command receiving unit 132 may receive other commands and information from any one or more terminal devices 11. The other command is, for example, a command that prompts execution of the second process.

  The information acquisition unit 133 performs processing for accessing the first server device 12 and acquiring information and an information identifier included in the update command received by the first command reception unit 122. The information acquisition unit 133 may periodically access the first server device 12 and perform processing for acquiring the information received by the first command receiving unit 122 and the information identifier. Further, it is preferable that the information acquisition unit 133 acquires only the information updated after the last access and the information identifier for identifying the information.

  The information acquisition unit 133 may include information that is not up-to-date in the information acquired by accessing the first server device 12. In such a case, the second update unit 134, which will be described later, determines whether the information acquired by the information acquisition unit 133 is new compared to the information stored in the second record storage unit 131. The information in the second record storage unit 131 is updated. In this case, the information acquisition unit 133 also acquires the update time of the information in association with the information.

  The second update unit 134 updates the information corresponding to the information identifier included in the update command received by the second command receiving unit 132 to the information included in the update command. Information corresponding to the information identifier included in the update command is information stored in the second record storage unit 131. The update command here is usually information input by the user of the terminal device 11. The terminal device 11 may be a terminal device 11 different from the terminal device 11 that has updated the information of the first server device 12.

  Further, the second update unit 134 updates each piece of information corresponding to one or more information identifiers acquired by the information acquisition unit 133 to one or more pieces of information acquired by the information acquisition unit 133. Information corresponding to one or more information identifiers acquired by the information acquisition unit 133 is information stored in the second record storage unit 131.

  The second update information transmission unit 135 transmits the update information including the information identifier included in the update command and the information included in the update command to the first server device 12.

  Further, the second update information transmission unit 135 checks whether or not the information stored in the second record storage unit 131 has been updated. If the information has been updated, the second update information transmission unit 135 identifies the updated information and the information. One or more pieces of update information having information identifiers to be transmitted may be transmitted to the first server device 12. Such inspection is usually a periodic inspection. However, the inspection may be performed irregularly. For example, the inspection may be performed at a time designated by the user.

  The second update information transmission unit 135 is information corresponding to the information identifier included in the update command, and the information stored in the second record storage unit 131 is included in the second update unit 134 in the update command. The update information may be transmitted to the first server device 12 every time the information is updated. Here, the time of updating may be after updating or before updating.

  Furthermore, the second update information transmission unit 135 may transmit all the records in the second record storage unit 131 to the first server device 12 periodically, for example. In such a case, selection of information to be updated is performed by the first server device 12.

  The second processing unit 136 performs the second process using information stored in the second record storage unit 131. The second process is usually the same as the first process, but may be different. The second process [0] is, for example, an authentication process for login. The second process is, for example, a process for attendance management, and may be, for example, output of working hours, update of working hours, or the like. There is no limitation on how information is used in the second processing.

  The transmission unit 112 and the second update information transmission unit 135 are usually realized by wireless or wired communication means, but may be realized by broadcasting means.

  The reception unit 113, the first command reception unit 122, the first information reception unit 123, the second command reception unit 132, and the information acquisition unit 133 are usually realized by wireless or wired communication means, but receive broadcasts. It may be realized by means.

  The first record storage unit 121 and the second record storage unit 131 are preferably non-volatile recording media, but can also be realized by volatile recording media.

  The first updating unit 124, the first processing unit 125, the second updating unit 134, and the second processing unit 136 can be usually realized by an MPU, a memory, or the like. The processing procedure of the first updating unit 124 or the like is usually realized by software, and the software is recorded on a recording medium such as a ROM. However, it may be realized by hardware (dedicated circuit).

  Next, the operation of the information system 1 will be described. First, the operation of the terminal device 11 will be described. The receiving unit 111 of the terminal device 11 receives an update command having an information identifier and information from the user. Then, the transmission unit 112 transmits an update command to the first server device 12 or the second server device 13. Next, the receiving unit 113 receives a processing result corresponding to the transmission of the update command from the first server device 12 or the second server device 13. Next, the output unit 114 outputs the processing result.

  In addition, when the reception part 111 receives other information and instructions other than an update instruction, a process is performed according to the information and instruction. Such processing is, for example, processing using a known technique.

  Next, operation | movement of the 1st server apparatus 12 is demonstrated using the flowchart of FIG.

  (Step S301) The first command receiving unit 122 determines whether or not an update command has been received from the terminal device 11. If an update command is received, the process goes to step S302, and if no update command is received, the process goes to step S304.

  (Step S302) The first update unit 124 acquires an information identifier included in the update command received in step S301.

  (Step S303) The first update unit 124 updates the information corresponding to the information identifier acquired in Step S302 to the information included in the update command received in Step S301. The process returns to step S301.

  (Step S304) The first information receiving unit 123 determines whether or not update information has been received from the second server device 13. If the update information is received, the process goes to step S305, and if the update information is not received, the process goes to step S307.

  (Step S305) The first update unit 124 acquires an information identifier included in the update information received in step S304.

  (Step S306) The first update unit 124 updates the information corresponding to the information identifier acquired in step S305 to the information included in the update information received in step S304. The process returns to step S301.

  (Step S307) The first command receiving unit 122 determines whether or not a command for the first process has been received from the terminal device 11. If the first process command is received, the process proceeds to step S308. If the first process command is not received, the process proceeds to step S309.

  (Step S308) The first processing unit 125 performs the first process using the information stored in the first record storage unit 121. The process returns to step S301.

  (Step S309) The first command receiving unit 122 determines whether another command, information, or the like has been received from the terminal device 11. If another command or information is received, the process proceeds to step S310, and if not received, the process returns to step S301.

  (Step S310) The first processing unit 125 performs processing corresponding to other commands, information, and the like. The process returns to step S301.

  In step S304 in the flowchart of FIG. 3, a plurality of update information may be received at a time. When the update information is received, the first update unit 124 performs the processes of step S305 and step S306 a plurality of times.

  In the flowchart of FIG. 3, the first information reception unit 123 may also receive information other than update information (information that is not up-to-date) from the second server device 13. In such a case, the first information receiving unit 123 also receives an update time corresponding to the information. And the 1st update part 124 updates the information in the 1st record storage part 121 only for the newest information using the said update time.

  Further, in the flowchart of FIG. 3, the process is ended by power-off or a process end interrupt.

  Next, operation | movement of the 2nd server apparatus 13 is demonstrated using the flowchart of FIG.

  (Step S401) The second command receiving unit 132 determines whether or not an update command has been received from the terminal device 11. If an update command is received, the process goes to step S402, and if no update command is received, the process goes to step S404.

  (Step S402) The second update unit 134 acquires an information identifier included in the update command received in Step S401.

  (Step S403) The second update unit 134 updates the information corresponding to the information identifier acquired in Step S402 to the information included in the update command received in Step S401. The process returns to step S401.

  (Step S404) The second update information transmission unit 135 determines whether it is a timing for examining whether or not the information stored in the second record storage unit 131 has been updated (referred to as an examination timing as appropriate). . If it is time to inspect, go to step S405, and if it is not time to inspect, go to step S408.

  (Step S <b> 405) The second update information transmission unit 135 determines whether there is information updated after the immediately preceding inspection timing among the information stored in the second record storage unit 131. If updated information exists, the process goes to step S406, and if updated information does not exist, the process returns to step S401. The second update information transmission unit 135 stores the inspection timing time in a storage unit (not shown). And And the 2nd update information transmission part 135 updates the time of an inspection timing, whenever it test | inspects.

  (Step S <b> 406) The second update information transmission unit 135 acquires update information including a set of information and an information identifier updated after the immediately previous examination timing from the second record storage unit 131. Here, two or more pieces of update information may be acquired.

  (Step S407) The second update information transmission unit 135 transmits one or more pieces of update information acquired in Step S406 to the first server device 12. The process returns to step S401.

  (Step S408) The information acquisition unit 133 determines whether it is time to access the first server device 12. If it is time to access the first server device 12, go to step S 409, otherwise go to step S 415. Note that the information acquisition unit 133 determines, for example, that it is time to periodically access the first server device 12.

  (Step S409) The information acquisition unit 133 accesses the first server device 12, and acquires a set of updated information and information identifiers in the first record storage unit 121 of the first server device 12. Here, there are cases where the updated information cannot be acquired, and there are cases where two or more pieces of updated information can be acquired. When updated information exists in the first server device 12, a set of the updated information and information identifier is stored in a predetermined storage area (either in the first record storage unit 121 or another recording area). Good). In such a case, the information acquisition unit 133 accesses a predetermined storage area and acquires a set of updated information and an information identifier. Then, the acquired set of information and information identifier is deleted.

  (Step S410) The second updating unit 134 substitutes 1 for the counter i.

  (Step S411) The second updating unit 134 determines whether or not the i-th information and information identifier pair exists among the information and information identifier pair acquired in Step S409. If i-th information etc. exist, it will go to Step S412, and if i-th information etc. do not exist, it will return to Step S401.

  (Step S412) The second updating unit 134 acquires an information identifier from the set of the i-th information and the information identifier.

  (Step S413) The second update unit 134 is information corresponding to the information identifier acquired in Step S412 and updates the information stored in the second record storage unit 131 to the i-th information.

  (Step S414) The second updating unit 134 increments the counter i by 1. The process returns to step S411.

  (Step S415) The second command receiving unit 132 determines whether or not a second processing command has been received from the terminal device 11. If an instruction for the second process is received, the process proceeds to step S416. If not received, the process proceeds to step S417.

  (Step S416) The second processing unit 136 performs the second process using the information stored in the second record storage unit 131. The process returns to step S401.

  (Step S417) The second command receiving unit 132 determines whether another command, information, or the like has been received from the terminal device 11. If another command or information is received, the process goes to step S418, and if not received, the process returns to step S401.

  (Step S418) The second processing unit 136 performs a process corresponding to another command or information. The process returns to step S401.

  In the flowchart of FIG. 4, every time an update command is received in step S <b> 401, the second update information transmission unit 135 may transmit update information to the first server device 12.

  In the flowchart of FIG. 4, the second update information transmission unit 135 may also transmit unupdated information to the first server device 12 in addition to one or more pieces of update information. In such a case, the first server device 12 selects information to be updated.

  In the flowchart of FIG. 4, the information acquisition unit 133 may also acquire information that has not been updated. In such a case, the information acquisition unit 133 also acquires an update time corresponding to the information. Then, the second update unit 134 compares the update time of the acquired information with the update time of the information in the second record storage unit 131, and updates the information when the update time of the acquired information is new To do.

  Further, in the flowchart of FIG. 4, the process is terminated by powering off or a process termination interrupt.

  Hereinafter, a specific operation of the information system 1 in the present embodiment will be described. A conceptual diagram of the information system 1 is shown in FIG.

  The first server device 12 is a server device that exists in the public network, and the second server device 13 is a server device that exists in the private network.

  Further, in the first server device 12, the user can use the attendance management system and the salary statement inquiry system. In the second server device 13, the user can use an attendance management system, a salary statement inquiry system, a personnel management system, and the like.

  In addition, the attendance management system manages the information on the time of leaving and the time of leaving the office input by each user. An example of the input screen of the attendance management system is shown in FIG. After logging in to the attendance management system, the user can input reasons such as time stamps and absences. Also, the attendance manager can check the attendance of the employee in charge and confirm the attendance for one month. Further, each employee can download one-month attendance data determined by the attendance officer. Note that employee attendance information may be stored in the first record storage unit 121 of the first server device 12 and the second record storage unit 131 of the second server device 13. And by the mechanism mentioned above, in the 1st server apparatus 12 and the 2nd server apparatus 13, the consistency of employee's attendance information may be guaranteed. Here, it is preferable that the user can perform time stamping using a medium such as an IC card. In other words, the receiving unit 111 of the terminal device 11 receives the information identifier from a medium such as a card that can only be held by the user (for example, an employee card storing the information identifier), and logs into the attendance management system. Then, for example, it is preferable that the input screen of FIG. 5 is displayed on the terminal device 11 and the user can input reasons such as time stamps, absences and absences. By using a medium such as a card, it is not possible to perform proxy engraving.

  An example of the structure of employee attendance information is shown in FIG. FIG. 6 shows the structure of attendance information for one employee. In FIG. 6, attendance daily data is managed for each employee and for each work day.

  The salary statement inquiry system is a system in which each user can inquire about salary. The user can inquire about his salary after logging into the salary statement inquiry system. An output screen example of the salary statement inquiry system is shown in FIG. In the salary statement inquiry system, overtime hours are calculated using the user's attendance information, and the salary information shown in FIG. 7 is output using the overtime hours and basic data (not shown) of each user.

  The first record storage unit 121 of the first server device 12 and the second record storage unit 131 of the second server device 13 each hold a user management table (see FIG. 8). Here, it is assumed that the user management table of the first record storage unit 121 and the user management table of the second server device 13 have the same structure.

  The user management table manages one or more records having attribute values such as “user ID”, “user code”, “account”, “user name”, “lock state”, “password”, and “password update date / time”. “User ID” is an ID for identifying a user. “User code” is an arbitrary code unique to the user. “Account” is the account name of the user. “User name” is the name of the user. “Lock state” is information indicating whether or not the user's record is locked. When the “lock state” is “0”, it is not locked, and when it is “1”, it is locked. For example, after the user logs in, the “lock state” becomes “1”, and when the user logs out, the “lock state” becomes “0”. The “password” is a password used for the user to log in. Further, “password update date / time” indicates the latest date / time updated to the current password.

  The schema name of the user management table stored in the first record storage unit 121 of the first server device 12 is “SchemaA”.

  In addition to the user management table, the first record storage unit 121 and the second record storage unit 131 store a password update management table (see FIG. 9). The password update management table stores password update history information for each user.

  Here, it is assumed that the first process and the second process are authentication processes for login. That is, in the first process and the second process, an authentication process for login is performed using information (here, a password) in the user management table. In the first process and the second process, it is assumed that an authentication process for login is performed using the user ID in addition to the password of the user management table.

  It is assumed that at time “2011/10/7 8:58:21”, the user “Ichiro Yamada” inputs the user ID “1” and the password “aabb” and tries to log in to the second server device 13. That is, the user “Ichiro Yamada” inputs the user ID “1” and the password “aabb” to his / her terminal device 11 and tries to log in to the attendance management system of the second server device 13. Then, the reception unit 111 of the terminal device 11 receives a second process command having the user ID “1” and the password “aabb”. Then, the transmission unit 112 transmits a second processing instruction having the user ID “1” and the password “aabb” to the second server device 13.

  Next, the second command receiving unit 132 of the second server device 13 receives the command for the second process having the user ID “1” and the password “aabb”. Next, the second processing unit 136 performs an authentication process, which is a second process, using the user ID “1” and the password “aabb”. That is, the second processing unit 136 determines that the user ID “1” and the password “aabb” are stored in the user management table of FIG. 8, and acquires information indicating authentication permission. Then, the second processing unit 136 transmits information indicating authentication permission to the terminal device 11 of “Ichiro Yamada”. In addition, an input screen (see FIG. 5) of the attendance management system is also transmitted to the terminal device 11 of “Ichiro Yamada”.

  Next, the terminal device 11 of “Ichiro Yamada” receives the information indicating the authentication permission and the input screen of the attendance management system, and displays the input screen. Then, “Ichiro Yamada” presses a button indicating attendance. Then, information indicating the user ID “1” and the attendance time is transmitted to the second server device 13.

  Next, it is assumed that “Ichiro Yamada” inputs an update command for updating the password to “abcc” in the terminal device 11. Then, the reception unit 111 of the terminal device 11 receives the update command. Next, the transmission unit 112 configures an update command “UpdateUser <UserID> 1 </ UserID> <UserPassword> abcc </ UserPassword>” and transmits it to the second server device 13. “UpdateUser” indicates a user information update command, “<UserID> 1 </ UserID>” is a kind of information identifier, and “<UserPassword> abcc </ UserPassword>” is information to be updated. Indicates the password to be used.

  Next, the second command receiving unit 132 of the second server device 13 receives the update command “UpdateUser <UserID> 1 </ UserID> <UserPassword> abcc </ UserPassword>”. Then, the second update unit 134 acquires the information identifier “<UserID> 1 </ UserID>” included in the received update command. Next, the second updating unit 134 updates information (here, password “aabb”) corresponding to the acquired information identifier “<UserID> 1 </ UserID>” and updates the password update date and time. The second update unit 134 holds the correspondence between the tag and the attribute of the user management table. For example, the second updating unit 134 holds that the tag <UserID> corresponds to the attribute “user ID” of the user management table of FIG.

  Then, the password of the record of the user ID “1” in FIG. 8 is updated from “aabb” to “abcc”. Further, the password update date and time of the record of the user ID “1” in FIG. 8 is updated from “2011/9/12 15:25:08” to “2011/10/7 9:30:26”. Note that “2011/10/7 9:30:26” is the current time acquired by the second updating unit 134 from a clock (not shown). Then, the second update unit 134 adds a record of “user ID“ 1 ”, password“ abcc ”, and password update date and time“ 2011/10/7 9:30:26 ”to the password update management table of FIG. .

  Then, the time has elapsed, and then the second update information transmission unit 135 has determined that it is the inspection timing for checking whether the information stored in the second record storage unit 131 has been updated. To do. And the 2nd update information transmission part 135 judges that the information updated after the last test | inspection timing exists in the information stored in the 2nd record storage part 131. FIG. It is assumed that the second update information transmission unit 135 holds the date and time of the immediately previous inspection timing in a recording medium (not shown).

  Next, the second update information transmission unit 135, from the user information management table of the second record storage unit 131, information (password “abcc”) and information identifier (user ID “1”) that have been updated since the last examination timing. ) Including update information “user ID“ 1 ”and password“ abcc ””.

  Next, the second update information transmission unit 135 transmits the acquired update information “user ID“ 1 ”, password“ abcc ”” to the first server device 12. It is assumed that the update information to be transmitted has a structure such as a message unique key “ID”, a schema name of the first server device 12, a message type, and a message content. For example, it is assumed that the second update information transmission unit 135 has transmitted the update information (message) illustrated in FIG. 10 to the first server device 12. It is assumed that the second update information transmission unit 135 manages in advance that the name of the table that manages passwords and the like is “SchemaA”. Also, the message type “UpdateUser” of the update information shown in FIG. 10 indicates update of a record in the user management table. Further, the message content “<User> <UserID> 1 </ UserID> <UserPassword> abcc </ UserPassword> </ User>” includes an information identifier “user ID“ 1 ”” and information to be updated “password“ abcc ””. Indicates that

  Next, the first information receiving unit 123 of the first server device 12 receives the update information of FIG. 10 from the second server device 13. Then, the first update unit 124 acquires the information identifier “user ID“ 1 ”” included in the received update information. Then, the first updating unit 124 updates the information “password“ aabb ”” corresponding to the information identifier “user ID“ 1 ”to the information“ password “abcc” ”included in the received update information. It is assumed that the password update date is also updated.

  Next, it is assumed that the user “Ichiro Yamada” inputs the user ID “1” and the password “abcc” and logs in to the first server device 12 on 2011/10/11.

  Next, it is assumed that “Ichiro Yamada” has input an update command for updating the password to “abcd” to the terminal device 11 which is a portable terminal from the outside. Then, the reception unit 111 of the terminal device 11 receives the update command “user ID“ 1 ”, password“ abcd ””. Then, the transmission unit 112 transmits the update command to the first server device 12.

  Next, the first command receiving unit 122 of the first server device 12 receives the update command “user ID“ 1 ”, password“ abcd ”” from the terminal device 11.

  Next, the first update unit 124 acquires the information identifier “user ID“ 1 ”” included in the received update command. Then, the first update unit 124 updates the information corresponding to the acquired information identifier “user ID“ 1 ”” to the information “password“ abcd ”” included in the received update command. That is, the first update unit 124 changes the password of the record of “user ID = 1” in the user information management table stored in the first record storage unit 121 of the first server device 12 from “abcc” to “abcd”. Update. The first update unit 124 also updates the password update date and time of the record of “user ID = 1” from “2011/10/7 9:30:26” to “2011/10/11 9:15:43”. , And. Note that “2011/10/11 9:15:43” is the current time.

  Then, the first update unit 124 adds the record “user ID“ 1 ”, password“ abcd ”, and password update date“ 2011/10/11 9:15:43 ”” to the password update management table of FIG. , And.

  It is assumed that time has elapsed and the information acquisition unit 133 of the second server device 13 determines that it is time to access the first server device 12.

  Next, the information acquisition unit 133 accesses the first server device 12, and in the first record storage unit 121 of the first server device 12, the password “abcd” which is updated information and the information identifier “user ID“ 1 ” ”” Set is acquired. Here, it is assumed that the information acquisition unit 133 also acquires the password update date “2011/10/11 9:15:43”.

  Next, the second update unit 134 is information (password) corresponding to the acquired information identifier “user ID“ 1 ””, and the information (password) stored in the second record storage unit 131 is used. Update to “abcd”. The second update unit 134 also updates the password update date “2011/10/11 9:15:43”.

  Through the above processing, the user information management table of the first record storage unit 121 of the first server device 12 and the user information management table of the second record storage unit 131 of the second server device 13 are updated as shown in FIG. Suppose that

  As described above, according to the present embodiment, it is possible to guarantee the consistency of information managed by a plurality of server devices even when the network environments in which the plurality of server devices exist are different. In particular, in an environment in which the second server device can access the first server device but cannot access the second server device from the first server device, the first server device and the second server device can be adapted to such an environment. Ensure the consistency of the information being managed. Furthermore, according to the present embodiment, the same information exists in the first server device and the second server device, and the user can update the information in either server device, and the second server Information that is managed by the first server device and the second server device in an environment where the first server device can be accessed from the device but the first server device cannot be accessed from the second server device so as to be suitable for the environment. Can guarantee consistency.

  That is, according to the present embodiment, the first server device 12 on the public network and the second server device 13 on the private network are not mutually synchronized, but the access direction is the second server device 13 on the private network. Is one-way to the first server device 12 on the public network. Such a mechanism can solve the problem that it is difficult for the first server device 12 on the public network to know the second server device 13 on the private network.

  According to the present embodiment, the number of server devices that guarantee the consistency of information may be three or more. In particular, according to the present embodiment, the information system 1 may include two or more first server devices 12 and two or more second server devices 13.

  When the information system 1 includes two or more first server devices 12, each of the one or more second server devices 13 acquires and updates update information of the two or more first server devices 12. In addition, when the information is updated, each second server device 13 transmits the update information to two or more first server devices 12. In such a case, normally, each of the two or more second server devices 13 receives update information from other second server devices 13 or obtains update information.

  Further, when the information system 1 has two or more second server devices 13, each second server device 13 updates the update information of each first server device 12, or the update information of each first server device 12 and other second server devices 13. Update information of the two server device 13 is acquired and updated. In addition, when the information is updated, each second server device 13 transmits the update information to each first server device 12 and usually transmits the update information to other second server devices 13.

  Moreover, in this Embodiment, the 1st server apparatus 12 and the 2nd server apparatus 13 may cooperate in order to ensure the consistency of information with the following mechanisms.

  In other words, a mechanism called Messaging Service is used. When transmitting information that should ensure consistency from the second server device 13 (on-premises side) to the first server device 12 (cloud side) using this mechanism, the second server device 13 called SendMessage is predetermined. When the information exists in the storage area (for example, the first record storage unit 121), the second update information transmission unit 135 transmits the information (update information) to the first server device 12. In SendMessage, only information that has been updated by the second server device 13 but has not been transmitted to the first server device 12 is stored.

  Next, the first information receiving unit 123 of the first server device 12 receives the update information. Then, the first update unit 124 reflects the update information in the first record storage unit 121. The information called “SendMessage” has the structure shown in FIG.

  Moreover, the operation | movement in the case of transmitting the information which should ensure consistency from the 1st server apparatus 12 (cloud side) to the 2nd server apparatus 13 (on-premises side) is as follows. That is, the second server device 13 periodically accesses the first server device 12 and checks whether information exists in SendMessage. SendMessage is a predetermined storage area (second record storage unit 131) of the second server device 13. And the information acquisition part 133 of the 2nd server apparatus 13 acquires the information which exists in SendMessage. When the information acquisition unit 133 acquires the information, the information acquisition unit 133 determines what the content is from the message type, reads the content of the data from the message content, and updates the information in the second record storage unit 131.

  Furthermore, the processing in the present embodiment may be realized by software. Then, this software may be distributed by software download or the like. Further, this software may be recorded and distributed on a recording medium such as a CD-ROM. This also applies to other embodiments in this specification. In addition, the software which implement | achieves the 1st server apparatus 12 in this Embodiment is the following programs. In other words, this program stores one or more records having information and an information identifier for identifying the information on a recording medium, and the computer receives one or more information update instructions including information identifier and information to be updated. A first command receiving unit that receives from any one of the terminal device, a first information receiving unit that receives update information including an information identifier and information to be updated from the second server device, and an information identifier included in the update command. Information corresponding to information stored in the recording medium is updated to information included in the update command, and information corresponding to an information identifier included in the update information is stored in the first record storage unit. As a first update unit that updates stored information to information included in the update information, and a first processing unit that performs a first process using information stored in the recording medium Program for ability is.

  Moreover, the software which implement | achieves the 2nd server apparatus 13 is the following programs. In other words, this program stores one or more records having information and an information identifier for identifying the information on a recording medium, and the computer receives one or more information update instructions including information identifier and information to be updated. The second command receiving unit that receives from any one of the terminal device and the information corresponding to the information identifier included in the update command and stored in the recording medium is updated to the information included in the update command A second update information transmitting unit that transmits update information having an information identifier included in the update command and information included in the update command to the first server device, and the first server device. An information acquisition unit that performs processing for acquiring information and an information identifier included in the update command received by the first command reception unit, and information stored in the recording medium A program for causing a second processing unit to perform a second process, wherein the second update unit is information corresponding to one or more information identifiers acquired by the information acquisition unit, and the recording medium Is a program for causing a computer to function as information to be updated to one or more pieces of information acquired by the information acquisition unit.

  FIG. 12 shows the external appearance of a computer that executes the program described in this specification and realizes the first server device and the like of the above-described embodiment. The above-described embodiments can be realized by computer hardware and a computer program executed thereon. FIG. 12 is an overview diagram of the computer system 300, and FIG. 13 is a block diagram of the computer system 300.

  In FIG. 12, a computer system 300 includes a computer 301 including an FD drive and a CD-ROM drive, a keyboard 302, a mouse 303, and a monitor 304.

  In FIG. 13, in addition to the FD drive 3011 and the CD-ROM drive 3012, the computer 301 stores an MPU 3013, a bus 3014 connected to the CD-ROM drive 3012 and the FD drive 3011, and a program such as a bootup program. And a RAM 3016 for temporarily storing application program instructions and providing a temporary storage space, and a hard disk 3017 for storing application programs, system programs, and data. Although not shown here, the computer 301 may further include a network card that provides connection to a LAN.

  A program that causes the computer system 300 to execute the functions of the first server device, the second server device, and the like of the above-described embodiment is stored in the CD-ROM 3101 or the FD 3102 and stored in the CD-ROM drive 3012 or the FD drive 3011. It may be inserted and further transferred to the hard disk 3017. Alternatively, the program may be transmitted to the computer 301 via a network (not shown) and stored in the hard disk 3017. The program is loaded into the RAM 3016 at the time of execution. The program may be loaded directly from the CD-ROM 3101, the FD 3102 or the network.

  The program does not necessarily include an operating system (OS) or a third-party program that causes the computer 301 to execute the functions of the first server device, the second server device, and the like according to the above-described embodiment. The program only needs to include an instruction portion that calls an appropriate function (module) in a controlled manner and obtains a desired result. How the computer system 300 operates is well known and will not be described in detail.

  In the above program, in the step of transmitting information, the step of receiving information, etc., processing performed by hardware, for example, processing performed by a modem or an interface card in the transmission step (only performed by hardware) Processing) is not included.

  Further, the computer that executes the program may be singular or plural. That is, centralized processing may be performed, or distributed processing may be performed.

  Further, in each of the above embodiments, it goes without saying that two or more communication units existing in one apparatus may be physically realized by one medium.

  In each of the above embodiments, each process (each function) may be realized by centralized processing by a single device (system), or by distributed processing by a plurality of devices. May be.

  The present invention is not limited to the above-described embodiments, and various modifications are possible, and it goes without saying that these are also included in the scope of the present invention.

  As described above, the information system according to the present invention is a case where it is necessary to guarantee the consistency of information managed by a plurality of server devices, and the network environment where the plurality of server devices exist is different. It has the effect of ensuring the consistency of information and is useful as an information system.

DESCRIPTION OF SYMBOLS 1 Information system 11 Terminal device 12 1st server apparatus 13 2nd server apparatus 111 Reception part 112 Transmission part 113 Reception part 114 Output part 121 First record storage part 122 First command reception part 123 First information reception part 124 First update Unit 125 first processing unit 131 second record storage unit 132 second command reception unit 133 information acquisition unit 134 second update unit 135 second update information transmission unit 136 second processing unit

Claims (13)

An information system comprising a first server device and a second server device,
The first server device is
A first record storage unit capable of storing one or more records having information and an information identifier for identifying the information;
A first command receiving unit that receives an update instruction for information including an information identifier and information to be updated from any one or more terminal devices;
A first information receiving unit that receives from the second server device update information including an information identifier and information to be updated;
The information corresponding to the information identifier included in the update command and the information stored in the first record storage unit is updated to the information included in the update command, and the information identifier included in the update information A first update unit that updates corresponding information and information stored in the first record storage unit to information included in the update information;
A first processing unit that performs a first process using information stored in the first record storage unit,
The second server device is
A second record storage unit capable of storing one or more records having information and an information identifier for identifying the information;
A second command receiving unit that receives an update instruction for information including an information identifier and information to be updated from any one or more terminal devices;
A second update unit that updates information stored in the second record storage unit to information included in the update command, which corresponds to an information identifier included in the update command;
A second update information transmitting unit for transmitting update information having an information identifier included in the update command and information included in the update command to the first server device;
An information acquisition unit that performs processing for accessing the first server device and acquiring information and an information identifier included in the update command received by the first command reception unit;
A second processing unit that performs a second process using information stored in the second record storage unit,
The second update unit is
Information corresponding to one or more information identifiers acquired by the information acquisition unit, and information for updating information stored in the second record storage unit to one or more pieces of information acquired by the information acquisition unit system. The second update information transmitting unit is
One or more updates having the updated information and an information identifier for identifying the information when the information stored in the second record storage unit is updated and the information is updated. The information system according to claim 1, wherein information is transmitted to the first server device. The second update information transmitting unit is
Each time the second update unit updates the information stored in the second record storage unit to the information included in the update command, the information corresponding to the information identifier included in the update command. The information system according to claim 1, wherein information is transmitted to the first server device. The information acquisition unit
The information system according to any one of claims 1 to 3, wherein the first server device is periodically accessed to perform processing for acquiring information and an information identifier received by the first command receiving unit. The information acquisition unit
4. The information system according to claim 3, wherein only the information updated after the last access and the information identifier for identifying the information are acquired. The first server device is
A server device on a public network,
The second server device is
6. The information system according to claim 1, wherein the information system is a server device on a private network. The information system according to any one of claims 1 to 6, wherein the information stored in the first record storage unit and the information stored in the second record storage unit are passwords. The information system according to claim 1, wherein the first process and the second process are the same process. A first record storage unit capable of storing one or more records having information and an information identifier for identifying the information;
A first command receiving unit that receives an update instruction for information including an information identifier and information to be updated from any one or more terminal devices;
A first information receiving unit that receives update information including an information identifier and information to be updated from the second server device;
The information corresponding to the information identifier included in the update command and the information stored in the first record storage unit is updated to the information included in the update command, and the information identifier included in the update information A first update unit that updates corresponding information and information stored in the first record storage unit to information included in the update information;
The server apparatus which comprises the 1st process part which performs a 1st process using the information stored in said 1st record storage part. A second record storage unit capable of storing one or more records having information and an information identifier for identifying the information;
A second command receiving unit that receives an update instruction for information including an information identifier and information to be updated from any one or more terminal devices;
A second update unit that updates information stored in the second record storage unit to information included in the update command, which corresponds to an information identifier included in the update command;
A second update information transmitting unit for transmitting update information having an information identifier included in the update command and information included in the update command to the first server device;
An information acquisition unit that performs processing for accessing the first server device and acquiring information and an information identifier included in the update command received by the first command reception unit;
A second processing unit that performs a second process using information stored in the second record storage unit,
The second update unit is
A server that is information corresponding to one or more information identifiers acquired by the information acquisition unit, and updates the information stored in the second record storage unit to one or more pieces of information acquired by the information acquisition unit apparatus. The information identifier is
The server device according to claim 9 or 10, wherein the server device is information acquired from a medium storing the information identifier by a medium reading function of the terminal device. On the recording medium,
Storing one or more records having information and an information identifier for identifying the information;
Computer
A first command receiving unit that receives an update instruction for information including an information identifier and information to be updated from any one or more terminal devices;
A first information receiving unit that receives update information including an information identifier and information to be updated from the second server device;
Information corresponding to an information identifier included in the update command, and updating information stored in the recording medium to information included in the update command, and corresponding to an information identifier included in the update information And the first update unit that updates the information stored in the first record storage unit to the information included in the update information;
The program for functioning as a 1st process part which performs a 1st process using the information stored in the said recording medium. On the recording medium,
Storing one or more records having information and an information identifier for identifying the information;
Computer
A second command receiving unit that receives an update instruction for information including an information identifier and information to be updated from any one or more terminal devices;
A second update unit that updates information stored in the recording medium and corresponding to an information identifier included in the update command to information included in the update command;
A second update information transmitting unit that transmits update information having an information identifier included in the update command and information included in the update command to the first server device;
An information acquisition unit that performs processing for accessing the first server device and acquiring information and an information identifier included in the update command received by the first command reception unit;
A program for functioning as a second processing unit that performs second processing using information stored in the recording medium,
The second update unit is
A computer that is information corresponding to one or more information identifiers acquired by the information acquisition unit, and updates the information stored in the recording medium to one or more pieces of information acquired by the information acquisition unit. Program to make it work.