M001: MongoDB Basics chapter 1 Introduction学习记录

M001: MongoDB Basics chapter 1 Introduction学习记录

运行环境

操作系统：windows 10 家庭中文版
Mongodb ：Mongodb 3.4

Mongodb安装路径：E:>MongoDB\Server\3.4\bin\
Mongodb存储路径：E:>MongoDB\data

课后问题

Lab 1.1: Install Compass and Connect

Problem:

If you have not yet downloaded Compass, please follow these instructions. Then answer the question below.

 1. Please download Compass from the MongoDB Download Center.
 2. Install Compass on your computer from the download.
 3. Launch Compass.

4. Use the following information to complete this form, but do not click "Connect" yet. Hostname is cluster0-shard-00-00-jxeqq.mongodb.net. Username is m001-student. Password is m001-mongodb-basics.
5. Click "Add to Favorites" so that you can easily connect to our class MongoDB deployment after closing and restarting Compass at some point in the future.
6. Now, click "Connect" and load the databases in the M001 class MongoDB deployment.
When Compass opens you will see a page titled "Connect to Host".

Question Which of the following field names appear in documents in the movies collection of the video database. Check all that apply.

Attempts Remaining:Correct Answer

• _id
• cast
• comments
• director
• genre
• length
• plot
• stars

解答

1. 按照题目给出的地址下载Compass工具,地址：MongoDB Compass
2. 安装MongoDB Compass工具（图文界面，傻瓜操作）
3. 启动MongoDB Compass工具，并按所给图示配置，使用所给账号密码登陆远程数据库服务

点击连接后进入后显示如图：

点击进入video库的movies 集合，观察可知出现过的字段名为：

_id，cast，director，genre，plot

Lab 1.2: Determine the Value Type, Part 1

Problem:
What is the value type of the ts field for documents in the 100YWeatherSmall.data collection?

Choose the best answer:

Attempts Remaining:Correct Answer
* array
* coordinates
* date
* document
* double
* int32
* mixed string and int32
* mixed string and double
* string

解答

按要求使用Compass工具进入100YWeatherSmall库的data集合
点击按table查看集合状态，可观察到ts字段的数据类型：

可知其字段类型为ts

Lab 1.3: Determine the Value Type, Part 2

Problem:
What is the value type of the airTemperature field for documents in the 100YWeatherSmall.data collection?

Choose the best answer:

Attempts Remaining:Incorrect Answer
* array
* coordinates
* date
* document
* double
* int32
* mixed string and int32
* mixed string and double
* string

解答

观察可知100YWeatherSmall库的data集合的 airTemperature 字段是个内嵌文档，所以选

document

Lab 1.4: Determine the Value Type, Part 3

Problem:
What is the value type of the year field for documents in the video.movies collection?

Choose the best answer:

Attempts Remaining:Correct Answer
* array
* coordinates
* date
* document
* double
* int32
* mixed string and int32
* mixed string and double
* string

解答

观察可知(方法同Lab 1.2)video库的movies集合中的year字段类型为

int32

Lab 1.5: Scavenger Hunt, Part 1

Problem:
How many movies in the video collection were directed by Patty Jenkins. Stated more precisely, how many documents in the video.movies collection have a value of “Patty Jenkins” for the director field?

Choose the best answer:

Attempts Remaining:Correct Answer
* 6
* 13
* 47
* 98
* 143

解答

按要求进入video库的movies集合，在查询栏输入查询命令：

{"director":"Patty Jenkins"}

查出结果如下：

可知总共有6条数据满足条件

Lab 1.6: Scavenger Hunt, Part 2

Problem:
How many documents in the citibike.trips collection have a tripduration that is greater than or equal to 60 and less than 65?

Choose the best answer:

Attempts Remaining:Correct Answer
* 0
* 94
* 216
* 355
* 754

解答

按要求进入citibike库的trips集合，执行查询命令：

{"tripduration":{"$gte":60,"$lt":65}}

查出结果如下：

可知总共有754条数据满足条件

Lab 1.7: Scavenger Hunt, Part 3

Problem:
Based on our shipwrecks dataset, how many shipwrecks lay off the coast of Cancun, Mexico? Choose the answer that best describes the number of shipwrecks you are able to find using Compass.

Choose the best answer:

Attempts Remaining:Correct Answer
* 0-10
* 25-50
* 51-100
* 101-200
* 201 or more

解答

按要求进入ships库的shipwrecks集合，并切换至Schema，以图表模式分析schema并快速查看schema：

可观察到coordinates字段已经转化为地图模式，在其中查看Mexico的Cancun港的船舶情况：

可观察到一条船都没有，所以选择0-10