• Title/Summary/Keyword: database systems

Search Result 2,864, Processing Time 0.03 seconds

A comparative study of library automation among Korea, Taiwan and Japan (한국. 중국. 일본의 도서관 자동화 비교 연구)

  • 이영자;남권희
    • Journal of Korean Library and Information Science Society
    • /
    • v.10
    • /
    • pp.193-228
    • /
    • 1983
  • The purposes of this study are; 1) to make a comparative analysis of the background factors helping the development of the library automation among Korea, Taiwan and Japan. 2) and on the basis of the analysis results, to make some suggestions on improving the variables which are likely to have influence on the library automation development. To accomplish the purpose of the study; 1) the use of computer and data communication technology for the library operations and the science policies among three countries were discussed as the background factors, 2) the pattern of library automation among three countries were presented, 3) the process of MARC development of three countries were compared with, 4) and three countries# information processing systems were discussed. The results of the study can be summarized as follows; 1) The a n.0, pplication of a computer into the library operations in Korea began much later than the other countries. 2) Korea has not have any independent department in the government organization taking charge of the policy making about the library automation in relation to the science policy. 3) Speaking of the national scientific and technological information center, JICST was founded in 1952, 국과회과중심 in 1958, and KORS TIC in 1962. 4) On the one hand, in both Taiwan and Japan, the circulation and acquisition systems tended to be first automated, on the other hand, in Korea the developments of MARC and bibliographies through the production of database were laid the emphasis. 5) The introduction and dissemination of LC MARC Tapes were implemented in Japan in 1972. Taiwan made various tests in the Tape in 1974. Korea planned to introduce and make tests on the Tape in 1983. 6) For the input system, Korea has developed KIPS series, 1,2,3. Chinas# 삼각호마법 and Japan#s 병음한자변환방식 have prospect to be prevalent. The following suggestions can be made from these results, 1) All the information infrastructures should be established in a desirable way. 2) The communication window for the information users is recommended to be set up. 3) The su n.0, pport for the physical environment such as library building, computer facilities, etc. should be provided. 4) The facilities necessary for the education of professionals in the library science department should be su n.0, pported. 5) A department of the government organization exclusively responsible for the development of library automation should be founded.

  • PDF

An Efficient Query Transformation for Multidimensional Data Views on Relational Databases (관계형 데이타베이스에서 다차원 데이타의 뷰를 위한 효율적인 질의 변환)

  • Shin, Sung-Hyun;Kim, Jin-Ho;Moon, Yang-Sae
    • Journal of KIISE:Databases
    • /
    • v.34 no.1
    • /
    • pp.18-34
    • /
    • 2007
  • In order to provide various business analysis methods, OLAP(On-Line Analytical Processing) systems represent their data with multidimensional structures. These multidimensional data are often delivered to users in the horizontal format of tables whose columns are corresponding to values of dimension attributes. Since the horizontal tables nay have a large number of columns, they cannot be stored directly in relational database systems. Furthermore, the tables are likely to have many null values (i.e., sparse tables). In order to manage the horizontal tables efficiently, we can store them as the vertical format of tables which has dimension attribute names as their columns thus transforms the columns of horizontal tables into rows. In this way, every queries for horizontal tables have to be transformed into those for vertical tables. This paper proposed a technique for transforming horizontal table queries into vertical table ones by utilizing not only traditional relational algebraic operators but also the PIVOT operator which recent DBMS versions are providing. For achieving this goal, we designed a relational algebraic expression equivalent to the PIVOT operator and we formally proved their equivalence. Then, we developed a transformation technique for horizontal table queries using the PIVOT operator. We also performed experiments to analyze the performance of the proposed method. From the experimental results, we revealed that the proposed method has better performance than existing methods.

