PostgreSQL Discussion - Re: [SQL] Flight numbers data

Author

Re: [SQL] Flight numbers data

Simon Riggs

2006-03-29, 8:26 pm

On Wed, 2006-03-29 at 10:50 -0600, Scott Marlowe wrote:

>
> Where I work, we're building a middle level system (look up the website
> that goes with my domain). And if we weren't in the airline reservation
> industry, we couldn't afford the data sets.
>
>
> But "doing it right" goes against almost every tenet of the airline
> reservation industry :) haha. only serious.

Yeh, IATA don't have a normalised data model, so you're badly out of
luck there.

There are some reasonable books on Data Modelling from Wiley you can get
with fair models in, plus Kimball has a simplified data model in his
Toolkit book.

I'd make sure you get your requirements straight, otherwise the data
model will grow and grow as each new strange-but-true wierdness emerges.

Best Regards, Simon Riggs

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql
.org so that your
message can get through to the mailing list cleanly

Josh Rovero

2006-03-29, 8:26 pm

We built an operational flight tracking and weather system that uses
Postgresql,
http://www.sonalysts.com/wXstation

One data feed (FAA ASDI) uses both aircraft registration
numbers (tail numbers) and airline-assigned flight numbers. Typically
if you have the latter, you won't get the former. This feed only has
information for flights in the U.S. or to/from the U.S. The data feed also
includes flight plans, so it wouldn't be too hard
to build up a flight number schedule over a short period of time.

Outside the U.S. the problem is more difficult.

> Has anyone from the postgresql camp ever solved such a problem?
>

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq

Achilleus Mantzios

2006-03-30, 3:25 am

O Josh Rovero Ýãñáøå óôéò Mar 29, 2006 :

> We built an operational flight tracking and weather system that uses
> Postgresql,
> http://www.sonalysts.com/wXstation
>
> One data feed (FAA ASDI) uses both aircraft registration
> numbers (tail numbers) and airline-assigned flight numbers. Typically
> if you have the latter, you won't get the former. This feed only has
> information for flights in the U.S. or to/from the U.S. The data feed also
> includes flight plans, so it wouldn't be too hard
> to build up a flight number schedule over a short period of time.
>
> Outside the U.S. the problem is more difficult.

Thanx, unfortunately our flights are 90% in middle east/asia.
Are you aware of any such feed in production?

>
>
>

--
-Achilleus

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql
.org so that your
message can get through to the mailing list cleanly

Sponsored Links