Academic
Publications
Adapting Materialized Views after Redefinitions

Adapting Materialized Views after Redefinitions,10.1145/223784.223817,Sigmod Record,Ashish Gupta,Inderpal Singh Mumick,Kenneth A. Ross

Adapting Materialized Views after Redefinitions   (Citations: 80)
BibTex | RIS | RefWorks Download
We consider a variant of the view maintenance problem: How does one keep a materialized view up-to-date when the view definition itself changes? Can one do better than recomputing the view from the base relations? Traditional view maintenance tries to maintain the materialized view in response to modifications to the base relations; we try to "adapt" the view in response to changes in the view definition.Such techniques are needed for applications where the user can change queries dynamically and see the changes in the results fast. Data archaeology, data visualization, and dynamic queries are examples of such applications.We consider all possible redefinitions of SQL SELECT-FROM-WHERE-GROUPBY, UNION, and EXCEPT views, and show how these views can be adapted using the old materialization for the cases where it is possible to do so. We identify extra information that can be kept with a materialization to facilitate redefinition. Multiple simultaneous changes to a view can be handled without necessarily materializing intermediate results. We identify guidelines for users and database administrators that can be used to facilitate efficient view adaptation.
Journal: Sigmod Record , vol. 24, no. 2, pp. 211-222, 1995
Cumulative Annual
View Publication
The following links allow you to view full publications. These links are maintained by other sources not affiliated with Microsoft Academic Search.
    • ...This problem, first introduced by Gupta, et al [14], is known to as the view adaptation problem...

    Jun Liuet al. A SchemaGuide for Accelerating the View Adaptation Process

    • ...In the relational database research community, the view adaptation problem was originally identied by Gupta et al [10]...

    Jun Liuet al. Precomputing queries for personal health sensor environments

    • ...The lineage tracing problem has already been discussed in many different areas such as: data warehousing[30], scientific databases[31], network monitoring , view updates and database visualization [29]...

    Roozbeh Derakhshanet al. RFID Data Management: Challenges and Opportunities

    • ...Gupta et al. [10] also described incremental view adaption techniques...

    Jingren Zhouet al. Dynamic Materialized Views

    • ...Two issues arise in the case of materialized views - one is the view update problem [11] or the problem of synchronizing materialized views with updates to the base data, and the other is the view adaptation problem [12] or the problem of synchronizing materialized views with changes to the view denition...
    • ...When access control rules change, the corresponding accesscontrol view denition also changes, and the view must be adapted [12] to conform to the user’s new access permissions...
    • ...There are two factors to be considered while adapting views efciently: (1) Computation cost for adapting access-control views, which is critical for interactive applications [12]; and (2) Communication cost for transferring data to adapt remote security views, e.g., in client-server systems, and client-based access control [5]...
    • ...[12]. That is, the incremental adaptation of XPath access-control views is the focus of our work...
    • ...Gupta et al. [12] have reported work on incrementally adapting relational views...
    • ...We also exploit XPath containment [17] and query answering using views [28] for efcient adaptation; these issues have not been addressed by previous work in relational databases [12]...
    • ...Gupta, et al., [12] originally introduced the problem of view adaptation for relational databases...

    Padmapriya Ayyagariet al. Incremental adaptation of XPath access control views

Sort by: