• Title/Summary/Keyword: relational model

Search Result 564, Processing Time 0.026 seconds

A Unified Design Methodology Development For XML Application based on Relational Database using UML Class (UML 클래스를 이용한, 관계형 데이터베이스 기반의 XML 응용을 위한 통합 설계 방법론 개발)

  • 방승윤;주경수
    • The Journal of Society for e-Business Studies
    • /
    • v.8 no.1
    • /
    • pp.85-102
    • /
    • 2003
  • 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 make the conversion rule which changes the hierarchical architecture to 2-dimensional information. Accordingly the modeling methodology for storing each structured information in relational database is needed. In this paper, we introduce a XML modeling methodology to design W3C XML schema using UML and we propose a unified design methodology for relational database schema to store XML data efficiently in relational databases. In the second place, in order to verify objectivity of a unified design methodology. By the way of Ronald Bourret, First we introduce the method of the transformation from XML schema to object model and second we translate object model into relational database schema. Therefore we show the mutual consistency between those consequence, and so can verify a unified design methodology.

  • PDF

Movie Recommendation Using Co-Clustering by Infinite Relational Models (Infinite Relational Model 기반 Co-Clustering을 이용한 영화 추천)

  • Kim, Byoung-Hee;Zhang, Byoung-Tak
    • Journal of the Korean Institute of Intelligent Systems
    • /
    • v.24 no.4
    • /
    • pp.443-449
    • /
    • 2014
  • Preferences of users on movies are observables of various factors that are related with user attributes and movie features. For movie recommendation, analysis methods for relation among users, movies, and preference patterns are mandatory. As a relational analysis tool, we focus on the Infinite Relational Model (IRM) which was introduced as a tool for multiple concept search. We show that IRM-based co-clustering on preference patterns and movie descriptors can be used as the first tool for movie recommender methods, especially content-based filtering approaches. By introducing a set of well-defined tag sets for movies and doing three-way co-clustering on a movie-rating matrix and a movie-tag matrix, we discovered various explainable relations among users and movies. We suggest various usages of IRM-based co-clustering, espcially, for incremental and dynamic recommender systems.

Relational 데이타 모형을 구현하는 씨스템 설계

  • 趙廷完;嚴基賢 = Um Ki Hyun
    • Communications of the Korean Institute of Information Scientists and Engineers
    • /
    • v.4 no.2
    • /
    • pp.34-44
    • /
    • 1986
  • A data base system for a minicomputer, designed on the basis of the concept of Relational model, is proposed in this thesis. It is a module of reentrant programs, which can serve multi-users concurrently and interactivelv. Relational calculus is chosen as a data sublanguage. The inverted-list file structure is used for the physical storage structuse with the technique of seperating data and their relationships, while data model records, which contain the information of the logical data organization and linkage to a physical structure, con struct the data model. The retrieval is performed mainly with these.

Prediction System on Chance of Rain by Fuzzy Relational Model

  • Sano, Manabu;Tanaka, Kazuo;Yoshioka, Keisuke
    • Proceedings of the Korean Institute of Intelligent Systems Conference
    • /
    • 1993.06a
    • /
    • pp.1222-1225
    • /
    • 1993
  • The purpose of this paper is to construct a prediction system on the chance of rain in a local region using a fuzzy relational model. The prediction system consists of two parts. One is a prediction part on the chance of rain. The compositional law of fuzzy inference, proposed by Zadeh, is applied to predict the chance of rain. The other is a learning part of a fuzzy relational model using input-output data. A simple and fast learning algorithm is used in this part. Simulations are carried out by the actual weather data in our city and their results show the validity of prediction by the fuzzy relational approach.

  • PDF

A Logical Design Methodology for Relational Databases Using the MAO (Multiple Aspects-based Object) Model (MAO 모델을 사용한 관계 데이타베이스의 논리적 설계방법론)

  • Cho, Dong-Young;Baik, Doo-Kwon;Hwang, Chong-Sun
    • Journal of the Korean Operations Research and Management Science Society
    • /
    • v.16 no.2
    • /
    • pp.49-64
    • /
    • 1991
  • In this paper, we present a stepwise design methodology for relational databases using a new conceptual data model, the MAO(Multiple Aspects-based Object) model. Our methodology consists two steps : first, data requirements are conceptualized using the MAO model with concepts such as objects types and aspect types : second, the MAO model is transformed into the third normal form inn the relational model supported by commercial DBMs. A top-down approach is used for the MAO modelling in the first, step, and the transformation process in the second step can be automated. Our methodology supports easier and more database design of real world than other methodologies using existing data models.

  • PDF

