Alessandro Fiori
Current Organizations / Institutes
The organizations/institutes from the scholar's latest article
Previous Organizations / Institutes
The organizations / institutes from the scholar's other articles in the past ten years
Research Subjects
Alessandro Fiori has a total of 70 co-authors. Here are the top co-authors by number of shared publications:
- Luca Cagliero
Politecnico di Torino
13 shared publications Elena Baralis
Politecnico di Torino, Torino (Italy)
12 shared publications- Giulia Bruno
Politecnico di Torino
8 shared publications - Andrea Bertotti
Candiolo Cancer Institute—FPO IRCCS, Torino, Italy
6 shared publications Alberto Grand
Institute for Cancer Research and Treatment, Italy
4 shared publications- Andrea Mignone
Candiolo Cancer Institute - FPO IRCCS, Strada Provinciale, Candiolo, Italy
4 shared publications
Latest Publications
- 8 February 2026
- Published by Springer Nature
- p. 550-561
Boosting the Entity-Relationship Model for Document-Oriented Databases
- 8 February 2026
- Published by Springer Nature
- p. 550-561
Boosting the Entity-Relationship Model for Document-Oriented Databases
- Open Access
- 29 April 2025
- Published by MDPI AG in Information
- Vol. 16 (5) , 368
Exploring Large Language Models’ Ability to Describe Entity-Relationship Schema-Based Conceptual Data Models
In the field of databases, Large Language Models (LLMs) have recently been studied for generating SQL queries from textual descriptions, while their use for conceptual or logical data modeling remains less explored. The conceptual design of relational databases commonly relies on the entity-relationship (ER) data model, where translation rules enable mapping an ER schema into corresponding relational tables with their constraints. Our study investigates the capability of LLMs to describe in natural language a database conceptual data model based on the ER schema. Whether for documentation, onboarding, or communication with non-technical stakeholders, LLMs can significantly improve the process of explaining the ER schema by generating accurate descriptions about how the components interact as well as the represented information. To guide the LLM with challenging constructs, specific hints are defined to provide an enriched ER schema. Different LLMs have been explored (ChatGPT 3.5 and 4, Llama2, Gemini, Mistral 7B) and different metrics (F1 score, ROUGE, perplexity) are used to assess the quality of the generated descriptions and compare the different LLMs.
- 29 April 2025
- Published by MDPI AG in Information
- Vol. 16 (5) , 368
Open AccessExploring Large Language Models’ Ability to Describe Entity-Relationship Schema-Based Conceptual Data Models
In the field of databases, Large Language Models (LLMs) have recently been studied for generating SQL queries from textual descriptions, while their use for conceptual or logical data modeling remains less explored. The conceptual design of relational databases commonly relies on the entity-relationship (ER) data model, where translation rules enable mapping an ER schema into corresponding relational tables with their constraints. Our study investigates the capability of LLMs to describe in natural language a database conceptual data model based on the ER schema. Whether for documentation, onboarding, or communication with non-technical stakeholders, LLMs can significantly improve the process of explaining the ER schema by generating accurate descriptions about how the components interact as well as the represented information. To guide the LLM with challenging constructs, specific hints are defined to provide an enriched ER schema. Different LLMs have been explored (ChatGPT 3.5 and 4, Llama2, Gemini, Mistral 7B) and different metrics (F1 score, ROUGE, perplexity) are used to assess the quality of the generated descriptions and compare the different LLMs.
- Open Access
- 22 February 2022
- Published by Springer Nature in BMC Genomics
- Vol. 23 (1) , 1-11
The EurOPDX Data Portal: an open platform for patient-derived cancer xenograft data sharing and visualization
Background: Patient-derived xenografts (PDX) mice models play an important role in preclinical trials and personalized medicine. Sharing data on the models is highly valuable for numerous reasons – ethical, economical, research cross validation etc. The EurOPDX Consortium was established 8 years ago to share such information and avoid duplicating efforts in developing new PDX mice models and unify approaches to support preclinical research. EurOPDX Data Portal is the unified data sharing platform adopted by the Consortium. Main body: In this paper we describe the main features of the EurOPDX Data Portal (https://dataportal.europdx.eu/), its architecture and possible utilization by researchers who look for PDX mice models for their research. The Portal offers a catalogue of European models accessible on a cooperative basis. The models are searchable by metadata, and a detailed view provides molecular profiles (gene expression, mutation, copy number alteration) and treatment studies. The Portal displays the data in multiple tools (PDX Finder, cBioPortal, and GenomeCruzer in future), which are populated from a common database displaying strictly mutually consistent views. (Short) Conclusion: EurOPDX Data Portal is an entry point to the EurOPDX Research Infrastructure offering PDX mice models for collaborative research, (meta)data describing their features and deep molecular data analysis according to users’ interests.
- 22 February 2022
- Published by Springer Nature in BMC Genomics
- Vol. 23 (1) , 1-11
Open AccessThe EurOPDX Data Portal: an open platform for patient-derived cancer xenograft data sharing and visualization
Background: Patient-derived xenografts (PDX) mice models play an important role in preclinical trials and personalized medicine. Sharing data on the models is highly valuable for numerous reasons – ethical, economical, research cross validation etc. The EurOPDX Consortium was established 8 years ago to share such information and avoid duplicating efforts in developing new PDX mice models and unify approaches to support preclinical research. EurOPDX Data Portal is the unified data sharing platform adopted by the Consortium. Main body: In this paper we describe the main features of the EurOPDX Data Portal (https://dataportal.europdx.eu/), its architecture and possible utilization by researchers who look for PDX mice models for their research. The Portal offers a catalogue of European models accessible on a cooperative basis. The models are searchable by metadata, and a detailed view provides molecular profiles (gene expression, mutation, copy number alteration) and treatment studies. The Portal displays the data in multiple tools (PDX Finder, cBioPortal, and GenomeCruzer in future), which are populated from a common database displaying strictly mutually consistent views. (Short) Conclusion: EurOPDX Data Portal is an entry point to the EurOPDX Research Infrastructure offering PDX mice models for collaborative research, (meta)data describing their features and deep molecular data analysis according to users’ interests.
- Open Access
- 1 January 2019
- Published by Oxford University Press (OUP) in Database: The Journal of Biological Databases and Curation
- Vol. 2019
Semalytics: a semantic analytics platform for the exploration of distributed and heterogeneous cancer data in translational research
Each cancer is a complex system with unique molecular features determining its dynamics, such as its prognosis and response to therapies. Understanding the role of these biological traits is fundamental in order to personalize cancer clinical care according to the characteristics of each patient’s disease. To achieve this, translational researchers propagate patients’ samples through in vivo and in vitro cultures to test different therapies on the same tumor and to compare their outcomes with the molecular profile of the disease. This in turn generates information that can be subsequently translated into the development of predictive biomarkers for clinical use. These large-scale experiments generate huge collections of hierarchical data (i.e. experimental trees) with relative annotations that are extremely difficult to analyze. To address such issues in data analyses, we came up with the Semalytics data framework, the core of an analytical platform that processes experimental information through Semantic Web technologies. Semalytics allows (i) the efficient exploration of experimental trees with irregular structures together with their annotations. Moreover, (ii) the platform links its data to a wider open knowledge base (i.e. Wikidata) to add an extended knowledge layer without the need to manage and curate those data locally. Altogether, Semalytics provides augmented perspectives on experimental data, allowing the generation of new hypotheses, which were not anticipated by the user a priori. In this work, we present the data core we created for Semalytics, focusing on its semantic nucleus and on how it exploits semantic reasoning and data integration to tackle issues of this kind of analyses. Finally, we describe a proof-of-concept study based on the examination of several dozen cases of metastatic colorectal cancer in order to illustrate how Semalytics can help researchers generate hypotheses about the role of genes alterations in causing resistance or sensitivity of cancer cells to specific drugs.
- 1 January 2019
- Published by Oxford University Press (OUP) in Database: The Journal of Biological Databases and Curation
- Vol. 2019
Open AccessSemalytics: a semantic analytics platform for the exploration of distributed and heterogeneous cancer data in translational research
Each cancer is a complex system with unique molecular features determining its dynamics, such as its prognosis and response to therapies. Understanding the role of these biological traits is fundamental in order to personalize cancer clinical care according to the characteristics of each patient’s disease. To achieve this, translational researchers propagate patients’ samples through in vivo and in vitro cultures to test different therapies on the same tumor and to compare their outcomes with the molecular profile of the disease. This in turn generates information that can be subsequently translated into the development of predictive biomarkers for clinical use. These large-scale experiments generate huge collections of hierarchical data (i.e. experimental trees) with relative annotations that are extremely difficult to analyze. To address such issues in data analyses, we came up with the Semalytics data framework, the core of an analytical platform that processes experimental information through Semantic Web technologies. Semalytics allows (i) the efficient exploration of experimental trees with irregular structures together with their annotations. Moreover, (ii) the platform links its data to a wider open knowledge base (i.e. Wikidata) to add an extended knowledge layer without the need to manage and curate those data locally. Altogether, Semalytics provides augmented perspectives on experimental data, allowing the generation of new hypotheses, which were not anticipated by the user a priori. In this work, we present the data core we created for Semalytics, focusing on its semantic nucleus and on how it exploits semantic reasoning and data integration to tackle issues of this kind of analyses. Finally, we describe a proof-of-concept study based on the examination of several dozen cases of metastatic colorectal cancer in order to illustrate how Semalytics can help researchers generate hypotheses about the role of genes alterations in causing resistance or sensitivity of cancer cells to specific drugs.
- Open Access
- 1 January 2019
- Published by Oxford University Press (OUP) in Database: The Journal of Biological Databases and Curation
- Vol. 2019
One tool to find them all: a case of data integration and querying in a distributed LIMS platform
In the last years, Laboratory Information Management Systems (LIMS) have been growing from mere inventory systems into increasingly comprehensive software platforms, spanning functionalities as diverse as data search, annotation and analysis. Our institution started in 2011 a LIMS project named the Laboratory Assistant Suite with the purpose of assisting researchers throughout all of their laboratory activities, providing graphical tools to support decision-making tasks and building complex analyses on integrated data. The modular architecture of the system exploits multiple databases with different technologies. To provide an efficient and easy tool for retrieving information of interest, we developed the Multi-Dimensional Data Manager (MDDM). By means of intuitive interfaces, scientists can execute complex queries without any knowledge of query languages or database structures, and easily integrate heterogeneous data stored in multiple databases. Together with the other software modules making up the platform, the MDDM has helped improve the overall quality of the data, substantially reduced the time spent with manual data entry and retrieval and ultimately broadened the spectrum of interconnections among the data, offering novel perspectives to the biomedical analysts.
- 1 January 2019
- Published by Oxford University Press (OUP) in Database: The Journal of Biological Databases and Curation
- Vol. 2019
Open AccessOne tool to find them all: a case of data integration and querying in a distributed LIMS platform
In the last years, Laboratory Information Management Systems (LIMS) have been growing from mere inventory systems into increasingly comprehensive software platforms, spanning functionalities as diverse as data search, annotation and analysis. Our institution started in 2011 a LIMS project named the Laboratory Assistant Suite with the purpose of assisting researchers throughout all of their laboratory activities, providing graphical tools to support decision-making tasks and building complex analyses on integrated data. The modular architecture of the system exploits multiple databases with different technologies. To provide an efficient and easy tool for retrieving information of interest, we developed the Multi-Dimensional Data Manager (MDDM). By means of intuitive interfaces, scientists can execute complex queries without any knowledge of query languages or database structures, and easily integrate heterogeneous data stored in multiple databases. Together with the other software modules making up the platform, the MDDM has helped improve the overall quality of the data, substantially reduced the time spent with manual data entry and retrieval and ultimately broadened the spectrum of interconnections among the data, offering novel perspectives to the biomedical analysts.
- 1 January 2018
- Published by IGI Global Scientific Publishing
- p. 505-531
A Case Study of a Laboratory Information System Developed at the Institute for Cancer Research at Candiolo
Research laboratories produce a huge amount of complex and heterogeneous data typically managed by Laboratory Information Management Systems (LIMSs). Although many LIMSs are available, it is often difficult to identify a product that covers all the requirements and peculiarities of a specific institution. To deal with this lack, the Candido Cancer Institute decided to start a project, named the Laboratory Assistant Suite (LAS), with the aim of developing a new software platform that assists researchers throughout diverse laboratory activities. The proposed system can track laboratory experiments even in problematic environments, support the integration of heterogeneous biomedical data, and help in decision-making tasks. In this chapter, the authors present the current architecture of the system, some real-use cases, as well as statistics about stored data and user feedback in order to provide an overview of the functionalities and show the effectiveness of the platform in supporting research in the molecular oncology field.
- 1 January 2018
- Published by IGI Global Scientific Publishing
- p. 505-531
A Case Study of a Laboratory Information System Developed at the Institute for Cancer Research at Candiolo
Research laboratories produce a huge amount of complex and heterogeneous data typically managed by Laboratory Information Management Systems (LIMSs). Although many LIMSs are available, it is often difficult to identify a product that covers all the requirements and peculiarities of a specific institution. To deal with this lack, the Candido Cancer Institute decided to start a project, named the Laboratory Assistant Suite (LAS), with the aim of developing a new software platform that assists researchers throughout diverse laboratory activities. The proposed system can track laboratory experiments even in problematic environments, support the integration of heterogeneous biomedical data, and help in decision-making tasks. In this chapter, the authors present the current architecture of the system, some real-use cases, as well as statistics about stored data and user feedback in order to provide an overview of the functionalities and show the effectiveness of the platform in supporting research in the molecular oncology field.
- 1 January 2018
- Published by IGI Global Scientific Publishing
- p. 56-93
LAS
Rapid technological evolution is providing biomedical research laboratories with huge amounts of complex and heterogeneous data. The LIMS project Laboratory Assistant Suite (LAS), started by our Institution, aims to assist researchers throughout all of their laboratory activities, providing graphical tools to support decision-making tasks and building complex analyses on integrated data. Thanks to a clinical data management module, linking biological samples analysed by translational research with the originating patients and their clinical history, it can effectively provide insight into tumor development. Furthermore, the LAS tracks molecular experiments and allows automatic annotation of biological samples with their molecular results. A genomic annotation module makes use of semantic web technologies to represent relevant concepts from the genomic domain. The LAS system has helped improve the overall quality of the data and broadened the spectrum of interconnections among the data, offering novel perspectives to the biomedical analyst.
- 1 January 2018
- Published by IGI Global Scientific Publishing
- p. 56-93
LAS
Rapid technological evolution is providing biomedical research laboratories with huge amounts of complex and heterogeneous data. The LIMS project Laboratory Assistant Suite (LAS), started by our Institution, aims to assist researchers throughout all of their laboratory activities, providing graphical tools to support decision-making tasks and building complex analyses on integrated data. Thanks to a clinical data management module, linking biological samples analysed by translational research with the originating patients and their clinical history, it can effectively provide insight into tumor development. Furthermore, the LAS tracks molecular experiments and allows automatic annotation of biological samples with their molecular results. A genomic annotation module makes use of semantic web technologies to represent relevant concepts from the genomic domain. The LAS system has helped improve the overall quality of the data and broadened the spectrum of interconnections among the data, offering novel perspectives to the biomedical analyst.
- Top Cited PapersOpen Access
- 31 May 2017
- Published by Springer Nature in Nature Communications
- Vol. 8 (1) , 15107
Selective analysis of cancer-cell intrinsic transcriptional traits defines novel clinically relevant subtypes of colorectal cancer
Stromal content heavily impacts the transcriptional classification of colorectal cancer (CRC), with clinical and biological implications. Lineage-dependent stromal transcriptional components could therefore dominate over more subtle expression traits inherent to cancer cells. Since in patient-derived xenografts (PDXs) stromal cells of the human tumour are substituted by murine counterparts, here we deploy human-specific expression profiling of CRC PDXs to assess cancer-cell intrinsic transcriptional features. Through this approach, we identify five CRC intrinsic subtypes (CRIS) endowed with distinctive molecular, functional and phenotypic peculiarities: (i) CRIS-A: mucinous, glycolytic, enriched for microsatellite instability or KRAS mutations; (ii) CRIS-B: TGF-β pathway activity, epithelial–mesenchymal transition, poor prognosis; (iii) CRIS-C: elevated EGFR signalling, sensitivity to EGFR inhibitors; (iv) CRIS-D: WNT activation, IGF2 gene overexpression and amplification; and (v) CRIS-E: Paneth cell-like phenotype, TP53 mutations. CRIS subtypes successfully categorize independent sets of primary and metastatic CRCs, with limited overlap on existing transcriptional classes and unprecedented predictive and prognostic performances.
- 31 May 2017
- Published by Springer Nature in Nature Communications
- Vol. 8 (1) , 15107
Top Cited PapersOpen AccessSelective analysis of cancer-cell intrinsic transcriptional traits defines novel clinically relevant subtypes of colorectal cancer
Stromal content heavily impacts the transcriptional classification of colorectal cancer (CRC), with clinical and biological implications. Lineage-dependent stromal transcriptional components could therefore dominate over more subtle expression traits inherent to cancer cells. Since in patient-derived xenografts (PDXs) stromal cells of the human tumour are substituted by murine counterparts, here we deploy human-specific expression profiling of CRC PDXs to assess cancer-cell intrinsic transcriptional features. Through this approach, we identify five CRC intrinsic subtypes (CRIS) endowed with distinctive molecular, functional and phenotypic peculiarities: (i) CRIS-A: mucinous, glycolytic, enriched for microsatellite instability or KRAS mutations; (ii) CRIS-B: TGF-β pathway activity, epithelial–mesenchymal transition, poor prognosis; (iii) CRIS-C: elevated EGFR signalling, sensitivity to EGFR inhibitors; (iv) CRIS-D: WNT activation, IGF2 gene overexpression and amplification; and (v) CRIS-E: Paneth cell-like phenotype, TP53 mutations. CRIS subtypes successfully categorize independent sets of primary and metastatic CRCs, with limited overlap on existing transcriptional classes and unprecedented predictive and prognostic performances.
- 1 January 2016
- Published by Elsevier in Information Sciences
- Vol. 328, 378-388
DeCoClu: Density consensus clustering approach for public transport data
- 1 January 2016
- Published by Elsevier in Information Sciences
- Vol. 328, 378-388
DeCoClu: Density consensus clustering approach for public transport data
- Open Access
- 21 September 2015
- Published by Association for Computing Machinery (ACM) in ACM Transactions on Information Systems
- Vol. 34 (1) , 1-35
MWI-Sum
Multidocument summarization addresses the selection of a compact subset of highly informative sentences, i.e., the summary, from a collection of textual documents. To perform sentence selection, two parallel strategies have been proposed: (a) apply general-purpose techniques relying on data mining or information retrieval techniques, and/or (b) perform advanced linguistic analysis relying on semantics-based models (e.g., ontologies) to capture the actual sentence meaning. Since there is an increasing need for processing documents written in different languages, the attention of the research community has recently focused on summarizers based on strategy (a). This article presents a novel multilingual summarizer, namely MWI-Sum (Multilingual Weighted Itemset-based Summarizer), that exploits an itemset-based model to summarize collections of documents ranging over the same topic. Unlike previous approaches, it extracts frequent weighted itemsets tailored to the analyzed collection and uses them to drive the sentence selection process. Weighted itemsets represent correlations among multiple highly relevant terms that are neglected by previous approaches. The proposed approach makes minimal use of language-dependent analyses. Thus, it is easily applicable to document collections written in different languages. Experiments performed on benchmark and real-life collections, English-written and not, demonstrate that the proposed approach performs better than state-of-the-art multilingual document summarizers.
- 21 September 2015
- Published by Association for Computing Machinery (ACM) in ACM Transactions on Information Systems
- Vol. 34 (1) , 1-35
Open AccessMWI-Sum
Multidocument summarization addresses the selection of a compact subset of highly informative sentences, i.e., the summary, from a collection of textual documents. To perform sentence selection, two parallel strategies have been proposed: (a) apply general-purpose techniques relying on data mining or information retrieval techniques, and/or (b) perform advanced linguistic analysis relying on semantics-based models (e.g., ontologies) to capture the actual sentence meaning. Since there is an increasing need for processing documents written in different languages, the attention of the research community has recently focused on summarizers based on strategy (a). This article presents a novel multilingual summarizer, namely MWI-Sum (Multilingual Weighted Itemset-based Summarizer), that exploits an itemset-based model to summarize collections of documents ranging over the same topic. Unlike previous approaches, it extracts frequent weighted itemsets tailored to the analyzed collection and uses them to drive the sentence selection process. Weighted itemsets represent correlations among multiple highly relevant terms that are neglected by previous approaches. The proposed approach makes minimal use of language-dependent analyses. Thus, it is easily applicable to document collections written in different languages. Experiments performed on benchmark and real-life collections, English-written and not, demonstrate that the proposed approach performs better than state-of-the-art multilingual document summarizers.