WO2008038364A1 - Work assisting program - Google Patents

Abstract

[PROBLEMS] To provided a work assisting program leading to reduction of the labor and time needed for alteration. [MEANS FOR SOLVING PROBLEMS] A work assisting program run on server computers (3, 4) for assisting the worker to work by distributing work instructions to a worker's terminal (1). The work assisting program comprises a data processing program, a database having a real table whose column-direction structure is fixed, which has a creating key item, as a column item, where a creating key for creating a virtual table is stored, and whose structure is unchanged even when the work assisting program is altered, a real table access program, and a data mapping API including a virtual table creating step of creating the virtual tables from the real table according to the creating key and an interface step of enabling the data processing program to access the virtual tables created by the virtual table creating step as normal real tables.

Description

 Specification

 Work support program

 Technical field

 [0001] The present invention relates to a work support program executed in a work support server for supporting a worker's work.

 Background art

 [0002] Conventionally, as a work support program for supporting these workers, a visit schedule and re-work instruction information as work instructions are transmitted to the worker, and a visit work of a field operator as a worker is performed. (For example, see Patent Document 1), and at the work site, an operator can obtain various data such as work process data by using a server computer (for example, Patent Document 2). reference).

 [0003] Patent Document 1: Japanese Patent Laid-Open No. 2005-339303 (page 5, FIG. 1)

 Patent Document 2: JP 2002-287846 A (Page 9, Fig. 5)

 Disclosure of the invention

 Problems to be solved by the invention

[0004] In the work support program executed on the server computer to implement these work support, changes such as change or increase of workers, increase or decrease of work contents or items, increase or decrease of work base or monitoring items, etc. However, there are many problems compared to normal processing programs, and there is a problem that if the changes are not made quickly, the actual work and work will be hindered. However, in these work support programs in the past, as shown in Fig. 17, program changes can be made in accordance with changes in the configuration of individual tables in the database or changes in the configuration of these tables. In addition to the need to change the SQL statement for accessing (searching, registering, changing, deleting) the table, each processing program that uses these SQL statements is also required. It is also necessary to make changes to each ram, and it is necessary to implement changes while verifying individually whether one change does not adversely affect other changes or processing programs. The problem is that it takes a lot of labor and time to meet the above requirements. There was a title.

 [0005] The present invention has been made paying attention to such problems, and an object thereof is to provide a work support program capable of reducing labor and time required for the change.

 Means for solving the problem

[0006] In order to solve the above problem, the work support program according to claim 1 of the present invention is a worker terminal (notebook computer 1) that can be operated and carried by a worker who goes to the work site and performs work. ) And data communication, and electronic documents (work instruction mails, work instructions, manuals, etc.) in which various types of information related to work performed at the work site are digitized are delivered to the worker terminals. A work support program (invention type program) that runs on a server computer (work support server 3, central monitoring server 4) that supports the work,

 A data processing program (data processing program) for performing data processing related to the work support;

 Generated key item in which the structure in the column direction (four items in this embodiment) is fixed, and the generated key for generating the virtual table (temporary table) used by the data processing program is stored as the column item A database having at least one real table having at least (table name, key, item number in the real table) and whose structure is unchanged even when the work support program is changed,

 A real table access program (actual table access program) for accessing a real table in the database;

A virtual table generation step (real table) for generating a plurality of virtual tables based on the generation key stored in the generation key item of the real table using the real table access program. All data with the same table name is grouped based on whether or not the key values are the same, and item values of multiple data grouped based on these key values The items are arranged in a horizontal row in numerical order, and the item values arranged in the horizontal row are sequentially arranged downward every time the key value changes), and the virtual table generated in the virtual table generation step is displayed. The data processing program is a normal real table and Interface step (processing to make one real table accessible as multiple temporary tables by using one temporary table with objects corresponding to each temporary table and its methods) Program (data mapping

API)

 It is characterized by being composed of power.

 According to this feature, even if the program needs to be changed, the interface program should be mainly changed so that the virtual table generated by the virtual table generation step becomes a virtual table corresponding to the change. Since the configuration of the actual table and the actual table access program need not be changed, the labor and time required for the change can be reduced.

[0007] A work support system according to claim 2 of the present invention is the work support program according to claim 1,

 In order to add, change, or delete items of the virtual table (temporary table) according to the change, at least the interface program (data mapping) based on predetermined data mapping data created by the change operator It includes an automatic update program that automatically updates API).

 According to this feature, the interface program is changed by using the predetermined data mapping data and the automatic update program instead of directly changing the interface program by the operator. Since it is only necessary to input the contents, it is possible to carry out these changes more easily and accurately than the case of directly changing the interface program, in which problems such as bugs due to mistakes in the change work are less likely to occur. In addition, it is possible to reduce the occurrence of inconvenience due to mistakes in the automatic update program that do not need to identify the automatic update program corresponding to the change of the work support program.

[0008] A work support system according to claim 3 of the present invention is the work support program according to claim 1 or 2,

The automatic update program updates the actual table based on the data mapping data (in the case of item addition / change / deletion, the table is updated). It is characterized in that for all data with the same name, one item is added / changed / deleted for each data grouped by the key value.

 According to this feature, the actual table update such as additional registration of the generated key to the real table based on the change is also automatically performed by the automatic update program, so that the labor and time required for the change can be further reduced. .

 [0009] A work support system according to claim 4 of the present invention is the work support program according to any one of claims 1 to 3,

 The data mapping data is included.

 According to this feature, the data mapping data used for the previous change can be easily obtained by including the data mapping data used for the previous change in the work support program to be changed. Even if a new change is made, these data mapping data can be easily used, so that the labor and time required for the change can be further reduced.

[0010] A work support system according to claim 5 of the present invention is the work support program according to any one of claims 1 to 4,

The server computer (work support server 3, central monitoring server 4) is connected to a support terminal (PC 2) that can be operated by a work support person who supports work by the worker so as to be able to perform data communication. The worker terminal (notebook computer 1) is provided with an imaging means (worker terminal camera 101) for capturing an image at the work site. The processing program (invention type program) is the electronic document (work program). A work instruction electronic document (work instruction mail, work instruction) including at least information on the work contents that the worker should work on (work instruction mail) as the instruction mail, work instruction, manual, etc. The work instruction electronic document transmission process step (work instruction mail transmission process, work instruction document transmission process) to be transmitted to the worker terminal and the operator's support request operation (support request) The worker terminal video data (worker terminal camera video) of the image captured by the imaging means transmitted from the worker terminal in response to the operation of the worker terminal is identified as a work supporter who supports the work. And processing for transmitting to the supporter terminal of the identified work supporter It is characterized in that it includes a worker terminal video data transmission step and (relay / recording start processing).

 According to this feature, the work supporter can perform work support while confirming the worker terminal image on the worker terminal on the supporter terminal, and the worker can provide more accurate work support. Be able to receive from supporters.

 The work support system according to claim 6 of the present invention is the work support program according to any one of claims 1 to 5,

 The server computers (work support server 3 and central monitoring server 4) are connected to the monitoring cameras permanently installed at the work site (permanent monitoring cameras 5a, 5b, 5c) so that data communication is possible, and are connected to the database. Surveillance camera identification information (permanent surveillance camera ID) that can identify each surveillance camera individually and site identification information (location number, work number, support number) that can identify the work site where the surveillance camera is permanently installed The work instruction electronic document (work instruction mail, work instruction) stores the work site identification information (base number, work number) of the work site where the worker should work. The processing program includes, in the worker terminal video data transmission step (relay / recording start process), in response to the support request operation (operation of the support request button). Monitoring camera that is stored in association with the on-site identification information included in the received support request information in response to receiving the on-site request information including the on-site identification information (work number) transmitted from the personal computer 1) The identification information is specified, and the monitoring video data (permanent monitoring camera video) of the video captured by the monitoring camera identified from the specified monitoring camera identification information, and the imaging means (worker terminal camera) of the worker terminal 101) Processing for transmitting worker terminal video data (worker terminal camera video), which is the image captured in step 101), to the above-described support terminal (PC 2) of the work supporter (relayed video recording) It is characterized by performing start processing.

According to this feature, the monitoring video data of the surveillance camera that is permanently installed at the work site identified from the site identification information included in the support request information of the worker terminal power and the worker by the imaging means of the worker terminal The terminal video data is transmitted to the supporter terminal of the identified work supporter, and the monitoring camera video and the worker terminal video based on the monitoring video data are transmitted. Since the worker terminal video based on the data is displayed on the supporter terminal, the work supporter can easily obtain the surveillance camera video that is a wide range of on-site video and respond to the situation at the site. Judgment and instructions can be implemented more accurately.

Brief Description of Drawings

FIG. 1 is a system diagram showing an overview of a work support system.

FIG. 2 is a block diagram showing a configuration of a permanent monitoring camera.

FIG. 3 is a diagram showing a permanent monitoring camera table stored in a work support server.

FIG. 4 is a diagram showing a central monitoring server table stored in the work support server.

[FIG. 5] (a) is a diagram showing a permanent monitoring camera recording information table stored in the work support server, and (b) is a diagram showing an abnormality information table stored in the work support server.

[Fig. 6] (a) is a diagram showing a work instruction table stored in the work support server, (b) is a diagram showing a work status table stored in the work support server, and (c) is a diagram showing the work support server. (D) is a diagram showing a support status table stored by the work support server, and (e) is a supporter table stored by the work support server. It is a figure, (f) is a figure which shows the worker table which a work assistance server memorize | stores.

 FIG. 7 shows a support history information table stored in the work support server.

 FIG. 8 is a diagram showing a supporter screen displayed on a personal computer as a supporter terminal.

 FIG. 9 is a diagram showing a flow of processing for simultaneously displaying the video of the permanent monitoring camera and the video of the worker terminal camera on the personal computer.

 FIG. 10 is a diagram showing a flow of processing for displaying an abnormal video on a personal computer.

 FIG. 11 is a diagram showing a flow of processing for displaying the video of the worker terminal camera while the notebook personal computer as the worker terminal is offline on the personal computer.

 [Fig.12] Shows the detailed flow of processing performed by the work support server and worker terminal in the process of displaying the video of the worker terminal camera while the notebook computer, which is the worker terminal, goes offline on the personal computer. FIG.

