DATA VISUALIZATION APPARATUS, DATA PROCESSING METHOD, AND NON-TRANSITORY COMPUTER-READABLE STORAGE MEDIUM

A data visualization apparatus includes a data obtaining unit that obtains, from a database, target data that is at least one of measurement data or a calculation result of calculation using the measurement data and also that obtains identification information of a user, an authorization unit that grants, based on the identification information of the user, authority to perform access processing that is at least one of processing of obtaining the measurement data from the database or processing of performing calculation using the measurement data in the database to a processing unit, and the processing unit that performs, based on the target data obtained by the authority via the data obtaining unit, processing of creating a confirmation screen including the measurement data or the calculation result and processing of causing a display to display the confirmation screen.

TECHNICAL FIELD

The present disclosure relates to a data visualization apparatus, a data processing method, and a data processing program.

The present application claims the priority based on Japanese Patent Application No. 2019-76412 filed on Apr. 12, 2019, the entire contents of which are incorporated herein by reference.

BACKGROUND ART

Japanese Patent Application Laid-Open No. 2019-003691 (PTL 1) discloses the following technique. That is, a management apparatus includes: a first obtaining unit that obtains a measurement result by a sensor performing measurement for a facility and a time corresponding to the measurement result; a second obtaining unit that obtains a plurality of use periods of the facility and contents of management items corresponding to each of the use periods from a storage unit; and a data processing unit that performs processing of summarizing measurement information based on the measurement result for each of the contents, based on the measurement result and the corresponding time obtained by the first obtaining unit, and the contents and the corresponding use periods obtained by the second obtaining unit.

CITATION LIST

Patent Literature

SUMMARY OF INVENTION

A data visualization apparatus according to the present disclosure includes a data obtaining unit that obtains, from a database, target data that is at least one of measurement data or a calculation result of calculation using the measurement data and also obtains identification information of a user, an authorization unit that grants, based on the identification information of the user, authority to perform access processing that is at least one of processing of obtaining the measurement data from the database or processing of performing calculation using the measurement data in the database to a processing unit, and the processing unit that performs, based on the target data obtained by the authority via the data obtaining unit, processing of creating a confirmation screen including the measurement data or the calculation result and processing of causing a display to display the confirmation screen.

A data processing method according to the present disclosure is a data processing method for a data visualization apparatus, wherein the data processing method includes obtaining, from a database, target data that is at least one of measurement data or a calculation result of calculation using the measurement data and also obtaining identification information of a user, setting, based on the identification information of the user, authority to perform access processing that is at least one of processing of obtaining the measurement data from the database or processing of performing calculation using the measurement data in the database, and performing, based on the target data obtained by the authority, processing of creating a confirmation screen including the measurement data or the calculation result and processing of causing a display to display the confirmation screen.

A data processing program according to the present disclosure is a data processing program used in a data visualization apparatus, wherein the data processing program causes a computer to obtain, from a database, target data that is at least one of measurement data or a calculation result of calculation using the measurement data and also obtain identification information of a user, set, based on the identification information of the user, authority to perform access processing that is at least one of processing of obtaining the measurement data from the database or processing of performing calculation using the measurement data in the database, and perform, based on the target data obtained by the authority via the data obtaining unit, processing of creating a confirmation screen including the measurement data or the calculation result and processing of causing a display to display the confirmation screen.

An embodiment according to the present disclosure can be implemented not only as a data visualization apparatus including such characteristic processing units, but also as a semiconductor integrated circuit that implements a part or all of the data visualization apparatus, or as a system including the data visualization apparatus.

DETAILED DESCRIPTION

Conventionally, a technique for monitoring the state of a facility using a measurement result of a sensor has been developed.

Problems to be Solved by Present Disclosure

In the system including the above-described management apparatus, it is considered that the measurement result by the sensor, the measurement information based on the measurement result, and the like are stored in a database provided outside the management apparatus.

In order to use the database, a user needs to change the description of a database language such as SQL. Depending on the description of the SQL, the processing load on the database side increases.

However, only a limited number of people have knowledge about the database, and it is not easy for people who do not have sufficient expert knowledge about the database to smoothly use the database using the database language.

The present disclosure is made to solve the above-mentioned problem, an object of which is to provide a data visualization apparatus, a data processing method, and a data processing program that enable a smoother use of a database.

Advantageous Effects of Present Disclosure

According to the present disclosure, the database can be used more smoothly.

DESCRIPTION OF EMBODIMENTS OF PRESENT DISCLOSURE

First, contents of embodiments according to the present disclosure will be listed and described.

(1) A data visualization apparatus according to an embodiment of the present disclosure includes a data obtaining unit that obtains, from a database, target data that is at least one of measurement data or a calculation result of calculation using the measurement data and also obtains identification information of a user, an authorization unit that grants, based on the identification information of the user, authority to perform access processing that is at least one of processing of obtaining the measurement data from the database or processing of performing calculation using the measurement data in the database to a processing unit, and the processing unit that performs, based on the target data obtained by the authority via the data obtaining unit, processing of creating a confirmation screen including the measurement data or the calculation result and processing of causing a display to display the confirmation screen.

With this configuration, since various authority can be set for processing using the database in accordance with the type of user, appropriate authority can be set in accordance with the type of user, and an increase in the processing load on the database side can be suppressed. Therefore, in the configurations in which the measurement data obtained from the database is visualized, the database can be used more smoothly.

(2) Preferably, the processing unit includes a display component creating unit that, in accordance with an instruction from a user, creates or updates one or more display components constituting the confirmation screen, and a confirmation screen creating unit that, in accordance with an instruction from a user, creates or updates the confirmation screen by disposing the one or more display components created by the display component creating unit. The authorization unit grants, to the processing unit, the authority that allows the confirmation screen creating unit to obtain a smaller number of pieces of the target data than the display component creating unit.

With this configuration, it is possible to realize an excellent system in which various confirmation screens corresponding to various applications can be easily created using the display component, appropriate authority corresponding to the type of user are set, and an increase in the processing load on the database side is suppressed. In particular, by separating the authority related to the display components and the authority related to the confirmation screen, more effective authorization can be realized.

(3) More preferably, the processing unit further includes a display processing unit that performs processing of displaying the confirmation screen in accordance with an instruction from a user. The authorization unit grants, to the processing unit, the authority that allows the display processing unit to obtain a smaller number of pieces of the target data than the confirmation screen creating unit.

With this configuration, since the authority related to the display components, the authority related to the confirmation screen, and the authority related to the screen viewing can be separated, more effective authority setting can be realized.

(4) Preferably, the authority includes at least any one of authority to set a temporal range of the measurement data to be obtained from the database, authority to set a unit of time of the measurement data to be obtained from the database, and authority to set a type of calculation using the measurement data.

With the configuration in which such parameters are set, it is possible to effectively suppress an increase in the processing load on the database side.

(5) Preferably, the processing unit includes a display component creating unit that, in accordance with an instruction from a user, creates or updates one or more display components constituting the confirmation screen, and a confirmation screen creating unit that, in accordance with an instruction from a user, creates or updates the confirmation screen by disposing the one or more display components created by the display component creating unit. The data visualization apparatus further includes a restriction unit that, in a state in which the confirmation screen creating unit is granted the authority, limits at least one of a time taken to perform the access processing once or the number of times of the access processing per certain time.

With this configuration, access processing is limited separately from the authority, and an increase in the processing load on the database side can be more reliably suppressed.

(6) More preferably, the restriction unit makes a predetermined notification in response to a corresponding predetermined condition being satisfied by at least one of the time taken to perform the access processing once or the number of times of the access processing per certain time.

With this configuration, it is possible to warn a user who is authorized for the access processing of an increase in processing load on the database side.

(7) Preferably, the processing unit performs processing of further displaying a time taken for the access processing on the confirmation screen.

With this configuration, the user who is authorized for the access processing can easily recognize the state of the processing load on the database side.

(8) A data processing method according to an embodiment of the present disclosure is a data processing method for a data visualization apparatus. The data processing method includes obtaining, from a database, target data that is at least one of measurement data or a calculation result of calculation using the measurement data and also obtaining identification information of a user, setting, based on the identification information of the user, authority to perform access processing that is at least one of processing of obtaining the measurement data from the database or processing of performing calculation using the measurement data in the database, and performing, based on the target data obtained by the authority, processing of creating a confirmation screen including the measurement data or the calculation result and processing of causing a display to display the confirmation screen.

With this configuration, since various authority can be set for processing using the database in accordance with the type of user, it is possible to set appropriate authority in accordance with the type of user and to suppress an increase in the processing load on the database side. Therefore, in the configuration in which the measurement data obtained from the database is visualized, the database can be used more smoothly.

(9) A data processing program according to an embodiment of the present disclosure is a data processing program used in a data visualization apparatus. The data processing program causes a computer to obtain, from a database, target data that is at least one of measurement data or a calculation result of calculation using the measurement data and also obtain identification information of a user, set, based on the identification information of the user, authority to perform access processing that is at least one of processing of obtaining the measurement data from the database or processing of performing calculation using the measurement data in the database, and perform, based on the target data obtained by the authority via the data obtaining unit, processing of creating a confirmation screen including the measurement data or the calculation result and processing of causing a display to display the confirmation screen.

With this configuration, since various authority can be set for processing using the database in accordance with the type of user, appropriate authority can be set in accordance with the type of user, and an increase in the processing load on the database side can be suppressed. Therefore, in the configurations in which the measurement data obtained from the database is visualized, the database can be used more smoothly.

