Method for forming a reusable and modifiable database interface object

• US 5,566,330 A
• Filed: 02/23/1995
• Issued: 10/15/1996
• 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/393,049
• Time in Patent Office: 600 Days
• Field of Search: 395/600, 395/155
• 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 method for interacting with a computer database table, comprising the steps of:

tailoring a database interface object by establishing associations between columns of the database table and associated editing styles, each editing style specifying a display format for data of the associated column, said column/style associations specifying modifying methods for modifying data of respective columns of said database table, said tailoring being effected by an applications programmer without access to source code of said interface object;

providing a client program;

combining said database interface object, said client program, and a database manager program to form an application program; and

executing said application program, said execution comprising the steps of;

sending an invocation message from said client program to a retrieve method of said database interface object,

receiving said retrieve invocation message by said database interface object at said retrieve method, execution of said retrieve method using said column/style associations to issue commands to said database manager program to retrieve data from said database table into a buffer maintained by and within said interface object;

invoking modifying methods of said database interface object, said modifying methods modifying said retrieved data in said buffer and storing a transcript of corresponding modification directives;

sending an invocation message from said client program to an update method of said database interface object,

receiving said update invocation message by said database interface object at said update methods, execution of said update method using said column/style associations and said modification directives of said transcript to issue commands to said database manager program to update the data of said database table in accordance with said modification directives.

2. A stored program computer comprising:

a central processor and a memory;

a client application program in said memory; and

a self-contained reusable database interface program object in said memory but external to the client application program and providing an interface between a computer database manager program for managing a database table and said client application program, the database interface object comprising;

associations between columns of the database table and associated editing styles, each editing style specifying a display format for data of the associated column, said column/style associations specifying modifying methods for modifying data of respective columns of said database table, said database interface object providing to an applications programmer the ability to tailor said column/style associations to said database table without access to source code of said database interface object;

a database communication portion for issuing database commands to the database manager program and receiving database results from the database through the database manager program;

a portion, comprising methods, for communicating with said client application program and providing for reuse of said database interface object among a plurality of client application programs, said methods being routines invocable by receipt of a message from the user or client program and including;

a retrieve method programmed to accept an invocation message from said client program, execution of said retrieve method using said column/style associations to issue commands to said database manager program to retrieve data from said database table into a buffer maintained by and within said database interface object;

said modifying methods accepting directives to modify said retrieved data in said buffer and store a transcript of corresponding modification directives; and

an update method programmed to accept an invocation message from said client program, execution of said update method using said column/style associations and said modification directives of said transcript to generate and issue commands to said database manager program to update the data of said database table in accordance with said modification directives.

3. The stored program computer of claim 2 wherein:

said database interface object is programmed to display said retrieved data on a computer display; and

at least some of said modifying methods are programmed to accept commands from an interactive user.

4. The stored program computer of claim 3 wherein said column/style associations specify whether or not retrieved data of the associated columns are to be displayed on a display screen.

5. The stored program computer of claim 3 wherein:

said column/style associations record a specification selected by said applications programmer of respective display formats for said displayable columns, said selectable data formats including built-in formats for displaying retrieved data of associated columns in a fixed format, and code-table formats displaying data of associated columns in a format tailorable by said applications programmer.

6. The stored program computer of claim 5 wherein said built-in formats include verbatim text display of data retrieved from the associated column, and said code-table formats include check boxes and radio buttons.

7. The stored program computer of claim 3 wherein:

said column/style associations specify whether or not retrieved data of the associated columns are modifiable.

8. The stored program computer of claim 7 wherein:

said database interface object is programmed to provide at least three modifying protocols including text, check boxes, and radio buttons, and said column/style associations select from among those provided a modifying protocol for modifying retrieved data of the associated column, for said columns specified to be both displayable and modifiable.

9. The stored program computer of claim 7 wherein:

a column/style association for a modifiable column includes an input validation criterion specified by said applications programmer.

