• 정보처리학회논문지D
• /
• 제10D권3호
• /
• pp.407-416
• /
• 2003

데이터베이스의 사용이 증가하고 다루어야 하는 데이터의 양이 방대해지면서 데이터베이스 시스템을 효율적으로 사용하기 위한 성능 관리 기술이 중요해지고 있다. 특히 데이터 웨어하우스는 대용량의 데이터를 대상으로 복잡한 분석을 수행하거나 전략적 의사 결정을 위해 사용하기 때문에 신속한 질의 응답을 위한 성능 관리가 무엇보다 중요하다. 데이터 웨어하우스는 일반 운영계 시스템과는 다른 목적과 특성을 가지기 때문에 그에 적합한 성능 모니터링 방법 및 튜닝 기술이 필요하다. 본 연구에서는 OLTP(On-Line Transaction Processing)용 오라클 데이터베이스를 위한 국산 성능 관리 도구인 DBMax를 데이터 웨어하우스 환경에 적합하도록 기능을 확장한다. 우선 데이터 웨어하우스 응용 분야를 지원하기 위한 오라클 9i의 요약 관리(summary management) 기능과 ETL(Data Extraction, Transformation and Loading) 기능을 중심으로 데이터 웨어하우스 시스템의 성능 관리시 고려해야 할 요구 사항을 분석하고 이를 지원하는 DBMax의 확장 아키텍처를 설계 및 구현한다. 구체적으로 요약 관리와 ETL 작업을 지원하기 위한 오라클 9i의 다양한 스키마 객체에 대한 정보와 성능 관련 지표를 제시하여 데이터 웨어하우스 환경에서 수행되는 질의에 대한 SQL 튜닝 기능을 강화한다. 또한 사후 분석을 위한 BBMax의 로그 파일에서 의미 있는 SQL 문을 추출하여 잠재적으로 유용한 실체화된 뷰를 추천하는 요약 권고 기능을 추가한다.

• 한국공간정보시스템학회 논문지
• /
• 제11권1호
• /
• pp.79-86
• /
• 2009

제약 데이터베이스의 투플은 제약 논리식으로 구성되었으며, 공간 데이터의 표현 및 질의를 비교적 간결하게 처리할 수 있다. 제약 데이터베이스를 통한 공간 데이터의 실렉션, 합집합, 교집합 등의 질의 연산 처리는 간단하게 관련 투플 간에 제약식을 포함시켜 주면 된다. 그러나 중복되거나 불필요한 데이터가 증가할 수 있으며, 그에 따른 질의 비용이 증가될 수도 있다. 이 논문에서는 제약 데이터베이스에서의 질의처리 결과에 대한 문제점을 밝히고, 효율적인 질의처리를 위해서 결과 릴레이션에 대한 투플 최소화 정리기법의 제안 및 그 효과를 분석했다. 우리는 투플 최소화 기법을 이용하여 제약 릴레이션의 불필요한 제약식을 제거함에 따른 질의처리의 효율성이 개선됨을 확인할 수 있었다.

• 한국IT서비스학회지
• /
• 제21권2호
• /
• pp.109-126
• /
• 2022

The number and variety of products and services offered by companies have increased dramatically, providing customers with more choices to meet their needs. As a solution to this information overload problem, the provision of tailored services to individuals has become increasingly important, and the personalized recommender systems have been widely studied and used in both academia and industry. Existing recommender systems face important problems in practical applications. The most important problem is that it cannot clearly explain why it recommends these products. In recent years, some researchers have found that the explanation of recommender systems may be very useful. As a result, users are generally increasing conversion rates, satisfaction, and trust in the recommender system if it is explained why those particular items are recommended. Therefore, this study presents a methodology of providing an explanatory function of a recommender system using a review text left by a user. The basic idea is not to use all of the user's reviews, but to provide them in a summarized form using only reviews left by similar users or neighbors involved in recommending the item as an explanation when providing the recommended item to the user. To achieve this research goal, this study aims to provide a product recommendation list using user-based collaborative filtering techniques, combine reviews left by neighboring users with each product to build a model that combines text summary methods among deep learning-based natural language processing methods. Using the IMDb movie database, text reviews of all target user neighbors' movies are collected and summarized to present descriptions of recommended movies. There are several text summary methods, but this study aims to evaluate whether the review summary is well performed by training the Sequence-to-sequence+attention model, which is a representative generation summary method, and the BertSum model, which is an extraction summary model.

• 한국수학교육학회지시리즈A:수학교육
• /
• 제42권2호
• /
• pp.87-109
• /
• 2003

