{"id":638,"date":"2009-05-05T01:55:01","date_gmt":"2009-05-05T07:55:01","guid":{"rendered":"http:\/\/gregsowell.com\/?p=638"},"modified":"2009-05-01T16:18:40","modified_gmt":"2009-05-01T22:18:40","slug":"large-scale-database-distrobution","status":"publish","type":"post","link":"https:\/\/gregsowell.com\/?p=638","title":{"rendered":"Large Scale Database Distribution"},"content":{"rendered":"<p>I was running the other day when my brain stumbled in an interesting direction.  I was thinking about how the government houses vast amounts of information about us.  Each person has to have several thousands of  lines of information in databases somewhere.  I was thinking how one could efficiently query this information in a manageable amount of time.  You could have a huge set of storage with a monster front end system, or perhaps there would be an alternative.  I then thought of how DNS works.<\/p>\n<p>If you are looking for a .com, you hit the root servers, and work your way down to the relevant server that holds the information.  If you are looking for a .org, you head in a different direction.  Why not use this same system for massive databases?<\/p>\n<p>You could store the person&#8217;s name in the &#8220;root&#8221; database server.  If you need tax information, you are directed to the &#8220;.tax&#8221; server.  If you need their arrest record, you head to the &#8220;.cops&#8221; server.  I know you could just write  nested queries or the like, but what if the back-end DB system was designed and built to do all of this for you?  You wouldn&#8217;t have thousands of programmers cranking away for hours every time they wanted to develop a system like this, it would already work like this, and you could just query the system.  I suppose you could just create views that did all of the joins and such for you&#8230;eh.<\/p>\n<p>I figure there is something already like this, or perhaps my logic is flawed&#8230;I didn&#8217;t put too much thought into it, it just seemed like an interesting concept.<\/p>\n<p>What does the peanut gallery have to say about it?<\/p>\n","protected":false},"excerpt":{"rendered":"<p>I was running the other day when my brain stumbled in an interesting direction. I was thinking about how the government houses vast amounts\u2026<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4],"tags":[],"class_list":["post-638","post","type-post","status-publish","format-standard","hentry","category-thoughts"],"_links":{"self":[{"href":"https:\/\/gregsowell.com\/index.php?rest_route=\/wp\/v2\/posts\/638","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/gregsowell.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/gregsowell.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/gregsowell.com\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/gregsowell.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=638"}],"version-history":[{"count":5,"href":"https:\/\/gregsowell.com\/index.php?rest_route=\/wp\/v2\/posts\/638\/revisions"}],"predecessor-version":[{"id":641,"href":"https:\/\/gregsowell.com\/index.php?rest_route=\/wp\/v2\/posts\/638\/revisions\/641"}],"wp:attachment":[{"href":"https:\/\/gregsowell.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=638"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/gregsowell.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=638"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/gregsowell.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=638"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}