Dynamic XML Generation via Nested Database Templates
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Existing methods for generating XML documents from databases lack flexibility, relying on static definitions for data access, which limits personalization and increases coding complexity, especially in applications requiring varied data presentation like travel agencies.
Innovation Solution
A method using nested templates in the database format with executable instructions and SQL queries to dynamically generate XML documents, allowing for a high degree of personalization and reducing the number of XML documents needed, by maintaining a current element concept and using parameters to link templates.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Adaptability or versatility
If static definitions are used for data access in XML generation, then the structure is simple and easy to implement, but the flexibility and personalization capability are limited
Solution Approach 1:
The patent transforms static XML generation definitions into dynamic templates that can adapt to different data presentations. Templates maintain a current element concept and can be dynamically instantiated with parameters, allowing the same template to generate different XML structures based on input data characteristics, thereby achieving personalization without proportionally increasing coding complexity.
Solution Approach 2:
The patent introduces parameters as a mechanism to vary template behavior without creating separate templates for each variation. By changing parameter values, the same template can produce different XML outputs tailored to specific needs, resolving the contradiction between adaptability and complexity.
2Adaptability or versatility
If multiple XML documents are generated for different data presentations, then personalization is achieved, but the number of documents and maintenance burden increase
Solution Approach 1:
The patent creates universal templates that can serve multiple purposes and generate different XML document types from a single definition. A template with appropriate parameters can generate various presentations of the same underlying data, eliminating the need to maintain separate documents for each presentation variant.
Solution Approach 2:
The patent implements nested templates where templates can contain or reference other templates, creating a hierarchical structure. This allows complex XML presentations to be built from simpler template components, reducing the total number of templates needed while maintaining presentation variety.
3Productivity
If static XML generation methods are used, then implementation is straightforward, but development time for customized presentations increases
Solution Approach 1:
The patent prepares template definitions in advance that encapsulate common XML generation patterns. These pre-configured templates with parameter placeholders can be quickly instantiated and customized for different presentations, significantly reducing development time compared to creating XML structures from scratch while maintaining ease of implementation through the template mechanism.
Data Source
AI summary
The invention describes a method for automatically generating XML documents containing data extracted from a database source. The method consists of defining a number of templates in the format of the database, these templates containing executable statements. Queries associated with each of the templates are also defined. The queries are used for extracting data from the data of the source database in the form of sets of records. The execution of statements of the templates generates at least one XML document that contains the data from the sets of records. By using a call instruction, a template can call any of the other templates for creating an XML document. The inventive method realizes a dynamic definition for accessing data from the database with the aid of nested templates operating directly from the database.