Lotico dataset: Difference between revisions

From lotico
Jump to navigation Jump to search
No edit summary
 
(No difference)

Latest revision as of 09:57, 30 July 2017

General Issue

Date of analysis: May 30th, 2011

SPARQL endpoint: http://www.lotico.com:3030/lotico

Prefixes

prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#>
prefix rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
prefix loticoowl: <http://www.lotico.com/ontology/>
prefix owl: <http://www.w3.org/2002/07/owl#>
prefix foaf: <http://xmlns.com/foaf/0.1/>

What are in the data

Classes used

SELECT count(?x) ?type
WHERE{
 ?x a ?type.
}
GROUP BY ?type

Results (classes and their number of instances)

| 6     | <http://www.w3.org/2002/07/owl#Class>                 |
| 9864  | <http://www.lotico.com/ontology/Member>               |
| 5542  | <http://www.lotico.com/ontology/Topic>                |
| 11312 | <http://www.lotico.com/ontology/MembershipEvent>      |
| 46    | <http://www.lotico.com/ontology/Chapter>              |
| 9864  | <http://xmlns.com/foaf/0.1/Person>                    |
| 24    | <http://www.w3.org/1999/02/22-rdf-syntax-ns#Property> |
| 2     | <http://www.w3.org/2002/07/owl#Ontology>              |
| 45    | <http://xmlns.com/foaf/0.1/Document>                  |

OWL Classes

(There is no instance of rdfs:Class)

SELECT ?x
WHERE{
 ?x a owl:Class .
}LIMIT 100

Results

<http://www.lotico.com/ontology/Member>
<http://www.lotico.com/ontology/TwitterAccountEvent>
<http://www.lotico.com/ontology/MembershipEvent>
<http://www.lotico.com/ontology/Topic>
<http://www.lotico.com/ontology/Chapter>
<http://www.lotico.com/ontology/TwitterAccountURL>

Instance counting

SELECT count(?y) ?x
WHERE{
 ?x a owl:Class .
 ?y a ?x .
}
GROUP BY ?x

Results

| 9864  | <http://www.lotico.com/ontology/Member>          |
| 5542  | <http://www.lotico.com/ontology/Topic>           |
| 11312 | <http://www.lotico.com/ontology/MembershipEvent> |
| 46    | <http://www.lotico.com/ontology/Chapter>         |

Class Hierarchy

There is no class hierarchy

SELECT ?s ?o
WHERE{
 ?s rdfs:subClassOf ?o .
}
LIMIT 100

Properties used

44 properties

SELECT DISTINCT ?p
WHERE{
 ?x ?p ?o .
}
ORDER BY ASC(?p)
LIMIT 100

Results

| <http://purl.org/dc/elements/1.1/date>                           |
| <http://purl.org/dc/elements/1.1/title>                          |
| <http://www.lotico.com/ontology/ISO_3166-1-alpha-2>              |
| <http://www.lotico.com/ontology/ISO_3166-1-alpha-2_country_code> |
| <http://www.lotico.com/ontology/ISO_3166-1-alpha-2_country_name> |
| <http://www.lotico.com/ontology/city>                            |
| <http://www.lotico.com/ontology/countryCode>                     |
| <http://www.lotico.com/ontology/groupid>                         |
| <http://www.lotico.com/ontology/hasGroupPlan>                    |
| <http://www.lotico.com/ontology/hasMembershipEvent>              |
| <http://www.lotico.com/ontology/hasParticipant>                  |
| <http://www.lotico.com/ontology/hasTopicInterest>                |
| <http://www.lotico.com/ontology/hasTopicUser>                    |
| <http://www.lotico.com/ontology/hasTwitterFollower>              |
| <http://www.lotico.com/ontology/hasTwitterFollowerCount>         |
| <http://www.lotico.com/ontology/joined>                          |
| <http://www.lotico.com/ontology/joinedChapter>                   |
| <http://www.lotico.com/ontology/linkedin>                        |
| <http://www.lotico.com/ontology/location>                        |
| <http://www.lotico.com/ontology/mbox>                            |
| <http://www.lotico.com/ontology/memberCount>                     |
| <http://www.lotico.com/ontology/memberOf>                        |
| <http://www.lotico.com/ontology/memberid>                        |
| <http://www.lotico.com/ontology/state>                           |
| <http://www.lotico.com/ontology/twitter>                         |
| <http://www.lotico.com/ontology/visited>                         |
| <http://www.lotico.com/ontology/zip>                             |
| <http://www.w3.org/1999/02/22-rdf-syntax-ns#type>                |
| <http://www.w3.org/2000/01/rdf-schema#comment>                   |
| <http://www.w3.org/2000/01/rdf-schema#domain>                    |
| <http://www.w3.org/2000/01/rdf-schema#label>                     |
| <http://www.w3.org/2000/01/rdf-schema#range>                     |
| <http://www.w3.org/2000/01/rdf-schema#seeAlso>                   |
| <http://www.w3.org/2000/01/rdf-schema#subClassOf>                |
| <http://www.w3.org/2002/07/owl#imports>                          |
| <http://www.w3.org/2002/07/owl#inverseOf>                        |
| <http://www.w3.org/2002/07/owl#versionInfo>                      |
| <http://www.w3.org/2003/01/geo/wgs84_pos#lat>                    |
| <http://www.w3.org/2003/01/geo/wgs84_pos#long>                   |
| <http://xmlns.com/foaf/0.1/img>                                  |
| <http://xmlns.com/foaf/0.1/member>                               |
| <http://xmlns.com/foaf/0.1/name>                                 |
| <http://xmlns.com/foaf/0.1/page>                                 |
| <http://xmlns.com/foaf/0.1/primaryTopic>  

