• Title/Summary/Keyword: Implementation

Search Result 33,749, Processing Time 0.061 seconds

Implementation of Reporting Tool Supporting OLAP and Data Mining Analysis Using XMLA (XMLA를 사용한 OLAP과 데이타 마이닝 분석이 가능한 리포팅 툴의 구현)

  • Choe, Jee-Woong;Kim, Myung-Ho
    • 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.

Study on Implementation Measures of Provincial Self-governing Police System : Focusing on the Implication from Enlargement of Work Scope of Self-governing Police of Jeju Province (광역자치경찰제의 정착방안에 관한 연구 - 제주자치경찰의 사무확대에 대한 시사점을 중심으로 -)

  • Kim, Seong-Hee
    • Korean Security Journal
    • /
    • no.59
    • /
    • pp.37-69
    • /
    • 2019
  • According to viewpoints of researchers and stakeholders, various opinions can be suggested on self-governing police system. Therefore, success of Korean self-governing police system will be defending on how to balance among conflicting values such as Empowerment, Political neutrality, Financial issues, Comprehensive competence in maintaining public safety. Before the launching of self-governing police system nation-wide, the experience of Jeju provincial police will be valuable model case. In specific, enlargement of work scope of self-governing police in Jeju province which has been introduced since last year will be a useful reference. There is more pessimism about self-governing police of Jeju province so far. However, this perspective is mostly based on the issue regarding hardwares such as manpower, equipment, law and organization. Issues regarding softwares such as organizational culture, operation system and work process need more attention to evaluate self-governing police system properly. To mark the first year after enlargement of work scope of Jeju police, this study demonstrate the overall result and implications of self-governing police of Jeju province based on documents, statistics, reports and media reports. In result, several preconditions are needed to implement the self-governing police system nation-wide successfully. 1. Strengthen the link between local government and local police 2. Establish the foundation for collaboration of state and local police 3. Enhance the aspect of citizen autonomy in local level 4. Reinforcing the capability of handling situation of state and local police 5. Invigorating the inter-organizational working group to operate self-governing police system effectively. The self-governing police system is unclosed topic to discuss. After this study, in-depth studies should be followed with more resources. Particularly, additional perspective including redundancy and equity need to be considered regarding self-governing police. By getting with the changes of macroscopic trends - lowbirth and aging, the fourth industrial revolution and possible reunification of north and south Koreas - these studies should suggest the long-term blueprint of self-governing police system of Korea.

Eco-friendly remediation and odor control of a contaminated urban stream using beneficial microorganisms (생물증강법을 이용한 도심 오염 소하천의 친환경적 수질정화 및 악취제어)

  • Chang, Jae-Soo;Song, Jikyung;Kim, In-Soo;Yoo, Jangyeon;Koh, Sung-Cheol
    • Korean Journal of Microbiology
    • /
    • v.51 no.4
    • /
    • pp.389-397
    • /
    • 2015
  • Dongchun, one of the representative streams in urban area, is a downstream that is connected to Hogyechun, Bujeonchun, Jeonpochun, Danggamchun, and Gayachun as its upstream. Hogyechun has been mostly covered with concrete structures for decades, causing sewage pollution from the upstream, overflow of the downstream region and other serious pollution that gave rise to many civil complaints from the residents nearby. In this study, we analyzed 3 stations, including control station for water quality and malodor changes of Hogyechun after applying the microbial augmentation (BM-2) for a few months including the rainy season. Amounts (g/h) of DO in the middle site (Middle) and the downstream site (Borim) increased by 1.7 times compared with the upstream site (Chuhae) after augmentation for about 2 months. Amounts (g/h) of COD and $NO_3{^-}N$ decreased by 2 and 1.7 times, respectively, in the middle and downstream sites while SS increased by 7.5 and 22 times in the middle and downstream sites, respectively. Moreover, odor removal efficiencies at the middle and downstream sites were 65% and 19%, respectively, indicating the microbial activity in reduction of malodor in the polluted stream. The dominant microbial species of the sampling sites were Hydrogenophaga caeni, Sphaerotilus natans, Acidovorax radicis, Acidovorax delafieldii, and Cloacibacterium rupense. Densities of the two species Sphaerotilus natans and Acidovorax delafieldii were significantly increased in the middle site after augmentation which possessed potential odor removal and denitrification activity, respectively. Potential pathogens (e.g., Arcobacter cryaerophilus) were also removed from the middle site after the implementation.

