1 / 19

Data Visualization for Database Software

Explore database user interfaces, visualization challenges, and projects in data visualization for database software. Learn about BI with multidimensional data, object tree hierarchies, and system topology projects.

stevensonjohn
Download Presentation

Data Visualization for Database Software

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Data Visualization for Database Software Anna Wichansky Advanced User Interface Group 9/28/00

  2. Outline • Database User Interfaces • Before and After Uis • Visualization Challenges • Visualization Projects

  3. A Database receives stores summarizes transforms manipulates reports Data

  4. Database tasks • Installation & configuration • Upgrade • Maintenance • Ad hoc and scheduled queries • Routine jobs • Analysis • Reporting and charting • Use of applications

  5. Database users • Database administrators (dbas) • Database designers • Programmers • High end-users (e.g. analysts) • Low end-users (e.g. data entry clerks)

  6. Database applications • Financial • Manufacturing • E-commerce • Marketing & Sales • Clinical • Government

  7. Oracle Browser 2.0 (Before)

  8. Discoverer 3.0 (After)

  9. Discoverer Graphing

  10. Reports 2.5 (Before)

  11. Reports 3.0 (After)

  12. Server Manager 2.3 (Before)

  13. Enterprise Manager 1.3 (After)

  14. Enterprise Manager 3.0

  15. Visualization Challenges • Diversity of data • Complexity of data • Expertise of users • Screen real estate • Platform issues • Internationalization pressure • Output constraints

  16. Visualization Projects • Business Intelligence w/ multidimensional data • Object tree hierarchies • Database system topologies

  17. Business Intelligence Visualization • Video store financial data • Multiple nested dimensions • Geography: Region ->City ->Store • Products: Video Rentals, Video Sales, Beverages, Snacks • Time: Year-> Quarter • Drill down capability on hierarchies • Geographical representation • 3-D representation

  18. Object tree hierarchy project • Thousands of objects in nested folders • Drill down into folder results in loss of context, truncation of text labels • Graphical representation required for interaction • Common problem on website databases • Dynamic demo (e.g. animation) may help • Hyperbolic browser not allowed

  19. System Topology Project • Distributed databases contain hundred of “nodes” with different features and functions • Geographical representation may be useful • Dynamic aspect to represent node status, jobs running (e.g. animation) • 3-D may be helpful

More Related