Browse Prior Art Database

Foreign Column Specification for Database Import/Export

IP.com Disclosure Number: IPCOM000034602D
Original Publication Date: 1989-Mar-01
Included in the Prior Art Database: 2005-Jan-27
Document File: 1 page(s) / 12K

Publishing Venue

IBM

Related People

Alexander, VL: AUTHOR [+3]

Abstract

Disclosed are methods for a user to control the selection of columns of data from a foreign file when importing data from the foreign file into a relational database, and means for the user to rename columns when exporting data from a database into the foreign file for migrating data to another system. The methods described herein apply to import and export utilities which are part of a relational database software product and are used as a means of migrating data from other systems, databases, or various software products into the relational database software product, and from databases of the relational software product into other systems, products and databases. One of the control parameters for the import and export utilities is the address of a table giving information about columns in the foreign data file.

This text was extracted from a PDF file.
This is the abbreviated version, containing approximately 71% of the total text.

Page 1 of 1

Foreign Column Specification for Database Import/Export

Disclosed are methods for a user to control the selection of columns of data from a foreign file when importing data from the foreign file into a relational database, and means for the user to rename columns when exporting data from a database into the foreign file for migrating data to another system. The methods described herein apply to import and export utilities which are part of a relational database software product and are used as a means of migrating data from other systems, databases, or various software products into the relational database software product, and from databases of the relational software product into other systems, products and databases. One of the control parameters for the import and export utilities is the address of a table giving information about columns in the foreign data file. (The foreign data file is the file containing data to be imported, or the file whose creation is the result of the export utility.) In the most simple case, if either no foreign column table is specified or the table specifies the 'default' method, then for import this implies selection of all or as many as needed columns in the foreign data file in their natural order, and for export this means column names placed in the created foreign data file are those implied by the selection of the columns of data from the relational database. When importing data from a foreign data file, the user may use the...