Information Processing and Management: an International Journal
Foundations of statistical natural language processing
Foundations of statistical natural language processing
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
Interacting with data warehouse by using a natural language interface
NLDB'12 Proceedings of the 17th international conference on Applications of Natural Language Processing and Information Systems
| Hi-index | 0.00 |
Automatic translation of natural language (NL) questions to Structured Query Language (SQL) queries is a challenging task. It is a common knowledge that writing Online Analytical Processing (OLAP) queries for data warehouses is difficult, particularly, for the novice users. In this paper, we present a natural language processing based approach to automatically generate OLAP queries those can be used to communicate with the a data warehouse. In the presented approach, user provides queries in English and our approach process English queries and generate OLAP queries. In our approach, we incorporate OMG's recent standard Semantic of Business Vocabulary and Business Rules (SBVR) to simplify the translation process of English to OLAP. SBVR is used in detailed semantic analysis of English queries. The presented approach is also implemented in Java as a prototype tool. To test the performance of the tool, an experimental study is also conducted. Results of the experimental study imply that our approach is capable in communicating with a data warehouse.