Patent
1992-07-20
1998-02-24
Bayerl, Raymond J.
395613, 395349, 395968, G06F 300
Patent
active
057219001
ABSTRACT:
A method, system and program for providing a graphical interface for a database are accomplished by the operation of a process in the memory of a processor. The definition of individual predicates, the definition of the relationship of predicates, the editing of predicates, and the editing of the relationship of predicates is simplified and rendered dynamic and interactive for the user thereby facilitating the completion of the task being performed. The user need not remember the related column information for a specified predicate because the system will provide that information simultaneously with the predicate definition in a form that supports the direct manipulation of the related information. The predicates and their relationship are displayed simultaneously with the definition activities for both the initial definition and any subsequent editing activities. The user may select this information and drag it to the desired location to proceed on the desired activity.
REFERENCES:
patent: 4068304 (1978-01-01), Beausoleil et al.
patent: 4087794 (1978-05-01), Beausoleil et al.
patent: 4449186 (1984-05-01), Kelly et al.
patent: 4464652 (1984-08-01), Lapson et al.
patent: 4477880 (1984-10-01), Advani et al.
patent: 4527250 (1985-07-01), Galdun et al.
patent: 4531918 (1985-07-01), Coquil et al.
patent: 4556954 (1985-12-01), Advani et al.
patent: 4601003 (1986-07-01), Yoneyama et al.
patent: 4635208 (1987-01-01), Coleby et al.
patent: 4642790 (1987-02-01), Minshull et al.
patent: 4648062 (1987-03-01), Johnson et al.
patent: 4656603 (1987-04-01), Dunn
patent: 4686522 (1987-08-01), Hernandez et al.
patent: 4689737 (1987-08-01), Grant
patent: 4712191 (1987-12-01), Penna
patent: 4763356 (1988-08-01), Day, Jr. et al.
patent: 4815029 (1989-03-01), Barker et al.
patent: 4821211 (1989-04-01), Torres
patent: 4829423 (1989-05-01), Tennant et al.
patent: 4843538 (1989-06-01), Lane et al.
patent: 4853843 (1989-08-01), Ecklund
patent: 4868766 (1989-09-01), Oosterholt
patent: 4873623 (1989-10-01), Lane et al.
patent: 4885717 (1989-12-01), Beck et al.
patent: 4899136 (1990-02-01), Beard et al.
patent: 4933514 (1990-06-01), Bowers
patent: 4939507 (1990-07-01), Beard et al.
patent: 4945475 (1990-07-01), Bruffey et al.
patent: 4951190 (1990-08-01), Lane et al.
patent: 4953080 (1990-08-01), Dysart et al.
patent: 4984152 (1991-01-01), Muller
patent: 4989132 (1991-01-01), Mellender et al.
patent: 4996654 (1991-02-01), Rosenow
patent: 5001697 (1991-03-01), Torres
patent: 5040131 (1991-08-01), Torres
patent: 5041967 (1991-08-01), Ephrath et al.
patent: 5041982 (1991-08-01), Rathnam
patent: 5088052 (1992-02-01), Spielman et al.
patent: 5175814 (1992-12-01), Anick et al.
patent: 5265246 (1993-11-01), Li et al.
Gerritson, "SQL Tutorial", DBMS, Feb. 1991, p. 44 (9).
Gerritsen, "Advanced SQL Queries", DBMS, Mar. 1991, p. 58(8).
Gerritsen, "SQL for Database Administrators", DBMS, Apr. 1991, p. 64(9).
Dunn, "SQL-Select Solutions", Data Based Advisor, Nov. 1991, p. 60(6).
Edelstein, "Relational vs. Object-Oriented", DBMS, Nov. 1991, p. 68(6).
Tsuda et al, "Iconic Browser", IEEE, 1989, pp. 130-137.
Hirakawa et al, "An Image Database System Facilitating Icon-Driven Spatial Information Definition and Retrieval", IEEE, 1991, pp. 192-198.
Sian et al, "Visual Database Interface for End User Computing", May 1992, IEEE, pp. 393-396.
Tan et al, "A Graphical Knowledge Level Approach for User-Database Interaction", IEEE, 1990, pp. 453-458.
IBM Tech. Discl. Bull., "Method of Detecting Atomic Bookan Factors", Oct. 1989, pp. 368-374.
Neill, "Introduction to Computer Science", 1979, West Publish. Co., pp. 305-336.
Czejdo et al, "Design and Implementation of an Interactive Graphical Query Interface", IEEE, 1988, pp. 14-20.
Catarci et al, "Iconic and Pragrammatic Interfaces", IEEE, Oct. 1991, pp. 199-204.
Catarci et al, "Visual Strategies for Querying Databases", IEEE, Oct. 1991, pp. 183-189.
Staes et al, "A Graphical Query Language for Object-Oriented Databases" IEEE, Oct. 1991, pp. 205-210.
Gardarin et al, "Extending a Relational DBMS to Support Complex Objects", IEEE, Oct. 1989, pp. 131-137.
Rohr, "Graphical User Language for Querying Information", IEEE, Oct. 1988, pp. 21-28.
Burns et al, "A Graphical Entity-Relationship Database Browser", IEEE, Jan. 1988, pp. 694-704.
IBM TDB, "Visual Representation of Database Query Definition", vol. 33, No. 9, Feb. 1991, pp. 238-242.
IBM TDB, "Direct Manipulation Techniques for Row Conditions in Structured Query Language Query Objects", vol. 33, No. 3B, Aug. 1990, pp. 398-400.
IBM TDB, "User-Defined Logical Relationship in Visual Query", vol. 33, No. 6A, Nov. 1990, pp. 221-222.
IBM Technical Disclosure Bulletin, Interactive Schema Diagram to Visually Represent Tables of Related Data and Meaningful Joins Between Tables, vol. 33, No. 9, Feb., 1991, pp. 243-246.
Banning Kenneth Ray
James Wendy Sue
Li Shih-Gong
Bayerl Raymond J.
Breene John E.
International Business Machines Corp
Mims David A.
Stephens Keith
LandOfFree
Method and apparatus for graphically displaying query relationsh does not yet have a rating. At this time, there are no reviews or comments for this patent.
If you have personal experience with Method and apparatus for graphically displaying query relationsh, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Method and apparatus for graphically displaying query relationsh will most certainly appreciate the feedback.
Profile ID: LFUS-PAI-O-1881529