Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Rick_Boston
Starting Member
5 Posts |
 Posted - 2009-03-07 : 08:43:40
|
| I have been given a web server log and need to find patterns based on users movements within the web site. For example a user moves from index.htm to products.htm and then to trainers.htm.I am trying to populate patterns and some sort of results i.e. what is the certainty of a user choosing index.htm to products.htm and then to trainers.htm.I am using ms sql 2005 I have made a new table with 3 rows. Unique ID UID, The page they are presently on reffering_page and page they moved to page_requested. I think I want to use association rules from the mining wizard in business intelligence?It would be a great help if someone could tell me the steps i am missing or the rows i need to add, ip_address?Many thanks Rick_Boston |
|
|
|
|
|
Web server log - MS SQL 2005 - Looking for user pa