SlideServe
Télécharger Obtenir Pro
Menu
Accueil Pro
Préférences
ApparenceLight Aide et commentaires
© SlideServe · v2026

Dynamic Aggregate Queries and User Interaction in Web Data Request Scenario

cedenoa avatar
cedenoa
22 diapositives · 265 Views · Jan 06, 2020

Explore a dynamic query mediator for interactive data exploration with millions of records and advanced statistical measures. Utilize a graphical user interface to interact with a unified results system and traditional DBMS.

Dynamic Aggregate Queries and User Interaction in Web Data Request Scenario - slide 1
01 / 22Dynamic Aggregate Queries and User Interaction in Web Data Request Scenario
1 / 17

Télécharger la présentation

Dynamic Aggregate Queries and User Interaction in Web Data Request Scenario
Une image / un lien ci-dessous est fourni (tel quel) pour télécharger la présentation

Politique de téléchargement : le contenu du site vous est fourni TEL QUEL pour votre information et votre usage personnel ; il ne peut être vendu, concédé sous licence ni partagé sur d’autres sites sans l’accord de son auteur.Le contenu vous est fourni TEL QUEL, pour votre information et votre usage personnel uniquement. Téléchargez la présentation en cliquant sur ce lien. Lors du téléchargement, si vous ne parvenez pas à télécharger une présentation, l’éditeur a peut-être supprimé le fichier de son serveur.Pendant le téléchargement, si vous ne parvenez pas à obtenir une présentation, le fichier a peut-être été supprimé par l’éditeur.

F I N

Plus de contenu associé

Transcription de la présentation

  1. Interactive Dynamic Aggregate Queries Kenneth A. Ross Junyan Ding Columbia University

  2. Scenario Outline User Web Data Request Dynamic Query Mediator ... Graphical User Interface UnifiedResults TraditionalDBMS Dynamic Query Engine Data Files e.g., PUMS

  3. Engine Decoupled from Interface • Can use a variety of interfaces • Multiple connections to one server • Can “do one thing well” • Client/Server parallelism • Abstract interaction via API

  4. Engine Performance Goals • Interactivedata exploration • Millions of records • Thousands of columns (but look at ten or so at a time) • Aggregates and statistical measures • Fine adjustments at 30 answers/second.

  5. Technical Details • Main Memory Implementation • Multidimensional tree structures • Cache consciousness • Branch Misprediction • SIMD • Asynchronous work

  6. GlossIT GetGloss Internet Xml glossary info .gov url Sensus ParseGloss

  7. GlossIT Automatic Ontologies from Web Pages Judith L. Klavans Peter K. Davis Samuel Popper Columbia University

  8. Where are Glossaries? Internet

  9. GetGLOSSWeb Crawling to Find Glossaries GetGloss

  10. ParseGLOSSBuilding an Ontology ParseGloss

  11. Output forSENSUS Ontology SENSUS

  12. Data Users Social Science Research Data Component Electronic Data Service – Columbia Univ Librarians and Data Specialists Steady stream of different user groups Collect user logs and interview users Coordinated by Walter Bourne

  13. DGRC User Interface Testbed Menu presented as grid of alternating rows and columns • Top level items in left column Ontology entry shown in beam for selected item • Located asnear as possible

  14. DGRC User Interface Testbed Color coding shows parental and semantic relationships

  15. DGRC User Interface Testbed Fisheye magnification of region of interest Magnified group laid out to avoid internal overlap

  16. Goals of Evaluation Optimize the effectiveness of the interface, Identify usability problems, Provide feedbackon the overall functionality, Anticipate changes in user need that might drive future development, Validate the design, Indicate the extent to which the interface improves on previous interfaces.

  17. Methods of Evaluation Interviews to Experts Analysis of DataGate Interface Design and Testing with Heuristic for Database Interface User and Task Analysis

  18. Interview Findings User Type Identification • Novice and Power/Expert Users User Goals Kinds of Questions Types of Searches Related Terms for Searches • Difficulty of Use of Alternative Terms Selecting the database Learning to Use the Interface • Innovative Interface • Need Orientation and Time to Familiarize with the Interface

  19. Interview Findings Searching Styles Flexibility to Searching Styles Helping the User Define the Search • Help users to Visualize the Context and Structure of Information • Definition and Redefinition of Search Standardization Problems Suggestions for the Design

  20. Variables Hierarchical Structure Massive Amount Terminology Definitions Change Obscure Terminology Census Question Change Geographical References Boundaries Change Unique Boundaries Codes for Areas Various Meanings for Same Names Content Visualization Display Information Organization Dynamic Menu Magnification on Selected Items with Full Content Zoom In, Zoom Out Manipulate the Level of Magnification Searchlight Multiple Layers of Display Alternative Terms Definition of Terms Alternative Pathways Create Dynamic Maps Census Characteristics and Interface Possibilities