database 在哪里可以找到可以在多个数据库引擎中使用的具有通用格式数据的示例数据库？

Where can I find sample databases with common formatted data that I can use in multiple database engines?

提问by Kibbee

Does anybody know of any sample databases I could download, preferably in CSV or some similar easy to import format so that I could get more practice in working with different types of data sets?

有谁知道我可以下载任何示例数据库，最好是 CSV 或一些类似的易于导入的格式，以便我可以在处理不同类型的数据集时获得更多实践？

I know that the Canadian Department of Environment has historical weather datathat you can download. However, it's not in a common format I can import into any other database. Moreover, you can only run queries based on the included program, which is actually quite limited in what kind of data it can provide.

我知道加拿大环境部有历史天气数据可供您下载。但是，它不是我可以导入任何其他数据库的通用格式。而且，只能基于包含的程序运行查询，实际上它可以提供的数据类型非常有限。

Does anybody know of any interesting data sets that are freely available in a common format that I could use with mySql, Sql Server, and other types of database engines?

有没有人知道我可以在 mySql、Sql Server 和其他类型的数据库引擎中使用的以通用格式免费提供的任何有趣的数据集？

采纳答案by Adam Hollidge

The datawrangling blog posted a nice list a while back:

datawrangling 博客不久前发布了一个不错的列表：

http://www.datawrangling.com/some-datasets-available-on-the-web

http://www.datawrangling.com/some-datasets-available-on-the-web

Includes financial, government data (labor, housing, etc.), and too many more to list here.

包括财务、政府数据（劳动力、住房等），还有太多无法在此列出。

回答by Kibbee

A lot of the data in Stack Overflow is licensed under the create commons. Every 3 months they release a data dumpwith all the questions, answers, comments, and votes.

Stack Overflow 中的很多数据都是在创建公共资源下获得许可的。他们每 3 个月发布一次包含所有问题、答案、评论和投票的数据转储。

回答by Yada

For MySQL there are quite a few sample database at http://dev.mysql.com/doc/index-other.html

对于 MySQL，http://dev.mysql.com/doc/index-other.html 上有很多示例数据库

1. world (world countries and cities)
2. sakila(video rental)
3. employee
4. menagerie

1. 世界（世界国家和城市）
2. sakila（视频出租）
3. 员工
4. 动物园

回答by Corey

For Microsoft SQL Server, there is the Northwind Sample DBand AdventureWorks.

对于 Microsoft SQL Server，有Northwind Sample DB和AdventureWorks。

回答by Stphane

I use generatedata.comto generate custom databases schemes with entries.

我使用generatedata.com生成带有条目的自定义数据库方案。

To use it, you can simply register a new account, or download its sources and install it on your server.

要使用它，您只需注册一个新帐户，或下载其源代码并将其安装在您的服务器上。

You can export generated code in SQL, XML, JSON, or even server-side scripting language like php etc.

您可以使用 SQL、XML、JSON 甚至服务器端脚本语言（如 php 等）导出生成的代码。

回答by andyuk

UnDataand Swivelare both good sources for data. Any database should be able to import CSV files.

UnData和Swivel都是很好的数据来源。任何数据库都应该能够导入 CSV 文件。

回答by Kilhoffer

What database engine are you importing into? That will help determine what formats you can include in your search.

您要导入什么数据库引擎？这将有助于确定您可以在搜索中包含哪些格式。

The Federal Energy RegulatoryCommission has some sample data for download in CSV format.

在美国联邦能源监管委员会有CSV格式下载一些样本数据。

回答by gorilla

The Guardian newspaper in the UK has a data-store, http://www.guardian.co.uk/data-store, full of categorized datasets. They're all ultimately stored as Google Documents, so you can export them into csv & Excel.

英国的卫报有一个数据存储，http://www.guardian.co.uk/data-store，里面装满了分类数据集。它们最终都存储为 Google 文档，因此您可以将它们导出到 csv 和 Excel 中。

回答by nathanchere

There's a whole bunch of free SQL Server sample databases on CodePlex: http://www.codeplex.com/Wikipage?ProjectName=SqlServerSamples#databases

CodePlex 上有一大堆免费的 SQL Server 示例数据库：http: //www.codeplex.com/Wikipage?ProjectName =SqlServerSamples#databases

One very simple way to get sample data is use full applications. I needed some sample data to practice what I was learning with MySQL at the time and just downloaded PHPBB and used their provided database. If you need to add users etc, just use the program to do it.

获取样本数据的一种非常简单的方法是使用完整的应用程序。我需要一些示例数据来练习我当时在 MySQL 中学习的内容，并且刚刚下载了 PHPBB 并使用了他们提供的数据库。如果您需要添加用户等，只需使用该程序即可。

Think generic. You can get weather data from common sources for free, thetvdb.com has a pretty nifty set of data for TV show episodes for free, sites like last.fm have a tonne of data available for music listening habits. If you just want sample data, the easiest way to get it is not thinking in terms of "I want a database". Think "what freely available data is out there".

认为通用。您可以免费从常见来源获取天气数据，thetvdb.com 有一组非常漂亮的免费电视节目数据集，last.fm 等网站有大量可用于音乐收听习惯的数据。如果您只想要示例数据，那么获取它的最简单方法不是考虑“我想要一个数据库”。想想“那里有哪些免费可用的数据”。

回答by good experience

For FileMaker, see Sample Database: http://www.yzysoft.com/printouts/yzy_soft___Sample_Database.html

对于 FileMaker，请参阅示例数据库：http: //www.yzysoft.com/printouts/yzy_soft___Sample_Database.html