Thank you, Yes i have CSV file, and i'm not interested in users(the first column). but i need to group tags by content id as it's shown in the figure above. I want to inform you that my goal is to represent data of social network (i have dataset from Bibsonomy <http://www.kde.cs.uni-kassel.de/bibsonomy/dumps/>social network) by graph, then i will transverse this graph and apply some algorithms (such as Spread Activation function) over this graph to extract tags which belongs to determine domain. I think D2RQ is read-only RDF graphs thanks in advance
On Fri, Jan 23, 2015 at 10:13 PM, Claude Warren <[email protected]> wrote: > Seems like the user is all the same user. But If you have this in a CSV I > agree with Andy, look at jena-csv. > > http://jena.apache.org/documentation/csv/ > > On Fri, Jan 23, 2015 at 8:48 PM, Mohammed Alrokaimi < > [email protected]> > wrote: > > > I have the both two format (CSV and database table) > > See this example about what i wanna do please > > > > > > *user* > > > > *content_id* > > > > *tag* > > > > 0 > > > > 21 > > > > simulator > > > > 0 > > > > 21 > > > > simulation > > > > 0 > > > > 21 > > > > p2p > > > > 0 > > > > 22 > > > > phone > > > > 0 > > > > 22 > > > > t_easy > > > > 0 > > > > 22 > > > > manual > > > > 0 > > > > 22 > > > > c214 > > > > 0 > > > > 23 > > > > Simulation > > > > 0 > > > > 23 > > > > sync > > > > > > > > > > > > > > It is supposed to get this graph > > > > [image: Inline image 1] > > > > On Fri, Jan 23, 2015 at 8:22 PM, Claude Warren <[email protected]> wrote: > > > >> Your data did not come through in a table format. > >> > >> Is the table really in a database or is it a CSV file or just how is it > >> stored? > >> > >> In general, most conversions convert each column to a property and > create > >> a > >> URI for each row. Then you can link them together by whatever property > >> values are the same. > >> > >> Claude > >> > >> On Fri, Jan 23, 2015 at 8:15 PM, Mohammed Alrokaimi < > >> [email protected]> > >> wrote: > >> > >> > Hello dears, > >> > I please wonder if i can turn the database table below into a graph > >> using > >> > Jena and how ?? > >> > > >> > *user* > >> > > >> > *content_id* > >> > > >> > *tag* > >> > > >> > 0 > >> > > >> > 21 > >> > > >> > simulator > >> > > >> > 0 > >> > > >> > 21 > >> > > >> > simulation > >> > > >> > 0 > >> > > >> > 21 > >> > > >> > p2p > >> > > >> > 0 > >> > > >> > 22 > >> > > >> > phone > >> > > >> > 0 > >> > > >> > 22 > >> > > >> > t_easy > >> > > >> > 0 > >> > > >> > 22 > >> > > >> > manual > >> > > >> > 0 > >> > > >> > 22 > >> > > >> > c214 > >> > > >> > > >> > > >> > > >> > > >> > Where each content_id will be represented as node, tag will be > >> properties > >> > in nodes. where tow nodes will be connected if they have tags in > common. > >> > After that i wanna transverse this graph. > >> > Is Jena support that ? if yes how is that please ? > >> > > >> > >> > >> > >> -- > >> I like: Like Like - The likeliest place on the web > >> <http://like-like.xenei.com> > >> LinkedIn: http://www.linkedin.com/in/claudewarren > >> > > > > > > > -- > I like: Like Like - The likeliest place on the web > <http://like-like.xenei.com> > LinkedIn: http://www.linkedin.com/in/claudewarren >
