CN105493050B - Data processing equipment and data processing method - Google Patents

Data processing equipment and data processing method Download PDF

Info

Publication number
CN105493050B
CN105493050B CN201480046468.2A CN201480046468A CN105493050B CN 105493050 B CN105493050 B CN 105493050B CN 201480046468 A CN201480046468 A CN 201480046468A CN 105493050 B CN105493050 B CN 105493050B
Authority
CN
China
Prior art keywords
data
subtree
measurement point
measured value
measuring device
Prior art date
Legal status (The legal status 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 status listed.)
Active
Application number
CN201480046468.2A
Other languages
Chinese (zh)
Other versions
CN105493050A (en
Inventor
中村隆显
菅野干人
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Mitsubishi Electric Corp
Original Assignee
Mitsubishi Electric Corp
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 Mitsubishi Electric Corp filed Critical Mitsubishi Electric Corp
Publication of CN105493050A publication Critical patent/CN105493050A/en
Application granted granted Critical
Publication of CN105493050B publication Critical patent/CN105493050B/en
Active legal-status Critical Current
Anticipated expiration legal-status Critical

Links

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/24Querying
    • G06F16/245Query processing

Abstract

Tree construction data are divided into multiple subtrees by measured value table design portion (121), enable the quantity of Measuring Device associated with each subtree below the upper limit number i.e. table storage number of devices for the Measuring Device that measured value is stored in measured value table, and judge whether subtree obtained from segmentation is in determining state, the measured value table stored to the measured value from Measuring Device associated with the subtree is distributed the subtree in the state of determination.The subtree for being not at determining state is further divided into multiple subtrees.

Description

Data processing equipment and data processing method
Technical field
The present invention relates to the technologies of the measurement result of management Measuring Device (also referred to as sensor).
Background technique
Following method has been disclosed: the various viewpoints such as configuration, affiliated or purposes from Measuring Device to by The measurement data that Measuring Device measures carry out having Measuring Device relative to actual setting in accumulative measurement data administrator Practical measurement point, set up actually be not provided with Measuring Device imagination measurement point (for example, patent document 1).
Reality measurement point is corresponding with the measurement data measured by the Measuring Device of physical presence, imaginary to measure point and use in fact The sum of measurement data of border measurement point are corresponding by the calculated virtual measurement data such as proportional assignment.
In addition, also disclosing following method: according to the time by unit, building unit, place unit, measurement classification The management of unit, purposes unit etc. is distinguished, and the measurement data of practical measurement point are divided in portion, and thus finds out imagination measurement point It measures data (for example, patent document 2).
Citation
Patent document
Patent document 1: No. 4640212 bulletins of Japanese Patent No.
Patent document 2: Japanese Unexamined Patent Publication 2006-185318 bulletin
Summary of the invention
Problems to be solved by the invention
There are following characteristic for measurement data: what is reached as time goes by and persistently measures at the same time Measure data often close association each other.
Therefore, in the case where that will measure data and be stored in the table of database, make each column phase of each measured value with table It is corresponding, the measured value at same measurement moment is summarized and is stored for a record, in this way using more convenient.
On the other hand, by the increasing expansion of high performance/low price of Measuring Device in recent years, network bandwidth, every list The technical backgrounds such as the decline of the cost of memory of bit capacity influence, and can receive from more Measuring Devices with the shorter collection period Collection measurement data, and accumulate/save.
Also, from measurement data user, using these measurement data demands also increasing.
For example, existing power consumption is collected and analyzed to determine to improve the strategy of strategy of Saving Energy effect and collect and analyze Machinery/equipment status data the demands such as saves from damage with the prevention to prevent trouble before it happens to machinery/equipment failure.
Based on background as described above, increased by the measurement data of a system administration of measurement data administrator.
In common data base management system, the columns that each table can define is about 1000.
Therefore, it in the case where managing measurement data of generate from the Measuring Device, type considerably beyond the columns upper limit, needs Will contingency table in a column direction, measurement data dispersion is stored in multiple tables.
When that will measure data and be scattered in multiple tables, when being clicked through as the above-mentioned prior art using imagination measurement In the case that row is added up and/or analyzed using a variety of measurement data, the case where reading measurement data from multiple tables is generated.
Therefore, compared with the case where reading measurement data from a table, there are the time required for accumulative/analysis is increased Problem.
Increase substantially as the quantity for the table for reading measurement data, which also increases.
Also, in the case where reading measurement data from multiple tables, there is also need to add in the application side of user The subsequent processings such as accumulative processing the case where, the problem of becoming larger there is also the research and development of application burden.
The present invention will solve the problems, such as it is as described above as main purpose, its main purpose is, in the number of Measuring Device Amount increases and is dispersed in multiple tables in the case where storage measured value, is determined in a manner of it can be carried out efficiently accumulative and analysis The table of storage location as measured value.
The means used to solve the problem
Data processing equipment management of the invention tree construction data associated with Measuring Device, which is characterized in that the number Data cutting part is included according to processing unit, the tree construction data are divided into multiple subtree datas, so that with each subtree The quantity of the associated Measuring Device of data is that table stores number of devices or less, wherein it is that measured value can that the table, which stores number of devices, It is stored in the upper limit number of the Measuring Device in measured value table;Condition adjudgement portion judges to be divided and obtained by the data cutting part To subtree data whether be in determining state;And table dispenser, it is judged as to by the condition adjudgement portion in determination The subtree data of state distributes the measured value stored to the measured value from Measuring Device associated with the subtree data Table, it is all unrelated to the associated Measuring Device of a subtree data and other any subtree datas and with a son The quantity for setting the associated Measuring Device of data is that the table stores in number of devices situation below, the condition adjudgement portion judgement The 1st is in for a subtree data and determines state, at least one of Measuring Device associated with a subtree data Measuring Device is repeatedly also associated with other subtree datas and number by Measuring Device associated with a subtree data Total number after the repeating part removal of amount and the quantity of Measuring Device associated with the other subtree datas is that the table is deposited It stores up in number of devices situation below, the condition adjudgement portion is judged as that a subtree data and other subtree datas are in the 2 determination states, the condition adjudgement portion make the data cutting part that will be judged as being not at the 1st determining state and the 2nd determination The subtree data of free position in state is further divided into multiple subtree datas.
Invention effect
According to the present invention, determine carry out son while whether subtree data is in the 1st determining state or the 2nd determining state Set the segmentation of data, it is thus possible to make to correspond to the same measured value as much as possible for accumulative and analysis measured value simultaneously Table can be carried out efficiently accumulative and analysis.
Detailed description of the invention
Fig. 1 is the figure for showing the structural example of measurement data administrator of embodiment 1.
Fig. 2 is the figure for showing the structural example of measurement data management system of embodiment 1.
Fig. 3 is the figure for showing the structural example of measurement data management system of embodiment 1.
Fig. 4 is the figure for showing the format example of measurement data of embodiment 1.
Fig. 5 is the exemplary figure for showing the measured value table of embodiment 1.
Fig. 6 is the exemplary figure for showing the structural information of embodiment 1.
Fig. 7 is the exemplary figure for showing the structural information of embodiment 1.
Fig. 8 is the exemplary figure for showing the structural information of embodiment 1.
Fig. 9 is the structural information tree for showing embodiment 1, imagination measurement point information, practical measurement point and measured value table The figure of relationship.
Figure 10 is the exemplary figure for showing the structural information table of embodiment 1.
Figure 11 is the exemplary figure for showing the group name table and grade name table of embodiment 1.
Figure 12 is the exemplary figure for showing the imagination measurement point definition table of embodiment 1.
Figure 13 is the exemplary figure for showing the measured value table design information of embodiment 1.
Figure 14 is the exemplary figure for replacing measurement point definition table for showing embodiment 1.
Figure 15 is the flow chart for showing the generation step of measured value table design information of embodiment 1.
Figure 16 is the flow chart for showing the generation step of measured value table design information of embodiment 1.
Figure 17 is the exemplary figure for showing the measurement point management information table of embodiment 1.
Figure 18 is the exemplary figure for showing the minor structure inforamtion tree management table of embodiment 1.
Figure 19 is the flow chart for showing the step of minor structure inforamtion tree of embodiment 1 is divided into subtree.
Figure 20 is the figure with the preparation stage for showing the measurement data administrator of embodiment 1.
Figure 21 is the collection for the measurement data of measurement data administrator for showing embodiment 1 and the figure for accumulating the stage.
Figure 22 is reading and the figure in accumulative stage for the measurement data of measurement data administrator for showing embodiment 1.
Figure 23 is to show the 1st of the embodiment 1 exemplary figure for determining state.
Figure 24 is to show the 2nd of the embodiment 1 exemplary figure for determining state.
Figure 25 is to show the 3rd of the embodiment 1 exemplary figure for determining state.
Figure 26 is the exemplary figure for showing the structural information tree of embodiment 1.
Figure 27 is the exemplary figure for showing the structural information table of embodiment 1.
Figure 28 is the exemplary figure for showing the structural information tree of embodiment 1.
Figure 29 is the exemplary figure for showing the structural information table of embodiment 1.
Figure 30 is the figure for showing the relationship between the structural information tree of embodiment 1 and practical measurement point.
Figure 31 is the exemplary figure for showing the imagination measurement point definition table of embodiment 1.
Figure 32 is the exemplary figure for showing the imagination measurement point definition table of embodiment 1.
Figure 33 is the exemplary figure for showing the temporary structure information table of embodiment 1.
Figure 34 is the exemplary figure for showing the temporary structure information table of embodiment 1.
Figure 35 is the exemplary figure for showing the measurement point management information table of embodiment 1.
Figure 36 is the exemplary figure for showing the minor structure information tree table of embodiment 1.
Figure 37 is the figure for showing the update example of temporary structure information table of embodiment 1.
Figure 38 is the figure for showing the update example of measurement point management information table of embodiment 1.
Figure 39 is the figure for showing the update example of minor structure information tree table of embodiment 1.
Figure 40 is the figure for showing the update example of temporary structure information table of embodiment 1.
Figure 41 is the figure for showing the update example of measurement point management information table of embodiment 1.
Figure 42 is the figure for showing the update example of minor structure information tree table of embodiment 1.
Figure 43 is the figure for showing the update example of minor structure information tree table of embodiment 1.
Figure 44 is the figure for showing the hardware configuration example of measurement data administrator of embodiment 1.
Figure 45 is the figure for showing the update example of imagination measurement point definition table of embodiment 1.
Figure 46 is the figure for showing the update example of imagination measurement point definition table of embodiment 1.
Figure 47 is the figure for showing the update example of measurement point management information table of embodiment 1.
Figure 48 is the figure for showing the deriving step for replacing measurement point definition of embodiment 1.
Specific embodiment
Embodiment 1
The measurement data administrator that is described as follows in the present embodiment: quantity, measurement data in Measuring Device In the case where maximum number of column of the type far more than a table of data base management system, make simultaneously based on accumulative and analysis Measured value corresponds to the same table as much as possible, execution when executing the time and executing analysis when thus, it is possible to inhibit to execute accumulative The application research and development burden of user is cut down in the increase of time.
The measurement data administrator 100 of present embodiment has structure illustrated by Fig. 1.
In addition, the respective details of constituent element about measurement data administrator 100 shown in FIG. 1, later It is illustrated.
Measurement data administrator 100 is equivalent to the example of data processing equipment.
Also, as shown in Figure 2 and Figure 3, the measurement data administrator 100 and Measuring Device 201, strong point of present embodiment Device 210 and operating terminal 220 constitute measurement data management system 200 together.
In addition, about Fig. 2, Measuring Device shown in Fig. 3 201, strong point device 210, operating terminal 220 details, It is illustrated later.
Before the structure of measurement data administrator 100 and the details of movement for illustrating present embodiment, first Illustrate the summary for measuring the movement of data administrator.
The movement of measurement data administrator 100 is divided into following three processes.
(1) with preparation
(2) collection and accumulation of data are measured
(3) it measures the reading of data and adds up
(1) with preparation
With in the preparation stage, sensing data collection and accumulation, read and accumulative etc. practice starts Before, as preparation, processing (Figure 20) below is executed.
User sets imaginary measurement to measurement data administrator 100 using imagination measurement point information input output section 111 Point defines table 141 (S11).
User uses structural information input and output portion 112, to measurement 100 setting structure information table 142 of data administrator (S12)。
Measured value table design portion 121 measures point according to imagination and defines table 141 and structural information table 142, generates measured value table Design information 143 (S13).
At this point, measured value table design portion 121 measures to record in point definition table 141 in imagination as needed replaces measurement point Information.
It is illustrated later about replacement measurement point.
By step S13, the corresponding relationship of practical measurement point and the column of measured value table 144 (multiple) is determined.
Measured value table defines portion 122 and generates (CREATE) measured value table (S14) according to measured value table design information 143.
In addition, mainly illustrating the processing of S13 in the present embodiment.
(2) collection and accumulation of data are measured
When usually with starting, measurement data, measured value are collected from each practical corresponding Measuring Device that measures It is accumulated in measured value table 144.
Processing (Figure 21) below is specifically executed in the collection and accumulation of measurement data.
(being regular when most cases) measurement data (S21) repeatedly in each Measuring Device 201.
Data collection will be measured in measurement data administrator 100 by strong point device 210.
It will be in the measurement data collection accumulation unit 131 of collected measurement data write-in measurement data administrator 100 (S22)。
Data collection accumulation unit 131 is measured according to measured value table design information 143, determines the storage location as measured value Measured value table 144 and column, by (S23) in the corresponding column of measured value write-in for measuring data.
Also, it in the case where defining replacement measurement point associated with the measurement practical measurement point ID of data, will count In the corresponding column of measured data write-in.
It is illustrated later about replacement measurement point.
(3) it measures the reading of data and adds up
When being usually accumulated in measured value table 144 with the measured value for starting, measuring data, counted as needed The reading of measured data and accumulative, user's use measurement data of measurement data administrator 100.
Processing (Figure 22) below is specifically executed in the reading for measuring data and in adding up.
The specified imagination of user measured point title and during the measurement moment for measuring data, from operating terminal 220 to measurement Data administrator 100 requests the reading (S31) of measurement data.
Imagination measurement data operation portion 132 defines table 141 based on imagination measurement point according to specified imagination measurement point title Obtain the list (S32) of the practical measurement point for obtaining the desired measurement data of user.
At this point, replace a measurement point to some imagination measurement point definition, measurement point and other practical measurement points are replaced at this In the case that measurement data are dispensed in the same table, imagination measurement data operation portion 132 is corresponding from point is measured with replacement Measurement data (S32) is read in column.
Also, imagination measurement data operation portion 132 will be measured according to imagination point define calculated measurement data export to Operating terminal 220 (S33).
In addition, measured value table design portion 121 is equivalent to data cutting part, condition adjudgement portion, table dispenser and replaces measurement The example of point configuration part.
In addition, measurement data collection accumulation unit 131 is equivalent to the example instead of measurement point calculation part.
In the following, (1) is described in more detail with preparation (S13 of Figure 20).
Knot of measurement data administrator 100 management of present embodiment as the tree-shaped construction data as illustrated in Fig. 9 Structure inforamtion tree 700 and structural information tree 710.
Also, it measures data administrator 100 and manages measured value table 144.
The measured value measured by multiple Measuring Devices 201 is stored in measured value table 144.
Structural information tree 700 and structural information tree 710 are respectively provided with the layered structure based on multiple nodes.
Each node becomes the accumulative unit of measured value.
It include 0 or more practical measurement in the calculating formula to each node definition calculating formula of cumulative calculation Point and 0 or more imagination measurement point.
Practical measurement point is the identifier being directly associated with the measured value of measured value table 144, and imagination measurement point is and reality The identifier or pass through other imagination measurement points and the practical identification for measuring point indirect correlation connection that border measurement point is directly associated Symbol.
That is, each node is associated with Measuring Device by practical measurement point and imagination measurement point.
In Fig. 9,721,722,723 indicate imagination measurement point, and 731,732,733 indicate practical measurement point.
The columns of measured value table 144 is that can store the quantity of Measuring Device of measured value in measured value table 144 (table is deposited Storage number of devices) it is limited, the quantity (i.e. the quantity of Measuring Device) that there is practical measurement point is more than the columns of measured value table 144 The case where.
In the case where the quantity of actually measurement point is more than the columns of measured value table 144, need using multiple measured value tables 144。
Measured value is stored in multiple measured value tables 144 by the decision of measurement data administrator 100 of present embodiment In which measured value table 144.
In the measurement data administrator 100 of present embodiment, measured value table design portion 121 is by structural information tree 700 It is divided into multiple minor structure inforamtion trees respectively with structural information tree 710, so that with minor structure inforamtion tree (also referred to as subtree data (subtree data) or subtree (subtree)) associated Measuring Device quantity be the columns of measured value table 214 with Under.
For example, measured value table design portion 121 structural information tree 700 is divided into only node 701 minor structure inforamtion tree, with Node 702a is the minor structure inforamtion tree of root node and using node 702b as the minor structure inforamtion tree of root node.
If the quantity of Measuring Device associated with the minor structure inforamtion tree of node 702a is the columns of measured value table 214 Hereinafter, then without the further segmentation of the minor structure inforamtion tree.
It on the other hand, is more than measured value table in the quantity of Measuring Device associated with the minor structure inforamtion tree of node 702b In the case where 214 columns, by the minor structure inforamtion tree be divided into for example only the subtree of node 702b, using node 703a as root section Point minor structure inforamtion tree, using node 703b as the minor structure inforamtion tree of root node.
If the quantity of Measuring Device associated with all minor structure inforamtion trees reach the columns of measured value table 214 with Under, then measured value table design portion 121 determines whether each minor structure inforamtion tree is in determining state.
Also, measured value table design portion 121 in determine state minor structure inforamtion tree, distribution for store from The measured value table of the measured value of the associated Measuring Device of minor structure inforamtion tree.
To the minor structure inforamtion tree for being not at determining state, measured value table design portion 121 is by the minor structure inforamtion tree into one Step is divided into multiple minor structure inforamtion trees.
There are two types of the states of determination in the present embodiment.
It is all unrelated to the associated Measuring Device of a subtree and other any subtrees and with a subtree phase The quantity of associated Measuring Device be measured value table columns situation below under, measured value table design portion 121 be determined as this one A subtree is in the 1st and determines state.
Also, in Measuring Device associated with a subtree at least one Measuring Device repeatedly with other subtrees It is associated and by the quantity of Measuring Device associated with a subtree and Measuring Device associated with the other subtrees Total number (unique total number) after the repeating part removal of quantity is measured value in the columns situation below of measured value table Table design portion 121 is determined as that a subtree and other subtrees are in the 2nd and determine state.
The subtree 1101,1102 of Figure 23 is in the 1st and determines state.
It is only associated with subtree 1101 with the associated practical measurement point 1~5 of subtree 1101, and the columns of measured value table Below 8.
Equally, only associated with subtree 1102 with the associated practical measurement point 6~11 of subtree 1102, and measured value table Columns below 8.
Therefore, the subtree 1101,1102 of Figure 23 is in the 1st and determines state.
The subtree 1111,1112 of Figure 24 is in the 2nd and determines state.
Practical measurement point associated with subtree 1111 is 1~6, practical measurement point associated with subtree 1112 is 2~ 7。
Practical measurement point 2~6 is associated with subtree 1111 and 1112 both sides of subtree, thus the repeating part is removed and is carried out It counts, the quantity of the quantity of practical measurement point associated with subtree 1111 and practical measurement point associated with subtree 1112 Total number is practical measurement point 1~7 this 7.
Columns of 7 practical measurement points in measured value table is below 8.
Therefore, the subtree 1111,1112 of Figure 24 is in the 2nd and determines state.
Also, the measured value table design portion 121 of present embodiment includes 1 in the calculating formula of root node (node R of Figure 23) The case where measurement point other than a practical measurement point (the case where including 2 or more practical measurement points, comprising practical measurement point and The case where combination of imagination measurement point only includes the case where imagination measures point) under, make to replace measurement point associated with root node.
It is the accumulative meter for indicating to need to carry out measured value in advance before user carries out accumulative instruction instead of measurement point The identifier of calculation.
Also, (comprising practical measurement point the case where the calculating formula of root node (node R of Figure 23) includes imagination measurement point With imagination measurement point combination the case where, only include imagination measurement the case where) under, 121 use of measured value table design portion and this An imagination measurement point directly or indirectly associated practical measurement point, generate only comprising practical measurement point and can obtain with it is right The replacement calculating formula of the identical calculated result of the calculating formula that root node defines makes to replace calculating formula associated with measurement point is replaced.
Also, data collection accumulation unit 131 is measured for a root node associated with replacement measurement point, there is related be somebody's turn to do The accumulative calculating for carrying out measured value before the accumulative instruction of root node in advance keeps calculated result related to measurement point is replaced Connection.
In this way, aggregate-value calculating is completed at the time of user has carried out the accumulative instruction in relation to root node, it is thus possible to Aggregate-value is forthwith prompted to user.
Based on above summary description, the structure of the measurement data administrator 100 of present embodiment is described in detail and moves Make.
Fig. 1 is the functional structure chart of the measurement data administrator 100 of embodiment 1.
The functional structure of measurement data administrator 100 about embodiment 1, is illustrated according to Fig. 1.
Measurement data administrator 100 is the computer installation of the various measurement data of management.
For in terms of big, measurement data administrator 100 has imagination measurement point a management department 110, measured value table pipe Reason portion 120, measurement Data Management Department 130 and data store 140.
Imagination measurement point management department 110 has imagination measurement point information input output section 111 and structural information input and output Portion 112.
Imagination measurement point information input output section 111 accepts the input of imagination measurement point information from the user, will be imaginary Measurement point information is stored in imagination measurement point definition table 141.
Structural information input and output portion 112 accepts the input of structural information from the user, and structural information is stored in number According in the structural information table 142 of storage unit 140.
Also, imagination measurement point information input output section 111 measures point from imagination and defines table according to request from the user 141 read imagination measurement point information, and export read-out imagination measurement point information.
Also, structural information input and output portion 112 is according to request from the user, from 142 reading out structure of structural information table Information, and export read-out structural information.
Table 141 and structural information table 142 are defined about these imagination measurement point information, structural information, imagination measurement point, It is described later.
There is measured value table design portion 121 and measured value table to define portion 122 for measured value table management department 120.
Measured value table design portion 121 according to being recorded in an imagination measurement point definition table 141, the information in structural information table 142, The design information for generating measured value table 144, is recorded as measured value table design information 143 for design information generated.
Also, measured value table defines portion 122 according to measured value table design information 143, actually generates measured value table 144.
Data Management Department 130 is measured by measurement data collection accumulation unit 131, imagination measurement data operation portion 132 and measurement Data output section 133 is constituted.
Measurement data collection accumulation unit 131 accepts the input for the measurement data collected from various Measuring Devices, and is stored in In measured value table 144.
Imagination measurement data operation portion 132 measures the imagination measurement point definition that point defines table 141 according to imagination, calculates imagination Measure the measurement data of point.
It measures data output section 133 to request according to the accumulative reading for waiting measurement data from the user, from measured value table 144 Measurement data are read, read-out measurement data are exported to user.
Data store 140 stores imagination measurement point definition table 141, structural information table 142, measured value table design information 143, the various data of measured value table 144 etc..
Each funtion part of measurement data administrator 100 can also be realized on 1 computer installation, can also divide It is scattered on the multiple stage computers device by network connection and realizes.
Fig. 2, Fig. 3 are the figures for showing the structural example of measurement data management system 200 of embodiment 1.
The structural example of measurement data management system 200 about embodiment 1, according to fig. 2 and Fig. 3 is illustrated.
Measurement data management system 200 shown in Fig. 2 also has in addition to measuring data administrator 100 and passes through network The operation of 210 and 1,1 or more strong point device (hub device) connecting with measurement data administrator 100 or more is whole End 220.
But has the function of the case where operating terminal 220 (application enforcement division 221) in measurement data administrator 100 Under, measurement data management system 200 can also not have operating terminal 220.
Strong point device 210 is that send to measurement data administrator 100 include measured value (such as power consumption, voltage, water consumption Amount, temperature etc.) measurement data computer or communication device.
Strong point device 210 has measurement data reception portion 211, measurement data sending part 212 and strong point device storage unit 219。
Measure data reception portion 211 from measurement measured value each Measuring Device 201 (such as distribution board, voltmeter, water meter, Thermometer etc.) receive the measurement data including measured value.
Measurement data sending part 212 sends to measurement data administrator 100 and is received by measuring data reception portion 211 Measurement data.
Strong point device storage unit 219 stores the meter received by measuring data reception portion 211 that strong point device 210 uses The data such as measured data.
Operating terminal 220 is to execute the application program of the processing of the users such as accumulative processing for carrying out measured value request The device (computer) of (hereinafter referred to as applying).
Operating terminal 220 has the application enforcement division 221 for executing application and is stored in the data that operating terminal 220 uses Operating terminal storage unit 229.
For example, the application enforcement division 221 of operating terminal 220 is acted as described below by executing application.
Measured value is requested to measurement data administrator 100 in application enforcement division 221, takes from measurement data administrator 100 Measured value is obtained, and executes the accumulative processing in relation to acquired measured value.
The measurement data collection accumulation unit 131 (referring to Fig.1) for measuring data administrator 100 is filled from measurement data management Each strong point device 210 for setting 100 connections collects the measurement data including measured value, and collected measurement data are stored in measurement It is worth in table 144.
Measurement data management system 200 shown in Fig. 2 is connect by each strong point device 210 with measurement data administrator 100 Star-like composition.But measure data management system 200 be also possible to each strong point device 210 layering connection as shown in Figure 3 and At tree or with other connection types connect measurement data administrator 100 and each strong point device 210 structure.
In measurement data management system 200 shown in Fig. 3, evidence of the strong point device 210A from the bottom by network connection Point device 210B, 210C collect measurement data, and collected measurement data are sent to measurement data administrator 100.
Fig. 4 is the figure for showing the essential structure of measurement data of present embodiment.
The measurement data 400 of embodiment 1 include at least practical measurement point ID401, measurement moment 402 and measured value 403.
Practical measurement point ID401 is the knowledge for the setting place of unique identification Measuring Device 201 or Measuring Device 201 It does not accord with.
After, the setting place of Measuring Device 201 or Measuring Device 201 is known as " practical measurement point ".
Also, practical measurement point ID is stated with the form of " $ × ".
Wherein, "×" indicates arbitrary integer value.
The measurement moment 402 indicates the time that measured value is measured.
The measurement moment 402 is set by each Measuring Device 201 and/or each strong point device 210.
Measured value 403 indicates the measured value measured by Measuring Device 201.
Fig. 5 is the figure for showing the measured value table 144 of embodiment 1.
Each item record (row) of measured value table 144 by row number 501, measure the moment 502 and measure in synchronization Multiple measured value 503A~503E are constituted.
Row number 501 is the number of the measured value measured for identification in synchronization.
The measurement moment 502 is equivalent to the measurement moment 402, also may include a little error.
The measurement moment 402 exists to be generated according to the deviation of each Measuring Device 201 and/or the clock and watch of strong point device 210 The case where error.
In this case it is necessary to be rounded in the error range of permission to the measurement moment 402 and when as identical measurement Carve the processing of 502 measurement data.
For example, the error of permission is set as 100 milliseconds in advance, will be included in " 2013/4/118:00:00.000 "~ Multiple measurement data in the measurement moment 402 of " 2013/4/118:00:00.099 " are " 2013/4/ as the measurement moment 502 118:00:00.000 " measurement data, be summarised in same record in.
In addition, in the present embodiment, the rounding mode for measuring the error at moment 402 is not essential problem, thus Omit details.
Measured value 403 is stored in any measured value of measured value 503.
Its corresponding relationship is determined according to aftermentioned measured value table design information 143.
In the present embodiment, premised on having the structural information of layered structure, there is shown as setting imagination Measure the structure of the object of the object of point.
The layered structure can for example be expressed as tree construction as shown in FIG. 6, herein will be with such layered structure Information is known as structural information tree.
Also the hierarchical relationship is known as set membership or upper and lower relation.
There are multiple types (viewpoint) as shown in the example of Fig. 6, Fig. 7, Fig. 8 in structural information tree.
Fig. 9 be illustrate structural information tree 700,710, imagination measurement point information 720, practical measurement point information 730 and counting The figure of the relationship of the measured value 503 stored in measured value table 144.
Structural information has multiple structural information trees as structural information tree 700,710.
Structural information tree is the tree construction being made of the node for being referred to as structural information node.
Structural information node is by with father node and the usual node of child node 702,703, the root section without father node Put 701 and the composition of leaf node 704,711 without child node.
It is associated that each structural information node measures imaginary measurement point (such as 722) in information 720 with imagination.
As structural information node 704 and 711, multiple structural information nodes are sometimes referred to as an imagination measurement point 723.
Also, the imagination measurement point for including in imagination measurement point information 720 and more than one practical measurement point information 730 In include practical measurement point (such as 731) or more than one imagination measurement point it is associated.
For example, imagination measurement point 722 is associated with practical measurement 731,732 the two practical measurement points of point.
Also, both existed only related to imagination measurement point (referred to imagination measurement point 722) as imagination measurement point 721 The case where connection, there is also feelings associated with practical measurement point 733 and imagination measurement point both sides as imagination measurement point 723 Condition.
In this way, imagination measurement point is the identifier being directly associated with practical measurement point or is measured by other imaginations Point and the practical identifier for measuring point indirect correlation connection.
In addition, meters more than 1 column of the practical measurement point 731 and measured value table 144 that include in practical measurement point information 730 Measured value 503 is associated.
Practical measurement point is the identifier being directly associated in this way with the measured value of Measuring Device.
The example of structural information tree is shown using Fig. 6.
Structural information tree is the node of the constituent element with the object for indicating the object as setting imagination measurement point The tree structure on the side (line for connecting each node) of (the fillet quadrangle in Fig. 6) and the expression mutual hierarchical relational of constituent element It makes.
Node (for example, " company " node in Fig. 6) positioned at the vertex of tree construction is root node, is father's section of upper Point.
Also, the node (for example, "-stock " node in Fig. 6) for being located at the end of tree construction is leaf node, is lowermost position Child node.
Fig. 6 is the structural information tree for being shown as being arranged the structure of " tissue " of the object of imagination measurement point.
" company " node 601 indicates that company is whole.
" company " is by " administrative department " 602, " zero operating divisions " 603, " △ operating divisions " multiple " department " structures such as 604 At.
Administrative department 602 is made of " Human Resources Department " 605, " General Affairs Department " 606, " accounting department " 607 etc. multiple " portions ".
Human Resources Department 605 is made of " personnel department " 608, " trainee department " 609 etc. multiple " sections ".
Each node " company " 601, " administrative department " 602, " Human Resources Department " 605, " personnel department " 608 etc. are imaginary meter respectively An example of measuring point.
Fig. 7 is an example for being shown as being arranged the structural information tree of the structure of " configuration " of the object of imagination measurement point.
Fig. 8 is an example for being shown as being arranged the structural information tree of the structure of " equipment " of the object of imagination measurement point.
Figure 10 and Figure 11 is the figure for showing the structural information table 142 of embodiment 1.
Structural information table 142 is the number for illustrating that the structural information of object of the object as setting imagination measurement point According to an example.
Structural information table 142 shown in Figure 10 and Figure 11 includes and Fig. 6~related structure of structural information shown in Fig. 8 tree Information.
Structural information table 142 has " node ID " " father ID " " group ID " " grade " " imagination measurement point ID " " node name The record of the corresponding formation of title ".
" node ID " indicates the identifier of structural information node for identification.
" father ID " expression is the identifier of the father node of set membership with the structural information node for identification.
In the case where being " empty (null) " at " father ID ", it is meant that the node is root node.
" group ID " indicates the identifier of structural information tree for identification.
" grade " indicates the depth (grade) of layer locating for the structural information node.
The grade of root node is set as " 1 ", whenever declining one layer towards inferior direction, numerical value increases by 1.
" imagination measurement point ID " indicates the identifier of imagination measurement point corresponding with the structural information node for identification.
In the following, describing imagination measurement point ID for " # × ".
Wherein, "×" indicates arbitrary integer value.
" nodename " illustrates that the nodename of the content of the structural information node.
For example, the node ID of " company " node shown in fig. 6 is " 1 ", group ID is " 1 ", and grade is " 1 ", imagination measurement Point ID is " #1 ".
Also, the node ID of " administrative department " node is " 2 ", and father ID is " 1 " (i.e. " company " node), and group ID is " 1 ", Grade is " 2 ", and imagination measurement point ID is " #2 ".
In structural information table 142, the group name table for indicating the group name of content of structural information tree will be defined 142A and define that indicate that the grade name table 142B of the grade name of the content of each layer of structural information tree associates (equal It is Figure 11).
Group name table 142A has " group ID " " group name " corresponding record.
For example, structural information tree shown in fig. 6 is identified with group ID " 1 ", the tissue in expression company.
Also, tree construction shown in Fig. 7 is identified with group ID " 2 ", indicates " configuration (place) " in company.
Grade name table 142B has the record of " group ID " " grade " " grade name " corresponding formation.
For example, the layer of the grade " 1 " in tree construction shown in fig. 6 indicates that " company " is whole, the layer of grade " 2 " indicates company Interior " department ".
Also, the layer of the grade " 1 " in tree construction shown in Fig. 7 indicates that " configuration " is whole, and the layer of grade " 2 " indicates company Interior cause locating " area ", " cause institute " in the layer expression company of grade " 3 ".
Figure 12 is the figure for showing the imagination measurement point definition table 141 of embodiment 1.
It is an example that the data of imagination measurement point are correspondingly defined with practical measurement point that imagination, which measures point definition table 141,.
Imagination measurement point definition table 141 has will " imagination measurement point ID " 901, " imaginary measurement point title " 902, " imagination The record of measurement point definition " 903, " instead of measurement point mark " 904 corresponding formation.
" imagination measurement point ID " 901 indicates the identifier of identification imagination measurement point.
" imagination measurement point ID " 901 is equivalent to the imagination measurement point ID805 of structural information table 142.
" imagination measurement point title " 902 illustrates that the imagination measurement point title of the content of imagination measurement point.
Imagination measurement point title can also be inconsistent with nodename.
" definition of imagination measurement point " 903 correspondingly shows imaginary measurement with practical measurement point or other imagination measurement points The definition of point.
" instead of measurement point mark " 904 is the mark for indicating whether to measure point comprising replacement in imaginary measurement point definition.
For example, imagination measurement point " #1 " is associated with " the company's total electricity " of power consumption of company's entirety is indicated.
It is organized on a large scale particularly with as company is whole, there is no the measurements for directly measuring its power consumption to set Standby, " company's total electricity " refers to actually not set imaginary measurement point.
Therefore, imagination measurement point " #2 " (administrative department's electricity of the power consumption of imagination measurement point " #1 " and, the next tissue Amount) power consumption, the power consumption of " #10 " (zero operating divisions's electricity) and the sum of the power consumption of " #20 " (△ operating divisions electricity) It is equal.
That is, imagination measurement point " #1 " definition as " #2+#10+#20 " defines.
Imagination measurement point " #201 " with control building " the 1st, Tokyo " entirety power consumption " power transformation of the 1st, Tokyo is set It is standby " it is associated.
The power consumption of imagination measurement point " #201 " is counted in the practical measurement point " $ 1 " for indicating the 1st, Tokyo transformer equipment The power consumption of survey is equal.
Wherein, in the imagination measurement point definition of imagination measurement point " #1 ", other than definition " #2+#10+#20 ", also It defines instead of measurement point " %1 ".
Refer to instead of measurement point other than original imagination measurement point definition or practical measurement point, also in measured value table The measurement point of the column of the measured value for reading imagination measurement point is defined in 144.
That is, in the case where defining instead of measurement point, it, can be from pair of measured value table 144 with practical measurement point Measured value is directly read in the column answered.
Also a point mark 904 is measured to replacement and is set in whether imaginary measure in a definition defines instead of measuring point.
It is explained below instead of the details of measurement point.
In the following, by replacing measurement point ID to describe as " % × " as the identifier for replacing measurement point.
Wherein, "×" indicates arbitrary integer value.
Described in Figure 12 instead of measurement point " %1 ", " %2 ", " %3 " and " %4 ", but due to replace measurement point be Measured value table design portion 121 is set in the S13 (Figure 20) of operational phase, thus replaces measurement point " %1 ", " %2 ", " % 3 " and " %4 " be to be described in measured value table 144 after the processing for carrying out S13.
Figure 13 is the figure for showing the measured value table design information 143 of embodiment 1.
Measured value table design information 143 is to define practical measurement point or replace between measurement point and measured value table 144 Corresponding relationship data an example.
Measured value table design information 143 have will " measurement point ID " 1001, " DB (database) server name " 1002, The record of " database-name " 1003, " table name " 1004, " column name " 1005 and " data type " 1006 corresponding formation.
" measurement point ID " 1001 indicates practical measurement point ID or replaces measurement point ID.
" DB server name " 1002 indicates to define the server name where the data base management system of measured value table 144 Claim.
" database-name " 1003 indicates to define the database-name of measured value table 144.
The actual table name of the expression measured value table 144 of " table name " 1004.
In addition, " DB server name " 1002, " database-name " 1003, " table name " 1004 are examples, with practical meter As long as measuring point replaces the table of the corresponding measured value table 144 of measurement point that can set the information uniquely determined.
" column name " 1005 indicates to store practical measurement point or replaces measuring on the measured value table 144 of the measured value of point Column name.
The data type of the expression measured value of " data type " 1006.
Figure 14 be show it is being attached to the measured value table design information 143 of embodiment 1, instead of measurement point a definition table 143A Figure.
Defining table 143A instead of measurement point has " instead of measuring point ID " 1011, " instead of the definition of measurement point " 1012 relatively The record that should be formed.
" instead of measuring point ID " 1011 indicates to replace measurement point ID.
" instead of the definition of measurement point " 1012 expressions are for calculating the replacement measurement point definition instead of the measurement data of measurement point.
By the measurement data of practical measurement point or practical measurement point and measurement is replaced instead of the definition of measurement point The arithmetic expression for measuring data is constituted.
It is illustrated later instead of the details of measurement point definition.
In a fairly large number of situation for the Measuring Device that large-scale building and/or tissue etc. use, exist and one The upper limit of the quantity of the associated practical measurement point of a structural information tree far more than the columns of a table of measured value table 144 Situation.
In such a case, it is possible to consider contingency table in a column direction, the measurement data of practical measurement point are distributed to more The countermeasure being managed in a table.
At this point, being stored in the method in which table as by the measurement data of which practical measurement point, it may be considered that concern In some structural information tree, the method for contingency table is carried out as unit of its subtree.
For example, focusing on the structural information " configured ", structural information tree is divided into the subtree of each " cause institute ", and divide It is cut into the table for storing measurement data associated with " Tokyo cause institute ", storage measurement number associated with " Kanagawn cause institute " According to table, storage it is associated with " Saitama jade cause institute " measure data table.
In this case, it when by accumulative and analysis the scope control of measured value in cause institute, will not generate tired The problem of efficiency decline of meter and analysis processing.
On the other hand, in the case where being added up and being analyzed according to the structural information other than " configuration ", exist it is accumulative and The case where efficiency decline of analysis processing.
As shown in figure 9, there are an imagination measurement point or practical measurement point situations associated with multiple structural information trees.
In a practical situation, it may be considered that imagination measurement point or practical measurement point are nearly all related to multiple structural information trees The case where connection.
Wherein, it assuming that belonging to each cause positioned at all parts of the country of " zero operating divisions ", needs Measured value is read from multiple measured value tables 144, to carry out the accumulative and analysis of the measurement data in relation to " zero operating divisions ".
Also, the corresponding imagination measurement point of the upper node with structural information tree the case where, to focusing on for example The case where structural information of " configuration " stated is come " company " and/or " Northeast area " when dividing measured value table 144, to passing through vacation In the case where thinking that measurement point definition calculates its measurement data, need to read measured value from multiple measured value tables 144 always.
Here, measurement data required for such progress and analysis are dispersed in the state in multiple measured value tables 144, claim For the part for measuring data.
Measured value table design portion 121 generates the part for inhibiting such measurement data, measured value table 144 set Count information.
As premise, it is assumed herein that pre-generated imagination measurement point information and structural information, and it is respectively stored in imaginary meter Measuring point defines in table 141 and structural information table 142.
In addition, replacing measurement point is to be defined by measured value table design portion 121, thus be in imagination measurement point at the moment There is no definition to replace the state of measurement point in definition.
And, it is assumed that " the measurement point ID " 1001 and " number of practical measurement point are set in measured value table design information 143 According to type " 1006.
It is defined as follows herein.
C: the columns of measurement data can be stored in a table of measured value table 144
The size of tree: the quantity for all nodes for including in the tree
The actual size of tree: unique practical measurement point associated with the tree and the quantity for replacing measurement point
According to Figure 15 and Figure 16, illustrate the movement (S13 shown in Figure 20 in the measured value table design portion 121 of embodiment 1 Movement).
Figure 15 and Figure 16 is the measured value table design information 143 for showing the measured value table design portion 121 of embodiment 1 and carrying out Generation processing the step of flow chart.
(step S1101) measured value table design portion 121 generates in the storage device that operation is used as structural information table 142 Copy temporary structure information table.
In addition, measured value table design portion 121 generates measurement point management information table, minor structure inforamtion tree manages table and initial Change.
These tables can generate in the temporary storing device that measured value table design portion 121 has alone, can also count It is generated in temporary storing device in measured data managing device 100.
Wherein, temporary structure information table is used to manage the state of minor structure inforamtion tree.
Figure 17 is the exemplary figure for showing the measurement point management information table 1200 generated in step S1101.
Measurement point management information table 1200 has will 1201, " this node ID " 1202, " root node ID " " measurement point ID " 1203, the record of " column name " 1204 and " instead of the definition of measurement point " 1205 corresponding formation.
" measurement point ID " 1201 indicates practical measurement point ID or replaces measurement point ID.
" this node ID " 1202 indicates all nodes associated with the imagination measurement point with imagination measurement point definition Node ID, the definition of imagination measurement point is directly comprising utilizing " measurement point ID " 1201 specified practical measurement point ID.
For example, the imagination measurement point in Figure 12 defines in table 141, the imagination measurement point definition of imagination measurement point ID " #201 " 903 be " $ 1 ", directly comprising practical measurement point ID.
In this case, " 201 " are extracted as associated with imagination measurement point ID " #201 " from structural information table 142 Node ID 801, and it is set as " this node ID " 1202.
On the other hand, it is defined in table 141 in the imagination measurement point of Figure 12, the imagination measurement point of imagination measurement point ID " #1 " is fixed Justice 903 is made of the arithmetic expression of the measurement data of all imagination measurement points, because without directly comprising practical measurement point ID.
" the root node ID " 1203 of the measurement point management information table 1200 of Figure 17 indicates to refer to " measurement point ID " 1201 is utilized Fixed practical measurement point replaces measuring a root node ID for associated minor structure inforamtion tree.
In actually measurement point or under replacing measurement point situation associated with multiple minor structure inforamtion trees, to root node ID Set the node ID of the root node of associated all minor structure inforamtion trees.
In the case where the size of associated all minor structure inforamtion trees is 1 (node 1) or with anyon knot In the case that structure inforamtion tree is not associated with, setting " empty (null) ".
" column name " 1204 indicates the measured value table 144 for storing utilization " measurement point ID " 1201 specified measurement data In column name.
" instead of the definition of measurement point " 1205 indicates the definition for calculating the measurement data instead of measurement point.
Instead of the definition of measurement point definition by the measurement data or practical measurement point of single practical measurement point and generation Arithmetic expression for the measurement data of measurement point is constituted.
Figure 18 is the figure for showing the minor structure inforamtion tree management table 1210 generated in step S1101.
Minor structure inforamtion tree, which manages table 1210, to be had " minor structure inforamtion tree ID " 1211, " root node ID " 1212, " sub- knot Structure inforamtion tree group ID " 1213, " determining mark " 1214, " DB server name " 1215, " database-name " 1216 and " table name The record of 1217 corresponding formation of title ".
" minor structure inforamtion tree ID " 1211 indicates the identifier for uniquely identifying minor structure inforamtion tree.
" root node ID " 1212 indicates the node of the root node of the minor structure inforamtion tree using minor structure inforamtion tree ID identification ID。
" minor structure inforamtion tree group ID " 1213 indicates the set for uniquely identifying associated minor structure inforamtion tree The identifier of (minor structure inforamtion tree group).
For being judged as the 2nd multiple minor structure inforamtion trees for determining state, same " the minor structure inforamtion tree group is set ID”。
Really whether " determine mark " 1214 indicate the minor structure inforamtion tree for utilizing " minor structure inforamtion tree ID " 1211 to identify It is fixed.
" DB server name " 1215, " database-name " 1216 and " table name " 1217 respectively indicate measured value table 144 DB server name, database-name and table name.
This is the information for uniquely identifying the table of the following measurement data of storage, is designed with the measured value table of Figure 13 " the DB server name " 1002 of information 143, " database-name " 1003, " table name " 1004 identical information, wherein the meter Measured data is practical measurement point associated with the minor structure inforamtion tree that utilization " minor structure inforamtion tree ID " 1211 identifies or generation For the measurement data of measurement point.
Wherein, " minor structure inforamtion tree T1 has determined that " as previously described refer to minor structure inforamtion tree be in it is below " the 1st really Determine state " or " the 2nd determines state ".
Also, the minor structure information that will not be complyed with any state in " the 1st determines state " and " the 2nd determines state " Tree is known as " still undetermined minor structure inforamtion tree ".
(the 1st determines state)
Actual size by C minor structure inforamtion tree T1 below, i.e. associated all practical measurement points or replace meter Measuring point and other minor structure inforamtion tree T2 are uncorrelated.
In measurement point management information table 1200, associated all practical measurement points or the root section for replacing measurement point Point ID is only the root node of minor structure inforamtion tree T1.
(the 2nd determines state)
Even being C minor structure inforamtion tree T1 below associated all practical measurement point or generation with actual size For in measurement point, situation associated with other minor structure inforamtion tree T2, reality associated with minor structure inforamtion tree T1, T2 is counted Unique (except repeating) quantity of measuring point is also C or less.
Also related with other minor structure inforamtion tree T2 to the associated practical measurement point N1 of some minor structure inforamtion tree T1 Connection, other practical measurement point N2s associated with minor structure inforamtion tree T2 and situation associated with other minor structure inforamtion tree T3 Under, it measures with any associated all practical measurement points in minor structure inforamtion tree T1, T2, T3 or instead of measurement point Unique quantity, if the quantity be C hereinafter, if be the 2nd to determine state.
Measured value table design portion 121 is first to the measurement point ID1201's of each item record of measurement point management information table 1200 All practical measurement point ID of each setting one.
Then, associated structural information tree is extracted to each practical measurement point ID, the node ID of its root node is set For root node ID1203.
For this purpose, the imagination measurement point that imagination measurement point definition table 141 is searched in measured value table design portion 121 defines 903, it will be with Imagination measurement point including corresponding practical measurement point ID defines corresponding imagination measurement point ID901 and all extracts.
Then, group ID803 associated with imagination measurement point ID is all extracted from structural information table 142.
Finally, extracting the node ID of the root node in the node ID for belonging to the group ID extracted, and it is set as measuring point The root node ID1203 of management information table 1200.
In order to learn that the size of some tree is opened in temporary structure information table from the comparable node of the root node of the tree Begin successively, recursively to count with the quantity for the node that the node ID is father ID.
Also, for the actual size for learning some tree, the root node in measurement point management information table 1200 is counted The number that the root node ID of the tree occurs in ID1203.
Equally, measured value table design portion 121 defines identifier=son for uniquely identifying each structural information tree first Structural information tree ID, and it is set as the minor structure inforamtion tree ID1211 of each item record of minor structure inforamtion tree management table 1210.
As minor structure inforamtion tree ID at this time, the group ID803 of structural information table 142 also can be used.
Structural information tree is divided into subtree by (step S1102) measured value table design portion 121, so that all minor structures are believed The actual size of breath tree is C or less.
As an example of the step, there is following step.
(1) it is more than the son knot of C that measured value table design portion 121 selects an actual size from all minor structure inforamtion trees Structure inforamtion tree T.
(2) selected minor structure inforamtion tree T is divided into root node and with the root node by measured value table design portion 121 Child node be new root node subtree.
Also, measured value table design portion 121 updates measurement point management information table 1200 and minor structure inforamtion tree manages table 1210。
The details of the step is illustrated later.
(3) measured value table design portion 121 executes the operation of (1)~(2) repeatedly, until being more than C there is no actual size Minor structure inforamtion tree until.
(step S1103) measured value table design portion 121 selects size maximum from still undetermined minor structure inforamtion tree Minor structure inforamtion tree T1.
(step S1104) measured value table design portion 121 from the minor structure inforamtion tree T1 phase selected in step S1103 Associated practical measurement point replaces selecting ruler associated by measurement point N1, in other still undetermined minor structure inforamtion trees Very little maximum minor structure inforamtion tree T2.
(step S1105) measured value table design portion 121 is by the quantity of the child node of root node in minor structure inforamtion tree T1, T2 It is compared, selects the more minor structure inforamtion tree T ' of child node.
Also, measured value table design portion 121 using minor structure inforamtion tree T ' be divided into root node R, He Yiqi child node as The minor structure inforamtion tree of new former generation.
Wherein, in the segmentation of the minor structure inforamtion tree T ' selected, it is applicable in the step identical as (2) of step S1102.
In the imagination measurement point definition of the root node R of 121 checking step S1105 of (step S1106) measured value table design portion Whether directly comprising practical measurement point.
That is, measured value table design portion 121 extracts imagination associated with the node ID of root node R from structural information table 142 Measure point ID805.
Also, measured value table design portion 121 measures point from imagination and defines the imagination meter that table 141 extracts imagination measurement point ID Measuring point defines 903, and checks whether directly comprising practical measurement point.
In inspection the result is that (YES) in the case where directly including, processing enter step S1109.
In the case where directly not including (no), processing enters step S1107.
It is the feelings with a practical measurement point definition that " directly comprising practical measurement point ", which refers to that imagination measurement point defines 903, Condition.
The case where imagination measurement point definition 903 is with multiple practical measurement definition, only use imagination measurement definition In the case where situation and combination definition with practical measurement point and imagination measurement point, it is determined as not directly comprising (no).
(step S1107) measured value table design portion 121 redistributes instead of measurement point ID the root node R of step S1105, And it is additional in measurement point management information table 1200.
The additional new record in measurement point management information table 1200 of measured value table design portion 121, will be as " measurement point ID " 1201 and it is newly assigned replace measurement point ID to be set as " this node ID " 1202, and to the setting root section of " root node ID " 1203 The node ID of point R.
" column name " 1204 is set afterwards.
The definition of the measurement data for calculating replacement measurement point is set with to " instead of the definition of measurement point " 1205.
In order to which to " instead of the definition of measurement point " 1205 setting definitions, measured value table design portion 121 is from structural information table 142 Imagination measurement point ID805 extract it is associated with the node ID of the root node R imagination measurement point ID, from imagination measurement define The imagination measurement point of table 141 defines the 903 imagination measurement point definition for extracting imagination measurement point.
In addition, definition is recursively unfolded in measured value table design portion 121, until the imagination measurement point extracted is fixed Until no longer measuring point ID comprising imagination in the definition of justice 903, and expansion result is set to " instead of the definition of measurement point " 1205。
At this point, after deployment " instead of measurement point definition " 1205 it is extremely complex and measure data calculated loads it is higher, Or in the case where cannot calculating according only to the measurement data at identical measurement moment instead of measurement data of measurement point etc., measurement Value table design portion 121 can not also be defined instead of measurement point.
(step S1108) measured value table design portion 121 will replace the information adding of measurement point to measure point in imagination and define table In 141.
In the same manner as the step of measured value table design portion 121 and above-mentioned steps S1107, determining and root node R node ID phase Associated imagination measurement point defines 903, and defines to add in 903 in imagination measurement point and replace measurement to what root node R was distributed Point ID.
(step S1109) measured value table design portion 121 is additional in son using root node R as the minor structure inforamtion tree of size 1 Structural information tree manages in table.
Measured value table design portion 121 generates the record of corresponding root node R, redistributes minor structure inforamtion tree ID, and set For " minor structure inforamtion tree ID " 1211.
Also, the node ID of root node R is set as " root node ID " 1212 by measured value table design portion 121.
In addition, measured value table design portion 121 is again to sub- structural information tree distribution group ID, and it is set as " minor structure letter Xi Shu group ID " 1213.
(step S1110) measured value table design portion 121 checks that minor structure inforamtion tree manages table 1210, and checks whether all Minor structure inforamtion tree have determined that (whether " determine mark " 1214 is established).
(the case where " determining mark " 1214 is established: yes), place in all fixed situations of minor structure inforamtion tree Reason enters step S1111.
In the case where there is still undetermined minor structure inforamtion tree (no), S1103 the processing returns to step.
(step S1111) measured value table design portion 121 sets DB server when all minor structure inforamtion trees have determined that Title 1215, database-name 1216, table name 1217 and column name 1204.
Firstly, measured value table design portion 121 is in minor structure inforamtion tree management table 1210, it is identical " sub to being set The record of structural information tree group ID " 1213 sets identical " DB server name " 1215, " database-name " 1216 and " table Title " 1217.
Measured value table design portion 121 for being set the record of different " minor structure inforamtion tree group ID " 1213, if The different value of either side in fixed at least " DB server name " 1215, " database-name " 1216 and " table name " 1217.
Then, measured value table design portion 121 belongs to identical minor structure inforamtion tree group from the extraction of " root node ID " 1212 Minor structure inforamtion tree root node ID, in " the root node ID " 1203 of measurement point management information table 1200, to being set The measurement point of root node ID distributes unique " column name " 1204.
(step S1112) measured value table design portion 121 is according to measurement point management information table 1200 and minor structure inforamtion tree pipe The information of table 1210 is managed, measured value table design information 143 is updated and measurement point is replaced to define table 143A.
That is, setting is as follows.
" the measurement point ID " 1201 of measurement point management information table 1200
" the measurement point ID " 1001 of → measured value table design information 143
" the DB server name " 1215 of minor structure inforamtion tree management table 1210
" the DB server name " 1002 of → measured value table design information 143
" database-name " 1216 of minor structure inforamtion tree management table 1210
" database-name " 1003 of → measured value table design information 143
" table name " 1217 of minor structure inforamtion tree management table 1210
" table name " 1004 of → measured value table design information 143
" column name " 1204 of measurement point management information table 1200
" column name " 1005 of → measured value table design information 143
Measurement point ID is replaced in " the measurement point ID " 1201 of measurement point management information table 1200
→ replace measuring " instead of the measuring point ID " 1011 that point defines table 143A
" instead of the definition of measurement point " 1205 of measurement point management information table 1200
→ replace measuring " defining instead of measurement point " 1012 that point defines table 143A
Wherein, measured value table design information 143 replace measurement point " data type " 1006, can according to the replacement Associated practical measurement point " data type " 1006 of measurement point is set.
In step S1112, " the measurement point ID " 1001 of measured value table design information 143 and the management of minor structure inforamtion tree " the DB server name " 1215 of table 1210 and/or the corresponding relationship of " database-name " 1216, can be with measurement point management letter Cease table 1200 " root node ID " 1203 and minor structure inforamtion tree management table 1210 " root node ID " 1212 as keyword into Row determines.
In addition, being assigned with " DB server name " 1215, " database-name " 1216, " table name " in step S1111 1217 and " column name " 1204 only set measurement but it is also possible to be, measured value table design portion 121 and puts management information table 1200 " measurement point ID " 1201, " this node ID " 1202, " root node ID " 1203, " instead of the definition of measurement point " 1205 and minor structure " minor structure inforamtion tree ID " 1211, " root node ID " 1212, " the minor structure inforamtion tree group ID " of inforamtion tree management table 1210 1213 and " determine mark " 1214, remaining " DB server name " 1215, " database-name " 1216, " table name " 1217, " column name " 1204 is set by the user.
(step S1113) measured value table design portion 121 is by updated measured value table design information 143 and replaces measurement point Definition table 143A is recorded in data store 140 and terminates.
When the size of minor structure inforamtion tree is bigger, practical measurement point associated there or replace measurement point with it is other The associated probability of minor structure inforamtion tree is higher.
Therefore, in above-mentioned step S1103, S1104, measured value table design portion 121 preferentially selects minor structure inforamtion tree Larger-size tree be split.
It, can not also be according to the size of tree, but using the actual size of tree as base in above-mentioned step S1103, S1104 Quasi- selection minor structure inforamtion tree T.
Alternatively, it is also possible to the minor structure inforamtion tree for selecting the quantity of the child node of root node most.
When the quantity of the child node of root node is more, by the segmentation once to minor structure inforamtion tree, it is divided into more Small minor structure inforamtion tree, it is thus possible to expect to carry out step quantity until all minor structure inforamtion trees have been determined The effect of reduction.
Alternatively, it is also possible to preset the threshold of the size of tree or the quantity of actual size or the child node of root node Value selects the minor structure inforamtion tree found at first in the minor structure inforamtion tree for being more than the threshold value.
Thereby, it is possible to expect the effect of time required for cutting down the candidate search of the minor structure inforamtion tree to be divided.
It, can not also be according to the quantity of the child node of root node, but with the size of tree or tree in step S1105 On the basis of actual size, minor structure inforamtion tree is selected.
Also, the quantity of the child node of root node or the size of tree or the actual size of tree can also be preset Threshold value, be more than the threshold value minor structure inforamtion tree in select the minor structure inforamtion tree found at first.
Figure 19 is the flow chart for showing the process for the processing that the minor structure inforamtion tree of embodiment 1 is divided into subtree.
That is, the details for the step of showing (2) of step S1102.
(step S1301) specifies the minor structure inforamtion tree T to be divided.
(step S1302) measured value table design portion 121 is in temporary structure information table, by the root section of minor structure inforamtion tree T The node ID of point R is that the record of " father ID " 802 all extracts.
These nodes recorded are set as Ri.
Also, " the father ID " 802 recorded accordingly is set as " sky " by measured value table design portion 121.
(step S1303) measured value table design portion 121 extract using the node ID of the root node R of minor structure inforamtion tree T as The record of " the root node ID " 1203 of measurement point management information table 1200, and update root node ID.Meanwhile measured value table designs Portion 121 updates " grade " 804 for all nodes for including in minor structure inforamtion tree T in structural information table 142.
The one of the update step of in step S1303, measurement point management information table 1200 " root node ID " 1203 is shown Example.
Firstly, measured value table design portion 121 selects in the node ID of the record of the node R i extracted in step S1302 Arbitrary node ID.
Also, it is sequentially searched the node ID that measured value table design portion 121 is selected in structural information table 142 since this " grade " 804 recorded accordingly is subtracted 1 by the node ID of large rope node.In addition, measured value table design portion 121 is detecting to count When the node ID for including in " this node ID " 1202 of measuring point management information table 1200, by the measurement point management information table 1200 " the root node ID " of record replaces with original ID, and sets the node ID selected.
The node ID operation repeatedly of measured value table design portion 121 to all records extracted in step S1302.
(step S1304) measured value table design portion 121 will be split by the operation of step S1302~S1303 To minor structure inforamtion tree Ti information adding minor structure inforamtion tree management table 1210 in.
Measured value table design portion 121 generates record corresponding with each minor structure inforamtion tree Ti, redistributes minor structure letter Breath tree ID, and it is set as " minor structure inforamtion tree ID " 1211.
Also, the node ID of the root node Ri of minor structure inforamtion tree Ti is set as " root node by measured value table design portion 121 ID"1212.In addition, measured value table design portion 121 redistributes the group ID of minor structure inforamtion tree, and it is set as " minor structure letter Xi Shu group ID " 1213.
(step S1305) measured value table design portion 121 checks fixed minor structure inforamtion tree, there are fixed sons In the case where structural information tree, " determining mark corresponding with the minor structure inforamtion tree in minor structure inforamtion tree management table 1210 is established Will " 1214.
In identified multiple minor structure inforamtion trees feelings associated with identical practical measurement point or replacement measurement point Under condition, measured value table design portion 121 distributes and sets to " the minor structure inforamtion tree group ID " 1213 of these minor structure inforamtion trees Identical minor structure inforamtion tree group ID.
Even also, determine the minor structure inforamtion tree for belonging to different minor structure inforamtion tree groups when, with this Unique quantity of the associated practical measurement point of a little structural information tree or replacement measurement point is meter in C situation below Measured value table design portion 121 can also reset identical minor structure inforamtion tree group ID.
Another condition (the 3rd determines state) for being determined as having determined that minor structure inforamtion tree in step S1305 is carried out It shows.
Even more than one practical measurement point P situation associated with multiple still undetermined minor structure inforamtion trees Under, by the way that the practical measurement point P is considered as independent measurement point, and different replacement measurement point ID is distributed, also can determine son Structural information tree.
That is, the measurement data of practical measurement point P are stored in multiple measured value tables 144 by measured value table design portion 121.
But in a fairly large number of situation of such practical measurement point P, it will dual, treply repeat to store to be permitted More measurement data, lead to the waste of memory capacity.
Therefore, the quantity of repeatable measurement point is set as threshold value in advance by measured value table design portion 121, with it is multiple still In the case that the quantity of the associated practical measurement point of undetermined minor structure inforamtion tree is no more than the threshold value, in measurement point management Additional record in information table 1200 redistributes instead of measurement point ID practical measurement point P, replacement measurement point ID is set as " measurement point ID " 1201.
Meanwhile original practical measurement point ID is set as the " fixed instead of measurement point of the record by measured value table design portion 121 Justice " 1205.
Also, measured value table design portion 121 directly carries out really minor structure inforamtion tree associated with the practical measurement point P It is fixed.
By to practical measurement point P distribute it is different replace measurement point ID, the associated son of point P can will be measured with reality Structural information tree is considered as independent minor structure inforamtion tree, determines in the determining state of these minor structure inforamtion trees satisfaction the 1st or the 2nd In the case where state, the minor structure inforamtion tree can determine.
In the example shown in Figure 25, subtree data 1101 and practical measurement point 1~6 are associated, subtree data 1102 with Practical measurement point 6~11 is associated.
Practical measurement point 6 is associated with subtree data 1101 and 1102 both sides of subtree data.
In the example of Figure 25, the columns of a measured value table is 8, with 1102 phase of subtree data 1101 and subtree data The quantity of associated practical measurement point is 11, thus is not belonging to the 2nd determining state shown in Figure 24.
In the example of Figure 25, the quantity of practical measurement point associated with multiple subtree datas is less than threshold value, thus It is determined as that subtree data 1101 and subtree data 1102 determine state all in the 3rd.
Also, the measured value table both sides of the measured value table and subtree data 1102 to subtree data 1101 distribute practical measurement Point 6.
The threshold value of the quantity of practical measurement point can be arbitrarily decided by user.
Here, illustrating the action example in measured value table design portion 121 using specific example.
Figure 26 and Figure 28 shows the structural information tree 1131 and structural information tree 1132 used in the following description.
Group ID=1 is set to structural information tree 1131, group ID=2 is set to structural information tree 1132.
In Figure 26 and Figure 28, the node of double outline is the node being directly associated with practical measurement point.
Figure 27 is the structural information table (the structural information table 142 for being equivalent to Figure 10) of the structural information tree 1131 of Figure 26, figure 29 be the structural information table of the structural information tree 1132 of Figure 28.
Structural information tree 1131 and structural information tree 1132 are associated with practical measurement point $ 1~$ 15 as shown in figure 30.
Figure 31 is that the imagination measurement point definition table of structural information tree 1131 (is equivalent to the imagination measurement point definition table of Figure 12 141), Figure 32 is the imagination measurement point definition table of structural information tree 1132.
Figure 33 is the temporary structure information table of structural information tree 1131, and Figure 34 is the temporary structure letter of structural information tree 1132 Cease table.
Figure 35 is that the measurement point management information table of structural information tree 1131 and structural information tree 1132 (is equivalent to the meter of Figure 17 Measuring point management information table 1200).
Figure 36 be measured value table design portion 121 start to carry out structural information tree 1131 and structural information tree 1132 segmentation it Preceding minor structure information tree table (the minor structure inforamtion tree management table 1210 for being equivalent to Figure 18).
It is assumed below that actual size C=8, can be stored in measured value table 144 measured value practical measurement point (meter Measurement equipment) quantity be 8.
As shown in the S1102 of Figure 15, measured value table design portion 121 so that each subtree actual size C=8 side below Formula segmenting structure inforamtion tree 1131 and structural information tree 1132.
Specifically, measured value table design portion 121 for example selects structural information tree 1131 (S1301 of Figure 19), root is extracted Child node, that is, the node " A02 " and " A03 " (S1302) of node " A01 ".
Also, measured value table design portion 121 is by the node of the temporary structure information table (Figure 33) of structural information tree 1131 " grade " of " A02 "~" A39 " subtracts 1 (S1303).
As a result, the temporary structure information table of structural information tree 1131 is updated as shown in figure 37.
Also, measured value table design portion 121 describes the column root node ID in measurement point management information table (Figure 35) The root node ID of the record of " 1 " (ID of root node " A01 ") updates (S1303).
As a result, measurement point management information table is updated as shown in figure 38.
Then, measured value table design portion 121 will be with the information for the subtree that node " A02 " is root node and with node " A03 " It is additional in minor structure information tree table (Figure 36) (S1304) for the information of the subtree of root node.
In addition, at the moment, with subtree that node " A02 " is root node and with node " A03 " be the subtree of root node all Do not determine.
It is practical measurement point 1~7 with the practical measurement point being directly associated with the subtree that node " A02 " is root node, because Although and actual size is 7, and it is also associated with structural information tree 1132 actually to measure point 1~7.
Therefore, the 1st is not at the subtree that node " A02 " is root node determine state.
Structural information tree 1132 is not divided at the moment, thus measures 1~7 associated structural information tree of point with practical 1132 is also associated with practical measurement point 8~15, thus determines state not also in the 2nd.
Also, structural information tree 1132 determines state not also in the 3rd.
It is practical measurement point 8~14 with the practical measurement point being directly associated with the subtree that node " A03 " is root node, because Although and actual size is 7, and it is also associated with structural information tree 1132 actually to measure point 8~14.
Therefore, the 1st is not at the subtree that node " A03 " is root node determine state.
Structural information tree 1132 is not divided at the moment, thus measures 8~14 associated structural informations of point with practical Tree 1132 is also associated with practical measurement point 1~7 and 15, thus determines state not also in the 2nd.
Also, structural information tree 1132 determines state not also in the 3rd.
Therefore, minor structure information tree table is updated as shown in figure 39.
In the minor structure information tree table of Figure 39, in the subtree being only made of root node " A01 ", determine that mark is " 1 ", But in subtree in addition to this, determine that mark is " 0 ".
Then, measured value table design portion 121 selects structural information tree 1132 (S1301 of Figure 19), and extracts root node Child node, that is, the node " B11 " of " B01 "~" B13 " (S1302).
Also, measured value table design portion 121 is by the node of the temporary structure information table (Figure 34) of structural information tree 1132 " grade " of " B11 "~" B44 " subtracts 1 (S1303).
As a result, the temporary structure information table of structural information tree 1132 is updated as shown in figure 40.
Also, measured value table design portion 121 describes the column root node ID in measurement point management information table (Figure 38) The root node ID of the record of " 101 " (ID of root node " B01 ") updates (S1303).
As a result, measurement point management information table is updated as shown in figure 41.
Then, measured value table design portion 121 will be with the information for the subtree that node " B11 " is root node and with node " B12 " It is additional in minor structure information tree table for the information of the subtree of root node and with the information for the subtree that node " B13 " is root node In (Figure 39) (S1304).
In addition, all subtrees determine at the moment.
With by subtree that node " A02 " is root node and by node " B11 " be the subtree of root node it is associated it is practical in terms of Unique quantity of measuring point is 7, thus is the son of root node with subtree that node " A02 " is root node and with node " B11 " Pterostyrax determines state in the 2nd.
It is with subtree that node " A03 " is root node and with subtree that node " B12 " is root node and with node " B13 " Unique quantity of the associated practical measurement point of the subtree of root node is 8, thus take node " A03 " as the subtree of root node And with subtree that node " B12 " is root node and belongs to the 2nd with the subtree that node " B13 " is root node and determine state.
Therefore, minor structure information tree table is updated as shown in figure 42.
In the minor structure information tree table of Figure 42, determine that mark is " 1 " in all subtrees.
Then, measured value table design portion 121 updates the column " minor structure inforamtion tree group ID " of minor structure information tree table.
Specifically, measured value table design portion 121 updates the column of " minor structure inforamtion tree group ID " as shown in figure 43.
Then, measured value table design portion 121 carries out S1103~S1105 of Figure 15, but in this example, due to all sons Tree it has been determined that thus omit S1103~S1105 processing.
Whether measured value table design portion 121 determines in the imagination measurement point definition of root node directly comprising practical measurement point (S1106)。
Referring to Figure 31 and Figure 32 imagination measurement point define a table, " A01 ", A02 as root node ", " A03 ", " B01 ", B11 ", " B12 ", " B13 " are measured in point definition in imagination not directly comprising practical measurement point (S1106: no).
Therefore, measured value table design portion 121 is for each " A01 ", A02 ", " A03 ", " B01 ", B11 ", " B12 ", " B13 " will replace the information adding of measurement point to measure point in imagination and define in table (S1108).
Also, in this example, the information of all subtrees is already registered in minor structure inforamtion tree management table, thus The processing of S1109 is omitted.
Also, since all subtrees have determined that (S1110: yes), thus the progress of measured value table design portion 121 S1111~ The processing of S1113.
As the processing that the processing of S1111~S1113 illustrates with referring to Fig.1 6, thus in this description will be omitted.
In the S1113 stage that processing terminate, imagination measurement point definition table is updated as shown in Figure 45 and Figure 46, measures point Management information table is updated as shown in figure 47.
It is defined in table in the imagination measurement point of Figure 45, it is additional in the imagination measurement point definition of imagination measurement point ID:#1 It is " 1 " instead of measurement point mark instead of measuring point " %1 ".
Also, it adds in the imagination measurement point definition of imagination measurement point ID:#2, #3 instead of measurement point " %2 ", " % 3 ", it is " 1 " instead of measurement point mark.
Equally, it is defined in table in the imagination measurement point of Figure 46, also measures point ID:#101, #111, #112, #113 in imagination Imagination measurement point definition in added instead of measurement point " %4 ", " %5 ", " %6 ", " %7 ", instead of measurement point a mark be “1”。
Also, it is defined in table in the imagination measurement point of Figure 47, has added the record of measurement point ID:%1~%7.
Measurement point definition is replaced for example to export according to step shown in Figure 48 in measurement point management information table.
Figure 48 shows the deriving step for replacing point measurement point of %1.
As shown in figure 45, the imagination measurement point for replacing point measurement to correspond to #1 of %1, according to imagination measurement definition, # 1=#2+#3, #2=#11+#12+#13, #3=#14+#15+#16.
Therefore, the measurement point that replaces of %1 is #1=(#11+#12+#13)+(#14+#15+#16).
After, point definition similarly is measured according to imagination each imagination measurement point is unfolded, and obtains the most footline such as Figure 48 Shown such replacement measurement point definition.
More than, measurement data administrator as shown below is illustrated in the present embodiment.
(a) measurement data administrator has the measurement of the input of the multiple measurement data measured by reason Measuring Device The storage device of data collection accumulation unit and storage measurement data, the measurement data inputted are stored in storage device In any measured value table of multiple measured value tables of definition.
(b) Measuring Device is associated with the structural information with multilayer (tree constructs).
(c) measurement data administrator has for calculating imagination measurement point according to the hierarchical relational of above-mentioned structural information Measurement data imagination measurement point definition, and have it is fixed according to the measurement data that are stored in measured value table and imagination measurement point Justice measures the measurement data of point and the measurement data output section of output to calculate imagination.
(d) measurement data administrator, which has, measures point definition for structural information minute according to above-mentioned structural information and imagination It is cut into the measured value table design portion of subtree.
(e) measured value table design portion by measurement data associated with one or more subtree of structural information and counts Measured value table associates, which is recorded as measured value table design information.
(f) measurement data administrator has the meter for defining multiple tables in storage device according to measured value table design information Measured value table defines portion.
(g) measurement data collection accumulation unit determines storage according to the identifier and measured value table design information of measurement data The measured value table of the measurement data.
Also, following measured value table design portion is illustrated in the present embodiment: so that the subtree phase with structural information The number of species of associated measurement data are in the specification limit of data base management system used in the storage of measurement data Mode, structural information is recursively divided into subtree.
Also, following measured value table design portion is illustrated in the present embodiment: in one or more measurement data In situation associated with multiple structural informations, the arbitrary structural information in the associated structural information is selected, and repeatedly Ground Split is at subtree, until the quantity of measurement data associated with one or more subtree is in above-mentioned specification limit Until.
Also, measured value table design portion as follows is illustrated in the present embodiment.
(a) segmentation of the structural information to subtree is to be divided into the root node of tree construction and be with the child node of the root node The subtree of new root.
(b) identifier instead of measurement point is redistributed to original root node, by the identifier and is used to calculate and be somebody's turn to do The calculating formula of the measurement data of the comparable imagination measurement point of root node is stored in measured value table design information.
Also, following measured value table design portion is illustrated in the present embodiment: in one or more measurement data In situation associated with the subtree of multiple structural informations, multiple identifiers for replacing measurement point are distributed to the measurement data, it will The identifier or calculating formula of the identifier and the Measuring Device for obtaining original measurement data are stored in measured value table and set It counts in information.
Finally, the hardware configuration example of the measurement data administrator 100 referring to shown in illustrating in present embodiment Figure 44.
Measuring data administrator 100 is computer, and each of measurement data administrator 100 can be realized using program Element.
As the hardware configuration of measurement data administrator 100, arithmetic unit 1901, external memory 1902, main memory Storage device 1903, communication device 1904 and input/output unit 1905 are connect with bus.
Arithmetic unit 1901 is the CPU (Central Processing Unit: central processing unit) for executing program.
External memory 1902 is, for example, ROM (Read Only Memory: read-only memory) or flash memory, hard disk dress It sets.
Main storage means 1903 are RAM (Random Access Memory: random access storage device).
Communication device 1904 is, for example, NIC (Network Interface Card: network interface card).
Input/output unit 1905 is, for example, mouse, keyboard, display equipment etc..
Program is generally stored inside in external memory 1902, be loaded in main storage means 1903 state successively by It is read into arithmetic unit 1901 and executes.
Program is to realize the function of illustrating as "~portion " shown in FIG. 1 (except data store, same as below).
In addition, be also stored with operating system (OS) in external memory 1902, at least part of OS be loaded in In main storage means 1903, arithmetic unit 1901 executes OS, and executes the journey of the function for realizing "~portion " shown in FIG. 1 Sequence.
Also, in description of the present embodiment, will indicate as "~judgement ", "~determine ", "~extract ", "~point Cut ", "~detection ", "~setting ", "~register ", "~selection ", "~generation ", "~it is additional ", "~update ", "~input ", "~output " etc. and the information of the result of processing and/or data and/or signal value and/or variate-value illustrated, are deposited as file Storage is in main storage means 1903.
Also, it can also be stored as a file in main memory by encryption key/decruption key and/or random number and/or parameter In storage device 1903.
In addition, the structure of Figure 44 is to show an example of the hardware configuration of measurement data administrator 100, data pipe is measured The hardware configuration of reason device 100 is not limited to structure shown in Figure 44, is also possible to other structures.
In addition, the step shown according to the present embodiment, can be realized data processing method of the invention.
Label declaration
100 measurement data administrators;110 imagination measurement point management departments;111 imagination measurement point information input output sections; 112 structural information input and output portions;120 measured value table management departments;121 measured value table design portions;122 measured value tables define portion; 130 measurement Data Management Departments;131 measurement data collection accumulation units;132 imagination measurement data operation portions;133 measurement data outputs Portion;140 data stores;141 imagination measurement points define table;142 structural information tables;143 measured value table design informations;144 meters Measured value table;200 measurement data management systems;201 Measuring Devices;210 strong point devices;211 measurement data reception portions;212 measurements Data sending part;219 strong point device storage units;220 operating terminals;221 application enforcement divisions;229 operating terminal storage units;400 Measure data;1200 measurement point management information tables;1210 minor structure inforamtion trees manage table.

Claims (9)

1. a kind of data processing equipment manages tree construction data associated with Measuring Device, which is characterized in that at the data Reason device includes
The tree construction data are divided into multiple subtree datas by data cutting part, so that associated with each subtree data Measuring Device quantity be table store number of devices below, wherein the table store number of devices be that measured value can be stored in measurement It is worth the upper limit number of the Measuring Device in table;
Condition adjudgement portion, judges whether subtree data obtained from being divided as the data cutting part is in determining state;With And
Table dispenser, to by the condition adjudgement portion be judged as in determine state subtree data, distribution to come from and this The measured value table that the measured value of the associated Measuring Device of subtree data is stored,
It is all unrelated to the associated Measuring Device of a subtree data and other any subtree datas and with a son The quantity for setting the associated Measuring Device of data is that the table stores in number of devices situation below, the condition adjudgement portion judgement The 1st, which is in, for a subtree data determines state,
At least one Measuring Device in Measuring Device associated with a subtree data repeatedly with other subtree datas Also it is associated and by the quantity of Measuring Device associated with a subtree data and associated with other subtree datas Total number after the repeating part removal of the quantity of Measuring Device is that the table stores in number of devices situation below, the state Judging part is judged as that a subtree data and other subtree datas are in the 2nd and determine state,
The condition adjudgement portion makes the data cutting part that will be judged as being not in the 1st determining state and the 2nd determining state The subtree data of free position be further divided into multiple subtree datas.
2. data processing equipment according to claim 1, which is characterized in that
At least one Measuring Device in Measuring Device associated with a subtree data repeatedly with other subtree datas Also it is associated and by the quantity of Measuring Device associated with a subtree data and associated with other subtree datas The quantity of Measuring Device repeating part removal after total number be more than the table storage number of devices and with a subtree data And other subtree datas repeatedly associated Measuring Device quantity be stated number situation below under, to a son Repeatedly associated Measuring Device distributes different replacement measurement point ID for tree data and other subtree datas, will count with replacement The associated subtree data of measuring point is considered as independent subtree data, when can judge these independent subtree datas be in the 1st really When determining state or the 2nd determining state, the condition adjudgement portion is judged as at a subtree data and other subtree datas State is determined in the 3rd,
The condition adjudgement portion makes the data cutting part that will be judged as being not at the 1st to determine that state, the 2nd determine state and the 3 determine that the subtree data of the free position in state is further divided into multiple subtree datas.
3. data processing equipment according to claim 1, which is characterized in that
The data processing equipment management includes the tree construction data of multiple nodes,
The data cutting part is partitioned into the only subtree data of root node and with the child node of the root node respectively for new root More than two subtree datas of node, as the multiple subtree data,
The condition adjudgement portion makes the data cutting part that will be not in determining state in addition to the only subtree data of root node Subtree data be further divided into multiple subtree datas, until all subtrees in addition to the only subtree data of root node Until data are in the state of determination.
4. data processing equipment according to claim 3, which is characterized in that
The data processing equipment manages following tree construction data, comprising as the accumulative of measured value in the tree construction data Unit multiple nodes, and to each node definition for adding up the calculating formula of measured value, in the calculating formula comprising with The identifier that the measured value of Measuring Device is directly associated is i.e. practical to be measured point and measures point directly or indirectly phase with practical Associated identifier is at least any one party in imagination measurement point,
The data processing equipment also judges the calculating of the root node of subtree data obtained from being divided as the data cutting part Whether the measurement point for including in formula is only practical measurement point one,
The data processing equipment also has instead of measurement point configuration part, the measurement point for including in the calculating formula of the root node In the case where not being merely practical measurement point one, make to replace measurement point associated with the root node, replacement measurement point is Indicate the identifier for needing to carry out the calculating for adding up measured value in advance before having accumulative instruction.
5. data processing equipment according to claim 4, which is characterized in that
It is described replace measurement point configuration part in the calculating formula of the root node comprising imagination measurement point in the case where, using with this An imagination measurement point directly or indirectly associated practical measurement point, generate only comprising practical measurement point and can obtain with it is described The replacement calculating formula of the identical calculated result of the calculating formula of root node,
It is described to replace measurement point configuration part that the replacement calculating formula is made to replace measurement point associated with described.
6. data processing equipment according to claim 4, which is characterized in that
The data processing equipment also has instead of measurement point calculation part, this replaces measurement point calculation part for replacing counting with described The associated root node of measuring point is carried out by adding up based on measured value in advance before having the accumulative instruction for the root node It calculates, calculated result is made to replace measurement point associated with described.
7. data processing equipment according to claim 1, which is characterized in that
The table dispenser is judged as the subtree data distribution for determining state in the described 1st to by the condition adjudgement portion One measured value table,
The table dispenser is judged as the multiple subtree datas distribution for determining state in the described 2nd to by the condition adjudgement portion One measured value table.
8. data processing equipment according to claim 2, which is characterized in that
The table dispenser is judged as the multiple subtree datas difference for determining state in the described 3rd to by the condition adjudgement portion A measured value table is distributed,
The table dispenser will be from being stored in the measured value of the multiple subtree data repeatedly associated Measuring Device In the measured value table of each subtree data.
9. a kind of data processing method, the computer by managing tree construction data associated with Measuring Device is executed, feature It is, which includes:
The tree construction data are divided into multiple subtree datas, so that with each by the computer implemented data dividing processing The quantity of the associated Measuring Device of subtree data is that table stores number of devices or less, wherein it is measured value that the table, which stores number of devices, The upper limit number of the Measuring Device in measured value table can be stored in;
The computer executes state judgement processing, and subtree data obtained from judgement is divided as the data dividing processing is It is no to be in the state of determination;And
The computer executes table allocation processing, is judged as the subtree in the state of determination to by state judgement processing Data distribute the measured value table stored to the measured value from Measuring Device associated with the subtree data,
In state judgement processing,
It is all unrelated to the associated Measuring Device of a subtree data and other any subtree datas and with a son The quantity for setting the associated Measuring Device of data is that the table stores in number of devices situation below, and the computer is judged as this One subtree data is in the 1st and determines state,
At least one Measuring Device in Measuring Device associated with a subtree data repeatedly with other subtree datas Also it is associated and by the quantity of Measuring Device associated with a subtree data and associated with other subtree datas Total number after the repeating part removal of the quantity of Measuring Device is that the table stores in number of devices situation below, the calculating Machine is judged as that a subtree data and other subtree datas are in the 2nd and determine state,
In the data dividing processing,
The computer will be judged as being not in the 1st determining state and the 2nd determining state in state judgement processing The subtree data of free position be further divided into multiple subtree datas.
CN201480046468.2A 2013-08-28 2014-08-26 Data processing equipment and data processing method Active CN105493050B (en)

Applications Claiming Priority (3)

Application Number Priority Date Filing Date Title
JP2013176173 2013-08-28
JP2013-176173 2013-08-28
PCT/JP2014/072234 WO2015029969A1 (en) 2013-08-28 2014-08-26 Data processing device, and data processing method and program

Publications (2)

Publication Number Publication Date
CN105493050A CN105493050A (en) 2016-04-13
CN105493050B true CN105493050B (en) 2019-03-12

Family

ID=52586526

Family Applications (1)

Application Number Title Priority Date Filing Date
CN201480046468.2A Active CN105493050B (en) 2013-08-28 2014-08-26 Data processing equipment and data processing method

Country Status (4)

Country Link
JP (1) JP5972472B2 (en)
CN (1) CN105493050B (en)
SG (1) SG11201600589RA (en)
WO (1) WO2015029969A1 (en)

Families Citing this family (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
JP6419234B2 (en) 2017-02-28 2018-11-07 株式会社テクロック Measurement solution service provision system
JP6793881B1 (en) * 2019-02-14 2020-12-02 三菱電機株式会社 Management equipment, management system, management method and program
JP6583871B2 (en) * 2019-02-28 2019-10-02 株式会社テクロック・スマートソリューションズ Measurement solution service provision system
JP6570210B2 (en) * 2019-02-28 2019-09-04 株式会社テクロック・スマートソリューションズ Measurement solution service provision system

Citations (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN102597966A (en) * 2009-11-04 2012-07-18 富士通株式会社 Operation management device and operation management method

Family Cites Families (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US5230047A (en) * 1990-04-16 1993-07-20 International Business Machines Corporation Method for balancing of distributed tree file structures in parallel computing systems to enable recovery after a failure
US7120637B2 (en) * 2003-05-30 2006-10-10 Microsoft Corporation Positional access using a b-tree
JP5574993B2 (en) * 2011-01-13 2014-08-20 三菱電機株式会社 Control computer, information processing system, control method, and program
JP5863494B2 (en) * 2012-02-13 2016-02-16 キヤノン株式会社 Information processing apparatus, control method therefor, and program

Patent Citations (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN102597966A (en) * 2009-11-04 2012-07-18 富士通株式会社 Operation management device and operation management method

Also Published As

Publication number Publication date
CN105493050A (en) 2016-04-13
JP5972472B2 (en) 2016-08-17
SG11201600589RA (en) 2016-03-30
JPWO2015029969A1 (en) 2017-03-02
WO2015029969A1 (en) 2015-03-05

Similar Documents

Publication Publication Date Title
CN105069703B (en) A kind of electrical network mass data management method
US11895515B2 (en) Systems and methods for communications node upgrade and selection
CN104756106B (en) Data source in characterize data storage system
CN102915347B (en) A kind of distributed traffic clustering method and system
WO2023115842A1 (en) Data-driven offline and online integrated simulation system and method for power distribution network
CN103970863B (en) The method for digging and system of microblog users interest based on LDA topic models
CN105493050B (en) Data processing equipment and data processing method
CN104866426A (en) Software test integrated control method and system
CN107730394A (en) The polynary isomeric data fusion method of panorama power network based on big data
CN101599070A (en) Utilize the spatial database synthesis method in the information multi-scale expression in the soil
CN103902816A (en) Electrification detection data processing method based on data mining technology
CN106534291A (en) Voltage monitoring method based on big data processing
US11456932B2 (en) System capacity heatmap
CN104158748B (en) A kind of topological detecting method towards system for cloud computing
CN104112084B (en) Execution-based license discovery and optimization method and device
JP2011034457A (en) Data mining system, data mining method and data mining program
JP2013156960A (en) Generation program, generation method, and generation system
Shaheen et al. Mining sustainability indicators to classify hydrocarbon development
CN114398669A (en) Joint credit scoring method and device based on privacy protection calculation and cross-organization
JP6242540B1 (en) Data conversion system and data conversion method
CN112631889B (en) Portrayal method, device, equipment and readable storage medium for application system
US11157267B1 (en) Evaluation of dynamic relationships between application components
CN102222038A (en) Transaction software test method and system based on banking business
US11328024B2 (en) Data analysis device and data analysis method
CN108123920B (en) Method for detecting malicious users in neighborhood network of smart power grid based on suspected electricity stealing degree

Legal Events

Date Code Title Description
C06 Publication
PB01 Publication
C10 Entry into substantive examination
SE01 Entry into force of request for substantive examination
GR01 Patent grant
GR01 Patent grant