| Thread | Last Post | Replies |
|
| Following up on the good argument for XML thread, JSON is simpler and more space efficient, and seems to be catching on as a data interchange format! | 27 Nov 2009 01:35 GMT | 5 |
From: http://www.json.org/ JSON (JavaScript Object Notation) is a lightweight data-interchange format. It is easy for humans to read and write. It is easy for machines to parse and generate. It is based on a subset of the
|
| questionable history | 23 Nov 2009 03:27 GMT | 2 |
http://www.nou.edu.ng/noun/NOUN_OCL/pdf/pdf2/MBA%20758%20Database%20Management%2 0System.pdf "IBM started working on a prototype system loosely based on Codd's concepts as System R in the early 1970s — unfortunately, System R was conceived as a way of proving Codd's ideas ...
|
| looking for another one of Codd's papers | 22 Nov 2009 16:13 GMT | 3 |
One I can't seem to find is: E. F. CODD, "Recent Investigations in Relational Database Systems," IBM. Research Report RJ1385 Grateful if anybody can point to a free link or even send it privately
|
| two nasty schemata, union types and surrogate keys | 20 Nov 2009 22:52 GMT | 60 |
I recently bumped into two patterns in schema design which I found interesting, especially since they seem to imply a real use for disjoint union types/domains and/or surrogate keys in schema design. Since that sort of thing is bound to be controversial, I thought I
|
| ADR's Normalization question | 17 Nov 2009 17:40 GMT | 8 |
In his 'Writings' series, this time from the 2006 edition, chapter 13, 'More on Normalization', Date examines a suggestion by one his correspondents, known only as 'ADR'. This suggestion intrigued me, here's a longish quote for some context:
|
| Codd's Information Principle | 07 Nov 2009 13:28 GMT | 58 |
I can't remember where in his papers Codd stated the Information Principle but here's a version of a quote by Date: "The entire information content of a relational database is represented in one and only one way: namely, as attribute values within tuples within relations."
|
| relational lattices from boolean algebra perspective | 07 Nov 2009 02:21 GMT | 2 |
http://vadimtropashko.wordpress.com/relational-lattice/
|
| foreign key constraint versus referential integrity constraint | 01 Nov 2009 22:41 GMT | 95 |
I'm trying to understand the relationship between referential integrity and foreign key constraints. My example is suppose we have the ubiquitous supplier who sends the usual Orders with the usual info but also includes a Coupon that can be redeemed
|
| Adding history/versioning to a Nested Set model (is it possible?) | 01 Nov 2009 03:32 GMT | 6 |
I'm trying to implement a tree structure, hence I'd like the Nested Set model, but I need to be able to record the history of the tree structure *somehow* so that I can access previous versions. I've searched up and down online but all I can find are transactions
|