Rana El Kaliouby

49 papers A 4B 20C 1Misc 2Journal 7Unranked 14
YearRankTypeTitle / Venue / Authors
2019 J jnl
IEEE Trans. Affect. Comput.
Daniel McDuff, May Amr, Rana El Kaliouby
2017 J jnl
IEEE Trans. Affect. Comput.
Daniel McDuff, Rana El Kaliouby
2016 conf
CHI Extended Abstracts
Daniel McDuff, Abdelrahman N. Mahmoud, Mohammad Mavadati, May Amr, Jay Turcot, Rana El Kaliouby
2016 conf
CHI Extended Abstracts
Phil Cohen, Adam Cheyer, Eric Horvitz, Rana El Kaliouby, Steve Whittaker
2015 B conf
ACII
Daniel McDuff, Rana El Kaliouby, Rosalind W. Picard
2015 B conf
FG
Thomas Vandal, Daniel McDuff, Rana El Kaliouby
2015 conf
ICCV Workshops
Thibaud Senechal, Daniel McDuff, Rana El Kaliouby
2015 J jnl
IEEE Trans. Affect. Comput.
Daniel McDuff, Rana El Kaliouby, Jeffrey F. Cohn, Rosalind W. Picard
2015 B conf
FG
Ahmed Osman, Jay Turcot, Rana El Kaliouby
2014 J jnl
Image Vis. Comput.
Daniel McDuff, Rana El Kaliouby, Thibaud Senechal, David Demirdjian, Rosalind W. Picard
2014 J jnl
Mark. Sci.
Thales Teixeira, Rosalind W. Picard, Rana El Kaliouby
2013 conf
CVPR Workshops
Daniel McDuff, Rana El Kaliouby, Thibaud Senechal, May Amr, Jeffrey F. Cohn, Rosalind W. Picard
2013 B conf
FG
Evan Kodra, Thibaud Senechal, Daniel McDuff, Rana El Kaliouby
2013 B conf
ACII
Daniel McDuff, Rana El Kaliouby, Evan Kodra, Rosalind W. Picard
2013 B conf
FG
Daniel McDuff, Rana El Kaliouby, David Demirdjian, Rosalind W. Picard
2013 B conf
FG
Thibaud Senechal, Jay Turcot, Rana El Kaliouby
2012 J jnl
IEEE Trans. Affect. Comput.
Daniel McDuff, Rana El Kaliouby, Rosalind W. Picard
2011 B conf
FG
Daniel McDuff, Rana El Kaliouby, Karim Kassam, Rosalind W. Picard
2011 B conf
ICMI
Daniel McDuff, Rana El Kaliouby, Rosalind W. Picard
2011 B conf
FG
Tadas Baltrusaitis, Daniel McDuff, Ntombikayise Banda, Marwa Mahmoud, Rana El Kaliouby, Peter Robinson, Rosalind W. Picard
2010 conf
CVPR Workshops
Daniel McDuff, Rana El Kaliouby, Karim Kassam, Rosalind W. Picard
2010 conf
AH
Mina Mikhail, Khaled El-Ayat, Rana El Kaliouby, James Arthur Coan, John J. B. Allen
2009 B conf
ACII
Miriam Madsen, Rana El Kaliouby, Micah Eckhardt, Matthew S. Goodwin, Mohammed E. Hoque, Rosalind W. Picard
2009 B conf
ICIP
Mina Mikhail, Rana El Kaliouby
2009 A conf
INTERSPEECH
Mohammed E. Hoque, Joseph K. Lane, Rana El Kaliouby, Matthew S. Goodwin, Rosalind W. Picard
2009 conf
CHI Extended Abstracts
Miriam Madsen, Rana El Kaliouby, Micah Eckhardt, Mohammed E. Hoque, Matthew S. Goodwin, Rosalind W. Picard
2009 B conf
ACII
Tina Gonsalves, Christopher D. Frith, Bruno B. Averbeck, Youssef Kashef, Abdelrahman N. Mahmoud, Rana El Kaliouby, Rosalind W. Picard, Nadia Bianchi-Berthouze, Matt Iacobini, Hugo D. Critchley, Helen Sloan
2009 conf
ICIAR
Marwa Mahmoud, Rana El Kaliouby, Amr Goneid
2009 B conf
IVA
Mohammed E. Hoque, Rana El Kaliouby, Rosalind W. Picard
2008 B conf
ICMI
Rana El Kaliouby, Mina Mikhail
2008 A conf
ASSETS
Miriam Madsen, Rana El Kaliouby, Matthew S. Goodwin, Rosalind W. Picard
2008 B conf
Intelligent Tutoring Systems
Toby Dragon, Ivon Arroyo, Beverly Park Woolf, Winslow Burleson, Rana El Kaliouby, Hoda Eydgahi
2008 Misc conf
IDC
Rana El Kaliouby, Matthew S. Goodwin
2007 B conf
ICMI
Rana El Kaliouby, Alea Teeters
2007 conf
SIGGRAPH Posters
Ronald Reisman, Rana El Kaliouby
2007 conf
CHI Extended Abstracts
Daniel R. Gillette, Gillian R. Hayes, Gregory D. Abowd, Justine Cassell, Rana El Kaliouby, Dorothy Strickland, Patrice L. (Tamar) Weiss
2007 A conf
AIED
Sidney K. D'Mello, Scotty D. Craig, Rana El Kaliouby, Madeline Alsmeyer, Genaro Rebolledo-Mendez
2006 C conf
BSN
Rana El Kaliouby, Alea Teeters, Rosalind W. Picard
2006 conf
SIGGRAPH Research Posters
Alea Teeters, Rana El Kaliouby, Rosalind W. Picard
2005 B conf
ACII
Rana El Kaliouby, Peter Robinson
2005
Rana El Kaliouby
2005 J jnl
Univers. Access Inf. Soc.
Rana El Kaliouby, Peter Robinson
2004 A conf
IUI
Rana El Kaliouby, Peter Robinson
2004 conf
SMC (1)
Rana El Kaliouby, Peter Robinson
2004 conf
CVPR Workshops
Rana El Kaliouby, Peter Robinson
2003 B conf
INTERACT
Rana El Kaliouby, Peter Robinson
2003 B conf
ICMI
Philipp Michel, Rana El Kaliouby
2003 conf
HCI (4)
Rana El Kaliouby, Peter Robinson
2001 Misc conf
HCI
Amr Goneid, Rana El Kaliouby
redb/extractors/macho_extractors/macho_similarity_hashes.py
← Index redb/extractors/macho_extractors/macho_similarity_hashes.py python
import inspect
from datetime import datetime, timezone
from typing import Any

