智能公交乘客信息服务数据库设计

Database Design for Intelligent Transit Passenger Service System

本文从车载、站台以及控制中心三方面分析了智能公交乘客信息服务系统,重点介绍了站台触摸屏公交查询系统中数据库的设计.查询系统数据库以ACCESS进行描述,创建了公交信息的存储结构,以ADO.NET与数据库进行连接访问,实现了对公交站点线路的查询.以VB.NET编程实现了起始站点名称选择和点击地图两种方式的公交站点查询、线路查询以及具有最少换乘次数的出行路径查询.

This paper analyzes the intelligent transit passenger service system from onboard unit, platform service and control center, and introduces the database design for platform touch-screen query system. With Access, the data storage structure of transit network is set up. ADO.NET connects and visits the Database to complete the query of routes and stops, and by VB.NET programming, the system achieves the query of stops, routes and travel path with the least times by two ways of map coordinates or origindestination selection.