Browse Prior Art Database

Blind Import Tool (BIT)

IP.com Disclosure Number: IPCOM000124298D
Original Publication Date: 2005-Apr-14
Included in the Prior Art Database: 2005-Apr-14
Document File: 1 page(s) / 27K

Publishing Venue

IBM

Abstract

This idea allows any database that supports ODBC connections to be converted to any other database format without knowing the structure of the source or target database. The data mapping feature allows data to change formats and fields without user intervention or understanding.

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

Page 1 of 1

Blind Import Tool (BIT)

This system first analyses the structure of the source database through an ODBC (Open DataBase Connectivity) driver. It then repeats this analysis for the destination database and provides a user interface that allows mapping from one the source to the destination on a field by field choice. The mapping interface / system converts the source data (when necessary) from one type to another type to maintain the integrity of the destination database. Essentially this would allow companies to convert databases, reports and other datasets from one another without any working knowledge on what the design of the input and output systems are. Furthermore, this design allows the conversion operations to scheduled. This is extremely valuable since many companies have scheduled data mining jobs that run in batch mode overnight. An example is that the user is sent a flat file (text file - csv delimited for example) nightly and needs the data to be shared in a Notes database (or any other source) for other users to see and access. In the past it was a HUGE amount of effort to input each record by hand -- now the tool can create several thousand records in the database in a very short amount of time (the time would be measured seconds, not minutes).

1