Database

The default data storage solution for PassengerSim is a SQLite database file.

Database Tables

The following tables are created when running a simulation:

Table	Description
carrier_summary	Aggregate summary information on carrier performance.
leg_defs	Static data about network legs
leg_detail	Simulation data at the leg level
leg_bucket_detail	Simulation data at the leg-bucket level
path_class_detail	Simulation data at the path-class level
demand_detail	Simulation data at the demand level
fare_detail	Simulation data at the fare level
bookings_by_timeframe	Aggregate summary simulation data on bookings by timeframe and bookings class

Common Queries

PassengerSim has a number of pre-packaged functions that query the database of results to provide useful summary tables.

Query	Description
bid_price_history	Compute average bid price history over all legs for each carrier
bookings_by_timeframe	Average bookings and revenue by carrier, booking class, and timeframe
carrier_history	Sample-level details of carrier-level measures
demand_to_come	Demand by market and timeframe across each sample
fare_class_mix	Fare class mix by carrier
leg_forecasts	Average forecasts of demand by leg, bucket, and days to departure
local_and_flow_yields	Yields for local (nonstop) and flow (connecting) passengers by leg
od_fare_class_mix	Fare class mix by carrier for a particular origin-destination market
path_forecasts	Average forecasts of demand by path, class, and days to departure
total_demand	Average total demand