SQL Contest – Win 10 Amazon Gift Cards worth (USD 200) and 10 NuoDB T-Shirts

This month, we have yet not run any contest so we will be running a very interesting contest with the help of good guys at NuoDB. NuoDB has just released version 2.0 and You can download NuoDB from here.

NuoDB’s NewSQL distributed database is designed to be a single database that works across multiple servers, which can scale easily, and scale on demand. That’s one system that gives high connectivity but no latency, complexity or maintenance issues. MySQL works in some circumstances, but a period of growth isn’t one of them. So as a company moves forward, the MySQL database can’t keep pace. Data storage and data replication errors creep in. Soon the diaspora of the offices becomes a problem. Your telephone system isn’t just distributed, it is literally all over the place. You can read my detailed article about how Why VoIP Service Providers Should Think About NuoDB’s Geo Distribution.

Here is the contest:

Contest Part 1:

NuoDB R2.0 delivered a long list of improvements and new features. List three of the major features of NuoDB 2.0.

Here is the hint1, hint2, hint3.

Contest Part 2:

Download NuoDB using this link. Once you download NuoDB, leave a comment over here with the name of the platform and installer size. (For example Windows Platform Size abc.dd MB)

Here is the what you can win!

Giveaways

  • 10 Amazon Gift Card (Each of USD 20 – total USD 200)
  • 10 Amazingly looking NuoDB T-Shirts (For the first 10 downloads)

Rules

Participate before Oct 28, 2013. All the valid answers will be published after Oct 28, 2013 and winners will receive an email on Nov 1st, 2013.

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

SQLAuthority News – Why VoIP Service Providers Should Think About NuoDB’s Geo Distribution

You can always tell when someone’s showing off their cool, cutting edge comms technology. They tend to raise their voice a lot.

Back in the day they’d announce their gadget leadership to the rest of the herd by shouting into their cellphone. Usually the message was no more urgent than “Hi, I’m on my cellphone!” Now the same types will loudly name-drop a different technology to the rest of the airport lounge. “I’m leveraging the wifi,” a fellow passenger bellowed, the other day, as we filtered through the departure gate. Nobody needed to know that, but the subtext was “look at me everybody”.

You can tell the really advanced mobile user – they tend to whisper. Their handset has a microphone (how cool is that!) and they know how to use it.

Sometimes these shouty public broadcasters aren’t even connected anyway because the database for their Voice over IP (VoIP) platform can’t cope. This will happen if they are using a traditional SQL model to try and cope with a phone network which has far flung offices and hundreds of mobile employees. That, like shouting into your phone, is just wrong on so many levels.

What VoIP needs now is a single, logical database across multiple servers in different geographies. It needs to be updated in real-time and automatically scaled out during times of peak demand. A VoIP system should scale up to handle increased traffic, but just as importantly is must then go back down in the off peak hours.

Try this with a MySQL database. It can’t scale easily enough, so it will keep your developers busy. They’ll have spent many hours trying to knit the different databases together.

Traditional relational databases can possibly achieve this, at a price. Mind you, you could extend baked bean cans and string to every point on the network and that would be no less elegant. That’s not really following engineering principles though is it?

Having said that, most telcos and VoIP systems use a separate, independent solution for each office location, which they link together – loosely.  The more office locations, the more complex and expensive the solution becomes and so the more you spend on maintenance. Ideally, you’d have a fluid system that can automatically shift its shape as the need arises. That’s the point of software isn’t it – it adapts. Otherwise, we might as well return to the old days. A MySQL system isn’t exactly baked bean cans attached by string, but it’s closer in spirit to the old many teethed mechanical beast that was employed in the first type of automated switchboard.

NuoBD’s NewSQL is designed to be a single database that works across multiple servers, which can scale easily, and scale on demand. That’s one system that gives high connectivity but no latency, complexity or maintenance issues.

MySQL works in some circumstances, but a period of growth isn’t one of them. So as a company moves forward, the MySQL database can’t keep pace. Data storage and data replication errors creep in. Soon the diaspora of offices becomes a problem. Your telephone system isn’t just distributed, it is literally all over the place.

Though voice calls are often a software function, some of the old habits of telephony remain. When you call an engineer out, some of them will listen to what you’re asking for and announce that it cannot be done. This is what happens if you ask, say, database engineers familiar with Oracle or Microsoft to fulfill your wish for a low maintenance system built on a single, fluid, scalable database. No can do, they’d say. In fact, I heard one shouting something similar into his VoIP handset at the airport. “I can’t get on the network, Mac. I’m on MySQL.”

