The Community for Technology Leaders
2013 IEEE 29th International Conference on Data Engineering (ICDE) (2006)
Atlanta, Georgia
Apr. 3, 2006 to Apr. 7, 2006
ISBN: 0-7695-2570-9
pp: 2
Yannis Kotidis , AT&T Labs
Divesh Srivastava , AT&T Labs
Yannis Velegrakis , AT&T Labs
Database views are extensively used to represent unmaterialized tables. Applications rarely distinguish between a materialized base table and a virtual view, thus, they may issue update requests on the views. Since views are virtual, update requests on them need to be translated to updates on the base tables. Existing literature has shown the difficulty of translating view updates in a side-effect free manner. To address this problem, we propose a novel approach for separating the data instance into a logical and a physical level. This separation allows us to achieve side-effect free translations of any kind of update on the view. Furthermore, deletes on a view can be translated without affecting the base tables. We describe the implementation of the framework and present our experimental results
Yannis Kotidis, Divesh Srivastava, Yannis Velegrakis, "Updates Through Views: A New Hope", 2013 IEEE 29th International Conference on Data Engineering (ICDE), vol. 00, no. , pp. 2, 2006, doi:10.1109/ICDE.2006.167
88 ms
(Ver 3.3 (11022016))