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 :
| SR.NO | SQLite | 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. |
| 9 | It supports C, C#, C++, Matlab info, ColdFusion info, R info, Dart info, Delphi info, Erlang, Java, JavaScript, PHP, Python, Ruby. | It supports C, C++, Cobol, Java, Perl, PL/1, Python, R, Ruby. |
| 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.
Recommended Posts:
- Difference between Cassandra and IBM Db2
- Difference between CouchDB and IBM Db2
- Difference between Couchbase and IBM Db2
- Difference between MS SQL Server and IBM DB2
- Difference between PouchDB and IBM Db2
- Difference between MariaDB and IBM Db2
- Difference between MySQL and IBM Db2
- Difference between MS SQL Server and IBM Db2
- Difference between MongoDB and IBM Db2
- Difference between IBM DB2 and PostgreSQL
- Difference between IBM DB2 and MS SQL
- Difference between PostgreSQL and IBM DB2
- Difference between IBM DB2 and Maria DB
- Difference between IBM DB2 and MongoDB
- Difference between Elasticsearch and IBM DB2
- Difference between Derby and IBM Db2
- Difference between IBM DB2 and Amazon DynamoDB
- Difference between Neo4j and IBM DB2
- Difference between RDBMS and IBM DB2
- Difference between Redis and IBM Db2
If you like GeeksforGeeks and would like to contribute, you can also write an article using contribute.geeksforgeeks.org or mail your article to contribute@geeksforgeeks.org. See your article appearing on the GeeksforGeeks main page and help other Geeks.
Please Improve this article if you find anything incorrect by clicking on the "Improve Article" button below.
