blocks|key|925358|text|我找到了this，您可以使用以下命令导入json数据：|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|925359|mongoimport+--db+scratch+--collection+zips+--file+zips.json|code-block|syntax|javascript|925360|我猜你可以导入你找到的任何json数据，它也支持csv和tsv。希望这能有所帮助。|925361|entityMap|0|LINK|mutability|MUTABLE|url|http://media.mongodb.org/zips.json^0|4|4|0|0|0|0^^$0|@$1|2|3|4|5|6|7|S|8|@]|9|@$A|T|B|U|1|V]]|C|$]]|$1|D|3|E|5|F|7|W|8|@]|9|@]|C|$G|H]]|$1|I|3|J|5|6|7|X|8|@]|9|@]|C|$]]|$1|K|3|-4|5|6|7|Y|8|@]|9|@]|C|$]]]|L|$M|$5|N|O|P|C|$Q|R]]]]

I found <a href="http://media.mongodb.org/zips.json" rel="noreferrer">this</a> you can import the json data with: 

<pre><code>mongoimport --db scratch --collection zips --file zips.json
</code></pre>

I guess that you can import any json data that you find, it also supports csv and tsv. Hope this helps.

blocks|key|709152|text|您可以创建TPC-H基准数据集并导入它们。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|709153|lineitem表的导入示例：|709154|./mongoimport+-d+test+-c+lineitem+--type+csv+-f++l_orderkey,l_partkey,l_suppkey,l_linenumber,l_quantity,l_extendedprice,l_discount,l_tax,l_returnflag,l_linestatus,l_shipdate,l_commitdate,l_receiptdate,l_shipinstruct,l_shipmode,l_comment+--file+/home/metdos/mongo/tpc-h/tpch_2_13_0/lineitem.tbl|code-block|syntax|javascript|709155|entityMap|0|LINK|mutability|MUTABLE|url|http://www.tpc.org/tpch/^0|5|5|0|0|0|0^^$0|@$1|2|3|4|5|6|7|S|8|@]|9|@$A|T|B|U|1|V]]|C|$]]|$1|D|3|E|5|6|7|W|8|@]|9|@]|C|$]]|$1|F|3|G|5|H|7|X|8|@]|9|@]|C|$I|J]]|$1|K|3|-4|5|6|7|Y|8|@]|9|@]|C|$]]]|L|$M|$5|N|O|P|C|$Q|R]]]]

You can create <a href="http://www.tpc.org/tpch/" rel="nofollow">TPC-H</a> benchmark data-sets and import them. 

Example import for lineitem table:

<pre><code>./mongoimport -d test -c lineitem --type csv -f l_orderkey,l_partkey,l_suppkey,l_linenumber,l_quantity,l_extendedprice,l_discount,l_tax,l_returnflag,l_linestatus,l_shipdate,l_commitdate,l_receiptdate,l_shipinstruct,l_shipmode,l_comment --file /home/metdos/mongo/tpc-h/tpch_2_13_0/lineitem.tbl
</code></pre>

blocks|key|709210|text|这并不是万能的，但这是让Northwind在MongoDB上迈出的一大步：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|709211|https://github.com/tmcnab/northwind-mongo|offset|length|709212|entityMap|0|LINK|mutability|MUTABLE|url^0|0|0|15|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|N|8|@]|9|@$D|O|E|P|1|Q]]|A|$]]|$1|F|3|-4|5|6|7|R|8|@]|9|@]|A|$]]]|G|$H|$5|I|J|K|A|$L|C]]]]

This doesn't have everything, but it is a nice step towards getting Northwind on MongoDB:

<a href="https://github.com/tmcnab/northwind-mongo">https://github.com/tmcnab/northwind-mongo</a>

