skip to main content
OSTI.GOV title logo U.S. Department of Energy
Office of Scientific and Technical Information

Title: Data visualization user interface for multidimensional databases

Patent ·
OSTI ID:1632412

A method is performed at a computer. The computer retrieves a dataset having a plurality of fields, including a first field and a second field. The computer displays a graphical user interface, including a first region displaying the plurality of fields from the dataset, a second region having a plurality of shelves determined according to a user-selected data visualization type, and a third region for displaying one or more data visualizations. The computer receives user actions to drop the first field on a first shelf and to drop the second field on a second shelf. The first and second shelves define positional attributes of data marks. The computer displays a data visualization in the third region. Each data mark has a position in the data visualization determined according to the first shelf, a data value for the first field, the second shelf, and a data value for the second field.

Research Organization:
Stanford Univ., CA (United States)
Sponsoring Organization:
USDOE
DOE Contract Number:
W-7405-ENG-48
Assignee:
The Board of Trustees of the Leland Stanford Junior University (Palo Alto, CA)
Patent Number(s):
10,528,583
Application Number:
16/137,457
OSTI ID:
1632412
Resource Relation:
Patent File Date: 09/20/2018
Country of Publication:
United States
Language:
English

References (111)

Visualization of multi-layer network topology patent-application September 2002
Image retrieval apparatus capable of printing a mark sheet for retrieval patent February 2000
Method and system for the integrated supply of telematic services and graphic information to user terminals, particularly for advertising purposes patent July 1991
Method and system for text mining using multidimensional subspaces patent August 2003
Interactive visualization of serial periodic data conference November 1998
Presenting node-link structures with modification patent April 2002
Method, system, and computer-readable medium for the layout of automatically-placed elements and user-placed elements in a chart patent-application June 2006
Ontology guided reference data discovery patent June 2013
Systems and methods for visualizing multi-dimensional data in spreadsheets and other data structures patent March 2004
Systems and methods of generating a plurality of data visualizations in a data visualization region patent August 2018
Apparatus and method for performing data transformations in data warehousing patent January 2002
Interactive graphic design using automatic presentation knowledge conference January 1994
Database system with subquery optimizer patent September 1997
Method for incremental aggregation of dynamically increasing database data sets patent August 1998
System and method for automatic transmission of personalized OLAP report output patent November 2000
Method and system for the interactive visualization and examination of data patent June 2002
Computer systems and methods for the query and visualization of multidimensional databases patent April 2014
Method for visualizing data patent January 2008
Converting structured reports to formulas patent-application March 2007
Method and apparatus for cluster exploration and visualization patent August 2000
Device and method for arranging data for use by a data client, such as a graph patent August 1999
Method for generating analyses of categorical data patent March 2004
Method and System for Dynamic Visualization of Multi-Dimensional Data patent-application September 2004
Computer systems and methods for the query and visualization of multidimensional databases patent March 2015
Image forming apparatus in which is calculated the number of images at a given magnification to duplicate repeatedly on a given size recording medium without interference patent September 1992
Query, analysis, and visualization of hierarchically structured data using Polaris
  • 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
