WO2010119628A1

WO2010119628A1 - System and method for environment information aggregation

Info

Publication number: WO2010119628A1
Application number: PCT/JP2010/002232
Authority: WO
Inventors: 加藤裕康; 佐々木一仁; 川辺洋平
Original assignee: 株式会社日立製作所
Priority date: 2009-04-16
Filing date: 2010-03-29
Publication date: 2010-10-21
Also published as: JP2010250567A; JP5500859B2

Abstract

Upon the linkage of an environment information aggregation analysis system and a client computer, an access right and a security requirement of a user must be satisfied, and thus, unrestricted customization is not allowed on a screen at a client computer side. Therefore, meta data such as rights at a server computer, and hierarchized environment information and organization information, is clipped in accordance with the right of each user, and is transferred to a user personal computer, and a parameter for linking to the database information of the server computer is set at each data address of the screen that the user creates.

Description

Environmental information aggregation system and method

The present invention relates to an environmental information aggregation / analysis system, and more particularly to an environmental information aggregation / analysis system in an organization having a complicated organizational hierarchy, such as a large-scale company group.

In the conventional technology, the name and unit of the environmental aspect are defined as a database record, each actual value is input from the site in the corporate organization, and the name and unit are aggregated by the higher organization (patent) Reference 1).

In addition, there is also a solution that solves the difficult problem of coexisting information of subordinate organizations having different side names and units by coexisting with the superordinate organization by defining the environmental aspects in a hierarchy (Patent Document 2). This method has an advantage that a subordinate organization can automatically add up to different environmental aspects by registering the actual values of environmental aspects that it manages.

In these prior arts, a side hierarchy definition database, side hierarchy definition interface, organization hierarchy definition database, organization hierarchy definition interface, side database, summary processing unit, side hierarchy data display interface, organization on a server computer connected to a network. It has a hierarchical data display interface, and the side hierarchy definition database describes a field in which a unique identifier, name, and unit of a side are described, and a parent-child relationship between hierarchies and a magnification when adding from child to parent. It is characterized by storing records consisting of fields, and the screen information created on the server computer is displayed by the browser software of the user's personal computer existing on the network, and the user uses this display interface. Environmental information, such as registration, browsing, or have been acquired by.

In these conventional methods, it is necessary to connect the server computer to the line while registering, viewing, or acquiring environmental information, and the user cannot customize the screen freely. Therefore, a method of registering environment information with an open business application program resident in a user personal computer has been considered. This method has an advantage that the user can easily customize it according to his / her business.

Japanese Patent Application Laid-Open No. 10-124587 JP 2004-62471 A

However, it is necessary to consider the access authority and security requirements of the user when transferring data with the server computer. However, these are not considered in the prior art. In other words, free screen creation must be reprogrammed by the system administrator or system development vendor, and general users cannot create programs or screens according to their work.

Furthermore, even if the issues of access authority and security requirements are solved, program development will be performed on the business application software in order to import and set these metadata into the user's open business application. Developers with both specialized program skills and business know-how were needed. Normally, multiple engineers participated in the development, which required know-how and a huge amount of man-hours.

The present invention enables each user to create a screen of an open business application in the user personal computer in accordance with the business requirements of each user in cooperation with the user personal computer and the environmental information totaling analysis system. Objective.

The present invention cuts out the authority in the server computer and the metadata such as hierarchical environment information and organization information according to the authority for each user. The extracted metadata is transferred to the user personal computer. Based on the extracted information, the user sets a parameter for linking with the database information of the server computer at each data address of the screen created by the user. The add-in program of the present invention can perform data linkage with the server computer based on this parameter.

In the environmental information totaling and analyzing system of the present invention, each user's application can create a screen tailored to his / her business and send / receive environmental information of the server computer without modifying the program by the development vendor.

Hardware configuration of environmental information summary analysis system example Example flowchart Example of extracting metadata Example of how to extract organization metadata Example of how to extract side metadata Work screen example of indirect parameter specification method Example of how to link actual value data Cell display screen example of indirect parameter specification method Example of work screen of direct parameter specification method

An add-in program is resident in open business application software on the user computer (here, resident means that the business application program on the user computer is implemented using a tool, stored in a storage device, and always read out) The metadata stored in the environmental information aggregation and analysis system in the server computer is extracted according to the user authority and made resident in the add-in program. Link data setting address information and database information. In particular, by using the parameter information described on the business application software and linking the server database information, it is possible to reduce the man-hours for creating the definition for linking.

FIG. 1 shows an embodiment of the apparatus of the present invention, where 100 is a server computer apparatus, and 101 is a storage device section in the server computer apparatus. Reference numeral 111 denotes a user terminal device, and reference numeral 106 denotes a storage device unit of the user terminal device.

The software of the environmental information collection / analysis system of the present invention includes a server-side program composed of 102 linkage programs, 103 authentication programs, 104 and 105 database portions, etc., which are implemented in 101 storage devices, and a user terminal device. It consists of add-in programs installed in 106 storage devices. This add-in program has 107 linkage programs and 108 metadata that differs for each user terminal, and is resident in the business application software and operates on it.

