System for viewing databases
First Claim
1. A method for expressing related database information comprising:
- receiving a defined linkage to a first database query result from a user;
performing a first query of a database stored on first computer storage apparatus;
displaying a result of the first database query in a first pane including a first table including data;
receiving a user selection of at least one entry within the first database query result;
automatically generating, for a second pane, a second database query by running the defined linkage to the first database query result using a parameterized query associated with the second pane, the parameterized query employing a reference to the first pane and an indicator the selected record within the first database query result, wherein the second database query is different than the first query;
wherein automatically generating the second database query includes employing an indicator of the selected record within the first database query result as a parameter in the automatic generating a second database query;
wherein automatically generating a second database query includes running a defined linkage to the first database query result;
receiving the defined linkage from user input;
performing the second database query of a database stored in second computer storage apparatus; and
expressing, in the second pane, a second database query result in a second table corresponding to the second database query;
wherein the second database query result includes data related to and different than data in the first database query result.
18 Assignments
0 Petitions
Accused Products
Abstract
A system and method allows for dynamic, parameterized linking of database views or tables. The database tables are related in a parent-dependent relationship, with dependent tables being linked to parent tables through a parameter. When a new record in the parent table is scrolled to, dependent tables automatically run queries and return records with matching parameters. The parameters include field values. Several table views may be combined in a single database table set. Multiple dependent tables may be linked to an individual parent table in a parallel manner. Dependent tables may also be cascaded through intermediate parent tables, each table in the cascade acting as a dependent to its parent and acting as a parent table to its dependent table(s). Database table sets may be saved and may be transmitted, for example via email.
-
Citations
48 Claims
-
1. A method for expressing related database information comprising:
-
receiving a defined linkage to a first database query result from a user; performing a first query of a database stored on first computer storage apparatus; displaying a result of the first database query in a first pane including a first table including data; receiving a user selection of at least one entry within the first database query result; automatically generating, for a second pane, a second database query by running the defined linkage to the first database query result using a parameterized query associated with the second pane, the parameterized query employing a reference to the first pane and an indicator the selected record within the first database query result, wherein the second database query is different than the first query; wherein automatically generating the second database query includes employing an indicator of the selected record within the first database query result as a parameter in the automatic generating a second database query; wherein automatically generating a second database query includes running a defined linkage to the first database query result; receiving the defined linkage from user input; performing the second database query of a database stored in second computer storage apparatus; and expressing, in the second pane, a second database query result in a second table corresponding to the second database query; wherein the second database query result includes data related to and different than data in the first database query result. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 45, 46, 47, 48)
-
-
9. A non-transitory computer readable medium carrying computer-readable instructions for expressing related database information comprising:
-
receiving a defined linkage to a first database query result from a user; displaying the result of a first database query in a first pane including a table including data; automatically generating, for a second pane, a second database query by running the defined linkage to the first database query result using a parameterized query associated with the second pane, the parameterized query, employing a reference to the first pane and an indicator of the selected record within the first database query result; and wherein automatically generating the second database query includes employing an indicator of the selected record within the first database query result as a parameter in the automatic generating a second database query; wherein automatically generating a second database query includes running a defined linkage to the first database query result; receiving the defined linkage from user input; expressing a second database query result corresponding to the second database query; wherein the first database query is different than the second database query; and wherein the second database query result includes a table with data related to and different that data in the first database query result. - View Dependent Claims (10, 11, 12, 13, 14, 15, 16)
-
-
17. A method comprising:
-
establishing a first window having records of a database corresponding to a first query of the database; establishing a second window having records of a database corresponding to a second query of the database different than the first query; establishing a defined dynamic linkage between records query in the first window and records in the second window including a parameterized query statement received from a user to automatically perform the second query of the database corresponding to the second window, the second query employing an indicator of a selected database recorded within the first window as a parameter, wherein the records displayed in the second window are selected automatically responsive to a selection of at least one record in the first window according to the dynamic linkage to the selected at least one record displayed in the first window; and wherein the database records of the first window and the database records of the second window are records from first and second databases, respectively. - View Dependent Claims (18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 42, 43, 44)
-
-
31. A non-transitory computer readable medium carrying computer readable instructions for viewing databases to cause a computer to execute steps comprising:
-
establishing a first window having records of a database; establishing a second window having records of a database; establishing a defined dynamic linkage between records in the first window and records in the second window including a parameterized query statement received from a user to automatically perform, the second query of the database corresponding to the second window, the second query employing an indicator of a selected database record within the first window as a parameter; and wherein selection of a record in the first window automatically determines the records displayed in the second window according to the defined dynamic linkage; wherein the database records of the first window and the database records of the second window are records from first and second databases, respectively. - View Dependent Claims (32, 33, 34, 35, 36, 37, 38, 39, 40, 41)
-
Specification