WO2010119628A1 - Système et procédé pour une agrégation d'informations d'environnement - Google Patents

Système et procédé pour une agrégation d'informations d'environnement Download PDF

Info

Publication number
WO2010119628A1
WO2010119628A1 PCT/JP2010/002232 JP2010002232W WO2010119628A1 WO 2010119628 A1 WO2010119628 A1 WO 2010119628A1 JP 2010002232 W JP2010002232 W JP 2010002232W WO 2010119628 A1 WO2010119628 A1 WO 2010119628A1
Authority
WO
WIPO (PCT)
Prior art keywords
environmental information
information
database
parameter
business application
Prior art date
Application number
PCT/JP2010/002232
Other languages
English (en)
Japanese (ja)
Inventor
加藤裕康
佐々木一仁
川辺洋平
Original Assignee
株式会社日立製作所
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by 株式会社日立製作所 filed Critical 株式会社日立製作所
Publication of WO2010119628A1 publication Critical patent/WO2010119628A1/fr

Links

Images

Classifications

    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
    • G06Q10/00—Administration; Management
    • G06Q10/06—Resources, workflows, human or project management; Enterprise or organisation planning; Enterprise or organisation modelling

Definitions

  • 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.
  • 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).
  • Patent Document 2 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.
  • 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.
  • a side hierarchy definition database 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.
  • 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.
  • the user 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.
  • 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 flowchart Example of extracting metadata
  • Example of how to extract organization metadata Example of how to extract side metadata
  • Example of indirect parameter specification method Example of how to link actual value data
  • Cell display screen example of indirect 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
  • 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. *
  • 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.
  • 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.
  • the add-in program in the user terminal device transmits user authentication information to the server device (302).
  • 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.
  • 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.
  • a plurality of organizations may be cut out and reconfigured into a tree structure under certain rules.
  • 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.
  • 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.
  • 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.
  • necessary metadata can be provided to the user terminal device.
  • 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.
  • 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.
  • the data type is the direct setting method
  • the data of the actual value is used as a parameter
  • the time axis is “upper cell”.
  • Data in the upper direction described in the cell is set as a parameter.
  • 2008/06/31 is a parameter.
  • 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.
  • 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 .
  • "actual value” "2008/06/31”
  • "environment headquarters” "travel distance”
  • 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.
  • 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.
  • 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.
  • 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.
  • 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.

Landscapes

  • Engineering & Computer Science (AREA)
  • Business, Economics & Management (AREA)
  • Human Resources & Organizations (AREA)
  • Strategic Management (AREA)
  • Economics (AREA)
  • Entrepreneurship & Innovation (AREA)
  • Educational Administration (AREA)
  • Game Theory and Decision Science (AREA)
  • Development Economics (AREA)
  • Marketing (AREA)
  • Operations Research (AREA)
  • Quality & Reliability (AREA)
  • Tourism & Hospitality (AREA)
  • Physics & Mathematics (AREA)
  • General Business, Economics & Management (AREA)
  • General Physics & Mathematics (AREA)
  • Theoretical Computer Science (AREA)
  • Management, Administration, Business Operations System, And Electronic Commerce (AREA)
  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)

Abstract

Lors de la liaison d'un système d'analyse d'agrégation d'informations d'environnement et d'un ordinateur client, un droit d'accès et une exigence de sécurité d'un utilisateur doivent être satisfaits, et ainsi, une personnalisation sans restriction n'est pas permise sur un écran au niveau d'un côté ordinateur client. Par conséquent, des métadonnées telles que des droits au niveau d'un ordinateur de serveur, et des informations d'environnement et des informations d'organisation hiérarchisées, sont découpées conformément au droit de chaque utilisateur et sont transférées à l'ordinateur personnel d'un utilisateur, et un paramètre pour une liaison aux informations de la base de données de l'ordinateur de serveur est fixé à chaque adresse de données de l'écran que crée l'utilisateur.
PCT/JP2010/002232 2009-04-16 2010-03-29 Système et procédé pour une agrégation d'informations d'environnement WO2010119628A1 (fr)

Applications Claiming Priority (2)

Application Number Priority Date Filing Date Title
JP2009099523A JP5500859B2 (ja) 2009-04-16 2009-04-16 環境関連情報集計分析システム。
JP2009-099523 2009-04-16

Publications (1)

