Over a million developers have joined DZone.
{{announcement.body}}
{{announcement.title}}

Going NoSQL with SQL

DZone's Guide to

Going NoSQL with SQL

· Database Zone
Free Resource

Download the Guide to Open Source Database Selection: MySQL vs. MariaDB and see how the side-by-side comparison of must-have features will ease the journey. Brought to you in partnership with MariaDB.

Some time ago I discovered, by the help of a colleague, a NoSQL database  for SQL-server. More specifically a document oriented db-provider for SQL-server, written in C#.

Wait, what? It is called "No"-SQL for a reason! What do you mean?

Actually, now days, it doesn't really mean "No SQL". Let me use a (slightly shortened) quote from nosql-database.org:

NoSQL DEFINITION: Next Generation Databases mostly addressing some of the points: being non-relational, distributed, open-source and horizontally scalable.

The original intention has been modern web-scale databases with characteristics such as: schema-free, easy replication support, simple API, eventually consistent / BASE (not ACID), a huge amount of data and more. So the misleading term "NoSQL" (the community now translates it mostly with "Not only SQL") should be seen as an alias to something like the definition above.

Okey, cool, so what is this database you're talking about?

Let me present you, SisoDb (Simple Structure Oriented Db), a free Document Store database for SQL-server and SQLCE4. It's created by Daniel Wertheim and uses JSON to store the POCO* objects in tables.

One of the things that really got me interested is that, since it's using SQL-server, you also get all the great infrastructure that SQL-server provides, like security, replication, scheduler, etc. and it is easy to get started and use. Another thing is that it even works with Azure.

Getting started

In my next blog post I will show you how we can implement a simple blog in ASP.NET MVC using SisoDb. But if you want to quick start, watch the short video below, from Daniel Wertheim. Also visit the SisoDb homepage and read the core concepts.


Interested in reducing database costs by moving from Oracle Enterprise to open source subscription?  Read the total cost of ownership (TCO) analysis. Brought to you in partnership with MariaDB.

Topics:

Published at DZone with permission of Mario Sannum, DZone MVB. See the original article here.

Opinions expressed by DZone contributors are their own.

THE DZONE NEWSLETTER

Dev Resources & Solutions Straight to Your Inbox

Thanks for subscribing!

Awesome! Check your inbox to verify your email so you can start receiving the latest in tech news and resources.

X

{{ parent.title || parent.header.title}}

{{ parent.tldr }}

{{ parent.urlSource.name }}