✕

Elasticsearch Physical Model

Schema for:

Model name: MovieLens Recommendations
Author:
Version:
File name: MovieLens Recommendations.json
File path: C:\Users\Pascal\Bitbucket\hackolade\schemas\Elasticsearch\MovieLens Recommendations.json
Printed On: Sat May 19 2018 10:52:48 GMT+0200 (Romance Summer Time)
Created with: Hackolade - Visual data modeling for NoSQL and multimodel databases
1. Model
1.1 Model MovieLens Recommendations
1.1.1 MovieLens Recommendations Entity Relationship Diagram
MovieLens
1.1.2 MovieLens Recommendations Properties
PropertyValue
Model name MovieLens Recommendations
Description Derived from https://github.com/elastic/examples/tree/master/Graph/movie_recommendations example
Author
Version
DB vendor Elasticsearch
DB version 5.6.x
Host
Port 9200
Comments
1.1.3 MovieLens Recommendations Model Definitions
2. Indices
2.1 Index MovieLens
2.1.1 MovieLens Properties
PropertyValue
Index nameMovieLens
Index
Index_index
Data typestring
Type
Document Type_type
Data typestring
ID
Document ID_id
Data typestring
Source
source_source
Data typeobject
Number of shards5
Number of replicas1
Aliases
[1] Namemovies
Filterblabla
Routingrouting
Description
Comments
2.1.2 MovieLens Types
2.1.2.1 Type genome-scores
2.1.2.1.1 genome-scores Tree Diagram
{...}
genome-scores
type
{ABC}
_index
type
{ABC}
_type
type
{ABC}
_id
type
{...}
_source
type
{ABC}
movieId
type
{ABC}
tagId
type
{123}
relevance
type
{...}
genome-scores
type
{ABC}
_index
type
{ABC}
_type
type
{ABC}
_id
type
{...}
_source
type
{ABC}
movieId
type
{ABC}
tagId
type
{123}
relevance
type
2.1.2.1.2 genome-scores Properties
PropertyValue
Typegenome-scores
Id
DescriptionSee http://files.grouplens.org/papers/tag_genome.pdf
IndexMovieLens
Additional propertiesfalse
Dynamic
Comments
2.1.2.1.3 genome-scores Fields
FieldTypeReqKeyDescriptionComments
_indexstringtrue
_typestringtrue
_idstringtrue
_sourceobjecttrue
movieIdstringtrue
tagIdstringtrue
relevancenumbertrue
2.1.2.1.3.1 Field _index
_index properties
PropertyValue
Name _index
Type string
Required true
Primary key true
index true
similarity BM25
2.1.2.1.3.2 Field _type
_type properties
PropertyValue
Name _type
Type string
Required true
Primary key true
similarity BM25
2.1.2.1.3.3 Field _id
_id properties
PropertyValue
Name _id
Type string
Required true
Primary key true
similarity BM25
2.1.2.1.3.4 Field _source
2.1.2.1.3.4.1 _source Tree Diagram
{...}
_source
type
{ABC}
movieId
type
{ABC}
tagId
type
{123}
relevance
type
{...}
_source
type
{ABC}
movieId
type
{ABC}
tagId
type
{123}
relevance
type
2.1.2.1.3.4.2 _source Hierarchy
Parent field: genome-scores
Child field(s):
FieldTypeReqKeyDescriptionComments
movieIdstringtruefk
tagIdstringtruefk
relevancenumbertrue
_source properties
PropertyValue
Name _source
Type object
Required true
Primary key false
Additional properties false
2.1.2.1.3.5 Field movieId
movieId properties
PropertyValue
Name movieId
Type string
Required true
Primary key false
Foreign collection movies
Foreign field _id
Relationship type Foreign Key
similarity BM25
2.1.2.1.3.6 Field tagId
tagId properties
PropertyValue
Name tagId
Type string
Required true
Primary key false
Foreign collection tags
Foreign field _id
Relationship type Foreign Key
similarity BM25
2.1.2.1.3.7 Field relevance
relevance properties
PropertyValue
Name relevance
Type number
Required true
Primary key false
Excl min false
Excl max false
2.1.2.1.4 genome-scores Definitions
2.1.2.2 Type genome-tags
2.1.2.2.1 genome-tags Tree Diagram
{...}
genome-tags
type
{ABC}
_index
type
{ABC}
_type
type
{ABC}
_id
type
{...}
_source
type
{ABC}
tagId
type
{ABC}
tag
type
{...}
genome-tags
type
{ABC}
_index
type
{ABC}
_type
type
{ABC}
_id
type
{...}
_source
type
{ABC}
tagId
type
{ABC}
tag
type
2.1.2.2.2 genome-tags Properties
PropertyValue
Typegenome-tags
Id
Description
IndexMovieLens
Additional propertiesfalse
Dynamic
Comments
2.1.2.2.3 genome-tags Fields
FieldTypeReqKeyDescriptionComments
_indexstringtrue
_typestringtrue
_idstringtrue
_sourceobjecttrue
tagIdstringtrue
tagstringtrue
2.1.2.2.3.1 Field _index
_index properties
PropertyValue
Name _index
Type string
Required true
Primary key true
index true
similarity BM25
2.1.2.2.3.2 Field _type
_type properties
PropertyValue
Name _type
Type string
Required true
Primary key true
similarity BM25
2.1.2.2.3.3 Field _id
_id properties
PropertyValue
Name _id
Type string
Required true
Primary key true
similarity BM25
2.1.2.2.3.4 Field _source
2.1.2.2.3.4.1 _source Tree Diagram
{...}
_source
type
{ABC}
tagId
type
{ABC}
tag
type
{...}
_source
type
{ABC}
tagId
type
{ABC}
tag
type
2.1.2.2.3.4.2 _source Hierarchy
Parent field: genome-tags
Child field(s):
FieldTypeReqKeyDescriptionComments
tagIdstringtruefk
tagstringtrue
_source properties
PropertyValue
Name _source
Type object
Required true
Primary key false
Additional properties false
2.1.2.2.3.5 Field tagId
tagId properties
PropertyValue
Name tagId
Type string
Required true
Primary key false
Foreign collection tags
Foreign field _id
Relationship type Foreign Key
similarity BM25
2.1.2.2.3.6 Field tag
tag properties
PropertyValue
Name tag
Type string
Required true
Primary key false
similarity BM25
2.1.2.2.4 genome-tags Definitions
2.1.2.3 Type genres
2.1.2.3.1 genres Tree Diagram
{...}
genres
type
{ABC}
_index
type
{ABC}
_type
type
{ABC}
_id
type
{...}
_source
type
{ABC}
genre
type
{...}
genres
type
{ABC}
_index
type
{ABC}
_type
type
{ABC}
_id
type
{...}
_source
type
{ABC}
genre
type
2.1.2.3.2 genres Properties
PropertyValue
Typegenres
Id
Description
IndexMovieLens
Additional propertiesfalse
Dynamic
Comments
2.1.2.3.3 genres Fields
FieldTypeReqKeyDescriptionComments
_indexstringtrue
_typestringtrue
_idstringtrue
_sourceobjecttrue
genrestringtrue
2.1.2.3.3.1 Field _index
_index properties
PropertyValue
Name _index
Type string
Required true
Primary key true
index true
similarity BM25
2.1.2.3.3.2 Field _type
_type properties
PropertyValue
Name _type
Type string
Required true
Primary key true
similarity BM25
2.1.2.3.3.3 Field _id
_id properties
PropertyValue
Name _id
Type string
Required true
Primary key true
similarity BM25
2.1.2.3.3.4 Field _source
2.1.2.3.3.4.1 _source Tree Diagram
{...}
_source
type
{ABC}
genre
type
{...}
_source
type
{ABC}
genre
type
2.1.2.3.3.4.2 _source Hierarchy
Parent field: genres
Child field(s):
FieldTypeReqKeyDescriptionComments
genrestringtrue
_source properties
PropertyValue
Name _source
Type object
Required true
Primary key false
Additional properties false
2.1.2.3.3.5 Field genre
genre properties
PropertyValue
Name genre
Type string
Required true
Primary key false
similarity BM25
Enum Action,Adventure,Animation,Children's,Comedy,Crime,Documentary,Drama,Fantasy,Film-Noir,Horror,Musical,Mystery,Romance,Sci-Fi,Thriller,War,Western
Sample Adventure
2.1.2.3.4 genres Definitions
2.1.2.4 Type movies
2.1.2.4.1 movies Tree Diagram
{...}
movies
type
{ABC}
_index
type
{ABC}
_type
type
{ABC}
_id
type
{...}
_source
type
{ABC}
title
type
{123}
year
type
[...]
genreId
type
{...}
links
type
{ABC}
[0]*
type
{ABC}
imdbId
type
{ABC}
tmdbId
type
{...}
movies
type
{ABC}
_index
type
{ABC}
_type
type
{ABC}
_id
type
{...}
_source
type
{ABC}
title
type
{123}
year
type
[...]
genreId
type
{...}
links
type
{ABC}
[0]*
type
{ABC}
imdbId
type
{ABC}
tmdbId
type
2.1.2.4.2 movies Properties
PropertyValue
Typemovies
Id
Description
IndexMovieLens
Additional propertiesfalse
Dynamicstrict
Comments
2.1.2.4.3 movies Fields
FieldTypeReqKeyDescriptionComments
_indexstringtrue
_typestringtrue
_idstringtrue
_sourceobjecttrue
titlestringtrue
yearnumbertrue
genreIdarrayfalse
[0]stringfalse
linksobjectfalse
imdbIdstringfalse
tmdbIdstringfalse
2.1.2.4.3.1 Field _index
_index properties
PropertyValue
Name _index
Type string
Required true
Primary key true
index true
similarity BM25
2.1.2.4.3.2 Field _type
_type properties
PropertyValue
Name _type
Type string
Required true
Primary key true
similarity BM25
2.1.2.4.3.3 Field _id
_id properties
PropertyValue
Name _id
Type string
Required true
Primary key true
similarity BM25
2.1.2.4.3.4 Field _source
2.1.2.4.3.4.1 _source Tree Diagram
{...}
_source
type
{ABC}
title
type
{123}
year
type
[...]
genreId
type
{...}
links
type
{...}
_source
type
{ABC}
title
type
{123}
year
type
[...]
genreId
type
{...}
links
type
2.1.2.4.3.4.2 _source Hierarchy
Parent field: movies
Child field(s):
FieldTypeReqKeyDescriptionComments
titlestringtrue
yearnumbertrue
genreIdarrayfalse
linksobjectfalse
_source properties
PropertyValue
Name _source
Type object
Required true
Primary key false
Additional properties false
2.1.2.4.3.5 Field title
title properties
PropertyValue
Name title
Type string
Required true
Primary key false
boost 1
eager_global_ordinals true
include_in_all true
index true
norms true
store true
similarity classic
Min length 1
Max length 20
Sample Toy Story
2.1.2.4.3.6 Field year
year properties
PropertyValue
Name year
Type number
Required true
Primary key false
coerce true
boost 2
doc_values true
ignore_malformed true
include_in_all true
index true
null_value dwf
store true
Unit fgd
Min value 1900
Excl min false
Max value 3000
Excl max false
Sample 1995
2.1.2.4.3.7 Field genreId
2.1.2.4.3.7.1 genreId Tree Diagram
[...]
genreId
type
{ABC}
[0]*
type
[...]
genreId
type
{ABC}
[0]*
type
2.1.2.4.3.7.2 genreId Hierarchy
Parent field: _source
Child field(s):
FieldTypeReqKeyDescriptionComments
[0]stringfalsefk
genreId properties
PropertyValue
Name genreId
Type array
Required false
Primary key false
Unique items false
Additional items true
2.1.2.4.3.8 Field [0]
[0] properties
PropertyValue
Type string
Required false
Primary key false
Foreign collection genres
Foreign field _id
Relationship type Foreign Key
2.1.2.4.3.9 Field links
2.1.2.4.3.9.1 links Tree Diagram
{...}
links
type
{ABC}
imdbId
type
{ABC}
tmdbId
type
{...}
links
type
{ABC}
imdbId
type
{ABC}
tmdbId
type
2.1.2.4.3.9.2 links Hierarchy
Parent field: _source
Child field(s):
FieldTypeReqKeyDescriptionComments
imdbIdstringfalse
tmdbIdstringfalse
links properties
PropertyValue
Name links
Type object
Required false
Primary key false
Additional properties false
2.1.2.4.3.10 Field imdbId
imdbId properties
PropertyValue
Name imdbId
Type string
Required false
Primary key false
2.1.2.4.3.11 Field tmdbId
tmdbId properties
PropertyValue
Name tmdbId
Type string
Required false
Primary key false
2.1.2.4.4 movies Definitions
2.1.2.5 Type ratings
2.1.2.5.1 ratings Tree Diagram
{...}
ratings
type
{ABC}
_index
type
{ABC}
_type
type
{ABC}
_id
type
{...}
_source
type
{ABC}
userId
type
{ABC}
movieId
type
{123}
rating
type
{...}
ratings
type
{ABC}
_index
type
{ABC}
_type
type
{ABC}
_id
type
{...}
_source
type
{ABC}
userId
type
{ABC}
movieId
type
{123}
rating
type
2.1.2.5.2 ratings Properties
PropertyValue
Typeratings
Id
Description
IndexMovieLens
Additional propertiesfalse
Dynamic
Comments
2.1.2.5.3 ratings Fields
FieldTypeReqKeyDescriptionComments
_indexstringtrue
_typestringtrue
_idstringtrue
_sourceobjecttrue
userIdstringtrue
movieIdstringtrue
ratingnumbertrue
2.1.2.5.3.1 Field _index
_index properties
PropertyValue
Name _index
Type string
Required true
Primary key true
index true
similarity BM25
2.1.2.5.3.2 Field _type
_type properties
PropertyValue
Name _type
Type string
Required true
Primary key true
similarity BM25
2.1.2.5.3.3 Field _id
_id properties
PropertyValue
Name _id
Type string
Required true
Primary key true
similarity BM25
2.1.2.5.3.4 Field _source
2.1.2.5.3.4.1 _source Tree Diagram
{...}
_source
type
{ABC}
userId
type
{ABC}
movieId
type
{123}
rating
type
{...}
_source
type
{ABC}
userId
type
{ABC}
movieId
type
{123}
rating
type
2.1.2.5.3.4.2 _source Hierarchy
Parent field: ratings
Child field(s):
FieldTypeReqKeyDescriptionComments
userIdstringtruefk
movieIdstringtruefk
ratingnumbertrue
_source properties
PropertyValue
Name _source
Type object
Required true
Primary key false
Additional properties false
2.1.2.5.3.5 Field userId
userId properties
PropertyValue
Name userId
Type string
Required true
Primary key false
Foreign collection users
Foreign field _id
Relationship type Foreign Key
similarity BM25
2.1.2.5.3.6 Field movieId
movieId properties
PropertyValue
Name movieId
Type string
Required true
Primary key false
Foreign collection movies
Foreign field _id
Relationship type Foreign Key
similarity BM25
2.1.2.5.3.7 Field rating
rating properties
PropertyValue
Name rating
Type number
Required true
Primary key false
Unit stars
Min value 0.5
Excl min false
Max value 5
Excl max false
Multiple of 0.5
Sample 4.5
2.1.2.5.4 ratings Definitions
2.1.2.6 Type tags
2.1.2.6.1 tags Tree Diagram
{...}
tags
type
{ABC}
_index
type
{ABC}
_type
type
{ABC}
_id
type
{...}
_source
type
{ABC}
userId
type
{ABC}
movieId
type
{ABC}
tag
type
{dt}
timestamp
type
{...}
tags
type
{ABC}
_index
type
{ABC}
_type
type
{ABC}
_id
type
{...}
_source
type
{ABC}
userId
type
{ABC}
movieId
type
{ABC}
tag
type
{dt}
timestamp
type
2.1.2.6.2 tags Properties
PropertyValue
Typetags
Id
Description
IndexMovieLens
Additional propertiesfalse
Dynamic
Comments
2.1.2.6.3 tags Fields
FieldTypeReqKeyDescriptionComments
_indexstringtrue
_typestringtrue
_idstringtrue
_sourceobjecttrue
userIdstringtrue
movieIdstringtrue
tagstringtrue
timestampdatetrue
2.1.2.6.3.1 Field _index
_index properties
PropertyValue
Name _index
Type string
Required true
Primary key true
index true
similarity BM25
2.1.2.6.3.2 Field _type
_type properties
PropertyValue
Name _type
Type string
Required true
Primary key true
similarity BM25
2.1.2.6.3.3 Field _id
_id properties
PropertyValue
Name _id
Type string
Required true
Primary key true
similarity BM25
2.1.2.6.3.4 Field _source
2.1.2.6.3.4.1 _source Tree Diagram
{...}
_source
type
{ABC}
userId
type
{ABC}
movieId
type
{ABC}
tag
type
{dt}
timestamp
type
{...}
_source
type
{ABC}
userId
type
{ABC}
movieId
type
{ABC}
tag
type
{dt}
timestamp
type
2.1.2.6.3.4.2 _source Hierarchy
Parent field: tags
Child field(s):
FieldTypeReqKeyDescriptionComments
userIdstringtruefk
movieIdstringtruefk
tagstringtrue
timestampdatetrue
_source properties
PropertyValue
Name _source
Type object
Required true
Primary key false
Additional properties false
2.1.2.6.3.5 Field userId
userId properties
PropertyValue
Name userId
Type string
Required true
Primary key false
Foreign collection users
Foreign field _id
Relationship type Foreign Key
similarity BM25
2.1.2.6.3.6 Field movieId
movieId properties
PropertyValue
Name movieId
Type string
Required true
Primary key false
Foreign collection movies
Foreign field _id
Relationship type Foreign Key
similarity BM25
2.1.2.6.3.7 Field tag
tag properties
PropertyValue
Name tag
Type string
Required true
Primary key false
similarity BM25
2.1.2.6.3.8 Field timestamp
timestamp properties
PropertyValue
Name timestamp
Type date
Required true
format yyyyMMdd'T'HHmmssZ
2.1.2.6.4 tags Definitions
2.1.2.7 Type users
2.1.2.7.1 users Tree Diagram
{...}
users
type
{ABC}
_index
type
{ABC}
_type
type
{ABC}
_id
type
{...}
_source
type
{ABC}
firstName
type
{ABC}
lastName
type
{ABC}
email
type
{...}
users
type
{ABC}
_index
type
{ABC}
_type
type
{ABC}
_id
type
{...}
_source
type
{ABC}
firstName
type
{ABC}
lastName
type
{ABC}
email
type
2.1.2.7.2 users Properties
PropertyValue
Typeusers
Id
Description
IndexMovieLens
Additional propertiesfalse
Dynamic
Comments
2.1.2.7.3 users Fields
FieldTypeReqKeyDescriptionComments
_indexstringtrue
_typestringtrue
_idstringtrue
_sourceobjecttrue
firstNamestringtrue
lastNamestringtrue
emailstringtrue
2.1.2.7.3.1 Field _index
_index properties
PropertyValue
Name _index
Type string
Required true
Primary key true
index true
similarity BM25
2.1.2.7.3.2 Field _type
_type properties
PropertyValue
Name _type
Type string
Required true
Primary key true
similarity BM25
2.1.2.7.3.3 Field _id
_id properties
PropertyValue
Name _id
Type string
Required true
Primary key true
similarity BM25
2.1.2.7.3.4 Field _source
2.1.2.7.3.4.1 _source Tree Diagram
{...}
_source
type
{ABC}
firstName
type
{ABC}
lastName
type
{ABC}
email
type
{...}
_source
type
{ABC}
firstName
type
{ABC}
lastName
type
{ABC}
email
type
2.1.2.7.3.4.2 _source Hierarchy
Parent field: users
Child field(s):
FieldTypeReqKeyDescriptionComments
firstNamestringtrue
lastNamestringtrue
emailstringtrue
_source properties
PropertyValue
Name _source
Type object
Required true
Primary key false
Additional properties false
2.1.2.7.3.5 Field firstName
firstName properties
PropertyValue
Name firstName
Type string
Required true
Primary key false
similarity BM25
2.1.2.7.3.6 Field lastName
lastName properties
PropertyValue
Name lastName
Type string
Required true
Primary key false
similarity BM25
2.1.2.7.3.7 Field email
email properties
PropertyValue
Name email
Type string
Required true
Primary key false
similarity BM25
2.1.2.7.4 users Definitions
3. Relationships
3.1 Relationship New Relationship
3.1.1 New Relationship Diagram
Parent TableParent field
users _id
Child TableChild field
ratings _source.userId
3.1.2 New Relationship Properties
PropertyValue
Name New Relationship
Description
Parent Typeusers
Parent field_id
Parent Cardinality 1
Child Typeratings
Child fielduserId
Child Cardinality 0..n
Comments
3.2 Relationship New Relationship(1)
3.2.1 New Relationship(1) Diagram
Parent TableParent field
movies _id
Child TableChild field
ratings _source.movieId
3.2.2 New Relationship(1) Properties
PropertyValue
Name New Relationship(1)
Description
Parent Typemovies
Parent field_id
Parent Cardinality 1
Child Typeratings
Child fieldmovieId
Child Cardinality 0..n
Comments
3.3 Relationship New Relationship(2)
3.3.1 New Relationship(2) Diagram
Parent TableParent field
genres _id
Child TableChild field
movies _source.genreId.[0]
3.3.2 New Relationship(2) Properties
PropertyValue
Name New Relationship(2)
Description
Parent Typegenres
Parent field_id
Parent Cardinality 1
Child Typemovies
Child field
Child Cardinality 0..n
Comments
3.4 Relationship New Relationship(3)
3.4.1 New Relationship(3) Diagram
Parent TableParent field
users _id
Child TableChild field
tags _source.userId
3.4.2 New Relationship(3) Properties
PropertyValue
Name New Relationship(3)
Description
Parent Typeusers
Parent field_id
Parent Cardinality 1
Child Typetags
Child fielduserId
Child Cardinality 0..n
Comments
3.5 Relationship New Relationship(4)
3.5.1 New Relationship(4) Diagram
Parent TableParent field
movies _id
Child TableChild field
tags _source.movieId
3.5.2 New Relationship(4) Properties
PropertyValue
Name New Relationship(4)
Description
Parent Typemovies
Parent field_id
Parent Cardinality 1
Child Typetags
Child fieldmovieId
Child Cardinality 0..n
Comments
3.6 Relationship New Relationship(5)
3.6.1 New Relationship(5) Diagram
Parent TableParent field
movies _id
Child TableChild field
genome-scores _source.movieId
3.6.2 New Relationship(5) Properties
PropertyValue
Name New Relationship(5)
Description
Parent Typemovies
Parent field_id
Parent Cardinality 1
Child Typegenome-scores
Child fieldmovieId
Child Cardinality 0..n
Comments
3.7 Relationship New Relationship(6)
3.7.1 New Relationship(6) Diagram
Parent TableParent field
tags _id
Child TableChild field
genome-scores _source.tagId
3.7.2 New Relationship(6) Properties
PropertyValue
Name New Relationship(6)
Description
Parent Typetags
Parent field_id
Parent Cardinality 1
Child Typegenome-scores
Child fieldtagId
Child Cardinality 0..n
Comments
3.8 Relationship New Relationship(7)
3.8.1 New Relationship(7) Diagram
Parent TableParent field
tags _id
Child TableChild field
genome-tags _source.tagId
3.8.2 New Relationship(7) Properties
PropertyValue
Name New Relationship(7)
Description
Parent Typetags
Parent field_id
Parent Cardinality 1
Child Typegenome-tags
Child fieldtagId
Child Cardinality 0..n
Comments