Cai Yi

33 papers Journal 29Unranked 4
YearRankTypeTitle / Venue / Authors
2026 J jnl
An unsupervised domain adaptation method for intelligent fault diagnosis based on target feature enhancement and feature-boundary alignment.
J. Intell. Manuf.
Ming Xie, Jianxin Liu, Yifan Li, Cai Yi
2025 J jnl
A Data-Driven Dynamics Simulation Model for Railway Vehicles Based on Lightweight 3DCNN With Physics-Informed Constraints.
IEEE Trans. Intell. Transp. Syst.
Zhiwei Zheng, Cai Yi, Jianhui Lin
2025 J jnl
A Multiscale Pooling Attention-Based Graph Attention Network for Remaining Useful Life Prediction.
IEEE Trans. Instrum. Meas.
Jiayin Tang, Yonghao Miao, Yu Xia, Qiuyang Zhou, Cai Yi
2025 J jnl
AGFCN:A bearing fault diagnosis method for high-speed train bogie under complex working conditions.
Reliab. Eng. Syst. Saf.
Deqiang He, Jinxin Wu, Zhenzhen Jin, Chenggeng Huang, Zexian Wei, Cai Yi
2025 J jnl
Acoustic Fault Diagnosis Method for Rotating Machinery Based on Collaborative Perception Information Aggregation Guidance Network.
Int. J. Comput. Intell. Syst.
Chaofan Li, Fan Zhang, Qichen Wang, Yufei Han, Tianrui Li, Fei Teng, Cai Yi, Yongmeng Wu
2025 J jnl
Bogie key components fault diagnosis utilizing multi-sensor tensor graphs and dual-attribute feature selection.
Eng. Appl. Artif. Intell.
Zexian Wei, Deqiang He, Zhenzhen Jin, Haimeng Sun, Jinxin Wu, Sheng Shan, Jian Miao, Cai Yi
2025 J jnl
DCAGGCN: A novel method for remaining useful life prediction of bearings.
Reliab. Eng. Syst. Saf.
Deqiang He, Jiayang Zhao, Zhenzhen Jin, Chenggeng Huang, Cai Yi, Jinxin Wu
2025 J jnl
Integrating Demodulation Techniques With Multisource Transfer Learning for Intelligent Fault Diagnosis of Bearings.
IEEE Trans. Instrum. Meas.
Guiting Tang, Chunjun Chen, Yifan Li, Lei Liu, Cai Yi, Jianhui Lin
2025 J jnl
Neural Network Integrated With Classical Signal Processing Techniques for Generating Optimized Square Envelope Spectrum and Its Application in Machine Condition Monitoring.
IEEE Trans. Instrum. Meas.
Liu He, Xinlun Li, Qiuyang Zhou, Cai Yi, Yifan Li
2024 J jnl
A parallel ensemble optimization and transfer learning based intelligent fault diagnosis framework for bearings.
Eng. Appl. Artif. Intell.
Guiting Tang, Cai Yi, Lei Liu, Du Xu, Qiuyang Zhou, Yongxu Hu, Pengcheng Zhou, Jianhui Lin
2024 J jnl
Cyclostationary harmonic product spectrum with its application for rolling bearing fault resonance frequency band adaptive location.
Expert Syst. Appl.
Cai Yi, Weihao Zhang, Hu Cao, Lei Yan, Qiuyang Zhou, Ying Shi, Guiting Tang, Le Ran, Jianhui Lin
2024 J jnl
Dictionary Learning Method for Cyclostationarity Maximization and Its Application to Bearing Fault Feature Extraction.
IEEE Trans. Instrum. Meas.
Weihao Zhang, Cai Yi, Lei Yan, Qi Liu, Qiuyang Zhou, Pengfei He, Le Ran, Yunzhi Lin
2024 J jnl
Direct Denoising of Fault Signal for Train Bogie Bearing Under Speed Change Condition.
IEEE Trans. Veh. Technol.
Zexian Wei, Deqiang He, Zhenzhen Jin, Haimeng Sun, Sheng Shan, Chang Liu, Cai Yi
2024 J jnl
Multi-Node Feature Learning Network Based on Maximum Spectral Harmonics-to-Noise Ratio Deconvolution for Machine Condition Monitoring.
IEEE Trans Autom. Sci. Eng.
Qiuyang Zhou, Cai Yi, Lei Yan, Chenguang Huang, Xinwu Song, Du Xu, Lu Zhou, Jianhui Lin
2023 J jnl
A Blind Deconvolution Approach Based on Spectral Harmonics-to-Noise Ratio for Rotating Machinery Condition Monitoring.
IEEE Trans Autom. Sci. Eng.
Qiuyang Zhou, Cai Yi, Lei Yan, Chenguang Huang, Jianhui Lin
2023 J jnl
A novel transfer learning network with adaptive input length selection and lightweight structure for bearing fault diagnosis.
Eng. Appl. Artif. Intell.
Guiting Tang, Cai Yi, Lei Liu, Xingguo Yang, Du Xu, Qiuyang Zhou, Jianhui Lin
2023 J jnl
An Adaptive Harmonic Product Spectrum for Rotating Machinery Fault Diagnosis.
IEEE Trans. Instrum. Meas.
Cai Yi, Hao Wang, Qiuyang Zhou, Qiwei Hu, Pengcheng Zhou, Jianhui Lin
2023 J jnl
Integrating adaptive input length selection strategy and unsupervised transfer learning for bearing fault diagnosis under noisy conditions.
Appl. Soft Comput.
Guiting Tang, Cai Yi, Lei Liu, Zhan Xing, Qiuyang Zhou, Jianhui Lin
2023 J jnl
Multi-Objective Sparsity Maximum Mode De-Composition: A New Method for Rotating Machine Fault Diagnosis on High-Speed Train Axle Box.
IEEE Trans. Veh. Technol.
Qiuyang Zhou, Cai Yi, Lei Yan, Xinwu Song, Du Xu, Chenguang Huang, Lu Zhou, Jianhui Lin
2023 J jnl
Unsupervised transfer learning for intelligent health status identification of bearing in adaptive input length selection.
Eng. Appl. Artif. Intell.
Guiting Tang, Lei Liu, Yirong Liu, Cai Yi, Yongxu Hu, Du Xu, Qiuyang Zhou, Jianhui Lin
2022 J jnl
Fast Convolutional Sparse Dictionary Learning Based on LocOMP and Its Application to Bearing Fault Detection.
IEEE Trans. Instrum. Meas.
Liu He, Cai Yi, Qiuyang Zhou, Jianhui Lin
2021 J jnl
Blind Deconvolution Technique Based on Improved Correlated Generalized Lp/Lq Norm for Extracting Repetitive Transient Feature.
IEEE Trans. Instrum. Meas.
Qiuyang Zhou, Yuhui Zhang, Jiayin Tang, Jianhui Lin, Liu He, Cai Yi
2021 J jnl
Correction to "High-Speed Rail Suspension System Health Monitoring Using Multi-Location Vibration Data".
IEEE Trans. Intell. Transp. Syst.
Ning Hong, Lishuai Li, Weiran Yao, Yang Zhao, Cai Yi, Jianhui Lin, Kwok Leung Tsui
2021 J jnl
Extracting cyclo-stationarity of repetitive transients from envelope spectrum based on prior-unknown blind deconvolution technique.
Signal Process.
Liu He, Dong Wang, Cai Yi, Qiuyang Zhou, Jianhui Lin
2020 J jnl
High-Speed Rail Suspension System Health Monitoring Using Multi-Location Vibration Data.
IEEE Trans. Intell. Transp. Syst.
Ning Hong, Lishuai Li, Weiran Yao, Yang Zhao, Cai Yi, Jianhui Lin, Kwok Leung Tsui
2018 — conf
Condition monitoring of wheel wear for high-speed trains: A data-driven approach.
ICPHM
Peiwen Xu, Weiran Yao, Yang Zhao, Cai Yi, Lishuai Li, Jianhui Lin, Kwok Leung Tsui
2018 J jnl
EEMD-Based Steady-State Indexes and Their Applications to Condition Monitoring and Fault Diagnosis of Railway Axle Bearings.
Sensors
Cai Yi, Dong Wang, Wei Fan, Kwok-Leung Tsui, Jianhui Lin
2018 J jnl
Making EEMD more effective in extracting bearing fault features for intelligent bearing fault diagnosis by using blind fault component separation.
J. Intell. Fuzzy Syst.
Dong Wang, Cai Yi, Kwok Leung Tsui
2018 — conf
Quantizing the Health State of Railway Axle Bearing via Signal-to-noise ratio defined by EEMD and SVD.
ICPHM
Cai Yi, Lu Liu, Jianhui Lin, Kwok-Leung Tsui
2017 J jnl
基于层次自动机模型的复杂事件层次实现研究 (Study of Complex Event Hierarchies Realization Based on Hierarchical Automata Model).
计算机科学
Dawei Jin, Si Shi, Cai Yi, Bing Yang
2015 J jnl
Faults Diagnostics of Railway Axle Bearings Based on IMF's Confidence Index Algorithm for Ensemble EMD.
Sensors
Cai Yi, Jianhui Lin, Weihua Zhang, Jianming Ding
1998 — conf
Plane-shape perception using point-contact type force feedback device.
SIGGRAPH Abstracts and Applications
Juli Yamashita, Cai Yi, Robert W. Lindeman, Yukio Fukui, Osamu Morikawa
1997 — conf
Feature based haptic rendering: architecture, protocol, and application.
SIGGRAPH Visual Proceedings
Juli Yamashita, Cai Yi, Yukio Fukui
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),