{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2022,5,7]],"date-time":"2022-05-07T06:10:24Z","timestamp":1651903824186},"reference-count":40,"publisher":"IGI Global","issue":"2","content-domain":{"domain":[],"crossmark-restriction":false},"short-container-title":[],"published-print":{"date-parts":[[2019,4]]},"abstract":"<jats:p>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 \u2018where' or a \u2018having' 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.<\/jats:p>","DOI":"10.4018\/ijncr.2019040104","type":"journal-article","created":{"date-parts":[[2019,3,21]],"date-time":"2019-03-21T17:18:30Z","timestamp":1553188710000},"page":"75-93","source":"Crossref","is-referenced-by-count":3,"title":["Reducing Query Processing Time for Non-Synonymous Materialized Queries With Differed Criteria"],"prefix":"10.4018","volume":"8","author":[{"given":"Sonali Ashish","family":"Chakraborty","sequence":"first","affiliation":[{"name":"GLS University, Ahmedabad, India"}]},{"given":"Jyotika","family":"Doshi","sequence":"additional","affiliation":[{"name":"GLS University, Ahmedabad, India"}]}],"member":"2432","reference":[{"key":"IJNCR.2019040104-0","unstructured":"Abdelhedi, G. P. (2011). Computer Aided Data Mart Design. ICEIS, (1)."},{"key":"IJNCR.2019040104-1","first-page":"232","article-title":"A. G. (n.d.). Modeling Multidimensional Databases.","author":"R.Agrawal","journal-title":"13th International Conference on Data Engineering"},{"issue":"3","key":"IJNCR.2019040104-2","first-page":"269","article-title":"Query Dispatching Tool Supporting Fast Access to Data Warehouse.","volume":"10","author":"Alijanabi","year":"2013","journal-title":"The International Arab Journal of Information Technology"},{"key":"IJNCR.2019040104-3","unstructured":"Bara, I. L. (2008). Improving query performance in Virtual Data Warehouses. WSEAS TRANSACTIONS on Information Science & Applications, 5(5), 632-641."},{"key":"IJNCR.2019040104-4","article-title":"Intelligent Computing and Information and Communication.","author":"S.Bhalla","year":"2018","journal-title":"Proceedings of 2nd International Conference ICICC 2017"},{"key":"IJNCR.2019040104-5","author":"V.Bhateja","year":"2018","journal-title":"Proceedings of the 6th International Conference on FICTA"},{"key":"IJNCR.2019040104-6","article-title":"Information Systems Design and Intelligent Applications.","author":"V.Bhateja","year":"2018","journal-title":"Proceedings of Fourth International Conference INDIA 2017"},{"key":"IJNCR.2019040104-7","doi-asserted-by":"publisher","DOI":"10.1145\/384189.384190"},{"issue":"1","key":"IJNCR.2019040104-8","first-page":"1527","article-title":"An Approach for Creating and Maintaining Dependent Data Marts using Materialized Querie\u2019s Information. International Journal of Scientific Research in Science","volume":"4","author":"SChakraborty","year":"2018","journal-title":"Engineering and Technology"},{"issue":"5","key":"IJNCR.2019040104-9","first-page":"835","article-title":"Deriving Aggregate Results with Incremental Data Using Materialize Queries.","volume":"6","author":"S.Chakraborty","year":"2018","journal-title":"International Journal on Computer Science and Engineering"},{"key":"IJNCR.2019040104-10","article-title":"Incremental Updates using Data Warehouse versus Data Marts.","author":"S.Chakraborty","year":"2018","journal-title":"4th IEEE International Conference on Convergence of Technology (I2CT)."},{"issue":"1","key":"IJNCR.2019040104-11","first-page":"243","article-title":"Performance Evaluation of Materialized Query.","volume":"8","author":"S.Chakraborty","year":"2018","journal-title":"International Journal of Emerging Technology and Advanced Engineering"},{"key":"IJNCR.2019040104-12","doi-asserted-by":"crossref","unstructured":"Chakraborty, S., J. D. (2018). Materialized Queries with Incremental Updates. In 3rd International Conference on Information and Communication Technology for Intelligent Systems. Ahmedabad: Springer Smart Innovation, Systems and Technologies (SIST).","DOI":"10.1007\/978-981-13-1742-2_4"},{"key":"IJNCR.2019040104-13","first-page":"190","article-title":"R. K. (n.d.). Optimizing Queries with Materialized Views.","author":"S.Chaudhuri","journal-title":"Proceedings of the Eleventh International Conference on Data Engineering"},{"key":"IJNCR.2019040104-14","doi-asserted-by":"publisher","DOI":"10.1147\/sj.414.0714"},{"key":"IJNCR.2019040104-15","doi-asserted-by":"publisher","DOI":"10.1016\/S0167-9236(99)00052-4"},{"key":"IJNCR.2019040104-16","article-title":"S. A. (n.d.). Computation of Multidimensional Aggregates.","author":"P.Deshpande","journal-title":"Proceedings of 22nd VLDB Conference"},{"key":"IJNCR.2019040104-17","doi-asserted-by":"publisher","DOI":"10.1145\/375663.375706"},{"key":"IJNCR.2019040104-18","doi-asserted-by":"publisher","DOI":"10.1145\/170035.170066"},{"issue":"2","key":"IJNCR.2019040104-19","article-title":"Maintenance of Materialized Views: Problems, Techniques and Applications.","volume":"18","author":"A.Gupta","year":"1995","journal-title":"A Quarterly Bulletin of the Computer Society of the IEEE Technical Committee on Data Engineering"},{"key":"IJNCR.2019040104-20","doi-asserted-by":"crossref","unstructured":"Gupta, A. H. J. (1996). Data Integration using Self Maintainable Views. In Advances in Database Technology-EDBT (pp. 140-144).","DOI":"10.1007\/BFb0014149"},{"key":"IJNCR.2019040104-21","article-title":"Data Mining-Concepts and Techniques (Vol. 3).","author":"J.Han","journal-title":"Morgan Kaufman Publishers."},{"key":"IJNCR.2019040104-22","doi-asserted-by":"crossref","first-page":"205","DOI":"10.1145\/235968.233333","article-title":"Implementing Data Cubes Efficiently.","author":"V.Harinarayan","year":"1996","journal-title":"ACM SIGMOD International Conference on Management Of Data"},{"issue":"4","key":"IJNCR.2019040104-23","first-page":"418","article-title":"Tuning the SQL Query in order to Reduc Time Consumption. IJCSI","volume":"9","author":"P.Karthik","year":"2012","journal-title":"International Journal of Computational Science"},{"key":"IJNCR.2019040104-24","first-page":"81","article-title":"X. S. (n.d.). A Data Model for Supporting Online Analytical Processing.","author":"C.Li","journal-title":"Proceedings of the fith International Conference on Information and Knowledge Management"},{"key":"IJNCR.2019040104-25","unstructured":"Nabli, A. A. S. (2005). Towards An Automatic Data Mart Design. In ICEIS, 2005- Databases and Information Systems Integration, (pp. 226-231)."},{"key":"IJNCR.2019040104-26","doi-asserted-by":"publisher","DOI":"10.1145\/253260.253268"},{"key":"IJNCR.2019040104-27","doi-asserted-by":"publisher","DOI":"10.1145\/233269.233361"},{"key":"IJNCR.2019040104-28","article-title":"C. W.-H.-L. (n.d.). Dynamic Update Cube for Range-Sum Queries.","journal-title":"Proceedings of the 27th VLDB Conference"},{"key":"IJNCR.2019040104-29","doi-asserted-by":"crossref","unstructured":"Satapathy, S. C. (2016). Computer Communication. Networking and Internet security. In Proceedings of IC3T 5.","DOI":"10.1007\/978-981-10-3226-4"},{"key":"IJNCR.2019040104-30","doi-asserted-by":"publisher","DOI":"10.1016\/j.infsof.2006.09.008"},{"key":"IJNCR.2019040104-31","first-page":"223","article-title":"U. F. (n.d.). Compressed Data Cubes for OLAP Aggregate Query Approximation on Continous Dimensions.","author":"J.Shanmugasundaram","journal-title":"Proceedings of the fifth ACM SIGKDD International Conference on Knowledge Discovery and Data Mining"},{"key":"IJNCR.2019040104-32","unstructured":"Srivastava, D. S. D. (1996). Answering Queries with Aggregation using Views. InProceedings of the 22nd VLDB Conference."},{"issue":"2","key":"IJNCR.2019040104-33","first-page":"409","article-title":"Ideal Strategy to Improve Data Warehouse Performance.","volume":"2","author":"F.Sultan","year":"2010","journal-title":"International Journal on Computer Science and Engineering"},{"key":"IJNCR.2019040104-34","article-title":"Data Warehouse Configuration.","author":"D.Theodoratos","year":"1997","journal-title":"Proceedings of the 23rd VLDB Conference"},{"key":"IJNCR.2019040104-35","unstructured":"Vanichayobon, S. (n.d.). Indexing Techniques for Data Warehouses' Queries. Retrieved from http:\/\/www.cs.ou.edu\/~database\/documents\/vg99.pdf"},{"key":"IJNCR.2019040104-36","doi-asserted-by":"publisher","DOI":"10.1109\/SSDM.1998.688111"},{"key":"IJNCR.2019040104-37","doi-asserted-by":"publisher","DOI":"10.1145\/344816.344869"},{"key":"IJNCR.2019040104-38","first-page":"231","article-title":"Lazy Maintenance of Materialized Views.","author":"J.Zhou","year":"2007","journal-title":"Proceedings of the 33rd International Conference on Very Large Databases"},{"key":"IJNCR.2019040104-39","doi-asserted-by":"publisher","DOI":"10.1145\/223784.223848"}],"container-title":["International Journal of Natural Computing Research"],"original-title":[],"language":"en","link":[{"URL":"https:\/\/www.igi-global.com\/viewtitle.aspx?TitleId=225824","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2022,5,6]],"date-time":"2022-05-06T14:11:49Z","timestamp":1651846309000},"score":1,"resource":{"primary":{"URL":"http:\/\/services.igi-global.com\/resolvedoi\/resolve.aspx?doi=10.4018\/IJNCR.2019040104"}},"subtitle":[""],"short-title":[],"issued":{"date-parts":[[2019,4]]},"references-count":40,"journal-issue":{"issue":"2"},"URL":"https:\/\/doi.org\/10.4018\/ijncr.2019040104","relation":{},"ISSN":["1947-928X","1947-9298"],"issn-type":[{"value":"1947-928X","type":"print"},{"value":"1947-9298","type":"electronic"}],"subject":[],"published":{"date-parts":[[2019,4]]}}}