SQL · Find the facts
The question
Which onward flights leave after the revised arrival?
Filter affected segments, times and candidate availability.
Explore SQLAirlines & aviation
Help passengers
with missed connections.
Connect flight updates, booking segments and carrier policies. Help support agents find affected connections and check the passenger’s options.
Connection support
Review a missed connection and check an alternative route.
Illustrative use case01 / Use case guide
10 practical use cases.
Compare the data models behind everyday industry tasks, from finding records to following connections.
SQL Filter and calculate Vector Match similar meaning Graph Follow relationships Full-text Find words and phrases
Suggested model combination
Scroll across to compare all four models| Use case | How the data models help | SQL | Vector | Graph | Full-text | Source |
|---|---|---|---|---|---|---|
| Identify connections at risk An inbound delay leaves a passenger with little time for an onward flight. | Graph follows the booking's connected flight segments; SQL compares updated arrivals, departures and gate transfer times for agent review. | SQL included | Vector not needed for this example | Graph included | Full-text not needed for this example | |
| Find passenger rebooking options An agent needs alternatives after a passenger misses a connection. | Graph finds onward journey options; SQL checks times and reported availability; Full-text retrieves applicable rebooking rules before booking-system confirmation. | SQL included | Vector not needed for this example | Graph included | Full-text included | |
| Find delay assistance guidance An agent needs the carrier's meal or hotel policy for a disrupted journey. | Vector matches the passenger's situation to guidance; SQL selects the carrier and disruption category; Full-text retrieves the applicable assistance conditions. | SQL included | Vector included | Graph not needed for this example | Full-text included | |
| Review flight refund eligibility A passenger declines a disrupted itinerary and asks about a refund. | SQL retrieves cancellation, schedule-change and acceptance records; Full-text finds current refund conditions for an authorized agent to review. | SQL included | Vector not needed for this example | Graph not needed for this example | Full-text included | |
| Locate delayed checked bags A passenger needs the latest status of a checked bag. | Graph connects bag tags to the passenger's flight segments; SQL retrieves the latest bag tracking event and claim status. | SQL included | Vector not needed for this example | Graph included | Full-text not needed for this example | |
| Prepare baggage expense claims A passenger needs to submit receipts against the correct baggage incident. | Graph links receipts to the bag incident and trip; SQL totals submitted expenses; Full-text retrieves claim instructions for staff review. | SQL included | Vector not needed for this example | Graph included | Full-text included | |
| Coordinate airport mobility assistance A requested wheelchair service must follow the passenger through connecting airports. | Graph links assistance requests to journey segments and airports; SQL checks request status and updated connection times for service staff. | SQL included | Vector not needed for this example | Graph included | Full-text not needed for this example | |
| Check travel document requirements A check-in agent needs current passport and visa requirements for an itinerary. | Graph follows destination and transit points; SQL filters nationality and travel dates; Full-text retrieves document requirements for staff confirmation. | SQL included | Vector not needed for this example | Graph included | Full-text included | |
| Explain ticket change rules A passenger wants to understand restrictions before changing a booking. | SQL retrieves ticket and fare details; Full-text locates the applicable change restrictions and fare-difference conditions for the agent. | SQL included | Vector not needed for this example | Graph not needed for this example | Full-text included | |
| Find special baggage guidance A traveller asks how to carry an unusual item. | Vector matches the item description to baggage categories; SQL checks recorded size and weight limits; Full-text retrieves packing and acceptance conditions. | SQL included | Vector included | Graph not needed for this example | Full-text included |
Use the query interfaces you need, then connect their results through shared record IDs in your application.
Industry sources 8
These sources describe real industry workflows. The model combinations above are proposed OriginChainDB designs, not customer deployment claims.
- United Airlines — United Mobile App Now Gives People More Information About Their Connecting Flight (opens in a new tab)
- U.S. Department of Transportation — Airline Cancellation and Delay Dashboard (opens in a new tab)
- Delta Air Lines — Damaged, Delayed or Lost Baggage (opens in a new tab)
- Delta Air Lines — Online Baggage Claim (opens in a new tab)
- Delta Air Lines — Wheelchairs, Scooters & Assistive Devices (opens in a new tab)
- International Air Transport Association — Timatic Solutions (opens in a new tab)
- Delta Air Lines — Ticket Rules & Restrictions (opens in a new tab)
- Delta Air Lines — Special Baggage Items (opens in a new tab)
02 / A closer look
An inbound delay puts a connection at risk
An inbound delay puts a connection at risk. A support agent needs the linked itinerary, updated flight information, available alternatives and the policy that applies to this disruption. The illustration uses a synthetic booking.
What makes it difficult
- 01
Flight updates and booking records arrive from different systems.
- 02
A single disrupted segment affects connecting journeys.
- 03
Rebooking guidance varies by carrier and circumstances.
Suggested approach
Check the journey before suggesting a change
Follow connected flight segments, retrieve current status and search the applicable carrier policy. Verify candidate alternatives with the booking system before offering them.
03 / Queries
What each data model does
Select a model to see the question it answers.
Vector · Match the meaning
The question
Find guidance for a delayed inbound connection.
Find approved guidance that matches a traveller's situation.
Explore Vector Graph · Follow the connections
The question
Which connections depend on this inbound flight?
Connect journeys, bookings and dependent flight segments.
Explore Graph Full-text · Find the exact wording
The question
Find the conditions attached to this disruption waiver.
Look up exact waiver codes and policy conditions.
Explore Full-textUse shared record IDs to combine results from the different query interfaces in your application.
04 / Implementation
How to build it
- STEP 01
Choose a delay scenario
Use one hub, authorized flight data and synthetic bookings. Agree which options agents can offer and which cases need specialist handling.
- STEP 02
Link flight segments
Keep flight, segment and booking IDs, update timestamps and policy effective dates. Refresh records and search indexes when sources change.
- STEP 03
Prepare rebooking options
Combine flight filters, journey links and carrier guidance. Show source times and policy citations. Recheck seats and rules with the booking service.
- STEP 04
Replay past disruptions
Test changing availability and unsuitable suggestions with support staff. Pilot with authorized agents while retaining existing booking and approval controls.
05 / Testing
What to measure
Compare these results with your current process before rollout.
Valid option rate
Check how many proposed options pass current availability and policy validation.
Time to a useful brief
Measure the time an agent needs to find the affected connection and relevant guidance.
Stale information
Track results superseded by a newer flight, seat or policy update.
06 / Sources
Examples from the industry
Published projects and reference material relevant to this use case.
United Airlines
United Mobile App now gives people more information about their connecting flight
United announced connection information including countdowns, gate directions, flight status and rebooking options when a connection is missed.
Read the sourceU.S. Department of Transportation
Airline Customer Service Dashboard
The dashboard compares airlines' commitments to passengers during controllable cancellations and delays, showing that available assistance differs between carriers.
Read the sourceThese are industry references, not OriginChainDB customer stories. The implementation above is a proposed example.
Build with OriginChainDB