Dismiss
The InnovationQ application will be updated on Sunday, May 31st from 10am-noon ET. You may experience brief service interruptions during that time.
Browse Prior Art Database

Method for Import With Replace That Eliminates Filling the Log File

IP.com Disclosure Number: IPCOM000034839D
Original Publication Date: 1989-Apr-01
Included in the Prior Art Database: 2005-Jan-27

Publishing Venue

IBM

Related People

Authors:
Allan, AL Camp, LS Jordan, LE Shih, CF [+details]

Abstract

Disclosed is a method for importing data into an existing table and replacing all records in that table with a minimal amount of logging. In a relational database management system, data in the database is stored in tables consisting of rows and columns. There are times when it is necessary to move data from one database to another. The Import and Export functions are a means of doing this. The Export function extracts data from one database (call it an "external system") and stores the data in a separate file, using a pre-defined interchange format. This file is then taken to another database (call it the "current system") and imported into a single table in that database. The imported data can be placed into a newly created table, added to an existing table, or can replace all rows in an existing table.