A comparison of the usability of performing ad hoc querying on dimensionally modeled data versus operationally modeled data

To study the usability of dimensionally modeled data (DMD), we conducted an experiment involving 113 participants to analyze their performance in ad hoc querying tasks. The results show that DMD's usability is high according to both objective and subjective measurements. Usability is dependent upon the segment of data model used and, in particular, on the type of task being performed, with the highest results for aggregations and holistic view creation. Interestingly, dimensionally modeled data seem to be distinguished by learnability. The study's results partially agree with the results obtained in usability studies of relational data models and similar data structures.

[1]  Ben Shneiderman,et al.  Time Stress Effects on Two Menu Selection Systems , 1987 .

[2]  Susan H. Gray,et al.  Using protocol analyses and drawings to study mental model construction during hypertext navigation , 1990, Int. J. Hum. Comput. Interact..

[3]  Ton de Jong,et al.  The design and evaluation of hypertext structures for supporting design problem solving , 1999 .

[4]  I. A. Newman,et al.  Virtual hierarchies and virtual networks: some lessons from hypermedia usability research applied to the World Wide Web , 1997, Int. J. Hum. Comput. Stud..

[5]  Diane M. Strong,et al.  Beyond Accuracy: What Data Quality Means to Data Consumers , 1996, J. Manag. Inf. Syst..

[6]  Carl Gutwin,et al.  A Predictive Model of Human Performance With Scrolling and Hierarchical Lists , 2009, Hum. Comput. Interact..

[7]  Roy Rada,et al.  Searching versus Browsing in Hypertext , 1992, Hypermedia.

[8]  W. H. Inmon,et al.  Building the data warehouse , 1992 .

[9]  Panayiotis Zaphiris,et al.  Depth vs Breath in the Arrangement of Web Links , 2000 .

[10]  Ben Shneiderman,et al.  Performance Benefits of Simultaneous Over Sequential Menus as Task Complexity Increases , 2000, Int. J. Hum. Comput. Interact..

[11]  Barbara Mirel.  New frontiers in usability for users' complex knowledge work , 2008 .

[12]  Stanley R. Parkinson,et al.  Computer display menus , 1983 .

[13]  Jean-François Rouet,et al.  Task and Activity Models in Hypertext Usage , 2004 .

[14]  Adir Even,et al.  Data quality assessment in context: A cognitive perspective , 2009, Decis. Support Syst..

[15]  Ben Shneiderman,et al.  Facilitating data exploration with query previews: A study of user performance and preference , 2000, Behav. Inf. Technol..

[16]  M. W. van Someren,et al.  Optimal link categorization for minimal retrieval effort , 2006 .

[17]  John David N. Dionisio,et al.  Unified Data Model for Representing Multimedia, Timeline, and Simulation Data , 1998, IEEE Trans. Knowl. Data Eng..

[18]  W. H. Inmon,et al.  Building the Data Warehouse,3rd Edition , 2002 .

[19]  Mary Czerwinski,et al.  Web page design: implications of memory, structure and scent for information retrieval , 1998, CHI.

[20]  Rui Chen,et al.  Response Information Interoperability: A Development of Data Standards in the Fire Incident Context , 2007 .

[21]  Jeff Conklin,et al.  Hypertext: An Introduction and Survey , 1987, Computer.

[22]  Michael Bernard,et al.  Examining a metric for predicting the accessibility of information within hypertext structures , 2002 .

[23]  JinKyu Lee,et al.  Task complexity and different decision criteria for online service acceptance: A comparison of two e-government compliance service domains , 2009, Decis. Support Syst..

[24]  S McDonald,et al.  Disorientation in hypertext: the effects of three text structures on navigation performance. , 1996, Applied ergonomics.

[25]  Karen Corral,et al.  The impact of alternative diagrams on the accuracy of recall: A comparison of star-schema diagrams and entity-relationship diagrams , 2006, Decis. Support Syst..

[26]  Panayiotis Zaphiris.  Expandable Indexes Versus Sequential Menus for Searching Hierarchies on the World Wide Web , 1999 .

[27]  Ralph Kimball,et al.  The Data Warehouse Toolkit: The Complete Guide to Dimensional Modeling , 1996 .

[28]  Ralph Kimball,et al.  The Data Warehouse Lifecycle Toolkit , 2009 .

[29]  P. Robinson.  Task complexity, task difficulty, and task production: exploring interactions in a componential framework , 2001 .

[30]  John I. Kiger,et al.  The Depth/Breadth Trade-Off in the Design of Menu-Driven User Interfaces , 1984, Int. J. Man Mach. Stud..

