JPH0340043A - Data base generation managing system - Google Patents

Abstract

PURPOSE:To integrally manage plural generations by controlling the generation management of a data base with a dictionary device. CONSTITUTION:As for the dictionary device 2, that which is incorporated in a data base managing system 4 is provided externally and independently so that the read-out and the change of generation information can be executed arbitrarily and directly from a user. Thus, the system is improved functionally. Also, both files 7, 8 of low speed and high speed are also provided so that the generation information can be fetched by each separate contents by connecting them to a generation managing system 5. In this state, when a user executes a designating operation from a keyboard, an access is executed to a dictionary file 3 in which generation management information is stored so that its contents can be displayed on a display device 1, and also, the generation management information can be changed arbitrarily. In such a manner, the generation information of a data base can be obtained at a arbitrary time, and also, plural generations can be managed integrally.

Description

[Detailed Description of the Invention] [Industrial Application Field] In generation management of a database, the present invention acquires generation information by specifying a dictionary device, selects a storage according to the level of the generation information, and stores the data. This article relates to database generation management methods.

[Background Art] As databases become larger and more diverse, there is an increasing need to manage database generation information. Generally, generation information can be enormous depending on the unit of acquisition, so it is necessary to manage generation information efficiently.

In a conventional database system, a database is connected under a database system (DBMS), and a user's application program issues a processing request to the database using a data description language. In this case, since the database management system has a built-in dictionary device that updates and outputs generation management information, the dictionary device is activated and these processes are performed in response to requests from application programs. I was going.

Therefore, the user cannot directly update or specify generation management information.

On the other hand, as a conventional generation management method, for example,
As described in Japanese Patent No. 1-243541, as a time-series data file management method, there is a method of managing data in a wrap-around manner using acquisition times and intervals. In other words, assuming that the time at which time series data is first acquired is T, and data is acquired sequentially at an acquisition interval t thereafter, the number N of data acquired at an arbitrary time T is N. It is determined by =(Ti-T,)/l. Therefore, by providing a base point time setter, a time-to-number converter, and a divider, time-series data at a desired time can be retrieved accurately and quickly from the database.

[Problem to be solved by the invention]

In the conventional system described in the above-mentioned publication, the management method is implemented using program logic, and therefore, once a set value is set, it cannot be changed until the program is changed or corrected. That is, it is necessary to collect time-series data at regular intervals, and the interval for generation management, storage location, storage expiration date, etc. are all fixed to constant values. Therefore, even if data were to be acquired at an arbitrary time as needed, it was necessary to wait for a fixed interval to acquire the data.

The purpose of the present invention is to solve such conventional problems and provide a database generation management method that can acquire database generation information at any time and manage multiple generations in an integrated manner. It's about doing.

[Means for Solving the Problems] In order to achieve the above object, the database generation management method of the present invention includes (a) built-in database management system;
and a database system comprising a dictionary device that manages database generation information, and a dictionary file that stores the generation information, and a generation system that acquires data according to the generation information between the database management system and the data storage file. A management system is provided, and the dictionary device is made independent from the database system, and the dictionary device is connected to a display device, the dictionary file, and the database management system, respectively, and generation information is transmitted item by item from the display device. When specifying new registration or change registration and specifying the acquisition timing of the generation information, the specified generation information is registered in the dictionary file by the dictionary device, and the database management system registers the generation information in the dictionary. By making a database output request to the generation management system using the generation information registered in the Nari file, the generation management system reads data from the database according to the registered generation information and converts the data into the specified data. The feature is that it outputs to a storage file.

In addition, (b) When generation information in the database is newly registered or changed, the dictionary device specifies changes to the data storage file, so that the dictionary device can specify changes in the data storage file according to the registered generation information item and generation management level. Another feature is that the connection of data storage files can be changed. (c) The dictionary device initially stores the registered generation information in the expansion memory or IC disk within the device, and registers it from the expansion memory or IC disk to a large-capacity optical disk at a predetermined time. Another feature is that it transfers the generated generation information. Furthermore, (d) the dictionary device is characterized in that it changes the interval value that defines the data acquisition interval in the registered generation information, depending on the capacity of the connected data storage file. In addition, (e) the dictionary device retrieves data from April to March of the following year in response to a year call, converts the call unit of generation information into knowledge, and also displays the generation acquisition status. It has characteristics. Furthermore, data for each generation information is distributed and managed in local files via the network, and unrecorded records such as record journals are saved as generation records. .

