JP2013201862A - Backup system, backup method, and database - Google Patents

Abstract

PROBLEM TO BE SOLVED: To provide a backup system and a backup method.SOLUTION: In the backup system configured by including a regional information management device and a home information management device, a part of information stored in a database included in the home information management device is matched with a part of information stored in the database included in the regional information management device, so that the regional information management device and the home information management device mutually recover information.

Description

  The present invention relates to a backup system, a backup method, and a database.

  Traditionally, countries, companies, households, and the like have been in the position of consumers who use energy sent from power companies and gas companies. However, nowadays, with the spread of renewable energy, consumers tend to be in a position to create and supply energy, and this trend seems to accelerate more and more in the future.

  On the other hand, since renewable energy is greatly affected by the environment, there is a problem that it is difficult to stably supply energy. In response to this issue, attention has been focused on smart grids that use information technology to manage the overall energy and to stabilize the entire energy level even if each renewable energy fluctuates.

  In addition, since the smart grid can manage the entire energy, it has attracted attention because it can detect failures early and strengthen preventive maintenance, and many researches, developments, and demonstration experiments have been conducted. Yes.

  On the other hand, consumers are expected to be able to use advanced energy that leads to carbon dioxide reduction by installing smart meters that manage energy consumption in OA equipment, home appliances, and electric vehicles. For example, if you select energy with low carbon dioxide emissions and charges from multiple energies, or if the power supply is tight, such as during the daytime on a hot day, increase the temperature of the air conditioner or power supply for low-priority equipment And cutting off.

  In addition, it becomes possible to provide information services such as equipment maintenance, medical care and nursing care in addition to advanced energy use by grasping such information.

  Regarding the method for managing the entire energy, Non-Patent Document 1 and Non-Patent Document 2 are disclosed as prior art documents.

  First, in Non-Patent Document 1, in-home device information possessed by the in-home device (101a) to the in-home device (101f) or the like, that is, in-home device information such as power consumption, operation state, and sensor value is stored in the regional information management device (103). An outline of the flow of in-house device information until it is stored in a database included in is disclosed.

FIG. 1 shows the flow of home appliance information in the regional information management system (100).
According to FIG. 1, the regional information management system (100) includes a service provider server (104a) to a service provider server (104c), etc., a regional information management device (103), and a home information management device (102a). The information management device (102C) and the like are connected via a network (NT), and the home information management device (102a) and the home device (101a) to the home device (101f) and the like are connected via an electric communication line. It has been configured.

  Further, in the home information management device (102b), the home information management device (102c), etc., the home devices are connected via an electric communication line as in the case of the home information management device (102a). The relationship between the device (102a) and the home device (101a) to the home device (101f) is the same as the relationship between the home information management device (102b), the home information management device (102c) and the home device. Therefore, the home appliances connected to the home information management device (102b) and the home information management device (102c) are omitted.

  According to FIG. 1, first, from the home device (101a) to the home device (101f), etc., the home device information is transmitted to the home information management device (102a) via the telecommunication line.

  Next, the home information management device (102a) receives the home device information transmitted from the home device (101a) to the home device (101f), etc., and has received the home information received in the database provided in the home information management device (102a) Accumulate device information.

  Next, from the home information management device (102a) to the home information management device (102c), etc., the home device information stored in the database is transmitted to the regional information management device (103).

  Next, the area information management device (103) receives the in-home device information transmitted from the in-home information management device (102a) to the in-home information management device (102c), etc., and the database provided in the area information management device (103) Stores received home device information.

  Next, in response to a request for home device information from the service provider server (104a) to the service provider server (104c), the regional information management device (103) stores the home device information stored in the database. The in-home device information is transmitted to the requested service provider server.

  Next, Non-Patent Document 2 discloses an example of a method for backing up information contained in a database.

  According to Non-Patent Document 2, the backup device is roughly composed of two backup devices. One is a backup device that backs up all the information stored in the database at once, and one is a comparison between the backed up information and the information stored in the database. It is a backup device that additionally backs up only the information that has not been backed up among the stored information.

  On the other hand, since the two backup devices target a large amount of information, both backup devices are large-scale.

“Interim report on study activities on smart house information utilization infrastructure”, Japan Information Economy and Society Promotion Association "Oracle Backup / Recovery Practice Techniques", Soft Research Center

Hereinafter, the problems of the present invention will be described.
Non-Patent Document 1 discloses an overview of the flow of home device information until the home device information of the home device is transmitted to the service provider via the home information management device and the regional information management device. Yes. The flow of in-home device information in the present invention is also approximately the same.

  Considering that the regional information management device disclosed in the non-patent document 1 includes the backup device disclosed in the non-patent document 2, the backup device included in the regional information management device is very Expect to be big.

  Therefore, in the present invention, a backup system, a backup device, and a backup in which the size of the backup device provided in the regional information management device is reduced by substituting the home information management device for a part of the backup device provided in the regional information management device. Provide a backup method using a device.

  In addition, a method is also provided in which the database included in the regional information management device and the database included in the home information management device enable information recovery from each other.

  According to one aspect of the present invention, there is provided a backup system that includes a home information management device and a regional information management device, and uses the information stored in the database 1 provided in the home information management device to use the local information. When recovering the database 2 included in the management device, the regional information management device is included in an information request table included in the regional information management device configured to include a set of an identifier of the home information management device and an information request code. An information request unit that changes the information request code to one that has not been used in the past, and the home information management device includes an identifier of the home information management device and the information request table included in the regional information management device. Before the information request code included in the set in which the identifier of the included home information management device matches is included in the home information management device When the information request code is different from the information request code, the in-house information management device stores the in-house information 3 that is a part of the database 1 provided in the in-house information management device and the database 2 provided in the area information management device. A function for transmitting recovery information 1 including a location for storing home information 3 to the regional information management device, and the information request code of the home information management device. And a function for changing to the information request code included in the set that matches the identifier of the in-home information management device included in the information request table included in the area information management device. The regional information management device includes a communication unit 3 having a function of receiving the recovery information 1 transmitted from the home information management device; and the recovery information 1 The home information 3 included in the recovery information 1 is stored in the database 2 included in the regional information management device based on the location where the home information 3 is stored in the database 2 included in the local information management device included. A backup system characterized by having an information recovery unit 1 is provided.

