Logical schema-based mapping technique to reduce search space in the data warehouse for keyword-based search
Joint Authors
Source
The International Arab Journal of Information Technology
Issue
Vol. 14, Issue 1 (31 Jan. 2017)
Publisher
Publication Date
2017-01-31
Country of Publication
Jordan
Main Subjects
Information Technology and Computer Science
Topics
Abstract EN
Data warehouse systems are used for decision-making purposes.
The Online Analytical Processing (OLAP) tools are commonly used to query and analysis of results on such systems.
It is complex task for non-technical users (executives, managers etc.,) to query the data warehouse using OLAP tool keeping in view the schema knowledge.
For such data warehouse users, a natural language interface is a viable solution that transparently access data to fulfil their requirement.
As data warehouse contain several times more data (that increase with incremental refreshes) than the operational systems.
So keyword-based searching in such systems cannot be performed similar to database based natural language systems.
Existing natural language interfaces to data warehouse commonly explore keywords in data instances directly that takes more than sufficient time in generating results.
This paper proposes a Logical Schema-based Mapping (LSM) technique to reduce search space in the data warehouse data instances.
It performs mapping of the natural language query keywords with logical schema of the data warehouse to identify the elements prior to search in the data instances.
The retrieved matches for a keyword are ranked based on six criteria proposed in this paper.
Further, an algorithm has been presented which is developed upon the proposed criteria.
Targeted search in the data instances is then performed efficiently after the identification of schema elements.
The in-depth experiments have been carried out on real dataset to evaluate the system with respect to completeness, accuracy and performance parameters.
The results show that LSM technique outperforms the existing systems.
American Psychological Association (APA)
Majid, Fayyd& Shuayb, Muhammad. 2017. Logical schema-based mapping technique to reduce search space in the data warehouse for keyword-based search. The International Arab Journal of Information Technology،Vol. 14, no. 1.
https://search.emarefa.net/detail/BIM-693586
Modern Language Association (MLA)
Majid, Fayyd& Shuayb, Muhammad. Logical schema-based mapping technique to reduce search space in the data warehouse for keyword-based search. The International Arab Journal of Information Technology Vol. 14, no. 1 (Jan. 2017).
https://search.emarefa.net/detail/BIM-693586
American Medical Association (AMA)
Majid, Fayyd& Shuayb, Muhammad. Logical schema-based mapping technique to reduce search space in the data warehouse for keyword-based search. The International Arab Journal of Information Technology. 2017. Vol. 14, no. 1.
https://search.emarefa.net/detail/BIM-693586
Data Type
Journal Articles
Language
English
Notes
Includes appendices.
Record ID
BIM-693586