If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > General > Database Concepts & Design > Is the third generation database manifesto out of date

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 05-15-08, 09:09
james19 james19 is offline
Registered User
 
Join Date: May 2008
Posts: 3
Is the third generation database manifesto out of date

HI
do you think that the third generstion database manifesto is out of date now that it is around 15 years old? what additions would need to be made with the introduction of XML????????
Reply With Quote
  #2 (permalink)  
Old 05-15-08, 12:22
blindman blindman is offline
World Class Flame Warrior
 
Join Date: Jun 2003
Location: Ohio
Posts: 11,726
I think we would need a manifesto outlawing XML. That would bring it up to date.
__________________
If it's not practically useful, then it's practically useless.

blindman
www.chess.com: "sqlblindman"
Reply With Quote
  #3 (permalink)  
Old 05-15-08, 13:12
andrewst andrewst is offline
Moderator.
 
Join Date: Sep 2002
Location: UK
Posts: 5,171
Quote:
Originally Posted by james19
HI
do you think that the third generstion database manifesto is out of date now that it is around 15 years old? what additions would need to be made with the introduction of XML????????
Do you mean The Third Manifesto?

I agree with Blindman, but specifically the Third Manifesto says:
1) You can store what you like as values in database columns (including XML)
2) You must manage the data as rows in relational tables (not as XML)
__________________
Tony Andrews
http://tinyurl.com/tonyandrews
Reply With Quote
  #4 (permalink)  
Old 05-16-08, 09:47
james19 james19 is offline
Registered User
 
Join Date: May 2008
Posts: 3
HI
a huge thanks to both blindman and Andrew for thier replies. Andrew, apparently there exists a thrid generation database system manifesto and a thrid manifesto. Im still trying to figure out the difference between the two but appears that the thrid manifesto backs up relational systems and the thrid generation database manifesto backs an object relational system.

Some interesting comments about XML, do you think it will affect new versions of object relational or object databses???

The third generation database system manifesto also states

"For better or for worse, SQL is 'Intergalactic dataspeak'."

Im a litlle confused, what does that mean???

Thanks again for your replies
Reply With Quote
  #5 (permalink)  
Old 05-16-08, 10:33
pootle flump pootle flump is offline
King of Understatement
 
Join Date: Feb 2004
Location: One Flump in One Place
Posts: 14,905
Quote:
Originally Posted by james19
The third generation database system manifesto also states

"For better or for worse, SQL is 'Intergalactic dataspeak'."

Im a litlle confused, what does that mean???
Not a clue. What's the source? What's the context? What's your stab at it?
Reply With Quote
  #6 (permalink)  
Old 05-16-08, 10:42
andrewst andrewst is offline
Moderator.
 
Join Date: Sep 2002
Location: UK
Posts: 5,171
Quote:
Originally Posted by james19
The third generation database system manifesto also states

"For better or for worse, SQL is 'Intergalactic dataspeak'."

Im a litlle confused, what does that mean???
I think it means the SQL is universally used, ubiquitous. In other words, the authors expect SQL is here to stay whether they like it or not.

This is very different from the view of the authors of "The Third Manifesto", who consider SQL to be "fatally flawed" and that it should not (indeed cannot) be the language of a true relational DBMS.
__________________
Tony Andrews
http://tinyurl.com/tonyandrews
Reply With Quote
  #7 (permalink)  
Old 05-17-08, 22:23
sco08y sco08y is offline
Registered User
 
Join Date: Oct 2002
Location: Baghdad, Iraq
Posts: 697
Quote:
Originally Posted by andrewst
Do you mean The Third Manifesto?

I agree with Blindman, but specifically the Third Manifesto says:
1) You can store what you like as values in database columns (including XML)
2) You must manage the data as rows in relational tables (not as XML)
I would also point out that, according to the 3rd Manifesto, if you were to store XML fragments or other types of XML data, a TRDBMS would allow you to define an internal representation of that data such that you can manipulate it using relational operations.

The problem with XML is that it's a tree structure and such structures are difficult to handle because when they get complex you have to use graph theory to manipulate them and enforce integrity constraints. Graph theory works, but it's very hard to do it right and since the relational model can do it anyway, it's unnecessarily hard.
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On