Hereinafter, embodiments according to the present disclosure will be described in detail with reference to the drawings. In the description of the drawings, like or corresponding elements are remarked by like reference numerals and redundant descriptions thereof will be omitted. At least some of the embodiments described below may be arbitrarily combined.

[Configuration and Basic Operation]

FIG. 1is a diagram illustrating a configuration of a management system according to an embodiment of the present disclosure.

Referring toFIG. 1, a management system201includes a data visualization apparatus101, a display131, servers132A and132B, and a database133.

Server132A is, for example, a Web server. Server132B is, for example, a REST (Representational State Transfer) API (Web Application Programming Interface) server. Server132A and server132B implement different Web APIs from each other.

More specifically, each of server132A and server132B prepares a URL (Uniform Resource Locator) for each processing, and receives a command such as a request, a response, or a post which are in accordance with an http (Hypertext Transfer Protocol) at the URL to perform processing in accordance with the received command.

In database133, for example, measurement data based on measurement results by one or more sensors (not illustrated) is stored. The measurement data includes, for example, a flow rate, a temperature, a measurement time, a measurement location, a sensor lot number, and the like.

Server132B obtains the measurement data from database133in accordance with the command, for example. Server132B performs a calculation using the obtained measurement data in accordance with the command, for example.

Data visualization apparatus101obtains target data, which is at least one of the measurement data or the calculation result using the measurement data, from database133via a network134such as the Internet and server132B, and displays a screen based on the obtained target data on display131.

Data visualization apparatus101and display131may be integrated. Network134may be a network other than the Internet, such as a local network.

Data visualization apparatus101includes a data obtaining unit11, a processing unit14, an authorization unit15, an input reception unit16, a storage unit17, and a restriction unit18. Processing unit14includes a display component creating unit21, a confirmation screen creating unit22, and a display processing unit23.

Data obtaining unit11obtains the target data. Based on the target data obtained by data obtaining unit11, processing unit14performs processing of displaying content related to the measurement data on a confirmation screen, that is, performs processing of creating a confirmation screen including the measurement data or the calculation result and processing of causing display131to display the confirmation screen.

For example, in processing unit14, display component creating unit21creates or updates one or more display components that constitute the confirmation screen in accordance with an instruction from a user.

For example, confirmation screen creating unit22creates or updates the confirmation screen by disposing the display components created by display component creating unit21in accordance with an instruction from a user.

For example, display processing unit23performs processing of displaying the confirmation screen on display131in accordance with an instruction from a user.

Storage unit17stores, for example, a plurality of OSS (Open Source Software) libraries for creating the corresponding display components.

The OSS libraries are, for example, flot for creating a graph and gantt-chart-d3 for creating a gantt chart.

Input reception unit16receives, for example, an input operation by a user via a keyboard or a mouse.

Upon receiving the input operation by the user, input reception unit16outputs information indicating the received input content to processing unit14.

More specifically, when data visualization apparatus101is activated and a predetermined operation is performed by the user via a keyboard, a mouse, or the like, for example, input reception unit16outputs operation information indicating the content of the operation performed by the user to processing unit14.

Processing unit14transmits an http request to server132A based on the operation information received from input reception unit16.

More specifically, processing unit14creates an http request including a URLa for login processing based on the operation information received from input reception unit16, and outputs the created http request and the operation information to data obtaining unit11.

Data obtaining unit11transmits the http request received from processing unit14to server132A.

Upon receiving the http request from data visualization apparatus101, server132A creates an http response including an HTML (HyperText Markup Language) file including a GUI (Graphical User Interface) for login processing based on the received http request, and transmits the created http response to data visualization apparatus101.

Upon receiving the http response from server132A, data visualization apparatus101performs, based on the received http response, processing of displaying, on display131, a screen on which the GUI for login processing is drawn on a Web browser.

More specifically, data obtaining unit11in data visualization apparatus101receives the http response transmitted from server132A, obtains the HTML file from the received http response, and outputs the HTML file to processing unit14.

Processing unit14obtains the GUI for login processing included in the HTML file received from data obtaining unit11, creates a screen on which the obtained GUI for login processing is drawn on the Web browser, and displays the created screen on display131.

For example, a user inputs his or her own “user ID (Identification)” and “password” in fields for inputting “user ID” and “password” in the GUI for login processing displayed on display131, and performs an operation of transmitting them to server132A to the Web browser.

Upon receiving the operation by the user, input reception unit16outputs a received input content, that is, the “user ID” and the “password” to processing unit14.

Processing unit14creates an http post including the “user ID” and the “password” based on the input content received from input reception unit16, and transmits the created http post to server132A via data obtaining unit11.

Server132A receives the http post from data visualization apparatus101and executes the login processing based on the received http post.

In the login processing, server132A determines whether to permit the login of the user having the user ID based on the “user ID” and the “password” included in the http post.

Then, when server132A determines to permit the login of the user having the user ID, server132A creates, for example, an http cookie indicating the user ID and a type of user, and transmits the created http cookie to data visualization apparatus101.

FIG. 2is a diagram illustrating an example of a type and authority of user in the management system according to the embodiment of the present disclosure.

Referring toFIG. 2, in management system201, the user is classified into, for example, any one of a system administrator, a display component creator, a confirmation screen creator, and a viewer.

The system administrator, the display component creator, the confirmation screen creator, and the viewer have, in this order, more authority for processing.

More specifically, the viewer can, for example, perform processing of viewing a confirmation screen created by an operation of the confirmation screen creator.

Data visualization apparatus101performs processing of displaying the confirmation screen on display131in accordance with an operation of the viewer.

The confirmation screen creator can, for example, perform processing of creating the confirmation screen in addition to the processing of viewing the confirmation screen.

Data visualization apparatus101creates the confirmation screen on which the display component created by an operation of the display component creator is disposed in accordance with the operation of the confirmation screen creator, and displays the created confirmation screen on display131.

In addition, the confirmation screen creator can determine whether to allow the viewer to view the created confirmation screen.

Thus, the viewer can view the confirmation screen permitted to be viewed by the confirmation screen creator.

On the other hand, when the confirmation screen creator does not permit the viewer to view the confirmation screen, for example, data visualization apparatus101performs processing of displaying a message indicating that the viewer is not permitted to view the confirmation screen on display131in response to the operation for viewing the confirmation screen by the viewer.

The display component creator can perform, for example, processing of creating a display component in addition to processing of creating and viewing the confirmation screen.

Data visualization apparatus101creates one or more display components constituting the confirmation screen in accordance with an operation of the display component creator.

The display component creator can determine whether to permit the confirmation screen creator to edit the display components created by the display component creator.

Thus, when the display component creator permits the confirmation screen creator to edit the display components, the confirmation screen creator can edit the display components.

The display component creator can determine whether to permit the viewer to view the display components included in the confirmation screen created by the confirmation screen creator.

Data visualization apparatus101does not display the display components in the confirmation screen on display131, for example, when the display component creator does not permit the viewer to view the display components.

The system administrator can perform a user management processing of managing the type of each user in management system201in addition to, for example, processing of creating the display components, creating the confirmation screen, and viewing the confirmation screen.

FIG. 3is a diagram illustrating an example of processing that can be performed for each user type in the management system according to the embodiment of the present disclosure.FIG. 3illustrates a case where the display component creator permits the confirmation screen creator to edit the display components and the confirmation screen creator permits the viewer to view the confirmation screen.

Referring toFIG. 3, the type of user who can execute the user management processing is the system administrator. The types of user who can execute processing of creating the display components are the system administrator and the display component creator. The types of user who can edit the display components are the system administrator, the display component creator, and the confirmation screen creator. The types of user who can view the display components are the system administrator, the display component creator, the confirmation screen creator, and the viewer. The types of user who can execute processing of creating the confirmation screen are the system administrator, the display component creator, and the confirmation screen creator. The types of user who can view the confirmation screen are the system administrator, the display component creator, the confirmation screen creator, and the viewer.

FIG. 4is a diagram illustrating another example of possible processing for each user type in the management system according to the embodiment of the present disclosure.FIG. 4illustrates a case where the display component creator does not permit the confirmation screen creator to edit the display components and the confirmation screen creator does not permit the viewer to view the confirmation screen.

Referring toFIG. 4, the type of user who can execute the user management processing is the system administrator. The types of user who can execute processing of creating the display components are the system administrator and the display component creator. The types of user who can edit the display components are the system administrator and the display component creator. The types of user who can view the display components are the system administrator, the display component creator, and the confirmation screen creator. The types of user who can execute processing of creating the confirmation screen are the system administrator, the display component creator, and the confirmation screen creator. The type of users who can view the confirmation screen are the system administrator, the display component creator, and the confirmation screen creator.

Referring again toFIG. 1, authorization unit15can set a plurality of types of authority for access processing which is at least one of obtaining measurement data from database133or calculation using the measurement data in database133.

More specifically, data obtaining unit11in data visualization apparatus101receives the http cookie transmitted from server132A and outputs the received http cookie to processing unit14. That is, data obtaining unit11obtains the user ID.

Processing unit14outputs the http cookie received from data obtaining unit11to authorization unit15.

Authorization unit15sets authority for processing performed by processing unit14in accordance with the type of user indicated by the http cookie received from processing unit14.

