• The KIPS Transactions:PartD
• /
• v.10D no.3
• /
• pp.407-416
• /
• 2003

As the usage of database systems dramatically increases and the amount of data pouring into them is massive, the performance administration techniques for using database systems effectively are getting more important. Especially in data warehouses, the performance management is much more significant mainly because of large volume of data and complex queries. The objectives and characteristics of data warehouses are different from those of other operational systems so adequate techniques for performance monitoring and tuning are needed. In this paper we extend functionalities of the DBMax, a performance administration tool for Oracle database systems, to apply it to data warehouse systems. First we analyze requirements based on summary management and ETL functions they are supported for data warehouse performance improvement in Oracle 9i. Then, we design architecture for extending DBMax functionalities and implement it. In specifics, we support SQL tuning by providing details of schema objects for summary management and ETL processes and statistics information. Also we provide new function that advises useful materialized views on workload extracted from DBMax log files and analyze usage of existing materialized views.

• Journal of Korea Spatial Information System Society
• /
• v.11 no.1
• /
• pp.79-86
• /
• 2009

The tuple of constraint database consists of constraint logical formula and it could process the presentation and query of the constraint database simply. Query operation processing shall include the constraint formula between related tuple such as selection, union, intersection of spatial data through the constraint database. However, this could produce the increasing of duplicated or unnecessary data. Hence, it will drive up the cost as per quality. This paper identified problems regarding query processing result in the constraint database. Also this paper suggested the tuple minimization summary method for result relation and analyzed the effects for efficient query processing. We were able to identify that the effectiveness of the query processing was enhanced by eliminating unnecessary constraint formula of constraint relation using the tuple minimization method.

• Journal of Information Technology Services
• /
• v.21 no.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.

• The Mathematical Education
• /
• v.42 no.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.

• Journal of Applied Reliability
• /
• v.17 no.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
• /
• v.32 no.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.

• The Journal of Korean Medicine
• /
• v.25 no.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
• /
• v.14 no.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.

• The Journal of Internal Korean Medicine
• /
• v.44 no.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.

• Journal of Korea Multimedia Society
• /
• v.16 no.4
• /
• pp.453-463
• /
• 2013

In this paper, we present an effective method and a system for the music summarization which automatically extract the chorus portion of a piece of music. A music summary technology is very useful for browsing a song or generating a sample music for an online music service. To develop the solution, conventional automatic music summarization methods use a 2-dimensional similarity matrix, statistical models, or clustering techniques. But our proposed method extracts the music summary by calculating BER(Bit Error Rate) between audio fingerprint blocks which are extracted from a song. But we could directly use an enormous audio fingerprint database which was already saved for a music retrieval solution. This shows the possibility of developing a various of new algorithms and solutions using the audio fingerprint database. In addition, experiments show that the proposed method captures the chorus of a song more effectively than a conventional method.