Newsgroups: comp.databases.theory
From: "Jan Hidders" <hidd...@gmail.com>
Date: 6 Apr 2006 06:05:03 -0700
Local: Thurs, Apr 6 2006 3:05 pm
Subject: Re: Relational lattice completeness
Mikito Harakiri wrote: I'm not sure I said that, but there is a strongly related result about > Jan Hidders wrote: > > That is under the assumption you are asking whether you are complete > > for all models of that cardinality. But here we only have *one* model, > > namely the (infinite) lattice over all relations as defined by the two > > operations. So, since there is only one, all the models you are > > considering are isomorphic. > > Sorry for asking such hard questions. > AFIR you mentioned long time ago that there is some kind of the undecidability of equivalence of two relational algebra expressions. But I suspect that is not going to help you much. I already gave an almost formal description of the problem in sci.math so I'm not sure what more there is to explain. I will elaborate that a bit: We are talking about expressions as described by the following syntax E ::= R | (E /\ E) | (E \/ E) We define a database as a tuple D = (S, f) where S is called the schema Now we define two expressions e1 and e2 as query equivalent if (1) they I think it is also clear that a set of algebraic identities of the form We now call a set of algebraic identities *complete* if ifor all two If this holds then you can be sure that you have all the rewrite rules Does that clear some things up? -- Jan Hidders You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
| ||||||||||||||