[31]  Ben Shneiderman,et al.  An exploratory evaluation of three interfaces for browsing large hierarchical tables of contents , 1994, TOIS.

[32]  Ben Shneiderman,et al.  Expandable indexes vs. sequential menus for searching hierarchies on the World Wide Web , 2002, Behav. Inf. Technol..

[33]  Carolyn L. Foss,et al.  Tools for reading and browsing hypertext , 1989, Inf. Process. Manag..

[34]  Christine L. Borgman,et al.  Why are Online Catalogs Hard to Use? Lessons Learned from Information=Retrieval Studies , 1986 .

[35]  Hsinchun Chen,et al.  Browsing in hypertext: a cognitive study , 1992, IEEE Trans. Syst. Man Cybern..

[36]  Ananth Srinivasan,et al.  Data Abstractions and Their Use: An Experimental Study of User Productivity , 1999, INTERACT.

[37]  John B. Smith,et al.  A hypertext writing environment and its cognitive basis (panel session) , 1987, Hypertext.

[38]  Dwight P. Miller.  The Depth/Breadth Tradeoff in Hierarchical Computer Menus , 1981 .

[39]  Michael F. Mohageg.  The Influence of Hypertext Linking Structures on the Efficiency of Information Retrieval , 1992 .

[40]  Wilbert O. Galitz,et al.  The Essential Guide to User Interface Design: An Introduction to GUI Design Principles and Techniques , 1996 .

[41]  Claudia Imhoff,et al.  Relational Modeling and Data Warehouse Design , 2003 .

[42]  Iouri Belski,et al.  of Task Complexity , 2014 .

[43]  Christopher Ahlberg,et al.  IVEE: an Information Visualization and Exploration Environment , 1995, Proceedings of Visualization 1995 Conference.

[44]  Gerardine DeSanctis,et al.  Computer-Based Support for Group Problem-Finding: An Experimental Investigation , 1988, MIS Q..

[45]  Amit Gupta,et al.  Dimensional Modeling: In a Business Intelligence Environment , 2006 .

[46]  Il-Yeol Song,et al.  Dimensional modeling: Identification, classification, and evaluation of patterns , 2008, Decis. Support Syst..

[47]  Brian D. Ehret,et al.  Learning where to look: the acquisition of location knowledge in display-based interaction , 1999 .

[48]  Anthony J. Hornof,et al.  Cognitive modeling reveals menu search in both random and systematic , 1997, CHI.

[49]  Rosemary J. Stevenson,et al.  Effects of Text Structure and Prior Knowledge of the Learner on Navigation in Hypertext , 1998, Hum. Factors.

[50]  Richard L. Daft,et al.  Message Equivocality, Media Selection, and Manager Performance: Implications for Information Systems , 1987, MIS Q..

[51]  Ben Shneiderman,et al.  Query previews in networked information systems , 1996, Proceedings of the Third Forum on Research and Technology Advances in Digital Libraries,.

[52]  Inderpal Singh Mumick,et al.  The Dynamic Homefinder: Evaluating Dynamic Queries In A Real-Estate Information Exploration System , 1999 .

[53]  Ben Shneiderman,et al.  Design and Evaluation of Incremental Data Structures and Algorithms for Dynamic Query Interfaces , 1997, INFOVIS.

[54]  D. Deschoolmeester,et al.  The Effect of Task Volume and Complexity upon Computer Use , 1972 .

[55]  Brian D. Ehret,et al.  Learning where to look: location learning in graphical user interfaces , 2002, CHI.

[56]  S. Chaiken,et al.  The psychology of attitudes. , 1993 .

[57]  Martha E. Crosby,et al.  The effect of graphic style on data model interpretation , 1999, Inf. Syst. J..

[58]  John David N. Dionisio,et al.  A unified data model for representing multimedia, timeline, and simulation data , 2001 .

[59]  Marc D. Hansen,et al.  An analysis of the diagrammatic visual data querying domain , 2005 .

[60]  T. Landauer,et al.  Handbook of Human-Computer Interaction , 1997 .

[61]  Ben Shneiderman,et al.  Structural analysis of hypertexts: identifying hierarchies and useful metrics , 1992, TOIS.

[62]  John W. Payne,et al.  Task complexity and contingent processing in decision making: An information search and protocol analysis☆ , 1976 .

[63]  Dowling,et al.  Star Join Schemas versus Normalized Relational Schemas : Does it Really Make a Difference to End-Users ? Research-in-Progress Paper submitted to Databases and Data Management ( DDM ) Mini-Track , 2001 .

[64]  Nancy J. Cooke,et al.  Design of Menus , 1997 .