System and method for integrating data between computer systems

• US 20070106705A1
• Filed: 11/06/2006
• Published: 05/10/2007
• Est. Priority Date: 11/07/2005
• Status: Abandoned Application

• Current Assignee: Winshuttle Holdings LLC
• Original Assignee: Winshuttle Holdings LLC
• Inventors: Chalana, Vikram
• Application Number:
  US11/556,943
• Publication Number:
  US 20070106705A1
• Time in Patent Office: Days
• US Class Current: 1/1
• CPC Class Codes: G06F 16/2462 Approximate or statistical queries
• CPC Class Codes: G06F 16/258 Data format conversion from or to a database

Abstract

Data within database and/or spreadsheet programs of a first computer system are made recognizable by a second computer system. The recognizable data serves to facilitate either data processing within the first computer system by instructions received from the second computer system and/or to transfer the recognizable data of the first computer system to the database and/or spreadsheet program of the second computer system for subsequent processing by the second computer system.

Claims

1. A method for integrating information between databases comprising:

sampling data from a first database;

configuring the sampled data within the first database into a form recognizable by a second database;

transferring the sampled and configured data to the second database; and

if transfer is successful

processing the remainder of the data from the first database by the same procedure used for the sampled data.

2. The method of claim 1, wherein configuring the sampled data includes performing a looping run to the data of the first database.

3. A method for integrating information between databases comprising:

sampling data from a first database;

procuring data processing instructions from a second database;

configuring the sampled data within the first database into a form recognizable by the processing instructions of the second database;

executing the data processing instructions of the second database on the sampled and configured data to generate processing results;

transferring the processing results to the second database; and

if transfer is successful,

processing the remainder of the data from the first database by the same procedure used for the sampled data.

4. The method of claim 3, wherein configuring the sampled data includes performing a looping run to the data of the first database.

5. A method for integrating information between databases comprising:

sampling data from a first database;

procuring data processing instructions from a second database;

configuring the sampled data within the first database into a form recognizable by the processing instructions of the second database;

executing the data processing instructions of the second database on the sampled and configured data to generate processing results;

examining the processing results of the sampled data for accuracy;

transferring the processing results to the second database; and

if transfer is successful, processing the remainder of the data from the first database by the same procedure used for the sampled data.

6. The method of claim 5, wherein configuring the sampled data includes performing a looping run to the data of the first database.

7. The method of claim 6, wherein the looping run is performed on single line items and multiple line items.

8. A system for integrating data between databases comprising:

a first computer system having a database; and

a second computer system in signal communication with the first computer system and having a second database and processing instructions;

wherein at least a portion of the first database is made to be recognizable by the processing instructions.

9. The system of claim 8, wherein the portion of the first database is made recognizable by the processing instructions within the first database.

10. The system of claim 9, wherein the recognizable first database receives executed instructions from the second database while residing in the first computer system.

11. The system of claim 10, wherein the recognizable first database is transferred to the second database before execution of processing instructions.

12. A computer-readable medium having computer-executable instructions for performing a method comprising:

sampling data from a first database;

configuring the sampled data within the first database into a form recognizable by a second database;

transferring the sampled and configured data to the second database; and

if transfer is successful

processing the remainder of the data from the first database by the same procedure used for the sampled data.

13. The method of claim 12, wherein configuring the sampled data includes performing a looping run to the data of the first database.

14. A computer-readable medium having stored thereon a data structure comprising:

a mapping tool having a do-while loop including;

a first field having first data elements selected from a first computer system;

a second field having second data elements selected from a second computer system;

wherein the first and second fields of the mapping tool is displayed in a user interface.

15. The computer-readable medium of claim 14, wherein the do-while loop verifies that conditions associated by the second field is met by data elements of the first field and that conditions associated by the first field is met by data elements of the second field.

16. A set of application program interfaces embodiment on a computer-readable medium for execution on a computer in conjunction with an application program that integrates data between databases comprising:

a first interface having;

a first field having first data elements selected from a first computer system;

a second field having second data elements selected from a second computer system;

a second interface having an at least one data line having an alphanumeric prefix applied to the second data elements for execution by a data processing program stored on the second computer;

wherein the results of the data processing program is listed in a location visible in the first field.

17. The set of application program interfaces of claim 16, wherein an error message of the data processing program is listed adjacent to the location visible in the first field.