JP5554731B2 - Information updating apparatus and information updating method - Google Patents

Description

  The present invention relates to an information updating apparatus that reflects information in a sensor information database in a relational database.

  Conventionally, there is a technique called a web framework as a technique for efficiently developing an application (web application) used from a web browser. An example of such a web framework is Ruby on Rails. Ruby on Rails is highly evaluated as a technology that dramatically improves the efficiency of Web application development. With the Web framework, it is possible to efficiently develop a Web application that dynamically generates a Web page while reading from and writing to an RDB (Relational Database).

  On the other hand, in the field of ubiquitous computing in which various sensors and actuators are arranged and operated around, a sensor information DB that provides a function of storing information from sensors as a history and then retrieving and acquiring it has been studied. As an example of such a sensor information DB (Database), there is u TupleSpace (Non-Patent Document 1). In uTupleSpace, individual sensor information is called EA, and a search expression is called EF. One of the technical features of uTupleSpace is the ability to search the EA history later by EF, and when an EF is registered in advance and a new EA is accumulated, the EF registration source receives the new arrival notification of the EA. It is mentioned that functions are integrated.

  Also, one of the technical features of uTupleSpace is a schemaless matching method in which various types of sensor information can be stored centrally and searched horizontally. In this method, individual sensor information is expressed as an array of key-value pairs such as “key name = value, key name = value,...”. This key name can be freely set by the data registrant, and does not necessarily have to be strictly uniform for each sensor information. When searching, the range of values of any number of keys from these key names can be specified as a search condition. For this reason, there exists an advantage that the versatility as sensor information DB is high.

  Non-patent document 2 points out a problem in developing a Web application that dynamically generates a Web page while reading and writing sensor information from and to such a history type sensor information DB. ing. According to this document, when developing a Web application, it is not enough to search for sensor information as a history, and it is necessary to provide each sensor individual with a function that can efficiently acquire the latest state from that sensor. .

  Non-patent document 2 discloses an elementary method for realizing such a function. That is, such a program can be configured by “using uTupleSpace in a standby mode and independently managing the latest state using a separate RDB or the like”. In the implementation, if the information handled by the program is known in advance, the previously known information is read from the EA obtained by waiting from u TupleSpace, and the previously known column of the RDB table is known in advance. Create a program that issues a SQL statement that updates. The program configured in this way operates with sufficiently high execution efficiency.

  In Non-Patent Document 2, if a sensor information DB that provides what kind of API (Application Program Interface) is provided when the information handled by the program is not known in advance, the Web application can be easily obtained. It shows how it can be developed. According to it, if there is the following API “Definition 3”, even if the information handled by the program is not known in advance, while maintaining the advantage of high versatility brought to the sensor information DB by the schemaless matching method, It is disclosed that the necessary information acquisition function can be satisfied.

Definition 3 For a function N that obtains “the latest state of each individual object at the present time”, an object identification function having all u Tuple spaces as W, and a search condition A⊂W, a search object R⊂W, and S as domains of definition When F is satisfied and S⊃ (R∩U) is satisfied for all u Tuple sets U⊂W being accumulated,
Nu (A, R, F) = {vi} ∩A;
∃i∈I vi = newest ({b∈R∩U | F (b) = i})
Define as follows. This gives a theoretical definition for the latest state of the object.

“Design and implementation of a new uTupleSpace that enables storage and retrieval of large amounts of schemaless data”, Keiichiro Kashiwagi et al., Multimedia, Distributed, Collaboration and Mobile (DICOMO2010) Symposium, July 2010 “Latest state of sensor information history accumulation”, Takayuki Nakamura et al., IEICE Society Conference, September 2009

  In Non-Patent Document 2, an API having high versatility required for application development has been theoretically proposed, but its execution efficiency has not been mentioned. Specifically, the high execution efficiency of the program configured by “using the uTupleSpace in the standby mode and managing the latest state separately using RDB etc.” is as high as the execution efficiency. However, there has been a problem that an API implementation method that can provide such high versatility is not mentioned.

  As one of methods for realizing the API, it is conceivable to implement the expression as a program according to the meaning of the expression. However, in that case, that is, every time an information acquisition operation is performed, all the sensor information held in the sensor information DB is scanned once, and a process of obtaining a result that satisfies the condition of the formula is performed. Therefore, there has been a problem that the execution efficiency of this implementation method remains extremely low.

  On the other hand, the functions required for application development described above are provided by using a program that is configured by “using uTupleSpace in standby mode and independently managing the latest state using RDB etc.” A way to do this is conceivable. However, as described above, this method cannot be applied unless the information handled by the program is known in advance. Accordingly, when developing another type of application, it is necessary to recreate the program again, which causes a problem of significant reduction in development efficiency.

  In view of the circumstances described above, the object of the present invention is to have a high versatility conforming to the schemaless matching method for the history type sensor information DB, and for each sensor individual, the latest state from the sensor is displayed. It is to provide a function that can be acquired efficiently.

  In order to achieve the above object, the information updating apparatus and information updating method of the present invention is directed to a history type sensor information DB conforming to the schemaless switching method, uses uTupleSpace in a standby mode, and uses a separate RDB. In the device that acquires the latest information of each sensor, the operation when acquiring the sensor information in the RDB is customized by the definition file based on the theoretical expression of “Definition 3”.