Specifically, for example, when authorization unit15receives an http cookie indicating the confirmation screen creator from processing unit14, authorization unit15limits processing executable by processing unit14to processing of displaying the confirmation screen on display131and processing of creating the confirmation screen, and outputs restriction information indicating the restricted content to processing unit14.

When authorization unit15receives, for example, an http cookie indicating the display component creator from processing unit14, authorization unit15limits processing executable by processing unit14to processing of displaying the confirmation screen on display131, processing of creating the confirmation screen, and processing of creating the display components, and outputs restriction information indicating the restricted content to processing unit14.

When authorization unit15receives, for example, an http cookie indicating the system administrator from processing unit14, authorization unit15does not limit processing executable by processing unit14and outputs restriction information indicating that the restriction is not performed to processing unit14.

Processing unit14receives the restriction information from authorization unit15and performs processing of displaying, on display131, a top screen corresponding to the restriction information, that is, the type of user. For example, the top screen includes a list of display component types and a list of confirmation screen types.

FIG. 5is a diagram illustrating an example of the top screen displayed on the display in the management system according to the embodiment of the present disclosure.FIG. 5illustrates the top screen when the type of user is the display component creator.

Referring toFIG. 5, an upper region r11of the top screen includes a confirmation screen table Tab1indicating a correspondence between one or more confirmation screens created by confirmation screen creating unit22and buttons B1for displaying the respective confirmation screens on display131.

A lower region r12of the top screen includes a display component table Tab2indicating a correspondence relationship between one or more display components created by display component creating unit21and buttons B2for displaying the respective display components on display131.

Above confirmation screen table Tab1in region r11, a button B3for causing confirmation screen creating unit22to create a new confirmation screen is included.

Hyperlinks of URLs corresponding to the respective processing are set in buttons B1to B4, respectively.

Here, a top screen in the case where the type of user is a confirmation screen creator does not include region r12corresponding to processing of creating the display component, as compared with the top screen illustrated inFIG. 5, for example.

Further, a top screen in the case where the type of user is a viewer does not include region r12corresponding to processing of creating the display component and button B3in region r11, as compared with the top screen illustrated inFIG. 5, for example.

[Creation of Display Component]

For example, when a user whose type is a display component creator creates, as a display component, a graph G1based on a target data as an example of content related to measurement data, the user performs an operation of pressing button B4using a keyboard, a mouse, or the like to data visualization apparatus101.

Referring again toFIG. 1, when input reception unit16receives the operation by the user, for example, input reception unit16outputs operation information indicating the content of the operation by the user to processing unit14.

Processing unit14transmits an http request including a URLb for creating the display component to server132A via data obtaining unit11, based on the operation information received from input reception unit16.

Server132A receives, for example, the http request from data visualization apparatus101, and based on the received http request, transmits, to data visualization apparatus101, an http response including an HTML file containing a program (hereinafter also referred to as a creation program) described using JavaScript (registered trademark) or the like for creating the display components.

When processing unit14in data visualization apparatus101receives the HTML file included in the http response from server132A via data obtaining unit11, processing unit14obtains the creation program from the received HTML file and executes the obtained creation program.

Thus, display component creating unit21creates a new display component.

More specifically, when the creation program is executed by processing unit14, display component creating unit21creates a selection screen for allowing the user to select the type of display component to be created, and outputs the created selection screen to display processing unit23.

Display processing unit23performs processing of displaying the selection screen received from display component creating unit21on display131.

FIG. 6is a diagram illustrating an example of the selection screen displayed on the display in the management system according to the embodiment of the present disclosure.

Referring toFIG. 6, the selection screen includes a plurality of icons for each type of display components, for example. Specifically, the selection screen includes, for example, an icon V1for creating a display component such as a bar graph and a line graph, an icon V2for creating a display component of a table, an icon V3for creating a display component of Andon, an icon V4for creating a display component of a map, and the like.

The user can create a desired type of display component by selecting one of the icons on the selection screen.

More specifically, the user can create a display component such as a bar graph and a line graph by selecting icon V1on the selection screen, for example.

For example, the user performs an operation of selecting icon V1to data visualization apparatus101.

For example, when input reception unit16receives the operation by the user, input reception unit16outputs operation information indicating the content of the operation by the user to display component creating unit21in processing unit14.

Based on the operation information received from input reception unit16, display component creating unit21creates a detailed screen that allows the user to select the type of graph to be created based on the operation information received from input reception section16, and outputs the created detailed screen to display processing unit23.

Display processing unit23performs processing of displaying the detailed screen received from display component creating unit21on display131.

FIG. 7is a diagram illustrating an example of the detailed screen displayed on the display in the management system according to the embodiment of the present disclosure.

Referring toFIG. 7, the detailed screen includes a region r21including a plurality of types of line graph 1 whose horizontal axes represent time, a region r22including a plurality of types of line graph 2 whose horizontal axes represent a category, a region r23including a plurality of types of area graph 1 whose horizontal axes represent time, and a region r24including a plurality of types of area graph 2 whose horizontal axes represent a category.

Region r21includes a type “1-1” in which the background color is black and one line graph 1 is drawn, a type “1-2” in which the background color is black and a plurality of line graphs 1 are drawn, a type “1-3” in which the background color is white and one line graph 1 is drawn, and a type “1-4” in which the background color is white and a plurality of line graphs 1 are drawn.

Region r22includes a type “2-1” in which the background color is black and one line graph 2 is drawn, a type “2-2” in which the background color is black and a plurality of line graphs 2 are drawn, a type “2-3” in which the background color is white and one line graph 2 is drawn, and a type “2-4” in which the background color is white and a plurality of line graphs 2 are drawn.

Region r23includes a type “3-1” in which the background color is black and one area graph 1 is drawn, a type “3-2” in which the background color is black and a plurality of area graphs 1 are drawn, a type “3-3” in which the background color is white and one area graph 1 is drawn, and a type “3-4” in which the background color is white and a plurality of area graphs 1 are drawn.

Region r24includes a type “4-1” in which the background color is black and one area graph 2 is drawn, a type “4-2” in which the background color is black and a plurality of area graphs 2 are drawn, a type “4-3” in which the background color is white and one area graph 2 is drawn, and a type “4-4” in which the background color is white and a plurality of area graphs 2 are drawn.

For example, the user performs an operation of selecting type “1-3” to data visualization apparatus101.

For example, when input reception unit16receives the operation by the user, input reception unit16outputs operation information indicating the content of the operation by the user to display component creating unit21in processing unit14.

Based on the operation information received from input reception unit16, display component creating unit21creates an initial setting screen that allows the user to set initial parameters of a graph to be created, and outputs the created initial setting screen to display processing unit23.

Display processing unit23performs processing of displaying the initial setting screen received from display component creating unit21on display131.

FIG. 8is a diagram illustrating an example of the initial setting screen that is displayed on the display in the management system according to the embodiment of the present disclosure.

Referring toFIG. 8, the initial setting screen includes, for example, an image Pic1indicating that a graph to be created is of type “1-3”, input fields Ip11to Ip13for inputting “graph ID”, “graph name”, and “update frequency” as initial parameters, respectively, and a button B5for causing display component creating unit21to create the graph.

For example, the user inputs a part or all of “graph ID”, “graph name”, and “update frequency” into the respective input fields, and performs an operation of pressing button B5to the Web browser.

For example, the user may perform an operation of pressing button B5to the Web browser without inputting “graph ID”, “graph name”, and “update frequency” into the respective input fields.

Upon receiving the operation by the user, input reception unit16outputs the input content of each input field to display component creating unit21in processing unit14.

Here, the creation program includes, for example, an instruction described using SQL (hereinafter also referred to as a temporary SQL instruction) for performing access processing which is at least one of obtaining measurement data from database133or calculation using measurement data in database133.

Display component creating unit21creates an http post including the temporary SQL instruction and a URLc for access processing based on the input content received from input reception unit16, and outputs the created http post to processing unit14.

Processing unit14transmits the http post output from display component creating unit21to server132B via data obtaining unit11.

Server132B receives the http post from data visualization apparatus101and executes access processing based on the received http post.

Server132B obtains the temporary SQL instruction included in the received http post, and performs at least one of obtaining measurement data from database133or calculation using measurement data in database133in accordance with the obtained temporary SQL instruction.

More specifically, for example, when the content of the temporary SQL instruction is an instruction for obtaining measurement data from database133, server132B obtains measurement data indicated by the temporary SQL instruction.

For example, when the content of the temporary SQL instruction is an instruction for performing a calculation using measurement data in database133, server132B obtains measurement data indicated by the temporary SQL instruction and performs the calculation such as calculation of an average value using the obtained measurement data.

Target data is, for example, a format in accordance with a JavaScript Object Notation (JSON).

Then, server132B creates an http response including the target data and transmits the http response to data visualization apparatus101.

Upon receiving the http response from server132B, data obtaining unit11in data visualization apparatus101obtains the target data included in the received http response, and outputs the obtained target data to display component creating unit21in processing unit14.

Display component creating unit21uses the target data received from data obtaining unit11to draw a graph based on the target data as a display component.

More specifically, display component creating unit21obtains, for example, an OSS library for drawing a graph of type “1-3” from storage unit17, and draws graph G1based on the target data received from data obtaining unit11as a display component using the obtained OSS library.

Display component creating unit21then creates a component editing screen that includes the drawn graph G1and a region r3for editing graph G1, and outputs the created component editing screen to display processing unit23.

