Author(s)

Bing Fang ¹, Sheng Liang ¹

Affiliation(s)

¹ 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)

Sponsors, Associates, and Links

---

• Power Systems Computation
  
  
• Internet of Things (IoT) and Engineering Applications
  
  
• Computing, Performance and Communication Systems
  
  
• Journal of Artificial Intelligence Practice
  
  
• Advances in Computer, Signals and Systems
  
  
• Journal of Network Computing and Applications
  
  
• Journal of Electrotechnology, Electrical Engineering and Management
  
  
• Journal of Wireless Sensors and Sensor Networks
  
  
• Journal of Image Processing Theory and Applications
  
  
• Mobile Computing and Networking
  
  
• Vehicle Power and Propulsion
  
  
• Frontiers in Computer Vision and Pattern Recognition
  
  
• Knowledge Discovery and Data Mining Letters
  
  
• Big Data Analysis and Cloud Computing
  
  
• Electrical Insulation and Dielectrics
  
  
• Crypto and Information Security
  
  
• Journal of Neural Information Processing
  
  
• Collaborative and Social Computing
  
  
• International Journal of Network and Communication Technology
  
  
• File and Storage Technologies
  
  
• Frontiers in Genetic and Evolutionary Computation
  
  
• Optical Network Design and Modeling
  
  
• Journal of Virtual Reality and Artificial Intelligence
  
  
• Natural Language Processing and Speech Recognition
  
  
• Journal of High-Voltage
  
  
• Programming Languages and Operating Systems
  
  
• Visual Communications and Image Processing
  
  
• Journal of Systems Analysis and Integration
  
  
• Knowledge Representation and Automated Reasoning
  
  
• Review of Information Display Techniques
  
  
• Data and Knowledge Engineering
  
  
• Journal of Database Systems
  
  
• Journal of Cluster and Grid Computing
  
  
• Cloud and Service-Oriented Computing
  
  
• Journal of Networking, Architecture and Storage
  
  
• Journal of Software Engineering and Metrics
  
  
• Visualization Techniques
  
  
• Journal of Parallel and Distributed Processing
  
  
• Journal of Modeling, Analysis and Simulation
  
  
• Journal of Privacy, Trust and Security
  
  
• Journal of Cognitive Informatics and Cognitive Computing
  
  
• Lecture Notes on Wireless Networks and Communications
  
  
• International Journal of Computer and Communications Security
  
  
• Journal of Multimedia Techniques
  
  
• Automation and Machine Learning
  
  
• Computational Linguistics Letters
  
  
• Journal of Computer Architecture and Design
  
  
• Journal of Ubiquitous and Future Networks