1 / 5

XML and Databases: Enhancing SQL Queries Through Efficient Data Handling

This book explores XML input and output integration with JDBC connections, facilitating SQL query conversions on the fly. It focuses on transitive closure operations, regular select and insert queries, and limitations related to data validation and relationships. The text includes how to enhance SQL cases with an added emphasis on web interfaces and metadata information.

lucine
Télécharger la présentation

XML and Databases: Enhancing SQL Queries Through Efficient Data Handling

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. XML and Databases Prasenjit Adak Stylianos Paparizos

  2. Description • XML input and output • JDBC connection • Assuming existing data collection • SQL query conversion on the fly • Regular select and insert queries • Transitive closure

  3. Input • Request tag • Connect tag • Query tag • Insert tag

  4. Limitations • No validation • No many-to-many relationships • Relationships between either one or two entities only • Outer table has to be specified first

  5. Extensions • Web interface • Metadata information • Add DTD or XML schema to output • Single-rooted hierarch output • Addition of more SQL cases like update

More Related