• Title/Summary/Keyword: support functions

Search Result 1,702, Processing Time 0.03 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.

Analysis of Knowledge and Competency for the Fourth Industrial Revolution Based on Anderson's Revision of Bloom's Taxonomy: Focused on Achievement Standard in the 2015 revised Practical Arts(Technology·Home Economics) (Bloom의 신교육목표 분류체계에 기초한 4차 산업혁명 시대에 요구하는 지식과 역량 분석: 2015 개정 실과(기술·가정) 교육과정의 가정과 성취기준을 대상으로)

  • Yang, Ji Sun;Lee, Gyeong Suk
    • Journal of Korean Home Economics Education Association
    • /
    • v.30 no.3
    • /
    • pp.129-149
    • /
    • 2018
  • This study has attempted to analyze the achievement standards in the 2015 revised curriculum, based on the revision of Bloom's Taxonomy and aims to identify the knowledge and required competencies in the fourth industrial era. The results of this study are as follows: First, the knowledge dimensions was the highest 'metacognitive knowledge' in middle school, while 'factual knowledge' was the highest in high school, and 'knowledge of specific details and elements' was the highest subtype of all of the knowledge dimensions. The dimensions of the cognitive process, such as the terms 'apply' and 'analyze' in middle school, as 'understand' and 'evaluate' in high school have been treated inattentively. Second, the knowledge dimension and the cognitive process dimension according to key concepts display the metacognitive knowledge and 'understand' in development, the conceptual knowledge and 'understand' in relationship. While the 'metacognitive knowledge' and 'apply' in life culture, the 'procedural knowledge' and 'evaluate' in safety, the 'factual knowledge' and 'apply' in management and the 'metacognitive knowledge' and 'understand' in life design were extremely high. Third, the verbs used in the achievement standards displayed as 'explore', 'understand', 'analyze', 'practice', 'suggest', 'recognize' and 'evaluate'. Since the statement of the action verb is the very basis for determining the performance process, specific competencies may be achieved by reflecting on the actual achievement standards. These standards should provide us with a effective cognitive process for to understand a learner's performance skills and support the direction of the education required, through a strategy that refines the connection between content elements and functions and develop their competences for the future.

A Comparative Study on Communication of Agricultural Innovation (농업 기술 전파 커뮤니케이션에 관한 비교 연구)

  • Kim, Sung-Soo
    • Journal of Agricultural Extension & Community Development
    • /
    • v.7 no.1
    • /
    • pp.121-136
    • /
    • 2000
  • This study reports on a comparison between the Korean diffusion of agricultural innovation or extension service and the cooperative extension service in the United States of America. It focuses on relevant differences between the two systems and provides recommendation for improvement of the Korean system to insure success in important areas related to the diffusion of agricultural innovations. After a comparative study on diffusion of innovations it is clear that: in order to have a productive agriculture that makes effective and efficient use of natural resources and helps achieve sustainability goals, a mechanism that delivers knowledge to agricultural communities must be established and maintained. This mechanism is clearly an agricultural extension service that is cooperatively funded by federal, state and local governments and that insures participation of constituents in the process of establishing priorities and evaluating achievements. The success of US agriculture, the most productive in the world, is to a large degree to the Cooperative Extension Service. Based on the results of this study and the differences of the United States and Korea, the following recommendations should be emphasized for more effective communication for agricultural innovation and rural development in Korea: 1) In order to insure that extension educators are high caliber professional individuals, it is important to establish a system that nationally recognizes these individuals as such, and that provides a professional development path. 2) The results of the decision of transfer of extension educators to local governments has not yielded positive outcomes, especially in terms of professional status. It is clearly demonstrable that valuable professionals are leaving the service, that local governments do not have the will and resources to implement a successful extension program. 3) Because of the critical importance of diffusing innovations to agricultural producers in order to insure and quality and steady food supply, it is of critical importance that these issues be addressed before the extension service is further deteriorated. Given the cement situation, it is clear that the extension service should become nationally supported again in cooperation with local and state governments and that extension professionals be given appropriate rank at the national level, commesurate with their peers in research and teaching. 4) The common current committee practice of lengthy reporting and short discussion needs to be changed to one that results in char, brief and substantive action oriented goals. Joint participation by researchers, extension educators and farmers should be encouraged in planning, implementation and evaluation of communication for agricultural innovations. Roles and functions of committees for institutional cooperation, and or agricultural extension committees should be enlarged. 5) Extension educators should be encouraged to adopt new communication technologies to improve their diffusion of innovations methods. Agricultural institutions and organizations should be encouraged to adopt farmer-first and or client-oriented approach in agricultural extension and diffusion of agricultural technologies. The number, complexity and rapid change of information in agricultural extension require the development of a computer based information and report system to support agricultural extension. 6) To facilitate and expand the further development of communication for agricultural innovation and rural development, agricultural communication programs in universities especially in colleges of agriculture and life sciences. 7) To strengthening the sense of national and social responsibility communication for agricultural innovation and rural development among students in agricultural colleges and universities through participation in learning activities by proactive recruitment. 8) To establish and reinforce a policy that insures participation in communication for agricultural innovation and regal development activities. 9) To improve further development of communication for agricultural innovation and rural development in Korea, more research activities should be encouraged.

  • PDF

