데이터는 살아 움직이고 있다. 10년 전만 해도 10GB 정도의 데이터라면 대용량 데 이터라고 불리던 시절이 있었다. 하지만 지금은 10TB보다 큰 데이터베이스도 흔하다. 결국, 대용량 데이터베이스(VLDB)의 시대가 개막된 것이다. VLDB로 변한 데이터베이스에는 백업, 복구, 관리와 같은 문제점이 있지만 그 중에 서도 성능 문제를 빼놓을 수 없다. 데이터베이스에 많은 데이터가 있고 그렇게 많은 데이터 중에서 필요한 몇 건의 데이터만 추출하는 것이 쉬운 일이 아니다. 과거에는 데이터가 적었기 때문에 이러한 것이 큰 문제가 아니었지만 이제는 VLDB가 되면서 성능 최적화는 일상적이고도 중요한 이슈가 되었다. 따라서 VLDB가 된 데이터베이스 나 VLDB로 변하고 있는 데이터베이스에서 성능 관리를 하고 최적화할 수 있는 전문 기술이 필요하다.

미국의 한국전 참전용사를 위한 인터넷 사이트에 게시 중인 242매의 1:50,000 축척의 지도를 분석하였다. 미육군지도창에서 발간된 지도에 대하여 지도제작을 위한 데이터 수집방법과 제작연도 및 지명표기를 위해 사용된 언어를 중심으로 난외주기를 읽어서 정리하였다. 분석에 이용된 240개 지도가운데 91개 도엽의 지도는 1910년대와 1930년대에 발간된 일본이 제작한 지도를 그대로 복제한 것이며, 24개 지역의 지도는 일본이 제작한 지도를 기반으로 재제도한 것이다. 가장 많은 수인 125개 도엽은 일제 강점기의 지도에 제2차 세계대전과 한국전 전후로 미군이 수집한 항공촬영정보를 보완하여 편집한 지도이다. 일본식 지명은 복제된 지도와 대부분의 편집된 지도에 그대로 나타나며, 이들이 미국의 국가지리정보국에서 운영 중인 지명 데이터베이스에 수록되게 되고 현재까지도 이칭의 형태로 남아 구글 어스 지도와 같은 인터넷 매체에 발견되는 오류의 근원이 되고 있다.

This study aimed at construction of text and graphic database for moment-rotation curves of partially restrained composite beam-to-column connections. key words The M-θ data or figures under monotonic or cyclic tests are made as text files. Also, Eurocode 3 classification is added to the M-θ curve to verify as semi-rigid connections. For structural analysis, linear rotational stiffeness or nonlinear M-θ curves are transformed three-parameter power model. Although this database has some limitation, it will be used for further PRCC researches and tests.

We constructed a photometric database system which is optimally designed for microlensing events from KMTNet (Korea Microlensing Telescope Network) observation. We developed a framework software for the convenience of archiving, uploading, searching, and downloading of processed photometric data. From various tests for optimal data archiving engines, we found that the MyISAM storage engine shows the best performance. For the high performance of database system, data types of each field are carefully suggested from various combinations of tests especially to correct round-off errors. The developed framework provides the convenience of access to the database server using query forms via web pages, and displays the light curve of selected target for a quick view.

Korea Astronomy and Space Science Institute (KASI) has constructed online database of the Korean Astronomical Almanac as a part of the 'Knowledge and Information Business Project 2009' supported by the Ministry of Knowledge Economy. Throughout this project, KASI provides both digitized images and extracted text from the almanac covering approximately 240 years. The primary purpose of this paper is to serve as a reference for users of the almanac database. Hence, we introduce the calendar history and kinds of the astronomical almanac used in Korea, and explain the contents of the almanacs according to its appearance time. We also briefly mention the steps employed in constructing the database system and Web site. Since ancient times, astronomical almanacs have been an essential part of daily life. We, therefore, believe that the astronomical almanac database constructed by KASI will prove its usefulness in various fields, and particularly in the study of historical astronomy.

