{"id":2,"date":"2014-01-26T21:56:51","date_gmt":"2014-01-26T21:56:51","guid":{"rendered":"http:\/\/oracle-internals.com\/blog\/?page_id=2"},"modified":"2020-04-21T20:13:24","modified_gmt":"2020-04-21T20:13:24","slug":"sample-page","status":"publish","type":"page","link":"http:\/\/oracle-internals.com\/blog\/sample-page\/","title":{"rendered":"My Research"},"content":{"rendered":"<p><strong>Overview<\/strong><br \/>\nAs a longtime database internals developer, I&#8217;ve worked on many different areas of database engine development. Given I&#8217;ve never worked on the Oracle Database, however, there are a few cool things it does that interest me. This is a summary of my academic research in those areas.<\/p>\n<p><strong>Research Methodology<\/strong><br \/>\nFrom a problem-solving standpoint, there are only so many ways to skin a cat. As such, all vendors generally solve the same computational problems in a similar fashion. While I often have a hunch about how to solve something, I like to ensure I have a solid understanding before sharing any information with others. Accordingly, my process is as follows:<\/p>\n<ol>\n<li>Play with the feature using public blogs, demos, and examples.<\/li>\n<li>Apply what I know about how the feature could be developed, from an algorithmic perspective, to how Oracle may have implemented it.<\/li>\n<li>Write personal code (<a href=\"http:\/\/oracle-internals.com\/blog\/projects\/\">My Projects<\/a>) to test my knowledge.<\/li>\n<li>Share my findings.<\/li>\n<\/ol>\n<p>In terms of sharing my findings, I generally do that based on the following:<\/p>\n<ul>\n<li>Discuss general functionality\/architecture in blogs\/conferences.<\/li>\n<li>Provide open-source tools (<a href=\"http:\/\/oracle-internals.com\/blog\/tools\/\">My Tools<\/a>) for things that are pretty simple to figure out, aren&#8217;t security-related, and which I don&#8217;t believe Oracle would consider trade secrets.<\/li>\n<\/ul>\n<hr \/>\n<h3>Storage Architecture<\/h3>\n<ul>\n<li>Oracle Block Format<\/li>\n<li>Oracle OLTP Compression<\/li>\n<li>Oracle Hybrid Columnar Compression<\/li>\n<li>ASM Internals<\/li>\n<\/ul>\n<h3>Network Protocol<\/h3>\n<ul>\n<li>Performance Optimization<\/li>\n<li>Transparent Network Substrate<\/li>\n<li>Two Task Common\/Interface<\/li>\n<\/ul>\n<h3>Memory Architecture<\/h3>\n<ul>\n<li>Shared Global Area<\/li>\n<\/ul>\n<h3>Data Access Components<\/h3>\n<ul>\n<li>Precompiler Compilation Unit Data (CUD)<\/li>\n<li>Oracle Call Interface<\/li>\n<li>User Programmatic Interface<\/li>\n<li>SQLLIB Interface<\/li>\n<\/ul>\n<h3>Utility File Formats<\/h3>\n<ul>\n<li>Oracle Messages Binary (MSB)<\/li>\n<li>Export File Format (DMP\/EXP)<\/li>\n<li>Data Dump File Format<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Overview As a longtime database internals developer, I&#8217;ve worked on many different areas of database engine development. Given I&#8217;ve never worked on the Oracle Database, however, there are a few cool things it does that interest me. This is a summary of my academic research in those areas. Research Methodology From a problem-solving standpoint, there [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"open","ping_status":"open","template":"","meta":{"footnotes":""},"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v22.8 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>My Research - Oracle Internals<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/oracle-internals.com\/blog\/sample-page\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"My Research - Oracle Internals\" \/>\n<meta property=\"og:description\" content=\"Overview As a longtime database internals developer, I&#8217;ve worked on many different areas of database engine development. Given I&#8217;ve never worked on the Oracle Database, however, there are a few cool things it does that interest me. This is a summary of my academic research in those areas. Research Methodology From a problem-solving standpoint, there [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/oracle-internals.com\/blog\/sample-page\/\" \/>\n<meta property=\"og:site_name\" content=\"Oracle Internals\" \/>\n<meta property=\"article:modified_time\" content=\"2020-04-21T20:13:24+00:00\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:site\" content=\"@jonahharris\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/oracle-internals.com\/blog\/sample-page\/\",\"url\":\"https:\/\/oracle-internals.com\/blog\/sample-page\/\",\"name\":\"My Research - Oracle Internals\",\"isPartOf\":{\"@id\":\"https:\/\/oracle-internals.com\/blog\/#website\"},\"datePublished\":\"2014-01-26T21:56:51+00:00\",\"dateModified\":\"2020-04-21T20:13:24+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/oracle-internals.com\/blog\/sample-page\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/oracle-internals.com\/blog\/sample-page\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/oracle-internals.com\/blog\/sample-page\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/oracle-internals.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"My Research\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/oracle-internals.com\/blog\/#website\",\"url\":\"https:\/\/oracle-internals.com\/blog\/\",\"name\":\"Oracle Internals\",\"description\":\"Researching the Inner Workings of the World&#039;s Most Powerful Database\",\"publisher\":{\"@id\":\"https:\/\/oracle-internals.com\/blog\/#\/schema\/person\/549d9c522c3960b062618b600bb762a4\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/oracle-internals.com\/blog\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/oracle-internals.com\/blog\/#\/schema\/person\/549d9c522c3960b062618b600bb762a4\",\"name\":\"Jonah Harris\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/oracle-internals.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"http:\/\/1.gravatar.com\/avatar\/a6d16ed0f510e8de0929f129471dc1e5?s=96&d=mm&r=g\",\"contentUrl\":\"http:\/\/1.gravatar.com\/avatar\/a6d16ed0f510e8de0929f129471dc1e5?s=96&d=mm&r=g\",\"caption\":\"Jonah Harris\"},\"logo\":{\"@id\":\"https:\/\/oracle-internals.com\/blog\/#\/schema\/person\/image\/\"},\"sameAs\":[\"https:\/\/www.linkedin.com\/in\/jonahharris\/\",\"https:\/\/x.com\/jonahharris\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"My Research - Oracle Internals","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/oracle-internals.com\/blog\/sample-page\/","og_locale":"en_US","og_type":"article","og_title":"My Research - Oracle Internals","og_description":"Overview As a longtime database internals developer, I&#8217;ve worked on many different areas of database engine development. Given I&#8217;ve never worked on the Oracle Database, however, there are a few cool things it does that interest me. This is a summary of my academic research in those areas. Research Methodology From a problem-solving standpoint, there [&hellip;]","og_url":"https:\/\/oracle-internals.com\/blog\/sample-page\/","og_site_name":"Oracle Internals","article_modified_time":"2020-04-21T20:13:24+00:00","twitter_card":"summary_large_image","twitter_site":"@jonahharris","twitter_misc":{"Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/oracle-internals.com\/blog\/sample-page\/","url":"https:\/\/oracle-internals.com\/blog\/sample-page\/","name":"My Research - Oracle Internals","isPartOf":{"@id":"https:\/\/oracle-internals.com\/blog\/#website"},"datePublished":"2014-01-26T21:56:51+00:00","dateModified":"2020-04-21T20:13:24+00:00","breadcrumb":{"@id":"https:\/\/oracle-internals.com\/blog\/sample-page\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/oracle-internals.com\/blog\/sample-page\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/oracle-internals.com\/blog\/sample-page\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/oracle-internals.com\/blog\/"},{"@type":"ListItem","position":2,"name":"My Research"}]},{"@type":"WebSite","@id":"https:\/\/oracle-internals.com\/blog\/#website","url":"https:\/\/oracle-internals.com\/blog\/","name":"Oracle Internals","description":"Researching the Inner Workings of the World&#039;s Most Powerful Database","publisher":{"@id":"https:\/\/oracle-internals.com\/blog\/#\/schema\/person\/549d9c522c3960b062618b600bb762a4"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/oracle-internals.com\/blog\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/oracle-internals.com\/blog\/#\/schema\/person\/549d9c522c3960b062618b600bb762a4","name":"Jonah Harris","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/oracle-internals.com\/blog\/#\/schema\/person\/image\/","url":"http:\/\/1.gravatar.com\/avatar\/a6d16ed0f510e8de0929f129471dc1e5?s=96&d=mm&r=g","contentUrl":"http:\/\/1.gravatar.com\/avatar\/a6d16ed0f510e8de0929f129471dc1e5?s=96&d=mm&r=g","caption":"Jonah Harris"},"logo":{"@id":"https:\/\/oracle-internals.com\/blog\/#\/schema\/person\/image\/"},"sameAs":["https:\/\/www.linkedin.com\/in\/jonahharris\/","https:\/\/x.com\/jonahharris"]}]}},"_links":{"self":[{"href":"http:\/\/oracle-internals.com\/blog\/wp-json\/wp\/v2\/pages\/2"}],"collection":[{"href":"http:\/\/oracle-internals.com\/blog\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"http:\/\/oracle-internals.com\/blog\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"http:\/\/oracle-internals.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/oracle-internals.com\/blog\/wp-json\/wp\/v2\/comments?post=2"}],"version-history":[{"count":6,"href":"http:\/\/oracle-internals.com\/blog\/wp-json\/wp\/v2\/pages\/2\/revisions"}],"predecessor-version":[{"id":147,"href":"http:\/\/oracle-internals.com\/blog\/wp-json\/wp\/v2\/pages\/2\/revisions\/147"}],"wp:attachment":[{"href":"http:\/\/oracle-internals.com\/blog\/wp-json\/wp\/v2\/media?parent=2"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}