Tech Support Websites

  • Subscribe to our RSS feed.
  • Twitter
  • StumbleUpon
  • Reddit
  • Facebook
  • Digg

Thursday, 14 October 2010

Can NoSQL replace SQL Server?

Posted on 22:37 by Unknown
Twitter, Facebook, Digg, and Rackspace are notable sites using various types of NoSQL implementations.

Michael Otey explains why NoSQL isn’t really a viable replacement for SQL Server -
The term “NoSQL” was coined back in 1998, and it originally stood for Not Only SQL. So the name NoSQL is a bit of a misnomer.

NoSQL databases aren’t relational at all.

Today’s NoSQL databases are distributed data stores that are designed for very large-scale data access requirements. Probably the most popular NoSQL database is the Cassandra open source project. Cassandra began as Facebook’s proprietary database, but Facebook released it as open source in 2008.

Other NoSQL implementations include Google BigTable, Apache Hadoop, MapReduce, MemcacheDB, and Voldemort.

...though NoSQL databases are designed for performance and scalability, they aren’t designed to support the atomicity, consistency, isolation, and durability (ACID) properties that are standard in relational databases such as SQL Server....each different NoSQL implementation uses a proprietary data access mechanism.

SQL Server DBAs don’t need to fear that NoSQL represents some new technology wave that will sweep away relational databases like SQL Server. Instead NoSQL is just another tool in the application developer’s toolbox.

NoSQL implementations solve a data storage problem that relational databases weren’t really designed to address. So the bottom line on NoSQL is that NoSQL isn’t a technology that’s going to replace relational database systems like SQL Server—except in very specialized instances.
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest
Posted in SQL Server | No comments
Newer Post Older Post Home

0 comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Popular Posts

  • Windows 8 keyboard shortcuts
    Win + X   - context menu to access common features like Control Panel, Task Manager, File Explorer, Programs & Features, Run, Search etc...
  • Dashboard-like info with Browser tabs, Windows 7 Taskbar tabs
    Browser tabs & Windows 7 Taskbar tabs are turning self-aware.  This is how my browser looked the other day: I had the summary of all tha...
  • The State Of HTML5 Video
    Key points from the  The State Of HTML5 Video  report by LongTailVideo (last updated on April 19, 2012): 75% of the desktop & mobile bro...
  • Archive tweets & favorites with Google Reader
    There are numerous ways to archive tweets but rather than use yet another tool, I prefer using Google Reader to preserve the tweets I mark ...
  • TWIL - Week #3
    This Week I Learned: New Azure VM Image Templates include SQL Server, BizTalk Server, and SharePoint Server (2013?) images . This can be han...
  • What is the difference between Browser Mode & Document Mode in IE
    If you're a web developer and your job actively involves building web pages that work the same in all browsers including the last three ...
  • My 30-day personal project - watch 100 hours of Pluralsight videos
    Inspired by Matt Cutts' 30-day challenges , I plan to watch 100 hours of Pluralsight online videos to get up-to-date with current ...
  • Azure in Pictures - overview of Windows Azure Features, Services and Common Uses
    Download the Windows Azure Poster in PDF format (1.1MB)
  • Indian comparison shopping sites
    Did you know, India has 120 million Internet users & the Indian e-commerce market is worth $7 billion ?  Travel accounts for over 80 per...
  • HOW TO dynamically generate a Word document with custom header & footer
    Way back in 2004, a project I was working on required a web page to be exported as a Word document (.DOC). Without relying on any components...

Categories

  • AJAX
  • Android
  • APIs
  • App
  • ASP
  • ASP.NET
  • ASP.NET-MVC
  • Azure
  • Azure SQL Database
  • AzureInPictures
  • Bing
  • Book Review
  • Bookmarklet
  • Browsers
  • C#
  • chart
  • Chrome
  • Cloud
  • CSS
  • CSS3
  • DidYouKnow
  • E-Commerce
  • Excel
  • FB
  • Fiddler
  • Firefox
  • Gadgets
  • GeoLocation
  • GMail
  • Google
  • Google Docs
  • Google Reader
  • Health
  • Hotmail
  • HOWTO
  • HTML
  • HTML/CSS
  • HTML5
  • Humor
  • Hyderabad
  • IE
  • IIS
  • India
  • Internet
  • IT
  • Javascript
  • jQuery
  • JSON
  • JSONP
  • Laptop
  • Learning Resources
  • Lists
  • Map
  • Metrics
  • Microsoft
  • miscellaneous
  • Mobile
  • NAPA
  • Office365
  • Opera
  • PDF
  • Performance
  • Personal
  • PHP
  • PM
  • PowerShell
  • Privacy
  • Programming
  • Rant
  • Safari
  • Science
  • Search Engines
  • SearchEngines
  • Security
  • SEO
  • Sharepoint
  • SharePoint2013
  • Silverlight
  • Software Engineering
  • Solutions
  • SQL Azure
  • SQL Server
  • TFS
  • Tip
  • Tips
  • Tools
  • Tools/Utilities
  • Trivia
  • TWIL
  • Twitter
  • UX
  • VM
  • VS.NET
  • VS2010
  • VS2012
  • WCF
  • WebApps
  • Websites
  • WF
  • Windows Phone
  • Windows7
  • Windows8
  • Word
  • WP7
  • WPF

Blog Archive

  • ►  2013 (112)
    • ►  October (16)
    • ►  September (14)
    • ►  August (8)
    • ►  July (8)
    • ►  June (13)
    • ►  May (12)
    • ►  April (12)
    • ►  March (8)
    • ►  February (15)
    • ►  January (6)
  • ►  2012 (127)
    • ►  December (11)
    • ►  November (14)
    • ►  October (13)
    • ►  September (14)
    • ►  August (16)
    • ►  July (16)
    • ►  June (6)
    • ►  May (5)
    • ►  April (11)
    • ►  March (12)
    • ►  February (7)
    • ►  January (2)
  • ►  2011 (98)
    • ►  December (5)
    • ►  November (2)
    • ►  October (5)
    • ►  September (7)
    • ►  August (7)
    • ►  July (15)
    • ►  June (10)
    • ►  May (7)
    • ►  April (8)
    • ►  March (10)
    • ►  February (11)
    • ►  January (11)
  • ▼  2010 (163)
    • ►  December (14)
    • ►  November (19)
    • ▼  October (19)
      • Microsoft PDC 2010 highlights
      • Hotmail lets you download attachments as a zip file
      • Why YQL?
      • Windows 7 is 1 year old, Windows platform soon to ...
      • Adding new Search Provider easiest with Opera
      • Search from browser address bar in IE, Firefox, Opera
      • Impact of online reputation on job recruitments
      • When to use Sleep & Hibernate
      • Google Labs Script Converter Bookmarklet
      • Can NoSQL replace SQL Server?
      • SharePoint in Pictures
      • Words that leave Google Instant speechless
      • Inside: Google on National Geographic channel
      • Thrilled to be renewed as a ASP.NET MVP again
      • Desktop shortcuts for Google Docs document, Outloo...
      • Comparison of Microsoft Data Access Technologies
      • Got tough IE questions? Check EricLaw's blog
      • Read proxied, mobile-friendly web pages with Googl...
      • Simulate Modem speeds with Fiddler
    • ►  September (15)
    • ►  August (18)
    • ►  July (17)
    • ►  June (20)
    • ►  May (17)
    • ►  April (19)
    • ►  March (5)
Powered by Blogger.

About Me

Unknown
View my complete profile