Reuseable and modifiable interface object

• US 5,832,481 A
• Filed: 10/14/1997
• Issued: 11/03/1998
• Est. Priority Date: 08/20/1991
• Status: Expired due to Term

• Current Assignee: Sybase Incorporated (SAP SE)
• Original Assignee: Powersoft Corp. (SAP SE)
• Inventors: Sheffield, Kim A.
• Primary Examiner(s): AMSBURY, WAYNE P
• Application Number:
  US08/950,011
• Time in Patent Office: 385 Days
• Field of Search: 707/4
• US Class Current: 1/1
• CPC Class Codes: G06F 16/2428 Query predicate definition using graphical user interfaces, including menus and forms G06F16/2423 takes precedence
• CPC Class Codes: Y10S 707/99932 Access augmentation or optimizing
• CPC Class Codes: Y10S 707/99934 Query formulation, input preparation, or translation

Abstract

A program object providing an interface between a computer database manager and a client application program external to the interface object. The interface object includes associations between columns of the table and associated editing styles, a retrieve method, and an update method. Each editing style specifies a display format for data of the associated column. The column/style associations specify modifying methods for modifying data of respective columns of the table. The interface object is programmed to allow an applications programmer using the interface object to tailor the column/style associations to the database table without access to source code of the interface object. The retrieve method accepts an invocation message from the client program, and uses the column/style associations to issue commands to the database manager to retrieve data from the database into a buffer maintained by and within the interface object. The modifying methods accept directives to modify the retrieved data in the buffer and store a transcript of corresponding modification directives. The update method uses the column/style associations and the modification directives of the transcript to issue commands to the database manager to update the data of the database table in accordance with the modification directives.

Claims

1. A database interface that allows a user to indirectly manipulate data in an application database, said interface comprising:

means for defining at design time a database selection statement which specifies a plurality of column elements from a plurality of database tables associated with said application database, said column elements comprising said data to be manipulated by an end user;

means for executing at runtime said database selection against said application database to select and retrieve information pertaining to said column elements from said database tables;

a plurality of list structures for storing said information pertaining to said column elements from said database tables within said interface;

means for generating a window display structure as a part of said interface and for displaying said information pertaining to said column elements retrieved from said database tables in said window;

means for allowing the end user to make modifications to said information pertaining to said column elements in said list structures, each of said modifications being reflected in said list structures only; and

means for applying said modifications to said column elements in said application database.

2. The interface of claim 1 wherein said means for generating a window display structure comprises a painter module which creates a data definition and presentation definition file and comprises an execution module which uses said definitions to generate said window and display said column elements retrieved from said database tables in said window.

3. The interface of claim 1 wherein said means for allowing the user to make modifications to said column elements in said list structures, each of said modifications being reflected in said list structures only.

4. In an application development system, a method for assisting a user with creating an application providing access to one or more data sources, the method comprising:

creating a reusable object providing access to at least one data source, including substeps of;

(i) receiving first user input specifying at least one particular data source which said reusable object is to retrieve information from, said at least one particular data source having information arranged into columns, said reusable object including at least one predefined method for retrieving information from data sources, and

(ii) receiving second user input specifying user-specified attributes for at least one particular column, said user-specified attributes affecting how at least one particular column can be displayed or modified during runtime execution of an application;

creating a particular application providing access to said at least one particular data source, said particular application employing said reusable object; and

executing said particular application for providing access to said at least one particular data source, including substeps of;

(i) retrieving information from said at least one particular data source and storing information so retrieved in a local buffer, and

(ii) displaying to an end user of the particular application the information stored in the local buffer, said information being displayed with a format based on said user-specified attributes.

5. The method of claim 4, further comprising:

receiving end user input for modifying the information being displayed;

determining, based on said user-specified attributes, whether end user input is acceptable for modifying the information being displayed; and

if the end user input is acceptable, modifying the information being displayed according to the end user input.

6. The method of claim 5, further comprising:

periodically updating said at least one particular data source with the modified information.

7. The method of claim 4, wherein said at least one data source comprises a relational database table.

8. The method of claim 7, wherein said at least one predefined method for retrieving information from data sources includes method steps for formulating a database query for retrieving information from data sources.

9. The method of claim 8, wherein said database query comprises a Structured Query Language (SQL) database query for retrieving information from at least one relational database table.