• Proceedings of the Korea Information Processing Society Conference
• /
• 2015.04a
• /
• pp.534-536
• /
• 2015

소프트웨어 산업의 발전에 따라 개발 수요의 충족 및 개발 효율성의 증대를 위해 다양한 개발 방법론과 개발 지원 도구들이 등장해 왔다. 그러나 데이터베이스 응용 소프트웨어(Database Application Software, DB-App)의 개발이 활발함에도 불구하고, 해당 분야 개발의 효율을 도모하는 방안에 관한 연구는 미비한 실정이다. DB-App의 소스 코드(Source code)에는 쿼리(Query)문이 빈번하게 사용되지만 작성 과정에서 오류가 발생하기가 쉽고 관리에 대한 어려움이 있다. 이는 개발 효율을 저하시켜 비용을 증가시키는 요인이 된다. 본 논문에서는 다양한 데이터베이스와 프로그래밍 언어로 개발되는 DB-App 개발을 지원하기 위한 방법을 기술하였으며, 사용자의 설정에 따라 쿼리문을 포함한 소스 코드를 생성하는 도구를 설계하였다.

• Proceedings of the Korean Society of Surveying, Geodesy, Photogrammetry, and Cartography Conference
• /
• 2004.11a
• /
• pp.325-333
• /
• 2004

Since 1995, One of the NGIS(National Geographic Information System) projects, the underground utilities project has been finished in 2003. The 19 cities in korea for this project will use underground utilities management system using underground utilities database focusing on water and sewage system. However, special expert, technical and experience problem in computer environment has not been had in working department for water and sewage management and maintenance for each local government. The management and maintenance of underground utilities database by manual method is getting lowered a data quality of underground utilities database because of the data omitting, error in writing and securing of the lasted database. Therefore, in this study, Application test for field workers using a mobile tool and environment analysis of wireless communication in Korea and application test of GPS receiver for mobile tools had been processed and made a mobile working environment. The efficient management and maintenance method for underground utilities database has been developed an off- line method for modification and update of database about general work which has a high working frequency because of the limitation of wireless communication environment Also, the emergency working has been applied for on-line method.

• Review of KIISC
• /
• v.4 no.1
• /
• pp.44-52
• /
• 1994

정보화 사회에서는 가계, 기업, 정보 등의 정보 활동의 주체들이 가진 정보자산은 데이타 베이스(이하DB)와 소프트웨어(S/W)로 대변할 수 있으며, 이중 DB는 정보화 사회의 기반시설의 하나라고 볼 수 있다. 특별히 통계DB는 각 주체들에게는 필수적인 정보를 갖고 있다. 금융자산의 정보, 국방에 관련된 병력, 장비, 군수물자등의 정보, 회계정보 뿐 아니라 인구센서스, 경제계획수립 등등의 다양한 분야에 이 통계 DB는 사용되고 있다. 이러한 통계DB는 기존의DB에서의 데이타의 저장, 관리, 추출 기능외에 통계적인 데이타의 분석기능이 요구되고 있다. 통계 처리를 위한 데이타베이스관리 시스템(DBMS, database management system)은 주로 기존의 DBMS 에 통계처리를 위한 기능을 추가하거나 통계를 위한 DB를 따로 구축하는 방법을 사용하고 있다. 따라서 일반적인 DB 보호 기술과 더불어 통계 의 환경을 이해하는 보호 기술이 요구되고 있다. 일반적으로 DB 를 보호하는 방법으로는 물리적인 보안(physical security)과 운영체계 보안(operating system security) 이 있으며, 이들과 함께 데이타 암호화(data encryption)의 방법을 사용하고 있다. DB 의 보안 방법에 관한 연구 중 George I. Davida 등에 의한 방법은 중국인의 나머지 정리(chinese remainder thorem)를 사용하는 암호화 알고리즘을 이용하여 레코드(record) 단위의 암호화를 하며, Khamis A. Omar등에 의한 방법은 읽기, 쓰기, 갱신의 3단계의 사용자 등급을 부여하여 DB 접근의 제약을 가하는 기능을 갖고 있다. 본고에서는 특히 그 중요성이 더해가고 있는 통계 의 일반적인 개념을 살펴보며, 특성 지향형 질의 모델(characteristic-specified query model)의 보호기술을 살펴본다. 특별히 본고는 통계 DB의 보호에 대한 일반적인 조사 연구로서 잘 알려진 사실들을 많은 참고 문헌과 더불어 소개하는 내용으로 통계 DB의 보호에 관한 새로운 연구 결과는 아니다.

