Oracle数据库系统通过 REDO L OG技术来管理数据操作和事务 ,如何分析跟踪 REDO L OG文件 ,实现对数据库操作的监控 ,在数据库审计、数据库复制和数据库安全等方面具有重要的实用价值 .本文对 ORACL E REDO L OG文件进行了详尽的分析 ,...Oracle数据库系统通过 REDO L OG技术来管理数据操作和事务 ,如何分析跟踪 REDO L OG文件 ,实现对数据库操作的监控 ,在数据库审计、数据库复制和数据库安全等方面具有重要的实用价值 .本文对 ORACL E REDO L OG文件进行了详尽的分析 ,给出了 REDO L OG文件头、文件体块结构和文件数据结构的 C语言描述 ,以及 REDO L OG事务控制机制的分析 。展开更多
随着财务系统数据库的使用时间增长,数据库中的数据量也会增加,数据量越大也意味着数据库备份与恢复所需要的成本就越高,不仅是备份所需时间越来越长,恢复数据所需时间也随之增长;当数据库发生意外而导致数据库中的数据不可修复的时候,...随着财务系统数据库的使用时间增长,数据库中的数据量也会增加,数据量越大也意味着数据库备份与恢复所需要的成本就越高,不仅是备份所需时间越来越长,恢复数据所需时间也随之增长;当数据库发生意外而导致数据库中的数据不可修复的时候,容灾远比备份更能快速有效的恢复生产业务的数据;在实际的使用过程中,我们也可以把容灾当做是一个活动的备份来使用,主要介绍了Oracle Data Guard和GoldenGate。展开更多
Objectives:To assess the effect of redo inferior pubectomy on the management of complicated pelvic fracture urethral injury(PFUI)in patients with a history of failed anastomotic urethroplasty.Materials and methods:We ...Objectives:To assess the effect of redo inferior pubectomy on the management of complicated pelvic fracture urethral injury(PFUI)in patients with a history of failed anastomotic urethroplasty.Materials and methods:We retrospectively reviewed all patients receiving redo anastomotic urethroplasty with redo inferior pubectomy for failed PFUI between January 2010 and December 2021.Patients with incomplete data and those who were lost to follow-up were excluded.Successful urethroplasty was defined as the restoration of a uniform urethral caliber without stenosis or leakage and further intervention.Functional results,including erectile function and urinary continence,were evaluated.Descriptive statistical analyses were then performed.Results:Thirty-one patients were included in this study.Among them,concomitant urethrorectal fistula occurred in 2 patients,and concomitant enlarged bladder neck occurred in 1.The stenosis site was the bulbomembranous urethra in 2 patients and the prostatomembranous urethra in 29.The mean length of urethral stenosis in all patients was 3.1 cm(range,2.0-5.0 cm).After a mean follow-up of 34.6 months,the final success rate was 96.8%.The incidence of erectile dysfunction reached 77.4%(24/31).Normal continence was achieved in 27(87.1%)patients.One patient developed urinary incontinence of gradeⅡrequiring urinary pads because of an enlarged bladder neck.According to the Clavien-Dindo classification,postoperative complications of grade I occurred in 7 patients and gradeⅡin 4.Conclusions:Repeat anastomotic urethroplasty with repeat inferior pubectomy provides reliable success rates for failed PFUI.In complicated cases,it should be known and mastered.展开更多
Background: With the increasing number of laparoscopic fundoplications, many more patients with a failed primary antireflux operation are being referred for complex redo procedures. The objective of this study was to ...Background: With the increasing number of laparoscopic fundoplications, many more patients with a failed primary antireflux operation are being referred for complex redo procedures. The objective of this study was to evaluate our results of redo antireflux surgery using the Belsey Mark IV (BMIV) Repair. Methods: A retrospective analysis of the patients who underwent BMIV repair following a failed fundoplication was performed. The primary endpoint was failure of the redo procedure and recurrent hiatal hernia. Secondary endpoints were assessment of the functional results of the redo fundoplication and quality of life with a Dysphagia Score, and Gastroesophageal Reflux Disease-Health-Related Quality of Life (GERD-HRQOL) questionnaire. Results: 206 patients underwent surgery for failed primary fundoplication. Most patients had one prior antireflux surgery 148/206 (71.8%). The most common primary failed fundoplication was the Nissen procedure (189/206, 91.7%). The median time from the prior operation to the redo operation was 34 months. Median follow-up was 25.6 months. The Dysphagia score decreased from 3.6 ± 0.5 preoperatively to 1.0 ± 0.4 postoperatively (p < 0.0001). At the time of follow-up, the Median GERD-HRQL score was 4 (range 0 - 9), classified as excellent, compared to a preoperative Median GERD-HRQL score of 43 (range 41 - 50) which was classified as poor. (p < 0.0001). There was no recurrence of the hiatal hernia. Conclusion: Complete takedown and reestablishment of the normal anatomy, recognition of a short esophagus, and proper placement of the wrap are essential components of a redo antireflux procedure. The BMIV repair as the choice of reopertaive procedure results in excellent symptom relief, significant improvement in quality of life, and is associated with excellent medium-term durability in terms of recurrence of the hiatal hernia.展开更多
Stroke rate in redo coronary artery bypass surgery has remained a stumbling block, where the aorta is used as origin for the top end of the vein graft. Avoiding the side-clamp on these redo aortas by using the Vettath...Stroke rate in redo coronary artery bypass surgery has remained a stumbling block, where the aorta is used as origin for the top end of the vein graft. Avoiding the side-clamp on these redo aortas by using the Vettath’s Anastomotic Obturator (VAO) technique of anatomosing the vein graft could bring this down. We have also been able to use this technique in combined aortic valve replacement and CABG. These two situations where the VAO is used are elucidated here.展开更多
Redo sternotomy in pediatric patients can be complicated due to the unsuitability of many arterial cannulation sites for the pediatric population. Innominate artery cannulation provides a safe and easily reproducible ...Redo sternotomy in pediatric patients can be complicated due to the unsuitability of many arterial cannulation sites for the pediatric population. Innominate artery cannulation provides a safe and easily reproducible alternative and prevents many of the disadvantages seen in femoral and axillary artery cannulation. Its use in pediatric cardiac surgery has seen a rise [1]. Herein, we describe the technique for innominate artery cannulation in pediatric patients undergoing redo sternotomy and review our experience with the technique.展开更多
Interactions between chalcopyrite and bornite during bioleaching by moderately thermophilic bacteria were investigated mainly by X-ray diffraction, scanning electron microscopy, and electrochemical measurements perfor...Interactions between chalcopyrite and bornite during bioleaching by moderately thermophilic bacteria were investigated mainly by X-ray diffraction, scanning electron microscopy, and electrochemical measurements performed in conjunction with bioleaching experiments. The results showed that a synergistic effect existed between chalcopyrite and bornite during bioleaching by both Acidithiobacillus caldus and Leptospirillum ferriphilum and that extremely high copper extraction could be achieved when chalcopyrite and bornite coexisted in a bioleaching system. Bornite dissolved preferentially because of its lower corrosion potential, and its dissolution was accelerated by the galvanic current during the initial stage of bioleaching. The galvanic current and optimum redox potential of 390-480 m V vs. Ag/Ag Cl promoted the reduction of chalcopyrite to chalcocite(Cu2S), thus accelerating its dissolution.展开更多
Background Reoperation for total colonic aganglionosis(TCA)may be required for residual aganglionosis after an initial radical operation.We aimed to investigate the symptoms,management,and outcomes of patients who req...Background Reoperation for total colonic aganglionosis(TCA)may be required for residual aganglionosis after an initial radical operation.We aimed to investigate the symptoms,management,and outcomes of patients who required a redo pullthrough(Redo PT).Methods Nine TCA patients underwent Redo PT at our center between 2007 and 2017.Their medical records were reviewed.Parental telephone interviews that included disease-specific clinical outcomes were conducted,and post-operative complications and long-termoutcomes(including height-for-age/weight-for-age and bowel-function score)were compared to those of single-pull-through(Single PT)patients(n=21).Results All the nine Redo PT patients suffered obstruction within 1 month after the initial operation that could not be alleviated by conservative treatment.All abdominal X-ray/contrast barium enemas showed proximal bowel dilatation,indicating residual aganglionosis.The median ages at the initial operation and Redo PT were 200 and 509 days,respectively.Reoperation consisted of an intraoperative frozen biopsy and a modified laparotomic Soave procedure in all patients.Postoperative complications included perianal excoriation(n=3),intestinal obstruction(n=2),enterocolitis(n=2),and rectovestibular fistula(n=1).Seven Redo PT patients were followed up for a mean time of 7.162.3 years;six(85.7%)had good growth and four(57.1%)had good bowel-function recovery.Post-operative complications and long-term outcomes were almost equal between the Redo PT and Single PT groups(all P>0.05).Conclusion TCA patients with recurrent obstructive symptoms and dilated proximal bowel may have residual aganglionosis after an initial operation.Redo PT is effective and provides good long-termoutcomes comparable to those of patients who benefited from Single PT.展开更多
文摘Oracle数据库系统通过 REDO L OG技术来管理数据操作和事务 ,如何分析跟踪 REDO L OG文件 ,实现对数据库操作的监控 ,在数据库审计、数据库复制和数据库安全等方面具有重要的实用价值 .本文对 ORACL E REDO L OG文件进行了详尽的分析 ,给出了 REDO L OG文件头、文件体块结构和文件数据结构的 C语言描述 ,以及 REDO L OG事务控制机制的分析 。
文摘随着财务系统数据库的使用时间增长,数据库中的数据量也会增加,数据量越大也意味着数据库备份与恢复所需要的成本就越高,不仅是备份所需时间越来越长,恢复数据所需时间也随之增长;当数据库发生意外而导致数据库中的数据不可修复的时候,容灾远比备份更能快速有效的恢复生产业务的数据;在实际的使用过程中,我们也可以把容灾当做是一个活动的备份来使用,主要介绍了Oracle Data Guard和GoldenGate。
基金supported by the National Natural Science Foundation of China(no.82100707 and 82270707)Shanghai Municipal Health Commission research project(no.202140191).
文摘Objectives:To assess the effect of redo inferior pubectomy on the management of complicated pelvic fracture urethral injury(PFUI)in patients with a history of failed anastomotic urethroplasty.Materials and methods:We retrospectively reviewed all patients receiving redo anastomotic urethroplasty with redo inferior pubectomy for failed PFUI between January 2010 and December 2021.Patients with incomplete data and those who were lost to follow-up were excluded.Successful urethroplasty was defined as the restoration of a uniform urethral caliber without stenosis or leakage and further intervention.Functional results,including erectile function and urinary continence,were evaluated.Descriptive statistical analyses were then performed.Results:Thirty-one patients were included in this study.Among them,concomitant urethrorectal fistula occurred in 2 patients,and concomitant enlarged bladder neck occurred in 1.The stenosis site was the bulbomembranous urethra in 2 patients and the prostatomembranous urethra in 29.The mean length of urethral stenosis in all patients was 3.1 cm(range,2.0-5.0 cm).After a mean follow-up of 34.6 months,the final success rate was 96.8%.The incidence of erectile dysfunction reached 77.4%(24/31).Normal continence was achieved in 27(87.1%)patients.One patient developed urinary incontinence of gradeⅡrequiring urinary pads because of an enlarged bladder neck.According to the Clavien-Dindo classification,postoperative complications of grade I occurred in 7 patients and gradeⅡin 4.Conclusions:Repeat anastomotic urethroplasty with repeat inferior pubectomy provides reliable success rates for failed PFUI.In complicated cases,it should be known and mastered.
文摘Background: With the increasing number of laparoscopic fundoplications, many more patients with a failed primary antireflux operation are being referred for complex redo procedures. The objective of this study was to evaluate our results of redo antireflux surgery using the Belsey Mark IV (BMIV) Repair. Methods: A retrospective analysis of the patients who underwent BMIV repair following a failed fundoplication was performed. The primary endpoint was failure of the redo procedure and recurrent hiatal hernia. Secondary endpoints were assessment of the functional results of the redo fundoplication and quality of life with a Dysphagia Score, and Gastroesophageal Reflux Disease-Health-Related Quality of Life (GERD-HRQOL) questionnaire. Results: 206 patients underwent surgery for failed primary fundoplication. Most patients had one prior antireflux surgery 148/206 (71.8%). The most common primary failed fundoplication was the Nissen procedure (189/206, 91.7%). The median time from the prior operation to the redo operation was 34 months. Median follow-up was 25.6 months. The Dysphagia score decreased from 3.6 ± 0.5 preoperatively to 1.0 ± 0.4 postoperatively (p < 0.0001). At the time of follow-up, the Median GERD-HRQL score was 4 (range 0 - 9), classified as excellent, compared to a preoperative Median GERD-HRQL score of 43 (range 41 - 50) which was classified as poor. (p < 0.0001). There was no recurrence of the hiatal hernia. Conclusion: Complete takedown and reestablishment of the normal anatomy, recognition of a short esophagus, and proper placement of the wrap are essential components of a redo antireflux procedure. The BMIV repair as the choice of reopertaive procedure results in excellent symptom relief, significant improvement in quality of life, and is associated with excellent medium-term durability in terms of recurrence of the hiatal hernia.
文摘Stroke rate in redo coronary artery bypass surgery has remained a stumbling block, where the aorta is used as origin for the top end of the vein graft. Avoiding the side-clamp on these redo aortas by using the Vettath’s Anastomotic Obturator (VAO) technique of anatomosing the vein graft could bring this down. We have also been able to use this technique in combined aortic valve replacement and CABG. These two situations where the VAO is used are elucidated here.
文摘Redo sternotomy in pediatric patients can be complicated due to the unsuitability of many arterial cannulation sites for the pediatric population. Innominate artery cannulation provides a safe and easily reproducible alternative and prevents many of the disadvantages seen in femoral and axillary artery cannulation. Its use in pediatric cardiac surgery has seen a rise [1]. Herein, we describe the technique for innominate artery cannulation in pediatric patients undergoing redo sternotomy and review our experience with the technique.
基金financially supported by the National Natural Science Foundation of China (Nos. 51374248 and 51320105006)the Program for New Century Excellent Talents in University (No. NCET-13-0595)the China Postdoctoral Science Foundation (No. 2014T70692)
文摘Interactions between chalcopyrite and bornite during bioleaching by moderately thermophilic bacteria were investigated mainly by X-ray diffraction, scanning electron microscopy, and electrochemical measurements performed in conjunction with bioleaching experiments. The results showed that a synergistic effect existed between chalcopyrite and bornite during bioleaching by both Acidithiobacillus caldus and Leptospirillum ferriphilum and that extremely high copper extraction could be achieved when chalcopyrite and bornite coexisted in a bioleaching system. Bornite dissolved preferentially because of its lower corrosion potential, and its dissolution was accelerated by the galvanic current during the initial stage of bioleaching. The galvanic current and optimum redox potential of 390-480 m V vs. Ag/Ag Cl promoted the reduction of chalcopyrite to chalcocite(Cu2S), thus accelerating its dissolution.
文摘Background Reoperation for total colonic aganglionosis(TCA)may be required for residual aganglionosis after an initial radical operation.We aimed to investigate the symptoms,management,and outcomes of patients who required a redo pullthrough(Redo PT).Methods Nine TCA patients underwent Redo PT at our center between 2007 and 2017.Their medical records were reviewed.Parental telephone interviews that included disease-specific clinical outcomes were conducted,and post-operative complications and long-termoutcomes(including height-for-age/weight-for-age and bowel-function score)were compared to those of single-pull-through(Single PT)patients(n=21).Results All the nine Redo PT patients suffered obstruction within 1 month after the initial operation that could not be alleviated by conservative treatment.All abdominal X-ray/contrast barium enemas showed proximal bowel dilatation,indicating residual aganglionosis.The median ages at the initial operation and Redo PT were 200 and 509 days,respectively.Reoperation consisted of an intraoperative frozen biopsy and a modified laparotomic Soave procedure in all patients.Postoperative complications included perianal excoriation(n=3),intestinal obstruction(n=2),enterocolitis(n=2),and rectovestibular fistula(n=1).Seven Redo PT patients were followed up for a mean time of 7.162.3 years;six(85.7%)had good growth and four(57.1%)had good bowel-function recovery.Post-operative complications and long-term outcomes were almost equal between the Redo PT and Single PT groups(all P>0.05).Conclusion TCA patients with recurrent obstructive symptoms and dilated proximal bowel may have residual aganglionosis after an initial operation.Redo PT is effective and provides good long-termoutcomes comparable to those of patients who benefited from Single PT.
