Transportation connection cache for dynamic network and route determination

A computer program product tangibly embodied on a non-transitory computer-readable storage medium and including executable code that, when executed, is configured to cause at least one processor to retrieve transportation information related to a shipment of goods, the executable code including instructions to:

• receive transportation parameters including at least a first location and a second location;
• query a connection cache based on the transportation parameters, the connection cache storing connection-relevant transportation information for transportation objects, the connection-relevant transportation information having been replicated from at least one of a plurality of transportation object sources, the plurality of transportation object sources including at least a first database storing schedules, a second database storing freight bookings, and a third database storing freight orders;
• and
• select one or more transportation objects from the connection cache related to at least one of the schedules, the freight bookings, and the freight orders, that are relevant for the first location and the second location.

A method for determining one or more transportation proposals for a shipment of goods, the method comprising:

• replicating, by at least one processor, connection-relevant transportation information from at least one of a plurality of transportation object sources, the plurality of transportation object sources including at least a first database storing schedules, a second database storing freight bookings, and a third database storing freight orders;
• storing, by the at least one processor, the connection-relevant transportation information as transportation objects to create a connection cache database;
• receiving, by the at least one processor, transportation parameters for the shipment of goods from a first location to a second location;
• selecting, by the at least one processor, a transportation network including determining connections within the transportation network for the first location and the second location based on the connection-relevant transportation information in the connection cache database;
• and
• determining, by the at least one processor, one or more transportation proposals based on the determined connections within the selected transportation network, each transportation proposal providing a different transportation plan for transporting the goods from the first location to the second location.