2014-07-10T11:53:00Z

How does NuoDB compare to MySQL and SQL Server?

AS
  • 6
  • 32
PeerSpot user
4

4 Answers

it_user135978 - PeerSpot reviewer
Vendor
2014-07-11T09:07:25Z
Jul 11, 2014

Hi,

I'm not familiar with NuoDB, since I work mostly with MS SQL, but it seems that it's main advantage is that it can be scaled very easy:

"In the interest of full disclosure, I work for NuoDB as a technology
evangelist. I have also had very good experiences with SQL Server in the
past. However, I don't think it's necessary to view this posting through
the lens of SQL Server vs. NuoDB. In my opinion it's about selecting the
right tool for the job. NuoDB has introduced a new innovation that enables
developers to build their applications on a single logical database and
scale their database horizontally to handle predictable and unpredictable
spikes in traffic . Horizontal scaling happens completely transparently and
without any changes to the application itself. Feel free to try it for
yourself. We ship with a sample eCommerce application that demonstrates our
capabilities. We also ship with our own ADO.NET driver so you can continue
to use the great tools that come with Visual Studio and SQL Server for
development and reporting."

On the other hand, 2014 has also increased scalability:
"SQL Server 2014 has increased the number of logical processors to 640 and
memory up to 4 TBs."

I can't imagine the company where this won't be enough :)
The hardware is the last option for dealing with performance problems. The
right architecture and database design usually solves all performance
problems.

There is so many features in ms sql server, years of studying of the best
developers in the world, still far from perfect but could be used in many
different scenarios. I guess NuoDB is more narrow, oriented to some
specific scenario and for that scenario could be better than MS SQL. As I
say, I'm not familiar with it. But from description it is very positive.

So, it depends on your needs. You must discover your needs and than find if
NuoDB would satisfy them.
And also budget have usually important role.

MySQL has far less features than MSSQL, but it comes with less cost and
since users typically use only 30% of MS SQL features, it could be enough.
So, again, it depends on your needs.

In our company budget for SQL server is not the case, so we decided for MS
SQL, which is overall better(in the way that it covers more scenarios)
product than my sql, probably more comparable with oracle than mysql.
And also important aspect is that your needs could change, and with MS SQL
you are probably on safe side while with my sql you could got stuck.
Sometimes it is better to buy the product which could support the most,
even if many of the features you don't need today.

br, Simon

Product comparison that may be of interest to you
it_user71118 - PeerSpot reviewer
Vendor
2014-07-10T15:02:05Z
Jul 10, 2014

Every one has its good and its not so good parts. MySQL is suffering from derived queries index usage, but it can simulate variables assignments as in a while/end loop when processing rows. MS SQL cannot simulate loops with conditional variable assignments in statements, but it is optimizing multiple layers of queries.
On the other hand NuoDB is designed for cloud storage/access and on the spot manipulation of configuration, where MS & My can have clusters pre defined and configured, Hadoop is an extension for MySQL to make it work in clusters. MS SQL also supports clusters within a defined group or with extra configuration steps for different cluster groups. All servers support big data but every one has its limitations and it really depends on your functionality requirements. Remember also cloud data are open from everywhere and extra security steps should be planned for compliance and regulations on top of the standard security credentials and filtering which apply to secured physical office placed servers.

it_user116742 - PeerSpot reviewer
Consultant
2014-07-10T13:18:26Z
Jul 10, 2014

SQL Server for big data but MySQL for small data. I support MySQL.

Vendor
2014-07-10T12:04:23Z
Jul 10, 2014

Please check out this link: http://db-engines.com/en/system/Microsoft+SQL+Server%3BMySQL%3BNuoDB

Find out what your peers are saying about Microsoft, Oracle, SAP and others in Relational Databases Tools. Updated: March 2024.
765,386 professionals have used our research since 2012.
Relational Databases Tools
What is a relational database? A database is an organized collection of structured data that is electronically stored in a computer system. A relational database is an intuitive database that stores and supplies access to various related data points. A relational database is based on the relational model where data is stored in tables in an intuitive and straightforward way, similar to an Excel spreadsheet. In this management system, tables are used to store complex data, which can be...
Download Relational Databases Tools ReportRead more

Related Q&As

Relational Databases Tools experts

Luis Mario Ramos Santos - PeerSpot reviewer
Bahattin Yetismis - PeerSpot reviewer
Siddharth Matalia - PeerSpot reviewer
Joyee Sen - PeerSpot reviewer
Kevin Honde - PeerSpot reviewer
Md Al-Amin - PeerSpot reviewer
Faustine Chisasa - PeerSpot reviewer
Muhammad_Irfan - PeerSpot reviewer