You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@jena.apache.org by Maria Jackson <ma...@gmail.com> on 2013/08/07 13:12:19 UTC
How to install Jena SDB
I downloaded Jena SDB from
http://mvnrepository.com/artifact/org.apache.jena/jena-sdb/1.3.6, but I am
not getting how to install it. Can someone please help
Re: How to install Jena SDB
Posted by Maria Jackson <ma...@gmail.com>.
Andy- I will be storing about a billion quads!
On Wed, Aug 7, 2013 at 10:06 PM, Andy Seaborne <an...@apache.org> wrote:
> Maria - how many triples will be stored?
>
> You could try comparing BSBM results - I /think/ SDB was tested at one
> time, not sure SDB and TDB were tested in the same version.
>
> You could also explain the support situation to your project lead.
>
> http://mail-archives.apache.**org/mod_mbox/jena-users/**
> 201306.mbox/%3C51B1A7FB.**4070601@apache.org%3E<http://mail-archives.apache.org/mod_mbox/jena-users/201306.mbox/%3C51B1A7FB.4070601@apache.org%3E>
>
> Andy
>
> (who has been involved in the development of both TDB and SDB)
>
>
> On 07/08/13 15:33, David Jordan wrote:
>
>> TDB IS much faster. I was even warned, in particular, that of the
>> relational DBs, that Postgres would be slower than similar alternatives,
>> like MySQL. I had done two benchmarks over the past year. One compared TDB
>> with SDB/MySQL, the other compared TDB with SDB/Postgres. But I never did a
>> comparison of MySQL and Postgres. Unfortunately, none of my results have
>> been published. The performance we got with the two SDB configurations were
>> deemed completely unusable due to the performance. Share this email with
>> your project head, making him aware of the issues. Much of your work will
>> be the same, regardless of which configuration you use. But there will
>> definitely be some time wasted for the configuration you choose not to use.
>>
>> -----Original Message-----
>> From: Maria Jackson [mailto:maria.jackson.phd@**gmail.com<ma...@gmail.com>
>> ]
>> Sent: Wednesday, August 07, 2013 10:25 AM
>> To: users@jena.apache.org
>> Subject: Re: How to install Jena SDB
>>
>> Thanks David for replying. I also think that TDB should be faster than
>> SDB.
>> But are there any publications for the same. Actually, I need to convey
>> this information to my project head and he would not believe me...until and
>> unless I show him these results published somewhere. (I hope you understand
>> :) and thanks again I think you have saved a lot of my effort which I
>> would have spent on SDB).
>>
>> Cheers,
>>
>>
>> On Wed, Aug 7, 2013 at 7:48 PM, David Jordan <Da...@sas.com>
>> wrote:
>>
>> Jena does support Postgres, you need to define an assembler file that
>>> establishes the connection info for it and you need to have the
>>> appropriate jars, etc. I'll warn you though, I did some benchmarks
>>> using Jena with Postgres and the performance was pretty bad, using TDB
>>> was orders of magnitude faster.
>>>
>>> -----Original Message-----
>>> From: Maria Jackson [mailto:maria.jackson.phd@**gmail.com<ma...@gmail.com>
>>> ]
>>> Sent: Wednesday, August 07, 2013 9:55 AM
>>> To: users@jena.apache.org
>>> Subject: Re: How to install Jena SDB
>>>
>>> A gentle reminder.
>>>
>>>
>>> On Wed, Aug 7, 2013 at 4:45 PM, Maria Jackson
>>> <ma...@gmail.com>**wrote:
>>>
>>> I want to run SDB with postgres
>>>>
>>>>
>>>> On Wed, Aug 7, 2013 at 4:42 PM, Maria Jackson
>>>> <maria.jackson.phd@gmail.com
>>>>
>>>>> wrote:
>>>>>
>>>>
>>>> I downloaded Jena SDB from
>>>>> http://mvnrepository.com/**artifact/org.apache.jena/jena-**sdb/1.3.6<http://mvnrepository.com/artifact/org.apache.jena/jena-sdb/1.3.6>
>>>>> ,
>>>>> but I am not getting how to install it. Can someone please help
>>>>>
>>>>>
>>>>
>>>>
>>>
>>>
>>
>
Re: How to install Jena SDB
Posted by Andy Seaborne <an...@apache.org>.
Maria - how many triples will be stored?
You could try comparing BSBM results - I /think/ SDB was tested at one
time, not sure SDB and TDB were tested in the same version.
You could also explain the support situation to your project lead.
http://mail-archives.apache.org/mod_mbox/jena-users/201306.mbox/%3C51B1A7FB.4070601@apache.org%3E
Andy
(who has been involved in the development of both TDB and SDB)
On 07/08/13 15:33, David Jordan wrote:
> TDB IS much faster. I was even warned, in particular, that of the relational DBs, that Postgres would be slower than similar alternatives, like MySQL. I had done two benchmarks over the past year. One compared TDB with SDB/MySQL, the other compared TDB with SDB/Postgres. But I never did a comparison of MySQL and Postgres. Unfortunately, none of my results have been published. The performance we got with the two SDB configurations were deemed completely unusable due to the performance. Share this email with your project head, making him aware of the issues. Much of your work will be the same, regardless of which configuration you use. But there will definitely be some time wasted for the configuration you choose not to use.
>
> -----Original Message-----
> From: Maria Jackson [mailto:maria.jackson.phd@gmail.com]
> Sent: Wednesday, August 07, 2013 10:25 AM
> To: users@jena.apache.org
> Subject: Re: How to install Jena SDB
>
> Thanks David for replying. I also think that TDB should be faster than SDB.
> But are there any publications for the same. Actually, I need to convey this information to my project head and he would not believe me...until and unless I show him these results published somewhere. (I hope you understand
> :) and thanks again I think you have saved a lot of my effort which I would have spent on SDB).
>
> Cheers,
>
>
> On Wed, Aug 7, 2013 at 7:48 PM, David Jordan <Da...@sas.com> wrote:
>
>> Jena does support Postgres, you need to define an assembler file that
>> establishes the connection info for it and you need to have the
>> appropriate jars, etc. I'll warn you though, I did some benchmarks
>> using Jena with Postgres and the performance was pretty bad, using TDB
>> was orders of magnitude faster.
>>
>> -----Original Message-----
>> From: Maria Jackson [mailto:maria.jackson.phd@gmail.com]
>> Sent: Wednesday, August 07, 2013 9:55 AM
>> To: users@jena.apache.org
>> Subject: Re: How to install Jena SDB
>>
>> A gentle reminder.
>>
>>
>> On Wed, Aug 7, 2013 at 4:45 PM, Maria Jackson
>> <ma...@gmail.com>wrote:
>>
>>> I want to run SDB with postgres
>>>
>>>
>>> On Wed, Aug 7, 2013 at 4:42 PM, Maria Jackson
>>> <maria.jackson.phd@gmail.com
>>>> wrote:
>>>
>>>> I downloaded Jena SDB from
>>>> http://mvnrepository.com/artifact/org.apache.jena/jena-sdb/1.3.6,
>>>> but I am not getting how to install it. Can someone please help
>>>>
>>>
>>>
>>
>>
>
RE: How to install Jena SDB
Posted by David Jordan <Da...@sas.com>.
I'll clarify that I was told by people doing Jena support that Postgres would be slower than other relational DBs running under SDB. I am just reporting what I was told by the Jena support team. I have no experience with Postgres in other contexts and I never did a direct MySQL vs. Postgres in an SDB environment.
-----Original Message-----
From: Ian Dickinson [mailto:ian@epimorphics.com]
Sent: Wednesday, August 07, 2013 5:46 PM
To: users@jena.apache.org
Subject: Re: How to install Jena SDB
On 07/08/13 15:33, David Jordan wrote:
> TDB IS much faster. I was even warned, in particular, that of the
> relational DBs, that Postgres would be slower than similar
> alternatives, like MySQL.
That hasn't been my experience. I don't use relational stores for RDF, but I do use them with my Rails projects. I find modern Postgres to be superior in most respects to MySQL, and as far as I can tell that's a fairly common view in the Ruby community. Of course, a lot of people will also say that NoSQL stores are even better, but that's another story!
Ian
Re: How to install Jena SDB
Posted by Ian Dickinson <ia...@epimorphics.com>.
On 07/08/13 15:33, David Jordan wrote:
> TDB IS much faster. I was even warned, in particular, that of the
> relational DBs, that Postgres would be slower than similar
> alternatives, like MySQL.
That hasn't been my experience. I don't use relational stores for RDF,
but I do use them with my Rails projects. I find modern Postgres to be
superior in most respects to MySQL, and as far as I can tell that's a
fairly common view in the Ruby community. Of course, a lot of people
will also say that NoSQL stores are even better, but that's another story!
Ian
RE: How to install Jena SDB
Posted by David Jordan <Da...@sas.com>.
TDB IS much faster. I was even warned, in particular, that of the relational DBs, that Postgres would be slower than similar alternatives, like MySQL. I had done two benchmarks over the past year. One compared TDB with SDB/MySQL, the other compared TDB with SDB/Postgres. But I never did a comparison of MySQL and Postgres. Unfortunately, none of my results have been published. The performance we got with the two SDB configurations were deemed completely unusable due to the performance. Share this email with your project head, making him aware of the issues. Much of your work will be the same, regardless of which configuration you use. But there will definitely be some time wasted for the configuration you choose not to use.
-----Original Message-----
From: Maria Jackson [mailto:maria.jackson.phd@gmail.com]
Sent: Wednesday, August 07, 2013 10:25 AM
To: users@jena.apache.org
Subject: Re: How to install Jena SDB
Thanks David for replying. I also think that TDB should be faster than SDB.
But are there any publications for the same. Actually, I need to convey this information to my project head and he would not believe me...until and unless I show him these results published somewhere. (I hope you understand
:) and thanks again I think you have saved a lot of my effort which I would have spent on SDB).
Cheers,
On Wed, Aug 7, 2013 at 7:48 PM, David Jordan <Da...@sas.com> wrote:
> Jena does support Postgres, you need to define an assembler file that
> establishes the connection info for it and you need to have the
> appropriate jars, etc. I'll warn you though, I did some benchmarks
> using Jena with Postgres and the performance was pretty bad, using TDB
> was orders of magnitude faster.
>
> -----Original Message-----
> From: Maria Jackson [mailto:maria.jackson.phd@gmail.com]
> Sent: Wednesday, August 07, 2013 9:55 AM
> To: users@jena.apache.org
> Subject: Re: How to install Jena SDB
>
> A gentle reminder.
>
>
> On Wed, Aug 7, 2013 at 4:45 PM, Maria Jackson
> <ma...@gmail.com>wrote:
>
> > I want to run SDB with postgres
> >
> >
> > On Wed, Aug 7, 2013 at 4:42 PM, Maria Jackson
> > <maria.jackson.phd@gmail.com
> > > wrote:
> >
> >> I downloaded Jena SDB from
> >> http://mvnrepository.com/artifact/org.apache.jena/jena-sdb/1.3.6,
> >> but I am not getting how to install it. Can someone please help
> >>
> >
> >
>
>
Re: How to install Jena SDB
Posted by Maria Jackson <ma...@gmail.com>.
Thanks David for replying. I also think that TDB should be faster than SDB.
But are there any publications for the same. Actually, I need to convey
this information to my project head and he would not believe me...until and
unless I show him these results published somewhere. (I hope you understand
:) and thanks again I think you have saved a lot of my effort which I
would have spent on SDB).
Cheers,
On Wed, Aug 7, 2013 at 7:48 PM, David Jordan <Da...@sas.com> wrote:
> Jena does support Postgres, you need to define an assembler file that
> establishes the connection info for it and you need to have the appropriate
> jars, etc. I'll warn you though, I did some benchmarks using Jena with
> Postgres and the performance was pretty bad, using TDB was orders of
> magnitude faster.
>
> -----Original Message-----
> From: Maria Jackson [mailto:maria.jackson.phd@gmail.com]
> Sent: Wednesday, August 07, 2013 9:55 AM
> To: users@jena.apache.org
> Subject: Re: How to install Jena SDB
>
> A gentle reminder.
>
>
> On Wed, Aug 7, 2013 at 4:45 PM, Maria Jackson
> <ma...@gmail.com>wrote:
>
> > I want to run SDB with postgres
> >
> >
> > On Wed, Aug 7, 2013 at 4:42 PM, Maria Jackson
> > <maria.jackson.phd@gmail.com
> > > wrote:
> >
> >> I downloaded Jena SDB from
> >> http://mvnrepository.com/artifact/org.apache.jena/jena-sdb/1.3.6, but
> >> I am not getting how to install it. Can someone please help
> >>
> >
> >
>
>
RE: How to install Jena SDB
Posted by David Jordan <Da...@sas.com>.
Jena does support Postgres, you need to define an assembler file that establishes the connection info for it and you need to have the appropriate jars, etc. I'll warn you though, I did some benchmarks using Jena with Postgres and the performance was pretty bad, using TDB was orders of magnitude faster.
-----Original Message-----
From: Maria Jackson [mailto:maria.jackson.phd@gmail.com]
Sent: Wednesday, August 07, 2013 9:55 AM
To: users@jena.apache.org
Subject: Re: How to install Jena SDB
A gentle reminder.
On Wed, Aug 7, 2013 at 4:45 PM, Maria Jackson
<ma...@gmail.com>wrote:
> I want to run SDB with postgres
>
>
> On Wed, Aug 7, 2013 at 4:42 PM, Maria Jackson
> <maria.jackson.phd@gmail.com
> > wrote:
>
>> I downloaded Jena SDB from
>> http://mvnrepository.com/artifact/org.apache.jena/jena-sdb/1.3.6, but
>> I am not getting how to install it. Can someone please help
>>
>
>
Re: How to install Jena SDB
Posted by Maria Jackson <ma...@gmail.com>.
A gentle reminder.
On Wed, Aug 7, 2013 at 4:45 PM, Maria Jackson
<ma...@gmail.com>wrote:
> I want to run SDB with postgres
>
>
> On Wed, Aug 7, 2013 at 4:42 PM, Maria Jackson <maria.jackson.phd@gmail.com
> > wrote:
>
>> I downloaded Jena SDB from
>> http://mvnrepository.com/artifact/org.apache.jena/jena-sdb/1.3.6, but I
>> am not getting how to install it. Can someone please help
>>
>
>
Re: How to install Jena SDB
Posted by Maria Jackson <ma...@gmail.com>.
I want to run SDB with postgres
On Wed, Aug 7, 2013 at 4:42 PM, Maria Jackson
<ma...@gmail.com>wrote:
> I downloaded Jena SDB from
> http://mvnrepository.com/artifact/org.apache.jena/jena-sdb/1.3.6, but I
> am not getting how to install it. Can someone please help
>
Re: How to install Jena SDB
Posted by Chris Dollin <ch...@epimorphics.com>.
On Wednesday, August 07, 2013 04:42:19 PM Maria Jackson wrote:
> I downloaded Jena SDB from
> http://mvnrepository.com/artifact/org.apache.jena/jena-sdb/1.3.6, but I am
> not getting how to install it. Can someone please help
What part of the installation instructions is giving you trouble?
Chris
--
RIP Diana Wynne Jones, 1934 - 2011.
Epimorphics Ltd, http://www.epimorphics.com
Registered address: Court Lodge, 105 High Street, Portishead, Bristol BS20 6PT
Epimorphics Ltd. is a limited company registered in England (number 7016688)