A backup system further including a home device, wherein the home device includes home device identifiers, measurement item identifiers, measurement times, and measurement values related to the home device. Are acquired at predetermined time intervals as in-home device information 1, and the in-home device information 1 acquisition unit for acquiring the in-home device information 1 and the timing at which the measured value changes significantly The home device information 2 is acquired as the home device information 2, and the home device information 2 acquiring unit for acquiring the home device information 2 and the acquired home device information 1 and the home device information 2 are determined in advance. A communication unit 1 for transmitting to the management device, wherein the home information management device receives the home device information 1 and the home device information 2 transmitted from the home device. Stored in the database 1 provided in the home information management apparatus, the database 1 that stores the home device information 1 and the home device information 2 of the home device The home information 1 is obtained by acquiring home information including the home information management device identifier, the home device information 1 and the group identifier at predetermined time intervals. A home information 1 acquisition unit that acquires the home information 2 using the home information acquired at a timing when the home information has changed significantly as home information 2 The communication unit 2 further has a function of transmitting the acquired home information 1 and the home information 2 to the predetermined regional information management device, The information management device stores the communication unit 3 further having a function of receiving the home information 1 and the home information 2 transmitted from the home information management device, and the home information 1 and the home information 2 The database 2 may be included.

  When the database 1 provided in the home information management device is recovered using information stored in the database 2 provided in the regional information management device, the home information management device provides information to the local information management device. The communication unit 2 further having a function of transmitting a request signal, wherein the area information management device receives the information request signal transmitted from the home information management apparatus, and the predetermined area information. The recovery information 2 including home information 3 which is a part of the database 2 included in the management device and a place where the home information 3 is stored in the database 1 included in the home information management device. The communication unit 3 further having a function of transmitting to the information management device, and the communication unit 2 is transmitted from the regional information management device. The home information management device further has a function of receiving recovery information 2, and the home information management device is configured to store the home information 3 in the database 1 included in the home information management device included in the recovery information 2. And an information recovery unit 2 that stores the home information 3 included in the recovery information 2 in the database 1 provided in the home information management apparatus.

  According to another aspect of the present invention, there is provided an information backup method in an area information management system including an area information management device, an in-home information management device, and an in-home device, wherein the in-home device is the in-home device. In-house device information 1 including home device information including an identifier of a home device, an identifier of a measurement item, a measurement time, and a measurement value, which is acquired at predetermined time intervals, is used as the home device information. A first step of acquiring information 1, a second step of acquiring the in-home device information 2 using the in-home device information acquired at the timing when the measured value has changed significantly as the in-home device information 2; Performing the third step of transmitting the in-home device information 1 and the in-home device information 2 to the predetermined in-house information management device, and The apparatus includes a database 1 for storing the home device information 1 and the home device information 2 of the home device, and receives the home device information 1 and the home device information 2 transmitted from the home device. Home information including the step 4 and the identifier of the home information management device, the home device information 1 and the group identifier stored in the database 1 of the home information management device is determined in advance. The information acquired at regular intervals is used as home information 1 and the home information 1 is obtained as a fifth step, and the home information is obtained as the home information 2 when the home information is significantly changed. The sixth step of acquiring the in-home information 2 and the acquired in-home information 1 and the in-home information 2 with respect to the predetermined regional information management device And the regional information management device includes a database 2 for storing the home information 1 and the home information 2, and the home information 1 transmitted from the home information management device. And an eighth step of receiving the in-home information 2 is provided.

Further, the present invention may be a program for causing a computer to execute the backup method described above, or a computer-readable recording medium that records the program.
Note that each of the above-described constituent elements can be arbitrarily added / deleted, and the invention for each apparatus is also included in the present invention.

By using the present invention, the following effects can be obtained.
(1) Even when it is necessary to recover the database included in the regional information management device, information necessary for recovery of the database included in the regional information management device is stored in the database included in the home information management device. By utilizing this, it is possible to recover the database provided in the regional information management device. In addition, the home information management device refers to the information request table provided in the regional information management device, so that the home information management device can provide information necessary for recovery of the database information provided in the regional information management device. For example, the local information management device does not need to store the IP (Internet Protocol) address of the home information management device, and therefore, for example, the IP (Internet Protocol) of the home information management device. ) Even if the address or the like is changed, it is not necessary to notify the regional information management device that the IP (Internet Protocol) address or the like of the home information management device has been changed.
(2) Even if it is necessary to recover the database provided in the home information management device, information required for recovery of the database provided in the home information management device is stored in the database provided in the regional information management device. This makes it possible to recover the database provided in the home information management apparatus.

It is a figure which shows an example of the flow of the household equipment information in the regional information management system currently disclosed by the nonpatent literature 1, and is a figure quoted also from 1st Embodiment to 3rd Embodiment. It is a figure which shows an example about the table for accumulating in-home apparatus information. It is a figure which shows an example about the table for accumulating in-home apparatus information. It is a figure which shows an example about the table for accumulating in-home information. It is a figure which shows an example about the table for accumulating in-home information. It is a figure which shows an example of the backup identifier table with which the area information management apparatus in 2nd Embodiment is provided. It is a functional block diagram which shows the example of 1 structure of a household device. It is a functional block diagram which shows the example of 1 structure of the home information management apparatus in 1st Embodiment and 2nd Embodiment. It is a functional block diagram which shows the example of 1 structure of the household information management apparatus in 3rd Embodiment. It is a functional block diagram which shows one structural example of the area information management apparatus in 1st Embodiment and 3rd Embodiment. It is a functional block diagram which shows one structural example of the area information management apparatus in 2nd Embodiment. It is a flowchart figure which shows the flow of the process in 2nd Embodiment. It is a flowchart figure which shows the flow of the process in 3rd Embodiment.

