: Sesterterpenoids, a subset of the terpene family, exhibit notable biological activities. These natural compounds are present in a variety of organisms such as plants, fungi, bacteria, insects and marine life. The therapeutic potential and structural diversity of sesterterpenoids have attracted considerable interest in pharmacological and chemical research. This study illustrates the development of a database to structure and manage data on these compounds. The design process involves the collection of user requirements, creation of a conceptual model with and Entity-Relationship Diagram (ERD), development of a logical model, and implementation in Microsoft SQL Server 2022. Data collection began with an extensive literature review and organization in an Excel spreadsheet. The resulting database improves data acquisition, organization, and accessibility. Future work will include building a website to facilitate data entry, editing, reading and extraction, and automation of data updates via external web services.

Organizing an Interdisciplinary Platform for Knowledge Sharing on a Class of Compounds of Natural Origin

Murgia Y.;Iobbi V.;Bisio A.;Giacomini M.
2024-01-01

Abstract

: Sesterterpenoids, a subset of the terpene family, exhibit notable biological activities. These natural compounds are present in a variety of organisms such as plants, fungi, bacteria, insects and marine life. The therapeutic potential and structural diversity of sesterterpenoids have attracted considerable interest in pharmacological and chemical research. This study illustrates the development of a database to structure and manage data on these compounds. The design process involves the collection of user requirements, creation of a conceptual model with and Entity-Relationship Diagram (ERD), development of a logical model, and implementation in Microsoft SQL Server 2022. Data collection began with an extensive literature review and organization in an Excel spreadsheet. The resulting database improves data acquisition, organization, and accessibility. Future work will include building a website to facilitate data entry, editing, reading and extraction, and automation of data updates via external web services.
File in questo prodotto:
File Dimensione Formato  
Murgia_et_al_STC2024.pdf

accesso aperto

Tipologia: Documento in Post-print
Dimensione 229.45 kB
Formato Adobe PDF
229.45 kB Adobe PDF Visualizza/Apri

I documenti in IRIS sono protetti da copyright e tutti i diritti sono riservati, salvo diversa indicazione.

Utilizza questo identificativo per citare o creare un link a questo documento: https://hdl.handle.net/11567/1225378
Citazioni
  • ???jsp.display-item.citation.pmc??? ND
  • Scopus 0
  • ???jsp.display-item.citation.isi??? ND
social impact