Jan Carlson

121 papers A* 3A 4B 19C 14Misc 3Journal 19Unranked 53
YearRankTypeTitle / Venue / Authors
2026 J jnl
Syst.
Joyce Martin, Jakob Axelsson, Jan Carlson
2026 C conf
MODELSWARD
Ifrah Qaisar, Jan Carlson, Robbert Jongeling, Antonio Cicchetti, Malvina Latifaj, Federico Ciccozzi
2026 C conf
MODELSWARD
Malvina Latifaj, Jan Carlson, Antonio Cicchetti, Robbert Jongeling, Ifrah Qaisar
2026 C conf
MODELSWARD
Joyce Martin, Jakob Axelsson, Jan Carlson
2025 B conf
SEAA
Robbert Jongeling, Niels Jørgen Strøm, Lars Peter Torp Nissen, Martin Kitchen, Jan Carlson
2025 conf
ICIT
Shamoona Imtiaz, Moris Behnam, Gabriele Capannini, Jan Carlson, Marcus Jägemar
2025 conf
ICSA Companion
Ifrah Qaisar, Robbert Jongeling, Jan Carlson
2024 J jnl
J. Softw. Evol. Process.
Efi Papatheocharous, Claes Wohlin, Deepika Badampudi, Jan Carlson, Krzysztof Wnuk
2024 conf
SysCon
Joyce Martin, Jakob Axelsson, Jan Carlson, Jagadish Suryadevara
2024 C conf
ETFA
Shamoona Imtiaz, Moris Behnam, Gabriele Capannini, Jan Carlson, Marcus Jägemar
2024 B conf
SEAA
Henrik Gustavsson, Jan Carlson, Eduard Paul Enoiu, David Lindgren
2024 conf
SysCon
Henrik Gustavsson, Damir Bilic, Jan Carlson, Eduard Paul Enoiu
2023 C conf
ETFA
Shamoona Imtiaz, Gabriele Capannini, Jan Carlson, Moris Behnam, Marcus Jägemar
2023 conf
MoDELS (Companion)
Maria Spichkova, Jan Carlson
2023 conf
SoSE
Joyce Martin, Jakob Axelsson, Jan Carlson, Jagadish Suryadevara
2022 book
Accelerating Digital Transformation
Jan Bosch, Jan Carlson, Helena Holmström Olsson, Kristian Sandahl, Miroslaw Staron
2022 ch.
Accelerating Digital Transformation
Robbert Jongeling, Federico Ciccozzi, Antonio Cicchetti, Jan Carlson
2022 J jnl
Softw. Syst. Model.
Robbert Jongeling, Federico Ciccozzi, Jan Carlson, Antonio Cicchetti
2022 B conf
ECSA
Robbert Jongeling, Federico Ciccozzi, Antonio Cicchetti, Jan Carlson
2022 ch.
Accelerating Digital Transformation
Christian Berger, Jan Carlson
2022 C conf
FedCSIS
Henrik Gustavsson, Jan Carlson, Eduard Enoiu
2022 B conf
COMPSAC
Gabriele Capannini, Jan Carlson, Roger Mellander
2022 J jnl
J. Object Technol.
Robbert Jongeling, Johan Fredriksson, Jan Carlson, Federico Ciccozzi, Antonio Cicchetti
2021 conf
ECBS
Cristina Seceleanu, Eduard Paul Enoiu, Jan Carlson, Kristina Lundqvist, Séverine Sentilles, Moris Behnam, Gabriele Capannini
2021 J jnl
J. Object Technol.
Enxhi Ferko, Alessio Bucaioni, Jan Carlson, Zulqarnain Haider
2021 C conf
ETFA
Shamoona Imtiaz, Jakob Danielsson, Moris Behnam, Gabriele Capannini, Jan Carlson, Marcus Jägemar
2021 J jnl
Comput. Stand. Interfaces
Kai Petersen, Jan Carlson, Efi Papatheocharous, Krzysztof Wnuk
2021 A conf
MoDELS
Robbert Jongeling, Sachin Bhatambrekar, Anders Lofberg, Antonio Cicchetti, Federico Ciccozzi, Jan Carlson
2021 conf
ECBS
Gabriele Capannini, Jan Carlson, Roger Mellander
2021 conf
ECBS
Shamoona Imtiaz, Jakob Danielsson, Moris Behnam, Gabriele Capannini, Jan Carlson, Marcus Jägemar
2021 J jnl
J. Softw. Evol. Process.
Claes Wohlin, Efi Papatheocharous, Jan Carlson, Kai Petersen, Emil Alégroth, Jakob Axelsson, Deepika Badampudi, Markus Borg, Antonio Cicchetti, Federico Ciccozzi, Thomas Olsson, Séverine Sentilles, Mikael Svahnberg, Krzysztof Wnuk, Tony Gorschek
2020 A conf
RTAS
Filip Markovic, Jan Carlson, Radu Dobrin
2020 A conf
MoDELS
Robbert Jongeling, Antonio Cicchetti, Federico Ciccozzi, Jan Carlson
2020 J jnl
J. Syst. Softw.
Gabriel Campeanu, Jan Carlson, Séverine Sentilles
2020 conf
SPLC (A)
Damir Bilic, Jan Carlson, Daniel Sundmark, Wasif Afzal, Peter Wallin
2020 B conf
ECRTS
Filip Markovic, Jan Carlson, Sebastian Altmeyer, Radu Dobrin
2020 conf
ICSMM
Robbert Jongeling, Johan Fredriksson, Federico Ciccozzi, Antonio Cicchetti, Jan Carlson
2020 conf
MoDELS (Companion)
Robbert Jongeling, Antonio Cicchetti, Federico Ciccozzi, Jan Carlson
2019 J jnl
IEEE Trans. Ind. Informatics
Filip Markovic, Jan Carlson, Radu Dobrin
2019 J jnl
Softw. Syst. Model.
Federico Ciccozzi, Jan Carlson, Patrizio Pelliccione, Massimo Tivoli
2019 B conf
SEAA
Robbert Jongeling, Jan Carlson, Antonio Cicchetti
2019 J jnl
J. Object Technol.
Robbert Jongeling, Federico Ciccozzi, Antonio Cicchetti, Jan Carlson
2019 J jnl
ACM SIGSOFT Softw. Eng. Notes
Tomás Bures, Danny Weyns, Bradley R. Schmerl, John S. Fitzgerald, Adina Aniculaesei, Christian Berger, João Cambeiro, Jan Carlson, Shafiul Azam Chowdhury, Marian Daun, Nianyu Li, Matthias Markthaler, Claudio Menghi, Birgit Penzenstadler, Aedan D. Pettit, Robert G. Pettit IV, Luca Sabatucci, Christos Tranoris, Hans Vangheluwe, Sebastian Voss, Edith Zavala
2018 B conf
SEAA
Gabriel Campeanu, Jan Carlson, Séverine Sentilles
2018 J jnl
Softw. Qual. J.
Federico Ciccozzi, Juraj Feljan, Jan Carlson, Ivica Crnkovic
2018 conf
MoDELS (Workshops)
Robbert Jongeling, Jan Carlson, Antonio Cicchetti, Federico Ciccozzi
2018 Misc conf
Ada-Europe
Filip Markovic, Jan Carlson, Radu Dobrin
2018 B conf
ENASE
Gabriel Campeanu, Jan Carlson, Séverine Sentilles
2018 conf
SIES
Filip Markovic, Jan Carlson, Radu Dobrin, Björn Lisper, Abhilash Thekkilakattil
2018 Misc conf
Ada-Europe
Irfan Sljivo, Barbara Gallina, Jan Carlson, Hans Hansson, Stefano Puri
2017 J jnl
J. Syst. Softw.
Irfan Sljivo, Barbara Gallina, Jan Carlson, Hans Hansson, Stefano Puri
2017 B conf
SEAA
Gabriel Campeanu, Jan Carlson, Séverine Sentilles
2017 C conf
APSEC
Gabriel Campeanu, Jan Carlson, Séverine Sentilles
2017 conf
ICSA Workshops
Maryam Razavian, Antony Tang, Hans van Vliet, Jan Carlson
2017 J jnl
CoRR
Ivan Svogor, Jan Carlson
2017 B conf
ENASE
Efi Papatheocharous, Kai Petersen, Jakob Axelsson, Claes Wohlin, Jan Carlson, Federico Ciccozzi, Séverine Sentilles, Antonio Cicchetti
2017 conf
WCET
Filip Markovic, Jan Carlson, Radu Dobrin
2017 conf
SysCon
Jakob Axelsson, Ulrik Franke, Jan Carlson, Séverine Sentilles, Antonio Cicchetti
2016 conf
MARCH@WICSA
Jan Carlson, Efi Papatheocharous, Kai Petersen
2016 conf
SAFECOMP Workshops
Irfan Sljivo, Barbara Gallina, Jan Carlson, Hans A. Hansson
2016 conf
CBSE
Gabriel Campeanu, Jan Carlson, Séverine Sentilles, Saad Mubeen
2016 conf
ME@MoDELS
Antonio Cicchetti, Federico Ciccozzi, Jan Carlson
2016 conf
MARCH@WICSA
Antonio Cicchetti, Markus Borg, Séverine Sentilles, Krzysztof Wnuk, Jan Carlson, Efi Papatheocharous
2015 B conf
ICSR
Irfan Sljivo, Barbara Gallina, Jan Carlson, Hans Hansson, Stefano Puri
2015 conf
EUROMICRO-SEAA
Juraj Feljan, Federico Ciccozzi, Jan Carlson, Ivica Crnkovic
2015 conf
ECSA Workshops
Manuel Oriol, Jan Carlson, Michael Wahler
2015 conf
ECSA Workshops
Ivan Svogor, Jan Carlson
2015 C conf
PRDC
Irfan Sljivo, Barbara Gallina, Jan Carlson, Hans Hansson
2014 C conf
ETFA
Luka Lednicki, Jan Carlson
2014 ed.
CBSE
Lionel Seinturier, Eduardo Santana de Almeida, Jan Carlson
2014 conf
EUROMICRO-SEAA
Gabriel Campeanu, Jan Carlson, Séverine Sentilles
2014 A* conf
ASE
Josip Maras, Maja Stula, Jan Carlson
2014 B conf
SAFECOMP
Irfan Sljivo, Barbara Gallina, Jan Carlson, Hans Hansson
2014 conf
EUROMICRO-SEAA
Luka Lednicki, Jan Carlson
2014 J jnl
J. Syst. Softw.
Rafia Inam, Jan Carlson, Mikael Sjödin, Jirí Kuncar
2014 ed.
ModComp@MoDELS
Federico Ciccozzi, Massimo Tivoli, Jan Carlson
2014 conf
EUROMICRO-SEAA
Juraj Feljan, Jan Carlson
2014 conf
ITNG
Aneta Vulgarakis, Rizwin Shooja, Aurelien Monot, Jan Carlson, Moris Behnam
2014 conf
COMPSAC Workshops
Zdravko Krpic, Ivica Crnkovic, Jan Carlson
2013 C conf
ETFA
Luka Lednicki, Jan Carlson, Kristian Sandström
2013 B conf
ICWE
Josip Maras, Maja Stula, Jan Carlson
2013 J jnl
IEEE Trans. Software Eng.
Josip Maras, Maja Stula, Jan Carlson, Ivica Crnkovic
2013 conf
CBSE
Hang Yin, Hongwan Qin, Jan Carlson, Hans Hansson
2013 conf
CBSE
Luka Lednicki, Jan Carlson, Kristian Sandström
2013 conf
ISSRE (Supplemental Proceedings)
Irfan Sljivo, Barbara Gallina, Jan Carlson, Hans Hansson
2013 conf
WISE (2)
Josip Maras, Jan Carlson, Ivica Crnkovic
2012 B conf
SAFECOMP
Rikard Land, Mikael Åkerholm, Jan Carlson
2012 A* conf
WWW
Josip Maras, Jan Carlson, Ivica Crnkovic
2012 conf
CBSE
Jan Carlson
2012 conf
EUROMICRO-SEAA
Juraj Feljan, Jan Carlson, Tiberiu Seceleanu
2012 conf
CBSE
Hang Yin, Jan Carlson, Hans Hansson
2011 conf
EUROMICRO-SEAA
Saad Mubeen, Jukka Mäki-Turja, Mikael Sjödin, Jan Carlson
2011 conf
COMPSAC Workshops
Etienne Borde, Jan Carlson
2011 A* conf
ASE
Josip Maras, Jan Carlson, Ivica Crnkovic
2011 conf
EUROMICRO-SEAA
Thomas Leveque, Jan Carlson, Séverine Sentilles, Etienne Borde
2011 C conf
ISORC
Thomas Leveque, Etienne Borde, Amine Marref, Jan Carlson
2011 conf
WICSA
Etienne Borde, Jan Carlson, Juraj Feljan, Luka Lednicki, Thomas Leveque, Josip Maras, Ana Petricic, Séverine Sentilles
2011 B conf
ICWE
Josip Maras, Maja Stula, Jan Carlson
2011 conf
CBSE
Etienne Borde, Jan Carlson
2010 J jnl
Sci. Comput. Program.
Jan Carlson, Björn Lisper
2010 conf
EUROMICRO-SEAA
Jan Carlson, Juraj Feljan, Jukka Mäki-Turja, Mikael Sjödin
2010 B conf
ICWE
Josip Maras, Maja Stula, Jan Carlson
2010 conf
EUROMICRO-SEAA
Aneta Vulgarakis, Séverine Sentilles, Jan Carlson, Cristina Cerschi Seceleanu
2010 B conf
ENASE
Rikard Land, Jan Carlson, Stig Larsson, Ivica Crnkovic
2009 conf
EUROMICRO-SEAA
Aneta Vulgarakis, Jagadish Suryadevara, Jan Carlson, Cristina Cerschi Seceleanu, Paul Pettersson
2009 conf
CBSE
Séverine Sentilles, Petr Stepan, Jan Carlson, Ivica Crnkovic
2009 conf
ICCSA (2)
Rikard Land, Jan Carlson, Stig Larsson, Ivica Crnkovic
2009 conf
EUROMICRO-SEAA
Juraj Feljan, Jan Carlson, Mario Zagar
2008 C conf
ICSEA
Tomás Bures, Jan Carlson, Séverine Sentilles, Aneta Vulgarakis
2008 conf
CBSE
Séverine Sentilles, Aneta Vulgarakis, Tomás Bures, Jan Carlson, Ivica Crnkovic
2008 B conf
ECRTS
Markus Bohlin, Kaj Hänninen, Jukka Mäki-Turja, Jan Carlson, Mikael Nolin
2008 B conf
ATVA
John Håkansson, Jan Carlson, Aurelien Monot, Paul Pettersson, Davor Slutej
2008 conf
CBSE
Daniel Sundmark, Jan Carlson, Sasikumar Punnekkat, Andreas Ermedahl
2007
Jan Carlson
2007 J jnl
J. Syst. Softw.
Mikael Åkerholm, Jan Carlson, Johan Fredriksson, Hans Hansson, John Håkansson, Anders Möller, Paul Pettersson, Massimo Tivoli
2006 A conf
RTSS
Kaj Hänninen, Jukka Mäki-Turja, Markus Bohlin, Jan Carlson, Mikael Nolin
2005 conf
FESCA@ETAPS
Jan Carlson, Mikael Åkerholm
2005 conf
FACS
Jan Carlson, John Håkansson, Paul Pettersson
2004 Misc conf
EMSOFT
Jan Carlson, Björn Lisper
2003 conf
FORMATS
Jan Carlson, Björn Lisper
2003 C conf
ISORC
Jan Carlson, Tomas Lennvall, Gerhard Fohler
redb/extractors/capa.py
← Index redb/extractors/capa.py python
from dataclasses import asdict
import inspect
import json
import subprocess
import magic
from magika import Magika
from typing import Any, Dict, List, Tuple
from datetime import datetime, timezone

