JP2010250567A - Environment information aggregation analysis system - Google Patents

Abstract

<P>PROBLEM TO BE SOLVED: To enable each user to create a screen of an open system business application installed in a user personal computer suited to business requirements in each user in the linkage of the user personal computer with an environment information aggregation analysis system. <P>SOLUTION: Meta data such as authority in a server computer, and hierarchized environment information and organization information is clipped in accordance with the authority of each user and transferred to the user personal computer to set a parameter for linking to the database information of the server computer in each data address of a screen to be created by the user. <P>COPYRIGHT: (C)2011,JPO&INPIT

Description

  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 within the corporate organization, and the name and unit are aggregated by the higher organization (specialized). No. 1998-124587).

  In addition, there is also a solution that solves the difficult problem of coexisting information of subordinate organizations with different side names and units by coexisting with the superordinate organization by defining the environmental aspects in a hierarchy (Japanese Patent Laid-Open No. 2004-62471). . 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 on the browser software of the user's personal computer existing on the network, and the user can use this display interface. Registration of environmental information, such as Te, browsing, or have been acquired.

  In these conventional methods, it is necessary to connect the server computer to the line while registering, browsing, or acquiring environment 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 Laid-Open No. 10-124587 JP 2004-62471 A

  However, it is necessary to consider the access authority and security requirements of the user for data transfer 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 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, it is possible to create a screen tailored to the user's business and transfer environment information of the server computer in each user's application 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.

<Example 1>
FIG. 1 shows an embodiment of the apparatus of the present invention, in which 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.

  100 server devices are connected to 111 user terminal devices and similar user terminal devices 112 and 113 via a network of 114 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 a method of extracting 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 surface structure is created in which the side surface 2 is the upper side and the structures 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 of setting cooperation data in a cell and reading the cooperation data stored in the 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 an 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 result of aggregation processing is extracted from the data stored in the storage device of the server with “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 the existing system and environment information data are linked, the data can be temporarily output from the existing system to a spreadsheet program or the like, and the data can be registered in the database on the server by the environment information collection / 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.

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 showing 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 Link information setting example in cell 900 Add-in program work screen 901 Cell reference setting pull-down indicating the direction of parameter Example 903 cell target range setting section 904 hours parameter setting unit 905 tissue parameter setting unit 906 environmental aspects parameter setting unit

Claims (5)

In the environmental information aggregation and analysis system that aggregates and analyzes environmental information,
A database for registering environment-related information;
A client computer that passes data over a network;
Resident in the client application program, set the parameters for registering and writing database system data in the application program, and start the authentication program such as access authority according to the parameters set by the client, A system linkage add-in program in which the client computer system registers and writes environment-related information of the database system in a preset range; and
An environmental information totaling and analyzing system characterized by comprising: In the environmental information totaling analysis system according to claim 1,
The system linkage add-in program has the position data of the parameters described in the business application by the client computer, searches for the parameter position data set at each predetermined position set by the client computer, integrates the parameters, An environment information totaling and analyzing system characterized in that predetermined environment related information on a database is written and read through an environment information system linkage program in the database system via a network. In the environmental information totaling analysis system according to claim 2,
The system cooperation add-in program registers a part of the metadata of the database system, and the client computer sets parameters for data writing and reading within the authority of the client computer. Analysis system In the environmental information totaling analysis system according to claim 3,
The environment on the server can be set by referring to the add-in program that resides in the user business application system and the information on the add-in program in a specific area of the screen or hidden screen that can be set by the business application system user. Environmental information aggregation and analysis system characterized by being able to register or acquire related information In the environmental information totaling analysis system according to claim 1,
For each cell on the open spreadsheet software screen, parameter information to be passed to the add-in program, such as organization code and environmental side code, is placed in the upper, lower, right, and left cells adjacent to the cell. Environmental information aggregation and analysis system with an add-in program

Images