{"id":25189,"date":"2015-02-23T00:00:00","date_gmt":"2024-09-13T08:48:24","guid":{"rendered":"https:\/\/wordpress-583806-4798031.cloudwaysapps.com\/cqrs-well-known-techniques-facelift\/"},"modified":"2024-11-15T16:22:39","modified_gmt":"2024-11-15T15:22:39","slug":"cqrs-well-known-techniques-facelift","status":"publish","type":"post","link":"https:\/\/informator.se\/en\/cqrs-well-known-techniques-facelift\/","title":{"rendered":"CQRS: well known techniques facelift."},"content":{"rendered":"

<\/p>\n

Quite many expert notes and articles here<\/a> imply Command Query Responsibility Segregation (CQRS) as an aside, while addressing a multitude of other important data-architecture issues. In this note, the relationship is reversed, focusing explicitly on CQRS.<\/b><\/span><\/div>\n

<\/span><\/div>\n
<\/o_p><\/span><\/span><\/div>\n
CQRS extends Command\u2013Query Separation (CQS) to handling commands (write requests) and queries (read requests) by separate Query objects and Command objects, whereas CQS made them separate operations within one interface.<\/o_p><\/span><\/span><\/p>\n
<\/a><\/div>\n

<\/div>\n

CQRS is an architectural sibling, although not a synonym, of separated read and write data stores or subsystems. If you\u2019ve been involved in data warehousing and data marts in your past, you probably argue, rightly, that the separation is nothing new. It has been tested and leveraged for decades. In fact, the more analytics and management data, the more sense CQRS makes; its typical niche are not simple \u201cget\u201d operations where plain CQS within one interface would do, for example \u201cget_updated_balance\u201d when producing an updated customer receipt (at the end of a withdrawal transaction on an account).<\/o_p><\/span><\/span><\/div>\n
<\/div>\n
On the benefit side of CQRS, we find many favourites of data architects, as well as of other roles. CQRS results in more components, but they become simpler and less dependent on each other. This makes CQRS systems more resilient to change. At the same time, they facilitate performance optimisation especially on the \u201cQ\u201d side (side-effect free read operations) which can be partitioned into several data stores, each optimised for different categories of queries. This makes CQRS quite special, compared to a multitude of other patterns and tactics where modifiability and performance (or availability) are a difficult architectural tradeoff.<\/o_p><\/span><\/span><\/div>\n
<\/div>\n
In an agile, iterative transition to a Software Product Line architecture, the underlying pre-programmed variability, i.e. the mechanisms for \u201creshaping without reprogramming\u201d, starts typically on the read\/\u201cQ\u201d side, which often becomes only 2-tier (interaction, data) plus security. Parameterised multidimensional expressions (in MDX, mdXML, etc.) in the data tier match smoothly a parameterised interaction tier (parameterised Use Cases, user stories, dialogs, GUI layouts). For example, natural-language localisation (often including currency symbol, date formatting, decimal separator etc.) follows a similar \u201cparameterised\u201d rationale, using config files, start-up time parameters, language files for captions, etc. This is simpler than on the write\/\u201cC\u201d side where even a simple localisation has to tackle rules (internal, external regulatory, or both) that tend to vary from country to country.<\/o_p><\/span><\/span><\/div>\n
<\/div>\n
CQRS makes the transition from CRUD to semantic (\u201crich\u201d) operations and task-based GUI more natural. On the \u201cC\u201d side, they speed up the transfer of business logic (from Post-Its, texts, and end users\u2019 minds) into the system, and they can also enable security improvements.<\/o_p><\/span><\/span><\/div>\n
<\/div>\n
The \u201cS\u201d in CQRS (segregation) paves the road to non-procedural programming paradigms, recently dealt with in the article by professor Reichenbach here<\/a> on big data query languages (January 20th<\/sup>). These make things simpler for the programmer (although rarely for the vendor of compilers, optimisers, or test tools), especially in a multicore and multithread environment where non-procedural approaches and automation are less prone to human error than procedural ones.<\/o_p><\/span><\/span><\/div>\n
<\/div>\n
\"MilanSumming up, CQRS is a widely used practice, rather than a law of nature. Its plus points cluster around modifiability: low coupling, high cohesion, scalability, variability (deferred binding time), notably without compromising performance.<\/span><\/span>

<\/span><\/span>\/\/ by <\/span>Milan Kratochvil<\/a>,  Trainer at Informator and senior modelling and architecture consultant, <\/span>Kiseldalen.com<\/a>, Sweden. <\/span><\/span>Milan<\/span><\/st1_place><\/st1_city> and Informator collaborate since 1996 on modelling, UML, architecture, requirements, analysis and design. You can meet Milan<\/st1_place><\/st1_city> in March at Architecture Fundamentals ( T1101<\/a> ) or Advanced Object Modelling ( T2716<\/a> , in Swedish).<\/span><\/div>\n
\n

Posted by courtesy of  ODBMS.ORG<\/a><\/b> \u2014The Resource Portal for Big Data, New Data Management Technologies and Data Science<\/i><\/span><\/span><\/p><\/blockquote>\n<\/div>\n

<\/span><\/span><\/p>\n

\u00a0<\/span><\/span><\/h4>\n

<\/span><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"

Quite many expert notes and articles here imply Command Query Responsibility Segregation (CQRS) as an aside, while addressing a multitude of other important data-architecture issues. In this note, the relationship is reversed, focusing explicitly on CQRS. CQRS extends Command\u2013Query Separation (CQS) to handling commands (write requests) and queries (read requests) by separate Query objects and […]<\/p>\n","protected":false},"author":6,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[584,570,922],"tags":[],"class_list":["post-25189","post","type-post","status-publish","format-standard","hentry","category-arkitektur","category-blogg","category-blogi"],"aioseo_notices":[],"aioseo_head":"\n\t\t\n\t\n\t\n\t\n\t\n\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t