No, it's generally true for broad categories - OLTP vs. OLAP. These patterns, along with different data structure needs to serve their intended use cases, are w

No, it's generally true for broad categories - OLTP vs. OLAP. These patterns, along with different data structure needs to serve their intended use cases, are why data warehouses are almost always separate from transactional systems. Re: auto-optimizing databases: the DB would need to understand query patterns before it could optimize storage format. Is it possible? Almost certainly, to an extent. But not upfront.