Design and Create Database Tables for Storing DISARM Red Framework Data

[KadeMorton]

Description

To support the integration of the DISARM Red Framework within Thread, we need to design and create the necessary database tables to store the DISARM Red Framework data, including STIX data. This ticket involves planning the database schema, ensuring it aligns with the structure and requirements of the DISARM Red Framework, and implementing the tables within the database.

Task

• Design Database Schema: Analyze the data requirements of the DISARM Red Framework and design a comprehensive database schema to store STIX data effectively.
• Create Database Tables: Implement the database tables according to the designed schema, ensuring they are optimized for performance and scalability.
• Ensure Data Integrity and Security: Implement appropriate data integrity constraints and security measures to protect the stored DISARM Red Framework data.
• Document the Schema: Provide clear documentation of the database schema, including table relationships, field descriptions, and any relevant indexing strategies.

Acceptance Criteria

• Completion of a documented database schema design that meets the data requirements of the DISARM Red Framework.
• Successful creation and deployment of the database tables in the relevant database environment.
• Verification that the tables support the required operations for storing, retrieving, and managing DISARM Red Framework data.
• Validation of data integrity and security measures implemented in the database schema.
• Documentation is provided and reviewed.

Steps

1. Requirement Gathering and Schema Design: Analysis and planning for the database structure.
2. Database Table Implementation: Develop and deploy the database tables according to the schema design.
3. Testing and Validation: Conduct testing to ensure data can be stored, retrieved, and managed correctly.
4. Documentation: Complete documentation.

[jecarr]

As Stephen (DISARM) kindly informed us, we can utilise generate_DISARM_pages.py and generate_disarm_sql.py

• generate_DISARM_pages.py looks as if it reads the framework data from two Excel spreadsheets (data and frameworks)
  • This then goes on to build the markdown pages using this data
• generate_disarm_sql.py builds local-database tables and imports the data previously read from the Excel spreadsheets
  • If we use this, we'd need a way to replace the hardcoded local-database settings in this file to connect to the database we want to use