from redb.extractors.enum import Tag
from redb.models.dataclasses import CAPA
from redb.extractors.extractor import Extractor
from dotenv import load_dotenv
import os

load_dotenv(override=True)

class CAPAExtractor(Extractor):

    def __init__(
        self,
        filepath,
        log,
        exporters=None,
        index_prefix=None,
        elastic_index=None,
        known_benign=False,
        known_malicious=False,
    ):
        super().__init__(
            filepath, 
            log, 
            exporters,
            index_prefix, 
            elastic_index, 
            known_benign, 
            known_malicious
        )
        self.capa = None
        self.elastic_index = self.index_prefix + "-capa"

    def _replace_empty_keys(self, dictionary, replacement="default_empty_key"):
        """
        Replace empty keys in a dictionary with a specified replacement.

        Args:
        dictionary (dict): The input dictionary
        replacement (str): The replacement for empty keys (default: 'empty_key')

        Returns:
        dict: A new dictionary with empty keys replaced
        """
        # tmp_dict = {}
        # for k, v in dictionary.items():
        #     if k == '':
        #         tmp_dict[replacement] = dictionary[k]
        #     else:
        #         tmp_dict[k] = dictionary[k]
        # return tmp_dict
        return {(replacement if k == "" else k): v for k, v in dictionary.items()}

    def _extract_capa(self):
        self.log.debug(inspect.currentframe().f_code.co_name)
        TIMEOUT = int(os.getenv("CAPA_TIMEOUT")) # 5 minutes in seconds
        capa_command = [os.getenv("CAPA_PATH"), "-j", self.filepath] # COMMENT FOR TESTING ON MAC

        import signal

        # try:
        #     result = subprocess.run(
        #         capa_command, capture_output=True, text=True, check=True, timeout=TIMEOUT
        #     )
        # except subprocess.TimeoutExpired:
        #     self.log.error(f"The capa command timed out after {TIMEOUT} seconds")
        #     return {}
        # except subprocess.CalledProcessError as e:
        #     self.log.error(f"Error running capa: {e}")
        #     return {}

        # try:
        #     capa_output = json.loads(result.stdout)
        # except json.JSONDecodeError as e:
        #     self.log.error("Error parsing capa output: {e}")
        #     return {}

        # Create a process group for easier termination of all child processes
        try:
            # Start the process in a new process group
            process = subprocess.Popen(
                capa_command,
                stdout=subprocess.PIPE,
                stderr=subprocess.PIPE,
                text=True,
                preexec_fn=os.setsid  # Use os.setsid() to create a new process group
            )
            
            # Implement timeout handling manually
            try:
                stdout, stderr = process.communicate(timeout=TIMEOUT)
                # Process completed within timeout
                if process.returncode != 0:
                    self.log.error(f"Error running capa, return code: {process.returncode}, stderr: {stderr}")
                    return {}
            except subprocess.TimeoutExpired:
                # Kill the entire process group on timeout
                self.log.warning(f"The capa command timed out after {TIMEOUT} seconds, terminating process group")
                
                try:
                    # Send SIGTERM to the entire process group
                    os.killpg(process.pid, signal.SIGTERM)
                    
                    # Give it a moment to terminate gracefully
                    try:
                        process.wait(timeout=3)
                    except subprocess.TimeoutExpired:
                        # If it's still running after 3 seconds, send SIGKILL
                        self.log.warning("Process didn't terminate with SIGTERM, sending SIGKILL")
                        os.killpg(process.pid, signal.SIGKILL)
                        
                    process.wait()  # Make sure process resources are fully cleaned up
                except (ProcessLookupError, OSError) as e:
                    self.log.warning(f"Error while killing process: {e}")
                    
                return {}
                
            try:
                capa_output = json.loads(stdout)
            except json.JSONDecodeError as e:
                self.log.error(f"Error parsing capa output: {e}")
                return {}

            capa_dump = {}  # dictionalry of capabilities
            capabilities = set()  # list of capabilities
            namespaces = set()  # list of namespaces
            attack_dump = {}  # dictionary of tuples [tactic](technique, technique_id)
            tactics = set()  # list of tactics
            techniques = set()  # list of techniques
            techniques_id = set()  # list of techniques_id
            mbc_dump = {}  # dictionary of tuples [objective](behavior, behavior_id)
            mbc_objectives = set()  # list of objectives
            mbc_behaviors = set()  # list of behaviors
            mbc_behaviors_id = set()  # list of behaviors_id

            if isinstance(capa_output, dict) and "rules" in capa_output:
                rules = capa_output["rules"]
                if isinstance(rules, dict):
                    for rule_name, rule_data in rules.items():
                        if isinstance(rule_data, dict) and "meta" in rule_data:
                            meta = rule_data["meta"]
                            if isinstance(meta, dict):
                                # Process capabilities
                                namespace = meta.get("namespace", "").lower()
                                # if namespace != 'lib':
                                if namespace not in capa_dump:
                                    capa_dump[namespace] = []
                                    namespaces.add(namespace)
                                capa_dump[namespace].append(rule_name)
                                capabilities.add(rule_name)

                                # Process ATTACK information
                                if "attack" in meta:
                                    for attack_entry in meta["attack"]:
                                        tactic = attack_entry.get("tactic", "")
                                        technique = attack_entry.get("technique", "")
                                        id = attack_entry.get("id", "")
                                        if tactic and technique:
                                            if tactic in attack_dump:
                                                attack_dump[tactic].append((technique, id))
                                            else:
                                                attack_dump[tactic] = [(technique, id)]
                                            tactics.add(tactic)
                                            techniques.add(technique)
                                            techniques_id.add(id)

                                # Process MBC information
                                if "mbc" in meta:
                                    for mbc_entry in meta["mbc"]:
                                        objective = mbc_entry.get("objective", "")
                                        behavior = mbc_entry.get("behavior", "")
                                        id = mbc_entry.get("id", "")
                                        if objective and behavior:
                                            if objective in mbc_dump:
                                                mbc_dump[objective].append((behavior, id))
                                            else:
                                                mbc_dump[objective] = [(behavior, id)]
                                            mbc_objectives.add(objective)
                                            mbc_behaviors.add(behavior)
                                            mbc_behaviors_id.add(id)

            # return {
            #     'capabilities_all': json.dumps(capabilities_all, indent=2),
            #     'capabilities': list(capabilities),
            #     'namespaces': list(namespaces),
            #     'attack': json.dumps(attack, indent=2),
            #     'tactics': list(tactics),
            #     'techniques': list(techniques),
            #     'techniques_id': list(techniques_id),
            #     'mbc': json.dumps(mbc, indent=2),
            #     'mbc_objectives': list(mbc_objectives),
            #     'mbc_behaviors': list(mbc_behaviors),
            #     'mbc_behaviors_id': list(mbc_behaviors_id)
            # }

            capa_dump = self._replace_empty_keys(capa_dump)
            attack_dump = self._replace_empty_keys(attack_dump)
            mbc_dump = self._replace_empty_keys(mbc_dump)
            self.capa = CAPA(
                json.dumps(capa_dump, indent=2),
                list(capabilities),
                list(namespaces),
                json.dumps(attack_dump, indent=2),
                list(tactics),
                list(techniques),
                list(techniques_id),
                json.dumps(mbc_dump, indent=2),
                list(mbc_objectives),
                list(mbc_behaviors),
                list(mbc_behaviors_id),
            )
            self.log.debug(f"CAPA dump: {self.capa})")
            
        except Exception as e:
            self.log.error(f"Unexpected error in CAPA extraction: {str(e)}")
            # Try to clean up any process if possible
            if 'process' in locals() and process.poll() is None:
                try:
                    os.killpg(process.pid, signal.SIGKILL)
                    process.wait()
                except:
                    pass
            return {}

    def prepare_export_data(self, exporter_type: str) -> Any:
        if exporter_type == "ElasticsearchExporter":
            return self.capa
        elif exporter_type == "ClickHouseExporter":
            current_time = datetime.now(timezone.utc)
            
            # Prepare data for multiple tables
            tables_data = {
                'multi_table': True,  # Flag for multi-table export
                
                # Raw data table
                'raw': {
                    'table': 'redb_capa',
                    'data': [[
                        self.sha256,
                        self.md5,
                        self.sha1,
                        current_time,
                        self.capa.capa_dump,  # capa_dump
                        self.capa.attack_dump,            # attack_dump
                        self.capa.mbc_dump                # mbc_dump
                    ]],
                    'column_names': [
                        'sha256', 'md5', 'sha1', 'analysis_date',
                        'capa_dump', 'attack_dump', 'mbc_dump'
                    ],
                    'column_type_names': [
                        'FixedString(64)', 'FixedString(32)', 'FixedString(40)',
                        'DateTime64(3, \'UTC\')',
                        'JSON', 'JSON', 'JSON'
                    ]
                },
                
                # Capabilities table
                'capabilities': {
                    'table': 'redb_capa_capabilities',
                    'data': [
                        [self.sha256, self.md5, self.sha1, current_time, namespace, capability]
                        for namespace, capabilities in json.loads(self.capa.capa_dump).items()
                        for capability in capabilities
                    ],
                    'column_names': [
                        'sha256', 'md5', 'sha1', 'analysis_date',
                        'namespace', 'capability'
                    ],
                    'column_type_names': [
                        'FixedString(64)', 'FixedString(32)', 'FixedString(40)',
                        'DateTime64(3, \'UTC\')',
                        'LowCardinality(String)', 'LowCardinality(String)'
                    ]
                },
                
                # MITRE ATT&CK table
                'attack': {
                    'table': 'redb_capa_attack',
                    'data': [
                        [self.sha256, self.md5, self.sha1, current_time, 
                         tactic, technique[0], technique[1]]  # technique[0] is the name, technique[1] is the ID
                        for tactic, techniques in json.loads(self.capa.attack_dump).items()
                        for technique in techniques
                    ],
                    'column_names': [
                        'sha256', 'md5', 'sha1', 'analysis_date',
                        'tactic', 'technique', 'technique_id'
                    ],
                    'column_type_names': [
                        'FixedString(64)', 'FixedString(32)', 'FixedString(40)',
                        'DateTime64(3, \'UTC\')',
                        'LowCardinality(String)', 'LowCardinality(String)', 
                        'LowCardinality(String)'
                    ]
                },
                
                # MBC table
                'mbc': {
                    'table': 'redb_capa_mbc',
                    'data': [
                        [self.sha256, self.md5, self.sha1, current_time,
                         objective, behavior[0], behavior[1]]  # behavior[0] is the name, behavior[1] is the ID
                        for objective, behaviors in json.loads(self.capa.mbc_dump).items()
                        for behavior in behaviors
                    ],
                    'column_names': [
                        'sha256', 'md5', 'sha1', 'analysis_date',
                        'objective', 'behavior', 'behavior_id'
                    ],
                    'column_type_names': [
                        'FixedString(64)', 'FixedString(32)', 'FixedString(40)',
                        'DateTime64(3, \'UTC\')',
                        'LowCardinality(String)', 'LowCardinality(String)',
                        'LowCardinality(String)'
                    ]
                }
            }
            
            return tables_data

    def get_clickhouse_table(self) -> str:
        return "redb_capa"  # Return the main table name

    def extract(self):
        self.log.debug(inspect.currentframe().f_code.co_name)
        try:
            self._extract_capa()
            return self.capa  # Return the extracted data instead of exporting directly
        except Exception as e:
            self.log.error(f"Error extracting CAPA: {e}")
            return None

    def tag(self):
        return Tag.CAPA.value