BI for linked open data [message #654984] |
Thu, 17 February 2011 21:23 |
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 |
|
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 |
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!
>
|
|
|
Powered by
FUDForum. Page generated in 0.03014 seconds