We tried to establish the history of outbreaks and control methods of ‘hwangchung’ in Joseon Dynasty, uncovering the biological reality of the ‘hwangchung’ (called hwang or bihwang) analyzed through the Database program on ‘the Annals of the Joseon Dynasty’ and ‘the Enrollment of Haegoeje’, two of the finest examples of classical historical records. The total number of articles on the outbreak of the hwangchung is 261 in the Annals of the Joseon Dynasty and 65 in the Enrollment of Haegoeje. There were four peaks by hwangchung throughout the Joseon Era. Among them, the periods of King Taejo to King Sejong had the highest incidence. By comparing the number of records of the hwangchung from the Annals of the Joseon Dynasty with that in the Enrollment of Haegoeje during the same period, results show the former was less than the latter, 35 vs 65. However, both records were relatively inconsistent with each other. Insect pests in forests as well as in agriculture were included in the biological identities of the hwangchung in the Joseon Dynasty periods, which is in accordance with those of Saigo’s. The taxonomic identity could be confirmed in only 25 cases (9.5%) among the articles on hwangchung. It largely coincided with Paik"s opinion: 11 in armyworm, nine in moth larva, one in rice stem borer, two in migratory locust, one in planthopper and one in rice-plant weevil. Therefore, it is not reasonable to regard hwangchung as a migratory locust or grasshopper only. The number of reports on the occurrence of hwangchung in the Annals of the Joseon Dynasty was 173 (66% of the total) and 47% of them were just simple reports, which means the report itself on the appearance of hwangchung was very significant. The reports on controlling insect pests were of low frequency, in 20% (34 cases) of the total reports, capturing insect pests or holding traditional ceremony called ‘Poje’. Among them, only one case related to the treatment of seeds to prevent the damage by hwangchung was published in the King Sejong period. There were 37 discussions about changes and management of government policies due to disasters by hwangchung. They were mostly about relief or tax cut to the people who suffered damage and about cancellation of recruiting people to military training, constructing castles, and so on. It seems that not only the people but also the king was influenced by the hwangchung. In the case of King Seongjong, he referred to the stress of the prevention measure of locusts in 10 articles. The damage also had an effect on abdication in the reign of King Jeongjong.

최근 국가지리정보유통망을 통한 공간정보 통합에 대한 논의처럼, 속성데이터 중심의 인문지리정보 데이터베이스도 시작 단계에서부터 향후의 통합을 고려한 프로토콜을 필요로 한다. 본 연구에서는 효율적인 인문지리정보 DB 구축을 위해 DB 모델의 원칙과 절차, 즉 데이터 모델, DB 정규화, 데이터 무결성에 대해 인문지리정보 사례를 통해 방향을 제시하였고, 인문지리정보의 변화를 수용할 수 있는 시간성 확보 방안과 온톨로지와 통합DB를 효과적으로 연계하는 방안을 제시하였다. 특히 시간에 따른 정보의 변화를 저장하기 위해 TimeStamp 객체와 TimeSPAN 객체를 DB에 임베드하였고 시간관계 함수를 이용해 검색할 수 있도록 하였다. 또한 수시 갱신이 필요한 인문지리정보 DB를 온톨로지와 연계하기 위해서는 DBMS 내의 RDF 객체를 활용하는 효율적인 방법을 제시하였다. 이러한 방안은 인문지리정보 DB 뿐만 아니라 수시갱신이 요구되는 대용량의 DB 구축시 가장 근본적으로 검토하여야 할 내용을 제시해 줄 것이다.

