J. Yang

39 papers Misc 1Journal 27Unranked 11
YearRankTypeTitle / Venue / Authors
2026 J jnl
Time-domain nonlinear SSSI seismic analysis of nuclear power plants supported by pile foundations considering various incident angles.
Reliab. Eng. Syst. Saf.
Y.-G. Wang, Mengtao Wu, J. Yang
2025 J jnl
Multimodal machine learning to predict surgical site infection with healthcare workload impact assessment.
npj Digit. Medicine
Kenneth A. McLean, Alessandro Sgrò, Leo R. Brown, Louis F. Buijs, Katie E. Mountain, Catherine A. Shaw, Thomas M. Drake, Riinu Pius, Stephen R. Knight, Cameron J. Fairfield, Richard J. E. Skipworth, Sotirios A. Tsaftaris, Stephen J. Wigmore, Mark A. Potter, Matt-Mouley Bouamrane, Ewen M. Harrison, K. Baweja, W. A. Cambridge, V. Chauhan, K. Czyzykowska, M. Edirisooriya, A. Forsyth, B. Fox, J. Fretwell, C. Gent, A. Gherman, L. Green, J. Grewar, S. Heelan, D. Henshall, C. Iiuoma, S. Jayasangaran, C. Johnston, E. Kennedy, D. Kremel, J. Kung, J. Kwong, C. Leavy, J. Liu, S. Mackay, A. Macnamara, S. Mowitt, E. Musenga, N. Ng, Z. H. Ng, S. O'Neill, M. Ramage, J. Reed, A. Riad, C. Scott, V. Sehgal, A. Sgrò, L. Steven, B. Stutchfield, S. Tominey, W. Wilson, M. Wojtowicz, J. Yang
2025 J jnl
Prediction of circulating airflow in flue gas cooler based on hybrid deep learning mode.
Signal Image Video Process.
J. Yang, Y. Chi, K. Cao, S. Shan, H. Xin, Z. Xu, S. Yang, L. Zhao
2024 J jnl
DynAMO: Multi-agent reinforcement learning for dynamic anticipatory mesh optimization with applications to hyperbolic conservation laws.
J. Comput. Phys.
Tarik Dzanic, Ketan Mittal, Dohyun Kim, J. Yang, Socratis Petrides, Brendan Keith, Robert W. Anderson
2024 J jnl
OpenCoder: The Open Cookbook for Top-Tier Code Large Language Models.
CoRR
Siming Huang, Tianhao Cheng, Jason Klein Liu, Jiaran Hao, Liuyihan Song, Yang Xu, J. Yang, J. H. Liu, Chenchen Zhang, Linzheng Chai, Ruifeng Yuan, Zhaoxiang Zhang, Jie Fu, Qian Liu, Ge Zhang, Zili Wang, Yuan Qi, Yinghui Xu, Wei Chu
2023 J jnl
Equation-Free Computations as DDDAS Protocols for Bifurcation Studies: A Granular Chain Example.
CoRR
Matthew O. Williams, Yorgos M. Psarellis, D. Pozharskiy, C. Chong, F. Li, J. Yang, Panayotis G. Kevrekidis, Ioannis G. Kevrekidis
2022 — conf
5G Green Network.
Honoring Professor Mohammad S. Obaidat
Xiaohu Ge, J. Yang, Junliang Ye
2021 J jnl
Nonlinear vibration of a deploying laminated Rayleigh beam with a spinning motion in hygrothermal environment.
Eng. Comput.
L. Wang, J. Yang, Yinghui Li
2021 J jnl
Remote diagnosis of surgical-site infection using a mobile digital intervention: a randomised controlled trial in emergency surgery patients.
npj Digit. Medicine
Kenneth A. McLean, Katie E. Mountain, Catherine A. Shaw, Thomas M. Drake, Riinu Pius, Stephen R. Knight, Cameron J. Fairfield, Alessandro Sgrò, Matt-Mouley Bouamrane, William A. Cambridge, Mathew Lyons, Aya Riad, Richard J. E. Skipworth, Stephen J. Wigmore, Mark A. Potter, Ewen M. Harrison, K. Baweja, W. A. Cambridge, V. Chauhan, K. Czyzykowska, M. Edirisooriya, A. Forsyth, B. Fox, J. Fretwell, C. Gent, A. Gherman, L. Green, J. Grewar, S. Heelan, D. Henshall, C. Iiuoma, S. Jayasangaran, C. Johnston, E. Kennedy, D. Kremel, J. Kung, J. Kwong, C. Leavy, J. Liu, S. Mackay, A. Macnamara, S. Mowitt, E. Musenga, N. Ng, Z. H. Ng, S. O'Neill, M. Ramage, J. Reed, A. Riad, C. Scott, V. Sehgal, A. Sgrò, L. Steven, B. Stutchfield, S. Tominey, W. Wilson, M. Wojtowicz, J. Yang
2019 J jnl
Learning to Trace: Expressive Line Drawing Generation from Photographs.
Comput. Graph. Forum
Naoto Inoue, Daichi Ito, Ning Xu, J. Yang, Brian L. Price, Toshihiko Yamasaki
2018 J jnl
Applicability of large-ion lithophile and high field strength element basalt discrimination diagrams.
Int. J. Digit. Earth
X. L. Liu, Qi Zhang, W. C. Li, F. C. Yang, Y. Zhao, Z. Li, S. T. Jiao, Jinrong Wang, N. Zhang, S. S. Wang, W. F. Chen, Z. J. Pan, J. Yang, X. L. Du
2016 J jnl
Recognizing metal and acid radical ion-binding sites by integrating
Bioinform.
X. Hu, Q. Dong, J. Yang, Y. Zhang
2016 Misc conf
System combination with log-linear models.
ICASSP
J. Yang, Chao Zhang, Anton Ragni, Mark J. F. Gales, Philip C. Woodland
2015 — conf
Reconfigurable optical inter-channel interference compensation of 20/25-Gbaud QPSK signals using nonlinear wave mixing.
ECOC
Yinwen Cao, Morteza Ziyadi, A. Mohajerin-Ariaei, Ahmed Almaiman, P. Liao, Changjing Bao, B. Shamee, J. Yang, Youichi Akasaka, M. Sekiya, Moshe Tur, Carsten Langrock, Martin M. Fejer, Joseph D. Touch, Alan E. Willner
2014 — conf
Multisensor analysis of teleconnection signals in relation to terrestrial precipitation and forest greenness in North and Central America.
ICNSC
Ni-Bin Chang, Sanaz Imen, L. Mullen, Chi-Farn Chen, Miguel Conrado Valdez, J. Yang
2013 — conf
The 2nd competition on counter measures to 2D face spoofing attacks.
ICB
Ivana Chingovska, J. Yang, Zhen Lei, Dong Yi, Stan Z. Li, Olga Kähm, Christian Glaser, Naser Damer, Arjan Kuijper, Alexander Nouak, Jukka Komulainen, Tiago Freitas Pereira, Shubham Gupta, Shubham Khandelwal, Shubham Bansal, Ayush K. Rai, Tarun Krishna, Dushyant Goyal, Muhammad-Adeel Waris, Honglei Zhang, Iftikhar Ahmad, Serkan Kiranyaz, Moncef Gabbouj, Roberto Tronci, Maurizio Pili, Nicola Sirena, Fabio Roli, Javier Galbally, Julian Fiérrez, Allan da Silva Pinto, Hélio Pedrini, W. S. Schwartz, Anderson Rocha, André Anjos, Sébastien Marcel
2012 — conf
Multi sensors based ultrasonic human face identification: Experiment and analysis.
MFI
Y. Xu, J. Y. Wang, B. X. Cao, J. Yang
2012 J jnl
Optimal power allocation for decode-and-forward multihop relaying system with direct link.
IET Commun.
J. Yang, X. Rui, X. Cao
2011 J jnl
An extreme automation framework for scaling cloud applications.
IBM J. Res. Dev.
J. Yang, T. Yu, L. R. Jian, J. Qiu, Y. Li
2010 J jnl
Defect-related degradation of Deep-UV-LEDs.
Microelectron. Reliab.
Matteo Meneghini, Diego Barbisan, Y. Bilenko, Maxim S. Shatalov, J. Yang, R. Gaska, Gaudenzio Meneghesso, Enrico Zanoni
2009 J jnl
A graph-based data structure for assembly dimensional variation control at a preliminary phase of product design.
Int. J. Comput. Integr. Manuf.
H. Wang, J. Yang, D. J. Ceglarek
2009 J jnl
A static-dynamic strategy for spare part inventory systems with nonstationary stochastic demand.
J. Oper. Res. Soc.
Z. Hua, J. Yang, F. Huang, X. Xu
2009 J jnl
An optimization approach to partitional data clustering.
J. Oper. Res. Soc.
J. Kim, J. Yang, Sigurdur Ólafsson
2009 J jnl
Near-optimal feature selection for large databases.
J. Oper. Res. Soc.
J. Yang, Sigurdur Ólafsson
2009 — conf
Single-chip RF CMOS UMTS/EGSM transceiver with integrated receive diversity and GPS.
ISSCC
Aristotele Hadjichristos, Marco Cassia, Hong Sun Kim, C. H. Park, Kevin Wang, W. Zhuo, Bahman Ahrari, Roger Brockenbrough, J. Chen, Conor Donovan, R. Jonnalagedda, J. Kim, Jin-Su Ko, Hee Choul Lee, Sang Oh Lee, Emilia Lei, T. Nguyen, T. Pan, S. Sridhara, W. Su, H. Yan, J. Yang, Cormac Conroy, Charles J. Persico, Kamal Sahota, B. Kim
2008 J jnl
Computer-Based Identification of Breast Cancer Using Digitized Mammograms.
J. Medical Syst.
U. Rajendra Acharya, Eddie-Yin-Kwee Ng, Y. H. Chang, J. Yang, G. J. L. Kaw
2007 J jnl
A new approach of forecasting intermittent demand for spare parts inventories in the process industries.
J. Oper. Res. Soc.
Z. S. Hua, B. Zhang, J. Yang, D. S. Tan
2007 J jnl
Changes in brain functional activation during resting and locomotor states after unilateral nigrostriatal damage in rats.
NeuroImage
J. Yang, T. R. Sadler, Tina K. Givrad, Jean-Michel I. Maarek, Daniel P. Holschneider
2006 J jnl
Mapping cerebral blood flow changes during auditory-cued conditioned fear in the nontethered, nonrestrained rat.
NeuroImage
Daniel P. Holschneider, J. Yang, T. R. Sadler, Peter T. Nguyen, Tina K. Givrad, Jean-Michel I. Maarek
2006 J jnl
Product data quality assurance for e-manufacturing in the automotive industry.
Int. J. Comput. Integr. Manuf.
J. Yang, S. Han, H. Kang, J. Kim
2005 J jnl
Experimental investigation of the dielectric-semiconductor interface with scanning capacitance microscopy.
Microelectron. Reliab.
J. Yang, Joseph J. Kopanski, Adam Postula, Marek E. Bialkowski
2005 J jnl
Tentative chip decision-feedback equalizer for multicode wideband CDMA.
IEEE Trans. Wirel. Commun.
J. Yang, Y. Li
2003 — conf
A Class of Semi-Orthogonal Wavelet Packets.
WAA
Yuan Yan Tang, J. Yang, Weipeng Zhang
2003 — conf
A Wavelet Based Watermarking Scheme for Information Security.
WAA
J. Yang, J. Cheng, B. Li
2003 — conf
Adapted Sampling and Interpolatory Wavelet Packets.
WAA
J. Yang, Z. Cheng
2003 — conf
Channel estimation for wireless communications using space-time block coding techniques.
ISCAS (2)
J. Yang, Y. Sun, John M. Senior, N. Pem
1999 — conf
An in-the-loop training method for VLSI neural networks.
ISCAS (5)
J. Yang, Majid Ahmadi, Graham A. Jullien, William C. Miller
1997 J jnl
Alternatives to the use of the DFT in MRI and spectroscopic reconstructions.
Int. J. Imaging Syst. Technol.
Michael R. Smith, L. Chen, Yan Hui, T. Mathews Jr., J. Yang, X. Zeng
1997 J jnl
Möbius polynomial species.
Discret. Math.
Domenico Senato, Antonietta Venezia, J. Yang
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),