Designing Data-Intensive Applications: The Big Ideas Behind Reliable, Scalable, and Maintainable Systems

by Martin Kleppmann

the data stored in the search index and the data warehouse is just another view onto the data in the system of record.