10. The stored program computer of claim 3 wherein said retrieved data in said buffer comprises data retrieved from at least two rows of said database table.

11. The stored program computer of claim 10 further comprising:

a sort method to sort said at least two rows on said display into a sorted order;

a scroll method to alter the portion of said retrieved data to be displayed on said display screen; and

a filter method to select from among said at least two rows those rows desired to be displayed on said display screen.

12. The stored program computer of claim 3 further comprising:

a graphic painter programmed to allow said applications programmer to tailor said column/style associations without access to source code of said interface program, each editing style further specifying a screen display position for data of the associated column, said graphic painter being programmed to allow said applications programmer to manipulate graphical figures on a display screen of a computer and thereby specify said column/style associations in correspondence to said graphical figures.

13. The stored program computer of claim 12 wherein:

the editing styles tailorable by said applications programmer further comprise extended column definitions of display characteristics for data of corresponding columns of said database table beyond those characteristics inherent in a data dictionary of said database table.

14. The stored program computer of claim 13 wherein:

said extended column definitions comprise a label for labelling the display of data of a column of said database table, said label being different than the column name maintained by said database manager program.

15. The stored program computer of claim 13 wherein:

said extended column definitions comprise a display format for displaying of data of a column of said database table, tailorable characteristics of said display format include one or more of the following attributes;

justification, screen position, and display size.

16. The stored program computer of claim 13 wherein:

said extended column definitions comprise a validation rule for verifying data entered by an interactive user.

17. The stored program computer of claim 2 wherein:

said modifying methods are methods that accept invocation messages from said client program.

18. The stored program computer of claim 17 further comprising:

an export method programmed to accept an invocation message from said client program and in response transfer said retrieved data from said database interface object to a destination other than said database table; and

an import method programmed to accept an invocation message from said client program and in response transfer data to said buffer from a source other than said database table.

19. The stored program computer of claim 17 wherein said modifying methods comprise:

an insert method programmed to accept an invocation message from said client program and in response add an "add row" directive to said transcript of modification directives; and

a delete method programmed to accept an invocation message from said client program and in response add a deletion directive to said transcript.

20. The stored program computer of claim 2 further comprising:

a second distinct client program, said two client programs each programmed to send messages to said database interface object to interface to said database table, said client programs presenting differing features to their respective users.

21. The stored program computer of claim 2, further comprising:

a second distinct database interface object as defined in claim 16,

the two database interface objects differing from each other in being differently tailored to the same database table or tailored to different database tables;

wherein said client program is configured to send messages to both said first or second database interface objects.

22. The stored program computer of claim 2 programmed to have two modes of operation,

an interactive mode in which said retrieved data are displayed on a computer display, and said modifying methods act in response to actions by an interactive user;

and

a non-interactive mode in which said modifying methods accept invocation messages from said client program.

23. The stored program computer of claim 22 wherein

at least one column of said database table has two associated modifying methods, one for invocation in said interactive mode and one for invocation in said non-interactive mode.

24. The stored program computer of claim 2 wherein:

said database interface object provides an interface to at least two database tables, and said column/style associations specify associations between columns of each of said database tables and associated editing styles.

25. The stored program computer of claim 24 wherein said retrieve method uses a selection criterion for selecting rows of said database tables to be retrieved, said selection criteria specifying criteria on data from two distinct ones of said database tables.

26. The stored program computer of claim 2 wherein:

said retrieve and update methods are program functions, and said invocation messages are sent by means of calling said retrieve and update methods.

27. The stored program computer of claim 2 wherein:

said transcript comprises a flag datum associated with each datum in said buffer retrieved from a modifiable column of said database table.

28. The stored program computer of claim 2 wherein:

said modifying methods are programmed to provide capabilities to invoke at least two of said modifying methods to modify said retrieved data in said buffer between invocation of said retrieve and update methods, said at least two modifying methods being programmed to store corresponding modification directives in said transcript; and

