大型石化企业管道管理系统的设计和实现

Design and Execution of Piping Administration System Used in Petrochemical Enterprises

应用关系型数据库规范化理论设计了石化企业管道管理系统的数据库结构 ,采用MssSQLServer6.5数据库系统的库结构 ,用PowerBuilder6.0语言编制数据库管理系统和用户界面 ,并应用大量的SQL结构化查询语言作为数据库的处理工具。采用了客户机/服务器模式建立企业局域网络系统。系统采用了菜单系统和以生产流程图为界面的图形界面两种界面查询方式 ,在图形界面上 ,用户能对形象的图形进行操作 ,易于定位 ,使用方便。

By using relational database theory, the database for administrating the piping system in the petrochemical enterprises was designed. MSS SQL Server 6.5 was used to create the structure of the database and PowerBuilder 6.0 was used to build the database administration system and user interface. At the same times, SQL structural retrieval language was used as the tools to operate the database. The client/server model was utilized in building the enterprise local network. In the system, the drawing interface and the menu system were supplied to carry out the data retrieval. The user can operate the system through the drawing. It is easy to obtain the data that is needed.