Computer systems and methods for the query and visualization of multidimensional databases
Abstract
A computer displays a graphical user interface on its display. The graphical user interface includes a schema information region and a data visualization region. The schema information region includes multiple operand names, each operand corresponding to one or more fields of a multi-dimensional database that includes at least one data hierarchy. The data visualization region includes a columns shelf and a rows shelf. The computer detects user actions to associate one or more first operands with the columns shelf and to associate one or more second operands with the rows shelf. The computer generates a visual table in the data visualization region in accordance with the user actions. The visual table includes one or more panes. Each pane has an x-axis defined based on data for the one or more first operands, and each pane has a y-axis defined based on data for the one or more second operands.
- Inventors:
- Issue Date:
- Research Org.:
- Board of Trustees of the Leland Stanford Jr. University, Palo Alto, CA (United States)
- Sponsoring Org.:
- USDOE
- OSTI Identifier:
- 1171634
- Patent Number(s):
- 8972457
- Application Number:
- 14/231,477
- Assignee:
- Board of Trustees of the Leland Stanford Jr. University (Palo Alto, CA)
- Patent Classifications (CPCs):
-
G - PHYSICS G06 - COMPUTING G06F - ELECTRIC DIGITAL DATA PROCESSING
Y - NEW / CROSS SECTIONAL TECHNOLOGIES Y10 - TECHNICAL SUBJECTS COVERED BY FORMER USPC Y10S - TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- DOE Contract Number:
- W-7405-ENG-48
- Resource Type:
- Patent
- Resource Relation:
- Patent File Date: 2014 Mar 31
- Country of Publication:
- United States
- Language:
- English
- Subject:
- 97 MATHEMATICS AND COMPUTING
Citation Formats
Stolte, Chris, Tang, Diane L, and Hanrahan, Patrick. Computer systems and methods for the query and visualization of multidimensional databases. United States: N. p., 2015.
Web.
Stolte, Chris, Tang, Diane L, & Hanrahan, Patrick. Computer systems and methods for the query and visualization of multidimensional databases. United States.
Stolte, Chris, Tang, Diane L, and Hanrahan, Patrick. Tue .
"Computer systems and methods for the query and visualization of multidimensional databases". United States. https://www.osti.gov/servlets/purl/1171634.
@article{osti_1171634,
title = {Computer systems and methods for the query and visualization of multidimensional databases},
author = {Stolte, Chris and Tang, Diane L and Hanrahan, Patrick},
abstractNote = {A computer displays a graphical user interface on its display. The graphical user interface includes a schema information region and a data visualization region. The schema information region includes multiple operand names, each operand corresponding to one or more fields of a multi-dimensional database that includes at least one data hierarchy. The data visualization region includes a columns shelf and a rows shelf. The computer detects user actions to associate one or more first operands with the columns shelf and to associate one or more second operands with the rows shelf. The computer generates a visual table in the data visualization region in accordance with the user actions. The visual table includes one or more panes. Each pane has an x-axis defined based on data for the one or more first operands, and each pane has a y-axis defined based on data for the one or more second operands.},
doi = {},
journal = {},
number = ,
volume = ,
place = {United States},
year = {2015},
month = {3}
}
Works referenced in this record:
Visualizing decision table classifiers
conference, January 1998
- Becker, B. G.
- Information Visualization, 1998. Proceedings. IEEE Symposium on
Performance analysis and visualization of parallel systems using SimOS and Rivet: a case study
conference, January 1999
- Bosch, R.; Stolte, C.; Stoll, G.
- High-Performance Computer Architecture, 2000. HPCA-6. Proceedings. Sixth International Symposium on
Rivet: a flexible environment for computer systems visualization
journal, February 2000
- Bosch, Robert; Stolte, Chris; Tang, Diane
- ACM SIGGRAPH Computer Graphics, Vol. 34, Issue 1, p. 68-73
An interactive visual query environment for exploring data
conference, October 1997
- Derthick, Mark; Kolojejchick, John; Roth, Steven F.
- UIST '97 Proceedings of the 10th annual ACM symposium on User interface software and technology, p. 189-198
Navigating hierarchies with structure-based brushes
conference, October 1999
- , ; Ward, M.O.; Rundensteiner, E.A.
- 1999 IEEE Symposium on Information Visualization, 1999
A Framework for Knowledge-based Interactive Data Exploration
journal, December 1994
- Goldstein, Jade; Roth, Steven F.; Kolojejchick, John
- Journal of Visual Languages & Computing, Vol. 5, Issue 4, p. 339-363
VisDB: database exploration using multidimensional visualization
journal, September 1994
- Keim, D.A.; Kriegel, H.-P.
- IEEE Computer Graphics and Applications, Vol. 14, Issue 5, p. 40-49
DEVise: integrated querying and visual exploration of large datasets
journal, June 1997
- Livny, M.; Ramakrishnan, R.; Beyer, K.
- ACM SIGMOD Record, Vol. 26, Issue 2
Automating the design of graphical presentations of relational information
journal, April 1986
- Mackinlay, Jock
- ACM Transactions on Graphics, Vol. 5, Issue 2, p. 110-141
Pad: an alternative approach to the computer interface
conference, August 1993
- Perlin, Ken; Fox, David
- SIGGRAPH '93 Proceedings of the 20th annual conference on Computer graphics and interactive techniques, p. 57-64
The table lens: merging graphical and symbolic representations in an interactive focus + context visualization for tabular information
conference, April 1994
- Rao, Ramana; Card, Stuart K.
- CHI '94 Proceedings of the SIGCHI Conference on Human Factors in Computing Systems, p. 318-322
Interactive graphic design using automatic presentation knowledge
conference, April 1994
- Roth, Steven F.; Kolojejchick, John; Mattis, Joe
- CHI '94 Proceedings of the SIGCHI Conference on Human Factors in Computing Systems, p. 112-117
Visage: a user interface environment for exploring information
conference, October 1996
- Roth, S.F.; Lucas, P.; Senn, J.A.
- Proceedings IEEE Symposium on Information Visualization '96
FOCUS: the interactive table for product comparison and selection
conference, November 1996
- Spenke, Michael; Beilken, Christian; Berlage, Thomas
- Proceedings of the 9th annual ACM symposium on User interface software and technology, p. 41-50
On the Theory of Scales of Measurement
journal, June 1946
- Stevens, S. S.
- Science, Vol. 103, Issue 2684
Multiscale visualization using data cubes
journal, April 2003
- Stolte, C.; Tang, D.; Hanrahan, P.
- IEEE Transactions on Visualization and Computer Graphics, Vol. 9, Issue 2
Polaris: a system for query, analysis, and visualization of multidimensional relational databases
journal, January 2002
- Stolte, C.; Tang, D.; Hanrahan, P.
- IEEE Transactions on Visualization and Computer Graphics, Vol. 8, Issue 1, p. 52-65
Query, analysis, and visualization of hierarchically structured data using Polaris
conference, July 2002
- Stolte, Chris; Tang, Diane; Hanrahan, Pat
- Proceedings of the eighth ACM SIGKDD international conference on Knowledge discovery and data mining, p. 112-122
Visualizing application behavior on superscalar processors
conference, January 1999
- Stolte, C.; Bosch, R.; Hanrahan, P.
- Information Visualization, 1999. (Info Vis '99) Proceedings. 1999 IEEE Symposium on
XmdvTool: integrating multiple methods for visualizing multivariate data
conference, January 1994
- Ward, M. O.
- Proceedings Visualization '94