FIG. 13 is a diagram showing a flow of processing for causing a personal computer to annotate the video of the worker terminal camera. FIG. 14 is a diagram showing a flow of processing for causing a personal computer to add an annotation to the video of a permanent monitoring camera.

 FIG. 15 is a diagram showing a flow of processing for displaying a support history on a personal computer.

 FIG. 16 is a diagram showing a detailed flow of processing performed by the work support server in processing for displaying support history on a personal computer.

 [Figure 17] This is a diagram showing the flow of procedures when changing, adding, or deleting functions in the work support system.

 [FIG. 18] (a) is a flowchart showing the flow of processing before the change of the screen generation processing to be changed, and (b) is a flowchart showing the flow of processing after the change.

 [FIG. 19] (a) is a diagram showing a configuration after the change of the permanent surveillance camera table to be changed.

(B) is a figure which shows the model information table added.

 FIG. 20 is a diagram showing a configuration after the change of the supporter screen to be changed.

 [Fig. 21] (a) is a diagram showing the configuration before the change of the real table to be changed, (b) is a diagram showing the configuration before the change of the data mapping data to be changed, (c ) Is a diagram showing the configuration after the actual table is changed, and (d) is a diagram showing the configuration after the data mapping data is changed.

 [FIG. 22] (a) is a diagram showing a configuration before change when the processing program to be changed is a conventional type, and (b) is a change when the processing program to be changed is of the present invention type. It is a figure which shows the former structure, (c) is a figure which shows the structure after a change of a conventional type program, (d) is a figure which shows the structure after a change of this invention type program.

 [Fig. 23] (a) is a diagram showing the configuration after the change of the work instruction camera table to be changed in the second function tracking, and (b) is a diagram showing the added supervisor table. It is.

[Fig. 24] (a) is a diagram showing the configuration before the change of the real table to be changed in the second function tracking, and (b) is the data before the change of the data mapping data to be changed. FIG. 4C is a diagram showing a configuration after changing the real table, and FIG. 4D is a diagram showing a configuration after changing the data mapping data.

Explanation of symbols

1 Laptop (worker terminal) 2 PC (Supporter terminal)

 3 Work support server (server computer)

 4 Central monitoring server (server computer)

 5a, 5b, 5c "'Permanent surveillance camera

 6 Internet network

 7 router

 8 Mobile phone network

 101 Worker terminal camera

 102 Worker terminal display

 103 Worker terminal microphone

 104 Worker terminal speaker

 201 Supporter terminal camera

 202 Supporter terminal display

 203 Supporter microphone

 204 Supporter terminal speaker

 501 Control microcomputer

 502 External IZO

 503 communication unit

 504 CCD camera

 BEST MODE FOR CARRYING OUT THE INVENTION

[0014] Examples of the present invention will be described below.

 Example

 An embodiment of the present invention will be described with reference to the drawings. First, FIG. 1 is a system diagram showing an overall image of a work support system in an embodiment of the present invention.

As shown in FIG. 1, the work support system of the present embodiment includes a notebook personal computer 1 serving as a worker terminal of the present invention, a personal computer 2 serving as a supporter terminal of the present invention, and a server combination of the present invention. The work support server 3 serving as a computer, a plurality of central monitoring servers 4 serving as server computers of the present invention, and permanent monitoring cameras 5a, 5b, 5c, serving as surveillance cameras of the present invention, are also mainly configured. They are connected to each other via the Internet network 6 so as to be able to communicate with each other.

[0017] Specifically, the notebook PC 1 is carried by a worker at a work execution place (hereinafter referred to as a base) to be supported by the work support system, and is connected to the Internet network 7 at the base. Must be accessible. For this reason, the notebook PC 1 is equipped with a data communication card that allows wireless access to the mobile phone network 8 provided by the mobile phone company, and this data communication card connects to the Internet network 6 via the mobile phone network 8. I can do it. The computer 2, the work support server 3, and the central monitoring server 4 are installed in a provider that provides work support services using this work support system and are connected to the Internet network 6 via the router 7. Yes. Permanent surveillance cameras 5a, 5b, 5c,... Are installed at each base and are directly connected to the Internet network 7.

[0018] It should be noted that these devices only need to be connected to the Internet network 6 so that data communication is possible, and the communication means for carrying out data communication with each device power S Internet network 6 is appropriately selected. Just do it.

 [0019] The notebook personal computer 1 of the present embodiment includes an operator terminal input unit such as a keyboard, an operator terminal display unit 102 configured by a liquid crystal display that forms the video and audio output device of the present invention, and the present invention. Data communication, worker terminal microphone 102 serving as the voice input means, worker terminal speaker 104 constituting the video / audio output device of the present invention, worker terminal control unit such as CPU, RAM, ROM, etc. It consists of a worker terminal communication unit for connecting cards and various devices, a worker terminal storage unit such as a hard disk (HDD), and a normal notebook computer composed of power. The worker terminal communication unit of the notebook computer 1 is connected with a data communication card capable of performing two-way wireless data communication with the mobile phone network 8 and a worker terminal camera 101 serving as an imaging means of the present invention. Yes.

In addition, the personal computer 2 that can be operated by the supporter used in the present embodiment includes a supporter terminal input unit including a keyboard and a mouse, and a supporter terminal display unit such as a liquid crystal display that is a display device of the present invention. 202, a supporter terminal microphone 202 serving as a voice imaging unit of the present invention, a worker terminal speaker 204 serving as a voice output device of the present invention, a supporter terminal control unit including a CPU, RAM, ROM, and the like, data It is an ordinary computer that consists of a supporter terminal communication unit for connecting a communication card and various devices, a supporter terminal storage unit, and power. A data communication card and a supporter terminal camera 201 serving as a voice imaging unit of the present invention are connected to the supporter terminal communication unit of the personal computer 2.

 [0021] The work support server 3 according to the present embodiment includes a work support server control unit including a CPU, a RAM, a ROM, and the like, a work support server communication unit for data communication via the Internet network 7, and various types described below. The server is a normal server computer having a relatively high processing capability and a work support server storage unit for storing information.

 [0022] The central monitoring server 4 of this embodiment includes a central monitoring server control unit including a CPU, RAM, ROM, and the like, a central monitoring server communication unit for data communication via the Internet network 7, and a central monitoring server In this embodiment, a large number of permanent monitoring cameras 5a, 5b, 5c,... In order to manage the images from the permanent surveillance cameras 5a, 5b, 5c ..., multiple central surveillance sanos are used, and a central surveillance sano ID is assigned to each central surveillance sano, but the present invention is not limited to this. However, the number of central monitoring servers 4 may be appropriately selected according to the number of bases, the number of permanent monitoring cameras, the processing capacity of the server computer to be used, and the like.

 As shown in FIG. 2, the permanent monitoring cameras 5a, 5b, and 5c of the present embodiment include a control microcomputer 501 that has CPU, RAM, and ROM power, an external IZO 502 that connects various devices, A communication unit 503 for data communication via the Internet network 7, a CCD camera 504 for imaging the base, and power are also configured. The external IZO502 is connected with various sensors for detecting abnormalities at the site.

Here, the abnormality detection at the base will be described. As sensors connected to these permanent surveillance cameras 5a, 5b, 5c ..., sensors that can output predetermined abnormal states with signals can be used. Specifically, the open state of the door is detected. Door sensor, temperature sensor that detects that the temperature is above a certain level, switch that detects the off state of various switches, voltage sensor that detects that the voltage has fallen below a certain voltage, and detects that a person is within a specified range A motion sensor or a motion detection sensor that detects that there has been a change in the area beyond the specified range in the video can be used. The present invention is not limited to these sensors and switches, but may be a sensor that monitors the lighting state of an LED and outputs an abnormality. These sensors may be appropriately selected according to the content of the abnormality to be detected.

 [0025] FIGS. 3 to 8 are diagrams showing various types of information for supporting a worker who goes to a base and performs work, and are stored in the work support server storage unit of the work support server 4 of the present embodiment. ing.

 FIG. 3 is a diagram showing a permanent monitoring camera table stored in the work support server 3. In the permanent monitoring camera table, the permanent monitoring cameras 5a, 5b, 5c,... Are associated with the permanent monitoring camera ID, which is identification information that can be individually identified, and the identification information of the base where the permanent monitoring camera is installed. The base number, the central monitoring server ID that is the identification information of the central monitoring server 4 that manages the permanent monitoring camera, the video description that is the description of the video taken by the permanent monitoring cameras 5a, 5b, 5c, etc. It is remembered.

 FIG. 4 is a diagram showing a central monitoring server table stored in the work support server 3.

 The central monitoring server table stores the permanent monitoring camera ID in association with the central monitoring server ID and the site number.

 [0028] With the tables shown in FIGS. 3 and 4, the base number and the central monitoring server ID can be uniquely specified based on the permanent monitoring camera ID. Also, based on the site number, the permanent surveillance camera ID (usually multiple) installed at the site can be identified. Also, based on the central monitoring server ID, the permanent monitoring camera ID (usually a plurality) managed by the central monitoring server can be identified.

 FIG. 5A is a diagram showing a permanent monitoring camera recording information table stored in the work support server 3. In the permanent monitoring camera recording information table, in association with the permanent monitoring camera ID, the start time when recording of the captured video is started in the permanent monitoring cameras 5a, 5b, 5c, and the file in which the recorded video is stored are accessed. Recording data, which is nose data for recording, and are stored. Using this table, recorded video can be identified based on the permanent surveillance camera ID and start time.