You can download NuoDB from here.

NuoDB provides the ability to replicate data globally in real-time, which is not available with any other product offering,” states Weeks.  “That alone is remarkable and it works. I’ve seen it. I’ve used it.  I’ve tested it. The ability to deploy NuoDB removes a tremendous burden from our support and engineering teams.”

SQLAuthority News – Mark the Date: October 16, 2013 – Introducing NuoDB Blackbirds: THE Distributed Database

I am very excited to announce first on this blog about the release of NuoDB Blackbirds (NuoDB Release 2.0). NuoDB is my favorite application to work with data now a days. They are increasingly gaining market share as well as brining out new features with their every new release. I was very excited when I learned that NuoDB is releasing their flagship release of 2.0 on October 16, 2013. Interesting enough I will be in USA while this release happens and I will be watching it live during my day time. Even though if I had to stay up the entire night to just watch this release, I would do it.

Here is the details of the announcements:

Introducing NuoDB Blackbirds: THE Distributed Database

Date: October 16, 2013
Time: 1:00 PM EDT
Location: Online
Registration Link

What is the best DBMS architecture to handle today’s and tomorrow’s evolving needs? The days of shared disk are over. The times are “a-changin” and IT infrastructure has to change with them.

Join NuoDB live for the introduction of our latest major product release, NuoDB Blackbirds, and take a look at why the NuoDB distributed database architecture is the only answer for customers like Fathom Voice, a leading provider of Voice Over IP (VoIP).

NuoDB CEO, Barry Morris, welcomes Cameron Weeks, CEO of Fathom Voice to discuss how his company is using DBMS to break away from the pack and become the hottest player in VoIP. The webcast will include demonstrations of a single, logical database running in multiple geographies and a live Q&A.

If due to any reason, you cannot watch it live, do not worry at all, just register at this Registration Link, as after the event you will get the link to watch the event on-demand. You can watch the launch event at any time if you have registered for the launch.

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

SQL Contest – Identify the Database Celebrity – Win USD 100 Amazon Gift Card

Regular readers of this blog are familiar with NuoDB and their generous offers for SQLAuthority.com readers. I was just talking to them earlier and together we have come up with a very interesting contest for all of us.

This contest has two parts. Part 1 Identify Database Personality and in Part 2 You have to identify the size of the NuoDB installer. You have to answer both the questions to eligible to enter in the contest.

Part 1: Identify Database Celebrity

Personality 1 – He is known as the father of Relational Database

Personality 2 – He has received the Turing Award “for seminal contributions to database and transaction processing research and technical leadership in system implementation.”

Personality 3 – He invented the NuoDB Emergent Architecture, and developed the initial implementation of the product.

Part 2: Identify NuoDB Samples Database Names

Download NuoDB for Linux or Mac and install the software. Run the Quick Start sample app. Tell us what the four tables in the sample Hockey database are called. Download NuoDB Here.

Contest Details

The contest will be open till September 25th. The winner will be announced before September 30th. Remember there are only two gift cards each worth USD 100. All the valid entries will be hidden till September 25th. You must give correct answer to both the questions.

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

SQL – Weekend Project – Watching Technically Seth Series – What is your plan for this weekend?

“What is your plan for this weekend?” I was recently asked by my fellow colleague.

I replied: “I have plan learn about Big Data and SQL from Technically Seth.”

“Technically Seth!” He replied, “Never heard of him.”

“Honestly even he has not heard of you.” I tried to look serious while making fun of him.

“Come on tell me more.”

“Dude!” (tried with fake Californian accent) I replied – “Even I am going to learn this weekend.”

“But who is Seth?” He asks impatiently.

I finally decided to stop annoying him and I replied “Seth is the CTO at NuoDB. He has nearly 20 years of experience, focusing on distributed computing, networking, security and other fun systems problems. Before NuoDB Seth worked for Nokia, and before that Sun Microsystems, tackling large-scale systems and understanding not just how to make technology scale, but to do it in such a way that users can scale with it.”

With sign of relief my colleague asked “Ahha.. okey well and what is Technically Seth series? Is it like he explains a complex subject of big data and scalability?”

“Actually you are very correct here. Technical Seth series is a very interesting to watch video series where he explains various concepts around Big Data and NuoDB. I am going to watch all the episodes this weekend.”

“May be I should.”

“You must”, I insisted.

“May be I will.”

“That’s better – you must!”

“Have a great weekend Pinal!”

“You too buddy – have a technically Seth Weekend!”


