Timeline for How could you reconcile declarative database development and non-trivial data 'motions'?
Current License: CC BY-SA 3.0
13 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Sep 5, 2022 at 12:38 | answer | added | Steve | timeline score: 1 | |
| Apr 13, 2017 at 12:42 | history | edited | CommunityBot |
replaced http://dba.stackexchange.com/ with https://dba.stackexchange.com/
|
|
| Aug 11, 2012 at 20:53 | answer | added | Michael Brown | timeline score: 1 | |
| Aug 11, 2012 at 11:52 | comment | added | Benjol | @DocBrown, I've 'relaxed' my theoretical 'requirements' to also accept solutions with non-declarative data migrations, but which can be elegantly combined. | |
| Aug 11, 2012 at 11:51 | history | edited | Benjol | CC BY-SA 3.0 |
added 91 characters in body
|
| Aug 11, 2012 at 11:44 | comment | added | NoChance | @DocBrown, you may be right. I was not sure of what input could represent a valid declarative specification. Most of the terms in this post are a bit vague to me to be honest. | |
| Aug 11, 2012 at 11:36 | comment | added | Doc Brown | @EmmadKareem: nice link. Having a short look into features of Liquibase (the first tool mentioned in your link), it shows that the feature for non-trivial "data motions" contained in that tool is "apply a custom SQL". Is that a "declarative solution"? I am not sure. | |
| Aug 11, 2012 at 11:10 | history | tweeted | twitter.com/#!/StackProgrammer/status/234245500264652800 | ||
| Aug 11, 2012 at 11:04 | comment | added | NoChance | You may want to take a look at: bartling.blogspot.com/2011/02/agile-database-modeling.html | |
| Aug 11, 2012 at 10:56 | answer | added | Doc Brown | timeline score: 3 | |
| Aug 11, 2012 at 10:08 | comment | added | Doc Brown | Typical changes may be simple, so the data migration could be defined declaratively, I am sure, but the requirements can also become quite complex, so the "data motion" will need a special in the processing, manual refinement or performance optimization. | |
| Aug 11, 2012 at 10:05 | comment | added | Doc Brown | I am pretty sure there must exist some sort of research about this topic (since it is an old one), though I don't know any references. But having developed some real-world databases with the need of structural changes from release to release, I guess there will be no general solution. | |
| Aug 11, 2012 at 9:49 | history | asked | Benjol | CC BY-SA 3.0 |