Specifically, the information updating apparatus of the present invention is an information updating apparatus, and includes a definition formula including at least a search formula, target object identification information, information on an update target table, and column correspondence information from a predetermined reading destination. When the sensor information including at least a plurality of combinations of key names and values is registered and the sensor information matches the registered search formula, the matched sensor is read. When the sensor information is transmitted from the sensor information DB to the sensor information DB that transmits information to the registration source of the search formula, the search formula registration function that registers the search formula included in the definition formula, and the sensor information DB receives the sensor information. A value corresponding to the key name that matches the object identification information included in the definition formula is extracted from the list, and the object identification information is identified based on the column correspondence information included in the definition formula. The key name is converted to the column names in the update target table included in the definition formula, the target row identified by the column name definitive to update target table, the update operation that updates at the extracted value RDBMS (Relational DataBase Information update function issued to Management System),
Have

In the information updating apparatus of the present invention, the defining equation includes at least the update limitation information to limit the column to further update the information update function, included in the Oite the update operation, the update restriction information issued to RDBMS an update of the column to only may indicate finger to be.

In the information updating apparatus of the present invention, queries the sensor information from the time the specified process start up current to the sensor information DB, the resulting sensor information of the query, the object identification to the update target table the update operation of the target row identified by the information may further have a rewind function is issued to the RDBMS.

Specifically, the information update method of the present invention is an information update method, and a definition formula including at least a search formula, object identification information, update target table information, and column correspondence information from a predetermined reading destination. After the definition formula reading procedure , and after the definition formula reading procedure, sensor information including at least a plurality of combinations of key names and values is registered, and the sensor information matches the registered search formula. In this case, a search formula registration procedure for registering a search formula included in the definition formula for the sensor information DB that transmits the matched sensor information to the registration source of the search formula, and after the search formula registration procedure, When the sensor information is received from the sensor information DB, a value corresponding to the key name that matches the object identification information included in the definition formula is extracted from the sensor information and included in the definition formula. It converts the key name that matches the object identification information on the basis of the column corresponding information in the column names in the update target table included in the definition formula, a target row identified by the column name definitive to the update target table And an information update procedure for issuing an update operation for updating with the extracted value to an RDBMS (Relational DataBase Management System) .

The information updating method of the present invention, the defining equation may further comprise at least an update limitation information to limit the column to be updated, included in the information in the update procedure, Oite the update operation to be issued to the RDBMS, the update restriction information an update of the column to only may indicate finger to be.

Processing the information updating method of the present invention, during the defining equation reading procedure and the search expression registration procedure or the search expression registration procedure simultaneously, or during the search expression registration procedure and the information update procedure, designated inquiry from the start sensor information to date on the sensor information DB, the resulting sensor information of the query, RDBMS update operations of the target row identified by the object identification information to the update target table There may be further provided a rewinding procedure to be issued.

  The program of the present invention includes the definition formula reading procedure, the search formula registration procedure and the information update procedure of the information update method of the present invention, or the definition formula read procedure, the search formula registration procedure, the information update procedure and the A program for causing a computer to execute a rewinding procedure.

  The above inventions can be combined as much as possible.

  According to the present invention, the history type sensor information DB has a high versatility that conforms to the schemaless matching method, and realizes a function that allows each sensor individual to efficiently acquire the latest state from the sensor. can do.

