ROAD TRAFFIC FLOW CHARACTERIZATION USING RELATIONAL DATABASES

Hristoski, Ilija and Malenkovska Todorova, Marija (2016) ROAD TRAFFIC FLOW CHARACTERIZATION USING RELATIONAL DATABASES. Horizons. ISSN 1857-9892

Full text not available from this repository.

Abstract

Characterizing road traffic flows at particular road sections is not only an integral but also a fundamental part of the preparation process of any traffic flow study. In this particular case, this means an exact specification of a set of traffic flow variables, including average flow rate, average headway, time mean speed, space mean speed, as well as traffic density, all being computed by travelling directions and by specific time intervals, whose optimal number and duration are a priori not known. In addition, this activity also includes obtaining the distribution of vehicles’ relative frequencies vis-à-vis their corresponding categories. Within this paper, we propose a methodology for a complete characterization of road traffic flows at a particular road section of a rural two-lane highway during the observation time, based strictly on the usage of relational databases and SQL scripts. Specifically, we propose a framework for post-processing of raw traffic data, built on the development of a corresponding Entity-Relational (E-R) diagram, its translation into a relational schema, as well as a physical implementation of a relational database in Microsoft SQL Server. We also develop specific SQL scripts necessary to obtain automatically the entire gamut of traffic flow variables from database table records.

Item Type: Article
Subjects: Scientific Fields (Frascati) > Engineering and Technology > Civil engineering
Divisions: Faculty of Technical Sciences
Depositing User: Unnamed user with email vladimir.milevski@uklo.edu.mk
Date Deposited: 19 Dec 2016 12:03
Last Modified: 20 Dec 2016 11:48
URI: http://eprints.uklo.edu.mk/id/eprint/467

Actions (login required)

View Item View Item