Using CQRS Pattern for Improving Performance in Relational Databases

Abstract

Data-intensive applications, such as social media, financial and trade systems, rely heavily on data generated by users. This type of application requires high performance, and traditional architecture may not be suitable for complex applications. CQRS is a programming model pattern that changes the traditional mentality of using one programming model as CRUD, where writing and reading operation work in a single model. CQRS segregates CRUD into two programming models. CQRS pattern treats retrieving data and writing data separately with different responsibilities. Here in the introduction, some quotes describe the CQRS pattern. Also, here are some motivations for the implementation of the CQRS pattern. The Case Study section presents an implementation of the CQRS pattern in API applications with the intention of optimization. Below is presented the value of segregating the reading data model from data store.