FIG. 5B is a diagram showing an abnormality information table stored in the work support server 3. In the error information table, the error time, which is the time when an error was detected at the site, is associated with the site number, and the signal input to the permanent monitoring cameras 5a, 5b, 5c ... The state is stored. This table is based on the site number Thus, it is possible to specify the abnormal time and abnormal content (there may be multiple cases).

 FIG. 6A shows a work instruction table stored in the work support server 3. The work instruction table is associated with the work number, which is identification information of the work performed by the worker at the site, and the supporter ID, which is the identification information of the support person in charge of supporting the work. The worker ID, which is the identification information of the worker in charge of the work, the base number of the base where the work is performed, and the work content that is an explanatory text of the content of the work are stored. This table can uniquely identify the supporter, worker ID, and site number based on the work number.

 FIG. 6 (b) is a diagram showing a work state table stored in the work support server 3. In association with the work number, the work state of the work and the update time of the work state are stored. The working state in the present embodiment is any of the following: unstarted, working, problem occurred, or completed. With this table, the work state can be uniquely specified based on the work number.

 FIG. 6 (c) is a diagram showing a support request form table stored in the work support server 3. In the support request form table, the work of the work subject to the support is associated with the support number that is the identification information of the support performed by the support person for the worker performing the work at the site. The number and the content of the support request, which is an explanation of the reason for requesting the support by the worker in charge of the work to be supported, are stored.

 FIG. 6D shows a support state table stored in the work support server 3. The support status of the support and the update time of the support status are stored in association with the support number. The support status in the present embodiment is any of support request issued, support in progress, problem occurrence, or completion. This table allows the support status to be uniquely identified based on the support number.

 FIG. 6E is a diagram showing a supporter table stored in the work support server 3. In the supporter table, a supporter terminal, which is identification information of the supporter terminal camera 201 mounted (connected) to the personal computer 2 used for work support by the supporter, is associated with the supporter ID. Camera ID is stored. Although not shown, the e-mail address of the supporter is also stored.

FIG. 6 (f) is a diagram showing a worker table stored in the work support server 3. worker In the table, the worker terminal camera ID, which is the identification information of the worker terminal camera 101 mounted (connected) to the laptop computer 1 used by the worker for the work, is associated with the worker ID. It is remembered. Although not shown, the e-mail address of the worker is also stored.

 FIG. 7 is a diagram showing a support history information table stored in the work support server 3. The support history information table stores a plurality of pieces of information related to work support that has been performed so far. Specifically, for each work support, base number, central monitoring server ID, permanent monitoring camera ID, worker terminal camera ID, supporter ID, worker ID, work number, support number, permanent monitoring camera 5a, 5b, 5c ... Permanent surveillance camera video, which is the nose data for accessing the file containing the captured video, and worker, the pass data for accessing the file containing the video captured by the worker terminal camera 101 The terminal camera video, start time, and end time are stored.

 Although not shown, a base table is also stored, and data relating to each base such as the base address and access information by transportation is stored in association with the base number.

 As described above, in this embodiment, the work number and the site number are uniquely associated with each other based on the work instruction table (FIG. 6 (a)). That is, the site number that is the site identification information is the site identification information that can identify the work site (site) in the present invention. Included in specific information.

 [0040] Based on the configuration described above, the flow in which the work support system of the present embodiment performs the work support of the worker will be described in detail below with reference to FIGS. Go.

FIG. 8 is a diagram showing a supporter terminal screen displayed on the personal computer 2 that is a supporter terminal. Base information for displaying a map of Japan Z Anomaly information area (upper left of the screen), work instruction area for displaying work instructions (lower left of the screen), and button areas for displaying various buttons for support ( The upper right part of the screen), the worker terminal camera area that displays the captured video of the worker terminal camera 101 (the right middle part of the screen), and the permanent surveillance camera area that displays the captured video of the permanent surveillance cameras 5a, 5b, 5c… The lower right corner of the screen) Display time and display method Will be described later together with the flow of processing.

 [0042] Note that the worker terminal screen displayed on the notebook personal computer 1 which is the worker terminal is not particularly illustrated, but, like the supporter terminal screen of the personal computer 2 operated by the supporter, Supporter terminal camera area for displaying the captured video of the support terminal camera 201 of the supporter, permanent monitoring camera area for displaying the captured video of the permanent monitoring powers 5a, 5b, 5c, etc., own worker terminal camera 101 In addition to the camera area of the operator's terminal that displays the captured video, a button area that displays various buttons necessary for the progress of the work and various buttons for requesting support, and the progress of the work. It also has a procedure display area for displaying the work contents of each process.

 [0043] First, the flow in which an abnormality is detected at each site where the permanent monitoring cameras 5a, 5b, 5c,... Are installed and an abnormal video is displayed on the personal computer 2 of the supporter will be described with reference to FIG. .

 [0044] As described above, various sensors are connected to the permanent monitoring cameras 5a, 5b, 5c,..., Which are permanently installed at the respective bases of this embodiment, and the permanent monitoring cameras 5a, 5b, 5c,. Sensor information transmission processing is performed in which sensor information that can identify the output state of the output signal is always transmitted to the central monitoring server 4 at predetermined time intervals together with the permanent monitoring camera ID and camera video data.

 [0045] The central monitoring server 4 that has received this sensor information performs an abnormality detection process for detecting whether there is an abnormality based on the sensor information. If no abnormality is detected in the abnormality detection process, the process ends and no processing is performed. On the other hand, if an abnormality is detected in the abnormality detection process, the following processing is performed. To implement.

 [0046] The central monitoring server 4 that has detected an abnormality, for example, a temperature abnormality in this way, detects abnormality detection information including sensor information including the permanent monitoring camera IDs of the permanent monitoring cameras 5a, 5b, 5c,. Send to work support server 3.

[0047] The work support server 3 that has received the abnormality detection information associates the base number stored in the permanent monitoring camera table (Fig. 3) with the supporter camera ID associated with the permanent monitoring camera ID included in the abnormality detection information. An anomaly detection email that identifies an email address (not shown) and sends an anomaly detection email that includes the site number to the supporter who should respond to the anomaly information Perform the process.

 [0048] It should be noted that all the supporters may be specified as supporters to be associated with the abnormality information, or a newly created base table in which the base number and the supporter ID are registered in association with each other, Based on this table, the corresponding supporter may be identified according to the base. A certain person creates a responsible abnormality table that newly registers sensor information (or an error code indicating individual abnormality) and a supporter ID, and makes the corresponding supporter abnormal based on this table. It may be specified accordingly.

 Furthermore, the work support server 3 newly registers abnormality information in the abnormality information table (FIG. 5 (b)). Specifically, the base number, abnormal time, and sensor information are registered. The abnormal time is the current time.

 [0050] On the other hand, the central monitoring server 4 transmits the abnormality detection information to the work support server 3, and immediately after that, the abnormal monitoring mode video is required for the permanent monitoring cameras 5a, 5b, 5c,. Send a request. An abnormal mode video is a video whose video quality is higher than that of video data normally transmitted to the central monitoring server 4.

 [0051] The permanent monitoring cameras 5a, 5b, 5c, ... that have received the abnormal mode video request transmit the abnormal mode permanent monitoring camera video to the central monitoring server 4.

 [0052] The central monitoring server 4 that has received the permanent monitoring camera video in the abnormal mode performs the abnormal recording process, and stores the permanent monitoring camera video in the abnormal mode in the central monitoring server storage unit. Thereafter, the stored permanent monitoring camera video in the abnormal mode is transmitted to the work support server 3 together with the permanent monitoring camera ID.

 [0053] At this time, it is sufficient that the abnormal surveillance mode video to be transmitted can be transmitted to the extent that the cause of the abnormality can be determined, but it may be a predetermined time in consideration of the capacity, or the entire stored amount. In this embodiment, which is good and can be set appropriately, these times vary depending on the monitoring target of each of the permanent monitoring cameras 5a, 5b, 5c ..., so that each of the permanent monitoring cameras 5a, 5b, 5cr " In the setting screen, you can now set it!

[0054] The reason why the permanent monitoring camera video in the abnormal mode is not directly transmitted to the work support server 3 in this way is that the high-quality video is simultaneously transmitted when abnormality detection occurs frequently. Server 3's communication line and processing load are significantly increased, and other This is in order not to interfere with work support. Furthermore, if the load is remarkably increased, the possibility that the video at the time of abnormality is not accurately recorded is also increased, so that the abnormal video is accurately stored.

 [0055] Then, the work support server 3 that has received the abnormal mode permanent monitoring camera video performs the abnormal time recording process, and stores the abnormal mode permanent monitoring camera video in the work support server storage unit. Further, the work support server 3 newly registers the permanent monitoring camera ID, the start time, and the recording data in the permanent monitoring camera recording information table (FIG. 5 (a)). The start time is the current time, and the recorded data is the path data for accessing the file that stores the permanent surveillance camera video in the abnormal mode.

 [0056] On the other hand, based on the reception of the abnormality detection mail transmitted from the work support server 3, the supporter displays the base information Z abnormality information area from the supporter terminal screen (Fig. 8) displayed on the personal computer 2. By operating, a base and an abnormality at the base are selected.

 [0057] The personal computer 2 that has received the supporter's base Z abnormality selection operation transmits an abnormal video request including the base number of the selected base to the work support server 3.

 [0058] The work support server 3 that has received the abnormal video request identifies the abnormal time stored in the abnormal information table (Fig. 5 (b)) in association with the base number, and further adds the base number to the base number. Correspondingly, the permanent surveillance camera ID identification process is performed to identify the permanent surveillance camera ID stored in the permanent surveillance camera table (Fig. 3).

 Then, the recording data stored in the permanent monitoring camera recording information table (FIG. 5 (a)) is specified in association with the identified permanent monitoring camera ID and the abnormal time. Note that the recording data whose start time is after the abnormal time and closest to the abnormal time is specified.

 Thereafter, the work support server 3 performs a permanent monitoring camera video transmission process of identifying the permanent monitoring camera video in the abnormal mode based on the recorded data and transmitting it to the personal computer 2 of the supporter.

