W3C home > Mailing lists > Public > semantic-web@w3.org > November 2016

Re: Storing RDF in a relational database

From: Andrew Woods <awoods@duraspace.org>
Date: Wed, 2 Nov 2016 10:38:44 -0400
Message-ID: <CADz=0Uk2jsdLqdimGUnPEYpoWGwYL9fe_ZeZtr=RrLwEwZ7Vjg@mail.gmail.com>
To: Bernadette Hyland <bhyland@3roundstones.com>
Cc: "Li, Ai-jun" <Ai-jun.Li@morganstanley.com>, "semantic-web@w3.org" <semantic-web@w3.org>
Hello Bernadette,
Would you be willing to share the name of the triplestore implementation
you are using to store 99B triples?
Andrew Woods

On Wed, Nov 2, 2016 at 10:24 AM, Bernadette Hyland <bhyland@3roundstones.com
> wrote:

> Hi Ai-jun,
> Not sure that storing RDF triples in a relational database is novel, at
> least not in 2016. And 300M isn’t a big number in the world of graph
> databases. For example, we’re working with a linked data repository,
> PubChem with 99B triples, and linking it to a subset of environmental
> linked open data. Point is, graph databases are a useful tool for specific
> jobs, just like RDBMS’s are great for other jobs.
> More importantly, getting triples out in a speedy manner, using a standard
> query language, and building a nice UI, is the part many people in the
> linked data community have spent 10+ years getting right.
> Just my 2 cents.
> Cheers,
> Bernadette Hyland
> CEO, 3 Round Stones, Inc.
> On Nov 2, 2016, at 04:11, Li, Ai-jun <Ai-jun.Li@morganstanley.com> wrote:
> I came across a very old request for comments for storing RDF data in
> relational database (http://infolab.stanford.edu/~melnik/rdf/db.html). I
> was unable to find any newer discussion on this. We had implemented a very
> innovative way of storing linked graph data in Sybase many years ago and
> the system is still being used today. The system is storing the equivalent
> of over 300 million triples and is scalable for much more. We’d be happy to
> share our approach if this is something the community is still interested
> in (will need to get the firm’s approval, obviously).
> Thanks,
> Ai-jun Li
> *Morgan Stanley | Enterprise Infrastructure   *1 New York Plaza, 16th
> Floor | New York, NY  10004
> Phone: +1 646 536-0765
> Ai-jun.Li@morganstanley.com
> ------------------------------
> NOTICE: Morgan Stanley is not acting as a municipal advisor and the
> opinions or views contained herein are not intended to be, and do not
> constitute, advice within the meaning of Section 975 of the Dodd-Frank Wall
> Street Reform and Consumer Protection Act. If you have received this
> communication in error, please destroy all electronic and paper copies and
> notify the sender immediately. Mistransmission is not intended to waive
> confidentiality or privilege. Morgan Stanley reserves the right, to the
> extent permitted under applicable law, to monitor electronic
> communications. This message is subject to terms available at the following
> link: http://www.morganstanley.com/disclaimers  If you cannot access
> these links, please notify us by reply message and we will send the
> contents to you. By communicating with Morgan Stanley you consent to the
> foregoing and to the voice recording of conversations with personnel of
> Morgan Stanley.
Received on Wednesday, 2 November 2016 14:40:15 UTC

This archive was generated by hypermail 2.4.0 : Friday, 17 January 2020 19:50:18 UTC