![](/assets/images/picto-drapeau-france-3a76576a5d60a512053b4612ab58dae5.png)
2. Purely relational approach
To store an XML document in a relational database, the simplest solution is to split the data into different tables and columns. Another solution would have been to store the XML data as a CLOB (Character Long Object). However, we won't go into this possibility here, as it is of little interest. It is then no longer possible to exploit the different levels of granularity of the XML document: it can only be rendered as a whole.
The first step is to set up the relational schema. Figure 2 shows the conceptual database model that can be implemented to achieve the desired objectives. In this model, we can identify two types of elements:
those that will be directly associated with data extracted from the XML document...
Exclusive to subscribers. 97% yet to be discovered!
You do not have access to this resource.
Click here to request your free trial access!
Already subscribed? Log in!
![](/assets/images/logo-eti-286623ed91fa802ce039246e516e5852.png)
The Ultimate Scientific and Technical Reference
This article is included in
Software technologies and System architectures
This offer includes:
Knowledge Base
Updated and enriched with articles validated by our scientific committees
Services
A set of exclusive tools to complement the resources
Practical Path
Operational and didactic, to guarantee the acquisition of transversal skills
Doc & Quiz
Interactive articles with quizzes, for constructive reading
Purely relational approach
Bibliography
- (1) - Oracle Database 11g XML DB - Technical Overview. - An Oracle White Paper (2007) http://www.oracle.com/technology/tech/xml/xmldb/Current/xmldb_11g_twg.pdf
- (2)...
Websites
Xylem http://www.xyleme.com/
Tamino Software AG https://documentation.softwareag.com/webmethods/tamino/ins10-3/concepts/cfintro.htm
Exclusive to subscribers. 97% yet to be discovered!
You do not have access to this resource.
Click here to request your free trial access!
Already subscribed? Log in!
![](/assets/images/logo-eti-286623ed91fa802ce039246e516e5852.png)
The Ultimate Scientific and Technical Reference