from redb.extractors.enum import Tag
from redb.extractors.macho_extractor import MachOExtractor


class MachOSimilarityHashExtractor(MachOExtractor):
    """Extract Mach-O similarity hashes using machofile API.

    Similarity hashes are MD5 fingerprints of sorted, deduplicated binary components:
    - dylib_hash: MD5 of dynamic library names
    - import_hash: MD5 of imported function names
    - export_hash: MD5 of exported symbol names
    - entitlement_hash: MD5 of entitlement names and array values
    - symhash: MD5 of external undefined symbols

    For FAT binaries:
    - Inserts one row per architecture slice with per-slice hashes
    - Inserts one row for the FAT container with combined hashes

    For single-arch binaries:
    - Inserts one row with that architecture's hashes

    Note: parent_sha256 and architecture relationships are tracked in redb_basic_properties,
    not duplicated here. Use JOIN with redb_basic_properties when needed.
    """

    def __init__(
        self,
        filepath,
        log,
        exporters=None,
        index_prefix=None,
        elastic_index=None,
        known_benign=False,
        known_malicious=False,
        macho=None,
    ):
        super().__init__(
            filepath,
            log,
            exporters,
            index_prefix,
            elastic_index,
            known_benign,
            known_malicious,
            macho,
        )
        self.elastic_index = self.index_prefix + "-macho_hashes"
        self.log.debug(inspect.currentframe().f_code.co_name)

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

    def _extract_similarity_hashes(self, arch_name=None):
        """Extract similarity hashes for a specific architecture."""
        self.log.debug(inspect.currentframe().f_code.co_name)

        if not self.macho:
            return None

        try:
            similarity_hashes = self.macho.get_similarity_hashes(arch=arch_name)
            return similarity_hashes if similarity_hashes else None
        except Exception as e:
            self.log.error(f"Error extracting similarity hashes for arch {arch_name}: {e}")
            return None

    def extract(self):
        self.log.debug(inspect.currentframe().f_code.co_name)
        try:
            if not self.macho:
                return None

            architectures = self.macho.get_architectures()
            if not architectures:
                return None

            if len(architectures) > 1:
                # FAT binary - return combined hashes + per-arch hashes
                results = []

                # First add combined hashes for the FAT container
                all_hashes = self.macho.get_similarity_hashes()
                combined_hashes = all_hashes.get('combined', {}) if all_hashes else {}
                if combined_hashes:
                    combined_hashes['arch_identifier'] = 'fat'
                    results.append(combined_hashes)

                # Then add per-arch hashes
                for arch_name in architectures:
                    hashes = self._extract_similarity_hashes(arch_name)
                    if hashes:
                        hashes['arch_identifier'] = arch_name
                        results.append(hashes)
                return results
            else:
                # Single architecture - return single result
                return self._extract_similarity_hashes(architectures[0])
        except Exception as e:
            self.log.error(f"Error extracting similarity hashes: {e}")
            return None

    def prepare_export_data(self, exporter_type: str) -> Any:
        if exporter_type == "ElasticsearchExporter":
            return self.extract()
        elif exporter_type == "ClickHouseExporter":
            if not self.macho:
                return None

            try:
                architectures = self.macho.get_architectures()
                is_fat = len(architectures) > 1
            except Exception as e:
                self.log.error(f"Could not get architectures: {e}")
                return None

            data = []
            current_time = datetime.now(timezone.utc)

            # For FAT binaries, first insert a row for the container with combined hashes
            if is_fat:
                all_hashes = self.macho.get_similarity_hashes()  # Without arch returns all including 'combined'
                combined_hashes = all_hashes.get('combined', {}) if all_hashes else {}
                if combined_hashes:
                    data.append([
                        self.sha256,                                    # sha256 (FAT container)
                        combined_hashes.get('dylib_hash'),              # dylib_hash
                        combined_hashes.get('import_hash'),             # import_hash
                        combined_hashes.get('export_hash'),             # export_hash
                        combined_hashes.get('entitlement_hash'),        # entitlement_hash
                        combined_hashes.get('symhash'),                 # symhash
                        current_time,                                   # analysis_date
                    ])

            # Insert rows for each architecture slice
            for arch_name in architectures:
                # Get architecture-specific sha256
                try:
                    arch_general_info = self.macho.get_general_info(arch=arch_name)
                    arch_sha256 = arch_general_info.get('SHA256', self.sha256)
                except Exception as e:
                    self.log.warning(f"Could not get arch-specific sha256 for {arch_name}: {e}")
                    arch_sha256 = self.sha256

                # Get similarity hashes for this architecture
                similarity_hashes = self._extract_similarity_hashes(arch_name)
                if not similarity_hashes:
                    continue

                data.append([
                    arch_sha256,                                    # sha256 (arch-specific)
                    similarity_hashes.get('dylib_hash'),            # dylib_hash
                    similarity_hashes.get('import_hash'),           # import_hash
                    similarity_hashes.get('export_hash'),           # export_hash
                    similarity_hashes.get('entitlement_hash'),      # entitlement_hash
                    similarity_hashes.get('symhash'),               # symhash
                    current_time,                                   # analysis_date
                ])

            if not data:
                return None

            column_names = [
                'sha256',
                'macho_dylib_hash', 'macho_import_hash', 'macho_export_hash',
                'macho_entitlement_hash', 'macho_symhash',
                'analysis_date'
            ]

            column_type_names = [
                'FixedString(64)',
                'Nullable(FixedString(32))', 'Nullable(FixedString(32))', 'Nullable(FixedString(32))',
                'Nullable(FixedString(32))', 'Nullable(FixedString(32))',
                'DateTime64(3, \'UTC\')'
            ]

            return (data, column_names, column_type_names)

        return None

    def get_clickhouse_table(self) -> str:
        return "redb_hashes"