• Digital Contents
• /
• no.11 s.6
• /
• pp.8-21
• /
• 1993

"지난 9월 22일에서 25일까지 KOEX에서 개최된 '제1회 서울국제데이터베이스 전시회'는 국내에서 처음 개최된 데이터베이스관련 국제전시회였다는 점에서도 여러가지 의미가 있는 행사였다. 그중에서도 행사기간중인 9월 24일 같은 장소에서 열린 '서울 국제데이터베이스 세미나'는 그간 매년 여러번에 걸쳐 준비되어온 'DB산업 육성을 위한 세미나'를 총정리하면서 고도정보화와 국제화를 맞이하는 국내 DB산업이 안고있는 문제점을 정책 및 공공적인 측면, 이용마인드 확산이라는 홍보 혹은 마케팅적인 측면, 개발과 유통의 표준화라는 기술적인 측면, 해외정보 이용과 기술이전이라는 측면 등에서 다각적으로 점검해 보는 귀중한 기회였다. 세미나에서 발표된 4편의 논문을 분야별로 살펴보면, DB산업의 현좌표에 대해서 최동휘 상무(한국PC통신)가 '국내외 DB산업현황'을, 해외정보이용 마인드 고취와 기술이전에 대해 Jeen Videau 부사장(KSD)이 'DB를 활용한 기술이전 방안'을 DB이용마인드 확산을 위한 마케팅 방법에 대해 우동진 실장(한국전자통신연구소)이 '이용자측면에서 본 DB문제점과 해결방안'을, 마지막으로 DB의 표준화에 대해 오해석 교수(숭실대)가 'DB구축과 유통 표준화'를 발표하는 등 각 분야에서 골고루 핵심적인 논문이 제시되었고 아울러 200여명의 참석자들이 이에 대한 열띤 토론을 벌였다. 이에 'DB월드'에서는 세미나에서 발표된 논문들을 지난호(DB구축과 유통표준화)에 이어 차례로 게재합니다.

• The Journal of the Korea Contents Association
• /
• v.17 no.4
• /
• pp.478-487
• /
• 2017

In recent years, developed countries have begun to pay attention to female workers through work-family balance in order to solve the problem of low fertility and aging. Korea has been building and running a women leaders database (hereafter, women leaders DB) centered on the female professionals since 2011. In particular, the Incheon women leader DB, which was built by Incheon city in 2009, is a classic example. As of 2015, about 2,735 people are registered in Incheon Women Leaders DB and it is systematically creating the database such as age, education, career years, major, occupation, and certification. However, there are administrative problems such as unspecified definition on professionalism and data trust issues including data entry, and DB personnels are concentrated in specific fields. Also, in the case of certification proving expertise, the utilization problem has been revealed including inclusion of private certification not yet verified. In order to solve these problems, we first need to clarify the concept of women leaders and establish the standard. The second is the improvement of data consistency through DB reorganization, and third is to build a system through continuous and active public relations that is used by both job seekers and recruiters.

• Journal of Intelligence and Information Systems
• /
• v.17 no.4
• /
• pp.37-58
• /
• 2011

In general, testing DB applications is much more difficult than testing other types of software. The fact that the DB states as much as the input data influence and determine the procedures and results of program testing is one of the decisive reasons for the difficulties. In order to create and maintain proper DB states for testing, it not only takes a lot of time and efforts, but also requires extensive IT expertise and business knowledge. Despite the difficulties, there are not enough research and tools for the needed help. This article reports the result of research on automatic creation and maintenance of DB states for testing DB applications. As its core, this investigation develops an automation tool which collects relevant information from a variety of sources such as log, schema, tables and messages, combines collected information intelligently, and creates pre- and post-Images of database tables proper for application tests. The proposed procedures and tool are expected to be greatly helpful for overcoming inefficiencies and difficulties in not just unit and integration tests but including regression tests. Practically, the tool and procedures proposed in this research allows developers to improve their productivity by reducing time and effort required for creating and maintaining appropriate DB sates, and enhances the quality of DB applications since they are conducive to a wider variety of test cases and support regression tests. Academically, this research deepens our understanding and introduces new approach to testing enterprise systems by analyzing patterns of SQL usages and defining a grammar to express and process the patterns.

• Journal of Nutrition and Health
• /
• v.47 no.6
• /
• pp.435-442
• /
• 2014

