• 한국정보처리학회:학술대회논문집
• /
• 한국정보처리학회 2018년도 춘계학술발표대회
• /
• pp.183-186
• /
• 2018

In this paper, we propose the database design for skill learning service through the internet from the viewpoint of service engineering. This paper we describe the outlines for a design theory for skill learning service, which can lead to the satisfaction of both learner and instructor. Compared to other services, motion control learning takes a considerable amount of time, and this leads to a difficulty for learners to rate the quality of the service as well as for the instructors to provide consistent quality and standard of teaching. To solve these problems, we use a relational database with MongoDB which is an unstructured database allowing to flexibly incorporate the demands of both learner and instructor into the database itself.

• 대한산업공학회지
• /
• 제41권2호
• /
• pp.162-172
• /
• 2015

This paper proposes a Product Data Management (PDM) system architecture that supports end-user computing for small and medium businesses (SMBs) in Korea to build and maintain efficient and sustainable information systems for their product development. Its open database with relational tables enables existing common application programs such as Microsoft office suites to access product data in PDM systems. In addition, the interactive query processor provided by database management systems helps design engineers to build ad hoc queries in standard SQL database language to response different data requirements during their product development. The PDM architecture with the open database allows design engineers or technical staffs in SMBs to build and maintain their application programs for product development by themselves. To show the feasibility of the proposed architecture, this study implemented a prototype PDM system based on the architecture and database, and represents real-world product data with the implemented PDM system.

• 한국컴퓨터정보학회논문지
• /
• 제22권11호
• /
• pp.57-63
• /
• 2017

The recent sudden increase of big data has characteristics such as continuous generation of data, large amount, and unstructured format. The existing relational database technologies are inadequate to handle such big data due to the limited processing speed and the significant storage expansion cost. Thus, big data processing technologies, which are normally based on distributed file systems, distributed database management, and parallel processing technologies, have arisen as a core technology to implement big data repositories. In this paper, we propose a design methodology for large-scale database based on MongoDB by extending the information engineering methodology based on E-R data model.

• 한국보건간호학회지
• /
• 제18권1호
• /
• pp.154-166
• /
• 2004

The purpose of this study was to design and implementation of database for school health activity. This database system was designed stand-alone application for college school health center without a hospital affiliation and the database system was made of relational database management system, Microsoft access 2000 to be made GUI (Graphic user interface) type design and made up 7 tables: patients. symptoms. departments, income and outgo. medical cures. and medicine. The construction of this database system was patient management. code management. medicine management. and statistics management. The results of the database system were as follows; 1) This database system could be used for college school health center. 2) This database system could be made correct statistic data. 3) This database system could be managed income and outgo. 4) This database system could be changed for the better activity of community health service. 5) This database system could be simply attired administrative system. This database system will be used for students and employees to protect and promote health to measure for health level and quality of health service. In conclusion. this database system can be applied for unit health center to manage the college school health activity and advanced data management can be applied for health profession to do quality improvement. cost containment. management information system. and decision support system.

• Nuclear Engineering and Technology
• /
• 제34권6호
• /
• pp.610-618
• /
• 2002

A study of the conceptual data modeling to realize the decommissioning database on the HRR-1&2 was carried out. In this study, the current state of the abroad decommissioning database was investigated to make a reference of the database. A scope of the construction of decommissioning database has been set up based on user requirements. Then, a theory of the database construction was established and a scheme on the decommissioning information was classified . The facility information, work information, radioactive waste information, and radiological information dealing with the decommissioning database were extracted through interviews with an expert group and also decided upon the system configuration of the decommissioning database. A code which is composed of 17 bit was produced considering the construction, scheme and information. The results of the conceptual data modeling and the classification scheme will be used as basic data to create a prototype design of the decommissioning database.

• 정보처리학회논문지D
• /
• 제9D권6호
• /
• pp.1105-1112
• /
• 2002

B2B 전자상거래와 같이 XML을 이용한 정보 교환이 확산되고 있으며 이에 따라 상호 교환되는 정보에 대하여 체계적이며 안정적인 저장관리가 요구되고 있다. 이를 위해 XML 응용과 데이터베이스 연계를 위한 다양한 연구가 관계형 데이터베이스를 중심으로 수행되었다. 그러나 계층구조를 갖는 XML 데이터를 2차원 테이블의 집합인 관계형 정보로 표현하는 관계형 데이터베이스로의 저장에는 본질적인 한계가 있어, 계층적 구조를 2차원 정보로 변환하는 방법에 의해서 각 구조화된 정보를 관계형 데이터베이스로 저장하기 위한 모델링 방안이 요구된다. 양질의 어플리케이션 시스템을 구축하기 위해서는 우선적으로 모델링이 중요하다. 1997년에 OMG는 표준 모델링 언어로 UML를 채택하였고, 이에 따라 UML은 보다 널리 사용될 것이다. 그러므로 효율적인 XML 어플리케이션을 개발하는데 UML에 기반을 둔 설계 방법론이 필요하다고 할 수 있다. 본 논문에서는 UML을 이용한, 관계형 데이터베이스기반의 XML 응용을 위한 통합 설계 방법론을 제안한다. 이를 위하여 먼저 UML을 이용하여 W3C XML schema를 설계하기 위한 XML 모델링 방안을 제시하고, 아울러 교환되는 XML 데이터를 효율적으로 저장하기 위하여 관계형 데이터베이스 스키마 설계를 위한 데이터 모델링 방법을 제안한다.

