• The KIPS Transactions:PartD
• /
• v.12D no.1 s.97
• /
• pp.13-20
• /
• 2005

The join operation is an important, fundamental operation in database systems, and it costs much to execute. In the literature, there are a number of technical attempts on development and evaluation of efficient join operations, all of which have been carried out In developers' perspective. This paper proposes a join operations benchmark that is dedicated to the evaluation of the join operations in database systems in users' perspective. This benchmark helps users select a database system that performs the join operations well in their work environment. The benchmark consists of 42 join queries, which are derived from on six performance factors that are picked out in two join categories. We have implemented this benchmark with two commercial database systems. The experimental results are also reported.

• Journal of the Korean Society of Safety
• /
• v.28 no.1
• /
• pp.137-143
• /
• 2013

Cultural heritage passing down to posterity is a global concern. But there are many culture heritage that not remained to now disappeared by various disasters. It is told that disaster is learnt from disaster. The most fundamental task in disaster prevention is to collect and analyze cases of accidents so as not to repeat a disaster. In other words, an analysis of various disaster-related materials and their countermeasures in the Joseon period is an actual condition-based phenomenological methodology used to prevent disasters at cultural properties today. In this context, it is important to collect histories of disasters in the Joseon period, to extract disaster-related historical data and to categorize the data to build a disaster literature database. This study has produced [Database of Disasters in the Joseon Era], a collection of articles on fire outbreaks based on The Annals and The Daily Records belonging to the Memory of the World. On the basis of this chronology, human and property damages caused by fires in Joseon have been examined, identified by districts, as well as disaster technologies, have been analyzed. It has also built disaster vulnerability maps in the Joseon Dynasty Era.

• Journal of KIISE:Computing Practices and Letters
• /
• v.16 no.11
• /
• pp.1046-1050
• /
• 2010

Corpus is widely used as a fundamental resource for various purposes in linguistic studies. There are several large corpora such as Sejong corpus in Korea. However, it is hard to find a tool utilizing such large corpora. In this paper, we propose a method of utilizing Sejong corpus based on the relational database. We designed the relational database scheme to store corpus and implemented a Web-based application so that many researchers can easily access and utilize the Sejong corpus.

• Genomics & Informatics
• /
• v.15 no.1
• /
• pp.19-27
• /
• 2017

Understanding complex relationships among heterogeneous biological data is one of the fundamental goals in biology. In most cases, diverse biological data are stored in relational databases, such as MySQL and Oracle, which store data in multiple tables and then infer relationships by multiple-join statements. Recently, a new type of database, called the graph-based database, was developed to natively represent various kinds of complex relationships, and it is widely used among computer science communities and IT industries. Here, we demonstrate the feasibility of using a graph-based database for complex biological relationships by comparing the performance between MySQL and Neo4j, one of the most widely used graph databases. We collected various biological data (protein-protein interaction, drug-target, gene-disease, etc.) from several existing sources, removed duplicate and redundant data, and finally constructed a graph database containing 114,550 nodes and 82,674,321 relationships. When we tested the query execution performance of MySQL versus Neo4j, we found that Neo4j outperformed MySQL in all cases. While Neo4j exhibited a very fast response for various queries, MySQL exhibited latent or unfinished responses for complex queries with multiple-join statements. These results show that using graph-based databases, such as Neo4j, is an efficient way to store complex biological relationships. Moreover, querying a graph database in diverse ways has the potential to reveal novel relationships among heterogeneous biological data.

• Phonetics and Speech Sciences
• /
• v.1 no.4
• /
• pp.147-157
• /
• 2009

The purpose of the study is to develop the normal voice database and to analyze the acoustic characteristics of Korean adults' voices by gender using MDVP. Eight categories in the 34 parameters of MDVP were analyzed in the voices of 170 Korean normal adults taken from /a/ vowel. Among them, Fundamental Frequency Parameters and Frequency Perturbation Parameters were significantly different by gender. In addition, Fundamental Frequency Parameters of our data were remarkably different from the data suggested in the MDVP program which currently used in clinics. Therefore, the data obtained from the current study can be effectively used for the diagnosis of voice disorders of Korean adults as the standard parameter values of MDVP.

• Proceedings of the Korea Concrete Institute Conference
• /
• 2010.05a
• /
• pp.61-62
• /
• 2010

This paper provides an analysis using statistical method on the basis of database (DB) of bridge inspection reports performed by KISTEC from 1995 to 2007. Measured impact factors of total 36 railway bridges were classified by the span length, type of bridges and natural frequency. The fundamental frequency and the impact factors of inspected bridge are compared with formulas specified in both domestic and foreign railway bridge design codes.