A Study on The Nursing Needs of Users and their Service Status at Short-Stay Centers for The Elderly (단기노인보호소 이용자의 간호요구도 및 서비스 실태연구)

  • Shin Kyoung Hi;Rhee Seon Ja
    • Journal of Korean Public Health Nursing
    • /
    • v.16 no.2
    • /
    • pp.354-377
    • /
    • 2002
  • Aging population is a global trend and Korea is no exception. Due to the progress of the medical and scientific sectors, increase in the average lifetime incurred increase in the number of elderly people. Meanwhile, the family function of supporting the elderly has become a major issue in a society due to the changes in the society's structure and increased entry of the women into the workforce. As a means to substitute the protection of the elderly who are not protected at their respective homes and to replace the tending needs, weekly protection centers and short-stay centers for the elderly were established and operated in Seoul since 1992. However, structured and satisfactory services are not yet to be provided, thus this research intends to understand the current situation at the short-stay centers for the elderly, to identify users' characteristics and to conduct study on nursing need for the health reasons so that the results of the research can be utilized as basic data for the development of nursing care program. Towards this end, this research targeted 142 elderly people who were undergoing treatment at the 11 short-stay centers for the elderly out of total of 13 located in Seoul that were willing to cooperate. The research was conducted from April to May 2002, with the measurement tool developed by Rhee, Seon-ja (2001) to measure the level of nursing need. Then data was collected and analyzed using SPSS program. The results are as follows. The general characteristics of users of the short-stay centers for the elderly were: 123 females $(86.6\%)$, 19 males $(13.4\%)$ and 72 elderly were over the age of 80 $(50.7\%)$. Among these, 24$(16.9\%)$ were living by themselves. Among the illnesses that the subjects were inflicted with were: dementia $(54.2\%)$, stroke $(54.1\%)$ and high blood pressure $(50.7\%)$, in the respective order. Despite the fact that they were diagnosed with illnesses, $47.2\%$ responded that they do not undergo special treatment due to financial reasons. When the level of needs for nursing care among the elderly who use the short-stay centers is divided into informational. physical. and emotional need levels and scored between zero to two, the level of emotional need is the highest with 1.80, followed by physical (1.45) and informational (1.44) need levels. As for the realities of services at the centers and improvement areas, restriction on term was cited as the greatest inconvenience with $38.7\%$, followed by lack of budget (24 respondents, $16.9\%$). Wishful services were financial assistance $(46.5\%)$, medical and nursing services $(40.1\%)$, meal provision service $(8.5\%)$ and counseling service $(4.9\%)$, in the respective order. Based on the above mentioned results, the research identified the need to develop nursing program for the patients of dementia that can be applied onto the short-stay centers and the need to develop volunteer service, backed by societal support. Also, placement of specialized cadre of professionals is needed so that medical and nursing service functions can be provided in a complementary manner.

  • PDF

