• Journal of Computing Science and Engineering
• /
• v.1 no.2
• /
• pp.177-194
• /
• 2007

Index selection is one of the most important decisions to take in the physical design of relational data warehouses. Indices reduce significantly the cost of processing complex OLAP queries, but require storage cost and induce maintenance overhead. Two main types of indices are available: mono-attribute indices (e.g., B-tree, bitmap, hash, etc.) and multi-attribute indices (join indices, bitmap join indices). To optimize star join queries characterized by joins between a large fact table and multiple dimension tables and selections on dimension tables, bitmap join indices are well adapted. They require less storage cost due to their binary representation. However, selecting these indices is a difficult task due to the exponential number of candidate attributes to be indexed. Most of approaches for index selection follow two main steps: (1) pruning the search space (i.e., reducing the number of candidate attributes) and (2) selecting indices using the pruned search space. In this paper, we first propose a data mining driven approach to prune the search space of bitmap join index selection problem. As opposed to an existing our technique that only uses frequency of attributes in queries as a pruning metric, our technique uses not only frequencies, but also other parameters such as the size of dimension tables involved in the indexing process, size of each dimension tuple, and page size on disk. We then define a greedy algorithm to select bitmap join indices that minimize processing cost and verify storage constraint. Finally, in order to evaluate the efficiency of our approach, we compare it with some existing techniques.

• Analytical Science and Technology
• /
• v.34 no.3
• /
• pp.99-114
• /
• 2021

Substance identification is the first step in implementing chemical legislation, such that subsequent hazard and risk assessments can be accurately followed. Based on the web page and related guidance documents of the European Chemicals Agency and available consortia information, the procedure for substance identification carried out in Registration, Evaluation, Authorization and Restriction of Chemicals (REACH) is surveyed. In this study, the importance of substance identification and substance sameness check, as well as the necessity of generating a substance identity profile (SIP) are considered. In addition, the SIPs of several substance types are presented, which focused on information utilization in the instrumental analysis results and organization of information to generate the SIP. Analytical science can contribute to the accurate and effective implementation of chemical regulation at the starting stage of substance identification. However, understanding of the regulation and consequent final wrap-up of analytical results as a SIP should be followed for communication among registrants in Substance Information Exchange Forum (SIEF) as well as with related authorities.

• Journal of The Korean Association of Information Education
• /
• v.26 no.5
• /
• pp.317-325
• /
• 2022

In textbooks, illustrations are used to easily explain concepts and guide the exploration process. Therefore, the illustration should be presented accurately and easily. However, as a result of analyzing previous studies, it was confirmed that there was no research related to illustration analysis at all in the case of the elementary school 'software education' unit. Therefore, among the six practical textbooks developed according to the 2015 revised curriculum, the illustration of the 'software education' unit was analyzed in terms of type, function, and use, and provided guidelines for the adoption of textbooks, curriculum research, and next textbook development. As a result of analyzing six practical textbooks, all textbooks used more than one illustration per page, and the types of illustrations were used in the order of screen capture, picture, picture, table, illustration, illustrative function, and use.

• Convergence Security Journal
• /
• v.23 no.3
• /
• pp.29-36
• /
• 2023

With the recent surge in exposure to fake advertising phishing sites in search engines, the damage caused by poor search quality and personal information leakage is increasing. In particular, the seriousness of the problem is worsening faster as the possibility of automating the creation of advertising phishing sites through tools such as ChatGPT increases. In this paper, the source code of fake advertising phishing sites was statically analyzed to derive structural commonalities, and among them, a detection crawler that filters sites step by step based on foreign domains and redirection was developed to confirm that fake advertising posts were finally detected. In addition, we demonstrate the need for new guide lines by verifying that the redirection page of fake advertising sites is divided into three types and returns different sites according to each situation. Furthermore, we propose new detection guidelines for fake advertising phishing sites that cannot be detected by existing detection methods.

• Journal of Intelligence and Information Systems
• /
• v.25 no.1
• /
• pp.85-107
• /
• 2019