Embodiments of the present invention will be described below with reference to the drawings.
(First embodiment)
FIG. 1 is a functional block diagram illustrating a configuration example of a backup system according to the first embodiment.

  According to FIG. 1, the regional information management system (100) includes a service provider server (104a) to a service provider server (104c), etc., a regional information management device (103), and a home information management device (102a). The information management device (102c) and the like are connected via a network (NT), and the home information management device (102a) and the home device (101a) to the home device (101f) and the like are connected via an electric communication line. It has been configured.

  Further, in the home information management device (102b), the home information management device (102c), etc., the home devices are connected via an electric communication line as in the case of the home information management device (102a). The relationship between the device (102a) and the home device (101a) to the home device (101f) is the same as the relationship between the home information management device (102b), the home information management device (102c) and the home device. For this reason, a home device connected to the home information management device (102b), the home information management device (102c), etc. is omitted.

  According to FIG. 1, first, from the home device (101a) to the home device (101f), etc., the home device information is transmitted to the home information management device (102a).

  Next, the home information management device (102a) receives the home device information transmitted from the home device (101a) to the home device (101f), etc., and has received the home information received in the database provided in the home information management device (102a) Accumulate device information.

  Next, from the home information management device (102a) to the home information management device (102c), etc., the home device information stored in the database is transmitted to the regional information management device (103).

  Next, the area information management device (103) receives the in-home device information transmitted from the in-home information management device (102a) to the in-home information management device (102c), etc., and the database provided in the area information management device (103) Stores received home device information.

  Next, in response to a request for in-home device information from the service provider server (104a) to the service provider server (104c), the regional information management device (103) stores the in-home device information stored in the database. The in-home device information is transmitted from the service provider server (104a) to the service provider server (104c), etc.

  FIG. 5 is a functional block diagram showing a configuration example of the home device (101) which is one of the home devices such as the home device (101a) to the home device (101f).

  According to FIG. 5, the home device (101) includes one or both of the home device information 1 acquisition unit (101-1) and the home device information 2 acquisition unit (101-2), and the communication unit (101). -3).

The following is executed in the home device (101).
The home device information 1 acquisition unit (101-1) acquires the home device information at regular time intervals, and the home device information 2 acquisition unit (101-2) acquires the home device information at a timing when the home device information changes significantly. The communication unit (101-3) acquires the in-home device acquired by the in-home device information 1 acquisition unit (101-1) when the in-home device (101) includes the in-home device information 1 acquisition unit (101-1). When the information is transmitted to the home information management apparatus (102a) and the home device (101) includes the home device information 2 acquisition unit (101-2), the home device information 2 acquisition unit (101-2) acquires the information. The home device information is transmitted to the home information management device (102a).
The above is executed in the home device (101).

The in-home device information includes an in-home device identifier, a measurement item identifier, a measurement time, and an actual measurement value.
Here, the identifier of the home device is used to distinguish the home device when the home information management apparatus and a plurality of home devices are connected, and is different for each home device. For example, if there are three home devices, that is, home device 1, home device 2, and home device 3, for example, the home device identifier 1 is assigned to home device 1, and home device 2 is assigned to home device 2. Then, the identifier 2 of the home device is assigned, and the identifier 3 of the home device is assigned to the home device 3.

The measurement item identifier is used to distinguish measurement items when the home device has a plurality of measurement items such as power consumption, humidity, and temperature, and is different for each measurement item. Shall. For example, when there are three measurement items, that is, measurement item 1, measurement item 2, and measurement item 3, for example, an identifier of measurement item identifier 1 is assigned to measurement item 1, and measurement item 2 is assigned to measurement item 2. Thus, an identifier of measurement item identifier 2 is assigned, and an identifier of measurement item identifier 3 is assigned to assumed item 3.

The measurement time is the time when the actual measurement value is acquired.
The actual measurement value is an actual measurement value for each identifier of the measurement item acquired by the home device. For example, when the measurement item identifier is power consumption, the actual measurement value is 100, etc. (unit: W), and when the measurement item identifier is humidity, the actual measurement value is 30, etc. (unit:%). Is the temperature, the measured value is 35 mag (unit: degree).

  FIG. 6A is a functional block diagram showing a configuration example of one of the home information management devices (102) from the home information management device (102a) to the home information management device (102c).

  According to FIG. 6A, the home information management device (102) includes one or both of the home information 1 acquisition unit (102-1) and the home information 2 acquisition unit (102-2), and the communication unit (102). -3) and a database (102-4).

  The communication unit (102-3) of the home information management device (102) can receive home device information, that is, the home device identifier, the measurement item identifier, the measurement time, and the actual measurement value, and the home information management device (102). When the communication unit (102-3) receives the home device information, the home information management apparatus (102) executes the following.

  First, the communication unit (102-3) stores the received home device information in a database (102-4) included in the home information management device (102).

  Next, the identifier of the home device and the identifier of the measurement item included in the measurement value table (208) constituting the database (102-4) included in the home information management device (102), the identifier of the received home device, and the measurement The identifier of the area and the identifier of the group when the identifiers of the items match each other are acquired.

  Next, the acquired region identifier, group identifier, received home device identifier, measurement item identifier, actual measurement value, and measurement time are combined and stored in the measurement value table (208).

Next, the home information 1 acquisition unit (102-1) acquires home information from the database (102-4) included in the home information management device at regular time intervals, and the home information 2 acquisition unit (102-2) The home information is acquired from the database (102-4) provided in the home information management device at the timing when the home information is significantly changed, and the home information management device (102) acquires the home information 1 acquisition unit (102-3). 102-1), the home information acquired by the home information 1 acquisition unit (102-1) is transmitted to the regional information management device (103), and the home information management device (102) acquires the home information 2 When the unit (102-2) is provided, the home information acquired by the home information 2 acquisition unit (102-2) is transmitted to the regional information management device (103).
The in-home information includes an in-house information management device identifier, a group identifier, an in-home device identifier, a measurement item identifier, a measurement time, and an actual measurement value.
The above is executed by the home information management apparatus (102).

  Therefore, the database (102-4) provided in the home information management apparatus (102) includes a table for storing the received home device information.

  An example of a table for storing in-home device information is shown in FIGS. 2A and 2B. According to FIG. 2A and FIG. 2B, there are eight tables for storing received home appliance information, and each table is associated with each other by a key.

  2A and 2B, the table includes an area table (203), a group table (204), a home device table (205), a home device classification table (206), and a home device information table (207). And a measurement value table (208), a measurement item information table (209), and a type information table (210). Details of each table are as follows.

  The area table (203) includes information on areas managed by the home information management apparatus (102), that is, area identifiers, area names, and area characteristics.

  The area identifier is used to distinguish areas when the home information management apparatus manages, for example, a plurality of areas such as a floor, a room, and an apartment house. , Different for each region. For example, if there are three areas, that is, area 1, area 2, and area 3, for example, an area identifier 1 is assigned to area 1, and an area identifier 2 is assigned to area 2. And an identifier of region identifier 3 is assigned to region 3.

  The name of the area indicates the name of the area, and may be a nickname set by the administrator of the home information management device, a nickname set by the contractor or null, etc., or according to some other rule It may be.

  The area characteristics indicate the characteristics of the area, and may be the characteristics set by the administrator of the home information management device, the specifications set by the contractor or null, etc., or according to some other rule. It may be.

  In the group table (204), information related to a group when the target home devices are grouped in advance so that the effect of integrating a plurality of home devices can be verified, that is, the region identifier and group Identifier, group name, and group characteristics.

