Computer systems and methods for the query and visualization of multidimensional databases
AssigneeThe Board of Trustees of the Leland Stanford Jr. University
InventorsChris Stolte, Diane L. Tang, Patrick Hanrahan
Life of this patent
Estimating the term…
Abstract
A method and system for producing graphics. A hierarchical structure of a database is determined. A visual table, comprising a plurality of panes, is constructed by providing a specification that is in a language based on the hierarchical structure of the database. In some cases, this language can include fields that are in the database schema. The database is queried to retrieve a set of tuples in accordance with the specification. A subset of the set of tuples is associated with a pane in the plurality of panes.
Claims196
A method for producing graphics comprising:
- (A) determining a hierarchical structure of a first database;
- (B) constructing a visual table, comprised of a plurality of panes, by providing a specification that is in a language based on the hierarchical structure of the first database;
- (C) querying the first database to retrieve a set of tuples in accordance with said specification;
- (D) associating a subset of said set of tuples with a pane in said plurality of panes;
- and
- (E) encoding a tuple in said subset of tuples in said pane as a graphical mark.
The method of 8 wherein said plurality of pages is hierarchically organized.
A computer program product for use in conjunction with a computer system, the computer program product comprising a computer readable storage medium and a computer program mechanism embedded therein, the computer program mechanism comprising:
- a first database;
- a database hierarchy module comprising instructions for determining a hierarchical structure of said first database;
- a user interface module comprising instructions for constructing a visual table, said visual table comprised of a plurality of panes, by obtaining a specification that is in a language based on the hierarchical structure of the first database;
- a data interpreter module comprising instructions for querying the first database to retrieve a set of tuples in accordance with said specification;
- a visual interpreter module comprising instructions for associating a subset of said set of tuples with a pane in said one or more panes;
- and
- instructions for encoding a tuple in said subset of tuples in said pane as a graphical mark.
A computer system for producing graphics, the computer system comprising:
- a central processing unit;
- a memory, coupled to the central processing unit, the memory storing:
- a first database;
- a database hierarchy module comprising instructions for determining a hierarchical structure of said first database;
- a user interface module comprising instructions for constructing a visual table, said visual table comprised of a plurality of panes, by obtaining a specification that is in a language based on the hierarchical structure of the first database;
- a data interpreter module comprising instructions for querying the first database to retrieve a set of tuples in accordance with said specification;
- a visual interpreter module comprising instructions for associating a subset of said set of tuples with a pane in said plurality of panes;
- and
- instructions for encoding a tuples in said subset of tuples s in said pane as a graphical mark.
Dependencies are inferred from the claim text.