Exploring Your Data

This topic provides information about common questions to ask when getting to know your data.

• How do I find out which predicates (keys) a data set uses?
• How do I determine the frequency of a predicate's use?
• How do I find symmetric predicates?

How do I find out which predicates (keys) a data set uses?

When you receive a new dataset, one of the first things to understand about the new dataset is what predicates are used. The following query lists the predicates used in the sample Tickit dataset.

SELECT DISTINCT ?predicates FROM http://anzograph.com/tickit WHERE { ?subject ?predicates ?object . } ORDER BY ?predicates

predicates

http://anzograph.com/tickit/birthday http://anzograph.com/tickit/buyerid http://anzograph.com/tickit/caldate http://anzograph.com/tickit/card http://anzograph.com/tickit/catdesc http://anzograph.com/tickit/catgroup http://anzograph.com/tickit/catid http://anzograph.com/tickit/catname http://anzograph.com/tickit/city http://anzograph.com/tickit/commission http://anzograph.com/tickit/dateid http://anzograph.com/tickit/day http://anzograph.com/tickit/dislike http://anzograph.com/tickit/email http://anzograph.com/tickit/eventid http://anzograph.com/tickit/eventname http://anzograph.com/tickit/firstname http://anzograph.com/tickit/friend http://anzograph.com/tickit/holiday http://anzograph.com/tickit/lastname http://anzograph.com/tickit/like http://anzograph.com/tickit/listid http://anzograph.com/tickit/listtime http://anzograph.com/tickit/month http://anzograph.com/tickit/numtickets http://anzograph.com/tickit/phone http://anzograph.com/tickit/pricepaid http://anzograph.com/tickit/priceperticket http://anzograph.com/tickit/qtr http://anzograph.com/tickit/qtysold http://anzograph.com/tickit/saletime http://anzograph.com/tickit/sellerid http://anzograph.com/tickit/ssn http://anzograph.com/tickit/starttime http://anzograph.com/tickit/state http://anzograph.com/tickit/totalprice http://anzograph.com/tickit/venuecity http://anzograph.com/tickit/venuecitypop http://anzograph.com/tickit/venueid http://anzograph.com/tickit/venuename http://anzograph.com/tickit/venueseats http://anzograph.com/tickit/venueseatspct http://anzograph.com/tickit/venuestate http://anzograph.com/tickit/week http://anzograph.com/tickit/year http://www.w3.org/1999/02/22-rdf-syntax-ns#type 46 rows

How do I determine the frequency of a predicate's use?

Once you determine what predicates a new data set uses, you might want to see how frequently the predicates are used. Frequency counts can give you an indication of which predicates the data set uses together, which helps to identify objects in the graph. The following query lists the predicates in the sample Tickit data set ordered by the frequency in which they appear.

SELECT ?predicate (COUNT (?predicate) AS ?count) FROM http://anzograph.com/tickit WHERE { ?s ?predicate ?o . } GROUP BY ?predicate ORDER BY DESC(?count)

predicate | count ------------------------------------------------+--------- http://anzograph.com/tickit/friend | 1445832 http://www.w3.org/1999/02/22-rdf-syntax-ns#type | 424319 http://anzograph.com/tickit/dateid | 373751 http://anzograph.com/tickit/sellerid | 364953 http://anzograph.com/tickit/eventid | 364953 http://anzograph.com/tickit/numtickets | 192497 http://anzograph.com/tickit/listtime | 192497 http://anzograph.com/tickit/priceperticket | 192497 http://anzograph.com/tickit/totalprice | 192497 http://anzograph.com/tickit/qtysold | 172456 http://anzograph.com/tickit/buyerid | 172456 http://anzograph.com/tickit/listid | 172456 http://anzograph.com/tickit/commission | 172456 http://anzograph.com/tickit/saletime | 172456 http://anzograph.com/tickit/pricepaid | 172456 http://anzograph.com/tickit/dislike | 121038 http://anzograph.com/tickit/like | 120911 http://anzograph.com/tickit/city | 49990 http://anzograph.com/tickit/phone | 49990 http://anzograph.com/tickit/state | 49990 http://anzograph.com/tickit/email | 49990 http://anzograph.com/tickit/lastname | 49990 http://anzograph.com/tickit/ssn | 49990 http://anzograph.com/tickit/firstname | 49990 http://anzograph.com/tickit/card | 49990 http://anzograph.com/tickit/birthday | 49990 http://anzograph.com/tickit/starttime | 8798 http://anzograph.com/tickit/venueid | 8798 http://anzograph.com/tickit/catid | 8798 http://anzograph.com/tickit/eventname | 8798 http://anzograph.com/tickit/year | 365 http://anzograph.com/tickit/week | 365 http://anzograph.com/tickit/holiday | 365 http://anzograph.com/tickit/caldate | 365 http://anzograph.com/tickit/day | 365 http://anzograph.com/tickit/qtr | 365 http://anzograph.com/tickit/month | 365 http://anzograph.com/tickit/venuecitypop | 202 http://anzograph.com/tickit/venuestate | 202 http://anzograph.com/tickit/venuecity | 202 http://anzograph.com/tickit/venuename | 202 http://anzograph.com/tickit/venueseatspct | 58 http://anzograph.com/tickit/venueseats | 58 http://anzograph.com/tickit/catdesc | 11 http://anzograph.com/tickit/catgroup | 11 http://anzograph.com/tickit/catname | 11 46 rows

How do I find symmetric predicates?

Another part of analyzing a new data set is understanding how the predicates are used. Predicates can be used in a symmetric way, for example, Ted knows Bob and Bob knows Ted. The following query finds the predicates in the sample Tickit data set that have symmetry and returns a count of the number of times that predicate is used symmetrically:

SELECT ?symmetricPredicate (COUNT (?symmetricPredicate) AS ?count) FROM http://anzograph.com/tickit WHERE { ?s ?symmetricPredicate ?o . ?o ?symmetricPredicate ?s . } GROUP BY ?symmetricPredicate

symmetricPredicate | count -----------------------------------+--------- http://anzograph.com/tickit/friend | 1293290 1 rows