1118243
Managing replicated files in partitioned distributed database systems
In this paper, we describe a consistency control algorithm for managing replicated files in the face of network partitioning due to node or communication link failures. It adopts a conservative approach in that mutual consistency among copies of a file is maintained by permitting files to be accessed only in a single partition. Our algorithm has the property that it permits dynamic switching between the “dynamic voting” algorithm and the “linearly ordered copies” algorithm. This aspect is not only appealing but results in greater file availability than in all previously published conservative algorithms.
45139817
Alternative methods for the reconstruction of trees from their traversals
It is well-known that given the inorder traversal of a binary tree's nodes, along with either one of its preorder or postorder traversals, the original binary tree can be reconstructed using a recursive algorithm. In this short note we provide a short, elegent, iterative solution to this classical problem.
24298643
Translation of entity-relationship diagrams into relational structures
Abstract An entity-relationship diagram (ERD) is considered to have two conceptual domains: its upper and lower conceptual domains. The semantic properties intrinsic in the upper conceptual domain were studied recently by Lien. In this paper, we discuss the properties inherent in the lower conceptual domain. We show that the latter contains a significant portion of the semantic information of an ERD and helps determine its data representation power. We develop the notions of fundamental functional dependencies (FDs) which can be readily recognized for the lower conceptual domain of an ERD, and regular ERDs which are ERDs such that all the FDs present among their attributes can be derived from their fundamental FDs. Then we give conditions under which a large number of ERDs are equivalent to their underlying relational structures.
17317346
Representative instances and γ-acyclic relational schemes
In this paper, we study under what conditions will a pairwise inconsistent relational database ≪R,r≫ have a universal/representative instance L. If R is γ-acyclic and r satisfies all existence constraints, then it is possible to construct a universal instance L, using unmarked nulls, whose total projections onto R yield exactly the relations in r. We show that L would actually be a representative instance under a set of functional dependencies if R satisfies the additional mild condition: for any functional dependency X → A where A is a single attribute, whenever XA is contained in two relation schemes R and R' of R, it follows that R ∩R' is a relation scheme of R, having X as one of its keys.
45839880
Universal and Representative Instances Using Unmarked Nulls
Representative instances are important since in addition to the universal relation view they permit updates in the individual relations; if these updates are locally valid, then they do not violate global consistency. In this paper, we first give conditions under which we can construct a universal instance I which uses only one type of nulls (unmarked nulls) and whose total projections onto the relation schemes yield exactly the database relations. Then, we give a necessary and sufficient condition under which this I is actually a representative instance. Our conditions are simple and easily maintained.
14430828
An Extension of "Representative Instances and &#947;-Acyclic Relational Schemes"
Let R be a γ-acyclic relational scheme, and let F be the set of functional dependencies (FD's) embodied in R. Given an existence constrained database r over R, it was shown in [1] that it is possible to connect tuples from different relations in r and construct a universal instance L, possibly containing null values δ, such that the total projection of L onto R yields exactly the set r. Moreover, conditions were given which guarantee that this L would satisfy the functional dependency with nulls (NFD) counterparts of FD's, in F. The purpose of this note is to generalize the latter result and show that under the same conditions, L actually satisfies NFD counterparts of FD's in the closure F+ of F.
6563671
Dynamic voting
In a voting-based algorithm, a replicated file can be updated in a partition if it contains a majority of copies. In this paper, we propose an extension of this scheme which permits a file to be updated in a partition provided it contains a majority of up-to-date copies. Our scheme not only preserves mutual consistency of the replicated file, but provides improvement in its availability as well. We develop a stochastic model which gives insight into the improvements afforded by our scheme over the voting scheme.
39298711
A Hybrid Replica Control Algorithm Combining Static and Dynamic Voting
A hybrid scheme that integrates the static voting protocol and dynamic voting with linearly ordered copies is proposed. A stochastic model is used to compare the file availability afforded by the proposed hybrid scheme with the availabilities of voting, dynamic voting, and dynamic voting with linearly ordered copies. The hybrid scheme has the most availability of these four algorithms for all reasonable repair/failure ratios tested. >
18664226
Dynamic voting algorithms for maintaining the consistency of a replicated database
There are several replica control algorithms for managing replicated files in the face of network partitioning due to site or communication link failures. Pessimistic algorithms ensure consistency at the price of reduced availability; they permit at most one (distinguished) partition to process updates at any given time. The best known pessimistic algorithm, voting, is a “static” algorithm, meaning that all potential distinguished partitions can be listed in advance. We present a dynamic extension of voting called dynamic voting. This algorithm permits updates in a partition provided it contains more than half of the up-to-date copies of the replicated file. We also present an extension of dynamic voting called dynamic voting with linearly ordered copies (abbreviated as dynamic-linear). These algorithms are dynamic because the order in which past distinguished partitions were created plays a role in the selection of the next distinguished partition. Our algorithms have all the virtues of ordinary voting, including its simplicity, and provide improved availability as well. We provide two stochastic models to support the latter claim. In the first (site) model, sites may fail but communication links are infallible; in the second (link) model the reverse is true. We prove that under the site model, dynamic-linear has greater availability than any static algorithm, including weighted voting, if there are four or more sites in the network. In the link model, we consider all biconnected five-site networks and a wide variety of failure and repair rates. In all cases considered, dynamic-linear had greater availability than any static algorithm.
14234886
Polyinstantiation integrity in multilevel relations
Polyinstantiation integrity (PI) as defined in the Sea View multilevel relational data model consists of a functional dependency component and a multivalued dependency component. It is shown that the latter component rules out many practically useful relations and is therefore unduly restrictive. This leads the authors to propose that PI be defined to consist only of the functional dependency component. For this revised definition of PI, they formulate and prove correct a lossless decomposition of multilevel relations into single-level ones with recovery based on the natural join operation.<<ETX>>
25460669
A theoretical formulation for degrees of isolation in databases
Abstract Although isolation is one of the desirable properties, most commercial database management systems do not provide complete isolation to transactions. They offer different degrees — 0, 1, 2, or 3 — of isolation, to transactions. By providing lower degrees of isolation, response time of a database system can be improved, although at the expense of consistency. Originally different degrees of isolation were defined in terms of lock-based protocols. This paper formulates these different degrees of isolation in terms of histories, as in the case of the usual serialization theory and proposes timestamp-based protocols for different degrees of isolation.