1 shows a configuration of the entire system in the present embodiment. The sensor information (221) stored in uTupleSpace (104) is shown. A table held by the RDBMS (103) is shown. The definition file (107) which an information update apparatus (102) reads at the time of starting is shown. The standby search expression that the information updating apparatus (102) registers at the time of activation is shown. Sensor information (261) that the sensor (106) additionally registers in the uTupleSpace (104) is shown. An information update processing procedure of the information update apparatus (102) is shown. An example (281) of the generated SQL sentence is shown. The table which RDBMS (103) hold | maintains as a result of the information update apparatus (102) updating information according to sensor information (261) is shown.

  Embodiments of the present invention will be described with reference to the accompanying drawings. The embodiments described below are examples of the present invention, and the present invention is not limited to the following embodiments. In the present specification and drawings, the same reference numerals denote the same components.

First, outline the basic ideas.
The basic idea of the present invention is that the operation of the above-mentioned “Definition 3” of Non-Patent Document 2 is described for the above-described program that uses “uTupleSpace in standby mode and independently manages the latest state using RDB or the like”. It is to be customizable by a definition file based on a theoretical formula.

  In general, if the behavior of a program having a fixed function can be customized by a definition file, it is natural that the versatility increases accordingly. However, as long as the part that can be customized is designed on the fly, the versatility can be improved only on the fly, and cannot be balanced with the high versatility of the schemaless matching method. In the present invention, high versatility is obtained by using the theoretical formula, which has been proposed for high versatility, as a basis for designing the customizable portion.

  Furthermore, in the present embodiment, the three arguments A, R, and F required by the theoretical API in the theoretical formula are not all made as customizable portions of the program as they are, but the above-mentioned including the program is included. Based on the structure of the entire Web application, the functions of the three arguments A, R, and F are arranged and arranged. Specific functional arrangement in the present embodiment will be described below. Thereby, it is possible to avoid an excessive increase in the number of customizable portions of the program, which leads to a reduction in the scale of the program, and it is possible to reduce the development period and maintenance cost of the program.

  Furthermore, in the present invention, only the sensor information obtained while the program is running is processed, and information in other periods is leaked from the sensor information acquisition target from the application, and versatility is impaired. In order to deal with this problem, it is assumed that the program has a function for rewinding past sensor information to be processed. Thereby, it becomes possible to avoid the problem of the target leakage.

  In the present embodiment, an apparatus configuration method based on the above basic concept is shown below. As a result, the above-described known two methods are not simply combined, and a remarkable effect is achieved.

  FIG. 1 shows the configuration of the entire system in the present embodiment. A Web server apparatus (101), an information update apparatus (102), an RDBMS (103), an uTupleSpace (104), and a sensor (106) are connected to the network (105). Each of these apparatuses connected to the network has a communication function, but details of the communication function are omitted in this embodiment.

  The information update apparatus (102) according to the present embodiment includes a definition formula reading function, a search formula registration function, an information update function, and a rewind function. The information update method according to this embodiment includes a definition formula reading procedure, a search formula registration procedure, and an information update procedure in this order.

  Further, the definition file (107) read by the information updating apparatus (102) is arranged at a predetermined reading destination. Here, the predetermined reading destination is not limited. The predetermined reading destination may be, for example, an arbitrary folder of the information update device (102) accessible from the outside, or an arbitrary server accessible from the information update device (102). Any database such as a registry database may be used. In this embodiment, the case where the definition formula is the definition file (107) will be described. However, when the predetermined reading destination is an arbitrary database, the definition formula is a row or value stored in the arbitrary database. It is also possible.

  The Web server apparatus (101) receives a request from the Web browser, performs an HTML generation process while exchanging data with the RDBMS (103), and returns it to the Web browser. Such systems are widely manufactured and can be easily implemented by those skilled in the art using, for example, a web framework technology such as Ruby on Rails.

  The sensor (106) has “A” as an identifier and includes temperature and humidity sensors.

  FIG. 2 shows sensor information (221) stored in uTupleSpace (104). Individual sensor information in uTupleSpace is represented by a set of “key = value” as shown in the figure, and is stored in time series. In the uTupleSpace terminology, each piece of sensor information is referred to as EA.

  In the figure, for example, line 222 is information from the sensor (106) with the identifier A, the meter reading date and time is 14:00:00 on December 24, 2010, the registration date and time is 14:03 on December 24, 2010, The data type is sensor, the message type is composite (hybrid), the value 1 or temperature is 21.3 degrees, and the value 2 or humidity is 60%. A difference of several minutes between the meter reading date and time and the registration date and time indicates that a communication delay to the server via the wireless network or the like has occurred.

  For example, line 223 is information from the sensor with the identifier A, the meter reading date and time is 16:10 on December 24, 2010, the registration date and time is 16:13 on December 24, 2010, the data type is sensor, The message type is temperature only, indicating that the value is 1, that is, the temperature is 21.8 degrees. In this example, due to some malfunction of the sensor (106) at 16:00, the temperature sensor does not function at 16:00 and only the humidity information is first stored in the uTupleSpace (104). Measurement is performed and only the temperature information is stored in the uTupleSpace (104) this time. In this way, when temperature and humidity are not registered at the same time, for example, for an application that analyzes the correlation between temperature and humidity, it is assumed that data at 16:00 is unsuitable for analysis and should be ignored. Is done.

  FIG. 3 shows a table held by the RDBMS (103). The RDBMS maintains a table “current_sensors” (231). The table “current_sensors” (231) stores data indicated by columns “address”, “sensor_date”, “temperature”, and “humidity”.

