{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2025,10,16]],"date-time":"2025-10-16T10:06:04Z","timestamp":1760609164517,"version":"3.37.3"},"reference-count":38,"publisher":"Springer Science and Business Media LLC","issue":"4","license":[{"start":{"date-parts":[[2019,6,14]],"date-time":"2019-06-14T00:00:00Z","timestamp":1560470400000},"content-version":"tdm","delay-in-days":0,"URL":"http:\/\/www.springer.com\/tdm"},{"start":{"date-parts":[[2019,6,14]],"date-time":"2019-06-14T00:00:00Z","timestamp":1560470400000},"content-version":"vor","delay-in-days":0,"URL":"http:\/\/www.springer.com\/tdm"}],"content-domain":{"domain":["link.springer.com"],"crossmark-restriction":false},"short-container-title":["Int J Syst Assur Eng Manag"],"published-print":{"date-parts":[[2019,8]]},"DOI":"10.1007\/s13198-019-00812-x","type":"journal-article","created":{"date-parts":[[2019,6,14]],"date-time":"2019-06-14T09:02:35Z","timestamp":1560502955000},"page":"801-810","update-policy":"https:\/\/doi.org\/10.1007\/springer_crossmark_policy","source":"Crossref","is-referenced-by-count":7,"title":["Selection of materialized views using stochastic ranking based Backtracking Search Optimization Algorithm"],"prefix":"10.1007","volume":"10","author":[{"given":"Anjana","family":"Gosain","sequence":"first","affiliation":[],"role":[{"role":"author","vocabulary":"crossref"}]},{"ORCID":"https:\/\/orcid.org\/0000-0002-5745-4586","authenticated-orcid":false,"given":"Kavita","family":"Sachdeva","sequence":"additional","affiliation":[],"role":[{"role":"author","vocabulary":"crossref"}]}],"member":"297","published-online":{"date-parts":[[2019,6,14]]},"reference":[{"key":"812_CR1","doi-asserted-by":"crossref","unstructured":"Agrawal S, Chaudhuri S, Narasayya VR (2001) Materialized view and index selection tool for microsoft SQL server 2000. In: Proceedings of the special interest group on management of data conference (ACM SIGMOND), p 608","DOI":"10.1145\/375663.375769"},{"key":"812_CR500","unstructured":"Bezdek JC (2001) What is computational intelligence? In: Computational intelligence lmitating life. IEEE Press, New York, pp 1\u201312"},{"issue":"2","key":"812_CR2","doi-asserted-by":"publisher","first-page":"367","DOI":"10.1145\/276305.276337","volume":"27","author":"Surajit Chaudhuri","year":"1998","unstructured":"Chaudhuri S, Narasayya VR (1998) AutoAdmin \u2018what-if\u2019 index analysis utility. In: Proceedings of the special interest group on management of data conference ACM SIGMOND, pp 367\u2013378","journal-title":"ACM SIGMOD Record"},{"key":"812_CR3","doi-asserted-by":"crossref","unstructured":"Chaudhuri S, Krishnamurthy R, Potamianos S, Shim K (1995) Optimizing queries with materialized views. In: Proceedings of the 11th international conference on data engineering, pp 190\u2013200","DOI":"10.1109\/ICDE.1995.380392"},{"key":"812_CR4","doi-asserted-by":"crossref","unstructured":"Choi CH, Yu JX, Lu H (2004) A simple but effective dynamic materialized view caching. In: International conference on web-age information management. Springer, pp 147\u2013156","DOI":"10.1007\/978-3-540-27772-9_16"},{"key":"812_CR5","first-page":"8121","volume":"219","author":"P Civicioglu","year":"2013","unstructured":"Civicioglu P (2013) Backtracking search optimization algorithm for numerical optimization problems. Appl Math Comput 219:8121\u20138144","journal-title":"Appl Math Comput"},{"key":"812_CR6","doi-asserted-by":"crossref","unstructured":"Coello CAC (2002) Theoretical and numerical constraint-handling techniques used with evolutionary algorithms: a survey of the state of the art. In: Computer methods in applied mechanics and engineering. Elsevier, pp 1245\u20131287","DOI":"10.1016\/S0045-7825(01)00323-1"},{"key":"812_CR7","unstructured":"Coello CAC (2012) Constraint-handling techniques used with evolutionary algorithms. In: Genetic and evolutionary computation conference GECCO\u201912. ACM"},{"key":"812_CR10","doi-asserted-by":"crossref","unstructured":"Gosain A, Heena (2016) Materialized cube selection using particle swarm optimization algorithm. In: 7th international conference on communication, computing and virtualization, vol 79. Elsevier, pp 2\u20137","DOI":"10.1016\/j.procs.2016.03.002"},{"issue":"1","key":"812_CR12","doi-asserted-by":"publisher","first-page":"29","DOI":"10.1023\/A:1009726021843","volume":"1","author":"J Gray","year":"1997","unstructured":"Gray J, Layman A, Bosworth A, Pirahesh H (1997) Data cube: a relational aggregation operator generalizing group-by, cross-tabs and subtotals. Data Min Knowl Discov 1(1):29\u201353","journal-title":"Data Min Knowl Discov"},{"key":"812_CR13","doi-asserted-by":"crossref","unstructured":"Gupta H (1997) Selection of views to materialize in a data warehouse. In: Proceedings of the 6th international conference on database theory. Springer, pp 98\u2013112","DOI":"10.1007\/3-540-62222-5_39"},{"key":"812_CR14","doi-asserted-by":"crossref","unstructured":"Gupta H, Mumick IS (1999) Selection of views to materialize under a maintenance cost constraint. In: Proceedings of the 7th international conference on database theory. Springer, pp 453\u2013470","DOI":"10.1007\/3-540-49257-7_28"},{"issue":"1","key":"812_CR15","doi-asserted-by":"publisher","first-page":"24","DOI":"10.1109\/TKDE.2005.16","volume":"17","author":"H Gupta","year":"2005","unstructured":"Gupta H, Mumick IS (2005) Selection of views to materialize in a data warehouse. IEEE Trans Knowl Data Eng 17(1):24\u201343","journal-title":"IEEE Trans Knowl Data Eng"},{"key":"812_CR16","doi-asserted-by":"crossref","unstructured":"Gupta H, Harinarayan V, Rajaraman A, Ullman JD (1997) Index selection for OLAP. In: Proceedings of 13th international conference on data engineering, pp 208\u2013219","DOI":"10.1109\/ICDE.1997.581755"},{"issue":"4","key":"812_CR17","doi-asserted-by":"publisher","first-page":"270","DOI":"10.1007\/s007780100054","volume":"10","author":"AY Halevy","year":"2001","unstructured":"Halevy AY (2001) Answering queries using views: a survey. VLDB J 10(4):270\u2013294","journal-title":"VLDB J"},{"key":"812_CR18","volume-title":"Data mining: concepts and techniques","author":"J Han","year":"2001","unstructured":"Han J, Kamber M (2001) Data mining: concepts and techniques. Morgan Kaufman, San Francisco"},{"key":"812_CR19","doi-asserted-by":"crossref","unstructured":"Harinarayan V, Rajaraman A, Ullman JD (1996) Implementing data cubes efficiently. In: Proceedings of the 1996 ACM SIGMOD international conference on management of data, Montreal, Que., Canada, pp 205\u2013216","DOI":"10.1145\/233269.233333"},{"issue":"8","key":"812_CR21","doi-asserted-by":"publisher","first-page":"574","DOI":"10.1007\/s00500-002-0243-1","volume":"7","author":"JT Horng","year":"2003","unstructured":"Horng JT, Chang YJ, Liu BJ (2003) Applying evolutionary algorithms to materialized view selection in a data warehouse. Soft Comput 7(8):574\u2013581","journal-title":"Soft Comput"},{"issue":"6","key":"812_CR22","doi-asserted-by":"publisher","first-page":"1333","DOI":"10.1016\/j.ins.2006.09.007","volume":"177","author":"MC Hung","year":"2007","unstructured":"Hung MC, Huang ML, Yang DL, Hsueh NL (2007) Efficient approaches for materialized views selection in a data warehouse. Inf Sci 177(6):1333\u20131348","journal-title":"Inf Sci"},{"issue":"5","key":"812_CR23","first-page":"1","volume":"37","author":"Hemant Jain","year":"2012","unstructured":"Jain H, Gosain A (2012) A comprehensive study of view maintenance approaches in data warehousing evolution. In: ACM SIGSOFT software engineering notes, vol 37, no 5, pp 1\u20138","journal-title":"ACM SIGSOFT Software Engineering Notes"},{"key":"812_CR24","doi-asserted-by":"crossref","unstructured":"Kotidis Y, Roussopoulos N (1999) Dynamat: a dynamic view management system for data warehouses. In: ACM SIGMOD record, vol 28. ACM, pp 371\u2013382","DOI":"10.1145\/304181.304215"},{"issue":"4","key":"812_CR25","doi-asserted-by":"publisher","first-page":"35","DOI":"10.4018\/IJSSCI.2015100103","volume":"7","author":"TV Kumar","year":"2015","unstructured":"Kumar TV, Arun B (2015) Materialized view selection using improvement based bee colony optimization. Int J Softw Sci Comput Intell 7(4):35\u201361","journal-title":"Int J Softw Sci Comput Intell"},{"key":"812_CR31","doi-asserted-by":"crossref","unstructured":"Lawrence M, Rau-Chaplin A (2006) Dynamic view selection for OLAP. In: International conference on data warehousing and knowledge discovery. Springer, pp 33\u201344","DOI":"10.1007\/11823728_4"},{"issue":"3","key":"812_CR32","doi-asserted-by":"publisher","first-page":"327","DOI":"10.1142\/S0218843001000370","volume":"10","author":"M Lee","year":"2001","unstructured":"Lee M, Hammer J (2001) Speeding up materialized view selection in data warehouses using a randomized algorithm. Int J Cooper Inf Syst 10(3):327\u2013353","journal-title":"Int J Cooper Inf Syst"},{"issue":"1","key":"812_CR33","doi-asserted-by":"publisher","first-page":"83","DOI":"10.1007\/s10115-003-0093-x","volume":"6","author":"WY Lin","year":"2004","unstructured":"Lin WY, Kuo IC (2004) A genetic selection algorithm for OLAP data cubes. Knowl Inf Syst 6(1):83\u2013102","journal-title":"Knowl Inf Syst"},{"key":"812_CR34","doi-asserted-by":"publisher","first-page":"396","DOI":"10.1007\/978-3-642-23091-2_33","volume-title":"Database and expert systems applications","author":"I Mami","year":"2011","unstructured":"Mami I, Coletta R, Bellahsene Z (2011) Modeling view selection as a constraint satisfaction problem. In: Hameurlain A., Liddle SW, Schewe KD, Zhou X (eds) Database and expert systems applications, vol 6861. Springer, Berlin, pp 396\u2013410"},{"key":"812_CR35","volume-title":"Parallel systems in the data warehouse","author":"S Morse","year":"1998","unstructured":"Morse S, Isaac D (1998) Parallel systems in the data warehouse. Prentice Hall, Upper saddle River"},{"key":"812_CR36","unstructured":"O\u2019Neil PE, O\u2019Neil EJ, Chen X (2007) The star schema benchmark (SSB). Pat"},{"key":"812_CR37","doi-asserted-by":"publisher","first-page":"284","DOI":"10.1109\/4235.873238","volume":"4","author":"TP Runarsson","year":"2000","unstructured":"Runarsson TP, Yao X (2000) Stochastic ranking for constrained evolutionary optimization. IEEE Trans Evolut Comput 4:284\u2013294","journal-title":"IEEE Trans Evolut Comput"},{"key":"812_CR38","unstructured":"Shukla A, Deshpande P, Naughton J F (1998) Materialized view selection for multidimensional datasets. In: Proceedings of 24th international conference on very large data bases, pp 488\u2013499"},{"key":"812_CR39","doi-asserted-by":"publisher","first-page":"558","DOI":"10.1016\/j.knosys.2018.09.012","volume":"163","author":"MK Sohrabi","year":"2019","unstructured":"Sohrabi MK, Azgomi H (2019) Evolutionary game theory approach to materialized view selection in datawarehouse. Knowl Based Syst 163:558\u2013571","journal-title":"Knowl Based Syst"},{"key":"812_CR40","doi-asserted-by":"crossref","unstructured":"Sun X, Ziqiang W (2009) An efficient materialized views selection algorithm based on PSO. In: Proceedings of the international workshop on intelligent systems and applications, ISA 2009, Wuhan, China","DOI":"10.1109\/IWISA.2009.5072711"},{"key":"812_CR41","doi-asserted-by":"publisher","first-page":"111","DOI":"10.1016\/j.datak.2012.11.001","volume":"83","author":"ZA Talebi","year":"2013","unstructured":"Talebi ZA, Chirkova R, Fathi Y (2013) An integer programming approach for the view and index selection problem. Data Knowl Eng 83:111\u2013125","journal-title":"Data Knowl Eng"},{"key":"812_CR43","unstructured":"Tamiozzo AS, Ale JM (2014) A solution to the materialized view selection problem in data warehousing. In: XX Congreso Argentino de Ciencias de la Computaci\u00f3n (Buenos Aires, 2014)"},{"key":"812_CR45","unstructured":"Yang J, Karlapalem K, Li Q (1997) Algorithms for materialized view design in data warehousing environment. In: VLDB, Proceedings of the 23rd international conference on very large data bases, vol 97, pp 136\u2013145"},{"issue":"4","key":"812_CR47","doi-asserted-by":"publisher","first-page":"458","DOI":"10.1109\/TSMCC.2003.818494","volume":"33","author":"JX Yu","year":"2003","unstructured":"Yu JX, Yao X, Choi CH, Gou G (2003) Materialized view selection as constrained evolutionary optimization. IEEE Trans Syst Man Cybernet Part C Appl Rev 33(4):458\u2013467","journal-title":"IEEE Trans Syst Man Cybernet Part C Appl Rev"},{"issue":"6","key":"812_CR48","doi-asserted-by":"crossref","first-page":"1091","DOI":"10.1080\/18756891.2015.1113744","volume":"8","author":"D Yu","year":"2015","unstructured":"Yu D, Dou W, Zhu Z, Wang J (2015) Materialized view selection based on adaptive genetic algorithm and its implementation with Apache Hive. Int J Comput Intell Syst 8(6):1091\u20131102","journal-title":"Int J Comput Intell Syst"},{"issue":"3","key":"812_CR49","doi-asserted-by":"publisher","first-page":"282","DOI":"10.1109\/5326.971656","volume":"31","author":"C Zhang","year":"2001","unstructured":"Zhang C, Yao X, Yang J (2001) An evolutionary approach to materialized views selection in a data warehouse environment. IEEE Trans Syst Man Cybernet Part C Appl Rev 31(3):282\u2013294","journal-title":"IEEE Trans Syst Man Cybernet Part C Appl Rev"}],"container-title":["International Journal of System Assurance Engineering and Management"],"original-title":[],"language":"en","link":[{"URL":"http:\/\/link.springer.com\/content\/pdf\/10.1007\/s13198-019-00812-x.pdf","content-type":"application\/pdf","content-version":"vor","intended-application":"text-mining"},{"URL":"http:\/\/link.springer.com\/article\/10.1007\/s13198-019-00812-x\/fulltext.html","content-type":"text\/html","content-version":"vor","intended-application":"text-mining"},{"URL":"http:\/\/link.springer.com\/content\/pdf\/10.1007\/s13198-019-00812-x.pdf","content-type":"application\/pdf","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2020,6,12]],"date-time":"2020-06-12T23:31:25Z","timestamp":1592004685000},"score":1,"resource":{"primary":{"URL":"http:\/\/link.springer.com\/10.1007\/s13198-019-00812-x"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2019,6,14]]},"references-count":38,"journal-issue":{"issue":"4","published-print":{"date-parts":[[2019,8]]}},"alternative-id":["812"],"URL":"https:\/\/doi.org\/10.1007\/s13198-019-00812-x","relation":{},"ISSN":["0975-6809","0976-4348"],"issn-type":[{"type":"print","value":"0975-6809"},{"type":"electronic","value":"0976-4348"}],"subject":[],"published":{"date-parts":[[2019,6,14]]},"assertion":[{"value":"12 December 2017","order":1,"name":"received","label":"Received","group":{"name":"ArticleHistory","label":"Article History"}},{"value":"8 May 2019","order":2,"name":"revised","label":"Revised","group":{"name":"ArticleHistory","label":"Article History"}},{"value":"14 June 2019","order":3,"name":"first_online","label":"First Online","group":{"name":"ArticleHistory","label":"Article History"}}]}}