Objective To improve the data storage performance of Oracle database and simplify data storage management in No.1 Military Medical Project.Methods Using the automatic storage management provided by Oracle 10g,Oracle database in No.1 Military Medical Project was upgraded to Oracle 10g,and then the upgraded Oracle database was migrated to Oracle automatic storage management system.At last,all kinds of tests were made to the Oracle automatic storage management system.Results Oracle automatic storage management system greatly simplified data storage management in such aspects as automatic disk striping,automatic datafile mirroring,automatic disk loads rebalancing,etc.Conclusion This method is simple and feasible with low cost.

Aiming at different Oracle database editions, this paper puts forwards several recovery solutions, including the technology of point-in-time recovery, redo logminer, and database flashback.

Objective To upgrade Oracle database to Oracle 10g Release 2 in No.1 Military Medical Project. Methods Technologies such as database upgrade assistance, manual script upgrade, exp/imp(expdp/impdp)of DBUA, transportable tablespace, materialized view and table copy were used to upgrade Oracle database respectively. Results It showed that all of these methods could upgrade Oracle database. Conclusion Although all of these methods can upgrade Oracle database, there are differences in their procedures and efficencies, so suitable methods should be chosen according to practical situation.

Objective To discuss the influence of Open resetlogs on Oracle database recovery. Methods Database backup was used to recover database before resetlogs. Before Oracle 9i, Oracle database was recovered through two steps; after Oracle10g, Oracle archived redo log by new format. Results Both methods could recover Oracle database by using backups before resetlogs. Conclusion Before Oracle9i, the recovery steps are complex, so it is suggested a consistent database backup should be made after resetlogs. By using the new archived redo log format after Oracle10g, it is easy to recover database through resetlogs.

Objective:To explore the curative effects of individualized surgical method for treating pyriform sinus fistula (PSF) in children.Methods:A total of 43 PSF children treated in the Department of Pediatric Surgery of Henan Provincial People′s Hospital from June 2015 to November 2019 were selected, with 41 cases on the left side and 2 cases on the right side.There were 27 cases in the quiescent inflammatory infection stage and 16 cases in the acute inflammatory infection stage.According to patients′ condition, low-temperature plasma radiofrequency ablation, fistulectomy, abscess incision and drainage or combined operation were conducted.The postoperative complications and recurrence were observed.Results:Among 43 cases, there were 19 cases treated with low-temperature plasma radiofrequency ablation, 11 cases treated with low-temperature plasma radiofrequency ablation combined with abscess incision and drainage, 5 cases treated with low-temperature plasma radiofrequency ablation combined with fistulectomy, and 8 cases treated with fistulectomy.Four cases had postoperative hoarseness and recovered within 1-5 months.One case occurred pseudo healing after abscess incision and drainage, and healed after incision and debridement.Totally, 4 cases recurred, and the follow-up time was from 3 months to 57 months.Conclusions:Low-temperature plasma radiofrequency ablation has the advantages of minimally invasive, safe and effective, which provides a new treatment for PSF in children.Based on the condition of children, the choice of individualized treatment can significantly improve the curative effects.