ViMDQL: An Easy-to-Use Drag-and-Drop Visual Query Composer for Multidimensional Data

Abstract

Abstract. In this study, we present ViMDQL, a useful system to tack the challenge of composing multidimensional data based analytical queries easily. Currently, fundamental query blocks such as import and export, create, retrieve, update, delete are supported, which can be used to loading and exporting data, creating, retrieving, updating, join, sampling and removing multidimensional data. Analytic functionalities such as aggregation, statistics are also supported. We demonstrated that, since ViMDQL make users can express their query intent by drag and drop to link query blocks together, which enable users can easily compose queries like the Stacker Game, it has been proved to be a productivity tool for graphically building multidimensional data based queries.