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.

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

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 (http://blog.sqlauthority.com)

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

  1. Pingback: SQLAuthority News – Weekend Experiment with NuoDB – Points to Pondor and Whitepaper « SQL Server Journey with SQL Authority

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s