KR101049945B1 - Object reorganization apparuatus and method - Google Patents

Abstract

PURPOSE: A device and method for reorganizing object are provided to prevent performance deterioration of a system according to a time which is not allowable for using when reorganizing the objects by reorganizing the object based on access level and automatically selecting objects to be reorganized. CONSTITUTION: An object information grasping unit(110) grasps object information including access information about the object and information about storing space of each object of database. A firstly selecting unit(120) uses information about the storing space of the object and selects a reorganized target object based on data storing distribution of the object. A secondly selecting unit(130) selects objects which are under a constant level as reorganizing object. A reorganizing unit(140) reorganizes objects corresponding to both the reorganizing target and available object.

Description

Object reorganization apparatus and method {Object reorganization apparuatus and method}

The present invention relates to object reorganization that efficiently rearranges object data in a scattered database.

Due to the frequent creation and update of objects in the database, the data distribution of the objects becomes sporadic, and thus, it becomes difficult to manage the objects efficiently, which takes a lot of time to access the objects.

The technical problem to be achieved by the present invention is to efficiently rearrange scattered data according to the continuous use of database objects, minimize object downtime due to reorganization work, improve system availability and ensure stable system operation. An object reorganization apparatus and a method for enabling the same are provided.

In order to solve the above technical problem, an embodiment of the object reorganization apparatus according to the present invention, an object for grasping information about the object including information about the storage space of each object in the database and access information for each object Information grasping unit; A primary sorting unit which selects a reorganization target object by identifying whether a storage distribution of data of each object corresponds to a preset reorganization target criterion based on the information on the storage space of each object; A secondary sorting unit configured to classify objects having a predetermined number of accesses to or below an object as a reorganizable object at an estimated time of reorganization operation based on the access information of each object; And a reorganization unit for reorganizing objects corresponding to both the reorganization target object and the reorganization object.

In order to solve the above technical problem, an embodiment of the object reorganization method according to the present invention, the step of grasping information about the object including information about the storage space of each object in the database and access information for each object ; Selecting a reorganization target object by determining whether a storage distribution of data of each object corresponds to a predetermined reorganization target criterion based on the information on the storage space of each object; Selecting objects as reorganizable objects in which the number of accesses to the objects is less than or equal to a predetermined criterion in the expected reorganization work time based on the access information for each object; And performing reorganization on objects corresponding to both the reorganization target object and the reorganization object.

According to the present invention, not only objects for reorganization work are sorted by an automated method according to a predetermined criterion, but also the degree of access of the object is determined and the reorganization is performed when the degree is low, so the system according to the unavailability time when the object is reorganized. It can prevent the performance deterioration.

1 is a view showing an example of an object reorganization apparatus according to the present invention, and
2 is a flowchart illustrating an embodiment of an object reorganization method according to the present invention.

Hereinafter, with reference to the accompanying drawings will be described in detail the object reorganization apparatus and method according to the present invention.

1 is a diagram illustrating an example of an object reorganization apparatus according to the present invention.

Referring to FIG. 1, the object reorganization apparatus 100 includes an object information extracting unit 110, a primary sorting unit 120, a secondary sorting unit 130, and a reorganizing unit 140.

The object information extracting unit 110 grasps information 150 about the objects stored in the database. Specifically, the object information extracting unit 110 collects information on the storage space of the disk where the objects are stored, authority of each object, information such as data type and routine, and access information about the object from the object information DB 150. . Through such information, it is possible to determine what distribution of object data is stored in the disk, how the index of the object is configured, and how much data is increased. Since this information is usually provided by the system frame in which the database is constructed, it is desirable to obtain this information. For example, in the case of an IBM mainframe, the object information extractor 110 queries the DB2 catalog table and the DB2 Real-Time Statistics (RTS) table (SYSTABLEPART, SYSINDEXPART, TABLESPACESTATS, INDEXSPACESTATS, etc.) for information about each object. It can collect and store and analyze the usage status of SQL (Structured Query Language) for DB objects through IBM Query Mointor (QM) to analyze and save by date and day.

