Reshape XML
Home Up Reshape XML CWD4ALL


Reshaping 2 ]

Fast, reliable data access for ODBC, JDBC, ADO.NET and XML
Business Intelligence with R&R ReportWorks
Got SOX compliance?
Movielink Logo 88x31
IBM eserver xSeries 306m 8849 - P4 3.4 GHz
iTunes Logo 88x31-1


XML Restructuring and Reshaping Should Not be Considered the Same

Logic in DB



MS SQL 2005


MS SQL 2005


1 2 3 4 5 6 7 Next >>

Michael M. David returns to to explore two approaches to XML hierarchical structure transformations. He explains the difference between restructuring and reshaping XML data, with the latter driven by the semantics of the data structure.

Michael M. David
Advanced Data Access Technologies, Inc.

Today the structure transformation terminology of Restructuring and Reshaping are used interchangeably for XML structure transformation processes. There are two basic types of XML hierarchical structure transformations that need to be distinguished because they are different in meaning, results, and use. These are Restructuring controlled by existing relationships in the data, and Reshaping controlled by the semantics of the current data structure. Restructuring is performed by using new and unused relationships to restructure the data. On the other hand, Reshaping uses the structure semantics of the current structure to mold the structure into any other shape without requiring or relying on any relationships in the data. Restructuring using data relationships can create a new structure and data with new semantics, while reshaping using structure semantics alters the structure without changing the data and its semantics. Both have their use. Restructuring is usually used to match a structure to its application use, and Reshaping to map a structure to a desired structure format.

Fast, reliable data access for ODBC, JDBC, ADO.NET and XML

Restructuring and Reshaping can both be performed or conceptually specified by using join conditions on multiple physical or logical copies of the same structure. Restructuring uses data relationships while Reshaping uses the same data field in the structure copies to synchronize them. Reshaping is also used in inverting structures when data relationships are not available in the data. This is often the case with XML data since foreign keys are not required because of their contiguous nested storage. This technique has been adapted for use in different database processors. XQuery procedural nested looping in its FLOWR statement can navigate linear and nonlinear structures, and along with its join capability, perform both Restructuring and Reshaping of linear and nonlinear structures using the structure transformation techniques described here.

1 2 3 4 5 6 7 Next >>

Database Server Watch  SQL Summit Home Page    Articles 

Visit (Grid Computing Knowledge Portal)


2007, Ken North Computing LLC, All rights reserved.


  Movielink Generic 120X90 Animated