DB Comparison

flameluxuriantData Management

Dec 16, 2012 (4 years and 8 months ago)

153 views

COMPUTING SUBJECT:

Concurency and recovery of DB


TYPE:

Assignment


IDENTIFICATION:

DB
-
COMPARISON


COPYRIGHT:

Michael Claudius


LEVEL:

Medium


TIME CONSUMPTION:

1
-
2 hours


EXTENT:

50 lines


OBJECTIVE:

Evaluation of databases


PRECONDITIONS:

Database System
s Ch. 19


COMMANDS:


IDENTIFICATION:
DB
-
COMPARISON
/MC


The Mission

To investigate the principles behind different databases

We are going to
explore the
basic concepts behind
databases

and have a look at some providers.


Useful links for this assignment


http://en.wikipedia.org/wiki/Database



http://en.wikipedia.org/wiki/Relational_database_management_system


http://en.wikipedia.org/wiki/Multiple_granularity_locking


http://en.wikipedia.org/wiki/Compar
ison_of_relational_database_management_systems


http://www.stanford.edu/dept/itss/docs/oracle/10g/server.101/b10743/consist.htm#i17856



1
.
DB

provide
rs

There are many
well known

and massively tested
databases
:




DB2



FireBird



Informix



Ingress



MySql




MicroSoft SQLServer



Oracle



PostgreSQL




SAS



SAP


Choose Oracle and one of the others
.


Now investigate the databases in the following topics.


DB
-
Type:
Relat
ional DB, Object Relational DB, Object Oriented DB

Support of OS

Max of file size

Security
, SSL

Data types

Inheritance

Concurrency

technique

Isolation

Locking

Time stamping
, MVCC

Deadlock handling

Recovery

Backup