Patent Application
20230046802
The present invention relates to an information linking system, an information linking method, and an information linking program.
In the activities of companies, local governments, and financial institutions, information processing is conducted using a plurality of systems. While each system performs information processing independently, it is required to improve work efficiency by linking data between these systems. Japanese laid-open patent publication No. 2020-47144 discloses an example of an information linking system.
One embodiment of the present invention provides an information linking system including a processor and a memory device configured to store a program, the program being executed by the processor to cause the processor to: acquire first system data transmitted from a first system server and second system data transmitted from a second system server, the first system data including a first identifier and a first data format associated with a first identifier, and the second system data including a second identifier, first sub-data and second sub-data, the second identifier being different from the first identifier, and the first sub-data and the second sub-data having a second data format associated with the second identifier, convert the first sub-data of the second system data to the first identifier, and convert the first data format of the first system data and the second data format of the second system data to a common data format, and generate first statistical data by statistically processing the first system data and generate second statistical data by statistically processing the second sub-data of the second system data associated with the first identifier.
In the information linking system, the program may further cause the processor to generate analysis data by statistic processing using the first statistical data and the second statistical data when first variation data included in the second sub-data and associated with the first identifier satisfies a predetermined condition.
In the information linking system, the program may cause the processor to generate analysis data by statistic processing using the first statistical data and the second statistical data when second variation data included in the second sub-data and associated with the second identifier satisfies a predetermined condition.
In the information linking system, the first identifier may be an identifier related to a user, and the second identifier may be an identifier related to an environment.
In the information linking system, the first variation data includes a body temperature of the user, the second variation data includes a temperature of the environment, and the predetermined condition may be that the body temperature of the user or the temperature of the environment exceeds a set value.
In the information linking system, the first statistical data and the second statistical data may be numerical data, and the analysis data may be the difference between the first statistical data and the second statistical data.
In the information linking system, the program may cause the processor to compare the analysis data with a predetermined set value, and extract abnormal data deviating from the set value among the analysis data.
In the information linking system, the program may cause the processor to generate warning information to inform a user terminal of the existence of the abnormal data based on the extracted abnormal data, and transmit the warning information to the user terminal.
In the information linking system, the program may cause the processor to convert the first data format of the first system data and the second data format of the second system data into CSV format.
One embodiment of the present invention provides an information linking method including acquiring first system data transmitted from a first system server and second system data transmitted from a second system server, the first system data including a first identifier and a first data format associated with a first identifier, and the second system data including a second identifier, first sub-data and second sub-data, the second identifier being different from the first identifier, and the first sub-data and the second sub-data having a second data format associated with the second identifier, converting the first sub-data of the second system data to the first identifier, and converting the first data format of the first system data and the second data format of the second system data to a common data format, and generating first statistical data by statistically processing the first system data and generating second statistical data by statistically processing the second sub-data of the second system data associated with the first identifier.
The information linking method may further include generating analysis data by statistic processing using the first statistical data and the second statistical data when first variation data included in the second sub-data and associated with the first identifier satisfies a predetermined condition.
The information linking method may further include generating analysis data by statistic processing using the first statistical data and the second statistical data when second variation data included in the second sub-data and associated with the second identifier satisfies a predetermined condition.
In the information linking method, the first identifier may be an identifier related to a user, and the second identifier may be an identifier related to an environment.
In the information linking method, the first variation data may include a body temperature of the user, the second variation data may include a temperature of the environment, and the predetermined condition may be that the body temperature of the user and the temperature of the environment exceeds a corresponding set value.
In the information linking method, the first statistical data and the second statistical data may be numerical data, and the analysis data may be the difference between the first statistical data and the second statistical data.
In the information linking method, the information linking server may include a step of comparing the analysis data with a predetermined set value, and extracting abnormal data deviating from the set value among the analysis data.
In the information linking method, the information linking server may include a step of generating warning information to inform a user terminal of the existence of the abnormal data based on the extracted abnormal data, and transmitting the warning information to the user terminal.
In the information linking method, the program may cause the processor to convert the first data format of the first system data and the second data format of the second system data into CSV format.
One embodiment of the present invention includes a non-transitory computer readable storage medium storing a program. The program cause a computer to: acquire first system data transmitted from a first system server and second system data transmitted from a second system server, the first system data including a first identifier and a first data format associated with a first identifier, and the second system data including a second identifier the first identifier and first sub-data and second sub-data, the second identifier being different from the first identifier, and the first sub-data and the second sub-data having a second data format associated with the second identifier, convert the first sub-data of the second system data to the first identifier, and convert the first data format of the first system data and the second data format of the second system data to a common data format, generate first statistical data by statistically processing the first system data and generate second statistical data by statistically processing the second sub-data of the second system data associated with the first identifier, and generate analysis data by statistic processing using the first statistical data and the second statistical data when first variation data included in the second sub-data and associated with the first identifier satisfies a predetermined condition, wherein the first statistical data and the second statistical data are numerical data, and the analysis data is the difference between the first statistical data and the second statistical data.
By using an embodiment of the present invention, systems can be easily and quickly linked.
Embodiments of the present invention will be described below with reference to the drawings and the like. However, the present invention can be implemented in many different modes and should not be construed as being limited to the description of the following embodiments. Although the drawings may be represented schematically for the sake of clarity of illustration, they are merely examples and do not limit the interpretation of the present invention.
The letters “first” and “second” attached to each element are convenient labels used to distinguish each element and have no further meaning unless otherwise stated. In the drawings referenced in the present embodiment, the same portions or portions having similar functions are denoted by the same or similar symbols (symbols with A, B, 1, 2, and the like added to numerals xxx), and a repetitive description thereof may be omitted. Part of the configuration may be omitted from the drawings. In addition, if it can be recognized by a person ordinarily skilled in the art to which the present invention belongs, no particular explanation will be given.
Linking conventional systems requires the development of a dedicated program, which is costly and time-consuming.
In view of such problems, one of the objects in the present invention is to link systems easily and quickly.
An information linking system and an information linking method according to the first embodiment of the present invention will be described in detail with reference to the drawings.
The first system server 20 includes various systems together with the first system. In this example, the first system server 20 is provided as a cloud server. In the first system server 20, various core business systems are executed on a serverless architecture called a FaaS (Function as a Service). In the present embodiment, an attendance management system is used as an example of the FaaS serving as the first system. The second system server 30 includes various systems together with the second system. In this example, the second system server 30 is provided as a cloud server. In this example, various information systems are executed as the FaaS in the second system server 30. More specifically, in the present embodiment, a face authentication system is used as an example of the FaaS. The information linking server 10, the first system server 20, and the second system server 30 are composed of a plurality of information processing devices.
The user terminal 40 is a terminal that inputs information to each system and transmits and receives various information. In
The information linking server 10 includes a control unit 11, a storage unit 12, a communication unit 13, and a display unit 14. The control unit 11, the storage unit 12, the communication unit 13, and the display unit 14 are connected via a bus. In the present embodiment, the information linking server 10 is composed of a plurality of information processing devices and is provided as a cloud server.
The control unit 11 is a computer and controls processing based on instructions defined in software (program) for executing information linkage processing using a CPU (Central Processing Unit), an ASIC (Application Specific Integrated Circuit), an FPGA (Field Programmable Gate Array), or other calculation processing circuits. Instructions from the control unit 11 may provide the display unit 14 with a user interface for executing an information linking program.
In addition to an SSD (Solid State Drive) semiconductor memory and the like, a magnetic recording medium (magnetic tape, magnetic disk, and the like), an optical recording medium, a magneto-optical recording medium, and other storage-capable elements are used as the storage unit 12. The storage unit 12 stores an information linking program and functions as an information linkage information database for storing the first system data and the second system data used in the information linking program. The storage unit 12 may be provided on a server different from the information linking server 10 as appropriate and may function as a database.
The communication unit 13 is connected to a network 50 based on the control of the control unit 11 and performs transmission and reception of data between external devices. The communication unit 13 includes, for example, a modem or an NIC (Network Interface Card). The communication between the communication unit 13 and the first system server 20, the second system server 30, and the user terminal 40 is performed using the Internet (specifically, SSL (Secure Sockets Layer)/TLS (Transport Layer Security) or VPN (Virtual Private Network)) or an intranet.
The first system server 20 includes a control unit 21, a storage unit 22, a communication unit 23, and a display unit 24. The control unit 21, the storage unit 22, the communication unit 23, and the display unit 24 are connected via a bus. In the present embodiment, the first system server 20 is composed of a plurality of information processing devices and is provided as a cloud server.
The control unit 21 is a computer and uses a CPU, an ASIC, an FPGA, or other calculation processing circuits to control processing based on instructions defined in software (program) for executing each system. Instructions from the control unit 21 may provide the display unit 24 with a user interface for executing an information linking program.
In addition to the semiconductor memory or the like of the SSD, a magnetic recording medium, an optical recording medium, a magneto-optical recording medium, and other storage-capable elements are used as the storage unit 22. The storage unit 22 stores a program related to the information linking program and has a function as an information linkage information database for storing data (e.g., first system data) used in the program of the first system. The storage unit 22 may be provided on a server different from the first system server 20 as appropriate and may function as a database.
The communication unit 23 includes a transmitter and a receiver for performing communication between the information linking server 10, the second system server 30, the user terminal 40, and transmitting other related information via the network 50. The communication unit 23 may include, for example, a modem or NIC. The communication between the communication unit 23 and the information linking server 10, the second system server 30, and the user terminal 40 is performed using the Internet (specifically, SSL/TLS or VPN) or an intranet.
The second system server 30 includes a control unit 31, a storage unit 32, a communication unit 33, and a display unit 34. The control unit 31, the storage unit 32, the communication unit 33, and the display unit 34 are connected via a bus. In the present embodiment, the second system server 30 is composed of a plurality of information processing devices and is provided as a cloud server. The configuration of the second system server 30 is the same as that of the first system server 20, and therefore will not be described.
The user terminal 40 includes a display unit 41, a control unit 42, a storage unit 43, an operation unit 44, and a communication unit 45. The display unit 41, the control unit 42, the storage unit 43, the operation unit 44, and the communication unit 45 are connected via a bus. The user terminal 40 may be a smartphone, a cellular phone (feature phone), a tablet-type terminal, a notebook PC (Personal Computer), a desktop PC, an IoT (Internet of Things) device (for example, a device having a power source, a control function, a communication function, and an information storage function), and the like, and can be applied to any device capable of communicating with the information linking server 10 through a network.
The display unit 41 is a display device such as a liquid crystal display or an organic EL (Electro Luminescence) display, and content which is displayed is controlled by a signal input from the control unit 42.
The control unit 42 is a computer and includes a CPU, an ASIC, an FPGA, or other calculation processing circuits. The control unit 42 executes programs stored in the storage unit 43, such as memory, based on the operations of the display unit 41 and the operation unit 44. The control unit 42 transmits information for instructing execution of processing related to the information linking program stored in the storage unit 12 of the information linking server 10.
The operation unit 44 includes a controller, a button, or a switch. When the user performs an operation, such as moving up, down, left, or right, pressing, or rotating using the operation unit 44, information based on the operation is input into the control unit 42. If it is a display device (touch panel) having a touch sensor, the display unit 41 and the operation unit 44 may be arranged in the same location.
The communication unit 45 has a function of performing transmission and reception of data between the information linking server 10. For example, a transceiver via a LAN is used for the communication unit 45. The communication unit 45 is not limited to the transceiver via a LAN and may be provided with a transceiver for a portable terminal communication (e.g., LTE communication), or may be provided with a transceiver for near field communication. The user terminal 40 is connected to the information linking server 10 via the network 50.
The information linking server 10 includes an information linkage control unit 100 that controls a program (information linking program) for realizing the information linkage function. The information linkage control unit 100 includes an acquisition unit 110, a data conversion unit 120, a conversion data storage unit 130, a transmitting unit 140, a data generation unit 150, a comparative analysis unit 160, an abnormal data extraction unit 170, and a warning information generation unit 180. Each of the acquisition unit 110, the data conversion unit 120, the conversion data storage unit 130, the transmitting unit 140, the data generation unit 150, the comparative analysis unit 160, the abnormal data extraction unit 170, and the warning information generation unit 180 in the information linking server 10 may be executed as a FaaS.
The acquisition unit 110 has a function of acquiring various data in the information linking system. For example, the acquisition unit 110 may have a function of acquiring the first system data processed in the first system, which is one FaaS in the first system server 20, and the second system data processed in the second system, which is one FaaS in the second system server 30. The acquisition unit 110 in this case may be referred to as a first acquisition unit.
The acquisition unit 110 may have a function of acquiring data corresponding to the first system data or the second system data transmitted from the user terminal 40. The acquisition unit 110 in this case may be referred to as a second acquisition unit.
The data conversion unit 120 has a function of converting the first system data and the second system data into a common data format. In this example, the data conversion unit 120 converts the first system data and the second system data into CSV format.
The conversion data storage unit 130 has a function of storing the converted first system data and second system data in a database. In this example, the converted first system data and second system data are converted into an information linking database (also referred to as a web database) in the storage unit 12.
The transmitting unit 140 has a function of transmitting the converted first system data and second system data to the user terminal 40-1 and the user terminal 40-2. In this example, the converted first system data and second system data are transmitted as display data.
The data generation unit 150 associates the first system data and the second system data with each identifier to generate a dataset corresponding to the identifier. In this case, the data generation unit 150 associates the attendance data of the face authentication system and the attendance data of the attendance system with the identification number of the user and generates a dataset (attendance dataset) corresponding to the identification number of a specific user. The dataset may be generated before the converted data is stored in the information linking database.
The first system data and the second system data may be associated with each other by an identifier of the work unit.
The comparative analysis unit 160 has a function of comparing and analyzing the generated dataset and a set value set in a predetermined condition.
The abnormal data extraction unit 170 has a function of extracting abnormal data deviating from the set value from the comparatively analyzed dataset.
The warning information generation unit 180 has a function of generating warning information for notifying the presence of the abnormal data to the user terminal 40 based on the abnormal data. The warning information may be display data such as character data or image data, or music data.
The first system server 20 executes the processing defined in a program related to an information linkage processing program stored in the storage unit 22. The first system server 20 has a receiving unit 210 and a transmitting unit 220 as functional units. The receiving unit 210 has a function of receiving various data from the information linking server 10 and the user terminal 40. The transmitting unit 220 has a function of transmitting various information linkage information including the first system data to the information linking server 10.
The second system server 30 executes the processing defined in a program related to the information linkage processing program stored in the storage unit 32. The second system server 30 has a receiving unit 310 and a transmitting unit 320 as functional units. The receiving unit 310 has a function of receiving various data from the information linking server 10 and the user terminal 40. The transmitting unit 320 has a function of transmitting various information linkage information including the second system data to the information linking server 10.
The user terminal 40 executes the processing defined in a program related to the information linkage processing program stored in the storage unit 43. The user terminal 40 has a receiving unit 410 and a transmitting unit 420 as functional units. The receiving unit 410 has a function of receiving the first system data and the second system data converted from the information linking server 10. The transmitting unit 420 has a function of transmitting a part of the converted first system data and second system to the information linking server 10.
Next, information linkage control processing based on instructions by the information linking program in the information linkage control unit 100 will be described.
The first information linkage control processing S100 includes first system data generation processing and second system data generation processing. The second information linkage control processing S200 includes system data acquisition processing, system data conversion processing, and converted data storage processing. The third information linkage control processing S300 includes data display processing, comparative analysis processing, and abnormal data extraction processing. Each information linkage control processing is described separately.
As shown in
When the first system server 20 receives the data input by the user terminal 40-1 (S107), the first system server 20 executes data processing (S109). Thus, the first system data is generated. The generated first system data is stored in the storage unit 22 of the first system server 20 (S111). In this example, attendance system data is generated as shown in
When the second system server 30 receives the data input by the user terminal 40-2 (S113), the second system server 30 executes data processing (S115). Thus, the second system data is generated. The generated second system data is stored in the storage unit 32 of the second system server 30 (S117). In this example, the attendance authentication system data is generated, as shown in
The second information linkage control processing starts with the completion of the first information linkage control processing as a trigger. As shown in
Next, the data conversion unit 120 converts the acquired first system data and the second system data into a common data format (S203). In this example, the data conversion unit 120 converts the first system data and the second system data into CSV format.
Next, the conversion data storage unit 130 stores the converted first system data and the second system data in an information linking database 12a (web database) (S205). As a result, the system data of the two standards (formats) can be stored in one system (also called a common system) as one standard. As a result, the second information linkage control processing is completed.
The third information linkage control processing starts with the completion of the second information linkage control processing as a trigger. First, as shown in
In the case where additional data (also referred to as third system data) corresponding to the information linking data is input with respect to the information linking data via the user interface displayed on the display unit 41 (S303; Yes), the transmitting unit 420 of the user terminal 40 may transmit additional data to the information linking server 10 (S305). Specifically, the user (the field worker) of the user terminal 40-2 may input attendance application data via the user interface of the common system. Alternatively, the user of the user terminal 40-1 (the employee of the management department of the cooperating company) may input various data such as input of aggregated data related to the dispatch status of workers via the user interface of the common system. The information linking server 10 receives the additional data transmitted from the user terminal 40 (S307).
Next, the data generation unit 150 associates the information linking data with each identifier to generate a dataset corresponding to the identifier (S309). In this example, an attendance dataset using the user identification number as an identifier is generated, as shown in
Next, the comparative analysis unit 160 compares and analyzes the generated dataset and the set value which is set to a predetermined condition (S313). More specifically, a difference between the overtime of the user and the actual out-of-time stay time based on the information of the attendance authorization time, as shown in
Next, as shown in
In this case, correction data for abnormal data may be input to the user terminal 40 (S325). When the correction data is transmitted to the information linking server 10 (S327), the acquisition unit 110 of the information linking server 10 acquires the correction data and may execute correction processing of the dataset (S329). In this case, the comparative analysis unit 160 may compare and analyze the modified dataset and the set value set to the predetermined condition (S331). If it exceeds the set value (S333; Yes), the process may return to the abnormal data extraction process (S317) again. As a result, the third information linkage control processing is completed.
As described above, systems can be easily and quickly linked by using the present embodiment. As a result, the attendance information of the user can be grasped in detail, and appropriate and efficient attendance management can be performed.
In the first embodiment of the present invention, although an example in which the systems provided in two system servers are linked is shown, the present invention is not limited thereto. In the present embodiment, an example of linking systems provided in three or more system servers will be described.
The third system server 60 includes a control unit 61, a storage unit 62, a communication unit 63, and a display unit 64. The control unit 61, the storage unit 62, the communication unit 63, and the display unit 64 are connected via a bus. In the present embodiment, the third system server 60 is composed of a plurality of information processing devices and is provided as a cloud server. The configuration of the third system server 60 is the same as that of the first system server 20, and therefore will not be described.
The third system server 60 includes various systems together with the third system. Various systems are executed on the FaaS in the third system server 60. In the present embodiment, a production management system is used as the first system, a sales support system is used as the second system, and a data analysis system is used as the third system.
In the present embodiment, when production data is input to the first system (production management system) of the first system server 20 via the user interface displayed on the user terminal 40-1 by the user of the user terminal 40-1 (for example, a person in charge of the production department), the user terminal 40-1 transmits the data to the first system server 20. The first system server 20 generates first system data (e.g., production management data relating to production plans and production performance). The user of the user terminal 40-2 (for example, a person in charge of the head office sales department) inputs negotiation data to the second system (sales support system) of the second system server 30 via the user interface displayed on the user terminal 40-2, and the user terminal 40-2 transmits the data to the second system server 30. The second system server 30 generates second system data (e.g., sales support data such as negotiation progress).
In the present embodiment, by converting the acquired first system data (production management data) and second system data (sales support data) into a common data format, the information linking data in which two system data are linked can be generated. As a result, it is possible to display various data as one system (common system). Therefore, the person in charge of the production department acquires the activity information of the sales department, and the person in charge of the sales department can easily grasp the inventory situation, and it is possible to promote the sales activity.
In the present embodiment, the information linking data may be associated with each identifier to generate a dataset corresponding to the identifier. In this example, a negotiation number is used as an identifier to generate a dataset corresponding to each negotiation number. As a result, the person in charge of the production department and the person in charge of the sales department can easily grasp the production volume data and the gross profit margin data for each case. Further, the dataset corresponding to each negotiation number and set value set in the predetermined condition may be compared and analyzed. For example, the profit margin may be set. In this case, the information linking server 10 may extract a low margin case as abnormal data, generate warning information (alert data), and transmit the warning information to the user terminal 40. As a result, the person in charge of the sales department and the person in charge of the production department can know cases where there is a low margin and can adjust the production volume for the product of these cases.
In the present embodiment, the analysis processing may be newly performed on the information linking data in which two system data are linked by using the analysis system. As a result, while the first system data and the second system data have conventionally had to be separated from each other and the analysis processing has to be executed, the data of the common system can be analyzed in detail as a whole.
In this embodiment, analysis processing by deep learning using machine learning processing or Artificial Intelligence (AI) in the analysis system may be performed to each dataset. As a result, it is possible to calculate the demand forecast data of the products for each project, and generate and transmit warning information for adjusting the production volume of the product expected to deviate significantly from the set value, and the person in charge in the production department can adjust the production volume from the warning information transmitted to the user terminal 40.
In the present embodiment, although an example in which the information linking system 1A uses the production management system as the first system, the sales support system as the second system, and the data analysis system as the third system is shown, the present invention is not limited thereto. The information linking system can also be used in financial related systems.
Specifically, a budget control system for supporting a company that starts up in business may be used as the first system, a sales support system may be used as the second system, and an accounting system may be used as the third system. In this case, a financial institution terminal is used as the user terminal 40-1, and a terminal of a loan customer company is used as the user terminal 40-2. The financial institution terminal obtains the balance data of a loan customer financial company from the budget control system.
In this case, by converting the budget control data of the budget control management system, sales performance data of the sales support system, and financial data of the accounting system into a common format, the data can be managed by one system (common system). In the case where the information linking data is associated with each identifier and a dataset corresponding to the identifier (e.g., the loan customer company number) is generated, the warning information may be transmitted to the user terminal 40-1 (financial institution terminal) when the abnormal data is extracted in the sales performance data (more specifically, the order/sales data). As a result, the financial institutions can acquire the latest information including the financial-related abnormal data in addition to the normal balance data. As a result, the financial institutions can improve the efficiency of management of the loan customer company and speed up performance judgment.
In the present embodiment, an information linking system and an information linking method different from those of the first embodiment and the second embodiment will be described in detail with reference to the drawings. Configurations similar to those of the first embodiment and the second embodiment will be appropriately omitted and explained.
An information linking server 10B has an information linkage control unit 100B that controls a program (information linking program) that realizes the information linkage function. The information linkage control unit 100 includes an acquisition unit 110B, a data conversion unit 120B, the conversion data storage unit 130, the transmitting unit 140, a data generation unit 150B, the comparative analysis unit 160, the abnormal data extraction unit 170, and the warning information generation unit 180. Each of the acquisition unit 110B, the data conversion unit 120B, the conversion data storage unit 130, the transmitting unit 140, the data generation unit 150B, the comparative analysis unit 160, the abnormal data extraction unit 170, and the warning information generation unit 180 in the information linking server 10B may be executed as a FaaS.
The acquisition unit 110B has a function of acquiring various data in the information linking system. In this example, the acquisition unit 110B acquires the first system data transmitted from the transmitting unit 220 of the first system server 20 and the second system data transmitted from the transmitting unit 320 of the second system server 30.
The data conversion unit 120B collates the face information stored in the database with the captured face information and identifies the target user. As a result, the data conversion unit 120B converts the captured face information into the identified username (user identification number). Thus, the data of the face authentication system is associated with the username (or the user identification number).
In this case, in the face authentication system, the attendance time and the leaving time of the user are authenticated based on the identified username (user identification number) and time information.
The data conversion unit 120B has a function of converting the first system data and the second system data into a common data format. In this example, the data conversion unit 120B converts the first system data and the second system data into CSV format. Thus, the conversion data storage unit 130 can store the first system data and the second system data in the database as one set of data (attendance dataset).
The data generation unit 150B associates the first system data and the second system data with each identifier to generate statistical data.
The data generation unit 150B generates analysis data.
(3-2. Information linkage control processing)
Next, information linkage control processing based on instructions by the information linking program in the information linkage control 100B will be described.
As shown in
When the first system server 20 receives the data input by the user terminal 40-1 (S107B), the first system server 20 executes data processing. Thus, the first system data is generated (S109B). The generated first system data is stored in the storage unit 22 of the first system server 20 (S111B). In this case, as shown in
When the second system server 30 receives the data input by the user terminal 40-2 (S113B), the second system server 30 executes data processing (S115B). Thus, the second system data is generated. The generated second system data is stored in the storage unit 32 of the second system server 30 (S117B). In this example, face authentication system data is generated as shown in
The second information linkage control processing S200B starts with the completion of the first information linkage control processing S100B as a trigger. As shown in
The data conversion unit 120B collates the face information of the user with the captured face information among the second system data (face authentication system data) stored in the database and identifies the target user. In this case, the data conversion unit 120B converts the face information into the identified username (user identification number) (S202B). Thus, the face authentication system data (attendance authentication data) related to the identified user is generated as shown in
The data conversion unit 120 executes conversion processing of the data format such that the acquired first system data and the second system data have a common data format (S203B). The data conversion unit 120 converts the first system data and the second system data into CSV format.
Next, the conversion data storage unit 130 stores the converted first system data and second system data in the information linking database 12a (web database) (S205B). In this case, the system data of the two standards (formats) can be stored in one system (also referred to as a common system) as one standard. As a result, the second information linkage control processing S200B is completed.
The third information linkage control processing S300B starts with the completion of the second information linkage control processing S200B as a trigger. As shown in
Further, the data generation unit 150B statistically processes the first system data and the second system data in association with the first identifier to generate statistical data as shown in
Similarly, the data generation unit 150B calculates the user's daily out-of-time stay time by processing the user's attendance time, the leaving time, and the predetermined working time as numerical data among the converted face authentication system data. The generation unit 150B calculates (adds) the calculated out-of-time stay time data to calculate the total out-of-time stay time data in July 2020 associated with the username (user identification number).
The data generation unit 150B may generate analysis data by statistically processing the first statistical data and the second statistical data when the health condition of the user satisfies a predetermined condition (S311B). Specifically, the user's overtime data and the actual attendance authentication data are calculated, and the difference in the out-of-time stay time may be calculated, as shown in
Next, the comparative analysis unit 160 compares and analyzes the generated dataset and the set value which is set to a predetermined condition (S313B). In this case, a set time of 15 hours or less is set as the predetermined condition. In the case where the difference does not exceed the set time (S315B; No), the third information linkage control processing S300B is completed. In the case where the difference exceeds (deviates from) the set time (S315B; Yes), the data is judged as abnormal data. In
As described above, systems can be easily and quickly linked by using the present embodiment. By using the present embodiment, the attendance information of the user can be grasped in detail, and attendance management can be performed in association with the health information.
In the present embodiment, an example in which the location name is used as the second identifier in the face authentication system is shown. However, the present invention is not limited thereto. For example, GPS information or map information may also be used. The second identifier in the second system may include environmental information.
In the present embodiment, although an example in which a health condition (body temperature) is acquired is shown, the present invention is not limited thereto. For example, blood pressure information or heart rate may also be used.
In the present embodiment, an example in which the analysis data is generated based on the health condition is shown. However, the present invention is not limited thereto. For example, the analysis data may be generated when the environmental information (outside air temperature) satisfies a predetermined condition (when the environmental data exceeds the set value). For example, the analysis data may be generated when the outside air temperature is 30° C. or more. This makes it possible to judge whether the user's labor situation is appropriate in response to changes in the environment. The analysis data may be generated when each of the user's body temperature and the outside air temperature satisfies the set value. As a result, attendance management can be performed according to a complex variable factor such as the user's physical condition and environment.
In the present embodiment, an example in which the data conversion unit 120B performs calculation processing for converting the first system data and the second system data into a common data format after the face information is converted into a username (user identification number) is shown. However, the present invention is not limited thereto. The data conversion unit 120B may convert the face information into the username (user identification number) after the conversion processing into the common data format while only the face information is retained at the stage of the conversion processing into the common data format.
The data conversion unit 120B does not need to convert all the data of the first system data and the second system data into one data format (CSV format). For example, the numerical data may be CSV format, and the image data may be converted according to the data format, such as JPEG format. As a result, it is possible to link a plurality of system data more effectively.
In the case where the difference between the body temperature (or average body temperature) and the outside air temperature satisfies a predetermined condition, overtime (or total overtime), out-of-time stay time (or total out-of-time stay time), and the difference between the out-of-time stay time and the overtime may be assessed, respectively. For example, there is a case where the difference between the body temperature and the outside air temperature is 7° C. or less or 37° C. or more as a predetermined condition. Specifically, a summer day or a mid-winter day is assumed. In the case of these conditions, fatigue or the burden on workers may be higher than usual. Therefore, more thorough labor-management (reduction of overtime and stay time) of workers is required. Therefore, by using the present embodiment, it is possible to perform more appropriate labor management in consideration of not only the health condition of the individual user but also the influence of the work environment.
The set time may be changed based on the outside air temperature. Therefore, the set time may be shortened when the outside air temperature is high or low. This makes it easier to grasp abnormalities in working conditions in severe environments. As a result, more appropriate labor management can be performed in consideration of the influence of the work environment, and good health conditions of the worker can be maintained.
In the present embodiment, an example of generating monthly analysis data is shown. However, the present invention is not limited thereto. For example, out-of-time stay time and overtime of the previous day, and the difference data (analysis data) thereof may be generated when the body temperature and the temperature are higher than the set value. As a result, it is possible to judge the real-time health condition and the labor situation of the worker in association with each other.
In the present embodiment, the user may input additional information into the user terminal 40-2. For example, a field supervisor may perform a patrol check of field workers and input labor situation data into the attendance system. For example, the labor situation may be input in three stages: good “1” to bad “3”. The labor situation data can be converted into a common data format. In the case where bad “3” is acquired as the labor situation, the analysis data may be generated. As a result, it is possible to judge the supervisory status of workers by the field supervisor and the real-time health condition and the labor situation of the worker in association with each other.
Although an example in which the face information captured in the present embodiment is used for the authentication of the worker is shown, the face information may be used for estimating the degree of fatigue of the worker. The degree of fatigue may be determined based on preset information such as the color of the face, the swelling of the eyelids, the degree of slack of the cheeks, and the like. The degree of fatigue may be calculated as numerical information in three stages: good “1” to bad “3”. The degree of fatigue can be converted into a common data format. In the case where bad “3” is acquired as the degree of fatigue, the analysis data may be generated. As a result, it is possible to judge the real-time health condition and the labor situation of the worker in association with each other.
In the present embodiment, the statistical data may be used as the analysis data.
(Modifications) Within the spirit of the present invention, it is understood that various changes and modifications can be made by those skilled in the art and that these changes and modifications also fall within the scope of the present invention. For example, the addition, deletion, or design change of components as appropriate by those skilled in the art based on each embodiment are also included in the scope of the present invention as long as they are provided with the gist of the present invention.
In the first embodiment of the present invention, an example in which the information linking server 10, the first system server 20, and the second system server 30 are provided as separate cloud servers is shown. However, the present invention is not limited thereto. For example, two cloud servers of the information linking server 10, the first system server 20, and the second system server 30 may be combined, or three cloud servers may be integrated. The information linking server 10, the first system server 20, and the second system server 30 are not limited to cloud servers, and may be web servers, virtual servers, or physical servers.
In the first embodiment of the present invention, an example in which the information linking server 10, the first system server 20, and the second system server 30 are composed of a plurality of information processing devices is shown. However, the present invention is not limited thereto. The information linking server 10, the first system server 20, and the second system server 30 may be composed of one information processing device. In this case, the server of each system may be provided independently.
In the first embodiment of the present invention, an example in which the data conversion unit 120 converts the first system data and the second system data into the CSV format is shown. However, the present invention is not limited thereto. For example, the data conversion unit 120 may convert the first system data and the second system data into a Java format or may convert them into a common format.
In the first embodiment of the present invention, an example in which the first system data and the second system data are converted and then stored in the information linking database is shown. However, the present invention is not limited thereto. For example, the first system data and the second system data may be acquired and then stored in the information linking database 12a.
In the first embodiment of the present invention, an example in which additional data (third system data) is transmitted from the user terminal 40 (the user terminal 40-1) to the converted first system data and second system data (information linking data), and the information linking server 10 acquires the additional data is shown. However, the present invention is not limited thereto. Further, when the information linking server 10 acquires the additional data, the information linking server 10 may include a data reconversion unit that reconverts the additional data into the first system data (attendance management data) of the first system (for example, the attendance management system) for transmitting to the user terminal 40-2 (the second user terminal) different from the user terminal 40-1.
In the first embodiment, an example in which the transmitting unit 220 of the first system server 20 transmits the first system data after a lapse of a predetermined time is shown. However, the present invention is not limited thereto. For example, the second system data may be transmitted when reaching a certain amount of data. Alternatively, it may be transmitted when receiving transmission instruction information from the information linking server 10.
Similarly, although an example in which the transmitting unit 320 of the second system server 30 transmits the second system data after a lapse of a predetermined time is shown, the present invention is not limited thereto. For example, the second system data may be transmitted when reaching a certain amount of data. Alternatively, it may be transmitted when receiving the transmission instruction information from the information linking server 10.
In the first embodiment of the present invention, an example in which the information linking server 10 receives the first system data and the second system data is shown. However, the present invention is not limited thereto. For example, in the case where the information linking server 10 and the first system server 20 or the second system server 30 are integrated, the acquisition unit 110 may quickly acquire the first system data or the second system data by direct acquisition.
| Number | Date | Country | Kind |
|---|---|---|---|
| 2020-086289 | May 2020 | JP | national |
This application is a Continuation of International Patent Application No. PCT/JP2021/018382, filed on May 14, 2021, which claims the benefit of priority to Japanese Patent Application No. 2020-086289, filed on May 15, 2020, the entire contents of which are incorporated herein by reference.
| Number | Date | Country | |
|---|---|---|---|
| Parent | PCT/JP2021/018382 | May 2021 | US |
| Child | 17979086 | US |