Well, that was a my conversation with fellow colleague. This weekend I am going to spend time with NuoDB and Technically Seth series. There are so much to learn in the world but there is so little time for the same. We are so busy with our daily routine we often ignore learning new technology. I encourage all of you watch Technical Seth Series as well as Download NuoDB. I am will be implementing various concepts which I will learn from Technically Seth series and will share them over here in coming weeks.

There are five episodes of the Technically Seth series so far.

  • Deployment Architecture
  • No Sharding
  • Low Latency & Geo-distribution
  • High Availability
  • Data Replication

Important Links – Webpage of Technically Seth Series and Download NuoDB.

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

SQL Contest – Download NuoDB 1.2 to Win 20 Amazon Gift Cards

NuoDb have earlier released NuoDB 1.2 and I have been using it for an entire month and my favorite feature is their support to Stored Procedure. I am a big fan of stored procedures and their advantages. Nod 1.2 has received great response in the industry and it has emerged as a serious competitor to many of the NewSQL databases. To celebrate the success and reception in the industry. The kind folks at NuoDB have announced 20 Amazon Gift Card (each of USD 10).

To enter in the contest you just have to download NuoDB 1.2. Everybody who downloads NuoDB in the next 36 hours will be eligible in the contest.  At the end of 36th hour, 20 winners will be selected and sent USD 10 Amazon Gift Card. This contest is open everywhere in the world and there is no other restriction.

Here are the details about the latest release. I am pretty excited with their product and all the new features.

SQL Explorer improvements

  • The NuoDB Schema Definition for defining new schemas, tables, columns, and keys via  easy-to-use UI gestures;
  • Multi-line statements are now supported in the query window.

A unique take on stored procedures (preview) that allows users to:

  • Scale-out at high performance; internal testing on DBT-2 resulted in a 3X increase in an already high performance of 1Million+ transactions per second;
  • Run procedures on multiple hosts;
  • Support for high-level languages like Java, .NET and JavaScript.

Enhanced SQL functions to:

  • Aid the user in more easily understanding his/her data. NEED MORE FROM ENGINEERING ON MIN/MAX OR WHATEVER

You can read my earlier article describing the same over here. You can download NuoDB 1.2.

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

SQL – NuoDB Releases 1.2 has Several SQL Enhancements

I have been following NuoDB for quite a while and the matter of the fact, I am very much impressed with the product. What impresses me that release cycle. Every 2-3 month they add some really new features to their products and make it more mature. When I was using NuoDB 1.0, I was thinking that they have finished the development of the product as it was very stable release and had pretty much most of the features which I was looking for. However, when I see the latest release of NuoDB 1.2, I can clearly see that they have indeed progressed a lot and have added features which some of the ancient database applications might have added after many years of the development of the product.

Here are the details about the latest release. I am pretty excited with their product and all the new features.

SQL Explorer improvements

  • The NuoDB Schema Definition for defining new schemas, tables, columns, and keys via  easy-to-use UI gestures;
  • Multi-line statements are now supported in the query window.

A unique take on stored procedures (preview) that allows users to:

  • Scale-out at high performance; internal testing on DBT-2 resulted in a 3X increase in an already high performance of 1Million+ transactions per second;
  • Run procedures on multiple hosts;
  • Support for high-level languages like Java, .NET and JavaScript.

Enhanced SQL functions to:

  • Aid the user in more easily understanding his/her data. NEED MORE FROM ENGINEERING ON MIN/MAX OR WHATEVER

Personally I was looking forward to Multi-line statements improvement very much eagerly as I think that feature was definitely required for mature product like NuoDb. In the real world we often need to run more than one line statements in our SQL Explorer for testing purpose and I am glad to see that it is now available in the query explorer for developers. Please note that this feature was for sure available when we were running code using application but was not there in SQL Explorer. I am delighted that the kind folks at NuoDB heard the feedback and immediately released the new version with this feature included. This demonstrates that how agile and customer oriented the organization is. Hats off to the team who took the feedback seriously and acted on it positively.

Call to Action

I have downloaded NuoDB earlier, if you haven’t experienced it so far the goodness of the product, I suggest you try it out today.

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

SQL – Download Database Cheat Sheet for MongoDB, NuoDB, MySQL for FREE

In the new database world there are so many different solutions, vendors and options available that it is super hard to figure out which database is the right solution for us. First of all the world of the big data itself is very confusing. It is so hard to figure out from where to start and where to stop. There are so many tutorials out but none of them addresses the need of the absolute beginner.

