Rapid prototyping strategy for a surgical data warehouse.

S-T Tang; Y-F Huang; M-L Hsiao; S-H Yang; S-T Young

PubMed · 12874656

Rapid prototyping strategy for a surgical data warehouse.

S-T Tang·Y-F Huang·M-L Hsiao·S-H Yang·S-T Young

Abstract

OBJECTIVES: Healthcare processes typically generate an enormous volume of patient information. This information largely represents unexploited knowledge, since current hospital operational systems (e.g., HIS, RIS) are not suitable for knowledge exploitation. Data warehousing provides an attractive method for solving these problems, but the process is very complicated. This study presents a novel strategy for effectively implementing a healthcare data warehouse. METHODS: This study adopted the rapid prototyping (RP) method, which involves intensive interactions. System developers and users were closely linked throughout the life cycle of the system development. The presence of iterative RP loops meant that the system requirements were increasingly integrated and problems were gradually solved, such that the prototype system evolved into the final operational system. RESULTS: The results were analyzed by monitoring the series of iterative RP loops. First a definite workflow for ensuring data completeness was established, taking a patient-oriented viewpoint when collecting the data. Subsequently the system architecture was determined for data retrieval, storage, and manipulation. This architecture also clarifies the relationships among the novel system and legacy systems. Finally, a graphic user interface for data presentation was implemented. CONCLUSIONS: Our results clearly demonstrate the potential for adopting an RP strategy in the successful establishment of a healthcare data warehouse. The strategy can be modified and expanded to provide new services or support new application domains. The design patterns and modular architecture used in the framework will be useful in solving problems in different healthcare domains.

Explore related subjects

Colorectal Surgery Computer Systems Data Collection Database Management Systems Efficiency, Organizational Hospitals, University Humans Information Centers Information Storage and Retrieval Operating Room Information Systems Systems Integration Taiwan User-Computer Interface Workload Journal Article Research Support, Non-U.S. Gov't

Keep this discovery

Explore connections, maps & timelines

BibTeX RIS

S-T Tang, Y-F Huang, M-L Hsiao, S-H Yang, S-T Young. 2003. Rapid prototyping strategy for a surgical data warehouse.. https://pubmed.ncbi.nlm.nih.gov/12874656/

Cite the original work for its findings. Save a collection to share your selection of sources.

PubMed2006

Modern management of rectal cancer: a 2006 update.

The goal of this review is to outline some of the important surgical issues surrounding the management of patients with early (T1/T2 and N0), as well as locally advanced (T3/T4 and/or N1) rectal cancer. Surgery for rectal cancer continues to develop towards the ultimate goals of improved local control and overall survival, maintaining quality of life, and preserving sphincter, genitourinary, and sexual function. Information concerning the depth of tumor penetration through the rectal wall, lymph node involvement, and presence of distant metastatic disease is of crucial importance when planning a curative rectal cancer resection. Preoperative staging is used to determine the indication for neoadjuvant therapy as well as the indication for local excision versus radical cancer resection. Local excision is likely to be curative in most patients with a primary tumor which is limited to the submucosa (T1N0M0), without high-risk features and in the absence of metastatic disease. In appropriate patients, minimally invasive procedures, such as local excision, TEM, and laparoscopic resection allow for improved patient comfort, shorter hospital stays, and earlier return to preoperative activity level. Once the tumor invades the muscularis propria (T2), radical rectal resection in acceptable operative candidates is recommended. In patients with transmural and/or node positive disease (T3/T4 and/or N1) with no distant metastases, preoperative chemoradiation followed by radical resection according to the principles of TME has become widely accepted. During the planning and conduct of a radical operation for a locally advanced rectal cancer, a number of surgical management issues are considered, including: (1) total mesorectal excision (TME); (2) autonomic nerve preservation (ANP); (3) circumferential resection margin (CRM); (4) distal resection margin; (5) sphincter preservation and options for restoration of bowel continuity; (6) laparoscopic approaches; and (7) postoperative quality of life.

Colorectal Surgery↗

Rapid prototyping strategy for a surgical data warehouse.

Abstract

Explore related subjects

Keep this discovery

Related citations

Disclosure of information in English case law.

Modern management of rectal cancer: a 2006 update.

Prospective surveillance effectively reduced rates of surgical site infection associated with elective colorectal surgery at a university hospital in Japan.