[1]郭建华,黄卫,孙晓莉,等.高速公路工程进度管理系统数据库设计[J].东南大学学报(自然科学版),2001,31(2):94-99.[doi:10.3969/j.issn.1001-0505.2001.02.023]
 Guo Jianhua,Huang Wei,Sun Xiaoli,et al.Database Design of Expressway Progress Management Systems[J].Journal of Southeast University (Natural Science Edition),2001,31(2):94-99.[doi:10.3969/j.issn.1001-0505.2001.02.023]
点击复制

高速公路工程进度管理系统数据库设计()
分享到:

《东南大学学报(自然科学版)》[ISSN:1001-0505/CN:32-1178/N]

卷:
31
期数:
2001年第2期
页码:
94-99
栏目:
交通运输工程
出版日期:
2001-03-20

文章信息/Info

Title:
Database Design of Expressway Progress Management Systems
作者:
郭建华 黄卫 孙晓莉 刘新旺
东南大学交通学院, 南京 210096
Author(s):
Guo Jianhua Huang Wei Sun Xiaoli Liu Xinwang
College of Traffic and Transportation Engineering, Southeast University, Nanjing 210096)
关键词:
数据库 进度管理 实体 高速公路
Keywords:
database progress management entity expressway
分类号:
U495
DOI:
10.3969/j.issn.1001-0505.2001.02.023
摘要:
利用数据库设计的基本理论,以省市两级管理体制为模板,从组织机构和数据流程2个方面分析高速公路工程进度管理的实际需求,指出进度管理系统中的主要实体,包括:高速公路、城市、标段、路基路面工程、桥梁工程、分部工程、分项工程.详细分析实体之间的关系,得到它们之间的实体-关系图,并据此设计进度管理系统数据库结构.设计成果已在江苏省的高速公路建设中得到实际应用.
Abstract:
Based on the database design theory, the practical demand of expressway construction progress management is analyzed using the province-city two level management structure as the template. Main entities involved in progress management are clearly picked out, including expressway, city, bid section, sub-base and pavement, bridge, subsection, subentry. The relations between them are discussed in detail, and the E-R diagrams are achieved. Based on the analysis, the database design of progress management system is given. And the practice of database design result in Jiangsu province is given as an example.

参考文献/References:

[1] 全国监理工程师培训教材编写委员会编.工程建设进度控制.北京:中国建筑工业出版社,1997.1~15
[2] 谢光渤编译.工程项目经营管理.北京:冶金工业出版社,1985.99~112
[3] 佐用泰司著.工程管理.北京:电力出版社,1982.146~165
[4] 王能斌.数据库系统.北京:电子工业出版社,1998.230~254
[5] 薛华成主编.管理信息系统.第2版.北京:清华大学出版社,1993.98~114

相似文献/References:

[1]王振新,王能斌.分布式数据库中关系运算结果大小的估计[J].东南大学学报(自然科学版),1988,18(4):43.[doi:10.3969/j.issn.1001-0505.1988.04.006]
 Wang Zhenxin Wang Nengbin(Department of Computer Science and Engineering).Size Estimation of the Relations Resulting from Relational Operations in a Distributed Data Base System[J].Journal of Southeast University (Natural Science Edition),1988,18(2):43.[doi:10.3969/j.issn.1001-0505.1988.04.006]
[2]凡开文,姚龙海,黄恩生.支持分布式数据库的局域网——NGNET[J].东南大学学报(自然科学版),1988,18(4):52.[doi:10.3969/j.issn.1001-0505.1988.04.007]
 Fan Kaiwen Yao Longhai Huang Ensheng(Department of Computer Science and Engincering).A LAN for Supporting Distributed Database System——NGNET[J].Journal of Southeast University (Natural Science Edition),1988,18(2):52.[doi:10.3969/j.issn.1001-0505.1988.04.007]
[3]朱静华,周佩德,左惟,等.《红楼梦》数据库系统的开发[J].东南大学学报(自然科学版),1987,17(4):85.[doi:10.3969/j.issn.1001-0505.1987.04.010]
 Zhu Jinghua Zhou Peide Zuo Wei Li Keyi Jia Jiawei(Department of Computer Science and Engineering).The Development of the Database System about 《Red Chamber Dream》[J].Journal of Southeast University (Natural Science Edition),1987,17(2):85.[doi:10.3969/j.issn.1001-0505.1987.04.010]
[4]王能斌,程祺.一个微机关系数据库管理系统的恢复子系统的设计与实现[J].东南大学学报(自然科学版),1987,17(4):95.[doi:10.3969/j.issn.1001-0505.1987.04.011]
 Wang Nengbin,Cheng Qi(Department of Computer Science and Enginecring).Design and Implementation of the Recovery Subsystem of a Micro-DBMS[J].Journal of Southeast University (Natural Science Edition),1987,17(2):95.[doi:10.3969/j.issn.1001-0505.1987.04.011]
[5]王平,王能斌.QUEL语言到Micro SQL语言的翻译器的实现[J].东南大学学报(自然科学版),1987,17(6):78.[doi:10.3969/j.issn.1001-0505.1987.06.009]
 Wang Ping Wang Nengbing (Department of Computer Science and Engineering).Implementaton of a Translator from QUEL into Micro SQL[J].Journal of Southeast University (Natural Science Edition),1987,17(2):78.[doi:10.3969/j.issn.1001-0505.1987.06.009]
[6]王能斌,冷嘉玲.NITDB存取方法层的设计与实现[J].东南大学学报(自然科学版),1986,16(5):37.[doi:10.3969/j.issn.1001-0505.1986.05.005]
 Wang Nengbin,Leng Jialing.The Design and Implementation of the Access Method Layer of NITDB[J].Journal of Southeast University (Natural Science Edition),1986,16(2):37.[doi:10.3969/j.issn.1001-0505.1986.05.005]
[7]吉祖勤,黄卫,石子石.高速公路养护管理系统数据库的设计[J].东南大学学报(自然科学版),2001,31(3):73.[doi:10.3969/j.issn.1001-0505.2001.03.018]
 Ji Zuqin,Huang Wei,Shi Zishi.Database Design of Expressway Maintenance Management System[J].Journal of Southeast University (Natural Science Edition),2001,31(2):73.[doi:10.3969/j.issn.1001-0505.2001.03.018]
[8]袁军,陈栋,王能斌.演绎数据库的语义查询优化[J].东南大学学报(自然科学版),1995,25(1):57.[doi:10.3969/j.issn.1001-0505.1995.01.011]
 Yuan Jun,Chen,Dong,et al.Semantic Query Optimization in Deductive Database[J].Journal of Southeast University (Natural Science Edition),1995,25(2):57.[doi:10.3969/j.issn.1001-0505.1995.01.011]
[9]夏井新,黄卫.高速公路工程建设管理一体化系统研究[J].东南大学学报(自然科学版),2001,31(3):65.[doi:10.3969/j.issn.1001-0505.2001.03.016]
 Xia Jingxin,Huang Wei.Research on Expressway Project Construction Management System[J].Journal of Southeast University (Natural Science Edition),2001,31(2):65.[doi:10.3969/j.issn.1001-0505.2001.03.016]

备注/Memo

备注/Memo:
作者简介:郭建华,男,1976年生,博士研究生.
更新日期/Last Update: 2001-03-20