JPH05334150A - Database generation managing device - Google Patents

Abstract

PURPOSE:To shorten a retrieving time and to contract each processing area, by reducing unnecessary data retrieval or processing area. CONSTITUTION:This database generation managing device is constituted of a database 11 for storing plural data, a data generation updating part 12 for updating the generation of change data at the time of changing the data stored in the database 11 and storing the updated data, an up-to-date generation data detecting part 13 for detecting all up-to-date generation data including unchanged data, a package part 14 for constructing a group consisting of a specification group for specifying the data detected by the detecting part 13, a database generation updating part 15 for updating the generation of the group constructed by the package part 14, and a control part 16 for controlling the execution of each processing part.

Description

Detailed Description of the Invention

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a database generation management device which mechanically manages the generation of data stored in a database and makes the use of the database fast and easy.

[0002]

2. Description of the Related Art In a conventional database generation management method, when stored data is changed, generation information attached to this data is updated to manage past data and updated data. , This management was based on individual data. Therefore, when using the database, all the stored data, including old and new, are searched. Referring to (FIG. 3) and (FIG. 5) below,
A conventional generation management method will be described.

FIG. 3 shows an example of a database in which the generation of data is updated when the data is changed and stored as separate data. In FIG. 3, reference numeral 30 is a database, and D1 to D12 are data stored in the database 30. D1 to D4 have the same data name
Although it is rect, it is data of different generations. Now, the generations are distinguished by showing a. (Period) symbol and a number indicating the generation after the data name. The data with the larger generation number is newer data. Similarly, D5 to D7, D8 to D9, D10
.. to D12 also indicate that they are data of different generations with the same data name. 40 is a time axis indicating the time when each data of D1 to D12 is stored in the database 30. In FIG. 3, data D1, D5, and D10 are stored in the database 30 at time t1 on the time axis 40,
Data D2, D8, D11 at the time of t2, data D3, D6 at the time of t3, data D7, D12 at the time of t4,
This indicates that the data D4 and D9 are stored at the time of t5.

FIG. 5A is an example of an application created by using the database 30 at the time t2 on the time axis 40 in FIG. Database 30 at t2
The data D1, D2, D5, D8, D10, and D11 are only stored in the application, and the application 5 of FIG.
0 is created using only these data. In FIG. 5A, for example, the portion B1 is the portion of the application object 50 created using the data D2, and similarly, the portions B2 and B3 are the data D5, the portion B4 is the data D8, and the portion B5. Is a portion using the data D11.

Now, consider a case where a part of the application shown in FIG. 5A is changed at the time t5 on the time axis 40 shown in FIG. For example, by changing the parts B2 and B3 to the same parts as the part B4, the application 60 shown in FIG.
If you want to use the same data as the part B4 database 30
Have to search from. The range of this search is D stored in the database 30 at time t5 on the time axis 40.
It is all data from 1 to D12. Each of all the data is collated with the portion B4, the matched data is read and replaced with the portions B2 and B3.

[0006]

However, in the above change, only the data stored in the database 30 at the time t2 of the time axis 40 need to be searched, and the data stored thereafter cannot be searched. Search is unnecessary. As described above, in the conventional database generation management method, useless database search occurs, resulting in an increase in search time and a large-scale processing area.

In order to solve the above-mentioned problems, the present invention automatically detects only the latest generation data when the data in the database is changed and the generation is updated, and groups it. By providing a mechanism that can use only the data of a necessary group according to the above, it is intended to reduce unnecessary data search and processing area, shorten the search time, and reduce the processing area.

[0008]

In order to achieve this object, the first aspect of the present invention relates to a database in which a plurality of data are stored, and when the data in the database is changed, the changed data A data generation updating unit that updates generations and stores it in the same database, a latest generation data detecting unit that detects all data of the latest generation including unmodified data from the database, and the latest generation data detecting unit. A package unit that constructs a set of instructions that specify the detected data, a database generation update unit that updates the generation of the set constructed by the package unit, and a control unit that controls the execution of each processing unit. It is equipped with.

