Development of a database system for operational use in the selection of titanium alloys

The selection of titanium alloys has become a complex decision-making task due to the growing number of creation and utilization for titanium alloys,with each having its own characteristics,advantages,and limitations.In choosing the most appropriate titanium alloys,it is very essential to offer a reasonable and intelligent service for technical engineers.One possible solution of this problem is to develop a database system（DS） to help retrieve rational proposals from different databases and information sources and analyze them to provide useful and explicit information.For this purpose,a design strategy of the fuzzy set theory is proposed,and a distributed database system is developed.Through ranking of the candidate titanium alloys,the most suitable material is determined.It is found that the selection results are in good agreement with the practical situation.

Type-2 Neutrosophic Set and Their Applications in Medical Databases Deadlock Resolution

Electronic patient data gives many advantages,but also new difficulties.Deadlocks may delay procedures like acquiring patient information.Distributed deadlock resolution solutions introduce uncertainty due to inaccurate transaction properties.Soft computing-based solutions have been developed to solve this challenge.In a single framework,ambiguous,vague,incomplete,and inconsistent transaction attribute information has received minimal attention.The work presented in this paper employed type-2 neutrosophic logic,an extension of type-1 neutrosophic logic,to handle uncertainty in real-time deadlock-resolving systems.The proposed method is structured to reflect multiple types of knowledge and relations among transactions’features that include validation factor degree,slackness degree,degree of deadline-missed transaction based on the degree of membership of truthiness,degree ofmembership of indeterminacy,and degree ofmembership of falsity.Here,the footprint of uncertainty(FOU)for truth,indeterminacy,and falsity represents the level of uncertainty that exists in the value of a grade of membership.We employed a distributed real-time transaction processing simulator(DRTTPS)to conduct the simulations and conducted experiments using the benchmark Pima Indians diabetes dataset(PIDD).As the results showed,there is an increase in detection rate and a large drop in rollback rate when this new strategy is used.The performance of Type-2 neutrosophicbased resolution is better than the Type-1 neutrosophic-based approach on the execution ratio scale.The improvement rate has reached 10%to 20%,depending on the number of arrived transactions.

LipoCol Forte capsules reduce the risk of liver cancer:A propensity score-matched,nationwide,population-based cohort study

BACKGROUND Liver cancer is among the top five most common cancers globally. Lipid-lowering drugs such as statins can lower the risk of liver cancer, but may also cause liver damage. LipoCol Forte capsules(LFC), a red yeast rice product, have demonstrated significant antihypercholesterolemic effects and a good safety profile in clinical studies.AIM To evaluate whether LFC lowers the risk of liver cancer in adults in this propensity score-matched, nationwide, population-based cohort study.METHODS We used data from Taiwan’s National Health Insurance Research Database, which includes electronic medical records for up to 99.99% of Taiwan’s population. LFC users and LFC non-users were matched 1:1 by propensity scores between January 2010 and December 2017. All had followup data for at least 1 year. Statistical analyses compared demographic distributions including sex, age, comorbidities, and prescribed medications. Cox regression analyses estimated adjusted hazard ratios(aHRs) after adjusting for potential confounders.RESULTS We enrolled 33231 LFC users and 33231 non-LFC users(controls). No significant differences between the study cohorts were identified regarding comorbidities and medications [standardized mean difference(SMD) < 0.05]. At follow-up, the overall incidence of liver cancer was significantly lower in the LFC cohort compared with controls [aHR 0.91;95% confidence interval(CI): 0.86-0.95;P < 0.001]. The risk of liver cancer was significantly reduced in both females(aHR 0.87;95%CI: 0.8-0.94;P < 0.001) and males(aHR 0.93;95%CI: 0.87-0.98;P < 0.01) in the LFC cohort compared with their counterparts in the non-LFC cohort. The antitumor protective effects applied to patients with comorbidities(including hypertension, ischemic stroke, diabetes mellitus, hyperlipidemia, hepatitis B infection and hepatitis C infection). Those using LFC for more than 84 drug days had a 0.64-fold lower risk of liver cancer compared with controls(P < 0.001). Compared with controls, the risk of developing liver cancer in the LFC cohort progressively decreased over time;the lowest incidence of liver cancer occurred in LFC users followed-up for more than 6 years(27.44 vs 31.49 per 1,000 person-years;aHR 0.75;95%CI: 0.68-0.82;P < 0.001).CONCLUSION This retrospective cohort study indicates that LFC has a significantly protective effect on lowering the risk of liver cancer, in a dose-dependent and time-dependent manner.

