• Journal of KIISE:Computing Practices and Letters
• /
• v.15 no.3
• /
• pp.154-166
• /
• 2009

Database query and reporting tools, OLAP tools and data mining tools are typical front-end tools in Business Intelligence environment which is able to support gathering, consolidating and analyzing data produced from business operation activities and provide access to the result to enterprise's users. Traditional reporting tools have an advantage of creating sophisticated dynamic reports including SQL query result sets, which look like documents produced by word processors, and publishing the reports to the Web environment, but data source for the tools is limited to RDBMS. On the other hand, OLAP tools and data mining tools have an advantage of providing powerful information analysis functions on each own way, but built-in visualization components for analysis results are limited to tables or some charts. Thus, this paper presents a system that integrates three typical front-end tools to complement one another for BI environment. Traditional reporting tools only have a query editor for generating SQL statements to bring data from RDBMS. However, the reporting tool presented by this paper can extract data also from OLAP and data mining servers, because editors for OLAP and data mining query requests are added into this tool. Traditional systems produce all documents in the server side. This structure enables reporting tools to avoid repetitive process to generate documents, when many clients intend to access the same dynamic document. But, because this system targets that a few users generate documents for data analysis, this tool generates documents at the client side. Therefore, the tool has a processing mechanism to deal with a number of data despite the limited memory capacity of the report viewer in the client side. Also, this reporting tool has data structure for integrating data from three kinds of data sources into one document. Finally, most of traditional front-end tools for BI are dependent on data source architecture from specific vendor. To overcome the problem, this system uses XMLA that is a protocol based on web service to access to data sources for OLAP and data mining services from various vendors.

• Korean Journal of Environment and Ecology
• /
• v.23 no.2
• /
• pp.116-126
• /
• 2009

This study was carried out focused an ecological characteristics and habitat management of Abeliophyllum distichum subpopulations in the Byeonsanbando National Park, Korea. Among three subpopulations of the target species in the studied area, Gamaso region are known as translocation site due to the dam construction while the wild populations which is located at both the lower terrain of the Buandaem bank and Chongnim-ni, which is designated as Natural Monument No 370, is threat due to an intensive site management likes clearance of scrub amongst the Abeliophyllum plants. Vascular plant taxa in the studied sites were summarized as 182 taxa; 65 families, 143 genera, 164 species, 17 varieties and 1 form, and Gamaso area, the lower terrain of the Buandaem and Cheongnim-ni areas are summarized as 75, 102 and 89 taxa, respectively. The plant species likes persimmon tree, paulownia tree and wild mulberry tree are dominant species in the Gamaso subpopulation, while Quercus variabilis is dominant at the lower terrain of the Buandaem. The intensive site management was applied to the Cheongnim-ni subpopulation, one of the original wild habitats of the species. The population dymanics was varied; the one or two sprouting number of stems was over 87% both at Gamaso area and the lower terrain of the Buandam, while the Cheongnim-ni subpopulation recorded as 74.8%. Also three sprouting number recorded as 16% and as 9.2% for sprouting on numbers of four to eleven. The invaded species likes Chenopodium album, Rumex obtusifolius, Phytolacca americana, Pharbitis nil, Solanum lyratum, Erigeron canadensis and Erigeron annuus, were found at the wild habitat of the species, and those invaded species grow faster than Abeliophyllum plants. Among three habitats of the target species in the studied area, the habitat which in located at the lower terrain of the Buandam and Gamaso region are known as translocated due to the dam construction, and wild subpopulation at Chongnim-ni, which is designated as Natural Monument No 370, is under threatened due to an intensive site management likes clearance of scrub amongst the Abeliophyllumplants. It is one of the evidence that Cuscuta japonica at the population indicated an intensive site management likes clearance of scrub is not proper habitat management protocol. Thus, further researches should be followed to determine the effect of canopy removal and other disturbance factors as management techniques.

• Tuberculosis and Respiratory Diseases
• /
• v.44 no.6
• /
• pp.1366-1381
• /
• 1997

