Relational Model versus XML

Question

Relational Model versus XML

Viewing 15 posts - 46 through 60 (of 71 total)

You must be logged in to reply to this topic. Login to reply

Sean Pearce SSCoach Points: 15999 More actions · Answer 1

sipas (1/25/2013)Personally I don't give two hoots if I get the answer right or not - as long as I learn something useful.

I agree with that sentiment, however I learned nothing from this question.

The SQL Guy @ blogspot[/url]

@SeanPearceSQL

About Me[/url]

sipas Hall of Fame Points: 3828 More actions · Answer 2

Sean Pearce (1/25/2013)
sipas (1/25/2013)Personally I don't give two hoots if I get the answer right or not - as long as I learn something useful.
I agree with that sentiment, however I learned nothing from this question.

I'm probably less experienced than a lot of people on this forum, so maybe this question was more useful for people like me who've still got a lot to learn.:blush:

(Bob Brown) SSCrazy Points: 2705 More actions · Answer 3

Thanks for the question. Wasn't quite sure of what to pick. I agree with most of the comments.

Mike Is Here Hall of Fame Points: 3348 More actions · Answer 4

Koen Verbeeck (1/23/2013)
I'd like to see the performance of the XML solution.
Also, I would think the structure of your website is known, so a relational model is preferred.
Curious to see the debate that will follow 🙂

Exactly.... according to the reference

If your data is highly structured with known schema, the relational model is likely to work best for data storage

And the details were given in the question so it is reasonable to assume it is known.

Mike Is Here Hall of Fame Points: 3348 More actions · Answer 5

Sean Pearce (1/25/2013)
sipas (1/25/2013)Personally I don't give two hoots if I get the answer right or not - as long as I learn something useful.
I agree with that sentiment, however I learned nothing from this question.

I second that.

sestell1 SSChampion Points: 10230 More actions · Answer 6

sipas (1/25/2013)
Which is why you don't make the decision based on that one sentence - therefore 'either' is the correct answer.

There is not enough information to know if either model would be appropriate, let alone both! Without any supporting information, the last answer isn't any more correct than the first two.

TomThomson SSC Guru Points: 104768 More actions · Answer 7

Sean Pearce (1/24/2013)
To add, I chose relational and I will stick to that.

But what, then, will you use for an RDBMS? I'm not aware of any that conforms to the relational model. :crying:

Tom

Miles Neale SSChampion Points: 13147 More actions · Answer 8

Read the question and then reread the question. I looked for the answer of "it depends" and found none. Then I thought about what would work and reread again and then got it right.

I have to admit that this question did not cause me to learn anything but such is life.

Not all gray hairs are Dinosaurs!

Tavis Reddick SSC Eights! Points: 817 More actions · Answer 9

Koen Verbeeck (1/23/2013)
I'd like to see the performance of the XML solution.
Also, I would think the structure of your website is known, so a relational model is preferred.
Curious to see the debate that will follow 🙂

I have no experience of using native XML databases with data capture from websites, but if XML is used to provide part of the read-only web content in a file-based early-rendering model, it can be exceptionally fast. We populated our College course web pages from a static 3 megabyte XML document with XSLT using ASP.NET's XslCompiledTransform, and rendering times were basically too fast to measure (served from our least-powerful production server in 2006, I recall) compared with serving static pages.

sqlnaive SSCoach Points: 17437 More actions · Answer 10

Absolutely no idea about the question. Just guessed it right. 🙂

Andre Ranieri SSCrazy Points: 2819 More actions · Answer 11

I guessed relational and got it wrong, based on the known unknowns such as performance and scalability factors.

+1

Uwe Ricken Hall of Fame Points: 3172 More actions · Answer 12

Koen Verbeeck (1/23/2013)
I'd like to see the performance of the XML solution.
Also, I would think the structure of your website is known, so a relational model is preferred.
Curious to see the debate that will follow 🙂

+1

I don't like questions like "it depends".

Without concrete and detailed information a proper solution could not be obtained.

Microsoft Certified Master: SQL Server 2008
MVP - Data Platform (2013 - ...)
my blog: http://www.sqlmaster.de (german only!)

marlon.seton SSCrazy Points: 2623 More actions · Answer 13

BrainDonor (1/24/2013)
The true answer should be "Either is a candidate at this point, due to insufficient information".

That goes along with my thoughts. An answer of 'Either may be appropriate' rather than 'Either is appropriate' would be better, IMO.

Mike Brockington SSC Eights! Points: 874 More actions · Answer 14

For the kind of website that was described, SQL server is not going to be appropriate, because none of the CMS's that are appropriate will use it as a back-end.

Or were we supposed to think that anyone would write a CMS from scratch in this day and age?

As for XML - is that meant to be a hierarchy of files, or a single monolithic schema? The latter is certainly not clever even if it is small enough to be held in memory.

Throw away your pocket calculators; visit www.calcResult.com

TomThomson SSC Guru Points: 104768 More actions · Answer 15

mike brockington (2/21/2013)
For the kind of website that was described, SQL server is not going to be appropriate, because none of the CMS's that are appropriate will use it as a back-end.
Or were we supposed to think that anyone would write a CMS from scratch in this day and age?
As for XML - is that meant to be a hierarchy of files, or a single monolithic schema? The latter is certainly not clever even if it is small enough to be held in memory.

I agree with that, so I'm going to stick with my original reaction: I'll use a mixture of both plus a few other things besides. The answer given as "correct" (either will do) is utter drivel (I suspect it wasn't intended as anything else, some questions are there just to provoke debate and this could well be one of them) but "neither of them will do" isn't useful either ("neiother will do on its own" would be somewhat useful, of course).

Tom