公开(公告)号：US20070016600A1

公开(公告)日：2007-01-18

申请号：US11433258

申请日：2006-05-12

申请人： Hae Bae ,  Jae Lee ,  Young Oh ,  Kyoung Kim ,  Myoung Kim ,  Soon Park ,  Ho Kim ,  Yong Jang ,  Byeong You ,  Sang Eo ,  Young Jeong

发明人： Hae Bae ,  Jae Lee ,  Young Oh ,  Kyoung Kim ,  Myoung Kim ,  Soon Park ,  Ho Kim ,  Yong Jang ,  Byeong You ,  Sang Eo ,  Young Jeong

IPC分类号： G06F7/00

CPC分类号： G06F17/30592 ,  G06F17/30333 ,  G06F17/30336 ,  Y10S707/99942

摘要： 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.

摘要翻译： 本发明是提供一种使用在空间数据仓库中部分索引转移的索引重组的系统和方法，其通过组织和转移具有符合索引的部分索引的簇来最小化用于索引重组的搜索，拆分和重新调整的成本 结构，使得部分索引可以直接插入到现有索引中，从而确保连续和稳定的数据处理，索引重组方法包括：通过构建器将从源数据库提取的数据聚类成与索引结构一致的第一步; 产生部分索引并将部分索引传送到根据聚类生成的集群的第二步骤; 在空间数据仓库服务器中记录未分配的物理连续空间中传送的部分索引的第三步骤; 以及在现有索引中插入记录的部分索引的第四步骤。