Display processing unit23performs processing of displaying the component editing screen received from display component creating unit21on display131.

Display component creating unit21can change content of the display component in accordance with one or more parameters.

FIG. 9is a diagram illustrating an example of the component editing screen displayed on the display in the management system according to the embodiment of the present disclosure.

Referring toFIG. 9, on the component editing screen, region r3is displayed so as to overlap graph G1. Region r3includes “graphConfig” that includes an input field Ip21for a graph title and an input field Ip22for a legend, “viewConfig” that includes an input field Ip23for a graph color and an input field Ip24for a shape, and “dataConfig” that includes an input field Ip25for a temporal range of the graph, an input field Ip26for an unit of time of the graph, and an input field Ip27for inputting a type of calculation using measurement data in the graph.

In “graphConfig”, the user can set a graph title and a legend as examples of parameters.

In “dataConfig”, the user can set a graph color and a shape as examples of parameters.

In “viewConfig”, the user can set a temporal range of the graph, a unit of time of the graph, and a type of calculation using measurement data in the graph as examples of parameters.

In addition, a plurality of buttons including a button B6for editing SQL are displayed in an upper portion of region r3.

When editing SQL, the user performs an operation of pressing button B6to the Web browser.

For example, when input reception unit16receives the operation by the user, input reception unit16outputs operation information indicating the content of the operation by the user to display component creating unit21in processing unit14.

Display component creating unit21creates a dataConfig screen for editing a temporary SQL instruction based on the operation information received from input reception unit16, and outputs the created dataConfig screen to display processing unit23.

Display processing unit23performs processing of displaying the dataConfig screen received from display component creating unit21on display131.

FIG. 10is a diagram illustrating an example of the dataConfig screen displayed on the display in the management system according to the embodiment of the present disclosure.

Referring toFIG. 10, in the above case, an instruction for performing the access processing, that is, a temporary SQL instruction is displayed on the dataConfig screen.

The user performs an operation of editing the temporary SQL instruction displayed on display131to the Web browser using a keyboard or a mouse.

Specifically, the user performs, to the Web browser, an operation of inputting an SQL instruction whose content is to obtain, from database133, measurement data of a flow rate at a predetermined time interval in a predetermined period measured by a certain sensor, using, for example, the keyboard or the mouse.

Referring again toFIG. 1, for example, upon receiving the operation by the user, input reception unit16outputs operation information indicating the content of the operation by the user to display component creating unit21in processing unit14.

Display component creating unit21creates a new SQL instruction by updating the temporary SQL instruction based on the operation information received from input reception unit16. Display component creating unit21then creates an http post including the created new SQL instruction and the URLc for access processing, and transmits the created http post to server132B via data obtaining unit11. Hereinafter, each of the temporary SQL instruction and the new SQL instruction is also referred to as an SQL instruction.

Server132B receives the http post from data visualization apparatus101, obtains the new SQL instruction included in the received http post, and obtains, from database133, measurement data of a flow rate at the predetermined time interval in the period indicated by the new SQL instruction in accordance with the obtained new SQL instruction.

Server132B then creates an http response including the obtained measurement data, which is target data, and transmits the http response to data visualization apparatus101.

Upon receiving the http response from server132B, data obtaining unit11in data visualization apparatus101obtains the target data included in the received http response, and outputs the obtained target data to display component creating unit21in processing unit14.

Display component creating unit21uses the target data received from data obtaining unit11to create a component editing screen including graph G1based on the target data, and outputs the created component editing screen to display processing unit23.

Display processing unit23performs processing for displaying the component editing screen received from display component creating unit21on display131.

Data visualization apparatus101may have a configuration in which the SQL instruction is edited by an operation in which the user inputs, as parameters, the temporal range of graph G1, the unit of time of graph G1, and the type of calculation using the measurement data in graph G1into the respective input fields Ip25, Ip26, and Ip27in the dataConfig of the component editing screen illustrated inFIG. 9.

For example, when input reception unit16receives the operation by the user, input reception unit16outputs input content information indicating input content by the user to display component creating unit21in processing unit14.

Based on the input content information received from input reception unit16, display component creating unit21determines whether it is necessary to edit the SQL instruction in accordance with the change of each of the parameters. When display component creating unit21determines that the SQL instruction needs to be changed, display component creating unit21edits corresponding parts in the SQL instruction in accordance with the changed parameters.

Authorization unit15in data visualization apparatus101sets authority based on the content of the SQL instruction. The authority include at least any one of authority that sets the temporal range and the unit of time of measurement data to be obtained from database133, or authority that sets the type of calculation using the measurement data.

More specifically, display component creating unit21outputs the content of the edited SQL instruction to authorization unit15, for example, when the SQL instruction is edited via the dataConfig screen illustrated inFIG. 10by a user whose type is the display component creator, or when display component creating unit21edits the SQL instruction by the user's input into each of the input fields in the dataConfig of the component editing screen illustrated inFIG. 9.

Based on the content of the SQL instruction received from display component creating unit21, authorization unit15can set a plurality of types of authority for access processing which are at least one of processing of obtaining the measurement data from database133or processing of performing calculation using the measurement data in database133.

For example, authorization unit15grants narrower authority to confirmation screen creating unit22than to display component creating unit21. For example, authorization unit15grants, to processing unit14, the authority that allows confirmation screen creating unit22to obtain a smaller number of pieces of the target data than display component creating unit21.

Specifically, for example, when the content of the SQL instruction received from display component creating unit21is content which enables confirmation screen creating unit22to set the temporal range and the unit of time of the measurement data to be obtained from database133, authorization unit15outputs, to confirmation screen creating unit22, authority information indicating that confirmation screen creating unit22has the authority to make such a setting.

Accordingly, a user whose type is a confirmation screen creator can set the temporal range and the unit of time of the measurement data to be obtained from database133in processing of creating the confirmation screen.

Also, for example, authorization unit15grants narrower authority to display processing unit23than to confirmation screen creating unit22. For example, the authorization unit15grants, to processing unit14, the authority that allows display processing unit23to obtain a smaller number of pieces of the target data than confirmation screen creating unit22.

Specifically, for example, when the content of the SQL instruction received from display component creating unit21is content which enables display processing unit23to set the temporal range of the measurement data to be obtained from database133, authorization unit15outputs, to display processing unit23, authority information indicating that display processing unit23has the authority to make such a setting.

Accordingly, a user whose type is a viewer can set the temporal range of the display component disposed on the confirmation screen created by a user whose type is the confirmation screen creator.

For example, when a user whose type is a display component creator edits a graph title and a legend as parameters, the user performs, to the Web browser, an operation of inputting a new graph title and a new legend into input fields Ip21and Ip22on the component editing screen illustrated inFIG. 9.

Referring again toFIG. 1, for example, upon receiving the operation by the user, input reception unit16outputs operation information indicating the content of the operation by the user to display component creating unit21in processing unit14.

Based on the operation information received from input reception unit16, display component creating unit21creates a component editing screen including graph G1in which a new graph title and a legend are set, and outputs the created component editing screen to display processing unit23.

Display processing unit23performs processing for displaying the component editing screen received from display component creating unit21on display131.

For example, when editing a graph color and a shape as parameters, the user performs, to the Web browser, an operation of inputting a new graph color and a new shape into input fields Ip23and Ip24, respectively, on the component editing screen illustrated inFIG. 9.

For example, when input reception unit16receives the operation by the user, input reception unit16outputs operation information indicating the content of the operation by the user to display component creating unit21in processing unit14.

Based on the operation information received from input reception unit16, display component creating unit21creates a component editing screen including graph G1in which the new graph color and the shape are set, and outputs the created component editing screen to display processing unit23.

Display processing unit23performs processing of displaying the component editing screen received from display component creating unit21on display131.

Thereafter, display component creating unit21transmits an http post including the SQL instruction and the URLc for access processing to server132B at each time interval set in “update frequency” on the initial setting screen illustrated inFIG. 8.

Accordingly, display component creating unit21obtains new target data from database133via server132B and data obtaining unit11at each time interval set in the “update frequency”, and uses the obtained target data to update the display component such as graph G1based on the target data.

Display component creating unit21stores the created display component in storage unit17in accordance with, for example, an operation by the user.

More specifically, for example, the user performs, to the Web browser, an operation of pressing an “overwrite save” button for saving the created display component among a plurality of buttons on the component editing screen illustrated inFIG. 9.

For example, when input reception unit16receives the operation by the user, input reception unit16outputs operation information indicating the content of the operation by the user to display component creating unit21in processing unit14.

Display component creating unit21stores display component information including the created SQL instruction and the content of the set parameters in storage unit17, based on the operation information received from input reception unit16.

Thus, the new display component created by display component creating unit21and button B2for displaying the display component on display131are added to display component table Tab2on the top screen illustrated inFIG. 5.

[Update of Display Component]

For example, a user whose type is a display component creator performs, to the Web browser, an operation of pressing button B2corresponding to graph G1on the top screen illustrated inFIG. 5using a keyboard, a mouse, or the like.

Referring again toFIG. 1, when input reception unit16receives the operation by the user, for example, input reception unit16outputs operation information indicating the content of the operation by the user to processing unit14.

Processing unit14transmits an http request including the URLb for creating a display component to server132A via data obtaining unit11based on the operation information received from input reception unit16.

