{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2025,7,30]],"date-time":"2025-07-30T14:48:05Z","timestamp":1753886885349,"version":"3.41.2"},"reference-count":39,"publisher":"Wiley","issue":"1","license":[{"start":{"date-parts":[[2018,10,2]],"date-time":"2018-10-02T00:00:00Z","timestamp":1538438400000},"content-version":"vor","delay-in-days":274,"URL":"http:\/\/creativecommons.org\/licenses\/by\/4.0\/"}],"funder":[{"DOI":"10.13039\/501100004731","name":"Natural Science Foundation of Zhejiang Province","doi-asserted-by":"publisher","award":["LY17G010008","LQ18E090004"],"award-info":[{"award-number":["LY17G010008","LQ18E090004"]}],"id":[{"id":"10.13039\/501100004731","id-type":"DOI","asserted-by":"publisher"}]}],"content-domain":{"domain":["onlinelibrary.wiley.com"],"crossmark-restriction":true},"short-container-title":["Complexity"],"published-print":{"date-parts":[[2018,1]]},"abstract":"<jats:p>As a complicated water treatment system project, an urban water supply plays a significant role in enhancing ecological civilization construction, promoting social\u2010economic sustainable development, and improving the living environment of humans. This paper has the goal of improving water treatment efficiency and reducing water treatment cost based on comparative studies by applying two types of distributed database query optimization methods, including the system for a distributed database (SDD\u20101) and all reduction algorithms. The approach involves the components of partial relations and deletes the database components that are unrelated to a query, using only attributes related to a query. Thereby, the realization process becomes simple, with a small amount of transmitted data. The results show that the validity and convenience of all reduction algorithms involve the whole query process. An algorithm is independent of the chart of static characteristics and can realize all reduction states without depending on analyzing the benefits from intermediate semijoin results, which will ultimately contribute to reductions in the transmission of useless data in the network and communication costs. Implementation of the query optimization strategy can improve water treatment efficiency, reduce water treatment cost, lower water treatment expense, and implement effective communication.<\/jats:p>","DOI":"10.1155\/2018\/8068914","type":"journal-article","created":{"date-parts":[[2018,10,2]],"date-time":"2018-10-02T23:32:06Z","timestamp":1538523126000},"update-policy":"https:\/\/doi.org\/10.1002\/crossmark_policy","source":"Crossref","is-referenced-by-count":1,"title":["Assessment of Urban Water Supply System Based on Query Optimization Strategy"],"prefix":"10.1155","volume":"2018","author":[{"ORCID":"https:\/\/orcid.org\/0000-0002-8615-2229","authenticated-orcid":false,"given":"Shibao","family":"Lu","sequence":"first","affiliation":[]},{"ORCID":"https:\/\/orcid.org\/0000-0002-8432-9561","authenticated-orcid":false,"given":"Yizi","family":"Shang","sequence":"additional","affiliation":[]},{"given":"Wei","family":"Li","sequence":"additional","affiliation":[]},{"ORCID":"https:\/\/orcid.org\/0000-0002-0059-4844","authenticated-orcid":false,"given":"Zhimin","family":"Wang","sequence":"additional","affiliation":[]}],"member":"311","published-online":{"date-parts":[[2018,10,2]]},"reference":[{"key":"e_1_2_9_1_2","doi-asserted-by":"publisher","DOI":"10.1016\/j.apenergy.2016.07.116"},{"key":"e_1_2_9_2_2","first-page":"27","article-title":"Xjoin: A reactively-scheduled pipelined join operator","volume":"23","author":"Urhan T.","year":"2000","journal-title":"IEEE Data Engineering Bulletin"},{"key":"e_1_2_9_3_2","doi-asserted-by":"publisher","DOI":"10.1007\/s00778-009-0155-0"},{"key":"e_1_2_9_4_2","doi-asserted-by":"publisher","DOI":"10.1016\/j.jcss.2006.10.013"},{"key":"e_1_2_9_5_2","doi-asserted-by":"publisher","DOI":"10.1007\/11896548_24"},{"key":"e_1_2_9_6_2","doi-asserted-by":"publisher","DOI":"10.1007\/s00778-006-0033-y"},{"key":"e_1_2_9_7_2","doi-asserted-by":"publisher","DOI":"10.1016\/j.ijhydene.2016.05.007"},{"key":"e_1_2_9_8_2","doi-asserted-by":"crossref","unstructured":"KoltsidasI.andViglasS. Flashing up the storage layer Proceedings of the VLDB Endowment August 2008 Auckland New Zealand 514\u2013525 https:\/\/doi.org\/10.14778\/1453856.1453913 2-s2.0-70449694274.","DOI":"10.14778\/1453856.1453913"},{"key":"e_1_2_9_9_2","doi-asserted-by":"publisher","DOI":"10.1016\/j.jclepro.2016.03.166"},{"key":"e_1_2_9_10_2","doi-asserted-by":"crossref","unstructured":"WuX.andReddyA. L. N. Managing storage space in a flash and disk hybrid storage system 2009 IEEE International Symposium on Modeling Analysis & Simulation of Computer and Telecommunication Systems September 2009 London UK 1\u20134 https:\/\/doi.org\/10.1109\/MASCOT.2009.5366764 2-s2.0-76349091119.","DOI":"10.1109\/MASCOT.2009.5366764"},{"key":"e_1_2_9_11_2","doi-asserted-by":"publisher","DOI":"10.1016\/j.jss.2013.01.069"},{"key":"e_1_2_9_12_2","doi-asserted-by":"crossref","unstructured":"KangW. H. LeeS. W. andMoonB. Flash-based extended cache for higher through put and faster recovery Proceedings of the VLDB Endowment July 2012 Istanbul Turkey 1615\u20131626 https:\/\/doi.org\/10.14778\/2350229.2350274 2-s2.0-84873163834.","DOI":"10.14778\/2350229.2350274"},{"key":"e_1_2_9_13_2","doi-asserted-by":"crossref","unstructured":"LeeS.-W.andMoonB. Design of flash-based DBMS: an in-page logging approach Proceedings of the 2007 ACM SIGMOD international conference on Management of data - SIGMOD \u201807 June 2007 Beijing China 55\u201366 https:\/\/doi.org\/10.1145\/1247480.1247488 2-s2.0-35448992171.","DOI":"10.1145\/1247480.1247488"},{"key":"e_1_2_9_14_2","doi-asserted-by":"crossref","unstructured":"KimY.-R. WhangK.-Y. andSongI.-Y. Page-differential logging: an efficient and independent approach for storing data into flash memory Proceedings of the 2010 international conference on Management of data - SIGMOD \u201810 June 2010 Indianapolis IN USA 363\u2013374 https:\/\/doi.org\/10.1145\/1807167.1807208 2-s2.0-77954753814.","DOI":"10.1145\/1807167.1807208"},{"key":"e_1_2_9_15_2","doi-asserted-by":"crossref","unstructured":"TsirogiannisD. HarizopoulosS. ShahM. A. WienerJ. L. andGraefeG. Query processing techniques for solid state drives Proceedings of the 35th SIGMOD international conference on Management of data - SIGMOD \u201809 June-July 2009 Providence RI USA 59\u201372 https:\/\/doi.org\/10.1145\/1559845.1559854 2-s2.0-70849091845.","DOI":"10.1145\/1559845.1559854"},{"key":"e_1_2_9_16_2","doi-asserted-by":"crossref","unstructured":"DoJ.andPatelJ. M. Join processing for flash SSDs: remembering past lessons Proceedings of the Fifth International Workshop on Data Management on New Hardware - DaMoN \u201809 June 2009 Providence RI USA 1\u20138 https:\/\/doi.org\/10.1145\/1565694.1565696 2-s2.0-70449672982.","DOI":"10.1145\/1565694.1565696"},{"key":"e_1_2_9_17_2","doi-asserted-by":"publisher","DOI":"10.1109\/TCE.2008.4637609"},{"key":"e_1_2_9_18_2","doi-asserted-by":"publisher","DOI":"10.1109\/tce.2009.5277999"},{"key":"e_1_2_9_19_2","doi-asserted-by":"crossref","unstructured":"TangX.andMengX. ACR: an adaptive cost-aware buffer replacement algorithm for flash storage devices 2010 Eleventh International Conference on Mobile Data Management May 2010 Kansas City MO USA 33\u201342 https:\/\/doi.org\/10.1109\/MDM.2010.34 2-s2.0-77955185701.","DOI":"10.1109\/MDM.2010.34"},{"key":"e_1_2_9_20_2","doi-asserted-by":"publisher","DOI":"10.1109\/TCE.2008.4637611"},{"key":"e_1_2_9_21_2","doi-asserted-by":"publisher","DOI":"10.1016\/j.habitatint.2014.01.008"},{"key":"e_1_2_9_22_2","doi-asserted-by":"crossref","unstructured":"OuY. H\u00e4rderT. andJinP. CFDC: a flash-aware replacement policy for database buffer management Proceedings of the Fifth International Workshop on Data Management on New Hardware - DaMoN \u201809 June 2009 Providence RI USA 15\u201320 https:\/\/doi.org\/10.1145\/1565694.1565698 2-s2.0-70449671106.","DOI":"10.1145\/1565694.1565698"},{"key":"e_1_2_9_23_2","unstructured":"Zeinalipour-YaztiD. LinS. KalogerakiV. GunopulosD. andNajjarW. A. MicroHash: an efficient index structure for flash-based sensor devices FAST \u201805 Paper December 2005 San Francisco CA USA."},{"key":"e_1_2_9_24_2","first-page":"17","volume-title":"Real-Time and Embedded Computing Systems and Applications. RTCSA 2003. Lecture Notes in Computer Science, vol 2968","author":"hsien Wu C.","year":"2003"},{"key":"e_1_2_9_25_2","doi-asserted-by":"publisher","DOI":"10.1016\/j.habitatint.2017.02.002"},{"key":"e_1_2_9_26_2","doi-asserted-by":"publisher","DOI":"10.1016\/j.habitatint.2015.03.017"},{"key":"e_1_2_9_27_2","doi-asserted-by":"publisher","DOI":"10.1016\/j.peva.2012.05.006"},{"key":"e_1_2_9_28_2","doi-asserted-by":"publisher","DOI":"10.1016\/j.is.2009.11.001"},{"key":"e_1_2_9_29_2","doi-asserted-by":"publisher","DOI":"10.1016\/j.jcss.2012.09.010"},{"key":"e_1_2_9_30_2","doi-asserted-by":"publisher","DOI":"10.1016\/j.jss.2014.02.056"},{"key":"e_1_2_9_31_2","doi-asserted-by":"publisher","DOI":"10.1016\/j.habitatint.2017.03.002"},{"key":"e_1_2_9_32_2","doi-asserted-by":"publisher","DOI":"10.1016\/j.jprocont.2012.12.001"},{"key":"e_1_2_9_33_2","doi-asserted-by":"publisher","DOI":"10.1016\/j.eswa.2014.04.042"},{"key":"e_1_2_9_34_2","doi-asserted-by":"publisher","DOI":"10.1016\/j.physletb.2014.07.056"},{"key":"e_1_2_9_35_2","doi-asserted-by":"publisher","DOI":"10.1016\/j.is.2012.12.001"},{"key":"e_1_2_9_36_2","doi-asserted-by":"publisher","DOI":"10.25300\/MISQ\/2014\/38.3.05"},{"key":"e_1_2_9_37_2","doi-asserted-by":"publisher","DOI":"10.25300\/MISQ\/2013\/37.4.11"},{"key":"e_1_2_9_38_2","doi-asserted-by":"publisher","DOI":"10.4018\/jdm.2013010103"},{"key":"e_1_2_9_39_2","doi-asserted-by":"publisher","DOI":"10.4018\/jdm.2013070102"}],"container-title":["Complexity"],"original-title":[],"language":"en","link":[{"URL":"http:\/\/downloads.hindawi.com\/journals\/complexity\/2018\/8068914.pdf","content-type":"application\/pdf","content-version":"vor","intended-application":"text-mining"},{"URL":"http:\/\/downloads.hindawi.com\/journals\/complexity\/2018\/8068914.xml","content-type":"application\/xml","content-version":"vor","intended-application":"text-mining"},{"URL":"https:\/\/onlinelibrary.wiley.com\/doi\/pdf\/10.1155\/2018\/8068914","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2024,8,8]],"date-time":"2024-08-08T22:47:43Z","timestamp":1723157263000},"score":1,"resource":{"primary":{"URL":"https:\/\/onlinelibrary.wiley.com\/doi\/10.1155\/2018\/8068914"}},"subtitle":[],"editor":[{"given":"Guido","family":"Caldarelli","sequence":"additional","affiliation":[]}],"short-title":[],"issued":{"date-parts":[[2018,1]]},"references-count":39,"journal-issue":{"issue":"1","published-print":{"date-parts":[[2018,1]]}},"alternative-id":["10.1155\/2018\/8068914"],"URL":"https:\/\/doi.org\/10.1155\/2018\/8068914","archive":["Portico"],"relation":{},"ISSN":["1076-2787","1099-0526"],"issn-type":[{"type":"print","value":"1076-2787"},{"type":"electronic","value":"1099-0526"}],"subject":[],"published":{"date-parts":[[2018,1]]},"assertion":[{"value":"2018-01-22","order":0,"name":"received","label":"Received","group":{"name":"publication_history","label":"Publication History"}},{"value":"2018-08-02","order":2,"name":"accepted","label":"Accepted","group":{"name":"publication_history","label":"Publication History"}},{"value":"2018-10-02","order":3,"name":"published","label":"Published","group":{"name":"publication_history","label":"Publication History"}}],"article-number":"8068914"}}