航空货运系统数据库的存储优化设计

Airlines Cargo System Database Storage Optimizing Design

开源数据库MySQL越来越广泛地应用于航空公司的信息系统,在深入分析航空货运系统数据特点的基础上,提出了联合使用内存和磁盘存储引擎的方法,用InnoDB存储业务数据,用Memory存储基础数据,大大提高了表连接操作的性能。针对内存表的永久保存问题,用写回相关磁盘表的方法加以解决。

Open source database MySQL is more and more widely used in airlines information system. Based on deeply analyzing the characteristic of airlines cargo system,the paper provides a method of combining memory type engine with disk type engine. That is using InnoDB to store business operation data and using memory storage engine to store fundamental data. It greatly improves the performance of table join operation. As to the problem of memory cann＇ t store data permanently, write back corresponding disk tables is used to solve it.