System for interactive graphical construction of a data base query and storing of the query object links as an object
First Claim
Patent Images
1. A method of graphically managing a query for extracting data from a first database in a computer system having a display device and user interaction means, the method comprising the steps of:
- displaying a plurality of query object class indicators;
creating a plurality of query objects by repeatedly selecting a query object class and entering query object data for each of said query objects;
linking said plurality of query objects by using said user interaction means to repeatedly select a first query object, a second query object and then specify link parameters, thereby creating a link object;
storing said query objects and said link objects in a second database.
1 Assignment
0 Petitions
Accused Products
Abstract
A method, system and program providing graphical queries and direct manipulation of a database is disclosed. In a preferred form, tables and lists are configured from a database to define a common data structure. Additional, dynamic data structures are employed based on information entered by a user to define various relationships between the dynamic data and the database information. The system employs a graphical query interface and a relational database to provide an ergonomic, natural interface for a database user.
267 Citations
12 Claims
-
1. A method of graphically managing a query for extracting data from a first database in a computer system having a display device and user interaction means, the method comprising the steps of:
-
displaying a plurality of query object class indicators; creating a plurality of query objects by repeatedly selecting a query object class and entering query object data for each of said query objects; linking said plurality of query objects by using said user interaction means to repeatedly select a first query object, a second query object and then specify link parameters, thereby creating a link object; storing said query objects and said link objects in a second database. - View Dependent Claims (2, 3, 4, 5, 6)
-
-
7. A system for graphically manipulating a query of data stored in a first database, said system operating in conjunction with a processor and display device, the system comprising:
-
means for displaying a list of query object classes; user interaction means for selecting one of said plurality of query object classes and entering query object data to create a query object; selection means for selecting two query objects to be linked and for specifying link information creating a link object; first storage means for storing query object definitions and link object definitions. - View Dependent Claims (8, 9, 10)
-
-
11. A method of converting a character based SQL query into a graphical representation of said query that can be manipulated on a display device and stored alternatively in said graphical representation or in modified character based form, the method comprising the steps of:
-
receiving said character based SQL query; parsing said query into query objects linked by link objects; displaying said query objects and said link objects on said display device; receiving changes to said displayed query objects and link objects; receiving requests to create new query objects and new link objects linking query objects; storing said query objects and link objects in a database. - View Dependent Claims (12)
-
Specification