Reshaping 7
Home Up


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 Are Not the Same

Logic in DB



MS SQL 2005


MS SQL 2005


<<Prev 1 2 3 4 5 6 7

Multi-type and Multiple Structure Transformation

Restructuring structure transformations can be performed using multiple input structures, they are not limited to a transform consisting of a single source structure. The target structure can be constructed from fragments of multiple source structures. It is also possible that both Restructuring and Reshaping operations can be applied in the same structure transform operation. Depending on how closely the result resembles a Restructure or Reshape operation, it may be safest to refer to the transform generically as a structure transform. The example structure transformation in Figure 6 uses multiple source structures (Department and Company) and both Restructuring and Reshaping operations. Reshaping inverts the Department and Employee nodes and Restructuring is used to relate employees in the Department structure to their qualifications in to the Company structure.

Additional Advanced Examples Available

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

My company, Advanced Data Access Technologies, Inc. has developed an ANSI SQL transparent native XML hierarchical processor, SQLfX, that handles relational and XML integration at a full nonlinear hierarchical processing level. It handles the restructuring and reshaping shown and described in this article as well as full hierarchical structure joining and advanced hierarchical processing capabilities. Notably, these capabilities are performed in ANSI SQL fully non-procedurally and hierarchically correct. To locate a pointer to these SQLfX Beta examples check out our sites home page at


There are two basic methods of performing structure transformations today and this article has shown the difference between these two structure transformations. Unfortunately, the terms Restructure and Reshape both apply to each of the basic structure transformations. It is important to understand the difference between these two structure transformations and assign them different distinguishable terms. This article has used a distinguishable terminology using the same two structure transformation terms that seems to make the most sense. Reshaping uses the structures semantics to transform the structure and its data, it does not use data relationships. This is useful for transforming a data structure to any desired structure. Restructuring uses data relationships to transform the structure. This is used to match a data structure to its intended application use. These methods can also support supplemental transformation capabilities such as renaming, splitting and duplicating nodes in transformation operation.

<<Prev 1 2 3 4 5 6 7

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