2.
SQL, NOSQL, AND POLYGLOT PERSISTENCE
• Microsoft published a book
on 10/15/13 on the benefits
of combining SQL data and
unstructured data
• This webinar explores the
practical implementation of
this strategy

3.
QUESTIONS TO ANSWER
•
•
•
•
•
What is NoSQL?
What is Polyglot Persistence (aka hybrid)?
How do you integrate SQL and NoSQL?
Why is it important?
How does a hybrid .NET, SQL and NoSQL Database benefit
your applications?
• What are the steps to enable your apps to use a
hybrid solution?

4.
WHAT IS NOSQL?
A NoSQL (Not Only SQL) database provides a mechanism for storage and
retrieval of data that employs less constrained consistency models than
traditional relational databases. Motivations for this approach include
simplicity of design, horizontal scaling and finer control over availability.
(Source: Wikipedia)
•
•
•
•
•
Distributed computing – scale out versus scale up
Fault tolerance through mirroring/replication
Ability to be schema-less and handle unstructured data
Eventually consistent as opposed to fully consistent
Several approaches – Key Value, Document, Graph etc

9.
WHAT IS POLYGLOT PERSISTENCE?
Polyglot Persistence, like polyglot programming, is all about choosing the
right persistence option for the task at hand.
Scott Leberknight
Different databases are designed to solve different problems. Using a single
database engine for all of the requirements usually leads to non- performant
solutions.
Martin Fowler
Polyglot Persistence is about using hybrid storage approach (RDBMS,
NOSQL,BLOB,FILE) that allows you to use the best tool for the job versus
being locked into one approach.
FatCloud

14.
WHY IS POLYGLOT (a.k.a HYBRID) IMPORTANT?
“…the advent of NoSQL databases has meant that many application
developers, designers, and architects are now looking to apply the most
appropriate means of data storage to each specific aspect of their systems,
and this may involve implementing multiple types of database and
integrating them into a single solution.”
Microsoft, “Data Access for Highly Scalable Solutions”, 2013
• One size may not fit all that well
• We can now use the best tools or toolset for the job