Sunday, May 9, 2021

MongoDB and SQL Server Comparision Table

 

MongoDB and SQL Server Comparision Table

Below is the comparison table between MongoDB and SQL Server.

Base of Comparison MS SQL ServerMongoDB
Initial Release19892009
Storage ModelRDBMSDocument-Oriented
JoinsYesNo
TransactionACIDNO
Agile practicesNoYes
Data SchemaFixedDynamic
ScalabilityVerticalHorizontal
Map ReduceNoYes
LanguageSQL query languageJSON Query Language
Secondary indexYesYes
TriggersYesNo
Foreign KeysYesNo
ConcurrencyYesNo
Company NameMicrosoftMongoDB.Inc
LicenseCommercialOpen Source
Implementation LanguageC++C++
Operating SystemWindowsWindows, Linux, OS X
Drivers.NET, Java, PHP, Python, Ruby, Visual Basic

 

Dart, Delphi, Erlang, Go, Groovy, Haskell, Java, JavaScript, Lisp, Lua, MatLab, Perl, PHP, PowerShell, Prolog, Python, R, Ruby, Scala, Smalltalk

 

Server-side scriptsTransact SQL and .NET languagesJavaScript’s
XML SupportYesNo

No comments:

Post a Comment