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_summary	Aggregate summary information on legs.
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

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