To help with a home project I would like a fully working demonstration Data Mining application that "scrapes" data off a website and outputs results to a MS Access Database. The main purpose of this exercise is for educationally purposes to allow me to review the programming techniques used and learn from them.
3 websites will be used to demonstrate the techniques required as follows:-
1. [url removed, login to view]
The left side of the webpage holds a tree. The tree will need to be automatically 'exploded' by the application down to all it's levels and then stored on a local database. Once loaded into database, user can select events (e.g. a specific Football match) from the database for further processing. The selected event(s) will then have its relevant web-page raw data loaded into a database. (Format of file is not particularly important it is how this is achieved programming wise). The event's page has multiple tabs on the screen - all the available sub-views on this event's page need to be loaded to the database. (Effectively the database would to some extent mimic what the user would see in a Browser if they navigated to this event manually)
2. [url removed, login to view]
Very similar to the first site. A tree exists on the left and you can navigate to a particular event. Details need to be updated to a database for the entire tree and selected events also need to be extracted as previously described. Extraction on this website is very similar in approach and control described above but just need to see how two different sites are handled.
3. [url removed, login to view]
From this website a tab/link is available titled 'Live Commentary' or 'Live Betting'. Selecting either of these opens a smaller Desktop webpage. The data from this 'desktop' webpage need to be extracted and stored in a database. Multiple events (races) (dropdown list) and multiple tabs in the upper and lower portions of the screen are available showing different data. The application needs to automatically determine what is available and download all the data to a database for further data mining.
On the 'Commentary' tab, when a race is in progress, a real-time text commentary is streamed and this needs to be captured to a database file as it appears.
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.
2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables):
a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment.
b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.
3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).
source must be able to be maintained in
Microsoft Visual Studio .Net 2002 (version [url removed, login to view])
Visual Basic .NET