Re: Demo: Things in Hierarchies (w/o RM/SQL)

"Laconic2" <laconic2_at_comcast.net> writes:
> An airline reservation system covering about 45 airlines, about 100,000
> flights per day, about 10,000,000 passengers,
> credit cards, airplanes, seating capacity in several classes, and about
> 10,000 fare changes a day. 200 simultaneous users on the web.

say 100 passengers/flight? ... then it is 10m PNR records ... so you might say that there are 5m new PNR records created each day (covers round-trip); 10m PNR records are updated as the flight is taken. The 5m new PNR records are typically created as some time in the future before the flight is actually taken and will exist for 90 days after the flight is teken and then 5m old PNR records are deleted each day as they expire. Say an avg. PNR record is created ten days before the flight, that gives PNR record something like 100 days ... or total PNR databse of possibly approaching 500m records (multiply by 8 if you want to keep for two years instead of 90-some days).

there are actually (at least) four different databases (for res)

PNR database
flight segment/seat database
routes database (i once got to rewrite routes from scratch) fares database

random past posts re: working on routes and/or amadeus

http://www.garlic.com/~lynn/96.html#29 Mainframes & Unix
http://www.garlic.com/~lynn/96.html#31 Mainframes & Unix
http://www.garlic.com/~lynn/99.html#136a checks (was S/390 on PowerPC?)
http://www.garlic.com/~lynn/99.html#153 Uptime (was Re: Q: S/390 on PowerPC?)
http://www.garlic.com/~lynn/2000.html#61 64 bit X86 ugliness (Re: Williamette trace cache (Re: First view of Willamette))
http://www.garlic.com/~lynn/2000f.html#20 Competitors to SABRE?
http://www.garlic.com/~lynn/2001d.html#69 Block oriented I/O over IP
http://www.garlic.com/~lynn/2001d.html#74 Pentium 4 Prefetch engine?
http://www.garlic.com/~lynn/2001g.html#49 Did AT&T offer Unix to Digital Equipment in the 70s?
http://www.garlic.com/~lynn/2001g.html#50 Did AT&T offer Unix to Digital Equipment in the 70s?
http://www.garlic.com/~lynn/2001h.html#76 Other oddball IBM System 360's ?
http://www.garlic.com/~lynn/2001k.html#26 microsoft going poof [was: HP Compaq merger, here we go again.]
http://www.garlic.com/~lynn/2002g.html#2 Computers in Science Fiction
http://www.garlic.com/~lynn/2002i.html#38 CDC6600 - just how powerful a machine was it?
http://www.garlic.com/~lynn/2002i.html#40 CDC6600 - just how powerful a machine was it?
http://www.garlic.com/~lynn/2002j.html#83 Summary: Robots of Doom
http://www.garlic.com/~lynn/2002l.html#39 Moore law
http://www.garlic.com/~lynn/2003b.html#12 InfiniBand Group Sharply, Evenly Divided
http://www.garlic.com/~lynn/2003c.html#52 diffence between itanium and alpha
http://www.garlic.com/~lynn/2003d.html#67 unix
http://www.garlic.com/~lynn/2003n.html#47 What makes a mainframe a mainframe?
http://www.garlic.com/~lynn/2003o.html#17 Rationale for Supercomputers
http://www.garlic.com/~lynn/2003o.html#38 When nerds were nerds
http://www.garlic.com/~lynn/2004b.html#6 Mainframe not a good architecture for interactive workloads
http://www.garlic.com/~lynn/2004b.html#7 Mainframe not a good architecture for interactive workloads
http://www.garlic.com/~lynn/2004m.html#27 Shipwrecks

-- 
Anne & Lynn Wheeler | http://www.garlic.com/~lynn/