{"id":82080,"date":"2010-06-08T21:54:16","date_gmt":"2010-06-08T21:54:16","guid":{"rendered":"https:\/\/www.webstaging.red-gate.com\/simple-talk\/?p=73318"},"modified":"2018-12-12T13:27:53","modified_gmt":"2018-12-12T13:27:53","slug":"perspective-in-modeling","status":"publish","type":"post","link":"https:\/\/www.red-gate.com\/simple-talk\/blogs\/perspective-in-modeling\/","title":{"rendered":"Perspective in Modeling"},"content":{"rendered":"<p>Your task, model a database that represents a suburban block.&#160; You survey the area, and see the following houses (pictures culled from Wikipedia <a href=\"http:\/\/en.wikipedia.org\/wiki\/House\" target=\"_blank\">here<\/a>)<\/p>\n<p><a href=\"http:\/\/en.wikipedia.org\/wiki\/File:Ranch_style_home_in_Salinas,_California.JPG\"><img loading=\"lazy\" decoding=\"async\" alt=\"\" src=\"https:\/\/www.webstaging.red-gate.com\/simple-talk\/wp-content\/uploads\/2017\/12\/26037_225px-Ranch_style_home_in_Salinas2C_California.jpg\" width=\"225\" height=\"169\" \/><\/a> and <a href=\"http:\/\/en.wikipedia.org\/wiki\/File:Gingerbread_House_Essex_CT.jpg\"><img loading=\"lazy\" decoding=\"async\" alt=\"\" src=\"https:\/\/www.webstaging.red-gate.com\/simple-talk\/wp-content\/uploads\/2017\/12\/26037_225px-Gingerbread_House_Essex_CT.jpg\" width=\"225\" height=\"152\" \/><\/a><\/p>\n<p>So you look at the houses, start modeling roofs, windows, lawn, driveway, mail boxes, porches, etc etc. You get done, and with your 30+ tables you are feeling great, right? I know I would be. \u201cI knocked this out of the park! We can capture everything about these houses.&#160; I\u2026am\u2026a\u2026superhero database modeler,\u201d I think, \u201cI will get a big promotion or a raise for sure! Shoot, I will get both!\u201d<\/p>\n<p>So you show this model to the client and they say, \u201cyou\u2019re fired. Do you even know what business we are in?\u201d Well, no, I suppose not.&#160; That is the lesson for the day.&#160; Perspective.&#160; Unless you realize the perspective of the client, understand the problems they want to solve, you are missing the point.<\/p>\n<p>One of my \u201cmind exercises\u201d I play when travelling in a car, or at a theme park, or at a doctor\u2019s office, etc is to think about how I could make the place better with database technology. During my family\u2019s excessive trips to Disney World, when I am the slightest bit mentally bored I think about how I could fix things. (RFID in every ticket tracking and predicting next moves, stored in a database for reevaluating how to herd people like the lunch crowd at Tech Ed, for example.)&#160; But driving through a neighborhood the other day, it really hit me.&#160; There are many different ways to look at a block of houses, apartments, flats, etc and model them for usage (in addition to basic locator information like address and perhaps longitude\/latitude).<\/p>\n<ul>\n<li>Fire Department \u2013 hydrant to home to occupant ratio<\/li>\n<li>Sales \u2013 Number of windows, roof style, lawn, age of home<\/li>\n<li>Law Enforcement \u2013 Name of occupants, previous law enforcement \u201ccontact\u201d<\/li>\n<li>Sanitation Department \u2013 Number of trash cans (including serial number for tracking), average amount of trash<\/li>\n<\/ul>\n<p>And so on, but then I thought, what about the Sanitation Department. Take a side loading trash truck (<a title=\"http:\/\/vehiclestoys.guidestobuy.com\/mack-granite-side-loading-garbage-truck\" href=\"http:\/\/vehiclestoys.guidestobuy.com\/mack-granite-side-loading-garbage-truck\">http:\/\/vehiclestoys.guidestobuy.com\/mack-granite-side-loading-garbage-truck<\/a>):<\/p>\n<blockquote>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.webstaging.red-gate.com\/simple-talk\/wp-content\/uploads\/2017\/12\/26037_41IAsq2B32BeL.jpg\" width=\"342\" height=\"186\" \/>`<\/p>\n<\/blockquote>\n<\/p>\n<p>What if they weighed the trash as the loaded it, then kept records of how they weight varied. They could predict how much trash they could pick up and change routes accordingly. How else might this information be used? The information might also be interesting to law enforcement. This single family dwelling makes 80% more trash that all of their neighbors.&#160; Is this suspicious? Does it hurt to check it out? Is this getting too big brother? Maybe, depending on how the information was used, but it certainly might be used as evidence in addition to an actual complaint. <\/p>\n<p><em>Privacy concerns aside (not that you have any privacy in your trash, right?) It will be centuries before two government organizations work together that smoothly. It can take 2 change of address forms per government agency to move from one house to another.<\/em><\/p>\n<p>In the end of this technically rather soft blog, the point is that requirements govern the design. Unless you know why the user wants you to model something, you cannot do a good job of building a database to meet their needs.&#160; Sure you can build a cool database that stores everything that you can possibly ever desire about a subject, but does it meet the needs of the user? The only way to know the needs of the user is to study them, understand them, and put yourself in their shoes. Figure out their job and build from there. Adding a few extra bells and whistles to delight the user isn\u2019t horrible sometimes, but missing the point is.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Your task, model a database that represents a suburban block.&#160; You survey the area, and see the following houses (pictures culled from Wikipedia here) and So you look at the houses, start modeling roofs, windows, lawn, driveway, mail boxes, porches, etc etc. You get done, and with your 30+ tables you are feeling great, right?&#8230;&hellip;<\/p>\n","protected":false},"author":56085,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[2],"tags":[],"coauthors":[19684],"class_list":["post-82080","post","type-post","status-publish","format-standard","hentry","category-blogs"],"acf":[],"_links":{"self":[{"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/posts\/82080","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\/56085"}],"replies":[{"embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/comments?post=82080"}],"version-history":[{"count":1,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/posts\/82080\/revisions"}],"predecessor-version":[{"id":82340,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/posts\/82080\/revisions\/82340"}],"wp:attachment":[{"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/media?parent=82080"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/categories?post=82080"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/tags?post=82080"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/coauthors?post=82080"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}