MongoDBCompass - initial level data exploration смотреть онлайн

MongoDBCompass - initial level data exploration



# Querying MongoDB - MongoCompass and MongoShell for an initial level data exploration task
Am using the sample datasets provided by MongoATLAS
This demo video is without a Voice Over as there is construction going on next door ,
they are very noisy :)

My contacts -

email-1 - [email protected]
email-2 - [email protected]
LinkedIn - https://www.linkedin.com/in/rohitdhankar/
GitHub - https://github.com/RohitDhankar


use sample_airbnb
show collections

The Dtype of the value is -- date
"$date": "2019-02-16T05:00:00.000Z"
},


### MongoDBCompass search query -
{_id:{$eq:'10006546'}}
An example of a REGEX search inplace of a specific ID Search
{'_id': {'$regex': '10006'}} # returns only 1 Document
{'_id': {'$regex': '100'}}
db.listingsAndReviews.find({_id: {$regex: '100'}}) # returns 55 Docs

db.listingsAndReviews.find({'_id':'10006546'}).sort({_id:1}).limit(1).pretty()
# Returns 1 DOCUMENT with lots of Reviews for the one Property ID

db.listingsAndReviews.find({},{_id:10006546}).sort({_id:-1}).limit(1).pretty()
{'_id': {'$regex': '100'}, 'summary': {'$regex': 'Ocean'}}

### Some queries can go horribly wrong -- that too with no Error messages or Alerts of any kind
db.listingsAndReviews.find({"summary":{"$regex":"duplex"},'name':{'$regex':'Charming'}},{space:1,description:1,"transit":1,interaction:1})
# We can see we have multilple DOCS which meet this search Query
## Thus there is only 1 User who has the name - which includes the sub-string or phrase == Charming

db.listingsAndReviews.find({"summary":{"$regex":"duplex"},'name':{'$regex':'duplex'}},{space:1,description:1,"transit":1,interaction:1})
# 3 DOCS for -- {"summary":{"$regex":"duplex"},'name':{'$regex':'duplex'}
db.listingsAndReviews.find({"summary":{"$regex":"duplex"},'name':{'$regex':'Duplex'}},{space:1,description:1,"transit":1,interaction:1}).count()

# So we get to see - 19 DOCS which have the Search Query satisfied == summary":{"$regex":"duplex"},'name':{'$regex':'Duplex'}


### We can thus notice - that as we have the phrase = duplex - within the name of the
Listing Creator , there quiet a high probability of finding the same within the - description also.

### Now we query for the phrase = duplex - only within the description -
notice below that now we are asking for the - NAME attribute
to also be printed as the result of our query .
Also the "transit" - attribute is still within Double Quotes and the rest are without any Quotes.
db.listingsAndReviews.find({"description":{"$regex":"duplex"}},{name:1,space:1,description:1,"transit":1,interaction:1}).count()


# As seen below these 51 listing_id": "10006546 -- are all Nested within the JSON structure
these are all Under "reviews":
So to understand this as a Python Dtype of DataStructure - we will consider this to be a
Nested DICT