[For production]

In the present invention, the dictionary device that was conventionally built into the database management system is made external and independent, and the user can access the dictionary file storing generation management information by specifying it from the keyboard. The content can be displayed on a display device, and the generation management information can be changed at will. And by setting up a generation management system,
By issuing a request from the database management system to the generation management system, the generation management information of the database can be read through the dictionary device, and the generation information can be acquired and stored according to the specification. That is, by specifying the generation information to be acquired for each item and specifying the generation information acquisition timing at an arbitrary time, the database can be stored in a file at the acquisition timing.

[Example] Hereinafter, an example of the present invention will be described in detail with reference to the drawings.

FIG. 1 is a block diagram of a database system showing one embodiment of the present invention.

In FIG. 1, 1 is a display device installed in pair with a keyboard as a console, and 2 is a dictionary for accessing the dictionary according to instructions from the user, reading out generation information, and displaying or updating it on the daybrake device 1. device, 3 is a dictionary file that stores generation management information, 4 is a pig base management system that manages the database, 5 is a file that specifies data stored in the database according to the generation information of dictionary file 3. 9 is a collection of one or more files, and is a database designed to improve search and update efficiency; 6 is a database buffer that stores copies of frequently read data; 7 is a database buffer for storing copies of frequently read data; A low-speed, large-capacity data file 8 stores the data to be acquired, and a high-speed, small-capacity data file 8 also stores the data to be acquired.

In FIG. 1, the mechanisms newly provided according to the present invention are a generation management system 5, a low-speed large-capacity file 7, a high-speed small-capacity file 8, and a dictionary device 2. In addition,
The dictionary device 2 has been built into the pigbase management system 4 and has been made external and independent, allowing the user to directly read and change generation information as desired, making it functionally new. The low-speed and high-speed files 7 and 8, which were conventionally connected directly to the database management system 4, are now connected to the generation management system 5, so that they can be retrieved by content of generation information.

When registering database generation management information, the user requests the dictionary device 2 from the display device 1 to read definition information of the database that performs generation management from the dictionary file 3. The dictionary device 2 accesses the dictionary file 3, reads definition information in the generation management information of a predetermined pig base, and displays the definition information on the display device 1.
to be displayed. The user specifies generation management information in the definition information displayed on the display device 1 and registers it in the dictionary file 3 via the dictionary device 2.

The database definition information includes name number, name, age, salary, number of family members, years of service, etc., and corresponding character lengths and attributes. These are the information that defines the database. Generation management information is information for managing generations of the database defined by each definition information, and includes the interval (period) to acquire files, the storage location (file) to acquire, the expiration date to retain, etc. .

The database management system 4 outputs the contents of the database 9 stored in the database buffer 6 to the generation management system 5 to the generation information file 7.8 based on the generation management information registered in the digital storage file 3. Make a request.

=12 Here, both the database management system 4 and the generation management system 5 are CPUs that perform predetermined processing by executing programs, and each has built-in programs that perform their respective functions.

When the generation management system 5 is started up from the database management system 4, it receives generation management information, reads out predetermined data from the database buffer 6 according to the generation management information, and stores the data in the low-speed large-capacity file 7 or the high-speed small-capacity file 8. and store them respectively. The output light and interval of the generation information can be registered by the user via the dictionary device 2 as described above.
It can be specified arbitrarily. Furthermore, by specifying via the dictionary device 2, the user can acquire the database at any timing (date and time).

When displaying and updating generation management information, the user sends the following information from the display device l to the dictionary device 2:
Request display of the generation management information. The dictionary device 2 reads the requested generation management information from the dictionary file 3 and displays it on the display device l. When changing, for example, the value of the acquisition interval of the generation management information, the user changes the value of the acquisition interval of the generation management information displayed on the display device 1. For example, if you want to change the period of acquisition every year to every two years, update the interval value 1 to 2.