Here, the region identifier is included for association with the region table (203).
The group identifier is used to distinguish the group of home devices when there are a plurality of groups of home devices, and is different for each group. For example, if there are three groups, that is, group 1, group 2, and group 3, for example, an identifier of group identifier 1 is assigned to group 1, and an identifier of group identifier 2 is assigned to group 2. And an identifier of group identifier 3 is assigned to group 3.

  The name of the group indicates the name of the group, and may be a nickname set by the administrator of the home information management device, a nickname set by the home appliance installer, null, or the like, or according to some other rule. It may be.

  The characteristics of the group indicate the characteristics of the group, and may be the characteristics set by the administrator of the home information management device, the specifications set by the home appliance installer, null, etc., or according to some other rule. It may be.

  In the in-home device table (205), information on the in-home device, that is, the identifier of the area, the identifier of the group, the identifier of the home device, the manufacturer of the home device, the serial number of the home device, the name of the home device, and the model number of the home device x-coordinate, y-coordinate, z-coordinate, and z-axis rotation are included.

Here, the region identifier and the group identifier are included for associating with the group table (204).
Further, the identifier of the home device is as described above.

  In addition, the manufacturer of a home device indicates the name of the manufacturer and may be a nickname, a company name or null set by the administrator of the home information management device, or according to some other rule. May be.

  Further, the home device serial number can uniquely identify the home device, and includes, for example, a serial number set by the manufacturer, a MAC (Media Access Control) address, an IP (Internet Protocol) address, and the like.

  In addition, the name of the home device indicates the name of the home device, and may be a nickname set by the administrator of the home information management device, a nickname set by the manufacturer, or null, or according to some other rule. It may be a thing.

The model number of the home device indicates the model number of the home device, and may be a code set by the administrator of the home information management device, a code set by the manufacturer, null, or the like, or according to some other rule. It may be a thing.

  The x-coordinate is a case where the axis orthogonal to the floor surface in the house is the z-axis, the axis orthogonal to the z-axis is the x-coordinate, and the axis orthogonal to the x-axis and the z-axis is the y-axis. x coordinate. However, when the position where the home device is arranged is not required, it may be null or the like.

  The y coordinate is the y coordinate when the x axis, the y axis, and the z axis are applied. However, when the position where the home device is arranged is not required, it may be null or the like.

  The z coordinate is a z coordinate when the x axis, the y axis, and the z axis are applied. However, when the position where the home device is arranged is not required, it may be null or the like.

  The z-axis rotation is z-axis rotation when the x-axis, y-axis, and z-axis are applied. However, if the direction in which the home device is arranged is not required, it may be null or the like.

  The home device classification table (206) includes information about home device classification, that is, home device identifiers and home device functions.

  Here, the identifier of the home device is included for associating with the home device table (205).

  The function of the home device indicates a name of the classification when the home device is classified by function, and examples thereof include a refrigerator, a television, and lighting.

  The in-home device information table (207) includes information about the home device, that is, the name of the home device manufacturer, the home device, the model number of the home device, and the characteristics of the home device.

  Here, the manufacturer of the home device, the name of the home device, and the model number of the home device are included for associating with the home device table (205).

  In addition, the characteristics of the home device indicate the characteristics of the home device, and may be a feature set by the administrator of the home information management device, a specification set by the manufacturer, null, or the like, or according to some other rule. It may be a thing.

  The measurement value table (208) includes information on measurement values, that is, region identifiers, group identifiers, home device identifiers, measurement item identifiers, measurement times, and actual measurement values.

  Here, the region identifier, the group identifier, and the home device identifier are included for associating with the home device table (205). Further, the identifier of the measurement item, the measurement time, and the actual measurement value are as described above.

  The measurement item information table (209) includes information relating to the measurement item, that is, an in-home device identifier, a measurement item identifier, a model name, a measurement item name, and a measurement item characteristic.

  Here, the identifier of the home device and the identifier of the measurement item are included for associating with the measurement item table (208).

  The type name indicates the type of the actual measurement value. For example, when the actual measurement value is a character string, it is char, when the actual measurement value is an integer, it is integer, when the actual measurement value is a real number, double, etc. And

  The name of the measurement item indicates the name of the measurement item, and may be a nickname set by the administrator of the home information management device, a nickname set by the manufacturer, null, or the like, or according to some other rule. It may be a thing.

  Moreover, the feature of the measurement item indicates the feature of the measurement item. The feature set by the administrator of the home information management device, the specification set by the manufacturer, null, or the like may be used, or it may be according to some other rule.

  The type information (210) table includes information on the type of the actually measured value, that is, the type name and type characteristics.

  Here, the type name is included for associating with the measurement item information table (209).

  The characteristics of the mold indicate the characteristics of the mold, and may be a characteristic set by the administrator of the home information management device, a specification set by the manufacturer, null, etc., or according to some other rule. There may be.

  However, the identifier of the area, the name of the area and the characteristics of the area included in the area table (203) constituting the database included in the home information management apparatus, and the group table (204) included in the database included in the home information management apparatus. Region identifiers, group identifiers, group names, group characteristics, region identifiers, group identifiers, and home device identifiers included in a home device table (205) that constitutes a database included in the home information management apparatus. Home device manufacturer, home device serial number, home device name, home device model number, x-coordinate, y-coordinate, z-coordinate, z-axis rotation, and home device classification table constituting the database provided in the home information management device The identifier of the home device, the function of the home device, and the data included in the home information management device included in (206) The home device manufacturer, the name of the home device, the home device model number, the characteristics of the home device, and the measurement value table that forms the database of the home information management device included in the home device information table (207) (208), the identifier of the area, the identifier of the group, the identifier of the home appliance, the identifier of the measurement item, and the identifier of the home appliance included in the information table (209) of the measurement item constituting the database of the home information management apparatus And the identifier of the measurement item, the name of the type, the name of the measurement item, the characteristics of the measurement item, the name of the type and the characteristics of the type included in the type information table (210) constituting the database provided in the home information management device, Are stored in advance by the administrator of the home information management apparatus.

