Assessment of Urban Water Supply System Based on Query Optimization Strategy
Joint Authors
Shang, Yizi
Lu, Shibao
Li, Wei
Wang, Zhimin
Source
Issue
Vol. 2018, Issue 2018 (31 Dec. 2018), pp.1-10, 10 p.
Publisher
Hindawi Publishing Corporation
Publication Date
2018-10-02
Country of Publication
Egypt
No. of Pages
10
Main Subjects
Abstract EN
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.
American Psychological Association (APA)
Lu, Shibao& Shang, Yizi& Li, Wei& Wang, Zhimin. 2018. Assessment of Urban Water Supply System Based on Query Optimization Strategy. Complexity،Vol. 2018, no. 2018, pp.1-10.
https://search.emarefa.net/detail/BIM-1135992
Modern Language Association (MLA)
Lu, Shibao…[et al.]. Assessment of Urban Water Supply System Based on Query Optimization Strategy. Complexity No. 2018 (2018), pp.1-10.
https://search.emarefa.net/detail/BIM-1135992
American Medical Association (AMA)
Lu, Shibao& Shang, Yizi& Li, Wei& Wang, Zhimin. Assessment of Urban Water Supply System Based on Query Optimization Strategy. Complexity. 2018. Vol. 2018, no. 2018, pp.1-10.
https://search.emarefa.net/detail/BIM-1135992
Data Type
Journal Articles
Language
English
Notes
Includes bibliographical references
Record ID
BIM-1135992