Xiaolei Wang

41 papers B 7C 6Misc 1Journal 18Unranked 7
YearRankTypeTitle / Venue / Authors
2022 J jnl
Parameter optimization of control system design for uncertain wireless power transfer systems using modified genetic algorithm.
CAAI Trans. Intell. Technol.
Xudong Gao, Wenjie Cao, Qiang Yang, Honglin Wang, Xiaolei Wang, Guang Jin, Jun Zhang
2015 J jnl
A memetic-inspired harmony search method in optimal wind generator design.
Int. J. Mach. Learn. Cybern.
Xiao Zhi Gao, Xiaolei Wang, Kai Zenger
2015 J jnl
Harmony Search Method: Theory and Applications.
Comput. Intell. Neurosci.
Xiao Zhi Gao, Govindasamy Vaiyapuri, He Xu, Xiaolei Wang, Kai Zenger
2014 J jnl
A Hybrid Optimization Method Based on differential Evolution and Harmony Search.
Int. J. Comput. Intell. Appl.
Xiao Zhi Gao, Xiaolei Wang, Seppo J. Ovaska, Kai Zenger
2014 J jnl
Motor fault diagnosis using negative selection algorithm.
Neural Comput. Appl.
Xiao Zhi Gao, Xiaolei Wang, Kai Zenger
2014 J jnl
Optimal Classification of Epileptic EEG Signals Using Neural Networks and Harmony Search Methods.
J. Softw.
Xiao Zhi Gao, Jing Wang, Jarno M. A. Tanskanen, Rongfang Bie, Xiaolei Wang, Ping Guo, Kai Zenger
2013 J jnl
A modified harmony search method for wind generator design.
Int. J. Bio Inspired Comput.
Xiao Zhi Gao, Xiaolei Wang, Kai Zenger
2013 C conf
Harmony Search method-based multi-modal optimal design of a wind generator.
IECON
Xiao Zhi Gao, Xiaolei Wang, Kai Zenger, Xiaofeng Wang, Jun Zhang
2012 C conf
A Modified PSO Method Based on Cultural Algorithm and Quantum Computing.
CIS
Xiao Zhi Gao, Ying Wu, Xiaolei Wang, Xianlin Huang, Kai Zenger, Xiaofeng Wang
2012 C conf
A Niching Harmony Search Method for Multi-modal Optimization.
CIS
Xiao Zhi Gao, Xiaolei Wang, Kai Zenger, Xiaofeng Wang
2012 B conf
A bee foraging-based memetic Harmony Search method.
SMC
Xiao Zhi Gao, Xiaolei Wang, Kai Zenger, Xiaofeng Wang
2012 J jnl
A hybrid PBIL-based harmony search method.
Neural Comput. Appl.
Xiao Zhi Gao, Xiaolei Wang, Tapani Jokinen, Seppo J. Ovaska, Antero Arkkio, Kai Zenger
2012 B conf
A multiple local search strategy in memetic evolutionary computation for Multi-objective Robust Control Design.
SMC
Jiaqi Liu, Xiao Zhi Gao, Xiaolei Wang, Kai Zenger
2012 B conf
A novel Harmony Search method with dual memory.
SMC
Xiao Zhi Gao, Xiaolei Wang, Kai Zenger, Xiaofeng Wang
2011 Misc conf
A Negative Selection Algorithm-based motor fault detection scheme.
ICNC
Xiao Zhi Gao, Xiaolei Wang, Seppo J. Ovaska, Antero Arkkio, Kai Zenger, Xiaofeng Wang
2010 — conf
A Harmony Search-Based Differential Evolution Method.
CSE
Xiao Zhi Gao, Xiaolei Wang, Seppo J. Ovaska
2010 — conf
A Hybrid Harmony Search Method Based on OBL.
CSE
Xiao Zhi Gao, Xiaolei Wang, Seppo J. Ovaska
2010 — conf
A hybrid PBIL-based Harmony Search method with application in wind generator optimization.
NaBIC
Xiao Zhi Gao, Tapani Jokinen, Xiaolei Wang, Seppo J. Ovaska, Antero Arkkio
2010 J jnl
A simplified linguistic information feedback-based dynamical fuzzy system.
Neural Comput. Appl.
Xiao Zhi Gao, Seppo J. Ovaska, Xiaolei Wang
2010 J jnl
Multi-Level Optimization Of Negative Selection Algorithm Detectors With Application In Motor Fault Detection.
Intell. Autom. Soft Comput.
Xiao Zhi Gao, Seppo J. Ovaska, Xiaolei Wang, Mo-Yuen Chow
2009 J jnl
A Hybrid Artificial Immune Optimization Method.
Int. J. Comput. Intell. Syst.
Xiaolei Wang, Xiao Zhi Gao, Seppo J. Ovaska
2009 J jnl
A linguistic information feed-back-based dynamical fuzzy system (LIFBDFS) with learning algorithm.
Neural Comput. Appl.
Xiao Zhi Gao, Seppo J. Ovaska, Xiaolei Wang
2009 J jnl
Clonal optimization-based negative selection algorithm with applications in motor fault detection.
Neural Comput. Appl.
Xiao Zhi Gao, Seppo J. Ovaska, Xiaolei Wang, Mo-Yuen Chow
2009 J jnl
Fusion of clonal selection algorithm and differential evolution method in training cascade-correlation neural network.
Neurocomputing
Xiao Zhi Gao, Xiaolei Wang, Seppo J. Ovaska
2009 J jnl
Fusion of clonal selection algorithm and harmony search method in optimisation of fuzzy classification systems.
Int. J. Bio Inspired Comput.
Xiaolei Wang, Xiao Zhi Gao, Seppo J. Ovaska
2009 — —
Hybrid nature-inspired computation methods for optimization.
Xiaolei Wang
2009 J jnl
Re-editing and Censoring of Detectors in Negative Selection Algorithm.
Int. J. Comput. Intell. Syst.
Xiao Zhi Gao, Seppo J. Ovaska, Xiaolei Wang
2008 C conf
A Hybrid Optimization Method for Fuzzy Classification Systems.
HIS
Xiaolei Wang, Xiao Zhi Gao, Seppo J. Ovaska
2008 C conf
A Novel Hybrid Optimization Method with Application in Cascade-Correlation Neural Network Training.
HIS
Xiao Zhi Gao, Xiaolei Wang, Seppo J. Ovaska
2008 J jnl
A neural networks-based negative selection algorithm in fault diagnosis.
Neural Comput. Appl.
Xiao Zhi Gao, Seppo J. Ovaska, Xiaolei Wang, Mo-Yuen Chow
2008 C conf
Modified Harmony Search Methods for Uni-Modal and Multi-Modal Optimization.
HIS
Xiao Zhi Gao, Xiaolei Wang, Seppo J. Ovaska
2008 — ch.
Negative Selection Algorithm with Applications in Motor Fault Detection.
Soft Computing Applications in Industry
Xiao Zhi Gao, Seppo J. Ovaska, Xiaolei Wang
2007 J jnl
A Hybrid Optimization Algorithm Based on Ant Colony and Immune Principles.
Int. J. Comput. Sci. Appl.
Xiaolei Wang, Xiao Zhi Gao, Seppo J. Ovaska
2007 B conf
An immune-based ant colony algorithm for static and dynamic optimization.
SMC
Xiaolei Wang, Xiao Zhi Gao, Seppo J. Ovaska
2007 B conf
Particle Swarm Optimization of detectors in Negative Selection Algorithm.
SMC
Xiao Zhi Gao, Seppo J. Ovaska, Xiaolei Wang
2006 B conf
A Hybrid Particle Swarm Optimization Method.
SMC
Xiaolei Wang, Xiao Zhi Gao, Seppo J. Ovaska
2006 B conf
Clonal Optimization of Negative Selection Algorithm with Applications in Motor Fault Detection.
SMC
Xiao Zhi Gao, Seppo J. Ovaska, Xiaolei Wang, Mo-Yuen Chow
2006 — conf
Don't Touch Me, I'm Fine: Robot Autonomy Using an Artificial Innate Immune System.
ICARIS
Mark James Neal, Jan Feyereisl, Rosario Rascunà, Xiaolei Wang
2004 — conf
Artificial immune optimization methods and applications - a survey.
SMC (4)
Xiaolei Wang, Xiao Zhi Gao, Seppo J. Ovaska
2004 — conf
Learning algorithm for linguistic information feedback-based dynamical fuzzy system (LIFDFS).
SMC (3)
Xiao Zhi Gao, Seppo J. Ovaska, Xiaolei Wang
2004 — conf
Neural networks-based negative selection algorithm with applications in fault diagnosis.
SMC (4)
Xiao Zhi Gao, Seppo J. Ovaska, Xiaolei Wang, Mo-Yuen Chow
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),