Forced benchmarking of relational database with mongodb and elasticsearch

Time:2019-12-15

Structural benchmarking

RDBMS MongoDB Elasticsearch
Table Collection Index
Row Document Document
Column Field Field
Schema Schema Mapping
SQL DSL

Noun interpretation

RDBMS

RDBMS is the relational database management system, which organizes data into related rows and columns. The computer software for managing RDBMS is the relational database management system. The commonly used database software includes Oracle, SQL server, mysql, etc.

MongoDB

Mongodb is a document oriented database management system written in C + + and other languages to solve a large number of practical problems in the application development community. In October 2007, mongodb was developed by the 10gen team. First launched in February 2009.

Elasticsearch

Elasticsearch is a search engine based on Lucene library. It provides a distributed, multi tenant full-text search engine with HTTP web interface and modeless JSON documents. Elasticsearch was developed in Java and released under the Apache license as open source software. Official clients are available in Java,. Net (c), PHP, python, Apache groovy, ruby, and many other languages. According to the ranking of DB engines, elastic search is the most popular enterprise search engine, followed by Apache Solr, which is also based on Lucene.

Schema

Database Schema,The database schema of a database system is its structure described in a formal language supported by the database management system (DBMS).

DSL

Domain Specific Language, Elasticsearch provides a full Query DSL based on JSON to define queries.

This article is from Walker snapshot

Recommended Today

On the reference count in PHP string type

Author: Wang Shu Background introduction String type is also a commonly used type. Due to the characteristics of strings, in order to save memory, the same string variables usually share a block of memory space. By reference counting, multiple variables are marked to use this memory. However, after GDB tracking, it is found that not […]