Changes
Jump to navigation
Jump to search
← Older edit
Newer edit →
ElasticSearch
(edit)
Revision as of 06:52, 15 April 2019
423 bytes added
,
06:52, 15 April 2019
m
no edit summary
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>
+
|}
Rafahsolis
Bureaucrats
,
Administrators
2,306
edits
Navigation menu
Personal tools
Not logged in
Talk
Contributions
Create account
Log in
Namespaces
Page
Discussion
Variants
Views
Read
Edit
View history
More
Search
Navigation
Main page
Recent changes
Random page
Help about MediaWiki
Tools
Special pages
Printable version