conference July 2002
System and method for displaying material characteristic information patent-application May 2005
Systems and methods of generating a chart matrix in a data visualization region patent August 2018
Computer systems and methods for visualizing data with generation of marks patent-application September 2006
Polaris: a system for query, analysis, and visualization of multidimensional relational databases journal January 2002
Indexing and searching entity-relationship data patent June 2014
Method for generating analyses of categorical data patent-application September 2002
VisDB: database exploration using multidimensional visualization journal September 1994
Sweep manager for signal analysis patent-application February 2005
Automatic graph display patent-application February 2005
Process and apparatus for simplifying access to information stored in databases patent January 1999
Method and apparatus for accessing multidimensional data patent November 2001
Method and architecture for automated optimization of ETL throughput in data warehousing applications patent March 2001
Impact rice huller patent January 1989
Method, system, and computer program product for visualizing a data structure patent October 2001
Semantic discovery and mapping between data sources patent May 2013
Computer systems and methods for visualizing data patent-application March 2005
Computer systems and methods for the query and visualization of multidimensional databases patent-application December 2004
Semantic discovery and mapping between data sources patent May 2016
The table lens: merging graphical and symbolic representations in an interactive focus+context visualization for tabular information conference January 1994
Information retrieval system patent January 1995
Method and apparatus for sharing metadata between multiple data marts through object references patent March 2000
Method and apparatus for recording and managing data object relationship data patent October 2007
B-tree key-range bit map index optimization of database queries patent September 1996
Programs and methods for the display, analysis and manipulation of multi-dimensional data implemented on a computer patent June 2004
Multiple chart user interface patent June 2005
Apparatus and method for capturing and propagating changes from an operational database to data marts patent February 2000
User-friendly graphics generator including automatic correlation patent April 2001
User-friendly graphics generator using direct manipulation patent February 2001
Computer method and apparatus for creating visible graphics by using a graph algebra patent February 2007
Dynamic recursive build for multidimensional databases and methods and apparatus thereof patent June 2002
Software Interface for dynamic API mapping patent June 2001
Creating charts and visualizations by demonstration patent December 1996
Method and system for facilitating processing of statistical inquires on stored data accessible through a data access structure patent November 1993
System and method for automatic transmission of personalized OLAP report output patent July 2001
Graphic definition of range in the selection of data from a database field patent November 1993
System and method for automatic transmission of on-line analytical processing system report output patent January 2001
Computer systems and methods for automatically viewing multidimensional databases patent-application March 2007
Computer systems and methods for the query and visualization multidimensional databases patent April 2017
Form utilizing encoded indications for form field processing patent October 1991
Plotting Numerical Data patent-application November 2004
Visualization and processing of multidimensional data using prefiltered and sorting criteria patent May 2008
Mapping a node-link structure to a rendering space beginning from any node patent October 2001
Computer systems and methods for the query and visualization of multidimensional database patent May 2010
Persistent storage of report objects patent September 1997
Computer systems and methods for the query and visualization of multidimensional databases patent March 2012
System, method and computer program for assembling process data of multi-database origins using a hierarchical display patent April 2004
System and method for non-uniform scaled mapping patent July 2002
Multiple chart user interface patent-application August 2002
Method and apparatus for semantic discovery and mapping between data sources patent September 2008
Data warehousing, annotation and statistical analysis system patent-application October 2003
System and method for performing database query using a marker table patent April 1999
System and method of adapting automatic output of service related OLAP reports to disparate output devices patent July 2001
Computer method and apparatus for creating visible graphics by using a graph algebra patent December 2002
Method, system, and software for automated generation of graphs from report data patent March 2006
Computer method and apparatus for creating visible graphics by using a graph algebra patent April 2006
Relational database access system using semantically dynamic objects patent June 2001
Client object API and gateway to enable OLTP via the internet patent September 2000
Systems and Methods of Generating Color Saturated Data Marks in Data Visualizations patent-application February 2019
FOCUS: the interactive table for product comparison and selection
  • 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
conference November 1996
Real time data warehousing patent December 2013
Systems and Methods of Generating Data Marks in Data Visualizations patent-application April 2019
Semantic discovery and mapping between data sources patent December 2011
Portal server that provides a customizable user Interface for access to computer networks patent December 2001
DEVise: integrated querying and visual exploration of large datasets journal June 1997
Automating the design of graphical presentations of relational information journal April 1986
DEVise: integrated querying and visual exploration of large datasets
  • 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
conference June 1997
Information retrieval system and method with implementation extensible query architecture patent November 1996
Semantic discovery and mapping between data sources patent October 2014
System for managing accounting information in a multi-dimensional database patent May 2002
System and method for formatting a cell in response to data stored in a separate location patent-application June 2006
Mapping of an RDBMS schema onto a multidimensional data model patent July 2004
System and method for collaborative hosted analysis of data bases via a network portal patent June 2002
Analysis of massive data accumulations using patient rule induction method and on-line analytical processing patent November 2003
System for searching a data base by creating a marking matrix in which two dimensional patterns control the search and selection patent December 1994
Sorting data based on data attributes for display in multiple display windows patent-application October 2002
Graphical tuning bar for a multi-program data stream patent February 2003
Automatic statistical process control (SPC) chart generation apparatus and method thereof patent October 2006
High frequency electromagnetic radiation absorbent coating comprising a binder and chips obtained from a laminate of alternating amorphous magnetic films and electrically insulating patent December 1992
Method and Apparatus for Recording and Managing Data Object Relationship Data patent-application January 2008
Range-based query optimizer patent September 1997
An interactive visual query environment for exploring data
  • 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
conference October 1997
Computer systems and methods for the query and visualization of multidimensional databases patent November 2015
Apparatus and method for compound on-line analytical processing in databases patent December 2002
Computer systems and methods for the query and visualization of multidimensional databases patent February 2011
Computer systems and methods for the query and visualization of multidimensional databases patent August 2006