![]() So it's big enough to be interesting, but not unwieldy. In addition to being a well-rounded OLTP sample, it is also a good choice to demonstrate ETL into a data warehouse. The code in some of the views demonstrates effective techniques for querying XML data. Custom format dump, 1.9GB compressed, but restored database is tens of GB in size. MGI is the international database resource for the laboratory mouse, providing integrated genetic, genomic, and biological data to facilitate the study of human health and disease. MGI use PostgreSQL in production, providing direct protocol access to researchers, so the custom format dump is not an afterthought.Benchmarking databases such as DBT-2 or TPC-H can be used as samples.Freebase - Various wiki style data on places/people/things - ~600MB compressed.OMDB - Open Media database, ~30MB compressed, 300MB when loaded.- US federal government data collection, see also Sunlight Labs.DBpedia - Wikipedia data export project.eoddata - historic stock market data (requires registration - licence?).RITA - Airline On-Time Performance Data.Openstreetmap - Openstreetmap source data.NCBI - biological annotation from NCBI's ENTREZ system (updated daily).Airlines Demo Database - Airlines Demo Database provides database schema with several tables and meaningful content, which can be used for learning SQL and writing applications.Stack Exchange Data Dump - Anonymized dump of all user-contributed content on the Stack Exchange network (Stack Overflow, Server Fault.) under cc-by-sa 3.0 license.Use this tool to import XML dumps in PostgresQL :.The Museum of Modern Art (MoMA) collection data - This research dataset contains more than 130,000 records, representing all of the works that have been accessioned into MoMA’s collection and cataloged in our database.It includes basic metadata for each work, including title, artist, date made, medium, dimensions, and date acquired by the Museum.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |