XML Database Integration via XSLT Mapping
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Existing methods for integrating XML documents with databases on the web face challenges such as low promptness in data storage and potential inaccuracies during the storage process, particularly when dealing with diverse schema structures and user requests.
Innovation Solution
A method utilizing XML replacement technology, involving user-defined tags, XSL format documents for data mapping, and SQL query statements generated through XSLT transformation to dynamically integrate XML data with databases, allowing for efficient storage and revision of data.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Quantity of substance
If XML documents are stored in a newly created database table, then data storage capability is improved, but system complexity and data migration requirements worsen
Solution Approach 1:
The patent introduces an intermediary mapping mechanism that translates between XML document structures and existing database schema structures. This mediator enables XML data to be stored in pre-existing database tables without requiring new table creations, thereby reducing system complexity while maintaining data storage capability.
Solution Approach 2:
The patent employs dynamic parameter mapping where the mapping between XML elements and database columns is determined by configurable parameters rather than fixed structural assumptions. This allows flexible adaptation of XML data to existing database schemas, avoiding the need for schema changes or new table creations.
2Adaptability or versatility
If XML documents with different schema structures are stored in separate database tables, then data storage flexibility is improved, but data reuse and integration capability worsen
Solution Approach 1:
The patent implements a universal mapping framework that can handle multiple XML schema structures through a single unified approach. The same mapping mechanism works for different XML document types by dynamically configuring parameter mappings, enabling data from diverse schemas to be stored in common database tables while maintaining flexibility.
Solution Approach 2:
The patent segments the mapping process into configurable parameter sets that can be selectively applied to different XML schemas. This segmentation allows the system to maintain flexibility for different data types while using a common database structure, thereby improving data integration capability without sacrificing storage flexibility.
3Quantity of substance
If existing database data is migrated to a new database, then data storage capability is improved, but time consumption and operational complexity worsen
Solution Approach 1:
The patent performs preliminary configuration of mapping parameters before data storage occurs. By pre-defining how XML structures map to database tables, the system eliminates the need for time-consuming migration operations when storing XML data, as the mapping is already established and can be applied directly to existing data.
Data Source
AI summary
Disclosed herein is a method of integrating data of an XML document with a DB on a web. In the method, an XML document provided with user-defined tags is designed. An XSL format document for normal data mapping and an XSL format document for repetitive data mapping are designed. Mapping information required to map the normal data and the repetitive data of the XML document to the XSL format document for normal data mapping and the XSL format document for repetitive data mapping is created. An XSL document for normal data mapping and an XSL document for repetitive data mapping are generated using the mapping information. An SQL query statement required to integrate the normal data and the repetitive data of the XML document with a DB is generated. Data of the XML document is integrated with the DB by executing the SQL query statement on the DB.