sessionid
sessions.sessionid
Integer
sessions
pagetype
clickstream.pagetype
String
clickstream.sessionid = sessions.sessionid
clickstream, sessions
concat(clickstream.sessionid , ":" , visit_page_num)
clickstream mapping
maps to clickstream data in mysql
Concept
concept
http://www.xes-standard.org/concept.xesext
concept:name
sessions.sessionid
String
concept:name
sessions.sessionid
String
concept:instance
String
concept:name
String
lifecycle:transition
Lifecycle
lifecycle
http://www.xes-standard.org/lifecycle.xesext
lifecycle:model
String
lifecycle:transition
String
concept:instance
String
concept:name
String
org:resource
Organizational
org
http://www.xes-standard.org/org.xesext
org:resource
String
org:group
String
org:role
String
org:group
String
org:role
String
org:resource
String
concept:instance
sessions.sessionid + clickstream.visit_page_num
String
pagetype
clickstream.pagetype
String
time:timestamp
clickstream.hitTimeStamp
Time
time
http://www.xes-standard.org/time.xesext
time:timestamp
Date
time:timestamp
Date
time:timestamp
clickstream.hitTimeStamp
Date
concept:name
clickstream.pagename
String
Pageview
Date
sessions.sessionid=clickstream.sessionid
clickstream
sessions.sessionid, clickstream.visit_page_num
Page View
org:group
String
org:role
String
org:resource
String
org:group
String
org:role
String
String
semantic:modelReference
Semantic
semantic
http://www.xes-standard.org/semantic.xesext
semantic:modelReference
String
semantic:modelReference
String
semantic:modelReference
String
semantic:modelReference
String
semantic:modelReference
String
String
Hit
lifecycle:transition
String
lifecycle:transition
String
String
sessions
Session
concept:instance
sessions.sessionid
String
jdbc:mysql://localhost/clickstream
com.mysql.jdbc.Driver
C:\jars\mysql-connector-java-5.1.36\mysql-connector-java-5.1.36-bin.jar
user
clickstream
password
click!2
MySQL clickstream data