Graphs with SQL & IBM DB2 - RDF Graph Store: Difference between revisions

From lotico
Jump to navigation Jump to search
 
(9 intermediate revisions by the same user not shown)
Line 1: Line 1:
[http://www.meetup.com/semweb-25/events/62433982/ Meetup May 31, 2012 - New York, NY]


Meetup URL: http://www.meetup.com/semweb-25/events/62433982/
Date: May 31, 2012
Loctation: New York, NY
<hr>
Short presentations
Short presentations


* [http://www.Edamam.com Edamam.com] - Eat better with a little help from semantics and linked data with Victor Penev.
* [http://www.Edamam.com Edamam.com] - Eat better with a little help from semantics and linked data with [[Victor Penev]].


* Semantic Web research intro with Lora Aroyo
* Semantic Web research intro with [[Lora Aroyo]]


<hr>


In this session we will take a look at RDBMS and SQL to better understand the evolution of commonplace database systems to enable them to deal with structured data, trees and hierarchies all the way to the new IBM DB2 RDF graph support in version 10.
In this session we will take a look at RDBMS and SQL to better understand the evolution of commonplace database systems to enable them to deal with structured data, trees and hierarchies all the way to the new IBM DB2 RDF graph support in version 10.


   
   
[http://photos4.meetupstatic.com/photos/event/9/7/0/6/highres_125318662.jpeg http://photos4.meetupstatic.com/photos/event/9/7/0/6/event_125318662.jpeg][http://photos3.meetupstatic.com/photos/event/9/6/f/c/highres_125318652.jpeg http://photos3.meetupstatic.com/photos/event/9/6/f/c/event_125318652.jpeg]
[http://photos1.meetupstatic.com/photos/event/9/6/e/8/highres_125318632.jpeg http://photos1.meetupstatic.com/photos/event/9/6/e/8/event_125318632.jpeg]
Full presentations
Full presentations


==Graphs, Trees and Hierarchies in SQL - Joe Celko ==
==Graphs, Trees and Hierarchies in SQL - [[Joe Celko]] ==
[http://photos4.meetupstatic.com/photos/event/9/6/d/4/highres_125318612.jpeg http://photos2.meetupstatic.com/photos/event/9/6/d/4/event_125318612.jpeg]
[http://photos4.meetupstatic.com/photos/event/9/6/d/4/highres_125318612.jpeg http://photos2.meetupstatic.com/photos/event/9/6/d/4/event_125318612.jpeg]
[http://files.meetup.com/274991/TREES.pdf Slides]
[http://files.meetup.com/274991/TREES.pdf Slides]


SQL is intended for structured data with strong data types modeled in sets. But it is possible to effectively model trees and hierarchies in SQL Joe will show you the programming techniques. see Trees and Hierachies in SQL 2nd edition.
SQL is intended for structured data with strong data types modeled in sets. But it is possible to effectively model trees and hierarchies in SQL Joe will show you the programming techniques. see Trees and Hierarchies in SQL 2nd edition.
 
==The case for storing RDF in a relational database - [[Kavitha Srinivas]] IBM T.J. Watson Research Center==
 
Video:
 
<youtube>wPzzS45evG8</youtube>


==The case for storing RDF in a relational database - Kavitha Srinivas IBM T.J. Watson Research Center==


[http://photos2.meetupstatic.com/photos/event/9/6/d/e/highres_125318622.jpeg http://photos2.meetupstatic.com/photos/event/9/6/d/e/event_125318622.jpeg]
[http://photos2.meetupstatic.com/photos/event/9/6/d/e/highres_125318622.jpeg http://photos2.meetupstatic.com/photos/event/9/6/d/e/event_125318622.jpeg]
Line 25: Line 42:
[http://files.meetup.com/274991/NYSemanticWebDB2RDF.pdf Slides]
[http://files.meetup.com/274991/NYSemanticWebDB2RDF.pdf Slides]


[https://vimeo.com/44237313 Video]




Line 32: Line 48:




session-level: intermediate
[[Category:Event]]
 
session-type: technology-standards-application

Latest revision as of 09:16, 23 July 2020


Meetup URL: http://www.meetup.com/semweb-25/events/62433982/

Date: May 31, 2012

Loctation: New York, NY


Short presentations


In this session we will take a look at RDBMS and SQL to better understand the evolution of commonplace database systems to enable them to deal with structured data, trees and hierarchies all the way to the new IBM DB2 RDF graph support in version 10.


event_125318662.jpegevent_125318652.jpeg event_125318632.jpeg

Full presentations

Graphs, Trees and Hierarchies in SQL - Joe Celko

event_125318612.jpeg Slides

SQL is intended for structured data with strong data types modeled in sets. But it is possible to effectively model trees and hierarchies in SQL Joe will show you the programming techniques. see Trees and Hierarchies in SQL 2nd edition.

The case for storing RDF in a relational database - Kavitha Srinivas IBM T.J. Watson Research Center

Video:


event_125318622.jpeg

Slides



A number of use cases within IBM have recently driven a requirement for an efficient and scalablepersistence mechanism for RDF data. IBM made the decision to build an RDF store on top of DB2 to exploit some of the existing strengths of the relational database -- such as concurrency, compression etc. In this talk, we will cover examples of use cases for RDF, and cover specific features of the use cases that made RDF the solution of choice. We will also describe key extensions we added to the DB2 RDF solution in order to accommodate these use cases.