Retrospective review of total neoadjuvant therapy

BACKGROUND Neoadjuvant chemoradiotherapy(nCRT)followed by resection and postoperative multi-agent chemotherapy(maChT)is the standard of care for locally advanced rectal cancer.Using this approach,maChT administration can be delayed for several months,leading to concern for distant metastases.To counteract this,a novel treatment approach known as total neoadjuvant therapy(TNT)has gained popularity,in which patients receive both maChT and nCRT prior to resection.We utilized the National Cancer Database to examine temporal trends in TNT usage,and any potential effect on survival.AIM To study the temporal trends in the usage of TNT and evaluate its efficacy compared to neoadjuvant chemoradiation.METHODS We queried the National Cancer Database for patients with locally advanced rectal cancer,Stage II-III,from 2004-2015 treated with nCRT or TNT.TNT was defined as maChT initiated≥90 d prior to nCRT initiation.Overall survival was calculated from the date of diagnosis to the date of last contact or death using Kaplan-Meier curves to present the cumulative probability of survival,with logrank statistics to assess significance.Multivariable cox regression was used to identify predictors of survival and propensity score analysis accounted for bias.RESULTS We identified 9066 eligible patients,with 8812 and 254 patients receiving neoadjuvant chemoradiation followed by maChT and TNT,respectively.Nodal involvement,stage III disease,and treatment in recent years were predictive of TNT use.There was greater use of TNT with more advanced stage,specifically>1 node involved(odds ratio[OR]=2.88,95%confidence interval[CI]:2.11-3.93,P<0.01)and stage III disease(OR=2.88,95%CI:2.11-3.93,P<0.01).From 2010 to 2012 the use of TNT increased(OR=2.41,95%CI:1.27-4.56,P<0.01)with a greater increase from 2013 to 2015(OR=6.62,95%CI:3.57-12.25,P<0.01).Both the TNT and neoadjuvant chemoradiation arms had a similar 5-year survival at 76%and 78%respectively.Multivariable analysis with propensity score demonstrated that increased age,high comorbidity score,higher grade,African American race,and female gender had worse overall survival.CONCLUSION Our data demonstrates a rising trend in TNT use,particularly in patients with worse disease.Patients treated with TNT and nCRT had similar survival.Randomized trials evaluating TNT are underway.

Analysis of cancer-specific survival in patients with metastatic colorectal cancer: A evidence-based medicine study

