Data Visualization Device, Data Processing Method, and Recording Medium
By setting user permissions and obtaining object data in the data visualization device, the problem of difficulty for ordinary users to use the database is solved, and the effect of smoother database use and reducing the burden of database processing is achieved.
Patent Information
- Application Number
- CN202080028189.9
- Authority / Receiving Office
- CN · China
- Patent Type
- Patents(China)
- Current Assignee / Owner
- Priority Date
- 2019-04-12
- Filing Date
- 2020-03-24
- Publication Date
- 2025-06-20
- Estimated Expiration
- 2040-03-24
AI Technical Summary
In the prior art, users need to master database languages, such as SQL, when using databases, and complex SQL descriptions will increase the burden of database processing, making it difficult for ordinary users to use the database smoothly.
A data visualization device is designed, including a data acquisition unit, a processing unit and an authority setting unit. By acquiring the user's identification information, setting access processing permissions, and obtaining target data based on the permissions, creating a confirmation screen containing measurement data or calculation results, and displaying it on the display device.
It realizes setting database usage permissions according to user categories, reducing the burden of database processing, and improving the convenience of ordinary users to use the database.
Smart Images

Figure CN113711200B_ABST
Abstract
Description
Technical Field
[0001] The present disclosure relates to a data visualization device, a data processing method, and a data processing program.
[0002] This application claims priority based on Japanese Patent Application No. 2019-76412 filed on April 12, 2019, and incorporates the entire contents disclosed therein. Background Art
[0003] The following technique is disclosed in Japanese Unexamined Patent Application Publication No. 2019-3691 (Patent Document 1). That is, the management device includes: a first acquisition unit that acquires a measurement result obtained by a sensor that measures an apparatus and a time corresponding to the measurement result; a second acquisition unit that acquires a plurality of usage periods of the apparatus and the contents of management items corresponding to each of the usage periods from a storage unit; and a data processing unit that performs processing for summarizing measurement information based on the measurement result for each of the contents based on the measurement result and the corresponding time acquired by the first acquisition unit and the contents and the corresponding usage periods acquired by the second acquisition unit.
[0004] Prior Art Documents
[0005] Patent Documents
[0006] Patent Document 1: Japanese Unexamined Patent Application Publication No. 2019-3691 Summary of the Invention
[0007] The data visualization device of the present disclosure includes: a data acquisition unit that acquires object data from a database and acquires identification information of a user, the object data being at least one of measurement data and a calculation result using the measurement data; an authority setting unit that grants an authority to perform an access process to a processing unit based on the identification information of the user, the access process being at least one of a process of acquiring the measurement data from the database and a process of performing a calculation using the measurement data in the database; and the processing unit that performs a process of creating a confirmation screen including the measurement data or the calculation result and a process of displaying the confirmation screen on a display device based on the object data acquired via the data acquisition unit by the authority.
[0008] The data processing method of the present disclosure is a data processing method in a data visualization device. The data processing method includes: obtaining object data from a database and obtaining identification information of a user, where the object data is at least one of measurement data and a calculation result using the measurement data; setting permissions for access processing based on the identification information of the user, where the access processing is at least one of the processing of obtaining the measurement data from the database and the processing of performing calculations using the measurement data in the database; and performing a production process of a confirmation screen including the measurement data or the calculation result and a process of displaying the confirmation screen on a display device based on the object data obtained through the permissions.
[0009] The data processing program of the present disclosure is a data processing program used in a data visualization device. The program causes a computer to: obtain object data from a database and obtain identification information of a user, where the object data is at least one of measurement data and a calculation result using the measurement data, set permissions for access processing based on the identification information of the user, where the access processing is at least one of the processing of obtaining the measurement data from the database and the processing of performing calculations using the measurement data in the database, and perform a production process of a confirmation screen including the measurement data or the calculation result and a process of displaying the confirmation screen on a display device based on the object data obtained through the permissions via a data acquisition unit.
[0010] One aspect of the present disclosure can be implemented not only as a data visualization device having such a unique processing unit, but also as a semiconductor integrated circuit that implements part or all of the data visualization device, or as a system including the data visualization device. BRIEF DESCRIPTION OF THE DRAWINGS
[0011] Figure 1 is a diagram showing the configuration of a management system according to an embodiment of the present disclosure.
[0012] Figure 2 is a diagram showing an example of the categories of users and the scope of permissions in the management system according to an embodiment of the present disclosure.
[0013] Figure 3 is a diagram showing an example of the processing that can be performed for each user category in the management system according to an embodiment of the present disclosure.
[0014] Figure 4 is a diagram showing another example of the processing that can be performed for each user category in the management system according to an embodiment of the present disclosure.
[0015] Figure 5This is a diagram showing an example of a home screen displayed on a display device in the management system of an embodiment of the present disclosure.
[0016] Figure 6 This is a diagram showing an example of a selection screen displayed on a display device in the management system of an embodiment of the present disclosure.
[0017] Figure 7 This is a diagram showing an example of a details screen displayed on a display device in the management system of an embodiment of the present disclosure.
[0018] Figure 8 This is a diagram showing an example of an initial setting screen displayed on a display device in the management system of an embodiment of the present disclosure.
[0019] Figure 9 This is a diagram showing an example of a component editing screen displayed on a display device in the management system of an embodiment of the present disclosure.
[0020] Figure 10 This is a diagram showing an example of a dataConfig screen displayed on a display device in the management system of an embodiment of the present disclosure.
[0021] Figure 11 This is a diagram showing an example of a display component in the management system of an embodiment of the present disclosure.
[0022] Figure 12 This is a diagram showing an example of a display component in the management system of an embodiment of the present disclosure.
[0023] Figure 13 This is a diagram showing an example of a display component in the management system of an embodiment of the present disclosure.
[0024] Figure 14 This is a diagram showing an example of a configuration screen displayed on a display device in the management system of an embodiment of the present disclosure.
[0025] Figure 15 This is a diagram showing an example of a screen in which a display component is configured in the configuration screen of the management system of an embodiment of the present disclosure.
[0026] Figure 16 This is a diagram showing an example of a content selection screen displayed on a display device in the management system of an embodiment of the present disclosure.
[0027] Figure 17 This is a diagram showing an example of a screen in which a display component is configured in the configuration screen of the management system of an embodiment of the present disclosure.
[0028] Figure 18This is a diagram showing an example of a configuration screen in a management system according to an embodiment of the present disclosure, which is configured with multiple display components.
[0029] Figure 19 This is a diagram showing an example of a parameter setting screen in a management system according to an embodiment of the present disclosure.
[0030] Figure 20 This is a diagram showing another example of a parameter setting screen in a management system according to an embodiment of the present disclosure.
[0031] Figure 21 This is a diagram showing an example of a configuration screen in a management system according to an embodiment of the present disclosure, which is configured with multiple types of display components.
[0032] Figure 22 This is a diagram showing an example of a configuration screen in a management system according to an embodiment of the present disclosure, which is configured with multiple types of display components.
[0033] Figure 23 This is a diagram showing an example of a configuration screen in a management system according to an embodiment of the present disclosure, which is configured with multiple types of display components.
[0034] Figure 24 This is a diagram showing an example of a configuration screen in a management system according to an embodiment of the present disclosure, which is configured with multiple types of display components.
[0035] Figure 25 This is a diagram schematically showing a method of using a moving image in a management system according to an embodiment of the present disclosure.
[0036] Figure 26 This is a diagram showing an example of a configuration screen in a management system according to an embodiment of the present disclosure, which displays each measurement result.
[0037] Figure 27 This is a flowchart defining an operation process when a data visualization device in a management system according to an embodiment of the present disclosure displays a confirmation screen on a display device. Detailed Embodiments
[0038] Conventionally, a technique has been developed for monitoring the state of a device using measurement results from sensors.
[0039] [Problems to be Solved by the Present Disclosure]
[0040] In a system including the management device as described above, it is conceivable to accumulate measurement results obtained by sensors and measurement information based on the measurement results in a database provided outside the management device.
[0041] To use a database, a user needs to change descriptions in a database language such as SQL (Structured Query Language). In addition, some SQL descriptions increase the processing load on the database side.
[0042] However, the number of people with knowledge related to databases is limited. For those who do not have sufficient expertise related to databases, it is not easy to use a database language to smoothly use a database.
[0043] The present disclosure has been made to solve the above problems, and an object thereof is to provide a data visualization device, a data processing method, and a data processing program that can more smoothly use a database.
[0044] [Effects of the Present Disclosure]
[0045] According to the present disclosure, a database can be used more smoothly.
[0046] [Description of Embodiments of the Present Invention]
[0047] First, the content of the embodiments of the present disclosure will be listed and described.
[0048] (1) The data visualization device according to an embodiment of the present disclosure includes: a data acquisition unit that acquires target data from a database and acquires identification information of a user, where the target data is at least one of measurement data and a calculation result using the measurement data; a permission setting unit that grants a permission to perform an access process to a processing unit based on the identification information of the user, where the access process is at least one of a process of acquiring the measurement data from the database and a process of performing a calculation using the measurement data in the database; and the processing unit that performs a production process of a confirmation screen including the measurement data or the calculation result and a process of displaying the confirmation screen on a display device based on the target data acquired via the data acquisition unit through the permission.
[0049] With such a configuration, various permissions can be set for the processes of using the database according to the user category. Therefore, appropriate permissions corresponding to the user category can be set to suppress an increase in the processing load on the database side. Therefore, in a configuration for visualizing measurement data acquired from a database, the database can be used more smoothly.
[0050] (2) Preferably, the processing unit includes: a display component production unit that produces or updates one or more display components constituting the confirmation screen according to an instruction from a user; and a confirmation screen production unit that configures the display components produced by the display component production unit according to an instruction from a user to produce or update the confirmation screen, and the authority setting unit grants the processing unit an authority such that the object data that the confirmation screen production unit can obtain is less than the object data that the display component production unit can obtain.
[0051] With such a configuration, an excellent system can be realized. This system can easily produce various confirmation screens corresponding to various uses using display components, set appropriate authorities corresponding to the user category, and suppress an increase in the processing load on the database side. In particular, by separating the authority related to the display component and the authority related to the confirmation screen, more effective authority setting can be realized.
[0052] (3) More preferably, the processing unit further includes a display processing unit that performs processing for displaying the confirmation screen according to an instruction from a user, and the authority setting unit grants the processing unit an authority such that the object data that the display processing unit can obtain is less than the object data that the confirmation screen production unit can obtain.
[0053] With such a configuration, the authority related to the display component, the authority related to the confirmation screen, and the authority related to screen viewing can be separated, and thus more effective authority setting can be realized.
[0054] (4) Preferably, the authority includes at least any one of the following authorities: the authority to set the time range of the measurement data that should be obtained from the database and the authority to set the time unit; and the authority to set the type of calculation using the measurement data.
[0055] With the configuration of setting such parameters, an increase in the processing load on the database side can be effectively suppressed.
[0056] (5) Preferably, the processing unit includes: a display component production unit that produces or updates one or more display components constituting the confirmation screen according to an instruction from a user; and a confirmation screen production unit that configures the display components produced by the display component production unit according to an instruction from a user to produce or update the confirmation screen, and the data visualization device further includes a restriction unit that restricts at least any one of the time required for each access process and the number of access processes per certain time in a state where the authority is granted to the confirmation screen production unit.
[0057] With such a configuration, it is possible to set restrictions on access processing independently of permissions, thereby more reliably suppressing an increase in the processing load on the database side.
[0058] (6) More preferably, when at least one of the time required for each access processing and the number of times of the access processing per predetermined time satisfies a corresponding specified condition, the restriction unit gives a specified notification.
[0059] With such a configuration, it is possible to warn a user granted the permission for access processing of an increase in the processing load on the database side.
[0060] (7) Preferably, the processing unit further performs a process of displaying the time required for the access processing on the confirmation screen.
[0061] With such a configuration, a user granted the permission for access processing can easily recognize the state of the processing load on the database side.
[0062] (8) The data processing method according to an embodiment of the present disclosure is a data processing method in a data visualization device, where the data processing method includes: obtaining object data from a database and obtaining identification information of a user, the object data being at least one of measurement data and a calculation result using the measurement data; setting a permission for performing an access processing based on the identification information of the user, the access processing being at least one of a process of obtaining the measurement data from the database and a process of performing a calculation using the measurement data in the database; and performing a process of creating a confirmation screen including the measurement data or the calculation result and a process of displaying the confirmation screen on a display device based on the object data obtained through the permission.
[0063] With such a configuration, it is possible to set various permissions for processing using the database according to the user category. Therefore, it is possible to set appropriate permissions corresponding to the user category and suppress an increase in the processing load on the database side. Therefore, in a configuration for visualizing measurement data obtained from a database, the database can be used more smoothly.
[0064] (9) The data processing program of the embodiment of the present disclosure is a data processing program used in a data visualization device, and the program causes a computer to: obtain object data from a database and obtain identification information of a user, where the object data is at least one of measurement data and a calculation result using the measurement data, set a permission for access processing based on the identification information of the user, the access processing being at least one of a process of obtaining the measurement data from the database and a process of performing a calculation using the measurement data in the database, and perform a production process of a confirmation screen including the measurement data or the calculation result and a process of displaying the confirmation screen on a display device based on the object data obtained via the data acquisition unit by the permission.
[0065] With such a configuration, various permissions can be set for the processing of using the database according to the category of the user. Therefore, appropriate permissions corresponding to the category of the user can be set to suppress an increase in the processing load on the database side. Therefore, in a configuration for visualizing the measurement data obtained from the database, the database can be used more smoothly.
[0066] Hereinafter, embodiments of the present disclosure will be described with reference to the drawings. It should be noted that the same or corresponding parts in the drawings are denoted by the same reference numerals and will not be described repeatedly. In addition, at least a part of the embodiments described below can be arbitrarily combined.
[0067] [Configuration and basic operation]
[0068] Figure 1 FIG. is a diagram showing the configuration of a management system according to an embodiment of the present disclosure.
[0069] Refer to Figure 1 , the management system 201 includes a data visualization device 101, a display device 131, servers 132A and 132B, and a database 133.
[0070] The server 132A is, for example, a Web server. The server 132B is, for example, a REST (Representational State Transfer) API (Web Application Programming Interface) server. The server 132A and the server 132B are installed with mutually different Web APIs.
[0071] More specifically, servers 132A and 132B prepare a URL (Uniform Resource Locator) for each process. For example, the URL accepts requests, responses, and commands such as post that follow the http (Hypertext Transfer Protocol) protocol, and processes are performed in accordance with the accepted commands.
[0072] In database 133, for example, measurement data based on measurement results obtained by one or more sensors (not shown) is accumulated. As an example, the measurement data includes flow rate, temperature, measurement time, measurement location, and the lot number of the sensor, etc.
[0073] Server 132B, for example, acquires the measurement data from database 133 according to the above command. In addition, server 132B, for example, performs calculations using the acquired measurement data according to the above command.
[0074] Data visualization device 101 acquires object data from database 133 via network 134 such as the Internet and server 132B, and performs a process of displaying a screen based on the acquired object data on display device 131. The object data is at least one of the measurement data and the calculation result using the measurement data.
[0075] It should be noted that data visualization device 101 and display device 131 may also be integrated. In addition, network 134 may also be a network other than the Internet such as a local network.
[0076] [Data Visualization Device]
[0077] Data visualization device 101 includes a data acquisition unit 11, a processing unit 14, a permission setting unit 15, an input reception unit 16, a storage unit 17, and a restriction unit 18. The processing unit 14 includes a display component production unit 21, a confirmation screen production unit 22, and a display processing unit 23.
[0078] Data acquisition unit 11 acquires the above object data. The processing unit 14 performs a process of displaying content related to the measurement data on the confirmation screen based on the object data acquired by the data acquisition unit 11, that is, performs a production process of a confirmation screen including the measurement data or the above calculation result and a process of displaying the confirmation screen on display device 131.
[0079] For example, in the processing unit 14, the display component production unit 21 produces or updates one or more display components constituting the confirmation screen according to an instruction from the user.
[0080] For example, the confirmation screen production unit 22 configures the display components produced by the display component production unit 21 according to instructions from the user to produce or update the confirmation screen.
[0081] For example, the display processing unit 23 performs processing to display the confirmation screen on the display device 131 according to instructions from the user.
[0082] In the storage unit 17, for example, multiple OSS (Open Source Software) libraries are stored for producing corresponding display components.
[0083] As an example, the OSS libraries are flot for producing charts and gantt-chart-d3 for producing Gantt charts, etc.
[0084] The input reception unit 16 receives, for example, input operations by the user via a keyboard or a mouse.
[0085] For the input reception unit 16, when receiving an input operation by the user, information representing the received input content is output to the processing unit 14.
[0086] More specifically, for the input reception unit 16, when the data visualization device 101 is started up, for example, when a specified operation by the user via a keyboard and a mouse, etc. is performed, operation information representing the operation content performed by the user is output to the processing unit 14.
[0087] The processing unit 14 sends an http request to the server 132A based on the operation information received from the input reception unit 16.
[0088] More specifically, the processing unit 14 produces an http request including a URL a for login processing based on the operation information received from the input reception unit 16, and outputs the produced http request and the operation information to the data acquisition unit 11.
[0089] The data acquisition unit 11 sends the http request received from the processing unit 14 to the server 132A.
[0090] For the server 132A, when receiving an http request from the data visualization device 101, it produces an http response including an HTML (HyperText Markup Language) file based on the received http request and sends the http response to the data visualization device 101. The HTML file includes a GUI (Graphical User Interface) for login processing.
[0091] For the data visualization device 101, when receiving an http response from the server 132A, it performs a process of displaying on the display device 131 a screen in which a GUI for login processing is depicted on a web browser based on the received http response.
[0092] More specifically, the data acquisition unit 11 in the data visualization device 101 receives the http response sent from the server 132A, obtains an HTML file from the received http response, and outputs the HTML file to the processing unit 14.
[0093] The processing unit 14 obtains the GUI for login processing included in the HTML file received from the data acquisition unit 11, creates a screen in which the obtained GUI for login processing is depicted on a web browser, and performs a process of displaying the created screen on the display device 131.
[0094] For example, the user operates the web browser as follows: In the fields for respectively inputting "User ID (Identification: identifier)" and "Password" in the GUI for login processing displayed on the display device 131, the user inputs their own "User ID" and "Password", and thereby sends the "User ID" and "Password" to the server 132A.
[0095] When the input reception unit 16 receives this operation performed by the user, it outputs the received input content, that is, the "User ID" and "Password", to the processing unit 14.
[0096] The processing unit 14 creates an http post including the "User ID" and "Password" based on the input content received from the input reception unit 16, and sends the created http post to the server 132A via the data acquisition unit 11.
[0097] The server 132A receives the http post from the data visualization device 101, and performs a login process based on the received http post.
[0098] During the login process, the server 132A determines whether to allow the login of the user with the user ID based on the "User ID" and "Password" included in the http post.
[0099] Then, when the server 132A determines that it allows the login of the user with the user ID, for example, it creates an http cookie indicating the user ID and the category of the user, and sends the created http cookie to the data visualization device 101.
[0100] Figure 2This is a diagram showing an example of the categories and scope of permissions of users in the management system according to an embodiment of the present disclosure.
[0101] Refer to Figure 2 , in the management system 201, users are classified as, for example, any one of a system administrator, a display component producer, a confirmation screen producer, and a viewer.
[0102] The system administrator, the display component producer, the confirmation screen producer, and the viewer can perform processing with permissions decreasing in order.
[0103] More specifically, a viewer can perform, for example, a viewing process of a confirmation screen produced by the operation of the confirmation screen producer.
[0104] The data visualization device 101 performs a process of displaying the confirmation screen on the display device 131 according to the operation of the viewer.
[0105] The confirmation screen producer can perform, for example, not only a viewing process of the confirmation screen but also a production process of the confirmation screen.
[0106] The data visualization device 101 produces a confirmation screen configured with display components produced by the operation of the display component producer according to the operation of the confirmation screen producer, and performs a process of displaying the produced confirmation screen on the display device 131.
[0107] In addition, the confirmation screen producer can determine whether to allow the viewer to view the produced confirmation screen.
[0108] Thus, the viewer can view the confirmation screen allowed to be viewed by the confirmation screen producer.
[0109] On the other hand, in the case where the confirmation screen producer does not allow the viewer to view the confirmation screen, the data visualization device 101 performs, for example, a process of displaying a message indicating that viewing is not allowed on the display device 131 for an operation by the viewer to view the confirmation screen.
[0110] The display component producer can perform, for example, not only a production process of the confirmation screen and a viewing process of the confirmation screen but also a production process of the display component.
[0111] The data visualization device 101 produces one or more display components constituting the confirmation screen according to the operation of the display component producer.
[0112] In addition, the display component producer can determine whether to allow the confirmation screen producer to edit the produced display component.
[0113] Accordingly, when the confirmation screen maker is permitted by the display component maker to edit the display component, the confirmation screen maker can perform the editing of the display component.
[0114] In addition, the display component maker can determine whether to permit the viewer to view the display component included in the confirmation screen made by the confirmation screen maker.
[0115] For example, when the display component maker does not permit the viewer to view the display component, the data visualization device 101 does not display the display component on the display device 131 in the confirmation screen.
[0116] For example, in addition to being able to perform the production process of the display component, the production process of the confirmation screen, and the viewing process of the confirmation screen, the system administrator can also perform a user management process for managing the categories of each user in the management system 201.
[0117] Figure 3 It is a diagram showing an example of the processes that can be performed by each user category in the management system of the present disclosure embodiment. Figure 3 It shows a case where the display component maker permits the confirmation screen maker to edit the display component and the confirmation screen maker permits the viewer to view the confirmation screen.
[0118] Refer to Figure 3 The category of users who can perform the user management process is the system administrator. The category of users who can perform the production process of the display component is the system administrator and the display component maker. The category of users who can perform the editing of the display component is the system administrator, the display component maker, and the confirmation screen maker. The category of users who can perform the viewing of the display component is the system administrator, the display component maker, the confirmation screen maker, and the viewer. The category of users who can perform the production process of the confirmation screen is the system administrator, the display component maker, and the confirmation screen maker. The category of users who can perform the viewing of the confirmation screen is the system administrator, the display component maker, the confirmation screen maker, and the viewer.
[0119] Figure 4 It is a diagram showing another example of the processes that can be performed by each user category in the management system of the present disclosure embodiment. Figure 4 It shows a case where the display component maker does not permit the confirmation screen maker to edit the display component and the confirmation screen maker does not permit the viewer to view the confirmation screen.
[0120] Refer to Figure 4The category of users who can perform user management processing is the system administrator. The category of users who can perform the production processing of display components is the system administrator and display component producers. The category of users who can perform the editing of display components is the system administrator and display component producers. The category of users who can perform the viewing of display components is the system administrator, display component producers, and confirmation screen producers. The category of users who can perform the production processing of confirmation screens is the system administrator, display component producers, and confirmation screen producers. The category of users who can perform the viewing of confirmation screens is the system administrator, display component producers, and confirmation screen producers.
[0121] Refer again to Figure 1 The permission setting unit 15 can set permissions for multiple types of access processing, which is at least one of the acquisition of measurement data from the database 133 and the calculation using the measurement data in the database 133.
[0122] More specifically, the data acquisition unit 11 in the data visualization device 101 receives the http cookie sent from the server 132A and outputs the received http cookie to the processing unit 14. That is, the data acquisition unit 11 acquires the user ID.
[0123] The processing unit 14 outputs the http cookie received from the data acquisition unit 11 to the permission setting unit 15.
[0124] The permission setting unit 15 sets the permissions for the processing performed by the processing unit 14 according to the category of the user indicated by the http cookie received from the processing unit 14.
[0125] Specifically, for example, when the permission setting unit 15 receives an http cookie indicating a confirmation screen producer from the processing unit 14, it restricts the processing that the processing unit 14 can perform to the processing of displaying the confirmation screen on the display device 131 and the production processing of the confirmation screen, and outputs restriction information indicating the restricted content to the processing unit 14.
[0126] In addition, for example, when the permission setting unit 15 receives an http cookie indicating a display component producer from the processing unit 14, it restricts the processing that the processing unit 14 can perform to the processing of displaying the confirmation screen on the display device 131, the production processing of the confirmation screen, and the production processing of display components, and outputs restriction information indicating the restricted content to the processing unit 14.
[0127] In addition, for example, when the permission setting unit 15 receives an http cookie indicating a system administrator from the processing unit 14, it does not restrict the processing that the processing unit 14 can execute, and outputs restriction information indicating that such restriction is not performed to the processing unit 14.
[0128] The processing unit 14 receives the restriction information from the permission setting unit 15, and performs processing to display on the display device 131 a home page screen corresponding to the restriction information, that is, a home page screen corresponding to the user's category. For example, the home page screen includes a list of types of display components and a list of types of confirmation screens.
[0129] Figure 5 It is a diagram showing an example of a home page screen displayed on a display device in the management system according to the embodiment of the present disclosure. Figure 5 It shows the home page screen when the user's category is a display component manufacturer.
[0130] Refer to Figure 5 , in the upper region r11 of the home page screen, a confirmation screen table Tab1 is included, and the confirmation screen table Tab1 shows the correspondence between one or more confirmation screens produced by the confirmation screen production unit 22 and a button B1 for causing each of the confirmation screens to be displayed on the display device 131.
[0131] In addition, in the lower region r12 of the home page screen, a display component table Tab2 is included, and the display component table Tab2 shows the correspondence between one or more display components produced by the display component production unit 21 and a button B2 for causing each of the display components to be displayed on the display device 131.
[0132] In addition, above the confirmation screen table Tab1 in the region r11, a button B3 for causing the confirmation screen production unit 22 to produce a new confirmation screen is included.
[0133] In addition, above the display component table Tab2 in the region r12, a button B4 for causing the display component production unit 21 to produce a new display component is included.
[0134] Hyperlinks corresponding to the respective processes are set for the buttons B1 to B4.
[0135] Here, in the home page screen when the user's category is a confirmation screen producer, for example, compared with the Figure 5 shown home page screen, the region r12 corresponding to the production process of the display component is not included.
[0136] In addition, in the home page screen when the user's category is a viewer, for example, compared with the Figure 5Compared with the home screen shown, it does not include the button B3 in the area r12 corresponding to the production process of the display component and the area r11.
[0137] [Production of Display Component]
[0138] For example, when a user whose category is a display component producer makes a chart G1 based on object data, which is an example of content related to measurement data, as a display component, the user operates the data visualization device 101 to press the button B4 using a keyboard and a mouse, etc.
[0139] Refer to again Figure 1 , for the input reception unit 16, for example, when receiving this operation performed by the user, it outputs operation information indicating the content of the operation performed by the user to the processing unit 14.
[0140] The processing unit 14 sends an http request including the URLb for display component production to the server 132A via the data acquisition unit 11 based on the operation information received from the input reception unit 16.
[0141] The server 132A, for example, receives this http request from the data visualization device 101, and based on the received http request, sends an http response including an HTML file to the data visualization device 101. A program (hereinafter, also referred to as a production program) described using JavaScript (registered trademark), etc. for producing a display component is stored in this HTML file.
[0142] For the processing unit 14 in the data visualization device 101, when receiving the HTML file included in this http response from the server 132A via the data acquisition unit 11, it acquires the production program from the received HTML file and executes the acquired production program.
[0143] Thereby, the display component production unit 21 produces a new display component.
[0144] More specifically, when the production program is executed by the processing unit 14, the display component production unit 21 produces a selection screen for the user to select the type of display component to be produced, and outputs the produced selection screen to the display processing unit 23.
[0145] The display processing unit 23 performs processing to display the selection screen received from the display component production unit 21 on the display device 131.
[0146] Figure 6 It is a diagram showing an example of a selection screen displayed on a display device in the management system according to the embodiment of the present disclosure.
[0147] Refer to Figure 6, in the selection screen, for example, multiple icons are included according to each display component type. Specifically, in the selection screen, for example, there are icons V1 for display components used to create bar charts and line charts, etc., icon V2 for display components used to create tables, icon V3 for display components used to create indicator lights, and icon V4 for display components used to create maps, etc.
[0148] The user can create a display component of a desired type by selecting any one of the icons in the selection screen.
[0149] More specifically, the user can, for example, create display components of types such as bar charts and line charts by selecting icon V1 in the selection screen.
[0150] The user, for example, performs an operation of selecting icon V1 on the data visualization device 101.
[0151] For the input reception unit 16, for example, when receiving this operation performed by the user, it outputs operation information indicating the content of the operation performed by the user to the display component creation unit 21 in the processing unit 14.
[0152] The display component creation unit 21 creates a details screen for the user to select the type of chart to be created based on the operation information received from the input reception unit 16, and outputs the created details screen to the display processing unit 23.
[0153] The display processing unit 23 performs processing to display the details screen received from the display component creation unit 21 on the display device 131.
[0154] Figure 7 It is a diagram showing an example of the details screen displayed on the display device in the management system of the embodiment of the present disclosure.
[0155] Refer to Figure 7 , in the details screen, it includes: multiple types of regions r21 containing a line graph with the horizontal axis being time Figure 1 multiple types of regions r22 containing a line graph with the horizontal axis being category Figure 2 multiple types of regions r23 containing an area graph with the horizontal axis being time Figure 1 and multiple types of regions r24 containing an area graph with the horizontal axis being category Figure 2
[0156] In region r21, it includes: type "1 - 1" with a black background color and one line graph drawn Figure 1 type "1 - 2" with a black background color and multiple line graphs drawn Figure 1 type "1 - 3" with a white background color and one line graph drawn Figure 1 type "1 - 4" with a white background color and multiple line graphs drawnFigure 1 Type “1-4”.
[0157] In area r22, it includes: a broken line depicted with a black background color and of type “2-1”, multiple broken lines depicted with a black background color and of type “2-2”, a broken line depicted with a white background color and of type “2-3”, and multiple broken lines depicted with a white background color and of type “2-4”. Figure 2 Type “2-1” with a black background color and depicting a broken line, type “2-2” with a black background color and depicting multiple broken lines, type “2-3” with a white background color and depicting a broken line, and type “2-4” with a white background color and depicting multiple broken lines Figure 2 Type “2-3” with a white background color and depicting a broken line Figure 2 Type “2-4” with a white background color and depicting multiple broken lines Figure 2 Type “2-4”.
[0158] In area r23, it includes: an area depicted with a black background color and of type “3-1”, multiple areas depicted with a black background color and of type “3-2”, an area depicted with a white background color and of type “3-3”, and multiple areas depicted with a white background color and of type “3-4”. Figure 1 Type “3-1” with a black background color and depicting an area, type “3-2” with a black background color and depicting multiple areas, type “3-3” with a white background color and depicting an area, and type “3-4” with a white background color and depicting multiple areas Figure 1 Type “3-3” with a white background color and depicting an area Figure 1 Type “3-4” with a white background color and depicting multiple areas Figure 1 Type “3-4”.
[0159] In area r24, it includes: an area depicted with a black background color and of type “4-1”, multiple areas depicted with a black background color and of type “4-2”, an area depicted with a white background color and of type “4-3”, and multiple areas depicted with a white background color and of type “4-4”. Figure 2 Type “4-1” with a black background color and depicting an area, type “4-2” with a black background color and depicting multiple areas, type “4-3” with a white background color and depicting an area, and type “4-4” with a white background color and depicting multiple areas Figure 2 Type “4-3” with a white background color and depicting an area Figure 2 Type “4-4” with a white background color and depicting multiple areas Figure 2 Type “4-4”.
[0160] The user, for example, performs an operation of selecting type “1-3” on the data visualization device 101.
[0161] For the input reception unit 16, for example, when receiving this operation performed by the user, it outputs operation information indicating the content of the operation performed by the user to the display component production unit 21 in the processing unit 14.
[0162] The display component production unit 21 produces an initial setting screen for allowing the user to set the initial parameters of the chart to be produced based on the operation information received from the input reception unit 16, and outputs the produced initial setting screen to the display processing unit 23.
[0163] The display processing unit 23 performs processing to display the initial setting screen received from the display component production unit 21 on the display device 131.
[0164] Figure 8 It is a diagram showing an example of the initial setting screen displayed on the display device in the management system according to the embodiment of the present disclosure.
[0165] Refer to Figure 8, in the initial setting screen, for example, it includes: an image Pic1 indicating that the chart to be created is of type "1-3"; input fields Ip11 to Ip13 for respectively inputting the "chart ID", "chart name", and "update frequency" as initial parameters; and a button B5 for causing the display component production unit 21 to create a chart.
[0166] The user, for example, operates the Web browser as follows: inputs a part or all of the "chart ID", "chart name", and "update frequency" in each of these input fields, and presses the button B5.
[0167] It should be noted that the user, for example, can also operate the Web browser as follows: does not input the "chart ID", "chart name", and "update frequency" in each of these input fields, and only presses the button B5.
[0168] When the input reception unit 16 receives this operation performed by the user, it outputs the input contents of each of these input fields to the display component production unit 21 in the processing unit 14.
[0169] Here, in the production program, for example, it includes an instruction described using SQL for performing access processing (hereinafter, also referred to as a temporary SQL instruction), and this access processing is at least any one of obtaining measurement data from the database 133 and calculating using the measurement data in the database 133.
[0170] The display component production unit 21 creates an http post including this temporary SQL instruction and the URLc for access processing based on the input contents received from the input reception unit 16, and outputs the created http post to the processing unit 14.
[0171] The processing unit 14 sends the http post output from the display component production unit 21 to the server 132B via the data acquisition unit 11.
[0172] The server 132B receives the http post from the data visualization device 101, and performs access processing based on the received http post.
[0173] The server 132B obtains the temporary SQL instruction included in the received http post, and performs at least any one of obtaining measurement data from the database 133 and calculating using the measurement data in the database 133 according to the obtained temporary SQL instruction.
[0174] More specifically, for example, when the content of the above temporary SQL instruction is an instruction for indicating obtaining measurement data from the database 133, the server 132B obtains the measurement data indicated by the temporary SQL instruction.
[0175] In addition, for example, when the content of the above-mentioned temporary SQL instruction is an instruction intended to represent a calculation using the measurement data in the database 133, the server 132B acquires the measurement data indicated by the temporary SQL instruction, and performs calculations such as calculating the average value using the acquired measurement data.
[0176] As an example, the object data follows the format of JSON (JavaScript Object Notation).
[0177] Then, the server 132B creates an http response containing the object data and sends the http response to the data visualization device 101.
[0178] For the data acquisition unit 11 in the data visualization device 101, when receiving an http response from the server 132B, it acquires the object data included in the received http response, and outputs the acquired object data to the display component creation unit 21 in the processing unit 14.
[0179] The display component creation unit 21 uses the object data received from the data acquisition unit 11 to depict a chart based on the object data as a display component.
[0180] More specifically, the display component creation unit 21, for example, acquires an OSS library for depicting a chart of type "1-3" from the storage unit 17, and uses the acquired OSS library to depict a chart G1 based on the object data received from the data acquisition unit 11 as a display component.
[0181] Then, the display component creation unit 21 creates a component editing screen including the depicted chart G1 and an area r3 for editing the chart G1, and outputs the created component editing screen to the display processing unit 23.
[0182] The display processing unit 23 performs processing to display the component editing screen received from the display component creation unit 21 on the display device 131.
[0183] The display component creation unit 21 can change the content of the display component according to one or more parameters.
[0184] Figure 9 It is a diagram showing an example of a component editing screen displayed on the display device in the management system according to the embodiment of the present disclosure.
[0185] Refer to Figure 9, in the component editing screen, an area r3 is displayed overlapping the chart G1. In the area r3, there are included: "graphConfig" including an input field Ip21 for the chart title and an input field Ip22 for the legend; "viewConfig" including an input field Ip23 for the chart color and an input field Ip24 for the shape; and "dataConfig" including an input field Ip25 for the time range of the chart, an input field Ip26 for the time unit of the chart, and an input field Ip27 for the type of calculation of the measurement data used in the chart.
[0186] In "graphConfig", the user can set the chart title and the legend as an example of parameters.
[0187] In "viewConfig", the user can set the chart color and the shape as an example of parameters.
[0188] In "dataConfig", the user can set the time range of the chart, the time unit of the chart, and the type of calculation of the measurement data used in the chart as an example of parameters.
[0189] In addition, a plurality of buttons including a button B6 for editing SQL are displayed at the upper part in the area r3.
[0190] When the user edits SQL, the user operates the button B6 on the web browser.
[0191] For the input reception unit 16, for example, when receiving this operation performed by the user, operation information indicating the operation content performed by the user is output to the display component production unit 21 in the processing unit 14.
[0192] The display component production unit 21 produces a dataConfig screen for editing a temporary SQL instruction based on the operation information received from the input reception unit 16, and outputs the produced dataConfig screen to the display processing unit 23.
[0193] The display processing unit 23 performs processing to display the dataConfig screen received from the display component production unit 21 on the display device 131.
[0194] Figure 10 It is a diagram showing an example of a dataConfig screen displayed on the display device in the management system according to the embodiment of the present disclosure.
[0195] Refer to Figure 10 , in the above case, a temporary SQL instruction, which is an instruction for performing the above access processing, is displayed in the dataConfig screen.
[0196] The user uses a keyboard or a mouse to operate the Web browser to edit the temporary SQL instruction displayed on the display device 131.
[0197] Specifically, for example, the user uses a keyboard or a mouse to operate the Web browser to input an SQL instruction, and the content of the SQL instruction is to obtain the flow rate at a specified time interval within a specified period measured by a certain sensor from the database 133 as measurement data.
[0198] Refer to again Figure 1 , for the input reception unit 16, for example, when receiving such an operation performed by the user, the operation information indicating the content of the operation performed by the user is output to the display component production unit 21 in the processing unit 14.
[0199] The display component production unit 21 updates the temporary SQL instruction based on the operation information received from the input reception unit 16, thereby creating a new SQL instruction. Then, the display component production unit 21 creates an http post including the created new SQL instruction and the URLc for access processing, and sends the created http post to the server 132B via the data acquisition unit 11. Hereinafter, each of the temporary SQL instruction and the new SQL instruction is also referred to as an SQL instruction.
[0200] The server 132B receives the http post from the data visualization device 101, obtains the new SQL instruction included in the received http post, and obtains the flow rate at a specified time interval within the period indicated by the new SQL instruction as measurement data from the database 133 according to the obtained new SQL instruction.
[0201] Then, the server 132B creates an http response including the obtained measurement data, i.e., the target data, and sends the http response to the data visualization device 101.
[0202] For the data acquisition unit 11 in the data visualization device 101, when receiving the http response from the server 132B, it obtains the target data included in the received http response, and outputs the obtained target data to the display component production unit 21 in the processing unit 14.
[0203] The display component production unit 21 uses the target data received from the data acquisition unit 11 to create a component editing screen including the chart G1 based on the target data, and outputs the created component editing screen to the display processing unit 23.
[0204] The display processing unit 23 performs processing to display the component editing screen received from the display component production unit 21 on the display device 131.
[0205] It should be noted that it can also be configured as follows: In the data visualization device 101, by the user in the Figure 9 input fields Ip25, Ip26, and Ip27 in dataConfig of the component editing screen shown, respectively inputting the time range of the chart G1 as a parameter, the time unit of the chart G1, and the type of calculation using the measurement data in the chart G1, the SQL instruction is edited.
[0206] For the input reception unit 16, for example, when receiving this operation performed by the user, the input content information indicating the input content implemented by the user is output to the display component production unit 21 in the processing unit 14.
[0207] The display component production unit 21 determines whether the SQL instruction needs to be edited due to the change of the above parameters based on the input content information received from the input reception unit 16. Then, when the display component production unit 21 determines that the SQL instruction needs to be edited, it edits the corresponding part in the SQL instruction according to the changed parameters.
[0208] Here, the permission setting unit 15 in the data visualization device 101 sets permissions based on the content of the SQL instruction. The permissions include at least any one of the following permissions: the permission to set the time range of the measurement data that should be obtained from the database 133 and the permission to set the time unit; and the permission to set the type of calculation using the measurement data.
[0209] More specifically, for example, when the user with the category of display component producer edits the SQL instruction via the Figure 10 dataConfig screen shown, or when the SQL instruction is edited by the user's input to each input field in dataConfig of the component editing screen shown, the content of the edited SQL instruction is output to the permission setting unit 15. Figure 9
[0210] The permission setting unit 15 can set permissions for multiple types of access processing based on the content of the SQL instruction received from the display component production unit 21, and the access processing is at least any one of obtaining the measurement data from the database 133 and calculating using the measurement data in the database 133.
[0211] For example, the permission setting unit 15 grants narrower permissions to the confirmation screen production unit 22 than to the display component production unit 21. For example, it grants the processing unit 14 the permission that the object data that the confirmation screen production unit 22 can obtain is less than the object data that the display component production unit 21 can obtain.
[0212] Specifically, for example, when the content of the SQL instruction received from the display component production unit 21 is that the confirmation screen production unit 22 can set the time range and time unit of the measurement data to be retrieved from the database 133, the permission setting unit 15 outputs permission information indicating that the confirmation screen production unit 22 has the permission to set to the confirmation screen production unit 22.
[0213] Thereby, a user whose category is a confirmation screen producer can set the time range and time unit of the measurement data to be retrieved from the database 133 during the production process of the confirmation screen.
[0214] In addition, for example, the permission setting unit 15 grants a narrower permission to the display processing unit 23 than to the confirmation screen production unit 22. For example, the permission setting unit 15 grants the processing unit 14 the permission that the object data that the display processing unit 23 can retrieve is less than the object data that the confirmation screen production unit 22 can retrieve.
[0215] Specifically, for example, when the content of the SQL instruction received from the display component production unit 21 is that the display processing unit 23 can set the time range of the measurement data to be retrieved from the database 133, the permission setting unit 15 outputs permission setting information indicating that the display processing unit 23 has the permission to set to the display processing unit 23.
[0216] Thereby, a user whose category is a viewer can set the time range of the display component configured in the confirmation screen produced by a user whose category is a confirmation screen producer.
[0217] In addition, for example, when a user whose category is a display component producer edits the chart title and legend as parameters, the user performs operations of inputting a new chart title and a new legend into the input field Ip21 and the input field Ip22 in the component editing screen shown in Figure 9 the Web browser respectively.
[0218] Referring again to Figure 1 , for the input reception unit 16, for example, when receiving the operation performed by the user, the input reception unit 16 outputs operation information indicating the content of the operation performed by the user to the display component production unit 21 in the processing unit 14.
[0219] The display component production unit 21 produces a component editing screen including the chart G1 with the new chart title and legend set based on the operation information received from the input reception unit 16, and outputs the produced component editing screen to the display processing unit 23.
[0220] The display processing unit 23 performs processing of displaying the component editing screen received from the display component production unit 21 on the display device 131.
[0221] In addition, when the user edits, for example, the color and shape of a chart as a parameter, the user performs an operation of inputting a new chart color and a new shape into the input field Ip23 and the input field Ip24 in the component editing screen shown in Figure 9 the Web browser, respectively.
[0222] When the input reception unit 16 receives, for example, this operation performed by the user, the input reception unit 16 outputs operation information indicating the operation content performed by the user to the display component creation unit 21 in the processing unit 14.
[0223] Based on the operation information received from the input reception unit 16, the display component creation unit 21 creates a component editing screen including the chart G1 with the newly set chart color and shape, and outputs the created component editing screen to the display processing unit 23.
[0224] The display processing unit 23 performs processing of displaying the component editing screen received from the display component creation unit 21 on the display device 131.
[0225] After that, the display component creation unit 21 sends an http post including the SQL instruction and the URLc for access processing to the server 132B at time intervals set in the "Update Frequency" in the Figure 8 shown initial setting screen.
[0226] Thus, the display component creation unit 21 obtains new object data from the database 133 via the server 132B and the data acquisition unit 11 at time intervals set in the "Update Frequency", and updates the display component based on the obtained object data, such as the chart G1.
[0227] In addition, the display component creation unit 21 saves the created display component in the storage unit 17, for example, according to the operation performed by the user.
[0228] More specifically, the user performs an operation of pressing the Figure 9 "Overwrite Save" button for saving the created display component among the multiple buttons in the component editing screen shown in the Web browser.
[0229] When the input reception unit 16 receives, for example, this operation performed by the user, the input reception unit 16 outputs operation information indicating the operation content performed by the user to the display component creation unit 21 in the processing unit 14.
[0230] Based on the operation information received from the input reception unit 16, the display component creation unit 21 saves the display component information including the created SQL instruction and the set parameters in the storage unit 17.
[0231] Accordingly, the newly produced display component made by the display component production department 21 and the button B2 for causing the display component to be displayed on the display device 131 are added to Figure 5 the display component table Tab2 in the shown home page screen.
[0232] [Update of Display Component]
[0233] A user whose category is a display component producer, for example, uses a keyboard and a mouse to press Figure 5 the button B2 corresponding to the chart G1 in the shown home page screen.
[0234] Refer to again Figure 1 , for the input reception unit 16, for example, when receiving this operation by the user, the operation information indicating the operation content implemented by the user is output to the processing unit 14.
[0235] Based on the operation information received from the input reception unit 16, the processing unit 14 sends an http request including the URLb for making the display component to the server 132A via the data acquisition unit 11.
[0236] For the server 132A, when receiving this http request from the data visualization device 101, based on the received http request, an http response including an HTML file storing the production program is sent to the data visualization device 101.
[0237] For the processing unit 14 in the data visualization device 101, when receiving the HTML file included in this http response from the server 132A via the data acquisition unit 11, the production program is obtained from the received HTML file.
[0238] In addition, based on the operation information received from the input reception unit 16, the processing unit 14 obtains the display component information corresponding to the chart G1 from the storage unit 17. Then, the processing unit 14 executes the production program in which the temporary SQL instruction in the obtained production program is changed to the SQL instruction included in the obtained display component information.
[0239] Accordingly, a component editing screen including the chart G1 corresponding to the display component information is displayed on the display device 131.
[0240] It should be noted that in the data visualization device 101, the display component is not limited to the chart G1, and may also be different types of charts, tables, indicator lights, progress management tables, Gantt charts, map information, box plots, etc.
[0241] Figure 11 It is a diagram showing an example of a display component in the management system according to the embodiment of the present disclosure.
[0242] Figure 11 A WBGT (Wet Bulb Globe Temperature) meter is shown as an example of the display component.
[0243] Refer to Figure 11 , the WBGT shows the correspondence between the air temperature and relative humidity and the heat index calculated based on the air temperature and the relative humidity.
[0244] In addition, in the WBGT meter, different colors are used according to the value of the heat index. Specifically, the colors in the case where the heat index is less than 25, the colors in the case where the heat index is 25 to 28, the colors in the case where the heat index is 29 to 31, and the colors in the case where the heat index is 32 or more are different. In Figure 11 , different colors are represented by different hatching.
[0245] Below the WBGT meter, for example, the partitions of the heat index shown in the WBGT meter are displayed. Specifically, the partition in the case where the heat index is less than 25 is "Caution", the partition in the case where the heat index is 25 to 28 is "Alarm", the partition in the case where the heat index is 29 to 31 is "Severe Alarm", and the partition in the case where the heat index is 32 or more is "Danger".
[0246] For example, when a user creates a WBGT meter, the user selects the icon V2 in the selection screen shown in Figure 6 .
[0247] Then, for example, the user operates the data visualization device 101 according to the screen displayed on the display device 131, thereby creating a WBGT meter.
[0248] Figure 12 FIG. is a diagram showing an example of a display component in the management system according to an embodiment of the present disclosure. Figure 12 A plurality of indicator lights An are shown as an example of the display component. The indicator light is a display method for warning the user according to the displayed color.
[0249] Refer to Figure 12 , the indicator light An represents, for example, the heat index shown in the WBGT meter. In addition, corresponding to the WBGT meter, the color of the indicator light An is, for example, a color corresponding to the heat index. In Figure 12 , different colors are represented by different hatching.
[0250] For example, when a user creates an indicator light, the user selects the icon V3 in the selection screen shown in Figure 6 .
[0251] Then, the user operates the data visualization device 101 according to the screen displayed on the display device 131, for example, to create an indicator light.
[0252] Figure 13 It is a diagram showing an example of a display component in the management system according to the embodiment of the present disclosure. Figure 13 Map information is shown as an example of the display component.
[0253] Refer to Figure 13 , for example, the map information represents the layout of a two-story factory that is the management object of the management system 201.
[0254] For example, when the user creates map information, the user selects the icon V4 in the selection screen shown in Figure 6 .
[0255] Then, the user operates the data visualization device 101 according to the screen displayed on the display device 131, for example, to create map information.
[0256] [Creation of confirmation screen]
[0257] A user whose category is a confirmation screen creator or a display component creator operates the data visualization device 101 to press the button B3 in the home screen shown in Figure 5 using a keyboard and a mouse, for example.
[0258] Refer to Figure 1 again. For the input reception unit 16, for example, when receiving this operation performed by the user, operation information indicating the operation content performed by the user is output to the processing unit 14.
[0259] Based on the operation information received from the input reception unit 16, the processing unit 14 sends an http request including the URL d for creating the confirmation screen to the server 132A via the data acquisition unit 11.
[0260] For the server 132A, when receiving this http request from the data visualization device 101, an http response including an HTML file is sent to the data visualization device 101 based on the received http request. A program (hereinafter, also referred to as a display program) described using JavaScript or the like for displaying the confirmation screen is stored in the HTML file.
[0261] For the processing unit 14 in the data visualization device 101, when receiving the HTML file included in this http response from the server 132A via the data acquisition unit 11, the display program is acquired from the received HTML file, and the acquired display program is executed.
[0262] Accordingly, the confirmation screen production unit 22 produces a confirmation screen configured with one or more display components produced by the display component production unit 21.
[0263] More specifically, when the display program is executed by the processing unit 14, the confirmation screen production unit 22 produces a configuration screen for configuring the display components, and outputs the produced configuration screen to the display processing unit 23.
[0264] The display processing unit 23 performs processing to display the configuration screen received from the confirmation screen production unit 22 on the display device 131.
[0265] Figure 14 It is a diagram showing an example of a configuration screen displayed on the display device in the management system according to the embodiment of the present disclosure.
[0266] Refer to Figure 14 , the configuration screen includes an area r4 for configuring the display components. Above the area r4, there are a plurality of buttons for selecting the display components to be configured.
[0267] The user operates the Web browser to press the button corresponding to the display component to be configured among the plurality of buttons. Then, the user operates the Web browser to select the position in the area r4 where the display component should be configured.
[0268] For the input reception unit 16, for example, when receiving this operation performed by the user, it outputs operation information indicating the content of the operation performed by the user to the confirmation screen production unit 22 in the processing unit 14.
[0269] The confirmation screen production unit 22 configures the display components in the area r4 according to the operation information received from the input reception unit 16.
[0270] Figure 15 It is a diagram showing an example of a screen in which a display component is configured in the configuration screen in the management system according to the embodiment of the present disclosure.
[0271] Refer to Figure 15 , the display component is configured at the position P in the area r4. In this display component, there is a button B7 for selecting the content of the display component.
[0272] The confirmation screen production unit 22 can select the content of the display components in the confirmation screen by setting one or more parameters according to the instructions from the user.
[0273] The user, for example, operates the Web browser to press the button B7.
[0274] For the input reception unit 16, for example, when receiving this operation performed by the user, operation information indicating the content of the operation performed by the user is output to the confirmation screen creation unit 22 in the processing unit 14.
[0275] The confirmation screen creation unit 22 creates a content selection screen including the content of Table Tab3 showing the display components created by the display component creation unit 21 based on the operation information received from the input reception unit 16, and outputs the created content selection screen to the display processing unit 23.
[0276] Figure 16 FIG. is an example of a content selection screen displayed on the display device in the management system according to the embodiment of the present disclosure.
[0277] Refer to Figure 16 , Table Tab3 shows the correspondence between one or more display components created by the display component creation unit 21 and the types of the display components.
[0278] The display processing unit 23 performs processing to display the content selection screen received from the confirmation screen creation unit 22 on the display device 131.
[0279] The user operates the Web browser to select a display component such as chart G1 from Table Tab3 in the content selection screen.
[0280] For the input reception unit 16, for example, when receiving this operation performed by the user, operation information indicating the content of the operation performed by the user is output to the confirmation screen creation unit 22 in the processing unit 14.
[0281] The confirmation screen creation unit 22 obtains the SQL instruction included in the display component information corresponding to chart G1 from the storage unit 17 based on the operation information received from the input reception unit 16.
[0282] Then, the confirmation screen creation unit 22 creates an http post including the obtained SQL instruction and the URLc for access processing, and sends the created http post to the server 132B via the data acquisition unit 11.
[0283] For the server 132B, when receiving an http post from the data visualization device 101, it obtains the SQL instruction included in the received http post, and performs at least one of obtaining measurement data from the database 133 and calculating using the measurement data in the database 133 according to the obtained SQL instruction.
[0284] Then, the server 132B creates an HTTP response containing the object data, which is at least one of the acquired measurement data and the calculation result using the measurement data, and sends the HTTP response to the data visualization device 101.
[0285] For the data acquisition unit 11 in the data visualization device 101, when receiving an HTTP response from the server 132B, it acquires the object data contained in the received HTTP response and outputs the acquired object data to the confirmation screen creation unit 22 in the processing unit 14.
[0286] Then, the confirmation screen creation unit 22, for example, acquires an OSS library for depicting the chart G1 from the storage unit 17, and uses the acquired OSS library to depict the chart G1 based on the object data received from the data acquisition unit 11 as a display component configured in the configuration screen.
[0287] Figure 17 FIG. is an example of a screen showing that a display component is configured in the configuration screen of the management system according to the embodiment of the present disclosure.
[0288] Refer to Figure 17 , the chart G1 is configured as a display component at the position P shown in Figure 15 .
[0289] In addition, the confirmation screen creation unit 22 can, for example, configure a plurality of display components in the configuration screen by setting one or more parameters of the display component.
[0290] More specifically, the user can create a configuration screen configured with one or more desired display components by repeating the above operations.
[0291] Figure 18 FIG. is an example of a configuration screen configured with a plurality of display components in the management system according to the embodiment of the present disclosure.
[0292] Refer to Figure 18 , a plurality of charts G1 with different one or more parameters are configured in the area r4 in the configuration screen.
[0293] The user, for example, performs an operation of selecting any one of the plurality of charts G1 on the web browser and changing the parameters of the selected chart G1.
[0294] For the input reception unit 16, for example, when receiving this operation performed by the user, it outputs operation information indicating the content of the operation performed by the user to the confirmation screen creation unit 22 in the processing unit 14.
[0295] The confirmation screen creation unit 22 creates a parameter setting screen for changing the parameters of the chart G1 based on the operation information received from the input reception unit 16, and outputs the created parameter setting screen to the display processing unit 23.
[0296] The display processing unit 23 performs processing to display the parameter setting screen received from the confirmation screen creation unit 22 on the display device 131.
[0297] Figure 19 It is a diagram showing an example of a parameter setting screen in the management system according to the embodiment of the present disclosure.
[0298] Refer to Figure 19 , in the parameter setting screen, there are an input field Ip31 for the chart title, an input field Ip32 for the legend, an input field Ip33 for the chart color, and an input field Ip34 for the shape.
[0299] In addition, in the parameter setting screen, for example, there are an input field Ip35 for the time range of the chart G1, an input field Ip36 for the time unit of the chart G1, and an input field Ip37 for inputting the type of calculation using the measurement data in the chart G1.
[0300] In addition, in the parameter setting screen, there are an input field Ip38 for the chart ID of the chart G1 and an input field Ip39 for the chart name of the chart G1.
[0301] In addition, the confirmation screen creation unit 22 restricts the types of parameters that can be set in the parameter setting screen based on the above-mentioned permission information received from the permission setting unit 15.
[0302] Thus, the confirmation screen creation unit 22 is granted a narrower permission by the permission setting unit 15 than the display component creation unit 21.
[0303] More specifically, for example, when the confirmation screen creation unit 22 receives permission information from the permission setting unit 15 that restricts the time range of the measurement data to be obtained from the database 133, it creates a parameter setting screen in which the input of the input field Ip35 is restricted.
[0304] That is, the access processing permission of the confirmation screen creation unit 22 is restricted.
[0305] Figure 20 It is a diagram showing another example of a parameter setting screen in the management system according to the embodiment of the present disclosure.
[0306] Refer to Figure 20 , in the parameter setting screen in the state where the access processing permission is restricted, compared with the Figure 19 parameter setting screen shown, for example, a fixed value is displayed in the input field Ip35.
[0307] Note that in the parameter setting screen in a state where the access processing permission is restricted, not only the display of the fixed value in the input field Ip35, but also the input field Ip35 may not be displayed.
[0308] Refer again to Figure 1 and Figure 19 For the input reception unit 16, for example, when receiving a parameter change operation performed by the user, the operation information indicating the operation content performed by the user is output to the confirmation screen creation unit 22 in the processing unit 14.
[0309] The confirmation screen creation unit 22 obtains the SQL instruction included in the corresponding display component information from the storage unit 17 based on the operation information received from the input reception unit 16, and edits the corresponding part in the SQL instruction according to the changed parameters.
[0310] Then, the confirmation screen creation unit 22 creates an http post including the edited SQL instruction and the URLc for access processing, and sends the created http post to the server 132B via the data acquisition unit 11.
[0311] The server 132B receives the http post from the data visualization device 101, obtains the SQL instruction included in the received http post, and performs at least any one of the acquisition of the measurement data from the database 133 and the calculation using the measurement data in the database 133 according to the obtained SQL instruction.
[0312] Then, the server 132B creates an http response including the object data and sends the http response to the data visualization device 101, where the object data is at least any one of the obtained measurement data and the calculation result using the measurement data.
[0313] For the data acquisition unit 11 in the data visualization device 101, when receiving the http response from the server 132B, it obtains the object data included in the received http response and outputs the obtained object data to the confirmation screen creation unit 22 in the processing unit 14.
[0314] Then, the confirmation screen creation unit 22 obtains, for example, the OSS library for depicting the chart G1 from the storage unit 17, and uses the obtained OSS library to depict the chart G1 based on the object data received from the data acquisition unit 11 as a display component configured in the configuration screen.
[0315] In addition, the confirmation screen creation unit 22 saves the created confirmation screen in the storage unit 17, for example, according to the operation performed by the user.
[0316] More specifically, for example, a user performs an operation on a Web browser in the configuration screen shown in Figure 18 to save the configuration screen.
[0317] For the input reception unit 16, for example, when receiving this operation performed by the user, operation information indicating the content of the operation performed by the user is output to the confirmation screen creation unit 22 in the processing unit 14.
[0318] The confirmation screen creation unit 22 saves confirmation screen information in the storage unit 17 based on the operation information received from the input reception unit 16. The confirmation screen information respectively includes SQL instructions of one or more display components included in the configuration screen and the content of the set parameters.
[0319] Thus, a new confirmation screen created by the confirmation screen creation unit 22 and a button B1 for displaying the confirmation screen on the display device 131 are added to Figure 5 the confirmation screen table Tab1 in the home screen shown in. In this way, the confirmation screen creation unit 22 can create multiple confirmation screens.
[0320] [Viewing of Confirmation Screen]
[0321] A user whose category is a viewer, a confirmation screen creator, or a display component creator, for example, performs an operation on a Web browser to press the button B1 corresponding to "Confirmation Screen 1" in the home screen shown in Figure 5 using a keyboard, a mouse, etc.
[0322] Referring again to Figure 1 , for the input reception unit 16, for example, when receiving this operation performed by the user, operation information indicating the content of the operation performed by the user is output to the processing unit 14.
[0323] The processing unit 14 sends an http request including the URLd for creating a confirmation screen to the server 132A via the data acquisition unit 11 based on the operation information received from the input reception unit 16.
[0324] For the server 132A, when receiving this http request from the data visualization device 101, an http response including an HTML file storing a display program is sent to the data visualization device 101 based on the received http request.
[0325] For the processing unit 14 in the data visualization device 101, when receiving the HTML file included in this http response from the server 132A via the data acquisition unit 11, a display program is obtained from the received HTML file.
[0326] In addition, the processing unit 14 obtains confirmation screen information corresponding to the "confirmation screen 1" from the storage unit 17 based on the operation information received from the input reception unit 16. Then, the processing unit 14 reflects the obtained confirmation screen information in the obtained display program and executes the display program.
[0327] As a result, a configuration screen corresponding to the confirmation screen information is displayed on the display device 131.
[0328] In addition, for example, the confirmation screen creation unit 22 can create a confirmation screen configured with multiple types of display components by setting one or more parameters based on the user's operations and the permission settings set by the permission setting unit 15.
[0329] Figure 21 It is a diagram showing an example of a configuration screen configured with multiple types of display components in the management system according to the embodiment of the present disclosure.
[0330] Refer to Figure 21 , in the configuration screen, for example, it includes Figure 11 the WBGT table shown in Figure 12 the indicator light An shown in Figure 13 and the map information shown in
[0331] In this configuration screen, the indicator light An is used to indicate the heat index at multiple locations in the factory of the two-story building.
[0332] The user can, for example, use this configuration screen to confirm the heat index at multiple locations in the factory of the two-story building and which zone the heat index belongs to.
[0333] Figure 22 It is a diagram showing an example of a configuration screen configured with multiple types of display components in the management system according to the embodiment of the present disclosure.
[0334] Figure 22 The configuration screen shown in
[0335] Refer to Figure 22 , in the configuration screen, it includes the indicator lights An1 to An9 produced by the display component production unit 21.
[0336] The indicator light An1 indicates that the working hours of component A1 are 5,297 hours. The indicator light An2 indicates that the working hours of component A2 are 4,498 hours. The indicator light An3 indicates that the working hours of component A3 are 5,949 hours. The indicator light An4 indicates that the working hours of component A4 are 12,630 hours. The indicator light An5 indicates that the working hours of component A5 are 2,518 hours. The indicator light An6 indicates that the working hours of component A6 are 2,858 hours. The indicator light An7 indicates that the working hours of component A7 are 9,017 hours. The indicator light An8 indicates that the working hours of component A8 are 2,830 hours. The indicator light An9 is an unconfigured indicator light.
[0337] In addition, in the configuration screen, the area r51 above the right side of the indicator lights An1 to An9 includes an input field Ip41 for the component name, which is a parameter of each indicator light, and an input field Ip42 for the replacement time, which is a parameter of each indicator light. The replacement time is the start time of the component's operation.
[0338] In addition, in the configuration screen, the area r52 below the right side of the indicator lights An1 to An9 includes a table Tab4 showing the correspondence between the component names of each component and the replacement times of each component.
[0339] Refer again to Figure 1 , for the input reception unit 16, for example, when receiving an input operation of inputting a component name into the input field Ip41 and an input operation of inputting the start time of the component's operation into the input field Ip42 performed by the user, the operation information indicating the operation content performed by the user is output to the confirmation screen creation unit 22 in the processing unit 14.
[0340] The confirmation screen creation unit 22 obtains the SQL instruction included in the display component information corresponding to the component name input by the user from the storage unit 17 based on the operation information received from the input reception unit 16, and edits the part corresponding to the start time of operation in the obtained SQL instruction to the start time of operation input by the user.
[0341] Then, the confirmation screen creation unit 22 creates an http post including the edited SQL instruction and the URLc for access processing, and sends the created http post to the server 132B via the data acquisition unit 11.
[0342] The server 132B receives the http post from the data visualization device 101, obtains the SQL instruction included in the received http post, and calculates the working hours of the corresponding component by subtracting the start time of operation indicated by the SQL instruction from the current time.
[0343] Then, the server 132B creates an HTTP response containing the working hours calculated as the object data and sends the HTTP response to the data visualization device 101.
[0344] For the data acquisition unit 11 in the data visualization device 101, when receiving an HTTP response from the server 132B, it acquires the object data included in the received HTTP response and outputs the acquired object data to the confirmation screen creation unit 22 in the processing unit 14.
[0345] Then, the confirmation screen creation unit 22 acquires, for example, the OSS library for depicting the indicator An from the storage unit 17, and uses the acquired OSS library to depict the indicator An based on the object data received from the data acquisition unit 11 as a display component configured in the configuration screen.
[0346] In addition, the confirmation screen creation unit 22 acquires, for example, the OSS library for depicting a table from the storage unit 17, and uses the acquired OSS library to depict the table Tab4 based on the object data received from the data acquisition unit 11 as a display component configured in the configuration screen.
[0347] Figure 23 It is a diagram showing an example of a configuration screen in the management system according to the embodiment of the present disclosure, in which multiple types of display components are configured.
[0348] Figure 23 The shown configuration screen is used, for example, to grasp the current value or power value of multiple types of varieties and components during a certain period.
[0349] Refer to Figure 23 , in the upper part of the configuration screen, in order from left to right, it includes: an input field for the display period, a table created by the display component creation unit 21 for selecting a variety, a table created by the display component creation unit 21 for selecting a part name, and a table created by the display component creation unit 21 for selecting an item to be displayed.
[0350] In addition, in the lower part of the configuration screen, there is an image showing information corresponding to the selected variety, part name, and item.
[0351] Figure 24 It is a diagram showing an example of a configuration screen in the management system according to the embodiment of the present disclosure, in which multiple types of display components are configured.
[0352] Figure 24 The shown configuration screen is used, for example, for the user to confirm the state of a certain device using a moving image.
[0353] Refer to Figure 24, in the configuration screen, for example, there is a Gantt chart with the horizontal axis being the time axis direction, representing the working state of a certain device in the factory to be managed, and a display component (hereinafter, also referred to as a moving image component) for playing back the captured moving image obtained by a camera installed in the factory for photographing the device.
[0354] Figure 25 It is a diagram schematically showing the method of using a moving image in the management system according to an embodiment of the present disclosure.
[0355] Refer to Figure 25 and Figure 1 , for the input reception unit 16, for example, when receiving an operation of selecting a part of the Gantt chart by the user, operation information including the ID of the above device (hereinafter, also referred to as the device ID) and the time corresponding to the part selected by the user (hereinafter, also referred to as the specified time) is output to the confirmation screen creation unit 22 in the processing unit 14.
[0356] The confirmation screen creation unit 22 receives the operation information from the input reception unit 16 and acquires the device ID and the specified time included in the received operation information.
[0357] Then, the confirmation screen creation unit 22 determines the ID of the camera corresponding to the acquired device ID (hereinafter, also referred to as the camera ID), and creates an SQL instruction, the content of which is to request a playlist in the form of HLS (HTTP Live Streaming) including the determined camera ID and the acquired specified time.
[0358] The confirmation screen creation unit 22 creates an http post including the created SQL instruction and sends the created http post to the server 132B via the data acquisition unit 11.
[0359] The server 132B receives the http post from the data visualization device 101, acquires the SQL instruction included in the received http post, and acquires the playlist indicated by the acquired SQL instruction from the database 133.
[0360] Then, the server 132B creates an http response including the acquired playlist as the object data and sends the http response to the data visualization device 101.
[0361] For the data acquisition unit 11 in the data visualization device 101, when receiving the http response from the server 132B, it acquires the object data included in the received http response and outputs the acquired object data to the confirmation screen creation unit 22 in the processing unit 14.
[0362] The confirmation screen creation unit 22 determines the moving image file represented by the playlist by analyzing the target data, i.e., the playlist, received from the data acquisition unit 11.
[0363] Then, the confirmation screen creation unit 22 acquires the SQL instruction included in the display component information of the above-mentioned moving image component from the storage unit 17, and edits the part corresponding to the moving image file in the acquired SQL instruction to the determined moving image file.
[0364] Then, the confirmation screen creation unit 22 creates an http post including the edited SQL instruction and the URLc for access processing, and sends the created http post to the server 132B via the data acquisition unit 11.
[0365] The server 132B receives the http post from the data visualization device 101, acquires the SQL instruction included in the received http post, and acquires the moving image file indicated by the acquired SQL instruction from the database 133.
[0366] Then, the server 132B creates an http response including the moving image file acquired as the target data and sends the http response to the data visualization device 101.
[0367] For the data acquisition unit 11 in the data visualization device 101, when receiving the http response from the server 132B, it acquires the target data included in the received http response, and outputs the acquired target data to the confirmation screen creation unit 22 in the processing unit 14.
[0368] Then, the confirmation screen creation unit 22, for example, acquires the OSS library for depicting the moving image component from the storage unit 17, and uses the acquired OSS library to depict the moving image component based on the target data received from the data acquisition unit 11 on the configuration screen.
[0369] In addition, for example, the processing unit 14 performs processing to also display the time required for the access processing on the confirmation screen.
[0370] More specifically, the confirmation screen creation unit 22 in the processing unit 14, for example, measures the data acquisition time required for the access processing and the drawing time required for the configuration of the display component, and outputs the configuration screen on which the data acquisition time and the drawing time are respectively displayed as the measurement results to the display processing unit 23.
[0371] Specifically, the confirmation screen production unit 22 sends an http post containing an SQL instruction and a URLc for access processing to the server 132B via the data acquisition unit 11, and starts measuring the time.
[0372] Then, for the confirmation screen production unit 22, when receiving the object data included in the http response to the http post from the server 132B, it stops measuring the time and obtains the measured time as the data acquisition time.
[0373] In addition, the confirmation screen production unit 22 measures the time from receiving the object data until the production of the configuration screen is completed.
[0374] Specifically, for the confirmation screen production unit 22, when receiving the object data, it starts measuring the time.
[0375] Then, when the production of the configuration screen based on the object data is completed, the confirmation screen production unit 22 stops measuring the time and obtains the measured time as the rendering time.
[0376] Then, the confirmation screen production unit 22 produces a configuration screen that separately displays the above data acquisition time and the above rendering time as measurement results.
[0377] The display processing unit 23 performs processing to display the configuration screen received from the confirmation screen production unit 22 on the display device 131.
[0378] Figure 26 It is a diagram showing an example of a configuration screen on which each measurement result is displayed in the management system according to an embodiment of the present disclosure.
[0379] Refer to Figure 26 , and the above measurement results are displayed, for example, in the upper right of the area r4 in the configuration screen.
[0380] It should be noted that the confirmation screen production unit 22 is not limited to the configuration of measuring the data acquisition time and the rendering time, and may also be configured to measure at least either the data acquisition time or the rendering time.
[0381] In addition, in Figure 1 , the confirmation screen production unit 22 outputs the above measurement results to the restriction unit 18.
[0382] For example, in a state where the access processing performed by the confirmation screen production unit 22 is permitted, that is, in a state where the above permissions are granted, the restriction unit 18 restricts at least either the time required for each access processing or the number of access processings per certain time.
[0383] Then, when at least one of the time required for each access process and the number of access processes per fixed time satisfies the corresponding specified condition, the restriction unit 18 gives a specified notification.
[0384] More specifically, for example, when at least one of the measurement results received from the confirmation screen production unit 22, i.e., the data acquisition time and the drawing time, is longer than the specified time, the restriction unit 18 outputs a warning indicating that the required time has been exceeded to the processing unit 14.
[0385] In addition, the confirmation screen production unit 22 outputs, for example, the number of access processes performed within the above-specified time to the restriction unit 18.
[0386] For example, when the number of access processes received from the confirmation screen production unit 22 is equal to or more than the specified number, the restriction unit 18 outputs a warning indicating that the number of access processes has exceeded the specified number to the processing unit 14.
[0387] The processing unit 14 receives each of these warnings from the restriction unit 18 and, for example, sends an e-mail (electronic mail) containing the content indicated by each of these warnings to the PC (Personal Computer) used by the user, etc.
[0388] [User management process]
[0389] For example, when the user is a system administrator, the user can perform user management processing by performing specified operations on the data visualization device 101 using a keyboard and mouse, etc. For example, a user management table showing the correspondence between a plurality of user IDs and the corresponding user categories is registered in the database 133.
[0390] When the specified operation is performed, the input reception unit 16 outputs operation information indicating the operation content performed by the user to the processing unit 14.
[0391] The processing unit 14 creates an http post based on the operation information received from the input reception unit 16 and sends the created http post to the server 132B via the data acquisition unit 11. The http post includes an SQL instruction whose content is a request for a plurality of user IDs and the corresponding user categories (hereinafter, also referred to as user data) included in the above user management table and a URLc for access processing.
[0392] The server 132B receives the http post from the data visualization device 101, acquires the SQL instruction included in the received http post, and acquires user data from the user management table in the database 133 according to the acquired SQL instruction.
[0393] Then, the server 132B creates an HTTP response containing the acquired user data and sends the HTTP response to the data visualization device 101.
[0394] For the data acquisition unit 11 in the data visualization device 101, when receiving an HTTP response from the server 132B, it acquires the user data contained in the received HTTP response and outputs the acquired user data to the processing unit 14.
[0395] The processing unit 14 creates a user management table showing the correspondence between multiple user IDs and the categories of the corresponding users based on the user data received from the data acquisition unit 11, and performs the process of displaying the screen containing the created user management table on the display device 131.
[0396] The user, for example, performs the following operations on the data visualization device 101: performing processes such as adding, changing, and deleting at least one of the user ID and the category of the user in the user management table in the screen displayed on the display device 131.
[0397] When this operation is performed, the input reception unit 16 outputs operation information indicating the content of the operation performed by the user to the processing unit 14.
[0398] The processing unit 14 creates an SQL instruction whose content is to update the user management table in the database 133 based on the operation information received from the input reception unit 16, creates an HTTP post containing the created SQL instruction and the URLc for access processing, and sends the created HTTP post to the server 132B via the data acquisition unit 11.
[0399] The server 132B receives the HTTP post from the data visualization device 101, acquires the SQL instruction contained in the received HTTP post, and updates the user management table in the database 133 according to the acquired SQL instruction.
[0400] In this way, in the data visualization device 101, users can create various display components according to various purposes.
[0401] In addition, in the data visualization device 101, users can easily create various confirmation screens corresponding to various purposes using the display components, so they can easily grasp the states of components, devices, buildings, etc. that are management objects.
[0402] In addition, in the data visualization device 101, various permissions for processing using the database can be set according to the user's category, so that appropriate permissions corresponding to the user's category can be set. Thereby, for example, an increase in the processing load of the database 133 can be suppressed, and even a user lacking knowledge related to the database can use the database 133 more smoothly.
[0403] [Flow of operations]
[0404] Each device in the management system 201 includes a computer with a memory, and the arithmetic processing parts such as the CPU in the computer respectively read out a part or all of the programs including the following steps of the flowchart from the memory and execute the programs. The programs of the multiple devices can be installed from the outside respectively. The programs of the multiple devices are respectively circulated in a state stored in a recording medium.
[0405] Figure 27 It is a flowchart that defines the operation process when the data visualization device in the management system according to the embodiment of the present disclosure displays a confirmation screen on the display device.
[0406] Refer to Figure 27 , first, the data visualization device 101 creates a display component according to the user's operation (step S101).
[0407] Next, the data visualization device 101 obtains object data from the database 133 via the server 132B according to the user's operation, and the object data is at least one of measurement data and a calculation result using the measurement data (step S102).
[0408] Next, the data visualization device 101 sets permissions for multiple types of access processing according to the user's operation, and the permissions for the access processing include at least any one of the following permissions: the permission to set the time range of the measurement data that should be obtained from the database 133 and the permission to set the time unit; and the permission to set the type of calculation using the measurement data (step S103).
[0409] Next, the data visualization device 101 updates the display component based on the obtained object data according to the user's operation (step S104).
[0410] Next, the data visualization device 101 creates a confirmation screen configured with the created or updated display component according to the user's operation (step S105).
[0411] In addition, the data visualization device 101 performs the following restriction processing: restricting at least any one of the time required for each access processing and the number of access processes per certain time to be less than a specified restriction time or less than a specified restriction number (step S106).
[0412] Next, the data visualization device 101 obtains object data from the database 133 via the server 132B according to the access processing authority, which is set according to the user's operation (step S107).
[0413] Next, the data visualization device 101 updates the confirmation screen based on the obtained object data according to the user's operation (step S108).
[0414] Next, in the access processing, when the specified conditions set in the restriction processing are satisfied, for example, when at least one of the time required for each access processing and the number of access processings per certain time is equal to or greater than the above-mentioned restriction time or the above-mentioned restriction number (Yes in step S109), the data visualization device 101 notifies the user (step S110).
[0415] Next, the data visualization device 101 performs a process of displaying the time required for the access processing and the content related to the measurement data on the confirmation screen (step S111).
[0416] On the other hand, when the time required for each access processing and the number of access processings per certain time are respectively less than the above-mentioned restriction time and less than the above-mentioned restriction number (No in step S109), the data visualization device 101 performs a process of displaying the time required for the access processing and the content related to the measurement data on the confirmation screen (step S111).
[0417] It should be noted that in the management system 201 of the embodiment of the present disclosure, the servers 132A and 132B and the database 133 are respectively set as single devices, but it is not limited thereto. Alternatively, part or all of the functions of the servers 132A and 132B and the database 133 may be provided by cloud computing. That is, each of the servers 132A and 132B and the database 133 may be composed of multiple cloud servers or the like.
[0418] In addition, in the management system 201 of the embodiment of the present disclosure, the user categories are set to four, but it is not limited thereto. The user categories may also be two, three, or five or more.
[0419] In addition, in the data visualization device 101 of the embodiment of the present disclosure, the processing unit 14 is configured to display a home page screen corresponding to the user category on the display device 131, but it is not limited thereto. The processing unit 14 may also be configured to display a home page screen common to all user categories on the display device 131.
[0420] In this case, for example, when a certain user performs an operation on the data visualization device 101 itself that is not permitted for the user's category, the data visualization device 101 performs a process of displaying a message indicating that the operation is not permitted on the display device 131.
[0421] In addition, in the data visualization device 101 according to the embodiment of the present disclosure, the permission setting unit 15 is configured to grant a narrower permission to the confirmation screen creation unit 22 than to the display component creation unit 21, but is not limited thereto. The permission setting unit 15 may also be configured to grant the same range of permissions to the confirmation screen creation unit 22 as to the display component creation unit 21.
[0422] In addition, in the data visualization device 101 according to the embodiment of the present disclosure, the permission setting unit 15 is configured to grant a narrower permission to the display processing unit 23 than to the confirmation screen creation unit 22, but is not limited thereto. The permission setting unit 15 may also be configured to grant the same range of permissions to the display processing unit 23 as to the confirmation screen creation unit 22.
[0423] In addition, in the data visualization device 101 according to the embodiment of the present disclosure, the permission setting unit 15 is configured to grant permissions including at least any one of the following permissions: the permission to set the time range of the measurement data to be acquired from the database and the permission to set the time unit; and the permission to set the type of calculation using the measurement data, but is not limited thereto. The permission setting unit 15 may also be configured to grant permissions to set other content than the above.
[0424] In addition, in the data visualization device 101 according to the embodiment of the present disclosure, the restriction unit 18 is configured to restrict at least either the time required for each access process or the number of access processes per certain time, but is not limited thereto. The restriction unit 18 may also be configured not to restrict the time required for each access process and the number of access processes per certain time.
[0425] In addition, in the data visualization device 101 according to the embodiment of the present disclosure, the restriction unit 18 is configured to give a prescribed notification when at least either the time required for each access process or the number of access processes per certain time satisfies the corresponding prescribed conditions, but is not limited thereto. The restriction unit 18 may also be configured not to give the prescribed notification.
[0426] In addition, in the management system 201 according to an embodiment of the present disclosure, the processing unit 14 in the data visualization device 101 is configured to send an e-mail including the content indicated by each warning received from the restriction unit 18 to a PC or the like used by the user, but it is not limited thereto. In the management system 201, it may also be configured that a device other than the data visualization device 101, such as the server 132B, sends the e-mail to a PC or the like used by the user.
[0427] More specifically, the restriction unit 18 in the data visualization device 101 outputs, for example, the regulation conditions related to the above access processing to the processing unit 14.
[0428] The processing unit 14 creates an SQL instruction indicating the regulation conditions received from the restriction unit 18, creates an http post including the created SQL instruction and the URLc for access processing, and sends the created http post to the server 132B via the data acquisition unit 11.
[0429] The server 132B receives the http post from the processing unit 14, acquires the regulation conditions indicated by the SQL instruction included in the received http post, and holds the acquired regulation conditions.
[0430] Then, when the processing of the server 132B conforms to the regulation conditions, the server 132B sends an e-mail indicating the conformity to the regulation conditions to a PC or the like used by the user.
[0431] In addition, in the data visualization device 101 according to an embodiment of the present disclosure, the processing unit 14 is configured to display the time required for the access processing on the confirmation screen, but it is not limited thereto. The processing unit 14 may also be configured not to display the time required for the access processing on the confirmation screen.
[0432] Furthermore, the number of people with knowledge related to databases is limited, and it is not easy for people who do not have sufficient professional knowledge related to databases to use the database smoothly using the database language.
[0433] In response to this, in the data visualization device 101 according to an embodiment of the present disclosure, the data acquisition unit 11 acquires object data, which is at least one of the measurement data obtained from the database 133 that accumulates measurement data based on measurement results and the calculation results using the measurement data in the database 133. The processing unit 14 performs processing to display the content related to the measurement data on the confirmation screen based on the object data acquired by the data acquisition unit 11. The permission setting unit 15 can set permissions for multiple types of access processing, which is at least one of the acquisition of measurement data from the database 133 and the calculation using the measurement data in the database 133.
[0434] With such a configuration, various permissions for processing using the database 133 can be set according to the user's category. Therefore, appropriate permissions corresponding to the user's category can be set to suppress an increase in the processing load on the database 133 side.
[0435] Therefore, in the data visualization device 101 according to the embodiment of the present disclosure, in the configuration for visualizing the measurement data obtained from the database 133, the database can be used more smoothly.
[0436] In addition, in the data visualization device 101 according to the embodiment of the present disclosure, in the processing unit 14, the display component production unit 21 produces or updates one or more display components constituting the confirmation screen according to an instruction from the user. The confirmation screen production unit 22 configures the display components produced by the display component production unit 21 to produce or update the confirmation screen according to an instruction from the user. The permission setting unit 15 grants a narrower permission to the confirmation screen production unit 22 than to the display component production unit 21.
[0437] With such a configuration, an excellent system can be realized. This system can easily produce various confirmation screens corresponding to various uses using the display components, and set appropriate permissions corresponding to the user's category, thereby suppressing an increase in the processing load on the database 133 side. In particular, by separating the permissions related to the display components and the permissions related to the confirmation screen, more effective permission setting can be realized.
[0438] In addition, in the data visualization device 101 according to the embodiment of the present disclosure, in the processing unit 14, the display processing unit 23 also performs the process of displaying the confirmation screen according to an instruction from the user. The permission setting unit 15 grants a narrower permission to the display processing unit 23 than to the confirmation screen production unit 22.
[0439] With such a configuration, the permissions related to the display components, the permissions related to the confirmation screen, and the permissions related to screen viewing can be separated, so more effective permission setting can be realized.
[0440] In addition, in the data visualization device 101 according to the embodiment of the present disclosure, the permissions include at least any one of the following permissions: the permission to set the time range of the measurement data that should be obtained from the database 133 and the permission to set the time unit; and the permission to set the type of calculation using the measurement data.
[0441] By setting such parameter configurations, an increase in the processing load on the database 133 side can be effectively suppressed.
[0442] In addition, in the data visualization device 101 according to the embodiment of the present disclosure, the restriction unit 18 also restricts at least one of the time required for each access process and the number of access processes per fixed time in a state where the access process performed by the confirmation screen creation unit 22 is permitted.
[0443] With such a configuration, it is possible to set restrictions on the access process independently of the authority, thereby more reliably suppressing an increase in the processing load on the database 133 side.
[0444] In addition, in the data visualization device 101 according to the embodiment of the present disclosure, when at least one of the time required for each access process and the number of access processes per fixed time satisfies a corresponding specified condition, the restriction unit 18 issues a specified notification.
[0445] With such a configuration, it is possible to warn a user who has been granted the authority for the access process about an increase in the processing load on the database 133 side.
[0446] In addition, in the data visualization device 101 according to the embodiment of the present disclosure, the processing unit 14 also performs a process of displaying the time required for the access process on the confirmation screen.
[0447] With such a configuration, a user who has been granted the authority for the access process can easily recognize the state of the processing load on the database 133 side.
[0448] In addition, in the data processing method in the data visualization device 101 according to the embodiment of the present disclosure, first, object data is acquired, where the object data is at least one of measurement data obtained from the database 133 that accumulates measurement data based on measurement results and calculation results using the measurement data in the database 133. Next, a process of displaying content related to the measurement data on the confirmation screen is performed based on the acquired object data. Next, authorities for multiple types of access processes are set, where the access process is at least one of obtaining measurement data from the database 133 and calculation using the measurement data in the database 133.
[0449] With such a configuration, it is possible to set various authorities for the processing of using the database 133 according to the user's category. Therefore, it is possible to set appropriate authorities corresponding to the user's category and suppress an increase in the processing load on the database 133 side.
[0450] Therefore, in the data processing method in the data visualization device 101 according to the embodiment of the present disclosure, in a configuration where the measurement data obtained from the database 133 is visualized, the database can be used more smoothly.
[0451] The above-described embodiments should be considered illustrative in all respects and not restrictive. The scope of the present invention is shown by the claims rather than by the above description, and it is intended to include all modifications within the meaning and scope equivalent to the claims.
[0452] The above description includes the features described in the following appendices.
[0453] [Appendix 1]
[0454] A data visualization device includes: a data acquisition unit that acquires target data, which is at least one of the measurement data obtained from a database storing measurement data based on measurement results and the calculation results using the measurement data in the database; a processing unit that performs processing to display content related to the measurement data on a confirmation screen based on the target data acquired by the data acquisition unit; and a permission setting unit that can set permissions for multiple types of access processing, where the access processing is at least one of acquiring the measurement data from the database and calculating using the measurement data in the database, and the confirmation screen production unit can select the content of the display components in the confirmation screen by setting the parameters according to an instruction from a user.
[0455] Explanation of reference numerals
[0456] 11: Data acquisition unit
[0457] 14: Processing unit
[0458] 15: Permission setting unit
[0459] 16: Input reception unit
[0460] 17: Storage unit
[0461] 18: Restriction unit
[0462] 21: Display component production unit
[0463] 22: Confirmation screen production unit
[0464] 23: Display processing unit
[0465] 101: Data visualization device
[0466] 131: Display device
[0467] 132A, 132B: Servers
[0468] 133: Database
[0469] 134: Network
[0470] 201: Management system.
Claims
1. A data visualization device, comprising: A data acquisition unit that acquires target data from a database and acquires identification information of a user, where the target data is at least one of measurement data and a calculation result using the measurement data; The permission setting unit grants the processing unit the permission to perform access processing, which is at least one of the processing of obtaining the measurement data from the database and the processing of performing calculations using the measurement data in the database, based on the identification information of the user; The processing unit performs the processing of creating a confirmation screen including the measurement data or the calculation result and the processing of displaying the confirmation screen on the display device based on the target data obtained via the data acquisition unit through the permission; And The storage unit The processing unit includes: The display component creation unit creates or updates one or more display components constituting the confirmation screen according to an instruction from the user, and saves the display components in the storage unit; And The confirmation screen creation unit obtains the display components created by the display component creation unit from the storage unit according to an instruction from the user, and configures the display components to create or update the confirmation screen, The permission setting unit grants the processing unit the permission that the target data that the confirmation screen creation unit can obtain is less than the target data that the display component creation unit can obtain.
2. The data visualization device according to claim 1, wherein The processing unit further includes a display processing unit, and the display processing unit performs the processing of displaying the confirmation screen according to an instruction from the user, The permission setting unit grants the processing unit the permission that the target data that the display processing unit can obtain is less than the target data that the confirmation screen creation unit can obtain.
3. The data visualization device according to claim 1 or 2, wherein The permission includes at least any one of the following permissions: The permission to set the time range of the measurement data to be obtained from the database and the permission to set the time unit; And The permission to set the type of calculation using the measurement data.
4. The data visualization device according to claim 1 or 2, wherein The data visualization device further includes a restriction unit, and the restriction unit restricts at least one of the time required for each access processing and the number of access processings per certain time in a state where the permission is granted to the confirmation screen creation unit.
5. The data visualization device according to claim 4, wherein When at least one of the time required for each access processing and the number of access processings per certain time satisfies the corresponding specified condition, the restriction unit makes a specified notification.
6. The data visualization device according to any one of claims 1, 2, and 5, wherein The processing unit further performs the processing of displaying the time required for the access processing on the confirmation screen.
7. A data processing method, which is a data processing method in a data visualization device, wherein The data processing method includes: Obtaining target data from a database and obtaining identification information of a user, where the target data is at least one of measurement data and a calculation result using the measurement data; Setting the permission to perform access processing based on the identification information of the user, where the access processing is at least one of the processing of obtaining the measurement data from the database and the processing of performing calculations using the measurement data in the database; Performing the processing of creating a confirmation screen including the measurement data or the calculation result and the processing of displaying the confirmation screen on the display device based on the target data obtained through the permission; Produce or update one or more display components constituting the confirmation screen according to instructions from the user, and save the display components; and Obtain the saved and produced display components according to instructions from the user, and configure the display components to produce or update the confirmation screen Set the permission such that the object data that can be obtained when producing or updating the confirmation screen is less than the object data that can be obtained when producing or updating the display components.
8. A computer-readable recording medium storing a data processing program including commands, The command is used to cause the data visualization device to: Obtain object data from a database and obtain identification information of a user, where the object data is at least one of measurement data and a calculation result using the measurement data, Set permissions for access processing based on the identification information of the user, where the access processing is at least one of the processing of obtaining the measurement data from the database and the processing of performing calculations using the measurement data in the database, Perform a production process of a confirmation screen including the measurement data or the calculation result and a process of displaying the confirmation screen on a display device based on the object data obtained through the permissions, Produce or update one or more display components constituting the confirmation screen according to an instruction from the user, and save the display components, Obtain the produced and saved display components according to an instruction from the user, and configure the display components to produce or update the confirmation screen, Set the permissions such that the object data that can be obtained when producing or updating the confirmation screen is less than the object data that can be obtained when producing or updating the display components.
Citation Information
Patent Citations
Management device and management program
JP2019003691A
Sheet for three-dimensional shape
JP2019076412A
Measuring equipment and method of preparing measurement data
US20030037255A1
Human-machine interface system and method for remotely monitoring and controlling a machine
US20050155043A1
System, method, computer program product and user interface for controlling, detecting, regulating and / or analyzing biological, biochemical, chemical and / or physical processes
US20170277829A1