The 100 server devices are connected to 111 user terminal devices and similar

user terminal devices

112 and 113 via the 114 network, and operate independently of each other. *

An embodiment of the present invention will be described below with reference to FIG.
The user activates business application software (in this case, taking spreadsheets as an example) and displays a screen. (201) Next, a cell or cell range on the screen is selected (202), and the work screen of the add-in program of the present invention is displayed. (203) The add-in program starts communication with the server, confirms the user authentication information, and extracts only the metadata within the authority determined by the user based on the user authentication information from the metadata in the server storage unit ( 205), and sends it to the user add-in program. The add-in program temporarily stores the metadata extracted for itself and the relationship information with the target cell or cell range in the storage device unit of the user terminal device.

The user freely modifies the layout on the spreadsheet program screen, and presses the communication button in the add-in program (208), then server cooperation is newly activated (209), and after confirming the user authentication information ( 210), processing using the user's metadata information as a parameter is executed. Examples of processing include registering the actual value data described in a specific cell displayed on the screen of the user terminal device in the storage area identified by the metadata of the server device (211), the user The metadata is read from the screen information of the terminal device, transmitted as a parameter to the server device, and the actual value data stored by this parameter is extracted or aggregated (211), and is stored in the screen cell of the user terminal device. Display actual value data. (213) Here, it is possible to display that the processing has been normally executed as registration completion.

Next, one metadata extraction method according to the user will be described in detail with reference to FIG.
When server cooperation is started, the add-in program in the user terminal device transmits user authentication information to the server device (302). In the server device, based on the received authentication information, the organization information permitted to be accessed is extracted together with the upper limit relationship (tree structure) of the organization and stored as user metadata in a storage device in the user device. From this metadata, the user sets information to be linked with the cell as a parameter.

Fig. 4 shows how to extract from metadata. Using the access authority information 401 and the user authentication information, a part such as 402 is cut out from the structured organization metadata, and is cut out as user data 403 as data for the user. I will provide a. When cutting out an organization, a plurality of organizations may be cut out and reconfigured into a tree structure under certain rules.

In the flow of FIG. 3, after extracting the organization metadata, environmental aspect information associated with each organization is extracted. (308) The user metadata is provided to the user terminal device after being cut out in the same manner as the organization metadata. In the user terminal device, using this metadata, information to be linked with the cell is set as a parameter. (309)
FIG. 5 illustrates a method for extracting environmental aspect metadata. The access authority is read from the user authentication information (501), and related organization information is extracted from the organization metadata (502). From the extracted organization information, only the relevant side surface (503) is extracted from the metadata that is the side surface structure, restructured, and then stored in the storage device unit in the user terminal device. In FIG. 3, the side surfaces 2-1 and 2-2 of 503 are associated with the tissue 2-1, and the side surface 2-3 is associated with the tissue 2-2. In this way, a side structure is created in which the side surface 2 is the upper side and the organizations 2-1, 2-2, 2-3 are connected to the lower side. In this way, by reconfiguring all the aspects determined for each organization into a tree shape, necessary metadata can be provided to the user terminal device.

Similarly, the time axis data is also checked to see if the organization existed during that period, and the necessary data is extracted as metadata (310). The user terminal device sets the time axis data to be linked to the cell as a parameter. And set. (311)
A method of associating which organization and which side with the target cell or cell range will be described using the screen example of FIG. An add-in program that resides in a business application can display a linked data setting work screen 600. A cell address is set in 605, time axis information is set in 606, organization information is set in 607, and environmental aspect information is set in 608 as parameters. The setting method includes the indirect setting method of FIG. 6 in which parameters are set by extracting from the metadata based on data in a cell adjacent to the target cell, and the direct selection of parameters from the metadata shown in FIG. There is a setting method. In FIG. 6, instead of selecting directly from the metadata, a method of setting up, down, left and right indicating the adjacent direction of the cell and using data existing in the adjacent cell of the target cell as a parameter is a method. It can also have a confirmation function that the parameters set here are consistent with each metadata.

FIG. 7 is a flowchart showing a method for setting linked data in a cell and reading linked data stored in a server. Specify the target cell or cell range on the screen (702), specify the cell adjacent to the cell that reads the address of the cell information and reads the placement direction as a parameter for the data type as in the subroutine indicated by A ( 705), data in the cell is acquired as parameter information. In the same manner, time axis parameters, organization parameters, and environmental aspect parameters are acquired and sent to the server together with user authentication information. The server executes registration and aggregation processing according to the parameters and returns the result to the user terminal device. (712) When all the cells have finished linking, the work of this program ends.

Fig. 8 shows the operation image on the user screen. Reference numeral 801 denotes an example of a table input screen created by the user. When a parameter such as 803 is set in the 802 cell, the data type is the direct setting method, the data of the actual value is used as a parameter, and the time axis is “upper cell”. Data in the upper direction described in the cell is set as a parameter. Here, 2008/06/31 is a parameter. Furthermore, the organization in charge directly sets the “environment headquarters”, and the environmental aspect has the travel distance in the left adjacent cell as a parameter. In the data linkage processing, the results of aggregation processing are extracted from the data stored in the storage device of the server using "actual value", "2008/06/31", "environment headquarters", and "travel distance" as parameters, and displayed in the user's cell . Here is an example of “2500”. In this way, direct designation and indirect designation can be used in combination.