blocks|key|709435|text|http://docs.mongodb.org/manual/tutorial/aggregation-zip-code-data-set/在以下链接提供了一个json文件：http://media.mongodb.org/zips.json，它是邮政编码数据。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|709436|这可以用于Map-Reduce、聚合和分组查询的学习目的，MongoDB上的上面的教程链接也展示了如何学习。|709437|你可以安装一个MongoVUE工具(来自http://www.mongovue.com)，这是一个用于MongoDB外壳操作的集成开发环境，还提供了映射缩减、聚合和过滤支持，以及从MySQL数据库到MongoDB的数据导入。|709438|上面链接中的JSON文件有3个重复的_id条目，这会阻碍导入过程，您可能需要对插入的文档执行removeall操作。但最终，您的集合中应该有29,467个文档。|709439|​|709440|📷|atomic|709441|709442|entityMap|0|LINK|mutability|MUTABLE|url|http://docs.mongodb.org/manual/tutorial/aggregation-zip-code-data-set/|1|http://media.mongodb.org/zips.json|2|http://www.mongovue.com/|3|IMAGE|IMMUTABLE|imageUrl|https://ask.qcloudimg.com/http-save/yehe-900000/4d38ad5a094fe6c869b98ad0feb2032e.jpeg|imageAlt^0|0|1Y|0|2F|Y|1|0|0|K|N|2|0|0|0|0|1|3|0|0^^$0|@$1|2|3|4|5|6|7|17|8|@]|9|@$A|18|B|19|1|1A]|$A|1B|B|1C|1|1D]]|C|$]]|$1|D|3|E|5|6|7|1E|8|@]|9|@]|C|$]]|$1|F|3|G|5|6|7|1F|8|@]|9|@$A|1G|B|1H|1|1I]]|C|$]]|$1|H|3|I|5|6|7|1J|8|@]|9|@]|C|$]]|$1|J|3|K|5|6|7|1K|8|@]|9|@]|C|$]]|$1|L|3|M|5|N|7|1L|8|@]|9|@$A|1M|B|1N|1|1O]]|C|$]]|$1|O|3|K|5|6|7|1P|8|@]|9|@]|C|$]]|$1|P|3|-4|5|6|7|1Q|8|@]|9|@]|C|$]]]|Q|$R|$5|S|T|U|C|$V|W]]|X|$5|S|T|U|C|$V|Y]]|Z|$5|S|T|U|C|$V|10]]|11|$5|12|T|13|C|$14|15|16|-4]]]]

<a href="http://docs.mongodb.org/manual/tutorial/aggregation-zip-code-data-set/" rel="nofollow noreferrer">http://docs.mongodb.org/manual/tutorial/aggregation-zip-code-data-set/</a> provides a json file at the link : <a href="http://media.mongodb.org/zips.json" rel="nofollow noreferrer">http://media.mongodb.org/zips.json</a> which is zip code data.

This can be used for Map-Reduce, Aggregation and Grouping queries learning purposes and the above tutorial link at MongoDB also shows how.