The primary sorting unit 120 selects the objects to be reorganized by identifying whether the objects correspond to the reorganization target criteria based on the information on each object collected and analyzed by the object information extraction unit 110. The reorganization target criterion may use a distribution tendency of the object data, an index configuration of the object, an increase amount of the object data, and the like. The criteria for reorganization are preferably set in advance by a database administrator (DBA) in consideration of system performance and storage space. For example, if the actual size of the object data and the actual storage space to be referred to for reading the object data are more than a certain ratio, that is, if the distribution tendency of the data is distributed more than a certain standard, the reorganization target criteria may be used. Can be. Or, if the amount of data increase is more than a certain level may be a reorganization criteria, each of these conditions may be applied together to be a reorganization criteria when all or some conditions are satisfied. The primary sorting unit preferably stores information on the selected reorganization target objects in a separate storage space (database or file).

The secondary sorting unit 130 sorts objects that are not currently used or use less as reorganizable objects. For example, the secondary sorting unit selects objects whose access is less than or equal to a predetermined criterion during the current reorganization operation through the SQL usage status information of the objects. For example, if the reorganization criterion is set to less than 1000 SQL usage, the secondary sorter reorganizes objects with statistically less than 1000 SQL usage in the expected reorganization time zone based on the SQL usage information for each object. Selectable objects. The secondary sorting unit 130 preferably stores information of the sorted reorganizable objects in a separate storage space (such as a database table or a file). In addition, the secondary sorting unit 130 may be configured to sort the object available objects only for the objects selected by the primary sorting unit 120 as the object target object.

The reorganization unit 140 performs reorganization 140 on objects that are simultaneously selected as a reorganization target object and a reorganization object by the primary sorting unit 120 and the secondary sorting unit 130. The reorganization unit 140 may perform a reorganization operation on each object by performing a reorganization command for each object. In the case where the reorganization work is performed at the same time, it is desirable to control the maximum number of concurrently executed jobs so that the reorganization work is performed efficiently. For example, when implemented in an IBM frame, the reorganization unit 140 generates reorganization by generating a job control language (JCL) for reorganization.

The reorganization unit 140 may check whether the reorganization is possible once again in the actual reorganization time slot for the reorganizable objects before performing the reorganization. That is, since the expected reorganization time zone and the actual reorganization execution time zone applied when the object is screened by the secondary screening unit 130 may be different due to the work scheduling of the system, the reorganization unit 140 selects the screening conditions of the secondary screening unit at the actual reorganization time zone. It is desirable to apply it again to see if reorganization is possible. The reorganization unit 140 may also perform a table modification operation (ALTER operation) before performing the reorganization if necessary. For example, the reorganization unit 140 performs a table modification operation (ALTER operation) when the extension number of the SAM file storing the reorganization objects is more than a predetermined number (for example, three times).

The reorganization unit 140 stores the results of such work in a separate database table 160 so that the manager 170 can inquire information such as an error or a result of the reorganization work.

2 is a flowchart illustrating an embodiment of an object reorganization method according to the present invention.

Referring to FIG. 2, the object reorganization apparatus collects and stores object information (S200). The object information includes information about the storage space of the object data to determine how sporadic the data distribution of the objects is, and information indicating the degree of access to the object, such as how much the object is used at a particular point in time. In the case of IBM, this object information can be obtained through QM (Query Manager), DB2 catalog table, DB2 RTS table, and so on.

The object reorganization apparatus selects an object having a degree of distribution of data equal to or more than a predetermined standard using the collected object information as a reorganization target object (S210). The degree of distribution of data can be determined through the distribution of object data or directly or indirectly through various information such as index composition and data increase, which can be set in various ways by the administrator in terms of system management. According to the selection criteria of the reorganization target object of the administrator, object information necessary for this is collected in the salping object information collecting step.

