Enzymologia biologica et clinica · 1999 · 52 citations · 10 references
ComputingComputer ScienceInformation TechnologyData ManagementDatabasesUser Experience DesignData WarehousingInteractive Data AnalysisQuery OptimizationQuery ProcessingUser Behavior AnalysisData Warehouse DesignEnd UsersGraphical NotationNavigational BehaviorOlap Query ProcessingQuery EvaluationSpeculative Execution EffectsUser Behavior Modeling
Interactive multidimensional data analysis tools (mostly OLAP systems) are the predominant frontend tools for end users in data warehouse environments. Thus, the design of these systems is an important part of the data warehouse design itself. This paper contributes to the important design step by discussing the modeling of user query behavior and its benefits. We present a mathematical model and a graphical notation for capturing knowledge about typical multidimensional interaction patterns in OLAP systems, taking into account the session oriented, interactive and navigational nature of the user query behavior. To exemplarily show that the modeling of user behavior is not only beneficial during the logical and physical design phase, we also present an architecture to speed up OLAP systems at runtime by using speculative execution techniques based on a prediction of the user query behavior. 1 Introduction OLAP systems are the predominant frontend tools for data war...
10
Himanshu Gupta, Venky Harinarayan, Anand Rajaraman et al. · 2002 · 425 citations
Conceptual design of data warehouses from E/R schemes
Matteo Golfarelli, Dario Maio, Stefano Rizzi · 2002 · 280 citations
Modeling multidimensional databases, cubes and cube operations
Panos Vassiliadis · 2002 · 170 citations · Full text