Browse > Article
http://dx.doi.org/10.3745/KIPSTD.2004.11D.1.061

Mixed Uses of Materialized View and Signature View-Index Mechanism for Efficient Query Processing on CORBA  

Lee, Seung-Yong (원광보건대학 컴퓨터응용개발과)
Kim, Myung-Hee (원광디지털대학교 게임소프트웨어학과)
Joo, Su-Chong (원광대학교 컴퓨터공학과)
Publication Information
The KIPS Transactions:PartD / v.11D, no.1, 2004 , pp. 61-68 More about this Journal
Abstract
Now, the representative researching trends of view managements for improving the query processing in multi-database system are focused on the materialized view mechanism and the signature view index mechanism. But when we compare with both mechanisms, the former mechanism's access time is faster than one of the latter's, and needs large space. The latter mechanism needs small space and the access time is slower than one of the former. These mechanisms are trade-off each other. Therefore, in case of query process using the view management, we are to improve the system performance and to reduce the access cost of disk input and output by suggesting a new mechanism mixing both the materialized view mechanism and the signature view index mechanism. We suggested that the structure of metadata and the algorithm about the new mired mechanism.
Keywords
Multi-Database; View; Materialized View; Signiture View Index; Mixed View;
Citations & Related Records
Times Cited By KSCI : 2  (Citation Analysis)
연도 인용수 순위
1 변광준, 'CORBA 기반의 이질적인 데이터베이스 통합,' 한국정보과학회지, 제17권 제7호, 1999   과학기술학회마을
2 A.Segev and J.Park, 'Updating Distributed Materialized Views,' IEEE Trans. on Knowledge and Data Engineering, Vol.1, No.2, 1989   DOI   ScienceOn
3 N.Goyal et al., 'Preliminary Report on View Materialization in GUI Programming,' Proceedings of the Workshop on Materialized Views : Techniques and Applications, pp.56-64, June, 1996
4 S.Chaudhuri, R.Krishnamurthy, S.Potaminanos and K.Shim, 'Materialized Views Optimizing Queries with Materialized Views,' IEEE, 1995
5 D.Lee and C.Leng, 'Partitioned Signature File : Design issues and performance evaluation,' ACM Trans. on Office Information Systems, Vol.7, pp.212-223, April, 1989   DOI
6 A.Dogac, C.Dengi, E.Kilic, G.Ozhan, F.Ozcan, S.Nural, C.Evrendilek, U.Hailci, B.Arpinar, P.Koksal, N.Kesim and S.Mancuhan, 'METU Interoperable Database System,' ACM SIGMOD Record, Vol.24, No.3, September, 1995
7 E.Kilic, G.Ozhan, C.Dengi, N.Kesim, P.Koksal, A.Dogac, 'Experience in Using CORBA for a Multidatabase Implementation,' Proc. Of 6th International Workshop on Database and Expert System Applications, London, Sept. 1995
8 W.Litwin and A.Abdellatif, 'Multidatabase Interoperability,' 1996
9 H.S.Yong, S.Lee and H.J.Kim, 'Applying Signatures for Forward Traversal Query Processing in Object-Oriented Databases,' International Conference on Data Engineering, pp.518-525, Feb., 1994   DOI
10 F.Rabitti and P.Savino, 'Image Query Proceesing Based on Multi-level Signatures,' Proc. of ACM SIGIR Conf. on Research and Development in Information Retrieval, pp.305-314, October, 1991   DOI
11 용환승, '관계 데이터베이스에서 시그니쳐를 이용한 뷰인덱스 기법', 정보처리논문지, 제3권 제4호, 1996
12 N.Roussopoulos, 'An Incremental Access Method for View Cache : Concept, Algorithms and Cost Analysis,' ACM Trans. on Database Systems, Vol.16, No.3, pp.535-563, 1991   DOI
13 문창주, 이선정, 박성공, 백두권, 'CORBA 환경에서 메타데이터를 이용한 관계형 데이터베이스와 파일 시스템간의 상호운용성 해결방안', 한국정보과학회 '98 봄 학술발표논문집(B), 제25권 제1호, 1998
14 이선정, 문창주, 박성공, 백두권, '효과적 질의 처리를 위한 메타데이터 기반 실체 뷰 관리 기법', 한국정보과학회 가을학술발표논문집, 제25권 제2호, 1998
15 P.Zezula et al., 'Dynamic Partitioning of Signature Files,' ACM Trans. on Information Systems, Vol.9, No.4, pp.336-369, 1991   DOI
16 김지운, 김보경, 이근철, 문강식, 이전영, ;CORBA 기반 멀티데이터베이스 관리 시스템의 설계,' Available from http://iis lab.postech.ac.kr/mrg/publish/xwidd/kiss.doc
17 J.Blakeley et al., 'Efficiently Updating Meterialized Views,' ACM SIGMOD Conference, pp.61-71, 1986   DOI