Statistics Tracker Channel Design As part of CSDepot

  • Slides: 10
Download presentation
Statistics Tracker Channel Design As part of CSDepot Master’s Project In partial fulfillment of

Statistics Tracker Channel Design As part of CSDepot Master’s Project In partial fulfillment of requirements for Master’s Degree Presented by Rebecca Twigg for Dr. Edward Chow Dr. Charlie Shub Dr. Tim Chamillard July 12, 2005 1

CSDepot Statistics Tracking – Design Considerations • • • Data Capture Persistence GUI Changes

CSDepot Statistics Tracking – Design Considerations • • • Data Capture Persistence GUI Changes Reporting Configuration Access Control/Permissions 2

Data Capture • What data? – User ID, Channel ID, Event, Date/Time • Which

Data Capture • What data? – User ID, Channel ID, Event, Date/Time • Which events? – Channel registration/subscription – Channel rendered – Channel targeted • How? – Implement as Stats. Recorder worker thread – Method called as event occurs, e. g. record channel rendered and targeted in Channel. Manager, from methods output. Channel() and process. Request. Channel. Parameters(), respectively. – Persist data with User. Instance in HTTP session – Since User. Instance implements Http. Session. Binding. Listener, will be notified of Http. Session. Binding. Events such as user logging out. Add method inside User. Instance method value. Unbound() to record channel statistics data to database at end of session. 3

Data Persistence • Across user session – By associating statistics with User. Instance object

Data Persistence • Across user session – By associating statistics with User. Instance object in HTTP session • Across sessions and users – By adding to portal database 4

Database Changes • Add new table to portal database: UP_CHANNEL_USER. Columns include: – –

Database Changes • Add new table to portal database: UP_CHANNEL_USER. Columns include: – – – – UP_CHANNEL (type integer) UP_USER (type integer) CHANNEL_ADDED (type date/time) CHANNEL_LAST_RENDERED (type date/time) CHANNEL_RENDERED_TOTAL (type long integer) CHANNEL_LAST_TARGETED (type date/time) CHANNEL_TARGETED_TOTAL (type long integer) • Add new column to portal database table UP_CHANNEL table: – TRACK_STATS (type Boolean) 5

GUI Changes • To add statistics tracking to a channel – Add checkbox in

GUI Changes • To add statistics tracking to a channel – Add checkbox in Channel Manager titled “Track Statistics” – Checked box indicates statistics will be tracked for that channel – Update code in Channel. Registry. Manager to capture new checkbox value • To report on channel statistics – Create new “Statistics Tracker” Channel 6

Statistics Tracker Channel Reporting • Drop-down list to select channel of all channels on

Statistics Tracker Channel Reporting • Drop-down list to select channel of all channels on which to report – List is determined from all channels in UP_CHANNEL with TRACK_STATS column = true • Radio buttons indicate columns on which to report • Date range – starting and ending dates on which to report • Report shows columns for chosen channels, includes both dates and times for events • Report query joins to UP_CHANNEL table to retrieve channel name, and to UP_USER to retrieve user name 7

Configuration • Set global (application-wide) statistics tracking properties to “on” in portal. properties file

Configuration • Set global (application-wide) statistics tracking properties to “on” in portal. properties file – record. Channel. Added. To. Layout – record. Channel. Rendered – record. Channel. Targeted • Set global statistics thread pool settings in portal. properties file – thread. Pool_initial. Threads – thread. Pool_max. Threads – thread. Pool_thread. Priority 8

Access Control / Permissions • In Channel Manager GUI: – Select which groups have

Access Control / Permissions • In Channel Manager GUI: – Select which groups have access to Channel Manager channel in order to select which channels to track – Select which groups have access to Statistics Tracker channel for viewing channel statistics 9

Project Status - as of 7/12/05 • Changed default skin – From Aggregated Tabs

Project Status - as of 7/12/05 • Changed default skin – From Aggregated Tabs & Columns to Tabs & Columns -- personal preference and more stable • Created Information Channel – Created new XML and XSLT documents – Implemented as Generic XSLT channel containing text and image • Designed Statistics Channel 10