Monday, September 2, 2013

MongoDB - Mapping from SQL

There is one important thing I want to take note about the MongoDB in comparison with SQL:

SQL Terms/ConceptsMongoDB Terms/Concepts
databasedatabase
tablecollection
rowdocument or BSON document
columnfield
indexindex
table joinsembedded documents and linking
primary key
Specify any unique column or column combination as primary key.
In MongoDB, the primary key is automatically set to the _id field.
aggregation (e.g. group by)
aggregation pipeline

Remember it if you are a mongodb newbie like me!!!!!!!


Source: http://docs.mongodb.org/manual/reference/sql-comparison/