Building Transparency on the Total System Performance Assessment of Radioactive Repository through the Development of the FEAS Program (FEAS 프로그램 개발을 통한 방사성폐기물 처분장 종합 성능 평가(TSPA) 투명성 증진에 관한 연구)

  • 서은진;황용수;강철형
    • Tunnel and Underground Space
    • /
    • v.13 no.4
    • /
    • pp.270-278
    • /
    • 2003
  • Transparency on the Total System Performance Assessment (TSPA) is the key issue to enhance the public acceptance for a permanent high level radioactive repository. Traditionally, the study on features, events and processes (FEPs) and associated scenarios has been regarded as the starting point to open the communicative discussion on TSPA such as what to evaluate, how to evaluate and how to translate outcomes into more friendly language that many stakeholders can easily understand and react with. However, in most cases, it has been limited to one way communication, because it is difficult for stakeholders outside the performance assessment field to assess the details on the story of the safety assessment, scenario and technical background of it. Fortunately, the advent of the internet era opens up the possibility of two way communication from the beginning of the performance assessment so that every stakeholder can exchange their keen opinions on the safety issues. To achieve it, KAERI develops the systematic approach from the FEPs to Assessment methods flow chart. All information is integrated into the web based program named FEAS (FEp to Assessment through Scenario development) under development in KAERI. In parallel, two independent systems are also under development the web based QA(Quality Assurance) system and the PA(Performance Assessment) input database. It is ideal to integrate the input data base with the QA system so that every data in the system can checked whenever necessary. Throughout the next phase R&D starting from the year 2003, these three systems will be consolidated into one unified system.

A Novel Query-by-Singing/Humming Method by Estimating Matching Positions Based on Multi-layered Perceptron

  • Pham, Tuyen Danh;Nam, Gi Pyo;Shin, Kwang Yong;Park, Kang Ryoung
    • KSII Transactions on Internet and Information Systems (TIIS)
    • /
    • v.7 no.7
    • /
    • pp.1657-1670
    • /
    • 2013
  • The increase in the number of music files in smart phone and MP3 player makes it difficult to find the music files which people want. So, Query-by-Singing/Humming (QbSH) systems have been developed to retrieve music from a user's humming or singing without having to know detailed information about the title or singer of song. Most previous researches on QbSH have been conducted using musical instrument digital interface (MIDI) files as reference songs. However, the production of MIDI files is a time-consuming process. In addition, more and more music files are newly published with the development of music market. Consequently, the method of using the more common MPEG-1 audio layer 3 (MP3) files for reference songs is considered as an alternative. However, there is little previous research on QbSH with MP3 files because an MP3 file has a different waveform due to background music and multiple (polyphonic) melodies compared to the humming/singing query. To overcome these problems, we propose a new QbSH method using MP3 files on mobile device. This research is novel in four ways. First, this is the first research on QbSH using MP3 files as reference songs. Second, the start and end positions on the MP3 file to be matched are estimated by using multi-layered perceptron (MLP) prior to performing the matching with humming/singing query file. Third, for more accurate results, four MLPs are used, which produce the start and end positions for dynamic time warping (DTW) matching algorithm, and those for chroma-based DTW algorithm, respectively. Fourth, two matching scores by the DTW and chroma-based DTW algorithms are combined by using PRODUCT rule, through which a higher matching accuracy is obtained. Experimental results with AFA MP3 database show that the accuracy (Top 1 accuracy of 98%, with an MRR of 0.989) of the proposed method is much higher than that of other methods. We also showed the effectiveness of the proposed system on consumer mobile device.

A Hybrid Collaborative Filtering Using a Low-dimensional Linear Model (저차원 선형 모델을 이용한 하이브리드 협력적 여과)

  • Ko, Su-Jeong
    • Journal of KIISE:Software and Applications
    • /
    • v.36 no.10
    • /
    • pp.777-785
    • /
    • 2009
  • Collaborative filtering is a technique used to predict whether a particular user will like a particular item. User-based or item-based collaborative techniques have been used extensively in many commercial recommender systems. In this paper, a hybrid collaborative filtering method that combines user-based and item-based methods using a low-dimensional linear model is proposed. The proposed method solves the problems of sparsity and a large database by using NMF among the low-dimensional linear models. In collaborative filtering systems the methods using the NMF are useful in expressing users as semantic relations. However, they are model-based methods and the process of computation is complex, so they can not recommend items dynamically. In order to complement the shortcomings, the proposed method clusters users into groups by using NMF and selects features of groups by using TF-IDF. Mutual information is then used to compute similarities between items. The proposed method clusters users into groups and extracts features of groups on offline and determines the most suitable group for an active user using the features of groups on online. Finally, the proposed method reduces the time required to classify an active user into a group and outperforms previous methods by combining user-based and item-based collaborative filtering methods.

