This is a small Relational Graph Analytics Benchmark (sRGAB) to test the capabilities and the correctness of a relational database that supports graph analytics.
There are three relational tables (airports, airlines, and routes), x sanity check queries, and x benchmark queries.
The data are taken from the OpenFlights Airport, Airline and Route Databases which are made available under the Open Database License.
-
Run
generate-sql.shto create theopenflights_copy.sqlfile with the correct local path to copy the data from. This should be run in the same directory where the .dat files are. -
Next, setup the database by executing the sql scripts in the following order:
openflights_schema.sql
openflights_copy.sql
openflights_alter.sql
- If you need to drop the database, run
openflights_drop.sql
| AIRPORTS | ROUTES | AIRLINES | ||
|---|---|---|---|---|
| AirportID (pk) | Airline | AirlineID (pk) | ||
| Name | AirlineID (fk) | Name | ||
| City | SourceAirport | Alias | ||
| Country | SourceAirportID (fk) | IATA | ||
| IATA | DestinationAirport | ICAO | ||
| ICAO | DestinationAirportID (fk) | Callsign | ||
| Latitude | Codeshare | Country | ||
| Longitude | Stops | Active | ||
| Altitude | Equipment | |||
| Timezone | ||||
| DST | ||||
| Tz | ||||
| Type | ||||
| Source |