FIG. 7A is a functional block diagram showing an example of the configuration of the regional information management device (103).
According to FIG. 7A, the area information management device (103) includes a communication unit (103-3) and a database (102-4).

  The communication unit (103-3) of the regional information management device (103) receives the home information, that is, the home information management device identifier, the group identifier, the home device identifier, the measurement item identifier, the measurement time, and the actual measurement value. When the communication unit (103-3) of the regional information management device (103) receives the home information, the regional information management device (103) executes the following.

  First, the communication unit (103-3) accumulates the received home information in a database (103-4) provided in the regional information management device (103).

  Next, the identifier of the home information management device, the home device identifier, and the measurement item identifier included in the measurement value table (310) constituting the database (103-4) included in the regional information management device (103) are received. The identifier of the area and the identifier of the group are acquired when the identifier of the home information management apparatus, the identifier of the home device, and the identifier of the measurement item match.

Next, in the measurement value table (310), the identifier of the acquired area, the identifier of the group, the identifier of the received home information management device, the identifier of the home device, the identifier of the measurement item, the measurement time, and the actual measurement value are stored. Add the composite.
The above is executed by the regional information management apparatus (103).

  Therefore, the database (103-4) provided in the regional information management apparatus (103) includes a table for storing the received home information.

  An example of a table for storing in-home information is shown in FIGS. 3A and 3B. According to FIG. 3A and FIG. 3B, there are 10 tables as tables for storing in-home information, and each table is related to each other by a key.

  As shown in FIGS. 3A and 3B, the information table (303) of the home information management device, the base table (304) of the home information management device, the area table (305), the group table (306), and the home A device table (307), a home device classification table (308), a home device information table (309), a measurement value table (310), a measurement item information table (311), and a type information table (312) are included. The details of each table are as follows.

  The information table (303) of the home information management device includes information about the home information management device, that is, the identifier of the home information management device, the name of the home information management device, and the characteristics of the home information management device.

  Here, the identifier of the home information management device is used to distinguish the home information management device when the regional information management device and a plurality of home information management devices are connected. Each one will be different. For example, when there are three home information management devices, that is, the home information management device 1, the home information management device 2, and the home information management device 3, for example, the home information management device 1 is connected to the home information management device 1. The identifier 1 is assigned, the home information management device 2 is assigned the identifier 2 of the home information management device, and the home information management device 3 is assigned the identifier 3 of the home information management device.

  The name of the home information management device is the name of the home information management device, and may be a nickname set by the administrator of the home information management device, a nickname set by the manufacturer of the home information management device, or null, etc. It may be according to some rules.

  The feature of the home information management device is the feature of the home information management device, the feature set by the administrator of the home information management device, the specification set by the manufacturer of the home information management device or null, etc. It may be according to some rules.

  The base table (304) of the home information management apparatus includes information necessary for communication with the base where the home information management apparatus is arranged, that is, the identifier, communication means, and address of the home information management apparatus.

  Here, the identifier of the home information management apparatus is included for associating with the information table (303) of the home information management apparatus.

  Further, the communication means is, for example, information on the base where the home information management device is arranged, a means for communicating with the manager of the home information management device, a means for communicating with the home information management device, and the like. For example, the Internet, a telephone, the local site, etc. are mentioned.

  Also, the address is an address corresponding to the communication means. For example, when the communication means is the Internet, an IP (Internet Protocol) address such as 151.120.024.050 is used, and when the communication means is a telephone, A telephone number such as 0139-41-0983 is used, and if the communication means is local, an address such as 16-1-2 Ibusuki City, Kagoshima Prefecture is assumed.

Since the region table (305) is almost the same as the region table (203) described above, the description thereof will be omitted. However, the identifier of the home information management device is added, and the information stored in the area table (305) can be limited by specifying the identifier of the home information management device.

  Since the group table (306) is almost the same as the above-described group table (204), the description is omitted. However, the identifier of the home information management device is added, and the information stored in the group table (306) can be limited by designating the identifier of the home information management device.

  The in-home device table (307) is almost the same as the above-described in-home device table (205), and therefore details are omitted. However, the identifier of the home information management device is added, and the information stored in the home device table (307) can be limited by designating the identifier of the home information management device.

  Since the home device classification table (308) is the same as the above-described home device classification table (206), the details are omitted.

  The in-home device information table (309) is the same as the above-described in-home device information table (207), and therefore details thereof are omitted.

  Since the measurement value table (310) is substantially the same as the above-described measurement value table (208), the details are omitted. However, the identifier of the home information management apparatus is added, and the information stored in the measurement value table (310) can be limited by specifying the identifier of the home information management apparatus.