Upon receiving the http request from data visualization apparatus101, server132A transmits an http response including an HTML file storing a creation program to data visualization apparatus101based on the received http request.

When processing unit14in data visualization apparatus101receives the HTML file included in the http response from server132A via data obtaining unit11, processing unit14obtains the creation program from the received HTML file.

Processing unit14obtains display component information corresponding to graph G1from storage unit17based on the operation information received from input reception unit16. Processing unit14then executes the creation program in which the temporary SQL instruction in the obtained creation program is changed to the SQL instruction included in the obtained display component information.

As a result, the component editing screen including graph G1corresponding to the display component information is displayed on display131.

In data visualization apparatus101, the display component is not limited to graph G1, and may be a different type of graph, table, Andon, process management table, Gantt chart, map information, box plot, or the like.

FIG. 11is a diagram illustrating an example of the display component in the management system according to the embodiment of the present disclosure.

FIG. 11illustrates a WBGT (Wet Bulb Globe Temperature) table as an example of the display component.

Referring toFIG. 11, the WBGT table indicates a correspondence of temperature and relative humidity to heat stress index calculated based on the temperature and the relative humidity.

In the WBGT table, different colors are used in accordance with a value of the heat stress index. Specifically, the color for a heat stress index less than 25, the color for a heat stress index of 25 to 28, the color for a heat stress index of 29 to 31, and the color for a heat stress index of 32 or more are different from each other. InFIG. 11, different colors are indicated by different hatchings.

For example, a class of the heat stress index illustrated in the WBGT table is displayed below the WBGT table. Specifically, the class for a heat stress index of less than 25 represents “Caution”, the class for a heat stress index of 25 to 28 represents “Warning”, the class for a heat stress index of 29 to 31 represents “Severe Warning”, and the class for a heat stress index of 32 or more represents “Danger”.

For example, when creating the WBGT table, a user selects icon V2on the selection screen illustrated inFIG. 6.

Then, the user creates the WBGT table, for example, by performing an operation to data visualization apparatus101in accordance with the screen displayed on display131.

FIG. 12is a diagram illustrating an example of the display component in the management system according to the embodiment of the present disclosure.FIG. 12illustrates a plurality of Andons An as an example of the display component. Andon is a display method of notifying a user of a warning according to displayed colors.

Referring toFIG. 12, Andons An indicate, for example, heat stress indices illustrated in the WBGT table. The colors of Andons An are colors corresponding to heat stress indices according to the WBGT table, for example. InFIG. 12, different colors are represented by different hatchings.

For example, when creating Andons, a user selects icon V3on the selection screen illustrated inFIG. 6.

For example, the user then creates Andons by performing an operation to data visualization apparatus101in accordance with a screen displayed on display131.

FIG. 13is a diagram illustrating an example of the display component in the management system according to the embodiment of the present disclosure.FIG. 13illustrates map information as an example of the display component.

Referring toFIG. 13, the map information indicates, for example, a floor plan of a two storied factory to be managed by management system201.

When creating the map information, for example, a user selects icon V4on the selection screen illustrated inFIG. 6.

For example, the user then creates the map information by performing an operation to data visualization apparatus101in accordance with a screen displayed on display131.

A user whose type is a confirmation screen creator or a display component creator, for example, performs, to data visualization apparatus101, an operation of pressing button B3on the top screen illustrated inFIG. 5using a keyboard, a mouse, or the like.

Referring again toFIG. 1, when input reception unit16receives the operation by the user, for example, input reception unit16outputs operation information indicating the content of the operation by the user to processing unit14.

Based on the operation information received from input reception unit16, processing unit14transmits an http request including the URLd for creating a confirmation screen to server132A via data obtaining unit11.

When the http request is received from data visualization apparatus101, server132A transmits to data visualization apparatus101, based on the received http request, an http response including an HTML file containing a program (hereinafter also referred to as a display program) described using JavaScript (registered trademark) or the like for displaying the confirmation screen.

When processing unit14in data visualization apparatus101receives the HTML file included in the http response from server132A via data obtaining unit11, processing unit14obtains the display program from the received HTML file and executes the obtained display program.

Accordingly, confirmation screen creating unit22creates the confirmation screen in which one or more display components created by display component creating unit21are disposed.

More specifically, when the display program is executed by processing unit14, confirmation screen creating unit22creates a layout screen for disposing the display components, and outputs the created layout screen to display processing unit23.

Display processing unit23performs processing for displaying the layout screen received from confirmation screen creating unit22on display131.

FIG. 14is a diagram illustrating an example of the layout screen displayed on the display in the management system according to the embodiment of the present disclosure.

Referring toFIG. 14, the layout screen includes a region r4in which a display component is to be disposed. A plurality of buttons for selecting the display component to be disposed are included in an upper part of region r4.

The user performs an operation of pressing a button corresponding to the display component to be disposed among the plurality of buttons to the Web browser. Then, the user performs, to the Web browser, an operation of selecting a position where the display component is to be disposed in region r4.

For example, when receiving the operation by the user, input reception unit16outputs operation information indicating the content of the operation by the user to confirmation screen creating unit22in processing unit14.

Confirmation screen creating unit22disposes the display component in region r4in accordance with the operation information received from input reception unit16.

FIG. 15is a diagram illustrating an example of a screen in which a display component is disposed on a layout screen in the management system according to the embodiment of the present disclosure.

Referring toFIG. 15, the display component is disposed at a position P in region r4. The display component includes a button B7for selecting content of the display component.

Confirmation screen creating unit22can select the content of the display component on the confirmation screen by setting one or more parameters in accordance with an instruction from the user.

For example, the user performs an operation of pressing button B7to the Web browser.

For example, when receiving the operation by the user, input reception unit16outputs operation information indicating the content of the operation by the user to confirmation screen creating unit22in processing unit14.

Based on the operation information received from input reception unit16, confirmation screen creating unit22creates a content selection screen including a table Tab3indicating display components created by display component creating unit21, and outputs the created content selection screen to display processing unit23.

FIG. 16is a diagram illustrating an example of the content selection screen displayed on the display in the management system according to the embodiment of the present disclosure.

Referring toFIG. 16, table Tab3illustrates a correspondence between one or more display components created by display component creating unit21and types of the display components.

Display processing unit23performs processing of displaying the content selection screen received from confirmation screen creating unit22on display131.

The user performs, to the Web browser, an operation of selecting one display component, for example, graph G1from table Tab3on the content selection screen.

For example, upon receiving the operation by the user, input reception unit16outputs operation information indicating the content of the operation by the user to confirmation screen creating unit22in processing unit14.

Confirmation screen creating unit22obtains a SQL instruction included in the display component information corresponding to graph G1from storage unit17based on the operation information received from input reception unit16.

Then, confirmation screen creating unit22creates an http post including the obtained SQL instruction and the URLc for access processing, and transmits the created http post to server132B via data obtaining unit11.

Upon receiving the http post from data visualization apparatus101, server132B obtains the SQL instruction included in the received http post, and performs at least one of processing of obtaining measurement data from database133or processing of calculation using the measurement data in database133in accordance with the obtained SQL instruction.

Then, server132B creates an http response including target data which is at least one of the obtained measurement data or the calculation result of calculation using the measurement data, and transmits the http response to data visualization apparatus101.

Upon receiving the http response from server132B, data obtaining unit11in data visualization apparatus101obtains the target data included in the received http response, and outputs the obtained target data to confirmation screen creating unit22in processing unit14.

Confirmation screen creating unit22then obtains, for example, an OSS library for drawing graph G1from storage unit17, and draws graph G1based on the target data received from data obtaining unit11in the display component disposed on the layout screen using the obtained OSS library.

FIG. 17is a diagram illustrating an example of a screen on which a display component is disposed in the layout screen in the management system according to the embodiment of the present disclosure.

Referring toFIG. 17, graph G1is disposed as a display component at position P illustrated inFIG. 15.

Confirmation screen creating unit22can dispose a plurality of display components on the layout screen by setting one or more parameters of the display components, for example.

More specifically, the user can create a layout screen in which one or more desired display components are disposed by repeatedly performing the above-described operation.

FIG. 18is a diagram illustrating an example of a layout screen in which a plurality of display components are disposed in the management system according to the embodiment of the present disclosure.

Referring toFIG. 18, a plurality of graphs G1having one or more different parameters are disposed in region r4of the layout screen.

For example, the user selects any one of the plurality of graphs G1and performs an operation of changing a parameter of the selected graph G1to the Web browser.

For example, upon receiving the operation by the user, input reception unit16outputs operation information indicating the content of the operation by the user to confirmation screen creating unit22in processing unit14.

Confirmation screen creating unit22creates a parameter setting screen for changing parameters of graph G1based on the operation information received from input reception unit16, and outputs the created parameter setting screen to display processing unit23.

Display processing unit23performs processing of displaying the parameter setting screen received from display component creating unit21on display131.

FIG. 19is a diagram illustrating an example of the parameter setting screen in the management system according to the embodiment of the present disclosure.

Referring toFIG. 19, the parameter setting screen includes an input field Ip31for a graph title, an input field Ip32for a legend, an input field Ip33for a graph color, and an input field Ip34for a shape.

The parameter setting screen includes, for example, an input field Ip35for a temporal range of graph G1, an input field Ip36for a unit of time of graph G1, and an input field Ip37for inputting the type of calculation using measurement data in graph G1.

