{"id":113,"date":"2011-03-30T09:29:14","date_gmt":"2011-03-30T14:29:14","guid":{"rendered":"http:\/\/www.mcneelytech.com\/blog1\/?p=113"},"modified":"2024-06-18T12:55:30","modified_gmt":"2024-06-18T17:55:30","slug":"database-shampoo","status":"publish","type":"post","link":"http:\/\/www.mcneelytech.com\/blog1\/?p=113","title":{"rendered":"Database Shampoo?"},"content":{"rendered":"<p>There\u2019s a genre of hair products called normalizing shampoos.&nbsp; The general idea is that they clean the oil away but still don\u2019t dry out your hair too badly.&nbsp; I\u2019ve used a certain normalizing shampoo for years, but, alas, the brand has finally been discontinued.&nbsp; I\u2019m almost done with the last bottle I have, and I\u2019d like to memorialize my beloved normalizing shampoo with some parting philosophical questions.<\/p>\n<p>I wonder how the shampoo has helped me over the years.&nbsp; Has my hair reached fifth normal form?&nbsp; What would that look like?&nbsp; And how long did it take?&nbsp; A week?&nbsp; A year?&nbsp; Did it work faster for me because I\u2019m a database specialist?&nbsp; What happens if a statistician uses it?&nbsp; A ballerina?&nbsp; Can red hair achieve 5NF?&nbsp; Really long hair?&nbsp; Dreadlocks?<\/p>\n<p>Does Chris Date know about normalizing shampoo, and does he approve?&nbsp; (The answer might depend on the shampoo\u2019s policy on nulls.&nbsp; Mr. Date is quite opinionated about nulls.)&nbsp; Is E. F. Codd spinning in his grave?<\/p>\n<p>What will happen when I stop using the shampoo?&nbsp; Will my hair lose all normal form?&nbsp; Will repeating groups tumble down my shoulders and back?&nbsp; Will newly emboldened non-2NF-compliant keys stop cowering behind the conditioner bottle and leap into my ears?&nbsp; Will transitive dependencies accumulate on the shower curtain, causing an odd odor?<\/p>\n<p>Do any of my database friends out there have any perspective on these things?&nbsp; As I begin the switch to a moisturizing shampoo, I\u2019d like to know what to expect on the journey ahead.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>There\u2019s a genre of hair products called normalizing shampoos.&nbsp; The general idea is that they clean the oil away but still don\u2019t dry out your hair too badly.&nbsp; I\u2019ve used a certain normalizing shampoo for years, but, alas, the brand has finally been discontinued.&nbsp; I\u2019m almost done with the last bottle I have, and I\u2019d [&#8230;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-113","post","type-post","status-publish","format-standard","hentry","category-uncategorized","odd"],"_links":{"self":[{"href":"http:\/\/www.mcneelytech.com\/blog1\/index.php?rest_route=\/wp\/v2\/posts\/113","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.mcneelytech.com\/blog1\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.mcneelytech.com\/blog1\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.mcneelytech.com\/blog1\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.mcneelytech.com\/blog1\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=113"}],"version-history":[{"count":2,"href":"http:\/\/www.mcneelytech.com\/blog1\/index.php?rest_route=\/wp\/v2\/posts\/113\/revisions"}],"predecessor-version":[{"id":258,"href":"http:\/\/www.mcneelytech.com\/blog1\/index.php?rest_route=\/wp\/v2\/posts\/113\/revisions\/258"}],"wp:attachment":[{"href":"http:\/\/www.mcneelytech.com\/blog1\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=113"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.mcneelytech.com\/blog1\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=113"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.mcneelytech.com\/blog1\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=113"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}