Now the same thing goes to the next level when one has to select the right database for their organization and there is no clear guidance. I was discussing the same thing with the NuoDB folks last month. The NuoDB is a great product, but it is extremely important to know where exactly NuoDB stands when compared with other product. Interesting enough the smart folks at NuoDB has come up with a Cheat Sheet which compares NuoDB with the other industry known database.

The best part is that even though we do not have enough time for learning all the other database in depth, it is totally possible to take 60 seconds of the time and see the comparison of the features in this cheatsheet.

Download “The Decision Maker’s Cheat Sheet” to compare NuoDB, MySQL and MongoDB on:

SQL / ACID transactions
Distributed Multi-version Concurrency Control (MVCC)
Elastic scale-out performance
Integration with existing tools and frameworks
Geo-distributed data management

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

SQL – Contest to Get The Date – Win USD 50 Amazon Gift Cards and Cool Gift

If you are a regular reader of this blog – you will find no issue at all in resolving this puzzle. This contest is based on my experience with NuoDB.

If you are not familiar with NuoDB, here are few pointers for you.

In today’s contest you have to answer following questions:

Q 1: Precision of NOW()

What is the precision of the NuoDB’s NOW() function, which returns current date time?

Hint: Run following script on NuoDB Console Explorer section:

SELECT NOW() AS CurrentTime
FROM dual;

Here is the image. I have masked the area where the time precision is displayed.

Q 2: Executing Date and Time Script

When I execute following script –

SELECT 'today' AS Today, 'tomorrow' AS Tomorrow, 'yesterday' AS Yesterday
FROM dual;

I will get the following result:

 

NOW – What will be the answer when we execute following script? and WHY?

SELECT CAST('today' AS DATE) AS Today, 
 CAST('tomorrow' AS DATE) AS Tomorrow, 
 CAST('yesterday'AS DATE) AS Yesterday
FROM dual;

HINT: Install NuoDB (it takes 90 seconds).

Prizes:

  • 2 Amazon Gifts
  • 2 Limited Edition Hoodies (US resident only)

 

Rules:

  • Please leave an answer in the comments section below.
  • You must answer both the questions together in a single comment.
  • US resident who wants to qualify to win NuoDB apparel please mention your country in the comment.
  • You can resubmit your answer multiple times, the latest entry will be considered valid.
  • Last day to participate in the puzzle is June 24, 2013.
  • All valid answer will be kept hidden till June 24, 2013.
  • The winner will be announced on June 25, 2013.
  • Two Winners will get USD 25 worth Amazon Gift Card. (Total Value = 25 x 2 = 50 USD)
  • The winner will be selected using a random algorithm from all the valid answers.
  • Anybody with a valid email address can take part in the contest.

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

SQL – NuoDB and Third Party Explorer – SQuirreL SQL Client, SQL Workbench/J and DbVisualizer

I recently wrote a four-part series on how I started to learn about and begin my journey with NuoDB. Big Data is indeed a big world and the learning of the Big Data is like spaghetti – no one knows in reality where to start, so I decided to learn it with the help of NuoDB. You can download NuoDB and continue your journey with me as well.

and in this blog post we will try to answer the most asked question about NuoDB.

“I like the NuoDB Explorer but can I connect to NuoDB from my preferred Graphical User Interface?”
Honestly, I did not expect this question to be asked of me so many times but from the question it is clear that we developers absolutely want to learn new things and along with that we do want to continue to use our most efficient developer tools. Now here is the answer to the question:

“Absolutely, you can continue to use any of the following most popular SQL clients.”
NuoDB supports the three most popular 3rd-party SQL clients. In all the leading development environments there are always more than one database installed and managing each of them with a different tool is often a very difficult task. Developers like to use one tool, which can control most of the databases. Once developers are familiar with one database tool it is very difficult for them to switch to another tool. This is particularly difficult when we developers find that tool to be the key reason for our efficiency.

Let us see how to install each of the NuoDB supported 3rd party tools along with a quick tutorial on how to go about using them.

SQuirreL SQL Client

First download SQuirreL Universal SQL client. On the Windows platform you can double-click on the file and it will install the SQuirrel client. Once it is installed, open the application and it will bring up the following screen. Now go to the Drivers tab on the left side and scroll it down. You will find NuoDB mentioned there.

Now right click over it and click on Modify Driver.

Now here is where you need to make sure that you make proper entries or your client will not work with the database. Enter following values:
Name: NuoDB
Example URL: jdbc:com:nuodb://localhost:48004/test
Website URL: http://www.nuodb.com

