SQLAuthority News – NuoDB Announces Webinar Series To Demystify Cloud Data Management

For those of you who read my blog regularly, you know that I’ve been evaluating NuoDB, a new database company that is re-writing the rules for relational databases. They’ve introduced a new category – Cloud Data Management Systems (CDMS) – and are claiming to be the first and only.

In an effort to ‘demystify CDMS’, they’re kicking-off a 5 part webcast series where industry experts, analysts, customers and partners will join NuoDB to cover a range of topics related to managing data in the cloud.

If you’re curious about the difference between a CDMS and a NoSQL store, NewSQL or even a 1980s RDBMS, like I am, this would be a good webcast to attend.

The first one starts tomorrow, Feb 19, at 12:00 p.m. EST.  It features Principal Analyst from Ovum, Tony Baer, and NuoDB’s CEO Barry Morris, and promises to cover:

  • Cloud database adoption, challenges and opportunities
  • What it means to be in the Cloud vs. on the Cloud
  • 12 Rules of CDMS and the need for Emergence
  • NewSQL vs. NoSQL vs. SQL

Tony Baer leads Ovum`s Big Data research practice. Over his 25 years in the industry, Baer has studied issues of data integration, software and data architecture, middleware, and application development. Having tracked the emergence of BI and data warehousing back in the 1990s, Baer sees similar parallels emerging in the world of big data today and discusses this frequently in his blog and Twitter feed. Baer’s coverage focuses on how Big Data must become a first class citizen in the data center, IT organization, and the business. He’s definitely someone worth listening to!

And as many of you know, Barry Morris also has over 25 years of industry experience in the USA and Europe, running private and public companies ranging in scale from early startup phase to 1,000+ employees. He loves to build companies around industry-changing paradigm-shifts in technology. Another great person to hear from!

Registration is required and you can register here. I’ll be there. Will you?

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

SQL SERVER – Contest to Win Amazon Card – Experience Cloud Data Management System (CDMS) and NuoDB

The world of database is changing. The traditional client server installation on premises still has a place in many organizations but many of these organizations are facing challenges with this setup setup as their data is growing exponentially every day. Well, as time changes the innovation is required. If you are reading this blog, you might have attended the announcement of the NuoDB General Availability. The event was highly attended and there was lots of interest for the product.

NuoDB has announced the general availability of NuoDB Starlings Release (V 1.0) – the industry’s first and only Cloud Data Management System (CDMS). I have just downloaded their product and trying out various features, they promised. I will be writing a detailed blog post as we go further on various aspects of the product.

There are two different editions of the product available – the Developer and Pro Editions.

Developer Editions (FREE)

This edition allows users to develop NuoDB apps at full throttle without restrictions on data size or number of hosts.  There is no charge associated with this edition. Additionally, it allows user to upgrade to pro edition when they are ready for commercial deployment. Register & Download  the Developer Edition today for FREE.

Pro Edition

This edition is very robust edition and it can handle millions of transactions per second, a huge number of concurrent users and Big Data on commodity hardware. And it’s free for apps that demand high transactional throughput with low storage requirements.

CONTEST

Here is good news – you can join me with the evaluation of the product. I am going to download the product and test various aspects of the product, you can do the same.

The good folks at NuoDB will give USD 10 Amazon Card to first 25 folks who download this product between now and Jan 31, 2013 11:59 PM EST.

Additionally, here is a bonus question for you – What is the maximum data storage capacity of Pro Edition? Leave a comment and you may win something really cool from me.

Here’s a few reasons I am finding this product interesting:

  • Elastic scalability built for the cloud.
    NuoDB scales elastically to improve transactions per second performance and handle both massive concurrency and data volume. Out and in; by simply adding or removing nodes.
  • 100% SQL, 100% ACID, 0% Hassle.
    This brand new CDMS has all of the features you want (like elastically scalable in the cloud with 100% ACID guarantees and SQL compliance) and none of the things you don’t (like complex database administration tasks).
  • Blistering Performance.
    NuoDB exceeds 1 million transactions per second in YCSB benchmark, all on inexpensive commodity hardware.

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

SQLAuthority News – Register for NuoDB the Elastically Scalable, SQL/ACID Database

nuodbbanner SQLAuthority News   Register for NuoDB the Elastically Scalable, SQL/ACID DatabaseIf you are reading this blog, you will be familiar with the innovative database product NuoDB, which I have been experimenting recently. I have been working with this product since last year. I got my hand’s on this product when the product was in its very early phase as well, the product was yet to be ready. Now I feel very proud when I hear the announcement the product which I have seen growing from an infant stage to become extremely mature product.

NuoDB started with a blank slate to design a brand new Cloud Data Management System (CDMS) that has all of the features you want: 100% SQL, 100% ACID, 100% Elastically Scalable. The reason I call it innovative because an NuoDB user does not have to worry about any of the following:

  • NO partitioning or sharding
  • NO clustering
  • NO complex database administration
  • NO performance tuning

 It just works – no wonder they have patents on this innovative product. Well, now is the best part, the product is going to launch live on January 15th, 2013. This one-hour event will be available on the Web live.

On January 15, 2013, NuoDB, the world’s first and only patented, elastically scalable, SQL/ACID database, becomes generally available!

Register for the event on January 15, 11 AM EST! 

Matt Aslett, an analyst at The 451 Group, NuoDB execs and NuoDB customer representatives will:

  • Unveil a new standard for SQL database performance
  • Issue an industry-wide performance challenge
  • Show how top enterprise customers already use NuoDB
  • Explain the rapidly changing database landscape
  • Define what a 21st century database has to be

I will be there will you? 

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

SQLAuthority News – NuoDB RC2 Available to Download – General Availability in Near Future

nuoDB logo rgb 300 SQLAuthority News   NuoDB RC2 Available to Download   General Availability in Near FutureRegular readers who are familiar with my blog will be also familiar with my interest in NuoDB. It is a very innovative new age database which follows 100% SQL, ACID and Elastically Scalability. Here is an earlier article on this subject where we explain why sharing will no more required due to the implementation of the NuoDB.

Each NuoDB database consists of at least three or more processes that enable a single database to run across multiple hosts. These processes include a Broker, a Transaction Engine and a Storage Manager.  Brokers are responsible for connecting client applications to Transaction Engines and maintain a global view of the network to keep track of the multiple Transaction Engines available at any time. Transaction Engines are in-memory processes that client applications connect to for processing SQL transactions. Storage Managers are responsible for persisting data to disk and serving up records to the Transaction Managers if they don’t exist in memory.

NuoDB had just made announcement that NuoDB Release Candidate (RC2) is now available for download. It is a very stable release and have many bugs fixed.

Here are few of the new enhancements in the product:

  • SQL Improvements
    • Improved support in NuoDB SQL for time zones. Continued improved compliance with the standard.
    • New EXPLAIN statement
    • Support for ‘!=’ operator.
  • Tunable Commit Protocol Improvements
    • Improvements in support for configurable durability
  • Administration
    • Feature enhancements for the command line administration tool (NuoDB Manager).
    • Feature enhancements and improved usability for NuoConsole
    • New option that allows starting a database in non-durable mode.
    • New warning message in case the user tries to use the Web Console with JavaScript turned OFF
  • Using NuoDB APIs
    • Support for com.nuodb.jdbc.DataSource has been added.
  • Drivers and Connections
    • Significant improvements in JRuby Driver
    • Improvements in soft shutdown performance

You can download the this innovative database from here.

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

SQL SERVER – Shard No More – An Innovative Look at Distributed Peer-to-peer SQL Database

There is no doubt that SQL databases play an important role in modern applications. In an ideal world, a single database can handle hundreds of incoming connections from multiple clients and scale to accommodate the related transactions. However the world is not ideal and databases are often a cause of major headaches when applications need to scale to accommodate more connections, transactions, or both.

nuodbshard1 SQL SERVER   Shard No More   An Innovative Look at Distributed Peer to peer SQL Database

In order to overcome scaling issues, application developers often resort to administrative acrobatics, also known as database sharding. Sharding helps to improve application performance and throughput by splitting the database into two or more shards. Unfortunately, this practice also requires application developers to code transactional consistency into their applications. Getting transactional consistency across multiple SQL database shards can prove to be very difficult.

nuodbshard2 SQL SERVER   Shard No More   An Innovative Look at Distributed Peer to peer SQL Database

Sharding requires developers to think about things like rollbacks, constraints, and referential integrity across tables within their applications when these types of concerns are best handled by the database. It also makes other common operations such as joins, searches, and memory management very difficult. In short, the very solution implemented to overcome throughput issues becomes a bottleneck in and of itself.

What if database sharding was no longer required to scale your application? Let me explain. For the past several months I have been following and writing about NuoDB, a hot new SQL database technology out of Cambridge, MA. NuoDB is officially out of beta and they have recently released their first release candidate so I decided to dig into the database in a little more detail. Their architecture is very interesting and exciting because it completely eliminates the need to shard a database to achieve higher throughput.

Each NuoDB database consists of at least three or more processes that enable a single database to run across multiple hosts. These processes include a Broker, a Transaction Engine and a Storage Manager.  Brokers are responsible for connecting client applications to Transaction Engines and maintain a global view of the network to keep track of the multiple Transaction Engines available at any time. Transaction Engines are in-memory processes that client applications connect to for processing SQL transactions. Storage Managers are responsible for persisting data to disk and serving up records to the Transaction Managers if they don’t exist in memory.

The secret to NuoDB’s approach to solving the sharding problem is that it is a truly distributed, peer-to-peer, SQL database. Each of its processes can be deployed across multiple hosts. When client applications need to connect to a Transaction Engine, the Broker will automatically route the request to the most available process. Since multiple Transaction Engines and Storage Managers running across multiple host machines represent a single logical database, you never have to resort to sharding to get the throughput your application requires.

nuodbshard3 SQL SERVER   Shard No More   An Innovative Look at Distributed Peer to peer SQL Database

NuoDB is a new pioneer in the SQL database world. They are making database scalability simple by eliminating the need for acrobatics such as sharding, and they are also making general administration of the database simpler as well.  Their distributed database appears to you as a user like a single SQL Server database.  With their RC1 release they have also provided a web based administrative console that they call NuoConsole. This tool makes it extremely easy to deploy and manage NuoDB processes across one or multiple hosts with the click of a mouse button. See for yourself by downloading NuoDB here.

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

 

SQLAuthority News – Amazon Gift Card Raffle for Beta Tester Feedback for NuoDB

nuoDB logo rgb 300 SQLAuthority News   Amazon Gift Card Raffle for Beta Tester Feedback for NuoDBAs regular readers know I’ve been spending some time working with the NuoDB beta software. They contacted me last week and asked if I would give you a chance to try their new web-based console for their scalable, SQL-compliant database.

They have just put out their final beta release, Beta 9.  It contains a preview of a new web-based “NuoConsole” that will replace and extend the functionality of their current desktop version.  I haven’t spent any time with the new console yet but a really quick look tells me it should make it easier to do deeper monitoring than the older one. It also looks like they have added query-level reporting through the console. I will try to play with it soon.

NuoDB is doing a last, big push to get some more feedback from developers before they release their 1.0 product sometime in the next several weeks. Since the console is new, they are especially interested in some quick feedback on it before general availability.

For SQLAuthority readers only, NuoDB will raffle off three $50 Amazon gift cards in exchange for your feedback on the NuoConsole preview.

Here’s how to Enter

  1. Download NuoDBeta 9 here
  2. You must build a domain before you can start the console.
  3. Launch the Web Console.
    1. Windows Code: start java -jar jarnuodbwebconsole.jar
    2. Mac, Linux, Solaris, Unix Code: java -jar jar/nuodbwebconsole.jar
  4. Access the Web Console: Code: http://localhost:8080
  5. When you have tried it out, go to a short (8 question) survey to enter the raffle
  6. Click here for the survey
  7. You must complete the survey before midnight EDT on October 17, 2012.

Here’s what else they are saying about this last beta before general availability:

  • Beta 9 now supports the Zend PHP framework so that PHP developers can directly integrate web applications with NuoDB.
  • Multi-threaded HDFS support – NuoDB Storage Managers can now be configured to persist data to the high performance Hadoop distributed file system (HDFS). Beta 9 optimizes for multi-thread I/O streams at maximum performance. This enhancement allows users to make Hadoop their core storage with no extra effort which is a pretty cool idea.
  • Improved Performance –On a single transaction node, Beta 9 offers performance comparable with MySQL and MariaDB. As additional nodes are added, NuoDB performance improves significantly at near linear scale.
  • Query & Explain Plan Logging – Beta 9 introduces SQL explain plans for your queries. Qualify queries with the word “EXPLAIN” and NuoDB will respond with the details of the execution plan allowing performance optimization to SQL.
  • Through the NuoConsole, you can now kill hung or long running queries.
  • Java App Server Support – Beta 9 now supports leading Web JEE app servers including JBoss, Tomcat, and ColdFusion.

They’ve also reported:

  • Improved PHP/PDO drivers
  • Support for Drupal
  • Faster Ruby on Rails driver
  • The Hibernate Dialect supports version 4.1
  • And good news for my readers: numerous SQL enhancements

They will share the results of the web console feedback with me.  I’ll let you know how it goes.

Also the winner of their last contest was Jaime Martínez Lafargue! 

Do leave a comment here once you complete the survey. 

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

SQL SERVER – Solution – 2 T-SQL Puzzles – Display Star and Shortest Code to Display 1

Earlier on this blog we had asked two puzzles. The response from all of you is nothing but Amazing. I have received 350+ responses. Many are valid and many were indeed something I had not thought about it.

I strongly suggest you read all the puzzles and their answers here – trust me if you start reading the comments you will not stop till you read every single comment. Seriously trust me on it. Personally I have learned a lot from it.

Let us recap the puzzles here quickly.

Puzzle 1:

Why following code when executed in SSMS displays result as a * (Star)?

SELECT CAST(634 AS VARCHAR(2))

Puzzle 2:

Write the shortest code that produces results as 1 without using any numbers in the select statement.

Bonus Q:

How many different Operating System (OS) NuoDB support?

As I mentioned earlier the participation was nothing but Amazing. I will write about the winners and the best answers in short time. Meanwhile I will give to the point answers to above puzzles.

Solution 1:

When you convert character or binary expressions (char, nchar, nvarchar, varchar,binary, or varbinary) to an expression of a different data type, data can be truncated, only partially displayed, or an error is returned because the result is too short to display. Conversions to char, varchar, nchar, nvarchar, binary, and varbinary are truncated, except for the conversions shown in the following table.

anspuz1 SQL SERVER   Solution   2 T SQL Puzzles   Display Star and Shortest Code to Display 1

Reference of the text and table from MSDN.

Solution 2:

The shortest code to produce answer 1 :

SELECT EXP($)

or

SELECT COS($)

or

SELECT DAY($)

anspuz2 SQL SERVER   Solution   2 T SQL Puzzles   Display Star and Shortest Code to Display 1

When SELECT $ it gives us the result as 0.00 and the EXP of the same is 1. I believe it is pretty neat. There were plenty other answers but this was the shortest. Another shorter answer would be PRINT EXP($) but no one has proposed that as in original Question I have explicitly mentioned SELECT in the original question.

Bonus Answer:

5 OS: Windows, MacOS, Linux, Solaris, Joyent SmartOS Reference

anspuz3 SQL SERVER   Solution   2 T SQL Puzzles   Display Star and Shortest Code to Display 1

Please do read every single comment here. Do leave a comment which one do you think is the best comment out of all the comments. Meanwhile if there is a better solution and I have missed it do let me know as we still have time to correct it. I will be selecting the winner before the weekend as I am going through each and every of 350 comment.

I will be selecting the best comments along with the winning comment. If our selection matches – one of you may still win something cool. 

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

SQL SERVER – 2 T-SQL Puzzles and Win USD 50 worth Amazon Gift Card and 25 Other Prizes

We all love brain teasers and interesting puzzles. Today I decided to come up with 2 interesting puzzles and winner of the contest will get USD 50 worth Amazon Gift Card. The puzzles are sponsored by NuoDB. Additionally, The first 25 individuals who download NuoDB Beta 8 by midnight Friday, Sept. 21 (EST) will automatically receive a $10 Amazon gift card.

Puzzle 1:

Why following code when executed in SSMS displays result as a * (Star)?

SELECT CAST(634 AS VARCHAR(2))

puzzlestar SQL SERVER   2 T SQL Puzzles and Win USD 50 worth Amazon Gift Card and 25 Other Prizes

Puzzle 2:

Write the shortest code that produces results as 1 without using any numbers in the select statement.

puzzle1 SQL SERVER   2 T SQL Puzzles and Win USD 50 worth Amazon Gift Card and 25 Other Prizes

Bonus Q:

How many different Operating System (OS) NuoDB support?
Click here HINT

If you can solve above puzzles you will be eligible for winning USD 50 Amazon Gift Card. However, you can always enroll yourself for following Bonus Prizes where if you have good chance of winning USD 10 Amazon Gift Card (if you are first 25 individual in specific time).

Bonus Prizes:

The first 25 individuals who download NuoDB Beta 8 by midnight Friday, Sept. 21 (EST) will automatically receive a $10 Amazon gift card.

Rules:

  • Please leave an answer in the comments section below.
  • You can resubmit your answer multiple times, the latest entry will be considered valid.
  • The winner will be announced on 1st October.
  • Last day to participate in the puzzle is September 28th, 2012.
  • All valid answer will be kept hidden till September 28th, 2012.
  • Only One Winner will get USD 50 worth Amazon Gift Card.
  • The first 25 individuals who download NuoDB Beta 8 by midnight Friday, Sept. 21 (EST) will automatically receive a $10 Amazon gift card.
  • The winner will be selected using random algorithm.

UPDATE: The winner of the contest is Jaime Mtnz Lafargue (@jaimeml)

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

SQL SERVER – Core Concepts – Elasticity, Scalability and ACID Properties – Exploring NuoDB an Elastically Scalable Database System

I have been recently exploring Elasticity and Scalability attributes of databases. You can see that in my earlier blog posts about NuoDB where I wanted to look at Elasticity and Scalability concepts. The concepts are very interesting, and intriguing as well. I have discussed these concepts with my friend Joyti M and together we have come up with this interesting read. The goal of this article is to answer following simple questions

  1. What is Elasticity?
  2. What is Scalability?
  3. How ACID properties vary from NOSQL Concepts?
  4. What are the prevailing problems in the current database system architectures?
  5. Why is NuoDB  an innovative and welcome change in database paradigm?

Elasticity

rubberband SQL SERVER   Core Concepts   Elasticity, Scalability and ACID Properties   Exploring NuoDB an Elastically Scalable Database System

This word’s original form is used in many different ways and honestly it does do a decent job in holding things together over the years as a person grows and contracts. Within the tech world, and specifically related to software systems (database, application servers), it has come to mean a few things – allow stretching of resources without reaching the breaking point (on demand).

What are resources in this context?

Resources are the usual suspects – RAM/CPU/IO/Bandwidth in the form of a container (a process or bunch of processes combined as modules). When it is about increasing resources the simplest idea which comes to mind is the addition of another container. Another container means adding a brand new physical node.

When it is about adding a new node there are two questions which comes to mind.

1) Can we add another node to our software system?
2) If yes, does adding new node cause downtime for the system?

Let us assume we have added new node, let us see what the new needs of the system are when a new node is added.

  • Balancing incoming requests to multiple nodes
  • Synchronization of a shared state across multiple nodes
  • Identification of “downstate” and resolution action to bring it to “upstate”

Well, adding a new node has its advantages as well. Here are few of the positive points

  • Throughput can increase nearly horizontally across the node throughout the system
  • Response times of application will increase as in-between layer interactions will be improved

Now, Let us put the above concepts in the perspective of a Database. When we mention the term “running out of resources” or “application is bound to resources” the resources can be CPU, Memory or Bandwidth. The regular approach to “gain scalability” in the database is to look around for bottlenecks and increase the bottlenecked resource.

When we have memory as a bottleneck we look at the data buffers, locks, query plans or indexes. After a point even this is not enough as there needs to be an efficient way of managing such large workload on a “single machine” across memory and CPU bound (right kind of scheduling)  workload. We next move on to either read/write separation of the workload or functionality-based sharing so that we still have control of the individual. But this requires lots of planning and change in client systems in terms of knowing where to go/update/read and for reporting applications to “aggregate the data” in an intelligent way. What we ideally need is an intelligent layer which allows us to do these things without us getting into managing, monitoring and distributing the workload.

Scalability

scalabilitys SQL SERVER   Core Concepts   Elasticity, Scalability and ACID Properties   Exploring NuoDB an Elastically Scalable Database System

In the context of database/applications, scalability means three main things

  • Ability to handle normal loads without pressure
    E.g. X users at the Y utilization of resources (CPU, Memory, Bandwidth) on the Z kind of hardware (4 processor, 32 GB machine with 15000 RPM SATA drives and 1 GHz Network switch) with T throughput
  • Ability to scale up to expected peak load which is greater than normal load with acceptable response times
  • Ability to provide acceptable response times across the system
    E.g. Response time in S milliseconds (or agreed upon unit of measure) – 90% of the time

The Issue – Need of Scale

In normal cases one can plan for the load testing to test out normal, peak, and stress scenarios to ensure specific hardware meets the needs. With help from Hardware and Software partners and best practices, bottlenecks can be identified and requisite resources added to the system. Unfortunately this vertical scale is expensive and difficult to achieve and most of the operational people need the ability to scale horizontally. This helps in getting better throughput as there are physical limits in terms of adding resources (Memory, CPU, Bandwidth and Storage) indefinitely.

Today we have different options to achieve scalability:

  1. Read & Write Separation
    The idea here is to do actual writes to one store and configure slaves receiving the latest data with acceptable delays. Slaves can be used for balancing out reads. We can also explore functional separation or sharing as well. We can separate data operations by a specific identifier (e.g. region, year, month) and consolidate it for reporting purposes.
    For functional separation the major disadvantage is when schema changes or workload pattern changes. As the requirement grows one still needs to deal with scale need in manual ways by providing an abstraction in the middle tier code.
  2. Using NOSQL solutions
    The idea is to flatten out the structures in general to keep all values which are retrieved together at the same store and provide flexible schema. The issue with the stores is that they are compromising on mostly consistency (no ACID guarantees) and one has to use NON-SQL dialect to work with the store.
    The other major issue is about education with NOSQL solutions. Would one really want to make these compromises on the ability to connect and retrieve in simple SQL manner and learn other skill sets? Or for that matter give up on ACID guarantee and start dealing with consistency issues?

Hybrid Deployment – Mac, Linux, Cloud, and Windows

allthree SQL SERVER   Core Concepts   Elasticity, Scalability and ACID Properties   Exploring NuoDB an Elastically Scalable Database System

One of the challenges today that we see across On-premise vs Cloud infrastructure is a difference in abilities. Take for example SQL Azure – it is wonderful in its concepts of throttling (as it is shared deployment) of resources and ability to scale using federation. However, the same abilities are not available on premise. This is not a mistake, mind you – but a compromise of the sweet spot of workloads, customer requirements and operational SLAs which can be supported by the team. In today’s world it is imperative that databases are available across operating systems – which are a commodity and used by developers of all hues.

An Ideal Database Ability List

nuodb SQL SERVER   Core Concepts   Elasticity, Scalability and ACID Properties   Exploring NuoDB an Elastically Scalable Database System

  • A system which allows a linear scale of the system (increase in throughput with reasonable response time) with the addition of resources
  • A system which does not compromise on the ACID guarantees and require developers to learn new paradigms
  • A system which does not force fit a new way interacting with database by learning Non-SQL dialect
  • A system which does not force fit its mechanisms for providing availability across its various modules.

Well NuoDB is the first database which has all of the above abilities and much more. In future articles I will cover my hands-on experience with it.

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

SQLAuthority News – Weekend Experiment with NuoDB – Points to Pondor and Whitepaper

This weekend I have downloaded the latest beta version of NuoDB. I found it much improved and better UI. I was very much impressed as the installation was very smooth and I was up and running in less than 5 minutes with the product. The tools which are related to the Administration of the NuoDB seems to get makeover during this beta release. As per the claim they support now Solaris platform and have improved the native MacOS installation. I neither have Mac nor Solaris – I wish I would have experimented with the same. I will appreciate if anyone out there can confirm how the installations goes on these platforms.

I have previously blogged about my experiment with NuoDB here:

question mark g SQLAuthority News   Weekend Experiment with NuoDB   Points to Pondor and WhitepaperI am very impressed with the product so far and I have decided to understand the product further deep. Here are few of the questions which I am going to try to find answers with regards to NuoDB. Just so it is clear – NuoDB is not NOSQL, matter of the fact, it is following all the ACID properties of the database.

  • If ACID properties are crucial why many NoSQL products are not adhering to it? (There are few out there do follow ACID but not all).
  • I do understand the scalability of the database however does elasticity is crucial for the database and if yes how? (Elasticity is where the workload on the database is heavily fluctuating and the need of more than a single database server is coming up).
  • How NuoDB has built scalable, elastic and 100% ACID compliance database which supports multiple platforms?
  • How is NOSQL compared to NuoDB’s new architecture?

In the next coming weeks, I am going to explore above concepts and dive deeper into the understanding of the same. Meanwhile I have read following white paper written by Experts at University of California at Santa Barbara. Very interesting read and great starter on the subject Database Scalability, Elasticity, and Autonomy in the Cloud.

Additionally, my questions are also talking about NoSQL, this weekend I have started to learn about NoSQL from Pluralsight‘s online learning library. I will share my experience very soon.

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