Background : Uvulopalatopharyngoplasty(UPPP) has become the most common surgical treatment for obstructive sleep apnea syndrome(OSAS). However, the results of this therapeutic modality have been quite variable with successful results by several authors and poor results by others. Until recently, in Korea, there is only a few reports about the clinical efficacy of UPPP. A prospective study was undertaken to evaluate the effectiveness and complications of UPPP. Method : Twenty-six OSAS patients who had undergone UPPP with preoperative and postoperative polysomnographic studies were included in this study. Two definitions of surgical success were used. The responder was defined, using a conventional criteria, as a 50% or more reduction in apnea index(AI) or apneahypopnea index(AHI) after UPPP, or a postoperative AI of <10 or AHI of <20. The initial cure was defined, using our own criteria, as a postoperative AI of <5 or AHI of <10. Complications were categorized in two groups : early(disorders during the first 10 postoperative days) and late. Results : Eighteen patients(69.2%) were responders, and ten patients(38.5%) were considered as initial cure. On the other hand, in five patients (19.2%), postoperative polysomnographic data demonstrated deterioration compared with preoperative data. Reduction rate of AI or AHI following UPPP was not significantly related to the preoperative body mass index, AI or AHI. There was no significant change of sleep architecture before and after UPPP in responder and initial cure groups. Early complications such as pain, dyspnea, bleeding, nasal reflux, dysphagia or wound disruption were observed in all patients. Late complications such as nasal reflux, voice change, dysphagia, loss of taste, pharyngeal dryness or foreign body sensation were discovered in 22 patients (84.6%). However, all early and late complications were of minor importance. Conclusion : The response to UPPP was favorable in approximately 70% of OSAS patient. However, the initial Cure rate of UPPP was relatively low. We suggest that selection of more appropriate surgical candidates and adequate surgical protocol is necessary to obtain a more successful result with UPPP.

• Journal of Intelligence and Information Systems
• /
• v.16 no.2
• /
• pp.73-94
• /
• 2010

The attending system is a medical system that allows doctors in clinics to use the extra equipment in hospitals-beds, laboratory, operating room, etc-for their patient's care under a contract between the doctors and hospitals. Therefore, the system is very beneficial in terms of the efficiency of the usage of medical resources. However, it is necessary to develop a strong support system to strengthen its weaknesses and supplement its merits. If doctors use hospital beds under the attending system of hospitals, they would be able to check a patient's condition often and provide them with nursing care services. However, the current attending system lacks delivery and assistance support. Thus, for the successful performance of the attending system, a networking system should be developed to facilitate communication between the doctors and nurses. In particular, the nursing records in the attending system could help doctors monitor the patient's condition and provision of nursing care services. A nursing record is the formal documentation associated with nursing care. It is merely a data repository that helps nurses to track their activities; nursing records thus represent a resource of primary information that can be reused. In order to maximize their usefulness, nursing records have been introduced as part of computerized patient records. However, nursing records are internal data that are not disclosed by hospitals. Moreover, the lack of standardization of the record list makes it difficult to share nursing records. Under the attending system, nurses would want to minimize the amount of effort they have to put in for the maintenance of additional records. Hence, they would try to maintain the current level of nursing records in the form of record lists and record attributes, while doctors would require more detailed and real-time information about their patients in order to monitor their condition. Therefore, this study developed a system for assisting in the maintenance and sharing of the nursing records under the attending system. In contrast to previous research on the functionality of computer-based nursing records, we have emphasized the practical usefulness of nursing records from the viewpoint of the actual implementation of the attending system. We suggested that nurses could design a nursing record dictionary for their convenience, and that doctors and nurses could confirm the definitions that they looked up in the dictionary through negotiations with intelligent agents. Such an agent-based system could facilitate networking among medical institutes. Multi-agent systems are a widely accepted paradigm for the distribution and sharing of computation workloads in the scientific community. Agent-based systems have been developed with differences in functional cooperation, coordination, and negotiation. To increase such communication, a framework for a multi-agent based system is proposed in this study. The agent-based approach is useful for developing a system that promotes trade-offs between transactions involving multiple attributes. A brief summary of our contributions follows. First, we propose an efficient and accurate utility representation and acquisition mechanism based on a preference scale while minimizing user interactions with the agent. Trade-offs between various transaction attributes can also be easily computed. Second, by providing a multi-attribute negotiation framework based on the attribute utility evaluation mechanism, we allow both the doctors in charge and nurses to negotiate over various transaction attributes in the nursing record lists that are defined by the latter. Third, we have designed the architecture of the nursing record management server and a system of agents that provides support to the doctors and nurses with regard to the framework and mechanisms proposed above. A formal protocol has also been developed to create and control the communication required for negotiations. We verified the realization of the system by developing a web-based prototype. The system was implemented using ASP and IIS5.1.