{"id":8355,"date":"2020-03-25T17:28:44","date_gmt":"2020-03-26T00:28:44","guid":{"rendered":"https:\/\/www.couchbase.com\/blog\/?p=8355"},"modified":"2025-12-18T08:43:03","modified_gmt":"2025-12-18T16:43:03","slug":"couchbase-for-oracle-developers-part-4-data-types","status":"publish","type":"post","link":"https:\/\/www.couchbase.com\/blog\/couchbase-for-oracle-developers-part-4-data-types\/","title":{"rendered":"Couchbase for Oracle Developers \u2013 Part 4 : Data types"},"content":{"rendered":"<p>Link to the series home page: <a href=\"https:\/\/www.couchbase.com\/blog\/couchbase-oracle-developers-part-2-architecture\/\">https:\/\/www.couchbase.com\/blog\/couchbase-oracle-developers-part-2-architecture\/<\/a><\/p>\n<p>As part of data remodeling, while moving from the relational model to the JSON model, you&#8217;ll have to consider the data type mapping. In Oracle, you&#8217;ll have to create and declare the types of each column explicitly before you load the data or write queries. In Couchbase, you simply conform to JSON syntax and the data type interpretation is automatic and implicit. Here&#8217;s the overview of mappings, conversion, and arithmetic on these data types.<a href=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/2020\/03\/Screen-Shot-2020-03-24-at-4.30.33-PM.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-8356\" src=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/2020\/03\/Screen-Shot-2020-03-24-at-4.30.33-PM-300x170.png\" alt=\"\" width=\"902\" height=\"511\" srcset=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2020\/03\/Screen-Shot-2020-03-24-at-4.30.33-PM-300x170.png 300w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2020\/03\/Screen-Shot-2020-03-24-at-4.30.33-PM-768x436.png 768w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2020\/03\/Screen-Shot-2020-03-24-at-4.30.33-PM-20x11.png 20w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2020\/03\/Screen-Shot-2020-03-24-at-4.30.33-PM.png 1852w\" sizes=\"auto, (max-width: 902px) 100vw, 902px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<table border=\"1\" width=\"100%\" cellpadding=\"8\" cellspacing=\"0\">\n<thead>\n<tr>\n<th>Feature<\/th>\n<th>\n        <a href=\"https:\/\/www.oracle.com\/database\/\" target=\"_blank\"><b>Oracle<\/b><\/a>\n      <\/th>\n<th>\n        <a href=\"https:\/\/www.couchbase.com\/\" target=\"_blank\"><b>Couchbase<\/b><\/a>\n      <\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td><b>Model<\/b><\/td>\n<td>Relational, Object-relational<\/td>\n<td>JSON model with N1QL (SQL for JSON)<\/td>\n<\/tr>\n<tr>\n<td><b>Data Types<\/b><\/td>\n<td>\n        <a href=\"https:\/\/docs.oracle.com\/en\/database\/oracle\/oracle-database\/18\/sqlrf\/Data-Types.html#GUID-A3C0D836-BADB-44E5-A5D4-265BA5968483\" target=\"_blank\"><br \/>\n          Oracle Data Types Reference<br \/>\n        <\/a>\n      <\/td>\n<td>\n        <a href=\"https:\/\/docs.couchbase.com\/server\/current\/n1ql\/n1ql-language-reference\/datatypes.html\" target=\"_blank\"><br \/>\n          Couchbase Data Types Reference<br \/>\n        <\/a>\n      <\/td>\n<\/tr>\n<tr>\n<td><b>String Data Types<\/b><\/td>\n<td>CHAR, VARCHAR, VARCHAR2, NCHAR, NVARCHAR, LONGVARCHAR<\/td>\n<td>String (Unicode), up to 20 MB<\/td>\n<\/tr>\n<tr>\n<td><b>Date &amp; Time Data Types<\/b><\/td>\n<td>DATE, TIME, TIMESTAMP (with timezone), INTERVAL<\/td>\n<td>\n        ISO-8601 strings with N1QL date functions<br \/>\n        <a href=\"https:\/\/www.couchbase.com\/blog\/dates-timestamps-timezones-comparative-study-oracle-n1ql-support-date-time-feature-part-1\/\" target=\"_blank\"><br \/>\n          Detailed article<br \/>\n        <\/a>\n      <\/td>\n<\/tr>\n<tr>\n<td><b>Boolean<\/b><\/td>\n<td>BOOLEAN<\/td>\n<td>true \/ false<\/td>\n<\/tr>\n<tr>\n<td><b>Numerical<\/b><\/td>\n<td>\n        NUMBER, DECIMAL, BIGINT, SMALLINT, INTEGER, FLOAT, REAL, DOUBLE\n      <\/td>\n<td>\n        Integer, fractional, exponential values<br \/>\n        <a href=\"https:\/\/docs.couchbase.com\/server\/current\/analytics\/9_data_type.html\" target=\"_blank\"><br \/>\n          Numeric ranges<br \/>\n        <\/a>\n      <\/td>\n<\/tr>\n<tr>\n<td><b>Binary Data Types<\/b><\/td>\n<td>BINARY, VARBINARY, LONGVARBINARY<\/td>\n<td>Binary document or Base64 encoded values<\/td>\n<\/tr>\n<tr>\n<td><b>Large Object Data Types<\/b><\/td>\n<td>BLOB, RAW, LONG_RAW, CLOB<\/td>\n<td>Each document up to 20 MB<\/td>\n<\/tr>\n<tr>\n<td><b>Objects<\/b><\/td>\n<td>\n        User-defined object types<br \/>\n        <a href=\"https:\/\/docs.oracle.com\/en\/database\/oracle\/oracle-database\/18\/adobj\/key-features-object-relational-model.html\" target=\"_blank\"><br \/>\n          Oracle Object Types<br \/>\n        <\/a>\n      <\/td>\n<td>Native JSON objects with unlimited nesting<\/td>\n<\/tr>\n<tr>\n<td><b>Arrays<\/b><\/td>\n<td>\n        VARRAY with predefined type<br \/>\n        <a href=\"https:\/\/docs.oracle.com\/cd\/B28359_01\/appdev.111\/b28371\/adobjcol.htm#i468598\" target=\"_blank\"><br \/>\n          VARRAY documentation<br \/>\n        <\/a>\n      <\/td>\n<td>\n        First-class JSON arrays of mixed types<br \/>\n        &#8220;A&#8221;: [1, &#8220;X&#8221;, [3, 4]]<br \/>\n        &#8220;B&#8221;: [{&#8220;x&#8221;:1}, {&#8220;x&#8221;:2}]\n      <\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>&nbsp;<\/p>\n<p><strong>Additional Notes<\/strong><\/p>\n<p><strong>Date and Datetime types.<\/strong><\/p>\n<p>Oracle and other RDBMS have extensive data types for handling time-related data and manipulating them. JSON does not have a date or datetime type.\u00a0 \u00a0We&#8217;ve chosen the <a href=\"https:\/\/www.w3.org\/TR\/NOTE-datetime\">ISO 8601<\/a> . The idea is to store the date &amp; time related data in a string form, conforming to ISO 8601 and then manipulating it in a consistent way.<\/p>\n<p><strong>Primary key to Document key conversion.<\/strong><\/p>\n<p>Couchbase document key is always less than 255 bytes and is usually a string. RDBMS can have a single column or multiple columns (composite) primary key for a table. One common way convert is to simply have a separator between the individual parts after converting each part to a string. The document key should be unique to a bucket and hence it&#8217;s typically prefixed with the table (collection) type.\u00a0 See the <a href=\"https:\/\/www.couchbase.com\/blog\/data-migration-from-oracle-to-couchbase\/\">blog with examples<\/a> of how to do this correctly.<\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Link to the series home page: https:\/\/www.couchbase.com\/blog\/couchbase-oracle-developers-part-2-architecture\/ As part of data remodeling, while moving from the relational model to the JSON model, you&#8217;ll have to consider the data type mapping. In Oracle, you&#8217;ll have to create and declare the types [&hellip;]<\/p>\n","protected":false},"author":55,"featured_media":13873,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"inline_featured_image":false,"footnotes":""},"categories":[2294,1816,1819,1812],"tags":[1883,1592],"ppma_author":[8929],"class_list":["post-8355","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-analytics","category-couchbase-server","category-data-modeling","category-n1ql-query","tag-data-modelling","tag-oracle"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v26.5 (Yoast SEO v26.5) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Couchbase for Oracle Developers \u2013 Part 4 : Data types - The Couchbase Blog<\/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:\/\/www.couchbase.com\/blog\/couchbase-for-oracle-developers-part-4-data-types\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Couchbase for Oracle Developers \u2013 Part 4 : Data types\" \/>\n<meta property=\"og:description\" content=\"Link to the series home page: https:\/\/www.couchbase.com\/blog\/couchbase-oracle-developers-part-2-architecture\/ As part of data remodeling, while moving from the relational model to the JSON model, you&#8217;ll have to consider the data type mapping. In Oracle, you&#8217;ll have to create and declare the types [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.couchbase.com\/blog\/couchbase-for-oracle-developers-part-4-data-types\/\" \/>\n<meta property=\"og:site_name\" content=\"The Couchbase Blog\" \/>\n<meta property=\"article:published_time\" content=\"2020-03-26T00:28:44+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-12-18T16:43:03+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2020\/03\/Screen-Shot-2020-03-24-at-4.30.33-PM.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1852\" \/>\n\t<meta property=\"og:image:height\" content=\"1052\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Keshav Murthy\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@rkeshavmurthy\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Keshav Murthy\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/couchbase-for-oracle-developers-part-4-data-types\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/couchbase-for-oracle-developers-part-4-data-types\/\"},\"author\":{\"name\":\"Keshav Murthy\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/#\/schema\/person\/c261644262bf98e146372fe647682636\"},\"headline\":\"Couchbase for Oracle Developers \u2013 Part 4 : Data types\",\"datePublished\":\"2020-03-26T00:28:44+00:00\",\"dateModified\":\"2025-12-18T16:43:03+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/couchbase-for-oracle-developers-part-4-data-types\/\"},\"wordCount\":381,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/couchbase-for-oracle-developers-part-4-data-types\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2022\/11\/couchbase-nosql-dbaas.png\",\"keywords\":[\"data modelling\",\"oracle\"],\"articleSection\":[\"Couchbase Analytics\",\"Couchbase Server\",\"Data Modeling\",\"SQL++ \/ N1QL Query\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.couchbase.com\/blog\/couchbase-for-oracle-developers-part-4-data-types\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/couchbase-for-oracle-developers-part-4-data-types\/\",\"url\":\"https:\/\/www.couchbase.com\/blog\/couchbase-for-oracle-developers-part-4-data-types\/\",\"name\":\"Couchbase for Oracle Developers \u2013 Part 4 : Data types - The Couchbase Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/couchbase-for-oracle-developers-part-4-data-types\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/couchbase-for-oracle-developers-part-4-data-types\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2022\/11\/couchbase-nosql-dbaas.png\",\"datePublished\":\"2020-03-26T00:28:44+00:00\",\"dateModified\":\"2025-12-18T16:43:03+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/couchbase-for-oracle-developers-part-4-data-types\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.couchbase.com\/blog\/couchbase-for-oracle-developers-part-4-data-types\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/couchbase-for-oracle-developers-part-4-data-types\/#primaryimage\",\"url\":\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2022\/11\/couchbase-nosql-dbaas.png\",\"contentUrl\":\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2022\/11\/couchbase-nosql-dbaas.png\",\"width\":1800,\"height\":630},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/couchbase-for-oracle-developers-part-4-data-types\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.couchbase.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Couchbase for Oracle Developers \u2013 Part 4 : Data types\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/#website\",\"url\":\"https:\/\/www.couchbase.com\/blog\/\",\"name\":\"The Couchbase Blog\",\"description\":\"Couchbase, the NoSQL Database\",\"publisher\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.couchbase.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/#organization\",\"name\":\"The Couchbase Blog\",\"url\":\"https:\/\/www.couchbase.com\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/2023\/04\/admin-logo.png\",\"contentUrl\":\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/2023\/04\/admin-logo.png\",\"width\":218,\"height\":34,\"caption\":\"The Couchbase Blog\"},\"image\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/#\/schema\/person\/c261644262bf98e146372fe647682636\",\"name\":\"Keshav Murthy\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/#\/schema\/person\/image\/4e51d72fc07c662aa791316deafffac4\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/af74df754db27152971d0aed2f323ead5a1f9fe5afd0209af91e12e784451224?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/af74df754db27152971d0aed2f323ead5a1f9fe5afd0209af91e12e784451224?s=96&d=mm&r=g\",\"caption\":\"Keshav Murthy\"},\"description\":\"Keshav Murthy is a Vice President at Couchbase R&amp;D. Previously, he was at MapR, IBM, Informix, Sybase, with more than 20 years of experience in database design &amp; development. He lead the SQL and NoSQL R&amp;D team at IBM Informix. He has received two President's Club awards at Couchbase, two Outstanding Technical Achievement Awards at IBM. Keshav has a bachelor's degree in Computer Science and Engineering from the University of Mysore, India, and has received twenty four US patents.\",\"sameAs\":[\"https:\/\/blog.planetnosql.com\/\",\"https:\/\/x.com\/rkeshavmurthy\"],\"url\":\"https:\/\/www.couchbase.com\/blog\/author\/keshav-murthy\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Couchbase for Oracle Developers \u2013 Part 4 : Data types - The Couchbase Blog","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:\/\/www.couchbase.com\/blog\/couchbase-for-oracle-developers-part-4-data-types\/","og_locale":"en_US","og_type":"article","og_title":"Couchbase for Oracle Developers \u2013 Part 4 : Data types","og_description":"Link to the series home page: https:\/\/www.couchbase.com\/blog\/couchbase-oracle-developers-part-2-architecture\/ As part of data remodeling, while moving from the relational model to the JSON model, you&#8217;ll have to consider the data type mapping. In Oracle, you&#8217;ll have to create and declare the types [&hellip;]","og_url":"https:\/\/www.couchbase.com\/blog\/couchbase-for-oracle-developers-part-4-data-types\/","og_site_name":"The Couchbase Blog","article_published_time":"2020-03-26T00:28:44+00:00","article_modified_time":"2025-12-18T16:43:03+00:00","og_image":[{"width":1852,"height":1052,"url":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2020\/03\/Screen-Shot-2020-03-24-at-4.30.33-PM.png","type":"image\/png"}],"author":"Keshav Murthy","twitter_card":"summary_large_image","twitter_creator":"@rkeshavmurthy","twitter_misc":{"Written by":"Keshav Murthy","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.couchbase.com\/blog\/couchbase-for-oracle-developers-part-4-data-types\/#article","isPartOf":{"@id":"https:\/\/www.couchbase.com\/blog\/couchbase-for-oracle-developers-part-4-data-types\/"},"author":{"name":"Keshav Murthy","@id":"https:\/\/www.couchbase.com\/blog\/#\/schema\/person\/c261644262bf98e146372fe647682636"},"headline":"Couchbase for Oracle Developers \u2013 Part 4 : Data types","datePublished":"2020-03-26T00:28:44+00:00","dateModified":"2025-12-18T16:43:03+00:00","mainEntityOfPage":{"@id":"https:\/\/www.couchbase.com\/blog\/couchbase-for-oracle-developers-part-4-data-types\/"},"wordCount":381,"commentCount":0,"publisher":{"@id":"https:\/\/www.couchbase.com\/blog\/#organization"},"image":{"@id":"https:\/\/www.couchbase.com\/blog\/couchbase-for-oracle-developers-part-4-data-types\/#primaryimage"},"thumbnailUrl":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2022\/11\/couchbase-nosql-dbaas.png","keywords":["data modelling","oracle"],"articleSection":["Couchbase Analytics","Couchbase Server","Data Modeling","SQL++ \/ N1QL Query"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.couchbase.com\/blog\/couchbase-for-oracle-developers-part-4-data-types\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.couchbase.com\/blog\/couchbase-for-oracle-developers-part-4-data-types\/","url":"https:\/\/www.couchbase.com\/blog\/couchbase-for-oracle-developers-part-4-data-types\/","name":"Couchbase for Oracle Developers \u2013 Part 4 : Data types - The Couchbase Blog","isPartOf":{"@id":"https:\/\/www.couchbase.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.couchbase.com\/blog\/couchbase-for-oracle-developers-part-4-data-types\/#primaryimage"},"image":{"@id":"https:\/\/www.couchbase.com\/blog\/couchbase-for-oracle-developers-part-4-data-types\/#primaryimage"},"thumbnailUrl":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2022\/11\/couchbase-nosql-dbaas.png","datePublished":"2020-03-26T00:28:44+00:00","dateModified":"2025-12-18T16:43:03+00:00","breadcrumb":{"@id":"https:\/\/www.couchbase.com\/blog\/couchbase-for-oracle-developers-part-4-data-types\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.couchbase.com\/blog\/couchbase-for-oracle-developers-part-4-data-types\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.couchbase.com\/blog\/couchbase-for-oracle-developers-part-4-data-types\/#primaryimage","url":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2022\/11\/couchbase-nosql-dbaas.png","contentUrl":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2022\/11\/couchbase-nosql-dbaas.png","width":1800,"height":630},{"@type":"BreadcrumbList","@id":"https:\/\/www.couchbase.com\/blog\/couchbase-for-oracle-developers-part-4-data-types\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.couchbase.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Couchbase for Oracle Developers \u2013 Part 4 : Data types"}]},{"@type":"WebSite","@id":"https:\/\/www.couchbase.com\/blog\/#website","url":"https:\/\/www.couchbase.com\/blog\/","name":"The Couchbase Blog","description":"Couchbase, the NoSQL Database","publisher":{"@id":"https:\/\/www.couchbase.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.couchbase.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.couchbase.com\/blog\/#organization","name":"The Couchbase Blog","url":"https:\/\/www.couchbase.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.couchbase.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/2023\/04\/admin-logo.png","contentUrl":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/2023\/04\/admin-logo.png","width":218,"height":34,"caption":"The Couchbase Blog"},"image":{"@id":"https:\/\/www.couchbase.com\/blog\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/www.couchbase.com\/blog\/#\/schema\/person\/c261644262bf98e146372fe647682636","name":"Keshav Murthy","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.couchbase.com\/blog\/#\/schema\/person\/image\/4e51d72fc07c662aa791316deafffac4","url":"https:\/\/secure.gravatar.com\/avatar\/af74df754db27152971d0aed2f323ead5a1f9fe5afd0209af91e12e784451224?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/af74df754db27152971d0aed2f323ead5a1f9fe5afd0209af91e12e784451224?s=96&d=mm&r=g","caption":"Keshav Murthy"},"description":"Keshav Murthy is a Vice President at Couchbase R&amp;D. Previously, he was at MapR, IBM, Informix, Sybase, with more than 20 years of experience in database design &amp; development. He lead the SQL and NoSQL R&amp;D team at IBM Informix. He has received two President's Club awards at Couchbase, two Outstanding Technical Achievement Awards at IBM. Keshav has a bachelor's degree in Computer Science and Engineering from the University of Mysore, India, and has received twenty four US patents.","sameAs":["https:\/\/blog.planetnosql.com\/","https:\/\/x.com\/rkeshavmurthy"],"url":"https:\/\/www.couchbase.com\/blog\/author\/keshav-murthy\/"}]}},"authors":[{"term_id":8929,"user_id":55,"is_guest":0,"slug":"keshav-murthy","display_name":"Keshav Murthy","avatar_url":"https:\/\/secure.gravatar.com\/avatar\/af74df754db27152971d0aed2f323ead5a1f9fe5afd0209af91e12e784451224?s=96&d=mm&r=g","author_category":"","last_name":"Murthy","first_name":"Keshav","job_title":"","user_url":"https:\/\/blog.planetnosql.com\/","description":"Keshav Murthy is a Vice President at Couchbase R&amp;D. Previously, he was at MapR, IBM, Informix, Sybase, with more than 20 years of experience in database design &amp; development. He lead the SQL and NoSQL R&amp;D team at IBM Informix. He has received two President's Club awards at Couchbase, two Outstanding Technical Achievement Awards at IBM. Keshav has a bachelor's degree in Computer Science and Engineering from the University of Mysore, India,  holds ten US patents and has three US patents pending."}],"_links":{"self":[{"href":"https:\/\/www.couchbase.com\/blog\/wp-json\/wp\/v2\/posts\/8355","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.couchbase.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.couchbase.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/wp-json\/wp\/v2\/users\/55"}],"replies":[{"embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/wp-json\/wp\/v2\/comments?post=8355"}],"version-history":[{"count":0,"href":"https:\/\/www.couchbase.com\/blog\/wp-json\/wp\/v2\/posts\/8355\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/wp-json\/wp\/v2\/media\/13873"}],"wp:attachment":[{"href":"https:\/\/www.couchbase.com\/blog\/wp-json\/wp\/v2\/media?parent=8355"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/wp-json\/wp\/v2\/categories?post=8355"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/wp-json\/wp\/v2\/tags?post=8355"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/wp-json\/wp\/v2\/ppma_author?post=8355"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}