Interface for an electronic spreadsheet and a database management system

• US 20030182287A1
• Filed: 03/22/2002
• Published: 09/25/2003
• Est. Priority Date: 03/22/2002
• Status: Abandoned Application

• Current Assignee: Carlo Parlanti
• Original Assignee: Carlo Parlanti
• Inventors: Parlanti, Carlo
• Application Number:
  US10/105,033
• Publication Number:
  US 20030182287A1
• Time in Patent Office: Days
• US Class Current: 707/10
• CPC Class Codes: G06F 16/252 between a Database Management System and a front-end application
• CPC Class Codes: G06F 40/18 of spreadsheets form-filling G06F40/174

Abstract

A generalized system between a first user system and any universal data access provider or open database connectivity data source for database management systems comprising: means for affixing to a first program instructions from a generalized interface between a first application and any UDA (Universal Data Access) provider or ODBC (Open Database Connectivity) data source for a DBMS (Database Management Systems); and means to affix instructions on the first application such that a sequence of statements to be performed for each Command can be embedded via the DBMS into the database. 12

Claims

1. A generalized system between a first user system and any universal data access provider or open database connectivity data source for database management systems comprising:

means for affixing to a first program instructions from a generalized interface between a first application and any UDA (Universal Data Access) provider or ODBC (Open Database Connectivity) data source for a DBMS (Database Management Systems);

means to affix instructions on the first application such that a sequence of statements to be performed for each Command can be sent to the DBMS via UDA.

2. The system of claim 1 wherein the first program is Microsoft Excel and the DBMS is DB2/400.

3. A method for operating a generalized interface between an Electronic Spreadsheet such as Microsoft Excel and an UDA data provider or ODBC data source for a DBMS comprising the following steps:

retrieving a value from a first end user application having a graphical interface field and replacing the corresponding field in the first application with at least one command or comment relevant to a DBMS statement; and

affixing the command or comment inside said DBMS statement and storing said command or comment within a database associated with said DBMS.

4. A generalized system between a first user system comprising a workbook and any universal data access data provider or open database connectivity data source for database management systems comprising:

means for affixing to the interface of first workbook program instructions from a generalized interface between said first application and any UDA (Universal Data Access) data provider or ODBC (Open Database Connectivity) data source for a DBMS (Database Management Systems); and

means to embed commands from said first workbook application via the DBMS into the database.

5. The system of claim 4 wherein the first program is Microsoft Excel and the DBMS is DB2/400.

6. A novel interface between a first workbook application having a menu interface and any UDA data provider or ODBC data source wherein said interface reads a script and enables a user to add commands to the menu interface of the workbook application.