CIRRS: A Relational Database Approach for Managing the Cyber Incident Life Cycle
International Journal of Advanced Research in Science Communication and Technology · 12.11.2026 · 402
DOI: 10.48175/ijarsct-40756 ↗Kurz gefasst
Fachartikel in der Zeitschrift International Journal of Advanced Research in Science Communication and Technology, online erschienen am 12.11.2026. Verfasst von Om Tushar Johari und 4 weiteren Autor:innen. Die Arbeit nennt 15 Literaturangaben.
Abstract (Originalsprache)
Small organisations and educational institutions often record cyber incidents through emails, phone calls and spreadsheets, which scatters incident details, evidence references and response activities across different places. This paper presents the database design of the Cyber Incident Reporting and Response System (CIRRS), a MySQL relational database that organises incident information from reporting to investigation and resolution. The schema has seven tables: Users, Incidents, Affected_Systems, Evidence, Investigators, Incident_Actions and Resolutions. Primary keys and foreign keys connect the records, while SQL queries, joins and views support retrieval and reporting. The sample database holds 28 inserted rows, including four incidents and one resolution record. The tests show retrieval of related records, an updatable single-table view, a non-updatable aggregate view and the rejection of a delete that would violate referential integrity. The review also found a mismatch between incident status and resolution records: one incident has a resolution record but a status of Under Investigation, and another is marked Resolved without any resolution record. The paper focuses on database design and SQL behaviour, not on automated threat detection.
Zitieren
APA
Johari, O. T., Hajare, A. D., Jadhav, A. P., Maan, O. V., & Pathak, D. M. K. (2026). CIRRS: A Relational Database Approach for Managing the Cyber Incident Life Cycle. International Journal of Advanced Research in Science Communication and Technology, 402. https://doi.org/10.48175/ijarsct-40756
Vancouver
Johari OT, Hajare AD, Jadhav AP, Maan OV, Pathak DMK. CIRRS: A Relational Database Approach for Managing the Cyber Incident Life Cycle. International Journal of Advanced Research in Science Communication and Technology. 2026:402. doi:10.48175/ijarsct-40756
BibTeX
@article{Johari2026,
author = {Johari, Om Tushar and Hajare, Atharva Dattatray and Jadhav, Aditya Pramod and Maan, Omkar Vithoba and Pathak, Dr. Mrunal K.},
title = {CIRRS: A Relational Database Approach for Managing the Cyber Incident Life Cycle},
journal = {International Journal of Advanced Research in Science Communication and Technology},
year = {2026},
pages = {402},
doi = {10.48175/ijarsct-40756}
}
EUVIMED