Welcome to the InfoSci Platform
Reference Hub3
Reducing Query Processing Time for Non-Synonymous Materialized Queries With Differed Criteria

Reducing Query Processing Time for Non-Synonymous Materialized Queries With Differed Criteria

Sonali Ashish Chakraborty, Jyotika Doshi
Copyright: © 2019 |Volume: 8 |Issue: 2 |Pages: 19
ISSN: 1947-928X|EISSN: 1947-9298|EISBN13: 9781522566335|DOI: 10.4018/IJNCR.2019040104
Cite Article Cite Article

MLA

Chakraborty, Sonali Ashish, and Jyotika Doshi. "Reducing Query Processing Time for Non-Synonymous Materialized Queries With Differed Criteria." IJNCR vol.8, no.2 2019: pp.75-93. http://doi.org/10.4018/IJNCR.2019040104

APA

Chakraborty, S. A. & Doshi, J. (2019). Reducing Query Processing Time for Non-Synonymous Materialized Queries With Differed Criteria. International Journal of Natural Computing Research (IJNCR), 8(2), 75-93. http://doi.org/10.4018/IJNCR.2019040104

Chicago

Chakraborty, Sonali Ashish, and Jyotika Doshi. "Reducing Query Processing Time for Non-Synonymous Materialized Queries With Differed Criteria," International Journal of Natural Computing Research (IJNCR) 8, no.2: 75-93. http://doi.org/10.4018/IJNCR.2019040104

Export Reference

Mendeley
Favorite Full-Issue Download

Abstract

Results of OLAP queries for strategic decision making are generated using warehouse data. For frequent queries, processing overhead increases as same results are generated by traversing through huge volume of warehouse data. Authors suggest saving time for frequent queries by storing them in a relational database referred as MQDB, along with its result and metadata information. Incremental updates for synonymous materialized queries are done using data marts. This article focusses on saving processing time for non-synonymous queries with differed criteria. Criteria is the query condition specified with ‘where' or a ‘having' clause apart from equijoin condition. Defined rules will determine if new results can be derived from existing stored results. If criteria of fired query are a subset of criteria in stored query, results are extracted from existing results using MINUS operation. When criteria are a superset of stored query criteria, new results are appended to existing results using the UNION operation.

Request Access

You do not own this content. Please login to recommend this title to your institution's librarian or purchase it from the IGI Global bookstore.