This article using the E-R model and 3NF (third model Form) and so on the database standardized design methods, synthesizing railway transportation department's application request, through to constructs on passenger train plan decision support system in the railway to carry on the database demand analysis. In the conceptual design stage concept pattern forms independent in the SQL Server. In the logical design stage the E-R chart is transformed to the concrete database model support by SQL the Server (i.e. relational model) and essential view is established to forms the database the outline template type in the basic model foundation; In physics design stage, according to the SQL Server characteristic and the processing need, carries on the physical memory arrangement, establishes the index and so on, the backstage database is obtained which corresponds with the system onstage application procedure. This design method once applied to the design and development of the passenger train plan decision support system based on the railway bureau network, and has obtained the good effect.


    Access

    Check access

    Check availability in my library

    Order at Subito €


    Export, share and cite



    Title :

    Database Design of Railway Passenger Train Plan Decision Support System


    Contributors:
    Zha, Weixiong (author) / Liu, Huilin (author) / Tao, Siyu (author)

    Conference:

    First International Conference on Transportation Engineering ; 2007 ; Southwest Jiaotong University, Chengdu, China



    Publication date :

    2007-07-09




    Type of media :

    Conference paper


    Type of material :

    Electronic Resource


    Language :

    English




    Database Design of Railway Passenger Train Plan Decision Support System

    Zha, W. / Liu, H. / Tao, S. et al. | British Library Conference Proceedings | 2007


    Train Combination Model of a Passenger Train Plan for a High-Speed Railway

    Yang, Rui / Chen, Weidong / Wen, Hao | ASCE | 2015


    RAILWAY TRAIN PASSENGER NUMBER ESTIMATING DEVICE AND RAILWAY TRAIN PASSENGER NUMBER ESTIMATING METHOD

    SAKAIRI HITOSHI / SHIODA YUU / ITO KAZUYOSHI | European Patent Office | 2017

    Free access

    Passenger Train Plan Optimal System for Dedicated Passenger Traffic Line

    Deng, Lian-bo / Shi, Feng / Qin, Jin | ASCE | 2011


    Railway Train Working Diagram Plan System

    Ni, Shaoquan / Lyu, Miaomiao / Lv, Hongxia | Springer Verlag | 2017