Quote:

to make an efficient representation usable for OLAP – we need to modify our data on its way to OLAP replicas

Another Quote:

Each of the DB Server Apps is a replica master, but all replica targets are within the same Replica DB

Quote:

while duplication MAY indeed improve performance – undue duplication also MAY hit performance pretty badly

Another Quote:

NoSQL will usually call for another denormalisation on top of what we’ve described above for SQL-with-XML.

Quote:

If we’re speaking about millions transactions per day over just a few hundred of different SQL statements – compiling those statements a million times (instead of a few hundred times) will be a dramatic waste of resources.

Another Quote:

Once upon a time, I observed the largest C++ file in my career – it was a 30’000-line file(!) consisting merely of ODBC bindings (and that was just for 300 or so SQL statements)

Quote:

99% of reporting requests and 99.9% of analytics is purely historical

Another Quote:

Information within the audit table should be sufficient to validate/justify current state