Skip to content

Instantly share code, notes, and snippets.

@agrawalo

agrawalo/ElasticsearchVsRDBMS.txt

Last active December 8, 2017 16:14
Show Gist options
  • Save agrawalo/c7c56b6109702cd93b24405a769c2fc4 to your computer and use it in GitHub Desktop.
Save agrawalo/c7c56b6109702cd93b24405a769c2fc4 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
ElasticsearchVsRDBMS.txt
+---------------------------------------+-----------------------+
| RDBMS | ElasticSearch |
+---------------------------------------+-----------------------+
| Database | Index |
| Table | Type |
| Row | Document |
| Column | Field |
| Schema | Mapping |
| SQL | Query DSL |
| SELECT * FROM | GET API |
| UPDATE <TABLE> SET | POST API |
| INSERT INTO <TABLE> | PUT API |
| Indexing on demand | Everything is indexed |
| SELECT <FIELD>, COUNT(*) FROM <TABLE> | Aggregation |
+---------------------------------------+-----------------------+
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment