RISS 학술연구정보서비스

검색
다국어 입력

http://chineseinput.net/에서 pinyin(병음)방식으로 중국어를 변환할 수 있습니다.

변환된 중국어를 복사하여 사용하시면 됩니다.

예시)
  • 中文 을 입력하시려면 zhongwen을 입력하시고 space를누르시면됩니다.
  • 北京 을 입력하시려면 beijing을 입력하시고 space를 누르시면 됩니다.
닫기
    인기검색어 순위 펼치기

    RISS 인기검색어

      검색결과 좁혀 보기

      선택해제

      오늘 본 자료

      • 오늘 본 자료가 없습니다.
      더보기
      • 무료
      • 기관 내 무료
      • 유료
      • Maximal object+: An acyclic semantic structure on the universal relation model

        Kim, I.J.,Whang, K.Y.,Kwon, H.Y. North-Holland, Elsevier Science Publishers 2017 Data & knowledge engineering Vol.111 No.-

        The universal relation model allows us to find the results on a virtual relation that joins all the relations in a relational database if the user specifies only selection and projection conditions. It automatically finds actual relations in which the selection and projection conditions are performed and possible join paths among the relations using the database schema. When there are cycles in the database schema graph, however, the universal relation model may lose some results since it adds an unintentional condition to the interpretation of a query. Here, the unintentional condition is an equality condition that intersects multiple query interpretations by different join paths, and thus, it returns only part of the results that the user intends. This paper proposes a new semantic structure, maximal object+, that completely removes cycles in a universal relation. A maximal object+ is a largest acyclic connected component in the database schema graph where the entire set of relations in the component has the lossless join property. Here, the important point is that a maximal object+ allows only the lossless join property indicated by functional dependencies excluding the lossless join property indicated by only multivalued dependencies. To show the advantage of a maximal object+, we compare the effectiveness of the query processing method based on maximal object+ with that of the existing query processing method based on the maximal object by performing experiments on the synthetic and real datasets. As a result, we show that our method significantly outperforms the one based on the maximal object in terms of mean recall when a cycle exists in a maximal object while maintaining comparable efficiency. Specifically, our method improves the mean recall by up to 8.15 times for the dataset whose schema involves cycles.

      • KCI등재후보

        쇼핑몰 데이터베이스 설계를 위한 의미객체 모델링

        전태보,김기동,오준형 江原大學校 産業技術硏究所 2005 産業技術硏究 Vol.25 No.A

        Semantic object model has widely been recognized as an alternative data modeling approach to entity-relationship model for database system design. In this study, we have presented a semantic object model for intermediary type shopping mall consisting of multiple buyers and sellers. Essential processes and information with regard to the customer management, product management, price estimation, product order etc. have been considered for this study. Upon careful examination and analysis of them, a detailed semantic objects and attributes have been drawn and structured into semantic object diagrams. The final objects were converted into an entity-relationship diagram so that intuitive comparison could be made for relational database design. The results in this study may form a conceptual framework for both academic concerns and more complicated system applications.

      연관 검색어 추천

      이 검색어로 많이 본 자료

      활용도 높은 자료

      해외이동버튼