Invention Grant
US07958091B2 Method for fast bulk loading data into a database while bypassing exit routines
有权
方法用于在绕过退出例程时将数据快速批量加载到数据库中
- Patent Title: Method for fast bulk loading data into a database while bypassing exit routines
- Patent Title (中): 方法用于在绕过退出例程时将数据快速批量加载到数据库中
-
Application No.: US11707622Application Date: 2007-02-15
-
Publication No.: US07958091B2Publication Date: 2011-06-07
- Inventor: Sushil Nair , Anatol Zolotusky , Claude Charpentier
- Applicant: Sushil Nair , Anatol Zolotusky , Claude Charpentier
- Applicant Address: US CA Redwood City
- Assignee: Ingrian Networks, Inc.
- Current Assignee: Ingrian Networks, Inc.
- Current Assignee Address: US CA Redwood City
- Agency: Drinker Biddle & Reath, LLP
- Main IPC: G06F7/00
- IPC: G06F7/00 ; G06F17/00 ; G06F9/46

Abstract:
System, method, computer program for fast bulk loading data into database while bypassing exit routines. Method for bulk loading of data into database tables with exit routines defined for operations on such tables, method characterized by existence of exit routines is by-passed by performing data preprocessing in batch mode before loading; and loading preprocessed data into database by performing operations on lower level of tablespace and index spaces where database tables reside and not on database tables themselves. Method for bulk loading data into database tables with exit routines defined for operations on such tables comprising: batch processing data that requires processing to generate processed data; switching tablespace and related index spaces to stop mode; marking required space map entries used; loading previously processed data into claimed data pages; updating database index pages; resetting consistency tokens in updated page; and switching the tablespace and related index spaces to start mode.
Public/Granted literature
- US20070214167A1 Method for fast bulk loading data into a database while bypassing exit routines Public/Granted day:2007-09-13
Information query