Through the processing as described above, the personal monitor 2 serving as the supporter terminal receives the permanent monitoring camera video at the time of abnormality and performs video display processing. As a result, the monitoring camera video at the time of abnormality will be displayed on the supporter terminal screen, and the supporter can grasp the situation at the time of the abnormality by video, and what kind of measures should be taken It ’s good I am able to decline.

 [0062] The supporter may want to check the past work history at the site where these abnormalities occurred or the past work content of the work for which the instruction is to be performed. In such a case, The flow of information acquisition by supporters is briefly described below.

 First, when the support person wants to display the support history information on the personal computer 2, a predetermined operation is performed to display the support history information search screen. The personal computer 2 that has received a search operation with assistance from the support history information search screen transmits a search request including the content of the search operation and the supporter ID of the supporter to the work monitoring server 3. In the search screen, for example, in addition to each item other than the supporter ID in the support history information table (Fig. 7) such as worker ID, date and time, base number, etc., keywords can be entered as appropriate according to the design. . In this embodiment, it is assumed that at least one of a base number, a work number, and a support number is input as information that can specify a base.

 The work monitoring server 3 that has received this search request performs support history search processing, identifies support history information that satisfies the search request, and transmits it to the personal computer 2. At this time, the worker terminal camera video and the permanent surveillance camera video corresponding to the identified support history information are also transmitted.

The personal computer 2 that has received the support history information performs video display processing to display the support history information, the worker terminal camera video, and the permanent monitoring camera video. Through the above processing, the supporter can confirm support history information supported by the supporter.

 FIG. 16 is a diagram showing a detailed flow of the process performed by the work support server 3 in the process of displaying the support history information on the personal computer 2 of the supporter. Specifically, it is an explanation of the support history search process.

 [0067] In Scl, the search request is received, the process proceeds to Sc2, and the work instruction sheet stored in the work instruction table (FIG. 6 (a)) is associated with the supporter ID included in the search request. And go to Sc3.

 In Sc3, the support history information table is associated with the work number included in the work instruction sheet.

Identify the support history information stored in (Figure 7), proceed to Sc4, and identify the specified support history information. The permanent surveillance camera image and worker terminal camera image included in the information are identified, the process proceeds to Sc5, and the support history information including the image is transmitted to the PC 2.

[0069] In this way, the supporter who has confirmed the video, support history, etc. at the time of abnormality operates the personal computer 2 and, as shown in FIG. 9, a work instruction regarding work for dealing with the abnormality. Enter 'create'.

 [0070] The information necessary for this work instruction is a work number, a supporter, a worker ID, a base number, and work contents as shown in the work instruction table (FIG. 6 (a)). The work number is not entered because it is automatically assigned by the system. The supporter ID is automatically identified based on the supporter's previous input (for example, the login ID entered at login). Therefore, the supporter inputs the worker ID, site number, and work content.

 The personal computer 2 that has received the input of the work instruction sheet transmits a work instruction sheet including the site number and the worker ID to the work support server 3.

 [0072] Upon receiving the work instruction, the work support server 3 generates a work number (for example, automatically generates a serial number) and associates it with the generated work number in the work instruction table (FIG. 6 (a)). Memorize the received work instructions. After that, the electronic mail address stored in the worker table (FIG. 6 (f)) is specified in association with the worker ID. In addition, the address stored in the base table (not shown) is specified in association with the base number. Then, a work instruction mail transmission process is performed in which a work instruction mail including the address of the identified base and the work contents included in the work instruction is sent to the e-mail address of the identified manufacturer.

 Furthermore, the work support server 3 newly registers a work number in the work state table (FIG. 6 (b)), sets the work state not yet started, and sets the update time as the current time.

 [0074] In the notebook personal computer 1 that is the worker terminal, the worker who has received the work instruction mail moves to the base and performs a login operation to the work support server 3. Based on login operations! The laptop PC 1 then sends a request for a work ID that also includes the worker ID and the work number included in the work instruction mail.

The work support server 3 that has received the login request transmits the output information to the worker terminal screen to the notebook personal computer 1. Specifically, the work instruction stored in the work instruction table (Fig. 6 (a)) is identified and transmitted in association with the work number included in the login request. Implement the work instruction form transmission process. In addition, if an electronic manual including a procedure (process) corresponding to the work is stored, it is transmitted.

 Furthermore, the work support server 3 updates the update time to the current time while working on the corresponding work state in the work state table (FIG. 6B).

 [0077] Receiving the output information to the worker terminal screen including the work instruction, the notebook personal computer 1 outputs the worker terminal screen. As described above, this worker terminal screen displays a work instruction, the contents of a procedure (process) corresponding to the work, a support request button operated when requesting support, and the like.

 [0078] Then, the operator inputs a “work start” button (not shown) provided on the worker terminal screen to start the work, so that the procedure display area includes the initial process. Each time the displayed process is completed, each time the displayed process is completed, the operation of the next process is displayed by inputting the “next process” button. The work contents of the process are sequentially displayed, so that the work of the worker is supported by the notebook computer 1.

 [0079] After that, in these operations, if assistance is required such that the details of the operation are unclear or the shape of the indicated part is different from the actual one, the worker shall Operate the support request button.

 The notebook personal computer 1 that has accepted the operation of the support request button by the worker performs support request information transmission processing for transmitting support request information to the work support server 3. The information required for the support request includes the support number, work number, and details of the support request as shown in the support request form table (Fig. 6 (c)). The support number is automatically entered by the system and is not entered. The work number is automatically specified based on the received information so far (for example, the work number included in the work instruction received from the work support server 3). For this reason, the worker enters the details of the support request.

[0081] The work support server 3 that has received the support request information generates a support number (for example, automatic generation of a serial number), and associates it with the generated support number to create a support request form table (FIG. 6 (c)). The work number included in the support request information received and the contents of the support request are stored. After that, the supporter ID stored in the work instruction table (Fig. 6 (a)) is associated with the work number. The e-mail address stored in the supporter table (Fig. 6 (e)) is specified in association with the supporter ID. Then, a support request email containing the support number and support request contents included in the registered support instruction is sent to the email address of the identified supporter.

 Furthermore, the work support server 3 updates the corresponding work state in the work state table (FIG. 6B) with a problem and updates the update time to the current time. In addition, a support number is newly registered in the support status table (Fig. 6 (d)), the work status is issued as a support request, and the update time is the current time.

 The supporter who has received the support request mail in the personal computer 2 performs a mouth-guin operation on the work support server 3. Based on the login operation, the personal computer 2 transmits a login request including the worker ID and the support number included in the support request mail. In this embodiment, the ability to make these support requests by e-mail. The present invention is not limited to this, but instead of these e-mails, a specific messenger utility program is stored in the computer 2. Make sure that the messenger utility program stays resident every predetermined time, for example, every 10 seconds, and confirms whether or not there is a support request to the support person who operates the personal computer 2 with respect to the work support server 3. If there is a problem, it may be possible for the supporter to recognize that the request for assistance has been made without delay by forcibly displaying a message that the request for assistance has been received on the display screen. .

 The work support server 3 that has received the login request transmits information output to the supporter terminal screen to the personal computer 2. Specifically, the work number stored in the support request form table (Fig. 6 (c)) is identified in association with the support number included in the login request, and the work order form table is associated with the work number. The work instruction stored in (Fig. 6 (a)) is specified and transmitted.

 Furthermore, the work support server 3 updates the update time to the current time while supporting the corresponding support state in the support state table (FIG. 6 (d)). Also, support history information recording processing is performed, and new support history information is registered in the support history information table (Fig. 7). At this point, the base number, supporter ID, worker ID, work number, support number, and start time are registered.

[0086] Further, the work support server 3 associates the work support server 3 with the base number included in the identified work instruction. All the central monitoring server IDs and permanent monitoring camera IDs stored in the permanent camera table (Fig. 3) are identified, and the permanent monitoring camera video transmission request including the identified permanent monitoring camera ID is specified to the identified central monitoring server 4 Send.

Furthermore, the work support server 3 performs support history information recording processing and updates the support history information table (FIG. 7). At this point, the central monitoring server ID and permanent monitoring camera ID are registered.

 [0088] The central monitoring server 4 that has received the permanent monitoring camera video transmission request includes the permanent monitoring camera ID included in the permanent monitoring cameras 5a, 5b, 5c, ... corresponding to the permanent monitoring camera ID included in this request. Send a video transmission request.

[0089] The permanent monitoring cameras 5a, 5b, 5c, ... that have received the request for transmission of the permanent monitoring camera video are the work support server together with the received permanent monitoring camera ID of the permanent monitoring camera video that is a captured image.

Send to 3.

 [0090] The work support server 3 that has received the permanent monitoring camera video performs a relay / recording start process. That is, the work support server 3 stores the received permanent monitoring camera video in the work support server storage unit and transmits the permanent monitoring camera video to the personal computer 2 of the supporter.

 [0091] It should be noted that which work support (support number) corresponds to the received permanent monitoring camera image includes the support monitoring camera ID included in the permanent monitoring camera image and the end time is not registered. The information can be confirmed by specifying it in the support history information table (Fig. 7).

 Furthermore, the work support server 3 performs support history information recording processing and updates the support history information table (FIG. 7). At this point, the permanent surveillance camera video is registered. Permanent surveillance The camera video shall be the nose data for accessing the file storing the recorded video. In addition, recording information is newly registered in the permanent monitoring camera recording information table (FIG. 6 (a)). At this point, the permanent surveillance camera ID, start time, and recording data are registered. The start time is the current time, and the recorded data is the path data for accessing the file that stores the recorded video.

