Briefly looking, I can't find the books that I thought covered a lot of this in a good way. Will keep looking, apologies.
I can't recommend it highly enough.
[1] https://www.amazon.com/Designing-Data-Intensive-Applications...
- OLAP: most queries need most records (aggregations span large swaths of data)
- OLTP: most queries access just a few records
Also, in OLAP, in many cases, you can live with a single-updater model without much trouble, where OLTP, the strength is to have many concurrent updaters (but mostly non-overlapping).
- OLTP: write-mostly, index-seek heavy, ~all queries pre-defined up front
OLTP - You are dealing with the ins and outs of people using stuff to do things. You buy something, you check out something, you some way perturb the state of things. This should not require large amount of row lookups in 99.9% of cases.
If you could elaborate on this further, I and others are probably very interested in reading more about it.