Education, Science, Technology, Innovation and Life
Open Access
Sign In

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

Download as PDF

DOI: 10.23977/jwsa.2017.11004 | Downloads: 10 | Views: 2058

Author(s)

Bing Fang 1, Sheng Liang 1

Affiliation(s)

1 College of Mathematics and Information Science, Guiyang University, Guiyang, China

Corresponding Author

Sheng Liang

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.

KEYWORDS

Query Composer, Multidimensional Data, Visual Query Builder

CITE THIS PAPER

Sheng, L. , Bing, F. (2017) ViMDQL: An Easy-to-Use Drag-and-Drop Visual Query Composer for Multidimensional Data. Journal of Web Systems and Applications (2017) 1: 20-24.

REFERENCES

[1] M.Stonebraker, P.Brown and et al.: SciDB: A database management system for applications with complex analytics. Computing in Science & Engineering, Vol.15(3), p.54-62 (2013)
[2] The Sloan Digital Sky Survey SkyServer, http://skyserver.sdss.org
[3] M.Yen and R.Scamell: A human factors experimental comparison of SQL and QBE. IEEE Transactions on Software Engineering, Vol.19(4), p.390-409 (1993)
[4] Ajax Query Builder: http://www.ajaxquerybuilder.com/
[5] D.Schweiger, Z.Trajanoski and et al.: SPARQLGraph: a web-based platform for graphically querying biological Semantic Web databases. BMC bioinformatics, Vol.15(1), p.279 (2014)
[6] F.Li, and H.Jagadish: NaLIR: an interactive natural language interface for querying relational databases. In Proceedings of the 2014 ACM SIGMOD, p.709-712 (2014)
[7] F.Sébastien: Sparklis: An expressive query builder for SPARQL endpoints with guidance in natural language. Semantic Web, Vol.8(3), p.405-418 (2017)
[8] A. Der, W. Hofstede, A.Kiepuszewski, and A.Barros: Workflow patterns. Distributed and parallel databases, Vol.14(1), p.5-51 (2013)

Downloads: 74
Visits: 10977

Sponsors, Associates, and Links


All published work is licensed under a Creative Commons Attribution 4.0 International License.

Copyright © 2016 - 2031 Clausius Scientific Press Inc. All Rights Reserved.