JPH04120663A - System for allocating data base area - Google Patents

Abstract

PURPOSE:To easily set an area for a table depending upon the data amount of each table by allocating table areas in a user-designated area in accordance with the data amount of each table. CONSTITUTION:When a table A is defined against a data base X by designating a file name, an area in a user designated area 7 is allocated to the table A and it is registered that the table A has been defined in a data base X defining information area 2 as the content 8 of a data base X defining information area together with the file name. At the time of referring to the table A, the information of the table A is obtained on the basis of the content 8 of the area 2 and, since the table A is in the area 7, the actual data of the table A are fetched from the area 7.

Description

DETAILED DESCRIPTION OF THE INVENTION [Field of Industrial Application] The present invention relates to a database area allocation method for allocating database areas in a relational database system.

[Conventional technology]

FIG. 3 is a block diagram showing the configuration of a conventional database area allocation system. In FIG. 3, 1 is a database X area that stores, for example, database X, 2 is a database X definition information area that stores definition information of database The table C area, 4, is also a table B eJ area, 5, which stores the actual data of table B.
Similarly, is the table C area that stores the actual data of table C.

FIG. 4 is a diagram showing the contents of the definition information of the database This is the content of database X definition information.

Next, the operation will be explained. When table A is defined for database It is registered as database X definition information content 6 in the database. When referring to table A, the information on table A is obtained from the database X definition information content 6 of the database X definition information area 2, and the actual data of table A is taken out from the table A area 3.

Problem to be solved by invention C] Conventional database area allocation was performed as described above, and all actual allocation of areas to tables was done by a relational database system. There were problems such as having to consider the amount of data in the entire table and not being able to specify a user file as the table area.

This invention was made to solve the above-mentioned problems, and it is possible to easily set the table area according to the amount of data for each table, and also to specify a user file as the table area. The aim is to obtain a possible database space allocation method.

[Means to solve the problem]

The database area allocation method according to the present invention includes a user specified area 7 that can be specified as a file by the user, and allocates table areas and the like according to the amount of data for each table to this user specified area 7.

[Effect]

In the user designated area 7, table areas and the like are allocated according to the amount of data for each table.

〔Example〕

FIG. 1 is a block diagram showing the configuration of a data area allocation system according to an embodiment of the present invention.

In FIG. 1, components corresponding to those shown in FIG. 3 are designated by the same reference numerals, and their explanations will be omitted. In FIG. 1, numeral 7 is a user-specified area that can be designated as a file by the user, and in this embodiment, the area of table A is allocated to the user-specified area 7. Therefore, the actual data of table A is stored in the user specified area 7.

FIG. 2 is a diagram showing the contents of definition information of database X, and 8 in the figure is the contents of database X definition information including table name, file name, number of columns, column name, column data type, and data length. In the explanation here, file-a corresponds to the user specified area 7.

Next, the operation will be explained. As shown in Figure 2, the definition of table A for database X is as follows:
le-a) If specified, table A is allocated to user specified area 7, and the definition of table A is registered together with the file name in database X definition information area 2 as database X definition information area contents 8. . When referring to table A, information on table A is obtained from database X definition information content 8 in database It will be done. Note that if a file name is not specified when defining a table, the same operation as before is performed.

According to the above embodiment, by specifying a file area prepared in advance by the user and using it as an area for table tables in the database, it is possible to secure an area according to the amount of data for each table, and also to freely can be assigned. That is, in the above embodiment, in addition to the initially set database-dedicated area, the user can freely designate a user-specified area (file area) for storing data, etc., and manage the database for data in this area. . Therefore, by allocating a user-designated area to specific data that exceeds the initially set database-dedicated area, flexible database area operation is possible. Furthermore, the user-specified area is not an area that is generally released to the database, but is an area that is individually allocated for a specific purpose. For example, it is allocated as a data file for storing large amounts of data. In this case, the large data area can be operated separately from the database area. Furthermore, the database area can be efficiently used for storing other data that is not very large-scale.

In addition, in the above embodiment, it is shown that the user specified area 7 is specified for table A, but the user specified area is specified for data hess definition information and other attached information (index information, operation log information, etc. that are database functions). may also be specified.

〔Effect of the invention〕

As described above, according to the present invention, a user-specified area that can be specified as a file by the user is provided, and a table area corresponding to the amount of data for each table is allocated to this user-specified area. The table area can be easily set according to the amount of data, and a file for the user can be specified as the table area. Further, according to the present invention, it is possible to flexibly set a table area and back up a large-capacity table.

[Brief explanation of drawings]

FIG. 1 is a block diagram showing the configuration of a data access definition information system according to an embodiment of the present invention, FIG. 2 is a diagram showing the contents of database X definition information in this embodiment, and FIG. The layout is a block diagram showing the configuration of the method, and FIG. 4 is a diagram showing the contents of the database X definition information in this juken row. 2... Database X definition information area, 4... Table B area, 5... Table C area, 7... User specified area. Agent Patent Attorney Jun Miyazono Figure 1 FILE Chle-a') Unsolved, ELECT ROM Figure 2 Figure 3 CRhiTE TA8LE Reference 5ELEC ding X A (a+ ROM Char (5), Q2-ChQr(5) )) Figure 4

Claims (1)

[Claims] In a relational database system that has a table area that stores multiple tables showing information related to the database, and a database definition information area that stores database definition information including table names, etc., a user specification that can be specified as a file by the user. A database area allocation method characterized by providing an area and allocating table areas and the like according to the amount of data for each table to this user-specified area.