Mansur H. Samadzadeh

53 papers B 1C 4Misc 6Journal 17Unranked 24
YearRankTypeTitle / Venue / Authors
2018 J jnl
Age-based anonymity: a randomized routing approach to communication unobservability.
Telecommun. Syst.
Peyman Taher, Alireza T. Boloorchi, Mansur H. Samadzadeh
2017 C conf
Design, Prototype Implementation, and Comparison of Scalable Web-Push Architectures on Amazon Web Services Using the Actor Model.
ICSEng
Hussachai Puripunpinyo, Mansur H. Samadzadeh
2017 — conf
Effect of optimizing Java deployment artifacts on AWS Lambda.
INFOCOM Workshops
Hussachai Puripunpinyo, Mansur H. Samadzadeh
2014 B conf
A New Parallelism-Capable Clustering Algorithm for Wireless Sensor Networks.
CCGRID
Alireza T. Boloorchi, Mansur H. Samadzadeh, Nazanin Rahnavard
2014 J jnl
Corrigendum to "Symmetric threshold multipath (STM): An online symmetric key management scheme" [Inform. Sci. 268(2014) 489-504].
Inf. Sci.
Alireza T. Boloorchi, Mansur H. Samadzadeh, T. Chen
2014 C conf
Migration from Legacy Systems to SOA Applications: A Survey and an Evaluation.
ICSEng
Sukanya Suwisuthikasem, Mansur H. Samadzadeh
2014 J jnl
Symmetric Threshold Multipath (STM): An online symmetric key management scheme.
Inf. Sci.
Alireza T. Boloorchi, Mansur H. Samadzadeh, T. Chen
2013 J jnl
Energy-efficient and secure in-network storage and retrieval for WSNs: an adaptive approach.
J. Supercomput.
Alireza T. Boloorchi, Mansur H. Samadzadeh
2011 C conf
Program Comprehension and Implications of Human Navigational Approaches.
ICSEng
Senthilrajan Moorthy, Mansur H. Samadzadeh
2010 — conf
Energy Efficient and Secure In-Network Storage for Wireless Sensor Networks.
Security and Management
Alireza T. Boloorchi, Mansur H. Samadzadeh
2010 — conf
Mining for Patterns in Program Dependence Graphs.
Software Engineering Research and Practice
Imran Afzal, Mansur H. Samadzadeh
2010 — conf
Toward Sender Anonymity in the Presence of an Active Global Adversary.
Security and Management
Peyman Taher, Mansur H. Samadzadeh
2009 — conf
A Detailed Analysis of the Component Object Model.
Software Engineering Research and Practice
Arif Muljadi, Mansur H. Samadzadeh
2009 — conf
Cognitector - A Source-Code Consistency Analysis Application.
Software Engineering Research and Practice
Peyman Taher, Mansur H. Samadzadeh
2008 Misc conf
A New Web Cache Replacement Algorithm: Perfect-Time-Size Least Frequently Used.
PDPTA
Tarik Kapetanovic, Mansur H. Samadzadeh
2008 — conf
An Integrated Test Environment Process Model to Control Software Failures.
Software Engineering Research and Practice
Mohan Bheemasenarao, Mansur H. Samadzadeh
2008 — conf
On the Power of Stochastic Automata Networks in Random Environments.
FCS
Jia Liu, Mansur H. Samadzadeh
2007 Misc conf
A Mutual Exclusion Algorithm Based on Request and Fair.
PDPTA
Jingsong Zhang, Mansur H. Samadzadeh
2007 — conf
A Survey and a Taxonomy of Automata-Theoretic Modeling Techniques.
FCS
Jaroslav Lajos, Mansur H. Samadzadeh
2006 J jnl
Organizing and Visualizing Software Repositories Using the Growing Hierarchical Self-Organizing Map.
J. Inf. Sci. Eng.
Songsri Tangsripairoj, Mansur H. Samadzadeh
2006 — conf
PAC: Progressive Alignment with Consensus Sequences.
BIOCOMP
Ke Liu, Mansur H. Samadzadeh
2005 — conf
A Comparison of Z and UML: Two Case Studies.
PLC
Bing Dong Li, Mansur H. Samadzadeh
2005 — conf
A Study of Tunnel Vision and Rotation as Aspects of Web Site Visibility.
ITCC (2)
Rami N. Hasan, Mansur H. Samadzadeh
2005 — conf
A Survey of Software Reliability Models and an Application of the Bayesian Belief Networks Model.
Software Engineering Research and Practice
Qiaolan Wan, Mansur H. Samadzadeh
2005 — conf
Determining the Complexity of XML Documents.
ITCC (2)
Mustafa H. Qureshi, Mansur H. Samadzadeh
2005 — conf
Development and Evaluation of a Slicing-Based C++ Debugger.
ITCC (2)
Winai Wichaipanitch, Mansur H. Samadzadeh, Songsri Tangsripairoj
2005 Misc conf
Organizing and visualizing software repositories using the growing hierarchical self-organizing map.
SAC
Songsri Tangsripairoj, Mansur H. Samadzadeh
2004 — conf
Application of Self-Organizing Maps to Software Repositories in Reuse-Based Software Development.
Software Engineering Research and Practice
Songsri Tangsripairoj, Mansur H. Samadzadeh
2004 J jnl
Extraction of Java program fingerprints for software authorship identification.
J. Syst. Softw.
Haibiao Ding, Mansur H. Samadzadeh
2004 — conf
The Role of OMG IDL in Component Composition: A Survey and a Case Study.
Software Engineering Research and Practice
Emran Al-Shahrouri, Mansur H. Samadzadeh
2003 Misc conf
A Coarse-Grain Parallel Genetic Algorithm for Finding Ramsey Numbers.
SAC
Iker Gondra, Mansur H. Samadzadeh
2003 — conf
A Survey of Data Mining Technology Applied to Software Reuse.
Software Engineering Research and Practice
Songsri Tangsripairoj, Mansur H. Samadzadeh
2003 J jnl
A new hybrid approach to exploit localities: LRFU with adaptive prefetching.
SIGMETRICS Perform. Evaluation Rev.
Jike Cui, Mansur H. Samadzadeh
2001 J jnl
Hardware/Software Cost Analysis of Interrupt Processing Strategies.
IEEE Micro
Mansur H. Samadzadeh, Loai E. Garalnabi
1996 J jnl
A Display and Analysis Tool for Process-Resource Graphs.
ACM SIGOPS Oper. Syst. Rev.
Mansur H. Samadzadeh, B. S. Koshy
1996 J jnl
SSR'95 summary report.
ACM SIGSOFT Softw. Eng. Notes
Mansur H. Samadzadeh, Mansour Kazerooni-Zand
1995 J jnl
Guest editors' corner Software reuse: Current status and trends.
J. Syst. Softw.
Mansour Zand, Mansur H. Samadzadeh
1995 — ed.
Proceedings of the ACM SIGSOFT Symposium on Software Reusability, SSR@ICSE 1995, April 23-30, 1995, Seattle, WA, USA
SSR@ICSE
Mansur H. Samadzadeh, Mansour Kazerooni-Zand
1994 C conf
Hybrid Fuzzy Metrics for Software Reusability.
IPMU
Bradley J. Balentine, Mansour Zand, Mansur H. Samadzadeh
1994 — conf
Stability, Coupling, and Cohesion of Object-Oriented Software Systems.
ACM Conference on Computer Science
Mansur H. Samadzadeh, S. J. Khan
1993 — conf
An Interactive Debugging Tool for C Based on Dynamic Slicing and Dicing.
ACM Conference on Computer Science
Mansur H. Samadzadeh, Winai Wichaipanitch
1993 J jnl
An interconnection language for reuse at the template/module level.
J. Syst. Softw.
Mansour Zand, Hossein Saiedian, K. M. George, Mansur H. Samadzadeh
1993 — conf
Object-oriented Simulation Of Capability Based Architectures.
Annual Simulation Symposium
Stephen R. Daily, Mansur H. Samadzadeh
1993 J jnl
Version management for ROPCO - a micro-incremental reuse environment.
Inf. Softw. Technol.
Mansour Kazerooni-Zand, Mansur H. Samadzadeh, Hossein Saiedian
1992 J jnl
A feedback inheritance model.
J. Syst. Softw.
H. M. Al-Haddad, K. M. George, Mansur H. Samadzadeh
1992 Misc conf
A reusable software catalog interface.
SAC
J. E. Swanson, Mansur H. Samadzadeh
1992 — conf
An object-oriented environment for simulation and evaluation of architectures.
Annual Simulation Symposium
Khaled M. Hassan, Mansur H. Samadzadeh
1992 J jnl
Measuring Complexity and Stability of WEB programs.
Struct. Program.
Lisa M. Smith, Mansur H. Samadzadeh
1992 Misc conf
Scheduling algorithms for precedence graphs.
SAC
Sridhar Mandyam, Mansur H. Samadzadeh
1991 J jnl
A study of software metrics.
J. Syst. Softw.
Mansur H. Samadzadeh, K. Nandakumar
1991 J jnl
An annotated bibliography of literate programming.
ACM SIGPLAN Notices
Lisa M. Smith, Mansur H. Samadzadeh
1991 — conf
Sensitivity of graph-theoretic metrics to edge directions for structured and unstructured programs (abstract and references only).
ACM Conference on Computer Science
Chinsyh Hu, Mansur H. Samadzadeh
1990 — conf
Minimizing Ripple Recompilation in a Persistent Software Environment.
ACM Conference on Computer Science
Mansour Kazerooni-Zand, Mansur H. Samadzadeh, K. M. George
notebooks/redb-clickhouse-TEST.ipynb
← Index notebooks/redb-clickhouse-TEST.ipynb plaintext
Truncated preview: showing the first 16384 bytes out of 5988848 total.
{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Definitions"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [],
   "source": [
    "import clickhouse_connect"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "\n",
    "ch_TEST_client = clickhouse_connect.get_client(host='e.rationaledge.io', port=443, username='default', password='werioubTGwvf0-dsbv_', database='redb', verify=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [],
   "source": [
    "ch_TEST_BETA_client = clickhouse_connect.get_client(host='k.rationaledge.io', port=443, username='default', password='werioubTGwvf0-dsbv_', database='default', verify=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<bound method HttpClient.close_connections of <clickhouse_connect.driver.httpclient.HttpClient object at 0x105fd64d0>>"
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "ch_TEST_BETA_client.close_connections"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<clickhouse_connect.driver.summary.QuerySummary at 0x11f900810>"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "ch_TEST_BETA_client.command(\"\"\"\n",
    "RENAME DATABASE redb TO orig_redb;\n",
    "\"\"\")"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## DB Creation (schema 2025-08-02)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "ch_TEST_client.command(\"\"\"\n",
    "CREATE DATABASE IF NOT EXISTS redb;\n",
    "\"\"\")"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Define General Tables"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "### CREATE FULL REDB DATABASE\n",
    "def create_redb_with_all_tables(client):\n",
    "    client.command(\"\"\"\n",
    "        CREATE DATABASE IF NOT EXISTS redb\n",
    "    \"\"\")\n",
    "    create_all_general_tables(client)\n",
    "    create_all_pe_tables(client)\n",
    "\n",
    "#### CREATE FULL TABLES\n",
    "def create_all_general_tables(client):\n",
    "    create_basic_properties_dbtable(client)\n",
    "    create_hashes_dbtable(client)\n",
    "    create_capa_dbtable(client)\n",
    "    create_die_dbtable(client)\n",
    "    create_extra_findings_dbtable(client)\n",
    "\n",
    "\n",
    "##################################\n",
    "#### CREATE INDIVIDUAL TABLES ####\n",
    "##################################\n",
    "\n",
    "#### GENERAL TABLES ####\n",
    "# All tables have SETTINGS index_granularity = 8192\n",
    "def create_basic_properties_dbtable(client):\n",
    "    # Create samples_metadata table\n",
    "    client.command(\"\"\"\n",
    "        CREATE TABLE IF NOT EXISTS redb_basic_properties (\n",
    "            sha256 FixedString(64), -- primary key\n",
    "            md5 FixedString(32),\n",
    "            sha1 FixedString(40),\n",
    "            filename Nullable(String),\n",
    "            sample_name String,\n",
    "            filesize UInt64,\n",
    "            file_entropy Float64,\n",
    "            filetype LowCardinality(String),\n",
    "            filetype_mime LowCardinality(String),\n",
    "            filetype_magika LowCardinality(String),\n",
    "            analysis_date DateTime64(3, 'UTC'),\n",
    "        ) ENGINE = ReplacingMergeTree(analysis_date)\n",
    "        PRIMARY KEY (sha256)\n",
    "        ORDER BY (sha256)\n",
    "    \"\"\")\n",
    "\n",
    "def create_hashes_dbtable(client):\n",
    "    # Create hashes table\n",
    "    client.command(\"\"\"\n",
    "        CREATE TABLE IF NOT EXISTS redb_hashes (\n",
    "            sha256 FixedString(64), -- primary key\n",
    "            md5 FixedString(32),\n",
    "            sha1 FixedString(40),\n",
    "            ssdeep_hash Nullable(String),\n",
    "            tlsh_hash Nullable(String),\n",
    "            authentihash Nullable(String),\n",
    "            imphash Nullable(String),\n",
    "            impfuzzy Nullable(String),\n",
    "            typerefhash Nullable(String),\n",
    "            richhash Nullable(String),\n",
    "            richpe_hash Nullable(String),\n",
    "            richpv_hash Nullable(String),\n",
    "            richpv_hash_sorted Nullable(String),\n",
    "            dhash Nullable(String),\n",
    "            analysis_date DateTime64(3, 'UTC')\n",
    "        ) ENGINE = ReplacingMergeTree(analysis_date)\n",
    "        PRIMARY KEY (sha256)\n",
    "        ORDER BY (sha256)\n",
    "    \"\"\")\n",
    "\n",
    "def create_capa_dbtable(client):\n",
    "    # Create sample_capabilities table\n",
    "    client.command(\"\"\"\n",
    "        SET enable_json_type = 1;\n",
    "    \"\"\")\n",
    "    client.command(\"\"\"\n",
    "        -- Base table for CAPA analysis results\n",
    "        CREATE TABLE IF NOT EXISTS redb_capa (\n",
    "            sha256 FixedString(64),\n",
    "            md5 FixedString(32),\n",
    "            sha1 FixedString(40),\n",
    "            analysis_date DateTime64(3, 'UTC'),\n",
    "            -- Store full JSON dumps as strings for flexibility\n",
    "            capa_dump JSON CODEC(ZSTD(3)),\n",
    "            attack_dump JSON CODEC(ZSTD(3)),\n",
    "            mbc_dump JSON CODEC(ZSTD(3))\n",
    "        ) ENGINE = ReplacingMergeTree(analysis_date)\n",
    "        ORDER BY sha256;\n",
    "    \"\"\")\n",
    "\n",
    "    client.command(\"\"\"\n",
    "        -- Normalized table for capabilities and namespaces\n",
    "        CREATE TABLE IF NOT EXISTS redb_capa_capabilities (\n",
    "            sha256 FixedString(64),\n",
    "            md5 FixedString(32),\n",
    "            sha1 FixedString(40),\n",
    "            analysis_date DateTime64(3, 'UTC'),\n",
    "            namespace LowCardinality(String),\n",
    "            capability LowCardinality(String)\n",
    "        ) ENGINE = ReplacingMergeTree(analysis_date)\n",
    "        ORDER BY (sha256, namespace, capability);\n",
    "    \"\"\")\n",
    "\n",
    "    client.command(\"\"\"\n",
    "        -- Materialized view for capability statistics\n",
    "        CREATE MATERIALIZED VIEW IF NOT EXISTS redb_capa_capabilities_stats (\n",
    "            namespace LowCardinality(String),\n",
    "            capability LowCardinality(String),\n",
    "            samples_bitmap AggregateFunction(groupBitmap, UInt64),\n",
    "            occurrence_count UInt64\n",
    "        ) ENGINE = AggregatingMergeTree()\n",
    "        ORDER BY (namespace, capability)\n",
    "        AS SELECT\n",
    "            namespace,\n",
    "            capability,\n",
    "            groupBitmapState(cityHash64(sha256)) as samples_bitmap,\n",
    "            count() as occurrence_count\n",
    "        FROM redb_capa_capabilities\n",
    "        GROUP BY namespace, capability;\n",
    "    \"\"\")\n",
    "\n",
    "    client.command(\"\"\"\n",
    "        -- Normalized table for MITRE ATT&CK mappings\n",
    "        CREATE TABLE IF NOT EXISTS redb_capa_attack (\n",
    "            sha256 FixedString(64),\n",
    "            md5 FixedString(32),\n",
    "            sha1 FixedString(40),\n",
    "            analysis_date DateTime64(3, 'UTC'),\n",
    "            tactic LowCardinality(String),\n",
    "            technique LowCardinality(String),\n",
    "            technique_id LowCardinality(String)\n",
    "        ) ENGINE = ReplacingMergeTree(analysis_date)\n",
    "        ORDER BY (sha256, tactic, technique_id);\n",
    "    \"\"\")\n",
    "\n",
    "    client.command(\"\"\"\n",
    "        -- Materialized view for ATT&CK statistics\n",
    "        CREATE MATERIALIZED VIEW IF NOT EXISTS redb_capa_attack_stats (\n",
    "            tactic LowCardinality(String),\n",
    "            technique LowCardinality(String),\n",
    "            technique_id LowCardinality(String),\n",
    "            samples_bitmap AggregateFunction(groupBitmap, UInt64),\n",
    "            occurrence_count UInt64\n",
    "        ) ENGINE = AggregatingMergeTree()\n",
    "        ORDER BY (tactic, technique_id)\n",
    "        AS SELECT\n",
    "            tactic,\n",
    "            technique,\n",
    "            technique_id,\n",
    "            groupBitmapState(cityHash64(sha256)) as samples_bitmap,\n",
    "            count() as occurrence_count\n",
    "        FROM redb_capa_attack\n",
    "        GROUP BY tactic, technique, technique_id;\n",
    "    \"\"\")\n",
    "\n",
    "    client.command(\"\"\"\n",
    "        -- Normalized table for MBC mappings\n",
    "        CREATE TABLE IF NOT EXISTS redb_capa_mbc (\n",
    "            sha256 FixedString(64),\n",
    "            md5 FixedString(32),\n",
    "            sha1 FixedString(40),\n",
    "            analysis_date DateTime64(3, 'UTC'),\n",
    "            objective LowCardinality(String),\n",
    "            behavior LowCardinality(String),\n",
    "            behavior_id LowCardinality(String)\n",
    "        ) ENGINE = ReplacingMergeTree(analysis_date)\n",
    "        ORDER BY (sha256, objective, behavior_id);\n",
    "    \"\"\")\n",
    "\n",
    "    client.command(\"\"\"\n",
    "        -- Materialized view for MBC statistics\n",
    "        CREATE MATERIALIZED VIEW IF NOT EXISTS redb_capa_mbc_stats (\n",
    "            objective LowCardinality(String),\n",
    "            behavior LowCardinality(String),\n",
    "            behavior_id LowCardinality(String),\n",
    "            samples_bitmap AggregateFunction(groupBitmap, UInt64),\n",
    "            occurrence_count UInt64\n",
    "        ) ENGINE = AggregatingMergeTree()\n",
    "        ORDER BY (objective, behavior_id)\n",
    "        AS SELECT\n",
    "            objective,\n",
    "            behavior,\n",
    "            behavior_id,\n",
    "            groupBitmapState(cityHash64(sha256)) as samples_bitmap,\n",
    "            count() as occurrence_count\n",
    "        FROM redb_capa_mbc\n",
    "        GROUP BY objective, behavior, behavior_id;\n",
    "    \"\"\")\n",
    "\n",
    "def create_die_dbtable(client):\n",
    "    # Create sample_die table\n",
    "    client.command(\"\"\"\n",
    "        SET enable_json_type = 1;\n",
    "    \"\"\")\n",
    "    client.command(\"\"\"\n",
    "        CREATE TABLE IF NOT EXISTS redb_die (\n",
    "            sha256 FixedString(64),\n",
    "            md5 FixedString(32),\n",
    "            sha1 FixedString(40),\n",
    "            die_info JSON CODEC(ZSTD(3)),\n",
    "            analysis_date DateTime64(3, 'UTC')\n",
    "        ) ENGINE = ReplacingMergeTree(analysis_date)\n",
    "        PRIMARY KEY (sha256)\n",
    "        ORDER BY (sha256)\n",
    "    \"\"\")\n",
    "\n",
    "    client.command(\"\"\"\n",
    "        CREATE MATERIALIZED VIEW redb_die_mv\n",
    "        (\n",
    "            sha256 FixedString(64),\n",
    "            md5 FixedString(32),\n",
    "            sha1 FixedString(40),\n",
    "            analysis_date DateTime64(3, 'UTC'),\n",
    "            compiler LowCardinality(Nullable(String)),\n",
    "            compiler_full Nullable(String),\n",
    "            format LowCardinality(Nullable(String)),\n",
    "            format_full Nullable(String),\n",
    "            installer LowCardinality(Nullable(String)),\n",
    "            installer_full Nullable(String),\n",
    "            joiner LowCardinality(Nullable(String)),\n",
    "            joiner_full Nullable(String),\n",
    "            language LowCardinality(Nullable(String)),\n",
    "            language_full Nullable(String),\n",
    "            library LowCardinality(Nullable(String)),\n",
    "            library_full Nullable(String),\n",
    "            linker LowCardinality(Nullable(String)),\n",
    "            linker_full Nullable(String),\n",
    "            operation_system LowCardinality(Nullable(String)),\n",
    "            operation_system_full Nullable(String),\n",
    "            packer LowCardinality(Nullable(String)),\n",
    "            packer_full Nullable(String),\n",
    "            protector LowCardinality(Nullable(String)),\n",
    "            protector_full Nullable(String),\n",
    "            sfx LowCardinality(Nullable(String)),\n",
    "            sfx_full Nullable(String),\n",
    "            sign_tool LowCardinality(Nullable(String)),\n",
    "            sign_tool_full Nullable(String),\n",
    "            stub LowCardinality(Nullable(String)),\n",
    "            stub_full Nullable(String),\n",
    "            tool LowCardinality(Nullable(String)),\n",
    "            tool_full Nullable(String),   \n",
    "            -- overlay JSON CODEC(ZSTD(3)),\n",
    "            -- resource JSON CODEC(ZSTD(3)),\n",
    "            has_overlay UInt8,\n",
    "            has_resources UInt8,\n",
    "            is_packed UInt8\n",
    "        )\n",
    "        ENGINE = ReplacingMergeTree(analysis_date)\n",
    "        ORDER BY (sha256)\n",
    "        POPULATE\n",
    "        AS SELECT\n",
    "            sha256,\n",
    "            md5,\n",
    "            sha1,\n",
    "            analysis_date,\n",
    "            nullIf(JSONExtractString(toString(die_info), 'compiler'), '') AS compiler,\n",
    "            nullIf(JSONExtractString(toString(die_info), 'compiler(full)'), '') AS compiler_full,\n",
    "            nullIf(JSONExtractString(toString(die_info), 'format'), '') AS format,\n",
    "            nullIf(JSONExtractString(toString(die_info), 'format(full)'), '') AS format_full,\n",
    "            nullIf(JSONExtractString(toString(die_info), 'installer'), '') AS installer,\n",
    "            nullIf(JSONExtractString(toString(die_info), 'installer(full)'), '') AS installer_full,\n",
    "            nullIf(JSONExtractString(toString(die_info), 'joiner'), '') AS joiner,\n",
    "            nullIf(JSONExtractString(toString(die_info), 'joiner(full)'), '') AS joiner_full,\n",
    "            nullIf(JSONExtractString(toString(die_info), 'language'), '') AS language,\n",
    "            nullIf(JSONExtractString(toString(die_info), 'language(full)'), '') AS language_full,\n",
    "            nullIf(JSONExtractString(toString(die_info), 'library'), '') AS library,\n",
    "            nullIf(JSONExtractString(toString(die_info), 'library(full)'), '') AS library_full,\n",
    "            nullIf(JSONExtractString(toString(die_info), 'linker'), '') AS linker,\n",
    "            nullIf(JSONExtractString(toString(die_info), 'linker(full)'), '') AS linker_full,\n",
    "            nullIf(JSONExtractString(toString(die_info), 'operation_system'), '') AS operation_system,\n",
    "            nullIf(JSONExtractString(toString(die_info), 'operation_system(full)'), '') AS operation_system_full,\n",
    "            nullIf(JSONExtractString(toString(die_info), 'packer'), '') AS packer,\n",
    "            nullIf(JSONExtractString(toString(die_info), 'packer(full)'), '') AS packer_full,\n",
    "            nullIf(JSONExtractString(toString(die_info), 'protector'), '') AS protector,\n",
    "            nullIf(JSONExtractString(toString(die_info), 'protector(full)'), '') AS protector_full,\n",
    "            nullIf(JSONExtractString(toString(die_info), 'sfx'), '') AS sfx,\n",
    "            nullIf(JSONExtractString(toString(die_info), 'sfx(full)'), '') AS sfx_full,\n",
    "            nullIf(JSONExtractString(toString(die_info), 'sign_tool'), '') AS sign_tool,\n",
    "            nullIf(JSONExtractString(toString(die_info), 'sign_tool(full)'), '') AS sign_tool_full,\n",
    "            nullIf(JSONExtractString(toString(die_info), 'stub'), '') AS stub,\n",
    "            nullIf(JSONExtractString(toString(die_info),