JP2009140417A - Data tabulating method and data tabulating device - Google Patents

Abstract

<P>PROBLEM TO BE SOLVED: To provide a data tabulating method and a data tabulating device capable of flexibly tabulating data. <P>SOLUTION: A data storage means 1 collects data from a data source, and stores the data. A tree structure input means 2 receives the input of a tree structure to which the data source is allocated. A tree structure storage means 3 stores the tree structures which are inputted via the tree structure receiving means 2. A tree structure designating means 4 receives the designation of the specified tree structure among the tree structures stored in the tree structure storage means 3. A tabulating means 5 tabulates the data stored in the data storage means 1 following the tree structure which is designated via the tree structure designating means 4. <P>COPYRIGHT: (C)2009,JPO&INPIT

Description

  The present invention relates to a data totaling method and a data totaling apparatus that collect data from a plurality of data sources and totalize the data.

2. Description of the Related Art An energy management system that automatically collects energy consumption data measured by a measuring instrument and totals the collected data for each energy type such as a facility system, a motive power system, and a production system is known. By collecting and managing energy data for each energy type in this way, it is possible to compare data between energy types, and it is possible to improve the efficiency of energy management, such as facilitating the formulation of energy saving measures.
JP 2007-264704 A

  However, the conventional energy management system employs a method of storing the totaling results obtained according to a fixed tabulation method, and the tabulation method cannot be flexibly changed, and the original data is not stored. Data cannot be aggregated again due to the aggregation method.

  For this reason, for example, if the same equipment is used in a different department from the past due to changes in organizational structure, etc., the data of the equipment will be used as new department data after the organizational structure is updated. It is necessary to tabulate. Further, for example, there are cases where it is desired to aggregate power consumption not only by power type but also by department of the organization. However, in the conventional system, it is not possible to change the allocation of original data or select a specific aggregation method from a plurality of aggregation methods based on different viewpoints.

  An object of the present invention is to provide a data tabulation method and a data tabulation apparatus that enable flexible data tabulation.

The data aggregation method of the present invention is a data aggregation method for collecting data from a plurality of data sources, and collecting the data, storing the data from the data sources, and storing the data, and the data sources are allocated. Receiving an input of a tree structure, storing the tree structure, receiving a designation of a specific tree structure from the stored tree structure, and storing the data according to the specified tree structure And a step of executing the aggregation.
According to this data tabulation method, input of a tree structure is accepted, specification of a specific tree structure is accepted, and data is tabulated according to the specified tree structure, so that flexible data tabulation is possible.

  In the step of storing the data, the data is stored in association with each collection time. In the step of storing the tree structure, the tree structure is input and stored in association with each application period. In the step of executing the aggregation, the tree structure corresponding to the data collection time may be selected and aggregated based on the aggregation time and the application period.

