Using Data Mining to Predict Response Times
This report is making real-time queries to a data mining model predicting the response time of the last 50 web requests to this site. The data mining algorithm is using the columns you see listed in the report (except actual) to predict response time. Since the model has not seen these records (it is only refreshed weekly) the accuracy is entirely due to the relationships the algorithm has found in historical data. To help make it easier to visualise, the actual and predicted columns are colour coded depending on response/prediction time. This report proves that data mining queries can be very fast and be included in online applications. Every execution of this report queries the relational database for the last 50 requests, and then queries the data mining model for a prediction on each record.
Request Time (Sydney Aust)
Predicted Response Time
Actual Response Time 
Bytes In
Bytes Out 
Country
City
Resource
Client Operating System
Client Agent
HTTP Status
Operation
Referring Server
9/3/2010 10:30:00 PM
4.840
3.359
556
1,604
UNITED STATES
MOUNTAIN VIEW
Reserved.ReportViewerWebControl.axd
Unknown
bot
Server error
GET
 
9/3/2010 9:52:00 PM
4.840
2.859
543
1,604
UNITED STATES
MOUNTAIN VIEW
Reserved.ReportViewerWebControl.axd
Unknown
bot
Server error
GET
 
9/3/2010 10:29:00 PM
0.647
0.343
425
274
DENMARK
SKANDERBORG
Blogs.gif
Windows NT 6.0
MSIE 7.0
OK
GET
 
9/3/2010 10:27:00 PM
6.541
3.468
302
83,612
BULGARIA
SOFIA
Surfing.jpg
Windows NT 5.1
MSIE 7.0
OK
GET
www.myspace.com
9/3/2010 10:26:00 PM
12.529
3.609
479
185,222
GERMANY
WALDKIRCHEN
DMClickStreamAnalysisOfEasternMining.com.au.jpg
Windows NT 5.2
MSIE 6.0
OK
GET
richardlees.com.au
9/3/2010 10:26:00 PM
0.490
0.375
457
1,146
GERMANY
WALDKIRCHEN
bl_Shadow_Right.jpg
Windows NT 5.2
MSIE 6.0
OK
GET
richardlees.com.au
9/3/2010 10:26:00 PM
0.491
0.671
474
3,086
GERMANY
WALDKIRCHEN
EasternMiningCube.jpg
Windows NT 5.2
MSIE 6.0
OK
GET
richardlees.com.au
9/3/2010 10:26:00 PM
0.827
0.359
477
356
GERMANY
WALDKIRCHEN
WebResource.axd
Windows NT 5.2
MSIE 6.0
OK
GET
richardlees.com.au
9/3/2010 10:26:00 PM
0.403
0.328
456
1,144
GERMANY
WALDKIRCHEN
bl_Shadow_Left.jpg
Windows NT 5.2
MSIE 6.0
OK
GET
richardlees.com.au
9/3/2010 10:26:00 PM
3.363
0.828
477
33,531
GERMANY
WALDKIRCHEN
WebResource.axd
Windows NT 5.2
MSIE 6.0
OK
GET
richardlees.com.au
9/3/2010 10:26:00 PM
16.855
5.546
469
264,534
GERMANY
WALDKIRCHEN
core.js
Windows NT 5.2
MSIE 6.0
OK
GET
richardlees.com.au
9/3/2010 10:26:00 PM
2.415
1.640
477
21,125
GERMANY
WALDKIRCHEN
WebResource.axd
Windows NT 5.2
MSIE 6.0
OK
GET
richardlees.com.au
9/3/2010 10:26:00 PM
10.711
3.437
475
105,685
GERMANY
WALDKIRCHEN
ie55up.js
Windows NT 5.2
MSIE 6.0
OK
GET
richardlees.com.au
9/3/2010 10:26:00 PM
5.326
2.484
477
83,133
GERMANY
WALDKIRCHEN
core.css
Windows NT 5.2
MSIE 6.0
OK
GET
richardlees.com.au
9/3/2010 10:26:00 PM
4.217
1.953
473
69,028
GERMANY
WALDKIRCHEN
init.js
Windows NT 5.2
MSIE 6.0
OK
GET
richardlees.com.au
9/3/2010 10:26:00 PM
1.021
1.046
458
6,067
GERMANY
WALDKIRCHEN
rca.css
Windows NT 5.2
MSIE 6.0
OK
GET
richardlees.com.au
9/3/2010 10:26:00 PM
0.627
0.312
443
524
GERMANY
WALDKIRCHEN
zz1_blue.css
Windows NT 5.2
MSIE 6.0
OK
GET
richardlees.com.au
9/3/2010 10:26:00 PM
0.292
0.390
466
2,277
GERMANY
WALDKIRCHEN
pageLayouts.css
Windows NT 5.2
MSIE 6.0
OK
GET
richardlees.com.au
9/3/2010 10:26:00 PM
0.703
1.140
495
12,464
GERMANY
WALDKIRCHEN
HtmlEditorTableFormats.css
Windows NT 5.2
MSIE 6.0
OK
GET
richardlees.com.au
9/3/2010 10:26:00 PM
1.527
1.046
463
7,412
GERMANY
WALDKIRCHEN
controls.css
Windows NT 5.2
MSIE 6.0
OK
GET
richardlees.com.au
9/3/2010 10:26:00 PM
1.662
1.000
459
7,045
GERMANY
WALDKIRCHEN
Band.css
Windows NT 5.2
MSIE 6.0
OK
GET
richardlees.com.au
9/3/2010 10:26:00 PM
0.955
0.390
495
2,217
GERMANY
WALDKIRCHEN
HtmlEditorCustomStyles.css
Windows NT 5.2
MSIE 6.0
OK
GET
richardlees.com.au
9/3/2010 10:25:00 PM
1.664
1.781
1,031
32,958
GERMANY
WALDKIRCHEN
DataMining.aspx
Windows NT 5.2
MSIE 6.0
OK
GET
www.google.de
9/3/2010 10:24:00 PM
0.394
0.328
263
428
FRANCE
PARIS
 
