DOE Patents title logo U.S. Department of Energy
Office of Scientific and Technical Information

Title: 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


Performance analysis and visualization of parallel systems using SimOS and Rivet: a case study
conference, January 1999


Rivet: a flexible environment for computer systems visualization
journal, February 2000


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
  • https://doi.org/10.1145/263407.263545

Navigating hierarchies with structure-based brushes
conference, October 1999


A Framework for Knowledge-based Interactive Data Exploration
journal, December 1994


VisDB: database exploration using multidimensional visualization
journal, September 1994


DEVise: integrated querying and visual exploration of large datasets
journal, June 1997


Automating the design of graphical presentations of relational information
journal, April 1986


Pad: an alternative approach to the computer interface
conference, August 1993


The table lens: merging graphical and symbolic representations in an interactive focus + context visualization for tabular information
conference, April 1994


Interactive graphic design using automatic presentation knowledge
conference, April 1994


Visage: a user interface environment for exploring information
conference, October 1996


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
  • https://doi.org/10.1145/237091.237097

On the Theory of Scales of Measurement
journal, June 1946


Multiscale visualization using data cubes
journal, April 2003


Polaris: a system for query, analysis, and visualization of multidimensional relational databases
journal, January 2002


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
  • https://doi.org/10.1145/775047.775064

Visualizing application behavior on superscalar processors
conference, January 1999