The data totaling device of the present invention collects data from a plurality of data sources and collects data from the data sources, collects data from the data sources, and stores the data. Tree structure input means for receiving an input of the tree structure to be allocated, tree structure storage means for storing the tree structure input via the tree structure reception means, and the tree structure stored in the tree structure storage means A tree structure designating unit for accepting designation of a specific tree structure, and a summing unit for summing up the data stored in the data storage unit according to the tree structure designated via the tree structure designating unit; It is characterized by providing.
According to this data tabulation apparatus, input of a tree structure is accepted, designation of a specific tree structure is accepted, and data is tabulated according to the designated tree structure, so that flexible data tabulation is possible.

  The data storage means stores the data in association with each collection time, the tree structure input means accepts an input of an application period corresponding to the tree structure, and the tree structure storage means A structure is stored in association with each application period, and the aggregation means selects and aggregates the tree structure corresponding to the data collection time based on the aggregation time and the application period. Good.

  According to the data tabulation method of the present invention, the input of a tree structure is accepted, the designation of a specific tree structure is accepted, and the data is tabulated according to the designated tree structure, so that flexible data tabulation is possible.

  According to the data tabulation apparatus of the present invention, the input of a tree structure is accepted, the designation of a specific tree structure is accepted, and the data is tabulated according to the designated tree structure, so that flexible data tabulation is possible.

  Hereinafter, an embodiment of a data tabulation method according to the present invention will be described with reference to FIGS.

  FIG. 1A is a block diagram showing a configuration of a data tabulation apparatus that executes the data tabulation method of the present embodiment.

  As shown in FIG. 1A, the data totaling device collects data from a data source, stores data, and stores a data storage unit 1 and a tree structure input unit 2 that receives an input of a tree structure to which the data source is allocated. A tree structure storage means 3 for storing the tree structure input via the tree structure reception means 2, and a tree structure for receiving a designation of a specific tree structure from among the tree structures stored in the tree structure storage means 3 A specifying unit 4, a totaling unit 5 that executes totaling of data stored in the data storage unit 1 in accordance with the tree structure specified via the tree structure specifying unit 4, and a display unit that displays the totaling result by the totaling unit 5 6.

  FIG. 1B is a diagram showing a data structure of data stored in the data storage unit 1 and a data structure of a tree structure setting file stored in the tree structure storage unit 3.

  As shown in FIG. 1B, the data stored in the data storage unit 1 is configured by associating a data ID for identifying each data, a collection date and time of the data, and a data value of the data. . Data stored in the data storage means 1 is collected online from various measuring instruments, for example, and stored and accumulated in the data storage means 1 each time.

  The tree structure setting file stored in the tree structure storage unit 3 is a tree structure ID that identifies each tree structure setting file, an application period in which the tree structure is to be applied, and a tree structure from the same viewpoint with different application periods. The link information for joining each other and the structure of the tree structure are associated with each other.

  The application period indicates a period during which the tree structure set by the tree structure setting file is applied, and is input as, for example, an application period start date and an application period end date generated by a change in the plant configuration or an organization change.

  The link information is information for associating, for example, tree structures with the same viewpoint, such as a viewpoint for each energy type or a viewpoint for each department in the organization, with different application periods. For example, tree structure IDs of other tree structure setting files having different application periods are stored as link information.

  FIG. 2 is a diagram illustrating a tree structure set by the “tree structure” (FIG. 1B) of the tree structure setting file.

  As shown in FIG. 2, the tree structure has a structure in which data stored in the data storage means 1 is allocated to hierarchized nodes. Nodes can be hierarchized in arbitrary groups. For example, if it is a department in an organization, each node should be set for each section (hierarchy I), for each department (hierarchy II), and for each office (hierarchy III). Can do. As shown in FIG. 2, a data ID indicating each data is associated with a node in the lowest hierarchy. In the tabulation method of this embodiment, data tabulation can be performed for each node in an arbitrary hierarchy.

  The tree structure is created as a tree structure setting file based on a free viewpoint according to the user's intention. For example, an arbitrary viewpoint such as a viewpoint for each energy type or each department in the organization can be used. Therefore, it is possible to aggregate the same data based on different viewpoints.

  As described above, an application period is given to the tree structure, and the tree structure setting file to be applied may differ depending on the time even from the same viewpoint.

  The tree structure setting file is input in advance through the tree structure input means 2 and stored in the tree structure storage means 3 prior to aggregation. The tree structure setting file stored in the tree structure storage means 3 can be edited via the tree structure input means 2.

  FIG. 3 is a flowchart showing the procedure of the data totaling calculation.

  In step S <b> 1 of FIG. 3, an operation for specifying a specific tree structure setting file from the tree structure setting files stored in the tree structure storage unit 3 is accepted via the tree structure specifying unit 4.

  In step S2, the tree structure setting file designated in step S1 is extracted from the tree structure storage means 3. If there is a file having the same viewpoint as the tree structure setting file specified in step S1 and having a different application period based on the link information, the tree structure setting means 3 stores the tree structure setting file. Extract from

  In step S3, a data ID corresponding to the extracted tree structure is acquired based on the “tree structure” (FIG. 1B, FIG. 2) of the tree structure setting file extracted in step S2.

  Next, in step S4, the tabulation unit 5 acquires data corresponding to the acquired data ID from the data storage unit 1, and executes data tabulation using the extracted tree structure setting file.

  Here, the aggregation means 5 applies the tree structure setting file corresponding to the collection date and time of each data based on the aggregation date and time of each data (FIG. 1 (b)) and the application period of the tree structure setting file. Execute. For this reason, even when aggregation is required over a plurality of tree structure setting files having different application periods, the correct tree structure is always selected regardless of the time.

  In step S4, designation of the range of data to be used can be received in advance. For example, it is possible to accept a range specification for data type (data ID) and data collection date and time. It is also possible to accept in advance the designation of the node that is the aggregation unit.

  In step S4, the data aggregation calculation is executed in order from the node of the lowest hierarchy, and the aggregation objects are sequentially expanded to the nodes of the upper hierarchy. By this procedure, the aggregation result can be obtained up to the node of the highest hierarchy. Aggregation can be performed not only for addition of data values but also for various statistical values.

  Next, in step S5, the result of aggregation in step S4 is displayed on the display unit 6, and the process ends. Here, the user can freely specify the hierarchy of nodes to be displayed. Therefore, it is possible to freely analyze the hierarchy necessary for the analysis.

  FIG. 4 shows a display example of the total result. In this example, data for each department (department A, department B, department C) is tabulated on a monthly basis, and the transition is graphically displayed.

  As described above, according to the present embodiment, the tree structure setting file can be input and edited by the tree structure input means 2, so that the tree structure can be easily changed.

  In addition, by setting an application deadline in the tree structure setting file, it is possible to cope with changes in the totaling category that frequently changes, such as organization organization.

  Furthermore, the collected data can be aggregated based on tree structures from various viewpoints. For this reason, even if the problem is not known in advance, data can be easily analyzed by setting a new tree structure or changing the designation of the tree structure to be used.

  In the above embodiment, by using an XMI file for setting the tree structure, text editing or setting by the XMI editor can be performed.

  In addition, it is possible to distribute the data on the web, and it is possible to flexibly execute the aggregation calculation at the client via the network. The shared data in the server can be used as an aggregation target element, and aggregation methods with different uses can be taken for each client. For example, the analysis tool used by the energy manager and the energy consumption notification tool for the manufacturing department can be used properly.

  As described above, according to the data totaling method of the present invention, the input of the tree structure is accepted, the designation of the specific tree structure is accepted, and the data is aggregated according to the designated tree structure. Aggregation is possible.

  The scope of application of the present invention is not limited to the above embodiment. The present invention can be widely applied to a data totaling method and a data totaling apparatus that collect data from a plurality of data sources and totalize the data.

