50 likes | 151 Views
XML and Databases. Prasenjit Adak Stylianos Paparizos. Description. XML input and output JDBC connection Assuming existing data collection SQL query conversion on the fly Regular select and insert queries Transitive closure. Input. Request tag Connect tag Query tag Insert tag.
E N D
XML and Databases Prasenjit Adak Stylianos Paparizos
Description • XML input and output • JDBC connection • Assuming existing data collection • SQL query conversion on the fly • Regular select and insert queries • Transitive closure
Input • Request tag • Connect tag • Query tag • Insert tag
Limitations • No validation • No many-to-many relationships • Relationships between either one or two entities only • Outer table has to be specified first
Extensions • Web interface • Metadata information • Add DTD or XML schema to output • Single-rooted hierarch output • Addition of more SQL cases like update