The Effects of Clinical Application of a Nursing Diagnosis Protocol (간호진단 프로토콜(Protocol)의 임상적용 효과에 관한 연구)

  • 이향련;조미영;조결자;김윤희;김귀분;김광주;문희자;박신애;강현숙
    • Journal of Korean Academy of Nursing
    • /
    • v.19 no.1
    • /
    • pp.40-62
    • /
    • 1989
  • This study was conducted to measure the effects of clinical application of a Nursing Diagnosis Protocol. The dependent variables were the degree of patient's satisfaction and the degree of nurse's satisfaction with the nursing activity. Analysis of the effect of the use of the nursing diagnosis protocol was based on the nursing record. The subjects for this study were 61 nurses(experimental group 31, control group 30) and 155 patients (experimental group 55, control group 100) on four internal medicine wards in K University Hospital in Seoul. Data collection was done from August to October 12,1988. The results obtained in this study can be summarized as follows, 1, Effect of the clinical application of the nursing diagnosis protocol. 1) The first hypothesis ; “nurses who use the nursing diagnosis protocol will have higher degrees of satisfaction than those who use traditional methods” was rejected (t=.54, df=58, p=.59). 2) The second hypothesis ; “patients nursed by nurses using the nursing diagnosis protocol will have higher degrees of satisfaction than those nursed with traditional methods” was supported(t=1.93, df=154, p=.05). 3) The third hypothisis : Major hypothesis ; “the nursing records of the experimental group, who used the nursing diagnosis protocol, will be more detailed than those of the control group” was supported (t=6.40, df=79.90, p=.000). (1) The first subhypothesis ; “The recorded data collection of the experimental group will be more detailed than that of the control group” was rejected (t=1.79, df=118, p=.07). (2) The second subhypothesis ; “The recorded patient's problem statement of the experimental group will be more detailed than that of the control group”, was supported. (3) The third subhypothesis ; “The nursing record of the experimental group will be more convenient for implementation than that of the control group” was supported. 2. Factors related to the nurse's degree of satisfaction with protocol. 1) No general characteristics(age, religion, education level, duty career, present duty career) were related to the nurse's degree of satisfaction. 2) Variables related to the nurse's degree of satisfaction were “satisfaction as a nurse” and “consider nursing as lifelong job” (t=-2.6, df=13.22, p=.02, t=2.41, df=23.85, p=.02). 3. Factors related to the patient's degree of satisfaction. 1) General characteristics related to the patient's degree of satisfaction with nurses using the protocol were age, educational level, and being married.(F=5.17, df=3/153, p=.00, t= -2.39, df=154, p=,01, f=5.91, df=2/153, p=.00) 2) The variables previous hospitalization, duration of hospitalization, the hospital unit presence of a relative, medical insurance, or medical diagnosis were not related to the patient's degree of satisfaction. 1. The experimental group's nursing record was more detailed than the control group's record with regard to the physical and psychological state of the patients. As noted above, the experimental group nurses, who use a nursing diagnosis had protocol were less satisfied than the control group who used traditional methods of the recording, but experimental group patients had a higher degree of satisfaction than the control group patients. The nursing records of experimental group, using the nursing, diagnosis protocol was more detailed than that of the control group. If the nursing diagnosis protocol is used in clinical nursing practice, the quality of nursing care may be improved.

  • PDF