BACKGROUND Metastatic colorectal cancer(mCRC)is a common malignancy whose treatment has been a clinical challenge.Cancer-specific survival(CSS)plays a crucial role in assessing patient prognosis and treatment outcomes.However,there is still li-mited research on the factors affecting CSS in mCRC patients and their corre-lation.AIM To predict CSS,we developed a new nomogram model and risk grading system to classify risk levels in patients with mCRC.METHODS Data were extracted from the United States Surveillance,Epidemiology,and End Results database from 2018 to 2023.All eligible patients were randomly divided into a training cohort and a validation cohort.The Cox proportional hazards model was used to investigate the independent risk factors for CSS.A new nomogram model was developed to predict CSS and was evaluated through internal and external validation.RESULTS A multivariate Cox proportional risk model was used to identify independent risk factors for CSS.Then,new CSS columns were developed based on these factors.The consistency index(C-index)of the histogram was 0.718(95%CI:0.712-0.725),and that of the validation cohort was 0.722(95%CI:0.711-0.732),indicating good discrimination ability and better performance than tumor-node-metastasis staging(C-index:0.712-0.732).For the training set,0.533,95%CI:0.525-0.540;for the verification set,0.524,95%CI:0.513-0.535.The calibration map and clinical decision curve showed good agreement and good potential clinical validity.The risk grading system divided all patients into three groups,and the Kaplan-Meier curve showed good stratification and differentiation of CSS between different groups.The median CSS times in the low-risk,medium-risk,and high-risk groups were 36 months(95%CI:34.987-37.013),18 months(95%CI:17.273-18.727),and 5 months(95%CI:4.503-5.497),respectively.CONCLUSION Our study developed a new nomogram model to predict CSS in patients with synchronous mCRC.In addition,the risk-grading system helps to accurately assess patient prognosis and guide treatment.

Computer Administering of the Psychological Investigations: Set-Relational Representation

Computer administering of a psychological investigation is the computer representation of the entire procedure of psychological assessments—test construction, test implementation, results evaluation, storage and maintenance of the developed database, its statistical processing, analysis and interpretation. A mathematical description of psychological assessment with the aid of personality tests is discussed in this article. The set theory and the relational algebra are used in this description. A relational model of data, needed to design a computer system for automation of certain psychological assessments is given. Some finite sets and relation on them, which are necessary for creating a personality psychological test, are described. The described model could be used to develop real software for computer administering of any psychological test and there is full automation of the whole process: test construction, test implementation, result evaluation, storage of the developed database, statistical implementation, analysis and interpretation. A software project for computer administering personality psychological tests is suggested.

一种网络安全数据库在植保机系统中的应用

针对我国现有植保机只能进行农药喷洒,并不能对病虫害进行预警而解决农作物病虫害的问题,对网络安全数据库在植保机系统的应用进行了研究。所设计的植保机DNN门户内容管理系统主要包括3层,分别为客户端、网络服务端和数据库端。为了使植保机系统可以根据数据库的数据对病虫害进行预警,同时保证数据库数据的安全,建立了粗糙集和BP神经网络的预警模型,包括采用粗糙集进行数据的预处理,并采用BP神经网络建立预警模型。为了验证植保机的DNN门户内容管理系统的有效性,利用采集到的样本对系统的运行进行了训练、验证和测试,结果表明:系统可以有效地对植物病虫害问题进行预警。

利用Microsoft Visual Basic开发关系数据库──太原市飞机场电话管理计费系统的设计与实现

主要以开发太原市飞机场电话管理计费系统为例介绍Ｍｉｃｒｏｓｏｆｔ Ｖｉｓｕａｌ Ｂａｓｉｃ ｆｏｒ Ｗｉｎｄｏｗｓ（以下简称ＶＢ）开发关系数据库的技术和方法。根据该文开发的管理计费系统，可使操作者达到对电话的快速改号，部门间的电话移动，电话的开放，限制，电话租金修改，电话用户的查询，电话费的查询统计和报表等功能的处理。

一种数据库记录集导入Office文档的方法

通过程序实例介绍如何利用Delphi的Server组件集将数据库中的记录集导出到Word,Excel与Powerpoint文档中,从而实现信息管理系统的办公自动化模块。

Landmark和Geoframe软件的集成

Landmark和Geoframe软件所带数据库不能同时存在于同一硬件上,所以只能将其安装在不同的工作站上,这样增加了硬件成本,又给实际工作带来问题。利用Oracle数据库多实例共存的特点,解决同一硬件系统上数据库共存的问题,实现Landmark和Geoframe软件的集成。通过实际工作的检验,集成的软件运行稳定正常,用户使用方便,软件集成技术操作简单、实用。