The parameter setting screen includes an input field Ip38for a graph ID of graph G1and an input field Ip39for a graph name of graph G1.

Also, confirmation screen creating unit22limits the types of parameters that can be set on the parameter setting screen based on authority information received from authorization unit15described above.

Thus, confirmation screen creating unit22is granted narrower authority than display component creating unit21by authorization unit15.

More specifically, confirmation screen creating unit22creates a parameter setting screen in which the input of input field Ip35is limited, for example, in a case where the authority information having content for limiting the temporal range of measurement data to be obtained from database133is received from authorization unit15.

That is, confirmation screen creating unit22is limited in authority for access processing.

FIG. 20is a diagram illustrating another example of the parameter setting screen in the management system according to the embodiment of the present disclosure.

Referring toFIG. 20, in the parameter setting screen in the state where the authority for access processing is limited, for example, a fixed value is displayed in input field Ip35, as compared with the parameter setting screen illustrated inFIG. 18.

The parameter setting screen in the state in which the authority for access processing is limited is not limited to the display of the fixed value in input field Ip35, and input field Ip35may not be displayed.

Referring again toFIGS. 1 and 19, when input reception unit16receives, for example, an operation of changing a parameter by a user, input reception unit16outputs operation information indicating the content of the operation by the user to confirmation screen creating unit22in processing unit14.

Confirmation screen creating unit22obtains a SQL instruction included in the corresponding display component information from storage unit17based on the operation information received from input reception unit16, and edits the corresponding parts in the SQL instruction in accordance with the changed parameters.

Confirmation screen creating unit22then creates an http post including the edited SQL instruction and the URLc for access processing, and transmits the created http post to server132B via data obtaining unit11.

Server132B receives the http post from data visualization apparatus101, obtains the SQL instruction included in the received http post, and performs at least one of processing of obtaining measurement data from database133or processing of calculation using the measurement data in database133in accordance with the obtained SQL instruction.

Server132B then creates an http response including target data which is at least one of the obtained measurement data or the calculation result of calculation using the measurement data, and transmits the http response to data visualization apparatus101.

Upon receiving the http response from server132B, data obtaining unit11in data visualization apparatus101obtains the target data included in the received http response, and outputs the obtained target data to confirmation screen creating unit22in processing unit14.

Then, confirmation screen creating unit22obtains, for example, an OSS library for drawing graph G1from storage unit17, and draws graph G1based on the target data received from data obtaining unit11in the display component disposed in the layout screen by using the obtained OSS library.

Further, confirmation screen creating unit22stores the created confirmation screen in storage unit17in accordance with, for example, an operation by a user.

More specifically, for example, in the layout screen illustrated inFIG. 18, the user performs an operation for saving the layout screen to the Web browser.

For example, when receiving the operation by the user, input reception unit16outputs operation information indicating the content of the operation by the user to confirmation screen creating unit22in processing unit14.

Based on the operation information received from input reception unit16, confirmation screen creating unit22stores, in storage unit17, confirmation screen information including each of the content of the SQL instruction and the set parameters of one or more display components included in the layout screen.

Thus, the new confirmation screen created by confirmation screen creating unit22and button B1for displaying the confirmation screen on display131are added to confirmation screen table Tab1on the top screen illustrated inFIG. 5. Thus, confirmation screen creating unit22can create a plurality of confirmation screens.

A user whose type is a viewer, a confirmation screen creator, or a display component creator performs, for example, an operation of pressing button B1corresponding to “confirmation screen1” on the top screen illustrated inFIG. 5using a keyboard, a mouse, or the like to the Web browser.

Referring again toFIG. 1, when input reception unit16receives the operation by the user, for example, input reception unit16outputs operation information indicating the content of the operation by the user to processing unit14.

Based on the operation information received from input reception unit16, processing unit14transmits an http request including the URLd for creating a confirmation screen to server132A via data obtaining unit11based on the operation information received from input reception unit16.

Upon receiving the http request from data visualization apparatus101, server132A transmits an http response including an HTML file storing a display program to data visualization apparatus101based on the received http request.

When processing unit14in data visualization apparatus101receives the HTML file included in the http response from server132A via data obtaining unit11, processing unit14obtains the display program from the received HTML file.

Processing unit14also obtains confirmation screen information corresponding to “confirmation screen1” from storage unit17based on the operation information received from input reception unit16. Then, processing unit14reflects the obtained confirmation screen information on the obtained display program and executes the display program.

As a result, a layout screen corresponding to the confirmation screen information is displayed on display131.

Further, for example, confirmation screen creating unit22can create a confirmation screen in which a plurality of types of display components are disposed by setting one or more parameters, based on authority set by a user's operation and authorization unit15.

FIG. 21is a diagram illustrating an example of a layout screen in which a plurality of types of display components are disposed in the management system according to the embodiment of the present disclosure.

Referring toFIG. 21, the layout screen includes, for example, the WBGT table illustrated inFIG. 11, the Andons An illustrated inFIG. 12, and the map information illustrated inFIG. 13.

In the layout screen, heat stress indices at a plurality of locations in the two storied factory are indicated using Andons An.

The user can check heat stress indices and classes of the heat stress indices at the plurality of locations in the two storied factory by using the layout screen, for example.

FIG. 22is a diagram illustrating an example of a layout screen in which a plurality of types of display components are disposed in the management system according to the embodiment of the present disclosure.

The layout screen illustrated inFIG. 22is used, for example, to manage operating time of a plurality of components.

Referring toFIG. 22, the layout screen includes Andons An1to An9created by display component creating unit21.

Andon An1indicates that an operating time of a component A1is 5297 hours. Andon An2indicates that an operating time of a component A2is 4498 hours. Andon An2indicates that an operating time of a component A3is 5949 hours. Andon An4indicates that an operating time of a component A4is 12630 hours. Andon An5indicates that an operating time of a component A5is 2518 hours. Andon An6indicates that an operating time of a component A6is 2858 hours. Andon An7indicates that an operating time of a component A7is 9017 hours. Andon An8indicates that an operating time of a component A8is 2830 hours. Andon An9is an unset Andon.

In addition, a region r51on the upper right side of Andons An1to An9in the layout screen includes an input field Ip41for a component name and an input field Ip42for an operation start time of the component as parameters of each of the Andons.

In addition, a region r52on the lower right side of Andons An1to An9in the layout screen includes a table Tab4indicating a correspondence between component name and replacement time of each of the components.

Referring again toFIG. 1, when input reception unit16receives, for example, an operation of inputting the component name into input field Ip41and an operation of inputting the operation start time of the component into input field Ip42by a user, input reception unit16outputs operation information indicating content of the operations by the user to confirmation screen creating unit22in processing unit14.

Confirmation screen creating unit22obtains a SQL instruction included in display component information corresponding to the component name inputted by the user from storage unit17based on the operation information received from input reception unit16, and edits a part corresponding to the operation start time in the obtained SQL instruction to the operation start time inputted by the user.

Then, confirmation screen creating unit22creates an http post including the edited SQL instruction and the URLc for access processing, and transmits the created http post to server132B via data obtaining unit11.

Server132B receives the http post from data visualization apparatus101, obtains the SQL instruction included in the received http post, and calculates an operating time of the corresponding component by subtracting the operation start time indicated by the SQL instruction from the current time in accordance with the obtained SQL instruction.

Then, server132B creates an http response including the operating time calculated as target data and transmits the http response to data visualization apparatus101.

Upon receiving the http response from server132B, data obtaining unit11in data visualization apparatus101obtains the target data included in the received http response, and outputs the obtained target data to confirmation screen creating unit22in processing unit14.

Then, confirmation screen creating unit22obtains, for example, an OSS library for drawing Andon An from storage unit17, and draws Andon An based on the target data received from data obtaining unit11on a display component disposed on the layout screen using the obtained OSS library.

In addition, confirmation screen creating unit22obtains, for example, an OSS library for drawing a table from storage unit17, and draws a table Tab4based on the target data received from data obtaining unit11on a display component disposed on the layout screen using the obtained OSS library.

FIG. 23is a diagram illustrating an example of a layout screen in which a plurality of types of display components are disposed in the management system according to the embodiment of the present disclosure.

The layout screen illustrated inFIG. 23is used, for example, to check current or power values in a plurality of types of products and components in a certain period of time.

Referring toFIG. 23, the upper part of the layout screen includes, in order from left to right, a input field for a display period, a table created by display component creating unit21for selecting a product type, a table created by display component creating unit21for selecting a component name, and a table created by display component creating unit21for selecting an item to be displayed.

The lower part of the layout screen includes an image indicating information corresponding to the selected product type, component name, and item.

FIG. 24is a diagram illustrating an example of a layout screen in which a plurality of types of display components are disposed in the management system according to the embodiment of the present disclosure.

The layout screen illustrated inFIG. 24is used, for example, for a user to confirm a state of a certain device using a video.

Referring toFIG. 24, the layout screen includes, for example, a Gantt chart in which a horizontal axis is a time axis, indicating an operating state of a certain apparatus in a factory to be managed, and a display component (hereinafter also referred to as a video component) for playing back a captured video of the apparatus captured by a camera installed in the factory.

FIG. 25is a diagram schematically illustrating a method of using a video in the management system according to the embodiment of the present disclosure.