Online consumers browse products belonging to a particular product line or brand for purchase, or simply leave a wide range of navigation without making purchase. The research on the behavior and purchase of online consumers has been steadily progressed, and related services and applications based on behavior data of consumers have been developed in practice. In recent years, customization strategies and recommendation systems of consumers have been utilized due to the development of big data technology, and attempts are being made to optimize users' shopping experience. However, even in such an attempt, it is very unlikely that online consumers will actually be able to visit the website and switch to the purchase stage. This is because online consumers do not just visit the website to purchase products but use and browse the websites differently according to their shopping motives and purposes. Therefore, it is important to analyze various types of visits as well as visits to purchase, which is important for understanding the behaviors of online consumers. In this study, we explored the clustering analysis of session based on click stream data of e-commerce company in order to explain diversity and complexity of search behavior of online consumers and typified search behavior. For the analysis, we converted data points of more than 8 million pages units into visit units' sessions, resulting in a total of over 500,000 website visit sessions. For each visit session, 12 characteristics such as page view, duration, search diversity, and page type concentration were extracted for clustering analysis. Considering the size of the data set, we performed the analysis using the Mini-Batch K-means algorithm, which has advantages in terms of learning speed and efficiency while maintaining the clustering performance similar to that of the clustering algorithm K-means. The most optimized number of clusters was derived from four, and the differences in session unit characteristics and purchasing rates were identified for each cluster. The online consumer visits the website several times and learns about the product and decides the purchase. In order to analyze the purchasing process over several visits of the online consumer, we constructed the visiting sequence data of the consumer based on the navigation patterns in the web site derived clustering analysis. The visit sequence data includes a series of visiting sequences until one purchase is made, and the items constituting one sequence become cluster labels derived from the foregoing. We have separately established a sequence data for consumers who have made purchases and data on visits for consumers who have only explored products without making purchases during the same period of time. And then sequential pattern mining was applied to extract frequent patterns from each sequence data. The minimum support is set to 10%, and frequent patterns consist of a sequence of cluster labels. While there are common derived patterns in both sequence data, there are also frequent patterns derived only from one side of sequence data. We found that the consumers who made purchases through the comparative analysis of the extracted frequent patterns showed the visiting pattern to decide to purchase the product repeatedly while searching for the specific product. The implication of this study is that we analyze the search type of online consumers by using large - scale click stream data and analyze the patterns of them to explain the behavior of purchasing process with data-driven point. Most studies that typology of online consumers have focused on the characteristics of the type and what factors are key in distinguishing that type. In this study, we carried out an analysis to type the behavior of online consumers, and further analyzed what order the types could be organized into one another and become a series of search patterns. In addition, online retailers will be able to try to improve their purchasing conversion through marketing strategies and recommendations for various types of visit and will be able to evaluate the effect of the strategy through changes in consumers' visit patterns.

• The KIPS Transactions:PartD
• /
• v.9D no.2
• /
• pp.203-214
• /
• 2002

This paper presents a physical database design methodology for spatial access structures using transformation techniques in spatial database systems. Recently, many spatial access structures have been proposed in the literature. However, there has been no effort for their physical database design. We first show that most spatial queries in the original space are transformed into one type of range queries in the transform space, and then propose a method for finding the optimal configuration of spatial access structures by using the relationship between the shapes of query regions, that are correspond to the range queries, and page regions, that are correspond to data pages, in the transform space. For performance evaluation, we perform extensive experiments with the MBR-MLGF, a spatial access structure using transformation techniques, using various types of queries and data distributions. The results indicate that our proposed method builds optimal MBR-MLGF according to the query types. When the interval ratio of a transformed four-dimensional query region is 1 : 16 : 256 : 4096, the performance of the proposed method is enhanced by as much as five times over that of the conventional cyclic splitting method. The result confirms that the proposed physical database design methodology is useful in a practical way.

• Korean journal of communication and information
• /
• v.40
• /
• pp.249-286
• /
• 2007

This study examines the main characteristics and differences on people's page in selected four national dailies, such as Chosun Ilbo, Joongang Ilbo, Seoul Shinmum and Hankyoreh Shinmun. Both Chosun Ilbo and Joongang Ilbo are categorized as the conservatives; while Seoul Shinmum and Hankyoreh Shinmun as the progressive. This study has been done by applying methods of content analysis to reveal the differences in terms of people's occupations, types of reports, their philosophies, and standards of selecting people by the dailies for the people's pages. The results shows that the conservative newspapers are very similar to the progressive newspapers in terms of occupations and the types of reports, covering the people on people's pages. More specifically, both the conservative dailies and the progressive dailies report the people for whose jobs are related to both social and cultural works. However, the conservative newspapers have much more coverages than the progressive papers in terms of the publicity reporting on the people. The conservatives are also much more reports on the people who are eager to economic success than the progressive dailies; while the progressives papers have much coverages on those who are interesting in helping others than the conservatives papers. Finally, this study reveals that the conservative dailies mainly cover those who are in publicity activities and social elite groups, while the progressive newspapers are the social celebrities and persons of fame in society.

• The Korean Journal of Ecology
• /
• v.16 no.2
• /
• pp.135-149
• /
• 1993