An Analysis of the National Suicide Rate in Korea during 2005 (2005년 전국 자살실태 분석)

  • Kim, Gi-Jeong;Kwak, Jyung-Sik
    • Journal of forensic and investigative science
    • /
    • v.2 no.1
    • /
    • pp.5-22
    • /
    • 2007
  • From the numerous social problems generated by the unbalanced social development and the social trend of belittling life overall, we found the causes of suicide getting worse in its seriousness day by day. In reality, the problem has been approached in a collateral level in contrast with other social problems. There have been an active involvement in studying the definition, causes and ways of prevention of suicide theoretically until now. However, different from other social problems, it is almost impossible to treat or fix the problem of suicide. Only ways to treat or fix the problem is when the suicide has ended in failure. Thus, this study intends to examine the suicide rate among the total accidents during the year 2005, perform the analyses on the actual causes according to the relations such as the means of suicide, occupation, age group, educational background, etc. In order to present a solution to the issue of suicide becoming serious each day. Among the total accidents in 2005, the suicide rate came out to be approximately 52.4%. Among the result, 52.4%, male with 69% resulted higher than female with 31%, which appears to be related to the social functions. While men tends to take more active(80%) means of suicide like jumping off, poison, hanging, etc., women tends to take more passive(60%) means of suicide like sleeping pills, slitting wrist, etc. In terms of the cause, pessimism, illness, denial, mental disorder, etc resulted more than 75%, and there were many cases of suicide after exhibiting the signs of depression. Also there were higher suicide rate of the unemployed engaged in direct labor with educational background lower than college level related to the pessimism regarding the family living cost. We were able to determine the recent increase in the suicidal tendency of the educated people higher than the college level and the retired people with depression caused by the sudden change in social status. Overall there are several reasons for suicide, however, in most cases the signs of depression were exhibited until the final suicide, which tells us the serious psychological problem of suicide. Assuming that the current development of suicide will continue in future, the result of this study will guide the corresponding social policies, be utilized in preparing the insurance or management at the national level dealing with the real social problems that are not just a conflict of an individual, but could spread like a fad and become much bigger than the present by the continuous support at the environmental, social and political levels, and be utilized as the basic data to establish the research plan.

  • PDF

A Dynamic Management Method for FOAF Using RSS and OLAP cube (RSS와 OLAP 큐브를 이용한 FOAF의 동적 관리 기법)

  • Sohn, Jong-Soo;Chung, In-Jeong
    • Journal of Intelligence and Information Systems
    • /
    • v.17 no.2
    • /
    • pp.39-60
    • /
    • 2011
  • Since the introduction of web 2.0 technology, social network service has been recognized as the foundation of an important future information technology. The advent of web 2.0 has led to the change of content creators. In the existing web, content creators are service providers, whereas they have changed into service users in the recent web. Users share experiences with other users improving contents quality, thereby it has increased the importance of social network. As a result, diverse forms of social network service have been emerged from relations and experiences of users. Social network is a network to construct and express social relations among people who share interests and activities. Today's social network service has not merely confined itself to showing user interactions, but it has also developed into a level in which content generation and evaluation are interacting with each other. As the volume of contents generated from social network service and the number of connections between users have drastically increased, the social network extraction method becomes more complicated. Consequently the following problems for the social network extraction arise. First problem lies in insufficiency of representational power of object in the social network. Second problem is incapability of expressional power in the diverse connections among users. Third problem is the difficulty of creating dynamic change in the social network due to change in user interests. And lastly, lack of method capable of integrating and processing data efficiently in the heterogeneous distributed computing environment. The first and last problems can be solved by using FOAF, a tool for describing ontology-based user profiles for construction of social network. However, solving second and third problems require a novel technology to reflect dynamic change of user interests and relations. In this paper, we propose a novel method to overcome the above problems of existing social network extraction method by applying FOAF (a tool for describing user profiles) and RSS (a literary web work publishing mechanism) to OLAP system in order to dynamically innovate and manage FOAF. We employed data interoperability which is an important characteristic of FOAF in this paper. Next we used RSS to reflect such changes as time flow and user interests. RSS, a tool for literary web work, provides standard vocabulary for distribution at web sites and contents in the form of RDF/XML. In this paper, we collect personal information and relations of users by utilizing FOAF. We also collect user contents by utilizing RSS. Finally, collected data is inserted into the database by star schema. The system we proposed in this paper generates OLAP cube using data in the database. 'Dynamic FOAF Management Algorithm' processes generated OLAP cube. Dynamic FOAF Management Algorithm consists of two functions: one is find_id_interest() and the other is find_relation (). Find_id_interest() is used to extract user interests during the input period, and find-relation() extracts users matching user interests. Finally, the proposed system reconstructs FOAF by reflecting extracted relationships and interests of users. For the justification of the suggested idea, we showed the implemented result together with its analysis. We used C# language and MS-SQL database, and input FOAF and RSS as data collected from livejournal.com. The implemented result shows that foaf : interest of users has reached an average of 19 percent increase for four weeks. In proportion to the increased foaf : interest change, the number of foaf : knows of users has grown an average of 9 percent for four weeks. As we use FOAF and RSS as basic data which have a wide support in web 2.0 and social network service, we have a definite advantage in utilizing user data distributed in the diverse web sites and services regardless of language and types of computer. By using suggested method in this paper, we can provide better services coping with the rapid change of user interests with the automatic application of FOAF.

