A Realtime Report Generation Model using Mterialized View Management Technique Based on Database Trigger

트리거 기반의 형성뷰 관리기법을 이용한 실시간 보고서 생성 모델

  • Choi Mi Ran (School of Communication Information in Far East University) ;
  • Jeon Keun Hwan (School of Computer Application in Kunjang College) ;
  • Hyun Deuk-chang (School of Communication Information in Far East University) ;
  • Shin Ye Ho (School of Communication Information in Far East University)
  • 최미란 (극동대학교 정보통신학부) ;
  • 전근환 (군장대학 컴퓨터응용학부) ;
  • 현득창 (극동대학교 정보통신학부) ;
  • 신예호 (극동대학교 정보통신학부)
  • Published : 2003.11.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 limited scope of time 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 propose a model which combines the incremental operation mechanism and materialized view mechanism using triggers and stored procedures. Further, the implementation and evaluation of the preposed model provides analysis for model characteristics.

Keywords