Method for fast bulk loading data into a database while bypassing exit routines
Number of patents in Portfolio can not be more than 2000
United States of America Patent
Stats
-
Jun 7, 2011
Grant Date -
Sep 13, 2007
app pub date -
Feb 15, 2007
filing date -
Feb 16, 2006
priority date (Note) -
In Force
status (Latency Note)
Importance
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.
First Claim
Family
International Classification(s)
Cited Art Landscape
Patent Citation Ranking
Advertisement
Advertisement
Advertisement
Recipient Email Address
Recipient Email Address
Comment
Recipient Email Address
Add to Portfolio(s)
To add this patent to one, or more, of your portfolios, simply click the add button.
This Patent is in these Portfolios:
Add to additional portfolios:
Last Refreshed On:
Changes done successfully