Design and Implementation of an Execution-Provenance Based Simulation Data Management Framework for Computational Science Engineering Simulation Platform (계산과학공학 플랫폼을 위한 실행-이력 기반의 시뮬레이션 데이터 관리 프레임워크 설계 및 구현)

  • Ma, Jin;Lee, Sik;Cho, Kum-won;Suh, Young-kyoon
    • Journal of Internet Computing and Services
    • /
    • v.19 no.1
    • /
    • pp.77-86
    • /
    • 2018
  • For the past few years, KISTI has been servicing an online simulation execution platform, called EDISON, allowing users to conduct simulations on various scientific applications supplied by diverse computational science and engineering disciplines. Typically, these simulations accompany large-scale computation and accordingly produce a huge volume of output data. One critical issue arising when conducting those simulations on an online platform stems from the fact that a number of users simultaneously submit to the platform their simulation requests (or jobs) with the same (or almost unchanging) input parameters or files, resulting in charging a significant burden on the platform. In other words, the same computing jobs lead to duplicate consumption computing and storage resources at an undesirably fast pace. To overcome excessive resource usage by such identical simulation requests, in this paper we introduce a novel framework, called IceSheet, to efficiently manage simulation data based on execution metadata, that is, provenance. The IceSheet framework captures and stores each provenance associated with a conducted simulation. The collected provenance records are utilized for not only inspecting duplicate simulation requests but also performing search on existing simulation results via an open-source search engine, ElasticSearch. In particular, this paper elaborates on the core components in the IceSheet framework to support the search and reuse on the stored simulation results. We implemented as prototype the proposed framework using the engine in conjunction with the online simulation execution platform. Our evaluation of the framework was performed on the real simulation execution-provenance records collected on the platform. Once the prototyped IceSheet framework fully functions with the platform, users can quickly search for past parameter values entered into desired simulation software and receive existing results on the same input parameter values on the software if any. Therefore, we expect that the proposed framework contributes to eliminating duplicate resource consumption and significantly reducing execution time on the same requests as previously-executed simulations.

A Survey of Ecological Knowledge and Information for Climate Change Adaptation in Korea - Focused on the Risk Assessment and Adaptation Strategy to Climate Change - (기후변화 적응정책 관련 생태계 지식정보 수요와 활용도 증진 방향 - 생태계 기후변화 리스크 평가 및 적응대책을 중심으로 -)

  • Yeo, Inae;Hong, Seungbum
    • Journal of Environmental Impact Assessment
    • /
    • v.29 no.1
    • /
    • pp.26-36
    • /
    • 2020
  • This study aimed at investigating present research and knowledge-base on climate change adaptation in ecosystem sector and analyzed the current status of basic information on ecosystem that functions as evidence-base of climate change adaptation to deduce the suggestions for the future development for knowledge and information in biodiversity. In this perspective, a questionary survey titled as "the ecological knowledge-base and information needs for climate change adaptation" with the researchers who were engaged with adaptation studies for biodiversity in the ecosystem related-research institutes including national and 17 regional local governments-affiliated agencies in Korea. The results are as follows; current status of utilizing ecological information which supports climate change adaptation strategy, future needs for adaptation knowledge and ecological information, and activation of utilizing ecological information. The majority of respondents (90.7%) replied that the ecological information has high relevance when conducting research on climate change adaptation. However, only half of all respondents (53.2%) agreed with the real viability of current information to the adaptation research. Particularly, urgent priority for researchers was deduced as intensifying knowledge-base and constructing related information on 'ecosystem change from climate change (productivity, community structure, food chain, phenology, range distribution, and number of individuals) with the overall improvement of information contents and its quality. The respondents emphasized with the necessity of conducting field surveys of local ecosystem and constructing ecosystem inventories, advancing monitoring designs for climate change in ecosystem, and case studies for regional ecosystem changes with the guidance or guidelines for monitoring ecosystem change to enhance the quality of adaptation research and produce related information. In terms of activation for ecological information usage, national and local adaptation network should be working based on the integrated ecological platform necessary to support exchanges of knowledge and information and to expand ecosystem types in time and spatial dimension.

