Re: [ontolog-forum] Is there something I missed?

[Александр Шкотин <alex.shkotin@xxxxxxxxx>]

Pat,

 

I am quite about humor but let me add my pence about situation with DBMS development you mentioned:

 

The Claremont Report on Database Research. Rakesh Agrawal, Anastasia Ailamaki, Philip A. Bernstein, Eric A. Brewer, Michael J. Carey, Surajit Chaudhuri, AnHai Doan, Daniela Florescu, Michael J. Franklin, Hector Garcia Molina, Johannes Gehrke, Le Gruenwald, Laura M. Haas, Alon Y. Halevy, Joseph M. Hellerstein, Yannis E. Ioannidis, Hank F. Korth, Donald Kossmann, Samuel Madden, Roger Magoulas, Beng Chin Ooi, Tim O'Reilly, Raghu Ramakrishnan, Sunita Sarawagi, Michael Stonebraker, Alexander S. Szalay, Gerhard Weikum, http://db.cs.berkeley.edu/claremont/claremontreport08.pdf.

 

it may be interesting.

 

more later,

 

Alex

2009/2/2 Pat Hayes <phayes@xxxxxxx>

On Feb 1, 2009, at 1:55 PM, John F. Sowa wrote:

> There are horror stories about large RDB systems in the US that
> were "mandated" to be translated to RDF with disastrous results.
>

Can you expand on this? I have not heard any such horror stories
related to RDF. It would be remarkable, as the RDF specs were only
published four years ago.

> The basic issue is that RDBs use indexes to find the relevant
> data in logarithmic time.  When the index cannot be used because
> it is necessary to process an entire column, the RDB pages the
> data in an orderly fashion.
>
> The problem with SPARQL is that RDF is not designed to support
> indexing.  The people who built so-called "triple stores" say
> that they're efficient because they run in RAM.

For some purposes, they outperform databases by being implemented via
hash tables, giving in effect constant rather than logarithmic access
time. But performance is influenced by the statistics of the triples
in use, to be sure.

>  But any DB that
> fits in RAM is a toy.

Not any longer. Laptops, and even some cell phones, now routinely use
64-bit address spaces, and a gigabyte of RAM costs around $50. The
complete Cyc ontology fits into a laptop. By next year I expect to
trade my disc drive for a flash disc, giving my Powerbook around 300
gig of close-to-RAM-speed memory without any moving parts.

>  If you take a non-toy DB and map it to
> RDF, it doesn't fit in RAM.  Furthermore, those triples aren't
> indexed, and they're not designed to be paged in an orderly
> fashion.  The result is endless disk thrashing.

Who says the triples aren't indexed? It all depends on how your
software is implemented. Bad software will thrash whether its using
RDB, RDF or anything else.

> If I had a pointy-haired boss who mandated the translation
> of an RDB to RDF, I would immediately send my resume to every
> reasonable employer

Me too, but only because bosses shouldn't be mandating engineering
decisions.

Pat

------------------------------------------------------------
IHMC                                     (850)434 8903 or (650)494 3973
40 South Alcaniz St.           (850)202 4416   office
Pensacola                            (850)202 4440   fax
FL 32502                              (850)291 0667   mobile
phayesAT-SIGNihmc.us       http://www.ihmc.us/users/phayes

_________________________________________________________________
Message Archives: http://ontolog.cim3.net/forum/ontolog-forum/
Config Subscr: http://ontolog.cim3.net/mailman/listinfo/ontolog-forum/
Unsubscribe: mailto:ontolog-forum-leave@xxxxxxxxxxxxxxxx
Shared Files: http://ontolog.cim3.net/file/
Community Wiki: http://ontolog.cim3.net/wiki/
To join: http://ontolog.cim3.net/cgi-bin/wiki.pl?WikiHomePage#nid1J
To Post: mailto:ontolog-forum@xxxxxxxxxxxxxxxx

_________________________________________________________________
Message Archives: http://ontolog.cim3.net/forum/ontolog-forum/  
Config Subscr: http://ontolog.cim3.net/mailman/listinfo/ontolog-forum/  
Unsubscribe: mailto:ontolog-forum-leave@xxxxxxxxxxxxxxxx
Shared Files: http://ontolog.cim3.net/file/
Community Wiki: http://ontolog.cim3.net/wiki/ 
To join: http://ontolog.cim3.net/cgi-bin/wiki.pl?WikiHomePage#nid1J
To Post: mailto:ontolog-forum@xxxxxxxxxxxxxxxx    (01)