Interacting with data warehouse by using a natural language interface

Authors:
M. Asif Naeem;Saif Ullah;Imran Sarwar Bajwa
Affiliations:
School of Computing and Mathematical Sciences, Auckland University of Technology, Auckland, New Zealand;Department of Computer Science & IT, Islamia University of Bahawalpur, Pakistan;School of Computer Science, University of Birmingham, UK
Venue:
NLDB'12 Proceedings of the 17th international conference on Applications of Natural Language Processing and Information Systems
Year:
2012

Citing 7
Cited 1

Learning syntactic rules and tags with genetic algorithms for information retrieval and filtering: an empirical basis for grammatical rules

Information Processing and Management: an International Journal
Foundations of statistical natural language processing

Foundations of statistical natural language processing
Building the Data Warehouse

Building the Data Warehouse
A comprehensive XQuery to SQL translation using dynamic interval encoding

Proceedings of the 2003 ACM SIGMOD international conference on Management of data
Learning semantic grammars with constructive inductive logic programming

AAAI'93 Proceedings of the eleventh national conference on Artificial intelligence
Part-of-speech tagging from 97% to 100%: is it time for some linguistics?

CICLing'11 Proceedings of the 12th international conference on Computational linguistics and intelligent text processing - Volume Part I
A natural language interface for data warehouse question answering

NLDB'11 Proceedings of the 16th international conference on Natural language processing and information systems

Generating OLAP queries from natural language specification

Proceedings of the International Conference on Advances in Computing, Communications and Informatics

Quantified Score

Hi-index	0.00

Visualization

Abstract

Writing Online Analytical Processing (OLAP) queries for data warehouses is a complex and skill requiring task especially for the novel users. The situation becomes more critical when a low skilled person wants to access or analyze his business data from a data warehouse. These scenarios require more expertise and skills in terms of understanding and writing the accurate and functional queries. However, these complex tasks can be simplified by providing an easy interface to the users. In order to resolve all such issues, automated software tool is needed, which facilitates both users and software engineers. In this paper we present a novel approach with name QueGen (Query Generator) that generates OLAP queries based on the specification provided in natural English language. Users need to write the requirements in simple English in a few statements. After a semantic analysis and mapping of associated information, QueGen generates the intended OLAP queries that can be executed directly on data warehouses. An experimental study has been conducted to analyze the performance and accuracy of proposed tool.