| Thread | Last Post | Replies |
|
| Proof that relational algebra is eqivalent to FOL | 18 Jul 2005 00:12 GMT | 2 |
I have seen reference (here and elsewhere) to the "common knowledge" that the relational algebra is equivalent in power to the first order logic. I would like to understand this proof, but I can't find any
|
| Object-Role Modeling? | 15 Jul 2005 15:38 GMT | 20 |
As a way to describe a problem domain with end users, why hasn't ORM taken off? From what I have read of it, it seems that it would be the place to start, then tweak on ER layer...
|
| source for RM research | 15 Jul 2005 09:01 GMT | 4 |
I recently started trying to understand the relational model. I took a DBMS class (undergrad) about five years ago...more recently I have been studying C. J. Date's 8th edition of 'Database Systems.' I would like to look at what recent work has been done in either
|
| cdt glossary 0.0.5 | 10 Jul 2005 09:46 GMT | 4 |
--------------- Glossary 0.0.5: "We have many future joys." july 10, 2005 The mythical man-month - Fred Brooks ---------------
|
| Memorable quotes | 08 Jul 2005 04:02 GMT | 3 |
<quote http://www.inconcept.com/jcm/may2005/David.html> This results in XML query languages having to be procedurally supplied with hierarchical semantic logic causing significant difficulty in specifying hierarchical queries that operate across multiple legs of
|
| Eliminating Nulls | 06 Jul 2005 18:05 GMT | 14 |
I know a number of database modelers try to avoid NULLs in their models because of their "unpredictability" and I believe there is merit in this approach. Is the ideal way to do this to move the optional attribute into it's own table? For example:
|
| Testing for the equivalence relation | 06 Jul 2005 14:25 GMT | 17 |
I'm seeking some help on a rather basic and trivial question. Is there a case where a relation's extension proves to be symmetric and transitive, but the relation is not an equivalence relation? In other words, can a relation be symmetric and transitive, but not be
|
| Sub-Entities | 05 Jul 2005 22:33 GMT | 8 |
When creating sub-entities should you put a column in the root table saying what kind of sub-entity it is, or is the presence of a row in the more specific table? For example: CREATE TABLE dbo.Clients
|
| What to call this operator? | 04 Jul 2005 07:02 GMT | 47 |
In chapter 4 or The Third Manifesto, D&D define a "new relational algebra." This algebra includes two operations named "<AND>" and "<OR>". (They use some weird triangle characters which I'm approximating with <>.)
|
| Simple Example, How To Model It In RM | 03 Jul 2005 16:27 GMT | 9 |
Could some post a RM script equivalent to the following xrdb script? // Create type person and make it an item of main directory. // Note: "inst" is short for instance. (CREATE type inst *person & dir item it)
|