新型冠状病毒肺炎专病库的建设与应用

旨在通过对长春中医药大学附属医院医疗队救治的新型冠状病毒肺炎患者临床数据的收集和整理,建立服务于临床医生和科研人员的新型冠状病毒肺炎专病库,为总结中医药干预新型冠状病毒肺炎的临床疗效提供有力支撑。依托长春中医药大学附属医院科研一体化平台,以新型冠状病毒肺炎患者为研究对象,融合与处理多源异构数据,经过数据集成、数据清洗、数据整合、数据后结构化等数据治理过程,形成新冠肺炎疾病结构化数据库标准数据集。专病库纳入患者1138例,为开展新型冠状病毒肺炎临床研究提供了有力的数据支撑,为充分利用相关临床研究数据开展各类临床研究提供了充分的保障。

医院重症医学专病库的建设与应用

目的构建具有科研应用及临床应用意义的重症医学专病库。方法基于医院构建的临床研究数据平台,挖掘重症医学相关的业务系统数据,建立重症医学专病标准数据集模型,实现专病库数据的自动采集与整合,形成具有数据分析与检索能力的重症医学数据库及应用平台。结果通过数据治理,将医院沉淀10年的重症医学数据重构为符合重症研究需要的重症医学专病库,实现了系统自动、持续地生成高质量、标准化、结构化的重症患者诊疗数据。结论搭建的重症医学数据库及应用平台可实现重症患者病例检索、病程浏览和患者数据导出等功能,支持重症医学相关课题研究,辅助科研人员建立临床预测模型,并应用于临床,验证其辅助诊疗效果.

书同文字与再造书契——论古籍数字化时代的字符统一与文本规范

随着古籍的电子化与数据库应用,曾经停废的大量汉字被激活。字体字形多样、字际关系复杂和编码系统不一,严重阻碍了古籍文本的编辑、保存、呈现、转换、检索及深度利用。文本的电子化、规范化及标准化是古籍数字化的起点,也是数字设施建设和数字人文研究的基础。近代以来新旧字体、正俗字形与字符编码的三次系统性变更,决定了字符集与文本库建设只能以发布的各种国家标准为基础。纵观历史,汉字一直处在不断统一规范的进程中,汉文典籍的一致性让中华文明具有突出的统一性。创建统一字符集和标准文本库将是继秦朝“书同文字”之后的全新规范,也是汉字系统继从刻画到书写,又到数码形态的再次重置。“再造书契”有利于实现古籍数据的统一刻画、深度标引、交互整合和多功能开发,促进古籍文本结构化、知识体系化、平台智能化,推动古籍整理利用的转型升级。

尿路结石专病数据库建设及应用

目的:基于昆明医科大学第二附属医院尿路结石患者临床诊疗数据,建立尿路结石专病数据库,为尿路结石疾病临床诊疗随访及科研数字化管理提供平台。方法:基于2013年1月至2022年6月就诊于昆明医科大学第二附属医院尿路结石患者相关临床诊疗数据,利用自然语言技术实现数据库的结构化,并根据行业标准实现数据元标准化。结果:尿路结石专病数据库共纳入业务域14个、数据域148个和数据元617个,实现了对26764例尿路结石患者临床诊疗数据采集及新入数据定期采集、检索功能,建立了患者随访数据采集系统,实现了数据标准化。结论:昆明医科大学第二附属医院尿路结石专病数据库的建立,为尿路结石临床诊疗、随访、临床科研数字化管理打下了坚实的基础。

铜死亡基因在骨关节炎免疫浸润中的生物信息学分析