According to the present embodiment, it is possible to download the result of aggregating the data registered on the server in the report format required for the government office report (written in spreadsheet application software). it can. In particular, instead of creating a special program for the reporting format, the environment information collection and analysis system add-in program allows data linkage to be freely set within the defined constraints. Users can download data directly. Compared to developing a single program, a significant reduction in man-hours can be expected.

When linking existing system and environmental information data, data can be temporarily output from the existing system to a spreadsheet program, and the data can be registered in the database on the server using the environmental information collection and analysis system add-in program. Thereby, the new program development man-hour can be reduced.

In this method, even people who have no knowledge in software development can create monthly reports and various reports by people who can operate business application programs, and can easily link with the server database system. The information collection and analysis system add-in program is not a method that captures all of the metadata registered in the server computer, but can add access authority and restrictions based on the user's ID information. The degree of freedom in creating the calculation screen is greatly improved, and security requirements can be secured.

In this example, open spreadsheet software is used. However, in addition to this, environmental information collection and analysis system metadata is extracted in an add-in program that is resident in a business application program, and within the scope of the corresponding access authority. It can be assumed that parameters are set.

Contributes to industry as an environmental information aggregation system. In particular, the present invention can be applied to an environmental information aggregation system in an organization having a complicated organizational hierarchy such as a large-scale corporate group.

DESCRIPTION OF SYMBOLS 100 Server computer apparatus 101 Memory | storage device part 102 Cooperation processing program 103 Authentication processing program 104 Metadata, such as an organization tree and an environmental side tree 105 Real data, such as an environmental side performance result value 106 Storage | storage device part 107 Cooperation processing program 108 User metadata 111 User terminal Device 114 Network system (Internet etc.)
401 Access authority information 402 Organization metadata reconfigured for extraction 403 Organization metadata 501 Access authority information 502 Organization metadata extracted 503 Environment aspect metadata reconfigured for extraction 503 Environment aspect metadata Data 600 Add-in program work screen 601 Cell reference setting pull-down example indicating parameter existence direction 602 Cell reference setting pull-down example indicating parameter existence direction 603 Cell target range setting unit 604 Time parameter setting unit 605 Organization parameter setting unit 606 Environmental aspect parameter Setting unit 800 User application software display example 801 Example of cell-linked information setting 900 Add-in program work screen 901 Cell reference setting indicating the direction of parameter existence Pulldown Case 903 cell target range setting section 904 hours parameter setting unit 905 tissue parameter setting unit 906 environmental aspects parameter setting unit

Claims

In the environmental information aggregation system that aggregates environmental information,
A server with a database for registering environmental information;
A client computer connected to the server via a network,
The client computer is
A parameter setting unit for setting parameters for performing writing to the database;
According to the set parameters, an access authority authenticating unit for confirming the access authority of the client computer;
A system linkage unit that writes the environment information in an area set according to the access authority of the database;
Environmental information totaling system characterized by comprising.
In the environmental information totaling system according to claim 1,
The client computer further includes a business application that handles the environmental information,
The parameter setting unit extracts a parameter of environment information displayed on the business application from a position where the environment information is displayed, and sets environment related information in a predetermined area on the database based on the extracted parameter. An environmental information aggregation system characterized by writing.
In the environmental information totaling system according to claim 2,
The business application is spreadsheet software,
The parameter setting unit recognizes a cell on the screen of the business application as the displayed position, and extracts a previous period parameter.
In the environmental information totaling system according to any one of claims 1 to 3,
The client computer has a portion of the database metadata;
The system cooperation unit sets an area to be written according to a part of the metadata and the access authority.
In the environmental information totaling system according to claim 4,
Information on the add-in program to be resident in the business application is installed in a specific area of a screen set by the user of the business application, and the environment information on the database can be registered or acquired by referring to the information Environmental information collection system characterized by being able to do.
In the environmental information aggregation method that aggregates environmental information,
Environmental information is stored in the server database.
By a client computer connected to the server via a network,
A parameter setting step for setting parameters for writing to the database;
According to the set parameters, an access authority authentication step for confirming the access authority of the client computer;
A system cooperation step of writing the environment information in an area set in accordance with the access authority of the database;
Environmental information totaling method characterized by comprising.
In the environmental information totaling method according to claim 6,
The client computer further includes a business application that handles the environmental information,
The parameter setting step extracts a parameter of environment information displayed on the business application from a position where the environment information is displayed, and sets environment related information in a predetermined area on the database based on the extracted parameter. An environmental information aggregation method characterized by writing.
In the environmental information totaling method according to claim 7,
The business application is spreadsheet software,
The parameter setting step includes recognizing a cell on the screen of the business application as the displayed position and extracting a previous period parameter.
In the environmental information totaling method according to any one of claims 6 to 8,
The client computer has a portion of the database metadata;
In the system cooperation step, an area to be written is set in accordance with a part of the metadata and the access authority.