Since the measurement item information table (311) is the same as the measurement item information table (209) described above, the details are omitted.
Since the type information table (312) is the same as the above-described type information table (210), details are omitted.

  However, the identifier of the home information management device, the name of the home information management device, the characteristics of the home information management device, the characteristics of the home information management device, and the local information management included in the information table (303) of the home information management device constituting the database included in the local information management device Included in the area table (305) constituting the database provided in the local information management apparatus, the identifier, communication means, and address of the home information management apparatus included in the base table (304) of the home information management apparatus constituting the database provided in the apparatus The identifier of the home information management device, the identifier of the region, the name of the region, the characteristics of the region, the identifier of the home information management device and the identifier of the region included in the group table (306) constituting the database of the regional information management device The group identifier, group name, group characteristics, and local information management device The identifier of the home information management device, the identifier of the area, the identifier of the group, the identifier of the home device, the manufacturer of the home device, the serial number of the home device, the name of the home device, and the home included in the home device table (307) constituting the database The model number of the device, the x coordinate, the y coordinate, the z coordinate, the z axis rotation, the identifier of the home device included in the home device classification table (308) constituting the database included in the area information management device, the function of the home device, The name of the home device, the name of the home device, the model number of the home device, the characteristics of the home device, and the database of the local information management device included in the information table (309) of the home device constituting the database included in the regional information management device Home information management device identifier, region identifier, group identifier, and home device included in the measurement value table (310) to be configured Identifier, measurement item identifier, home device identifier, measurement item identifier, type name, measurement item name, and measurement included in the measurement item information table (311) constituting the database included in the regional information management device The feature of the item and the type name and type characteristics included in the type information table (312) constituting the database included in the area information management apparatus are stored in advance by the administrator of the area information management apparatus. Shall.

By using the first embodiment, the following effects can be obtained.
In the first embodiment, the local information management device (102a) to the home information management device (102C) and the like receive the home device information from the home device at regular intervals or at the timing when the home device information is received from the home device. 103) part of the database provided in the home information management device (102a) to the home information management device (102C) and the like, and part of the database provided in the regional information management device (103) And can be matched.

(Second Embodiment)
A second embodiment will be described below.
In the second embodiment, the backup system of the first embodiment will be described as an example. In the second embodiment, any one of the home information management devices such as the home information management device (102a) to the home information management device (102c) in FIG. 1 is used as the home information management device (102).

  As shown in FIG. 4, the area information management device (103) includes the set of the identifier of the home information management device and the information request code, and the set of the identifier of the home information management device and the information request code. Has an information request table.

  Here, the information request code is updated when the information stored in the home information management apparatus (102) is requested, and a character string different from the conventionally set character string is set every time the information request code is updated. And

  In addition, the identifier of the home information management apparatus possessed by the home information management apparatus (102) is recorded as the identifier of the home information management apparatus.

FIG. 8 is a flowchart showing the flow of processing according to the present embodiment.
FIG. 7B is a diagram showing details of the area information management apparatus (103).
When the information request unit (103-6) of the regional information management device (103) needs to recover information in the database (103-4) included in the regional information management device (103), the regional information management device (103) ) Is changed (step S11). At this time, all the information request codes may be changed, or the home information management device (102) that holds information necessary for the recovery of the information in the database (103-4) provided in the regional information management device (103) In particular, only the information request code (1) that is set with the identifier of the home information management apparatus included in the specified home information management apparatus (102) may be changed.

The communication unit (102-3) of the home information management device (102) sends a code request signal including an identifier of the home information management device included in the home information management device (102) at regular time intervals to the area information management device (103). Send to.

  The communication unit (103-3) of the regional information management device (103) can receive the code request signal transmitted from the home information management device (102), and the communication unit (103-3) of the regional information management device (103). ) Receives the code request signal transmitted from the home information management device (102), the following is executed in the regional information management device (103).

The communication unit (103-3) of the regional information management device (103) includes the identifier of the residential information management device included in the received code request signal and the residential request included in the information request table included in the regional information management device (103). An information request included in the set of identifier and information request code of the selected home information management device is selected by selecting a set of the identifier and information request code of the home information management device that matches the identifier of the information management device The code (1) is transmitted.
The above is executed by the regional information management apparatus (103).

  The communication unit (102-3) of the home information management device (102) can receive the information request code (1) transmitted from the regional information management device (103), and the communication unit (102) of the home information management device (102) ( When 102-3) receives the information request code (1) transmitted from the area information management device (103), the following is executed in the home information management device (102).

  First, the communication unit (102-3) of the home information management device (102) compares the received information request code (1) with the information request code (2) of the home information management device (102). (Step S12) If the two match (NO in Step S13), the regional information management device (103) has a database (103-4) provided in the regional information management device (103) with respect to the home information management device (102). It is determined that the information required for the recovery of the information is not requested, and the process returns to step S12. On the other hand, when the received information request code (1) is different from the information request code (2) of the home information management device (102) (YES in step S13), the regional information management device (103) It is determined that the information management apparatus (102) is requested for information necessary for recovery of information in the database (103-4) provided in the regional information management apparatus (103).

  Next, the communication unit (102-3) of the home information management device (102) includes a database (103) provided in the local information management device (103) by the local information management device (103) with respect to the home information management device (102). -4), when it is determined that information required for the recovery of information is requested, predetermined information out of the information stored in the database (102-4) provided in the home information management device (102) That is, the recovery information is transmitted to the regional information management device (103) (step S14).

  The recovery information is the name of the table of the database (103-2) provided in the regional information management apparatus (103) that must be recovered, and the in-house information management apparatus (of the row unit information registered in the table) ( 102). For example, when recovering the measurement values included in the measurement value table (310) of the database (103-4) included in the regional information management device (103), the table name of the measurement value table (310) and the home information management device An identifier, an area identifier, a group identifier, a home device identifier, a measurement item identifier, a measurement time, and an actual measurement value are used.

  However, information other than the above may be used as long as it is possible to recover the database (103-4) included in the regional information management device (103) as described above.

Next, the communication unit (102-3) of the home information management apparatus (102) changes the information request code (2) of the home information management apparatus (102) to the received information request code (1) (step) S15).
The above is executed by the home information management apparatus (102).

  The communication unit (103-3) of the regional information management device (103) can receive the recovery information transmitted from the home information management device (102), and the communication unit (103-3) of the regional information management device (103). However, when the recovery information transmitted from the home information management device (102) is received (step S15), the following is executed in the regional information management device (103).

  The information recovery unit (103-5) of the regional information management device (103) recovers the database (103-4) included in the regional information management device (103) based on the received recovery information (step S17).

For example, based on the name of the measurement value table included in the recovery information, the home information included in the recovery information is compared with the measurement value table (310) of the database (103-4) included in the regional information management device (103). An information management device identifier, a region identifier, a group identifier, a home device identifier, a measurement item identifier, a measurement time, and an actual measurement value are recorded.
The above is executed by the regional information management apparatus (103).

