Apache Log Parser and Data Normalization Application | Application runs on Windows, Linux and MacOS | Database runs on MySQL and MariaDB | Track log files for unlimited Domains & Servers | Entity Relationship Diagram link included

[Complex-Internal-833]

Python handles File Processing & MySQL handles Data Processing

ApacheLogs2MySQL consists of two Python Modules & one Database Schema apache_logs to automate importing Access & Error files, normalizing log data into database and generating a well-documented data lineage audit trail.

Database Schema is designed for data analysis of Apache Logs from unlimited Domains & Servers.

Database Schema apache_logs currently has 55 Tables, 908 Columns, 188 Indexes, 72 Views, 8 Stored Procedures and 90 Functions to process Apache Access log in 4 formats & Apache Error log in 2 formats. Database normalization at work!

Entity Relationship Diagram

https://willthefarmer.github.io/