Sign In
Create Account
Follow Us on Twitter
Subscribe on Youtube
I am designing a system that will receive text files, convert them to XML documents and then store them in some form of database. The users of this system will then want to make queries on these documents.
So I wonder what would be best suited? Native XML seems to me like the natural choice, since it is after all XML I am storing. But I want your opinions.
5 replies to this topic
Back to top|
|
|
#2
Posted 14 October 2008 - 08:07 AM
WingedPanther
-
- Moderators
-
- 16,831 posts
A spammer's worst nightmare
If you want to do queries, you will probably want a database. Be aware that you CANNOT search against blob fields in most databases.
#3
Guest_Jordan_*
Posted 14 October 2008 - 08:41 AM
Guest_Jordan_*
Guest_Jordan_*
-
- Guests
I would also use a database. My question is why are you retrieving data and storing it in an actual XML file? You could retrieve the data, store it in a database and then present it as an XML document (if your need is to simply present XML files).
#4
Posted 14 October 2008 - 10:43 AM
Xav
-
- Members
-
- 13,118 posts
Writes binary right handed and hex left handed
There is no need to convert to XML first. Simply pop the data straight into the database. As Jordan says, if you want to send the data in some way or something, you can always load it into XML as and when you need it. For example, an RSS feed.
#5
Posted 30 October 2008 - 09:36 PM
shokosugi
-
- Members
-
- 10 posts
Newbie
SQL Server can generate XML.
SQL Server also has a way to search text field similar to Oracle Intermedia text.
SQL Server also has a way to search text field similar to Oracle Intermedia text.
Edited by WingedPanther, 31 October 2008 - 04:38 AM.
Double post
#6
Posted 31 October 2008 - 12:17 PM
Xav
-
- Members
-
- 13,118 posts
Writes binary right handed and hex left handed