For Windows: You can install a MongoVUE tool (from <a href="http://www.mongovue.com" rel="nofollow noreferrer">http://www.mongovue.com</a>) , which is IDE for MongoDB shell operations and also provides Map-Reduce, Aggregation and Filtering support as well as data import from MySQL databases to MongoDB.

The JSON file at the link above has 3 duplicate _id entries which will hinder the import process a bit and you may have to do removeall for inserted documents. But in the end you should have 29,467 documents in your collection.

<img src="https://i.stack.imgur.com/V8dPL.jpg" alt="MongoVUE IDE after the import">

blocks|key|925714|text|在根据@tslater下载了Northwind数据之后，我对它进行了一些清理。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|925715|​|925716|📷|atomic|925717|925718|并运行以下PowerShell命令以导入到mongo中：|925719|Get-ChildItem+"C:\MongoDb\samples\northwind\csv"+-Filter+*.csv+%7C+`
Foreach-Object+{
++++C:\MongoDb\bin\mongoimport.exe+-h+localhost:55000+-d+northwind+-c+$_.BaseName+--type+csv+--file+$_.FullName+--headerline+
}|code-block|syntax|javascript|925720|entityMap|0|LINK|mutability|MUTABLE|url|https://github.com/tmcnab/northwind-mongo|1|IMAGE|IMMUTABLE|imageUrl|https://ask.qcloudimg.com/http-save/yehe-900000/4bb34b86202f2769fd76ebeb248d6022.png|imageAlt^0|E|9|0|0|0|0|1|1|0|0|0|0^^$0|@$1|2|3|4|5|6|7|14|8|@]|9|@$A|15|B|16|1|17]]|C|$]]|$1|D|3|E|5|6|7|18|8|@]|9|@]|C|$]]|$1|F|3|G|5|H|7|19|8|@]|9|@$A|1A|B|1B|1|1C]]|C|$]]|$1|I|3|E|5|6|7|1D|8|@]|9|@]|C|$]]|$1|J|3|K|5|6|7|1E|8|@]|9|@]|C|$]]|$1|L|3|M|5|N|7|1F|8|@]|9|@]|C|$O|P]]|$1|Q|3|-4|5|6|7|1G|8|@]|9|@]|C|$]]]|R|$S|$5|T|U|V|C|$W|X]]|Y|$5|Z|U|10|C|$11|12|13|-4]]]]

After downloading <a href="https://github.com/tmcnab/northwind-mongo" rel="noreferrer">Northwind</a> data as per @tslater, I cleaned it up a bit..

<img src="https://i.stack.imgur.com/WkDmq.png" alt="">

And ran the following PowerShell command to import into the mongo:

<pre><code>Get-ChildItem "C:\MongoDb\samples\northwind\csv" -Filter *.csv | `
Foreach-Object {
 C:\MongoDb\bin\mongoimport.exe -h localhost:55000 -d northwind -c $_.BaseName --type csv --file $_.FullName --headerline 
}
</code></pre>

blocks|key|709578|text|从https://github.com/tmcnab/northwind-mongo/archive/master.zip下载Northwind+csv文件集合|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|709579|执行以下命令，将csv导入mongodb|709580|mongoimport+-d+Northwind+-c+categories+--type+csv+--file+categories.csv+--headerline
mongoimport+-d+Northwind+-c+customers+--type+csv+--file+customers.csv+--headerline
mongoimport+-d+Northwind+-c+employee-territories+--type+csv+--file+employee-territories.csv+--headerline
mongoimport+-d+Northwind+-c+employees+--type+csv+--file+employees.csv+--headerline
mongoimport+-d+Northwind+-c+northwind+--type+csv+--file+northwind.csv+--headerline
mongoimport+-d+Northwind+-c+order-details+--type+csv+--file+order-details.csv+--headerline
mongoimport+-d+Northwind+-c+orders+--type+csv+--file+orders.csv+--headerline
mongoimport+-d+Northwind+-c+products+--type+csv+--file+products.csv+--headerline
mongoimport+-d+Northwind+-c+regions+--type+csv+--file+regions.csv+--headerline
mongoimport+-d+Northwind+-c+shippers+--type+csv+--file+shippers.csv+--headerline
mongoimport+-d+Northwind+-c+suppliers+--type+csv+--file+suppliers.csv+--headerline
mongoimport+-d+Northwind+-c+territories+--type+csv+--file+territories.csv+--headerline|code-block|syntax|javascript|709581|这可用于Windows和Liinux操作系统|709582|entityMap|0|LINK|mutability|MUTABLE|url|https://github.com/tmcnab/northwind-mongo/archive/master.zip^0|1|1O|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|U|8|@]|9|@$A|V|B|W|1|X]]|C|$]]|$1|D|3|E|5|6|7|Y|8|@]|9|@]|C|$]]|$1|F|3|G|5|H|7|Z|8|@]|9|@]|C|$I|J]]|$1|K|3|L|5|6|7|10|8|@]|9|@]|C|$]]|$1|M|3|-4|5|6|7|11|8|@]|9|@]|C|$]]]|N|$O|$5|P|Q|R|C|$S|T]]]]

Download the collection of Northwind csv files from <a href="https://github.com/tmcnab/northwind-mongo/archive/master.zip" rel="noreferrer">https://github.com/tmcnab/northwind-mongo/archive/master.zip</a> 

Execute following command to import csv into mongodb

<pre><code>mongoimport -d Northwind -c categories --type csv --file categories.csv --headerline
mongoimport -d Northwind -c customers --type csv --file customers.csv --headerline
mongoimport -d Northwind -c employee-territories --type csv --file employee-territories.csv --headerline
mongoimport -d Northwind -c employees --type csv --file employees.csv --headerline
mongoimport -d Northwind -c northwind --type csv --file northwind.csv --headerline
mongoimport -d Northwind -c order-details --type csv --file order-details.csv --headerline
mongoimport -d Northwind -c orders --type csv --file orders.csv --headerline
mongoimport -d Northwind -c products --type csv --file products.csv --headerline
mongoimport -d Northwind -c regions --type csv --file regions.csv --headerline
mongoimport -d Northwind -c shippers --type csv --file shippers.csv --headerline
mongoimport -d Northwind -c suppliers --type csv --file suppliers.csv --headerline
mongoimport -d Northwind -c territories --type csv --file territories.csv --headerline
</code></pre>

This can be used for both Windows and Liinux OS

blocks|key|925807|text|只要有空闲时间，我就会更新电影收藏。就我个人而言，它对我非常有用，因为它包含嵌入式对象、数组字段、字符串字段、日期字段。单击此处获取movie+collection的JSON文件|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|925808|一个文档的演示|925809|{
++++"_id"+:+ObjectId("5692a15524de1e0ce2dfcfa3"),
++++"title"+:+"Toy+Story+4",
++++"year"+:+2011,
++++"rated"+:+"G",
++++"released"+:+ISODate("2010-06-18T04:00:00.000Z"),
++++"runtime"+:+206,
++++"countries"+:+[+
++++++++"USA"
++++],
++++"genres"+:+[+
++++++++"Animation",+
++++++++"Adventure",+
++++++++"Comedy"
++++],
++++"director"+:+"Lee+Unkrich",
++++"writers"+:+[+
++++++++"John+Lasseter",+
++++++++"Andrew+Stanton",+
++++++++"Lee+Unkrich",+
++++++++"Michael+Arndt"
++++],
++++"actors"+:+[+
++++++++"Tom+Hanks",+
++++++++"Tim+Allen",+
++++++++"Joan+Cusack",+
++++++++"Ned+Beatty"
++++],
++++"plot"+:+"The+toys+are+mistakenly+delivered+to+a+day-care+center+instead+of+the+attic+right+before+Andy+leaves+for+college,+and+it's+up+to+Woody+to+convince+the+other+toys+that+they+weren't+abandoned+and+to+return+home.",
++++"poster"+:+"http://ia.media-imdb.com/images/M/MV5BMTgxOTY4Mjc0MF5BMl5BanBnXkFtZTcwNTA4MDQyMw@@._V1_SX300.jpg",
++++"imdb"+:+{
++++++++"id"+:+"tt0435761",
++++++++"rating"+:+8.4,
++++++++"votes"+:+500084
++++},
++++"tomato"+:+{
++++++++"meter"+:+99,
++++++++"image"+:+"certified",
++++++++"rating"+:+8.9,
++++++++"reviews"+:+287,
++++++++"fresh"+:+283,
++++++++"consensus"+:+"Deftly+blending+comedy,+adventure,+and+honest+emotion,+Toy+Story+3+is+a+rare+second+sequel+that+really+works.",
++++++++"userMeter"+:+89,
++++++++"userRating"+:+4.3,
++++++++"userReviews"+:+602138
++++},
++++"metacritic"+:+92,
++++"awards"+:+{
++++++++"wins"+:+56,
++++++++"nominations"+:+86,
++++++++"text"+:+"Won+2+Oscars.+Another+56+wins+&+86+nominations."
++++},
++++"type"+:+"movie",
++++"reviews"+:+[+
++++++++{
++++++++++++"date"+:+ISODate("2017-02-13T04:00:00.000Z"),
++++++++++++"name"+:+"parvesh",
++++++++++++"rating"+:+8.9,
++++++++++++"comment"+:+"My+first+review+for+Toy+Story+3,+hoping+it+will+execute+while+trying+for+the+very+first+time."
++++++++},+
++++++++{
++++++++++++"date"+:+ISODate("2017-02-13T04:00:00.000Z"),
++++++++++++"name"+:+"Prabhash",
++++++++++++"rating"+:+9.3,
++++++++++++"comment"+:+"My+second+review+for+Toy+Story+3,+hoping+it+will+execute+while+trying+for+the+very+first+time."
++++++++},+
++++++++{
++++++++++++"date"+:+ISODate("2017-02-11T04:00:00.000Z"),
++++++++++++"name"+:+"praveen",
++++++++++++"rating"+:+6.7,
++++++++++++"comment"+:+"My+third+review+for+Toy+Story+3,+hoping+it+will+execute+while+trying+for+the+very+first+time."
++++++++}
++++]
}|code-block|syntax|javascript|925810|entityMap|0|LINK|mutability|MUTABLE|url|https://github.com/mistertandon/node-express-hbs/blob/master/movies_collection.json^0|1U|G|0|0|0|0^^$0|@$1|2|3|4|5|6|7|S|8|@]|9|@$A|T|B|U|1|V]]|C|$]]|$1|D|3|E|5|6|7|W|8|@]|9|@]|C|$]]|$1|F|3|G|5|H|7|X|8|@]|9|@]|C|$I|J]]|$1|K|3|-4|5|6|7|Y|8|@]|9|@]|C|$]]]|L|$M|$5|N|O|P|C|$Q|R]]]]

I am updating movies collection, whenever get free time.
Personally it is very useful for me as it contains embedded object, array field, string field, date field. Click here to get JSON file of <a href="https://github.com/mistertandon/node-express-hbs/blob/master/movies_collection.json" rel="nofollow noreferrer">movie collection</a>

Demo of one document

<pre><code>{
 "_id" : ObjectId("5692a15524de1e0ce2dfcfa3"),
 "title" : "Toy Story 4",
 "year" : 2011,
 "rated" : "G",
 "released" : ISODate("2010-06-18T04:00:00.000Z"),
 "runtime" : 206,
 "countries" : [ 
 "USA"
 ],
 "genres" : [ 
 "Animation", 
 "Adventure", 
 "Comedy"
 ],
 "director" : "Lee Unkrich",
 "writers" : [ 
 "John Lasseter", 
 "Andrew Stanton", 
 "Lee Unkrich", 
 "Michael Arndt"
 ],
 "actors" : [ 
 "Tom Hanks", 
 "Tim Allen", 
 "Joan Cusack", 
 "Ned Beatty"
 ],
 "plot" : "The toys are mistakenly delivered to a day-care center instead of the attic right before Andy leaves for college, and it's up to Woody to convince the other toys that they weren't abandoned and to return home.",
 "poster" : "http://ia.media-imdb.com/images/M/MV5BMTgxOTY4Mjc0MF5BMl5BanBnXkFtZTcwNTA4MDQyMw@@._V1_SX300.jpg",
 "imdb" : {
 "id" : "tt0435761",
 "rating" : 8.4,
 "votes" : 500084
 },
 "tomato" : {
 "meter" : 99,
 "image" : "certified",
 "rating" : 8.9,
 "reviews" : 287,
 "fresh" : 283,
 "consensus" : "Deftly blending comedy, adventure, and honest emotion, Toy Story 3 is a rare second sequel that really works.",
 "userMeter" : 89,
 "userRating" : 4.3,
 "userReviews" : 602138
 },
 "metacritic" : 92,
 "awards" : {
 "wins" : 56,
 "nominations" : 86,
 "text" : "Won 2 Oscars. Another 56 wins &amp; 86 nominations."
 },
 "type" : "movie",
 "reviews" : [ 
 {
 "date" : ISODate("2017-02-13T04:00:00.000Z"),
 "name" : "parvesh",
 "rating" : 8.9,
 "comment" : "My first review for Toy Story 3, hoping it will execute while trying for the very first time."
 }, 
 {
 "date" : ISODate("2017-02-13T04:00:00.000Z"),
 "name" : "Prabhash",
 "rating" : 9.3,
 "comment" : "My second review for Toy Story 3, hoping it will execute while trying for the very first time."
 }, 
 {
 "date" : ISODate("2017-02-11T04:00:00.000Z"),
 "name" : "praveen",
 "rating" : 6.7,
 "comment" : "My third review for Toy Story 3, hoping it will execute while trying for the very first time."
 }
 ]
}
</code></pre>

As someone new to Mongo, I am looking for a sample MongoDB database that I can import and play with.
Something along the lines of <a href="http://dev.mysql.com/doc/world-setup/en/index.html">world</a> for mysql or <a href="http://www.microsoft.com/downloads/en/details.aspx?FamilyID=06616212-0356-46a0-8da2-eebc53a68034&amp;displaylang=en">Northwind</a> for MSSQL.

Is there one? (I couldn't find any reference to one at <a href="http://www.mongodb.org">http://www.mongodb.org</a> nor did my googling help)

Is there a sample MongoDB Database along the lines of world for MySql?

集成开发环境

SQL数据库

数据库

MongoDB

Windows

MySQL

JSON

作为一个新接触Mongo的人，我正在寻找一个可以导入和使用的示例MongoDB数据库。类似于mysql的或MSSQL的。有吗？(我在上找不到任何参考资料，我的谷歌搜索也没有帮助)

问是否有一个类似于MySql的示例MongoDB数据库？
EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问是否有一个类似于MySql的示例MongoDB数据库？EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问是否有一个类似于MySql的示例MongoDB数据库？
EN