Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
elwoos
Master Smack Fu Yak Hacker
2052 Posts |
 Posted - 2008-03-14 : 09:24:10
|
| Im not particularly familiar with SQL server 2005 (or 2008) but I think one of these may be the answer to my question. We have an application that produces XML, currently it produces files but it can instead put the XML into a database field. The suppliers say it doesn't matter which version of SQL Server we use to do this as currently there isn't much done with the XML.However, our users want reports which we can only produce by analysing (and querying)the XML. Each XML record contains a single transaction and the users want aggregate reports - How many so and so did this sort if thing. Given that I can choose the database platform I presume that 2005 is my best option, however can I write reasonably efficient queries on the XML which will be held in these fields?Is there perhaps a better alternative altogether e.g. analysing the XML files that are currently produced, trying to import the XML into a database of it's own etc.?thanks in advancesteve-----------ASCII and ye shall receive. |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2008-03-14 : 10:09:23
|
| well i guess it depends on how complex reports you're going to have.xml can be pretty fast with xml indexes in place._______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenpSSMS Add-in that does a few things: www.ssmstoolspack.com |
 |
|
|
smeira
Starting Member
6 Posts |
Posted - 2008-03-17 : 02:14:14
|
| I prefer to extract xml files into relational tables and then I can provide any reports in xml format or in any other format by selecting from relational tables ... |
|
|
|
elwoos
Master Smack Fu Yak Hacker
2052 Posts |
Posted - 2008-03-18 : 09:07:36
|
| The reports will probably be pretty straightforward, just simple aggregates. So for example one of these sets of files is payments to a certain section of the organisation, so the reports would be things like total payments per organisation per month, with a bottom line total. That sort of thing. In terms of volume the largest will be a few thousand a month, most sets will be significantly lower. Thanks both for your responses, I hadn't registered that SQL Server 2005 had an XML index feature.At the moment I'm wondering if holding the data as XML and using something like Crystal Reports would provide the answer I need.steve-----------ASCII and ye shall receive. |
|
|
|
|
|
|
XML data question