Marco at 09:57, 30 July 2017

2017-07-30T09:57:26Z

New page

__TOC__

==General Issue==

Date of analysis: May 30th, 2011

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

==Prefixes==
<pre>
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/>
</pre>

=What are in the data=
==Classes used==
<pre>
SELECT count(?x) ?type
WHERE{
?x a ?type.
}
GROUP BY ?type
</pre>

Results (classes and their number of instances)
<pre>
| 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> |
</pre>

==OWL Classes==
(There is no instance of rdfs:Class)
<pre>
SELECT ?x
WHERE{
?x a owl:Class .
}LIMIT 100
</pre>

Results
<pre>
<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>
</pre>

Instance counting
<pre>
SELECT count(?y) ?x
WHERE{
?x a owl:Class .
?y a ?x .
}
GROUP BY ?x
</pre>

Results
<pre>
| 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> |
</pre>

==Class Hierarchy==

There is no class hierarchy

<pre>
SELECT ?s ?o
WHERE{
?s rdfs:subClassOf ?o .
}
LIMIT 100
</pre>

==Properties used==
44 properties
<pre>
SELECT DISTINCT ?p
WHERE{
?x ?p ?o .
}
ORDER BY ASC(?p)
LIMIT 100
</pre>

Results
<pre>
| <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>
</pre>

==Property Axioms==

Domains and ranges

<pre>
SELECT ?s ?domain ?range
WHERE{
?s a rdf:Property .
?s rdfs:domain ?domain .
?s rdfs:range ?range .
}
ORDER BY ?p
LIMIT 100
</pre>

<pre>
| 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> |

</pre>

Inverse Properties
<pre>
SELECT *
WHERE{
?p1 owl:inverseOf ?p2 .
}
ORDER BY ?p1
LIMIT 100
</pre>
<pre>
| <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> |
</pre>

==Instances (Triples)==
Total triples:
<pre>
SELECT count(*)
WHERE{
?s ?p ?o .
}
</pre>

Results: 1,261,640

Triples by property
<pre>
SELECT (count(*) AS ?c) ?p
WHERE{
?s ?p ?o .
}
GROUP BY ?p
ORDER BY ?c
</pre>

Result
<pre>
| 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> |
</pre>

==Class Slots==

Example query
<pre>
SELECT DISTINCT ?p
WHERE{
?s a loticoowl:Member .
?s ?p ?o .
}
ORDER BY ?p
LIMIT 100
</pre>

loticoowl:Member and foaf:Person
<pre>
| <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>
</pre>

loticoowl:Topic
<pre>
| <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> |
</pre>

loticoowl:MembershipEvent
<pre>
| <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> |
</pre>

loticoowl:Chapter
<pre>
| <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> |
</pre>

foaf:Document
<pre>
| <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> |
</pre>

Some properties are used by instances with no class membership
<pre>
SELECT DISTINCT ?p
WHERE{
?s ?p ?o .
OPTIONAL { ?s a ?x }
FILTER ( ! bound(?x) )
}
</pre>

<pre>
| <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> |
</pre>

=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
* 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).

Lotico dataset - Revision history

Marco at 09:57, 30 July 2017