Efficient view maintenance using version numbers

被引:0
|
作者
Sze, EK [1 ]
Ling, TW [1 ]
机构
[1] Natl Univ Singapore, Singapore 117543, Singapore
来源
DATABASE AND EXPERT SYSTEMS APPLICATIONS | 2001年 / 2113卷
关键词
D O I
暂无
中图分类号
TP [自动化技术、计算机技术];
学科分类号
0812 ;
摘要
Maintaining a materialized view in an environment of multiple, distributed, autonomous data sources is a challenging issue. The results of incremental computation are effected by interfering updates and compensation is required. In this paper, we improve the incremental computation proposed in our previous work by making it more efficient through the use of data source and refreshed version numbers. This is achieved by cutting down unnecessary maintenance queries and thus their corresponding query results. The number of times of sending subqueries to a data source with multiple base relations are also reduced, as well as avoiding the execution of cartesian products. Updates that will not affect the view are detected and incremental computation is not applied on them. We also provide a compensation algorithm that resolve the anomalies caused by using the view in the incremental computation.
引用
收藏
页码:527 / 536
页数:10
相关论文
共 50 条
  • [31] ESTIMATING NUMBERS OF RODENTS AND EDGE EFFECT USING A MODIFIED VERSION OF THE STANDARD MINIMUM METHOD
    CHUDOBA, S
    HUMINSKI, S
    ACTA THERIOLOGICA, 1980, 25 (22-3): : 365 - 376
  • [32] Materialized view selection and maintenance using multi-query optimization
    Mistry, H
    Roy, P
    Sudarshan, S
    Ramamritham, K
    SIGMOD RECORD, 2001, 30 (02) : 307 - 318
  • [33] A Rawlsian Version of the Opportunity Maintenance Thesis
    Lavazza, Andrea
    AMERICAN JOURNAL OF BIOETHICS, 2016, 16 (06): : 50 - 52
  • [34] The maintenance management framework: A practical view to maintenance management
    Crespo Marquez, A.
    Moreu de Leon, P.
    Gomez Fernandez, J. F.
    Parra Marquez, C.
    Gonzalez, V.
    SAFETY, RELIABILITY AND RISK ANALYSIS: THEORY, METHODS AND APPLICATIONS, VOLS 1-4, 2009, : 669 - 674
  • [35] The maintenance management framework A practical view to maintenance management
    Crespo Marquez, A.
    de Leon, P. Moreu
    Gomez Fernandez, J. F.
    Parra Marquez, C.
    Lopez Campos, M.
    JOURNAL OF QUALITY IN MAINTENANCE ENGINEERING, 2009, 15 (02) : 167 - +
  • [36] SOFTWARE MAINTENANCE - A DIFFERENT VIEW
    CHAPIN, N
    AFIPS CONFERENCE PROCEEDINGS, 1985, 54 : 507 - &
  • [37] ROAD MAINTENANCE - THE METROPOLITAN VIEW
    SIMS, FA
    CIVIL ENGINEERING-LONDON, 1984, (FEB): : 25 - 27
  • [38] Efficient multi-view video coding using inter-view information
    Huang, Xin-Xian
    Chen, Mei-Juan
    Yeh, Chia-Hung
    Chi, Hao-Wen
    Chen, Chia-Yen
    SIGNAL PROCESSING-IMAGE COMMUNICATION, 2014, 29 (06) : 667 - 677
  • [39] MAINTENANCE AND OBSOLESCENCE - THE USER VIEW
    不详
    INSTRUMENTATION TECHNOLOGY, 1982, 29 (07): : 19 - &
  • [40] Parallel multisource view maintenance
    Zhang, X
    Ding, LL
    Rundensteiner, EA
    VLDB JOURNAL, 2004, 13 (01): : 22 - 48