Vicentiu D. Radulescu

Year	Rank	Type	Title / Venue / Authors
2026	J	`jnl`	Positive Bound States of Fractional Choquard Equations with Upper Hardy-Littlewood-Sobolev Critical Exponent. SIAM J. Math. Anal. Vicentiu D. Radulescu, Da-Bin Wang, Huafei Xie
2026	J	`jnl`	Small perturbations of convective singular eigenvalue problems. Appl. Math. Lett. Ahmed Alsaedi, Nikolaos S. Papageorgiou, Vicentiu D. Radulescu
2025	J	`jnl`	Eigenvalue problems with unbalanced growth. Appl. Math. Lett. Nejmeddine Chorfi, Nikolaos S. Papageorgiou, Vicentiu D. Radulescu
2024	J	`jnl`	Long-time behavior for the Kirchhoff diffusion problem with magnetic fractional Laplace operator. Appl. Math. Lett. Jiabin Zuo, Juliana Honda Lopes, Vicentiu D. Radulescu
2024	J	`jnl`	Nonlocal Double Phase Implicit Obstacle Problems with Multivalued Boundary Conditions. SIAM J. Math. Anal. Shengda Zeng, Vicentiu D. Radulescu, Patrick Winkert
2023	J	`jnl`	Anisotropic and isotropic implicit obstacle problems with nonlocal terms and multivalued boundary conditions. Commun. Nonlinear Sci. Numer. Simul. Shengda Zeng, Leszek Gasinski, Vicentiu D. Radulescu, Patrick Winkert
2023	J	`jnl`	Convergence of least energy sign-changing solutions for logarithmic Schrödinger equations on locally finite graphs. Commun. Nonlinear Sci. Numer. Simul. Xiaojun Chang, Vicentiu D. Radulescu, Ru Wang, Duokui Yan
2023	J	`jnl`	Infinitely many smooth nodal solutions for Orlicz Robin problems. Appl. Math. Lett. Anouar Bahrouni, Hlel Missaoui, Vicentiu D. Radulescu
2023	J	`jnl`	Normalized Solutions for Schrödinger Equations with Critical Exponential Growth in \(\boldsymbol{\mathbb{R}^2}\). SIAM J. Math. Anal. Sitong Chen, Vicentiu D. Radulescu, Xianhua Tang, Shuai Yuan
2022	J	`jnl`	Double Phase Implicit Obstacle Problems with Convection and Multivalued Mixed Boundary Value Conditions. SIAM J. Math. Anal. Shengda Zeng, Vicentiu D. Radulescu, Patrick Winkert
2022	J	`jnl`	Groundstates for magnetic Choquard equations with critical exponential growth. Appl. Math. Lett. Lixi Wen, Vicentiu D. Radulescu
2021	J	`jnl`	High perturbations of critical fractional Kirchhoff equations with logarithmic nonlinearity. Appl. Math. Lett. Sihua Liang, Hongling Pu, Vicentiu D. Radulescu
2020	J	`jnl`	Axially symmetric solutions of the Schrödinger-Poisson system with zero mass potential in R2. Appl. Math. Lett. Lixi Wen, Sitong Chen, Vicentiu D. Radulescu
2018	J	`jnl`	Compactly supported solutions of Schrödinger equations with small perturbation. Appl. Math. Lett. Anouar Bahrouni, Hichem Ounaies, Vicentiu D. Radulescu
2018	J	`jnl`	Further on set-valued equilibrium problems in the pseudo-monotone case and applications to Browder variational inclusions. Optim. Lett. Boualem Alleche, Vicentiu D. Radulescu
2018	J	`jnl`	Periodic solutions for a class of evolution inclusions. Comput. Math. Appl. Nikolaos S. Papageorgiou, Vicentiu D. Radulescu, Dusan Repovs
2018	J	`jnl`	Positive solutions for nonvariational Robin problems. Asymptot. Anal. Nikolaos S. Papageorgiou, Vicentiu D. Radulescu, Dusan Repovs
2018	J	`jnl`	Positive solutions for superdiffusive mixed problems. Appl. Math. Lett. Nikolaos S. Papageorgiou, Vicentiu D. Radulescu, Dusan Repovs
2017	J	`jnl`	Further on Set-Valued Equilibrium Problems and Applications to Browder Variational Inclusions. J. Optim. Theory Appl. Boualem Alleche, Vicentiu D. Radulescu
2017	J	`jnl`	Infinitely many nodal solutions for semilinear Robin problems with an indefinite linear part. Appl. Math. Lett. Nikolaos S. Papageorgiou, Vicentiu D. Radulescu
2017	J	`jnl`	Nonhomogeneous Hemivariational Inequalities with Indefinite Potential and Robin Boundary Condition. J. Optim. Theory Appl. Nikolaos S. Papageorgiou, Vicentiu D. Radulescu, Dusan Repovs
2017	J	`jnl`	Small perturbations of elliptic problems with variable growth. Appl. Math. Lett. Nejmeddine Chorfi, Vicentiu D. Radulescu
2016	J	`jnl`	Existence of solutions for a bi-nonlocal fractional p-Kirchhoff type problem. Comput. Math. Appl. Mingqi Xiang, Binlin Zhang, Vicentiu D. Radulescu
2016	J	`jnl`	On a p(⋅)-biharmonic problem with no-flux boundary condition. Comput. Math. Appl. Maria-Magdalena Boureanu, Vicentiu D. Radulescu, Dusan Repovs
2016	J	`jnl`	Solutions and Approximate Solutions of Quasi-Equilibrium Problems in Banach Spaces. J. Optim. Theory Appl. Boualem Alleche, Vicentiu D. Radulescu
2015	J	`jnl`	Bifurcation analysis for nonhomogeneous Robin problems with competing nonlinearities. Appl. Math. Lett. Nikolaos S. Papageorgiou, Vicentiu D. Radulescu
2015	J	`jnl`	Combined effects of concave-convex nonlinearities and indefinite potential in some elliptic problems. Asymptot. Anal. Nikolaos S. Papageorgiou, Vicentiu D. Radulescu
2015	J	`jnl`	Facility location in normed linear spaces. Optim. Lett. Sorin Radulescu, Diana-Olimpia Alexandrescu, Vicentiu D. Radulescu
2015	J	`jnl`	Hodge decomposition of variable exponent spaces of Clifford-valued functions and applications to Dirac and Stokes equations. Comput. Math. Appl. Yongqiang Fu, Vicentiu D. Radulescu, Binlin Zhang
2015	J	`jnl`	Positive solutions of singular elliptic systems with multiple parameters and Caffarelli-Kohn-Nirenberg exponents. Period. Math. Hung. G. A. Afrouzi, Vicentiu D. Radulescu, Saleh Shakeri
2015	J	`jnl`	Resonant Neumann problems with indefinite and unbounded potential. Appl. Math. Lett. Nikolaos S. Papageorgiou, Vicentiu D. Radulescu
2015	J	`jnl`	The Tikhonov regularization for equilibrium problems and applications to quasi-hemivariational inequalities. Optim. Lett. Boualem Alleche, Vicentiu D. Radulescu, Madjid Sebaoui
2014	J	`jnl`	Nonlinearities in Elliptic Curve Authentication. Entropy Ramzi Alsaedi, Nicolae Constantinescu, Vicentiu D. Radulescu
2014	J	`jnl`	Positive solutions for Neumann problems with indefinite and unbounded potential. Appl. Math. Lett. Nikolaos S. Papageorgiou, Vicentiu D. Radulescu
2012	J	`jnl`	Inequality problems of quasi-hemivariational type involving set-valued operators and a nonlinear term. J. Glob. Optim. Nicusor Costea, Vicentiu D. Radulescu
2007	J	`jnl`	Exponential Growth of a Solution: 11137. Am. Math. Mon. Vicentiu D. Radulescu, Richard Stong
2007	J	`jnl`	Ginzburg-Landau Energy: 11167. Am. Math. Mon. Vicentiu D. Radulescu, et al.
2006	J	`jnl`	An Example With Periodic Orbits: 11073. Am. Math. Mon. Vicentiu D. Radulescu, Richard Stong
2006	J	`jnl`	Nonlinear problems with boundary blow-up: a Karamata regular variation theory approach. Asymptot. Anal. Corina Cîrstea, Vicentiu D. Radulescu
2006	J	`jnl`	Periodic Solution of a Differential Equation: 11104. Am. Math. Mon. Vicentiu D. Radulescu, et al.
2005	J	`jnl`	Problem 11137. Am. Math. Mon. Vicentiu D. Radulescu
2005	J	`jnl`	Problem 11167. Am. Math. Mon. Vicentiu D. Radulescu
2004	J	`jnl`	A Limit Problem: 11024. Am. Math. Mon. Vicentiu D. Radulescu, Richard Stong
2004	J	`jnl`	Problem 11073. Am. Math. Mon. Vicentiu D. Radulescu
2004	J	`jnl`	Problem 11104. Am. Math. Mon. Vicentiu D. Radulescu
2003	J	`jnl`	Problem 11024. Am. Math. Mon. Vicentiu D. Radulescu
2000	J	`jnl`	Multiplicity of solutions for a class of nonsymmetric eigenvalue hemivariational inequalities. J. Glob. Optim. Florica St. Cîrstea, Vicentiu D. Radulescu
1999	J	`jnl`	A Perturbation Result for a Double Eigenvalue Hemivariational Inequality with Constraints and Applications. J. Glob. Optim. M. F. Bocea, Panagiotis D. Panagiotopoulos, Vicentiu D. Radulescu
1999	J	`jnl`	Existence Theorems of Hartman-Stampacchia Type for Hemivariational Inequalities and Applications. J. Glob. Optim. Panagiotis D. Panagiotopoulos, Michel Fundo, Vicentiu D. Radulescu
1998	J	`jnl`	Perturbations of Hemivariational Inequalities with Constraints and Applications. J. Glob. Optim. Vicentiu D. Radulescu, Panagiotis D. Panagiotopoulos

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