Inder S. Gopal

Year	Rank	Type	Title / Venue / Authors
1999	J	`jnl`	Fast broadcast in high-speed networks. IEEE/ACM Trans. Netw. Ajei S. Gopal, Inder S. Gopal, Shay Kutten
1997	J	`jnl`	Efficient On-Line Call Control Algorithms. J. Algorithms Juan A. Garay, Inder S. Gopal, Shay Kutten, Yishay Mansour, Moti Yung
1995	J	`jnl`	A distributed control architecture of high-speed networks. IEEE Trans. Commun. Israel Cidon, Inder S. Gopal, Marc A. Kaplan, Shay Kutten
1995	J	`jnl`	ARQ Protocols for High Speed Hardware Implementation. Comput. Networks ISDN Syst. Inder S. Gopal, Raphael Rom
1995	J	`jnl`	New models and algorithms for future networks. IEEE Trans. Inf. Theory Israel Cidon, Inder S. Gopal, Shay Kutten
1995	J	`jnl`	Overview of the NBBS Architecture. IBM Syst. J. Gerald A. Marin, C. Paul Immanuel, Phillip F. Chimento Jr., Inder S. Gopal
1995	J	`jnl`	The KryptoKnight family of light-weight protocols for authentication and key distribution. IEEE/ACM Trans. Netw. Ray Bird, Inder S. Gopal, Amir Herzberg, Philippe A. Janson, Shay Kutten, Refik Molva, Moti Yung
1994	J	`jnl`	Fault tolerant queries in computer networks. IEEE Trans. Commun. Alan E. Baratz, Inder S. Gopal, Adrian Segall
1994	J	`jnl`	Multicasting to multiple groups over broadcast channels. IEEE Trans. Commun. Inder S. Gopal, Raphael Rom
1994	A*	`conf`	Multimedia Networking: Applications and Challenges. PODC Inder S. Gopal
1994	J	`jnl`	Network transparency the plaNET approach. IEEE/ACM Trans. Netw. Inder S. Gopal, Roch Guérin
1993	J	`jnl`	Congestion control through input rate regulation. IEEE Trans. Commun. Moshe Sidi, Wen-Zu Liu, Israel Cidon, Inder S. Gopal
1993	J	`jnl`	Connection establishment in high-speed networks. IEEE/ACM Trans. Netw. Israel Cidon, Inder S. Gopal, Adrian Segall
1993	—	`conf`	Efficient On-Line Call Control Algorithms. ISTCS Juan A. Garay, Inder S. Gopal, Shay Kutten, Yishay Mansour, Moti Yung
1993	J	`jnl`	Systematic Design of a Family of Attack-Resistant Authentication Protocols. IEEE J. Sel. Areas Commun. Ray Bird, Inder S. Gopal, Amir Herzberg, Philippe A. Janson, Shay Kutten, Refik Molva, Moti Yung
1993	J	`jnl`	The AURORA Gigabit Testbed. Comput. Networks ISDN Syst. David D. Clark, Bruce S. Davie, David J. Farber, Inder S. Gopal, Bharath K. Kadaba, W. David Sincoskie, Jonathan M. Smith, David L. Tennenhouse
1993	J	`jnl`	The plaNET/ORBIT High Speed Network. J. High Speed Networks Israel Cidon, Inder S. Gopal, Prabandham M. Gopal, Roch Guérin, James P. Janniello, Marc A. Kaplan
1992	J	`jnl`	A Critique of ATM from a Data Communications Perspective. J. High Speed Networks Israel Cidon, Jeff Derby, Inder S. Gopal, Bharath K. Kadaba
1992	J	`jnl`	ATM support in a transparent network. IEEE Netw. Inder S. Gopal, Roch Guérin, James P. Janniello, Vasilios Theoharakis
1992	A*	`conf`	An Overview of the AURORA Gigabit Testbed. INFOCOM David D. Clark, David L. Tennenhouse, David J. Farber, Jonathan M. Smith, Bruce S. Davie, W. David Sincoskie, Inder S. Gopal, Bharath K. Kadaba
1992	A*	`conf`	Call Preemption in Communication Networks. INFOCOM Juan A. Garay, Inder S. Gopal
1992	A*	`conf`	Network Transparency: The plaNET Approach. INFOCOM Inder S. Gopal, Roch Guérin
1991	J	`jnl`	Bandwidth management and congestion control in plaNET. IEEE Commun. Mag. Israel Cidon, Inder S. Gopal, Roch Guérin
1991	A*	`conf`	Hardware Flooding (preliminary version). SIGCOMM Ajei S. Gopal, Inder S. Gopal, Shay Kutten
1991	J	`jnl`	Incremental time-slot assignment in SS/TDMA satellite systems. IEEE Trans. Commun. Maurizio A. Bonuccelli, Inder S. Gopal, C. K. Wong
1991	A*	`conf`	Systematic Design of Two-Party Authentication Protocols. CRYPTO Ray Bird, Inder S. Gopal, Amir Herzberg, Philippe A. Janson, Shay Kutten, Refik Molva, Moti Yung
1990	A*	`conf`	Broadcast in Fast Networks. INFOCOM Ajei S. Gopal, Inder S. Gopal, Shay Kutten
1990	A*	`conf`	Distributed Control for PARIS. PODC Baruch Awerbuch, Israel Cidon, Inder S. Gopal, Marc A. Kaplan, Shay Kutten
1990	J	`jnl`	Dynamic Detection of Subgraphs in Computer Networks. Algorithmica Israel Cidon, Inder S. Gopal
1990	A*	`conf`	Fast Connection Establishment in High Speed Networks. SIGCOMM Israel Cidon, Inder S. Gopal, Adrian Segall
1990	A*	`conf`	Improving ARQ Protocol Performance By Multiple FIFO Buffers. INFOCOM Inder S. Gopal, Raphael Rom
1990	—	`conf`	Optimal Computation of Global Sensitive Functions in Fast Networks. WDAG Israel Cidon, Inder S. Gopal, Shay Kutten
1990	J	`jnl`	Synchronizing asynchronous bounded delay networks. IEEE Trans. Commun. Ching-Tsun Chou, Israel Cidon, Inder S. Gopal, Shmuel Zaks
1989	J	`jnl`	Directories for Networks with Casually Connected Users. Comput. Networks ISDN Syst. Inder S. Gopal, Adrian Segall
1989	J	`jnl`	Distributed Name Assignment in Computer Networks. Comput. Networks Adrian Segall, Inder S. Gopal
1989	J	`jnl`	Editor's Foreword: Special Issue on Algorithmic Aspects of Communications. Algorithmica Israel Cidon, Inder S. Gopal
1989	J	`jnl`	Linear Broadcast Routing. J. Algorithms Ching-Tsun Chou, Inder S. Gopal
1988	A*	`conf`	Directories for networks with casually connected users. INFOCOM Inder S. Gopal, Adrian Segall
1988	C	`conf`	Memory requirements for a fast packet switching node. ICCC Israel Cidon, Inder S. Gopal, George A. Grover, Moshe Sidi
1988	A*	`conf`	New Models and Algorithms for Future Networks. PODC Israel Cidon, Inder S. Gopal, Shay Kutten
1988	J	`jnl`	Real-time packet switching: a performance analysis. IEEE J. Sel. Areas Commun. Israel Cidon, Inder S. Gopal, George A. Grover, Moshe Sidi
1987	—	`conf`	Fault Tolerant Queries in Computer Networks. WDAG Alan E. Baratz, Inder S. Gopal, Adrian Segall
1987	—	`conf`	Synchronizing Aysnchronous Bounded Delay Networks. WDAG Ching-Tsun Chou, Israel Cidon, Inder S. Gopal, Shmuel Zaks
1986	—	`conf`	Distributed Resource Sharing in Computer Networks. FSTTCS Inder S. Gopal, Parviz Kermani
1986	J	`jnl`	Dynamic Address Assignment in Broadcast Networks. IEEE Trans. Commun. Inder S. Gopal, Adrian Segall
1985	J	`jnl`	Minimizing the Number of Switchings in an SS/TDMA System. IEEE Trans. Commun. Inder S. Gopal, C. K. Wong
1985	J	`jnl`	Prevention of Store-and-Forward Deadlock in Computer Networks. IEEE Trans. Commun. Inder S. Gopal
1984	A*	`conf`	Dynamic Address Assignment Protocols. INFOCOM Inder S. Gopal, Adrian Segall
1984	J	`jnl`	Point-To-Multipoint Communication Over Broadcast Links. IEEE Trans. Commun. Inder S. Gopal, Jeffrey M. Jaffe
1983	J	`jnl`	Optimal Wiring of Movable Terminals. IEEE Trans. Computers Inder S. Gopal, Don Coppersmith, C. K. Wong
1983	J	`jnl`	Performance of stop-and-wait protocols over high-delay links. Comput. Commun. Inder S. Gopal, Parviz Kermani
1983	J	`jnl`	Scheduling in Multibeam Satellites with Interfering Zones. IEEE Trans. Commun. Inder S. Gopal, Maurizio A. Bonuccelli, C. K. Wong
1982	J	`jnl`	An Optimal Switching Algorithm for Multibeam Satellite Systems with Variable Bandwidth Beams. IEEE Trans. Commun. Inder S. Gopal, Giancarlo Bongiovanni, Maurizio A. Bonuccelli, Donald T. Tang, C. K. Wong
1982	J	`jnl`	Minimizing Packet Waiting Time in a Multibeam Satellite System. IEEE Trans. Commun. Inder S. Gopal, Don Coppersmith, C. K. Wong

{
 "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),