[ Reshaping 2 ]

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

Predictive Analytics World 2011, San Francisco

Need an expert for Java, XML and Web Services projects?

Got SOX compliance?

IBM eserver xSeries 306m 8849 - P4 3.4 GHz

Memory

PROLIANT BL20P G3 XEON 3.6G 2P

		XML Restructuring and Reshaping Should Not be Considered 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		1 2 3 4 5 6 7 Next >>   Michael M. David returns to SQLSummit.com 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. www.adatinc.com 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    © 2007, Ken North Computing LLC, All rights reserved.