Open Access Open Access  Restricted Access Subscription Access

Using SQL for managing Traffic Incident data

Claudia Marlene Prerana

Abstract


As the research subject, SQL performance and procedures are examined, with a focus on how it applies to managing data regarding traffic incidents in California’s 7 major areas. In

fact, when designing a relational database, SQL makes it easier to sort data on traffic incident cases, the vehicles involved, weather conditions and responses made. This framework

permits querying; thus it is possible to assess the traffic density, time, severity of the incident, and response.


Full Text:

PDF

References


Hasan, S. R. (2024). Advance Real-Time Detection of Traffic Incidents in Highways using Vehicle Trajectory Data.

Li, L. Z. (2021). Data-Driven Predictive Analysis for Traffic Incidents in California.

Pablo Marcillo, Á. V.-Á. (2022). A Systematic Literature Review of Learning-Based Traffic Accident Prediction Models.

Thompson, H. C. (2023). SQL-Based Traffic Data Management for Real-Time Incident Detection.

White, R. J. (2022). Traffic Data Analysis for Real-Time Incident Management: A California Case Study.


Refbacks

  • There are currently no refbacks.