EUVIMEDEUVIMED entdecken
Crossref

CIRRS: A Relational Database Approach for Managing the Cyber Incident Life Cycle

Om Tushar Johari, Atharva Dattatray Hajare, Aditya Pramod Jadhav, Omkar Vithoba Maan, Dr. Mrunal K. Pathak

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.

AbstractBibliografische AngabenZitierenVerwandte Studien

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}
}
Kostenlos starten →