Patent
1995-08-30
1997-12-23
Black, Thomas G.
395349, G06F 1730
Patent
active
057014566
ABSTRACT:
In a computerized database system, a query is formulated to retrieve data from the database by interactively identifying at least one table containing query data, and at least one column and at least one row in the identified table containing the query data. The rows are interactively identified using a condition statement. The condition statement is interactively formulated using at least one displayed flowline. Input is received from the user specifying a position on the flowline for insertion of a predicate and the predicate. The flowline is displayed with the predicate inserted in the specified location. The predicates are displayed on the flowline in between nodes. Predicates on the same flowline are combined through a logical AND operation. Predicates on different flowlines between the same nodes are combined through a logical OR operation. The flowline is converted to a corresponding Boolean algebra statement and displayed. Input from the user adding a predicate is received in the Boolean statement and is converted to a corresponding updated graphical flow representation.
REFERENCES:
patent: 4506326 (1985-03-01), Shaw
patent: 5175814 (1992-12-01), Anick
patent: 5201046 (1993-04-01), Goldberg
patent: 5287493 (1994-02-01), Jacopi
patent: 5355474 (1994-10-01), Thuraisngham
patent: 5421008 (1995-05-01), Banning et al.
patent: 5428737 (1995-06-01), Li et al.
patent: 5428776 (1995-06-01), Rothfield
"Data Partner 1.0 Simplified DB Query Routies", article in PC Week, Sep. 14, 1992, pp. 55, 58.
Burns et al, "Graqula: A Graphical Query Language for Entity-Relationship or Relational Databases", IBM Research Journal, RC 16877, Mar. 14, 1991, Computer Science, 34 pp.
IBM TDB -K. R. Banning, et al., Dynamic, Interactive Show SQL Window, Sep. 1992, vol. 35, No. 4A, pp. 101-102.
D. Young, et al., "A Graphical Filter/Flow Representation of Boolean Queries: A Prototype Implementation and Evaluation", Jul. 1993, vol. 44, #6.
P. Anick et al., "A Direct Manipulation Interface for Boolean Information Retrieval via Natural Language Query," Proc. ACM SIGIR '90, pp. 135-150, 1990.
Jacopi Tom William
Payton Brian Gerrit
Siwek Howard Alexander
Black Thomas G.
Choules Jack M.
International Business Machines - Corporation
LandOfFree
System and method for interactively formulating database queries does not yet have a rating. At this time, there are no reviews or comments for this patent.
If you have personal experience with System and method for interactively formulating database queries, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and System and method for interactively formulating database queries will most certainly appreciate the feedback.
Profile ID: LFUS-PAI-O-1807923