1. SQLite :
SQLite is a software library that provides a relational database management system (RDBMS). It was designed by D. Richard Hipp on August 2000. The design goals of SQLite were to allow the program to be operated without installing a database management system (DBMS) or requiring a database administrator. The lite in SQLite means light weight in terms of setup, database administration, and required resource.
2. IBM Db2 :
IBM Db2 is a family of data management products, including database servers, developed by IBM. It is a Relational Database Management System (RDBMS) which supports object-oriented features and non relational structure with XML. Db2 is designed to store, analyze and retrieve the data efficiently. It was initially released in 1983 and is written in C, C++, Java and Assembly language.
Difference between SQLite and IBM Db2 :
|1.||It is developed by D. Richard Hipp in 2000.||It is developed by IBM in 1983.|
|2||SQLite server operating systems are server-less.||Db2 server operating systems are AIX, HP-UX, Linux, Solaris, Windows and z/OS.|
|3||The primary database model for SQLite is Relational DBMS.||The primary database model for IBM Db2 is Relational DBMS.|
|4||It is written in C language.||It is written in C, C++, Assembly language, Java languages.|
|5||Famous companies like Adobe, Google, Bosch, Facebook, Dropbox, etc uses SQLite.||Famous companies like JPMorgan Chase, Bank of America, Scotiabank, Citi, etc use Db2.|
|6||It provide in-memory capabilities.||It do not provide in-memory capabilities .|
|7||It is a open source software framework.||It is a commercial databases.|
|8||It supports Secondary indexes.||It supports the secondary indexes without any restrictions.|
|10||It do not provides access rights for users and roles.||It provide fine grained access rights according to SQL-standard.|
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.