skip to main content
OSTI.GOV 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 a plurality of 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 fields with the columns shelf and to associate one or more second fields 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 fields, and each pane has a y-axis defined based on data for the one or more second fields.

Inventors:
; ;
Publication Date:
Research Org.:
The Board of Trustees of the Leland Stanford Jr. University, Palo Alto, CA (United States)
Sponsoring Org.:
USDOE
OSTI Identifier:
1225709
Patent Number(s):
9,183,235
Application Number:
14/637,333
Assignee:
The Board of Trustees of the Leland Stanford Jr. University
DOE Contract Number:  
W-7405-ENG-48
Resource Type:
Patent
Resource Relation:
Patent File Date: 2015 Mar 03
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. 2015. "Computer systems and methods for the query and visualization of multidimensional databases". United States. https://www.osti.gov/servlets/purl/1225709.
@article{osti_1225709,
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 a plurality of 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 fields with the columns shelf and to associate one or more second fields 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 fields, and each pane has a y-axis defined based on data for the one or more second fields.},
doi = {},
url = {https://www.osti.gov/biblio/1225709}, journal = {},
number = ,
volume = ,
place = {United States},
year = {Tue Nov 10 00:00:00 EST 2015},
month = {Tue Nov 10 00:00:00 EST 2015}
}

Works referenced in this record:

Impact rice huller
patent, January 1989


Form utilizing encoded indications for form field processing
patent, October 1991


Creating charts and visualizations by demonstration
patent, December 1996


Range-based query optimizer
patent, September 1997


Persistent storage of report objects
patent, September 1997


System and method for performing database query using a marker table
patent, April 1999


Method and apparatus for cluster exploration and visualization
patent, August 2000


User-friendly graphics generator using direct manipulation
patent, February 2001


Presenting node-link structures with modification
patent, April 2002


Graphical tuning bar for a multi-program data stream
patent, February 2003


Method and system for text mining using multidimensional subspaces
patent, August 2003


Method for generating analyses of categorical data
patent, March 2004


Mapping of an RDBMS schema onto a multidimensional data model
patent, July 2004


Multiple chart user interface
patent, June 2005


Method for visualizing data
patent, January 2008


Multiple chart user interface
patent-application, August 2002


Method for generating analyses of categorical data
patent-application, September 2002


Visualization of multi-layer network topology
patent-application, September 2002


Sorting data based on data attributes for display in multiple display windows
patent-application, October 2002


Data warehousing, annotation and statistical analysis system
patent-application, October 2003


Plotting Numerical Data
patent-application, November 2004


Computer systems and methods for the query and visualization of multidimensional databases
patent-application, December 2004


Sweep manager for signal analysis
patent-application, February 2005


Automatic graph display
patent-application, February 2005


Computer systems and methods for visualizing data
patent-application, March 2005


System and method for formatting a cell in response to data stored in a separate location
patent-application, June 2006


Computer systems and methods for visualizing data with generation of marks
patent-application, September 2006


Converting structured reports to formulas
patent-application, March 2007


Computer systems and methods for automatically viewing multidimensional databases
patent-application, March 2007


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

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


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

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