Hereinafter, the operation of this system will be described step by step.
First, the operation when the system is started will be described. The definition formula reading procedure is performed at system startup. In the definition formula reading procedure, for example, the information updating apparatus (102) reads the definition file (107) using the definition formula reading function.

  FIG. 4 shows a definition file (107) that is read by the information updating device (102) at startup. The first line “query1” indicates that a declaration of a series of definition blocks (groups) is to be started. In the present embodiment, an example in which only one operation of the information updating apparatus (102) is defined by the definition file (107) is shown. The scope of the present invention is not limited to this, and a plurality of definition blocks are listed in the definition file (107), and the information update device (102) performs a plurality of operations defined by the plurality of definition blocks. May be performed in parallel.

The second line “EF:” in the definition file (107) indicates a standby search expression.
The third line “IDENT:” in the definition file (107) indicates object identification information.
The fourth line “TABLE:” in the definition file (107) indicates update target table information.
The fifth line “COLMAP:” in the definition file (107) indicates column correspondence information.
“UPDATE:” on the sixth line of the definition file (107) indicates update limitation information.
The method of using these pieces of information will be shown below in order.

  FIG. 5 shows a standby search expression that the information updating apparatus (102) registers at the time of activation. When the system is activated, in the retrieval formula registration procedure after the definition formula reading procedure, the information updating apparatus (102) registers the EF indicated by 251 in the uTupleSpace (104) as a standby retrieval formula. Here, in the (current date and time) portion, the date and time at the time of performing the registration process is embedded as a numerical value. For the other parts, the contents described in the standby search expression definition of the definition file (107) are used. Expression 251 includes the key “msg_kind”, its value is “hybrid”, includes the key “type”, its value is “sensor”, includes the key “date”, and This means that an EA that matches a condition whose value is equal to or later than “(current date and time)” is searched. When the uTupleSpace (104) receives the EF (251), it enters a standby state thereafter.