The second aspect of the present invention is a database in which a plurality of data are stored, and when the data in the database is changed, data for updating the generation of the changed data and storing it in the database. It consists of a generation update unit, a latest generation data detection unit that detects all the latest generation data including unmodified data from the database, and an instruction group that specifies the data detected by the latest generation data detection unit. A package part that constructs a set, a database generation update part that updates the generation of the set constructed by the package part, and a set of specified generations among the generations of the set created by the database generation update part. It is provided with a generation designation unit that is retrieved from the database and a control unit that controls the execution of each of the processing units.

[0010]

With the above configuration, since only the data at the required time can be specified, only the necessary data according to the application can be processed, the search range of the database can be narrowed, and the search can be performed. It is possible to reduce the time and the processing area. Further, since it is only necessary to be aware of the generation of a group of necessary data rather than being aware of the generation of individual data, it is possible to simplify the maintenance work of the application and the management work of the database.

[0011]

DESCRIPTION OF THE PREFERRED EMBODIMENTS A database generation management apparatus according to an embodiment of the present invention will be described below with reference to the drawings.

FIG. 1 is an example of a configuration diagram of a database generation management apparatus according to the first embodiment of the present invention. (Fig. 1)
In FIG. 11, 11 is a database that stores a plurality of data, 12 is a data generation update unit that updates the generation of the changed data and stores it in the database 11 when the data in the database 11 is changed, and 13 is a database The latest generation data detection unit that detects all the latest generation data including unmodified data from 11, and 14 is a package that builds a set of instruction groups that specify the data detected by the latest generation data detection unit 13. Reference numeral 15 is a database generation updating unit that updates the generation of the set constructed by the packaging unit 14, and 16 is a control unit that controls the execution of each processing unit.

The operation of the database generation management apparatus according to the first embodiment of the present invention will be described below with reference to (FIG. 1), (FIG. 3) and (FIG. 4).

As the database 11 of (FIG. 1),
Consider the case where the database 30 of FIG. 3 is applied.
At time t1 on the time axis 40 in (Fig. 3), the database 3
Only data D1, D5, and D10 are stored in 0. When the data D1 and the data D10 are changed at the time of t2, the control unit 16 causes the data generation updating unit 12 to update the generation of these data, and stores them in the database 30 as the data D2 and the data D11.

Then, the latest generation data detection unit 13
The latest generation data of each data at the time of is detected. In this case, the data names rect and trig have the generation number 2 and the data D2, data D11, and circ have not been updated.
Since the data D5 stored at t1 and the data D8 having the data name star newly stored at t2 are the latest generation at t2, these data are detected. The control unit 16 causes the package unit 14 to create a set of the data thus detected, and stores this in the database 30. The created set does not have elements such as the data D2 and the data D8 as they are, or the copied data as an element, but information for instructing these data, for example, a data name with a generation number and the database 30. Information such as an address unique to each is used as an element.

In the present case, this set is stored in the database 3
Although it is stored in 0, it may be stored in another database. At that time, the elements of the set are composed of information designating the data 30 and information designating the database 30 storing them. In this case, the set created by the packaging unit 14 is stored in the database 30 with the information of the data name with the generation number as its constituent element. At the time of storing this set, the control unit 16 causes the database generation updating unit 15 to update the generation of the set data. For example, if the generation of the aggregate data at t1 is the first generation, then t2
The aggregate data of the second generation at times and the third generation of data at t3 are stored in the database 30.

FIG. 4 shows the result at t5 of the database 30 subjected to the above procedure (FIG. 3). In FIG. 4, S1 is set data at time t1, S2
Indicates aggregate data at t2, S3 at t3, S4 at t4, and S5 at t5. The set data S1 to S5 have the same data name pkg, and following this data name are the. (Period) symbol and the generation number. The aggregate data S1 is composed of the latest generation data at time t1, rect.1, circ.1, and trig.1 elements. Similarly, the aggregate data S2 contains rect.2, c.
irc.1, star.1, trig.2, set data S3 is rect.3,
circ.2, star.1, trig.2, rect.
3, circ.3, star.1, trig.3, rec for set data S5
Each has t.4, circ.3, star.2, trig.3 as elements.

As described above, according to the present embodiment, when the data is changed, the generation management conventionally required for individual data is managed only by managing the generation of aggregate data in which a plurality of data are aggregated. Because it is good, management work can be dramatically facilitated. Further, the application created by using the database of which generation is managed by the device of the present invention can reproduce the state of the database at that time only by the generation information of the collective data at the time of creation, so that the application can be easily maintained. Can be converted.

