Re: Open Source Database Questions

From: Niall Litchfield <niall.litchfield_at_gmail.com>
Date: Tue, 9 Jun 2009 23:08:01 +0100
Message-ID: <7765c8970906091508q56ecd6d6vce66821a0b46f058_at_mail.gmail.com>

so does that mean that jtpcc scores are non-audited in the 'smart people verify it and show how it's done, but we don't pay them' sense, or in the 'we published a score and called it jtpcc' sense. If it's repeatable and clear then in my book it counts. If it's the same class as "8 out of 10 cat owners say their cats prefer it" as the second approach is well, chalk one up to big business.

Niall

On Tue, Jun 9, 2009 at 4:14 PM, Matthew Zito <mzito_at_gridapp.com> wrote:

>
>
> The open-source database options at this point - postgres, mysql, ingres,
> etc. all have totally valid use cases in the enterprise today. Basically,
> Postgres is the most stable, as Dick says, similar concepts to Oracle, but
> not nearly as flexible as MySQL and with fewer features. MySQL offers a
> couple of different kinds of replication and clustering, different types of
> tablespaces, interchangeable storage engines, etc., but is comparably stable
> to Postgres. Ingres is a little more nichey, but definitely workable.
>
> The big differentiation is the amount of community knowledge - there's a
> lot of good information on tuning, configuring MySQL out in the wild, and if
> you wanted to purchase commercial support for MySQL there's a couple of
> different avenues. For PostgreSQL your best bet is to go get EnterpriseDB,
> which claims Oracle compatibility, though my understanding is that
> "compatibility" is relative.
>
> The reason that they're using JTPCC is that it costs money to have an
> "audited" TPC-C run, and non-trivial amounts. Consequently, a lot of
> open-source projects can't afford or don't want to try to compete with
> certified benchmarks, so instead they use non-audited reimplementations of
> the various benchmarks.
>
> Matt
>
> --
> Matthew Zito
> Chief Scientist
> GridApp Systems
> P: 646-452-4090
> mzito_at_gridapp.com
> http://www.gridapp.com
>
>
>
>
> -----Original Message-----
> From: oracle-l-bounce_at_freelists.org on behalf of Goulet, Richard
> Sent: Tue 6/9/2009 11:06 AM
> To: regdba_at_yahoo.com; Oracle-l
> Subject: RE: Open Source Database Questions
>
> Peter,
>
> From past experience (which had the same motives) take a serious
> look at PostGreSql(http://www.postgresql.org/). The latest versions
> have a lot in common with Oracle, though not everything, so it's a lot
> easier to transition from one to the other.
>
>
> Dick Goulet
> Senior Oracle DBA
> PAREXEL International
>
> -----Original Message-----
> From: oracle-l-bounce_at_freelists.org
> [mailto:oracle-l-bounce_at_freelists.org <oracle-l-bounce_at_freelists.org>] On
> Behalf Of Peter Barnett
> Sent: Tuesday, June 09, 2009 10:53 AM
> To: Oracle-l
> Subject: Open Source Database Questions
>
>
> Because of the current economy we are being encouraged to consider open
> source databases.
>
> One of the vendors has referenced a JTPCC benchmark which is an open
> source Java version of TPCC. Has anyone heard of JTPCC? Is it in any
> way truly comparable to TPCC? Keep in mind that I am skeptical of TPCC
> so this may be a loaded question.
>
> Is anyone currently using open source databases in production? Our
> typical database is approximately 200G but the range is 50G to 3.5T.
> One of our typical databases has approximately 200 distinct users at any
> one time. Any thoughts on a sweet spot for open source databases?
>
> This does all come down to money! I am pretty sure that we will have an
> open source database inhouse by year end. The major question is how
> best to use it.
>
> Thanks,
>
> Pete Barnett
> Database Technologies Lead
> Regence
>
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>
>

-- 
Niall Litchfield
Oracle DBA
http://www.orawin.info

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Jun 09 2009 - 17:08:01 CDT