Understanding Index and Type

ashokchinna · June 11, 2019, 5:20pm

In general comparison of Elastic Search with Relational Database,

Database (Relational Database) is Index (Elastic Search)
Table (Relational Database) is Document Type (Elastic Search)

So, a database can have multiple tables.

However, Elastic Search 7.0 doesn't support having multiple types in the same index.

How I can design the database where I have a database (logical host) which have multiple tables?

Christian_Dahlqvist · June 11, 2019, 5:45pm

When you model data in Elasticsearch you need to think about it in terms of what you want to serach and get returned rather than how it might be structured in a relational database. As it is a document store and very different from a relational database this kind of analogies are typically not very useful.

Topic		Replies	Views
Index->table, document->row? Elasticsearch	5	1557	March 6, 2019
Heelp Elasticsearch	6	552	September 1, 2018
Adding mutliple types to an index Elasticsearch	2	1701	July 6, 2017
Which is the best way to create types in terms of performance in elasticsearch Elasticsearch	2	384	July 6, 2017
Are documents of different types indexed via one index? Elasticsearch	6	1323	July 5, 2017

Understanding Index and Type

Related topics