[0093] Then, the work support server 3 informs the worker's notebook computer 1 that the support request has been granted. A support permission response indicating is sent. The support permission response includes a support number.

 [0094] On the other hand, the work support server 3 performing the relay 'recording start process based on the log-in request of the supporter, the work included in the work instruction specified by the support number included in the log-in request as described above The worker camera ID stored in the worker table (FIG. 6 (f)) is further specified in association with the worker ID. Then, the worker terminal camera video transmission request including the worker camera ID is transmitted to the notebook computer 1.

 Furthermore, the work support server 3 performs support history information recording processing and updates the support history information table (FIG. 7). At this point, the operator terminal camera ID is registered.

 [0096] The notebook computer 1 that has received the worker terminal camera video transmission request transmits the worker terminal camera video, which is a photographed image of the worker terminal camera 101, to the work support server 3 together with the received worker camera ID. Carry out worker terminal camera video transmission processing. Note that the voice input from the worker terminal microphone 103 is also transmitted at the same time.

 The work support server 3 that has received the worker terminal camera video stores the worker terminal camera video received and spoken in the work support server storage unit, and also stores the worker terminal camera video of the supporter. Send to BASCON2.

 [0098] It should be noted that which work support (support number) the received worker terminal camera video corresponds to! / Speak includes the worker terminal camera ID included in the worker terminal camera video and the end time. By identifying support history information that is not registered in the support history information table (Fig. 7), it can be confirmed.

 Furthermore, the work support server 3 performs support history information recording processing and updates the support history information table (FIG. 7). At this point, the operator terminal camera video is registered. Worker The terminal camera video is the nose data for accessing the file that stores the recorded video.

[0100] Through the processing described above, the personal monitor 2 serving as the supporter terminal receives the permanent monitoring camera image and the worker terminal camera image, and as a result, the supporter terminal screen as shown in FIG. In addition, the video of the permanent monitoring camera and the video of the worker terminal camera are displayed at the same time, so that the supporter can easily connect the worker terminal camera video of the worker and the permanent monitoring camera such as the surrounding situation of the worker. You will be able to check the video. [0101] After that, the personal computer 2 of the supporter supports the supporter terminal camera 201 and the supporter terminal camera image acquired by the supporter terminal microphone 202 installed (connected) to the personal computer 2 for support. Supporter terminal camera video transmission processing to be sent to the laptop PC 1 of the worker who requested it is implemented, and in this way, the PC 2 of the supporter and the laptop PC 1 of the worker In the meantime, so-called video conferencing is realized, and the supporter and the worker can get close communication with each other through video and audio.

[0102] As described above, in the exchange of video and audio between the personal computer 2 and the notebook computer 1, the notebook computer 1, which is the worker terminal, is brought to the base only by the worker during the work. Therefore, in order to make it easier to carry out these movements and to make the work easier, as in this embodiment, data for carrying out two-way wireless data communication with the mobile phone network 8 wirelessly as in this embodiment. Since a communication card is used, data communication may be disrupted depending on the movement during these operations and the operation status of surrounding devices. If these data communications are disrupted, In other words, since the supporter cannot understand the work performed by the operator while offline, the video and audio cannot be understood. The video during the fly-in is automatically sent to the supporter, and the flow when the video during the cut is automatically sent to the supporter is shown below based on Fig. 11. Explained.

First, as described above with reference to FIG. 9, it is assumed that the permanent monitoring camera image and the worker terminal camera image are simultaneously displayed on the supporter terminal screen. In this state, the processing when the communication between the notebook computer 1 and the work support server 3 is disconnected, that is, goes offline will be described. For example, it is assumed that the wireless communication via the mobile phone network 8 is temporarily disabled due to a temporary failure.

[0104] The notebook computer 1 that has detected that it has gone offline performs unsent data recording processing, and the captured video of the worker terminal camera 101 (worker terminal camera image) is stored in the worker terminal storage unit. Remember. After that, by detecting that it is online, the recording end processing is performed to end the recording, and at the same time, the recorded video transmission processing for transmitting the recorded worker terminal camera video to the work support server 3 is performed. carry out. In addition, the operator terminal camera image currently being shot is also sent to work support Sano 3. [0105] On the other hand, the work support server 3 that has detected that it has become offline performs relay'recording interruption processing and transmits the fact that it has become offline to the personal computer 2 of the supporter.

 [0106] After that, the work support server 3 that has detected that it is online performs the relay'recording recovery process to receive the offline worker terminal camera video and the offline worker terminal camera. The time synchronization signal is generated so that the video and the permanent monitoring camera video stored in the work support server storage unit while offline are displayed simultaneously on the supporter terminal screen, and these offline worker terminal cameras Send video and offline surveillance camera video to PC 2. The supporter can select the video playback stop and playback speed, and the current video can be viewed after it is terminated appropriately.

 [0107] Through the above processing, in the personal computer 2 serving as the supporter terminal, the notebook personal computer 1 serving as the worker terminal goes offline, and the video of the worker terminal camera 101 is received for a while. As a result, the permanent surveillance camera image that is offline is displayed on the supporter terminal screen.

 FIG. 12 shows the work support server 3 and the notebook computer 1 in the process of displaying the video of the worker terminal camera 101 while the notebook computer 1 as the worker terminal is offline on the supporter's personal computer 2. It is a figure which shows the detailed flow of the process which is implemented.

 First, the processing of the notebook computer 1 will be described. During the work support, the notebook computer 1 always performs the processing of Sbl to Sb3 while transmitting the video of the worker terminal camera 101.

 [0110] In Sbl, the disconnection time counter is reset, the process proceeds to Sb2, and the current time is acquired. Then, proceed to Sb3, send a confirmation signal to the work support server 3, and determine whether or not the line has been disconnected based on whether or not the response from the work support server 3 has been received. To implement. If it is not disconnected, it is determined as YES and the process proceeds to Sb7. If it is disconnected, it is determined as NO and the process proceeds to Sb4.

[0111] In Sb4, a flag indicating that it is in an offline state is set, the process proceeds to Sb5, and the disconnection time counter is incremented by one. Then, the process proceeds to Sb6, and after performing the unsent data recording process of storing the captured video of the worker terminal camera 101 in the worker terminal camera storage unit, the process returns to Sb3. [0112] After this, if the offline state continues, Sb4 to Sb6 will be performed again, but Sb4 and Sb6 have already been performed, so there will be no new action. become. On the other hand, in the implementation of Sb5, the cutting time counter is incremented by one. Since this loop period is designed to be 1 second, the value of the disconnection time counter is the number of seconds that are offline.

 [0113] In Sb7, it is determined whether or not the force indicating that the offline state flag is set, and if it is set, that is, if the offline state force is restored to the online state, YES is determined. Then go to Sb8. If it is not set, that is, if the online state continues, the determination is NO and the process proceeds to Sbl 1.

 [0114] In Sb8, the recording stop process is performed, and the process proceeds to Sb9, in which the recording video of the worker terminal camera 101 corresponding to the disconnection time counter, that is, the number of continuous seconds in the offline state is transmitted to the work support server 3. Perform video transmission processing. Then, the process proceeds to SblO, clears the flag indicating that it is in the offline state, shifts to the online state, and proceeds to Sb11.

 [0115] In Sbl l, the current captured video of the worker terminal camera 101 is transmitted to the work support server 3, and the process returns to Sbl.

 Next, the process of the work support server 3 will be described. The work support server 3 always performs the processing of Sal to Sa3 during work support.

[0117] In Sal, the cutting time counter is reset, the process proceeds to Sa2, and the current time is acquired. Then, go to Sa3, receive the permanent surveillance camera video from the permanent surveillance cameras 5a, 5b, 5c…

Proceed to 4.

 [0118] In Sa4, it is determined whether or not the line is disconnected based on whether or not the worker terminal camera video is received from the notebook personal computer 1. If it is not disconnected, it will be judged as YES and proceed to Sa 9. If it is disconnected, it will be judged as NO and go to Sa5.

[0119] In Sa5, an offline signal indicating offline is sent to the personal computer 2 of the supporter, the process proceeds to Sb6, a flag indicating offline is set, the process proceeds to Sa7, and the disconnection time counter Add 1 to. Then, the process proceeds to Sa8, and after performing processing for storing the captured images of the permanent monitoring cameras 5a, 5b, 5c... In the work support server storage unit, the process returns to Sa4. [0120] After this, if the offline state continues, Sa5 to Sa8 will be performed again, but Sa5, Sa6, and Sa8 are already performed, so there is no new operation. Absent. On the other hand, in the implementation of Sa7, the cutting time counter is incremented by one. Since this loop period is designed to be 1 second, the value of the disconnection time counter is the number of seconds in the off-line state.

 [0121] In Sa7, it is determined whether or not the force indicating that the offline state flag is set, and if it is set, that is, if the offline state force is restored to the online state, YES is determined. Then proceed to SalO. If it is not set, that is, if the online state continues, it is judged as NO and proceeds to Sal4.

 [0122] In SalO, the offline worker terminal camera image is received from the worker's notebook computer 1 and the process proceeds to Sai l. The offline worker terminal camera image and the work support server storage section Synchronize the saved offline surveillance camera video, proceed to Sal2, and send to PC2. Then, proceed to Sal3, clear the flag indicating that it is offline, shift to online status, and proceed to Sal4.

 [0123] In Sal4, the current video captured by the worker terminal camera 101 is received, and the process proceeds to Sal5. In synchronization with the current permanent monitoring camera video, the process proceeds to Sal6 and is transmitted to the personal computer 2. Then return to Sal.

 [0124] By doing the above, it is detected whether or not the notebook PC 1 is offline, and when an offline state occurs, the offline operator terminal camera video is temporarily stored and offline. When the status is resolved, that is, when there is an offline worker terminal camera video when it is online, the offline worker terminal camera video is transmitted, so that these offline worker terminals The camera image can now be displayed on the supporter's computer 2! /!

 FIG. 13 is a diagram showing a flow of processing for causing the supporter's personal computer 2 to annotate the video of the worker terminal camera 101.