Purpose: The objective of this study was to develop a fatty acid database (DB) for estimation of intake levels of fatty acids in the Korean population, using data from the Korea National Health and Nutrition Survey (KNHANES). Methods: Analytical values of fatty acids in foods were collected from food composition tables of national institutions (National Fisheries Research & Development Institute, Rural Development Administration), Japan Ministry of Education, Culture, Sports, Science and Technology, US Department of Agriculture, and journal articles that previously reported analytical fatty acid content of some Korean foods. The coverage of fatty acids was C14:0, C16:0, C18:0, C18:1, C18:2 n-6, C18:3 n-3, C20:5 n-3 (EPA), C22:6 n-3 (DHA), SFA, MUFA, and PUFA (n-3, n-6, n-9). The fatty acids DB covered a total of 5,144 food items used in the KNHANES nutrition survey. The food items were preferentially filled with analytical values of the collected data source. An analytical value for each food item was selected based on the priority criteria and the quality evaluation of data sources. Missing values were replaced with calculated or imputed values using the analytical values of similar food items from the data source. Results: A total of 1,545 analytical values, 2,589 calculated values, and 1,010 imputed values were included in the fatty acid DB. The developed fatty acid DB was applied to 2,112 food items available for 2011 KNHANES data. Mean intake levels of total fatty acids and saturated fatty acids were 40.3 g/day and 13.2 g/day, respectively. The estimation of total fatty acid intake was 84.3% (men 83.2%, women 86.0%) of daily total fat intake. Conclusion: This newly developed fatty acid DB would be helpful in determining the association of fatty acids intake and related health concerns in the Korean population.

• Journal of Korean Society for Geospatial Information Science
• /
• v.20 no.2
• /
• pp.31-37
• /
• 2012

Because of road construction and expansion, Update of the road traffic facilities DB is steadily increased each year, and, Increasing drivers and cars, safety signs for traffic safety are required management and additional installation continuously. To update Safety Sign database promptly, we have developed auto recognition function of safety sign, and analyzed coordinates accuracy. The purpose of this study was to propose methods to update about road traffic facilities efficiently. For this purpose, omni-directional camera was calibrated for acquisition of 3-dimensional coordinates, integrated GPS/IMU/DMI system and applied image processing. In this experiment, we proposed a effective method to update database of road traffic facilities for digital map.

• Biomedical Science Letters
• /
• v.28 no.3
• /
• pp.157-169
• /
• 2022

DNA typing is the typical technology in the forensic science and plays a significant role in the personal identification of victims and suspects. Short tandem repeat (STR) is the short tandemly repeated DNA sequence consisting of 2~7 bp DNA units in specific loci. It is disseminated across the human genome and represents polymorphism among individuals. Because polymorphism is a key feature of the application of DNA typing STR analysis, STR analysis becomes the standard technology in forensics. Therefore, the DNA database (DNA-DB) was first introduced with 4 essential STR markers for the application of forensic science; however, the number of STR markers was expanded from 4 to 13 and 13 to 20 later to counteract the continuously increased DNA profile and other needed situations. After applying expanded STR markers to the South Korean DNA-DB system, it positively affected to low copy number analysis that had a high possibility of partial DNA profiles, and especially contributed to the theft cases due to the high portion of touch DNA evidence in the theft case. Furthermore, STR marker expansion not only contributed to the resolution of cold cases but also increased kinship index indicating the potential for improved kinship test accuracy using extended STR markers. Collectively, the expansion of the STR locus was considered to be necessary to keep pace with the continuously increasing DNA profile, and to improve the data integrity of the DNA-DB.

• Digital Contents
• /
• no.5 s.72
• /
• pp.74-76
• /
• 1999

90년대 중반 이후 국내에 본격적으로 등장한 가장 유명한 단어중의 하나가 아마 벤처란 단어일 것이다. 특히 국제 통화기금의 지원을 받게 된 이 후부터는 벤처 산업, 벤처 기업만이 황량한 우리 경제를 살릴 수 있는 유일한 대안이라는 다소 경직된 표현으로 국민적 관심사가 되고 있을 정도이다. 그러나 DB 업계를 포함한 많은 기업들은 벤처 자금의 활용할 방법에 대한 지식이 부족한 상태이다. 이 글에서는 DB업체를 포함한 벤처기업의 벤처 캐피탈 활용방법에 대해 살펴본다.