skip to main content
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

In response to a user request, a computer generates a graphical user interface on a computer display. A schema information region of the graphical user interface includes multiple operand names, each operand name associated with one or more fields of a multi-dimensional database. A data visualization region of the graphical user interface includes multiple shelves. Upon detecting a user selection of the operand names and a user request to associate each user-selected operand name with a respective shelf in the data visualization region, the computer generates a visual table in the data visualization region in accordance with the associations between the operand names and the corresponding shelves. The visual table includes a plurality of panes, each pane having at least one axis defined based on data for the fields associated with a respective operand name.

Inventors:
 [1];  [1];  [2]
  1. Palo Alto, CA
  2. Portola Valley, CA
Issue Date:
Research Org.:
Tableau Software, Inc. (Seattle, WA)
Sponsoring Org.:
USDOE
OSTI Identifier:
1039562
Patent Number(s):
8140586
Application Number:
13/019,227
Assignee:
Tableau Software, Inc. (Seattle, WA)
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:  
LLL-B523583
Resource Type:
Patent
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., 2012. 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/1039562.
@article{osti_1039562,
title = {Computer systems and methods for the query and visualization of multidimensional databases},
author = {Stolte, Chris and Tang, Diane L and Hanrahan, Patrick},
abstractNote = {In response to a user request, a computer generates a graphical user interface on a computer display. A schema information region of the graphical user interface includes multiple operand names, each operand name associated with one or more fields of a multi-dimensional database. A data visualization region of the graphical user interface includes multiple shelves. Upon detecting a user selection of the operand names and a user request to associate each user-selected operand name with a respective shelf in the data visualization region, the computer generates a visual table in the data visualization region in accordance with the associations between the operand names and the corresponding shelves. The visual table includes a plurality of panes, each pane having at least one axis defined based on data for the fields associated with a respective operand name.},
doi = {},
journal = {},
number = ,
volume = ,
place = {United States},
year = {2012},
month = {3}
}

Patent:

Save / Share:

Works referenced in this record:

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

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


Visualizing application behavior on superscalar processors
conference, January 1999


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


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


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

Adaptive Investment Strategies for Periodic Environments
journal, October 2008


Navigating hierarchies with structure-based brushes
conference, October 1999


Visualizing decision table classifiers
conference, January 1998


Interactive graphic design using automatic presentation knowledge
conference, April 1994


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


VisDB: database exploration using multidimensional visualization
journal, September 1994


On the Theory of Scales of Measurement
journal, June 1946


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


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

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


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

  • Livny, M.; Ramakrishnan, R.; Beyer, K.
  • SIGMOD '97 Proceedings of the 1997 ACM SIGMOD international conference on Management of data, Vol. 26, Issue 2, p. 301-312
  • https://doi.org/10.1145/253260.253335

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