{"repo":"mariadb-corporation/mariadb-analytics-sample-data","free":true,"listed":false,"github":"https://github.com/mariadb-corporation/mariadb-analytics-sample-data","clone":"git clone https://github.com/mariadb-corporation/mariadb-analytics-sample-data.git","description":"Example OLAP queries and dataset","language":"Shell","stars":21,"topics":["database","columnstore","analytics","olap","mariadb"],"license":null,"category":"analytics","readme_excerpt":"Sample Analytics Data Description This simple data set uses the on time performance dataset from the Bureau of Transportation Statistics (BTS) for US based commercial airline flights. This includes the following 3 tables: airlines : Dimension table for airlines (30 records) airports : Dimension table for airports (400 records) flights : Fact table for airline departure data (38,083,735 records) Prerequisite A MariaDB server is required. For a quick test environment, try MariaDB Cloud. Quick Start Clone The Repo Run The Project This script will: 1. Create sample schemas(s) 2. Download flight data from our public S3 bucket 3. Load into the database 4. Offer you the ability to clone this data to InnoDB for direct comparisions with ColumnStore. Sample Queries The following sample queries are provided in the queries directory: 1. 1.sql : Provides a report of flight count, market share percentage, cancelled flights percentage, and diverted flights percentage by airline for 2020. 2. 2.sql : Provides a report of the delay types by airline by year. 3. 3.sql : Provides a report of the volume and average arrival delay for California based airports by airline in 2020. 4. 4.sql : Provides a report of the average and maximum delay by month and hour in the day for bay area airports in 2020. 5. 5.sql : Provides a report of the average and maximum delay by day and hour for bay area airports in November 2020. or InnoDB vs Analytics Comparison Environment Metric Value :--------------------- ---","default_branch":null,"files":null,"tree":[],"storefront":"/r/mariadb-corporation","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/mariadb-corporation/mariadb-analytics-sample-data/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}