US5832481A
Expired / Lapsed
US
⏱️ 0.0 years remaining
Reuseable and modifiable interface object
Assignee: Sybase Inc
•
Filing: 1997-10-14
•
Granted: 1998-11-03
•
Expires: 2017-10-14
Abstract
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.
Inventors
- 👤 Kim A. Sheffield
Bibliographic Details
Application Number
—
Jurisdiction
US
Data Source
google_patents
Last Synchronized
2026-11-04 17:07
CPC Classifications
G; G06; G06F; G06F16/00; G06F16/20; G06F16/24; G06F16/242; G06F16/2428; Y; Y10; Y10S; Y10S707/00; Y10S707/99931; Y10S707/99932; Y10S707/99933; Y10S707/99934
Claims Analysis
Total Claims: 11
Claim 1
Independent Claim
183 words
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.
Claim 2
Dependent Claim
183 words
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.
Claim 3
Dependent Claim
53 words
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.
Claim 4
Dependent Claim
34 words
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.
Claim 5
Dependent Claim
215 words
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.
Claim 6
Dependent Claim
215 words
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.
Claim 7
Dependent Claim
54 words
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.
Claim 8
Dependent Claim
20 words
The method of claim 5, further comprising: periodically updating said at least one particular data source with the modified information.
Claim 9
Dependent Claim
17 words
The method of claim 4, wherein said at least one data source comprises a relational database table.
Claim 10
Dependent Claim
32 words
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.
Claim 11
Dependent Claim
27 words
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.
References Cited (Backward Citations)
US5121477A
Cited
US5594899A
Cited
US5682535A
Cited
US5410704A
Cited
US5179652A
Cited
US5396587A
Cited
US5367619A
Cited
US5204947A
Cited
US5293615A
Cited
US5148154A
Cited
US5566330A
Cited
USPTO Annuity & Maintenance Windows
| Annuity Stage | Window Opens | Payment Deadline | Surcharge Period Until | Estimated Fee | Status |
|---|---|---|---|---|---|
| 3.5 Years (Year 4) | 2001-11-02 | 2002-05-04 | 2002-11-03 | $2000.00 | Window Closed / Lapsed |
| 7.5 Years (Year 8) | 2005-11-02 | 2006-05-04 | 2006-11-03 | $3760.00 | Window Closed / Lapsed |
| 11.5 Years (Year 12) | 2009-11-02 | 2010-05-04 | 2010-11-03 | $7700.00 | Window Closed / Lapsed |