(FIG. 2) is to specify the collective data of a specific generation from the collective data of a plurality of generations created by the database generation management device of (FIG. 1) of the second embodiment of the present invention. It is a block diagram of the database generation management apparatus to which a processing unit capable of performing the above is added.

In FIG. 2, reference numeral 17 indicates, from among the generations of the aggregate data created by the database generation updating unit 15,
This is a generation designation unit that designates aggregate data of a specific generation.

The operation of the database generation management apparatus according to the second embodiment of the present invention will be described below with reference to (FIG. 2) and (FIG. 4).

It is assumed that the database 30 shown in FIG. 4 is created by the same operation as the database generation management apparatus according to the first embodiment of the present invention. In FIG. 2, the control unit 16 causes the generation designating unit 17 to designate any set data from the set data S1 to S5 in the database 30 of FIG. Now, consider a case where the aggregate data S3 is designated. The generation designating unit 17 uses the control unit 16 to rect.3, cir which are the constituent elements of the aggregate data S3.
c.2, star.1, trig.2 are read, and data D3, D6, D8, D1 on the database 30 corresponding to this constituent element
Only 1 is expanded in the processing area of this device.

As described above, according to the configuration of the present embodiment, only the data required for the processing needs to be expanded in the processing area, so that a smaller processing area than the conventional one is required. In addition, data retrieval is also speeded up.

[0024]

As described above, according to the first aspect of the present invention,
When changing the data, it is only necessary to manage the generation of the aggregate data in which a plurality of data are aggregated, and therefore the management work can be dramatically simplified. In addition, the application created by using the generation-controlled database by the device of the present invention,
Since the state of the database at that time can be reproduced only by the generation information of the aggregate data at the time of creation, the maintenance of the application becomes easy.

Further, according to the second aspect of the present invention, since only the data of the required generation needs to be expanded in the processing area, the processing area can be made smaller than before. In addition, data retrieval is also speeded up.

[Brief description of drawings]

FIG. 1 is a configuration diagram of a database generation management apparatus according to a first embodiment of this invention.

FIG. 2 is a configuration diagram of a database generation management device according to a second embodiment of the present invention.

[Fig. 3] Example of database showing storage time of data

FIG. 4 is a diagram showing the result of generation management of the database of FIG. 3 by the database generation management device of the present invention.

FIG. 5 is an example of an application created using the data in the database shown in FIG.

[Explanation of symbols]

 11 database 12 data generation updating unit 13 latest generation data detecting unit 14 package unit 15 database generation updating unit 16 control unit 17 generation specifying unit

Claims (4)

[Claims] 1. When a part of the stored data is changed, in a database generation management device that manages the generation of a database that updates the generation of the data and stores the data before and after the change, A stored database, and a data generation updating unit that updates the generation of the changed data and stores it in the database when the data in the database is changed, and also includes unmodified data from the database. The latest generation data detection unit that detects all the latest generation data, a package unit that constructs a set consisting of an instruction group that specifies the data detected by the latest generation data detection unit, and a set that is constructed by the package unit Database generation updating unit for updating the generations of the above, and a control unit for controlling the execution of each processing unit described above. Generation management device. 2. The database generation management apparatus according to claim 1, further comprising the package unit for constructing a set of instruction groups for designating the latest generation data of a plurality of distributed databases. 3. When a part of the stored data is changed, in a database generation management device that manages the generation of a database that updates the generation of data and stores the data before and after the change, A stored database, and a data generation updating unit that updates the generation of the changed data and stores it in the database when the data in the database is changed, and also includes unmodified data from the database. The latest generation data detection unit that detects all the latest generation data, a package unit that constructs a set consisting of an instruction group that specifies the data detected by the latest generation data detection unit, and a set that is constructed by the package unit Database generation update unit that updates the generations of the A database generation management device comprising: a generation specifying unit that extracts the result from the database; and a control unit that controls the execution of each processing unit. 4. The database generation management apparatus according to claim 3, further comprising: the generation designating unit that extracts the latest generation set from the database among the generations of the set.