Property Axioms

Domains and ranges

SELECT ?s ?domain ?range
WHERE{
 ?s a rdf:Property .
 ?s rdfs:domain ?domain .
 ?s rdfs:range ?range .
}
ORDER BY ?p
LIMIT 100
| property                                                | domain                                   | range                                                |
=============================================================================================================================================================
| <http://www.lotico.com/ontology/hasTwitterAccountEvent> | <http://xmlns.com/foaf/0.1/Person>       | <http://www.lotico.com/ontology/TwitterAccountEvent> |
| <http://www.lotico.com/ontology/twitter>                | <http://xmlns.com/foaf/0.1/Person>       | <http://www.lotico.com/ontology/TwitterAccountURL>   |
| <http://www.lotico.com/ontology/location>               | <http://www.lotico.com/ontology/Chapter> | <http://www.w3.org/2000/01/rdf-schema#Resource>      |

Inverse Properties

SELECT *
WHERE{
 ?p1 owl:inverseOf ?p2 .
}
ORDER BY ?p1
LIMIT 100
| <http://www.lotico.com/ontology/followsTwitterUser> | <http://www.lotico.com/ontology/hasTwitterFollower> |
| <http://www.lotico.com/ontology/hasTopicInterest>   | <http://www.lotico.com/ontology/hasTopicUser>       |
| <http://www.lotico.com/ontology/memberOf>           | <http://xmlns.com/foaf/0.1/member>                  |

Instances (Triples)

Total triples:

SELECT count(*)
WHERE{
 ?s ?p ?o .
}

Results: 1,261,640

Triples by property

SELECT (count(*) AS ?c) ?p
WHERE{
 ?s ?p ?o .
}
GROUP BY ?p
ORDER BY ?c

Result

