Abstract: The present invention is to provide a system and a method for index reorganization using a partial index transfer in a spatial data warehouse that minimize costs of search, split and readjustment for the index reorganization by organizing and transferring clusters with partial indexes in conformity with an index structure so that the partial indexes can be inserted directly into the existing index, thus ensuring continuous and stable data processes, the index reorganization method comprising: a first step of clustering data extracted from the source database in conformity with an index structure via the builder; a second step of generating partial indexes and transferring the partial indexes to a cluster generated according to the clustering; a third step of recording the transferred partial indexes in physically consecutive spaces, not allocated, in the spatial data warehouse server; and a fourth step of inserting the recorded partial indexes in an existing index.

Abstract: The present invention provides a recovery method using extendible hashing-based cluster logs in a shared-nothing spatial database cluster, which eliminates the duplication of cluster logs required for cluster recovery in a shared-nothing database cluster, so that recovery time is decreased, thus allowing the shared-nothing spatial database cluster system to continuously provide stable service. In the recovery method, if a failure occurs in a predetermined node, a second node in a group, including the node, records cluster logs in main memory on the basis of extendible hashing. If the node that has failed recovers itself using a local log, the second node in the group transmits cluster logs in packets to a recovery node that is the failed node. If the recovery node reflects the received cluster logs and maintains consistency with other nodes in the group, the recovery node resumes normal service.

Abstract: Disclosed herein is a method of designing a query classificaton component for a multilevel DataBase Management System (DBMS). The method includes determining whether a plan tree, which is used for query processing, is input; if the plan tree is input, designing the query classification component to output locations for respective tables, at which data must be referenced in conjunction with the plan tree, and corresponding predicates; and transferring the locations for respective tables and the corresponding predicates to respective storage managers and causing each of the storage managers to process corresponding data.

Abstract: The present invention relates to a lazy bulk insertion method for moving object indexing, which utilizes a hash-based data structure to overcome the disadvantages of an R-tree, and uses two buffers to simultaneously store operations in the buffers and process queries stored in the buffers, so that the overall update cost can be reduced. In the lazy bulk insertion method, a buffer is substituted and a state of the buffer is changed to a deactivated state if an input query cannot be stored in the buffer. Operations stored in the deactivated buffer are sequentially analyzed, information about objects corresponding to respective operations is obtained from a direct link to analyze the operations, and thus the operations are aligned on the basis of object IDs. Operations, aligned in ascending order of spatial objects, are identified depending on respective objects, effectiveness of the operations is determined, and thus the operations are realigned on the basis of terminal node IDs.

Abstract: The present invention provides a recovery method using extendible hashing-based cluster logs in a shared-nothing spatial database cluster, which eliminates the duplication of cluster logs required for cluster recovery in a shared-nothing database cluster, so that recovery time is decreased, thus allowing the shared-nothing spatial database cluster system to continuously provide stable service. In the recovery method, if a failure occurs in a predetermined node, a second node in a group, including the node, records cluster logs in main memory on the basis of extendible hashing. If the node that has failed recovers itself using a local log, the second node in the group transmits cluster logs in packets to a recovery node that is the failed node. If the recovery node reflects the received cluster logs and maintains consistency with other nodes in the group, the recovery node resumes normal service.