Distributed databases

Mòdul 3 del llibre Database Architecture. UOC, 20122022/202

Designing and Implementing a Distributed Database for a Small Multi-Outlet Business

Data is a fundamental and necessary element for businesses. During their operations they generate a certain amount of data that they need to capture, store, and later on retrieve when required. Databases provide the means to store and effectively retrieve data. Such a database can help a business improve its services, be more competitive, and ultimately increase its profits. In this paper, the system requirements of a distributed database are researched for a movie rental and sale store that has at least two outlets in different locations besides the main one. This project investigates the different stages of such a database, namely, the planning, analysis, decision, implementation and testing

The Erasmus insurance case and a related questionnaire for distributed database management systems

This is the third report concerning transaction management in the database environment. In the first report the role of the transaction manager in protecting the integrity of a database has been studied [van der Made-Potuijt 1989]. In the second report a model has been given for a transaction manager as a parallel decision process [van der Made-Potuijt & Groenewegen 1990], In this report a case, the Erasmus Insurance Case (EI-Case) will be presented that can be used to test transaction management in a centralized and distributed environment. It can also be used to describe transaction management in a distributed environment as parallel decision processes. The purpose of the questionnaire is to investigate the functionality of a particular distributed database management system. The answers of the questionnaire can be certified by tests on an implementation of a case. To this aim tests are added to the questions, referring to the implementation of the EI-case in the Distributed DBMS under investigation

Space station data system analysis/architecture study. Task 2: Options development, DR-5. Volume 2: Design options

The primary objective of Task 2 is the development of an information base that will support the conduct of trade studies and provide sufficient data to make key design/programmatic decisions. This includes: (1) the establishment of option categories that are most likely to influence Space Station Data System (SSDS) definition; (2) the identification of preferred options in each category; and (3) the characterization of these options with respect to performance attributes, constraints, cost and risk. This volume contains the options development for the design category. This category comprises alternative structures, configurations and techniques that can be used to develop designs that are responsive to the SSDS requirements. The specific areas discussed are software, including data base management and distributed operating systems; system architecture, including fault tolerance and system growth/automation/autonomy and system interfaces; time management; and system security/privacy. Also discussed are space communications and local area networking

Data issues at the Euro-Mediterranean Centre for Climate Change

Climate Change research is even more becoming a data intensive and oriented scientific activity. Petabytes of climate data, big collections of datasets are continuously produced, delivered, accessed, processed by scientists and researchers at multiple sites at an international level. This work presents the Euro-Mediterranean Centre for Climate Change (CMCC) initiative, discussing data and metadata issues and dealing with both architectural and infrastructural aspects concerning the adopted grid enabled solution. A complete overview of the grid services deployed at the Centre is presented as well as the client side support (CMCC data portal and monitoring dashboard)

Sequoia RAIDb-3: a new model for data distribution and replication using commodity systems

Unprecedented growth in the amount of data generated and used in the modern world has made distributed databases an important target for contemporary research. Today, advances in distributed databases embrace a wide range of concepts and ideas including, but not limited to, fragmentation, replication, distributed transactions and distributed concurrency control. One novel idea in this area was the introduction of the Redundant Array of Inexpensive Databases (RAIDb) initially proposed by the authors of Sequoia, a Java- based clustering middle-ware framework. On a conceptual level, RAIDb is similar to RAID arrays of disks; however, in contrast to traditional RAID, RAIDb utilizes an array of individual databases. The objective of RAIDb is to provide improved performance and fault tolerance relative to a single database while preserving the abstraction of a standard SQL DBMS. This thesis extends the functionality of Sequoia and proposes a distribution model based upon full horizontal fragmentation. We refer to this new design as RAIDb-3. We discuss details of the implementation and support its validity with an extensive suite of test cases