• 한국컴퓨터정보학회논문지
• /
• 제6권1호
• /
• pp.38-44
• /
• 2001

최근 인터넷의 발전으로 인하여 정보교환을 위한 표준으로 XML에 대한 연구가 활발히 진행되고 있다. 본 논문에서는 객체관계 데이터베이스인 uniSQL/X를 이용한 XML 문서 저장 시스템 설계하고 구현하였다. 관계 데이터베이스와 객체지향 데이터베이스의 장점을 수용한 객체관계 데이터베이스(Object-Relational Database : ORDB)를 이용하여 XML 문서 저장 모델을 설계하여 XML 문서의 구조적인 정보를 효과적으로 표현할 수 있다. XML 문서의 빈번한 수정이 용이하도록 분할저장 방식을 사용하였고, DTD에 관계없이 XML 문서를 저장할 수 있도록 DTD 독립적인 모델을 제안하였다. 또한 데이터의 중복문제를 해결함으로써 검색 속도가 향상되었다

• 대한기계학회:학술대회논문집
• /
• 대한기계학회 2004년도 추계학술대회
• /
• pp.154-159
• /
• 2004

In this study, in order to perform more efficiently reliability design and integrity assessment of structural members, the relational database management program on the engineering plastics was constructed. This program contained 476 grades for 14 kinds of the engineering plastics and was developed using MS-access and MS-visualbasic. This program consists of 3 modules; search condition, probabilistic characteristics of material property, evaluation of P-S-N curve. We perform fatigue test for probabilistic durability analysis and this results input the database program to estimate P-S-N.

• 대한예방한의학회지
• /
• 제13권2호
• /
• pp.115-128
• /
• 2009

Background : Currently, ontology research has led the trend of technical development in medical informatics area. For Korean medicine, the reference terminology should be developed to facilitate the ontology research. Objective : This research aimed to design the management system for traditional Korean medical terms. Method :We built the internet-based system in which multi-users work simultaneously by using the relational database system(SQL Server2005) and visual studio 2005. Result : By this system, researchers can collect, refine, and inspect Korean medicine terms efficiently, and the terms can be transcribed into synonym, Korean, Chinese, and simplified Chinese. It enables the terms be input into the system accurately and managed by its classification. Conclusion : We developed the concept groups and its hierarchy system for Korean medicine terms which provides the basis for ontology system.

• 한국컴퓨터정보학회:학술대회논문집
• /
• 한국컴퓨터정보학회 2013년도 제47차 동계학술대회논문집 21권1호
• /
• pp.243-247
• /
• 2013

응용시스템 개발 과정에 있어서 중요하고 핵심을 이루는 작업은 분석과 설계 작업이며 아울러 대부분의 응용시스템은 데이터베이스 기반으로 구축된다. 또한, 응용시스템들은 외부 공격에 쉽게 노출되기 때문에 보안과 관련된 처리 과정 역시 중요하다. 하지만 이러한 보안은 대부분 개발 마지막 과정에서 고려하기 때문에 보안에 취약한 응용시스템들이 개발될 가능성이 매우 높다. 따라서 개발 초기에 보안을 반영한 분석 및 설계 과정이 매우 중요하다. Java EE는 웹 응용시스템을 위한 보안 방안을 제공하고 아울러 관계형 데이터베이스도 보안을 위하여 역할기반 접근제어를 지원하고 있지만 관계형 데이터베이스 및 Java EE의 역할기반 접근제어를 활용하는, 요구사항 수집부터 구현까지 개발 단계 전체에 걸친 일관된 개발방법론은 전무한 실정이다. 따라서 본 논문에서는 보안 요구사항을 요구사항 수집부터 분석 및 설계 그리고 마지막 구현 단계까지 반영하여 Java EE 기반의 웹 응용시스템을 개발하기 위한, 보안을 고려한 일관된 통합 분석.설계 방법론을 제안한다.