The design & optimization of database in locomotive overhaul servicing management system
Yang Tuan-ming · Machinery Design and Manufacture · 2010
According to the actual needs of locomotive Overhaul work,in accordance with the Opti-mization principle of database,It optimization of database from distracting memory,optimizing disk I/O and configuring performance of operating system in several aspects,SQL Language is optimized by Oracle opti-mizer and Personnel Information,locomotive work station dictionary series of table and database view are established,finally Database Store Procedure and database trigger are design.This locomotive overhaul servicing management system is running well in several Railway Administrations,meet the information management optimization design requirements.