Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » BIRT » BI for linked open data(Linked open data / RDF)
BI for linked open data [message #654984] Thu, 17 February 2011 21:23 Go to next message
Cory Casanave is currently offline Cory Casanave
Messages: 1
Registered: February 2011
Junior Member
I am exploring BI options such as Jaspersoft, Pentaho & Birt to front-end existing "linked open data" (LOD) repositories. My interest is in how appropriate these BI tools would be for LOD with the expectation of developing a direct interface from the BI tool to RDF repositories (not going through an ETL step). These repositories use "RDF" as their data abstraction, not SQL. RDF has its own schema and query languages. There is a substantial data resource becoming available for LOD (I.E. See www.data.gov).

There are a couple of features of RDF that are quite different from SQL (or even XML) that may or may not be a good match. These include:
• Support of subclassing (similar to an OODBMS)
• Support for an open set of properties for a class there are properties for primitive data as well as other instances
• The ability of an instance to have more than one class
• The use of a non-SQL query language

While there are other differences, these are the ones that would be hard to abstract away. So my question is: How well does the data model in Jaspersoft, Pentaho & Birt fit with this very open and general data model? And, how open is the data layer API such that a driver to RDF repositories could be implemented?

Also, has there been any other work to integrate RDF?
Based on the responses to this enquiry we will pick one of these packages to prototype the integration.
Thanks in advance!

[Updated on: Thu, 17 February 2011 21:24]

Report message to a moderator

Re: BI for linked open data [message #655190 is a reply to message #654984] Fri, 18 February 2011 15:10 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason Weathersby
Messages: 9167
Registered: July 2009
Senior Member

Cory,

I have not done any work with RDF, but BIRT has a very open data access
model. BIRT uses the DTP project's Open Data Access (ODA) model to
retrieve data and offers an extension point to plugin your own gui in to
the designer to retrieve data from virtually any data source. Generally
the data is retrieved as a set of primitive type columns and rows, but
BIRT also supports Java Objects as column values as well. If you decide
to look at BIRT for this, send me an email at jasonweathersby at
windstream dot net. I may be able to help prototype something for you.

Jason

On 2/17/2011 4:23 PM, Cory Casanave wrote:
> I am exploring BI options such as Jaspersoft, Pentaho & Birt to
> front-end existing "linked open data" (LOD) repositories. My interest is
> in how appropriate these BI tools would be for LOD with the expectation
> of developing a direct interface from the BI tool to RDF repositories
> (not going through an ETL step). These repositories use "RDF" as their
> data abstraction, not SQL. RDF has its own schema and query languages.
> There is a substantial bode of data becoming available for LOD (See
> www.data.gov).
>
> There are a couple of features of RDF that are quite different from SQL
> (or even XML) that may or may not be a good match. These include:
> • Support of subclassing (similar to an OODBMS)
> • Support for an open set of properties for a class there are properties
> for primitive data as well as other instances
> • The ability of an instance to have more than one class
> • The use of a non-SQL query language
>
> While there are other differences, these are the ones that would be hard
> to abstract away. So my question is: How well does the data model in
> Jaspersoft, Pentaho & Birt fit with this very open and general data
> model? And, how open is the data layer API such that a driver to RDF
> repositories could be implemented?
> Also, has there been any other work to integrate RDF?
> Based on the responses to this enquiry we will pick one of these
> packages to prototype the integration.
> Thanks in advance!
>
Re: BI for linked open data [message #655863 is a reply to message #654984] Tue, 22 February 2011 21:45 Go to previous message
Eclipse User
Originally posted by: remkus.wideopenwest.com

Cory,

I'm not sure how much you've dug into BIRT, but it does support XML as a
datasource. While RDF is not XML, it does seem to leverage XML as it's
vehicle, so it may not be a far stretch.

On 02/17/11 16:23, Cory Casanave wrote:
> I am exploring BI options such as Jaspersoft, Pentaho & Birt to
> front-end existing "linked open data" (LOD) repositories. My interest
> is in how appropriate these BI tools would be for LOD with the
> expectation of developing a direct interface from the BI tool to RDF
> repositories (not going through an ETL step). These repositories use
> "RDF" as their data abstraction, not SQL. RDF has its own schema and
> query languages. There is a substantial bode of data becoming available
> for LOD (See www.data.gov).
>
> There are a couple of features of RDF that are quite different from SQL
> (or even XML) that may or may not be a good match. These include:
> • Support of subclassing (similar to an OODBMS)
> • Support for an open set of properties for a class there are
> properties for primitive data as well as other instances
> • The ability of an instance to have more than one class
> • The use of a non-SQL query language
>
> While there are other differences, these are the ones that would be hard
> to abstract away. So my question is: How well does the data model in
> Jaspersoft, Pentaho & Birt fit with this very open and general data
> model? And, how open is the data layer API such that a driver to RDF
> repositories could be implemented?
> Also, has there been any other work to integrate RDF?
> Based on the responses to this enquiry we will pick one of these
> packages to prototype the integration.
> Thanks in advance!
>
Previous Topic:Custom Label on Pie Chart
Next Topic:Problems manually installing BIRT
Goto Forum:
  


Current Time: Fri Sep 19 07:57:16 GMT 2014

Powered by FUDForum. Page generated in 0.02387 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software