I like awstats for my reports.
The log files are pretty basic, and are space-delimited, with some fields using quotation marks to encapsulate a field. Extracting the data into a database is the more trivial aspect of what you want to do. The hard part will be interpreting and manipulating the data.
The logs are in your home directory’s “logs” folder.