XML Restructuring and Reshaping Are Not the Same
TechNotes Logic in DB Beyond Java Data Access SOX SQL/XML Restructuring Trees Open Source BizIntel MySQL Drivers ODBC JDBC OLE DB .NET Podcast SQL:2003 MS SQL 2005 XML DBs XQuery Webcast XQuery SQL:2003 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 site’s home page at www.adatinc.com. Conclusion 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 structure’s 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    © 2007, Ken North Computing LLC, All rights reserved.