CN105493050A - Data processing device, and data processing method and program - Google Patents

Data processing device, and data processing method and program Download PDF

Info

Publication number
CN105493050A
CN105493050A CN201480046468.2A CN201480046468A CN105493050A CN 105493050 A CN105493050 A CN 105493050A CN 201480046468 A CN201480046468 A CN 201480046468A CN 105493050 A CN105493050 A CN 105493050A
Authority
CN
China
Prior art keywords
data
measurement
subtree
measuring device
measurement point
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.)
Granted
Application number
CN201480046468.2A
Other languages
Chinese (zh)
Other versions
CN105493050B (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

Landscapes

  • Engineering & Computer Science (AREA)
  • Theoretical Computer Science (AREA)
  • Computational Linguistics (AREA)
  • Data Mining & Analysis (AREA)
  • Databases & Information Systems (AREA)
  • Physics & Mathematics (AREA)
  • General Engineering & Computer Science (AREA)
  • General Physics & Mathematics (AREA)
  • Data Exchanges In Wide-Area Networks (AREA)
  • Testing Or Calibration Of Command Recording Devices (AREA)

Abstract

A measured value table design unit (121) which: divides tree structure data into a plurality of subtrees in a manner such that the number of measuring instruments associated with each subtree is equal to or less than a number of table storage instruments, which is the upper limit number of measuring instruments that can store measured values in a measured value table; determines whether the divided subtrees are in an established state; and allocates measured value tables to the subtrees that are in an established state, said measured value tables storing the measured values from the measuring instruments associated with the subtrees. The subtrees that are not in an established state are further divided into a plurality of subtrees.

Description

Data processing equipment, data processing method and program
Technical field
The present invention relates to the technology of the measurement result of management Measuring Device (also referred to as sensor).
Background technology
Disclose following method: in the measurement data administrator measurement data measured by Measuring Device added up from various viewpoints such as the configuration of Measuring Device, affiliated or purposes, relative to the actual actual measurement point being provided with Measuring Device, set up reality that imagination measurement point (such as, patent documentation 1) of Measuring Device is not set.
Actual measurement point is corresponding with the measurement data measured by esse Measuring Device, imagination measurement point and use reality measure measurement data sum a little or the virtual measurement data passing through to pro rata distribute etc. to calculate corresponding.
In addition, also disclose following method: distinguish according to the management of time through unit, buildings unit, place unit, measurement classification unit, purposes unit etc., the measurement data of the actual measurement point of pro-rata, obtain the measurement data (such as, patent documentation 2) of imagination measurement point thus.
At first technical literature
Patent documentation
Patent documentation 1: Jap.P. No. 4640212 publication
Patent documentation 2: Japanese Unexamined Patent Publication 2006-185318 publication
Summary of the invention
The problem that invention will solve
There is following characteristic in measurement data: along with the time through and continue the measurement data measured the at the same time often close association each other that arrives.
Therefore, when measurement data being stored in the table of database, make each measurement value corresponding with each row of table, the measurement value in same measurement moment being gathered is that a record stores, and uses more convenient like this.
On the other hand, be subject to the lower degradation technical background impact of the high performance/low price of Measuring Device in recent years, the increasing expansion of the network bandwidth, the cost of memory of per unit capacity, measurement data can be collected from more Measuring Device with the shorter collection cycle, and carry out accumulating/preserving.
Further, from measurement data user, utilize these measurement data demands also growth.
Such as, exist to collect and analyze power consumption and decide the strategy of raising strategy of Saving Energy effect and to collect and the status data analyzing machinery/equipment the demand such as to save from damage with the prevention prevented trouble before it happens to the fault of machinery/equipment.
Based on background as above, the measurement data managed by a system of measurement data administrator are in increase.
In common data base management system (DBMS), the columns that each table can define is maximum is about 1000.
Therefore, when manage produce from Measuring Device, kind considerably beyond the measurement data of the columns upper limit, need contingency table in a column direction, measurement data scatter be stored in multiple table.
Will measure data scatter in multiple table time, when carry out at the utilization imagination measurement point as above-mentioned prior art accumulative and/or utilize multiple measurement data analysis, produce the situation reading measurement data from multiple table.
Therefore, with from one show to read measure data situation compared with, exist accumulative/analyze required for the problem that increases of time.
Substantially along with the quantity of the table reading measurement data increases, this time also increases.
Further, when reading measurement data from multiple table, also there is the situation needing to carry out the subsequent treatment such as the accumulative process added at the application side of user, the research and development burden that also there is application becomes large problem.
The present invention will solve problem as above as fundamental purpose, its fundamental purpose is, when Measuring Device increasing number and be dispersed in multiple table store measurement value, determine the table of the storage location as measurement value in the mode that can carry out efficiently adding up and analyzing.
For the means of dealing with problems
Data processing equipment of the present invention manages the tree construction data be associated with Measuring Device, it is characterized in that, this data processing equipment has: Data Segmentation portion, described tree construction Data Segmentation is become multiple subtree data by it, make the quantity of the Measuring Device be associated with each subtree data for show below memory device number, wherein, this table memory device number is the upper limit number that measurement value can be stored in the Measuring Device in measurement value table; Condition adjudgement portion, whether its subtree data judging to be split by described Data Segmentation portion and obtain is in is determined state; and table dispenser, it is judged as being in by described condition adjudgement portion the subtree data determining state, the measurement value table stored is carried out in point pairing from the measurement value of the Measuring Device be associated with this subtree data, the Measuring Device be associated with a subtree data and other any subtree data all unconnected, and the quantity of the Measuring Device be associated with this subtree data is when being below described table memory device number, described condition adjudgement portion is judged as that this subtree data is in the 1st and determines state, at least one Measuring Device in the Measuring Device be associated with a subtree data is repeatedly also associated with other subtree data, and the total number after the quantity of the Measuring Device be associated with this subtree data and the repeating part of the quantity of Measuring Device that is associated with this other subtree data being removed is when being below described table memory device number, described condition adjudgement portion is judged as that this subtree data and this other subtree data are in the 2nd and determine state, described condition adjudgement portion makes described Data Segmentation portion not be in the 1st determine that state and the 2nd determines that the subtree data of the free position in state is divided into multiple subtree data further by being judged as.
Invention effect
According to the present invention, judge whether subtree data is in the segmentation that the 1st determines to carry out while state or the 2nd determines state subtree data, thus can make to correspond to same measurement value table as much as possible for measurement value that is accumulative and that analyze simultaneously, can carry out efficiently adding up and analyzing.
Accompanying drawing explanation
Fig. 1 is the figure of the structure example of the measurement data administrator that embodiment 1 is shown.
Fig. 2 is the figure of the structure example of the measurement data management system that embodiment 1 is shown.
Fig. 3 is the figure of the structure example of the measurement data management system that embodiment 1 is shown.
Fig. 4 is the figure of the form example of the measurement data that embodiment 1 is shown.
Fig. 5 is the figure of the example of the measurement value table that embodiment 1 is shown.
Fig. 6 is the figure of the example of the structural information that embodiment 1 is shown.
Fig. 7 is the figure of the example of the structural information that embodiment 1 is shown.
Fig. 8 is the figure of the example of the structural information that embodiment 1 is shown.
Fig. 9 illustrates the structural information tree of embodiment 1, imaginary measurement dot information, the actual figure measuring the relation of point and measurement value table.
Figure 10 is the figure of the example of the structural information table that embodiment 1 is shown.
Figure 11 is the figure that the group name table of embodiment 1 and the example of grade name table are shown.
Figure 12 is the figure of the example of the imagination measurement point definition list that embodiment 1 is shown.
Figure 13 is the figure of the example of the measurement value table design information that embodiment 1 is shown.
Figure 14 is the figure of the example of the replacement measurement point definition list that embodiment 1 is shown.
Figure 15 is the process flow diagram of the generation step of the measurement value table design information that embodiment 1 is shown.
Figure 16 is the process flow diagram of the generation step of the measurement value table design information that embodiment 1 is shown.
Figure 17 is the figure of the example of the measurement point management information table that embodiment 1 is shown.
Figure 18 is the figure of the example of the minor structure inforamtion tree admin table that embodiment 1 is shown.
Figure 19 is the process flow diagram that the minor structure inforamtion tree illustrating embodiment 1 is divided into the step of subtree.
Figure 20 is the figure of the utilization preparatory stage of the measurement data administrator that embodiment 1 is shown.
Figure 21 is collection and the figure in accumulation stage of the measurement data of the measurement data administrator that embodiment 1 is shown.
Figure 22 is reading and the figure in accumulative stage of the measurement data of the measurement data administrator that embodiment 1 is shown.
Figure 23 illustrates the 1st of embodiment 1 the figure determining the example of state.
Figure 24 illustrates the 2nd of embodiment 1 the figure determining the example of state.
Figure 25 illustrates the 3rd of embodiment 1 the figure determining the example of state.
Figure 26 is the figure of the example of the structural information tree that embodiment 1 is shown.
Figure 27 is the figure of the example of the structural information table that embodiment 1 is shown.
Figure 28 is the figure of the example of the structural information tree that embodiment 1 is shown.
Figure 29 is the figure of the example of the structural information table that embodiment 1 is shown.
Figure 30 is the figure of the relation illustrated between the structural information tree of embodiment 1 and actual measurement point.
Figure 31 is the figure of the example of the imagination measurement point definition list that embodiment 1 is shown.
Figure 32 is the figure of the example of the imagination measurement point definition list that embodiment 1 is shown.
Figure 33 is the figure of the example of the temporary structure information table that embodiment 1 is shown.
Figure 34 is the figure of the example of the temporary structure information table that embodiment 1 is shown.
Figure 35 is the figure of the example of the measurement point management information table that embodiment 1 is shown.
Figure 36 is the figure of the example of the minor structure information tree table that embodiment 1 is shown.
Figure 37 is the figure of the renewal example of the temporary structure information table that embodiment 1 is shown.
Figure 38 is the figure of the renewal example of the measurement point management information table that embodiment 1 is shown.
Figure 39 is the figure of the renewal example of the minor structure information tree table that embodiment 1 is shown.
Figure 40 is the figure of the renewal example of the temporary structure information table that embodiment 1 is shown.
Figure 41 is the figure of the renewal example of the measurement point management information table that embodiment 1 is shown.
Figure 42 is the figure of the renewal example of the minor structure information tree table that embodiment 1 is shown.
Figure 43 is the figure of the renewal example of the minor structure information tree table that embodiment 1 is shown.
Figure 44 is the figure of the hardware configuration example of the measurement data administrator that embodiment 1 is shown.
Figure 45 is the figure of the renewal example of the imagination measurement point definition list that embodiment 1 is shown.
Figure 46 is the figure of the renewal example of the imagination measurement point definition list that embodiment 1 is shown.
Figure 47 is the figure of the renewal example of the measurement point management information table that embodiment 1 is shown.
Figure 48 is the figure of the derivation step of the replacement point measurement point definition that embodiment 1 is shown.
Embodiment
Embodiment 1
The measurement data administrator be described as follows in the present embodiment: when maximum number of column far away more than one of data base management system (DBMS) table of the kind of the quantity of Measuring Device, measurement data, make to correspond to same table as much as possible for measurement value that is accumulative and that analyze simultaneously, the increase of execution time when can suppress execution time when performing accumulative and execution analysis thus, cuts down the application research and development burden of user.
The measurement data administrator 100 of present embodiment has the structure illustrated in Fig. 1.
In addition, about the inscape details separately of the measurement data administrator 100 shown in Fig. 1, be described later.
Measurement data administrator 100 is equivalent to the example of data processing equipment.
Further, as shown in Figure 2 and Figure 3, the measurement data administrator 100 of present embodiment forms with Measuring Device 201, strong point device 210 and measures data management system 200 together with operating terminal 220.
In addition, about the details of the Measuring Device 201 shown in Fig. 2, Fig. 3, strong point device 210, operating terminal 220, be described later.
Before the structure of measurement data administrator 100 that present embodiment is described and the details of action, first the summary of the action of measurement data administrator is described.
The action of measurement data administrator 100 is divided into following three processes.
(1) preparation is used
(2) collection and the accumulation of data is measured
(3) measure the reading of data and add up
(1) preparation is used
In the utilization preparatory stage, before the collection of sensing data and accumulation, reading and accumulative etc. practice start, as preparation, perform following process (Figure 20).
User uses imagination measurement dot information input and output portion 111, sets imagination measurement point definition list 141 (S11) to measurement data administrator 100.
User uses structural information input and output portion 112, to measurement data administrator 100 setting structure information table 142 (S12).
Measurement value table design portion 121, according to imagination measurement point definition list 141 and structural information table 142, generates measurement value table design information 143 (S13).
Now, measurement value table design portion 121 records the information replacing measurement point as required in imagination measurement point definition list 141.
Be described later about replacement measurement point.
By this step S13, determine the corresponding relation of the row of actual measurement point and measurement value table 144 (multiple).
Measurement value table definition portion 122 generates (CREATE) measurement value table (S14) according to measurement value table design information 143.
In addition, the process of S13 is mainly described in the present embodiment.
(2) collection and the accumulation of data is measured
Usually use start time, actually measure a little corresponding Measuring Device from each and collect and measure data, measurement value is accumulated in measurement value table 144.
The process (Figure 21) that concrete execution is following in the collection and accumulation of measurement data.
(being regular during 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.
By in the measurement Data Collection accumulation unit 131 of collected measurement data write measurement data administrator 100 (S22).
Measurement Data Collection accumulation unit 131, according to measurement value table design information 143, determines the measurement value table 144 as the storage location of measurement value and row, by the corresponding row of measurement value write of measurement data (S23).
Further, when define with measure data actual measure replacement that some ID are associated measure some, will measure during data write arranges accordingly.
Be described later about replacement measurement point.
(3) measure the reading of data and add up
Usually using beginning, the measurement value of measurement data is when being accumulated in measurement value table 144, and carry out measuring the reading of data and accumulative as required, the user of measurement data administrator 100 uses measurement data.
Measuring the reading of data and specifically performing following process (Figure 22) in adding up.
User asks the reading (S31) of measurement data during specifying the measurement moment of imagination measurement point title and measurement data from operating terminal 220 to measurement data administrator 100.
Imagination measurement data operation portion 132, according to the imagination measurement point title of specifying, obtains the list (S32) of the actual measurement point for obtaining the measurement data that user expects based on imagination measurement point definition list 141.
Now, measurement point is replaced to certain imagination measurement point definition, when this replacement measurement point and other actual measurement data measuring point are dispensed in same table, imagination measurement data operation portion 132 measures data (S32) from measuring a little corresponding row to read with replacement.
Further, imagination measurement data operation portion 132 exports to operating terminal 220 (S33) by defining according to imagination measurement point the measurement data calculated.
In addition, measurement value table design portion 121 is equivalent to Data Segmentation portion, condition adjudgement portion, table dispenser and replaces the example of measurement point configuration part.
In addition, the example that Data Collection accumulation unit 131 is equivalent to replace measurement point calculating part is measured.
Below, illustrate in greater detail (1) and use preparation (S13 of Figure 20).
The measurement data administrator 100 of present embodiment manage as the structural information of illustrative tree-shaped construction data in such as Fig. 9 set 700 and structural information set 710.
Further, measure data administrator 100 and manage measurement value table 144.
The measurement value measured by multiple Measuring Device 201 is stored in measurement value table 144.
Structural information tree 700 and structural information tree 710 have the layered structure based on multiple node respectively.
Each node becomes the accumulative unit of measurement value.
The calculating formula of cumulative calculation to each node definition, comprises the actual measurement point of more than 0 in this calculating formula and the imagination of more than 0 measures point.
Actual measurement point is worth directly related identifier, and imagination measurement point measures a little directly related identifier with reality or measured the identifier a little measuring some indirect correlations with reality and join by other imagination.
That is, each node is associated with Measuring Device by actual measurement point and imagination measurement point.
In fig .9,721,722,723 represent imagination measurement point, and 731,732,733 represent actual measurement point.
The quantity (table memory device number) that namely columns of measurement value table 144 can store the Measuring Device of measurement value in measurement value table 144 is limited, and the quantity (i.e. the quantity of Measuring Device) that there is actual measurement point exceedes the situation of the columns of measurement value table 144.
When the quantity of reality measurement point exceedes the columns of measurement value table 144, need to use multiple measurement value table 144.
The measurement data administrator 100 of present embodiment determines measurement value to be stored in which the measurement value table 144 in multiple measurement value table 144.
In the measurement data administrator 100 of present embodiment, structural information tree 700 and structural information tree 710 are divided into multiple minor structure inforamtion tree by measurement value table design portion 121 respectively, and the quantity making the Measuring Device be associated with minor structure inforamtion tree (also referred to as subtree data (subtreedata) or subtree (subtree)) is below the columns of measurement value table 214.
Such as, the minor structure inforamtion tree that structural information tree 700 is divided into only node 701 by measurement value table design portion 121, with the node 702a minor structure inforamtion tree that is root node and the minor structure inforamtion tree that is root node with node 702b.
If the quantity of the Measuring Device be associated with the minor structure inforamtion tree of node 702a is below the columns of measurement value table 214, then do not carry out the further segmentation of this minor structure inforamtion tree.
On the other hand, when the quantity of the Measuring Device be associated with the minor structure inforamtion tree of node 702b exceedes the columns of measurement value table 214, this minor structure inforamtion tree is divided into the subtree of such as only node 702b, with the node 703a minor structure inforamtion tree that is root node, the minor structure inforamtion tree that is root node with node 703b.
If the quantity of the Measuring Device be associated with all minor structure inforamtion trees reaches below the columns of measurement value table 214, then measurement value table design portion 121 judges whether each minor structure inforamtion tree is in and determines state.
Further, measurement value table design portion 121, to being in the minor structure inforamtion tree determining state, divides the measurement value table being used in and storing from the measurement value of the Measuring Device be associated with this minor structure inforamtion tree.
To not being in the minor structure inforamtion tree determining state, this minor structure inforamtion tree is divided into multiple minor structure inforamtion tree by measurement value table design portion 121 further.
Two kinds are had to determine state in the present embodiment.
At the Measuring Device be associated with a subtree all unconnected with other any subtree and the quantity of Measuring Device that is that be associated with this subtree is below the columns of measurement value table, measurement value table design portion 121 is judged to be that this subtree is in the 1st and determines state.
And, in the Measuring Device be associated with a subtree at least one Measuring Device be repeatedly also associated with other subtree and below total number (unique total number) after the quantity of the Measuring Device be associated with this subtree and the repeating part of the quantity of Measuring Device that is associated with this other subtree the are removed columns that is measurement value table, measurement value table design portion 121 is judged to be that this subtree and this other subtree are in the 2nd and determine state.
The subtree 1101,1102 of Figure 23 is in the 1st and determines state.
The actual measurement be associated with subtree 1101 a little 1 ~ 5 is only associated with subtree 1101, and the columns of measurement value table is below 8.
Equally, the actual measurement be associated with subtree 1102 a little 6 ~ 11 is only associated with subtree 1102, and the columns of measurement value table is 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.
The actual measurement be associated with subtree 1111 is a little 1 ~ 6, and actual measurement the be associated with subtree 1112 is a little 2 ~ 7.
Actual measurement point 2 ~ 6 is associated with subtree 1111 and subtree 1112 both sides, thus removed by this repeating part and count, what be associated with subtree 1111 actually measures quantity a little and the actual total number measuring quantity a little that is associated with subtree 1112 is actual measurement point 1 ~ 7 these 7.
7 actual measures the columns of counting in measurement value table below 8.
Therefore, the subtree 1111,1112 of Figure 24 is in the 2nd and determines state.
And, in the situation (situation comprising the actual measurement point of more than 2, the situation comprising the combination of actual measurement point and imagination measurement point, only comprise the situation that imagination measures) that the measurement value table design portion 121 of present embodiment comprises the measurement point beyond 1 actual measurement point in the calculating formula of root node (node R of Figure 23), replacement measurement is associated with root node.
Measurement point is replaced to be represent that needs carried out the identifier of the accumulative calculating of measurement value in advance before user carries out accumulative instruction.
And, in the situation (comprise the situation of the combination of actual measurement point and imagination measurement point, only comprise the situation of imagination measurement point) that the calculating formula of root node (node R of Figure 23) comprises imagination measurement point, the use of measurement value table design portion 121 and this imagination measure the actual measurement point that a little direct or indirect correlation joins, generate and only comprise actual measurement point and the replacement calculating formula that can obtain the result of calculation identical with the calculating formula defined root node, replacement calculating formula is measured with replacement and is a little associated.
Further, measurement Data Collection accumulation unit 131 measures for replacement the root node be a little associated, and carries out the accumulative calculating of measurement value before having the accumulative instruction about this root node in advance, result of calculation is measured with replacement and is a little associated.
Like this, carried out calculating about the moment of the accumulative instruction of root node has completed aggregate-value user, thus forthwith aggregate-value can be prompted to user.
Based on above summary description, describe structure and the action of the measurement data administrator 100 of present embodiment in detail.
Fig. 1 is the functional structure chart of the measurement data administrator 100 of embodiment 1.
About the functional structure of the measurement data administrator 100 of embodiment 1, be described according to Fig. 1.
Measurement data administrator 100 is the computer installations managing various measurement data.
From large aspect, measurement data administrator 100 has imagination measurement point management department 110, measurement Zhi Biao management department 120, measurement Data Management Department 130 and data store 140.
Imagination measurement point management department 110 has imagination measurement dot information input and output portion 111 and structural information input and output portion 112.
Imagination measurement dot information input and output portion 111 accepts the input of the imagination measurement dot information from user, imagination is measured dot information and is stored in imagination measurement point definition list 141.
Structural information input and output portion 112 accepts the input of the structural information from user, structural information is stored in the structural information table 142 of data store 140.
Further, imagination measurement dot information input and output portion 111, according to the request from user, reads imagination measurement dot information from imagination measurement point definition list 141, and the imagination measurement dot information read-out by exporting.
Further, structural information input and output portion 112 according to the request from user, from structural information table 142 reading out structure information, and export read-out by structural information.
About these imagination measurement dot informations, structural information, imagination measurement point definition list 141 and structural information table 142, be described later.
Measurement Zhi Biao management department 120 has measurement value table design portion 121 and measurement value table definition portion 122.
Measurement value table design portion 121, according to the information be recorded in imagination measurement point definition list 141, structural information table 142, generates the design information of measurement value table 144, generated design information is recorded as measurement value table design information 143.
Further, measurement value table definition portion 122 is according to measurement value table design information 143, and reality generates measurement value table 144.
Measurement Data Management Department 130 is made up of measurement Data Collection accumulation unit 131, imagination measurement data operation portion 132 and measurement data output section 133.
Measurement Data Collection accumulation unit 131 accepts the input of the measurement data of collecting from various Measuring Device, and is stored in measurement value table 144.
Imagination measurement data operation portion 132, according to the imagination measurement point definition of imagination measurement point definition list 141, calculates the measurement data of imagination measurement point.
Measurement data output section 133, according to the accumulative reading request waiting measurement data from user, reads measurement data from measurement value table 144, read-out measurement data is exported to user.
Data store 140 stores the various data of imagination measurement point definition list 141, structural information table 142, measurement value table design information 143, measurement value table 144 etc.
Each funtion part of measurement data administrator 100 also can realize on 1 computer installation, also can be distributed on the multiple stage computer installation that connected by network and realize.
Fig. 2, Fig. 3 are the figure of the structure example of the measurement data management system 200 that embodiment 1 is shown.
About the structure example of the measurement data management system 200 of embodiment 1, be described according to Fig. 2 and Fig. 3.
Measurement data management system 200 shown in Fig. 2, except measurement data administrator 100, also has the operating terminal 220 of more than 210 and 1, the strong point device (hubdevice) of more than 1 be connected with measurement data administrator 100 by network.
But when measuring data administrator 100 and having function (application enforcement division 221) of operating terminal 220, measurement data management system 200 also can not have operating terminal 220.
Strong point device 210 sends to measurement data administrator 100 computing machine or the communicator that comprise the measurement data of measurement value (such as power consumption, voltage, water consumption, temperature etc.).
Strong point device 210 has measurement data reception portion 211, measurement data sending part 212 and strong point device storage part 219.
Measurement data reception portion 211 receives from each Measuring Device 201 (such as switchboard, voltage table, water meter, thermometer etc.) of measurement measurement value the measurement data comprising measurement value.
Measurement data sending part 212 sends to measurement data administrator 100 the measurement data received by measurement data reception portion 211.
Strong point device storage part 219 store that strong point device 210 uses by data such as the measurement data that receive of measurement data reception portion 211.
Operating terminal 220 is devices (computing machine) that the accumulative process performed for carrying out measurement value waits the application program (hereinafter referred to as application) of the process of user's request.
Operating terminal 220 has the application enforcement division 221 performing application and the operating terminal storage part 229 being stored in the data that operating terminal 220 uses.
Such as, action, by performing application, is carried out according to the following stated in the application enforcement division 221 of operating terminal 220.
Measurement value is asked to measurement data administrator 100 in application enforcement division 221, obtains measurement value, and perform the accumulative process about acquired measurement value from measurement data administrator 100.
The measurement Data Collection accumulation unit 131 (with reference to Fig. 1) of measurement data administrator 100 collects from each strong point device 210 be connected with measurement data administrator 100 the measurement data comprising measurement value, collected measurement data is stored in measurement value table 144.
What the measurement data management system 200 shown in Fig. 2 was connected with measurement data administrator 100 by each strong point device 210 is star-likely formed.But measurement data management system 200 also can be the tree that each strong point device 210 layering is as shown in Figure 3 formed by connecting or the structure connecting measurement data administrator 100 and each strong point device 210 with other connected mode.
In the measurement data management system 200 shown in Fig. 3, strong point device 210A collects measurement data from strong point device 210B, 210C of the bottom connected by network, collected measurement data is sent to measurement data administrator 100.
Fig. 4 is the figure of the essential structure of the measurement data that present embodiment is shown.
The measurement data 400 of embodiment 1 at least comprise actual measurement point ID401, measurement moment 402 and measurement value 403.
Actual measurement point ID401 is the identifier of the setting place for uniquely identifying Measuring Device 201 or Measuring Device 201.
After, the setting place of Measuring Device 201 or Measuring Device 201 is called " actual measurement point ".
Further, with the form statement of " $ × " actual measurement point ID.
Wherein, "×" represents arbitrary round values.
The measurement moment 402 represents that measurement value is by the time measured.
The measurement moment 402 is set by each Measuring Device 201 and/or each strong point device 210.
Measurement value 403 represents the measurement value measured by Measuring Device 201.
Fig. 5 is the figure of the measurement value table 144 that embodiment 1 is shown.
Each bar record (OK) of measurement value table 144 is by line number 501, measurement moment 502 and form at multiple measurement value 503A ~ 503E that synchronization measures.
Line number 501 is the numberings for being identified in the measurement value that synchronization measures.
The measurement moment 502 is equivalent to measure the moment 402, also can comprise a little error.
There is the deviation according to the clock and watch of each Measuring Device 201 and/or strong point device 210 and produce the situation of error in the measurement moment 402.
In this case, need to round the measurement moment 402 in the error range allowed and as the process of measurement data in identical measurement moment 502.
Such as, in advance the error of permission is set as 100 milliseconds, ~ multiple measurement data in measurement moment 402 of " 2013/4/118:00:00.099 " will be included in " 2013/4/118:00:00.000 ", as the measurement data that the measurement moment 502 is " 2013/4/118:00:00.000 ", be summarised in same record.
In addition, in the present embodiment, the mode that rounds of the error in measurement moment 402 is not the problem of internal, thus omits details.
Measurement value 403 is stored in any measurement value of measurement value 503.
Its corresponding relation determines according to measurement value table design information 143 described later.
In the present embodiment, to have premised on the structural information possessing layered structure, indicate the structure of the object of the object as setting imagination measurement point.
This layered structure such as can be expressed as tree structure as shown in Figure 6, at this, information with such layered structure is called that structural information is set.
Also this hierarchical relationship is called set membership or upper and lower relation.
There are the multiple kinds (viewpoint) as shown in the example of Fig. 6, Fig. 7, Fig. 8 in structural information tree.
Fig. 9 be description architecture inforamtion tree 700,710, imagination measurement dot information 720, actual measurement dot information 730 and the figure of the relation of measurement value 503 that stores in measurement value table 144.
Structural information has the multiple structural information trees as structural information tree 700,710.
Structural information tree is the tree structure be made up of the node being called as structural information node.
Structural information node by have father node and child node usual node 702,703, the root node 701 without father node and the leaf node 704,711 without child node form.
Each structural information node and the imagination imagination measured in dot information 720 measures point (such as 722) and is associated.
As structural information node 704 and 711, multiple structural information node refers to an imagination measurement point 723 sometimes.
Further, the imagination measurement point comprised in imagination measurement dot information 720 and more than one reality measure the actual measurement point (such as 731) that comprises in dot information 730 or more than one imagination and measure and be a little associated.
Such as, imagination measurement point 722 measures a little be associated with actual a little 731,732 these two reality that measure.
Further, both existed as imagination measurement point 721 only measure like that the situation that point (refer to imagination measure a little 722) is associated herein with imagination, also exist as imaginary measure 723 measure a little 733 and the imaginary situation measuring some both sides and be associated with actual.
Like this, imagination measurement point measures a little directly related identifier with reality or measured the identifier a little measuring some indirect correlations with reality and join by other imagination.
In addition, the actual measurement point 731 comprised in actual measurement dot information 730 arranges above measurement value 503 with 1 of measurement value table 144 and is associated.
Actual measurement point is worth directly related identifier with the measurement of Measuring Device like this.
Use Fig. 6 that the example that structural information is set is shown.
Structural information tree has expression to construct with the tree on the limit (being connected the line of each node) representing inscape hierarchical relational each other as arranging the imaginary node (the fillet quadrilateral in Fig. 6) measuring the inscape of the object of the object of point.
The node (such as, " company " node in Fig. 6) being positioned at the summit of tree structure is root node, is the father node of upper.
Further, the node (such as, the "-stock " node in Fig. 6) being positioned at the end of tree structure is leaf node, is the child node of lowermost position.
Fig. 6 is the structural information tree of the structure of " tissue " illustrated as the object arranging imagination measurement point.
" company " node 601 represents that company is overall.
" company " is made up of multiple " departments " such as " administrative authority " 602, " zero operating divisions " 603, " △ operating divisions " 604.
Administrative authority 602 is made up of multiple " portions " such as " Human Resources Department " 605, " General Affairs Department " 606, " accounting departments " 607.
Human Resources Department 605 is made up of " personnel department " 608, " trainee department " 609 etc. multiple " section ".
Each node " company " 601, " administrative authority " 602, " Human Resources Department " 605, " personnel department " 608 etc. are an example of imagination measurement point respectively.
Fig. 7 is an example of the structural information tree of the structure of " configuration " illustrated as the object arranging imagination measurement point.
Fig. 8 is an example of the structural information tree of the structure of " equipment " illustrated as the object arranging imagination measurement point.
Figure 10 and Figure 11 is the figure of the structural information table 142 that embodiment 1 is shown.
Structural information table 142 is examples for the data of the structural information that the object represented as the object arranging imagination measurement point is shown.
Structural information table 142 shown in Figure 10 and Figure 11 comprises sets relevant structural information with the structural information shown in Fig. 6 ~ Fig. 8.
Structural information table 142 has the record of " node ID " " father ID " " group ID " " grade " " imagination measurement point ID " " nodename " corresponding formation.
" node ID " represents the identifier for identifying structural information node.
" father ID " represents the identifier for identifying with this structural information node the father node being set membership.
When at " father ID " being " empty (null) ", mean that this node is root node.
" group ID " represents for identifying the identifier that structural information is set.
" grade " represents the degree of depth (grade) of the layer residing for this structural information node.
The grade of root node be set to " 1 ", whenever declining one deck towards inferior direction, numerical value increases by 1.
" imagination measurement point ID " represents for identifying that the imagination corresponding with this structural information node measures identifier a little.
Below, imagination measurement point ID is described as " # × ".
Wherein, "×" represents arbitrary round values.
" nodename " illustrates the nodename of the content representing this structural information node.
Such as, the node ID of " company " node shown in Fig. 6 is " 1 ", and group ID is " 1 ", and grade is " 1 ", and imagination measurement point ID is " #1 ".
Further, the node ID of " administrative authority " node is " 2 ", and father ID is " 1 " (i.e. " company " node), and group ID is " 1 ", and grade is " 2 ", and imagination measurement point ID is " #2 ".
In structural information table 142, the grade name table 142B of grade name of the group name table 142A defining the group name of the content representing structural information tree and the content that defines each layer representing structural information tree is associated (being all Figure 11).
Group name table 142A has record corresponding to " group ID " " group name ".
Such as, the structural information tree group ID " 1 " shown in Fig. 6 identifies, the tissue in expression company.
Further, the tree structure group ID " 2 " shown in Fig. 7 identifies, represents " configuration (place) " in company.
Grade name table 142B has the record of " group ID " " grade " " grade name " corresponding formation.
Such as, the layer of the grade " 1 " in the tree structure shown in Fig. 6 represents that " company " is overall, " department " in the layer expression company of grade " 2 ".
Further, the layer of the grade " 1 " in tree shown in Fig. 7 structure represents that " configuration " is overall, the cause in the layer expression company of grade " 2 " residing for " area ", " cause institute " in the layer expression company of grade " 3 ".
Figure 12 is the figure of the imagination measurement point definition list 141 that embodiment 1 is shown.
Imagination measurement point definition list 141 measures with reality a little to define the example that imagination measures data a little accordingly.
Imagination measurement point definition list 141 has the record of " imagination measurement point ID " 901, " imagination measurement point title " 902, " definition of imagination measurement point " 903, " replacing measurement point mark " 904 corresponding formation.
" imagination measurement point ID " 901 represents the identifier identifying 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 the imagination measurement point title of the content representing imagination measurement point.
Imagination measurement point title also can be inconsistent with nodename.
" imagination measurement point definition " 903 measure a little with actual or other imaginary measurement a little illustrates the imaginary definition measured a little accordingly.
" replacing measuring a mark " 904 is represent the mark whether comprising replacement measurement point in imagination measurement point defines.
Such as, imagination measurement point " #1 " is associated with " the total electricity of company " of the power consumption representing company's entirety.
Especially for large-scale tissue as company is overall, there is not the Measuring Device for directly measuring its power consumption, " the total electricity of company " refers to the imaginary measurement point in fact do not arranged.
Therefore, imagination measurement point " #1 " power consumption and, the next tissue imagination measures the power consumption of point " #2 " (administrative authority's electricity), the power consumption of " #10 " (zero operating divisions's electricity) is equal with the power consumption sum of " #20 " (△ operating divisions electricity).
That is, imagination measurement point " #1 " defines with the definition that " #2+#10+#20 " is such.
" the 1st, the Tokyo converting equipment " of the power consumption that imagination measurement point " #201 " is overall with controlling buildings " the 1st, Tokyo " is associated.
Imagination measurement point " #201 " power consumption with representing that the power consumption that the actual measurement point " $ 1 " of the 1st converting equipment in Tokyo measures is equal.
Wherein, in the imagination measurement point definition of imagination measurement point " #1 ", except definition " #2+#10+#20 ", also define and replace measurement point " %1 ".
Replace measurement point to refer to except original imagination measurement point definition or actual measurement point, in measurement value table 144, also define the measurement point of the row of the measurement value for reading this imagination measurement point.
That is, when defining replacement measurement point, measuring a little the same with reality, can be worth the row of the correspondence of table 144 from measurement and directly reading measurement value.
Also be set in the definition of imagination measurement point whether to define to replacement measurement point mark 904 and replace measurement point.
The details of measurement point is replaced to illustrate below.
Below, the replacement measurement point ID of the identifier instead measured a little is described as " % × ".
Wherein, "×" represents arbitrary round values.
Describe in fig. 12 and replace measurement point " %1 ", " %2 ", " %3 " and " %4 ", but be set in the S13 (Figure 20) of the operational phase measured value table design portion 121 that falls into a trap owing to replacing measurement point, thus replace measurement point " %1 ", " %2 ", " %3 " and " %4 " be after the process carrying out S13 by description in measurement value table 144.
Figure 13 is the figure of the measurement value table design information 143 that embodiment 1 is shown.
Measurement value table design information 143 is examples for the data defining actual measurement point or replace the corresponding relation between measurement point and measurement value table 144.
Measurement value table design information 143 has " measurement point an ID " 1001, " DB (database) server name " 1002, " database-name " 1003, " table name claims " 1004, " row title " 1005 and " data type " 1006 record of corresponding formation.
" measurement point ID " 1001 represents actual measurement point ID or replaces measurement point ID.
" DB server name " 1002 represents the server name defining the data base management system (DBMS) place of measurement value table 144.
" database-name " 1003 represents the database-name defining measurement value table 144.
" table name claims " 1004, represents that the table name of the reality of measurement value table 144 claims.
In addition, " DB server name " 1002, " database-name " 1003, " table name claims " 1004 are examples, as long as measure a little with reality or replace the table measuring a little corresponding measurement value table 144 can set well-determined information.
" row title " 1005 represents the row title on the measurement value table 144 of the measurement value storing actual measurement point or replace measurement point.
" data type " 1006 represents the data type of measurement value.
Figure 14 illustrates figure that be attached to the measurement value table design information 143 of embodiment 1, that replace measurement point definition list 143A.
Measurement point definition list 143A is replaced to have the record of " replacing measurement point ID " 1011, " replacing the definition of measurement point " 1012 corresponding formation.
1011 expressions replace measurement point ID " to replace measurement point ID ".
1012 expressions that " replace the definition of measurement point " are for calculating a replacement measurement definition of the measurement data replacing measurement point.
Replace the definition of measurement point by measurement data or the actual measurement point of an actual measurement point and replace the arithmetic expression of the measurement data of measurement point to form.
The details of measurement point definition is replaced to be described later.
In a fairly large number of situation of the Measuring Device used at large-scale buildings and/or tissue etc., to exist and a structural information is set be associated actual and measured quantity a little far away more than the situation of the upper limit of a columns shown of measurement value table 144.
In this case, contingency table in a column direction can be considered, the measurement data scatter of reality measurement point be carried out in multiple table the countermeasure managed.
Now, as the method measurement data of which actual measurement point are stored in which table, can consider to pay close attention to some structural informations tree, in units of its subtree, carry out the method for contingency table.
Such as, pay close attention to the structural information of " configuration ", structural information tree is divided into the subtree of each " cause institute ", and is divided into the table storing the measurement data be associated with " Tokyo cause institute ", the table storing the measurement data be associated with " Kanagawn cause institute ", stores the table of the measurement data be associated with " Saitama jade cause institute ".
In this case, by when the accumulative of measurement value and the scope control analyzed are in cause institute, the problem of the efficiency decline of accumulative and analyzing and processing can not be produced.
On the other hand, when carrying out adding up and analyzing according to the structural information beyond " configuration ", there is the situation that efficiency that is accumulative and analyzing and processing declines.
As shown in Figure 9, existence one imagination measurement point or the actual point that measures set situation about being associated with multiple structural information.
In a practical situation, can consider that imagination measurement point or actual measurement point nearly all set situation about being associated with multiple structural information.
Wherein, when each portion that hypothesis belongs to " zero operating divisions " is positioned at cause institute in all parts of the country, need to read measurement value from multiple measurement value table 144, to carry out the accumulative and analysis of the measurement data about " zero operating divisions ".
And, measure situation a little in the imagination corresponding with the upper node that structural information is set, to the structural information paying close attention to " configuration " as escribed above to split measurement value table 144 time " company " and/or " area, the Northeast " situation, to by imaginary measure some definitions calculate its measure data, needs read measurement value from multiple measurement value table 144 all the time.
At this, by the state of measurement data scatter in multiple measurement value table 144 of carrying out like this and required for analyzing, be called the part of measurement data.
Measurement value table design portion 121 generate part for suppressing such measurement data, the design information of measurement value table 144.
As prerequisite, generate imagination measurement dot information and structural information in advance in this hypothesis, and be stored in respectively in imagination measurement point definition list 141 and structural information table 142.
In addition, replace measurement point to be defined by measurement value table design portion 121, be thus in the definition of imagination measurement point in this moment and do not define the state replacing measurement point.
Further, in measurement value table design information 143, set actual measurement point " measurement point ID " 1001 and " data type " 1006 is supposed.
Be defined as follows at this.
C: the columns that can store measurement data in a table of measurement value table 144
The size of tree: the quantity of all nodes comprised in this tree
The physical size of tree: what be associated with this tree unique actually measures a little and replace measuring quantity a little
According to Figure 15 and Figure 16, the action (action of the S13 shown in Figure 20) in the measurement value table design portion 121 of embodiment 1 is described.
Figure 15 and Figure 16 is the process flow diagram of the step of the generating process that the measurement value table design information 143 that the measurement value table design portion 121 of embodiment 1 carries out is shown.
(step S1101) measurement value table design portion 121 generates the temporary structure information table of the copy as structural information table 142 in the memory storage of operation.
In addition, measurement value table design portion 121 generates a measurement point management information table, minor structure inforamtion tree admin table initialization.
Generate in the temporary storing device that these tables can have alone in measurement value table design portion 121, also can generate in the temporary storing device on measurement data administrator 100.
Wherein, temporary structure information table is for managing the state of minor structure inforamtion tree.
Figure 17 is the figure of the example that the measurement point management information table 1200 generated in step S1101 is shown.
Measurement point management information table 1200 has the record of " measurement point an ID " 1201, " this node ID " 1202, " root node ID " 1203, " row title " 1204 and " replacing the definition of measurement point " 1205 corresponding formation.
" measurement point ID " 1201 represents actual measurement point ID or replaces measurement point ID.
" this node ID " 1202 represents and has imagination and measure the node ID that the imagination a little define measure all nodes be a little associated, and this imagination measures to define and directly comprises the utilization 1201 actual measurement point ID specified that " measure an ID ".
Such as, in the imagination measurement point definition list 141 of Figure 12, the imagination measurement point definition 903 of imagination measurement point ID " #201 " is " $ 1 ", directly comprises actual measurement point ID.
In this case, extract " 201 " from structural information table 142 and measure as with imagination the node ID 801 that some ID " #201 " are associated, and be set as " this node ID " 1202.
On the other hand, in the imagination measurement point definition list 141 of Figure 12, the imagination measurement point definition 903 of imagination measurement point ID " #1 " is made up of the arithmetic expression of the measurement data of all imagination measurement points, does not thus directly comprise actual measurement point ID.
" the root node ID " 1203 of the measurement point management information table 1200 of Figure 17, represents and utilization " measuring some ID " 1201 actual root node ID measuring a little or replace measuring the minor structure inforamtion tree be a little associated specified.
At reality measurement point or when replacing measurement point to be associated with multiple minor structure inforamtion tree, root node ID is set to the node ID of the root node of all minor structure inforamtion trees that this is associated.
When the size of all minor structure inforamtion trees that this is associated is 1 (nodes 1) or with anyon structural information set do not associate when, setting " empty (null) ".
" row title " 1204 represents the row title in the measurement value table 144 being used for memory " measurement point ID " the 1201 measurement data of specifying.
" replace measuring some definition " 1205 to represent for calculating the definition replacing the measurement data measuring point.
Replace the definition of measurement point definition by measurement data or the actual measurement point of single actual measurement point and replace the arithmetic expression of the measurement data of measurement point to form.
Figure 18 is the figure that the minor structure inforamtion tree admin table 1210 generated in step S1101 is shown.
Minor structure inforamtion tree admin table 1210 has " minor structure inforamtion tree ID " 1211, " root node ID " 1212, " minor structure inforamtion tree group ID " 1213, " determine indicate " 1214, " DB server name " 1215, " database-name " 1216 and " table name claims " 1217 record of corresponding formation.
" minor structure inforamtion tree ID " 1211 represents the identifier being used for recognin structural information tree uniquely.
" root node ID " 1212 represents the node ID of the root node of the minor structure inforamtion tree utilizing minor structure inforamtion tree ID to identify.
" minor structure inforamtion tree group ID " 1213 represents the identifier being used for the set (minor structure inforamtion tree group) identifying the minor structure inforamtion tree be associated uniquely.
For being judged as multiple minor structure inforamtion trees that the 2nd determines state, set same " minor structure inforamtion tree group ID ".
" determine to indicate " that 1214 represent whether the minor structure inforamtion tree utilizing " minor structure inforamtion tree ID " 1211 to identify is determined.
" DB server name " 1215, " database-name " 1216 and " table name claims " 1217, represent that the DB server name of measurement value table 144, database-name and table name claim respectively.
This is the information for identifying the table storing following measurement data uniquely, be and " the DB server name " 1002 of the measurement value table design information 143 of Figure 13, information that " database-name " 1003 is identical, wherein, these measurement data be with utilize " minor structure inforamtion tree ID " 1211 the minor structure inforamtion tree identified be associated actually measure a little or replace the measurement data that measure a little.
Wherein, " minor structure inforamtion tree T1 determines " refers to that minor structure inforamtion tree is in following " the 1st determines state " or " the 2nd determines state " as previously described.
Further, will be called " still undetermined minor structure inforamtion tree " with all incongruent minor structure inforamtion tree of any state in " the 1st determines state " and " the 2nd determines state ".
(the 1st determines state)
Physical size is that the minor structure inforamtion tree T1 of below C, all actual measurement points be namely associated or replacement measurement point are all uncorrelated with other minor structure inforamtion tree T2.
In measurement point management information table 1200, all actual measurement points be associated or the root node ID of replacement measurement point are only the root nodes of minor structure inforamtion tree T1.
(the 2nd determines state)
Even the minor structure inforamtion tree T1 being below C with physical size be associated all actual measure a little or replace measuring point, when being associated with other minor structure inforamtion tree T2, actual unique (except the repetition) quantity measured a little be associated with minor structure inforamtion tree T1, T2 is also below C.
When be associated with certain minor structure inforamtion tree T1 actual measure some N1 be also associated with other minor structure inforamtion tree T2, be associated with minor structure inforamtion tree T2 other actual measure some N2 be associated with other minor structure inforamtion tree T3 again, measure the unique quantity measuring a little with being associated arbitrarily in minor structure inforamtion tree T1, T2, T3 all actual or replace to measure a little, if this quantity is below C, be then the 2nd determine state.
Measurement value table design portion 121 is first to whole each setting one actual measurement point ID of the measurement point ID1201 of each bar record of measurement point management information table 1200.
Then, the structural information tree be associated is extracted to each actual measurement point ID, the node ID of its root node is set as root node ID1203.
For this reason, an imagination measurement point definition 903 for imagination measurement point definition list 141 is searched in measurement value table design portion 121, by comprise the corresponding actual imagination measuring some ID and measure and a little define corresponding imagination and measure some ID901 and all extract.
Then, all extract measuring with this imagination the group ID803 that some ID are associated from structural information table 142.
Finally, extract the node ID of the root node belonged in the node ID of the group ID extracted, and be set as the root node ID1203 measuring some management information table 1200.
In order to learn certain size set, in temporary structure information table, successively, recursively count with the quantity of this node ID for the node of father ID from the node suitable with the root node of this tree.
Further, in order to learn certain physical size set, the number of times that the root node ID of this tree occurs in the root node ID1203 of measurement point management information table 1200 is counted.
Equally, first measurement value table design portion 121 defines and is used for identifying identifier=minor structure inforamtion tree ID that each structural information is set uniquely, and is set as the minor structure inforamtion tree ID1211 of each bar record of minor structure inforamtion tree admin table 1210.
As minor structure inforamtion tree ID now, the group ID803 of structural information table 142 also can be used.
Structural information tree is divided into subtree by (step S1102) measurement value table design portion 121, makes the physical size of all minor structure inforamtion trees be below C.
As an example of this step, there is following step.
(1) measurement value table design portion 121 selects a physical size more than the minor structure inforamtion tree T of C from all minor structure inforamtion trees.
(2) selected minor structure inforamtion tree T is divided into root node and take the child node of this root node as the subtree of new root node by measurement value table design portion 121.
Further, measurement value table design portion 121 upgrades measurement point management information table 1200 and minor structure inforamtion tree admin table 1210.
The details of this step is described later.
(3) measurement value table design portion 121 performs the operation of (1) ~ (2) repeatedly, until till there is not the minor structure inforamtion tree of physical size more than C.
The minor structure inforamtion tree T1 that size is maximum, from still undetermined minor structure inforamtion tree, selects in (step S1103) measurement value table design portion 121.
(step S1104) measurement value table design portion 121 from be associated with the minor structure inforamtion tree T1 selected among step S1103 actual measure a little or replace measuring associated by some N1, in other still undetermined minor structure inforamtion tree, select the minor structure inforamtion tree T2 that size is maximum.
The quantity of the child node of root node in minor structure inforamtion tree T1, T2 compares by (step S1105) measurement value table design portion 121, the more minor structure inforamtion tree T ' of chooser node.
Further, minor structure inforamtion tree T ' is divided into root node R and using its child node as the minor structure inforamtion tree of new former generation by measurement value table design portion 121.
Wherein, in the segmentation of the minor structure inforamtion tree T ' selected, be suitable for the step identical with (2) of step S1102.
(step S1106) measurement value table design portion 121 checks in the imagination measurement point definition of the root node R of step S1105 whether directly comprise actual measurement point.
That is, measurement value table design portion 121 extracts from structural information table 142 imagination be associated with the node ID of root node R and measures some ID805.
Further, measurement value table design portion 121 extracts an imagination measurement definition 903 of this imagination measurement point ID from imagination measurement point definition list 141, and checks whether and directly comprise actual measurement point.
When check result be directly comprise (YES), process enters step S1109.
When directly not comprising (no), process enters step S1107.
" directly comprise actual measurement point " and refer to that the definition 903 of imagination measurement point is the situations with the definition of an actual measurement point.
When the definition 903 of imagination measurement point be a situation with the definition of multiple reality measurement point, only by the situation of imagination measurement point definition and define with the combination of actual measurement point and imagination measurement point, be judged to directly not comprise (no).
The root node R of (step S1107) measurement value table design 121 couples of step S1105 in portion redistributes and replaces measurement point ID, and adds in measurement point management information table 1200.
Measurement value table design portion 121 adds new record in measurement point management information table 1200, " this node ID " 1202 will be set as by newly assigned replacements a measurement point ID as " measurement point an ID " 1201, and the node ID of root node R will be set to " root node ID " 1203.
" row title " 1204 sets afterwards.
Be set with to the definition of the measurement data for calculating this replacement measurement point " replacing the definition of measurement point " 1205.
In order to set definitions to " replacing the definition of measurement point " 1205, measurement value table design portion 121 extracts from the imagination measurement point ID805 of structural information table 142 imagination be associated with the node ID of this root node R and measures some ID, extracts the imagination measurement point definition of this imagination measurement point from the imagination measurement point definition 903 of imagination measurement point definition list 141.
In addition, definition recursively launches by measurement value table design portion 121, until till no longer comprising imagination measurement point ID in the definition of this imagination measurement point definition 903 extracted, and expansion result is set to " replacing the definition of measurement point " 1205.
Now, " replace measurement point definition " after deployment 1205 is very complicated and calculated load that is measurement data is higher or when only can not calculate according to the measurement data in identical measurement moment the measurement data etc. replacing measurement point, measurement value table design portion 121 also can not define and replace measurement point.
(step S1108) measurement value table design portion 121 will replace the information adding of measurement point in imagination measurement point definition list 141.
Measurement value table design portion 121, in the same manner as the step of above-mentioned steps S1107, determines that the imagination be associated with the node ID of root node R measures some definition 903, and in the definition 903 of this imagination measurement point, add the replacement measurement point ID distributed root node R.
(step S1109) measurement value table design portion 121, using the minor structure inforamtion tree of root node R as size 1, adds in minor structure inforamtion tree admin table.
Measurement value table design portion 121 generates the record of corresponding root node R, redistributes minor structure inforamtion tree ID, and is set as " minor structure inforamtion tree ID " 1211.
Further, the node ID of root node R is set as " root node ID " 1212 by measurement value table design portion 121.
In addition, measurement value table design portion 121 is antithetical phrase structural information tree distribution group ID again, and is set as " minor structure inforamtion tree group ID " 1213.
(step S1110) measurement value table design portion 121 checks minor structure inforamtion tree admin table 1210, and checks whether that all minor structure inforamtion trees are determined (whether " determining mark " 904 is established).
In all fixed situations of minor structure inforamtion tree (" determining mark " 904 situations about being established: yes), process enters step S1111.
When there is still undetermined minor structure inforamtion tree (no), the processing returns to step S1103.
(step S1111) measurement value table design portion 121 is when all minor structure inforamtion trees are determined, and setting DB server name 1215, database-name 1216, table name claim 1217 and row title 1204.
First, measurement value table design portion 121 in minor structure inforamtion tree admin table 1210, to identical " the DB server name " 1215 of the record setting being set identical " minor structure inforamtion tree group ID " 1213, " database-name " 1216 and " table name claims " 1217.
Measurement value table design portion 121 for the record being set different " minor structure inforamtion tree group ID " 1213, the setting value that at least " DB server name " 1215, " database-name " 1216 are different with any one party in " table name claims " 1217.
Then, measurement value table design portion 121 extracts the root node ID of the minor structure inforamtion tree of the minor structure inforamtion tree group belonging to identical from " root node ID " 1212, in " the root node ID " 1203 of measurement point management information table 1200, distribute unique " row title " 1204 to the measurement point being set this root node ID.
(step S1112) measurement value table design portion 121, according to the information measuring some management information table 1200 and minor structure inforamtion tree admin table 1210, upgrades measurement value table design information 143 and replaces measuring some definition list 143A.
That is, be set as follows.
" the measurement point ID " 1201 of measurement point management information table 1200
" the measurement point ID " 1001 of → measurement value table design information 143
" the DB server name " 1215 of minor structure inforamtion tree admin table 1210
" the DB server name " 1002 of → measurement value table design information 143
" database-name " 1216 of minor structure inforamtion tree admin table 1210
" database-name " 1003 of → measurement value table design information 143
" table name claims " 1217 of minor structure inforamtion tree admin table 1210
" table name claims " 1004 of → measurement value table design information 143
" the row title " 1204 of measurement point management information table 1200
" the row title " 1005 of → measurement value table design information 143
Replacement measurement point ID in " the measurement point ID " 1201 of measurement point management information table 1200
→ replace " the replacing measurement point ID " 1011 measuring some definition list 143A
" replacing the definition of measurement point " 1205 of measurement point management information table 1200
→ replace " the replacing measurement point to define " 1012 measuring some definition list 143A
Wherein, " data type " 1006 of the replacement measurement point of measurement value table design information 143, can set according to measuring with this replacement the actual measurement point " data type " 1006 be a little associated.
In step S1112, " measurement point ID " 1001 of measurement value table design information 143, with " the DB server name " 1215 of minor structure inforamtion tree admin table 1210 and/or the corresponding relation of " database-name " 1216, can determine to measure some " root node ID " 1203 of management information table 1200 and " the root node ID " 1212 of minor structure inforamtion tree admin table 1210 as keyword.
In addition, " DB server name " 1215 is assigned with in step S1111, " database-name " 1216, " table name claims " 1217 and " row title " 1204, but also can be, measurement value table design portion 121 only sets " the measurement point ID " 1201 of measurement point management information table 1200, " this node ID " 1202, " root node ID " 1203, " replace measuring some definition " 1205, and " the minor structure inforamtion tree ID " 1211 of minor structure inforamtion tree admin table 1210, " root node ID " 1212, " minor structure inforamtion tree group ID " 1213 and " determining mark " 1214, remaining " DB server name " 1215, " database-name " 1216, " table name claims " 1217, " row title " 1204 is set by the user.
(step S1113) measurement value table design portion 121 is by the measurement value table design information 143 after upgrading and replace a measurement point definition list 143A to be recorded in data store 140 and terminate.
When the size of minor structure inforamtion tree is larger, the probability that actual measurement point associated with it or replacement measurement point are associated with other minor structure inforamtion tree is higher.
Therefore, in above-mentioned step S1103, S1104, the larger-size tree of measurement value table design portion 121 prioritizing selection minor structure inforamtion tree is split.
In above-mentioned step S1103, S1104, also can not in accordance with tree size, but with tree physical size for selection of reference frame minor structure inforamtion tree T.
In addition, the minor structure inforamtion tree that the quantity of the child node of root node is maximum can also be selected.
When the quantity of the child node of root node is more, by once to the segmentation of minor structure inforamtion tree, be divided into less minor structure inforamtion tree, thus can expect until the step number that the determines all minor structure inforamtion trees effect of cutting down.
In addition, also can preset the threshold value of the quantity of the size of tree or the child node of physical size or root node, in the minor structure inforamtion tree exceeding this threshold value, select the minor structure inforamtion tree found at first.
Thereby, it is possible to expect the effect of the time required for search of the candidate cutting down the minor structure inforamtion tree that will split.
In step S1105, also can not in accordance with the quantity of the child node of root node, but with the physical size of the size of tree or tree for benchmark, chooser structural information is set.
Further, also can preset the threshold value of the physical size of the quantity of the child node of root node or the size of tree or tree, in the minor structure inforamtion tree exceeding this threshold value, select the minor structure inforamtion tree found at first.
Figure 19 is the process flow diagram that the minor structure inforamtion tree illustrating embodiment 1 is divided into the flow process of the process of subtree.
That is, the details of the step of (2) of step S1102 is shown.
(step S1301) specifies the minor structure inforamtion tree T that will split.
(step S1302) measurement value table design portion 121 is in temporary structure information table, and the record being " father ID " 802 by the node ID of the root node R of minor structure inforamtion tree T all extracts.
These nodes recorded are set to Ri.
Further, " the father ID " 802 recorded accordingly is set as " sky " by measurement value table design portion 121.
(step S1303) measurement value table design portion 121 extracts the record of the node ID of the root node R of minor structure inforamtion tree T as " the root node ID " 1203 of measurement point management information table 1200, and upgrades this root node ID.Meanwhile, measurement value table design portion 121, in structural information table 142, upgrades " grade " 804 of all nodes comprised in minor structure inforamtion tree T.
One example of the step of updating of " root node ID " 1203 in step S1303, measurement point management information table 1200 is shown.
First, the arbitrary node ID in the node ID of the record of the node R i extracted in step S1302 is selected in measurement value table design portion 121.
Further, the node ID of child node is sequentially searched in measurement value table design portion 121 in structural information table 142 from the node ID that this is selected, and " grade " 804 recorded accordingly is subtracted 1.In addition, measurement value table design portion 121 is when detecting the node ID comprised in " this node ID " 1202 of measurement point management information table 1200, " the root node ID " of the record of this measurement point management information table 1200 is replaced with original ID, and sets this node ID selected.
Measurement value table design portion 121 is to node ID this operation repeatedly of all records extracted in step S1302.
The information adding of the minor structure inforamtion tree Ti that the operation by step S1302 ~ S1303 is carried out splitting and obtained by (step S1304) measurement value table design portion 121 is in minor structure inforamtion tree admin table 1210.
Measurement value table design portion 121 generates the record corresponding with each minor structure inforamtion tree Ti, redistributes minor structure inforamtion tree ID, and is set as " minor structure inforamtion tree ID " 1211.
Further, the node ID of the root node Ri of minor structure inforamtion tree Ti is set as " root node ID " 1212 by measurement value table design portion 121.In addition, measurement value table design portion 121 redistributes the group ID of minor structure inforamtion tree, and is set as " minor structure inforamtion tree group ID " 1213.
(step S1305) measurement value table design portion 121 checks fixed minor structure inforamtion tree, when there is fixed minor structure inforamtion tree, set up " determining to indicate " 1214 corresponding to this minor structure inforamtion tree in minor structure inforamtion tree admin table 1210.
When determined multiple minor structure inforamtion tree with identical actual measure a little or replace measuring a little be associated, " the minor structure inforamtion tree group ID " 1213 of measurement value table design portion 121 to these minor structure inforamtion trees distributes and sets identical minor structure inforamtion tree group ID.
And, even during the minor structure inforamtion tree of the minor structure inforamtion tree group that belonging to of determining is different, when be associated with these minor structure inforamtion trees actual measure a little or replace the unique quantity measured a little to be below C, measurement value table design portion 121 also can reset identical minor structure inforamtion tree group ID.
Illustrate being determined as another condition (the 3rd determines state) determining minor structure inforamtion tree in step S1305.
Even when more than one reality measurement point P is associated with multiple still undetermined minor structure inforamtion tree, by being considered as independently measuring a little by this actual measurement point P, and distributing different replacement measurement point ID, also can determine minor structure inforamtion tree.
That is, the measurement data of reality measurement point P are stored in multiple measurement value table 144 by measurement value table design portion 121.
But, in a fairly large number of situation of so actual measurement point P, will dual, that treply repeated storage is many measurement data, cause the waste of memory capacity.
Therefore, the quantity set repeatably measured a little is threshold value by measurement value table design portion 121 in advance, when the actual quantity measured a little be associated with multiple still undetermined minor structure inforamtion tree is no more than this threshold value, additional record in measurement point management information table 1200, reality measurement point P is redistributed and replaces measurement point ID, this replacement measurement point ID is set as " measurement point ID " 1201.
Meanwhile, original actual measurement point ID is set as " replacing the definition of measurement point " 1205 of this record by measurement value table design portion 121.
Further, measurement value table design portion 121 actually measures the minor structure inforamtion tree that some P are associated to this and directly determines.
By distributing different replacement measurement point ID to reality measurement point P, independently minor structure inforamtion tree can be considered as by measuring with reality the minor structure inforamtion tree that some P are associated, when these minor structure inforamtion trees meet the 1st determine that state or the 2nd determines state, this minor structure inforamtion tree can be determined.
In the example shown in Figure 25, subtree data 1101 measures with reality and a little 1 ~ 6 is associated, and subtree data 1102 measures with reality and a little 6 ~ 11 is associated.
Actual measurement point 6 is associated with subtree data 1101 and subtree data 1102 both sides.
In the example of Figure 25, the columns of a measurement value table is 8, and the actual quantity measured a little be associated with subtree data 1101 and subtree data 1102 is 11, does not thus belong to the 2nd shown in Figure 24 and determines state.
In the example of Figure 25, the actual quantity measured a little be associated with multiple subtree data does not exceed threshold value, is thus judged to be that subtree data 1101 and subtree data 1102 are all in the 3rd and determine state.
Further, actual measurement point 6 is distributed to the measurement value table of subtree data 1101 and the measurement value table both sides of subtree data 1102.
The threshold value of the quantity of actual measurement point can by user's arbitrary decision.
At this, use concrete example that the action case in measurement value table design portion 121 is described.
Figure 26 and Figure 28 illustrates the structural information tree 1131 and structural information tree 1132 that use in the following description.
To structural information tree 1131 setting group ID=1, to structural information tree 1132 setting group ID=2.
In Figure 26 and Figure 28, the node of double outline measures a little directly related node with reality.
Figure 27 is the structural information table (being equivalent to the structural information table 142 of Figure 10) of the structural information tree 1131 of Figure 26, and Figure 29 is the structural information table of the structural information tree 1132 of Figure 28.
Structural information tree 1131 and structural information tree 1132 measure some $ 1 ~ $ 15 as shown in figure 30 and are associated with reality.
Figure 31 is the imagination measurement point definition list (being equivalent to the imagination measurement point definition list 141 of Figure 12) of structural information tree 1131, and Figure 32 is the imagination measurement point definition list 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 information table of structural information tree 1132.
Figure 35 is the measurement point management information table (being equivalent to the measurement point management information table 1200 of Figure 17) of structural information tree 1131 and structural information tree 1132.
Figure 36 is the minor structure information tree table (being equivalent to the minor structure inforamtion tree admin table 1210 of Figure 18) that measurement value table design portion 121 starts to carry out before the segmentation of structural information tree 1131 and structural information tree 1132.
Below, assuming that physical size C=8, the quantity of actual measurement point (Measuring Device) that namely can store measurement value in measurement value table 144 are 8.
As shown in the S1102 of Figure 15, measurement value table design portion 121 is to make mode segmenting structure inforamtion tree 1131 and the structural information tree 1132 of below the physical size C=8 of each subtree.
Specifically, measurement value table design portion 121 is choice structure inforamtion tree 1131 (S1301 of Figure 19) such as, extracts child node and node " A02 " and " A03 " (S1302) of root node " A01 ".
Further, " grade " of node " A02 " ~ " A39 " of the temporary structure information table (Figure 33) of structural information tree 1131 is subtracted 1 (S1303) by measurement value table design portion 121.
Consequently, the temporary structure information table of structural information tree 1131 is updated as shown in figure 37.
Further, the root node ID that the root node ID hurdle in measurement point management information table (Figure 35) describes the record of " 1 " (ID of root node " A01 ") is upgraded (S1303) by measurement value table design portion 121.
Consequently, measurement point management information table is updated as shown in figure 38.
Then, the information of the subtree that measurement value table design portion 121 will be root node with node " A02 " and the information with node " A03 " subtree that is root node, add in minor structure information tree table (Figure 36) (S1304).
In addition, in this moment, the subtree being root node with node " A02 " and all not determining with the subtree that node " A03 " is root node.
Actual measure directly related with the subtree being root node with node " A02 " is a little actual measurement point 1 ~ 7, although thus physical size is 7, actual measurement point 1 ~ 7 is also set 1132 with structural information and is associated.
Therefore, the subtree being root node with node " A02 " is not in the 1st and determines state.
Structural information tree is 1132 divided in this moment, thus measures a little 1 ~ 7 structural information be associated with reality and sets 1132 and measure with reality yet and a little 8 ~ 15 be associated, be not thus in the 2nd yet and determine state.
Further, structural information tree 1132 is not in the 3rd yet and determines state.
Actual measure directly related with the subtree being root node with node " A03 " is a little actual measurement point 8 ~ 14, although thus physical size is 7, actual measurement point 8 ~ 14 is also set 1132 with structural information and is associated.
Therefore, the subtree being root node with node " A03 " is not in the 1st and determines state.
Structural information tree is 1132 divided in this moment, thus measures a little 8 ~ 14 structural informations be associated with reality and sets 1132 and measure with reality yet and a little 1 ~ 7 and 15 be associated, be not thus in the 2nd yet and determine state.
Further, structural information tree 1132 is not in the 3rd yet and determines state.
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 be only made up of root node " A01 ", determine that mark is " 1 ", but in subtree in addition, determine that mark is " 0 ".
Then, measurement value table design portion 121 choice structure inforamtion tree 1132 (S1301 of Figure 19), and child node and node " B11 " ~ " B13 " (S1302) of extracting root node " B01 ".
Further, " grade " of node " B11 " ~ " B44 " of the temporary structure information table (Figure 34) of structural information tree 1132 is subtracted 1 (S1303) by measurement value table design portion 121.
Consequently, the temporary structure information table of structural information tree 1132 is updated as shown in figure 40.
Further, the root node ID that the root node ID hurdle in measurement point management information table (Figure 38) describes the record of " 101 " (ID of root node " B01 ") is upgraded (S1303) by measurement value table design portion 121.
Consequently, measurement point management information table is updated as shown in figure 41.
Then, the information of the subtree that measurement value table design portion 121 will be root node with node " B11 " and with the information of node " B12 " subtree that is root node with the information of node " B13 " subtree that is root node, adds in minor structure information tree table (Figure 39) (S1307).
In addition, in this moment, all subtrees are determined.
It is 7 with the subtree being root node with node " A02 " and with the actual unique quantity measured a little that the subtree that node " B11 " is root node is associated, thus with node " A02 " subtree that is root node and belong to the 2nd with the subtree that node " B11 " is root node and determine state.
With the subtree being root node with node " A03 " and with node " B12 " subtree that is root node and be 8 with the actual unique quantity measured a little that the subtree that node " B13 " is root node is associated, thus with node " A03 " subtree that is root node and with node " B12 " subtree that is root node and belong 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, in all subtrees, determine that mark is " 1 ".
Then, " minor structure inforamtion tree group ID " hurdle of minor structure information tree table upgrades by measurement value table design portion 121.
Specifically, measurement value table design portion 121 upgrades the hurdle of " minor structure inforamtion tree group ID " as shown in figure 43.
Then, measurement value table design portion 121 carries out the S1103 ~ S1105 of Figure 15, but in this example, because all subtrees are determined, thus omits the process of S1103 ~ S1105.
Measurement value table design portion 121 judges whether directly comprise actual measurement point (S1106) in the imagination measurement point definition of root node.
With reference to Figure 31 and Figure 32 imagination measurement point a definition list, " A01 ", A02 as root node ", " A03 ", " B01 ", B11 ", " B12 ", " B13 " imagination measurement point definition in directly do not comprise actual measurement point (S1106: no).
Therefore, measurement value table design portion 121 is for each " A01 ", A02 ", " A03 ", " B01 ", B11 ", " B12 ", " B13 ", by replace measurement point information adding imagination measurement point definition list in (S1108).
Further, in this example, the information of all subtrees has been registered in minor structure inforamtion tree admin table, and thus the process of S1109 is omitted.
Further, because all subtrees are determined (S1110: yes), thus measurement value table design portion 121 carries out the process of S1111 ~ S1113.
The process of S1111 ~ S1113 is the same with the process illustrated with reference to Figure 16, thus in this description will be omitted.
In the stage that the process of S1113 terminates, imagination measurement point definition list is updated as shown in Figure 45 and Figure 46, and measurement point management information table is updated as shown in figure 47.
In the imagination measurement point definition list of Figure 45, add in the imagination measurement point definition of imagination measurement point ID:#1 and replaced measurement point " %1 ", replaced measurement point mark to be " 1 ".
Further, added in the imagination measurement point definition of imagination measurement point ID:#2, #3 and replaced measurement point " %2 ", " %3 ", replaced measurement point mark to be " 1 ".
Equally, in the imagination measurement point definition list of Figure 46, also added in the imagination measurement point definition of imagination measurement point ID:#101, #111, #112, #113 and replaced measurement point " %4 ", " %5 ", " %6 ", " %7 ", replaced measurement point mark to be " 1 ".
Further, in the imagination measurement point definition list of Figure 47, the record of measurement point ID:%1 ~ %7 has been added.
Replacement measurement point definition in measurement point management information table is such as derived according to the step shown in Figure 48.
Figure 48 illustrates the derivation step of the replacement point measurement point of %1.
As shown in figure 45, the replacement point measurement point of %1 corresponds to the imagination measurement point of #1, according to the definition of imagination measurement point, and #1=#2+#3, #2=#11+#12+#13, #3=#14+#15+#16.
Therefore, the replacement measurement point of %1 is #1=(#11+#12+#13)+(#14+#15+#16).
After, similarly launch each imagination measurement point according to the definition of imagination measurement point, obtain the replacement measurement point definition as shown in the most footline of Figure 48.
Above, measurement data administrator shown below is described in the present embodiment.
A () measurement data administrator has the measurement Data Collection accumulation unit of the input of the multiple measurement data measured by reason Measuring Device and stores the memory storage of measurement data, inputted measurement data be stored in any measurement value table of the multiple measurement value tables defined in memory storage.
B () Measuring Device is associated with the structural information with multilayer (set and construct).
C () measurement data administrator has the imagination measurement point definition of the measurement data for calculating imagination measurement point according to the hierarchical relational of above-mentioned structural information, and have and calculate the measurement data of imagination measurement point and the measurement data output section exported according to the measurement data stored in measurement value table and the definition of imagination measurement point.
D () measurement data administrator has the measurement value table design portion according to above-mentioned structural information and the definition of imagination measurement point structural information being divided into subtree.
E the measurement data be associated with one or more subtree of structural information and measurement value table associate by () measurement value table design portion, this corresponding informance is recorded as measurement value table design information.
F () measurement data administrator has the measurement value table definition portion defining multiple table according to measurement value table design information in memory storage.
G () measurement Data Collection accumulation unit, according to the identifier of measurement data and measurement value table design information, determines the measurement value table storing these measurement data.
And, describe following measurement value table design portion in the present embodiment: the mode in the specification limit of the data base management system (DBMS) used with the storage making the kind quantity of the measurement data be associated with the subtree of structural information be in measure data, is recursively divided into subtree by structural information.
And, describe following measurement value table design portion in the present embodiment: when one or more measurement data are associated with multiple structural information, arbitrary structural information in the structural information selecting this to be associated, and be divided into subtree repeatedly, till the quantity of the measurement data be associated with one or more subtree is in above-mentioned specification limit.
Further, measurement value table design portion as follows is described in the present embodiment.
A () structural information, to the segmentation of subtree, is be divided into the root node of tree construction and take the child node of this root node as the subtree of new root.
B () redistributes the identifier replacing measurement point to original root node, this identifier and the calculating formula that is used for calculating the measurement data that the imagination suitable with this root node measures a little are stored in measurement value table design information.
And, describe following measurement value table design portion in the present embodiment: when one or more measurement data are associated with the subtree of multiple structural information, multiple identifier replacing measurement point is distributed, by this identifier be used for the identifier of the Measuring Device obtaining original measurement data or calculating formula is stored in measurement value table design information to these measurement data.
Finally, the hardware configuration example of the measurement data administrator 100 shown in present embodiment is described with reference to Figure 44.
Measurement data administrator 100 is computing machines, and program can be utilized to realize each key element of measurement data administrator 100.
As the hardware configuration of measurement data administrator 100, arithmetic unit 1901, external memory 1902, main storage means 1903, communicator 1904 are connected with bus with input-output unit 1905.
Arithmetic unit 1901 is CPU (CentralProcessingUnit: CPU (central processing unit)) of executive routine.
External memory 1902 is such as ROM (ReadOnlyMemory: ROM (read-only memory)) or flash memory, hard disk unit.
Main storage means 1903 is RAM (RandomAccessMemory: random access storage device).
Communicator 1904 is such as NIC (NetworkInterfaceCard: network interface card).
Input-output unit 1905 is such as mouse, keyboard, display equipment etc.
Program is stored in external memory 1902 usually, is read into execution in arithmetic unit 1901 successively with the state be loaded in main storage means 1903.
Program is the function realizing illustrating as " ~ portion " (except data store, identical below) shown in Fig. 1.
In addition, also store operating system (OS) in external memory 1902, OS is loaded at least partially in main storage means 1903, and arithmetic unit 1901 performs OS, and performs the program of the function for realizing " ~ the portion " shown in Fig. 1.
And, in description of the present embodiment, the information of the result of the process illustrated as " ~ judge ", " ~ judge ", " ~ extract ", " ~ segmentation ", " ~ detect ", " ~ setting ", " ~ registration ", " ~ select ", " ~ generate ", " ~ add ", " ~ upgrade ", " ~ input ", " ~ export " etc. and/or data and/or signal value and/or variate-value will be represented, stored as a file in main storage means 1903.
Further, also can by encryption key/decruption key and/or random number and/or parameter stored as a file in main storage means 1903.
In addition, the structure of Figure 44 just illustrates an example of the hardware configuration of measurement data administrator 100, and the hardware configuration of measurement data administrator 100 is not limited to the structure shown in Figure 44, also can be other structure.
In addition, the step according to the present embodiment, can realize data processing method of the present invention.
Label declaration
100 measurement data administrators; 110 imagination measurement point management departments; 111 imagination measurement dot information input and output portions; 112 structural information input and output portions; 120 measurement Zhi Biao management departments; 121 measurement value table design portions; 122 measurement value table definition portions; 130 measurement Data Management Departments; 131 measurement Data Collection accumulation units; 132 imagination measurement data operation portions; 133 measurement data output section; 140 data store; 141 imagination measurement point definition lists; 142 structural information tables; 143 measurement value table design informations; 144 measurement value tables; 200 measurement data management systems; 201 Measuring Devices; 210 strong point devices; 211 measurement data reception portion; 212 measurement data sending parts; 219 strong point device storage parts; 220 operating terminals; 221 application enforcement divisions; 229 operating terminal storage parts; 400 measurement data; 1200 measurement point management information tables; 1210 minor structure inforamtion tree admin tables.

Claims (10)

1. a data processing equipment, it manages the tree construction data be associated with Measuring Device, and it is characterized in that, this data processing equipment has:
Data Segmentation portion, described tree construction Data Segmentation is become multiple subtree data by it, make the quantity of the Measuring Device be associated with each subtree data for show below memory device number, wherein, this table memory device number is the upper limit number that measurement value can be stored in the Measuring Device in measurement value table;
Condition adjudgement portion, whether its subtree data judging to be split by described Data Segmentation portion and obtain is in is determined state; And
Table dispenser, it is judged as being in by described condition adjudgement portion the subtree data determining state, and the measurement value table stored is carried out in point pairing from the measurement value of the Measuring Device be associated with this subtree data,
At the Measuring Device be associated with a subtree data all unconnected with other any subtree data and the quantity of Measuring Device that is that be associated with this subtree data is below described table memory device number, described condition adjudgement portion is judged as that this subtree data is in the 1st and determines state
At least one Measuring Device in the Measuring Device be associated with a subtree data is repeatedly also associated with other subtree data and total number after the quantity of the Measuring Device be associated with this subtree data and the repeating part of the quantity of Measuring Device that is associated with this other subtree data being removed is below described table memory device number, described condition adjudgement portion is judged as that this subtree data and this other subtree data are in the 2nd and determine state
Described condition adjudgement portion makes described Data Segmentation portion not be in the 1st determine that state and the 2nd determines that the subtree data of the free position in state is divided into multiple subtree data further by being judged as.
2. data processing equipment according to claim 1, is characterized in that,
At least one Measuring Device in the Measuring Device be associated with a subtree data is repeatedly also associated with other subtree data, and the total number after the quantity of the Measuring Device be associated with this subtree data and the repeating part of the quantity of Measuring Device that is associated with this other subtree data being removed exceedes described table memory device number, and the quantity of the Measuring Device be repeatedly associated with this subtree data and this other subtree data is when being below stated number, when can be judged as this subtree data and this other subtree data be in the 1st determine that state or the 2nd determines state time, described condition adjudgement portion is judged as that this subtree data and this other subtree data are in the 3rd and determine state,
Described condition adjudgement portion makes described Data Segmentation portion not be in the 1st determine that state, the 2nd determines that state and the 3rd determines that the subtree data of the free position in state is divided into multiple subtree data further by being judged as.
3. data processing equipment according to claim 1, is characterized in that,
Described data processing equipment supervisory packet contains the tree construction data of multiple node,
Described Data Segmentation portion is partitioned into the subtree data of only root node respectively and take the child node of described root node as the plural subtree data of new root node, as described multiple subtree data,
Described condition adjudgement portion makes described Data Segmentation portion that the subtree data determining state that is not in except the subtree data of only root node is divided into multiple subtree data further, until till all subtree data except the subtree data of only root node are in and determine state.
4. data processing equipment according to claim 3, is characterized in that,
Described data processing equipment manages following tree construction data, multiple nodes of the accumulative unit as measurement value are comprised in these tree construction data, and to each node definition the calculating formula that is worth for accumulative measurement, comprise in this calculating formula and to be worth directly related identifier with the measurement of Measuring Device namely actual measure point and measure with reality the identifier that a little direct or indirect correlation joins be the imaginary at least any one party measured a little
Whether the measurement point comprised in the calculating formula of the root node of the subtree data that described data processing equipment also judges to be split by described Data Segmentation portion and obtains is only actual measurement point one,
Described data processing equipment also has a replacement measurement point configuration part, the measurement point comprised in the calculating formula of described root node is not merely actual measurement point one, make replacement measure point to be associated with described root node, this replacement measurement point represents that needs carried out the identifier of the calculating be worth for accumulative measurement in advance before having accumulative instruction.
5. data processing equipment according to claim 4, is characterized in that,
Described replacement measurement point configuration part comprises imagination measurement point in the calculating formula of described root node, use and this imagination measure the actual measurement point that a little direct or indirect correlation joins, generate and only comprise actual measurement point and the replacement calculating formula that can obtain the result of calculation identical with the calculating formula of described root node
A described replacement measurement point configuration part make described replacement calculating formula with described replace measuring a little be associated.
6. data processing equipment according to claim 4, is characterized in that,
Described data processing equipment also has a replacement measurement point calculating part, this replacement measurement point calculating part is for replacing measuring with described the root node be a little associated, before having the accumulative instruction for this root node, carry out the calculating be worth for accumulative measurement in advance, make result of calculation with described replace measuring a little be associated.
7. data processing equipment according to claim 1, is characterized in that,
Described table dispenser to being judged as that by described condition adjudgement portion being in the described 1st determines that a subtree data of state distributes a measurement value table,
Described table dispenser is to being judged as that by described condition adjudgement portion being in the described 2nd determines that multiple subtree data of state distribute a measurement value table.
8. data processing equipment according to claim 2, is characterized in that,
Described table dispenser to being judged as that by described condition adjudgement portion being in the described 3rd determines that multiple subtree data of state distribute a measurement value table respectively,
Measurement value from the Measuring Device be repeatedly associated with described multiple subtree data is stored in the measurement value table of each subtree data by described table dispenser.
9. a data processing method, performed by the computing machine managing the tree construction data be associated with Measuring Device, it is characterized in that, this data processing method comprises:
Described computer implemented data dividing processing, described tree construction Data Segmentation is become multiple subtree data, make the quantity of the Measuring Device be associated with each subtree data for show below memory device number, wherein, this table memory device number is the upper limit number that measurement value can be stored in the Measuring Device in measurement value table;
Described computing machine executing state judges process, judges whether the subtree data obtained by described Data Segmentation process segmentation is in and determines state; And
Described computing machine performs table allocation process, is judged as to by described condition adjudgement process the subtree data being in and determining state, and the measurement value table stored is carried out in point pairing from the measurement value of the Measuring Device be associated with this subtree data,
In described condition adjudgement process,
At the Measuring Device be associated with a subtree data all unconnected with other any subtree data and the quantity of Measuring Device that is that be associated with this subtree data is below described table memory device number, described computing machine is judged as that this subtree data is in the 1st and determines state
At least one Measuring Device in the Measuring Device be associated with a subtree data is repeatedly also associated with other subtree data and total number after the quantity of the Measuring Device be associated with this subtree data and the repeating part of the quantity of Measuring Device that is associated with this other subtree data being removed is below described table memory device number, described computing machine is judged as that this subtree data and this other subtree data are in the 2nd and determine state
In described Data Segmentation process,
Described computing machine is not in the 1st determines that state and the 2nd determines that the subtree data of the free position in state is divided into multiple subtree data further by being judged as in described condition adjudgement process.
10. a program, is characterized in that, the computing machine of the tree construction data that management is associated with Measuring Device performs following process:
Data Segmentation process, described tree construction Data Segmentation is become multiple subtree data, make the quantity of the Measuring Device be associated with each subtree data for show below memory device number, wherein, this table memory device number is the upper limit number that measurement value can be stored in the Measuring Device in measurement value table;
Condition adjudgement process, judges whether the subtree data obtained by described Data Segmentation process segmentation is in and determines state; And
Table allocation process, is judged as to by described condition adjudgement process the subtree data being in and determining state, and the measurement value table stored is carried out in point pairing from the measurement value of the Measuring Device be associated with this subtree data,
In described condition adjudgement process,
At the Measuring Device be associated with a subtree data all unconnected with other any subtree data and the quantity of Measuring Device that is that be associated with this subtree data is below described table memory device number, described computing machine is judged as, and this subtree data is in the 1st and determines state
At least one Measuring Device in the Measuring Device be associated with a subtree data is repeatedly also associated with other subtree data and total number after the quantity of the Measuring Device be associated with this subtree data and the repeating part of the quantity of Measuring Device that is associated with this other subtree data being removed is below described table memory device number, described computing machine is judged as, and this subtree data and this other subtree data are in the 2nd and determine state
In described Data Segmentation process,
Make described computing machine not be in the 1st determine that state and the 2nd determines the subtree data of the free position in state by being judged as in described condition adjudgement process, be divided into multiple subtree data further.
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
JP2013-176173 2013-08-28
JP2013176173 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 true CN105493050A (en) 2016-04-13
CN105493050B 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)

Cited By (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN110325979A (en) * 2017-02-28 2019-10-11 得乐智能解决方案株式会社 Measure solution service provider system
CN113474737A (en) * 2019-02-14 2021-10-01 三菱电机株式会社 Management device, management system, management method, and program

Families Citing this family (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
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 (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
JP2004362574A (en) * 2003-05-30 2004-12-24 Microsoft Corp Position access using b-tree
CN102597966A (en) * 2009-11-04 2012-07-18 富士通株式会社 Operation management device and operation management method
JP2012146207A (en) * 2011-01-13 2012-08-02 Mitsubishi Electric Corp Control computer, information processing system, control method, and program
JP2013164813A (en) * 2012-02-13 2013-08-22 Canon Inc Information processor and control method of the same

Family Cites Families (1)

* 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

Patent Citations (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
JP2004362574A (en) * 2003-05-30 2004-12-24 Microsoft Corp Position access using b-tree
CN102597966A (en) * 2009-11-04 2012-07-18 富士通株式会社 Operation management device and operation management method
JP2012146207A (en) * 2011-01-13 2012-08-02 Mitsubishi Electric Corp Control computer, information processing system, control method, and program
JP2013164813A (en) * 2012-02-13 2013-08-22 Canon Inc Information processor and control method of the same

Cited By (5)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN110325979A (en) * 2017-02-28 2019-10-11 得乐智能解决方案株式会社 Measure solution service provider system
CN110325979B (en) * 2017-02-28 2024-04-16 得乐智能解决方案株式会社 Measurement solution service providing system
CN113474737A (en) * 2019-02-14 2021-10-01 三菱电机株式会社 Management device, management system, management method, and program
CN113474737B (en) * 2019-02-14 2022-07-29 三菱电机株式会社 Management device, management system, management method, and computer-readable non-transitory recording medium storing program
US11442433B2 (en) 2019-02-14 2022-09-13 Mitsubishi Electric Corporation Management device, management system, management method, and program for providing virtual and real resource information values

Also Published As

Publication number Publication date
JPWO2015029969A1 (en) 2017-03-02
SG11201600589RA (en) 2016-03-30
CN105493050B (en) 2019-03-12
JP5972472B2 (en) 2016-08-17
WO2015029969A1 (en) 2015-03-05

Similar Documents

Publication Publication Date Title
JP7434417B2 (en) Topology processing method, device, and system
US10452625B2 (en) Data lineage analysis
CN110245078A (en) A kind of method for testing pressure of software, device, storage medium and server
CN108255925A (en) A kind of display methods and its terminal of data list structure alteration
CN107733986A (en) Support the protection of integrated deployment and monitoring operation big data support platform
CN107451034A (en) A kind of big data cluster log management apparatus, method and system
CN102735485B (en) Excavator and method and system for determining equipment fault
CN107730394A (en) The polynary isomeric data fusion method of panorama power network based on big data
CN103902816A (en) Electrification detection data processing method based on data mining technology
CN105227405A (en) Method for supervising and system
CN105493050A (en) Data processing device, and data processing method and program
CN104461824A (en) Magnetic disk health information optimal management method and device
CN102096688A (en) Method and device for generating data report
CN113283096B (en) Method for acquiring distribution network line account data and analyzing abnormal data and related device
CN103714004A (en) JVM online memory leak analysis method and system
CN114398669A (en) Joint credit scoring method and device based on privacy protection calculation and cross-organization
CN113852204B (en) Transformer substation three-dimensional panoramic monitoring system and method based on digital twinning
CN103077080B (en) Based on parallel program performance collecting method and the device of high performance platform
CN106383897A (en) Database capacity calculation method and apparatus
CN104516953B (en) A kind of black box subsystem for power dispatching automation magnanimity message
CN112965990A (en) Low-voltage contact cabinet fault solution generation method and device
CN108564261A (en) Method, apparatus and computer equipment are determined based on the power information of work ticket
CN111311079A (en) Comprehensive energy-using service system for large users
JP2020052451A (en) Computer system and pattern generation method of business flow
CN114911677A (en) Monitoring method and device for containers in cluster and computer readable storage medium

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