Databases are key topic in almost any current project. It is important to know which type to select for a specific application.
There are 3 main Data Base types:
- Relational (SQL) Data Base
- Object Oriented Data Base
- NOSQL Data Base
When and why use a certain DB type:
1) Relational (SQL) Data Base
- When the project handles high volume, but well-structured and well defined Data
- When you aim to develop a medium complexity suite of applications
Because Relational Data Bases:
- improve interoperability
- Provide access to widely accepted standards
- Can process ad-hoc queries
2) Object Oriented Data Base
- When a complex Data Model needs to be in the memory
- When your Data is structured as a hierarchy or a graph (network) of arbitrary depth
Because Object Oriented Data Bases:
- enhances execution speed
- allows rapid search for object in the DB
3) NOSQL Data Base
- When the project must handle Big Data
- When the binary Data is diverse, not well structured and involves spatial coordinates
Because NOSQL Data Bases:
- Are Schema less
- Are suitable for RD (Rapid Development)
Most commonly used Data Bases:
- Relational: Microsoft SQL 2010, Oracle, Solid DB, Sybase, Postgres SQL, MySQL, Access
- Object Oriented:Versant VOD
- NOSQL: MongoDB
