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

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

Kim, Jin-Soo (육군 교육사령부 체제분석실)
Shin, Ye-Ho (극동대학교 정보통신학부)
Ryu, Keun-Ho (충북대학교 전기전자 및 컴퓨터공학부)
Publication Information
The KIPS Transactions:PartD / v.11D, no.3, 2004 , pp. 533-544 More about this Journal
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
Large Transaction Environments; Realtime Report Generation; Incremental Materialized View Maintenance Model;
Citations & Related Records
Times Cited By KSCI : 1  (Citation Analysis)
연도 인용수 순위
1 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
2 Zohra Bellahsene, 'Adapting Materialized Views after Redefinition in Distributed Environments,' ER 2000, International Conference on Conceptual Modeling(ER), pp.239-252, 2000
3 Chuan Zhang, Jian Yang, 'Materialized View Evolution Support in Data Warehouse Environment,' (DASFAA)'99, pp.247-254, 1999   DOI
4 Dimitri Theodoratos, 'Detecting redundant materialized views in data warehouse evolution,' Information Systems, Vol.26, No.5, pp.363-381, 2001   DOI   ScienceOn
5 C. Forgy, 'Rete, a fast algorithm for the main memory patterns many objects pattern mathching problem,' J. Artificial Intelligence, p.19, 1982
6 'Oracle 9i Administration Guide,' Oracle Press, 2003
7 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
8 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
9 신예호, 류근호, '실시간 연관규칙 탐사를 위한 능동적 후보 항목 관리모델', 정보처리학회논문지D, 제9-D권 제2호, 2002   과학기술학회마을   DOI
10 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
11 Norman. W. Patton, andrew. Dinn, M. Howard Williams, 'Active Rules in Database systems,' Springer, 1998
12 Mukesh K. Mohania, Guozhu Dong, 'Materialized View Adaption in Distributed Databases,' Asian Computing Science Conference, (ASIAN)'96, pp.353-354, 1996   DOI   ScienceOn
13 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
14 ANSI X3H2-99-079/WG3:YGJ-011(ANS/ISO Working Draft) Foundation (SQL/Foundation), ANSI, 1999
15 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
16 D. P. Miranker, 'TREAT : A better match algorithm for AI production systems,' In Proceedins of AAAI 87 Conference on Artificial Inteligence, 1987
17 류근호, '시간지원 데이터베이스에서 뷰 형성 유지를 위한 실행트리', 한국정보과학회 논문지, 제20권 제8호, 1993