In order to study and ecotypic variation of Phragmites communis Trin., we investigated germination rates, velocities, and protein band patte군 of seeds of three population of salt marsh, estuary and fresh water areas of Muan Peninsular in southwestern coast of Korea from March, 1990 to October, 1992. The highest germination rates of seeds were observed at $25^{\circ}C$; those of population of the estuary and fresh water are were 100% and that of the salt marsh was 95%. Similar germination rates were observed from the populations of estuary and fresh water areas at $30^{\circ}C$ and $20^{\circ}C$, but they decreased at $15^{\circ}C$. The onset of germination of seeds of three population was earlier $^{\circ}C$, but they decreased at $15^{\circ}C$. The onset of germination of seeds of th three populations was earlier at both $25^{\circ}C$, which was higher than those of any other areas, while that of fresh water areas was the lowest. were different; those of salt marsh and estuary decreased to 30% and 2.5%, respectively, at 3.0% of salt content, but seeds of the fresh water area did not germinate at all at the same salt content. The onset of germination was delayed in the order of the salt marsh, esturay and fresh water areas as salt content of culture solution increased. Germination of seeds from the population of salt marsh was found to begin earliest. The highest germination velocity of three populations was observed in the culture containing no salt. The germination velocity constant decreased as salt content of culture solution increased from 0.5% to 3.0%: those of the populations of the salt marsh, estuary, and fresh water areas were 9.50, 0.75 and 0.00, respectively, at the salt concentration of 3.0%. Soluble protein patterns of seedings from the three populations were analyzed by SDS-PAGE method. The results showed that protein patterns of the three populations were distinctly different qualitatively and quantitatively. The present study suggests that populations of Phragmites communis Trin. in the coast of Korea had taken ecotypic variations of habitats, i.e., fresh water, estuary, and salt marsh types, according to the salt content.

• Korean Journal of Agricultural Science
• /
• v.25 no.1
• /
• pp.68-78
• /
• 1998

To investigate the genetic polymorphisms and constitutions of blood proteins and enzymes in the Korean native cattle population of National Livestock Cooperatives Federation(NLCF), the genetic variants of transferrin(Tf), post-transferrin-2(pTf-2), albumin(Alb), post-albumin(pAlb), ceruloplasmin(Cp), amylase-I(Am-I) and herroglobin(Hb) were analyzed using the PAGE(polyacrylamide gel electrophoresis) and ST AGE(starch gel electrophoresis) methods. On the genetic variants of the serum proteins, the transferrin(Tf) locus was assumed to be genetically controlled by codominant alleles, Tf A, $D_1$, $D_2$ and E alleles, and the gene frequencies of these were 0.249, 0.248, 0.260 and 0.243, respectively. The post-transferrin locus was observed to be controlled by pTf-2 F and S alleles, and the gene frequencies of these were 0.662 and 0.338, respectively. The post-albumin(pAlb) loci were identified to be controlled by two alleles, pAlb F and S alleles for pAlb locus, and the gene frequncies of these were 0.440 and 0.560 for pAlb F and S alleles, respectively. On the genetic variants of the serum enzymes, ceruloplasmin(Cp) and amylase-I(Am-I) loci were found to be controlled by two alleles, Cp F and S for Cp locus, and Am-I B and C for Am-I locus, and gene frequencies of these were 0.319 and 0.681 for Cp F and S, and 0.871 and 0.120 for Am-I Band C, respectively. On the genetic variants of the hemoglobin(Hb), the distributions of genotypes were 76.5, 21.2 and 2.3% for Hb AA, AB and BB types, and the gene frequnecies for Hb A and B were 0.871 and 0.129, respectively. On the effects of genetic variants of blood proteins, Tf $D_1D_1$, $D_2D_2$ and $D_2E$ genotypes were significantly higher on body weight at 6 month and average daily gain than that of other Tf genotypes.

• Journal of The Korean Association For Science Education
• /
• v.19 no.3
• /
• pp.428-440
• /
• 1999

The colorful overhead projector films, named as Bio-cosmos II, including photographs, pictures, concept maps, and diagrams, were developed and manufactured as audio-visual teaching aids and teaching resources for students' biology learning in high school, and the CD-ROM and web sites for their application to the school were also constructed. The content of the films was organized based upon the analysis of seven different biology textbooks approved by the Ministry of Education. The films were designated based on various instructional strategies and manufactured using multimedia with various educational softwares. The CD-ROM was composed of the scenes as logo, initial main, chapters list, contents, and quit. Initial main scene indicated various chapters according to the texts of biology areas in General Science, Biology I, and II. Each chapters linked with the scenes for detailed concept maps, the downstream real subjects, and contents. The subject screens were composed of various types of summarized diagrams including lesson contents, figures, pictures, photographs, and their explanation, experimental procedures and results, tables for summarized contents, and additional animation with video captures, explanations, glossary, etc. Most files were manufactured in software Adobe Photoshop by scanning the pictures, figures and photographs, and then the explanation, modification, storing with PICT or PSD files, and transformation with JPG files, were processed in the aspect of high quality in terms of instructional strategies and graphic skills on gracefulness, clearness, colorfulness, brightness, and distinctness. A 14 films for biology areas in General Science, 80 for Biology I, and 142 for Biology II were manufactured and loaded to the CD-ROM and web site, and the files had been attempted to opened with an internet home-page of http://gic.kyungpook.ac.kr/biocosmos.