• Journal of Korea Multimedia Society
• /
• v.1 no.2
• /
• pp.142-153
• /
• 1998

In this paper, Java Method approach for the integration of Web and Object-Relational DBMS is proposed. For the purpose, we extend to use Java language in programming user-defined function which is one of important characteristic of Object-Relational DBMS with object concept. Therefore we can retrieve not only database objects but also their associated Java methods to run in clients. Finally, to demonstrate the feasibility of the proposed Java Method technique, we designed and implemented this Java method system based on three-tier client/server architecture using JDBC(Java Database Connectivity) and Java RMI(Remote Method Invocation).

• Journal of the Korea Society for Simulation
• /
• v.17 no.3
• /
• pp.53-62
• /
• 2008

This paper proposes a new implementational model based on the security model of Oracle for Web ontology. Recently, several access control models using relational database security model for access control to Web ontology have been developing, and one of the most representative access control model is the RAC model. However, the RAC model is based on the standard security model, and thus it does not provide a implementational model for practical relational database management systems. In this paper, we propose an implementational model based on Oracle which is widely used and providing various security policies. This paper shows the implementation and experimental evaluation. Especially, the proposed model uses the VPD security model of Oracle and support high application and usability.

• Journal of Ocean Engineering and Technology
• /
• v.11 no.3
• /
• pp.200-211
• /
• 1997

Most recently, offshore Engineering & Construction field is concerned about integration management technology such as CIM(Computer Integrated Manufacturing), PDM(Product Data Management) and Enterprise Information Engineering in order to cope with the rapid change of engineering and manufacturer specification as per owner's requirement during construction stage of the project. System integration and integrated data modeling with relational database in integration management technology improve the quality of product and reduce the period of the construction project by reason of owing design information jointly. This paper represents the design methodology of system integration using Business Process Reengineering by the case study. The case study is about the offshore plant material information process from front end engineering design to detail engineering for the construction and the basis of monitoring system by integrating and sharing the design information between the 2D intelligent P&ID and 3D plant modeling using relational database. As a result of the integrated data modeling and system integration, it is possible to maintain the consistency of design process in point of view of the material balancing and reduce the design assumption/duration. Near future, this system will be expanded and connected with the MRP(Material Requirement Planing) and the POR (Purchase Order Requisition) system.

• Progress in Medical Physics
• /
• v.31 no.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.

• The Transactions of the Korea Information Processing Society
• /
• v.3 no.1
• /
• pp.87-94
• /
• 1996

In order to design an extended relational database management system supporting multilevel security, the standard relational data model is extended and new relational integrity constrains are proposed for the model. The extended relational model and proposed multilevel integrity constraniants maintain database in consistent state and produce a basis that can eliminat eambiguity of entity and relation ship representations bypoly instantiation. The proposed up dates emantics canincreases the efficiency of up date operations by supporting multilevel entry and up dates. The semantics also provides a basis for the implementation of decomposition of extended relations.

• Proceedings of the Korea Association of Information Systems Conference
• /
• 2001.12a
• /
• pp.64-82
• /
• 2001

HTML revolutionized the way we specify the appearance of data on the Internet. Today, XML (the eXtensible Markup Language) is changing the way we specify the meaning of data. XML, lets document authors define their own markup tags and attribute names to assign meaning to the data elements in the document. Further, XML elements can be nested and include references to indicate data relationships, as Listing One. Unlike HTML, XML markup tags do not describe how to render the data. Rather, they provide descriptions of data, allowing software to understand the meaning of the data automatically For publishing, instead, XSL, the eXtensible Stylesheet Language as a separate language , is in charge of specifying the presentation of XML documents. The purpose of this study is to discover how to transform your organizations relational data into potential e-commerce, business-to-business, and web application with XML and XSL documents. For this purpose, the literature survey, first of all, was undertaken to understand the basic structures of XML documents. Second, one case implementation was performed to understand how to transform Access 2002 XML Files into HTML with XSLTand VB script. The results come out to be successful, more or less. But the limitations of it still exist. One immediate limitation is that XML documents are essentially tree structure, as dictated by the nesting of elements. However, relational database tables are two dimensional matrix structure. In addition, real-world data often is graph structured-a single data element may be referenced in multiple ways. However, this study is useful for understanding how to convert relational database into XML documents and to publish them using XSL or VB script.

• The Journal of Korean Institute of Communications and Information Sciences
• /
• v.30 no.1C
• /
• pp.9-17
• /
• 2005

XML is rapidly spreading as a standard for data representation and exchange, and XML documents are adopted in various applications. According to this trend, researches in database has also focused on efficient storage and retrieval of XML documents. Recently, major (object) relational DBMS vendors support XML functionality, and several native XML DBMSs have been developed in academic or industry side. In addition, various benchmarks have been proposed so as to evaluate these na database performance. In this paper, we evaluate the XBench benchmark using a commercial object-relational DBMS, analyze its performance, and investigate the future improvements of object-relational DBMSs for XML support.

• Journal of the Korean Society for information Management
• /
• v.19 no.2
• /
• pp.49-67
• /
• 2002

Nowadays an information exchange on XML such as B2B electronic commerce is spreading. Therefore the systematic and stable management mechanism for storing the exchanged information is needed. For this goal there are many research activities for connection between XML application and database. Accordingly, A unified modeling methodology need to store the XML file on the variety database. In this paper, we propose a unified design methodology for XML applications based on variety databases using UML. To this goal, first we introduce a XML modeling methodology to design W3C XML schema using UML and second we propose data modeling methodology for object-relational database schema, object oriented database an schema and relational database schema to store efficiently XML data in databases.

• Journal of Information Technology Applications and Management
• /
• v.9 no.1
• /
• pp.85-96
• /
• 2002

Nowadays an information exchange on XML such as B2B electronic commerce is spreading. Therefore the systematic and stable management mechanism for storing the exchanged Information is needed. For this goal there are many research activities for connection between XML application and relational database. But because XML data have hierarchical structures and relational database can store only flat-structured data, we need to store XML data in object-oriented database that support hierarchical structure. Accordingly the modeling methodology for storing XML data in object-oriented database is needed. In order to build good quality application systems, modeling is an important first step. In 1997, the OMG adopted the UML as its standard modeling language. Since industry has warmly embraced UML, its popularity should become more important in the future. So a design methodology based on UML is need to develop efficiently XML applications. In this paper, we propose a unified design methodology for XML applications based on object- oriented database using UML. To this goal, first we introduce a XML modeling methodology to design W3C XML schema using UML and second we propose data modeling methodology for object-oriented database schema to store efficiently XML data in object-oriented databases.

• Journal of the Korea Institute of Information and Communication Engineering
• /
• v.6 no.5
• /
• pp.653-660
• /
• 2002

This paper proposes a method for storing graphs and defining graph algorithms based on the well-developed relational database. In this method, graphs are represented in the form of relations. Each vertex and edge of a graph is represented as tuples of the table and saved in a database. We developed a library of graph operations for the storage and management of graphs and the development of graph applications. Furthermore, we defined graph algorithms in terms of relational algebraic operations such as projection, selection, and join. They can be implemented with the database language such as SQL. This database approach provides an efficient methodology to deal with very large-scale graphs and to support the development of graph applications.