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 |
|
vinnie_jones99
Starting Member
1 Post |
 Posted - 2002-04-25 : 05:36:43
|
| Hi everybody, im in the last stage of my study and need some bad help........PLEASE!!!!!!!!This is the problem:Weblog Analysis Many portals are interested in the click-stream behavior of their visitors. This involves the design of a database containing the clickstream information as receivedfrom the webservers. For this purpose we assume a relational DBMS with temporal facilities and triggers as discussed during the course. As a frame of reference we assume a large publisher in the Dutch market aiming to improve their advertising income through generation of personalised adds. You are being hired as a 'consultant' to design the information system to gather the click-stream information, to derive from the clickstream personal adds, and toproduce knowledge on customer profiles. You are expected to deliver a 10-15 page report covering the following, non-limiting list of topics: 1.what information can be obtained from the Webservers? 2.what information can/should be maintained for customers? 3.what customer profiles segments can be distinguished? 4.design a TSQL schema to keep the clickstream information 5.design a TSQL schema to keep the customer profile 6.design a TSQL schema to keep the advertising campaigns 7.design triggers to generate an add based on the customer profile 8.develop ca 4 TSQL reports to provide insight into the access behavior of the clients on the site. 9.cast the database schemas into a star/snowflake structure to enable OLAP processing 10.assess the techniques for datamining to improve knowledge extraction.If there is a piece that you like, please help me........ |
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2002-04-25 : 07:32:04
|
Sorry, we don't do homework for people. You have to put some thought in yourself  Damian |
 |
|
|
|
|
|
Big problem, nice exercice........