Could you elaborate on the architectural differences between OLTP (Online Transaction Processing) and OLAP (Online Analytical Processing) database systems, including their respective design considerations, query optimization strategies, and performance trade-offs in supporting transactional and analytical workloads?