Referring toFIGS. 25 and 1, when input reception unit16receives, for example, an operation of selecting a part of Gantt chart by a user, input reception unit16outputs operation information including an ID of the above apparatus (hereinafter, also referred to as an apparatus ID) and a time corresponding to the part of Gantt chart selected by the user (hereinafter, also referred to as a designated time) to confirmation screen creating unit22.

Confirmation screen creating unit22receives the operation information from input reception unit16and obtains the apparatus ID and the designated time included in the received operation information.

Then, confirmation screen creating unit22identifies an ID of a camera (hereinafter also referred to as a camera ID) that is associated with the obtained apparatus ID, and creates an SQL instruction for requesting a playlist which is in accordance with an HTTP Live Streaming (HLS) format and includes the identified camera ID and the obtained designated time.

Confirmation screen creating unit22creates an http post including the created SQL instruction, and transmits the created http post to server132B via data obtaining unit11.

Server132B receives the http post from data visualization apparatus101, obtains the SQL instruction included in the received http post, and obtains the playlist indicated by the obtained SQL instruction from database133.

Then, server132B creates an http response including the playlist obtained as target data and transmits the http response to data visualization apparatus101.

Upon receiving the http response from server132B, data obtaining unit11in data visualization apparatus101obtains the target data included in the received http response, and outputs the obtained target data to confirmation screen creating unit22in processing unit14.

Confirmation screen creating unit22analyzes the playlist, that is, the target data received from data obtaining unit11to specify a video file indicated by the playlist.

Then, confirmation screen creating unit22obtains the SQL instruction included in the display component information of the video component from storage unit17, and edits a part corresponding to the video file in the obtained SQL instruction to the specified video file.

Subsequently, confirmation screen creating unit22creates an http post including the edited SQL instruction and the URLc for access processing, and transmits the created http post to server132B via data obtaining unit11.

Server132B receives the http post from data visualization apparatus101, obtains the SQL instruction included in the received http post, and obtains the video file indicated by the obtained SQL instruction from database133.

Then, server132B creates an http response including the video file obtained as target data and transmits the http response to data visualization apparatus101.

Upon receiving the http response from server132B, data obtaining unit11in data visualization apparatus101obtains the target data included in the received http response, and outputs the obtained target data to confirmation screen creating unit22in processing unit14.

Then, confirmation screen creating unit22obtains, for example, an OSS library for drawing a video component from storage unit17, and draws the video component based on the target data received from data obtaining unit11on the layout screen using the obtained OSS library.

Further, for example, processing unit14performs processing of further displaying a time taken for the access processing on the confirmation screen.

More specifically, confirmation screen creating unit22in processing unit14measures, for example, a data obtaining time taken for access processing and a drawing time taken for disposing a display component, and outputs, to display processing unit23, a layout screen on which the data obtaining time and the drawing time are displayed as measurement results, respectively.

Specifically, confirmation screen creating unit22transmits the http post including the SQL instruction and the URLc for access processing to server132B via data obtaining unit11, and also starts measuring time.

When confirmation screen creating unit22receives the target data included in the http response from server132B for the http post, confirmation screen creating unit22stops measuring the time and obtains the measured time as the data obtaining time.

Confirmation screen creating unit22measures a time from the reception of the target data to the completion of the creation of the layout screen.

Specifically, when confirmation screen creating unit22receives the target data, confirmation screen creating unit22starts measuring time.

Then, when the creation of the layout screen is completed based on the target data, confirmation screen creating unit22stops measuring time and obtains the measured time as the drawing time.

Subsequently, confirmation screen creating unit22creates a layout screen in which the data obtaining time and the drawing time are displayed as measurement results, respectively.

Display processing unit23performs processing for displaying the layout screen received from confirmation screen creating unit22on display131.

FIG. 26is a diagram illustrating an example of a layout screen on which each of measurement results in the management system according to the embodiment of the present disclosure is displayed.

Referring toFIG. 26, each of the measurement results is displayed, for example, in an upper right portion of region r4on the layout screen.

Confirmation screen creating unit22is not limited to a configuration of measuring the data obtaining time and the drawing time, and may be configured to measure at least one of the data obtaining time or the drawing time.

InFIG. 1, confirmation screen creating unit22outputs each of the measurement results to restriction unit18.

For example, restriction unit18limits at least one of a time taken to perform access processing once or the number of times of the access processing per certain time in a state in which the access processing by confirmation screen creation unit22is permitted, that is, in a state in which confirmation screen creating unit22is granted the authority for the access processing.

Restriction unit18makes a predetermined notification when a corresponding predetermined condition is satisfied by at least one of the time taken to perform the access processing once or the number of times of the access processing per certain time.

More specifically, for example, when each of the measurement results received from confirmation screen creating unit22, that is, at least one of the data obtaining time or the drawing time is equal to or longer than a predetermined time, restriction unit18outputs, to processing unit14, a warning indicating that the required time has been exceeded.

Confirmation screen creating unit22outputs, for example, the number of times of access processing performed within the predetermined time to restriction unit18.

For example, when the number of times of access processing received from confirmation screen creating unit22is equal to or more than a predetermined number of times, restriction unit18outputs, to processing unit14, a warning indicating that the number of times of access processing exceeds the predetermined number of times.

Processing unit14receives each of the warnings from restriction unit18and sends, for example, an e-mail with the content indicated by each of the warnings to a PC or the like used by a user.

When a user is a system administrator, for example, the user can perform user management processing by performing a predetermined operation to data visualization apparatus101using a keyboard, a mouse, or the like. For example, a user management table indicating a correspondence between a plurality of user IDs and corresponding user types is registered in database133.

When the predetermined operation is performed, input reception unit16outputs operation information indicating the content of the operation by the user to processing unit14.

Based on the operation information received from input reception unit16, processing unit14creates an http post including a SQL instruction with content for requesting the plurality of user IDs and the corresponding user types (hereinafter collectively referred to as user data) included in the user management table, and the URLc for access processing, and transmits the created http post to server132B via data obtaining unit11.

Server132B receives the http post from data visualization apparatus101, obtains the SQL instruction included in the received http post, and obtains the user data from the user management table in database133in accordance with the obtained SQL instruction.

Then, server132B creates an http response including the obtained user data and transmits the http response to data-visualization apparatus101.

Upon receiving the http response from server132B, data obtaining unit11in data-visualization apparatus101obtains the user data included in the received http response and outputs the user data to processing unit14.

Based on the user data received from data obtaining unit11, processing unit14creates a user management table indicating a correspondence between the plurality of user IDs and the corresponding user types, and performs processing of displaying a screen including the created user management table on display131.

For example, the user performs, to data visualization apparatus101, an operation of performing processing such as addition, change, and deletion of at least one of the user ID or the user type to the user management table on the screen displayed on display131.

When the operation is performed, input reception unit16outputs operation information indicating the content of the operation by the user to processing unit14.

Based on the operation information received from input reception unit16, processing unit14creates an SQL instruction with content updating the user management table in the database133, creates an http post including the created SQL instruction and the URLc for access processing, and transmits the created http post to server132B via data obtaining unit11.

Server132B receives the http post from data visualization apparatus101, obtains the SQL instruction included in the received http post, and updates the user management table in database133in accordance with the obtained SQL instruction.

In this way, in data visualization apparatus101, the user can create various display components in accordance with various applications.

In addition, in data visualization apparatus101, since the user can easily create various confirmation screens corresponding to various applications by using display components, the user can easily grasp states of components, apparatus, buildings, and the like to be managed.

Further, in data visualization apparatus101, since various authority can be set for processing using the database in accordance with the type of user, appropriate authority can be set in accordance with the type of user. As a result, for example, an increase in the processing load of database133can be suppressed, and database133can be used more smoothly even by a user having little knowledge about the database.

Each of a plurality of apparatus in management system201includes a computer including a memory, and an arithmetic processing unit such as a CPU in the computer reads a program including a part or all of each step of the following flowchart from the memory to execute the program. Each program of the plurality of apparatus can be installed from the outside. Each program of the plurality of apparatus is distributed in a form of being stored in a recording medium.

FIG. 27is a flowchart defining an operation procedure when the data visualization apparatus in the management system according to the embodiment of the present disclosure displays a confirmation screen on the display.

Referring toFIG. 27, data visualization apparatus101creates a display component in accordance with an operation by a user (step S101).

Next, data visualization apparatus101obtains target data, which is at least one of measurement data or a calculation result of calculation using the measurement data, from database133via server132B in accordance with an operation by the user (step S102).

Subsequently, data visualization apparatus101sets a plurality of types of authority for access processing including at least any one of authority to set a temporal range of the measurement data to be obtained from database133, authority to set a unit of time of the measurement data to be obtained from database133, or authority to set a type of calculation using the measurement data, in accordance with an operation by the user (step S103).

Then, data visualization apparatus101updates the display component based on the obtained target data in accordance with an operation by the user (step S104).

Next, in accordance with an operation by the user, data visualization apparatus101creates a confirmation screen in which the created or updated display component is disposed (step S105).

Further, data visualization apparatus101performs processing of limiting at least one of a time taken to perform access processing once or the number of times of the access processing per certain time to less than a predetermined time limit or less than a predetermined number of times limit, respectively (step S106).

Next, data visualization apparatus101obtains target data from database133via server132B in accordance with the authority for access processing set in accordance with an operation of the user (step S107).

Then, data visualization apparatus101updates the confirmation screen based on the obtained target data according to an operation of the user (step S108).

