Browse > Article

Object Views in the ODYSSEUS Object-Relational DBMS  

이재길 (한국과학기술원 전자전산학과/첨단정보기술연구센터)
한욱신 (경북대학교 컴퓨터공학과)
이민재 (한국과학기술원 전자전산학과/첨단정보기술연구센터)
이종학 (대구가톨릭대학교 컴퓨터정보통신공학부)
황규영 (한국과학기술원 전자전산학과, 첨단정보기술연구센터)
Publication Information
Journal of KIISE:Computing Practices and Letters / v.10, no.1, 2004 , pp. 14-24 More about this Journal
Abstract
Views are essential in providing logical data independence for database systems. Object views in object-oriented/object-relational databases have requirements quite different from those of relational databases due to support for object-oriented concepts. Although many commercial object-oriented/object-relational database systems support object views, implementation techniques have not been discussed sufficiently in the literature. In this paper, we devise a technique for implementing views in object-oriented/object-relational databases and apply it to the ODYSSEUS object-relational database system. We first analyze the requirements of object views. Next, to implement object views, we extend the existing query modification algorithm that has been proposed for implementing views in relational databases. Next, we compare the features of the proposed object view with those of object views in commercial object-relational database systems. It is shown that the proposed object view supports all object-oriented concepts such as object identifiers, inheritance, methods, and composite objects, while existing object views support part of them. Last, we propose detailed techniques for implementing the extended query modification algorithm in the ODYSSEUS object-relational database system.
Keywords
object-oriented/object-relational database; view;
Citations & Related Records
연도 인용수 순위
  • Reference
1 Motschnig-Pitrik, R., 'Requirements and Comparison of View Mechanisms for Object-Oriented Databases,' Int'l Journal on Information Systems, Vol. 21, No. 3, pp. 229-252, 1996   DOI   ScienceOn
2 Kim, W., Modern Database Systems, ACM Press, 1995
3 Ceri, S. and Widom, J., 'Deriving Production Rules for Incremental View Maintanence,' In Proc. 17th Int. Conf. on Very Large Data Bases, Barcelona, Spain, pp. 577-589, Sept. 1991
4 Data, C., A Guide to the SQL Standard, Addison Wesley, 1987
5 Kim, W., 'Object-oriented database systems: Promises, reality, and future,' In Proc.19th Int. Conf. on Very Large Data Bases, Dublin, Ireland, pp. 676-687, Aug. 1993
6 Oracle, Oralce9i SQL Reference Manual, 2001
7 IBM, DB2 SQL Reference Manual, 2001
8 Shmueli, Q. and Itai, A., 'Maintenance of Views,' In Proc. Int'l Conf. on Management of Data, ACM SIGMOD, pp. 240-256, June 1984   DOI
9 한욱신, 이민재, 이재길, 박상영, 황규영, '오디세우스 객체관계형 멀티미디어 DBMS의 아키텍처', 한국정보과학회 추계학술발표회, 27권, 2호, pp. 45-47, 2000년 10월   과학기술학회마을
10 Stonebraker, M., 'Implementation of Integrity Constraints and Views by Query Modification,' In Proc. Int'l Conf. on Management of Data, ACM SIGMOD, pp. 65-78, May 1975   DOI
11 Kim, W., Introduction to Object-Oriented Databases, MIT Press, 1990
12 Carey, M., Rielau, S., and Vance, B., 'Object View Hierarchies in DB2 UDB,' In Proc. Int'l Conf. on Extending Database Technology, EDBT, pp. 478-492, Mar. 2000
13 Dayal, U. and Bernstein, P., 'On the Correct Translation of Update Operations on Relational Views,' ACM Trans. on Database Systems, Vol. 8, No. 2, pp. 381-416, 1982   DOI
14 Bancilhon, F. and Spyratos, N., 'Update Semantics of Relational Views,' ACM Trans. on Database Systems, Vol. 6, No. 4, pp. 557-575, 1981   DOI   ScienceOn
15 우준호, ODYSSEUS 객체지향 데이타베이스 시스템을 위한 질의 처리기의 설계 및 구현, 석사 학위 논문, KAIST 전산학과, 1995
16 Stonebraker, M. and Moore, D., Object-Relational DBMSs: The Next Great Wave, Morgan Kaufmann, 1999
17 Blakeley, J., Larson, P., and Tompa, F., 'Efficiently Updating Materialized Views,' In Proc. Int'l Conf. on Management of Data, ACM SIGMOD, pp. 61-71, June 1986   DOI
18 Hanson, E., 'A Performance Analysis of View Materialization Strategies,' In Proc. Int'l Conf. on Management of Data, ACM SIGMOD, pp. 440-453, May 1987   DOI