{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2025,12,12]],"date-time":"2025-12-12T13:36:43Z","timestamp":1765546603511,"version":"3.37.3"},"reference-count":48,"publisher":"World Scientific Pub Co Pte Ltd","issue":"03","content-domain":{"domain":[],"crossmark-restriction":false},"short-container-title":["Int. J. Coop. Info. Syst."],"published-print":{"date-parts":[[2020,9]]},"abstract":"<jats:p> The process of extracting data from different heterogeneous data sources, transforming them into an integrated, unified and cleaned repository, and storing the result as a single entity leads to the construction of a data warehouse (DW), which facilitates access to data for the users of information systems and decision support systems. Due to their enormous volumes of data, processing of analytical queries of decision support systems need to scan very large amounts of data, which has a negative effect on the systems\u2019 response time. Because of the special importance of online analytical processing (OLAP) in these systems, to enhance the performance and improve the query response time of the system, an appropriate number of views of the DW are selected for materialization and will be utilized for responding to the analytical queries, instead of direct access to the base relations. Memory constraint and views maintenance overhead are two main limitations that make it impossible, in most cases, to materialize all views of the DW. Selecting a proper set of views of DW for materialization, called materialized view selection (MVS) problem, is an important research issue that has been focused in various papers. In this paper, we have proposed a method, called P-SA, to select an appropriate set of views using an improved version of simulated annealing (SA) algorithm that utilizes a proper neighborhood selection strategy. P-SA uses the multiple view processing plan (MVPP) structure for selecting the views. Data and queries of a benchmark DW have been used in experimental results for evaluating the introduced method. The experimental results show better performance of the P-SA compared to other SA-based MVS methods for increasing the number of queries, in terms of the total cost of view maintenance and query processing. Moreover, the total cost of queries in the P-SA is also better than the other important SA-based MVS methods of the literature when the size of the DW is increased. <\/jats:p>","DOI":"10.1142\/s021884302050001x","type":"journal-article","created":{"date-parts":[[2020,6,18]],"date-time":"2020-06-18T14:38:25Z","timestamp":1592491105000},"page":"2050001","source":"Crossref","is-referenced-by-count":8,"title":["MVPP-Based Materialized View Selection in Data Warehouses Using Simulated Annealing"],"prefix":"10.1142","volume":"29","author":[{"given":"Mohsen","family":"Mohseni","sequence":"first","affiliation":[{"name":"Department of Computer Engineering, Semnan Branch, Islamic Azad University, Semnan, Iran"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"ORCID":"https:\/\/orcid.org\/0000-0001-8066-0356","authenticated-orcid":false,"given":"Mohammad Karim","family":"Sohrabi","sequence":"additional","affiliation":[{"name":"Department of Computer Engineering, Semnan Branch, Islamic Azad University, Semnan, Iran"}],"role":[{"role":"author","vocabulary":"crossref"}]}],"member":"219","published-online":{"date-parts":[[2020,8,28]]},"reference":[{"key":"S021884302050001XBIB001","doi-asserted-by":"publisher","DOI":"10.1109\/TKDE.2005.16"},{"key":"S021884302050001XBIB002","doi-asserted-by":"publisher","DOI":"10.1109\/TSMCC.2004.843248"},{"key":"S021884302050001XBIB003","doi-asserted-by":"publisher","DOI":"10.1142\/S0218843001000370"},{"key":"S021884302050001XBIB004","doi-asserted-by":"publisher","DOI":"10.1109\/TSMCC.2003.818494"},{"key":"S021884302050001XBIB005","doi-asserted-by":"publisher","DOI":"10.1016\/S0169-023X(02)00045-9"},{"key":"S021884302050001XBIB006","doi-asserted-by":"publisher","DOI":"10.1002\/9780470496916"},{"key":"S021884302050001XBIB007","doi-asserted-by":"publisher","DOI":"10.1109\/5326.971656"},{"key":"S021884302050001XBIB008","first-page":"25","volume":"97","author":"Yang J.","year":"1997","journal-title":"VLDB"},{"key":"S021884302050001XBIB009","doi-asserted-by":"publisher","DOI":"10.3906\/elk-1608-112"},{"key":"S021884302050001XBIB010","doi-asserted-by":"publisher","DOI":"10.1145\/335191.335419"},{"key":"S021884302050001XBIB011","doi-asserted-by":"publisher","DOI":"10.1145\/235968.233333"},{"key":"S021884302050001XBIB012","first-page":"150","volume":"5","author":"Suchyukorn B.","year":"2013","journal-title":"Int. J. Adv. Comput. Technol."},{"key":"S021884302050001XBIB013","doi-asserted-by":"publisher","DOI":"10.1016\/j.engappai.2018.02.018"},{"key":"S021884302050001XBIB014","first-page":"89","volume-title":"Proc. Int. Conf. Databases and Applications","author":"Derakhshan R.","year":"2006"},{"key":"S021884302050001XBIB015","doi-asserted-by":"publisher","DOI":"10.1016\/j.is.2013.03.005"},{"key":"S021884302050001XBIB016","doi-asserted-by":"publisher","DOI":"10.1109\/ICDE.2008.4497496"},{"key":"S021884302050001XBIB017","doi-asserted-by":"publisher","DOI":"10.1145\/1516360.1516484"},{"key":"S021884302050001XBIB018","doi-asserted-by":"publisher","DOI":"10.1145\/376284.375703"},{"key":"S021884302050001XBIB019","first-page":"116","volume-title":"Data Warehousing and Knowledge Discovery","author":"Zhang C.","year":"1999"},{"key":"S021884302050001XBIB020","doi-asserted-by":"publisher","DOI":"10.1109\/ETCS.2010.480"},{"key":"S021884302050001XBIB021","first-page":"464","volume":"3","author":"Jogekar R. N.","year":"2013","journal-title":"Int. J. Emerging Technol. Adv. Eng."},{"key":"S021884302050001XBIB022","doi-asserted-by":"publisher","DOI":"10.1007\/s11831-018-9300-5"},{"key":"S021884302050001XBIB023","doi-asserted-by":"publisher","DOI":"10.1007\/s00500-002-0243-1"},{"key":"S021884302050001XBIB024","doi-asserted-by":"publisher","DOI":"10.4018\/IJSSCI.2015100103"},{"key":"S021884302050001XBIB025","doi-asserted-by":"publisher","DOI":"10.4018\/IJIIT.2017010102"},{"key":"S021884302050001XBIB026","first-page":"534","volume-title":"Proc. IEEE Int. Conf. Intelligent Computing and Integrated Systems, ICISS\u201910","author":"Song X.","year":"2010"},{"key":"S021884302050001XBIB027","doi-asserted-by":"publisher","DOI":"10.1109\/IWISA.2009.5072711"},{"key":"S021884302050001XBIB028","doi-asserted-by":"publisher","DOI":"10.1007\/s10489-019-01481-w"},{"key":"S021884302050001XBIB029","doi-asserted-by":"crossref","first-page":"168","DOI":"10.1007\/978-3-642-35542-4_15","volume-title":"Proc. Int. Conf. Big Data Analytics, BDA\u201912","author":"Kumar T. V. Vijay","year":"2012"},{"key":"S021884302050001XBIB030","doi-asserted-by":"publisher","DOI":"10.1145\/38713.38722"},{"key":"S021884302050001XBIB031","doi-asserted-by":"publisher","DOI":"10.1016\/j.cor.2015.03.002"},{"key":"S021884302050001XBIB032","doi-asserted-by":"publisher","DOI":"10.1016\/j.physa.2016.03.029"},{"key":"S021884302050001XBIB033","doi-asserted-by":"publisher","DOI":"10.1016\/j.eswa.2017.01.053"},{"key":"S021884302050001XBIB034","doi-asserted-by":"publisher","DOI":"10.1007\/s10844-009-0080-0"},{"key":"S021884302050001XBIB035","doi-asserted-by":"publisher","DOI":"10.1016\/j.knosys.2018.09.012"},{"key":"S021884302050001XBIB036","first-page":"225","volume-title":"Proc. Int. Conf. Contemporary Computing, Contemporary Computing, IC3","author":"Kumar T. V. Vijay","year":"2012"},{"key":"S021884302050001XBIB037","doi-asserted-by":"publisher","DOI":"10.1504\/IJICA.2014.066499"},{"key":"S021884302050001XBIB038","doi-asserted-by":"publisher","DOI":"10.1007\/978-981-10-7566-7_25"},{"key":"S021884302050001XBIB039","doi-asserted-by":"publisher","DOI":"10.1007\/s12046-018-0936-5"},{"key":"S021884302050001XBIB040","doi-asserted-by":"publisher","DOI":"10.4304\/jcp.6.1.130-138"},{"key":"S021884302050001XBIB041","first-page":"18455346","volume-title":"Proc. 1st Annual Int. Conf. Information and Sciences (AiCIS)","author":"Al Saedi A. K. Z.","year":"2018"},{"key":"S021884302050001XBIB042","doi-asserted-by":"publisher","DOI":"10.1016\/j.ins.2006.09.007"},{"journal-title":"Int. J. Syst. Assur. Eng. Manag.","year":"2020","author":"Prakash J.","key":"S021884302050001XBIB043"},{"key":"S021884302050001XBIB044","doi-asserted-by":"publisher","DOI":"10.1007\/s13198-019-00812-x"},{"key":"S021884302050001XBIB045","doi-asserted-by":"publisher","DOI":"10.1007\/s10844-017-0455-6"},{"key":"S021884302050001XBIB046","doi-asserted-by":"publisher","DOI":"10.1007\/978-3-540-69501-1_14"},{"key":"S021884302050001XBIB048","doi-asserted-by":"publisher","DOI":"10.1126\/science.220.4598.671"},{"key":"S021884302050001XBIB049","doi-asserted-by":"publisher","DOI":"10.1142\/S0218843019300018"}],"container-title":["International Journal of Cooperative Information Systems"],"original-title":[],"language":"en","link":[{"URL":"https:\/\/www.worldscientific.com\/doi\/pdf\/10.1142\/S021884302050001X","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2020,9,29]],"date-time":"2020-09-29T08:55:12Z","timestamp":1601369712000},"score":1,"resource":{"primary":{"URL":"https:\/\/www.worldscientific.com\/doi\/abs\/10.1142\/S021884302050001X"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2020,8,28]]},"references-count":48,"journal-issue":{"issue":"03","published-print":{"date-parts":[[2020,9]]}},"alternative-id":["10.1142\/S021884302050001X"],"URL":"https:\/\/doi.org\/10.1142\/s021884302050001x","relation":{},"ISSN":["0218-8430","1793-6365"],"issn-type":[{"type":"print","value":"0218-8430"},{"type":"electronic","value":"1793-6365"}],"subject":[],"published":{"date-parts":[[2020,8,28]]}}}