| 1      | <http://www.w3.org/2002/07/owl#versionInfo>                      |
| 2      | <http://www.w3.org/2002/07/owl#imports>                          |
| 3      | <http://www.w3.org/2000/01/rdf-schema#comment>                   |
| 3      | <http://www.w3.org/2002/07/owl#inverseOf>                        |
| 4      | <http://www.w3.org/2000/01/rdf-schema#domain>                    |
| 4      | <http://www.w3.org/2000/01/rdf-schema#range>                     |
| 6      | <http://www.w3.org/2000/01/rdf-schema#subClassOf>                |
| 36     | <http://xmlns.com/foaf/0.1/page>                                 |
| 45     | <http://purl.org/dc/elements/1.1/title>                          |
| 45     | <http://www.lotico.com/ontology/mbox>                            |
| 45     | <http://www.lotico.com/ontology/memberCount>                     |
| 45     | <http://xmlns.com/foaf/0.1/primaryTopic>                         |
| 46     | <http://www.lotico.com/ontology/location>                        |
| 248    | <http://www.lotico.com/ontology/ISO_3166-1-alpha-2_country_code> |
| 248    | <http://www.lotico.com/ontology/ISO_3166-1-alpha-2_country_name> |
| 944    | <http://www.lotico.com/ontology/hasTwitterFollowerCount>         |
| 1332   | <http://www.lotico.com/ontology/linkedin>                        |
| 1697   | <http://www.lotico.com/ontology/twitter>                         |
| 5587   | <http://www.lotico.com/ontology/hasGroupPlan>                    |
| 7150   | <http://xmlns.com/foaf/0.1/img>                                  |
| 8537   | <http://www.lotico.com/ontology/state>                           |
| 9864   | <http://www.lotico.com/ontology/ISO_3166-1-alpha-2>              |
| 9864   | <http://www.lotico.com/ontology/city>                            |
| 9864   | <http://www.lotico.com/ontology/countryCode>                     |
| 9864   | <http://www.lotico.com/ontology/memberid>                        |
| 9864   | <http://www.lotico.com/ontology/zip>                             |
| 9864   | <http://www.w3.org/2000/01/rdf-schema#seeAlso>                   |
| 9864   | <http://www.w3.org/2003/01/geo/wgs84_pos#lat>                    |
| 9864   | <http://www.w3.org/2003/01/geo/wgs84_pos#long>                   |
| 9864   | <http://xmlns.com/foaf/0.1/name>                                 |
| 11312  | <http://purl.org/dc/elements/1.1/date>                           |
| 11312  | <http://www.lotico.com/ontology/hasMembershipEvent>              |
| 11312  | <http://www.lotico.com/ontology/hasParticipant>                  |
| 11312  | <http://www.lotico.com/ontology/joined>                          |
| 11312  | <http://www.lotico.com/ontology/joinedChapter>                   |
| 11312  | <http://www.lotico.com/ontology/memberOf>                        |
| 11312  | <http://www.lotico.com/ontology/visited>                         |
| 11312  | <http://xmlns.com/foaf/0.1/member>                               |
| 11358  | <http://www.lotico.com/ontology/groupid>                         |
| 26764  | <http://www.w3.org/2000/01/rdf-schema#label>                     |
| 36705  | <http://www.w3.org/1999/02/22-rdf-syntax-ns#type>                |
| 63855  | <http://www.lotico.com/ontology/hasTopicInterest>                |
| 63855  | <http://www.lotico.com/ontology/hasTopicUser>                    |
| 853803 | <http://www.lotico.com/ontology/hasTwitterFollower>              |

Class Slots

Example query

SELECT DISTINCT ?p
WHERE{
 ?s a loticoowl:Member .
 ?s ?p ?o .
}
ORDER BY ?p
LIMIT 100

loticoowl:Member and foaf:Person

| <http://www.lotico.com/ontology/ISO_3166-1-alpha-2> |
| <http://www.lotico.com/ontology/city>               |
| <http://www.lotico.com/ontology/countryCode>        |
| <http://www.lotico.com/ontology/hasMembershipEvent> |
| <http://www.lotico.com/ontology/hasTopicInterest>   |
| <http://www.lotico.com/ontology/linkedin>           |
| <http://www.lotico.com/ontology/memberOf>           |
| <http://www.lotico.com/ontology/memberid>           |
| <http://www.lotico.com/ontology/state>              |
| <http://www.lotico.com/ontology/twitter>            |
| <http://www.lotico.com/ontology/zip>                |
| <http://www.w3.org/1999/02/22-rdf-syntax-ns#type>   |
| <http://www.w3.org/2000/01/rdf-schema#label>        |
| <http://www.w3.org/2000/01/rdf-schema#seeAlso>      |
| <http://www.w3.org/2003/01/geo/wgs84_pos#lat>       |
| <http://www.w3.org/2003/01/geo/wgs84_pos#long>      |
| <http://xmlns.com/foaf/0.1/img>                     |
| <http://xmlns.com/foaf/0.1/name> 

loticoowl:Topic

| <http://www.lotico.com/ontology/hasTopicUser>     |
| <http://www.w3.org/1999/02/22-rdf-syntax-ns#type> |
| <http://www.w3.org/2000/01/rdf-schema#label>      |

loticoowl:MembershipEvent

