Difference between revisions of "ElasticSearch"
Jump to navigation
Jump to search
Rafahsolis (talk | contribs) m Tag: visualeditor |
Rafahsolis (talk | contribs) m Tag: visualeditor |
||
| Line 12: | Line 12: | ||
*SmartCN: Analyze Chinese text | *SmartCN: Analyze Chinese text | ||
| + | |||
| + | QueryDSL vs RDMBS | ||
| + | {| class="wikitable" | ||
| + | |+ | ||
| + | !Elastic Search | ||
| + | !RDMBS | ||
| + | |- | ||
| + | |Index | ||
| + | |Database | ||
| + | |- | ||
| + | |Type | ||
| + | |Table | ||
| + | |- | ||
| + | |Document | ||
| + | |Row | ||
| + | |- | ||
| + | |Field | ||
| + | |Column | ||
| + | |- | ||
| + | |Mapping | ||
| + | |Schema | ||
| + | |- | ||
| + | |Query DSL | ||
| + | |SQL | ||
| + | |- | ||
| + | |Get API | ||
| + | |Select * FROM | ||
| + | |- | ||
| + | |POST API | ||
| + | |UPDATE <nowiki><TABLE> SET</nowiki> | ||
| + | |- | ||
| + | |PUT API | ||
| + | |INSERT INTO <nowiki><TABLE></nowiki> | ||
| + | |- | ||
| + | |Everything is indexed | ||
| + | |Index on demand | ||
| + | |- | ||
| + | |Aggregation | ||
| + | |SELECT <FIELD>, COUNT (*) FROM <nowiki><TABLE></nowiki> | ||
| + | |} | ||
Revision as of 06:52, 15 April 2019
Plugins
Site Plugins
- Head: Swiss Army Knife for ElasticSearch cluster topology & cluster status, table views & API frontend views
- BigDesk: Statistics, charts
- Kopf: Cluster administration & query tool
Analysis Plugins
- SmartCN: Analyze Chinese text
QueryDSL vs RDMBS
| Elastic Search | RDMBS |
|---|---|
| Index | Database |
| Type | Table |
| Document | Row |
| Field | Column |
| Mapping | Schema |
| Query DSL | SQL |
| Get API | Select * FROM |
| POST API | UPDATE <TABLE> SET |
| PUT API | INSERT INTO <TABLE> |
| Everything is indexed | Index on demand |
| Aggregation | SELECT <FIELD>, COUNT (*) FROM <TABLE> |