Tech Blogs
  • Vivek bhargav
  • Books
    • Seven Databases In Seven Weeks
      • Factors to consider
      • Genres of databases
      • Important questions
      • PostGreSQL
  • Tech
    • C++
      • Type Conversions
      • String
      • Vector
      • Set
      • Unordered Set
      • Map
      • Unordered Map
      • Queue
      • Priority Queue
      • Union find
      • Algorithms
      • Matrix to Graph
      • Trie
      • Dijkstra
      • Math
      • Utils
    • Database Transactions
      • A Simple Transaction Analysis
      • Implementation of Isolation Levels
      • Isolation Levels
      • Isolation
      • Storage Types
      • Transaction Atomicity and Durability
    • Java
      • Important Questions
      • Spring MVC
    • Program execution
      • Node.js
      • Runtimes
    • System Design
      • Basic Terminologies
      • CAP Theorem
      • Normalization of Database
      • Useful Reads
  • Personal Finance
    • Asset Classes
      • Equity instruments
      • Debt instruments
Powered by GitBook
On this page
  • What type of datastore is this ?
  • What was the driving force ?
  • How do you talk to it ?
  • What makes it unique ?
  • How does it perform ?
  • How does it scale ?
  1. Books
  2. Seven Databases In Seven Weeks

Important questions

What type of datastore is this ?

  • relational

  • key-value

  • columnar

  • document-oriented

  • graph

What was the driving force ?

  • RDBMS databases arose in a world where query flexibility was more important than flexible schemas

  • Column-oriented datastores were built to be well suited for storing large amounts of data across several machines, while data relationships took a backseat

How do you talk to it ?

  • command line interface

  • script

  • graphical interface

What makes it unique ?

  • querying on arbitrary fields

  • indexing for rapid lookup

  • some support ad hoc queries; For others, queries must be planned

  • Is schema a rigid framework enforced by the database or merely a set of guidelines to be renegotiated at will

How does it perform ?

  • Does it support sharding

  • What about replication?

  • Does it distribute data evenly using consistent hashing, or does it keep like data together ?

  • Is this database tuned for reading, writing, or some other operation ?

  • How much control do you have over its tuning

How does it scale ?

  • Talking about scalability without the context of what you want to scale to is generally fruitless

  • Whether each datastore is geared more for

  • horizontal scaling (MongoDB, HBase, Riak),

  • vertical scaling (Postgres, Neo4J, Redis),

  • something in between

PreviousGenres of databasesNextPostGreSQL

Last updated 5 years ago