Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I am currently evaluating NuoDB as a replacement for SQL Server. The application is written in C#, .NET 4.0.

Now I am using features of SQL Server like:

  • Common Table Expressions (I have a table with a reference to itself composing a n-level parent-chilren hierarchy)
  • Stored Procedures
  • Bulk Uploads

I didn't find enough reference on NuoDB to understand if it is suitable to do these things:

  • Large select operations with hierarchy logics (now I use a recursive CTE on the 'items' table to accomplish this)
  • Complex updates/inserts thru some kind of algorithm (stored procs would be ok)
  • Bulk insert/update of 100.000+ elements (I am using bulk upload feature of SQL Server .NET client and it works ok)

Besides this, I am also interested in partitioning, anybody has some experience in partitioning with NuoDB?

Thanks

share|improve this question
    
thanks @mrdenny I don't have enough reputation to create a new tag –  Genesio Apr 28 '13 at 9:32
    
No problem. :) Happy to help. –  mrdenny Apr 28 '13 at 9:33
    
You can download NuoDB for free and try for yourself. Or simply read the manual: nuodb.com/community/documentation.php –  a_horse_with_no_name Apr 28 '13 at 9:49
1  
Maybe if you told us why you want to switch, there might be other alternatives as well. –  a_horse_with_no_name Apr 28 '13 at 9:59
1  
You can scale a MSSQL database across multiple boxes. It isn't easy to do, but it can be done. For 99% of databases it isn't needed, you just scale up to a bigger server. –  mrdenny Apr 28 '13 at 12:01

2 Answers 2

up vote 3 down vote accepted

The manual for CREATE PROCEDURE states: "Not Yet Implemented"

The documentation of the SELECT statement neither shows a WITH nor an alternative like connect by (as e.g. Cubrid does).

For bulkloading there is nuoloader but there doesn't seem to be an API for it.

But you will probably get a better answer if you post directly to the NuoDB forum: http://www.nuodb.com/community/forum.php?

I had a look at NuoDB as well and was pretty disappointed by the lack of SQL features. I guess that's not their main focus right now.

share|improve this answer
    
thanks, I also found this: nuodb.com/community/… - I think NuoDB is not my right choice for the moment!! than you!!! –  Genesio Apr 28 '13 at 10:07

Thanks for your feedback. NuoDB provides standards compliant SQL support, which includes strong language integration with LINQ and the Entity Framework. Besides .NET language support, NuoDB also supports JDBC, ODBC, Node.JS, Ruby/JRuby ActiveRecord & RAILS, PHP/PDO, and Hibernate.

Most importantly we do that with elastic scale-out support, an active/active redundancy model that includes geo-redundancy, and the ability to co-locate an in memory transaction engine close to the application to avoid network overhead and latency. Because of that we have excellent performance characteristics without the need for stored procedures or specialized bulk-loaders.

That all said, we are rapidly adding additional SQL features with each quarterly feature release and plan to release stored procedures in just a few months. In reference to CTEs, we don't have those but we support sub-queries and views, so in many cases you can get what you need with things that the product has today.

Adam (I'm responsible for the engineering team at NuoDB)

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.