US5950190A
Expired / Lapsed
US
⏱️ 0.0 years remaining
Dynamic, self-modifying graphical user interface for relational database applications
Assignee: Oracle America Inc
•
Filing: 1997-05-13
•
Granted: 1999-09-07
•
Expires: 2017-05-13
Abstract
Abstract A dynamic database interface for relational and object-oriented databases includes a dynamic, self-modifying graphical user interface defining a plurality of graphical windows for searching and editing the contents of the relational database, as well as modifying the structure of the database tables. The graphical user interface recognizes modifications to the structure of the database tables and regenerates the graphical windows to accommodate such modifications. The graphical windows also depict schematic representations of physical locations of objects stored within the tables of the relational database. In addition to using the graphical windows to edit the contents and modify the structure of the relational database, batches of data may be imported to both edit the contents of the relational database and modify the structure of the relational database tables.
Inventors
- 👤 Carolyn Marie Yeager
- 👤 Jerry Lynn Udy
Bibliographic Details
Application Number
—
Jurisdiction
US
Data Source
google_patents
Last Synchronized
2026-11-09 17:56
CPC Classifications
G; G06; G06F; G06F16/00; G06F16/20; G06F16/28; G06F16/284; G06F16/26; Y; Y10; Y10S; Y10S707/00; Y10S707/99931; Y10S707/99933
Claims Analysis
Total Claims: 27
Claim 1
Independent Claim
192 words
A dynamic database interface executed by programmed instructions on a general purpose computer in response to input information; the general purpose computer including a memory in which the programmed instructions are recorded, an input device to supply input information for interaction with the programmed instructions, and a display device for displaying information created by the programmed instructions and the input information; said dynamic database interface operating in conjunction with an underlying relational database having database contents contained within a plurality of tables, said relational database further containing data dictionary information defining individual columns of said tables and relations between said columns, wherein said dynamic database interface comprises: a graphical user interface defining a plurality of graphical windows for formulating commands to be sent to the relational database and for displaying information in the graphical windows from the relational database, said graphical user interface recognizing a structural change in the underlying relational database by initiating a reference to the data dictionary information and dynamically modifying the information displayed in at least one of the plurality of graphical windows in response to a modification of the data dictionary information resulting from the structural change.
Claim 2
Dependent Claim
192 words
A dynamic database interface executed by programmed instructions on a general purpose computer in response to input information; the general purpose computer including a memory in which the programmed instructions are recorded, an input device to supply input information for interaction with the programmed instructions, and a display device for displaying information created by the programmed instructions and the input information; said dynamic database interface operating in conjunction with an underlying relational database having database contents contained within a plurality of tables, said relational database further containing data dictionary information defining individual columns of said tables and relations between said columns, wherein said dynamic database interface comprises: a graphical user interface defining a plurality of graphical windows for formulating commands to be sent to the relational database and for displaying information in the graphical windows from the relational database, said graphical user interface recognizing a structural change in the underlying relational database by initiating a reference to the data dictionary information and dynamically modifying the information displayed in at least one of the plurality of graphical windows in response to a modification of the data dictionary information resulting from the structural change.
Claim 3
Dependent Claim
33 words
A dynamic database interface as defined in claim 1, wherein the graphical user interface regenerates each one of the plurality of graphical windows in response to a modification of the data dictionary information.
Claim 4
Dependent Claim
33 words
A dynamic database interface as defined in claim 1, wherein the graphical user interface translates the commands formulated in the graphical windows into a structured query language for processing by the relational database.
Claim 5
Dependent Claim
37 words
A dynamic database interface as defined in claim 3, wherein: the commands formulated in the graphical windows include a search query; and the graphical user interface displays a response to the search query on the display device.
Claim 6
Dependent Claim
81 words
A dynamic database interface as defined in claim 4, wherein: the database contents of the relational database includes a plurality of inventory objects; at least one of the individual columns defines a physical location for each inventory object; the response to the search query lists at least one inventory object and its respective physical location; and the plurality of graphical windows includes a topology window to display a schematic representation of the physical location of the at least one inventory object.
Claim 7
Dependent Claim
25 words
A dynamic database interface as defined in claim 3, wherein: the commands formulated in the graphical windows include a command to edit the database contents.
Claim 8
Dependent Claim
102 words
A dynamic database interface as defined in claim 6, wherein: the database contents of the relational database includes a plurality of inventory objects; at least one of the individual columns defines a physical location for each inventory object; the plurality of graphical windows includes a topology window to display a schematic representation of the physical locations of each of the inventory objects; and the defined physical location of at least one of the inventory objects may be modified by moving the schematic representation of the physical location of the at least one inventory object to a new location within the topology window.
Claim 9
Dependent Claim
30 words
A dynamic database interface as defined in claim 3, wherein: the commands formulated in the graphical windows include a command to modify the data dictionary information of the relational database.
Claim 10
Dependent Claim
48 words
A dynamic database interface as defined in claim 1, wherein: the plurality of graphical windows includes a search window for searching the contents of the relational database, said search window defining user-input fields corresponding to the individual columns defined within the data dictionary information of the relational database.
Claim 11
Dependent Claim
34 words
A dynamic database interface as defined in claim 9, wherein: the graphical user interface updates the user-input fields each time the data dictionary information is modified to incorporate any changes to the individual columns.
Claim 12
Dependent Claim
52 words
A dynamic database interface as defined in claim 10, wherein: the plurality of graphical windows includes a choices window for each user-input field defined within the search window, each said choices window providing a list of the database contents for the individual column of the relational database corresponding to the user-input field.
Claim 13
Dependent Claim
48 words
A dynamic database interface as defined in claim 1, wherein: the plurality of graphical windows includes an edit window for editing the contents of the relational database, said edit window defining user-input fields corresponding to the individual columns defined within the data dictionary information of the relational database.
Claim 14
Dependent Claim
34 words
A dynamic database interface as defined in claim 12, wherein: the graphical user interface updates the user-input fields each time the data dictionary information is modified to incorporate any changes to the individual columns.
Claim 15
Dependent Claim
52 words
A dynamic database interface as defined in claim 13, wherein: the plurality of graphical windows includes a choices window for each user-input field defined within the edit window, each said choices window providing a list of the database contents for the individual column of the relational database corresponding to the user-input field.
Claim 16
Dependent Claim
96 words
A dynamic database interface as defined in claim 1, wherein the plurality of graphical windows includes a design window for modifying the data dictionary information of the relational database, said design window: displaying the individual columns defined within the data dictionary information for a predetermined one of the tables of the relational database; allowing at least one of the individual columns displayed within the design window to be deleted from the data dictionary information; and allowing at least one new column to be added to the data dictionary information for the predetermined one of the tables.
Claim 17
Dependent Claim
26 words
A dynamic database interface as defined in claim 15, wherein: the design window further allows the individual columns displayed within the design window to be modified.
Claim 18
Dependent Claim
39 words
A dynamic database interface as defined in claim 15, wherein: the graphical user interface updates the individual columns displayed within the design window each time the data dictionary information is modified to incorporate any changes to the individual columns.
Claim 19
Dependent Claim
39 words
A dynamic database interface as defined in claim 1, wherein: the database contents of the relational database includes a plurality of inventory objects; and at least one of the individual columns defines a physical location for each inventory object.
Claim 20
Dependent Claim
34 words
A dynamic database interface as defined in claim 18, wherein the plurality of graphical windows includes a topology window to display a schematic representation of the physical location of each of the inventory objects.
Claim 21
Dependent Claim
27 words
A dynamic database interface as defined in claim 1, further comprising: means for importing a batch of data into the relational database to edit the database contents.
Claim 22
Dependent Claim
28 words
A dynamic database interface as defined in claim 20, further comprising: means for importing a batch of data into the relational database to modify the data dictionary information.
Claim 23
Dependent Claim
39 words
A dynamic database interface as defined in claim 1, wherein the data dictionary information contains database contents of the underlying relational database, and further comprising: means for exporting the database contents of the relational database to a text file.
Claim 24
Dependent Claim
38 words
A dynamic database interface as defined in claim 1 wherein the data dictionary information is stored in a location of the memory, and the graphical user interface accesses the memory location where the data dictionary information is stored.
Claim 25
Dependent Claim
33 words
A dynamic database interface as defined in claim 1 wherein the graphical user interface initiates a reference to the data dictionary information prior to each new display of information in the graphical windows.
Claim 26
Dependent Claim
31 words
A dynamic database interface as defined in claim 1 wherein the graphical user interface periodically self-initiates a reference to the data dictionary information to recognize changes in the underlying relational database.
Claim 27
Dependent Claim
44 words
A dynamic database interface as defined in claim 1 wherein the graphical user interface recognizes changes in the underlying relational database and self modifies the information displayed in response to changes to the data dictionary information occurring during use of said dynamic database interface.
References Cited (Backward Citations)
US5428776A
Cited
US5832481A
Cited
US5428737A
Cited
US5555403A
Cited
US5749079A
Cited
US5745896A
Cited
US5893125A
Cited
US5732274A
Cited
US5899997A
Cited
USPTO Annuity & Maintenance Windows
| Annuity Stage | Window Opens | Payment Deadline | Surcharge Period Until | Estimated Fee | Status |
|---|---|---|---|---|---|
| 3.5 Years (Year 4) | 2002-09-06 | 2003-03-08 | 2003-09-07 | $2000.00 | Window Closed / Lapsed |
| 7.5 Years (Year 8) | 2006-09-06 | 2007-03-08 | 2007-09-07 | $3760.00 | Window Closed / Lapsed |
| 11.5 Years (Year 12) | 2010-09-06 | 2011-03-08 | 2011-09-07 | $7700.00 | Window Closed / Lapsed |