C# 7 and .NET Core 2.0 High Performance

Denormalizing data into a flat schema for read/query purposes

This is another technique where we want to consume a service to read data from heterogeneous sources. It could be from multiple tables or databases. To transform multiple service calls into a single call, we can design each service and use patterns such as publisher/subscriber or mediator that listen for any CRUD operation to be performed on any service, save the data into a flat schema, and develop a service that only reads the data from that table(s). The technique to address this scenario is known as Command Query Responsibility Segregation (CQRS) and is discussed in the CQRS section later in the chapter.