본 연구는 국립기상연구소에서 생산한 기상자원지도 및 기상정보의 원시자료로부터 Web2.0기반의 기상자원정보시스템 설계 및 구축을 목적으로 한다. 세부 목표로는 (1)기상자원 DB의 공간정보화, 통계적 정보 제공에 적합한 DB 서비스 개발 (2)사용자 경험 중심의 RIA 서비스 개발, (3)기상자원 KML 배포 서비스 웹 제공을 통해 사용자가 참여와 기상정보 콘텐츠 창작환경 조성에 있다. 이를 위해 풍력과 태양광 관련 기상자원지도와 원시자료를 이용해 GeoDB 및 웹서비스를 설계 및 구현하였다. 결과로서 구축된 기상자원 GeoDB 및 웹서비스가 Web2.0 패러다임을 지향하는 지에 대해 그 활용성을 평가하였다. 본 연구를 통해 생산생산된 기상자원 공간/통계 정보 및 RIA서비스는 입지분석, 의사결정지원, 창작활동 등 여러 응용분야에 유용하게 활용될 것이다.

The Realization of Ubiquitous is achieved by magic mirror and it is required more concrete study to realize it's functionality. Especially its function of professional fashion co-ordinator for managing the appearance could be of further use. The Objective of this Study is to establish RFID chip data base to put into a computer for making use of the functionality of the magic mirror aiming at suggesting the available information on the total fashion co-ordination. I sought firstly the code with binary system determining the criteria of accessories to be input in a RFID chip. Secondly, as the image with cloth is an important element for the total fashion co-ordination, desired co-ordination among the emphasis, harmony, character, season and accent can be made selectable classifying into a limit element and a common element to extract the codes. Thirdly, necessary conditions were given to the generated codes using Visual C++ program of Microsoft and the extracted codes as per groups were compared and analyzed.

