I need to build a logging system for QA testing devices in production line. There are around 25 such devices, with 7 or so different types that all work differently (I more or less understand 2 of them). At this moment I don't know if all of them will be on network and what are their capabilities. I will need to track how long each test lasts, what's the failure rate for each of them and present them in easy for managers to understand way.
Do you have any tips on how should I structure this? I'm thinking of doing two databases: one for raw logs, other for structured results for presentation. That way I could have different structure from each device type and format them later into universal structure in a cron job.
Has anyone else build something similar? Some hindsight would help.