Linear cutting machine test for assessment of the cutting performance of a pick cutter in sedimentary rocks (퇴적층 암석의 픽 커터 절삭성능 평가를 위한 선형절삭시험)

  • Jeong, Hoyoung;Jeon, Seokwon
    • Journal of Korean Tunnelling and Underground Space Association
    • /
    • v.20 no.1
    • /
    • pp.161-182
    • /
    • 2018
  • We carried out a series of linear cutting machine tests to assess the cutting performance of a pick cutter in sedimentary rock. The specimens were Linyi sandstone from China and Concrete (rock-like material, conglomerate). Using the small scaled LCM system, we estimated the cutter force and specific energy under different cutting conditions. The cutter forces (cutting and normal) increased with penetration depth and cutter spacing in two rock types, and it was affected by the strength of specimens. On the other hand, the ratio of the peak cutter force to the mean cutter force was influenced by cutting characteristic and composition of rock rather than rock strength. The cutting coefficient was affected by the friction characteristic between rock and pick cutter rather than the cutting conditions. Therefore, the optimal cutting angle can be determined by considering of cutting coefficient and resultant force of pick cutter. The optimum cutting condition was determined from the relationship between the specific energy and cutting condition. For two specimens, the optimum s/p ratio was found to be two to four, and the specific energy decreased with the penetration depth. The result from this study can be used as background database to understand the cutting mechanism of a pick cutter, also it can be used to design for the mechanical excavator.

An Algorithm for Finding a Relationship Between Entities: Semi-Automated Schema Integration Approach (엔티티 간의 관계명을 생성하는 알고리즘: 반자동화된 스키마 통합)

  • Kim, Yongchan;Park, Jinsoo;Suh, Jihae
    • Journal of Intelligence and Information Systems
    • /
    • v.24 no.3
    • /
    • pp.243-262
    • /
    • 2018
  • Database schema integration is a significant issue in information systems. Because schema integration is a time-consuming and labor-intensive task, many studies have attempted to automate it. Researchers typically use XML as the source schema and leave much of the work to be done through DBA intervention, e.g., there are various naming conflicts related to relationship names in schema integration. In the past, the DBA had to intervene to resolve the naming-conflict name. In this paper, we introduce an algorithm that automatically generates relationship names to resolve relationship name conflicts that occur during schema integration. This algorithm is based on an Internet collocation and English sentence example dictionary. The relationship between the two entities is generated by analyzing examples extracted based on dictionary data through natural language processing. By building a semi-automated schema integration system and testing this algorithm, we found that it showed about 90% accuracy. Using this algorithm, we can resolve the problems related to naming conflicts that occur at schema integration automatically without DBA intervention.

The Demand Survey and Correlational Analysis for Geological Data (지질 자료의 수요조사 및 상관성 분석)

  • Hwang, JaeHong;Chi, KwangHoon;Han, JongGyu;Yeon, YoungKwang;Ryu, Keun Ho
    • Journal of the Korean Association of Geographic Information Studies
    • /
    • v.10 no.1
    • /
    • pp.60-72
    • /
    • 2007
  • In general, the importance of geological information is emphasized not only for national SOC construction, underground space development and energy resources development but also in areas related to environmental disasters such as mine damage, ground subsidence and landslides. Although geological information is highly useful in developing industrial raw materials, national land management and people's welfare, there is no unified governmental institution in charge of collecting and managing geological information in the national level. For this, this paper study: first, to analyze geological demand for common experts; second, to analyze geological demand for public institution; and third, to set priority for geological informatization. In the result of surveying demand for geological information, we need to improve laws and systems for collecting and reporting geology-related materials, making thematic maps, and maintaining and managing geological information we need to establish national strategies and build an integrated system for interoperability of databases and systems. Accordingly, we will guideline on future direction of strategies for the national integration of geological information management system.

  • PDF