TOOTH MOVEMENTS TO THE SITE OF ALVEOLAR BONE GRAFT (구순구개열 환아에서의 치조골이식)

  • Cho, Hae-Sung;Park, Jae-Hong;Kim, Gwang-Chul;Choi, Seong-Chul;Lee, Keung-Ho;Choi, Yeung-Chul
    • Journal of the korean academy of Pediatric Dentistry
    • /
    • v.34 no.1
    • /
    • pp.140-149
    • /
    • 2007
  • Cleft lip and palate are congenital craniofacial malformation. Reconstruction of dental arch in patient with alveolo-palatal clefts is very important, because they have many problems in functions and esthetics. Malnutrition, poor oral hygiene, respiratory infections, speech malfunctions, maxillofacial deformity, and psychological problems may be occured without proper treatment during the long period of management of the cleft lip and palate. So the treatment should be managed with a multidisciplinary approach. Bone grafting is a consequential step in the dental rehabilitation of the cleft lip and palate patient A complete alveolar arch should be achieyed of the teeth to erupt in and to form a stable dentition. And the presence of the cleft complicate the orthodontic treatment. Therefore bone grafting in patients with cleft lip and palate is a widely adopted surgical procedure. Grafted bone stabilizes the alveolar process and allows the canine or incisor to move into the graft site. After the bone grafting, orthodontic closure of the maxillary arch has become a common practice for achieving dental reconstruction without any prosthodontic treatment. Various grafting materials have been used in alveolar clefts. Iliac bone is most widely fovoured, but tibia, rib, cranial bone, mandible have also been used. And according to its time of occurrence, the bone graft may be divided into primary, early secondary, secondary, late secondary. Bone grafting is called secondary when performed later, at the end of the mixed dentition. It is the most accepted procedure and has become part of treatment of protocol A secondary bone graft is performed preferably before the eruption of the permanent canine in order to provide adequate periodontal support for the eruption and preservation of the teeth adjacent to the cleft. In this report, we report here on a patient with unilateral cleft lip and palate, who underwent iliac bone graft. The cleft was fully obliterated by grafted bone in the region of the alveolar process. The presence of bone permitted physiologic tooth movement and the orthodontic movement of adjacent tooth into the former cleft area. Satisfactory arch alignment could be achieved in by subsequent orthodontic treatment.

  • PDF

Evaluating Impact Resistance of Externally Strengthened Steel Fiber Reinforced Concrete Slab with Fiber Reinforced Polymers (섬유 보강재로 외부 보강된 강섬유 보강 콘크리트 슬래브의 충격저항성능 평가)

  • Yoo, Doo-Yeol;Min, Kyung-Hwan;Lee, Jin-Young;Yoon, Young-Soo
    • Journal of the Korea Concrete Institute
    • /
    • v.24 no.3
    • /
    • pp.293-303
    • /
    • 2012
  • Recently, as construction technology improved, concrete structures not only became larger, taller and longer but were able to perform various functions. However, if extreme loads such as impact, blast, and fire are applied to those structures, it would cause severe property damages and human casualties. Especially, the structural responses from extreme loading are totally different than that from quasi-static loading, because large pressure is applied to structures from mass acceleration effect of impact and blast loads. Therefore, the strain rate effect and damage levels should be considered when concrete structure is designed. In this study, the low velocity impact loading test of steel fiber reinforced concrete (SFRC) slabs including 0%~1.5% (by volume) of steel fibers, and strengthened with two types of FRP sheets was performed to develop an impact resistant structural member. From the test results, the maximum impact load, dissipated energy and the number of drop to failure increased, whereas the maximum displacement and support rotation were reduced by strengthening SFRC slab with FRP sheets in tensile zone. The test results showed that the impact resistance of concrete slab can be substantially improved by externally strengthening using FRP sheets. This result can be used in designing of primary facilities exposed to such extreme loads. The dynamic responses of SFRC slab strengthened with FRP sheets under low velocity impact load were also analyzed using LS-DYNA, a finite element analysis program with an explicit time integration scheme. The comparison of test and analytical results showed that they were within 5% of error with respect to maximum displacements.