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...
  • 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 ...
  • 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 ...
  • Azure in Pictures - overview of Windows Azure Features, Services and Common Uses
    Download the Windows Azure Poster in PDF format (1.1MB)
  • 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...
  • 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 ...
  • 10 ways to make laptop battery last longer
    Paraphrased from a Right Choice magazine article with my own opinions: Keep the brightness of the screen as low as possible. If portability ...
  • India ranks fourth in Internet usage
    Deepak Shenoy informs that as per Telecom Regulatory Authority of India (TRAI) data, India has nearly 10 million Broadband connections in ...
  • HOW TO let Google watch over your web activity
    When we get onto the Internet, we trade our privacy for convenience. Everyone from marketers, ISPs to Governments can watch our activities o...
  • The Glorious History of Internet Explorer
    Love it or hate it, you will have to appreciate IE’s staying power. Having been around for 16 years, it is still the browser market leader ....

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