Now click on the Extra Class Path tab and Add the location of the nuodbjdbc.jar file. If you are following my blog posts and have installed NuoDB in the default location, you will find the default path as C:\Program Files\NuoDB\jar\nuodbjdbc.jar.

The class name of the driver is automatically populated.


Once you click OK you will see that there is a small icon displayed to the left of NuoDB, which shows that you have successfully configured and installed the NuoDB driver.

Now click on the tab of Alias tab and you can notice that it is empty. Now click on the big Plus icon and it will open screen of adding an alias.

“Alias” means nothing more than adding a database to your system. The database name of the original installation can be anything and, if you wish, you can register the database with any other alternative name.

Here are the details you should fill into the Alias screen below.

Name: Test (or your preferred alias)
Driver: NuoDB
URL: jdbc:com:nuodb://localhost:48004/test (This is for test database)
User Name: dba (This is the username which I entered for test Database)
Password: goalie (This is the password which I entered for test Database)
Check Auto Logon and Connect at Startup and click on OK.

That’s it! You are done. On the right side you will see a table name and on the left side you will see various tabs with all the relevant details from respective table. You can see various metadata, schemas, data types and other information in the table.

In addition, you can also generate script and do various important tasks related to database.

You can see how easy it is to configure NuoDB with the SQuirreL Client and get going with it immediately.

SQL Workbench/J

This is another wonderful client tool, which works very well with NuoDB. The best part is that in the Driver dropdown you will see NuoDB being mentioned there. Click here to download  SQL Workbench/J Universal SQL client.

The download process is straight forward and the installation is a very easy process for SQL Workbench/J. As soon as you open the client, you will notice on following screen the NuoDB driver when selecting a New Connection Profile.

Select NuoDB from the drop down and click on OK.


In the driver information, enter following details:
Driver: NuoDB (com.nuodb.jdbc.Driver)
URL: jdbc:com.nuodb://localhost/test
Username: dba
Password: goalie

While clicking on OK, it will bring up the following pop-up. Click Yes to edit the driver information.

Click on OK and it will bring you to following screen. This is the screen where you can perform various tasks.

You can write any SQL query you want and it will instantly show you the results. Now click on the database icon, which you see right on the left side of the word User=dba. 

Once you click on Database Explorer, you can perform various database related tasks.

As a developer, one of my favorite tasks is to look at the source of the table as it gives me a proper view of the structure of the database. I find SQL Workbench/J very efficient in doing the same.

DbVisualizer

DBVisualizer is another great tool, which helps you to connect to NuoDB and retrieve database information in your desired format. A developer who is familiar with DBVisualizer will find this client to be very easy to work with.

The installation of the DBVisualizer is very pretty straight forward. When we open the client, it will bring us to the following screen.

As a first step we need to set up the driver. Go to Tools >> Driver Manager.


It will bring up following screen where we set up the diver. Click on Create Driver and it will open up the driver settings on the right side.

On the right side of the area where it displays Driver Settings please enter the following values-
Name: NuoDB
URL Format: jdbc:com.nuodb://localhost:48004/test

Now under the driver path, click on the folder icon and it will ask for the location of the jar file. Provide the path as a C:\Program Files\NuoDB\jar\nuodbjdbc.jar and click OK. You will notice there is a green button displayed at the bottom right corner. This means the driver is configured properly.


Once driver is configured properly, we can go to Create Database Connection and create a database.

If the pop up show up for the Wizard. Click on No Wizard and continue to enter the settings manually.

Here is the Database Connection screen. This screen can be bit tricky. Here are the settings you need to remember to enter.
Name: NuoDB
Database Type: Generic
Driver: NuoDB
Database URL: jdbc:com.nuodb://localhost:48004/test
Database Userid: dba
Database Password: goalie
Once you enter the values, click on Connect.

Once Connect is pressed, it will change the button value to Reconnect if the connection is successfully established and it will show the connection details on lthe eft side.

When we further explore the NuoDB, we can see various tables created in our test application. We can further click on the right side screen and see various details on the table.

If you click on the Data Tab, it will display the entire data of the table.

The Tools menu also has some very interesting and cool features like Driver Manager, Data Monitor and SQL History.

Summary

Well, this was a relatively long post but I find it is extremely essential to cover all the three important clients, which we developers use in our daily database development. Here is my question to you?
Which one of the following is your favorite NuoDB 3rd-Party Database Client? (Pick One)

  • SQuirreL SQL Client
  • SQL Workbench/J
  • DbVisualizer

I will be very much eager to read your experience about NuoDB. You can download NuoDB from here.

Reference: Pinal Dave (http://blog.SQLAuthority.com)