Finding Influential Users in the SNS Using Interaction Concept : Focusing on the Blogosphere with Continuous Referencing Relationships (상호작용성에 의한 SNS 영향유저 선정에 관한 연구 : 연속적인 참조관계가 있는 블로고스피어를 중심으로)

  • Park, Hyunjung;Rho, Sangkyu
    • The Journal of Society for e-Business Studies
    • /
    • v.17 no.4
    • /
    • pp.69-93
    • /
    • 2012
  • Various influence-related relationships in Social Network Services (SNS) among users, posts, and user-and-post, can be expressed using links. The current research evaluates the influence of specific users or posts by analyzing the link structure of relevant social network graphs to identify influential users. We applied the concept of mutual interactions proposed for ranking semantic web resources, rather than the voting notion of Page Rank or HITS, to blogosphere, one of the early SNS. Through many experiments with network models, where the performance and validity of each alternative approach can be analyzed, we showed the applicability and strengths of our approach. The weight tuning processes for the links of these network models enabled us to control the experiment errors form the link weight differences and compare the implementation easiness of alternatives. An additional example of how to enter the content scores of commercial or spam posts into the graph-based method is suggested on a small network model as well. This research, as a starting point of the study on identifying influential users in SNS, is distinctive from the previous researches in the following points. First, various influence-related properties that are deemed important but are disregarded, such as scraping, commenting, subscribing to RSS feeds, and trusting friends, can be considered simultaneously. Second, the framework reflects the general phenomenon where objects interacting with more influential objects increase their influence. Third, regarding the extent to which a bloggers causes other bloggers to act after him or her as the most important factor of influence, we treated sequential referencing relationships with a viewpoint from that of PageRank or HITS (Hypertext Induced Topic Selection).

Clinical Implementation of an Eye Fixing and Monitoring System with Head Mount Display (Head Mount Display (HMD)를 이용한 안구의 고정 및 감시장치의 임상사용 가능성 확인)

  • Ko, Young-Eun;Park, Seoung-HO;Yi, Byong-Yong;Ahn, Seung-Do;Lim, Sang-Wook;Lee, Sang-Wook;Shin, Seong-Soo;Kim, Jong-Hoon;Choi, Eun-Kyung;Noh, Young-Ju
    • Progress in Medical Physics
    • /
    • v.18 no.1
    • /
    • pp.1-6
    • /
    • 2007
  • A system to non-invasively fix and monitor eye by a head mounted display (HMD) with a CCD camera for stereotactic radiotherapy (SRS) of uveal melanoma has been developed and implemented clinically. The eye fixing and monitoring system consists of a HMD showing patient a screen for fixing eyeball, a CCD camera monitoring patient's eyeball, and an immobilization mask. At flrst, patient's head was immobilized with a mask. Then, patient was Instructed to wear HMD, to which CCD camera was attached, on the mask and see the given reference point on its screen. While patient stared at the given point in order to fix eyeball, the camera monitored Its motion. Four volunteers and one patient of uveal melanoma for SRS came into this study. For the volunteers, setup errors and the motion of eyeball were analyzed. For the patient, CT scans were peformed, with patient's wearing HMD and fixing the eye to the given point. To treat patient under the same condition, daily CT scans were also peformed before every treatment and the motion of lens was compared to the planning CT Setup errors for four volunteers were within 1mm and the motion of eyeball was fixed within the clinically acceptable ranges. For the patient with uveal melanoma, the motion of lens was fixed within 2mm from daily CT scans. An eye fixing and monitoring system allowed Immobilizing patient as well as monitoring eyeball and was successfully implemented in the treatment of uveal melanoma for SRS.

  • PDF

Intensity Modulated Radiation Therapy Commissioning and Quality Assurance: Implementation of AAPM TG119 (세기조절방사선치료(IMRT)의 Commissioning 및 정도관리: AAPM TG119 적용)

  • Ahn, Woo-Sang;Cho, Byung-Chul
    • Progress in Medical Physics
    • /
    • v.22 no.2
    • /
    • pp.99-105
    • /
    • 2011
  • The purpose of this study is to evaluate the accuracy of IMRT in our clinic from based on TG119 procedure and establish action level. Five IMRT test cases were described in TG119: multi-target, head&neck, prostate, and two C-shapes (easy&hard). There were used and delivered to water-equivalent solid phantom for IMRT. Absolute dose for points in target and OAR was measured by using an ion chamber (CC13, IBA). EBT2 film was utilized to compare the measured two-dimensional dose distribution with the calculated one by treatment planning system. All collected data were analyzed using the TG119 specifications to determine the confidence limit. The mean of relative error (%) between measured and calculated value was $1.2{\pm}1.1%$ and $1.2{\pm}0.7%$ for target and OAR, respectively. The resulting confidence limits were 3.4% and 2.6%. In EBT2 film dosimetry, the average percentage of points passing the gamma criteria (3%/3 mm) was $97.7{\pm}0.8%$. Confidence limit values determined by EBT2 film analysis was 3.9%. This study has focused on IMRT commissioning and quality assurance based on TG119 guideline. It is concluded that action level were ${\pm}4%$ and ${\pm}3%$ for target and OAR and 97% for film measurement, respectively. It is expected that TG119-based procedure can be used as reference to evaluate the accuracy of IMRT for each institution.

