专利快速检索-快速检索全球专利，免费商用专利数据库-IPRDB

1. 发明授权

US06965899B1 Online reorganization and redefinition of relational database tables 有权
标题翻译：关系数据库表的在线重组和重新定义
公开(公告)号：US06965899B1
公开(公告)日：2005-11-15
申请号：US09968703
申请日：2001-09-28
申请人： Mahesh Subramaniam , Joan Loaiza
发明人： Mahesh Subramaniam , Joan Loaiza
IPC分类号： G06F17/30
CPC分类号： G06F17/30339 , Y10S707/99943
摘要： Techniques are provided for allowing the reorganization and/or redefinition of data in a relational database with minimal or no downtime by allowing “online” reorganization/redefinition of the data. According to one aspect of the invention, an empty revised table is created in the same schema as the target table. The revised table is created with the attributes that are desired for the reorganization/redefinition of the target table. Triggers, constraints, grants and indexes that are associated with the target table are replicated for the revised table. The reorganization/redefinition is performed by using an underlying mechanism that involves using incrementally maintainable materialized views.According to one feature, the revised table is initialized and periodically synchronized with the target table. After the reorganization and/or redefinition is complete on the revised table, the revised table and the target table switch identities such that the revised table is now the target table and the target table becomes the revised table.
摘要翻译：提供了技术，允许通过允许“在线”重组/重新定义数据，使关系数据库中的数据重新组织和/或重新定义最少或无停机时间。根据本发明的一个方面，在与目标表相同的模式中创建空修订表。修改后的表格将使用目标表重组/重新定义所需的属性创建。与目标表关联的触发器，约束，授权和索引将复制为修订的表。重组/重新定义是通过使用涉及使用增量可维护的物化视图的底层机制来执行的。根据一个特征，修改的表被初始化并且与目标表周期性地同步。修改后的表格和/或重新定义完成后，修订表和目标表切换标识，使修订表现在成为目标表，目标表成为修订表。

IPRDB

热门服务

关于我们

友情链接

联系方式