Relational DB VS ElasticSearch

------------------------------------------------------

|  Relational DB       |   ElasticSearch             |

------------------------------------------------------

|  Database            |   Index (Indices)           |

|  Table               |   Mapping/Type              |

|  Record (Tuples)     |   Record (JSON object)      |

------------------------------------------------------

CRUD

• Create

------------------------------------------------------------------------

|  Relational DB   |   ElasticSearch                                       |

------------------------------------------------------------------------

|  Insert          |curl -XPOST localhost:9200/pzindex/type/id             |

------------------------------------------------------------------------

• Read

------------------------------------------------------------------------

|  Relational DB   |   ElasticSearch                                       |

------------------------------------------------------------------------

|  Select          |curl -XGET localhost:9200/pzindex/type/id              |

------------------------------------------------------------------------

• Update

-------------------------------------------------------------------------

|  Relational DB   |   ElasticSearch                                      |

-------------------------------------------------------------------------

|  Update          |curl -XPOST localhost:9200/pzindex/type/id/_update    |

-------------------------------------------------------------------------

• Delete

-------------------------------------------------------------------------

|  Relational DB   |   ElasticSearch                                      |

-------------------------------------------------------------------------

|  Delete          |curl -XDELETE localhost:9200/pzindex/type/id          |

-------------------------------------------------------------------------