Development of 'the safety' theme-based integrated teaching·learning process plans for the middle school Home Economics Instruction (중학교 가정과 수업을 위한 '안전' 주제 중심 통합 교수·학습 과정안 개발)

  • Kim, Nam Eun;Chae, Jung Hyun;Cho, Jae Soon
    • Journal of Korean Home Economics Education Association
    • /
    • v.28 no.1
    • /
    • pp.19-39
    • /
    • 2016
  • The purpose of this study was to develop the safety theme-based integrated teaching learning process plans for the middle school Home Economics(HE) Instruction and ultimately to contribute for the middle school students to live their safe lives. To achieve the goals of this study, HE curriculum documents from the 1st to the 2015 revision were analyzed and a survey was conducted to identify the middle school students' current status of safety accidents and needs on the HE safety education. The respondents of the survey were the 512 students of one ${\bigcirc}{\bigcirc}$ Girls' Middle School in Busan. And then, the seven integrated themes were selected, each seven integrated theme-networks were formed, and safety theme-based Home Economics curriculum and learning materials were developed. The results of this study were as the follows. The safety education content has continually been included from the first HE curriculum of 1954 to the 2015 revised HE curriculum. The middle school student respondents highly needed the content of 'the methods to deal with sexual violence and prostitution prevention', 'suicide prevention', and 'bullying net' for the HE safety education. All the 42 items were needed for the HE safety education by the respondents. The safety theme-based HE teaching learning process plans developed finally included the seven integrated themes, which were (1) dietary life safety, (2) adolescents' sex and safety, (3) adolescents' relationships with friends and safety, (4) family life and safety, (5) dwelling life and safety, (6) adolescents' egos and safety, and (7) social environment and safety. Each integrated theme consisted of three to six small themes, which amounted to total 28(for 35 lessons). Each small theme was presented with learning objectives and particular goals. The total 157 learning materials including the Home Economics curriculum were developed, which offered learning objectives and content for each safety theme, total 28 teaching and learning plans(for 35 lessons) were developed, which offered specific instructions for the easy implementation of the curriculum in the classroom, 28 PPTs, 25 film materials, four reading materials, 61 workbooks, 14 activity sheets, 16 evaluation sheets, 3 test sheets, 2 reference materials, and 4 learning material models(the refrigerator model, traffic lights for discussions, food tray model and stickers, and food mileage card). In this study, the safety education themes of 'clothing life and safety', 'conflict and safety', 'professional life and safety', and 'consumer and safety' were not addressed because these theme were not needed highly by the respondents. Therefore, for the further development of the teaching learning process plans for the HE safety education, it is necessary to develop and evaluate the teaching learning process plans to address the themes of 'clothing life and safety', 'conflict and safety', 'professional life and safety', and 'consumer and safety'.