Spacio-temporal Analysis of Urban Population Exposure to Traffic-Related air Pollution (교통흐름에 기인하는 미세먼지 노출 도시인구에 대한 시.공간적 분석)

  • Lee, Keum-Sook
    • Journal of the Economic Geographical Society of Korea
    • /
    • v.11 no.1
    • /
    • pp.59-77
    • /
    • 2008
  • The purpose of this study is to investigate the impact of traffic-related air pollution on the urban population in the Metropolitan Seoul area. In particular, this study analyzes urban population exposure to traffic-related particulate materials(PM). For the purpose, this study examines the relationships between traffic flows and PM concentration levels during the last fifteen years. Traffic volumes have been decreased significantly in recent year in Seoul, however, PM levels have been declined less compare to traffic volumes. It may be related with the rapid growth in the population and vehicle numbers in Gyenggi, the outskirt of Seoul, where several New Towns have been developed in the middle of 1990's. The spatial pattern of commuting has changed, and thus and travel distances and traffic volumes have increased along the main roads connecting CBDs in Seoul and New Towns consisting of large residential apartment complexes. These changes in traffic flows and travel behaviors cause increasing exposure to traffic-related air pollution for urban population over the Metropolitan Seoul area. GIS techniques are applied to analyze the spatial patterns of traffic flows, population distributions, PM distributions, and passenger flows comprehensively. This study also analyzes real time base traffic flow data and passenger flow data obtained from T-card transaction database applying data mining techniques. This study also attempts to develop a space-time model for assessing journey-time exposure to traffic related air pollutants based on travel passenger frequency distribution function. The results of this study can be used for the implications for sustainable transport systems, public health and transportation policy by reducing urban air pollution and road traffics in the Metropolitan Seoul area.

  • PDF

Generation, Diversity Determination, and Application to Antibody Selection of a Human Naïve Fab Library

  • Kim, Sangkyu;Park, Insoo;Park, Seung Gu;Cho, Seulki;Kim, Jin Hong;S.Ipper, Nagesh;Choi, Sun Shim;Lee, Eung Suk;Hong, Hyo Jeong
    • Molecules and Cells
    • /
    • v.40 no.9
    • /
    • pp.655-666
    • /
    • 2017
  • We constructed a large $na{\ddot{i}}ve$ human Fab library ($3{\times}10^{10}$ colonies) from the lymphocytes of 809 human donors, assessed available diversities of the heavy-chain variable (VH) and ${\kappa}$ light-chain variable (VK) domain repertoires, and validated the library by selecting Fabs against 10 therapeutically relevant antigens by phage display. We obtained a database of unique 7,373 VH and 41,804 VK sequences by 454 pyrosequencing, and analyzed the repertoires. The distribution of VH and VK subfamilies and germline genes in our antibody repertoires slightly differed from those in earlier published natural antibody libraries. The frequency of somatic hypermutations (SHMs) in heavy-chain complementarity determining region (HCDR)1 and HCDR2 are higher compared with the natural IgM repertoire. Analysis of position-specific SHMs in CDRs indicates that asparagine, threonine, arginine, aspartate and phenylalanine are the most frequent non-germline residues on the antibody-antigen interface and are converted mostly from the germline residues, which are highly represented in germline SHM hotspots. The amino acid composition and length-dependent changes in amino acid frequencies of HCDR3 are similar to those in previous reports, except that frequencies of aspartate and phenylalanine are a little higher in our repertoire. Taken together, the results show that this antibody library shares common features of natural antibody repertoires and also has unique features. The antibody library will be useful in the generation of human antibodies against diverse antigens, and the information about the diversity of natural antibody repertoires will be valuable in the future design of synthetic human antibody libraries with high functional diversity.