First, as described above with reference to FIG. 9, it is assumed that the permanent monitoring camera image and the worker terminal camera image are displayed simultaneously on the supporter terminal screen (FIG. 8). . In this state, if the supporter selects (focuses) the worker terminal camera video area Both explain the processing when the annotation button is operated.

 [0127] The personal computer 2 that accepts the operation of the annotation button transmits a still image transmission instruction to the notebook personal computer 1 of the worker via the work support server 3.

 [0128] The notebook computer 1 that has received the still image transmission instruction transmits to the work support server 3 the video image (still image) of the worker terminal camera 101 at this time.

The work support server 3 that has received the worker terminal camera video (still image) transmits the worker terminal camera video (still image) to the personal computer 2.

[0130] The personal computer 2 that has received the worker terminal camera video (still image) performs a process of displaying the still image in a multi-layer (layer) format, and generates a layer of the annotation image above the still image. .

 [0131] Then, the drawing operation for this annotation layer is accepted. For example, as shown in the upper right part of Fig. 8, the annotation data can be changed based on the operation of the drawing menu that also has a circle 'rectangle' free curve force, a line thickness selection button, a color selection button, etc. Accept drawing.

 [0132] The annotation data (the drawing content on the annotation layer) received from the personal computer 2 of the supporter is transmitted to the work support server 3 by the annotation data transmission process. In addition, the work support server 3 performs the annotation data relay process, and is transmitted to the notebook computer 2 of the worker.

 As shown in the upper right part of FIG. 8, the drawing menu is provided with a save button, and the personal computer 2 that has accepted the operation of the save button transmits the annotation data to the work support server 3.

 The work support server 3 that has received the annotation data stores the annotation data in the work support server storage unit as part of the support history information.

 Through the above processing, the supporter can send a visual instruction to the worker about the situation at the site (recorded video of the worker terminal camera 101), for example, an instruction such as turning this to the right. .

 Note that an annotation button may be provided on the operator terminal screen, and these processes may be started according to the operator's request.

[0137] An annotation menu is provided on the worker terminal screen so that the worker can input the annotation data. The annotation data is transmitted from the notebook computer 1 of the worker to the work support server 3. You may make it. Work support server 3 is an annotation data relay process Is sent to the laptop PC 2 of the supporter.

[0138] FIG. 14 is a diagram showing a flow of processing for causing the personal computer 2 of the supporter to add an annotation to the recorded video of the permanent monitoring camera.

First, as described above with reference to FIG. 9, it is assumed that the permanent monitoring camera video and the worker terminal camera video are displayed simultaneously on the supporter terminal screen (FIG. 8). . In this state, the supporter will select (focus) the permanent surveillance camera video area and explain the processing when the annotation button is operated.

[0140] The personal computer 2 that has accepted the operation of the annotation button transmits a video request to the work support server 3. For example, as described above with reference to FIG. 10, an abnormal video request is transmitted.

[0141] The work support server 3 that has received the abnormal video request identifies the permanent monitoring camera video in the abnormal mode and transmits it to the personal computer 2 of the supporter as described above with reference to FIG.

[0142] The personal computer 2 that has received the video of the permanent monitoring camera displays it on the supporter terminal screen.

[0143] When the operation of the still image button from the supporter is accepted in this state, the personal computer 2 displays the permanent monitoring camera video (still image) displayed on the supporter terminal screen at that time as the work support server. Send to 3.

[0144] The personal computer 2 that has selected the permanent surveillance camera video (still image) performs processing to display the still image in a multi-layer (layer one) format, and generates a layer of the annotation image above the still image .

 [0145] Then, the drawing operation for this annotation layer is accepted. For example, as shown in the upper right part of Fig. 8, the annotation data can be changed based on the operation of the drawing menu that also has a circle 'rectangle' free curve force, a line thickness selection button, a color selection button, etc. Accept drawing.

 Supporter Power The received annotation data (drawing contents on the annotation layer) is transmitted to the operator's notebook computer 1 via the work support server 3.

As shown in the upper right part of FIG. 8, the drawing menu is provided with a save button, and the personal computer 2 that receives the operation of the save button transmits annotation data to the work support server 3.

The work support server 3 that has received the annotation data stores the annotation data in the work support server storage unit as part of the support history information. [0149] With the above processing, the support person gives a visual indication to the worker about the surrounding situation (recorded video of the permanent surveillance cameras 5a, 5b, 5c ...), for example, there is an abnormality here. Can send instructions.

 [0150] Note that an annotation button may be provided on the worker terminal screen, and these processes may be started at the request of the worker.

 [0151] Also, select the still image from the recorded video images of the permanent surveillance cameras 5a, 5b, 5c ... and annotate it! Select the video currently displayed as a still image and annotate it. It is good to go.

 [0152] In addition, although it is instructed that the abnormal image power is also abnormal, it may be instructed from the normal image that this is the normal state. In such a case, it is sufficient to output the recorded video list menu in the work monitoring server 3 so that the supporter can select the recorded video from which the still image is to be extracted.

 [0153] Note that the power described in the present embodiment is centered on video. The worker's notebook computer 1 is the worker terminal microphone 103, the worker terminal speaker 104, and the supporter computer 2 is the supporter terminal. A microphone 203 and a supporter terminal speaker 204 are provided. In the present embodiment, in the case of simply a video, video data including audio, so-called moving image data is shown.

 Next, the flow of processing when changing, adding, or deleting functions in the work support system according to the present embodiment will be described with reference to FIGS.

 [0155] FIG. 17 is a diagram showing a flow of procedures when a function is changed, added, or deleted in the work support system. The differences between the conventional program and the present invention program will be clarified.

 [0156] First, assuming that the work support system is composed of conventional programs, the flow of procedures when changing, adding, or deleting functions will be described.

[0157] As shown in Fig. 17, the conventional program is mainly composed of three types of element forces. Specifically, the database stores a plurality of real tables (1), (2) ···, and the real tables (1), (2) ··· stored in these databases. Multiple access programs to access (search, register, change, delete) individually, ie, access program for real table (1), access program for real table (2) ···, and these real table and access program To perform multiple processes for work support as described above. And a processing program.

 [0158] In the present invention, the actual table is a command for creating a table in a relational database, specifically, a table generated by a CREATE TABLE command.

 [0159] On the other hand, the present invention type program is mainly composed of four types of element forces as shown in FIG. Specifically, a database in which one real table is stored, and one access program for individually accessing (searching, registering, changing, and deleting) the real table stored in the database, that is, one real table. Access program, these one real table and one access program to make one real table look like multiple virtual real tables, ie temporary tables (1), (2) It consists of a data mapping API (Application Programming Interface) that is an interface program.

 [0160] At this time, the following functions will be added.

 [0161] As a premise, a large number of permanent surveillance cameras 5a, 5b, 5c, etc. installed at each site receive the predetermined command data for each model, thereby moving the imaging direction up, down, left, and right. And panning, tilting and zooming. At this time, the work support server 3 stores the models of the permanent monitoring cameras 5a, 5b, 5c,... In an identifiable manner. Further, predetermined command data is registered for each model, and the work support server 3 When the operation is accepted, the models of the permanent monitoring cameras 5a, 5b, 5c ... are identified, and the predetermined command data corresponding to the accepted operation in the identified model is identified to identify the permanent monitoring cameras 5a, 5b, 5c ... and add functions to allow the permanent surveillance cameras 5a, 5b, 5c ... to move the imaging direction up / down / left / right and pan / tilt / zoom.

[0162] Specifically, in the work support server 3, the permanent monitoring cameras 5a, 5b, 5c, ... are moved up, down, left, and right in the imaging direction with respect to the supporter screen transmitted to the personal computer 2 serving as the supporter terminal. Command data corresponding to the operation of the supporter received via the operation unit is added, along with processing for adding and outputting an operation unit for receiving supporter operations indicating panning, tilting, and zooming. Add processing to send to surveillance cameras 5a, 5b, 5c…. [0163] The process of generating a supporter screen to be transmitted to the personal computer 2 serving as the supporter terminal corresponds to the screen generation process shown in FIG. FIG. 18 (a) is a flowchart showing the process flow before the change of the screen generation process, and (b) is a flowchart showing the process flow after the change.

 [0164] The process flow before the change will be described with reference to Fig. 18 (a). The work support server 3 is first stored in association with the support number included in the login request received from the personal computer 2. And a work instruction stored in association with the work number stored in the support request. Then, the permanent monitoring camera stored in association with the base number stored in the work instruction sheet is specified. Finally, the work support server 3 generates a supporter screen having the various types of identified data and the video power acquired by the permanent monitoring camera power.

 The processing flow after the change will be described with reference to FIG. 18 (b). The work support server 3 is first stored in association with the support number included in the login request received from the personal computer 2. And a work instruction stored in association with the work number stored in the support request. Then, the permanent monitoring camera stored in association with the base number stored in the work instruction sheet is specified. In addition, identify the types of permanent surveillance lenses and specify the acceptable operations (moving the imaging direction up and down, left and right, and any or all of the power of panning, tilting and zooming). Finally, the work support server 3 generates the supporter screen shown in FIG. 20 as the operation unit power to receive the various kinds of identified data, the video acquired by the permanent monitoring camera force, and the supporter's power to operate the permanent monitoring camera. . As shown in Fig. 20, the operation unit is displayed at the upper part of the captured image of each permanent monitoring power mela, and is filled with black triangles for moving the imaging direction up and down, left and right, and for panning and tilting. It consists of "+" and "-".

 [0166] In order to perform the process after such a change, it is necessary to change and add a table as shown in FIG. FIG. 19 (a) is a diagram showing a configuration after the change of the permanent monitoring camera table to be changed, and (b) is a diagram showing a model information table to be added.

