192,706 research outputs found
Middleware-based Database Replication: The Gaps between Theory and Practice
The need for high availability and performance in data management systems has
been fueling a long running interest in database replication from both academia
and industry. However, academic groups often attack replication problems in
isolation, overlooking the need for completeness in their solutions, while
commercial teams take a holistic approach that often misses opportunities for
fundamental innovation. This has created over time a gap between academic
research and industrial practice.
This paper aims to characterize the gap along three axes: performance,
availability, and administration. We build on our own experience developing and
deploying replication systems in commercial and academic settings, as well as
on a large body of prior related work. We sift through representative examples
from the last decade of open-source, academic, and commercial database
replication systems and combine this material with case studies from real
systems deployed at Fortune 500 customers. We propose two agendas, one for
academic research and one for industrial R&D, which we believe can bridge the
gap within 5-10 years. This way, we hope to both motivate and help researchers
in making the theory and practice of middleware-based database replication more
relevant to each other.Comment: 14 pages. Appears in Proc. ACM SIGMOD International Conference on
Management of Data, Vancouver, Canada, June 200
Recommended from our members
Improving DBMS performance through diverse redundancy
Database replication is widely used to improve both fault tolerance and DBMS performance. Non-diverse database replication has a significant limitation - it is effective against crash failures only. Diverse redundancy is an effective mechanism of tolerating a wider range of failures, including many non-crash failures. However it has not been adopted in practice because many see DBMS performance as the main concern. In this paper we show experimental evidence that diverse redundancy (diverse replication) can bring benefits in terms of DBMS performance, too. We report on experimental results with an optimistic architecture built with two diverse DBMSs under a load derived from TPC-C benchmark, which show that a diverse pair performs faster not only than non-diverse pairs but also than the individual copies of the DBMSs used. This result is important because it shows potential for DBMS performance better than anything achievable with the available off-the-shelf servers
Comparative genomic analysis of Acinetobacter spp. plasmids originating from clinical settings and environmental habitats
Bacteria belonging to the genus Acinetobacter have become of clinical importance over the last decade due to the development of a multi-resistant phenotype and their ability to survive under multiple environmental conditions. The development of these traits among Acinetobacter strains occurs frequently as a result of plasmid-mediated horizontal gene transfer. In this work, plasmids from nosocomial and environmental Acinetobacter spp. collections were separately sequenced and characterized. Assembly of the sequenced data resulted in 19 complete replicons in the nosocomial collection and 77 plasmid contigs in the environmental collection. Comparative genomic analysis showed that many of them had conserved backbones. Plasmid coding sequences corresponding to plasmid specific functions were bioinformatically and functionally analyzed. Replication initiation protein analysis revealed the predominance of the Rep_3 superfamily. The phylogenetic tree constructed from all Acinetobacter Rep_3 superfamily plasmids showed 16 intermingled clades originating from nosocomial and environmental habitats. Phylogenetic analysis of relaxase proteins revealed the presence of a new sub-clade named MOBQAci, composed exclusively of Acinetobacter relaxases. Functional analysis of proteins belonging to this group showed that they behaved differently when mobilized using helper plasmids belonging to different incompatibility groups.Fil: Salto, Ileana Paula. Consejo Nacional de Investigaciones CientĂficas y TĂ©cnicas. Centro CientĂfico TecnolĂłgico Conicet - La Plata. Instituto de BiotecnologĂa y BiologĂa Molecular. Universidad Nacional de La Plata. Facultad de Ciencias Exactas. Instituto de BiotecnologĂa y BiologĂa Molecular; ArgentinaFil: Torres Tejerizo, Gonzalo Arturo. Consejo Nacional de Investigaciones CientĂficas y TĂ©cnicas. Centro CientĂfico TecnolĂłgico Conicet - La Plata. Instituto de BiotecnologĂa y BiologĂa Molecular. Universidad Nacional de La Plata. Facultad de Ciencias Exactas. Instituto de BiotecnologĂa y BiologĂa Molecular; Argentina. Universitat Bielefeld. Center For Biotechnology; AlemaniaFil: Wibberg, Daniel. Universitat Bielefeld. Center For Biotechnology; AlemaniaFil: PĂĽhler, Alfred. Universitat Bielefeld. Center For Biotechnology; AlemaniaFil: SchlĂĽter, Andreas. Universitat Bielefeld. Center For Biotechnology; AlemaniaFil: Pistorio, Mariano. Consejo Nacional de Investigaciones CientĂficas y TĂ©cnicas. Centro CientĂfico TecnolĂłgico Conicet - La Plata. Instituto de BiotecnologĂa y BiologĂa Molecular. Universidad Nacional de La Plata. Facultad de Ciencias Exactas. Instituto de BiotecnologĂa y BiologĂa Molecular; Argentin
- …