It is a figure explaining the data totaling method of this embodiment, (a) is a block diagram which shows the structure of the data totaling apparatus which performs the data totaling method of this embodiment, (b) is stored in the data storage means 1 The data structure of the data to be processed, and the data structure of the tree structure setting file stored in the tree structure storage means. The figure which illustrates the tree structure set by the tree structure setting file. The flowchart which shows the procedure of data totaling calculation. The figure which shows the example of a display of a total result.

Explanation of symbols

DESCRIPTION OF SYMBOLS 1 Data storage means 2 Tree structure input means 3 Tree structure storage means 4 Tree structure designation means 5 Aggregation means

Claims (4)

In a data aggregation method that collects data from multiple data sources and aggregates the data,
Collecting data from the data source and storing the data;
Receiving an input of a tree structure to which the data source is allocated, and storing the tree structure;
Receiving a designation of a specific tree structure from among the stored tree structures;
Performing aggregation of the stored data according to the specified tree structure;
A data totaling method comprising: In the step of storing the data, the data is stored in association with each collection time,
In the step of storing the tree structure, the tree structure is input and stored in association with respective application periods;
The data aggregation method according to claim 1, wherein in the step of executing the aggregation, the tree structure corresponding to the data collection time is selected and aggregated based on the aggregation time and the application period. . In a data aggregation device that collects data from multiple data sources and aggregates the data,
Data storage means for collecting data from the data source and storing the data;
A tree structure input means for receiving an input of a tree structure to which the data source is allocated;
Tree structure storage means for storing the tree structure input via the tree structure reception means;
Tree structure designating means for accepting designation of a specific tree structure from the tree structures stored in the tree structure storing means;
Aggregating means for performing aggregation of the data stored in the data storage means according to the tree structure designated via the tree structure designating means;
A data totaling device comprising: The data storage means stores the data in association with each collection time,
The tree structure input means receives an input of an application period corresponding to the tree structure;
The tree structure storage means stores the tree structure in association with each application period,
4. The data totaling apparatus according to claim 3, wherein the totaling unit selects and totalizes the tree structure corresponding to the data collection time based on the totaling time and the application period.

Images