{"id":5413,"date":"2023-05-18T12:15:56","date_gmt":"2023-05-18T16:15:56","guid":{"rendered":"https:\/\/solutionsreview.com\/data-management\/?p=5413"},"modified":"2023-05-19T11:42:18","modified_gmt":"2023-05-19T15:42:18","slug":"expert-commentary-on-the-evolution-of-operational-databases","status":"publish","type":"post","link":"https:\/\/solutionsreview.com\/data-management\/expert-commentary-on-the-evolution-of-operational-databases\/","title":{"rendered":"Expert Commentary on the Evolution of Operational Databases"},"content":{"rendered":"

\"Operational<\/p>\n

Solutions Review\u2019s Expert Insights Series is a collection of contributed articles written by industry experts in enterprise software categories. In this feature, Yugabyte<\/a> Founder and CTO Karthik Ranganathan offers commentary on the evolution of of operational databases.<\/strong><\/i><\/p>\n

As enterprises move applications and services to the cloud, they are migrating from big iron scale-up proprietary infrastructure to cloud native architectures. At first glance, traditional database management systems may appear cloud-ready for this critical change, but in reality they still face significant challenges around performance, availability, and simplicity when run at scale. Luckily, the evolution of operational databases has finally reached a point where it is ready to match cloud and modern application layers with a cloud native database. To understand how we got to where we are today, let\u2019s walk through this database evolution and define what \u201ccloud native\u201d really means.<\/p>\n

Moving from Monolithic to Distributed SQL – availability and sharding<\/strong><\/p>\n

The foundation of modern transactional databases starts with relational, or Structured Query Language (SQL) databases. These databases have set the standard for Online Transaction Processing (OLTP) for the past four decades. They have proved reliable, but are monolithic in nature, running on a single server. Increasing capacity requires vertical hardware scaling. This can be difficult and costly as it requires more specialized, expensive servers. Their method of copying data, via async or sync replication, can also result in data loss (with async) or downtime (with sync replication). SQL databases weren\u2019t built to scale out to cloud architectures, so these problems are unsurprising.<\/p>\n

A significant step towards a viable solution came with sharded and distributed databases \u2013 first NoSQL, then NewSQL. However, NoSQL also has its limits. NoSQL databases emphasize scalability and high availability, but compromise on consistency, ACID transactions, and familiar relational data modeling. They are typically used for workloads with very simple data access patterns without requiring transactional guarantees. They are not ideal for business-critical OLTP or HTAP applications that require referential integrity, transactional capabilities and flexible data access patterns using features such as joins.<\/p>\n

The tradeoffs between availability (NoSQL) and RDBMS capabilities (NewSQL) force organizations to make a choice. Many early NoSQL adopters (mostly large tech companies) are having second thoughts about pouring more money into that strategy. NewSQL databases are cloud hosted, but not fully cloud native. They represent a critical step in the evolution of databases, but often lead to operational complexity, difficult application development, and inconsistent customer experiences.<\/p>\n

\t\t\t
\"Download<\/a><\/div>\n\t\t<\/div><\/div>\n

Operational Database Evolution<\/strong><\/h2>\n
<\/div>\n

Solving NoSQL Challenges with Distributed SQL<\/strong><\/p>\n

The next stage in the evolution of databases is distributed SQL, which combines the strongest aspects of traditional relational database management systems (RDBMS) with key cloud native capabilities, including scale and availability, made popular by NoSQL databases.<\/p>\n

Distributed SQL offers continuous availability, replicating data across nodes and keeping it available regardless of node, zone, region, or data center failures. It allows organizations to scale horizontally on demand without impacting performance and is strongly consistent across geographic zones. It offers developers familiar RDBMS features, allowing them to build data-driven applications, and can strengthen security by providing encryption at rest and in transit.<\/p>\n

Although no database reference architecture is perfect for every application, a cloud native distributed SQL database solves many of the challenges that plague NoSQL and other approaches, providing a consistent, versatile, cloud native data layer.<\/p>\n

Defining \u201cCloud Native\u201d for Databases<\/strong><\/p>\n

Cloud native is one of the more recent phases of the operational database evolution. Cloud native is rapidly becoming common practice at the application layer, as enterprises move transactions, microservices, and other applications to dynamic, containerized environments. The same can\u2019t be said of the data layer that supports those applications.<\/p>\n

NoSQL and NewSQL databases can be hosted in the cloud and horizontally deployed on cloud infrastructure, but they fall short \u2012 in one way or another \u2012 of keeping the core database functionality uniform and reliable.<\/p>\n

A true cloud native database has five defining characteristics:<\/p>\n

    \n
  1. Extreme elasticity, with the ability to scale clusters up and down, both quickly and reliably that allows it to use the virtually limitless resources in the cloud.<\/li>\n
  2. Geo-redundancy and always-on availability to easily create multi-AZ and\/or multi-region clusters, and expand or shrink availability zones or regions at any time while remaining resilient to both unplanned failures and planned upgrades. This is important because even the best public cloud services have suffered failures at the zone and region level.<\/li>\n
  3. Simplified management – from hardware flexibility to seamless upgrades allows for seamless movement from one type of compute and storage to another for cost and performance reasons, and to leverage the latest technology advances in the cloud.<\/li>\n
  4. Multi-cloud mobility to avoid cloud lock-in by moving to another cloud provider or co-existing with multiple providers.<\/li>\n
  5. Data placement policies that define and enforce geo-specific data residency controls without impacting applications.<\/li>\n<\/ol>\n

    Today, business happens in the cloud. Enterprises will continue to expand operations beyond their own data centers and embrace the public cloud.<\/p>\n

    While a cloud approach helps organizations operate efficiently and effectively, enterprises need a multi-cloud model that gives them the same cloud native agility they get from microservices and containers. Modern, cloud native operational databases, like distributed SQL databases, fully support those operations, helping enterprises deliver high-value services much faster than legacy databases.<\/p>\n

    <\/div>\n
    \t\t\t

    \"Download<\/a><\/p>\n<\/div>\n\t\t<\/div><\/div>\n","protected":false},"excerpt":{"rendered":"

    Solutions Review\u2019s Expert Insights Series is a collection of contributed articles written by industry experts in enterprise software categories. In this feature, Yugabyte Founder and CTO Karthik Ranganathan offers commentary on the evolution of of operational databases. As enterprises move applications and services to the cloud, they are migrating from big iron scale-up proprietary infrastructure […]<\/p>\n","protected":false},"author":667,"featured_media":5414,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"inline_featured_image":false,"footnotes":""},"categories":[3],"tags":[1365,861],"acf":[],"yoast_head":"\nExpert Commentary on the Evolution of Operational Databases<\/title>\n<meta name=\"description\" content=\"Yugabyte Founder and CTO Karthik Ranganathan offers commentary on the evolution of of operational databases.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/solutionsreview.com\/data-management\/expert-commentary-on-the-evolution-of-operational-databases\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Expert Commentary on the Evolution of Operational Databases\" \/>\n<meta property=\"og:description\" content=\"Yugabyte Founder and CTO Karthik Ranganathan offers commentary on the evolution of of operational databases.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/solutionsreview.com\/data-management\/expert-commentary-on-the-evolution-of-operational-databases\/\" \/>\n<meta property=\"og:site_name\" content=\"Best Data Management Software, Vendors and Data Science Platforms\" \/>\n<meta property=\"article:published_time\" content=\"2023-05-18T16:15:56+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-05-19T15:42:18+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/solutionsreview.com\/data-management\/files\/2023\/05\/Operational-Database-Evolution.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"800\" \/>\n\t<meta property=\"og:image:height\" content=\"400\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Karthik Ranganathan\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Karthik Ranganathan\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/solutionsreview.com\/data-management\/expert-commentary-on-the-evolution-of-operational-databases\/\",\"url\":\"https:\/\/solutionsreview.com\/data-management\/expert-commentary-on-the-evolution-of-operational-databases\/\",\"name\":\"Expert Commentary on the Evolution of Operational Databases\",\"isPartOf\":{\"@id\":\"https:\/\/solutionsreview.com\/data-management\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/solutionsreview.com\/data-management\/expert-commentary-on-the-evolution-of-operational-databases\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/solutionsreview.com\/data-management\/expert-commentary-on-the-evolution-of-operational-databases\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/solutionsreview.com\/data-management\/files\/2023\/05\/Operational-Database-Evolution.jpg\",\"datePublished\":\"2023-05-18T16:15:56+00:00\",\"dateModified\":\"2023-05-19T15:42:18+00:00\",\"author\":{\"@id\":\"https:\/\/solutionsreview.com\/data-management\/#\/schema\/person\/794d3f0dac0a127b0b0ceedcbe61e0de\"},\"description\":\"Yugabyte Founder and CTO Karthik Ranganathan offers commentary on the evolution of of operational databases.\",\"breadcrumb\":{\"@id\":\"https:\/\/solutionsreview.com\/data-management\/expert-commentary-on-the-evolution-of-operational-databases\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/solutionsreview.com\/data-management\/expert-commentary-on-the-evolution-of-operational-databases\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/solutionsreview.com\/data-management\/expert-commentary-on-the-evolution-of-operational-databases\/#primaryimage\",\"url\":\"https:\/\/solutionsreview.com\/data-management\/files\/2023\/05\/Operational-Database-Evolution.jpg\",\"contentUrl\":\"https:\/\/solutionsreview.com\/data-management\/files\/2023\/05\/Operational-Database-Evolution.jpg\",\"width\":800,\"height\":400,\"caption\":\"Operational Database Evolution\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/solutionsreview.com\/data-management\/expert-commentary-on-the-evolution-of-operational-databases\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/solutionsreview.com\/data-management\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Expert Commentary on the Evolution of Operational Databases\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/solutionsreview.com\/data-management\/#website\",\"url\":\"https:\/\/solutionsreview.com\/data-management\/\",\"name\":\"Best Data Management Software, Vendors and Data Science Platforms\",\"description\":\"Enterprise Information Management\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/solutionsreview.com\/data-management\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/solutionsreview.com\/data-management\/#\/schema\/person\/794d3f0dac0a127b0b0ceedcbe61e0de\",\"name\":\"Karthik Ranganathan\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/solutionsreview.com\/data-management\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/2b2bf95df66b21e07781bcfa73365265?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/2b2bf95df66b21e07781bcfa73365265?s=96&d=mm&r=g\",\"caption\":\"Karthik Ranganathan\"},\"description\":\"Karthik Ranganathan is the co-founder and CTO of Yugabyte. Karthik has played a key role in driving distributed SQL database adoption and bringing together NoSQL and SQL capabilities into a single relational database. Before Yugabyte, Karthik was one of the original database engineers at Facebook.\",\"url\":\"https:\/\/solutionsreview.com\/data-management\/author\/kranganathan\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Expert Commentary on the Evolution of Operational Databases","description":"Yugabyte Founder and CTO Karthik Ranganathan offers commentary on the evolution of of operational databases.","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:\/\/solutionsreview.com\/data-management\/expert-commentary-on-the-evolution-of-operational-databases\/","og_locale":"en_US","og_type":"article","og_title":"Expert Commentary on the Evolution of Operational Databases","og_description":"Yugabyte Founder and CTO Karthik Ranganathan offers commentary on the evolution of of operational databases.","og_url":"https:\/\/solutionsreview.com\/data-management\/expert-commentary-on-the-evolution-of-operational-databases\/","og_site_name":"Best Data Management Software, Vendors and Data Science Platforms","article_published_time":"2023-05-18T16:15:56+00:00","article_modified_time":"2023-05-19T15:42:18+00:00","og_image":[{"width":800,"height":400,"url":"https:\/\/solutionsreview.com\/data-management\/files\/2023\/05\/Operational-Database-Evolution.jpg","type":"image\/jpeg"}],"author":"Karthik Ranganathan","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Karthik Ranganathan","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/solutionsreview.com\/data-management\/expert-commentary-on-the-evolution-of-operational-databases\/","url":"https:\/\/solutionsreview.com\/data-management\/expert-commentary-on-the-evolution-of-operational-databases\/","name":"Expert Commentary on the Evolution of Operational Databases","isPartOf":{"@id":"https:\/\/solutionsreview.com\/data-management\/#website"},"primaryImageOfPage":{"@id":"https:\/\/solutionsreview.com\/data-management\/expert-commentary-on-the-evolution-of-operational-databases\/#primaryimage"},"image":{"@id":"https:\/\/solutionsreview.com\/data-management\/expert-commentary-on-the-evolution-of-operational-databases\/#primaryimage"},"thumbnailUrl":"https:\/\/solutionsreview.com\/data-management\/files\/2023\/05\/Operational-Database-Evolution.jpg","datePublished":"2023-05-18T16:15:56+00:00","dateModified":"2023-05-19T15:42:18+00:00","author":{"@id":"https:\/\/solutionsreview.com\/data-management\/#\/schema\/person\/794d3f0dac0a127b0b0ceedcbe61e0de"},"description":"Yugabyte Founder and CTO Karthik Ranganathan offers commentary on the evolution of of operational databases.","breadcrumb":{"@id":"https:\/\/solutionsreview.com\/data-management\/expert-commentary-on-the-evolution-of-operational-databases\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/solutionsreview.com\/data-management\/expert-commentary-on-the-evolution-of-operational-databases\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/solutionsreview.com\/data-management\/expert-commentary-on-the-evolution-of-operational-databases\/#primaryimage","url":"https:\/\/solutionsreview.com\/data-management\/files\/2023\/05\/Operational-Database-Evolution.jpg","contentUrl":"https:\/\/solutionsreview.com\/data-management\/files\/2023\/05\/Operational-Database-Evolution.jpg","width":800,"height":400,"caption":"Operational Database Evolution"},{"@type":"BreadcrumbList","@id":"https:\/\/solutionsreview.com\/data-management\/expert-commentary-on-the-evolution-of-operational-databases\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/solutionsreview.com\/data-management\/"},{"@type":"ListItem","position":2,"name":"Expert Commentary on the Evolution of Operational Databases"}]},{"@type":"WebSite","@id":"https:\/\/solutionsreview.com\/data-management\/#website","url":"https:\/\/solutionsreview.com\/data-management\/","name":"Best Data Management Software, Vendors and Data Science Platforms","description":"Enterprise Information Management","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/solutionsreview.com\/data-management\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/solutionsreview.com\/data-management\/#\/schema\/person\/794d3f0dac0a127b0b0ceedcbe61e0de","name":"Karthik Ranganathan","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/solutionsreview.com\/data-management\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/2b2bf95df66b21e07781bcfa73365265?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/2b2bf95df66b21e07781bcfa73365265?s=96&d=mm&r=g","caption":"Karthik Ranganathan"},"description":"Karthik Ranganathan is the co-founder and CTO of Yugabyte. Karthik has played a key role in driving distributed SQL database adoption and bringing together NoSQL and SQL capabilities into a single relational database. Before Yugabyte, Karthik was one of the original database engineers at Facebook.","url":"https:\/\/solutionsreview.com\/data-management\/author\/kranganathan\/"}]}},"_links":{"self":[{"href":"https:\/\/solutionsreview.com\/data-management\/wp-json\/wp\/v2\/posts\/5413"}],"collection":[{"href":"https:\/\/solutionsreview.com\/data-management\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/solutionsreview.com\/data-management\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/solutionsreview.com\/data-management\/wp-json\/wp\/v2\/users\/667"}],"replies":[{"embeddable":true,"href":"https:\/\/solutionsreview.com\/data-management\/wp-json\/wp\/v2\/comments?post=5413"}],"version-history":[{"count":0,"href":"https:\/\/solutionsreview.com\/data-management\/wp-json\/wp\/v2\/posts\/5413\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/solutionsreview.com\/data-management\/wp-json\/wp\/v2\/media\/5414"}],"wp:attachment":[{"href":"https:\/\/solutionsreview.com\/data-management\/wp-json\/wp\/v2\/media?parent=5413"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/solutionsreview.com\/data-management\/wp-json\/wp\/v2\/categories?post=5413"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/solutionsreview.com\/data-management\/wp-json\/wp\/v2\/tags?post=5413"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}