Database Reference
In-Depth Information
EXERCISE
3:
I
NTERPRETING
Q
UERIES
db.title.find( { $or : [ { pageCount : { $gt : 200 } }, { publicationYear : { $lt : 2010 } } ] } )
Page
Count
Publication
Year
Amazon
Review
Title Name
Author
Data Modeling Made
Simple
Steve Hober-
man
250
2009
4.35
db.title.find( { authorName : { $ne : “Shive” } } )
Page
Count
Publication
Year
Amazon
Review
Title Name
Author
Extreme Scoping
300
2013
Larissa Moss
4.5
Barry Devlin,
PhD
Business unIntelligence
442
2013
5
Data Modeling Made
Simple
Steve Hober-
man
250
2009
4.35
EXERCISE
4:
M
ONGO
DB F
UNCTIONALITY
Here is the statement to insert this data into the
Title
collection:
db.Title.insert( [ { titleName : “FruITion”,
pageCount : 100,
publicationYear : “2010”,
author : “Chris Potts”
},
{ titleName : “Data Quality Assessment”,
pageCount : 400,
publicationYear : “2009”,
