DOI QR코드

DOI QR Code

Incremental Materialized View Management Model for Realtime Report Generation on Large Transaction Processing Environment

대규모 트랜잭션 환경에서의 실시간 보고서 생성을 위한 점진적 형성뷰 관리모델

  • 김진수 (육군 교육사령부 체제분석실) ;
  • 신예호 (극동대학교 정보통신학부) ;
  • 류근호 (충북대학교 전기전자 및 컴퓨터공학부)
  • Published : 2004.06.01

Abstract

Reports have a significant meaning in time-constrained large transaction environments, such as airplane control systems or wargame simulations. This is due to the necessity of generating reports within a given time limit without restraining the operation performance of large transaction environments. In order to generate reports in large transaction environments while satisfying time-constrained requirements, this paper proposes a model which combines the incremental operation mechanism and materialized view mechanism using triggers and stored procedures. Further, the implementation and evaluation of the proposed model provides the Identification of the characteristics of the proposed model.

항공관제 시스템, 워게임 등과 같이 시간제약을 갖는 대규모 트랜잭션 환경에서 보고서의 의미는 특별하다 이는 대규모 트랜잭션 연산을 수행하면서 성능의 제약 없이 제한된 시간 내에 보고서를 생성할 수 있어야 하기 때문이다. 이와 같이 대규모 트랜잭션 환경에서 시간제약을 만족하면서 보고서를 생성할 수 있도록 하기 위하여 이 논문에서는 점진적 연산 기법과 형성뷰 기법을 트리거와 저장 프로시져를 이용하여 결합시킨 모델을 제안한다. 아울러 제안 모델에 대한 구현 및 평가를 통해 제안 모델의 특성을 분석한다.

Keywords

References

  1. J. widom, S. Ceri, 'chapter 1, Introduction to Active Database systems(Triggers and Rules for Advanced Database Processing),' Morgan kaufman Publishers, pp.1-42, 1996
  2. ANSI X3H2-99-079/WG3:YGJ-011(ANS/ISO Working Draft) Foundation (SQL/Foundation), ANSI, 1999
  3. 류근호, '시간지원 데이터베이스에서 뷰 형성 유지를 위한 실행트리', 한국정보과학회 논문지, 제20권 제8호, 1993
  4. Mukesh K. Mohania, Guozhu Dong, 'Materialized View Adaption in Distributed Databases,' Asian Computing Science Conference, (ASIAN)'96, pp.353-354, 1996 https://doi.org/10.1007/BFb0027815
  5. Zohra Bellahsene, 'Adapting Materialized Views after Redefinition in Distributed Environments,' ER 2000, International Conference on Conceptual Modeling(ER), pp.239-252, 2000
  6. Chuan Zhang, Jian Yang, 'Materialized View Evolution Support in Data Warehouse Environment,' (DASFAA)'99, pp.247-254, 1999 https://doi.org/10.1109/DASFAA.1999.765758
  7. Dimitri Theodoratos, 'Detecting redundant materialized views in data warehouse evolution,' Information Systems, Vol.26, No.5, pp.363-381, 2001 https://doi.org/10.1016/S0306-4379(01)00025-4
  8. C. Forgy, 'Rete, a fast algorithm for the main memory patterns many objects pattern mathching problem,' J. Artificial Intelligence, p.19, 1982
  9. 'Oracle 9i Administration Guide,' Oracle Press, 2003
  10. D. P. Miranker, 'TREAT : A better match algorithm for AI production systems,' In Proceedins of AAAI 87 Conference on Artificial Inteligence, 1987
  11. F. Fabret, M. Reginer and E. simon, 'An adaptive algorithm for incremental evaluation of production rules in databases,' In Proceedings of the Nineth International Conference on VLDB, pp.455-467, 1993
  12. K. D. Moon, Park Jeong Seok, Y. H. Shin and K. H. Ryu, 'Incremnetal Condition Evaluation for Active Temporal Rules,' 4th International Conference on Intelligent Data Engineering and Automated, Springer, 2003
  13. 신예호, 류근호, '실시간 연관규칙 탐사를 위한 능동적 후보 항목 관리모델', 정보처리학회논문지D, 제9-D권 제2호, 2002 https://doi.org/10.3745/KIPSTD.2002.9D.2.215
  14. E. Hanson, Sreenath Bodagala, Mohammed Hasan, Goutam Kulkarni, and Jayashree Rangarajan, 'Optimized rule condition testing in ariel using gator networks,' Technical Report TR-95-027, University of florida CIS Dept., Oct., 1995
  15. David Wai-Lok Cheung, Jiawei Han, Vincent Ng, C. Y. Wong : Maintenance of Discovered Association Rules in Large Databases : An Incremental Updating Technique. ICDE : pp.106-114, 1996
  16. S. Chakravarthy et al., 'HiPAC : Research project in active, time-constrained database management,' Technical Report XAIT-89-02, Xerox Advanced Information Technology, Cambridge, Massachusetts, 1989
  17. Norman. W. Patton, andrew. Dinn, M. Howard Williams, 'Active Rules in Database systems,' Springer, 1998