Look at implementing a star schema. It's a dimensional data model. This
is typically used for BI and reporting because it's as fast as can be
for response time.The trade off is it is slower with inserts and the
code doing the inserts has to be more c...