NuoDB has Microsoft SQL Server in its sights

NuoDB has Microsoft SQL Server in its sights

Summary: With its 1.1 release, the "NewSQL" player strikes at the Microsoft ecosystem with ADO.NET, LINQ, and Entity Framework providers ... and a migration tool to poach databases from SQL Server.

SHARE:
TOPICS: Big Data
3

Most of the young, scale-out database players, be they of the NoSQL or NewSQL (distributed, relational), variety, are very Linux oriented. Although many of these databases, including MongoDB, CouchDB, and Cassandra, run just fine on Windows, they still have a proclivity toward best serving developers on the Linux platform.

One NewSQL database, NuoDB, also runs on both operating systems. But the folks at NuoDB looked at their downloads, and discovered that a full 80 percent of them were attributable to the Windows edition of the product. Rather than bury their heads in the Linux sand regarding this phenomenon, the NuoDB folks took ownership of it instead.

(.Net) Developers, developers, developers

The result is version 1.1 of the NuoDB Starlings database. This version ships with support for Microsoft developer technologies to a degree that is almost unprecedented for a third party. These creature comforts include an ADO.NET provider, a LINQ (Language Integrated Query) provider, and an Entity Framework provider that supports the code-first and model-first approaches.

NuoDB 1.1 also includes a migration assistant for moving databases off the SQL Server platform and onto NuoDB. This is a shot across Microsoft's bow, although from a relatively small vessel. Regardless, the value proposition is interesting. While SQL Server can be implemented in a clustered configuration, that's not easy to do, and its architecture is mostly geared toward single-node installations. Additional SQL Server nodes are often made available for fault tolerance purposes, more than for distributed processing.

How it works

NuoDB is a scale-out, cloud-oriented database, built to be geographically distributed by default. Its architecture consists of broker nodes, transaction nodes, and storage management nodes. Each transaction node is responsible for its own "atoms" — little pieces of the database, be it data rows or parts of indexes, that communicate asynchronously. The atoms use multi-version concurrency control (MVCC) to maintain database consistency and ACID guarantees.

The broker nodes handle load balancing between the transaction nodes, and as long as there are two or more broker nodes, NuoDB avoids having any single points of failure. Storage management nodes keep track of the atoms that make up a database, and their replicas.

Nodes in a NuoDB cluster act together on a peer-to-peer basis, analogously to birds in a flock, hence the "Starlings" name and the company's logo design. The whole scheme leads, if the company's claims are accurate, to a very low-latency, geo-distributed database that still uses the relational model, transactional guarantees, and SQL query language that are standard for enterprise developers.

NuoDB nodes can run in the cloud (NuoDB now explicitly claims Windows Azure compatibility) and, interestingly, NuoDB clusters can consist of a mixture of Windows and Linux nodes.

Should Redmond worry?

It's not at all clear to me that NuoDB will siphon off hordes of SQL Server databases and customers. Of course, I'm an SQL Server MVP and a co-author of a book on Microsoft's flagship database, so I have my biases. But coming from that background, NuoDB seems more tempting to me than MongoDB or Cassandra, for example.

Allowing .Net developers to move to a scale-out database architecture — and yet keep their existing APIs, database schemas, and query language — poses a formidable challenge to Redmond.

Topic: Big Data

Andrew Brust

About Andrew Brust

Andrew J. Brust has worked in the software industry for 25 years as a developer, consultant, entrepreneur and CTO, specializing in application development, databases and business intelligence technology.

Kick off your day with ZDNet's daily email newsletter. It's the freshest tech news and opinion, served hot. Get it.

Talkback

3 comments
Log in or register to join the discussion
  • login to download?

    No thanks. Yet another DB, except this one is not even open source. With the wealth of extremely good open source databases, it seems very strange to see one that isn't. What are they hiding? Oh, their software patents...

    "Our patent-pending database is 100% SQL compliant, guarantees ACID transactions, and scales out and in elastically and effortlessly on decentralized cloud-based computing resources"

    So non-open source, and patent pending. Yes, I'll definitely pass on this.
    spackle
  • You can get SQL Server for free too

    After 15+ years of solid Microsoft innovation on SQL Server with all its BI, MDM and other cloud services, I fail to see the benefit of this?
    hubivedder
  • Why NuoDB

    In the interest of full disclosure, I work for NuoDB as a technology evangelist. I have also had very good experiences with SQL Server in the past. However, I don't think it's necessary to view this posting through the lens of SQL Server vs. NuoDB. In my opinion it's about selecting the right tool for the job. NuoDB has introduced a new innovation that enables developers to build their applications on a single logical database and scale their database horizontally to handle predictable and unpredictable spikes in traffic . Horizontal scaling happens completely transparently and without any changes to the application itself. Feel free to try it for yourself. We ship with a sample eCommerce application that demonstrates our capabilities. We also ship with our own ADO.NET driver so you can continue to use the great tools that come with Visual Studio and SQL Server for development and reporting.

    Thanks,

    Wiqar Chaudry
    Technology Evangelist
    NuoDB
    wchaudry