Next, an operation when new sensor information is generated will be described.
FIG. 6 shows an EA (261) that the sensor (106) additionally registers in the uTupleSpace (104). In this example, a sensor (106) having an identifier of A is a meter reading date and time at 18:00:00 on December 24, 2010, a data type is a sensor, a message type is composite (hybrid), a value of 1, that is, a temperature is 22 .2 degrees, value 2 or humidity is 65%, indicating that it was registered with the server at 18:03 on December 24, 2010. The sensor information is registered in uTupleSpace (104) as EA.

  The uTupleSpace (104) adds the EA to the list of sensor information held inside, and checks whether there is a matching EF among the waiting EFs. If there is a match, the EA To the EF registration source. In this example, since EA (261) matches EF (251), EA (261) is transmitted to the information update device (102).

  FIG. 7 shows an information update procedure of the information update device (102). When the EA (261) is received from the u TupleSpace (104) (procedure 271), first, information for identifying the sensor is extracted from the EA (procedure 272). In the present embodiment, since “address” is described in the object identification information of the definition file (107), a value “A” corresponding to the key “address” of EA (261) is extracted.

  Next, the key name of EA (261) is converted into the column name of RDB (procedure 273). In the present embodiment, since “temperature = value01, humidity = value02” is described in the column correspondence information of the definition file (107), the key “value01” is replaced with the column name “temperature”, and the key “ “value02” is read as the column name “humidity”. In addition, in the example of EA (261), which is not described in the column correspondence information, for the address, date, msg_kind, sensor_date, and type, the key name is used as it is as the column name.

  Next, only column data to be updated to the RDB is extracted (procedure 274). In the present embodiment, “sensor_date, temperature, humidity” is described in the update limitation information of the definition file (107), so the column name “sensor_date”, the corresponding value “2010122241800”, and the column name “temperature”. And the value “22.2” corresponding to the key “value01” before conversion of the column, the column name “humidity”, and the value “65” corresponding to the key “value02” before conversion of the column are extracted. To do.

  Next, an SQL statement for performing a database update operation is generated (procedure 275). In the present embodiment, since “current_sensors” is described in the update target table information of the definition file (107), the update target table name is current_sensors, and the row according to the target object identification information is the update target. Then, an SQL statement for rewriting the extracted data is generated.

  FIG. 8 shows an example (281) of the generated SQL sentence. In this example, the description is written in Japanese (pseudo programming language) for ease of understanding. It is easy for those skilled in the art to replace this with an original English SQL statement.

Finally, a database update operation is performed by issuing the SQL statement to the RDBMS (103) (procedure 276).
This completes the information update procedure.

  FIG. 9 shows a table held by the RDBMS (103) as a result of information updating by the information updating device (102) according to the EA (261). A line 292 indicates a record whose information has been updated.

  The RDB table “current_sensors” (291) updated by the above-described procedure can be easily read by the Web server device (101), and the data can be used for HTML creation in the Web browser. For example, when a Web framework technology such as Ruby on Rails is used, an inquiry to the RDBMS by SQL can be easily described, so that a program in the Web server device (101) can be easily created.

  In addition to the above, the information updating apparatus (102) has a rewind function that accepts a designation at the start of processing by an option designation at the time of activation. The process start time is a time point when the process starts, for example, a date and time. Hereinafter, the rewinding procedure using the rewinding function will be described.

  When this processing start time is designated, the information updating device (102) starts the designated processing instead of the “(current date and time)” portion of the EF (251) registered in the uTupleSpace (104) at the time of activation. Embed time. As a result, the TU from the designated process start time to the present time is inquired of the uTupleSpace (104). Here, at the start of processing, the information update device (102) may be designated in advance, or may be acquired when the information update device (102) is activated. When acquiring at the time of starting of an information update apparatus (102), the program which reads the process start time as an argument is executed, for example.

  When the uTupleSpace (104) receives an EF with the current process start time specified as the EF date key, it returns all EAs that have a date from the start of the process to the present and that match the EF. After that, an operation of entering a new EA standby is performed. As a result, the information updating apparatus (102) can rewind and receive EA while the information updating apparatus has not been activated, so that it is shown in FIG. 7 described in the information updating function described above. The processing procedure from the procedure 271 to the procedure 276 can also be applied to the EA, and sensor information in such a period can be processed.

