April 21, 2010 at 3:39 pm
Does anyone have comments or experiences to relate about the CQRS pattern and its implications for the database tier? I have got some views (and some doubts) of my own but they are not based on seeing any real implementation or concrete design yet. Is anyone actually using this with SQL Server or another DBMS?
http://blog.fossmo.net/post/Command-and-Query-Responsibility-Segregation-(CQRS).aspx
February 14, 2011 at 9:00 am
David - long after you wrote
Does anyone have comments or experiences to relate about the CQRS pattern and its implications for the database tier? I have got some views (and some doubts) of my own but they are not based on seeing any real implementation or concrete design yet. Is anyone actually using this with SQL Server or another DBMS?
http://blog.fossmo.net/post/Command-and-Query-Responsibility-Segregation-(CQRS).aspx
http://elegantcode.com/2009/11/11/cqrs-la-greg-young/
my answer is: For more than 4 years, we have a SQL Server machinery (framework) in place that does quite arbitrary "persistent views" (using [sometimes huge] triggers and SPs that recompute query models async'ly). It works quite good and fast ... but it's definitely a complex machine. Having heard recently about CQRS, I'd like to believe that this is a viable method for the "Denormalizer" and the "Query column" in http://blog.fossmo.net/post/Command-and-Query-Responsibility-Segregation-%28CQRS%29.aspx - but I'm not sure.
Hope this "blip" on the screen makes someone curious - then I'd add more explanations; or not 🙂
Harald M.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply