How to read a Log file and map the data to a table in an RDBMS?
Hello please help me with this..
I have a log file,... i want to read the data from the log file which shows how many requests are there ... the code must be in such a way that there should be an hourly stats mapped to a database , typically an oracle database...
The req. is to take the data from the log file..
split the data in such a way that there is Date Stamp, Number of requests, time
This should occur each and every hour.. we must get how many requests there were to the server in the previous hour.. and that number of requests and the time should be mapped to columns in a database table..
Someone please help me.. Please give me the code.. or atleast please give me some brief specifics about how to achieve this... and how to do it...
Thank you very much!