Development of content management system for traffic survey reports

Abstract

Transportation has become one of the key development factors in Sri Lanka recently. More studies and research have been initiated relating to the transportation infrastructure development. The one of the essential parameter for these studies and research is the availability of traffic related information Since traffic data is vital for any type of study or research in transportation, the traffic survey reports files should be stored efficiently in a suitable repository from for interested party to view or use them. There are different types of surveys conducted to gather traffic related information. Efficient mechanism to store collected data and an easy access to past data is a growing requirement. Currently there are no proper ways of keeping all surveys results that have been conducted. This paper discusses the development of a content management system to handle traffic related information. A development of Content Management System for managing all common types of traffic and transport surveys is discussed. A separate file server is configured to store digital copies of survey results while end user software is connected with server and give all information about surveys. The Users can download relevant data from the server. java technology was used in developing the software and relational database management concept was used to develop the data model. The database schema is developed by identifying the basic information/data regarding to be stored from any survey type (O-D, MCC etc.) by applying the concept of relational database and EER modelling. The software development has gone through the basic steps defined in waterfall method. The final system is user friendly and safe since all the information is gathered to one central server database. Using this central server any type of survey reports can be retrieved with details. The administrator who is responsible for the system can grant the privileges to other low level users to do their tasks separately. Both functional and non functional requirements have been considered in the development of this database. As functional requirement the main processes for the system have been considered. For non functional requirement the quality of the system; security, reliability, performance, resources etc. have been considered based on the software and hardware components.