The application of Sybase in aviation field

Passengers who fly often have their own preferences, for example, long-distance flight like window seat, short flight like aisle seat, want to sit in the front of the plane or back, like what kind of drink food, like to read what kind of newspapers and magazines, listen to what kind of music ... If the airline can unknowingly meet all the requirements of passengers, passengers will certainly feel at home. So how do airlines offer personalized service to travelers with different hobbies and attract those "flying flyers to become loyal travellers to airlines?" Hu Senge, deputy director of the Southern Airlines Computing Center, said that the "Frequent flyer program" is the best way to achieve this goal, and the key to the successful implementation of the regular passenger program is the construction of the database system. According to Mr. Hu, a study of the composition of travellers found that a small number of business travellers often take a flight, in the airline's entire passenger transport revenue, always occupy a higher proportion of income, this part of the passengers are called frequent passengers. Frequent passenger plans, that is, passengers join the airline's frequent travellers club, the airline by understanding the preferences of members to meet their needs, and by accumulating a certain number of miles, the airlines provide a dead or ascending class rewards. Because of the need to track and process the large number of passengers check-in, the frequent passenger system needs a strong database system as the backing. To construct the frequent passenger system, we should first determine its platform, including application development platform, database platform, system platform and network platform. In the construction of the frequent passenger system, the Southern Airlines first consider the frequent passenger system data processing capacity is large, is expected to deal with the number of members 500,000 per year, the opportunity to 5 million passengers, so the database has excellent performance; and the system requires the support of users and booking system online access, The system requires high reliability and a faster response. In order to obtain the information of the members, frequent passenger system data sources are more complex, need to connect the departure system, telegraph system, branch office Data acquisition system, which requires the database to support a variety of data sources, based on open technology, application development platform and network protocol. Considering the actual situation in China, Southern Airlines ' frequent passenger systems are all self-developed. The Sybase database on UNIX platform is a mature relational database product, it has good stability, Visual database management interface and high performance price ratio for real-time database, so it is selected by Southern Airlines. Using PowerBuilder 6.0 as a front-end development tool for the database, the development of the entire frequent passenger system took only 3 months. For PowerBuilder 6.0, the development manager in charge of the project said: "PowerBuilder has a good development interface, easy to master; its unique DW control, flexible operation using a variety of databases to speed up the development of the interface for more and more complex systems, this is very important. The

As for the large airports such as Beijing, Guangzhou and Shanghai, the departure system is already quite perfect, so the frequent passenger system can read the flight records directly from the departure system, and how can the frequent passenger system obtain information for the small airport without the departure system? Southern Airlines for each member has issued a printed bar code of the instant stickers, members on the flight as long as they affixed to the air tickets, Southern Airlines can be in the financial settlement, through the scanning bar code to obtain passenger information. If you forget to bring the bar code, members can also be in the airport through the Southern Airlines set up a query machine to print barcode.

South Airlines frequent passenger system in early 1998 feasibility study, and in March 1998 through the company project, after more than half a year of demand analysis, system design, System platform selection, module design, programming, testing, installation training, on November 1, 1998 into operation, issued the first South Airlines Pearl Club membership card , while ICBC Peony South Airlines Joint card also issued. At present, frequent passenger system, the system absorbs more than 90,000 members, get the opportunity to record 20余万条, more than the desired effect.

The data accumulated in the frequent passenger system not only provides the high quality service for the frequent passengers, but also the data accumulated in the Southern Airlines ' market operation decision-making. For example, Southern Airlines found that flights from Guangzhou to Beijing were very busy on the Guangzhou-Beijing-Guangzhou route, while passengers returning to Guangzhou from Beijing were often attracted by other airlines, resulting in a decrease in Southern airlines ' passengers. Master This situation, Southern Airlines in time to the frequent Flyer mileage incentive strategy adjustment, from Beijing to fly to Guangzhou visitors can get 150% mileage accumulation. In this way, a large number of passengers were again attracted, from Beijing to Guangzhou flights back to a busy scene.