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