| | | | | | | 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 | |
| | |  |
| |