scholarly journals Assessment of Urban Water Supply System Based on Query Optimization Strategy

Complexity ◽  
2018 ◽  
Vol 2018 ◽  
pp. 1-10 ◽  
Author(s):  
Shibao Lu ◽  
Yizi Shang ◽  
Wei Li ◽  
Zhimin Wang

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.

2020 ◽  
Vol 20 (3) ◽  
pp. 773-786 ◽  
Author(s):  
A. N. Angelakis ◽  
K. S. Voudouris ◽  
G. Tchobanoglous

Abstract Advanced, well organized, and operated urban water supply systems existed in Greece from the Bronze Age (ca. 3200–1100 BC). At the dawn of human history, surface water and groundwater, principally springs, were the most common water supply sources. As the population grew, periodic water shortages occurred. In Early Minoan times (ca. 3200–2100 BC), these water shortages led to the development of sophisticated hydraulic structures for importing water and for the harvesting and storage of rainwater. In addition, the water treatment technologies and water distribution techniques developed at that time served as the basis for the advanced technological progress in the development of the urban water supply systems in the centuries that followed. In this paper, an overview of the evolution of public water supplies and water treatment technologies in the Hellenic world through the centuries up to modern times is presented. Some of the most significant innovations in the provision of water, its treatment, and distribution are highlighted. The overview is followed by a discussion of the contemporary situation, emerging trends, and future challenges, and parallels are drawn between historical developments and the water supply problems faced today.


2021 ◽  
Vol 14 (6) ◽  
Author(s):  
Abdul Khaliq ◽  
Ahsan Maqbool ◽  
Husnain Tansar ◽  
Allah Bakhsh ◽  
Muhammad Saeed ◽  
...  

BMJ ◽  
1893 ◽  
Vol 2 (1707) ◽  
pp. 652-652
Author(s):  
G. J. Symons

2017 ◽  
Vol 37 (1) ◽  
pp. 58 ◽  
Author(s):  
Jure Margeta ◽  
Bojan Đurin

Paper describes and analyses new and innovative concept for possible integration of solar photovoltaic (PV) energy in urban water supply system (UWSS). Proposed system consists of PV generator and invertor, pump station and water reservoir. System is sized in such a manner that every his part is sized separately and after this integrated into a whole. This integration is desirable for several reasons, where the most important is the achievement of the objectives of sustainable living in urban areas i.e. achieving of sustainable urban water supply system. The biggest technological challenge associated with the use of solar, wind and other intermittent renewable energy sources RES is the realization of economically and environmentally friendly electric energy storage (EES). The paper elaborates the use of water reservoires in UWSS as EES. The proposed solution is still more expensive than the traditional and is economically acceptable today in the cases of isolated urban water system and special situations. Wider application will depend on the future trends of energy prices, construction costs of PV generators and needs for CO2 reduction by urban water infrastructure.


2002 ◽  
Vol 30 (9) ◽  
pp. 1517-1537 ◽  
Author(s):  
George R.G Clarke ◽  
Claude Menard ◽  
Ana Maria Zuluaga

Sign in / Sign up

Export Citation Format

Share Document