-
1.发明授权System and method for identifying and maintaining base table data blocks requiring deferred incremental integrity maintenance 失效用于识别和维护需要延迟增量完整性维护的基表数据块的系统和方法公开(公告)号：US07167878B2
公开(公告)日：2007-01-23
申请号：US10423407
申请日：2003-04-25
CPC分类号： G06F17/30371 , G06F17/30592 , Y10S707/99955
摘要： A block map is associated with a multi-dimensionally clustered (MDC) base table in a database to maintain a “free” or “in use” status for each of the contiguous blocks in the table. Additionally, information may be stored in the block map to indicate whether, after loading data, a given block in the base table requires constraint checking operation or whether, based on changes to the block, a materialized query table dependent upon the table requires a refresh operation. Each time data is loaded into the table, the associated block map is updated. When delayed constraint check or refresh operations are to be performed, the block map is consulted to learn which blocks require the operations. After one of the constraint check or refresh operations is performed, the associated block map is again updated. The block map enables a method to efficiently identify data blocks in a base table, changes to which trigger incremental constraint checking operations and incremental maintenance operations of dependent materialized query tables.
摘要翻译： 块映射与数据库中的多维集群（MDC）基表相关联，以维持表中每个连续块的“空闲”或“正在使用”状态。 另外，可以将信息存储在块映射中，以指示在加载数据之后，基表中的给定块是否需要约束检查操作，或者基于对块的改变，依赖于该表的物化查询表是否需要刷新 操作。 每次将数据加载到表中时，将更新相关的块映射。 当要执行延迟约束检查或刷新操作时，请参考块图以了解哪些块需要操作。 执行约束检查或刷新操作之一后，再次更新关联的块映射。 块映射使得能够有效地识别基表中的数据块，更改依赖实体化查询表的哪个触发器增量约束检查操作和增量维护操作。
搜索结果
1 条记录 (耗时 0.016 秒)