• 한국의학물리학회지:의학물리
• /
• 제31권4호
• /
• pp.172-178
• /
• 2020

Purpose: Radiation oncology information systems (ROIS) have evolved toward connecting and integrating information between radiation treatment procedures. ROIS can play an important role in utilizing modern radiotherapy techniques that have high complexity and require a large amount of information. Methods: Using Access^TM software, we have developed a relational database that is highly optimized for a radiotherapeutic workflow. Results: The prescription table was chosen as the core table to which the other tables were connected, and three types of forms-charts, worklists, and calendars- were suggested. A fast and reliable channel for delivering orders and remarks according to changes in the situation was also designed. Conclusions: We expect our ROIS design to inspire those who need to develop and manage an individual ROIS suitable for their radiation oncology departments at a low cost.

• 산업공학
• /
• 제7권3호
• /
• pp.227-237
• /
• 1994

In this study, graphic environment for system monitoring is designed that can efficiently manage monitoring data. And also system informations are inplemented to database for reliability and a utility management software is developed to monitor systems on graphic environment and RDBMS (Relational DataBase Management System). Specially, system status informations are presented in the forms of animation, graph, value, icon, and voice message. Status data and general basic informations of system can be all the times updated and indexly reported on database.

• 대한기계학회논문집
• /
• 제18권9호
• /
• pp.2297-2311
• /
• 1994

This paper presents the study on the development of a DNC, system IPIS(Interactive Plant Information System)/DNC, which can manage NC machines and robots as a distributed control method in the machine. processing factory. The IPIS/DNC system is composed of a host computer, satellites and NC machines. A set of software modules are developed on the host computer and the satellites separately. By modularizing each functions of the IPIS/DNC system and using multi-taking method, the functions such as NC program management, NC program distribution, and shop monitoring can be performed on the host computer, and the functions such as NC program transfer to the NC machines, and NC program editing can be performed on the satellites. A Relational database which is linked with job scheduling system is used for IPIS/DNC system.

• 한국전산구조공학회:학술대회논문집
• /
• 한국전산구조공학회 2008년도 정기 학술대회
• /
• pp.458-463
• /
• 2008

An IFC Server is a database management system that stores data complying with a standard data format, called IFC, and keeps track of data transactions, modifications, and deletions. It plays a role as an information hub for storing and sharing information between various parties involved in construction projects. There have been several efforts to develop an IFC Server, however, they suffered from slow performance and long transaction time due to a complex mapping process between IFC files and relational database structures. In this study, we aim to develop an IFC Server using an object-relational database system. Since IFC has an object-flavored data structure, we expect to have a simpler and faster mapping process from IFC to the IFC Server. This paper reviews existing studies and describes the overall framework of the OR-IFC Server.

• 한국인터넷방송통신학회논문지
• /
• 제10권3호
• /
• pp.27-33
• /
• 2010

통합 정보시스템의 도입과 구축에 있어 가장 중요한 성공요소중의 하나가 성능 최적화이다. 본 연구에서는 정보시스템의 성능향상을 위해 비용도 저렴하고 단시간에 효과를 나타낼 수 있는 관계형 데이터베이스의 SQL 튜닝 기법을 제안하고, 이를 중소규모의 회사에 실제 운용되고 있는 데이터베이스 시스템에 적용하여 그 효율성을 분석하였다.

• 산업공학
• /
• 제17권2호
• /
• pp.226-232
• /
• 2004

In shipbuilding area, data sharing is one of the crucial issues. Recently, for collaborative design, ship structural CAD systems adopt the database as its primary storage. Database is useful to deal with the large amount of design information among the heterogeneous design department and design stage. To make the database-based CAD system object-oriented database(OODB) and object-relational database(ORDB) can be used. It is important to select proper database because the CAD system performance mainly depends on access performance of database. In this research, using prototype CAD system from other research, access performance of OODB and ORDB form CAD system was evaluated. STEP application protocol was used as the database schema and experiment was made in query by property and query by region. The results give some idea of how to choose the database for CAD systems.

