数据库技术在润滑油管理系统中的应用

The Application of Database to Lubricant Oil Management System

以宝钢润滑油仓储及使用过程中出现的数据为对象,经过需求分析,建立了基于数据分析的数据库系统。同时对大量数据进行汇总分析,得到了企业生产发展的有利信息。经过对比分析,后台数据库选择了关系型数据库管理系统SQL Server,前端开发语言选择了可视化编程语言Delphi。本系统实现了数据输入、修改、删除、数据查询、统计报表生成等多方面的使用功能,并能对数据库中的数据进行分析,对数据进行多方面的汇总比较,从而得出有用的信息。

Taking the data which appears in the storage and using process of Baosteel lubricant oil as an object, after analyzing the requirement, the database system for data analyzing was built up. By analyzing on a great deal of data, the advantageous information for the production development of business enterprise was obtained. After comparing and analyzing the system, the relationship database management system SQL Server was chosen as the database management system and the visible program language Delphi was chosen as DBMS exploiture tool. This system carries out the function of data addition, data modification, data deleting, data query and statistics, and the useful information can be gotten through data analyzing and comparing in the database.