On supporting full-text retrievals in XML query

  • Hong, Dong-Kweon
    • International Journal of Fuzzy Logic and Intelligent Systems
    • /
    • v.7 no.4
    • /
    • pp.274-278
    • /
    • 2007
  • As XML becomes the standard of digital data exchange format we need to manage a lot of XML data effectively. Unlike tables in relational model XML documents are not structural. That makes it difficult to store XML documents as tables in relational model. To solve these problems there have been significant researches in relational database systems. There are two kinds of approaches: 1) One way is to decompose XML documents so that elements of XML match fields of relational tables. 2) The other one stores a whole XML document as a field of relational table. In this paper we adopted the second approach to store XML documents because sometimes it is not easy for us to decompose XML documents and in some cases their element order in documents are very meaningful. We suggest an efficient table schema to store only inverted index as tables to retrieve required data from XML data fields of relational tables and shows SQL translations that correspond to XML full-text retrievals. The functionalities of XML retrieval are based on the W3C XQuery which includes full-text retrievals. In this paper we show the superiority of our method by comparing the performances in terms of a response time and a space to store inverted index. Experiments show our approach uses less space and shows faster response times.

Development of an Object-Relational IFC Server

  • Hoon-sig Kang;Ghang Lee
    • International conference on construction engineering and project management
    • /
    • 2009.05a
    • /
    • 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.

  • PDF

Design and Implemetation of an Object-Relational Geographic Information System based on a commercial ORDB (상용 ORDB를 하부구조로 갖는 객체관계형 지리정보 시스템의 설계 및 구현)

  • 윤지희
    • Spatial Information Research
    • /
    • v.5 no.1
    • /
    • pp.77-88
    • /
    • 1997
  • This paper presents the design and implementaion of an object-relational geographic information system. This system has been developed on top of a commercial object-relational database management system. It provides flexible spatial data model, spatial query language, visual user interface, and efficient spatial access methods(D0T) in which traditional primary-key access methods can be applied. We report on our design choices and describe the current status of Implementation. The conceptual model of the system is based on SDTS, and is mapped to the intemal obiect-oriented data model. Kevwords : object-oriented data model, GIS, spatial data model, spatial access method.

  • PDF

The Structural Effects of Relational Benefits on Brand Loyalty in Financial Institute (금융기관에서 관계편익이 브랜드충성도에 미치는 구조적 영향)

  • Jang, Jungbin;Kim, Shin;Choi, Jeongil
    • Journal of Korean Society for Quality Management
    • /
    • v.45 no.1
    • /
    • pp.39-54
    • /
    • 2017
  • Purpose: This study evaluated the effect of customer relationship management (CRM) on customer's brand loyalty in the holistic perspective of relational benefits, relationship quality and relation value. This paper attempted to find out the psychological process that links the relational benefits and brand loyalty. Methods: The data was collected by using the structured questionnaires to VIP customers and general customers of major domestic banks. The proposed research model is empirically tested using 324 valid questionnaires using SPSS 23 and AMOS 23. Results: This research indicated the partially positive relationship between the relational benefits and relation values, and between relational benefits and relationship quality. The relation value and relationship quality positively affects the relation commitment and the relation commitment also positively affects brand loyalty. This study also shows that the relation value affects the brand loyalty through the mediation of relation commitment, but also the relationship quality affects the brand loyalty through the media of relation commitment. Conclusions: This study investigates the role of perceptional factors(relational value and relationship quality) and affective factors(relation commitment) to find the relationship between relational benefits and brand loyalty. It also suggest the relative influence of relational benefits on relation value.

Constructions of Relational Database Model Using Rough Sets and Its Analysis (러프 집합을 이용한 관계데이터베이스 모델의 구성 및 해석)

  • 정구범;정환묵
    • Proceedings of the Korean Institute of Intelligent Systems Conference
    • /
    • 1996.10a
    • /
    • pp.337-339
    • /
    • 1996
  • In this paper, we construct rough relational database model using approximation concepts of rough set. Also, we analyze the relation between objects, attributes and attribute values and, propose the method that can generate flexible retrieval results.

  • PDF