Implementing Performance Competitive Logical Recovery

New hardware platforms, e.g. cloud, multi-core, etc., have led to a reconsideration of database system architecture. Our Deuteronomy project separates transactional functionality from data management functionality, enabling a flexible response to exploiting new platforms. This separation requires, however, that recovery is described logically. In this paper, we extend current recovery methods to work in this logical setting. While this is straightforward in principle, performance is an issue. We show how ARIES style recovery optimizations can work for logical recovery where page information is not captured on the log. In side-by-side performance experiments using a common log, we compare logical recovery with a state-of-the art ARIES style recovery implementation and show that logical redo performance can be competitive.Comment: VLDB201

06121 Abstracts Collection -- Atomicity: A Unifying Concept in Computer Science

From 19.03.06 to 24.03.06, the Dagstuhl Seminar 06121 ``Atomicity: A Unifying Concept in Computer Science\u27\u27 was held in the International Conference and Research Center (IBFI), Schloss Dagstuhl. During the seminar, several participants presented their current research, and ongoing work and open problems were discussed. Abstracts of the presentations given during the seminar as well as abstracts of seminar results and ideas are put together in this paper. The first section describes the seminar topics and goals in general. Links to extended abstracts or full papers are provided, if available

Perspects in astrophysical databases

Astrophysics has become a domain extremely rich of scientific data. Data mining tools are needed for information extraction from such large datasets. This asks for an approach to data management emphasizing the efficiency and simplicity of data access; efficiency is obtained using multidimensional access methods and simplicity is achieved by properly handling metadata. Moreover, clustering and classification techniques on large datasets pose additional requirements in terms of computation and memory scalability and interpretability of results. In this study we review some possible solutions

Transactional failure recovery for a distributed key-value store

With the advent of cloud computing, many applications have embraced the ensuing paradigm shift towards modern distributed key-value data stores, like HBase, in order to benefit from the elastic scalability on offer. However, many applications still hesitate to make the leap from the traditional relational database model simply because they cannot compromise on the standard transactional guarantees of atomicity, isolation, and durability. To get the best of both worlds, one option is to integrate an independent transaction management component with a distributed key-value store. In this paper, we discuss the implications of this approach for durability. In particular, if the transaction manager provides durability (e.g., through logging), then we can relax durability constraints in the key-value store. However, if a component fails (e.g., a client or a key-value server), then we need a coordinated recovery procedure to ensure that commits are persisted correctly. In our research, we integrate an independent transaction manager with HBase. Our main contribution is a failure recovery middleware for the integrated system, which tracks the progress of each commit as it is flushed down by the client and persisted within HBase, so that we can recover reliably from failures. During recovery, commits that were interrupted by the failure are replayed from the transaction management log. Importantly, the recovery process does not interrupt transaction processing on the available servers. Using a benchmark, we evaluate the impact of component failure, and subsequent recovery, on application performance

The Atomic Manifesto: a Story in Four Quarks

This report summarizes the viewpoints and insights gathered in the Dagstuhl Seminar on Atomicity in System Design and Execution, which was attended by 32 people from four different scientific communities: database and transaction processing systems, fault tolerance and dependable systems, formal methods for system design and correctness reasoning, and hardware architecture and programming languages. Each community presents its position in interpreting the notion of atomicity and the existing state of the art, and each community identifies scientific challenges that should be addressed in future work. In addition, the report discusses common themes across communities and strategic research problems that require multiple communities to team up for a viable solution. The general theme of how to specify, implement, compose, and reason about extended and relaxed notions of atomicity is viewed as a key piece in coping with the pressing issue of building and maintaining highly dependable systems that comprise many components with complex interaction patterns

The "Ram Effect": A "Non-Classical" Mechanism for Inducing LH Surges in Sheep

During spring sheep do not normally ovulate but exposure to a ram can induce ovulation. In some ewes an LH surge is induced immediately after exposure to a ram thus raising questions about the control of this precocious LH surge. Our first aim was to determine the plasma concentrations of oestradiol (E2) E2 in anoestrous ewes before and after the "ram effect" in ewes that had a "precocious" LH surge (starting within 6 hours), a "normal" surge (between 6 and 28h) and "late» surge (not detected by 56h). In another experiment we tested if a small increase in circulating E2 could induce an LH surge in anoestrus ewes. The concentration of E2 significantly was not different at the time of ram introduction among ewes with the three types of LH surge. "Precocious" LH surges were not preceded by a large increase in E2 unlike "normal" surges and small elevations of circulating E2 alone were unable to induce LH surges. These results show that the "precocious" LH surge was not the result of E2 positive feedback. Our second aim was to test if noradrenaline (NA) is involved in the LH response to the "ram effect". Using double labelling for Fos and tyrosine hydroxylase (TH) we showed that exposure of anoestrous ewes to a ram induced a higher density of cells positive for both in the A1 nucleus and the Locus Coeruleus complex compared to unstimulated controls. Finally, the administration by retrodialysis into the preoptic area, of NA increased the proportion of ewes with an LH response to ram odor whereas treatment with the α1 antagonist Prazosin decreased the LH pulse frequency and amplitude induced by a sexually active ram. Collectively these results suggest that in anoestrous ewes NA is involved in ram-induced LH secretion as observed in other induced ovulators

XIV. On the preparation of crayons used for drawing, from the paste of reddle

n/