SQL SERVER – Follow up on Beginning NuoDB – Who will Benefit and How to Start – Part 2

Earlier I blogged about Beginning NuoDB – Who will Benefit and How to Start, I received a few follow up questions about it so I decided to write a short article as a follow up. One of the questions I received was why I started with this product. Well, the reason is that I decided to learn more in the database field. This product got my attention and would like to explore more. I started to play with the NuoDB beta 7 and I am finding it very interesting. There were a few more questions as well and I decided to write them in the following post to my earlier post.

The power of NuoDB becomes evident when you need more Transaction Engines to handle load.  You can add these to (and take them away from) a running chorus dynamically.  Transaction Engines in a chorus can run on a mixture of networked hosts – on a variety of operating systems, including ones in the cloud – as I mentioned above.  Let me quickly divert here, by saying that the idea that a database can span multiple computers and run across multiple operational systems is mind boggling to me.  You know that I am a geek but this is more than super-cool and a true revolution in database technology and architecture.

During beta 7 (and beta 8 as far as I know), the broker hands out the connections to Transaction Engines in a round-robin fashion.  NuoDB will provide different load balancing mechanisms as needed.  I expect that load balancing algorithm could get very interesting.  To browse NuoDB and test my SQL code, I use DBVisualizer as recommended by NuoDB.  SQuirreL is also supported, and your tool of choice likely works with very little configuration – as long as it uses ODBC or JDBC to connect.  There is also a command line tool called NuoSQL, which can run SQL in interactive or batch mode.  Another tool, NuoLoader, imports your CSV-formatted data.

This should be enough information to be dangerous.  I very much recommend that you give it a try and tell me how it goes.  By beginning to embrace NuoDB’s innovative SQL database concepts, I am sensing that we might be on to something very big that hasn’t happened in the database market in a long time. You can download the NuoDB beta software at this link.

Action Items:

• Download and try out NuoDB (The same link will work for future versions of the product)
• Leave a comment with your experiment

Reference: Pinal Dave (https://blog.sqlauthority.com)