Services for Organizations

Using our research, best practices and expertise, we help you understand how to optimize your business processes using applications, information and technology. We provide advisory, education, and assessment services to rapidly identify and prioritize areas for improvement and perform vendor selection

Consulting & Strategy Sessions

Ventana On Demand

    Services for Investment Firms

    We provide guidance using our market research and expertise to significantly improve your marketing, sales and product efforts. We offer a portfolio of advisory, research, thought leadership and digital education services to help optimize market strategy, planning and execution.

    Consulting & Strategy Sessions

    Ventana On Demand

      Services for Technology Vendors

      We provide guidance using our market research and expertise to significantly improve your marketing, sales and product efforts. We offer a portfolio of advisory, research, thought leadership and digital education services to help optimize market strategy, planning and execution.

      Analyst Relations

      Demand Generation

      Product Marketing

      Market Coverage

      Request a Briefing



        Matt Aslett's Analyst Perspectives

        << Back to Blog Index

        Exploring the Case for Distributed SQL Databases

        There is always space for innovation in the data platforms sector, and new vendors continue to emerge at regular intervals with new approaches designed to serve specialist data storage and processing requirements. Factors including performance, reliability, security and scalability provide a focal point for new vendors to differentiate from established vendors, especially for the most demanding operational or analytic data platform requirements. It is never easy, however, for developers of new data platform products to gain significant market traction, given the dominance of the established relational database vendors and cloud providers. Targeting requirements that are not well-served by general purpose data platforms can help new vendors get a toe in the door of customer accounts. The challenge to gaining further market traction is for new vendors to avoid having products become pigeon-holed as only being suitable for a niche set of requirements. This is precisely the problem facing the various distributed SQL database providers.

        Distributed SQL is a term that has been adopted by several vendors to describe operational data platform products designed to combine the benefits of the relational database model and native support for distributed cloud architecture, including resilience that spans multiple data centers and/or cloud regions. Vendors of products that meet this description include the likes of Cockroach Labs, MariaDB, PingCAP, PlanetScale, and Yugabyte as well as Amazon Web Services, Google Cloud and Microsoft Azure. Distributed SQL database vendors provide relational data platforms that replicate data across multiple servers, forming a single, logical database. Replicating data across multiple servers could mean spanning multiple nodes in a single data center, multiple nodes across multiple data centers or even multiple nodes across multiple cloud providers in multiple geographic regions. Distributed SQL databases are primarily designed to support operational workloads used to run the business and should not be confused with distributed SQL query engines such as Presto and Trino, which are used to accelerate analysis of data in multiple data platforms across a distributed architecture. Distributed SQL databases and distributed SQL query engines are complementary and could potentially be used in conjunction.

        There are multiple reasons why organizations might be interested in distributed SQL databases. A significant potential benefit is business continuity. Distributed SQL databases are specifically designed to provide scalability and resiliency that extend beyond a single data center or cloud instance. Support for elastic scalability can be utilized to deliver automated cloud expansion and contraction in response to evolving capacity requirements, while the ability to span multiple geographic regions – or even cloud providers – can be used to support disaster recovery and high availability. Multi-region support could also be used to segregate data processing to support data sovereignty requirements. Latency is also a consideration for data platforms that can replicate data that is not subject to regulatory limitations, supporting local performance requirements by minimizing network delays between the data platform and users across multiple regions.

        All of these are potential advantages of distributed SQL databases and are driving adoption by organizations that have identified use cases that require active-active cross data center data replication. However, the same was also true of the first generation of distributed relational database vendors such as GenieDB, NuoDB, TransLattice and Xeround, which emerged around 2010 only to be acquired or closed within a few years without having made a material impact on the data platforms landscape. These vendors, sometimes referred to by the collective term NewSQL, provide a cautionary tale for distributed SQL providers. Since active-active cross data center data replication functionality was relatively new, organizations needed time to understand the potential use cases and develop applications to take advantage of that functionality. Customer demand for NewSQL databases was by no means non-existent, but it did not materialize fast enough to keep the various vendors in business long enough to become more than niche providers.

        The prospects for distributed SQL vendors seem brighter. Enterprise understanding and demand for active-active cross data center data replication, while still not mainstream, has benefited from a decadeVentana_Research_Analytics_and_Data_Cloud_Providers_Used (2)-png-1 of evolving cloud adoption and globalization. Multi-cloud and hybrid IT architectures are now common. More than one-half (52%) of participants in Ventana Research’s Analytics and Data Benchmark Research are using a hybrid architecture involving both on-premises and cloud computing for analytics and data, while more than two-fifths (42%) of those using cloud systems currently have more than one cloud provider. Additionally, the next generation of distributed SQL vendors has learned from the experiences of NewSQL predecessors and have cultivated other drivers for the adoption of new databases to help build momentum.

        Another potential benefit of distributed SQL is avoidance of complexity, compared to the use of database sharding and in-memory caching layers that are used to scale existing relational databases. Developer VR_2022_Operational_Data_Platforms_Assertion_2_Square (2)agility is also a key focus for distributed SQL providers, including facilitating adoption through the use of cloud native architecture, managed services and serverless database options. Engaging with developers is critical to ensure they are considering distributed SQL as they choose the databases that will underpin next-generation applications. I assert that through 2024, 6 in 10 organizations will re-examine current operational database suppliers with a view of supporting more agile and intelligent operational applications and improving fault tolerance.

        Another key factor in lowering barriers to developer adoption is compatibility with existing applications, frameworks, drivers and tools. The various distributed SQL vendors have delivered compatibility with popular open-source databases such as MySQL or PostgreSQL to enable developers to use familiar tools and techniques when developing new applications to run on distributed SQL databases. Migrating existing applications to distributed SQL databases is more complex given that existing, single-node applications have not been developed to take advantage of a distributed architecture, and many distributed SQL databases are not designed to support single-node applications.

        If distributed SQL vendors are to avoid the pitfalls that befell NewSQL vendors, these organizations need to provide additional value to customers by supporting the migration of existing software as well as the development of new applications. Ironically, support for single-node applications may be critical to proving the value of distributed SQL. While this functionality is a work in progress for the various distributed SQL vendors, I nevertheless recommend that organizations evaluate the potential benefits of distributed SQL when considering options for new operational data platforms.

        Regards,

        Matt Aslett

        Matt Aslett
        Director of Research, Analytics and Data

        Matt Aslett leads the software research and advisory for Analytics and Data at ISG Software Research, covering software that improves the utilization and value of information. His focus areas of expertise and market coverage include analytics, data intelligence, data operations, data platforms, and streaming and events.

        JOIN OUR COMMUNITY

        Our Analyst Perspective Policy

        • Ventana Research’s Analyst Perspectives are fact-based analysis and guidance on business, industry and technology vendor trends. Each Analyst Perspective presents the view of the analyst who is an established subject matter expert on new developments, business and technology trends, findings from our research, or best practice insights.

          Each is prepared and reviewed in accordance with Ventana Research’s strict standards for accuracy and objectivity and reviewed to ensure it delivers reliable and actionable insights. It is reviewed and edited by research management and is approved by the Chief Research Officer; no individual or organization outside of Ventana Research reviews any Analyst Perspective before it is published. If you have any issue with an Analyst Perspective, please email them to ChiefResearchOfficer@ventanaresearch.com

        View Policy

        Subscribe to Email Updates



        Analyst Perspectives Archive

        See All