{"id":22,"date":"2006-04-20T16:30:12","date_gmt":"2006-04-21T00:30:12","guid":{"rendered":"http:\/\/wp.colliertech.org\/cj\/?p=22"},"modified":"2006-04-20T16:41:02","modified_gmt":"2006-04-21T00:41:02","slug":"a-quick-over-view-of-rdbmss-general-place-in-the-world-and-ours-in-particular","status":"publish","type":"post","link":"https:\/\/wp.c9h.org\/cj\/?p=22","title":{"rendered":"A quick over-view of RDBMSs&#8217; general place in the world, and ours in particular"},"content":{"rendered":"<pre>[1][2][3]\r\n\r\nRDBMSs (or for clarity, Databases) are a basic element of any\r\ncomputer-based appliance in the same way as are an Operating System,\r\nWeb Server and software development platform.  As is common for\r\ndevelopers of Open Source software, I am quite familiar with Linux as\r\nthe Operating System, Apache as the Web Server, MaxDB and MySQL as\r\nDatabases and Perl (and to a lesser degree, PHP) as the software\r\ndevelopment platform.  This combination is often called the \"LAMP\"\r\nstack [4].  Take the following as coming from that background.\r\n\r\nDatabases are the storage mechanism of the content presented to the\r\nuser of any computer-based appliance.  This content may be displayed\r\nvia a desktop application or through a web browser.  The main display\r\nmechanisms I think of when writing applications are 1) Through the end\r\nusers's computer in real-time via a desktop application, in an\r\ninteractive manner.  2) Through a web server, not in real-time, via a\r\nuser's web browser (I prefer to think of Firefox[5]), often in an\r\ninteractive manner. 3) Through a portable computer device, be it a\r\ncell phone, pager, pda, or the like.  This is most commonly done in a\r\n\"broadcast\" or other non-interactive manner which does not require\r\nprocessing user feedback.  4) TV, Radio: rarely interactive.  Never in\r\nreal-time.  Always broadcast.  In this email, I will discuss the\r\ncommunication medium I'm most familiar with, case #2.\r\n\r\nThe web server is responsible for communication between your appliance\r\nand the user's web browser.  It is responsible for taking information\r\nfrom your appliance's database and delivering it to the user's\r\ncomputer, in many cases over a secure channel.  The need for a secure\r\nchannel has been growing as more of the world's population begins\r\nusing the Internet and other forms of inter-computer-networks.\r\n\"Security,\" in this use of the word, is intended to indicate a\r\nguarantee that the information that your appliance sends is the same\r\ninformation that the user's browser receives.  The word can also be\r\nused to indicate that information \"on the wire\" between your appliance\r\nand the user's personal computer can not be read.  One more use of the\r\nword is more focused on the user's perspective, and indicates that\r\nusers can validate that your appliance is who it claims to be. [6]\r\n\r\nThe software development platform is the \"glue\" between the web server\r\nand the database.  A recent software development trend [7] is to\r\nseparate logically the ideas of data \"Model,\" user's \"View,\" and\r\n\"Controller.\"  In this case of a web appliance, the data Model would\r\nbe a MySQL database, which stores content for display to the user.\r\nThe client's browser would be used to View the content, and is\r\nresponsible for initiating a connection to the web server.  The\r\nsoftware development platform Controls the mechanism which transform\r\nthe content of the database for presentation via the web server and\r\nbrowser to the user.  It is not, in my opinion, a perfect analogy, but\r\nit often fits.\r\n\r\nThe Operating System is responsible for keeping all of these pieces\r\nplaying together well on the hardware that is available.  For\r\ninstance, MySQL databases use the operating system to transfer data\r\nbetween their cache, disk, and network stack.  Web servers ask the\r\noperating system for resources such as images, html files, database\r\nconnections and network resources. [8]\r\n\r\nI hope this is a good overview of the topic.  If you have any\r\nquestions about how either of our databases might fit in to your\r\norganization, don't hesitate to give me a call at the number below.\r\n\r\nC.J.\r\n\r\n[1] http:\/\/en.wikipedia.org\/wiki\/RDBMS\r\n[2] http:\/\/en.wikipedia.org\/wiki\/MaxDB\r\n[3] http:\/\/en.wikipedia.org\/wiki\/MySQL\r\n[4] http:\/\/en.wikipedia.org\/wiki\/LAMP_(software_bundle)\r\n[5] http:\/\/en.wikipedia.org\/wiki\/Firefox\r\n[6] http:\/\/en.wikipedia.org\/wiki\/Transport_Layer_Security\r\n[7] http:\/\/en.wikipedia.org\/wiki\/Model-view-controller\r\n[8] http:\/\/en.wikipedia.org\/wiki\/Operating_System\r\n\r\n&lt;cjcollier@mysql.com&gt;, MySQL\/( AB|, Inc\\.)\/\r\nhttp:\/\/www.mysql.com\/products\/maxdb\r\nSupport Manager MaxDB\r\nPhone: +1 206 226 5809 \r\n<\/pre>\n\n<div class=\"twitter-share\"><a href=\"https:\/\/twitter.com\/intent\/tweet?via=cjamescollier\" class=\"twitter-share-button\">Tweet<\/a><\/div>\n","protected":false},"excerpt":{"rendered":"<p>[1][2][3] RDBMSs (or for clarity, Databases) are a basic element of any computer-based appliance in the same way as are an Operating System, Web Server and software development platform. As is common for developers of Open Source software, I am quite familiar with Linux as the Operating System, Apache as the Web Server, MaxDB and [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[11,12,8],"tags":[],"class_list":["post-22","post","type-post","status-publish","format-standard","hentry","category-maxdb","category-mysql","category-work"],"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/p1YDIB-m","jetpack_sharing_enabled":true,"jetpack_likes_enabled":true,"_links":{"self":[{"href":"https:\/\/wp.c9h.org\/cj\/index.php?rest_route=\/wp\/v2\/posts\/22","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/wp.c9h.org\/cj\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/wp.c9h.org\/cj\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/wp.c9h.org\/cj\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/wp.c9h.org\/cj\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=22"}],"version-history":[{"count":0,"href":"https:\/\/wp.c9h.org\/cj\/index.php?rest_route=\/wp\/v2\/posts\/22\/revisions"}],"wp:attachment":[{"href":"https:\/\/wp.c9h.org\/cj\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=22"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/wp.c9h.org\/cj\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=22"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/wp.c9h.org\/cj\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=22"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}