SSIS(SQL Server Integration Services,数据集成服务)是微软公司开发的一套用于解决异构数据集成问题的平台,具备数据仓库的提取、转换与加载数据包等功能。在SSIS的基础上,可使用微软的Visual Studio等开发工具创建、调用、展现各种类型的报表。因其搭建部署快捷、调试及后期维护简单,中小型企事业单位可广泛使用,其应用及部署是数据库开发人员关注的重点之一。笔者就SSIS的应用及部署进行简要阐述。
Surgical site infections (SSIs) are recognized as a common surgical complication, occurring in about 2% - 5% of all surgical procedures. For this reason, it is the second most common nosocomial infection, representing the 19.6% of all infections observed in hospitalized patients and 38% of those observed among surgical patients. Among SSIs prevention strategies, surveillance has been proved to be very incisive. The most recent surveillance study carried out at a national level in Italy is SNICh protocol (National Surveillance System of Surgical Site Infections), which analyses data received from 127 Italian hospitals, from the 2009 to 2011 and the entire 2013. The only application of a surveillance strategy, observing the recommended prophylaxis protocols, brought to a reduction of SSIs: their incidence has been shown to be comparable to European or American one. Furthermore, recent studies have brought strong evidence that the development of new devices, such as dressings impregnated with silver nanoparticles or triclosan-coated sutures, is strongly connected with the reduction of incidence of SSIs. In conclusion, if common preventive techniques were applied to all surgical procedures performed in the country, about 14,000 SSIs per year could be avoided with a possible savings after three years between 50 million and EUR 175 million euro.
Carlo de WerraSergio AloiaRosa di MiccoRoberto del GiudiceRoberto TramontanoFrancesco ManganiLudovica Maria EspositoGabriele di Filippo
目的探讨结直肠癌采用不同手术方式与易感菌株细菌分布的相关性,以及术后手术部位感染(Surgical Site Infections,SSIs)发生与易感菌株关系。方法采集本院164例确诊为结直肠癌手术患者的术后引流液进行细菌培养,按照美国临床和实验标准化研究所制定的指导原则进行结果判断,并采用统计方法对所取标本相应的手术方式与易感菌株、术后SSIs发生进行相关性分析。结果引流液各组标本分离细菌以革兰阴性菌(G-)为主。4组手术方式中的引流液细菌分离阳性率不全相同(P=0.031),其中左半结肠切除术+乙状结肠切除术组、经腹直肠癌前切除术组(Dixon’s术组)较高,分别占36.0%(9/25)、32.6%(29/89)。总体SSIs发生率为6%(10/164),以Dixon’s术组较高(7/89)。其样本分离菌株以大肠埃希菌为主。Dixon’s术引流液细菌分离阳性率与术后SSIs的发生有关联性(P<0.05)。结论不同手术方式易感菌株的来源主要以大肠埃希菌为代表的G-菌为主,结直肠癌手术方式与易感菌株引起术后SSIs存在一定关联性。