Xiaogang Lin - RankMe

Year	Rank	Type	Title / Venue / Authors
2025	J	`jnl`	An Extended Model Predictive Control for PMSM With Minimum Ripples and Small Runtimes. IEEE Trans. Ind. Electron. Kaiyuan Huang, Xiaogang Lin, Thomas Wu, Tao Luo, Wei Wang, Tianhao Liu, Dongdong Zhang
2025	J	`jnl`	Customer and provider bounded rationality in on-demand service platforms. Eur. J. Oper. Res. Danna Chen, Yong-Wu Zhou, Xiaogang Lin, Kangning Jin
2025	J	`jnl`	Decision-making and coordination in the contract-farming supply chain with fairness concern and output uncertainty. INFOR Inf. Syst. Oper. Res. Qiang Lin, Jiali Feng, Yongqi Zhu, Lu Xiao, Xiaogang Lin
2025	J	`jnl`	Horizontal mergers between public and private firms in vertically-differentiated markets. J. Oper. Res. Soc. Xiaogang Lin, Hailing Huang, Qiang Lin
2025	J	`jnl`	Knowledge-driven federated learning: A systematic literature review on approaches, challenges, and prospects. J. Supercomput. Xiaogang Lin, Xiaoli Zhao, Zilong Yin, Hao Pan, Panzhao Jing, Weishan Li, Kangwei Wang, Yincan Shu
2025	J	`jnl`	Mergers Between On-Demand Service Platforms: The Impact on Consumer Surplus and Labor Welfare. Inf. Syst. Res. Xiaogang Lin, Tao Lu, Xin Wang, Gang Kou
2025	Misc	`conf`	Meta-Conscious Driven Domain-Aware Federated Learning. ICASSP Zilong Yin, Haoyu Wang, Xiaogang Lin, Xin Zhang, Bin Chen, Chenyu Zhou
2025	J	`jnl`	Recruiting without-car drivers through multiple sources: the impact on a ride-sharing platform's driver surplus and consumer surplus. Int. Trans. Oper. Res. Qiang Lin, Jiaxin Zhai, Kangning Jin, Xiaogang Lin
2025	J	`jnl`	Research Progress on Molecularly Imprinted Polymer-Aptasensors for Food Safety Detection. Symmetry Jiuyi Wang, Xiaogang Lin, Jinyu Wu, Xiao Lv, Binji Dai, Ke Wang, Jayne Wu
2025	J	`jnl`	Retailer information sharing with green manufacturer encroachment in a hybrid supply chain. Int. Trans. Oper. Res. Xiaogang Lin, Ying Zhu, Zhangzheng Lin, Wenzhuo Li, Qiang Lin
2024	J	`jnl`	A survey of multimodal federated learning: background, applications, and perspectives. Multim. Syst. Hao Pan, Xiaoli Zhao, Lipeng He, Yicong Shi, Xiaogang Lin
2024	J	`jnl`	ACEK Biosensor for the Minute-Scale Quantification of Breast Cancer ctDNA. Sensors Ke Wang, Xiaogang Lin, Maoxiao Zhang, Mengjie Yang, Xiang Shi, Mingna Xie, Yang Luo
2024	J	`jnl`	Advancements in Chemical and Biosensors for Point-of-Care Detection of Acrylamide. Sensors Mingna Xie, Xiao Lv, Ke Wang, Yong Zhou, Xiaogang Lin
2024	J	`jnl`	Asset-light or asset-heavy? Implications for ride-hailing platforms' profits, consumer surplus, and driver surplus. Comput. Ind. Eng. Xiaogang Lin, Kangning Jin, Qiang Lin, Yong-Wu Zhou, Wenhui Fu
2024	J	`jnl`	Federated semi-supervised representation augmentation with cross-institutional knowledge transfer for healthcare collaboration. Knowl. Based Syst. Zilong Yin, Haoyu Wang, Bin Chen, Xin Zhang, Xiaogang Lin, Hangling Sun, Anji Li, Chenyu Zhou
2024	—	`conf`	Humidity Detection Based on Inorganic Topological Insulator Bi2Se3-Organic PEO Composite Film. IEEE SENSORS Mengqing Wang, Yongcai Guoa, Xiaogang Lin, Lei Xiea, Cheng Zou, Hongping Liang, Yong Zhou
2024	J	`jnl`	Information sharing and production mode selection with price and quality competition. Int. Trans. Oper. Res. Qiang Lin, Wenzhuo Li, Xiaogang Lin, Wenhui Fu
2024	J	`jnl`	Sales model and logistics selections for a manufacturer considering carbon emission and logistics levels. RAIRO Oper. Res. Xin Liu, Xiaojun Wu, Xiaogang Lin
2023	J	`jnl`	An Improved Parallel Predictive Torque Control for Permanent Magnet Synchronous Motor. IEEE Access Xiaocan Wang, Xiaogang Lin, Qian Huang, Wei Xie
2023	C	`conf`	Field Oriented Control Strategy for Five-Phase Self-Excited Synchronous Motor Based on Injecting High-Frequency Current. IECON Xiaocan Wang, Zeliang Xiong, Huafeng Jiang, Yudong Li, Xiaogang Lin, Wei Xie
2023	J	`jnl`	Review of Chemical Sensors for Hydrogen Sulfide Detection in Organisms and Living Cells. Sensors Mengjie Yang, Yong Zhou, Ke Wang, Chunfeng Luo, Mingna Xie, Xiang Shi, Xiaogang Lin
2022	J	`jnl`	A Novel Stator Wound Field Flux Switching Machine With the Combination of Overlapping Armature Winding and Asymmetric Stator Poles. IEEE Trans. Ind. Electron. Wen Jiang, Wenxin Huang, Xiaogang Lin, Yong Zhao, Xu Wu, Yajun Zhao, Dingfeng Dong, Xuefeng Jiang
2022	J	`jnl`	Horizontal mergers in low carbon manufacturing. Eur. J. Oper. Res. Xiaogang Lin, Danna Chen, Yong-Wu Zhou, Qiang Lin
2022	J	`jnl`	Impact of quality decisions on information sharing with supplier encroachment. RAIRO Oper. Res. Rui Hou, Weijian Li, Xiaogang Lin, You Zhao
2022	J	`jnl`	Two-period information-sharing and quality decision in a supply chain under static and dynamic wholesale pricing strategies. Int. Trans. Oper. Res. You Zhao, Rui Hou, Xiaogang Lin, Qiang Lin
2021	J	`jnl`	A Fault-Tolerant Machine Based on Radial-Flux Dual Stator and Parallel Permanent-Magnet/Reluctance Structure. IEEE Trans. Ind. Electron. Yong Zhao, Wenxin Huang, Wen Jiang, Xiaogang Lin, Dingfeng Dong
2021	J	`jnl`	Analysis of Rotor Poles and Armature Winding Configurations Combinations of Wound Field Flux Switching Machines. IEEE Trans. Ind. Electron. Wen Jiang, Wenxin Huang, Xiaogang Lin, Yong Zhao, Shanfeng Zhu
2021	J	`jnl`	Direct Torque Control for Induction Motors Based on Minimum Voltage Vector Error. IEEE Trans. Ind. Electron. Xu Wu, Wenxin Huang, Xiaogang Lin, Wen Jiang, Yong Zhao, Shanfeng Zhu
2021	J	`jnl`	Impact of a "Buy-online-and-pickup-in-store" Channel on Price and Quality Decisions in a Supply Chain. Eur. J. Oper. Res. Xiaogang Lin, Yong-Wu Zhou, Rui Hou
2021	J	`jnl`	Pricing strategy for logistics service platforms with competition and user distance preference. Int. Trans. Oper. Res. Rui Hou, Liang Li, Xiaogang Lin, Yong Zha, You Zhao
2021	J	`jnl`	Rapid and Sensitive Detection of miRNA Based on AC Electrokinetic Capacitive Sensing for Point-of-Care Applications. Sensors Nan Wan, Yu Jiang, Jiamei Huang, Rania Oueslati, Shigetoshi Eda, Jayne Wu, Xiaogang Lin
2020	J	`jnl`	Pricing Strategies of Unbundling and Mixed-Bundling in a Two-Sided Market Under Stochastic Demand. Asia Pac. J. Oper. Res. Xiaogang Lin, Yong-Wu Zhou, Qiang Lin
2020	J	`jnl`	Pricing and Product-bundling Strategies for E-commerce Platforms with Competition. Eur. J. Oper. Res. Xiaogang Lin, Yong-Wu Zhou, Wei Xie, Yuanguang Zhong, Bin Cao
2019	—	`conf`	An Improved 24/14 Poles Stator Wound-Field Flux-Switching DC Generator Based on Virtual Coil Flux Linkages. ISIE Wen Jiang, Wenxin Huang, Xiaogang Lin, Dingfeng Dong, Yong Zhao
2019	J	`jnl`	Control of Five-Phase Dual Stator-Winding Induction Generator With an Open Phase. IEEE Trans. Ind. Electron. Haijun Xu, Wenxin Huang, Feifei Bu, Haozhe Liu, Xiaogang Lin
2019	—	`conf`	Position Sensorless Direct Torque Control for PMSM Based on Pulse High Frequency Stator Flux Injection at Low Speed. ISIE Xiaogang Lin, Wenxin Huang, Wen Jiang
2019	J	`jnl`	Pricing policy selection for a platform providing vertically differentiated services with self-scheduling capacity. J. Oper. Res. Soc. Xiaogang Lin, Yong-Wu Zhou
2019	—	`conf`	Serologic Diagnosis of Taenia Solium Cysticercosis through Linear Unmixing Analysis of Biosignals from ACEK Capacitive Sensing Method. EMBC Jia Liang, Fanqi Wang, Xiaogang Lin, Hairong Qi, Jayne Wu
2014	J	`jnl`	Research on the Interaction between Tubeimoside 1 and HepG2 Cells Using the Microscopic Imaging and Fluorescent Spectra Method. Comput. Math. Methods Medicine Xiaogang Lin, Wenchao Li, Changbin Ye, Xiaozhu Liu, Hao Zhu, Wenbing Peng, Jie Rong

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