Schema architecture and their relationships to transaction processing in distributed database systems

We discuss the different types of schema architectures which could be supported by distributed database systems, making a clear distinction between logical, physical, and federated distribution. We elaborate on the additional mapping information required in architecture based on logical distribution in order to support retrieval as well as update operations. We illustrate the problems in schema integration and data integration in multidatabase systems and discuss their impact on query processing. Finally, we discuss different issues relevant to the cooperation (or noncooperation) of local database systems in a heterogeneous multidatabase system and their relationship to the schema architecture and transaction processing

Optimistic concurrency control revisited

Several years ago optimistic concurrency control gained much attention in the database community. However, two-phase locking was already well established, especially in the relational database market. Concerning traditional database systems most developers felt that pessimistic concurrency control might not be the best solution for concurrency control, but, a well-known and accepted one. With the work on new generation database systems, however, there has been a revival of optimistic concurrency control (at least a partial one). This paper will reconsider optimistic concurrency control. It will lay bare the shortcomings of the original approach and present some major improvements. Moreover, several techniques will be presented which especially support read transactions with the consequence that the number of backups can be decreased substantially. Finally, a general solution for the starvation problem is presented. The solution is perfectly consistent with the underlying optimistic approach

Modelo hidrogeoquímico del acuífero de las cañadas del Teide, Tenerife, Islas Canarias

