Over a million developers have joined DZone.

NewSQL: The Cake You Can Eat

· Java Zone

Microservices! They are everywhere, or at least, the term is. When should you use a microservice architecture? What factors should be considered when making that decision? Do the benefits outweigh the costs? Why is everyone so excited about them, anyway?  Brought to you in partnership with IBM.

This post was originally written by Ryan Betts

Formula for startup success: extract the lessons of the past and mix in present reality and macro-trends. That’s NewSQL in a nutshell.

NewSQL is growing in popularity because it preserves the value accumulated over the last 30 years of database development and deploys that capability on modern architectures and configurations.

But SQL is dead, right?

Not even close. When Facebook announced Presto a few months ago, I poked some fun at NoSQL. I was tweeted back, “Hive’s been doing SQL on Hadoop since, what, 2008?” (I was kinda snarky and deserved the tone in return.) But – absolutely! The most successful NoSQL platform out there, Hadoop, has been doing SQL since 2008.

Good database designers understand that all database business value derives from making data interactive. And SQL is the lingua franca for interacting with data. Decades of research, advancement, specification, ecosystem, integration, tooling and user training have nurtured SQL into a rich and powerful language for interacting with data. SQL is a cornerstone of a $30B industry. Architects and users alike are unwilling to discard that wealth of experience and capability.

That doesn’t mean they love their legacy systems.

The NoSQL movement was instrumental in teaching the marketplace that distributed, fault-tolerant, cloud-deployable, clustered database services are feasible and desirable. Early adopters seeking scale at all costs were willing to sacrifice interaction for scale – often they had no choice. The early majority is not willing to make this sacrifice. The database market is ripe for disruption by technologies that offer new functions: the ability to scale to ingest fast data streams, offer real time analytics and real-time decisions in cloud-friendly, mission-critical configurations. Or the ability to run historical analytics in 1/100 the time on less expensive hardware than the legacy players. But there’s no value in redefining the language of fluency: SQL.

NewSQL systems offer the best of both worlds: deploy SQL semantics and query capability on modern, distributed, fault-tolerant, cloud-deployable clustered architectures. New SQL combines the richness and flexibility of SQL for data interaction with the scale necessary in today’s fast data, big data world.

NoSQL vendors are recognizing the value of SQL or are public about their need to “mature their systems.” Legacy vendors face a tougher challenge. While they support a well-known query interface, they need to evolve to a more flexible, higher performance architecture in concert with their existing product lines.

Discover how the Watson team is further developing SDKs in Java, Node.js, Python, iOS, and Android to access these services and make programming easy. Brought to you in partnership with IBM.


Published at DZone with permission of Mike Stonebraker, DZone MVB. See the original article here.

Opinions expressed by DZone contributors are their own.

The best of DZone straight to your inbox.

Please provide a valid email address.

Thanks for subscribing!

Awesome! Check your inbox to verify your email so you can start receiving the latest in tech news and resources.

{{ parent.title || parent.header.title}}

{{ parent.tldr }}

{{ parent.urlSource.name }}