This completes the rewinding procedure.
In addition, the timing which performs a rewinding procedure is arbitrary. For example, the rewinding procedure may be started after the definition formula reading procedure, and the rewinding procedure may be terminated after the search formula registration procedure.

  In the present embodiment described above, in order to realize a function that can efficiently acquire the latest state from the sensor for each sensor individual while having a high versatility conforming to the schemaless matching method, it is not patented. The following describes how the three arguments A, R, and F of the API “Definition 3” shown in Document 2 are arranged.

  Of the arguments of the API, it is shown in the literature that F is an object identification function. As described above, in the present embodiment, the object identification is performed using the object identification information, that is, the value of the key indicated by “IDENT:” in the definition file (107). That is, the argument F describes corresponding information in the definition file (107).

  Non-patent document 2 shows that A is a search condition and R is a search target among arguments of the API. These two arguments have a similar function in the sense that the search range is narrowed down, but from the definition definition of Definition 3, R performs a search operation as preprocessing for the latest state calculation for all data in the sensor information DB. I can read what to do.

  As described above, in the present embodiment, the search operation as the pre-processing for the latest state calculation is performed using the standby search formula, that is, the value of the search formula indicated by “EF:” in the definition file (107). . That is, the argument R describes corresponding information in the definition file (107).

  Among the arguments of the API, A can be read from the definition definition of Definition 3 as a search operation that sifts the target data after the latest state is calculated. As described above, in the present embodiment, the latest result calculation result is directly reflected as rewriting of the RDB table.

  In other words, the process corresponding to the sieve operation after the latest state calculation is performed by the program part that reads the table, that is, in the above example, for example, the program in the Web server apparatus (101), for example, using Ruby on Rails to the RDBMS (103) It can be described in the part that makes an inquiry by SQL. That is, the argument A describes the corresponding information as a program in the Web server device (101).

  As described above, in the present embodiment, along with the API “Definition 3” shown in Non-Patent Document 2, the three arguments A, R, and F are transferred to the definition file (107) and the Web server device (101). ) Place them as a program in (). As a result, it is possible to avoid an excessive increase in customizable locations of the information updating device (102), leading to a reduction in the scale of a program for operating the device, and reducing the development period and maintenance cost of the program. Can do.

  For reference, an effect obtained by specifying the arguments A and R for narrowing down the search range as two arguments instead of a single argument among the three arguments of the API will be described below using a specific example. Here, the case where EA (261) in FIG. 6 is added to the sensor information (221) in FIG. 2 is taken as an example.

  Here, it is assumed that a list of sensors whose humidity is in the range of 40% to 60% is displayed as an assumption of the application. In this case, since the sensor with address = C is the latest information and value02 = 40, it satisfies the condition. On the other hand, since the sensor with address = B is the latest information and value02 = 35, it does not meet the condition and is excluded from the display target of the application.

  If the sensor of address = A includes information of msg_kind = humally, the latest information is value02 = 50 in the state of FIG. However, when EA (261) is added, value02 = 65 with the latest information, so the condition is not met and the application is not displayed.

  When attempting to realize the above operation, first, it is assumed that A cannot be specified as an argument for narrowing the search range, and only R can be specified. Here, it is assumed that a keyword meaning humidity = 40% to 60% is included in the search condition for R.

  As described above, the condition is registered as EF in uTupleSpace (104). Then, before the EA (261) is added, since the table “current_sensors” of the RDBMS (103) is an argument on the assumption that msg_kind = humationally is included in the above example, the humidity of the row where address = A is included. Should hold 50 as the latest value.

  At this time, it is assumed that the EA (261) is registered by the sensor (106). Since the EA has a value of 65% in humidity, it does not match the EF, and therefore is not transmitted to the information update device (102). For this reason, the information updating device (102) cannot rewrite the table “current_sensors” of the RDBMS (103), and the address = A row of the table is maintained as the old information.

  Therefore, when the application reads the table “current_sensors” of the RDBMS (103) for information display, the old information is read out as it is, so that the sensor is erroneous information as if the humidity is still 50%. Will be displayed. As described above, assuming that A cannot be specified as an argument for narrowing the search range and only R can be specified, a function required by the application cannot be realized.

  On the other hand, when trying to realize the above operation, it is assumed that R cannot be specified as an argument for narrowing the search range, and only A can be specified. In this case, if R cannot be specified, it means that it is not possible to narrow down the conditions for the EF registered by the information updating apparatus (102), so all EAs registered in the uTupleSpace (104) It is transmitted to the information update device (102). In uTupleSpace (104), not only the information of the sensor focused on in this application but also various sensors are connected to accumulate information, so that the information update device (102) receives all the information of these various sensors. Thus, the processing load becomes enormous.

  Unlike these cases, in the present embodiment, A and R can be specified separately as arguments for narrowing the search range, so that the above-described problems can be solved and functions required by the application can be realized. The effect that the processing load can be reduced is obtained.

  In the present embodiment, uTupleSpace is used as the sensor information DB. The scope of the present invention is not limited to this, and the sensor information DB may be configured by using another storage device or DB device that provides a function of accumulating information history and obtaining it later. .

  Moreover, each function of the information update device in the present embodiment is an example when the sensor information DB is u TupleSpace, and is not limited to the function of the present embodiment. That is, the information updating apparatus of the present invention executes each function according to the specification of the sensor information DB. For example, in the explanation of the sensor information inquiry of the rewind function, the current date and time of the EF used in the search expression registration function is rewritten at the start of processing, but the present invention is not limited to this. If it is a sensor information DB that separately provides an API that inquires about accumulated sensor information and an API that requests reception of future sensor information notifications, an API different from the search expression registration function is used in the rewind function. Use. In this case, the two APIs are called sequentially or simultaneously, a procedure for inquiring past sensor information in the rewinding procedure is performed, and a retrieval formula registration procedure for receiving future sensor information is performed simultaneously with the procedure or after the procedure. You may go.

  The sensor information referred to in the present invention is not limited to the value measured by the sensor device, but may be information handled by the sensor information DB. In particular, it may be metadata indicating the characteristics and state of the sensor, or information acquired via, for example, the Web or the Internet other than the sensor.

  In the present embodiment, an example of realizing a Web server function accessed from a Web browser is shown. The scope of the present invention is not limited to this, and can be widely applied to the development of applications that read and write the sensor information.

  The information updating apparatus of the present invention can be realized by a computer and a program, and can be recorded on a recording medium or provided through a network.

  The present invention can be used in the information communication industry.

