Introduction: Resection of malignant pelvic tumors has long been considered to be associated with higher postoperative mortality and morbidity than resection of malignant limb tumors. We compared the postoperative adv...Introduction: Resection of malignant pelvic tumors has long been considered to be associated with higher postoperative mortality and morbidity than resection of malignant limb tumors. We compared the postoperative adverse events of pelvic tumor surgery and limb tumor surgery using a national inpatient database. Methods: We identified patients who underwent surgery for primary musculoskeletal malignant tumors of the pelvis or limbs between July and December in 2007- 2010 using the Japanese Diagnosis Procedure Combination inpatient database. We calculated the risk-adjusted odds ratio for the occurrence of postoperative complications following pelvic tumor surgery with reference to limb tumor surgery using a multivariable logistic regression analysis. Results: Of 3255 eligible patients, 3116 underwent limb tumor surgery and 139 underwent pelvic tumor surgery. In-hospital mortality was 0.6% and 0.7% and postoperative complication rates were 8.2% and 18.7%, respectively. The rate of blood transfusion and duration of anesthesia over 480 min were higher in the pelvic tumor group. Blood transfusion volume and duration of anesthesia were independently associated with worse outcomes, but there was no significant association between tumor location and occurrence of postoperative complications (odds ratio 1.18, 95% confidence interval 0.73 - 1.88, p = 0.502). Conclusions: Blood transfusion volume and duration of anesthesia were significant predictors of outcome. Our data demonstrate that the higher morbidity rate after pelvic tumor resection could result from the larger blood transfusion volume and longer anesthesia duration.展开更多
Currently, endoscopic submucosal dissection(ESD) and laparoscopic gastrectomy(LG) have become widely accepted and increasingly play important roles in the treatment of gastric cancer. Data from an administrative datab...Currently, endoscopic submucosal dissection(ESD) and laparoscopic gastrectomy(LG) have become widely accepted and increasingly play important roles in the treatment of gastric cancer. Data from an administrative database associated with the diagnosis procedure combination(DPC) system have revealed some circumstances of ESD and LG in Japan. Some studiesdemonstrated that medical costs or length of stay of patients receiving ESD for gastric cancer had become significantly reduced while length of hospitalization and costs were significantly increased in older patients. With respect to LG, some recent reports have shown that this has been a cost-beneficial treatment for patients compared with open gastrectomy while simultaneous LG and cholecystectomy is a safe procedure for patients with both gastric cancer and gallbladder stones. These epidemiological studies using the administrative database in the DPC system closely reflect clinical circumstances of endoscopic and surgical treatment for gastric cancer in Japan. However, DPC database does not contain detailed clinical data such as histological types and lesion size of gastric cancer. The link between the DPC database and another detailed clinical database may be vital for future research into endoscopic and laparoscopic treatments for gastric cancer.展开更多
The paper firstly analyses disadvantages in the traditional Web database systems. And then it puts forward a simplified framework called database-oriented Web framework (DOWF). In this framework, the pages and the dat...The paper firstly analyses disadvantages in the traditional Web database systems. And then it puts forward a simplified framework called database-oriented Web framework (DOWF). In this framework, the pages and the data are all managed by database system. In order to get keywords or search a special page, which the users accessed before, users access the static pages by common script procedure (CSP), and access the dynamic pages by functional script procedure (FSP) and CSP. The article expounds the method how to implement DOWF in details. The paper also analyses the mechanism of a DOWF site by implementing a prototype system. At last, the article gives the features of DOWS in search, in security, in reuse of pages and in offline waiting, etc. Key words database-oriented - Web framework - common script procedure (CSP) - functional script procedure (FSP) CLC number TP 391 Foundation item: Supported by Natural Science Foundation of Jiangsu Province (BK2003030).Biography: ZHU Qiao-ming (1963-), male, professor, research direction: Web information processing chinses information processing.展开更多
随着工业物联网(industrial Internet of things,IIoT)的不断发展,越来越多的设备和传感器开始连接到网络中,产生了大量的时间序列数据(简称“时序数据”),时序数据爆炸式的增长给数据库管理系统带来了新的挑战:持续高吞吐量数据摄取、...随着工业物联网(industrial Internet of things,IIoT)的不断发展,越来越多的设备和传感器开始连接到网络中,产生了大量的时间序列数据(简称“时序数据”),时序数据爆炸式的增长给数据库管理系统带来了新的挑战:持续高吞吐量数据摄取、低延迟多维度数据查询、高性能时间序列索引以及低成本数据存储.近年来时序数据库技术已经成为一个研究热点,一些学者对时序数据库技术进行了深入的研究,同时出现了一些专门用于管理时序数据的时序数据库,并且已经被应用在多个领域,成为工业物联网中不可缺少的关键组成.现有的时序数据库相关综述侧重于时序数据库的功能和性能比较,以及在特定领域中对时序数据库的选择建议,缺少对时序数据库持久化存储、查询、计算和索引等关键技术的研究,同时这些综述工作出现的时间较早,缺少对现代时序数据库关键技术的研究.对学术界时序数据存储研究和工业界时序数据库进行了全面的调查和研究,凝练了时序数据库的4类关键技术:1)时间序列索引优化技术;2)内存数据组织技术;3)高吞吐量数据摄取和低延迟数据查询技术;4)海量历史数据低成本存储技术.同时分析总结了时序数据库评测基准.最后,展望了时序数据库关键技术在未来的发展方向.展开更多
存储过程和触发器是数据库中的重要编程对象,在系统设计中可以提升数据库的性能。触发器是一种特殊的存储过程,主要用于实现比约束更复杂的功能,维护数据的完整性。文章利用SQL Server 2019数据库管理工具,以商超管理系统为例,研究存储...存储过程和触发器是数据库中的重要编程对象,在系统设计中可以提升数据库的性能。触发器是一种特殊的存储过程,主要用于实现比约束更复杂的功能,维护数据的完整性。文章利用SQL Server 2019数据库管理工具,以商超管理系统为例,研究存储过程和触发器在该系统中的应用,并结合实际案例,给出了存储过程和触发器在解决具体业务问题中的实现方法。展开更多
The advantage of recursive programming is that it is very easy to write and it only requires very few lines of code if done correctly.Structured query language(SQL)is a database language and is used to manipulate data...The advantage of recursive programming is that it is very easy to write and it only requires very few lines of code if done correctly.Structured query language(SQL)is a database language and is used to manipulate data.In Microsoft SQL Server 2000,recursive queries are implemented to retrieve data which is presented in a hierarchical format,but this way has its disadvantages.Common table expression(CTE)construction introduced in Microsoft SQL Server 2005 provides the significant advantage of being able to reference itself to create a recursive CTE.Hierarchical data structures,organizational charts and other parent-child table relationship reports can easily benefit from the use of recursive CTEs.The recursive query is illustrated and implemented on some simple hierarchical data.In addition,one business case study is brought forward and the solution using recursive query based on CTE is shown.At the same time,stored procedures are programmed to do the recursion in SQL.Test results show that recursive queries based on CTEs bring us the chance to create much more complex queries while retaining a much simpler syntax.展开更多
文摘Introduction: Resection of malignant pelvic tumors has long been considered to be associated with higher postoperative mortality and morbidity than resection of malignant limb tumors. We compared the postoperative adverse events of pelvic tumor surgery and limb tumor surgery using a national inpatient database. Methods: We identified patients who underwent surgery for primary musculoskeletal malignant tumors of the pelvis or limbs between July and December in 2007- 2010 using the Japanese Diagnosis Procedure Combination inpatient database. We calculated the risk-adjusted odds ratio for the occurrence of postoperative complications following pelvic tumor surgery with reference to limb tumor surgery using a multivariable logistic regression analysis. Results: Of 3255 eligible patients, 3116 underwent limb tumor surgery and 139 underwent pelvic tumor surgery. In-hospital mortality was 0.6% and 0.7% and postoperative complication rates were 8.2% and 18.7%, respectively. The rate of blood transfusion and duration of anesthesia over 480 min were higher in the pelvic tumor group. Blood transfusion volume and duration of anesthesia were independently associated with worse outcomes, but there was no significant association between tumor location and occurrence of postoperative complications (odds ratio 1.18, 95% confidence interval 0.73 - 1.88, p = 0.502). Conclusions: Blood transfusion volume and duration of anesthesia were significant predictors of outcome. Our data demonstrate that the higher morbidity rate after pelvic tumor resection could result from the larger blood transfusion volume and longer anesthesia duration.
文摘Currently, endoscopic submucosal dissection(ESD) and laparoscopic gastrectomy(LG) have become widely accepted and increasingly play important roles in the treatment of gastric cancer. Data from an administrative database associated with the diagnosis procedure combination(DPC) system have revealed some circumstances of ESD and LG in Japan. Some studiesdemonstrated that medical costs or length of stay of patients receiving ESD for gastric cancer had become significantly reduced while length of hospitalization and costs were significantly increased in older patients. With respect to LG, some recent reports have shown that this has been a cost-beneficial treatment for patients compared with open gastrectomy while simultaneous LG and cholecystectomy is a safe procedure for patients with both gastric cancer and gallbladder stones. These epidemiological studies using the administrative database in the DPC system closely reflect clinical circumstances of endoscopic and surgical treatment for gastric cancer in Japan. However, DPC database does not contain detailed clinical data such as histological types and lesion size of gastric cancer. The link between the DPC database and another detailed clinical database may be vital for future research into endoscopic and laparoscopic treatments for gastric cancer.
文摘The paper firstly analyses disadvantages in the traditional Web database systems. And then it puts forward a simplified framework called database-oriented Web framework (DOWF). In this framework, the pages and the data are all managed by database system. In order to get keywords or search a special page, which the users accessed before, users access the static pages by common script procedure (CSP), and access the dynamic pages by functional script procedure (FSP) and CSP. The article expounds the method how to implement DOWF in details. The paper also analyses the mechanism of a DOWF site by implementing a prototype system. At last, the article gives the features of DOWS in search, in security, in reuse of pages and in offline waiting, etc. Key words database-oriented - Web framework - common script procedure (CSP) - functional script procedure (FSP) CLC number TP 391 Foundation item: Supported by Natural Science Foundation of Jiangsu Province (BK2003030).Biography: ZHU Qiao-ming (1963-), male, professor, research direction: Web information processing chinses information processing.
文摘随着工业物联网(industrial Internet of things,IIoT)的不断发展,越来越多的设备和传感器开始连接到网络中,产生了大量的时间序列数据(简称“时序数据”),时序数据爆炸式的增长给数据库管理系统带来了新的挑战:持续高吞吐量数据摄取、低延迟多维度数据查询、高性能时间序列索引以及低成本数据存储.近年来时序数据库技术已经成为一个研究热点,一些学者对时序数据库技术进行了深入的研究,同时出现了一些专门用于管理时序数据的时序数据库,并且已经被应用在多个领域,成为工业物联网中不可缺少的关键组成.现有的时序数据库相关综述侧重于时序数据库的功能和性能比较,以及在特定领域中对时序数据库的选择建议,缺少对时序数据库持久化存储、查询、计算和索引等关键技术的研究,同时这些综述工作出现的时间较早,缺少对现代时序数据库关键技术的研究.对学术界时序数据存储研究和工业界时序数据库进行了全面的调查和研究,凝练了时序数据库的4类关键技术:1)时间序列索引优化技术;2)内存数据组织技术;3)高吞吐量数据摄取和低延迟数据查询技术;4)海量历史数据低成本存储技术.同时分析总结了时序数据库评测基准.最后,展望了时序数据库关键技术在未来的发展方向.
文摘存储过程和触发器是数据库中的重要编程对象,在系统设计中可以提升数据库的性能。触发器是一种特殊的存储过程,主要用于实现比约束更复杂的功能,维护数据的完整性。文章利用SQL Server 2019数据库管理工具,以商超管理系统为例,研究存储过程和触发器在该系统中的应用,并结合实际案例,给出了存储过程和触发器在解决具体业务问题中的实现方法。
文摘The advantage of recursive programming is that it is very easy to write and it only requires very few lines of code if done correctly.Structured query language(SQL)is a database language and is used to manipulate data.In Microsoft SQL Server 2000,recursive queries are implemented to retrieve data which is presented in a hierarchical format,but this way has its disadvantages.Common table expression(CTE)construction introduced in Microsoft SQL Server 2005 provides the significant advantage of being able to reference itself to create a recursive CTE.Hierarchical data structures,organizational charts and other parent-child table relationship reports can easily benefit from the use of recursive CTEs.The recursive query is illustrated and implemented on some simple hierarchical data.In addition,one business case study is brought forward and the solution using recursive query based on CTE is shown.At the same time,stored procedures are programmed to do the recursion in SQL.Test results show that recursive queries based on CTEs bring us the chance to create much more complex queries while retaining a much simpler syntax.
