Greenplum is a DW/BI database. So the workload is read-only :P
The only time writes happen is when you're loading the DW using your ETL tools; this is a bulk-load. So there are no transactional issues. I was referring to the amazing performance figures (e.g. showing a picture of a single Sun X4500 and saying you could load 1TB in 2 minutes which the /hardware/ is not capable of) -- they don't say that the performance figure was obtained on a bigger box. On 4/30/07, Tiger Quimpo <[EMAIL PROTECTED]> wrote:
On Fri, 2007-04-27 at 14:10 +0800, Orlando Andico wrote: > On 4/27/07, Tiger Quimpo <[EMAIL PROTECTED]> wrote: > > Interesting claims on that site though :-). > > Some of their claims don't make sense though.. Yeah, I thought so too. Or if they're true, I just don't understand them. I'm concerned about transaction semantics over that cluster of inexpensive servers running in parallel. I'm wondering how they partition the dataset into pieces that run on individual inexpensive servers and know how to partition a query into smaller queries that run on the right individual servers. Is the partitioning automatic or how much manual configuration is involved. I can believe that queries can be made to run very fast by cutting the data apart into small pieces and running queries in parallel. It's the data consistency among many inexpensive servers that i'm concerned about (transaction semantics, what happens when a box goes down [so the partition data that lives on that box isn't available anymore], etc.) tiger _________________________________________________ Philippine Linux Users' Group (PLUG) Mailing List [email protected] (#PLUG @ irc.free.net.ph) Read the Guidelines: http://linux.org.ph/lists Searchable Archives: http://archives.free.net.ph
-- Orlando Andico Senior Sales Consultant - Embedded GTMi Oracle (Philippines) Corporation The statements and opinions expressed here are my own and do not necessarily represent those of Oracle Corporation. _________________________________________________ Philippine Linux Users' Group (PLUG) Mailing List [email protected] (#PLUG @ irc.free.net.ph) Read the Guidelines: http://linux.org.ph/lists Searchable Archives: http://archives.free.net.ph