• Proceedings of the Korean Vacuum Society Conference
• /
• 2015.08a
• /
• pp.64-64
• /
• 2015

Control of plasma processing methodologies can only occur by obtaining a thorough understanding of the physical and chemical properties of plasmas. However, all plasma processes are currently used in the industry with an incomplete understanding of the coupled chemical and physical properties of the plasma involved. Thus, they are often 'non-predictive' and hence it is not possible to alter the manufacturing process without the risk of considerable product loss. Only a more comprehensive understanding of such processes will allow models of such plasmas to be constructed that in turn can be used to design the next generation of plasma reactors. Developing such models and gaining a detailed understanding of the physical and chemical mechanisms within plasma systems is intricately linked to our knowledge of the key interactions within the plasma and thus the status of the database for characterizing electron, ion and photon interactions with those atomic and molecular species within the plasma and knowledge of both the cross-sections and reaction rates for such collisions, both in the gaseous phase and on the surfaces of the plasma reactor. The compilation of databases required for understanding most plasmas remains inadequate. The spectroscopic database required for monitoring both technological and fusion plasmas and thence deriving fundamental quantities such as chemical composition, neutral, electron and ion temperatures is incomplete with several gaps in our knowledge of many molecular spectra, particularly for radicals and excited (vibrational and electronic) species. However, the compilation of fundamental atomic and molecular data required for such plasma databases is rarely a coherent, planned research program, instead it is a parasitic process. The plasma community is a rapacious user of atomic and molecular data but is increasingly faced with a deficit of data necessary to both interpret observations and build models that can be used to develop the next-generation plasma tools that will continue the scientific and technological progress of the late 20th and early 21st century. It is therefore necessary to both compile and curate the A&M data we do have and thence identify missing data needed by the plasma community (and other user communities). Such data may then be acquired using a mixture of benchmarking experiments and theoretical formalisms. However, equally important is the need for the scientific/technological community to recognize the need to support the value of such databases and the underlying fundamental A&M that populates them. This must be conveyed to funders who are currently attracted to more apparent high-profile projects.

• Journal of the Korean Society for information Management
• /
• v.4 no.1
• /
• pp.24-46
• /
• 1987

The recent growth of full-text database operations has brought new opportunities for subject access. The fundamental problem of subject access in the online environment is the indexing language and technology. The purpose of this paper is to identify the characteristics and capabilities of full-text retrieval as compared to traditional bibliographic retrieval. Retrieval performance of indexing languages, full-text systems features achieved so far, and the new role of a controlled vocabulary, are examined. This paper also includes a review of the research on full-text retrieval performance.

• The Journal of Society for e-Business Studies
• /
• v.1 no.1
• /
• pp.69-92
• /
• 1996

An Integrated Data Environment (IDE) is the end state of the CALS vision. It refers to an environment where all the data generated from the entire lifecycle activities of a product can be shared by anyone that participates in the management. engineering, manufacturing, or support of the product, although the data are geographically distributed and are maintained in heterogeneous platforms. The primary purpose of this paper is to introduce the fundamental concept, architecture, and core implementation technology of an IDE. The secondary purpose is to suggest some strategic directions to the planning staffs in both government and industry. and to suggest some research issues to the researchers in academia. The reference architecture of an IDE being developed by the US DoD and that of NIIIP (National Industrial Information Infrastructure Protocol) being developed by a consortium are discussed. Two principal issues of implementing an integrated database, i.e., distributed object computing including CORBA and multi-database system (MDBS) are reviewed. As a conclusion. the author suggests that daring investment in prototyping an IDE by a nationwide consortium is essential to keep up with the advanced countries in CALS implementation.

• Journal of Computing Science and Engineering
• /
• v.4 no.4
• /
• pp.276-290
• /
• 2010

The join operator is fundamental in relational database systems. Evaluating join queries on large tables is challenging because records need to be efficiently matched based on a given key. In this work, we analyze join queries in SQL with large tables in which a foreign key may be null, invalid or valid, given a referential integrity constraint. We conduct an extensive join performance evaluation on three DBMSs. Specifically, we study join queries varying table sizes, row size and key probabilistic distribution, inserting null, invalid or valid foreign key values. We also benchmark three well-known query optimizations: view materialization, secondary index and join reordering. Our experiments show certain optimizations perform well across DBMSs, whereas other optimizations depend on the DBMS architecture.