• Journal of information and communication convergence engineering
• /
• 제8권1호
• /
• pp.89-94
• /
• 2010

The most important of rule-base system is the knowledge base that determines the power of rule-base system. The important form of this knowledge is how to descript kinds of rules. The Rule-Base System (RBS) has been using in many field that need reflect quickly change of business rules in management system. As far, when develop the Rule-Based System, we must make a rule engine with a general language. There are three disadvantage of in this developed method. First, while there are many data that must be processed in the system, the speed of processing data will become very slow so that we cannot accept it. Second, we cannot change the current system to make it adaptive to changes of business rules as quickly as possible. Third, large data make the rule engine become very complex. Therefore, in this paper, we propose the two important methods of raising efficiency of Rule-Base System. The first method refers to using the Relational database technology to process the rules of the Rule-Base System, the second method refers to a algorithm of according to Quine McCluskey formula compress the rows of rule table. Because the expressive languages of rule are still remaining many problems, we will introduce a new expressive language, which is Rule-Base Data Model short as RBDM in this paper.

• 대한약학회:학술대회논문집
• /
• 대한약학회 2003년도 Proceedings of the Convention of the Pharmaceutical Society of Korea Vol.2-2
• /
• pp.221.2-221.2
• /
• 2003

Several Compendia are effective in relation with production and supply of pharmaceutical agents in Korea. Those compendia exists only in printed documents, which are not suitable for the analysis of their contents and inter-relationship among them when they have specifications on the same or related pharmaceutical agents. For the analysis of contents of Korean compendia, database system is desinged and all of the available data are entered into relational database system. Every specification was analyzed into several database tables, fields and relations between tables. (omitted)

• 한국정보통신학회:학술대회논문집
• /
• 한국해양정보통신학회 2003년도 추계종합학술대회
• /
• pp.615-618
• /
• 2003

관계형 데이터베이스의 설계 과정은 요구사항 분석, ER 모델을 이용한 개념적 설계, 논리적 설계, 그리고 물리적 설계 과정으로 구성된다. 논리적 설계과정은 ER 다이어그램으로 구성된 개념적 스키마를 관계형 스키마로 전환하여 정규화시키는 과정으로 이루어진다. 이런 기존의 설계 과정에서 요구사항의 분석후 개념적 스키마를 도출하는 개념적 설계 과정이 명확치 않음으로 인해서, 실제 데이터베이스 설계현장에서 적용하기 어려운 점이 있다. 본 논문에서는 작업과정이 모호한 개념적 설계를 제거함으로 보다 체계적으로 데이터베이스 스키마를 설계할 수 있는 방법을 제안한다. 구조적 설계 방법을 이용하여 자료흐름도를 작성하고, 자료흐름도의 자료저장소에 파악된 애트리뷰트를 이용하여 관계합성으로 관계형 스키마를 도출한다. 관계형 스키마를 정규화하고, 정규화된 테이블로부터 데이터의 의미를 파악하여 테이블 관계도를 작성함으로써 최종 논리적 스키마를 결정한다.

• 한국컴퓨터정보학회논문지
• /
• 제7권4호
• /
• pp.157-162
• /
• 2002

본 연구는 UML을 이용해 유스케이스에 의한 순차 다이어그램을 도출하여 클래스 다이어그램을 만든후 그 클래스 다이어그램에 의해서 XML 모델링과 데이터 모델링을 구현하고자 한다. XML 모델링을 위해 UML 클래스를 XML 문서로 변환시키는 가이드라인을 제시하고, 제시한 방법에 파라 UML 클래스를 XML DTD로 도출하는 예를 보일 것이며, 한편 데이터 모델링은 UML클래스를 관계형 데이터베이스 스키마와 객체-관계 데이터베이스 스키마 그리고 객체지향 데이터베이스 스키마로 변환시키기 위한 통합 설계 변환 방법을 제시하며, 제시한 변환 방법에 따라 각각의 데이터베이스 스키마를 구현했다.