By using the second embodiment, the following effects can be obtained.
In the second embodiment, even if it is necessary to recover the database (103-4) included in the regional information management device (103), the database (102-4) included in the home information management device (102) is required. In addition, the database (103-4) provided in the regional information management device (103) is created using the fact that the information necessary for the recovery of the database (103-4) provided in the regional information management device (103) is accumulated. Can be recovered.

  Further, the home information management device (102) accesses the information request table of the regional information management device (103), so that the regional information management device (103) has a database (103) provided in the regional information management device (103). It is determined whether information required for the recovery in (4) is requested. Accordingly, since the regional information management device (103) does not need to have the IP (Internet Protocol) address of the home information management device (102), for example, the IP (Internet Protocol) address of the home information management device (102) Even in the case of a change, it is not necessary to notify the local information management device (103) that the IP (Internet Protocol) address of the home information management device (102) has been changed.

  Further, the regional information management device (103) is identified by identifying the home information management device (102) having information necessary for the recovery of information in the database (103-4) included in the regional information management device (103). The information request code that is set together with the identifier of the home information management device of the home information management device (102) can be updated, so that the database (103) provided in the regional information management device (103) is based on the recovery information. 103-4) cannot be recovered, the premises information management device (102) is updated by updating only the information request code that is set with the identifier of the premises information management device of the premises information management device (102). 102) can determine that the database (103-4) included in the regional information management device (103) could not be recovered.

(Third embodiment)
A third embodiment will be described below.
In the third embodiment, the backup system of the first embodiment will be described as an example. In the third embodiment, any one of the home information management devices (102a) to the home information management device (102c) in FIG. 1 is used as the home information management device (102).

FIG. 9 is a flowchart showing the flow of processing in the third embodiment.
The home information management device (102) executes the following processing when it is necessary to recover the information in the database (102-4) provided in the home information management device (102).

FIG. 6B is a diagram showing details of the home information management apparatus (102).
The communication unit (102-3) of the home information management device (102) receives information necessary for the recovery of the information in the database (102-4) included in the home information management device (102) with respect to the regional information management device (103). An information request signal for requesting is transmitted (step S21). However, the information request signal is transmitted by the administrator of the home information management apparatus (102) operating the home information management apparatus (102) or automatically by the home information management apparatus (102).

  The communication unit (103-3) of the regional information management device (103) can receive the information request signal transmitted from the home information management device (102), and the communication unit (103-3) of the regional information management device (103). ) Receives the information request signal transmitted from the home information management device (102) (step S22), the following is executed in the regional information management device (103).

  The communication unit (103-3) of the regional information management device (103) includes a database (102-4) provided in the residential information management device (102) with respect to the regional information management device (103). It is determined that the information required for the recovery of the information is requested, and the information stored in the database (103-4) of the regional information management device (103) is predetermined information, that is, the recovery Information is transmitted to the home information management device (102) (step S23).

  The recovery information is the name of the table of the database (102-4) provided in the home information management device (102) that must be recovered, and the region information management device (of the row unit information registered in the table) ( 103). For example, when recovering measurement values included in the measurement value table (208) of the database (102-4) provided in the home information management apparatus (102), the table name, area identifier, and group of the measurement value table (208) Identifier, home device identifier, measurement item identifier, measurement time, and actual measurement value.

However, information other than the above may be used as long as it is possible to recover the database (102-4) included in the home information management apparatus (102) as described above.
The above is executed by the regional information management apparatus (103).

  The communication unit (102-3) of the home information management apparatus (102) can receive the recovery information transmitted from the area information management apparatus (103), and the communication unit (102-3) of the home information management apparatus (102). However, when the recovery information transmitted from the area information management apparatus (103) is received (step S24), the following is executed in the home information management apparatus (102).

  The information recovery unit (102-5) of the home information management apparatus (102) recovers the database (102-4) included in the home information management apparatus (102) based on the received recovery information (step S25).

For example, based on the name of the measurement value table included in the recovery information, the area included in the recovery information with respect to the measurement value table (208) of the database (102-4) included in the home information management device (102) Identifier, group identifier, home device identifier, measurement item identifier, measurement time, and actual measurement value are recorded.
The above is executed by the home information management apparatus (102).

By using the third embodiment, the following effects can be obtained.
In the third embodiment, even if it is necessary to recover the database (102-4) included in the home information management apparatus (102), the database (103-4) included in the area information management apparatus (103) is required. In addition, the database (102-4) provided in the home information management device (102) is created by using the fact that information necessary for the recovery of the database (102-4) provided in the home information management device (102) is accumulated. Can be recovered.

(Fourth embodiment)
The in-home information management device (102) and the regional information management device (103) described in the first to third embodiments above can read a program for realizing a plurality of functions by a computer. You may implement | achieve the process of each function part by recording on a recording medium, making a computer system read the program recorded on this recording medium, and executing it. Note that the “computer system” here includes an OS (Operating System) and hardware such as peripheral home devices.

  Further, the “computer system” includes a homepage providing environment (or display environment) if a WWW (World Wide Web) system is used.

  Further, the program may be for realizing a part of the functions described above, and may be capable of realizing the functions described above in combination with a program already recorded in the computer system. .

  In addition, the “recording medium” storing the program includes a computer-readable portable medium such as a flexible disk, a magneto-optical disk, a ROM (Read Only Memory), and a CD-ROM, and a hard disk built in the computer system. A storage device. Furthermore, a program that dynamically holds a program for a short time, such as a communication line when transmitting a program via a network such as the Internet or a communication line such as a telephone line, and a server or client in that case Such a volatile memory inside a computer system as described above includes a program that holds a program for a certain period of time.

(Fifth embodiment)
The in-home information management device (102) and the regional information management device (103) described in the first to third embodiments are the circuit devices and ICs (Integrated Circuits) that realize these functions. It can be configured using hardware such as an integrated circuit. These functional units may be individually configured, or a plurality of functional units may be configured by a single hardware.

  The configurations and the like illustrated in the accompanying drawings described in the first to third embodiments are not limited to these, and may be appropriately selected within the scope of the effects of the present invention. It is possible to change. In addition, various modifications can be made without departing from the scope of the object of the present invention.