Cerebral Activity by Motor Task in Welders Exposed to Manganese through fMRI (fMRI를 이용한 망간 노출 용접공의 운동수행에 따른 뇌 활성도 평가)

  • Choi, Jae-Ho;Jang, Bong-Ki;Lee, Jong-Wha;Hong, Eun-Ju;Lee, Myeong-Ju;Ji, Dong-Ha
    • Journal of Environmental Health Sciences
    • /
    • v.37 no.2
    • /
    • pp.102-112
    • /
    • 2011
  • Objectives: The purpose of this study is to analyze the effects of chronic exposure by welders to manganese (Mn) through an analysis of the degree of brain activity in different activities such as cognition and motor activities using the neuroimaging technique of functional magnetic resonance imaging (fMRI). The neurotoxic effect that Mn has on the brain was examined as well as changes in the neuro-network in motor areas, and the usefulness of fMRI was evaluated as a tool to determine changes in brain function from occupational exposure to Mn. Methods: A survey was carried out from July 2010 to October 2010 targeting by means of a questionnaire 160 workers from the shipbuilding and other manufacturing industries. Among them, 14 welders with more than ten years of job-related exposure to Mn were recruited on a voluntary basis as an exposure group, and 13 workers from other manufacturing industries with corresponding gender and age were recruited as a control group. A questionnaire survey, a blood test, and an fMRI test were carried out with the study group as target. Results: Of 27 fMRI targets, blood Mn concentration of the exposure group was significantly higher than that of the control group (p<0.001), and Pallidal Index (PI) of the welder group was also significantly higher than that of the control group (p<0.001). As a result of the survey, the score of the exposure group in self-awareness of abnormal nerve symptoms and abnormal musculoskeletal symptoms was higher than those of the control group, and there was a significant difference between the two groups (p<0.05, respectively). In the correlation between PI and the results of blood tests, the correlation coefficient with blood Mn concentration was 0.893, revealing a significant amount of correlation (p<0.001). As for brain activity area within the control group, the right and the left areas of the superior frontal cortex showed significant activity, and the right area of superior parietal cortex, the left area of occipital cortex and cerebellum showed significant activity. Unlike the control group, the exposure group showed significant activity selectively on the right area of premotor cortex, at the center of supplementary motor area, and on the left side of superior temporal cortex. In the comparison of brain activity areas between the two groups, the exposure group showed a significantly higher activation state than did the control group in such areas as the right and the left superior parietal cortex, superior temporal cortex, and cerebellum including superior frontal cortex and the right area of premotor cortex. However, in nowhere did the control group show a more activated area than did the exposure group. Conclusions: Chronic exposure to Mn increased brain activity during implementation of hand motor tasks. In an identical task, activation increased in the premotor cortex, superior temporal cortex, and supplementary motor area. It was also discovered that brain activity increase in the frontal area and occipital area was more pronounced in the exposure group than in the control group. This result suggests that chronic exposure to Mn in the work environment affects brain activation neuro-networks.

Identification of Variables as the Effects of Integrated Education Using the Delphi Method (통합교육의 효과변인 추출을 위한 델파이 연구)

  • Yoon, Heojoeng;Kim, Jiyoung;Bang, Dami
    • Journal of The Korean Association For Science Education
    • /
    • v.36 no.6
    • /
    • pp.959-968
    • /
    • 2016
  • In this study, the Delphi Method was conducted to extract variables as effects of integrated education. Forty-six experts engaged in both the integrated education and research fields participated in this study. The Delphi survey was conducted for three rounds. In the first round, an open questionnaire was given asking variables possibly considered as effects of integrated education. In the second round, variables induced from analysis of the first survey results were given and the degree of agreement for each variable was determined according to the Likert scale. In the third round of the survey, mean, standard deviation, and the first and third quartile calculated using the results of the second survey were given to experts to determine their degree of assent. In addition, categories for variables were suggested. The degree of agreement for appropriateness of categorization and relative importance were determined As a result, a total of 18 variables were chosen except for career awareness. They were categorized according to their definition and properties into five categories: 'creativity' (flexible thinking, associative thinking, intuitive thinking, creative thinking), 'problem solving' (meta-cognition, problem recognition and solving, critical thinking, decision making ability, ability of knowledge application, knowledge and information processing skills), 'integrative perception and sensitivity' (concern and interest in various disciplines, understanding and acceptance of difference, integrative thinking), 'interpersonal relations' (communication skills, cooperation), and 'disciplinary literacy' (humanistic imagination, basic knowledge and literacy of each discipline, academic motivation). The degree of agreement was high in variables included in 'creativity' and 'problem solving' categories and the frequency of choosing the importance was high in variables included in 'integrative perception and sensitivity'. The educational implication related to implementation and practice of integrated education were discussed on the basis of results.