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
>