The object reorganization apparatus also selects an object having no access in the reorganization expected time zone or access below a predetermined threshold value as a reorganizable object based on the degree of access to the object (S220). The reclassification of the reorganizable object may be configured to separate the reclassifiable object only for the objects that are performed separately from each screening process of the reorganization target object or selected for reorganization.

The object reorganization apparatus performs reorganization on objects that are a reorganization target object and a reorganization object (S230). Since the actual recombination time and the expected reorganization expected time when screening reorganizable objects may differ depending on the system's job scheduling, access to the objects in the real time of the reorganization for those objects once again before reorganization is performed. It is preferable to perform a process of screening whether or not the degree is an object of less than a predetermined reference value. You can also perform database table modifications (ALTER) if necessary before reorganization.

The object reorganization apparatus stores the result of the reorganization in a separate table so that the administrator can determine whether the reorganization is correctly performed or if a failure occurs when the reorganization is performed.

The present invention can also be embodied as computer-readable codes on a computer-readable recording medium. The computer-readable recording medium includes all kinds of recording devices in which data that can be read by a computer system is stored. Examples of computer-readable recording media include ROM, RAM, CD-ROM, magnetic tape, floppy disks, optical data storage devices, and the like. The computer readable recording medium can also be distributed over network coupled computer systems so that the computer readable code is stored and executed in a distributed fashion.

So far I looked at the center of the preferred embodiment for the present invention. Those skilled in the art will appreciate that the present invention can be implemented in a modified form without departing from the essential features of the present invention. Therefore, the disclosed embodiments should be considered in an illustrative rather than a restrictive sense. The scope of the present invention is shown in the claims rather than the foregoing description, and all differences within the scope will be construed as being included in the present invention.

Claims (9)

An object information grasping unit that grasps information about an object including information about a storage space of each object in a database and access information about each object;
A primary sorting unit which selects a reorganization target object by identifying whether a storage distribution of data of each object corresponds to a preset reorganization target criterion based on the information on the storage space of each object;
A secondary sorting unit configured to classify objects having a predetermined number of accesses to or below an object as a reorganizable object at an estimated time of reorganization operation based on the access information of each object; And
And a reorganization unit configured to reorganize objects corresponding to both the reorganization target object and the reorganization object.
The realignment unit,
Before reorganizing the objects corresponding to both the reorganization target object and the reorganization object, the objects of which the number of accesses to the object is less than or equal to a predetermined criterion for the actual reorganization time zone, not the estimated reorganization time, are reselected. Object reorganization device. The method of claim 1, wherein the object information grasping unit,
The DB2 catalog table and DB2 RTS table to query the information about the storage space of each object, the object reorganization device characterized in that to grasp the access information for each object through the SQL usage status. delete The method of claim 1,
And the reorganization unit performs a modification of a database table before performing the reorganization. Identifying information about an object including information about a storage space of each object in the database and access information about each object;
Selecting a reorganization target object by determining whether a storage distribution of data of each object corresponds to a predetermined reorganization target criterion based on the information on the storage space of each object;
Selecting objects as reorganizable objects in which the number of accesses to the objects is less than or equal to a predetermined criterion in the expected reorganization work time based on the access information for each object; And
And performing reorganization on objects corresponding to both the reorganization target object and the reorganization object.
And re-selecting the objects whose number of accesses to the object is less than or equal to a predetermined criterion for the actual time of the reorganization, not the expected reorganization time, before performing the reorganization. The method of claim 5, wherein identifying information about the object comprises:
Querying the DB2 catalog table and the DB2 RTS table to obtain information about the storage space of each object; And
Identifying access information of each object through a SQL usage status; object reorganization method comprising a. delete 6. The method of claim 5,
And prior to performing the reorganization, performing a modification operation of a database table. A computer-readable recording medium having recorded thereon a program for performing the method according to claim 5 or 6.

Images