KR20010009728A - apparatus and method for data base management in real-time memory DBMS - Google Patents

Abstract

PURPOSE: An apparatus and method for managing a database of a real-time memory DBMS(Data Base Management System) is provided to automatically generate, modify and cancel indexes and tables by separating and managing an integrated database by the table, without interrupting a database in case that addition, modification or cancellation for a table is requested. CONSTITUTION: The apparatus for managing a database is comprised of a database(10), a DBMS(20), an ODBG(On-line Data Base Generator)(30) and a disk(40). The database(10) is separated by the table and stored in a shared memory. The DBMS(20) is connected to the database(10) and manages the database(10). The ODBG(30) generates a table in the database(10) on line and modifies the structure of an existing table. The disk(40) is used as an auxiliary memory to generate a new or modified table under the control of the ODBG(30) in case that the ODBG(30) generates a table in the database(10) or modifies the structure of an existing table.

Description

Apparatus and method for data base management in real-time memory DBMS}

The present invention relates to an apparatus and method for managing a database of a real-time memory database management system. In particular, a single integrated database is managed separately by a table to add / change / delete a table. An apparatus and method for managing a database of a real-time memory database management system for automatically creating / modifying / deleting indexes and tables without interruption.

In general, a mobile communication system collects data in one place for comprehensive management and management of a large amount of subscriber data, and employs a database management device to access, modify, manage, and produce data in real time. It is.

1 is a diagram illustrating a configuration of a database management apparatus used in a conventional mobile communication system. As shown in Fig. 1, a conventional database management apparatus includes a database 1 and a database management system 5 (hereinafter referred to as a DBMS). Here, the database 1 is stored in the shared memory, and is composed of a table in which actual data is stored and an index used to search for desired data. In addition, the DBMS 5 is connected to the database 1 to manage the database 1.

The conventional database management apparatus having the above-described configuration includes and manages multiple tables in one integrated database, and manages by integrating and managing indexes corresponding to each table as one. Only one memory ID is required.

Hereinafter, an operation process of a database management apparatus used in a conventional mobile communication system will be described with reference to FIG. 1.

In the database management apparatus used in the conventional mobile communication system, the DBMS 5 loads into the shared memory after generating or changing data in an offline state. After killing 5), the database is created / changed offline, and the DBMS 5 restarts using the newly created / modified database.

That is, in the conventional database management apparatus, when changing the data of the database in accordance with the addition of the function, the database is created / modified after the DBMS 5 is stopped. Therefore, the data service must be stopped when the database is created / modified. There is a problem.

SUMMARY OF THE INVENTION The present invention has been made to solve the above-mentioned problems. By managing a single integrated database in table units, an index and a table are automatically managed without interruption of data service when a table is required to be added, changed, or deleted. An object of the present invention is to provide an apparatus and method for managing a database of a real-time memory database management system that can be created, changed, or deleted.

1 is a diagram showing the configuration of a database management apparatus of a conventional real time memory DBMS.

2 is a diagram showing the configuration of a database management device of a real-time memory DBMS according to the present invention.

3A to 3C are diagrams for explaining a database management method of a real-time memory DBMS according to the present invention.

*** Explanation of symbols for the main parts of the drawing ***

10. Database,

20.Data Base Management System (DBMS),

30.On-line data base generator (ODBG),

40. Disc

The database management apparatus of the real-time memory database management system of the present invention for achieving the above object, the database is divided into tables and stored in the memory; Database management means for managing the database; Auxiliary storage means for generating and storing a table to be created / modified when creating / modifying a table; And a data necessary for creating a table, generating a table to be created / modified by controlling the auxiliary storage means when creating / modifying / deleting a table, and notifying the database management means of information about the table. And an online database generating unit for loading the table created and stored in the auxiliary storage means into the database.

The table is a data structure composed of data related to each other.

On the other hand, the database management method of the real-time memory database management system of the present invention, the table generation process of generating a new table by creating a new table in accordance with the data addition request, loading into the shared memory; Creating a table whose structure is changed according to a data change request, deleting a table whose structure is to be changed in shared memory, and changing the table by loading the table whose structure is changed into shared memory; And deleting a table from the shared memory according to a data deletion request.

