You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@asterixdb.apache.org by Michael Carey <mj...@ics.uci.edu> on 2019/08/07 21:44:08 UTC

Re: what parallel DBMS is AsterixDB compared against?

You should be fine:  "The Greenplum project is released under the Apache 
2 license." (quoting from their github repo)  :-)

This sounds like an interesting undertaking - keep us posted and feel 
free to come here for support/Q's/tuning thoughts/etc.  You should be 
able to grab a copy of BigFUN and its data generator if using it is of 
interest; exactly where to find those will be listed in the BigFUN paper 
references.

Cheers,

Mike

On 8/7/19 2:35 PM, Karl Pietrzak wrote:
> Thanks, Michael!  I'm looking to compare AsterixDB against Greenplum 
> and post the results.  Anyone know if Greenplum has the "DeWitt clause"?
>
> On Wed, Aug 7, 2019 at 4:20 PM Michael Carey <mjcarey@ics.uci.edu 
> <ma...@ics.uci.edu>> wrote:
>
>     (Meant to reply to the list!)
>
>
>     -------- Forwarded Message --------
>     Subject: 	Re: what parallel DBMS is AsterixDB compared against?
>     Date: 	Wed, 7 Aug 2019 13:18:04 -0700
>     From: 	Michael Carey <mj...@ics.uci.edu>
>     <ma...@ics.uci.edu>
>     To: 	Karl Pietrzak <ka...@gmail.com> <ma...@gmail.com>
>
>
>     It's known in the literature as "System X" - other work, e.g., the
>     early MIT/Brown work in 2008-2009, used that same system in their
>     work on commercial databases vs. Hadoop and referred to it as
>     "System X" (so we did the same, name-wise).  Most for-pay database
>     vendors' license agreements have a clause known informally as the
>     "DeWitt clause" that prohibit publishing any performance results
>     from their systems, so the tradition in the DBMS academic
>     benchmarking world is to not name the systems.  This one was a
>     commercial shared-nothing parallel DBMS that is known to be a
>     solid performer (it wasn't just a strawman) and in the end the
>     graduate student who ran the numbers visited them on-site to get
>     some help in properly setting up the system.
>
>     If you go to http://asterix.ics.uci.edu//publications.html you can
>     find a copy of the BigFUN benchmark paper (which this was a
>     preliminary version of) as well as some other papers that might be
>     of interest.
>
>     Cheers,
>
>     Mike
>
>     On 8/7/19 10:52 AM, Karl Pietrzak wrote:
>>     Hi everyone!
>>
>>     Looking at the home page
>>     (https://asterixdb.apache.org/index.html), I'm wondering what
>>     parallel DBMS is AsterixDB being compared against?
>>
>>     Is there more information on this benchmark, too?
>>
>>     Thanks!
>>
>>     -- 
>>     Karl
>
>
>
> -- 
> Karl

Re: what parallel DBMS is AsterixDB compared against?

Posted by "Dylan T. Zuber" <dz...@uw.edu>.
Can you please not include me in this email thread?

Get Outlook for iOS<https://aka.ms/o0ukef>
________________________________
From: Karl Pietrzak <ka...@gmail.com>
Sent: Wednesday, August 7, 2019 7:03:59 PM
To: users@asterixdb.apache.org <us...@asterixdb.apache.org>
Cc: dev@asterixdb.apache.org <de...@asterixdb.apache.org>
Subject: Re: what parallel DBMS is AsterixDB compared against?

Yes, please, that would be great.  Ill throw it into Google Translate and look at the graphs.

On Wed, Aug 7, 2019, 6:42 PM Chen Li <ch...@gmail.com>> wrote:
About one year ago some students in China did an AsterixDB/Greenplum and wrote a report in Chinese.  If needed, I can contact them to get the report again, since the old one was not kept.

Chen

On Wed, Aug 7, 2019 at 2:44 PM Michael Carey <mj...@ics.uci.edu>> wrote:
You should be fine:  "The Greenplum project is released under the Apache
2 license." (quoting from their github repo)  :-)

This sounds like an interesting undertaking - keep us posted and feel
free to come here for support/Q's/tuning thoughts/etc.  You should be
able to grab a copy of BigFUN and its data generator if using it is of
interest; exactly where to find those will be listed in the BigFUN paper
references.

Cheers,

Mike

On 8/7/19 2:35 PM, Karl Pietrzak wrote:
> Thanks, Michael!  I'm looking to compare AsterixDB against Greenplum
> and post the results.  Anyone know if Greenplum has the "DeWitt clause"?
>
> On Wed, Aug 7, 2019 at 4:20 PM Michael Carey <mj...@ics.uci.edu>
> <ma...@ics.uci.edu>>> wrote:
>
>     (Meant to reply to the list!)
>
>
>     -------- Forwarded Message --------
>     Subject:  Re: what parallel DBMS is AsterixDB compared against?
>     Date:     Wed, 7 Aug 2019 13:18:04 -0700
>     From:     Michael Carey <mj...@ics.uci.edu>>
>     <ma...@ics.uci.edu>>
>     To:       Karl Pietrzak <ka...@gmail.com>> <ma...@gmail.com>>
>
>
>     It's known in the literature as "System X" - other work, e.g., the
>     early MIT/Brown work in 2008-2009, used that same system in their
>     work on commercial databases vs. Hadoop and referred to it as
>     "System X" (so we did the same, name-wise).  Most for-pay database
>     vendors' license agreements have a clause known informally as the
>     "DeWitt clause" that prohibit publishing any performance results
>     from their systems, so the tradition in the DBMS academic
>     benchmarking world is to not name the systems.  This one was a
>     commercial shared-nothing parallel DBMS that is known to be a
>     solid performer (it wasn't just a strawman) and in the end the
>     graduate student who ran the numbers visited them on-site to get
>     some help in properly setting up the system.
>
>     If you go to http://asterix.ics.uci.edu//publications.html you can
>     find a copy of the BigFUN benchmark paper (which this was a
>     preliminary version of) as well as some other papers that might be
>     of interest.
>
>     Cheers,
>
>     Mike
>
>     On 8/7/19 10:52 AM, Karl Pietrzak wrote:
>>     Hi everyone!
>>
>>     Looking at the home page
>>     (https://asterixdb.apache.org/index.html), I'm wondering what
>>     parallel DBMS is AsterixDB being compared against?
>>
>>     Is there more information on this benchmark, too?
>>
>>     Thanks!
>>
>>     --
>>     Karl
>
>
>
> --
> Karl

Re: what parallel DBMS is AsterixDB compared against?

Posted by Karl Pietrzak <ka...@gmail.com>.
Yes, please, that would be great.  Ill throw it into Google Translate and
look at the graphs.

On Wed, Aug 7, 2019, 6:42 PM Chen Li <ch...@gmail.com> wrote:

> About one year ago some students in China did an AsterixDB/Greenplum and
> wrote a report in Chinese.  If needed, I can contact them to get the report
> again, since the old one was not kept.
>
> Chen
>
> On Wed, Aug 7, 2019 at 2:44 PM Michael Carey <mj...@ics.uci.edu> wrote:
>
>> You should be fine:  "The Greenplum project is released under the Apache
>> 2 license." (quoting from their github repo)  :-)
>>
>> This sounds like an interesting undertaking - keep us posted and feel
>> free to come here for support/Q's/tuning thoughts/etc.  You should be
>> able to grab a copy of BigFUN and its data generator if using it is of
>> interest; exactly where to find those will be listed in the BigFUN paper
>> references.
>>
>> Cheers,
>>
>> Mike
>>
>> On 8/7/19 2:35 PM, Karl Pietrzak wrote:
>> > Thanks, Michael!  I'm looking to compare AsterixDB against Greenplum
>> > and post the results.  Anyone know if Greenplum has the "DeWitt clause"?
>> >
>> > On Wed, Aug 7, 2019 at 4:20 PM Michael Carey <mjcarey@ics.uci.edu
>> > <ma...@ics.uci.edu>> wrote:
>> >
>> >     (Meant to reply to the list!)
>> >
>> >
>> >     -------- Forwarded Message --------
>> >     Subject:  Re: what parallel DBMS is AsterixDB compared against?
>> >     Date:     Wed, 7 Aug 2019 13:18:04 -0700
>> >     From:     Michael Carey <mj...@ics.uci.edu>
>> >     <ma...@ics.uci.edu>
>> >     To:       Karl Pietrzak <ka...@gmail.com> <mailto:
>> kap4020@gmail.com>
>> >
>> >
>> >     It's known in the literature as "System X" - other work, e.g., the
>> >     early MIT/Brown work in 2008-2009, used that same system in their
>> >     work on commercial databases vs. Hadoop and referred to it as
>> >     "System X" (so we did the same, name-wise).  Most for-pay database
>> >     vendors' license agreements have a clause known informally as the
>> >     "DeWitt clause" that prohibit publishing any performance results
>> >     from their systems, so the tradition in the DBMS academic
>> >     benchmarking world is to not name the systems.  This one was a
>> >     commercial shared-nothing parallel DBMS that is known to be a
>> >     solid performer (it wasn't just a strawman) and in the end the
>> >     graduate student who ran the numbers visited them on-site to get
>> >     some help in properly setting up the system.
>> >
>> >     If you go to http://asterix.ics.uci.edu//publications.html you can
>> >     find a copy of the BigFUN benchmark paper (which this was a
>> >     preliminary version of) as well as some other papers that might be
>> >     of interest.
>> >
>> >     Cheers,
>> >
>> >     Mike
>> >
>> >     On 8/7/19 10:52 AM, Karl Pietrzak wrote:
>> >>     Hi everyone!
>> >>
>> >>     Looking at the home page
>> >>     (https://asterixdb.apache.org/index.html), I'm wondering what
>> >>     parallel DBMS is AsterixDB being compared against?
>> >>
>> >>     Is there more information on this benchmark, too?
>> >>
>> >>     Thanks!
>> >>
>> >>     --
>> >>     Karl
>> >
>> >
>> >
>> > --
>> > Karl
>>
>

Re: what parallel DBMS is AsterixDB compared against?

Posted by Chen Li <ch...@gmail.com>.
About one year ago some students in China did an AsterixDB/Greenplum and
wrote a report in Chinese.  If needed, I can contact them to get the report
again, since the old one was not kept.

Chen

On Wed, Aug 7, 2019 at 2:44 PM Michael Carey <mj...@ics.uci.edu> wrote:

> You should be fine:  "The Greenplum project is released under the Apache
> 2 license." (quoting from their github repo)  :-)
>
> This sounds like an interesting undertaking - keep us posted and feel
> free to come here for support/Q's/tuning thoughts/etc.  You should be
> able to grab a copy of BigFUN and its data generator if using it is of
> interest; exactly where to find those will be listed in the BigFUN paper
> references.
>
> Cheers,
>
> Mike
>
> On 8/7/19 2:35 PM, Karl Pietrzak wrote:
> > Thanks, Michael!  I'm looking to compare AsterixDB against Greenplum
> > and post the results.  Anyone know if Greenplum has the "DeWitt clause"?
> >
> > On Wed, Aug 7, 2019 at 4:20 PM Michael Carey <mjcarey@ics.uci.edu
> > <ma...@ics.uci.edu>> wrote:
> >
> >     (Meant to reply to the list!)
> >
> >
> >     -------- Forwarded Message --------
> >     Subject:  Re: what parallel DBMS is AsterixDB compared against?
> >     Date:     Wed, 7 Aug 2019 13:18:04 -0700
> >     From:     Michael Carey <mj...@ics.uci.edu>
> >     <ma...@ics.uci.edu>
> >     To:       Karl Pietrzak <ka...@gmail.com> <mailto:
> kap4020@gmail.com>
> >
> >
> >     It's known in the literature as "System X" - other work, e.g., the
> >     early MIT/Brown work in 2008-2009, used that same system in their
> >     work on commercial databases vs. Hadoop and referred to it as
> >     "System X" (so we did the same, name-wise).  Most for-pay database
> >     vendors' license agreements have a clause known informally as the
> >     "DeWitt clause" that prohibit publishing any performance results
> >     from their systems, so the tradition in the DBMS academic
> >     benchmarking world is to not name the systems.  This one was a
> >     commercial shared-nothing parallel DBMS that is known to be a
> >     solid performer (it wasn't just a strawman) and in the end the
> >     graduate student who ran the numbers visited them on-site to get
> >     some help in properly setting up the system.
> >
> >     If you go to http://asterix.ics.uci.edu//publications.html you can
> >     find a copy of the BigFUN benchmark paper (which this was a
> >     preliminary version of) as well as some other papers that might be
> >     of interest.
> >
> >     Cheers,
> >
> >     Mike
> >
> >     On 8/7/19 10:52 AM, Karl Pietrzak wrote:
> >>     Hi everyone!
> >>
> >>     Looking at the home page
> >>     (https://asterixdb.apache.org/index.html), I'm wondering what
> >>     parallel DBMS is AsterixDB being compared against?
> >>
> >>     Is there more information on this benchmark, too?
> >>
> >>     Thanks!
> >>
> >>     --
> >>     Karl
> >
> >
> >
> > --
> > Karl
>

Re: what parallel DBMS is AsterixDB compared against?

Posted by Chen Li <ch...@gmail.com>.
About one year ago some students in China did an AsterixDB/Greenplum and
wrote a report in Chinese.  If needed, I can contact them to get the report
again, since the old one was not kept.

Chen

On Wed, Aug 7, 2019 at 2:44 PM Michael Carey <mj...@ics.uci.edu> wrote:

> You should be fine:  "The Greenplum project is released under the Apache
> 2 license." (quoting from their github repo)  :-)
>
> This sounds like an interesting undertaking - keep us posted and feel
> free to come here for support/Q's/tuning thoughts/etc.  You should be
> able to grab a copy of BigFUN and its data generator if using it is of
> interest; exactly where to find those will be listed in the BigFUN paper
> references.
>
> Cheers,
>
> Mike
>
> On 8/7/19 2:35 PM, Karl Pietrzak wrote:
> > Thanks, Michael!  I'm looking to compare AsterixDB against Greenplum
> > and post the results.  Anyone know if Greenplum has the "DeWitt clause"?
> >
> > On Wed, Aug 7, 2019 at 4:20 PM Michael Carey <mjcarey@ics.uci.edu
> > <ma...@ics.uci.edu>> wrote:
> >
> >     (Meant to reply to the list!)
> >
> >
> >     -------- Forwarded Message --------
> >     Subject:  Re: what parallel DBMS is AsterixDB compared against?
> >     Date:     Wed, 7 Aug 2019 13:18:04 -0700
> >     From:     Michael Carey <mj...@ics.uci.edu>
> >     <ma...@ics.uci.edu>
> >     To:       Karl Pietrzak <ka...@gmail.com> <mailto:
> kap4020@gmail.com>
> >
> >
> >     It's known in the literature as "System X" - other work, e.g., the
> >     early MIT/Brown work in 2008-2009, used that same system in their
> >     work on commercial databases vs. Hadoop and referred to it as
> >     "System X" (so we did the same, name-wise).  Most for-pay database
> >     vendors' license agreements have a clause known informally as the
> >     "DeWitt clause" that prohibit publishing any performance results
> >     from their systems, so the tradition in the DBMS academic
> >     benchmarking world is to not name the systems.  This one was a
> >     commercial shared-nothing parallel DBMS that is known to be a
> >     solid performer (it wasn't just a strawman) and in the end the
> >     graduate student who ran the numbers visited them on-site to get
> >     some help in properly setting up the system.
> >
> >     If you go to http://asterix.ics.uci.edu//publications.html you can
> >     find a copy of the BigFUN benchmark paper (which this was a
> >     preliminary version of) as well as some other papers that might be
> >     of interest.
> >
> >     Cheers,
> >
> >     Mike
> >
> >     On 8/7/19 10:52 AM, Karl Pietrzak wrote:
> >>     Hi everyone!
> >>
> >>     Looking at the home page
> >>     (https://asterixdb.apache.org/index.html), I'm wondering what
> >>     parallel DBMS is AsterixDB being compared against?
> >>
> >>     Is there more information on this benchmark, too?
> >>
> >>     Thanks!
> >>
> >>     --
> >>     Karl
> >
> >
> >
> > --
> > Karl
>