In this way, when it is necessary to update the generation information acquisition information, the contents displayed on the display device 1 can be directly rewritten from the keyboard, etc., and the dictionary device 2 can be updated.
It is possible to write to the digital storage file 3 via .

FIG. 2 is a diagram showing an example of generation management information in the dictionary in FIG. 1.

As shown in Figure 2, in this example, database definition information such as fields, lengths, and attributes are specified, and corresponding to each definition information, generation management information such as generation acquisition interval and storage of acquired data are specified. The location and expiration date of retained data are specified. For example, the name number is the employee number registered when joining the company, and the length of the name is 10 characters.
The character and attribute are ■, the interval to be acquired is always acquired as a keyword, and the storage location at the time of acquisition is specified as file l. Further, the name must be 30 characters long, and the attribute C1 is specified to be acquired once a year and stored in file 1. Further, the age requires three characters, the attribute is I, it needs to be acquired twice a year, and it is specified that it is stored in file 1. Also, salary requires 7 characters,
The attribute is ■, acquired at twice-yearly intervals, and file 1
is specified to be stored in . The expiry date for both is undetermined. Of course, this can also be registered in the 30th or 40th year.

When registering or changing generation management information, the corresponding generation management information is displayed together with the database definition information on the display device 1, so all you have to do is update any column of the generation management information. It is registered by writing.

Figure 3 shows the operation flowchart 5 of the generation management system. - It is.

First, a counter value i is initialized by a program in the generation management system 5 (step 51), and then it is determined whether field information DCT(i) of generation management information exists (step 52). Note that the field information DCT is
For example, information such as name number, name, age, and salary in Figure 2, where counter 1 = 1 is the name number, i = 2 is the name, 1 = 3 is the age, i = 4 is the salary, and 4 The same process is repeated. When field information DCT(i) exists, its field information (name number in i-1)
It is determined whether there is a generation information acquisition designation (G (i)) corresponding to (step 53), and if so, the field information is input from the database buffer 6 (step 54). In the case of Figure 2, the name number is used as a keyword every time, the name is specified to be obtained once a year, the age is also obtained once a year, and the salary is specified to be obtained twice a year. There is. Then, at the timing specified by the user (for example, March 31st and February 2018)
In the case of 6 days, it will be obtained on September 30th).

Next, it is determined whether the storage location (○(i)) of the data corresponding to this field information is specified (step 55).
, output to a large capacity file (step 56), or output to a small capacity file (step 57). In the case of Figure 2, all files are file l, that is, large-capacity file 7.
storage is specified.

And once the output to these files is finished,
The counter is updated (step 58), the process returns to the beginning, and the same process is repeated for the number of field information, and then the process ends.

Next, the present invention will be explained in detail.

(i) First, when managing a plurality of generation information in a database, the storage location of generation data can be changed according to each data item and generation management level. In other words, in Figure 2, all field information is stored in the same file, but each field information is stored in a different storage location, for example, name number and name data are stored in file l, and age data is stored in file l. File 2, salary data can be changed as shown in File 3. Furthermore, it is also possible to store data at the generation management level, that is, name and age data once a year in file 1, and data on salaries twice a year in file 2, respectively.

(n) Enable the dictionary device to specify generation management information item by item. For example, in the case of Figure 2, if a name is specified for each field, only the length and attributes of the database definition information corresponding to that name, the interval, storage location, and expiration date of the generation management information will be displayed on the display device. After the item is displayed and the item is specified, the user moves on to the next item so that registration/changes can be made without error.

(iii) A dictionary device for managing generation management information, a disk device for managing generation information, and storage locations can be provided separately depending on the level of generation information. In other words, files are stored in files 1, 2, and 3 according to the dictionary devices A, B, and C, and files 1 and 2 are stored in files 1, 2, and 3 according to the database disk devices A, B, and C.
, 2.3, and furthermore, depending on the generation information interval of 1 year, 2 years, 3 years or more, the file l
.

