• Asia pacific journal of information systems
• /
• 제6권1호
• /
• pp.165-194
• /
• 1996

Data distribution is one of the most important steps in distributed database design. This paper proposes a methodology for distributing database by using a relational schema as an input. A design support system called DBDD (Database Distribution Design) is implemented within the framework of this methodology. The methodology consists of three phases such as (i) schema analysis, (ii) fragmentation, and (iii) allocation. In the schema analysis phase, all the table names are acquired from a global relational schema. In the fragmentation phase, fragments are generated according to transaction retrieval patterns. Furthermore, DBDD enhances the design quality by allocating fragments in a progressive manner. A real-life case is illustrated to demonstrate the practical usefulness of the DBDD.

• 국제학술발표논문집
• /
• The 3th International Conference on Construction Engineering and Project Management
• /
• pp.1346-1351
• /
• 2009

In this paper we propose a framework for an Object Relational IFC Server (OR-IFC Server). Enormous amounts of information are generated in each project. Today, many BIM systems are developed by various CAD software vendors. Industry Foundation Classes (IFC) developed by International Alliance for Interoperability (IAI) is an open standard data model for exchanging data between the various BIM tools. The IFC provides a foundation for exchanging and sharing of information directly between software applications and define a shared building project model. The IFC model server is a database management system that can keep track of transactions, modifications, and deletions. It plays a role as an information hub for storing and sharing information between various parties involved in construction projects. Users can communicate with each other via the internet and utilize functions implemented in the model server such as partial data import/export, file merge, version control, etc. IFC model servers using relational database systems have been developed. However, they suffered from slow performance and long transaction time due to a complex mapping process between the IFC structure and a relational-database structure because the IFC model schema is defined in the EXPRESS language which is object-favored language. In order to simplify the mapping process, we developed a set of rules to map the IFC model to an object-relational database (ORDB). Once the database has been configured, only those pieces of information that are required for a specific information-exchange scenario are extracted using the pre-defined information delivery manual (IDM). Therefore, file sizes will be reduced when exchanging data, meaning that files can now be effectively exchanged and shared. In this study, the framework of the IFC server using ORDB and IDM and the method to develop it will be examined.

• 한국지능시스템학회:학술대회논문집
• /
• 한국퍼지및지능시스템학회 2004년도 추계학술대회 학술발표 논문집 제14권 제2호
• /
• pp.568-571
• /
• 2004

In this study, we propose an efficient expert system (ES) construction mechanism by using dynamic knowledge map (DKM) and database management systems (DBMS). Generally, traditional ES and ES developing tools has some limitations such as, 1) a lot of time to extend the knowledge base (KB), 2) too difficult to change the inference path, 3) inflexible use of inference functions and operators. First, to overcome these limitations, we use DKM in extracting the complex relationships and causal rules from human expert and other knowledge resources. Then, elation database (RDB) and its management systems will help to transform the relationships from diagram to relational table. Therefore, our mechanism can help the ES or KBS (Knowledge-Based Systems) developers in several ways efficiently. In the experiment section, we used medical data to show the efficiency of our mechanism. Experimental results with various disease show that the mechanism is superior in terms of extension ability and flexible inference.

• 대한예방한의학회지
• /
• 제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.

• 대한기계학회논문집
• /
• 제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.

• 한국정보통신학회논문지
• /
• 제7권2호
• /
• pp.183-193
• /
• 2003

XML은 e-비지니스와 많은 응용 프로그램 사이에서 정보를 교환하는 인터넷 표준으로 자리잡고 있다. 따라서 이러한 XML 문서를 효율적으로 관리하기 위해 데이터베이스를 사용하여 저장할 필요성이 있다. 본 논문에서는 객체관계형 데이터베이스를 기반으로 XML 문서를 저장하고 검색하는 시스템을 설계하고 구현하였다. XML 문서를 엘리먼트로 분해하고, 각 엘리먼트 타입에 따라 저장하는 방법을 사용하였다. 또한 저장된 XML 문서를 추출할 수 있는 다양한 형태의 검색을 가능하도록 하였다.

• 한국철도학회:학술대회논문집
• /
• 한국철도학회 1998년도 창립기념 춘계학술대회 논문집
• /
• pp.323-329
• /
• 1998

Fatigue strength database system was developed for Windows 95 on personal computer. The relational database management system Visual Foxpro 5.0 was used. The database system developed contains 3,147 S-N curves and 311 $\varepsilon$-N ones for 437 material symbols and has the ability to search data by material symbol that each specification marks differently. Visual Basic 5.0 was used for graphic presentation and statistical treatment of the data searched.

• 지능정보연구
• /
• 제9권2호
• /
• pp.19-38
• /
• 2003

In this research, we propose the mechanism to develop self-evolving expert systems (SEES) based on data mining (DM), fuzzy neural networks (FNN), and relational database (RDB)-driven forward/backward inference engine. Most researchers had tried to develop a text-oriented knowledge base (KB) and inference engine (IE). However, this approach had some limitations such as 1) automatic rule extraction, 2) manipulation of ambiguousness in knowledge, 3) expandability of knowledge base, and 4) speed of inference. To overcome these limitations, knowledge engineers had tried to develop an automatic knowledge extraction mechanism. As a result, the adaptability of the expert systems was improved. Nonetheless, they didn't suggest a hybrid and generalized solution to develop self-evolving expert systems. To this purpose, we propose an automatic knowledge acquisition and composite inference mechanism based on DM, FNN, and RDB-driven inference engine. Our proposed mechanism has five advantages. First, it can extract and reduce the specific domain knowledge from incomplete database by using data mining technology. Second, our proposed mechanism can manipulate the ambiguousness in knowledge by using fuzzy membership functions. Third, it can construct the relational knowledge base and expand the knowledge base unlimitedly with RDBMS (relational database management systems) module. Fourth, our proposed hybrid data mining mechanism can reflect both association rule-based logical inference and complicate fuzzy relationships. Fifth, RDB-driven forward and backward inference time is shorter than the traditional text-oriented inference time.

• 한국경영과학회:학술대회논문집
• /
• 대한산업공학회/한국경영과학회 1994년도 춘계공동학술대회논문집; 창원대학교; 08월 09일 Apr. 1994
• /
• pp.519-526
• /
• 1994

In the large and multifunctional engineering system, the heterogeneous computer system situation is inevitable. Accordingly a lot of integration efforts are being made to comply with the industrial requirement of productivity. In this paper, a practical concept of integration is introduced through the development of a prototype system for ship outfitting design which is a typical example of large/multi-functional application system. On the development of the prototype system, three points are considered as a practical concept-which are integration of database, integration of application programs, and system-user interface. The relation model based commercial database management system(RDBMS) is used to build the project integrated database, and the graphical user interface tool(OSF/Motif) on X-window system is used for the integration of application programs and the user interface.