17,322 research outputs found

    PrivLava: Synthesizing Relational Data with Foreign Keys under Differential Privacy

    Full text link
    Answering database queries while preserving privacy is an important problem that has attracted considerable research attention in recent years. A canonical approach to this problem is to use synthetic data. That is, we replace the input database R with a synthetic database R* that preserves the characteristics of R, and use R* to answer queries. Existing solutions for relational data synthesis, however, either fail to provide strong privacy protection, or assume that R contains a single relation. In addition, it is challenging to extend the existing single-relation solutions to the case of multiple relations, because they are unable to model the complex correlations induced by the foreign keys. Therefore, multi-relational data synthesis with strong privacy guarantees is an open problem. In this paper, we address the above open problem by proposing PrivLava, the first solution for synthesizing relational data with foreign keys under differential privacy, a rigorous privacy framework widely adopted in both academia and industry. The key idea of PrivLava is to model the data distribution in R using graphical models, with latent variables included to capture the inter-relational correlations caused by foreign keys. We show that PrivLava supports arbitrary foreign key references that form a directed acyclic graph, and is able to tackle the common case when R contains a mixture of public and private relations. Extensive experiments on census data sets and the TPC-H benchmark demonstrate that PrivLava significantly outperforms its competitors in terms of the accuracy of aggregate queries processed on the synthetic data.Comment: This is an extended version of a SIGMOD 2023 pape

    Corporate Social Responsibility: the institutionalization of ESG

    Get PDF
    Understanding the impact of Corporate Social Responsibility (CSR) on firm performance as it relates to industries reliant on technological innovation is a complex and perpetually evolving challenge. To thoroughly investigate this topic, this dissertation will adopt an economics-based structure to address three primary hypotheses. This structure allows for each hypothesis to essentially be a standalone empirical paper, unified by an overall analysis of the nature of impact that ESG has on firm performance. The first hypothesis explores the evolution of CSR to the modern quantified iteration of ESG has led to the institutionalization and standardization of the CSR concept. The second hypothesis fills gaps in existing literature testing the relationship between firm performance and ESG by finding that the relationship is significantly positive in long-term, strategic metrics (ROA and ROIC) and that there is no correlation in short-term metrics (ROE and ROS). Finally, the third hypothesis states that if a firm has a long-term strategic ESG plan, as proxied by the publication of CSR reports, then it is more resilience to damage from controversies. This is supported by the finding that pro-ESG firms consistently fared better than their counterparts in both financial and ESG performance, even in the event of a controversy. However, firms with consistent reporting are also held to a higher standard than their nonreporting peers, suggesting a higher risk and higher reward dynamic. These findings support the theory of good management, in that long-term strategic planning is both immediately economically beneficial and serves as a means of risk management and social impact mitigation. Overall, this contributes to the literature by fillings gaps in the nature of impact that ESG has on firm performance, particularly from a management perspective

    People make Places

    Get PDF
    For centuries Glasgow, as a bucolic fishing village and ecclesiastical centre on the banks of the River Clyde, held little of strategic significance. When success and later threats came to the city, it was as a consequence of explosive growth during the industrial era that left a significant civic presence accompanied by social and environmental challenges. Wartime damage to the fabric of the city and the subsequent implementation of modernist planning left Glasgow with a series of existential threats to the lives and the health of its people that have taken time to understand and come to terms with. In a few remarkable decades of late 20th century regeneration, Glasgow began to be put back together. The trauma of the second half of the 20th century is fading but not yet a distant memory. Existential threats from the climate emergency can provoke the reaction “what, again?” However, the resilience built over the last 50 years has instilled a belief that a constructive, pro-active and creative approach to face this challenge along with the recognition that such action can be transformational for safeguarding and improving people’s lives and the quality of their places. A process described as a just transition that has become central to Glasgow’s approach. Of Scotland’s four big cities, three are surrounded by landscape and sea only Glasgow is surrounded by itself. Even with a small territory, Glasgow is still the largest of Scotland’s big cities and by some margin. When the wider metropolitan area is considered, Glasgow is – like Birmingham, Manchester and Liverpool – no mean city. People make Places begins with a review of the concept and complexities of place, discusses why these matter and reviews the growing body of evidence that place quality can deliver economic, social and environmental value. The following chapters focus on the history and evolution of modern Glasgow in four eras of 19th and early 20th century industrialisation, de- industrialisation and modernism in mid 20th century, late 20th century regeneration and a 21st century recovery towards transition and renaissance, and document the process, synthesis and the results of a major engagement programme and to explore systematic approaches to place and consensus building around the principal issues. The second half of the work reflects on a stocktaking of place in contemporary Glasgow, looking at the city through the lenses of an international, metropolitan and everyday city, concluding with a review of the places of Glasgow and what may be learned from them revealing some valuable insights presented in a series of Place Stories included. The concluding chapter sets out the findings of the investigation and analysis reviewing place goals, challenges and opportunities for Glasgow over the decades to 2030 and 2040 and ends with some recommendations about what Glasgow might do better to combine place thinking and climate awareness and setting out practical steps to mobilise Glasgow’s ‘place ecosystem’

    Chiral active fluids: Odd viscosity, active turbulence, and directed flows of hydrodynamic microrotors

    Get PDF
    While the number of publications on rotating active matter has rapidly increased in recent years, studies on purely hydrodynamically interacting rotors on the microscale are still rare, especially from the perspective of particle based hydrodynamic simulations. The work presented here targets to fill this gap. By means of high-performance computer simulations, performed in a highly parallelised fashion on graphics processing units, the dynamics of ensembles of up to 70,000 rotating colloids immersed in an explicit mesoscopic solvent consisting out of up to 30 million fluid particles, are investigated. Some of the results presented in this thesis have been worked out in collaboration with experimentalists, such that the theoretical considerations developed in this thesis are supported by experiments, and vice versa. The studied system, modelled in order to resemble the essential physics of the experimentally realisable system, consists out of rotating magnetic colloidal particles, i.e., (micro-)rotors, rotating in sync to an externally applied magnetic field, where the rotors solely interact via hydrodynamic and steric interactions. Overall, the agreement between simulations and experiments is very good, proving that hydrodynamic interactions play a key role in this and related systems. While already an isolated rotating colloid is driven out of equilibrium, only collections of two or more rotors have experimentally shown to be able to convert the rotational energy input into translational dynamics in an orbital rotating fashion. The rotating colloids inject circular flows into the fluid, such that detailed balance is broken, and it is not a priori known whether equilibrium properties of colloids can be extended to isolated rotating colloids. A joint theoretical and experimental analysis of isolated, pairs, and small groups of hydrodynamically interacting rotors is given in chapter 2. While the translational dynamics of isolated rotors effectively resemble the dynamics of non-rotating colloids, the orbital rotation of pairs of rotors can be described with leading order hydrodynamics and a two-dimensional analogy of Faxén’s law is derived. In chapter 3, a homogeneously distributed ensemble of rotors (bulk) as a realisation of a chiral active fluid is studied and it is explicitly shown computationally and experimentally that it carries odd viscosity. The mutual orbital translation of rotors and an increase of the effective solvent viscosity with rotor density lead to a non-monotonous behaviour of the average translational velocity. Meanwhile, the rotor suspension bears a finite osmotic compressibility resulting from the long-ranged nature of hydrody- namic interactions such that rotational and odd stresses are transmitted through the solvent also at small and intermediate rotor densities. Consequently, density inhomogeneities predicted for chiral active fluids with odd viscosity can be found and allow for an explicit measurement of odd viscosity in simulations and experiments. At intermediate densities, the collective dynamics shows the emergence of multi-scale vortices and chaotic motion which is identified as active turbulence with a self-similar power-law decay in the energy spectrum, showing that the injected energy on the rotor scale is transported to larger scales, similar to the inverse energy cascade of clas- sical two-dimensional turbulence. While either odd viscosity or active turbulence have been reported in chiral active matter previously, the system studied here shows that the emergence of both simultaneously is possible resulting from the osmotic compressibility and hydrodynamic mediation of odd and active stresses. The collective dynamics of colloids rotating out of phase, i.e., where a constant torque instead of a constant angular velocity is applied, is shown to be qualitatively very similar. However, at smaller densities, local density inhomogeneities imply position dependent angular velocities of the rotors resulting from inter-rotor friction. While the friction of a quasi-2D layer of active colloids with the substrate is often not easily modifiable in experiments, the incorporation of substrate friction into the simulation models typically implies a considerable increase in computational effort. In chapter 4, a very efficient way of incorporating the friction with a substrate into a two-dimensional multiparticle collision dynamics solvent is introduced, allowing for an explicit investigation of the influences of substrate on active dynamics. For the rotor fluid, it is explicitly shown that the influence of the substrate friction results in a cutoff of the hydrodynamic interaction length, such that the maximum size of the formed vortices is controlled by the substrate friction, also resulting in a cutoff in the energy spectrum, because energy is taken out of the system at the respective length. These findings are in agreement with the experiments. Since active particles in confinement are known to organise in states of collective dynamics, ensembles of rotationally actuated colloids are studied in circular confinement and in the presence of periodic obstacle lattices in chapters 5 and 6, respectively. The results show that the chaotic active turbulent transport of rotors in suspension can be enhanced and guided resulting from edge flows generated at the boundaries, as has recently been reported for a related chiral active system. The consequent collective rotor dynamics can be regarded as a superposition of active turbulent and imposed flows, leading to on average stationary flows. In contrast to the bulk dynamics, the imposed flows inject additional energy into the system on the long length scales, and the same scaling behaviour of the energy spectrum as in bulk is only obtained if the energy injection scales, due to the mutual generation of rotor translational dynamics throughout the system and the edge flows, are well separated. The combination of edge flow and entropic layering at the boundaries leads to oscillating hydrodynamic stresses and consequently to an oscillating vorticity profile. In the presence of odd viscosity, this consequently leads to non-trivial steady-state density modulations at the boundary, resulting from a balance of osmotic pressure and odd stresses. Relevant for the efficient dispersion and mixing of inert particles on the mesoscale by means of active turbulent mixing powered by rotors, a study of the dynamics of a binary mixture consisting out of rotors and passive particles is presented in chapter 7. Because the rotors are not self-propelled, but the translational dynamics is induced by the surrounding rotors, the passive particles, which do not inject further energy into the system, are transported according to the same mechanism as the rotors. The collective dynamics thus resembles the pure rotor bulk dynamics at the respective density of only rotors. However, since no odd stresses act between the passive particles, only mutual rotor interactions lead to odd stresses leading to the accumulation of rotors in the regions of positive vorticity. This density increase is associated with a pressure increase, which balances the odd stresses acting on the rotors. However, the passive particles are only subject to the accumulation induced pressure increase such that these particles are transported into the areas of low rotor concentration, i.e., the regions of negative vorticity. Under conditions of sustained vortex flow, this results in segregation of both particle types. Since local symmetry breaking can convert injected rotational into translational energy, microswimmers can be constructed out of rotor materials when a suitable breaking of symmetry is kept in the vicinity of a rotor. One hypothetical realisation, i.e., a coupled rotor pair consisting out of two rotors of opposite angular velocity and of fixed distance, termed a birotor, are studied in chapter 8. The birotor pumps the fluid into one direction and consequently translates into the opposite direction, and creates a flow field reminiscent of a source doublet, or sliplet flow field. Fixed in space the birotor might be an interesting realisation of a microfluidic pump. The trans- lational dynamics of a birotor can be mapped onto the active Brownian particle model for single swimmers. However, due to the hydrodynamic interactions among the rotors, the birotor ensemble dynamics do not show the emergence of stable motility induced clustering. The reason for this is the flow created by birotor in small aggregates which effectively pushes further arriving birotors away from small aggregates, which eventually are all dispersed by thermal fluctuations

    Exploring Potential Domains of Agroecological Transformation in the United States

    Get PDF
    There is now substantial evidence that agroecology constitutes a necessary pathway towards socially just and ecologically resilient agrifood systems. In the United States, however, agroecology remains relegated to the margins of research and policy spaces. This dissertation explores three potential domains of agroecological transformation in the US. Domains of transformation are sites of contestation in which agroecology interfaces with the industrial agrifood system; these material and conceptual spaces may point to important pathways for scaling agroecology. To explore this concept, I examine formal agroecology education (Chapter 1), extension services and statewide discourses around soil health (Chapter 2), and models of farmland access not based on private property (Chapter 3). While these constitute three distinct topics, I seek to demonstrate that they are linked by similar forces that enable and constrain the extent to which these domains can be sites of agroecological transformation. First, I use case study methodology to explore the evolution of an advanced undergraduate agroecology course at the University of Vermont. I examine how course content and pedagogy align with a transformative framing of agroecology as inherently transdisciplinary, participatory, action-oriented, and political. I find that student-centered pedagogies and experiential education on farms successfully promote transformative learning whereby students shift their understanding of agrifood systems and their role(s) within them. In my second chapter, I zoom out to consider soil health discourses amongst farmers and extension professionals in Vermont. Using co-created mental models and participatory analysis, I find that a singular notion of soil health based on biological, chemical, and physical properties fails to capture the diverse ways in which farmers and extension professionals understand soil health. I advocate for a principles-based approach to soil health that includes social factors and may provide a valuable heuristic for mobilizing knowledge towards agroecology transition pathways. My third chapter, conducted in collaboration with the national non-profit organization Agrarian Trust, considers equitable farmland access. Through semi-structured interviews with 13 farmers and growers across the US, I explore both farmer motivations for engaging with alternative land access models (ALAMs) and the potential role(s) these models may play within broader transformation processes. I argue that ALAMs constitute material and conceptual ‘third spaces’ within which the private property regime is challenged and new identities and language around land ownership can emerge; as such, ALAMs may facilitate a (re)imagining of land-based social-ecological relationships. I conclude the dissertation by identifying conceptual and practical linkages across the domains explored in Chapters 1-3. I pay particular attention to processes that challenge neoliberal logics, enact plural ways of knowing, and prefigure just futures. In considering these concepts, I apply an expansive notion of pedagogy to explore how processes of teaching and (un)learning can contribute to cultivating foundational capacities for transition processes

    A Decision Support System for Economic Viability and Environmental Impact Assessment of Vertical Farms

    Get PDF
    Vertical farming (VF) is the practice of growing crops or animals using the vertical dimension via multi-tier racks or vertically inclined surfaces. In this thesis, I focus on the emerging industry of plant-specific VF. Vertical plant farming (VPF) is a promising and relatively novel practice that can be conducted in buildings with environmental control and artificial lighting. However, the nascent sector has experienced challenges in economic viability, standardisation, and environmental sustainability. Practitioners and academics call for a comprehensive financial analysis of VPF, but efforts are stifled by a lack of valid and available data. A review of economic estimation and horticultural software identifies a need for a decision support system (DSS) that facilitates risk-empowered business planning for vertical farmers. This thesis proposes an open-source DSS framework to evaluate business sustainability through financial risk and environmental impact assessments. Data from the literature, alongside lessons learned from industry practitioners, would be centralised in the proposed DSS using imprecise data techniques. These techniques have been applied in engineering but are seldom used in financial forecasting. This could benefit complex sectors which only have scarce data to predict business viability. To begin the execution of the DSS framework, VPF practitioners were interviewed using a mixed-methods approach. Learnings from over 19 shuttered and operational VPF projects provide insights into the barriers inhibiting scalability and identifying risks to form a risk taxonomy. Labour was the most commonly reported top challenge. Therefore, research was conducted to explore lean principles to improve productivity. A probabilistic model representing a spectrum of variables and their associated uncertainty was built according to the DSS framework to evaluate the financial risk for VF projects. This enabled flexible computation without precise production or financial data to improve economic estimation accuracy. The model assessed two VPF cases (one in the UK and another in Japan), demonstrating the first risk and uncertainty quantification of VPF business models in the literature. The results highlighted measures to improve economic viability and the viability of the UK and Japan case. The environmental impact assessment model was developed, allowing VPF operators to evaluate their carbon footprint compared to traditional agriculture using life-cycle assessment. I explore strategies for net-zero carbon production through sensitivity analysis. Renewable energies, especially solar, geothermal, and tidal power, show promise for reducing the carbon emissions of indoor VPF. Results show that renewably-powered VPF can reduce carbon emissions compared to field-based agriculture when considering the land-use change. The drivers for DSS adoption have been researched, showing a pathway of compliance and design thinking to overcome the ‘problem of implementation’ and enable commercialisation. Further work is suggested to standardise VF equipment, collect benchmarking data, and characterise risks. This work will reduce risk and uncertainty and accelerate the sector’s emergence

    Gasificação direta de biomassa para produção de gás combustível

    Get PDF
    The excessive consumption of fossil fuels to satisfy the world necessities of energy and commodities led to the emission of large amounts of greenhouse gases in the last decades, contributing significantly to the greatest environmental threat of the 21st century: Climate Change. The answer to this man-made disaster is not simple and can only be made if distinct stakeholders and governments are brought to cooperate and work together. This is mandatory if we want to change our economy to one more sustainable and based in renewable materials, and whose energy is provided by the eternal nature energies (e.g., wind, solar). In this regard, biomass can have a main role as an adjustable and renewable feedstock that allows the replacement of fossil fuels in various applications, and the conversion by gasification allows the necessary flexibility for that purpose. In fact, fossil fuels are just biomass that underwent extreme pressures and heat for millions of years. Furthermore, biomass is a resource that, if not used or managed, increases wildfire risks. Consequently, we also have the obligation of valorizing and using this resource. In this work, it was obtained new scientific knowledge to support the development of direct (air) gasification of biomass in bubbling fluidized bed reactors to obtain a fuel gas with suitable properties to replace natural gas in industrial gas burners. This is the first step for the integration and development of gasification-based biorefineries, which will produce a diverse number of value-added products from biomass and compete with current petrochemical refineries in the future. In this regard, solutions for the improvement of the raw producer gas quality and process efficiency parameters were defined and analyzed. First, addition of superheated steam as primary measure allowed the increase of H2 concentration and H2/CO molar ratio in the producer gas without compromising the stability of the process. However, the measure mainly showed potential for the direct (air) gasification of high-density biomass (e.g., pellets), due to the necessity of having char accumulation in the reactor bottom bed for char-steam reforming reactions. Secondly, addition of refused derived fuel to the biomass feedstock led to enhanced gasification products, revealing itself as a highly promising strategy in terms of economic viability and environmental benefits of future gasification-based biorefineries, due to the high availability and low costs of wastes. Nevertheless, integrated techno economic and life cycle analyses must be performed to fully characterize the process. Thirdly, application of low-cost catalyst as primary measure revealed potential by allowing the improvement of the producer gas quality (e.g., H2 and CO concentration, lower heating value) and process efficiency parameters with distinct solid materials; particularly, the application of concrete, synthetic fayalite and wood pellets chars, showed promising results. Finally, the economic viability of the integration of direct (air) biomass gasification processes in the pulp and paper industry was also shown, despite still lacking interest to potential investors. In this context, the role of government policies and appropriate economic instruments are of major relevance to increase the implementation of these projects.O consumo excessivo de combustíveis fósseis para garantir as necessidades e interesses da sociedade conduziu à emissão de elevadas quantidades de gases com efeito de estufa nas últimas décadas, contribuindo significativamente para a maior ameaça ambiental do século XXI: Alterações Climáticas. A solução para este desastre de origem humana é de caráter complexo e só pode ser atingida através da cooperação de todos os governos e partes interessadas. Para isto, é obrigatória a criação de uma bioeconomia como base de um futuro mais sustentável, cujas necessidades energéticas e materiais sejam garantidas pelas eternas energias da natureza (e.g., vento, sol). Neste sentido, a biomassa pode ter um papel principal como uma matéria prima ajustável e renovável que permite a substituição de combustíveis fósseis num variado número de aplicações, e a sua conversão através da gasificação pode ser a chave para este propósito. Afinal, na prática, os combustíveis fósseis são apenas biomassa sujeita a elevada temperatura e pressão durante milhões de anos. Além do mais, a gestão eficaz da biomassa é fundamental para a redução dos riscos de incêndio florestal e, como tal, temos o dever de utilizar e valorizar este recurso. Neste trabalho, foi obtido novo conhecimento científico para suporte do desenvolvimento das tecnologias de gasificação direta (ar) de biomassa em leitos fluidizados borbulhantes para produção de gás combustível, com o objetivo da substituição de gás natural em queimadores industriais. Este é o primeiro passo para o desenvolvimento de biorrefinarias de gasificação, uma potencial futura indústria que irá providenciar um variado número de produtos de valor acrescentado através da biomassa e competir com a atual indústria petroquímica. Neste sentido, foram analisadas várias medidas para a melhoria da qualidade do gás produto bruto e dos parâmetros de eficiência do processo. Em primeiro, a adição de vapor sobreaquecido como medida primária permitiu o aumento da concentração de H2 e da razão molar H2/CO no gás produto sem comprometer a estabilidade do processo. No entanto, esta medida somente revelou potencial para a gasificação direta (ar) de biomassa de alta densidade (e.g., pellets) devido à necessidade da acumulação de carbonizados no leito do reator para a ocorrência de reações de reforma com vapor. Em segundo, a mistura de combustíveis derivados de resíduos e biomassa residual florestal permitiu a melhoria dos produtos de gasificação, constituindo desta forma uma estratégia bastante promissora a nível económico e ambiental, devido à elevada abundância e baixo custo dos resíduos urbanos. Contudo, devem ser efetuadas análises técnico-económicas e de ciclo de vida para a completa caraterização do processo. Em terceiro, a aplicação de catalisadores de baixo custo como medida primária demonstrou elevado potencial para a melhoria do gás produto (e.g., concentração de H2 e CO, poder calorífico inferior) e para o incremento dos parâmetros de eficiência do processo; em particular, a aplicação de betão, faialite sintética e carbonizados de pellets de madeira, demonstrou resultados promissores. Finalmente, foi demonstrada a viabilidade económica da integração do processo de gasificação direta (ar) de biomassa na indústria da pasta e papel, apesar dos parâmetros determinados não serem atrativos para potenciais investidores. Neste contexto, a intervenção dos governos e o desenvolvimento de instrumentos de apoio económico é de grande relevância para a implementação destes projetos.Este trabalho foi financiado pela The Navigator Company e por Fundos Nacionais através da Fundação para a Ciência e a Tecnologia (FCT).Programa Doutoral em Engenharia da Refinação, Petroquímica e Químic

    Life-Cycle Portfolio Choice with Stock Market Loss Framing: Explaining the Empirical Evidence

    Get PDF
    We develop a life-cycle model with optimal consumption, portfolio choice, and flexible work hours for households with loss-framing preferences giving them disutility if they experience losses from stock investments. Structural estimation using U.S. data shows that the model tracks the empirical age-pattern of stock market participants’ financial wealth, stock shares, and work hours remarkably well. Including stock market participation costs in the model allows us to also predict low stock market participations rates observed in the overall population. Allowing for heterogeneous agents further improves explanatory power and accounts for the observed discrepancy in wealth accumulation between stockholders and non-stockholders
    corecore