En Tenerife, al igual que en el resto de las islas del Archipiélago Canario, los recursos hídricos superficiales son prácticamente inexistentes, siendo las aguas subterráneas las que aportan más del 90 % de los recursos hídricos que se consumen. En este contexto, el acuífero de Las Cañadas del Teide es, según el Plan Hidrológico Insular de Tenerife de 1996, la principal reserva de aguas subterráneas de la isla. Además, el acuífero de Las Cañadas posee una estrecha interacción con el sistema volcánico-hidrotermal del volcán Teide, que lo convierte en un potencial "trazador" de la actividad sismo-volcánica de la zonaEl objetivo general de esta tesis es la elaboración de un Modelo Hidrogeoquímico del acuífero de Las Cañadas que permita entender la evolución y comportamiento del acuífero, los procesos y condiciones que determinan las características físico-químicas e isotópicas finales de las aguas subterráneas y su interacción con el sistema volcánico-hidrotermal del Teide. Para la elaboración del Modelo Hidrogeoquímico ha sido necesario aplicar diversas metodologías geoquímicas, en las que cada una de las cuales no puede explicar por sí sola el funcionamiento físico y químico del sistema y producir un modelo conceptual, por lo que ha sido necesario la integración de todos los resultados para una mejor interpretación. Se ha elaborado un modelo físico del acuífero de Las Cañadas que también ha permitido realizar una primera aproximación de la geometría de la zona saturada, aportando nueva información al debate sobre el origen de la Caldera de Las Cañadas. Esta geometría se ha obtenido considerando los diferentes estudios geofísicos y geológicos realizados en años recientes en Las Cañadas, y la información litológica de las galerías, pozos y sondeos de la zona.Se ha realizado un estudio de las características químicas e isotópicas de la recarga a través del muestreo y análisis del agua de lluvia durante 18 meses a lo largo de un perfil N-S de Tenerife, que atraviesa el acuífero de Las Cañadas desde el nivel del mar hasta la Caldera de Las Cañadas, siendo los datos más completos, hasta la fecha, por su representatividad espacial y temporal. Debido a la complejidad del acuífero de Las Cañadas y de la cuantiosa información disponible desde el punto de vista hidroquímico, en la presente tesis se optó por no estudiar las variaciones temporales de las características hidrogeoquímicas del mismo, centrándose casi exclusivamente en describir la situación actual y usando principalmente los datos recopilados durante el desarrollo de la tesis en dos campañas de campo realizadas en los años 2004 y 2006. También se ha creado una Base de Datos Hidroquímica de Las Cañadas (BDHLC) que por primera vez integra y unifica gran parte de la información disponible, no sólo de las características físico-químicas e isotópicas de las aguas subterráneas del acuífero de Las Cañadas sino de todo Tenerife.El estudio de los procesos de interacción agua-roca-gases en el acuífero ha sido el centro de atención en gran parte de la presente tesis a través de estudios geotermométricos, diagramas de estabilidad mineral y de equilibrio químico y un modelado hidrogeoquímico. Los estudios de isótopos estables de oxígeno, hidrógeno y carbono han permitido determinar la principal área de recarga, así como el origen de las aguas subterráneas y del dióxido de carbono (CO2) disuelto en las mismas. Por último, también se ha cuantificado la aportación endógena y atmosférica de CO2 y de cloruros (Cl) a las aguas subterráneas, y se ha realizado un balance de masa de los mismos para el acuífero.En este trabajo también se ha llevado a cabo un estudio sobre el origen, características y distribución espacial de los gases disueltos en las aguas subterráneas del acuífero de Las Cañadas. Dicho estudio ha permitido comprobar que el control espacial de los mismos puede resultar una herramienta muy útil para la comprensión de la circulación del agua subterránea en dicho acuífero y para identificar las zonas de mayor conexión con el sistema volcánico-hidrotermal del Teide.Considerando los principales resultados de la geoquímica de las aguas subterráneas y de los gases disueltos en la presente tesis, el modelo propuesto del funcionamiento del sistema es que las aguas subterráneas de la zona de Las Cañadas están recibiendo un aporte directo de CO2 que disminuye el pH y favorece los procesos de interacción agua-roca, aumentando considerablemente su contenido salino, especialmente de Na y HCO3; las aguas antes de llegar a la zona de descarga del Valle de salida de Icod-La Guancha donde son captadas por las galerías y pozos, se alejan de las zonas con aporte de CO2, por lo que rápidamente aumentan su pH debido a procesos de desgasificación y/o consumo de CO2 en las reacciones de interacción agua-roca. A través de un balance de masas de cloruros en el acuífero se ha podido estimar en la Caldera de Las Cañadas un coeficiente de recarga medio de 0,75 (con una incertidumbre notable, aún no estimada), muy similar al valor de 0,69 obtenido por el Consejo Insular de Aguas de Tenerife en la misma región.Por último, esta tesis, además de presentar un modelo del funcionamiento del acuífero desde el punto de vista geoquímico, también provee de nuevos y cuantiosos datos para futuros estudios, relacionados directa e indirectamente con la hidrogeología (geotermia, vigilancia volcánica, etc.).Surficial water resources are absent in Tenerife Island as they are in the other islands of the Canary Islands. For that reason, groundwaters represent more than 90% of the resources for water consumption. Within this picture, the Hydrologic Plan for Tenerife Island of 1996 considers the aquifer within Las Cañadas del Teide caldera as the main reserve of groundwater for the island. In addition, Las Cañadas aquifer has a close interaction with the volcanic-hydrothermal system of Teide volcano, making possible to use its chemical properties as potential "tracers" of the seismic-volcanic activity of the region. The general objective of this dissertation is to elaborate a Hydrogeochemical Model of Las Cañadas aquifer that explains the evolution and behavior of the aquifer, its processes and the conditions that determine the final physical-chemical and isotopic characteristics of the groundwater, and its interaction with the volcanic-hydrothermal system of Teide volcano. For the elaboration of this model, it was necessary to apply diverse geochemical methodologies. Each one of these methodologies cannot explain by themselves how the physical and chemical work the system to produce a conceptual model. For that reason, an integration of all the studies and results was done in order to get a better interpretation.The construction of the physical model of Las Cañadas aquifer has allowed the identification of the geometry of the saturated zone, which gives an important contribution to the debate about the origin of the Las Cañadas Caldera. This geometry was obtained throughout the study of the different geophysical and geologic studies at Las Cañadas Caldera that have been carried out in recent years, and the lithologic information of galleries, wells, and boreholes in the region.The chemical and isotopic characteristics of the water recharge have been studied throughout the sampling and analysis of rainfall during 18 months and along a profile N-S of Tenerife Island. This profile intercepts Las Cañadas from sea level to the North, crosses Las Cañadas Caldera, and then to the southern shore. This data is the most complete to date, due to its spatial and temporal coverage.Due to the complexity of Las Cañadas aquifer and the amount of information available from the hydrochemical point of view, in this dissertation, the transient variations of the hydrochemical properties of the aquifer are not studied. Instead, this dissertation is centered almost exclusively in describing the present day situation or snapshot of the aquifer. To achieve that, we are using mainly the data collected during the development of this dissertation in two field seasons during 2004 and 2006. A Hydrochemical Data Base for Las Cañadas Aquifer has been created unifying a large proportion of the available information, not only about the physical-chemical and isotopic characteristics of the groundwaters of Las Cañadas but also of the entire Tenerife Island.A large proportion of this dissertation is centered in studying the water-rock-gas interaction processes using geothermometric studies, mineral stability diagrams, chemical equilibrium, and hydrogeochemical modeling. The stable isotopes of oxygen, hydrogen, and carbon have allowed the identification of the recharge areas as well as the origin of the groundwaters and the dissolved carbon dioxide (CO2). Finally, the endogenic and atmospheric contributions of CO2 and chloride (Cl) to groundwater have been quantified, and mass balance of these components for the aquifer have been made.The origin, characteristics, and spatial distribution of dissolved gases in the groundwaters of Las Cañadas aquifer have been assessed in this work. This study has shown that the spatial distribution of these gases can be an important tool for the understanding of the circulation of groundwater in this aquifer and for the identification of zones of greater connection with the volcanic-hydrothermal system of Teide volcano.Taking into account the results of the groundwater geochemistry and the dissolved gases, the proposed model for Las Cañadas aquifer is as follows: 1) the groundwaters within the zone of Las Cañadas is getting a direct input of CO2 that decreases the pH and favors the water-rock interactions, increasing its salinity, especially the concentration of Na and HCO3; 2) the waters leave the high CO2 recharge zone before they reach the discharge zone at the output valley of Icod-La Guancha (where the water is tapped by several galleries), increasing the pH fast due to degasification processes and the consumption of CO2 in water-rock reactions.Using the chloride mass balance for the aquifer, it has been possible to determine a mean recharge coefficient equal to 0.75 (with a non-determined large uncertainty), similar to the 0.69 value obtained by the Insular Water Council of Tenerife for the same region.Finally, in addition to present a model for the functioning of the aquifer from the geochemical point of view, this dissertation provides new and many data for future studies that are related directly of indirectly with hydrogeology (geothermics, volcanic monitoring, etc.)

