General DB Topics - DB Theory

Thread preview

Thread	Last Post	Replies

Merry Christmas!	27 Dec 2006 15:08 GMT	9
Merry Christmas Mr. Lawrence! Merry Christmas Bedford Falls! Merry Christmas comp.databases.theory! Marshall
Datalog (DLV) question	26 Dec 2006 16:50 GMT	3
I am a software engineer trying to describe a system of interacting services and the messages they send, in an attempt to better understand and improve the messaging. I started by defining my system in SQL, but have problems due to the
Whatever happened to BS-12?	24 Dec 2006 21:04 GMT	11
And how in hell did System R (and the SQL nightmare) get so popular? Feh. http://www.mcjones.org/System_R/bs12.html
"OO" Equivalent of SQL Ad Hoc Program	22 Dec 2006 21:13 GMT	1
The following from thread titled "Databases As Objects". If someone (Bob Badour) can describe the underlying data/structure, I would like to give it an attempt with an network/OO type db. > Without even getting into a good data language but sticking with SQL,
Transitive Closure and Relational Division	21 Dec 2006 23:37 GMT	4
Some earlier exchange suggested a method of quering hierarchies via set containment query. This is a further development of this topic. For our purposes we'd focus on the following tree example: 1---2---4
Took forever	21 Dec 2006 12:35 GMT	4
Troels Arvin wrote: >On Wed, 05 Apr 2006 19:06:00 -0700, Vadim Tropashko wrote: >> http://www.rampant-books.com/book_2006_1_sql_coding_styles.htm >Interesting. Please post a message in this group when the book has been
SQL for intervals	18 Dec 2006 00:05 GMT	18
I just start learning sql. I wonder whether you can help me with this: I have a table W for a warehouse in which each item has a unique id and a timestamp t. Each record in the table is an id and the time stamp shows the day the
What Actually Causes Deadlock	17 Dec 2006 01:40 GMT	20
Over dinner and some excellent red wine, it occurred to me that the "folks at home" following some of the commentary on deadlock might not actually be fully up to speed on what causes deadlock, and might not be altogether following the ironic mode of speech
Generalised approach to storing address details	16 Dec 2006 18:02 GMT	119
This is really a database design question. I am not sure if this is the correct forum. If not, please can someone recommend a more appropriate one. I want to set up a generic way of entering names and address details.
SQL For Smarties 3rd Edition - ATTN Joe Celko	12 Dec 2006 02:06 GMT	41
This message is for Joe Celko - I thought this might be the best way to get in touch. I've just started reading 'SQL For Smarties - 3rd Edition', so far an excellent book, and noticed a few minor errors on page 73 in section
how to build a database from scratch	11 Dec 2006 12:28 GMT	64
search on google, you see a lot of info and books talking about how to build operating systems and compilers from scratch, but i have never seen any books talks about how to build a database from scratch. any one know this kind of book even exists?
set-valued values	08 Dec 2006 13:28 GMT	7
Another maybe crazy question - if instead of 'atomic values' (whatever that means) a relational engine (note for David, I've avoided using the term 'DBMS' !) expressed only values made up of sets, would the presence of the empty set in both true and false extensions create any ...
Where is the cdt glossary?	05 Dec 2006 14:45 GMT	1
The subject says it all.
Perhaps an idiotic question	03 Dec 2006 14:49 GMT	18
But it perplexes me even though I admit I have no good reason for asking: If I declare a relation (or more properly a relvar) R to have an attribute A where A's type is the type of R am I declaring a fallacy or something that is logically possible (ignoring whether it has any ...