[0167] As shown in Fig. 19 (a), the permanent surveillance camera table is added with a model ID that can identify the model of the permanent surveillance camera. In the model information table, as shown in FIG. 19 (b), the types of operations that can be accepted by this model in association with the model ID (moving the imaging direction up / down / left / right, pan, tilt, zoom) ) And command data for causing the permanent monitoring camera to perform control corresponding to the operation.

 The permanent monitoring camera table and the model information table correspond to actual tables in the conventional program and correspond to temporary tables in the present invention type program.

 It should be noted that the various tables described so far also correspond to real tables in the conventional program and also correspond to temporary tables in the present invention type program. In other words, all data stored in various tables, which are temporary tables in the present invention type program, are stored in actual tables in the present invention type program.

[0171] Here, the real table in the present invention type program will be described.

[0172] Fig. 21 (a) is a diagram showing the configuration before the change of the real table, (b) is a diagram showing the configuration before the data mapping data is changed, and (c) is a diagram after the change of the real table (D) is a diagram showing the configuration after the data mapping data is changed.

[0173] As shown in FIGS. 21 (a) and 21 (c), the real table of the present invention specifies the table name, which is the name of the temporary table to which the data belongs, and the temporary table. It consists of a key, which is data for the data, an item number for specifying the item of the data, and an item value, which is the value of the item of the data.

This real table is configured as a plurality of temporary tables based on the data mapping data shown in FIGS. 21 (b) and 21 (d). The method of constructing the temporary table for the actual table power will be explained.

 [0175] Data mapping data includes a table name that is a name of a temporary table, an item number of an item belonging to the temporary table, an item name that is an item name, and an item type that is an item data type. And options as supplementary information of items.

[0176] As an option, if this item is specific information in the temporary table, a key indicating whether it is the so-called main key, or the name of the linked temporary table if it is an item linked to another temporary table And item names and the like are stored. It is stored as the item value of the item's key value in the actual table key. [0177] For example, as shown in Fig. 21 (b), in the data mapping data, four items of the permanent monitoring camera, which is a temporary table, are stored, and each item is a permanent type that is an integer type and a key. Assume that the surveillance camera ID, the integer type base number, the integer type central monitoring server ID, and the text type video description.

 Based on the data mapping data, a permanent monitoring camera that is a temporary table can be configured from the real table shown in FIG. 21 (a).

 [0179] Specifically, first, all data whose table name is the permanent monitoring camera is extracted from the actual table. All data belonging to these permanent surveillance cameras are grouped based on whether the key values are the same. Each group should consist of 4 data! Each item number is 1 ~ 4. This one group (= 4 data) represents one permanent surveillance camera. In other words, the item values of the four data grouped based on these key values are arranged in one horizontal row in the order of the item number, and the four item values arranged in the horizontal one row are arranged as the key value. The permanent surveillance camera table shown in Fig. 3 can be configured by sequentially arranging each change in the downward direction.

 [0180] With the same procedure, all data belonging to all other temporary tables, for example, all data belonging to the central monitoring server table (Fig. 4), etc. can be stored in the same real table. . Moreover, by creating data mapping data appropriately for each temporary table, a plurality of temporary tables can be configured from a single real table.

 [0181] As described above, the inventive program extracts all data having the same table name from the real table. Group these data based on whether the key values are the same. The item values of multiple data grouped based on these key values are arranged in a horizontal row in the order of the item numbers, and the item values arranged in this horizontal row are arranged sequentially downward as the key value changes. This process is called a virtual table generation step.

Here, the change of the real table in the conventional program shown in FIGS. 19 (a) and 19 (b), that is, the change of the temporary table in the invention type program is changed to the real table in the invention type program (FIG. 21 (a )) And how it is reflected in the data mapping data (Figure 21 (b)). [0183] First, in the data mapping data, as shown in Fig. 21 (d), the table name is permanent monitoring camera, the item number is 5, the item name is model ID, the item type is integer, the option is model information table Add the data that becomes the model ID of. This option indicates that the model ID of the permanent surveillance camera should be linked with the model ID in the model information table.

 [0184] Although not particularly shown, data whose table name is model information is added according to Fig. 19 (b). In other words, model data and data mapping data for constructing a temporary table are added to the actual table.

 [0185] Next, as shown in Fig. 21 (c), the real table includes an item for each data grouped by the key value with respect to all data whose table name is a permanent monitoring camera. The number is 5 and the item value is S. Additional data is recorded as the model ID corresponding to the model of this permanent surveillance camera.

 [0186] Although not specifically shown, data whose model name is model information is added to the actual table in accordance with Fig. 19 (b).

 [0187] By doing so, the permanent monitoring camera table shown in Fig. 19 (a) is temporarily set based on the data mapping data shown in Fig. 21 (d) from the real table shown in Fig. 21 (c). Can be configured as a table.

 [0188] Real table power The process of constructing a temporary table based on data mapping data is a mechanical procedure as described above, and the program for executing these procedures is based on the data mapping data. Can be generated automatically.

Therefore, in this embodiment, as shown in the right part of FIG. 17, a temporary table is configured from the actual table based on the data mapping data, and the screen generation process shown in FIGS. 18 (a) and 18 (b), etc. An interface program that makes a real table look like multiple temporary tables, so-called API (hereinafter referred to as data mapping API), is automatically generated based on the data mapping data. An automatic update program is provided. Therefore, in the present invention type program, as a typical procedure for adding / changing functions, first, data mapping data for adding / changing / deleting items to the corresponding temporary table in the database. Create Then, the automatic update program is executed, the real table, the program for accessing the real table, and the data Update the mapping API. Finally, using the automatically updated data mapping API, add / change / delete the part corresponding to the updated contents in the data processing program.

 FIG. 22 (b) is a diagram showing a configuration before the change when the processing program is the present invention type, and (d) is a diagram showing a configuration after the change of the present invention type program. As the actual addition 'change' deletion work, as shown in Fig. 22 (d), only the addition of the part to use the newly added real table is performed.

 [0191] The illustrated program is described in a virtual object-oriented language, and the Came ra object and its method, the CameraType object and its method correspond to the data mapping API. By accessing the real table via these objects and their methods, the data processing program consists of a single real table consisting of a camera object and its constantly-monitoring camera table consisting of that method, a CameraType object and its method. It becomes possible to access as two temporary tables that can also be used as a model information table!

 [0192] As described above, the present invention type program includes a process for making one real table accessible as a plurality of temporary tables by means of an object corresponding to each temporary table and its method and its method. This process is called an interface step.

 [0193] On the other hand, as shown in the left part of Fig. 17, in the conventional program, as a typical procedure for adding functions 'change-deletion', first add items to the corresponding actual table in the database 'change' delete. Then, in the access program to access the actual table that has been added, “changed” and deleted, the part corresponding to the added “changed” and deleted item is added and changed. Finally, using the added / changed / deleted access program, add / change / delete the part corresponding to the added / changed / deleted contents in the data processing program.

[0194] For example, adding / changing / deleting an actual table in the database has a risk of adding, changing, and deleting existing data incorrectly, and it is preferable not to do it manually as much as possible. Also, when adding / changing / deleting access programs, there is a possibility that unintended bugs may be mixed in by changing them. Further In addition, in the process of adding / changing / deleting data processing programs, there are generally multiple locations where the same access program is used, typically displayed. Because there are at least a processing program for changing and a processing program for changing, there are many places to change even when changing the actual table. This large number of changes itself is a problem, and unintended bugs may be introduced by making changes in the same way as adding / changing / deleting access programs. However, the contents of changes to the processing program must be considered by the developer each time, and in most cases, it must be changed manually.

 FIG. 22 (a) is a diagram showing a configuration before change when the processing program is a conventional type, and (c) is a diagram showing a configuration after change of the conventional program. As shown in Fig. 22 (c), the actual addition 'change' deletion work involves changing the part that existed before the change and adding a part to use the newly added real table. And has been done. The illustrated program is described in a virtual object-oriented language, and is a program in which a program for accessing an actual table and a program for processing data are mixed and integrated.

 [0196] Although this is a very simplified example, there are actually multiple data processing programs that use a permanent camera table, and the conventional program has additional 'change' deletion work. The part that needs to be present exists over a wide range of systems.

 [0197] Furthermore, another function tracking will be exemplified.

 [0198] Assume that a company that operates a work support system thinks that it has improved the performance of each work by placing a supervisor in addition to the supporter and the worker for each work. .

 [0199] To make such a change, it is necessary to change and add a table as shown in FIG. FIG. 23 (a) is a diagram showing the configuration after the change of the work instruction table to be changed, and (b) is a diagram showing the added supervisor table.

 [0200] As shown in Fig. 23 (a), the work instruction document camera table is powered by a supervisor ID that can identify the supervisor! ]

[0201] As shown in FIG. 23 (b), the monitor table stores a monitor terminal ID that can identify the monitor terminal that the monitor uses for monitoring in association with the monitor ID. . [0202] Fig. 24 (a) is a diagram showing the configuration before the change of the real table, (b) is a diagram showing the configuration before the change of the data mapping data, and (c) is after the change of the real table. (D) is a diagram showing the configuration after the data mapping data is changed.

 [0203] As shown in Fig. 24 (b), the data mapping data before the change contains 5 items of work instructions that are temporary tables, each of which is an integer type and a key. Work number, integer type supporter ID linked to the supporter ID of the supporter table, integer type worker ID linked to the worker ID of the worker table, integer type base number, text type work contents , Is stored.

 [0204] As shown in Figure 24 (d), the data mapping data after the change has a table name of work instruction, item number of 6, item name of monitor ID, item type of integer, and option of Add data to be the monitor ID of the monitor table. This option indicates that the monitor ID of the work order is linked to the monitor ID of the monitor table.

 [0205] Although not particularly shown in the figure, the data whose table name is the monitor is added to the data mapping data after the change in accordance with Fig. 23 (b). In other words, data mapping data for constructing a temporary table called a monitor is added from the actual table.

 [0206] In the actual table before the change, as shown in Fig. 24 (a), the item value whose table name is the work instruction and item number is 1 to 5 is the key of the work instruction. It is stored in association with a certain work number.

 [0207] In the actual table after the change, as shown in FIG. 24 (c), the item value force with the table name being either the work instruction and the item number being 6, that is, the supervisor ID is the work instruction. It is stored in association with the work number that is the key of.

 [0208] In addition to the actual table after the change, data whose table name is the monitor is added according to Fig. 23 (b), although not specifically shown.

