• Title/Summary/Keyword: Incremental Materialized View Maintenance Model

Search Result 2, Processing Time 0.019 seconds

Incremental Materialized View Management Model for Realtime Report Generation on Large Transaction Processing Environment (대규모 트랜잭션 환경에서의 실시간 보고서 생성을 위한 점진적 형성뷰 관리모델)

  • Kim, Jin-Soo;Shin, Ye-Ho;Ryu, Keun-Ho
    • The KIPS Transactions:PartD
    • /
    • v.11D no.3
    • /
    • pp.533-544
    • /
    • 2004
  • 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.

Realtime Report Generation Model using Trigger Based Incremental Materialized View Maintenance Mechanism (트리거 기반의 점진적 형성뷰 관리기법을 이용한 실시간 보고서 생성모델)

  • Lee, Nam-Il;Kim, Jin-Soo;Hyun, Deuk-Chang;Ryu, Keun-Ho;Shin, Ye-Ho
    • Journal of the Korea Computer Industry Society
    • /
    • v.5 no.9
    • /
    • pp.973-986
    • /
    • 2004
  • Reports have a significant meaning In large transaction environments, such as advanced the information technology and online environment. This is due to the necessity of generating reports within a giventime limit without restraining the operation performance of large transaction environments. In order to generate reports in large transaction environments while sa!isfying 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.

  • PDF