Using SQL for Managing Traffic Incident Data
Fuente:
Zenodo
Enregistré dans:
| Auteur principal: | |
|---|---|
| Format: | Recurso digital |
| Langue: | anglais |
| Publié: |
Zenodo
2025
|
| Sujets: | |
| Accès en ligne: | |
| Tags: |
Ajouter un tag
Pas de tags, Soyez le premier à ajouter un tag!
|
| _version_ | 1866901579058118656 |
|---|---|
| author | Claudia Marlene Prerana |
| author_facet | Claudia Marlene Prerana |
| contents | <p><em><span>As the research subject, SQL<span> </span>performance and procedures are examined, with a focus on how<span> </span>it<span> </span>applies<span> </span>to<span> </span>managing<span> </span>data<span> </span>regarding traffic<span> </span>incidents<span> </span>in<span> </span>California’s<span> </span>7<span> </span>major<span> </span>areas.<span> </span>Infact,<span> </span>when<span> </span>designing<span> </span>a<span> </span>relational<span> </span>database,<span> </span>SQL<span> </span>makes<span> </span>it<span> </span>easier<span> </span>to<span> </span>sort<span> </span>data<span> </span>on<span> </span>traffic<span> </span>incident cases, the vehicles involved, weather conditions and responses made. This framework permits<span> </span>querying;<span> </span>thus<span> </span>it<span> </span>is<span> </span>possible<span> </span>to<span> </span>assess<span> </span>the<span> </span>traffic density,<span> </span>time,<span> </span>severity<span> </span>of<span> </span>the incident, and response.</span></em></p> |
| format | Recurso digital |
| id | zenodo_https___doi_org_10_5281_zenodo_14885819 |
| institution | Zenodo |
| language | eng |
| publishDate | 2025 |
| publisher | Zenodo |
| record_format | zenodo |
| spellingShingle | Using SQL for Managing Traffic Incident Data Claudia Marlene Prerana Managing data, traffic incident cases, traffic density <p><em><span>As the research subject, SQL<span> </span>performance and procedures are examined, with a focus on how<span> </span>it<span> </span>applies<span> </span>to<span> </span>managing<span> </span>data<span> </span>regarding traffic<span> </span>incidents<span> </span>in<span> </span>California’s<span> </span>7<span> </span>major<span> </span>areas.<span> </span>Infact,<span> </span>when<span> </span>designing<span> </span>a<span> </span>relational<span> </span>database,<span> </span>SQL<span> </span>makes<span> </span>it<span> </span>easier<span> </span>to<span> </span>sort<span> </span>data<span> </span>on<span> </span>traffic<span> </span>incident cases, the vehicles involved, weather conditions and responses made. This framework permits<span> </span>querying;<span> </span>thus<span> </span>it<span> </span>is<span> </span>possible<span> </span>to<span> </span>assess<span> </span>the<span> </span>traffic density,<span> </span>time,<span> </span>severity<span> </span>of<span> </span>the incident, and response.</span></em></p> |
| title | Using SQL for Managing Traffic Incident Data |
| topic | Managing data, traffic incident cases, traffic density |
| url | https://doi.org/10.5281/zenodo.14885819 |