[0209] As described above, when changing the program of the present invention, the developer executes the automatic update program using the data mapping data change operation and the data mapping data as input, thereby enabling the data mapping API, The table access program, the work to update the actual table, and the work to change the data processing program using the updated data mapping API can be performed. [0210] The present invention type program may include data mapping data and an automatic update program.

 [0211] On the other hand, if there is no automatic update program, the developer must manually change the real table, change the real table access program, change the data mapping API, and change the data processing program. The four operations will be performed.

 [0212] Even in this case, it is almost unnecessary to change the structure (item) of the real table in the invention type program. As a result, the program for accessing the real table is changed. There is no need to do that.

 [0213] Therefore, the developer performs only two tasks: a data mapping API change task and a data processing program change task. This is a significant burden compared to the work of changing the data mapping data and automatically updating the data mapping API using the automatic update program. Compared to the case where the three tasks of changing the program for accessing the real table and changing the data processing program are necessary, the burden on the developer is small.

 [0214] As described above, according to this embodiment, even if it is necessary to change the inventive program, the temporary table generated by the virtual table generation step becomes a temporary table corresponding to the change. In addition, it is not necessary to change the configuration of the real table and the access program for the real table which should be changed mainly by changing the data mapping API, which is an interface program.

[0215] Also, according to the present embodiment, the interface program is changed using the predetermined data mapping data and the automatic update program, instead of directly changing the data mapping API as an interface program by the operator. Therefore, it is only necessary to input the contents of the change to the predetermined data mapping data, so that problems such as bugs due to mistakes in the change work are less likely to occur than when the interface program is changed directly. These changes can be carried out more easily and accurately, and the occurrence of inconvenience due to mistakes in the automatic update program that do not require identification of the automatic update program corresponding to the change in the work support program can be reduced. [0216] Also, according to the present embodiment, updating of the real table such as additional registration of the generated key (table name, key, item number) based on the change to the real table is also automatically performed by the automatic update program. Therefore, the labor and time required for the change can be further reduced.

 [0217] Also, according to the present embodiment, when the change is made, the data mapping data used for the previous change is included in the invention-type program that is the work support program to be changed. The data mapping data used for the change can be easily identified, and the data mapping data can be easily used in the new change, thus reducing the labor and time required for the change. be able to

[0218] Also, according to the present example, the work support person confirms the worker terminal video (worker terminal camera video) on the notebook personal computer 1 as the worker terminal on the personal computer 2 as the support terminal. However, the work support can be performed, and the worker can receive more accurate work support by the power of the work supporter.

 [0219] Also, according to the present embodiment, surveillance cameras 5a and 5b that are permanently installed at the work site (base) identified from the site specific information (work number) included in the support request information from the worker terminal. , 5c ... and the worker terminal image data from the worker terminal camera 101 of the notebook computer 1 are transmitted to the personal computer 2 which is the support terminal of the identified work supporter, and the monitoring is performed. Since the permanent surveillance camera video based on the video data and the worker terminal camera video based on the worker terminal video data are displayed on the personal computer 2, the work supporter can view the permanent surveillance camera video that is a wide range of on-site video. Can be obtained easily, and judgments and instructions according to the actual situation can be implemented more accurately.

 [0220] While the embodiments of the present invention have been described with reference to the drawings, the specific configuration is not limited to these embodiments, and there are changes and additional efforts within the scope of the present invention. It is included in the present invention.

 [0221] For example, in the above-described embodiment, there is provided a sensor, and is capable of performing abnormality detection processing, video recording and display processing during an abnormality, and the present invention is not limited to this. Also good.

[0222] In the above embodiment, the annotation data is input and the transmission process is performed! However, the present invention is not limited to this, and may be configured not to perform these.

 [0223] Further, in the above-described embodiment, the power of the operator terminal camera image being recorded offline and displayed when it is online. The present invention is not limited to this. Don't do it, the configuration is good.

[0224] Further, in the above-described embodiment, the support history information is recorded and can be searched and displayed later. The present invention is not limited to this. Also good.

 [0225] Further, in the above-described embodiment, the power that the server computer is composed of two units, the work support server 3 and the central management server 4, is not limited to this. Alternatively, each may be composed of a plurality of units.

 [0226] In the above-described embodiment, the worker terminal camera ID, the supporter terminal camera ID, and the permanent monitoring camera ID are all stored in advance in the work support server 3. However, the present invention is not limited thereto. There is a separate ID registration process that is not limited, and the device ID set by the manufacturer can be sent to the work support Sano 3 so that it can be registered in the work support Sano 3. An ID assigning process may be provided so that the work support server 3 automatically generates an ID and transmits it to the device so that the ID is transmitted to the device.

In the embodiment, the work support server 3 transmits the permanent monitoring camera video (monitoring video data) and the worker terminal camera video (worker terminal video data) to the personal computer 2 that is the supporter terminal. For this purpose, the work support server 3 directly relays the permanent monitoring camera video (monitoring video data) and the worker terminal camera video (worker terminal video data) to the personal computer 2. However, the process for transmitting to the personal computer 2 that is the support terminal is not limited to this. The work support server 3 is not directly relayed to the personal computer 2 but the personal computer 2 that is the transmission destination. By notifying the network address (IP address) to the notebook computer 1 (worker terminal) and the permanent monitoring cameras 5a, 5b, 5c…, these notebook computer 1 (worker terminal) and the permanent monitoring camera 5a, 5b, 5c… directly send the surveillance camera video (monitoring video data) and worker terminal camera video (worker terminal video data) directly to the PC 2, and the work support server 3 sends these permanent surveillance camera videos (monitoring video data). Image data) and worker terminal camera video (worker terminal video data) may be relayed.

 [0228] In the above embodiment, the data communication card for connecting the notebook computer 1 (worker terminal) to the Internet network via the mobile phone network 8 is used. However, the present invention is not limited to this. As a means of data communication, a PHS telephone network or a public wireless LAN network may be used instead of the cellular telephone network 8, and a wired connection to the base is possible. If a LAN environment exists, these wired LANs may be used.

 [0229] In the above-described embodiment, the present invention type program has one real table. However, the present invention is not limited to this. It is sufficient if there is at least one real table. If the actual table power is very large and inefficient, a configuration in which it is distributed over multiple tapes may be used.

 Industrial applicability

[0230] The present invention verifies the effect of a work support program in which changes occur frequently. As an application example of the present invention, the present invention also relates to other programs in which these changes occur frequently. Therefore, there is a possibility that the same effect as the work support program of the present invention can be obtained, and it can be used.

Claims

The scope of the claims  [1] A worker who goes to the work site is connected to a worker terminal that can be operated and carried so that data communication is possible, and various types of information related to the work performed at the work site are digitized. A work support program that operates on a server computer that supports the work by delivering an electronic document to the worker terminal, a data processing program that performs data processing related to the work support, and a structure in a column direction is fixed, The column has at least a generation key item in which a generation key for generating a virtual table used by the data processing program is stored as an item in the column, and the structure is unchanged even when the work support program is changed. A database with two real tables,  A real table access program for accessing a real table in the database;  A virtual table generation step for generating a plurality of virtual tables based on the generation key stored in the generation key item of the real table using the real table and a real table access program; An interface program including an interface step that allows the data processing program to access the virtual table generated in the virtual table generation step as a normal real table;  A work support program that is characterized by that!  [2] At least the interface program is automatically updated based on predetermined data mapping data created by the change operator in order to add or change or delete the virtual table items according to the change The work support program according to claim 1, further comprising an automatic update program.  [3] The work support program according to claim 1 or 2, wherein the automatic update program includes a real table update step of updating the real table based on the data mapping data. . [4] The work support program according to any one of claims 1 to 3, wherein the data mapping data is included. [5] The server computer is connected to a supporter terminal that can be operated by a work supporter who supports work by the worker so that data communication is possible, and the worker terminal captures an image at the work site. Imaging means for  The processing program transmits, as the electronic document, a work instruction electronic document transmission processing step for transmitting, to the worker terminal of the worker, a work instruction electronic document including at least information regarding work contents to be worked by the worker; The operator terminal image data of the video imaged by the imaging means transmitted from the operator terminal device in response to the operator's support request operation is specified as the operator who supports the operation, The work support program according to any one of claims 1 to 4, further comprising a worker terminal video data transmission step for performing a process for transmitting the identified work support person to the support terminal.  [6] The server computer is connected to a monitoring camera permanently installed at the work site so as to be able to perform data communication. The database includes monitoring power identification information that can individually identify each monitoring camera and the monitoring camera. Stored in association with site-specific information that can identify the work site where the camera is permanently installed, the work instruction electronic document includes site-specific information of the work site where the worker should perform work,  In the worker terminal video data transmission step, the processing program receives the support request information including the site specific information transmitted from the worker terminal in response to the support request operation. The monitoring camera identification information that is stored in association with the on-site identification information included in the requested assistance request information is specified, and the video captured by the monitoring camera identified by the specified monitoring camera identification information card is identified. A process for transmitting monitoring video data and worker terminal video data, which is a video captured by the imaging means of the worker terminal, to the supporter terminal of the identified work supporter is performed. The work support program according to any one of claims 1 to 5.