Data processing: database and file management or data structures – Database design – Data structure types
Reexamination Certificate
2000-01-14
2003-03-04
Vu, Kim (Department: 2172)
Data processing: database and file management or data structures
Database design
Data structure types
C707S793000, C707S793000, C707S793000, C707S793000, C345S215000, C345S215000
Reexamination Certificate
active
06529900
ABSTRACT:
BACKGROUND OF THE INVENTION
This invention relates generally to the display and storage of data in a database system, and more particularly to data visualization mechanisms for the display and updating of data in a database system.
Data visualization is a technique that allows a user of a database system to view information about data stored in the database along different dimensions. The data visualizations that are created to display the information can take on various forms. One typical form is that of a table layout, with each row representing a record in the database and each column representing a field from the record. The table usually lists a subset of the database records and a subset of the available fields in the database records. The table can be ordered as an aid to navigation.
There exist systems that provide data visualizations (or views) of database records. Existing views are often restricted to list or table-like structures with possible sorting, categorization or outlining features. Other systems use non-list type structures, but are restricted to views based upon intermediary data gathered from the database, not the actual database records themselves. The Cuber™ product from Show Business Software Ltd., 137-139 Euston Road, London NW1 2AA creates charts and graphs based on intermediate database information.
Providing creative data visualization mechanisms, integrated into database systems, with views based upon access to underlying database records has proven to be a difficult problem.
SUMMARY OF THE INVENTION
Existing systems do not allow for the storage of data visualizations within the database while providing access to underlying database records.
The present invention provides an effective technique for integrated data visualization by creating and rendering visualization points representing the database records. The visualization points are associated with particular underlying database records. A navigational interface for processing user interaction with the visualization points provides direct access to the underlying database records. The direct access allows for the display of information stored in the associated database record. The display of information can also include information generated from the information stored in the database records (e.g., “virtual fields”). Additionally, the direct access allows for the updating of information stored in the associated database record. Updating can take place as the user manipulates the visualization points associated with the database records.
In one embodiment of the present invention the navigational interface presents the visualization points along a number line. The number line can represent a time line, such that database records associated with dates can be visualized. The time line can comprise a first scale representing a full range of dates for the database records, a second scale representing a displayed range of dates for the database records associated with the visualization points, and a slider mechanism for adjusting the ratio of the fill range of dates to the displayed range of dates. In another embodiment, the navigational interface presents the visualization points along an X and Y axis in a two-dimensional blank sheet display. The two-dimensional space is analogous to a blank “whiteboard” that allows a user to position visualization points data anywhere within the two-dimensional space. Annotation of the space with text and/or graphics gives further meaning to groupings of visualization points created on the blank sheet display.
Each visualization point allows for a “drill-down” process. The “drill-down” process provides complete access to the underlying database record associated with the visualization point. The user can display information from all the fields in the underlying database record as well as edit/update information in these fields.
Data visualization (alternate views) provides an effective way in which to organize vast amounts of data stored in databases such that a user can organize related information and retrieve it when needed. Existing visualization mechanisms provide some organizational features, including categorization schemes, but categorization schemes are typically limited to simple hierarchical structures (e.g., Company, Division, Department, Employee). These schemes do not provide the flexibility of the data visualization techniques of the present invention.
The present invention provides data visualization that is integrated with the database (e.g., the visualizations are stored within the database) with the ability to drill-down to a specific underlying database record. Additionally, specific user interface mechanisms (e.g., the time line and the blank sheet display) allow for both effective viewing and manipulation of data stored in the underlying database records.
REFERENCES:
patent: 5414809 (1995-05-01), Hogan et al.
patent: 5581677 (1996-12-01), Myers et al.
patent: 5841437 (1998-11-01), Fishkin et al.
patent: 5850531 (1998-12-01), Cox et al.
patent: 6023280 (2000-01-01), Becker et al.
patent: 6188403 (2001-02-01), Sacerdoti et al.
patent: 6282547 (2001-08-01), Hirsch
Aiken, A. et al., “Tioga-2: a direct manipulation database visualization environment” in “Data Engineering, 1996”, Feb. 26-Mar. 1, 1996, IEEE Catalog No.: 96CB35888, pp.: 208-217.*
Shneiderman, B., “Dynamic queries, starfield displays and the path to Spotfire,” http://www.cs.umd.edu/hcil/spotfire/ (Feb. 4, 1999; downloaded Nov. 30, 1999)/.
“Show Business Cuber 2.0—Overview”, http://www.showbusiness.com/sh . . . /a (downloaded Nov. 30, 1999).
“Show Business Cuber 2.0—Competition Overview,” http://www.showbusiness.com/showbus/cube (downloaded Dec. 22, 1999).
“Show Business Cuber 2.0—Data Sheet,” http://www.showbusiness.com/showbus/cube (downloaded Dec. 29, 1999).
Mizuno, H. et al., “Data Queries using Data Visualization Techniques,”Proc. of 12th International Conference on Sysetm, Man, and Cybernetics, Oct. 1997, vol. 3, pp. 2392-2396.
Tenev, T. and R. Rao, “Managing Multiple Focal Levels in Table Lens,”Proc. of the IEEE Symposium on Information Visualization, Oct. 1997, pp. 59-63, 122.
Stonebraker, M. et al., “Tioga, A Database-Oriented Visualization Tool,” IEEE 1993 (p. 86-93).
Patterson John F.
Rohall Steven L.
Wijeyekoon Arjuna
Hamilton Brook Smith & Reynolds P.C.
Liang Gwen
Vu Kim
LandOfFree
Method and apparatus for data visualization does not yet have a rating. At this time, there are no reviews or comments for this patent.
If you have personal experience with Method and apparatus for data visualization, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Method and apparatus for data visualization will most certainly appreciate the feedback.
Profile ID: LFUS-PAI-O-3013308