100: Regional information management systems 101a to 101f: In-home devices 102a to 102c: In-home information management device 103: Regional information management device 104: Service provider server NT: Network 401: In-home information management device column 402: Backup identifier column 101 : Home device 101-1: Home device information 1 acquisition unit 101-2: Home device information 2 acquisition unit 101-3: Communication unit 102: Home information management device 102-1: Home information 1 acquisition unit 102-2: Home information 2 acquisition unit 102-3: communication unit 102-4: database 102-5: information recovery unit 2
103: Regional information management device 103-3: Communication unit 103-4: Database 103-5: Information recovery unit 1
103-6: Information request unit 203: Area table 204: Group table 205: Home device table 206: Home device classification table 207: Home device information table 208: Measurement value table 209: Measurement value information table 210: Type Information table 303: Home information management device information table 304: Home information management device base table 305: Area table 306: Group table 307: Home device table 308: Home device classification table 309: Home device information table 310: Measurement Value table 311: Measurement value information table 312: Type information table.

Claims (4)

A backup system comprising a home information management device and a regional information management device,
When recovering the database 2 provided in the regional information management device using information stored in the database 1 provided in the home information management device,
The regional information management device
An information requesting unit for changing the information request code included in the information request table included in the regional information management device configured to include a set of an identifier of the home information management device and an information request code to one that has not been used conventionally Have
The home information management device includes:
The information request code included in the set in which the identifier of the home information management device matches the identifier of the home information management device included in the information request table included in the area information management device is the home information management device. If the information request code is different from the information request code included in the home information management device, the home information management device is a part of the database 1 provided in the home information management device and the database provided in the regional information management device. A function for transmitting recovery information 1 including the location where the home information 3 is stored in 2 to the regional information management device, and the information request code included in the home information management device. The identifier of the information management device matches the identifier of the in-home information management device included in the information request table provided in the area information management device The communication unit 2 has a function to change the information request code in the set that the
Have
The regional information management device
A communication unit 3 having a function of receiving the recovery information 1 transmitted from the home information management device;
The regional information management device includes the home information 3 included in the recovery information 1 based on a location where the home information 3 is stored in the database 2 included in the regional information management device included in the recovery information 1. An information recovery unit 1 stored in the database 2;
A backup system characterized by comprising: A backup system further including a home device,
The in-home equipment is
With respect to the in-home device, the in-home device information including the in-home device identifier, the measurement item identifier, the measurement time, and the measurement value is acquired at a predetermined time interval as in-home device information 1, A home appliance information 1 acquisition unit for acquiring the home appliance information 1;
In-house device information 2 acquisition unit for acquiring the in-home device information 2 as the in-home device information 2 obtained by acquiring the in-home device information at a timing when the measurement value has changed significantly,
A communication unit 1 for transmitting the acquired home device information 1 and the home device information 2 to the predetermined home information management device;
Have
The home information management device includes:
The communication unit 2 further having a function of receiving the home device information 1 and the home device information 2 transmitted from the home device;
The database 1 for storing the home appliance information 1 and the home appliance information 2 of the home appliance;
The home information that is stored in the database 1 included in the home information management device and includes the home information management device identifier, the home device information 1 and the group identifier is stored in a predetermined time period. The home information 1 acquisition unit that acquires the home information 1 as home information 1 acquired at intervals;
A home information 2 acquisition unit that acquires the home information 2 as home information 2 obtained by acquiring the home information at a timing when the home information has changed significantly;
Have
The communication unit 2 further has a function of transmitting the acquired home information 1 and the home information 2 to the predetermined regional information management device,
The regional information management device
The communication unit 3 further having a function of receiving the home information 1 and the home information 2 transmitted from the home information management device;
The database 2 for storing the home information 1 and the home information 2;
The backup system according to claim 1, further comprising: When recovering the database 1 provided in the home information management device using information stored in the database 2 provided in the regional information management device,
The home information management device includes:
The communication unit 2 further having a function of transmitting an information request signal to the regional information management device;
The regional information management device
A function of receiving the information request signal transmitted from the home information management device, home information 3 as a part of the database 2 provided in the predetermined area information management device, and the home information management device A location for storing the home information 3 in the database 1, and a function of transmitting recovery information 2 including the home information management device to the home information management device;
The communication unit 2 further has a function of receiving the recovery information 2 transmitted from the area information management device,
The home information management device includes:
The home information management device includes the home information 3 included in the recovery information 2 based on a location where the home information 3 is stored in the database 1 included in the home information management device included in the recovery information 2 An information recovery unit 2 stored in the database 1;
The backup system according to claim 1, further comprising: A method for backing up information in a regional information management system including a regional information management device, a home information management device, and home devices,
The in-home equipment is
With respect to the in-home device, the in-home device information including the in-home device identifier, the measurement item identifier, the measurement time, and the measurement value is acquired at a predetermined time interval as in-home device information 1, A first step of acquiring the home appliance information 1;
A second step of acquiring the in-home device information 2 as the in-home device information 2 obtained by acquiring the in-home device information at a timing when the measurement value has changed significantly;
A third step of transmitting the acquired home device information 1 and the home device information 2 to the predetermined home information management device;
Run
The home information management device includes:
A database 1 for storing the home appliance information 1 and the home appliance information 2 of the home appliance;
A fourth step of receiving the home device information 1 and the home device information 2 transmitted from the home device;
The home information configured to include the home information management device identifier, the home device information 1 and the group identifier stored in the database 1 included in the home information management device is set at predetermined time intervals. The fifth step of acquiring the in-house information 1 as the in-house information 1 obtained in step
A sixth step of acquiring the in-home information 2 with the in-home information acquired as the in-house information 2 at a timing when the in-house information has changed significantly;
A seventh step of transmitting the acquired in-home information 1 and the in-home information 2 to the predetermined regional information management device;
Run
The regional information management device
A database 2 for storing the home information 1 and the home information 2;
A backup method characterized by executing an eighth step of receiving the in-home information 1 and the in-home information 2 transmitted from the in-home information management device.

Images