Database Conventions

Database Conventions #

Models #

  • Network Model (CODASYL model)
  • Relational Model
  • Hierarchial Model
  • Object Model
  • XML based Model
  • Document Model (MonogDB, CouchDB)

The choice of a datastore is determined by multitude of factors.

  • Volume of read and write
  • Storage considerations
  • Response time for CRUD operations
  • Access patterns
  • Functionality provided
  • Type and complexity of data stored
  • Scalability
  • Throughput

SQL #

SQL databases are well known for the ACID properties and NoSQL for the BASE. NoSQL databases are used almost everywhere where once SQL was unchallenged. For example, a bank transaction that is typically considered ACID are implemented using NoSQL storage solutions.