said update method being programmed to issue two or more database commands to said database manager program to update the data of said database table in accordance with said transcript of modification directives, said database commands being protected by a commit/rollback protocol to guarantee that all modification directives of said transcript are applied as a single unit of work, or that none are.

29. The stored program computer of claim 2 wherein:

said modifying methods are programmed to provide capabilities to invoke at least two of said modifying methods to modify said retrieved data in said buffer between invocation of said retrieve and update methods, said at least two modifying methods being programmed to store corresponding modification directives in said transcript; and

said update method being programmed to issue two or more database commands to said database manager program to update the data of said database table in accordance with said transcript of modification directives, said database commands being issued sequentially to said database table until all said modification directives of said transcript are applied or until one of said issued database commands fails.

30. The stored program computer of claim 2 wherein:

said modifying methods are programmed to provide capabilities to invoke at least two of said modifying methods to modify said retrieved data in said buffer between invocation of said retrieve and update methods, said at least two modifying methods being programmed to store corresponding modification directives in said transcript; and

said update method being programmed to issue two or more commands to said database manager program to update the data of said database table in accordance with said transcript of modification directives, said update method being programmed to alternatively issue said database commands in both of two modes;

a first mode in which said commands are issued sequentially to said database table until all said modifications of said transcript are applied to said database table or until one of said issued database commands fails, and

a second mode in which said database commands are protected by a commit/rollback protocol to guarantee that all modifications of said transcript are applied to said database table as a single unit of work, or that none are.

31. A stored program computer, comprising:

a central processor and a memory; and

in said memory, a computer-executable interface program for providing a graphical user interface to a computer database manager program, the interface program comprising;

a graphic painter being programmed to allow an applications programmer to tailor associations between columns of a database table managed by said database manager program and associated editing styles, without access to source code of said interface program;

each editing style specifying a display format and screen display position for data of the associated column, said graphic painter being programmed to allow said applications programmer to manipulate graphical figures on a display screen of a computer and thereby specify said column/style associations in correspondence to said graphical figures;

the editing styles tailorable by said applications programmer further comprising extended column definitions of display characteristics for data of corresponding columns of said database table beyond those characteristics inherent in a data dictionary of said database table;

a graphical user interface component programmed to provide said graphical user interface and allow a user to manipulate data of said database table, the behavior and appearance of said graphical user interface being determined by said column/style associations with said extended column definitions, said graphical user interface component being programmed to generate and issue commands to said database manager program to direct said database manager program to read data from and write data to said database table, said commands being determined in accordance with said column/style associations and in response to requests entered to said graphical user interface component by said user.

32. The stored program computer of claim 31 wherein:

said extended column definitions comprise a label for labelling the display of data of a column of said database table, said label being different than the column name maintained by said database manager program.

33. The stored program computer of claim 31 wherein:

said extended column definitions comprise a display format for displaying of data of a column of said database table, tailorable characteristics of said display format include one or more of justification, screen position, and display size.

34. The stored program computer of claim 31 wherein:

said extended column definitions comprise a validation rule for verifying data entered by said user.

35. The stored program computer of claim 31 wherein:

said column/style associations record a specification selected by said applications programmer of respective display formats for said displayable columns, said selectable data formats including built-in formats for displaying retrieved data of associated columns in a fixed format, and code-table formats displaying data of associated columns in a format tailorable by said applications programmer.

36. The stored program computer of claim 35 wherein said built-in formats include verbatim text display of data retrieved from the associated column, and said code-table formats include check boxes and radio buttons.

37. The stored program computer of claim 31 wherein:

said column/style associations specify whether or not retrieved data of the associated columns are modifiable.

38. The stored program computer of claim 37 wherein:

said interface program is programmed to provide at least three modifying protocols including text, check boxes, and radio buttons, and said column/style associations select from among those provided a modifying protocol for modifying retrieved data of the associated column, for said columns specified to be both displayable and modifiable.

39. The stored program computer of claim 38 wherein:

a column/style association for a modifiable column includes an input value validation criterion specified by said applications programmer.