背景:免疫浸润在骨关节炎的病程发展过程中发挥着重要作用,而铜死亡是近期最新发现的一种新型细胞程序性死亡,目前尚未有铜死亡基因调控免疫浸润在骨关节炎中的相关机制研究。目的:整合铜死亡基因和GEO数据库相关芯片,分析铜死亡基因与免疫浸润之间的关联性,构建风险模型,并进行基因本体、京都基因与基因组百科全书富集分析以及miRNA、中药预测,为今后骨关节炎免疫浸润方面的铜死亡机制挖掘提供理论支持。方法:通过GEO数据库检索符合条件的骨关节炎相关芯片,对其进行标准化处理;基于处理后的基因表达矩阵进行免疫浸润提取和量化,分析免疫浸润细胞及功能之间的相关性,以及它们在骨关节炎组和对照组中的差异性;整合处理后的铜死亡基因表达矩阵和标准化处理后的芯片基因表达矩阵,筛选出与骨关节炎相关的铜死亡基因,并构建风险模型,分析骨关节炎铜死亡相关基因的风险概率,另外通过FunRich软件预测其上游miRNA;最后通过Enrichr网站和Coremine Medical数据库对骨关节炎铜死亡相关基因进行基因本体、京都基因与基因组百科全书富集分析及中药预测。结果与结论:①免疫浸润相关性结果显示,树状突细胞和肥大细胞呈最强的正相关性(r=0.87),肥大细胞和肿瘤浸润淋巴细胞呈最强的负相关性(r=-0.81);②免疫浸润差异性分析显示,骨关节炎组中的树状突细胞、未成熟树状突细胞、巨噬细胞、肥大细胞、中性粒细胞、抗原呈递共抑制和趋化因子C-C-基序受体显著增加(P<0.05),而B细胞、Th2细胞和T细胞共刺激则显著减少(P<0.05);③共筛选出10个骨关节炎铜死亡基因,分别为SLC31A1、PDHB、PDHA1、LIPT1、LIAS、DLD、FDX1、DLST、DLAT、DBT,其中风险模型结果显示,PDHB可能是骨关节炎的风险因子;④富集分析结果,骨关节炎铜死亡基因主要富集在柠檬酸循环、丙酮酸代谢、糖酵解/糖异生等相关信号通路上;⑤通过Coremine Medical数据库共预测到包括温莪术(0.00475)、黄芩(0.049)、红景天苷(0.000237)等在内的27味中药和1种中药活性成分,其中红景天苷是此次研究中骨关节炎独立风险因子PDHB潜在的治疗中药活性成分;⑥FunRich软件共预测到包括has-miR-7a-5p、has-miR-7e-5p、has-miR-96-5p在内的29个骨关节炎铜死亡相关基因上游miRNA;⑦结果显示,骨关节炎铜死亡基因主要通过调节柠檬酸循环、丙酮酸代谢、糖酵解/糖异生等相关信号通路,影响树状突细胞、巨噬细胞、B细胞、抗原呈递共抑制等相关免疫细胞和功能在骨关节炎患者中的变化;在此过程中,包括has-miR-7a-5p、has-miR-7e-5p、has-miR-96-5p在内的29个miRNA可能也发挥着重要作用;另外,羊肝、温莪术和红景天苷等中药和中药活性成分可能是其潜在的分子药物来源。

空间方向关系表达与推理模型研究综述

空间方向关系作为空间关系不可缺少的组成部分,广泛应用于城市智能交通管控、环境资源检测、防灾减灾等诸多任务,日益成为地理信息系统、空间数据库、人工智能、模式识别等领域研究的热点。综合分析和梳理现有空间方向关系表达与推理模型,针对二维空间对象,从单目标对象、群组目标对象等方面详细介绍目前二维空间方向关系表达与推理模型的研究进展,依据描述对象的不同进行分类,对每类模型的特性及适用范围进行定性分析比较。针对三维空间对象,从点到区域依次分析当前三维空间方向关系表达与推理模型的特点、优势和不足。针对不确定性对象,从确定性空间方向关系模型的扩展模型、基于不确定性集合理论模型2个方面阐述不确定性方向关系模型的研究现状,并对每类模型的优缺点、适用范围等进行分析总结。最后阐明当前工作存在的不足,并从自动推理技术、空间关系的联合表达以及群组目标对象等方面对空间方向关系的未来研究方向进行展望。

