Concentrated rural settlement (CRS) was used for housing reconstruction in Sichuan Province, China, after the Wenchuan earthquake. Although CRS is claimed to provide enhanced infrastructure and public services, a sufficient number of farmers should be involved to reduce costs. Existing studies on CRS reconstruction overlook potential conflicts during reconstruction, which may hinder CRS reconstruction. This study explores the collective behaviors of rural victims and the local government in the process of CRS reconstruction. Evolutionary game analysis and agent-based simulation are applied to identify the evolutionary stable strategy for rural victims and the local government. Findings of this study can facilitate the local government in improving post-disaster recovery in terms of CRS. It can also provide an alternative method for investigating the behaviors of stakeholders during resettlement after disasters in other regions and countries.

Construction waste reduction (CWR) is an important approach to tackling the environmental problems resulting from increasing construction and demolition activities. Existing studies have explored various factors influencing construction stakeholders’ behavior or behavior intention regarding CWR mainly in terms of individual traits and environmental issues. With the advancement of information society, message framing has been explored as an emerging low-cost nudge approach for promoting pro-environment behavior or behavior intention in various research fields. Yet, few studies have investigated the influence of message framing on project managers’ behavior intentions regarding CWR. This study explores the relationship between project managers’ behavior intentions regarding CWR and message framing of CWR in terms of economic benefit vs. environmental benefit and small scale vs. large scale. A questionnaire experiment with 120 randomly selected project managers was conducted in Hangzhou. Two-way ANOVA and linear regression were performed to test the hypotheses. The results show that environmental benefit information has a higher impact on project managers’ behavior intentions regarding CWR than economic benefit information, while scale framing has an insignificant influence. The findings provide an alternative approach to increasing project managers’ awareness of CWR and further improve construction waste management.

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.