This paper aims to review the overall development of constructivist approaches in science education research from two different perspectives, that is a summary of the past development in science education in general and a report of the outline of a recent research project on students' physics misconceptions in particular. In the summary of the past development of constructivist science education the introduction of constructivism as well as its psychological and philosophical backgrounds are briefly reported. Then main findings of the researches of constructivist approach are discussed in terms of the features of students' misconceptions, of the ways of effective conceptual change, of the implications toward school science education, and of the criticisms given to the constructivist approach. In the report of a recent development in addition to its background necessity and implications, the research structure and the format of the data analysis of the study on the map of students' physics misconceptions are presented. It is particularly emphasized that the practical informations and suggestions for actual teaching of school science, such as the database(DB) of students' misconceptions and teaching guides, are of most practical and effective values in order to maximize the advantage of the constructivist approach to science education.

• 한국신뢰성학회지:신뢰성응용연구
• /
• 제17권4호
• /
• pp.305-315
• /
• 2017

Purpose: The purpose of this research is to propose procedure and methodology for developing failure rate databook which is suitable for Korean operation environment. Methods: To this end, we investigate failure databooks used in foreign countries and study the procedure and methodology for collecting failure data, organizing the data, estimating failure rate and summarizing results. Results: We develop the procedure of development of failure databook, the items for data collection, database schema of part details and part summary and contents of failure databook by considering the application environment in Korea. Conclusion: The results of our research could be utilized for the development of Korean failure rate databook and research of reliability prediction model and could ultimately contribute to improve the accuracy of reliability prediction.

• Journal of Nutrition and Health
• /
• 제32권3호
• /
• pp.296-306
• /
• 1999

This study was carried out to prepare a copper database of Korean foods which can be used in calculating copper intake from dietary data, and to evaluate the copper nutritional status of Koran adults living in rural areas by dietary intake and serum copper concentrations. A copper database for 1,176 Korean foods was constructed (1) by analysing 112 Korean foods which are frequently consumed by Korean adults living in rural areas, (2) by adapting values form food composition databases from other countries-320 items from the University of Minnesota database, 201 items from the USAD database, and 25 items from U.K. database, and (3) by imputing values from similar foods for 518 food items. Copper intake of 2,034 Korean adults over the age of 30 living in Yeonchongun was Kyunggi province, Korea was estimated by 24-hour recall method. Mean daily copper intake of subjects was 0.98mg. Mean daily intake level of males was 1.11mg which was significantly higher than that of females, 0.88mg. There was a significant difference in the distribution of subjects by the level of copper intake and sex(p<0.05). Mean serum copper concentration was 14.8umol/1 and the percentage of subjects with low, adequate, and high levels of copper concentration were 23.9%, 69.4%, and 6.6%, respectively. The two food groups which contributed most to the dietary copper intake of subjects were cereals and grain products, and vegetables, supplying 46.2% and 12.7% of total copper intake, respectively. Individuallym, rice contributed most, suppling 31% of total copper intake, followed by soybean curd, starch vermicle, barley, etc. Plant foods contributed to 82.1% of the total copper intake. In summary, results of this study show that copper intake of Korean adults living in rural areas is low, and that dietary sources of copper are mainly plant foods. Serum levels of copper in the subjects were relatively normal. The copper database for Korean foods constructed in present study will be a valuable tool for the as-yet limited assessment of copper intake of Koreans. Such studies will contribute to the establishment of a dietary of a dietary allowance of copper and the relationship of copper nutriture and chronic diseases in Koreans.

• 대한한의학회지
• /
• 제25권3호
• /
• pp.12-19
• /
• 2004

Objectives : In the WIPO conference about the protection of intellectual property for traditional knowledge (TK) and genetic resources (GR), there was a demand concerning the necessity of recognizing the invention of TK and GR and the foundation of a related database. Methods : In the standard of the foundation of a database, the content and resource identification standards, the technological standards and the security and transmission standards were discussed. In a decision on intellectual property, it means the protection and recognition as a technology precedent of the materials of the database. Results : Massive material on traditional medical care technology in Korea has existed in many areas. However, it is hard to make a database because it is difficult to organize and find the data. In addition, a database demanded by WIPO is not only the material of images or texts of simple technology information, but also the use of patent decisions about traditional knowledge technology and the public sharing of information in related areas. A traditional medical care database would consist of the core of a subject and the related areas. The core part is the medical herb resource and Oriental clinical technology. Conclusions : These are necessary to detail the kind of medicines and prescriptions, their use, and their processing. In the related areas, it needs to detail PIAS and clinical data in regarding the industrialization. These DB have to protect the TK and the GR of Korea.

