System using two passes searching to locate record having only parameters and corresponding values of an input record

摘要

A new database table obtained by transferring records from a conventional database table. Each database table has a pluralilty of rows and columns, and each record includes a plurality of data items. Each data item in the conventional table is transferred to a first column of the new database, and a second column of the new table identifies the columns of the conventional table from which the data items in the first column of the new table were taken. A third column of the new table identifies the records of the conventional table from which the data items in the first column of the new tables were taken. A method and system are also disclosed for searching the new database table for a given record.