In addition, the table generation process includes the steps of: creating a new table in the auxiliary storage means based on data necessary for creating the table; Creating and allocating a shared memory area in which the new table is to be located; Loading the new table into the shared memory area; After allocating another shared memory area, creating an index using the table and loading it into the other shared memory area; Notifying database management means of a shared memory ID for the new table and index; Adding the informed shared memory ID to the new table and index.

The table changing process includes the steps of: generating, in the auxiliary storage means, a table whose structure is changed based on the data necessary for creating the table; Notifying the database management means of the ID of the table whose structure has changed; Deleting the shared memory of the table and the index based on the informed ID of the table; Creating and allocating a shared memory area for the generated table; Loading the table into the shared memory area; Allocating another shared memory area, and then creating an index using the loaded table and loading it into the other shared memory area.

In addition, the table deletion process includes the step of notifying the database management means of the ID of the table to be deleted; And deleting the shared memory of the table and the index based on the informed ID of the table.

Hereinafter, an apparatus and method for managing a database of a real-time memory database management system according to a preferred embodiment of the present invention will be described in detail with reference to the accompanying drawings.

2 is a diagram illustrating a configuration of a database management apparatus of a real-time memory database management system according to the present invention. As shown in FIG. 2, a database management apparatus of a real-time memory database management system according to the present invention includes a database 10, a DBMS 20, and an online database generator (hereinafter, referred to as “On-line Data Base Generator”). 30) and a disk 40. The " ODBG "

In such a configuration, the database 10 is divided into tables and stored in the shared memory. Here, the database 10 divided into table units is composed of a table in which actual data is stored and an index in which table management information used when a desired data is to be searched is stored. Table of dimension arrays.

The DBMS 20 is connected to the database 10 and manages the database 10.

The ODBG 30 has data necessary for creating a table, creates a table in the database 10 online, and changes the structure of an existing table.

The disk 40 is used as an auxiliary storage device for creating a new table or a changed table under the control of the ODBG 30 when creating a table in the database 10 or changing the structure of an existing table.

Table 1 is a table showing a mapping table showing the correspondence between the table and the shared memory address applied to the present invention.

Table id Shared memory key Shared memory ID Start address Availability status 0 Table 1 color phosphorus 1 Table 1 color phosphorus 1 Table 1 color phosphorus 1 Flag 1 One Table 2 color 2 Table 2 color 2 Table 2 color 2 Flag 2 ： ： ： ： : n-1 Table n color n Table n color n Table n color n Flag n

In Table 1, the table ID is an identifier given to each table to identify each table, the shared memory key is a number or letter that forms an area used to locate each table's distinction or location, and is shared. The memory ID is an integer assigned by the operating system based on the shared memory key value. The start address is the address where the table starts, and the availability status is a flag used to manage that table. With flag, you can check whether this table is used with this flag.

3A to 3C are diagrams for explaining a database management method of the real-time memory database management system according to the present invention. The database management method of the real-time memory database management system according to the present invention includes a table creation process for creating a new table online, a table change process for changing the structure of an existing table, and a table deletion process for deleting an existing table. Is done.

First, when a new table needs to be created due to the addition of subscribers, a new table is generated by performing a table generation process. FIG. 3A illustrates a table creation process in a database management method of a real-time memory database management system according to the present invention. This is for explaining.

The ODBG 30 creates a new table on the disk 40 based on the data necessary for creating the table (S1), and then creates and allocates a shared memory area in which the table generated in the above-described process S1 is located (S3). Thereafter, the ODBG 30 loads the new table created in the disk 40 in the shared memory area created in step S3 (S5), creates and allocates another shared memory area in which the index is located, and loads in the step S5. After generating an index using the prepared table, the generated index is loaded in the corresponding memory area (S7). Thereafter, the ODBG 30 notifies the DBMS 20 of the table loaded into the shared memory in the step S5 and the shared memory ID for the index loaded in the step S7 (S9), and shares the data from the ODBG 30. The DBMS 20 receiving the memory ID adds the received shared memory ID to a new table and index of the shared memory 10 (S11).