• Asian Pacific Journal of Cancer Prevention
• /
• 제14권7호
• /
• pp.4283-4287
• /
• 2013

Background: In this meta-analysis we review evidence suggesting that exposure to cadmium is a cause of breast cancer. Materials and Methods: We conducted Medline/PubMed and Scopus searches using selected MeSH keywords to identify papers published from January 1, 1980 through January 1, 2013. Data were merged and summary mean differences were estimated using either a random-effects model or a fixed-effects model. Results: There were 13 studies including 978 exposed cases and 1,279 controls. There was no statistically significant difference in the frequencies of breast cancer between cadmium-exposed and control groups, and the summary estimate of mean difference was 0.71 (95%CI: 0.33-1.08). However, stratification showed that there were statistically significant differences in the frequencies of breast cancer between cadmium-exposed and control groups among Asian compared with Caucasian population, and the summary estimates of mean difference were 1.45 (95%CI: 0.62-2.28) vs. 0.25 (95%CI: -0.09-0.6), respectively. There was a difference in the frequencies of breast cancer between cadmium-exposed and control groups in peripheral venous blood sampling methods, and the summary estimate of mean difference was 1.41 (95%CI: 0.46-2.37). Conclusions: Data indicate that the frequencies of breast cancer might be an indicator of early genetic effects for cadmium-exposed populations. However, our meta-analysis was performed on population-based studies; meta-analysis based on individual data might provide more precise and reliable results. Therefore, it is necessary to construct an international database on genetic damage among populations exposed to cadmium that may contain all raw data of studies examining genetic toxicity.

• 대한한방내과학회지
• /
• 제44권6호
• /
• pp.1176-1185
• /
• 2023

Introduction: Non-erosive reflux disease (NERD) is the most common subtype of gastroesophageal reflux disease (GERD). This study aims to synthesize evidence on the efficacy and safety of various herbal medicines for the treatment of NERD. Methods and analysis: Ten electronic databases will be examined: MEDLINE (via PubMed), Cochrane Central Register of Controlled Trials, Embase, Allied and Complementary Medicine Database, China National Knowledge Infrastructure Database, Citation Information by Nii, Korean Medical Database, Korean Studies Information Service System, National Digital Science Library, and Oriental Medicine Advanced Searching Integrated System. All randomized controlled trials published from inception to May 2023 that meet the eligibility criteria will be selected. Two independent researchers will extract data, such as publication year, study design, intervention details, outcome measures, main results, and adverse events. The risk of bias and quality of evidence will be assessed, and subgroup analyses will be performed according to the type of control intervention and herbal medicine. The analysis process will be conducted using Review Manager 5.4 software. Discussion: This review will present a summary and rationale for herbal medicine's effectiveness in treating NERD. The findings of this review can help those who want to apply herbal medicine to the treatment of NERD.

• 한국멀티미디어학회논문지
• /
• 제16권4호
• /
• pp.453-463
• /
• 2013

본 논문은 음악의 코러스(chorus) 구간을 자동으로 추출하는 기법 및 시스템에 대하여 다루었다. 코러스 구간을 자동으로 추출하는 음악 요약 기술은 방대한 음악 데이터베이스에서 특정 음악 검색을 용이하게 할 수 있으며, 온라인 스트리밍 서비스에서 샘플 음악을 생성할 때 사용될 수 있다. 이를 구현하기 위해, 기존의 알고리즘들은 2차원 유사도 행렬, 확률모델, 신경망모델, 템포 특징 벡터, 클러스터링 기법 등을 적절히 활용하여 개발되었다. 본 논문에서는 음악의 오디오 핑거프린트를 추출한 후 곡 내의 오디오 핑거프린트 구간 쌍의 비트에러율을 통해 음악 요약을 추출한다. 다만, 음악 검색 솔루션에서 사용된 오디오 핑거프린트가 데이터베이스에 이미 존재할 경우에는 이를 바로 로딩한 후 비트에러율을 계산하여 음악 요약을 추출할 수 있다. 이런 방법은 이미 만들어진 데이터베이스를 변형 없이 그대로 사용할 수 있음으로써 음악 데이터베이스를 활용한 다양한 알고리즘과 솔루션의 가능성을 보여주었다. 또한, 음악의 코러스를 추출하는데 있어서 기존 방식보다 매우 뛰어난 성능을 보임을 알 수 있었다.