| <http://purl.org/dc/elements/1.1/date>            |
| <http://www.lotico.com/ontology/groupid>          |
| <http://www.lotico.com/ontology/hasGroupPlan>     |
| <http://www.lotico.com/ontology/hasParticipant>   |
| <http://www.lotico.com/ontology/joined>           |
| <http://www.lotico.com/ontology/joinedChapter>    |
| <http://www.lotico.com/ontology/visited>          |
| <http://www.w3.org/1999/02/22-rdf-syntax-ns#type> |
| <http://www.w3.org/2000/01/rdf-schema#label>      |

loticoowl:Chapter

| <http://www.lotico.com/ontology/groupid>          |
| <http://www.lotico.com/ontology/location>         |
| <http://www.lotico.com/ontology/mbox>             |
| <http://www.lotico.com/ontology/memberCount>      |
| <http://www.w3.org/1999/02/22-rdf-syntax-ns#type> |
| <http://www.w3.org/2000/01/rdf-schema#label>      |
| <http://xmlns.com/foaf/0.1/member>                |
| <http://xmlns.com/foaf/0.1/page>                  |

foaf:Document

| <http://purl.org/dc/elements/1.1/title>           |
| <http://www.w3.org/1999/02/22-rdf-syntax-ns#type> |
| <http://xmlns.com/foaf/0.1/primaryTopic>          |

Some properties are used by instances with no class membership

SELECT DISTINCT ?p
WHERE{
?s ?p ?o .
OPTIONAL { ?s a ?x }
FILTER ( ! bound(?x) )
}
| <http://www.lotico.com/ontology/ISO_3166-1-alpha-2_country_name> |
| <http://www.lotico.com/ontology/ISO_3166-1-alpha-2_country_code> |
| <http://www.lotico.com/ontology/hasTwitterFollower>              |
| <http://www.lotico.com/ontology/hasTwitterFollowerCount>         |
| <http://www.lotico.com/ontology/memberCount>                     |
| <http://xmlns.com/foaf/0.1/member>                               |
| <http://www.lotico.com/ontology/mbox>                            |

Potential use of the Lotico dataset

Faceted Browser

A better browsing user interface may be provided for the dataset.

Some example browsers are (with screenshots): http://www.slideshare.net/baojie_iowa/15-ways-to-explore-iswc-2010-data

The list of general-purposed browsers http://www.w3.org/2001/sw/wiki/ISWC_2010_Data_and_Demos#Browsers

More production-level Faceted browsers

  • Paggr Prospect (semsol)
  • Information Workbench ( fluid Operations)

Mobile Browser

See the example of ISWC Mobile (by Alvaro Graves, RPI)

http://iswc.mobi/2010/

Similar browser may be developed for Lotico. A different set of SPARQL queries are needed to adapt the ISWC Mobile to Lotico Mobile.

Visualization

Lotico has some visualization of maps and growth charts.

Some more interesting charts may be developed, for example

Social Network and Media

1697 members has Twitter accounts, and there are 853,803 following relation ships.

1332 members has LinkedIn accounts. The LinkedIn network may be linked to Lotico data.

In-depth analysis of user profiles and their relations may lead to better understanding of this community. Potential collaborators including researchers from the Social Cognitive Networks Academic Research Center (SCNARC) at RPI.

Moderate targeted marketing or information outreach may be possible within this community.

By monitoring twitter data from members, real-time data may be integrated into Lotico, e.g. Visual Backchannel (http://ilab51.cpsc.ucalgary.ca/iswc2010/) or Twitter widgets (http://tw.rpi.edu/weblog/2010/11/08/real-time-twitter-filters-for-iswc/)

Linking to External Data

User profiles may be automatically linked to external datasets, such as ArnetMiner (http://arnetminer.org/) and Semantic Web Dog Food (http://data.semanticweb.org/)

Event data may be linked to WikiCFP (http://www.wikicfp.com/cfp/)

General semantic web community data from ESWC, ISWC, WWW, SemTech and RuleML may be linked as well.

Other suggestions

Organization data is currently weak. Some seed information about organizations may be imported from the Semantic Web Dog Food dataset. New data maybe added by using forms on the wiki.

The opening and hiring page is currently non-semantics. Using semantic forms and semantic wiki to maintain this page may be better.

Supporting tagging on events or people may be useful.

While the Twitter data may be useful, it may not be necessary to store the Twitter following information in the main dataset (currently accounts for 2/3 of data), as they are dynamic and are considered less critical than other event or user profile data. If scalability becomes an issue, consider pruning external social relations to a separate dataset. The same for LinkedIn data (if added).