NETB307 Distributed Databases Project

 

Zlatin Stanimirov F64571

 

Comparison between database engines

SQLite vs Oracle

Oracle

Webstiewww.oracle.com/­us/­products/­database

Developer: Oracle

Initial release: 1980

Database model: Relational

Licence: commercial

Server operating systems: AIX, HP-UX, Linux, OS X, Solaris, Windows

SQLite

Webstiewww.oracle.com/­us/­products/­database

Developer: Dwayne Hipp

Initial release: 2000

Database model: Relational

Licence: opensource

Server operating systems:  Serverless

General info

Oracle

 

C,C#,C++,Clojure,Cobol,Eiffel,Erlang,Fortran,Groovy,Haskell, Java, JavaScript, Lisp, Objective C, OCaml, Perl, PHP, Python,
R, Ruby, Scala, Tcl, Visual Basic

SQLite

Actionscript, Ada, Basic, C, C#, C++, D, Delphi, Forth, Fortran,Haskell, Java, JavaScript,
Lisp,Lua,MatLab,Objective-C,
OCaml,Perl,PHP,PL/SQL,
Python,R,Ruby,Scala,Scheme,
Smalltalk, Tcl

Supported programming languages

Oracle

 

Server-side scripts: PL/SQL

Triggers: yes

Constraints: yes

Indexes: yes

Foreign Keys: yes

 

SQLite

Server-side scripts: no

This means that there are no stored procedures.:(

Triggers: yes

Constraints: yes

Indexes: yes

Foreign Keys: yes

 

Core features

Oracle

 

 

Concurency: yes 

Transactions: yes

Partitioning methods: horizontal partitioning

Replication methods: master-slave, master-master

Access control: yes

SQLite

 

Concurency: yes (fs locks)

Transactions: yes

Partitioning methods: none

Replication methods: none

Access control: no

Core features

Oracle

 

Large enterprise software

SQLite

Defacto standard for mobile applications which require their own database

Use cases

Made with Slides.com