Patent US5842209A successfully refreshed from Google Patents.
US5842209A
Expired / Lapsed
US
⏱️ 0.0 years remaining
User interface for visually depicting inner/outer/left/right joins in a database system
Assignee: International Business Machines Corp
•
Filing: 1996-09-03
•
Granted: 1998-11-24
•
Expires: 2016-09-03
Abstract
Abstract A method, apparatus, and article of manufacture which provides for visually depicting join relationships in a database management system. The method comprises the steps of visually depicting join relationships on a monitor coupled to a computer and receiving a join command from a user input device into the computer, wherein the join command selectively chooses a join relationship. The join relationships are visually depicted in a window displaying matching records in a first table joined to matching records in a second table, all records in a first table joined to matching records in a second table, and matching records in a first table joined to all records in a second table.
Inventors
- 👤 Darryl Jon Mocek
- 👤 Kester Li
- 👤 Jonathan Michael Levine
Bibliographic Details
Application Number
—
Jurisdiction
US
Data Source
google_patents
Last Synchronized
2026-11-09 18:13
CPC Classifications
G; G06; G06F; G06F16/00; G06F16/20; G06F16/24; G06F16/242; G06F16/2428; G06F16/2423; Y; Y10; Y10S; Y10S707/00; Y10S707/99931; Y10S707/99932; Y10S707/99933; Y10S707/99934
Claims Analysis
Total Claims: 27
Claim 1
Independent Claim
89 words
A computerized method for controlling a database management system, comprising the steps of: visually depicting at least two tables, fields in the tables, and one or more join relationships between fields in the tables on a display device coupled to a computer, wherein the join relationships illustrate join operations performed between two or more tables in the database management system; and accepting a user command from a user input device into the computer, wherein the user command selectively chooses among the join relationships visually depicted on the display device.
Claim 2
Dependent Claim
89 words
A computerized method for controlling a database management system, comprising the steps of: visually depicting at least two tables, fields in the tables, and one or more join relationships between fields in the tables on a display device coupled to a computer, wherein the join relationships illustrate join operations performed between two or more tables in the database management system; and accepting a user command from a user input device into the computer, wherein the user command selectively chooses among the join relationships visually depicted on the display device.
Claim 3
Dependent Claim
102 words
A computerized method for controlling a database management system, comprising the steps of: visually depicting one or more join relationships on a display device coupled to a computer, wherein the join relationships illustrate join operations performed between two or more tables in the database management system; accepting a user command from a user input device into the computer, wherein the user command selectively chooses among the join relationships visually depicted on the display device; and performing one or more of the join operations between two or more of the tables in the database management system in response to the accepted user command.
Claim 4
Dependent Claim
102 words
A computerized method for controlling a database management system, comprising the steps of: visually depicting one or more join relationships on a display device coupled to a computer, wherein the join relationships illustrate join operations performed between two or more tables in the database management system; accepting a user command from a user input device into the computer, wherein the user command selectively chooses among the join relationships visually depicted on the display device; and performing one or more of the join operations between two or more of the tables in the database management system in response to the accepted user command.
Claim 5
Dependent Claim
38 words
The method of claim 2, wherein the visually depicted join relationships are selected from a group comprising a visually depicted inner join relationship, a visually depicted left outer join relationship, and a visually depicted right outer join relationship.
Claim 6
Dependent Claim
32 words
The method of claim 3, wherein the visually depicted inner join relationship comprises a window displaying only matching records in a first table joined to only matching records in a second table.
Claim 7
Dependent Claim
32 words
The method of claim 3, wherein the visually depicted left outer join relationship comprises a window displaying all records in a first table joined to only matching records in a second table.
Claim 8
Dependent Claim
32 words
The method of claim 2, wherein the visually depicted right outer join relationship comprises a window displaying only matching records in a first table joined to all records in a second table.
Claim 9
Dependent Claim
27 words
The method of claim 2, wherein the join operations are selected from a group comprising an inner join, a left outer join, and a right outer join.
Claim 10
Dependent Claim
100 words
A computerized apparatus for controlling a database management system, comprising: a computer; means, performed by the computer, for visually depicting at least two tables, fields in the tables, and one or more join relationships between fields in the tables on a display device coupled to a computer, wherein the join relationships illustrate join operations performed between two or more tables in the database management system; and means, performed by the computer, for accepting a user command from a user input device into the computer, wherein the user command selectively chooses among the join relationships visually depicted on the display device.
Claim 11
Dependent Claim
100 words
A computerized apparatus for controlling a database management system, comprising: a computer; means, performed by the computer, for visually depicting at least two tables, fields in the tables, and one or more join relationships between fields in the tables on a display device coupled to a computer, wherein the join relationships illustrate join operations performed between two or more tables in the database management system; and means, performed by the computer, for accepting a user command from a user input device into the computer, wherein the user command selectively chooses among the join relationships visually depicted on the display device.
Claim 12
Dependent Claim
115 words
A computerized apparatus for controlling a database management system, comprising: a computer; means, performed by the computer, for visually depicting one or more join relationships on a display device coupled to a computer, wherein the join relationships illustrate join operations performed between two or more tables in the database management system; means, performed by the computer, for accepting a user command from a user input device into the computer, wherein the user command selectively chooses among the join relationships visually depicted on the display device; and means for performing one or more of the join operations between two or more of the tables in the database management system in response to the accepted user command.
Claim 13
Dependent Claim
115 words
A computerized apparatus for controlling a database management system, comprising: a computer; means, performed by the computer, for visually depicting one or more join relationships on a display device coupled to a computer, wherein the join relationships illustrate join operations performed between two or more tables in the database management system; means, performed by the computer, for accepting a user command from a user input device into the computer, wherein the user command selectively chooses among the join relationships visually depicted on the display device; and means for performing one or more of the join operations between two or more of the tables in the database management system in response to the accepted user command.
Claim 14
Dependent Claim
38 words
The apparatus of claim 9, wherein the visually depicted join relationships are selected from a group comprising a visually depicted inner join relationship, a visually depicted left outer join relationship, and a visually depicted right outer join relationship.
Claim 15
Dependent Claim
32 words
The apparatus of claim 10, wherein the visually depicted inner join relationship comprises a window displaying only matching records in a first table joined to only matching records in a second table.
Claim 16
Dependent Claim
32 words
The apparatus of claim 10, wherein the visually depicted left outer join relationship comprises a window displaying all records in a first table joined to only matching records in a second table.
Claim 17
Dependent Claim
32 words
The apparatus of claim 10, wherein the visually depicted right outer join relationship comprises a window displaying only matching records in a first table joined to all records in a second table.
Claim 18
Dependent Claim
27 words
The apparatus of claim 9, wherein the join operations are selected from a group comprising an inner join, a left outer join, and a right outer join.
Claim 19
Dependent Claim
112 words
A program storage device, readable by a computer, tangibly embodying one or more programs of instructions executable by the computer to perform method steps for controlling a database management system, the method comprising the steps of: visually depicting at least two tables, fields in the tables, and one or more join relationships between fields in the tables on a display device coupled to the computer, wherein the join relationships illustrate join operations performed between two or more tables in the database management system; and accepting a user command from a user input device into the computer, wherein the user command selectively chooses among the join relationships visually depicted on the display device.
Claim 20
Dependent Claim
112 words
A program storage device, readable by a computer, tangibly embodying one or more programs of instructions executable by the computer to perform method steps for controlling a database management system, the method comprising the steps of: visually depicting at least two tables, fields in the tables, and one or more join relationships between fields in the tables on a display device coupled to the computer, wherein the join relationships illustrate join operations performed between two or more tables in the database management system; and accepting a user command from a user input device into the computer, wherein the user command selectively chooses among the join relationships visually depicted on the display device.
Claim 21
Dependent Claim
125 words
A program storage device, readable by a computer, tangibly embodying one or more programs of instructions executable by the computer to perform method steps for controlling a database management system, the method comprising the steps of: visually depicting one or more join relationships on a display device coupled to the computer, wherein the join relationships illustrate join operations performed between two or more tables in the database management system; accepting a user command from a user input device into the computer, wherein the user command selectively chooses among the join relationships visually depicted on the display device; and performing one or more of the join operations between two or more of the tables in the database management system in response to the accepted user command.
Claim 22
Dependent Claim
125 words
A program storage device, readable by a computer, tangibly embodying one or more programs of instructions executable by the computer to perform method steps for controlling a database management system, the method comprising the steps of: visually depicting one or more join relationships on a display device coupled to the computer, wherein the join relationships illustrate join operations performed between two or more tables in the database management system; accepting a user command from a user input device into the computer, wherein the user command selectively chooses among the join relationships visually depicted on the display device; and performing one or more of the join operations between two or more of the tables in the database management system in response to the accepted user command.
Claim 23
Dependent Claim
40 words
The program storage device of claim 16, wherein the visually depicted join relationships are selected from a group comprising a visually depicted inner join relationship, a visually depicted left outer join relationship, and a visually depicted right outer join relationship.
Claim 24
Dependent Claim
34 words
The program storage device of claim 17, wherein the visually depicted inner join relationship comprises a window displaying only matching records in a first table joined to only matching records in a second table.
Claim 25
Dependent Claim
34 words
The program storage device of claim 17, wherein the visually depicted left outer join relationship comprises a window displaying all records in a first table joined to only matching records in a second table.
Claim 26
Dependent Claim
34 words
The program storage device of claim 17, wherein the visually depicted right outer join relationship comprises a window displaying only matching records in a first table joined to all records in a second table.
Claim 27
Dependent Claim
29 words
The program storage device of claim 16, wherein the join operations are selected from a group comprising an inner join, a left outer join, and a right outer join.
References Cited (Backward Citations)
US5157783A
Cited
US5386556A
Cited
US5197005A
Cited
US5265014A
Cited
US5237502A
Cited
US5471611A
Cited
US5557791A
Cited
US5623591A
Cited
US5412804A
Cited
US5583982A
Cited
US5519862A
Cited
US5446842A
Cited
US5615367A
Cited
US5584024A
Cited
US5555367A
Cited
US5680603A
Cited
US5548755A
Cited
USPTO Annuity & Maintenance Windows
| Annuity Stage | Window Opens | Payment Deadline | Surcharge Period Until | Estimated Fee | Status |
|---|---|---|---|---|---|
| 3.5 Years (Year 4) | 2001-11-23 | 2002-05-25 | 2002-11-24 | $2000.00 | Window Closed / Lapsed |
| 7.5 Years (Year 8) | 2005-11-23 | 2006-05-25 | 2006-11-24 | $3760.00 | Window Closed / Lapsed |
| 11.5 Years (Year 12) | 2009-11-23 | 2010-05-25 | 2010-11-24 | $7700.00 | Window Closed / Lapsed |