Lotico dataset
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)
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
- Dynamic growth charts of members in each chapter. e.g., http://www.cs.rpi.edu/~baojie/cta/location.html
- Timeline of events e.g., http://tw.rpi.edu/weblog/2010/11/01/timeline-of-iswc-main-conference-talks-2/
- Map of members by cities or locations, e.g., http://goo.gl/maps/Ipr1
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).