Rob Ferber gave a talk about [OpenSales]*.
<Andy's paraphrase, with apologies to Rob>
Rob started off his talk by explaining that he has an opensales system that did 190,000,000 inserts in 24 hours.
(That's 2199 sql inserts per second for 24 hours). He went on to say that the OpenSales architecture was based on
perl, perl:dbi, and mysql. They don't use Database joins, stored proceedures, or transactions. (mySQL doesn't support
transactions) Yet they have developed a masterless (or a distrubited database , my words) database architecture,
that allows infinite expansion and redundancy. One node could fall into the ocean and the system would continue.
</end paraphrase>
Among the most notable quotes:
" OpenSales in a document management system before it is an ecommerce solution. "
" On a 47 node cluster we did 190,000,000 inserts in 24 hours. "
" In our database schema we have object tables and event tables."
Andy's note: There is so much more I want to say about this object/event data structure. I have implemented
philosophy at my job with outstanding results. This view of data management has turned my thinking 180 degrees.
During the break and after the meeting:
I don't know I had to leave.
Links:
[OpenSales.org]*
[mySQL]* (which BTW was released as GPL today)
[perl.org]*
[perl.com]*
[perl:dbi]*