Publication Number Publication Date
WO2010119628A1 true WO2010119628A1 (fr) 2010-10-21

Family

ID=42982303

Family Applications (1)

Application Number Title Priority Date Filing Date
PCT/JP2010/002232 WO2010119628A1 (fr) 2009-04-16 2010-03-29 Système et procédé pour une agrégation d'informations d'environnement

Country Status (2)

Country Link
JP (1) JP5500859B2 (fr)
WO (1) WO2010119628A1 (fr)

Families Citing this family (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US10339157B2 (en) * 2013-02-13 2019-07-02 Facebook, Inc. Hive table links
JP7284958B2 (ja) * 2019-05-20 2023-06-01 株式会社DSi データ連携システム

Citations (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
JPH10124587A (ja) * 1996-10-25 1998-05-15 Hitachi Ltd 環境管理支援システム
JP2002032255A (ja) * 2000-07-17 2002-01-31 Toshiba Corp ユーザ情報管理プログラムを記録したコンピュータ読み取り可能な記録媒体及びデータベース管理システムのユーザ情報管理装置
JP2004341770A (ja) * 2003-05-15 2004-12-02 Kazuo Kobayashi データ管理システム及びデータ管理方法

Patent Citations (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
JPH10124587A (ja) * 1996-10-25 1998-05-15 Hitachi Ltd 環境管理支援システム
JP2002032255A (ja) * 2000-07-17 2002-01-31 Toshiba Corp ユーザ情報管理プログラムを記録したコンピュータ読み取り可能な記録媒体及びデータベース管理システムのユーザ情報管理装置
JP2004341770A (ja) * 2003-05-15 2004-12-02 Kazuo Kobayashi データ管理システム及びデータ管理方法

Also Published As

Publication number Publication date
JP2010250567A (ja) 2010-11-04
JP5500859B2 (ja) 2014-05-21

Similar Documents

Publication Publication Date Title
US7523135B2 (en) Risk and compliance framework
US10503822B1 (en) Application tracking, auditing and collaboration systems and methods
US10860549B2 (en) Building and managing data-processing attributes for modeled data sources
JP6116139B2 (ja) 解析データ用の直感的なコンテクストを作成するためのシステム及び方法
US20030233631A1 (en) Web services development method
CN101454779A (zh) 基于搜索的应用开发框架
US11698944B2 (en) System and method for creation and handling of configurable applications for website building systems
US6959429B1 (en) System for developing data collection software applications
CN106095670A (zh) 测试报告的生成方法及装置
JP5469645B2 (ja) 文書管理サーバーシステム
CN110941629A (zh) 元数据处理方法、装置、设备及计算机可读存储介质
CN110889013B (zh) 一种基于xml的数据关联方法、装置、服务器及存储介质
JP2003015869A (ja) 開発支援プログラム及び開発支援方法並びに開発支援システム
WO2010119628A1 (fr) Système et procédé pour une agrégation d'informations d'environnement
CN106796591A (zh) 将来自多个信息源的信息及工具予以统一化的方法以及应用该方法的计算机程序产品与装置
CN111933228A (zh) 用于临床研究中的项目分发与管理系统的实现方法和装置
Ham et al. Evaluation of Data Catalog Software for Hanford Site Environmental Datasets
US20230359814A1 (en) System and method for creation and handling of configurable applications for website building systems
CN106257413A (zh) 将多个信息源的信息及工具统一化的方法以及产品与装置
Addis ELECTRONIC DOCUMENT MANAGEMENT SYSTEM FOR St. MARY’S UNIVERSITY
Ramos-Vidal Tool for the semi-automatic generation of software for Digital Libraries
Chikwanda et al. Call center management systems
Nattapon et al. Visualization of Electrical Architectures In the Automotive Domain Based on the Needs of Stakeholders
WO2023181059A1 (fr) Système(s) et procédé(s) de gestion de cycle de vie de produit réglementaire avec intelligence réglementaire
Ekman Handling Big Data using a Distributed Search Engine: Preparing Log Data for On-Demand Analysis

Legal Events

Date Code Title Description
121 Ep: the epo has been informed by wipo that ep was designated in this application

Ref document number: 10764215

Country of ref document: EP

Kind code of ref document: A1

NENP Non-entry into the national phase

Ref country code: DE

122 Ep: pct application non-entry in european phase

Ref document number: 10764215

Country of ref document: EP

Kind code of ref document: A1