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: 15
Divesh Srivastava , AT&T Labs
Laks V. S. Lakshmanan , U of British Columbia
Nuwee Wiwatwattana , U of Michigan
H. V. Jagadish , U of Michigan
XML schema design has two opposing goals: elimination of update anomalies requires that the schema be as normalized as possible; yet higher query performance and simpler query expression are often obtained through the use of schemas that permit redundancy. In this paper, we show that the recently proposed MCT data model, which extends XML by adding colors, can be used to address this dichotomy effectively. Specifically, we formalize the intuition of anomaly avoidance in MCT using notions of node normal and edge normal forms, and the goal of efficient query processing using notions of association recoverability and direct recoverability. We develop algorithms for transforming design specifications given as ER diagrams into MCT schemas that are in a node or edge normal form and satisfy association or direct recoverability. Experimental results using a wide variety of ER diagrams validate the benefits of our design methodology.
Divesh Srivastava, Laks V. S. Lakshmanan, Nuwee Wiwatwattana, H. V. Jagadish, "Making Designer Schemas with Colors", 2013 IEEE 29th International Conference on Data Engineering (ICDE), vol. 00, no. , pp. 15, 2006, doi:10.1109/ICDE.2006.88
186 ms
(Ver 3.3 (11022016))