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.

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

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)

, ,
Previous Post
SQL SERVER – Beginning NuoDB – Who will Benefit and How to Start
Next Post
SQL SERVER – 5 Videos from Joes 2 Pros Series Exam Prep Series 70-433 – SQL in Sixty Seconds

Related Posts

2 Comments. Leave new

  • coldfusionPaul
    August 5, 2012 9:40 am

    yeah it looks interesting but it doesn’t have any spatial data types or functions yet.

    Reply

Leave a Reply

Menu