2.3.

(iv) All generation information is placed in an expanded memory or IC disk, and the generation information is written to an optical disk at a specific point in time. That is, the dictionary file 3 shown in FIG. 1 is used as an optical disk, and the generation information is initially recorded on the extended memory or IC disk in the dictionary device 2 without being written on the optical disk, so that when the memory capacity is insufficient, At this point, this information is transferred to an optical disc.

(V) Provide a function to adjust the interval according to the capacity of the generation data set (file). Also, a method is used in which unrecorded records are stored as they are as generational records. That is, files 1, 2.3 that store data
When the capacity ratio of is 1:2:3, file l, 2.3 is adjusted to store data for intervals of 3 years or more, data for intervals of 2 years, and data for intervals of l + 9- years, respectively. do. For example, unrecorded records such as recording journals can be saved as they are as generational records.

(vi) Generation data can be managed in a distributed manner via a network. In that case, generation records that are accessed less frequently are distributed locally.

(籟) Convert the call unit of generation information into knowledge. for example,
When a fiscal year is given, the period from April to March of the following year is extracted.

Also, display the generation acquisition status. For example, the number of generations is displayed by specifying an item.

(viii) Build a decision support system using generation information for each item. In other words, the support system is for realizing the smooth operation of the database system.
Initial database generation, reconfiguration, failure countermeasures (recovery),
It also performs functions such as operation monitoring. When performing these operations, generation information for each item is used.

(ix) In the bank online system, unrecorded records are stored as generation information. That is, unrecorded records such as recording journals are saved as log information and used as generation information.

[Effects of the Invention] As explained above, according to the present invention, since generation management of the database is controlled by the dictionary device, the generation information acquisition method and storage location can be easily adjusted as necessary. It is possible to obtain database generation information at any time, and as a result, multiple generations can be managed in an integrated manner.

[Brief explanation of drawings]

FIG. 1 is a block diagram of a database system that performs generation management showing an embodiment of the present invention, FIG. 2 is a diagram showing an example of the format of generation management information in FIG. 1, and FIG.
It is an operation flowchart of the generation management system in the figure. ■=Nibu play position, 2: Dictionary device, 3:
Dictionary file, 4: Database system,
5. Generation management system, 6: Database buffer, 7
, 8: File, 9: Database.

Claims (1)

[Scope of Claims] 1. A database system that is built into the database management system and includes a dictionary device that manages database generation information and a dictionary file that stores the generation information, the database management system and A generation management system for acquiring data according to generation information is provided between the data storage file and the dictionary device is made independent from the database management system, and the dictionary device is connected to the display device, the dictionary file, and the database management system. By connecting to each system, specifying generation information item by item from the display device, registering new or changing information, and specifying the acquisition timing of the generation information, the specified generation information will be transferred to the dictionary device. By registering it in the dictionary file, and making a database output request to the generation management system by the database management system using the generation information registered in the dictionary file,
A database generation management method characterized in that the generation management system reads data from a database according to registered generation information and outputs the data to a specified data storage file. 2. When the generation information in the database is newly registered or changed, the dictionary device specifies changes to the data storage file, and stores the data according to the registered generation information item and generation management level. 2. The database generation management method according to claim 1, wherein file connections are changed. 3. The dictionary device initially stores the registered generation information in the expansion memory or IC disk within the device, and then stores it in the expansion memory or IC disk at a predetermined time.
3. The database generation management method according to claim 1, further comprising transferring generation information registered from a C disk to a large-capacity optical disk. 4. The dictionary device according to claim 1 or 2, wherein the dictionary device changes an interval value defining a data acquisition interval in the registered generation information according to the capacity of the connected data storage file. The database generation management method described in 3. 5. The dictionary device according to any one of claims 1 to 4 is characterized in that in response to a year call, the year data is retrieved, the call unit of the generation information is converted into knowledge, and the generation acquisition status is displayed. Database generation management method described in one. 6. The data for each generation information is managed in a distributed manner in local files via a network, and unrecorded records such as record journals are stored as they are as generation records. A database generation management method described in one of them.