1. MS SQL Server :
Microsoft SQL Server is a relational database management system (RDBMS) which is platform dependent and it is both GUI and command based software. It supports a wide variety of transaction processing, business intelligence and analytics applications in corporate IT environments. It was developed by Microsoft Corporation and initially released on April 24, 1989. It is written in C and C++ languages.
2. Cassandra :
Cassandra is a free and open-source, distributed, wide column store, NoSQL database management system. It was developed by Apache Software foundation and initially released on July 2008. Cassandra is designed to handle large amounts of data across many commodity servers, providing high availability with no single point of failure.
Difference between MS SQL Server and Cassandra :
|S.NO.||MS SQL Server||Cassandra|
|1.||Developed by Microsoft Corporation and initially released on April 24, 1989.||Developed by Apache Software foundation and released on July 2008.|
|2.||MS SQL server is written in C and C++.||Cassandra is written only in Java language.|
|3.||The primary database model for MS SQL Server is Relational DBMS.||The primary database model for Cassandra is Wide Column Store.|
|4.||MS SQL Server does supports the concept of secondary indexes without any restriction.||Secondary indexing in Cassandra is restricted.|
|5.||The license for MS SQL Server is Commercial.||The license for Cassandra is Open Source.|
|6.||MS SQL Server supports XML data format.||Cassandra does not supports XML data format.|
|7.||In MS SQL Server the data schema is Fixed.||Cassandra is schema free.|
|8.||MS SQL Server provides ACID transactions.||Cassandra does not provides ACID transactions.|
|9.||MS SQL Server provides the concept of Referential Integrity and have Foreign keys.||There is no concept of Foreign keys in Casandra.|
|10.||MS SQL Server does not supports Map Reduce method.||Cassandra supports Map Reduce method.|
|11.||Server operating systems for MS SQL Server are Linux and Windows.||Server operating systems for Cassandra are BSD, Linux, OS X and Windows.|
|12.||Famous companies like Citi, Bank of America, UPS, etc uses MS SQL Server.||Famous companies like Hulu, Instagram, Intuit, Netflix, Reddit, etc uses Cassandra.|
Attention reader! Don’t stop learning now. Get hold of all the important CS Theory concepts for SDE interviews with the CS Theory Course at a student-friendly price and become industry ready.