Unknown
bot
OK
GET
 
9/3/2010 10:14:00 PM
1.308
0.343
470
274
UNITED KINGDOM
LONDON
Blogs.gif
Windows
Firefox 3.6.8
OK
GET
 
9/3/2010 10:14:00 PM
0.408
0.125
143
428
JAPAN
TOKYO
 
Unknown
bot
OK
GET
 
9/3/2010 10:13:00 PM
1.308
0.343
470
274
UNITED KINGDOM
LONDON
Blogs.gif
Windows
Firefox 3.6.8
OK
GET
 
9/3/2010 10:13:00 PM
0.441
0.218
447
288
UNITED STATES
SUNNYVALE
Authenticate.aspx
Unknown
Mozilla
Denied
GET
 
9/3/2010 10:13:00 PM
1.308
0.328
470
274
UNITED KINGDOM
LONDON
Blogs.gif
Windows
Firefox 3.6.8
OK
GET
 
9/3/2010 10:12:00 PM
1.308
0.375
470
274
UNITED KINGDOM
LONDON
Blogs.gif
Windows
Firefox 3.6.8
OK
GET
 
9/3/2010 10:10:00 PM
1.956
1.078
629
12,464
UNITED KINGDOM
LONDON
HtmlEditorTableFormats.css
Windows NT 5.1
MSIE 8.0
OK
GET
richardlees.com.au
9/3/2010 10:10:00 PM
1.802
0.734
597
7,412
UNITED KINGDOM
LONDON
controls.css
Windows NT 5.1
MSIE 8.0
OK
GET
richardlees.com.au
9/3/2010 10:10:00 PM
1.908
0.671
593
7,045
UNITED KINGDOM
LONDON
Band.css
Windows NT 5.1
MSIE 8.0
OK
GET
richardlees.com.au
9/3/2010 10:10:00 PM
1.554
0.328
600
2,277
UNITED KINGDOM
LONDON
pageLayouts.css
Windows NT 5.1
MSIE 8.0
OK
GET
richardlees.com.au
9/3/2010 10:10:00 PM
1.819
0.343
577
524
UNITED KINGDOM
LONDON
zz1_blue.css
Windows NT 5.1
MSIE 8.0
OK
GET
richardlees.com.au
9/3/2010 10:10:00 PM
0.821
0.406
629
2,217
UNITED KINGDOM
LONDON
HtmlEditorCustomStyles.css
Windows NT 5.1
MSIE 8.0
OK
GET
richardlees.com.au
9/3/2010 10:10:00 PM
1.274
0.375
592
6,067
UNITED KINGDOM
LONDON
rca.css
Windows NT 5.1
MSIE 8.0
OK
GET
richardlees.com.au
9/3/2010 10:10:00 PM
3.330
1.484
288
35,748
UNITED STATES
CHICAGO
RichardsWelcomePage.aspx
Windows
Firefox 3.0
OK
GET
 
9/3/2010 10:10:00 PM
3.330
1.437
288
35,748
UNITED STATES
CHICAGO
RichardsWelcomePage.aspx
Windows
Firefox 3.0
OK
GET
 
9/3/2010 10:10:00 PM
6.396
1.640
1,260
35,785
UNITED KINGDOM
LONDON
RichardsWelcomePage.aspx
Windows NT 5.1
MSIE 8.0
OK
GET
www.google.co.uk
9/3/2010 10:10:00 PM
2.283
1.265
1,023
20,683
UNITED KINGDOM
LONDON
Richard Unicycling Manly Beach.JPG
Windows NT 5.1
MSIE 8.0
OK
GET
www.google.co.uk
9/3/2010 10:10:00 PM
0.717
0.265
258
433
UNITED STATES
CHICAGO
 
Windows
Firefox 3.0
OK
GET
 
9/3/2010 10:10:00 PM
0.512
0.312
1,230
433
UNITED KINGDOM
LONDON
 
Windows NT 5.1
MSIE 8.0
OK
GET
www.google.co.uk
9/3/2010 10:09:00 PM
2.609
1.796
420
54,092
UNITED STATES
REDMOND
Internet Activity Today.aspx
Unknown
Unknown
OK
GET
 
9/3/2010 10:09:00 PM
0.321
0.343
281
615
UNITED STATES
REDMOND
demonstrations
Unknown
Unknown
OK
GET
 
9/3/2010 10:08:00 PM
0.361
0.218
217
 
UNITED STATES
REDMOND
 
Unknown
bot
OK
GET
 
9/3/2010 10:07:00 PM
1.308
0.328
470
274
UNITED KINGDOM
LONDON
Blogs.gif
Windows
Firefox 3.6.8
OK
GET
 
9/3/2010 10:06:00 PM
1.308
0.375
470
274
UNITED KINGDOM
LONDON
Blogs.gif
Windows
Firefox 3.6.8
OK
GET
 
9/3/2010 10:06:00 PM
1.308
0.359
470
274
UNITED KINGDOM
LONDON
Blogs.gif
Windows
Firefox 3.6.8
OK
GET
 
9/3/2010 10:05:00 PM
1.308
0.359
470
274
UNITED KINGDOM
LONDON
Blogs.gif
Windows
Firefox 3.6.8
OK
GET