发明授权
US06453314B1 System and method for selective incremental deferred constraint processing after bulk loading data
有权
批量加载数据后选择性增量延迟约束处理的系统和方法
- 专利标题: System and method for selective incremental deferred constraint processing after bulk loading data
- 专利标题(中): 批量加载数据后选择性增量延迟约束处理的系统和方法
-
申请号: US09364753申请日: 1999-07-30
-
公开(公告)号: US06453314B1公开(公告)日: 2002-09-17
- 发明人: Petrus Kai Chung Chan , Roberta Jo Cochrane , Sam Sampson Lightstone , Mir Hamid Pirahesh , Richard Sefton Sidle , Tuong Chanh Truong , Michael J. Winer , Calisto Paul Zuzarte
- 申请人: Petrus Kai Chung Chan , Roberta Jo Cochrane , Sam Sampson Lightstone , Mir Hamid Pirahesh , Richard Sefton Sidle , Tuong Chanh Truong , Michael J. Winer , Calisto Paul Zuzarte
- 主分类号: G06F1730
- IPC分类号: G06F1730
摘要:
The invention provides method and apparatus for use in a database management system for managing a database containing data, where the database has storage for storing data in the database, and has an instruction processor for processing instructions for managing data stored in the database. The database has a constraint manager for managing constraints on said data stored in the database. The invention provides efficient method and means for deferred checking of data after bulk loading into said database for violation of constraints by determining an appropriate procedure for constraint checking by determining whether constraint checking is required; and if it is required, determining whether to implement full, or incremental checking for compliance with said constraints; and then checking the data in the database in accordance with the determined constraint checking procedure.