If a table change (deleting an attribute, inserting an attribute, changing a data type, or changing a data size) is required due to a change in subscriber data while performing a service using a table created through the above-described table creation process, change the table. 3B is a diagram for explaining a table changing process in a method of managing a database of a real-time memory database management system according to the present invention.

First, the ODBG 30 generates a table whose structure is changed on the disk 40 based on the data necessary for creating the table (S21), and informs the DBMS 20 of the ID of the table whose structure has been changed (S23). The DBMS 20 notified of the table whose structure has been changed from the ODBG 30 obtains the start address of the table and the index based on the table ID notified from the ODBG 30, and uses the start address. Delete the shared memory of the corresponding table and index (S25). The DBMS 20 creates and allocates a shared memory area for the table created in step S21 (S27), loads the new table created in the disk 40 into the shared memory area created in step S27 (S29). After creating and allocating another shared memory area, an index is generated using the loaded table and loaded into the corresponding shared memory area (S31).

Meanwhile, when deleting a table by deleting a subscriber, the table is deleted by performing a table deletion process. FIG. 3C is a view for explaining a table deletion process in a database management method of a real-time memory database management system according to the present invention. to be.

First, the ODBG 30 notifies the DBMS 20 of the ID of the table to be deleted (for example, Table 2) (S31). The DBMS 20 obtains the starting address of the table and the index based on the ID of the table to be deleted received from the ODBG 30, and deletes the shared memory of the table and the index using the starting address (S33). ).

As described above, when the database 10 is changed because the table is created, deleted, or changed, each shared memory key, shared memory ID, start address, and availability state of the table are changed. In this case, the information related to the newly created table is added to the mapping table. When the table is deleted, the information related to the deleted table is reset. When the table structure is changed, the information related to the restructured table is changed.

The database management apparatus and method of the real-time memory database management system of the present invention are not limited to the above-described embodiments, and may be variously modified and implemented within the range permitted by the technical idea of the present invention.

According to the apparatus and method for managing a database of the real-time memory database management system of the present invention as described above, when adding / modifying / deleting a table is required by separating and managing one integrated database in table units You can create / modify / delete a table while online, which can create / manage indexes and tables without interrupting data services.

Claims (6)

A database divided into tables and stored in a memory; Database management means for managing the database; Auxiliary storage means for generating and storing a table to be created / modified when creating / modifying a table; And a data necessary for creating a table, generating a table to be created / modified by controlling the auxiliary storage means when creating / modifying / deleting a table, and notifying the database management means of information about the table. And an on-line database generating unit for loading the table generated and stored in the auxiliary storage means into the database. 2. The database management apparatus of claim 1, wherein the table is a data structure composed of data related to each other. Creating a new table by loading a new table in shared memory according to a data addition request and creating a new table; Creating a table whose structure is changed according to a data change request, deleting a table whose structure is to be changed in shared memory, and changing the table by loading the table whose structure is changed into shared memory; And a table deletion process of deleting a corresponding table from the shared memory according to a data deletion request. The method of claim 3, wherein the table generation process Creating a new table in the auxiliary storage means based on the data necessary for creating the table; Creating and allocating a shared memory area in which the new table is to be located; Loading the new table into the shared memory area; After allocating another shared memory area, creating an index using the table and loading it into the other shared memory area; Notifying database management means of a shared memory ID for the new table and index; Adding the informed shared memory ID to the new table and index. The method of claim 3, wherein the table change process is Generating a table whose structure has been changed in accordance with data necessary for creating the table to the auxiliary storage means; Notifying the database management means of the ID of the table whose structure has changed; Deleting the shared memory of the table and the index based on the informed ID of the table; Creating and allocating a shared memory area for the generated table; Loading the table into the shared memory area; And assigning another shared memory area to create an index using the loaded table and to load the shared memory area into the other shared memory area. The method of claim 3, wherein the table deletion process Notifying the database management means of the ID of the table to be deleted; And deleting the shared memory of the corresponding table and the index based on the informed ID of the table.