{"id":72899,"date":"2017-09-21T16:25:18","date_gmt":"2017-09-21T16:25:18","guid":{"rendered":"https:\/\/www.red-gate.com\/simple-talk\/?p=72899"},"modified":"2017-10-09T15:42:22","modified_gmt":"2017-10-09T15:42:22","slug":"conversations-gran-databases","status":"publish","type":"post","link":"https:\/\/www.red-gate.com\/simple-talk\/opinion\/editorials\/conversations-gran-databases\/","title":{"rendered":"Conversations with Gran about Databases"},"content":{"rendered":"<p><em>So, what&#8217;s going on in your databases world this week, young man?<\/em> I paused, as always, a little unsure of what I was getting myself into. I&#8217;d been having these little &#8220;technical chats&#8221; with Gran ever since her &#8216;computer incident&#8217;, when a blue screen informing her of a &#8220;Fatal error: <em>catastrophic failure<\/em>&#8220;, had thrown her into such a state of panic and confusion that she&#8217;d fled the room and locked the door.<\/p>\n<p>I thought it might help restore her confidence. Unwisely though, I&#8217;d strayed into explaining what I mainly did, databases, and now she wanted a weekly update. She feared for my safety, I think.<\/p>\n<p>I&#8217;d had some notable early success explaining things to her, mainly with the help of the Bible. Tables in a database were no different than the money changers&#8217; accounting tables, famously overturned (<em>John 2:13-16<\/em>). Also, I pointed out, warming to the theme, the &#8220;book, chapter and verse&#8221; reference that told us exactly what bit of the bible we meant was also used in databases, except we called it a Primary Key.<\/p>\n<p>However, there seemed only so far one could go with this, and generally, the conversations had been a minefield. She&#8217;d pick up phrases, misunderstand their meaning and generally get confused.<\/p>\n<ul>\n<li><strong>Concurrency<\/strong> \u2013 it that like a bitcoin, one of those <strong>cache invalidation<\/strong> things?<\/li>\n<li><strong>Many-to-one correspondence <\/strong>\u2013 we just called it fan mail in my day.<\/li>\n<li><strong>Crash recovery<\/strong> \u2013 yes, your granddad was in hospital for weeks. I told him he should have got <strong>cyclic protection<\/strong>. He was nearly a <strong>flat relation<\/strong>.<\/li>\n<li><strong>Dirty pages<\/strong> \u2013 well I hope you didn&#8217;t look at any of them, young man. That&#8217;s a <strong>nonrepeatable read<\/strong> if ever I heard one.<\/li>\n<li><strong>Middleware<\/strong> \u2013 it held our stomachs in, pushed various <strong>BLOB<\/strong>s up or down, and concealed your <strong>input member <\/strong>and other<strong> external predicates<\/strong>.<\/li>\n<li><strong>Dump Device <\/strong>\u2013 ours was in a shed at the bottom of the garden, down the <strong>materialized path<\/strong> and just past our ornamental <strong>buffer pool<\/strong>.<\/li>\n<li><strong>Little endian<\/strong> \u2013 He was a <strong>wide character<\/strong>. He used to hang out with that <strong>primitive operator<\/strong>, Arthur TerrorBite.<\/li>\n<li><strong>High whisker <\/strong>\u2013 don&#8217;t get me started on your granddad&#8217;s eyebrows. They were <strong>bushy joins<\/strong>, I can tell you.<\/li>\n<li><strong>Hard-coded variables<\/strong> \u2013 wouldn&#8217;t it be better to try the easy-coded ones first?<\/li>\n<\/ul>\n<p>Certain concepts, such as denormalization, or dynamic cursors, seemed so obviously fraught with difficulty that I hadn&#8217;t gone near them. I was learning to choose the battles carefully.<\/p>\n<p>Now it&#8217;s <a href=\"https:\/\/msdn.microsoft.com\/en-us\/library\/ms165911.aspx\">your turn<\/a>. What are the phrases that would confuse your gran or other <strong>base relations<\/strong>? Oh help, it&#8217;s caching.<\/p>\n<div class=\"spaced-bottom padded--tight scheme--lightest-grey\">\n<h4>Commentary Competition<\/h4>\n<p>Enjoyed the topic? Have a relevant anecdote? Disagree with the author? Leave your two cents on this post in the comments below, and our favourite response will win a $50 Amazon gift card. The competition closes two weeks from the date of publication, and the winner will be announced in the next Simple Talk newsletter.<\/p>\n<\/div>\n\n","protected":false},"excerpt":{"rendered":"<p>So, what&#8217;s going on in your databases world this week, young man? I paused, as always, a little unsure of what I was getting myself into. I&#8217;d been having these little &#8220;technical chats&#8221; with Gran ever since her &#8216;computer incident&#8217;, when a blue screen informing her of a &#8220;Fatal error: catastrophic failure&#8220;, had thrown her&#8230;&hellip;<\/p>\n","protected":false},"author":200703,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[47125],"tags":[],"coauthors":[7955],"class_list":["post-72899","post","type-post","status-publish","format-standard","hentry","category-editorials"],"acf":[],"_links":{"self":[{"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/posts\/72899","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/users\/200703"}],"replies":[{"embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/comments?post=72899"}],"version-history":[{"count":2,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/posts\/72899\/revisions"}],"predecessor-version":[{"id":72901,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/posts\/72899\/revisions\/72901"}],"wp:attachment":[{"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/media?parent=72899"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/categories?post=72899"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/tags?post=72899"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/coauthors?post=72899"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}