{"id":24657,"date":"2015-08-26T16:36:55","date_gmt":"2015-08-26T14:36:55","guid":{"rendered":"https:\/\/mamchenkov.net\/wordpress\/?p=24657"},"modified":"2015-08-26T16:36:55","modified_gmt":"2015-08-26T14:36:55","slug":"how-does-a-relational-database-work","status":"publish","type":"post","link":"https:\/\/mamchenkov.net\/wordpress\/2015\/08\/26\/how-does-a-relational-database-work\/","title":{"rendered":"How does a relational database work"},"content":{"rendered":"\n

\"databases\"<\/a><\/p>\n

“How does a relational database work<\/a>” is an excellent (lengthy, technical, but simply written and well explained) article on some of the most important bits inside the relational database. \u00a0It’s somewhat of a middle ground between a theoretical database discussion in college and vendor-specific documentation of a database engine.<\/p>\n

Though the title of this article is explicit, the aim of this article is NOT\u00a0to understand how to use a database<\/strong>. Therefore, you should already know how to write a simple join query and basic CRUD queries<\/strong>; otherwise you might not understand this article. This is the only thing you need to know<\/strong>, I\u2019ll explain everything else.<\/p>\n

I\u2019ll start with some computer science stuff like time complexity. I know that some of you hate this concept but, without it, you can\u2019t understand the cleverness inside a database. Since it\u2019s a huge topic, I\u2019ll focus on<\/strong> what I think is essential: the way a database handles an SQL query<\/strong>. I\u2019ll only present the basic concepts behind a database<\/strong> so that at the end of the article you\u2019ll have a good idea of what\u2019s happening under the hood<\/strong>.<\/p><\/blockquote>\n

Whether you are a young programmer or an experienced DBA, I think, you’ll still find something in there which you either didn’t know or didn’t think about in this particular way. \u00a0 Even if you know all this stuff, it’s a good memory refresher.<\/p>\n

Strongly recommended!<\/p>\n\n","protected":false},"excerpt":{"rendered":"\n

“How does a relational database work” is an excellent (lengthy, technical, but simply written and well explained) article on some of the most important bits inside the relational database. \u00a0It’s somewhat of a middle ground between a theoretical database discussion in college and vendor-specific documentation of a database engine. Though the title of this article … Continue reading How does a relational database work<\/span><\/a><\/p>\n\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"How does a relational database work #databases #WebDev #ComputerScience","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2},"_links_to":"","_links_to_target":""},"categories":[1,18,62],"tags":[1192,1559,1330],"keyring_services":[],"class_list":["post-24657","post","type-post","status-publish","format-standard","hentry","category-general","category-programming","category-technology","tag-computer-science","tag-databases","tag-web-development"],"aioseo_notices":[],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack-related-posts":[{"id":27949,"url":"https:\/\/mamchenkov.net\/wordpress\/2017\/09\/06\/grakn-and-graql-a-database-for-ai\/","url_meta":{"origin":24657,"position":0},"title":"Grakn and Graql – a database for AI","author":"Leonid Mamchenkov","date":"September 6, 2017","format":false,"excerpt":"From the grakn.ai website: Grakn\u00a0is a distributed\u00a0hyper-relational\u00a0database for knowledge-oriented systems. Grakn enables machines to manage complex data that serves as a knowledge base for cognitive\/AI systems. Graql\u00a0is Grakn's reasoning (through OLTP) and analytics (through OLAP) query language. Graql is a much higher level abstraction over traditional query language - SQL,\u2026","rel":"","context":"In "All"","block_context":{"text":"All","link":"https:\/\/mamchenkov.net\/wordpress\/category\/general\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":25946,"url":"https:\/\/mamchenkov.net\/wordpress\/2016\/03\/16\/aws-database-migration-service\/","url_meta":{"origin":24657,"position":1},"title":"AWS Database Migration Service","author":"Leonid Mamchenkov","date":"March 16, 2016","format":false,"excerpt":"AWS Database Migration Service is yet another one of those tools that you always wished that somebody created, but never actually got to checking if it exists. \u00a0Here is a recent blog post showcasing the functionality. Do you currently store relational data in an on-premises Oracle, SQL Server, MySQL, MariaDB,\u2026","rel":"","context":"In "All"","block_context":{"text":"All","link":"https:\/\/mamchenkov.net\/wordpress\/category\/general\/"},"img":{"alt_text":"AWS Database Migration Service","src":"https:\/\/i0.wp.com\/mamchenkov.net\/wordpress\/wp-content\/uploads\/2016\/03\/dms_connect_endpoints_filled_3-500x409.png?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]},{"id":11628,"url":"https:\/\/mamchenkov.net\/wordpress\/2009\/07\/09\/learning-wordpress-files-and-database\/","url_meta":{"origin":24657,"position":2},"title":"Learning WordPress : files and database","author":"Leonid Mamchenkov","date":"July 9, 2009","format":false,"excerpt":"There are a numerous blog posts and forum discussion about WordPress.\u00a0 However you can read all of them back and forward and still not know how the system works.\u00a0 If you seek the real understanding of WordPress, there are two and two things only that you need to go through\u2026","rel":"","context":"In "All"","block_context":{"text":"All","link":"https:\/\/mamchenkov.net\/wordpress\/category\/general\/"},"img":{"alt_text":"WordPress at PHPXref.com","src":"https:\/\/i0.wp.com\/mamchenkov.net\/wordpress\/wp-content\/uploads\/2009\/07\/wordpress_source_code.jpg?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]},{"id":11605,"url":"https:\/\/mamchenkov.net\/wordpress\/2009\/06\/24\/understanding-wordpress-database-in-10-minutes\/","url_meta":{"origin":24657,"position":3},"title":"Understanding WordPress database in 10 minutes","author":"Leonid Mamchenkov","date":"June 24, 2009","format":false,"excerpt":"Almost two years ago I wrote a blog post titled \"A look inside the WordPress database\".\u00a0 While a lot of people enjoyed it (and, apparently still do, even though it's a bit outdated), I think it could be greatly simplified.\u00a0 And it will probably take you less time to understand\u2026","rel":"","context":"In "All"","block_context":{"text":"All","link":"https:\/\/mamchenkov.net\/wordpress\/category\/general\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":24008,"url":"https:\/\/mamchenkov.net\/wordpress\/2015\/04\/27\/schemaspy-graphical-database-schema-metadata-browser\/","url_meta":{"origin":24657,"position":4},"title":"SchemaSpy – Graphical Database Schema Metadata Browser","author":"Leonid Mamchenkov","date":"April 27, 2015","format":"link","excerpt":"SchemaSpy - Graphical Database Schema Metadata Browser. \u00a0This is a tool written in Java that helps one to generate database schema documentation. \u00a0Have a look at some sample pages. \u00a0Those familiar with Graphviz will immediately realize that the tools is using dot for graphing tables and their relationships. \u00a0Those familiar\u2026","rel":"","context":"In "All"","block_context":{"text":"All","link":"https:\/\/mamchenkov.net\/wordpress\/category\/general\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":27005,"url":"https:\/\/mamchenkov.net\/wordpress\/2016\/11\/29\/magento-database-maintenance\/","url_meta":{"origin":24657,"position":5},"title":"Magento database maintenance","author":"Leonid Mamchenkov","date":"November 29, 2016","format":false,"excerpt":"If you are running a Magento-based website, make sure you add the database maintenance script to the cron. \u00a0For example, append this to the \/etc\/crontab: Thanks to this page, obviously. \u00a0You'll be surprised how much leaner your database will be, especially if you get any kind of traffic to the\u2026","rel":"","context":"In "All"","block_context":{"text":"All","link":"https:\/\/mamchenkov.net\/wordpress\/category\/general\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"jetpack_sharing_enabled":true,"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/mamchenkov.net\/wordpress\/wp-json\/wp\/v2\/posts\/24657","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/mamchenkov.net\/wordpress\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/mamchenkov.net\/wordpress\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/mamchenkov.net\/wordpress\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/mamchenkov.net\/wordpress\/wp-json\/wp\/v2\/comments?post=24657"}],"version-history":[{"count":0,"href":"https:\/\/mamchenkov.net\/wordpress\/wp-json\/wp\/v2\/posts\/24657\/revisions"}],"wp:attachment":[{"href":"https:\/\/mamchenkov.net\/wordpress\/wp-json\/wp\/v2\/media?parent=24657"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/mamchenkov.net\/wordpress\/wp-json\/wp\/v2\/categories?post=24657"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/mamchenkov.net\/wordpress\/wp-json\/wp\/v2\/tags?post=24657"},{"taxonomy":"keyring_services","embeddable":true,"href":"https:\/\/mamchenkov.net\/wordpress\/wp-json\/wp\/v2\/keyring_services?post=24657"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}