{"title":"组织跨学科平台,分享有关一类天然化合物的知识。","authors":"Ylenia Murgia, Valeria Iobbi, Angela Bisio, Nunziatina de Tommasi, Mauro Giacomini","doi":"10.3233/SHTI241061","DOIUrl":null,"url":null,"abstract":"<p><p>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.</p>","PeriodicalId":94357,"journal":{"name":"Studies in health technology and informatics","volume":"321 ","pages":"53-57"},"PeriodicalIF":0.0000,"publicationDate":"2024-11-22","publicationTypes":"Journal Article","fieldsOfStudy":null,"isOpenAccess":false,"openAccessPdf":"","citationCount":"0","resultStr":"{\"title\":\"Organizing an Interdisciplinary Platform for Knowledge Sharing on a Class of Compounds of Natural Origin.\",\"authors\":\"Ylenia Murgia, Valeria Iobbi, Angela Bisio, Nunziatina de Tommasi, Mauro Giacomini\",\"doi\":\"10.3233/SHTI241061\",\"DOIUrl\":null,\"url\":null,\"abstract\":\"<p><p>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.</p>\",\"PeriodicalId\":94357,\"journal\":{\"name\":\"Studies in health technology and informatics\",\"volume\":\"321 \",\"pages\":\"53-57\"},\"PeriodicalIF\":0.0000,\"publicationDate\":\"2024-11-22\",\"publicationTypes\":\"Journal Article\",\"fieldsOfStudy\":null,\"isOpenAccess\":false,\"openAccessPdf\":\"\",\"citationCount\":\"0\",\"resultStr\":null,\"platform\":\"Semanticscholar\",\"paperid\":null,\"PeriodicalName\":\"Studies in health technology and informatics\",\"FirstCategoryId\":\"1085\",\"ListUrlMain\":\"https://doi.org/10.3233/SHTI241061\",\"RegionNum\":0,\"RegionCategory\":null,\"ArticlePicture\":[],\"TitleCN\":null,\"AbstractTextCN\":null,\"PMCID\":null,\"EPubDate\":\"\",\"PubModel\":\"\",\"JCR\":\"\",\"JCRName\":\"\",\"Score\":null,\"Total\":0}","platform":"Semanticscholar","paperid":null,"PeriodicalName":"Studies in health technology and informatics","FirstCategoryId":"1085","ListUrlMain":"https://doi.org/10.3233/SHTI241061","RegionNum":0,"RegionCategory":null,"ArticlePicture":[],"TitleCN":null,"AbstractTextCN":null,"PMCID":null,"EPubDate":"","PubModel":"","JCR":"","JCRName":"","Score":null,"Total":0}
引用次数: 0
摘要
酯萜类化合物是萜烯家族的一个分支,具有显著的生物活性。这些天然化合物存在于植物、真菌、细菌、昆虫和海洋生物等多种生物体中。酯萜类化合物的治疗潜力和结构多样性引起了药理学和化学研究的极大兴趣。本研究说明了如何开发一个数据库来构建和管理这些化合物的数据。设计过程包括收集用户需求、创建带有实体关系图(ERD)的概念模型、开发逻辑模型以及在 Microsoft SQL Server 2022 中实施。数据收集始于广泛的文献综述,并在 Excel 电子表格中进行整理。由此产生的数据库改进了数据采集、组织和可访问性。未来的工作将包括建立一个网站,以方便数据的输入、编辑、读取和提取,并通过外部网络服务实现数据更新的自动化。
Organizing an Interdisciplinary Platform for Knowledge Sharing on a Class of Compounds of Natural Origin.
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.