[Home ] [Archive]   [ فارسی ]  
:: Main :: About :: Current Issue :: Archive :: Search :: Submit :: Contact ::
Main Menu
Home::
Journal Information::
Articles archive::
For Authors::
For Reviewers::
Registration::
Contact us::
Site Facilities::
::
Search in website

Advanced Search
..
Receive site information
Enter your Email in the following box to receive the site news and information.
..
:: Volume 5, Issue 11 (5-2026) ::
3 2026, 5(11): 9-24 Back to browse issues page
Design and Implementation of a Data Warehouse for Analyzing and Optimizing Urban Traffic Flow Using OLAP Techniques
Adnan Keshvari , Sahar Keshvari , Hosein Moeinzad
Abstract:   (2 Views)
With the growing complexity of traffic-related challenges in major metropolitan areas, traditional and reactive traffic management approaches have increasingly lost their effectiveness. This paper presents a data-warehouse-driven analytical framework, supported by OLAP techniques, for proactive urban traffic management. The study introduces the fundamental concepts and architecture of data warehouses, identifies heterogeneous traffic-related data sources, and proposes a star-schema conceptual model integrating traffic, spatial, and meteorological data. An ETL process is then designed and implemented to extract, transform, and load data into the data warehouse. Prototype implementation and multidimensional analyses conducted on sample datasets demonstrate the system’s capability to uncover traffic patterns and evaluate the influence of various variables on traffic flow. This framework enables municipalities to make data-driven and effective decisions to optimize urban road networks through interactive management dashboards.
 
Article number: 2
Keywords: Data Warehouse, OLAP, Intelligent Traffic Management, Transportation Systems, Star Schema, Multidimensional Analysis, Smart City.
Full-Text [PDF 467 kb]   (3 Downloads)    
Type of Study: Applicable | Subject: Special
Received: 2026/02/26 | Accepted: 2026/10/3 | Published: 2026/10/3
References
1. Li, Y., Yu, R., Shah, C., & Liu, Y. (2018). Diffusion Convolutional Recurrent Neural Network: Data-Driven Traffic Forecasting. In International Conference on Learning Representations (ICLR).
2. Wei, H., Zheng, G., Yao, H., & Li, Z. (2019). PressLight: Learning Max Pressure Control to Coordinate Traffic Signals. In Proceedings of the 25th ACM SIGKDD International Conference on Knowledge Discovery & Data Mining.
3. Wang, W., Jiang, W., & Luo, D. (2019). Mining Social Media Data for Traffic Event Detection. Journal of Transportation Technologies, 9(3), 237-251.
4. Mahmassani, H. S. (2016). Traffic Flow Theory: A State-of-the-Art Review. Transportation Science, 50(3), 100–121.
5. Zheng, Z., & Van Zuylen, H. (2019). Urban Traffic Flow Prediction Based on Data Warehouse and Neural Network Integration. International Journal of Transportation Science and Technology.
6. Chen, C., et al. (2017). Freeway Performance Measurement System (PeMS): An Integrated Real-Time and Historical Traffic Data Warehouse. Transportation Research Part C.
7. Golubchik, L., et al. (2013). Data Cube: A Relational Aggregation Operator Generalization for Traffic Analytics. IEEE Transactions on Knowledge and Data Engineering.
Send email to the article author

Add your comments about this article
Your username or Email:

CAPTCHA


XML   Persian Abstract   Print


Download citation:
BibTeX | RIS | EndNote | Medlars | ProCite | Reference Manager | RefWorks
Send citation to:

keshvari A, keshvari S, moeinzad H. Design and Implementation of a Data Warehouse for Analyzing and Optimizing Urban Traffic Flow Using OLAP Techniques. 3 2026; 5 (11) : 2
URL: http://jiis.iauh.ac.ir/article-1-67-en.html


Rights and permissions
Creative Commons License This work is licensed under a Creative Commons Attribution-NonCommercial 4.0 International License.
Volume 5, Issue 11 (5-2026) Back to browse issues page
فصلنامه سیستم های اطلاعاتی هوشمند Intelligent Information Systems Journal
Persian site map - English site map - Created in 0.16 seconds with 37 queries by YEKTAWEB 4774