Next, when a predetermined condition set in the processing of limiting is satisfied in the access processing, for example, when at least one of the time taken to perform access processing once or the number of times of the access processing per certain time is equal to or greater than the time limit or equal to or greater than the number of times limit, respectively (YES in step S109), data visualization apparatus101notifies the user (step S110).

Subsequently, data visualization apparatus101performs processing for displaying the time taken to perform the access processing and content related to the measurement data on the confirmation screen (step S111).

On the other hand, when the time taken to perform the access processing once and the number of times of the access processing per certain time are less than the time limit and less than the number of times limit, respectively (NO in step S109), data visualization apparatus101performs processing for displaying the time taken to perform the access processing and the content related to the measurement data on the confirmation screen (step S111).

In management system201according to the embodiment of the present disclosure, each of servers132A,132B and database133is a single apparatus, but the present disclosure is not limited thereto. Some or all of the functions of servers132A,132B and database133may be provided by cloud computing. That is, each of servers132A,132B and database133may be configured by a plurality of cloud servers or the like.

In management system201according to the embodiment of the present disclosure, the number of types of users is four, but the present disclosure is not limited thereto. The number of types of users may be two, three, or five or more.

In data visualization apparatus101according to the embodiment of the present disclosure, processing unit14is configured to display a top screen corresponding to the type of user on display131. However, the configuration is not limited thereto. Processing unit14may be configured to display a top screen common to all types of user on display131.

In this case, for example, when a user performs, to data visualization apparatus101, an operation that is not permitted to the type of the user, data visualization apparatus101performs processing for displaying, on display131, a message indicating that the operation is not permitted.

In data visualization apparatus101according to the embodiment of the present disclosure, authorization unit15is configured to grants narrower authority to confirmation screen creating unit22than to display component creating unit21, but the present disclosure is not limited thereto. Authorization unit15may be configured to grant the same range of authority to confirmation screen creating unit22as that of display component creation unit21.

In data visualization apparatus101according to the embodiment of the present disclosure, authorization unit15is configured to grant narrower authority to display processing unit23than to confirmation screen creating unit22, but the present disclosure is not limited thereto. Authorization unit15may be configured to grant the same range of authority to display processing unit23as that of confirmation screen creating unit22.

In data visualization apparatus101according to the embodiment of the present disclosure, authorization unit15is configured to grant authority including at least any one of authority to set a temporal range of the measurement data to be obtained from the database, authority to set a unit of time of the measurement data to be obtained from the database, or authority to set a type of calculation using the measurement data, but the configuration is not limited thereto. Authorization unit15may be configured to grant authority to set other than the above.

In addition, in data visualization apparatus101according to the embodiment of the present disclosure, restriction unit18is configured to limit at least one of a time taken to perform access processing once or the number of times of the access processing per certain time, but the configuration is not limited thereto. Restriction unit18may be configured not to limit the time taken to perform access processing once and the number of times of the access processing per certain time.

In addition, in data visualization apparatus101according to the embodiment of the present disclosure, restriction unit18is configured to make a predetermined notification when a corresponding predetermined condition is satisfied by at least one of the time taken to perform the access processing once or the number of times of the access processing per certain time, but the configuration is not limited thereto. Restriction unit18may be configured not to make the predetermined notification.

In management system201according to the embodiment of the present disclosure, processing unit14in data visualization apparatus101is configured to send an e-mail with the content indicated by each of the warnings received from restriction unit18to a PC or the like used by a user, but the configuration is not limited thereto. In management system201, an apparatus other than data visualization apparatus101, for example, server132B may be configured to send the e-mail to the PC or the like used by the user.

More specifically, restriction unit18in data visualization apparatus101outputs, for example, a predetermined condition related to the access processing to processing unit14.

Processing unit14creates an SQL instruction indicating the predetermined condition received from restriction unit18, creates an http post including the created SQL instruction and the URLc for access processing, and transmits the created http post to server132B via data obtaining unit11.

Server132B receives the http post from processing unit14, obtains the predetermined condition indicated by the SQL instruction included in the received http post, and retains the obtained predetermined condition.

When the processing of server132B corresponds to the predetermined condition, server132B sends an e-mail indicating that the processing corresponds to the predetermined condition to a PC or the like used by a user.

In data visualization apparatus101according to the embodiment of the present disclosure, processing unit14is configured to display a time taken for access processing on a confirmation screen, but the configuration is not limited thereto. Processing unit14may be configured not to display the time taken for the access processing on the confirmation screen.

Only a limited number of people have knowledge about databases, and it is not easy for people who do not have sufficient expertise about databases to smoothly use databases using database languages.

On the other hand, in data visualization apparatus101according to the embodiment of the present disclosure, data obtaining unit11obtains target data which is at least one of measurement data obtained from database133in which the measurement data based on measurement results is accumulated or a calculation result using the measurement data in database133. Based on the target data obtained by data obtaining unit11, processing unit14performs processing for displaying the content related to the measurement data on the confirmation screen. Authorization unit15can set a plurality of types of authority for access processing which is at least one of obtaining the measurement data from database133or calculation using the measurement data in database133.

With this configuration, since various authority can be set for processing using database133in accordance with the type of user, it is possible to set appropriate authority in accordance with the type of user, and an increase in the processing load of database133can be suppressed.

Therefore, in data visualization apparatus101according to the embodiment of the present disclosure, the database can be more smoothly used in a configuration in which the measurement data obtained from database133is visualized.

In data visualization apparatus101according to the embodiment of the present disclosure, in processing unit14, display component creating unit21creates or updates one or more display components constituting a confirmation screen in accordance with an instruction from a user. Confirmation screen creating unit22creates or updates the confirmation screen by disposing the display components created by display component creating unit21in accordance with an instruction from a user. Authorization unit15grants, to confirmation screen creating unit22, narrower authority than to display component creating unit21.

With this configuration, it is possible to easily create various confirmation screens corresponding to various applications by using display components, and at the same time, to set appropriate authority in accordance with the type of user to realize an excellent system that suppresses an increase in the processing load on database133side. In particular, by separating authority related to display component and authority related to confirmation screen, more effective authority setting can be realized.

In data visualization apparatus101according to the embodiment of the present disclosure, in processing unit14, display processing unit23further performs processing for displaying a confirmation screen in accordance with an instruction from a user. Authorization unit15grants, to display processing unit23, narrower authority than to confirmation screen creating unit22.

With this configuration, since authority related to display component, authority related to confirmation screen, and authority related to screen viewing can be separated, more effective authority setting can be realized.

In data visualization apparatus101according to the embodiment of the present disclosure, the authority includes at least any one of authority to set a temporal range of the measurement data to be obtained from the database, authority to set a unit of time of the measurement data to be obtained from the database, or authority to set a type of calculation using the measurement data.

With the configuration in which such parameters are set, it is possible to effectively suppress an increase in the processing load on database133side.

In addition, in data visualization apparatus101according to the embodiment of the present disclosure, restriction unit18further limits at least one of a time taken to perform access processing once or the number of times of the access processing per certain time in a state in which the access processing by confirmation screen creating unit22is permitted.

With this configuration, the access processing is limited separately from the authority, and an increase in the processing load on database133side can be more reliably suppressed.

In data visualization apparatus101according to the embodiment of the present disclosure, restriction unit18makes a predetermined notification when a corresponding predetermined condition is satisfied by at least one of a time taken to perform access processing once or the number of times of the access processing per certain time.

With this configuration, it is possible to warn a user who is granted the authority for the access processing of an increase in the processing load on database133side.

In addition, in data visualization apparatus101according to the embodiment of the present disclosure, processing unit14further performs processing of displaying a time taken for the access processing on a confirmation screen.

With this configuration, a user who is granted the authority for the access processing can easily recognize the state of the processing load on database133side.

In the data processing method in data visualization apparatus101according to the embodiment of the present disclosure, first, target data that is at least one of measurement data obtained from database133in which the measurement data based on measurement results is accumulated or a calculation result using the measurement data in database133is obtained. Next, based on the obtained target data, processing of displaying the content related to the measurement data on the confirmation screen is performed. Then, a plurality of types of authority for access processing which is at least one of obtaining the measurement data from database133or calculation using measurement data in database133are set.

With this configuration, since various authority can be set for processing using database133in accordance with the type of user, it is possible to set appropriate authority in accordance with the type of user and to suppress an increase in the processing load on database133side.

Therefore, in the data processing method in data visualization apparatus101according to the embodiment of the present disclosure, the database can be used more smoothly in a configuration in which measurement data obtained from database133is visualized.

It should be understood that the above-described embodiments are illustrative in all aspects and should not be recognized as being restrictive. The scope of the present invention is defined by the scope of the claims rather than the above description, and is intended to embrace all the modifications within the meaning and range of equivalency of the claims.

The above description includes the following additional features.

A data visualization apparatus includes: a data obtaining unit configured to obtain target data that is at least one of measurement data obtained from a database in which the measurement data based on measurement results is accumulated or a calculation result using the measurement data in the database; a processing unit configured to performs process of displaying content related to the measurement data on a confirmation screen based on the target data obtained by the data obtaining unit; and an authorization unit configured to set a plurality of types of authority for access processing that is at least one of obtaining the measurement data from the database or calculation using the measurement data in the database, wherein the confirmation screen creating unit can select a content of the display component on the confirmation screen by setting the parameters in accordance with an instruction from a user.

REFERENCE SIGNS LIST