Changeset: b8d377edbf4f for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=b8d377edbf4f Added Files: sql/benchmarks/ATIS/Tests/aircraft.dat sql/benchmarks/ATIS/Tests/airline.dat sql/benchmarks/ATIS/Tests/airport.dat sql/benchmarks/ATIS/Tests/airport_service.dat sql/benchmarks/ATIS/Tests/city.dat sql/benchmarks/ATIS/Tests/class_of_service.dat sql/benchmarks/ATIS/Tests/code_description.dat sql/benchmarks/ATIS/Tests/compound_class.dat sql/benchmarks/ATIS/Tests/connect_leg.dat sql/benchmarks/ATIS/Tests/day_name.dat sql/benchmarks/ATIS/Tests/dual_carrier.dat sql/benchmarks/ATIS/Tests/fare.dat sql/benchmarks/ATIS/Tests/fconnection.dat sql/benchmarks/ATIS/Tests/flight.dat sql/benchmarks/ATIS/Tests/flight_class.dat sql/benchmarks/ATIS/Tests/flight_day.dat sql/benchmarks/ATIS/Tests/flight_fare.dat sql/benchmarks/ATIS/Tests/food_service.dat sql/benchmarks/ATIS/Tests/ground_service.dat sql/benchmarks/ATIS/Tests/month_name.dat sql/benchmarks/ATIS/Tests/one.sql.in sql/benchmarks/ATIS/Tests/one.test.in sql/benchmarks/ATIS/Tests/restrict_carrier.dat sql/benchmarks/ATIS/Tests/restrict_class.dat sql/benchmarks/ATIS/Tests/restriction.dat sql/benchmarks/ATIS/Tests/state.dat sql/benchmarks/ATIS/Tests/stop1.dat sql/benchmarks/ATIS/Tests/time_interval.dat sql/benchmarks/ATIS/Tests/time_zone.dat sql/benchmarks/ATIS/Tests/transport.dat Modified Files: sql/benchmarks/ATIS/Tests/All Branch: mtest Log Message:
ATIS benchmark diffs (truncated from 10465 to 300 lines): diff --git a/sql/benchmarks/ATIS/Tests/All b/sql/benchmarks/ATIS/Tests/All --- a/sql/benchmarks/ATIS/Tests/All +++ b/sql/benchmarks/ATIS/Tests/All @@ -1,6 +1,7 @@ -load -select_simple_join -select_join -select_key_prefix_join -select_distinct -select_group +one +#load +#select_simple_join +#select_join +#select_key_prefix_join +#select_distinct +#select_group diff --git a/sql/benchmarks/ATIS/Tests/aircraft.dat b/sql/benchmarks/ATIS/Tests/aircraft.dat new file mode 100644 --- /dev/null +++ b/sql/benchmarks/ATIS/Tests/aircraft.dat @@ -0,0 +1,135 @@ +"ATR" "AEROSPATIALE/AERITALIA (ALL SERIES)" 2 "TURBOPROP" "NO" 80.58 73.83 32446 49 10603 277 0 "YES" +"SSC" "AEROSPATIALE-BRITISH AEROSPACE (BAC) CONCORDE" 4 "JET" "NO" 83.83 203.75 400000 128 25000 1400 3800 "YES" +"CRV" "AEROSPATIALE CARAVELLE (ALL SERIES)" 2 "JET" "NO" 112.5 118.83 127870 140 29100 512 2150 "YES" +"ND2" "AEROSPATIALE N 262/FRAKES MOHAWK 298" 2 "TURBOPROP" "NO" 71.83 63.25 23370 27 5810 240 500 "YES" +"NDH" "AEROSPATIALE SA 365 DAUPHIN 2" 1 "HELICOPTER" "NO" 0 43.5 6615 14 0 196 423 "NO" +"AGH" "AGUSTA A 109 A" 2 "HELICOPTER" "NO" 36.08 35.14 5402 6 0 165 351 "NO" +"AB3" "AIRBUS INDUSTRIE (ALL SERIES)" 2 "JET" "YES" 147.08 175.91 313060 345 68000 576 2100 "YES" +"AN2" "ANTONOV AN22 FREIGHTER" 4 "TURBOPROP" "YES" 211.29 189.62 551156 28 99280 375 3107 "" +"AN4" "ANTONOV AN24" 2 "TURBOPROP" "NO" 95.83 77.25 42997 50 8150 295 807 "NO" +"AN6" "ANTONOV AN26 FREIGHTER" 2 "TURBOPROP" "NO" 95.79 77.2 49297 50 0 280 342 "" +"BEC" "BEECHCRAFT (ALL SERIES)" 2 "TURBOPROP" "NO" 0 0 0 0 0 0 0 "NO" +"BEB" "BEECHCRAFT BARON" 2 "PROPELLER" "NO" 37.83 28 5120 6 1965 225 1085 "NO" +"BEQ" "BEECHCRAFT QUEEN AIR" 2 "PROPELLER" "NO" 50.25 35.5 8800 11 3578 214 1185 "NO" +"BEO" "BEECHCRAFT TWIN BONANZA" 2 "PROPELLER" "NO" 45.95 31.5 6300 5 2230 201 1110 "NO" +"BE8" "BEECHCRAFT 18/VOLPAR TURBO 18" 2 "PROPELLER" "NO" 49.66 35.25 9900 15 4055 256 1515 "NO" +"BE9" "BEECHCRAFT C99 AIRLINER" 2 "TURBOPROP" "NO" 45.66 44.5 10900 15 5123 280 1150 "NO" +"BH2" "BELL (ALL SERIES)" 1 "HELICOPTER" "NO" 33.25 39.08 3200 4 860 140 341 "NO" +"DHP" "BOEING CANADA DHC-2 BEAVER" 1 "PROPELLER" "NO" 48 30.25 5100 10 1800 143 733 "" +"DHB" "BOEING CANADA DHC-2 TURBO BEAVER" 1 "TURBOPROP" "NO" 48 35.25 5370 10 1800 157 750 "NO" +"DHO" "BOEING CANADA DHC-3 OTTER" 1 "PROPELLER" "NO" 58 41.83 8000 10 2100 132 960 "NO" +"DHT" "BOEING CANADA DHC-6 TWIN OTTER" 2 "TURBOPROP" "NO" 65 51.75 12500 20 4420 209 745 "NO" +"DH7" "BOEING CANADA DHC-7 DASH-7 PASSENGER" 4 "TURBOPROP" "NO" 93 80.58 43000 50 15000 275 850 "YES" +"DH8" "BOEING CANADA DHC-8 DASH-8 (ALL SERIES)" 2 "TURBOPROP" "NO" 84 75 0 32 0 300 691 "" +"707" "BOEING 707 PASSENGER (ALL SERIES)" 4 "JET" "NO" 130.83 145.08 258000 181 52000 615 6325 "YES" +"70M" "BOEING 707-320C MIXED CONFIGURATION" 4 "JET" "NO" 145.75 152.91 336000 145 83447 615 5750 "YES" +"727" "BOEING 727 PASSENGER (ALL SERIES)" 3 "JET" "NO" 108 133.16 170000 131 35900 622 3000 "YES" +"72M" "BOEING 727-100C/100QC MIXED CONFIGURATION" 3 "JET" "NO" 108 133.16 160000 96 30500 600 0 "YES" +"72S" "BOEING 727-200 (ALL SERIES)" 3 "JET" "NO" 108 153.16 191000 145 40670 622 2400 "YES" +"737" "BOEING 737 PASSENGER (ALL SERIES)" 2 "JET" "NO" 93 94 111000 138 29093 577 1300 "YES" +"73M" "BOEING 737-200C/200QC MIXED CONFIGURATION" 2 "JET" "NO" 93 100.16 125000 130 33561 573 1800 "YES" +"73S" "BOEING 737 PASSENGER (ALL 200/200C SERIES)" 2 "JET" "NO" 93 100.16 120000 130 34050 577 2300 "YES" +"733" "BOEING 737-300" 2 "JET" "NO" 94.75 105.58 135000 138 35500 550 2500 "YES" +"74M" "BOEING 747 MIXED CONFIGURATION (ALL SERIES)" 4 "JET" "YES" 195.66 231.83 78500 238 165710 600 5500 "YES" +"747" "BOEING 747 PASSENGER (ALL SERIES)" 4 "JET" "YES" 195.66 321.83 833000 452 134000 557 7500 "YES" +"74L" "BOEING 747SP" 4 "JET" "YES" 195.66 184.75 700000 430 98000 564 6730 "YES" +"757" "BOEING 757-200 PASSENGER" 2 "JET" "NO" 124.5 155.25 220000 224 38940 560 2440 "YES" +"767" "BOEING 767 (ALL SERIES)" 2 "JET" "YES" 156.08 159.16 312000 290 69000 550 4500 "YES" +"B11" "BRITISH AEROSPACE (BAC) ONE-ELEVEN (ALL SERIES)" 2 "JET" "NO" 88.5 93.5 78500 79 17600 550 1430 "YES" +"VGP" "BRITISH AEROSPACE (BAC-VICKERS) VANGUARD PASSENGER" 4 "TURBOPROP" "NO" 118 122.87 146500 139 21500 405 2910 "YES" +"VCV" "BRITISH AEROSPACE (BAC-VICKERS) VISCOUNT (ALL SERIES)" 4 "TURBOPROP" "NO" 93.7 85.66 72500 75 14500 352 1725 "YES" +"HPH" "BRITISH AEROSPACE (HANDLEY PAGE) HERALD" 2 "TURBOPROP" "NO" 113 96.83 82000 74 12000 266 3150 "YES" +"HPJ" "BRITISH AEROSPACE (HANDLEY PAGE) JETSTREAM 1/200" 2 "TURBOPROP" "NO" 52 47.08 12550 18 4100 250 1440 "YES" +"DHH" "BRITISH AEROSPACE (HAWKER SIDDELEY) HERON" 4 "PROPELLER" "NO" 71.5 48.5 13500 17 2100 195 0 "NO" +"TRD" "BRITISH AEROSPACE (HAWKER SIDDELEY) TRIDENT (ALL SERIES)" 3 "JET" "NO" 95 114.75 135500 103 24500 606 2700 "YES" +"HS7" "BRITISH AEROSPACE (HAWKER SIDDELEY) 748 PASSENGER" 2 "TURBOPROP" "NO" 98.5 67 46500 56 11363 275 850 "YES" +"J31" "BRITISH AEROSPACE JETSTREAM 31" 2 "TURBOPROP" "NO" 52 47.12 12566 18 0 282 1380 "YES" +"141" "BRITISH AEROSPACE 146-100" 4 "JET" "NO" 86.41 85.83 74600 88 17277 460 1450 "YES" +"142" "BRITISH AEROSPACE 146-200 PASSENGER" 4 "JET" "NO" 86.41 93.66 89500 100 21000 460 1450 "YES" +"BNI" "BRITTEN-NORMAN BN-2A/B ISLANDER/BN-2T TURBINE ISLANDER" 2 "PROPELLER" "NO" 49 35.66 6300 10 2000 260 425 "NO" +"BNT" "BRITTEN-NORMAN BN-2A MK III TRISLANDER" 3 "PROPELLER" "NO" 53 43.75 9350 18 4000 180 0 "NO" +"CS2" "CASA C-212/NUSANTARA NC-212 AVIOCAR" 2 "TURBOPROP" "NO" 62.5 45.83 16427 28 6077 230 1400 "NO" +"CNA" "CESSNA (ALL SERIES)" 1 "TURBOPROP" "NO" 0 0 0 0 0 0 0 "NO" +"CN2" "CESSNA STATIONAIR/TURBO STATIONAIR 6" 1 "PROPELLER" "NO" 35.83 28 3600 7 1792 169 702 "NO" +"CNT" "CESSNA STATIONAIR 207/TURBO STATIONAIR 7/8" 1 "PROPELLER" "NO" 35.83 31.75 3800 7 1729 185 581 "NO" +"CN4" "CESSNA 402/402 UTILILINER" 2 "PROPELLER" "NO" 39.91 36.08 6300 8 2436 239 562 "NO" +"CVR" "CONVAIR (ALL SERIES)" 2 "TURBOPROP" "NO" 105.33 79.16 54600 56 11200 350 1100 "YES" +"CWC" "CURTISS C-46 COMMANDO" 2 "PROPELLER" "NO" 108.08 76.33 40000 60 12000 220 1600 "NO" +"DAM" "DASSAULT-BREGUET MERCURE" 2 "JET" "NO" 100.25 114.25 120150 0 32850 574 1094 "YES" +"DOS" "DORNIER DO 28" 2 "PROPELLER" "NO" 51.02 37.02 8852 15 3000 160 708 "" +"DO8" "DORNIER 228 (ALL SERIES)" 2 "TURBOPROP" "NO" 55.58 49.25 12570 19 6000 231 1065 "NO" +"EMB" "EMBRAER EMP-110 BANDEIRANTE" 2 "TURBOPROP" "NO" 50.16 49.41 12500 19 5000 262 900 "NO" +"EM2" "EMBRAER EMP-120 BRASILIA" 2 "TURBOPROP" "NO" 64.89 64.7 12295 30 0 288 628 "YES" +"FK7" "FAIRCHILD INDUSTRIES FH-227" 2 "TURBOPROP" "NO" 95.16 83.08 43500 52 11500 294 1520 "YES" +"SWM" "FAIRCHILD (SWEARINGEN) METRO/MERLIN" 2 "TURBOPROP" "NO" 46.25 59.33 12500 19 3950 294 2139 "YES" +"F27" "FOKKER F27 FRIENDSHIP/FAIRCHILD (ALL SERIES)" 2 "TURBOPROP" "NO" 95.16 82.16 45000 56 13500 265 1450 "YES" +"F28" "FOKKER F28 FELLOWSHIP (ALL SERIES)" 2 "JET" "NO" 82.25 96.16 73000 85 19623 523 1055 "YES" +"CD2" "GOVERNMENT AIRCRAFT FACTORIES N22B/N24A NOMAD" 2 "TURBOPROP" "NO" 54 43 8500 16 3000 165 850 "NO" +"GRA" "GRUMMAN G-111 ALBATROSS G-111" 2 "AMPHIBIAN" "NO" 96.66 61.25 31000 28 7965 160 1500 "NO" +"GRG" "GRUMMAN G-21 GOOSE" 2 "AMPHIBIAN" "NO" 49 38.33 8000 10 2000 160 825 "NO" +"GRM" "GRUMMAN G-73 MALLARD" 2 "AMPHIBIAN" "NO" 66.66 48.33 12750 10 1950 180 1245 "NO" +"GRS" "GULFSTREAM AEROSPACE (GRUMMAN) GULFSTREAM 1/1-C" 2 "TURBOPROP" "NO" 78.33 63.75 36000 37 4300 345 2300 "YES" +"IL4" "ILYUSHIN IL14" 2 "PROPELLER" "NO" 104 69.91 36380 24 4800 224 1250 "NO" +"IL8" "ILYUSHIN IL18" 4 "TURBOPROP" "NO" 122.7 117.79 119000 125 30860 403 1860 "YES" +"IL6" "ILYUSHIN IL62/62M" 4 "JET" "NO" 141.29 174.16 347224 186 50706 528 5716 "YES" +"ILW" "ILYUSHIN IL86" 4 "JET" "YES" 157.68 197.54 454152 350 0 575 0 "YES" +"LOM" "LOCKHEED L188 ELECTRA MIXED CONFIGURATION" 4 "TURBOPROP" "NO" 99 104.5 116000 0 0 390 2200 "" +"LOE" "LOCKHEED L188 ELECTRA PASSENGER" 4 "TURBOPROP" "NO" 99 104.54 116000 104 22000 405 2750 "YES" +"L10" "LOCKHEED L1011 (ALL SERIES)" 3 "JET" "YES" 155.25 177.58 430000 400 95500 615 3450 "YES" +"L15" "LOCKHEED L1011-500 TRISTAR" 3 "JET" "YES" 155.33 164.2 496000 330 115000 580 5998 "YES" +"MR4" "MARTIN 404" 2 "PROPELLER" "NO" 93.25 74.58 44900 44 9500 255 900 "YES" +"DC3" "MCDONNELL DOUGLAS DC3/C47 DAKOTA PASSENGER" 2 "PROPELLER" "NO" 95 64.5 25200 30 7380 207 1330 "NO" +"DC4" "MCDONNELL DOUGLAS DOUGLAS DC4/C-54 SKYMASTER PASSENGER" 4 "PROPELLER" "NO" 117.5 93.91 73800 80 11440 230 2750 "NO" +"DC6" "MCDONNELL DOUGLAS DC6 (ALL SERIES)" 4 "PROPELLER" "NO" 117.5 101.5 93200 80 12310 309 3070 "YES" +"D8M" "MCDONNELL DOUGLAS DC8 MIXED CONFIGURATION (ALL SEIRES)" 4 "JET" "NO" 142.33 187.41 325000 259 66665 600 3700 "YES" +"DC8" "MCDONNELL DOUGLAS DC8 PASSENGER (ALL 20-50 SERIES)" 4 "JET" "NO" 142.25 150.41 315000 176 34000 544 7010 "YES" +"D8S" "MCDONNELL DOUGLAS DC8 (ALL 60/70 SERIES)" 4 "JET" "NO" 142.25 187.33 325000 259 66665 580 7150 "YES" +"DC9" "MCDONNELL DOUGLAS DC9 (ALL 10 & 20 SERIES)" 2 "JET" "NO" 93.25 104.33 98000 90 20850 593 2200 "YES" +"D95" "MCDONNELL DOUGLAS DC9-50" 2 "JET" "NO" 93.25 133.41 12200 139 32615 593 2550 "YES" +"D10" "MCDONNELL DOUGLAS DC10 (ALL SERIES)" 3 "JET" "YES" 155.25 182.25 455000 380 98490 608 6350 "YES" +"M80" "MCDONNELL DOUGLAS (MD-80 SERIES)" 2 "JET" "NO" 107.83 147.83 140000 172 0 579 3060 "YES" +"MIH" "MIL MI-8" 2 "HELICOPTER" "NO" 50.2 108.85 26455 28 0 140 311 "" +"MU2" "MITSUBISHI MU2/MARQUISE/SOLITARE" 2 "TURBOPROP" "NO" 39.16 39.41 11575 8 0 347 1606 "" +"YS1" "NAMC YS-11" 2 "TURBOPROP" "NO" 105 86.25 51800 60 12550 292 1980 "YES" +"PN6" "PARTENAVIA P.68 VICTOR" 2 "PROPELLER" "NO" 39.37 31.33 4387 7 0 185 1312 "" +"PL6" "PILATUS PC-6 TURBO-PORTER" 1 "TURBOPROP" "NO" 49.66 35.75 4850 0 0 151 644 "" +"PA6" "PIPER AEROSTAR" 2 "TURBOPROP" "NO" 34.16 54.75 5500 6 240 250 1400 "YES" +"PAZ" "PIPER APACHE/AZTEC" 2 "PROPELLER" "NO" 37.33 31.16 5200 6 2151 206 1519 "NO" +"PAC" "PIPER CHEROKEE" 1 "PROPELLER" "NO" 32.83 27.66 3400 7 1544 167 856 "NO" +"PAH" "PIPER NAVAJO/MOHAVE/CHIEFTAIN" 2 "PROPELLER" "NO" 40.5 34.5 7000 8 0 254 1019 "NO" +"PAS" "PIPER SENECA" 2 "PROPELLER" "NO" 38.91 28.5 4570 7 1747 219 1036 "NO" +"PA1" "PIPER T-1020/1040" 2 "TURBOPROP" "NO" 41.08 36.66 9000 9 3800 250 900 "NO" +"ACD" "ROCKWELL COMMANDER (ALL SERIES)" 2 "PROPELLER" "NO" 49.5 35.08 6750 7 2750 205 1220 "YES" +"SF3" "SAAB-FAIRCHILD 340" 2 "TURBOPROP" "NO" 70.33 63.75 25020 34 0 300 920 "YES" +"SA2" "SAUNDERS ST-27" 2 "TURBOPROP" "NO" 71.5 59 13500 23 0 230 0 "NO" +"SHP" "SHORTS SKYLINER" 2 "TURBOPROP" "NO" 64.91 40 12500 19 4600 188 694 "YES" +"SHS" "SHORTS SKYVAN" 2 "TURBOPROP" "NO" 64.91 40.08 12500 19 0 188 694 "" +"SH3" "SHORTS 330 PASSENGER" 2 "TURBOPROP" "NO" 74.66 58 22000 30 7500 218 1137 "NO" +"SH6" "SHORTS 360" 2 "TURBOPROP" "NO" 74.83 70.83 26000 36 7500 244 1151 "NO" +"S58" "SIKORSKY S58T" 1 "HELICOPTER" "NO" 56 47.25 13000 16 0 127 278 "NO" +"S61" "SIKORSKY S61" 2 "HELICOPTER" "NO" 62 72 20500 30 5500 139 282 "NO" +"TU3" "TUPOLEV TU134" 2 "JET" "NO" 95.16 112.71 98100 72 14300 546 1490 "YES" +"TU5" "TUPOLEV TU154" 3 "JET" "NO" 123.2 157.14 198410 164 44090 605 3280 "YES" +"WLH" "WESTLAND 30" 2 "HELICOPTER" "NO" 43.66 52.16 12350 21 0 0 100 "" +"YK4" "YAKOVLEV YAK-40" 3 "JET" "NO" 82.08 66.75 35270 40 5070 342 1240 "YES" +"YK2" "YAKOVLEV YAK-42" 3 "JET" "NO" 112.2 119.35 114640 120 2000 510 621 "YES" +"100" "FOKKER 100" 0 "JET" "" 0 0 0 0 0 0 0 "" +"146" "BRITISH AEROSPACE 146 (ALL SERIES)" 0 "JET" "" 0 0 0 0 0 0 0 "" +"310" "AIRBUS INDUSTRIE A310 (ALL SERIES)" 0 "JET" "" 0 0 0 0 0 0 0 "" +"320" "AIRBUS INDUSTRIE A320 (ALL SERIES)" 0 "JET" "" 0 0 0 0 0 0 0 "" +"734" "BOEING 737-400" 0 "JET" "" 0 0 0 0 0 0 0 "" +"743" "BOEING 737-300 PASSENGER" 0 "JET" "" 0 0 0 0 0 0 0 "" +"744" "BOEING 747-400 PASSENGER" 0 "JET" "" 0 0 0 0 0 0 0 "" +"74E" "BOEING 747-400 MIXED CONFIGURATION" 0 "JET" "" 0 0 0 0 0 0 0 "" +"763" "BOEING 767-300/300ER" 0 "JET" "" 0 0 0 0 0 0 0 "" +"BE1" "BEECHCRAFT 1900" 0 "TURBOPROP" "" 0 0 0 0 0 0 0 "" +"BUS" "BUS" 0 "" "" 0 0 0 0 0 0 0 "" +"CNJ" "CESSNA CITATION" 0 "JET" "" 0 0 0 0 0 0 0 "" +"D3M" "DOUGLAS DC3/C-47 DAKOTA MIXED CONFIGURATION" 0 "PROPELLER" "" 0 0 0 0 0 0 0 "" +"D9S" "MCDONNELL DOUGLAS DC9 (ALL 30/40/50 & 80 SERIES)" 0 "JET" "" 0 0 0 0 0 0 0 "" +"DHM" "BOEING CANADA DHC-7 DASH 7 MIXED CONFIGURATION" 0 "TURBOPROP" "" 0 0 0 0 0 0 0 "" +"LMO" "LIMOSINE" 0 "" "" 0 0 0 0 0 0 0 "" +"M87" "MCDONNELL DOUGLAS MD-87" 0 "JET" "" 0 0 0 0 0 0 0 "" +"NDE" "AEROSPATIALE AS 350 ECUREUIL/AS 355 ECUREUIL 2" 1 "TURBOPROP" "" 0 0 0 0 0 0 0 "" +"PAG" "PIPER (ALL SERIES)" 0 "PROPELLER" "" 0 0 0 0 0 0 0 "" +"S76" "SIKORSKY S76" 1 "TURBOPROP" "" 0 0 0 0 0 0 0 "" diff --git a/sql/benchmarks/ATIS/Tests/airline.dat b/sql/benchmarks/ATIS/Tests/airline.dat new file mode 100644 --- /dev/null +++ b/sql/benchmarks/ATIS/Tests/airline.dat @@ -0,0 +1,314 @@ +"AA" "AMERICAN AIRLINES" "" +"AC" "AIR CANADA" "" +"AD" "EXEC EXPRESS II,INC." "" +"AF" "AIR FRANCE" "" +"AG" "ATLANTIC AIRWAYS LIMITED" "" +"AM" "AEROMEXICO - AEROVIAS DE MEXICO S.A. DE C.V." "" +"AP" "ASPEN AIRWAYS,INC." "" +"AQ" "ALOHA AIRLINES INC." "" +"AR" "AEROLINEAS ARGENTINAS" "" +"AS" "ALASKA AIRLINES" "" +"AT" "ROYAL AIR MAROC" "" +"AV" "AVIANCA" "" +"AY" "FINNAIR" "" +"AZ" "ALITALIA" "" +"BA" "BRITISH AIRWAYS" "" +"BE" "ENTERPRISE AIRLINES,INC." "" +"BF" "MARKAIR,INC." "" +"BK" "CHALKS/PARADISE ISLAND AIRLINES" "" +"BL" "AIR BVI,LTD." "" +"BW" "BWIA INTERNATIONAL" "" +"CA" "CAAC" "" +"CD" "TRANS-PROVINCIAL AIRLINES LTD." "" +"CH" "BEMIDJI AIRLINES" "" +"CI" "CHINA AIRLINES LTD." "" +"CO" "CONTINENTAL AIRLINES" "" +"CP" "CANADIAN AIRLINES INTERNATIONAL LTD." "" +"CS" "AIR TORONTO" "" +"CT" "MIDCONTINENT AIRLINES INC." "" +"CU" "CUBANA AIRLINES" "" +"CX" "CATHAY PACIFIC AIRWAYS LTD." "" +"DD" "COMMAND AIRWAYS,INC." "" +"DE" "PRIME AIR,INC." "" +"DF" "AERO COACH AVIATION INTERNATIONAL,INC." "" +"DL" "DELTA AIR LINES,INC." "" +"DO" "DOMINICANA DE AVIACION" "" +"DQ" "COASTAL AIR TRANSPORT" "" +"DV" "NANTUCKET AIRLINES" "" +"EA" "EASTERN AIR LINES,INC." "" +"ED" "CCAIR INC." "" +"EI" "AER LINGUS P.L.C." "" +"EJ" "NEW ENGLAND AIRLINES,INC." "" +"EM" "EMPIRE AIRWAYS" "" +"EU" "EMPRESA ECUATORIANA DE AVIACION" "" +"EV" "ATLANTIC SOUTHEAST AIRLINES,INC." "" +"FC" "CHAPARRAL AIRLINES,INC." "" +"FH" "MALL AIRWAYS INC." "" +"FI" "ICELANDAIR" "" +"FK" "FLAMENCO AIRWAYS,INC." "" +"FN" "SFO HEICOPTER AIRLINES,INC." "" +"FQ" "AIR ARUBA" "" +"FX" "EXPRESS AIR,INC." "" +"FY" "METROFLIGHT AIRLINES" "" +"GA" "GARUDA INDONESIAN AIRWAYS" "" +"GM" "AIR AMERICA" "" +"GQ" "BIG SKY AIRLINES" "" +"GS" "BAS AIRLINES" "" +"GU" "AVIATECA S.A." "" +"HA" "HAWAIIAN AIR LINES" "" +"HD" "NEW YORK HELICOPTER CORPORATION" "" +"HE" "KEYSTONE AIR SERVICE LTD." "" +"HG" "HARBOR AIRLINES,INC" "" +"HI" "GRAND CANYON HELICOPTERS" "" +"HP" "AMERICA WEST AIRLINES,INC." "" +"HQ" "BUSINESS EXPRESS" "" +"HY" "METRO AIRLINES" "" +"IB" "IBERIA" "" +"IF" "INTERFUG" "" +"IH" "CHANNEL FLYING,INC." "SERVICE TEMPORARILY SUSPENDED" +"IN" "EAST HAMPTON AIRE" "" +"IU" "HELITRANS AIR SERVICE,INC." "" +"JB" "HELIJET AIRWAYS" "" +"JC" "ROCKY MOUNTAIN AIRWAYS" "" +"JF" "L.A.B. FYING SERVICE,INC." "CARRIER PERFORMS SEASONAL SERVICE ONLY" +"JI" "JET EXPRESS" "" +"JL" "JAPAN AIRLINES" "" +"JM" "AIR JAMAICA LIMITED" "" +"JO" "HOLIDAY AIRLINES,INC." "" +"JQ" "TRANS-JAMAICAN AIRLINES LTD." "" +"JR" "AERO CALIFORNIA" "" +"JT" "IOWA AIRWAYS,INC." "" +"JU" "YUGOSLAV AIRLINES (JAT)" "" +"JV" "BEARSKIN LAKE AIR SERVICE LIMITED" "" +"KE" "KOREAN AIR" "" +"KI" "TIME AIR LTD." "" +"KL" "KLM-ROYAL DUTCH AIRLINES" "" +"KS" "PENINSULA AIRWAYS,INC." "" +"KW" "CARNIVAL AIR LINES" "" +"KX" "CAYMAN AIRWAYS,LTD." "" +"LA" "LAN CHILE S.A." "" +"LH" "LUFTHANSA GERMAN AIRLINES" "" +"LI" "LIAT (1974) LTD." "" +"LM" "ALM-ANTILLEAN AIRLINES" "" +"LR" "LACSA" "" +"LS" "ILIAMNA AIR TAXI,INC." "" +"LV" "LAV-LINEA AEROPOSTAL VENEZOLANA" "" +"LW" "AIR NEVADA" "" +"LY" "EL AL ISRAEL AIRLINES" "" +"MG" "MGM GRAND AIR,INC." "" +"MH" "MALAYSIAN AIRLINE SYSTEM" "" +"ML" "MIDWAY AIRLINES,INC." "" +"MO" "CALM AIR INTERNATIONAL LTD." "" +"MQ" "SIMMONS AIRLINES" "" +"MX" "MEXICANA DE AVIACION" "" +"NA" "EXECUTIVE AIR CHARTER" "" +"ND" "INTAIR" "" +"NN" "C.A.A.A.-AIR MARTINIQUE" "" +"NQ" "CUMBERLAND AIRLINES" "" +"NR" "NORONTAIR" "" +"NV" "NORTHWEST TERRITORIAL AIRWAYS,LTD." "" +"NW" "NORTHWEST AIRLINES,INC." "" +"OA" "OLYMPIC AIRWAYS" "" +"OB" "TEMPUS AIR LTD." "CARRIER PERFORMS SEASONAL SERVICE ONLY" +"OE" "WESTAIR AIRLINES" "" +"OG" "AIR GUADELOUPE" "" +"OH" "COMAIR,INC." "NATL AIR TRANSPORTATION ASSOC,INC." +"OJ" "AIR ST.-BARTHELEMY" "" +"OK" "CZECHOSLOVAK AIRLINES" "" +"OO" "SKY WEST AIRLINES" "" +"OQ" "AEROLIBERTAD S.A. DE C.V." "" +"OT" "EVERGREEN ALASKA" "" +"OU" "CITY EXPRESS" "" +"OY" "SUNAIRE" "" +"PA" "PAN AMERICAN WORLD AIRWAYS,INC." "" +"PD" "PEM AIR LIMITED" "" +"PK" "PAKISTAN INTERNATIONAL AIRLINES" "" +"PN" "COASTAL AIRWAYS" "" +"PQ" "HOLIDAY AIRWAYS" "SERVICE TEMPORARILY SUSPENDED" +"PR" "PHILIPPINE AIRLINES,INC." "" +"PS" "CENTRAL STATES AIRLINES,INC." "" +"PT" "PBA-PROVINCETOWN-BOSTON AIRLINE,INC." "" +"PV" "PANORAMA AIR" "" +"PY" "SURINAM AIRWAYS LTD." "" +"QA" "AERO CARIBE" "" +"QB" "INTER-QUEBEC" "" +"QD" "GRAND AIRWAYS,INC." "" +"QF" "QANTAS AIRWAYS LTD." "" +"QO" "BAR HARBOR AIRLINES" "" +"QQ" "DRUMMOND ISLAND AIR" "CARRIER PERFORMS SEASONAL SERVICE ONLY" _______________________________________________ checkin-list mailing list checkin-list@monetdb.org https://www.monetdb.org/mailman/listinfo/checkin-list