The management of coral reef resource systems

Coral reefs, Resource management, Conferences

Information needs for rural development

In a special issue of Information development, v. 6, no. 1, Jan. 1990 (ARCHIV 45259)French version available in IDRC Digital Library: Besoins d'information pour le développement rura

Suporte a gerenciamento do trânsito baseado em computação na névoa para os sistemas de transporte inteligentes

Orientadores: Leandro Aparecido Villas, Daniel Ludovico GuidoniTese (doutorado) ¿ Universidade Estadual de Campinas, Instituto de ComputaçãoResumo: O trânsito nos grandes centros urbanos contribui com problemas que vão desde diminuição da qualidade de vida e segurança da população até o aumento de custos financeiros às pessoas, cidades e empresas. Um dos motivos para um maior tráfego de veículos é o vertiginoso crescimento populacional dos centros urbanos. Além disso, o fluxo de veículos é prejudicado por situações adversas recorrentes nas vias, como o aumento súbito do tráfego durante os horários de pico, gargalos nas infraestruturas de transporte, e acidentes de trânsito. Com o avanço das tecnologias de comunicação, processamento e sensoriamento, os Sistemas de Transporte Inteligentes (ITS) surgem como uma alternativa para mitigar esses problemas. A interoperabilidade dos ITS com novas tecnologias tais como as redes veiculares (VANETs) e computação em névoa, os tornam mais promissores e eficazes. As VANETs preveem que veículos possuam poder computacional e capacidade de comunicação sem fio com outros veículos e com as infraestruturas fixa de comunicação, assim, uma nova gama de serviços de segurança e entretenimento aos motoristas e passageiros podem ser desenvolvidas. Entretanto, estes tipos de serviços, em especial o de gerenciamento de trânsito, demandam uma análise contínua das condições de fluxo de veículos nas vias e um vasto recurso de rede e processamento, tornando o desenvolvimento de soluções para ITS mais complexo e de difícil escalabilidade. A computação em névoa é uma infraestrutura de computação descentralizada na qual dados, processamento, armazenamento e aplicações são distribuídos na borda da rede, assim, aumentando a escalabilidade do sistema. Na literatura, os sistemas de gerenciamento de tráfego não tratam de maneira adequada o problema de escalabilidade, implicando em problemas relacionados ao balanceamento de carga e tempo de resposta. Esta tese de doutorado propõe um sistema de gerenciamento de tráfego baseado no paradigma de computação em névoa, para detectar, classificar e controlar o congestionamento de tráfego. O sistema proposto apresenta um framework distribuído e escalável que reduz os problemas supracitados em relação ao estado da arte. Para tanto, utilizando da natureza distribuída da computação em névoa, a solução implementa um algoritmo de roteamento probabilístico que faz o balanceamento do tráfego e evita o problema de deslocamento de congestionamentos para outras regiões. Utilizando às características da computação em névoa, foi desenvolvida uma metodologia distribuída baseada em regiões que faz a coleta de dados e classificação das vias em relação às condições do trânsito compartilhadas pelos veículos. Finalmente, foi desenvolvido um conjunto de algoritmos/protocolos de comunicação que comparado com outras soluções da literatura, reduz a perda de pacotes e o número de mensagens transmitidas. O serviço proposto foi comparado extensivamente com outras soluções da literatura em relação às métricas de trânsito, onde o sistema proposto foi capaz de reduzir em até 70% o tempo parado e em até 49% o planning time index. Considerando as métricas de comunicação, o serviço proposto é capaz de reduzir em até 12% a colisão de pacotes alcançando uma cobertura de 98% do cenário. Os resultados mostram que o framework baseado em computação em névoa desenvolvido, melhora o fluxo de veículos de forma eficiente e escalávelAbstract: Traffic in large urban centers contributes to problems that range from decreasing the population¿s quality of life and security to increasing financial costs for people, cities, and companies. One of the reasons for increased vehicle traffic is the population growth in urban centers. Moreover, vehicle flow is hampered by recurring adverse situations on roads, such as the sudden increase in vehicle traffic during peak hours, bottlenecks in transportation infrastructure, and traffic accidents. Considering the advance of communication, processing, and sensing technologies, Intelligent Transport Systems (ITS) have emerged as an alternative to mitigate these problems. The interoperability of ITS with new technologies, such as vehicular networks (VANETs) and Fog computing, make them more promising and effective. VANETs ensure that vehicles have the computing power and wireless communication capabilities with other vehicles and with fixed communication infrastructures; therefore, a new range of security and entertainment services for drivers and passengers can be developed. However, these types of services, especially traffic management, demand a continuous analysis of vehicle flow conditions on roads and a huge network and processing resource, making the development of ITS solutions more complex and difficult to scale. Fog computing is a decentralized computing infrastructure in which data, processing, storage, and applications are distributed at the network edge, thereby increasing the system¿s scalability. In the literature, traffic management systems do not adequately address the scalability problem, resulting in load balancing and response time problems. This doctoral thesis proposes a traffic management system based on the Fog computing paradigm to detect, classify, and control traffic congestion. The proposed system presents a distributed and scalable framework that reduces the aforementioned problems in relation to state of the art. Therefore, using Fog computing¿s distributed nature, the solution implements a probabilistic routing algorithm that balances traffic and avoids the problem of congestion displacement to other regions. Using the characteristics of Fog computing, a distributed methodology was developed based on regions that collect data and classify the roads concerning the traffic conditions shared by the vehicles. Finally, a set of communication algorithms/protocols was developed which, compared with other literature solutions, reduces packet loss and the number of messages transmitted. The proposed service was compared extensively with other solutions in the literature regarding traffic metrics, where the proposed system was able to reduce downtime by up to 70% and up to 49% of the planning time index. Considering communication metrics, the proposed service can reduce packet collision by up to 12% reaching 98% coverage of the scenario. The results show that the framework based on Fog computing developed improves the vehicles¿ flow efficiently and in a scalable wayDoutoradoCiência da ComputaçãoDoutor em Ciência da Computaçã