Assessment of Urban Water Supply System Based on Query Optimization Strategy

Shibao Lu, Yizi Shang, Wei Li and Zhimin Wang

Complexity, 2018, vol. 2018, 1-10

Abstract:

As a complicated water treatment system project, an urban water supply plays a significant role in enhancing ecological civilization construction, promoting social-economic 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-1) 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.

Date: 2018
References: View complete reference list from CitEc
Citations: View citations in EconPapers (2)

Downloads: (external link)
http://downloads.hindawi.com/journals/8503/2018/8068914.pdf (application/pdf)
http://downloads.hindawi.com/journals/8503/2018/8068914.xml (text/xml)

Related works:
This item may be available elsewhere in EconPapers: Search for items with the same title.

Export reference: BibTeX RIS (EndNote, ProCite, RefMan) HTML/Text

Persistent link: https://EconPapers.repec.org/RePEc:hin:complx:8068914

DOI: 10.1155/2018/8068914

Access Statistics for this article

More articles in Complexity from Hindawi
Bibliographic data for series maintained by Mohamed Abdelhakeem ().