基于预处理-枚举的子图匹配算法

子图匹配是从与查询图格式相同的数据图中找到所有嵌入。目前常用的算法主要通过基于查询图在数据图上生成树结构索引来工作,对树中的顶点根到叶的路径进行排序,并按照匹配顺序枚举嵌入。但是这种处理方式由于没有考虑路径中邻接点之间的影响,其基于路径的排序和基于树结构的枚举在本质上限制了算法的性能。为了解决这个问题,提出了一种基于预处理-枚举的子图匹配算法。先通过查询顶点的前向邻居生成候选集,再通过后向邻居对候选集进行精化得到更小的候选集。同时,根据查询顶点的候选数量和度生成匹配顺序,进一步消除了基于路径的排序带来的限制。针对真实数据集的模拟实验结果表明,所提出的算法与现有的算法相比具有更好的候选集过滤效果和更快的匹配速度。

基于TCGA及Oncomine数据库挖掘TMEM164在肝细胞癌中的表达及临床意义

目的TMEM164是TMEM家族的一员,实验基于肿瘤基因组图谱(TCGA)和Oncomine数据库评估了TMEM164在肝细胞癌中表达及临床意义。方法从GDC Data Portal网站(https://portal.gdc.cancer.gov/)下载424例HCC的RNA表达谱和临床病理参数资料。其中肝细胞癌(HCC)组织374例,癌旁正常组织50例。借助Oncomine数据库进一步扩大样本量,验证TCGA数据库分析结果是否正确。采用Kaplan-Meier曲线和Cox回归分析TMEM164表达与患者预后的相关性,并进行基因集富集分析(GSEA),探讨其潜在作用机制。结果TMEM164在HCC组织中表达量显著高于癌旁正常组织(P<0.001);TMEM164表达水平与HCC患者的Stage分期和T分期均显著相关(P<0.05);生存分析显示TMEM164高表达患者总生存率显著低于低表达患者(P<0.01);单因素及多因素Cox回归分析结果表明TMEM164高表达可能作为HCC患者预后的独立指标。GSEA表明TMEM164可能通过调控mTOR、ERBB等通路进而调控细胞周期、凋亡、自噬及RNA降解等参与HCC的进程,此外TMEM164还可能作用于与免疫相关的信号通路。结论TMEM164在肝细胞癌中高表达,与患者预后不良相关,可能成为HCC患者的预后标志物及潜在治疗靶点。

基于SET-CNN的紧凑型地波雷达弱目标检测方法

紧凑型高频地波雷达发射功率较低且采用小孔径阵列,导致雷达回波中的弱目标增多,进而引起基于距离-多普勒谱的目标检测方法性能降低,目标探测能力减弱。为提高紧凑型地波雷达对弱目标的检测性能,本文提出一种基于同步提取变换-卷积神经网络(Synchroextracting Transform-Convolutional Neural Network,SET-CNN)的紧凑型地波雷达弱目标检测方法:首先在时频谱处理中,利用信噪比方法抑制信号中的海杂波,减少杂波时频脊线对目标检测的影响;然后基于SET时频谱构建时频脊线样本数据库,再通过卷积神经网络进行时频脊线分类,并基于分类结果的后处理完成船只目标检测。通过仿真和实测数据验证提出的目标检测方法,结果表明,本文提出的方法能够有效检测到弱目标,提高紧凑型地波雷达的目标检测性能。

基于最小割集的核安全风险评价在线计算方法研究

基于计算机技术,研究支持多任务场景的最小割集高效算法和风险模型重构后最小割集算法数据库的高效更新方式,在提升风险监测器计算速度的同时,满足多任务多场景下的风险高效计算要求,并为下一阶段高效计算引擎的开发提供数据算法依据。