101: Web server apparatus 102: Information update apparatus 103: RDBMS
104: u TupleSpace
105: Network 106: Sensor 107: Definition file

Claims (7)

An information update device,
A definition expression reading function for reading a definition expression including at least a search expression, object identification information, information of an update target table, and column correspondence information from a predetermined reading destination ;
When sensor information including at least a plurality of combinations of key names and values is registered and the search information matches the search formula in which the sensor information is registered, the matching sensor information is registered in the search formula registration source. A search expression registration function for registering a search expression included in the definition expression for the sensor information DB to be transmitted to
When the sensor information is received from the sensor information DB, a value corresponding to the key name matching the object identification information included in the definition formula is extracted from the sensor information, and the column correspondence information included in the definition formula is extracted. the converted to the column name in the update target table, the target row identified by the column name definitive to the update target table, extracted values contained a key name that matches the object identification information to the definition formula, based on An information update function for issuing an update operation to be updated to RDBMS (Relational DataBase Management System);
An information updating apparatus characterized by comprising: The information update device according to claim 1 ,
The defining equation includes at least the update limitation information to limit the column for further updates,
The information update function, information updating apparatus according to the Oite the update operation, wherein the fingers view the updating of the column only to that contained in the update-limiting information to be issued to the RDBMS. The information update device according to claim 1 or 2 ,
Inquiry from the time of the specified processing start sensor information to date on the sensor information DB, the resulting sensor information of the query, the target row identified by the object identification information to the update target table An information update apparatus further comprising a rewind function for issuing an update operation to the RDBMS. An information update method,
A definition formula reading procedure for reading a definition formula including at least a search formula, target object identification information, update target table information, and column correspondence information from a predetermined reading destination ,
After the definition formula reading procedure, when sensor information including at least a plurality of combinations of key names and values is registered, and the sensor information matches the registered search formula, the matched sensor A search formula registration procedure for registering a search formula included in the definition formula with respect to the sensor information DB that transmits information to the registration source of the search formula;
When the sensor information is received from the sensor information DB after the search formula registration procedure, a value corresponding to the key name matching the object identification information included in the definition formula is extracted from the sensor information, converts the key name that matches the object identification information on the basis of the column corresponding information contained in the definition formula column names in the update target table included in the definition formula are identified in column names definitive in the update target table An information update procedure for issuing an update operation for updating a target row with an extracted value to an RDBMS (Relational DataBase Management System) ;
An information updating method characterized by comprising: The information update method according to claim 4 ,
The defining equation includes at least the update limitation information to limit the column for further updates,
In the information updating procedure, the Oite the update operation, the information updating method updates the column only to that contained in the update limit information and wherein the finger Shimesuru issuing the RDBMS. An information updating method according to claim 4 or 5 ,
Between the definition formula reading procedure and the search formula registration procedure, or simultaneously with the search formula registration procedure, or between the search formula registration procedure and the information update procedure ,
Inquiry from the time of the specified processing start sensor information to date on the sensor information DB, the resulting sensor information of the query, the target row identified by the object identification information to the update target table An information update method , further comprising a rewind procedure for issuing an update operation to the RDBMS. The defining equation read instructions on how to update information according to any one of claims 4 to 6, wherein the search expression registration procedure and the information update procedure, or the defining equation reading procedure, the search expression registration procedure, the information update Procedure and rewind procedure
A program that causes a computer to execute.

Images