•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the RSS, Web Services and SOAP section within the Web Development category of DaniWeb, a massive community of 456,448 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 2,675 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our RSS, Web Services and SOAP advertiser: Programming Forums
Views: 9897 | Replies: 79
 |
•
•
Join Date: Oct 2007
Posts: 23
Reputation: 
Rep Power: 2
Solved Threads: 0
Newbie Poster
I do not want to store only XML documents. I also have other data types in my application
•
•
Join Date: Oct 2007
Posts: 36
Reputation:
Rep Power: 2
Solved Threads: 0
Light Poster
DB2 is not a XML-only database. DB2 provides integration of relational data and XML data within a single database. Tables created with XML data types may also contain columns with “traditional” SQL data types, including numeric data, character strings, date/time data, and others.
•
•
Join Date: Oct 2007
Posts: 23
Reputation:
Rep Power: 2
Solved Threads: 0
Newbie Poster
I have not worked with pureXML. How difficult it is to query the XML data from database?
•
•
Join Date: Oct 2007
Posts: 36
Reputation:
Rep Power: 2
Solved Threads: 0
Light Poster
It is very easy to work with pureXML. If you're already familiar with SQL, you can immediately apply your skills to working with XML data stored natively in DB2. SQL/XML or Xquery statements are used to query the data. Both relational and XML data can be requested within a single request. Please check http://www.ibm.com/developerworks/db...-0603saracco2/ for more details.
•
•
Join Date: Oct 2007
Posts: 23
Reputation:
Rep Power: 2
Solved Threads: 0
Newbie Poster
Is it possible to add indexes to XML data type?
•
•
Join Date: Oct 2007
Posts: 36
Reputation:
Rep Power: 2
Solved Threads: 0
Light Poster
pureXML has new indexing technology; Indexes can be created for specific elements or attributes of the XML documents to speedup the data retrieval. It helps those queries which require specific portions of XML documents. Full text search over XML documents is also supported, and specialized text indexes can be defined to improve performance of such searches
•
•
Join Date: Sep 2007
Posts: 19
Reputation:
Rep Power: 2
Solved Threads: 0
Newbie Poster
Re: XML Management pureXML stores XML data in database retaining the XML format. Is it possible to index the columns? This could give us better query performance. 
•
•
Join Date: Oct 2007
Posts: 36
Reputation:
Rep Power: 2
Solved Threads: 0
Light Poster
Yes. pureXML has an indexing feature that can index over XML columns. With this indexing feature, retrieving XML node sets is much faster compared to retrieving nodes from XML documents stored in CLOB.
•
•
Join Date: Oct 2007
Posts: 23
Reputation:
Rep Power: 2
Solved Threads: 0
Newbie Poster
Are the XML documents stored in the same area as the relational data?
•
•
Join Date: Oct 2007
Posts: 36
Reputation:
Rep Power: 2
Solved Threads: 0
Light Poster
If you create a table which has an integer column and an XML column, the integer column (relational data) is stored in same table , but DB2 does not store the XML document in same table. Instead, the XML column contains an XML data descriptor that has the document ID and version ID for the XML document. The document is stored in the XML Data Area (XDA), which is separate from the base table.
|
•
•
•
•
•
•
•
•
DaniWeb RSS, Web Services and SOAP Marketplace
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Linear Mode
•
•
•
•
accounting software selection api apple asp bebo blogger blogging business software cd code development digital dom drama drm erp systems evaluations feed gdata google html ipod katemodern key linspire linux lonelygirl15 management microsoft mp3 news programming project management reader rights ripping rss soap software selection standards technology evaluation tv video w3c weather web xml xoap youtube zune
- Ezines (E-mail Management System) (eCommerce)
- Contract: Java, JSP, J2EE, XML & Fuego - USA (anywhere) (Web Development Job Offers)
- Windows XP and RAM Management (Windows NT / 2000 / XP / 2003)
- Senior Configuration Management/Build Engineer (Software Development Job Offers)
- Java XML Developer London WC1 (Web Development Job Offers)
- xml parser to validate xml files-Urgent (XML, XSLT and XPATH)
- How XML can be used in place of any database management system. (RSS, Web Services and SOAP)
- How are you making use of xml? (XML, XSLT and XPATH)
- over heating (Cases, Fans and Power Supplies)
- Processor (Windows NT / 2000 / XP / 2003)
Other Threads in the RSS, Web Services and SOAP Forum
- Previous Thread: session variable
- Next Thread: XML Update??
