Design And Implementation Of Database For Warehouse Management System

This article, with Tianjin TEDA General Bonded Warehouse Company in the background, according to the working process, combined with managerial information system development's concept, structure and basic principle and method, designs and develops a set of storing management information system.The storing management system database should be designed to satisfy users'present needs with high performance and good expansibility to meet the needs of enterprises'development in future. This article analyzes the present database designation technique, and points out the limitation of traditional way. During the designation of database, based on relation data model's normal form standard design theory, taking use of object-oriented technique and unified modeling language it designs system database. From object mapping and relation mapping, in the light of UML object's different relevance models, it discusses the project mapping from object to relation data model, and designs according to needs of enterprises by all kinds of mapping project. This article also analyzes the naming method of database modeling, establishes a naming principle easy to understand, maintain and expand. The designation takes future database operating into consideration, takes rationally anti-standard, table space division, index, storage process and trigger to upgrade database's performance.The popular relation database Oracle is adopted in realizing system database. This article introduces the optimized details in ORACLE 9i application, gives full play to Oracle through optimizing, and upgrades storage management system's performance.