Navigation Home Page Product Overview Log Processing Reporting Tool Standard Reports Advanced Reports Word Report Tool Register Interest Useful Links Debian MySQL Remote Data Services Office Web Components Customer Login Report Database Username Password Website Statistics are compliant with the rules and regulations as set by industry standards for web log processing.

Website Log Analysis And Reporting The Reporting Tool 1. Internet Explorer Browser The tools used to display statistics and reports use features only offered by Microsoft Internet Explorer versions 4 and above. These features enhance the procedures of executing queries against the back end MySQL database and displaying results. VBScript runs in the browser to process data on the client side ensuring fast processing and report access. ActiveX controls, specifically Microsoft Office Web Components, display the report data in a professional way allowing manipulation of data and export mechanisms. The client chooses a report and enters report parameters. The browser sends these details via RDS to the webserver which processes the query and returns the result data back to the browser. Only the data is sent back to the browser - there are no HTML or XML markup tags which increase the data size and therefore resulting data is downloaded very quickly. 2. Remote Data Services Remote Data Services run from within the browser and connect to COM components running on the ANL IIS v5 webserver. Most noticably, this allows for data download without having to refresh the browser screen. Once report data is downloaded to the browser it runs on the clients computer and allows reporting and manipulation without having to requery the database. This therefore means reports are generated quickly and efficiently using the clients computer processing power instead of the webserver's. 3. Custom COM Component A custom COM component runs on the IIS webserver and handles the interaction between the client's browser and the back end MySQL database. The COM component builds the database query commands on the webserver and executes them against the MySQL database returning the results to the browser in the form of a recordset. As the database commands are built and executed server side no database statements are passed over the internet ensuring a high level of security - only the resulting data is passed back to the browser. 4. Open Database Connectivity (ODBC) To connect to the back end database store the webserver uses MyODBC to connect to the MySQL database. Using customised database timeouts and ODBC connection pooling the connectivity to the database is fast and reliable. 5. MySQL Database Server Once the COM component has built the database commands using the criteria parameters passed to it from the browser the commands are executed on the MySQL database. The MySQL server executes the database command and passes the data back via ODBC to the COM component running on the webserver. MySQL offers very fast database querying and the way that the databases are stored and indexed on the database server result in very positive response times. MySQL also allows the use of a wide range of string manipulation functions within the database query commands ideal for querying web site logs.