DNA ‘barcoding’ has potential applications in insect pest monitoring and quarantine since large numbers of DNA sequences for insect species identification have been reported in recent years. However, the exact number of relevant COI sequences in public databases such as NCBI (http://www.ncbi.nlm.nih.gov/) is not readily available. The IMGD (Insect Mitochondrial Genome Database; http://www.imgd.org) contains 162,847 partially sequenced mitochondrial gene entries originated from 35,067 hexapod species and makes it possible to check whether DNA sequences have been previously reported or not for certain insect species. In this study, we applied the IMGD to establish baseline data for the forest pest insects in Korea, before constructing a DNA barcode system. Retrieving data from the IMGD, we recognized that DNA sequences were already available for 73 of 259 species known as forest pest insects in Korea. Most of the 73 species with DNA sequences are common pests worldwide but there maining 186 species are endemic to the Eastern Palearctic region. Based on these data, we are proceeding to construct a Korean Forest Insect Pest DNA barcode database.

In this study, we have developed the database of safety and health information for pesticide active ingredients used in Korea. There were 1,283 pesticide items among which 296 were found to be out of use in current. A total of 349 pesticide ingredients were being used in Korea. The database consists of 32 types of information including chemical characteristics, acute toxicity, chronic toxicity (carcinogenic and reproductive toxicity), specific symptoms by exposure route and first aid. When pesticide ingredients were assessed in terms of key properties such as color, odor, acute toxicity, carcinogenic and reproductive toxicity, they were white, colorless and odorless, in general. When ingredients were classified by category of acute toxicity, 'Non-hazardous' represented 29%, followed by 'Slightly hazardous' at 16%, 'Moderately hazardous' at 14%, 'Highly hazardous' at 5%, and 'Extremely hazardous' at 2%. 85 out of 349, or 24% of ingredients were found to be possibly carcinogenic to human. This database is expected to provide an easy access for farmers, agriculture supervisors, researchers and consumers, and it can ultimately be used as basic data on farmer's safety and health.

인공지능 캐릭터에 대한 연구는 게임뿐만 아니라 애니메이션 그래픽스 분야에서 가장 많이 연구되고 논의되어 왔 던 이론 중의 하나이다. 게임 환경의 인공지능 캐릭터인 NPC는 감각 시스템을 이용하여 환경을 인지하고 기억 시스 템에 저장한다. 기억 체계는 감각 기억과 인지 기억으로 구성되고 인지 기억은 공간 데이터베이스 이론에 기반을 둔 공간에 존재하는 정보들 간의 위치 관계를 이용하여 정보를 저장한다. 본 논문에서는 NPC의 효율적인 인지 기억 기 법으로 공간 데이터베이스 이론과 퍼지이론을 적용하여 인지한 객체 간의 관계그래프, 즉 인지 맵을 만들어 기억한다. 즉 기억된 정보간의 인지 맵을 표현하기 위해 퍼지함수 이론을 적용한다. NPC는 이 인지 맵을 통해 객체 간의 개략 적인 거리와 방향을 자신의 인지 메모리에 저장 가능하다. 실험 결과 인지 맵을 이용한 결과 NPC의 목표 객체 탐색 시간이 기존 NPC와 비교하여 1.5배 향상되었다.

We have designed data processing server system to include data archiving, photometric processing and light curve analysis for KMTNet (Korea Microlensing Telescope Network). Outputs of each process are reported to the main photometric database, which manages the whole processing steps and archives the photometric results. The database is developed using ORACLE 11g Release 2 engine. It allows to select objects applying any set of criteria such as RA/DEC coordinate and Star ID, etc. We tested the performance of the database using the OGLE photometric data. The searching time for querying 70,000,000 records was under 1 second. The database is fully accessed using query forms via web page.

To search for hyper-variable genetic markers that can distinguish regional populations of head lice, we screened the inter simple sequence repeats (ISSR) based on the genome database of body louse, which is closely related conspecific species. An ISSR mining software, SciRoKo 3.4, was employed to excavate ISSR markers from the genome database under the MISA mode (≥ 60 bp repeats). Entire body louse genome (ca.100 Mb) was loaded to SciRoKo for ISSRs mining. A total of 5,336 ISSRs were obtained, and primers specific to individual ISSRs were designed by the Primer 3 and DesignPrimer 1.0 softwares. In order to prove the compatibility of body louse ISSRs to head lice, 31 PCR primers were randomly chosen out of a total of 613 pairs, and their appropriateness was tested by comparing the amplified PCR band patterns between body and head lice. Eleven primer pairs that resulted in poor or little amplification were excluded, and 20 primer pairs were further tested for three head louse populations (California, Panama and Chung-ju, Korea). Finally, nine primer pairs ensuring robust amplification of highly variable band patterns were selected to use for population genetic study of head lice.

본 논문에서는 유도무기 통합 설계 프레임워크를 위한 데이터베이스를 설계하였다. 실제 개발에 앞서 유도무기 설계에 필요한 데이터베이스를 위한 요구도를 분석하였으며, 데이터베이스 설계 개념을 정립하였다. 또한 해석도구 간의 데이터흐름 등을 파악하였으며, 이들 정보를 토대로 테이블들을 구성하고 각 객체관계를 정의하여 데이터베이스 스키마를 설계 및 구축하였다. 개발된 DB는 유도무기 통합 설계 프레임워크에 통합되었으며 프레임워크내의 데이터 저장, 검색 및 관리 등의 역할을 수행하며, 유도무기 설계에 적용하여 그 효용성을 검증하였다.

The purpose of this research is to develope street trees management program for more an effective street trees management. The principal point of this program is to relate spatial data and attribute data that is the main concept in GIS(Geographic Information System). To do this function, MapObjects which is ESRI's mapping and GIS components was used to process spatial data and Access which had been developed by MS was used to manipulate attribute data in this program. Visual Basic also was used to design and develop user interfaces and procedures, relate two sort of data, and lastly complete Application. Relational data model was adopted to design tables and their relation, Antenucci's GIS development model was selected to design and complete this program. The configuration of this application is composed of management data and reference data. The management data includes the location of street tree, a growth condition, a surrounding environment, the characters of tree, an equipments, a management records and etc. The reference data include general information about tree, blight and insects.