Jinbo Chen

XML enables the integration and transformation of data from distributed data sources. These data sources may be relational database systems, ERP systems, legacy applications, or a combination. By accessing data from one or more sources in an XML format, applications can focus on the functional logic and let the data layer deal with multiple systems and different formats with different drivers and tools. To enable the easy and flexible creation of XML data from these data sources, I developed a platform- and database-independent Java tool - tree-structured SQL (TS-SQL). Structured Query Language (SQL) is a powerful and flexible tool that allows users to define and manipulate the data in the database. However, it's not intuitive in some cases, such as queries with both self- and outer-joins. Furthermore, SQL query results are always in a flat structure, a denormalized ... (more)