Airline schedules published to OAG provide the latest daily arrivals and departures at each airport. Each airport provides terminal and gate configurations, such as airline specific vs. common use, domestic vs. international, gate capacity by aircraft type, and adjacency constraints. Each airport provides airport operating costs by terminals and airport level costs. All batch inputs, like SSIM (schedule files), SSM (updates to schedules), configurations and operating costs are loaded into a batch staging bucket in Amazon S3. Use AWS Glue and Amazon EMR to discover, catalog, process inputs, and create the processed data in Amazon S3. These services process batch data to create the flight data from SSIM and SSM files and PARQUET format for all the other data. Flight data is created by converting the schedule files into individual flights. Hourly and daily passenger traffic, and landing slots by hour are created based on flight data. Optimized airport terminal and gate assignments are created based on terminal and gate configurations and operating costs. Visualization and reports are provided using ondemand Amazon Athena and Amazon QuickSight. Optionally, build a configuration dashboard with microservices using Amazon API Gateway, AWS Lambda, and Amazon DynamoDB to collect changes to configurations and use these configurations to create what-if-analyses for gate and terminal assignments.
