Relational Model versus XML

Question

Relational Model versus XML

Viewing 15 posts - 31 through 45 (of 71 total)

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

TomThomson SSC Guru Points: 104768 More actions · Answer 1

Nils Gustav Stråbø (1/24/2013)
You live in the US and need to attend a meeting in Europe. What do you do?
1. Buy a plane ticket?
2. Buy a canoo and paddle across the Atlantic?

No, those are very un-American answers. Senator MacCarthy might have disapproved. 😀

The proper American solution to this problem is to tell the meeting organisers to move the meeting to a more suitable place - maybe Springfield Missouri, or San Diego. Or Brownsville, Texas :hehe:. Or even Fairbanks :w00t:. After all, anything that side of the pond is better than anywhere where visitors risk corruption by those awful liberal Europeans.

Tom

Ken SSCoach Points: 17191 More actions · Answer 2

I knew I was going to get this one wrong since it was basically a opinion piece. Good discussion but not a great question.

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

KWymore (1/24/2013)
I knew I was going to get this one wrong since it was basically a opinion piece. Good discussion but not a great question.

It's not really an opinion piece, it's making the point that you need to think about the requirements before deciding whether to use SQL Server, native XML or something else. It also makes you think about how to store your data within the database; sometimes it's best to store some data in SQL Server in XML format.

sestell1 SSChampion Points: 10230 More actions · Answer 4

sipas (1/24/2013)
KWymore (1/24/2013)
I knew I was going to get this one wrong since it was basically a opinion piece. Good discussion but not a great question.
It's not really an opinion piece, it's making the point that you need to think about the requirements before deciding whether to use SQL Server, native XML or something else. It also makes you think about how to store your data within the database; sometimes it's best to store some data in SQL Server in XML format.

Since this question does not provide enough information about the requirements to effectively make that decision, the answer cannot be supported by facts... leaving only opinion to base your answer on.

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

sestell1 (1/24/2013)
sipas (1/24/2013)
KWymore (1/24/2013)
I knew I was going to get this one wrong since it was basically a opinion piece. Good discussion but not a great question.
It's not really an opinion piece, it's making the point that you need to think about the requirements before deciding whether to use SQL Server, native XML or something else. It also makes you think about how to store your data within the database; sometimes it's best to store some data in SQL Server in XML format.
Since this question does not provide enough information about the requirements to effectively make that decision, the answer cannot be supported by facts... leaving only opinion to base your answer on.

When you don't have enough information to make a firm decision between the two options, surely the answer is that either could be appropriate. Admittedly the wording of option 3 could have been better.

But that's just my opinion.

lnoland SSCommitted Points: 1783 More actions · Answer 6

I was confused by the lack of an option, "Irrelevant, since markup languages should have been abandoned at least 30 years ago." 😉

- Les

Revenant SSC-Forever Points: 42467 More actions · Answer 7

I would like to see the performance of an XML database on the day when the course registrations open. Not speaking about the absence of native views and sprocs that isolate the middle tier from schema changes.

(Yes, I got it wrong. 😉 )

TomThomson SSC Guru Points: 104768 More actions · Answer 8

Revenant (1/24/2013)
I would like to see the performance of an XML database on the day when the course registrations open. Not speaking about the absence of native views and sprocs that isolate the middle tier from schema changes.
(Yes, I got it wrong. 😉 )

Personally, I would hate to see it. These days I believe in prevention, not cure.

Tom

PChiragS SSCarpal Tunnel Points: 4965 More actions · Answer 9

PChiragS

SSCarpal Tunnel

Points: 4965

January 24, 2013 at 12:46 pm

#1580679

Great Question..

Thank You..:-)

Thomas Abraham SSChampion Points: 10761 More actions · Answer 10

L' Eomot Inversé (1/24/2013)
Nils Gustav Stråbø (1/24/2013)
You live in the US and need to attend a meeting in Europe. What do you do?
1. Buy a plane ticket?
2. Buy a canoo and paddle across the Atlantic?
No, those are very un-American answers. Senator MacCarthy might have disapproved. 😀
The proper American solution to this problem is to tell the meeting organisers to move the meeting to a more suitable place - maybe Springfield Missouri, or San Diego. Or Brownsville, Texas :hehe:. Or even Fairbanks :w00t:. After all, anything that side of the pond is better than anywhere where visitors risk corruption by those awful liberal Europeans.

Now, now, Tom. There are some American's who wish we had been born and raised in, or lived now in Europe. If it wasn't for my wife, and her desire to stay close to her family, I'd be there right now. Guess that makes me an "improper" American. I can live with that. 🙂

[font="Verdana"]Please don't go. The drones need you. They look up to you.[/font]
Connect to me on LinkedIn

Sean Pearce SSCoach Points: 15999 More actions · Answer 11

Terrible question. To have to make such a fundamental architecture decision with a one sentence spec means this project will be doomed from the start.

Also the explanation mentions the need for a platform independant solution (did Joe write that passage). Personally I don't give two hoots if my solution doesn't work on Oracle or MySQL. If you bring me in to design a SQL Server solution, that's exactly what you will get.

The SQL Guy @ blogspot[/url]

@SeanPearceSQL

About Me[/url]

Sean Pearce SSCoach Points: 15999 More actions · Answer 12

To add, I chose relational and I will stick to that.

The SQL Guy @ blogspot[/url]

@SeanPearceSQL

About Me[/url]

demonfox SSCertifiable Points: 6289 More actions · Answer 13

Well, I got it wrong for thinking ; that the university website needs more publications and subscriptions , so better to have xml structures ; good for subscribers..

~ demonfox
___________________________________________________________________
Wondering what I would do next , when I am done with this one :ermm:

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

I would agree with the views that (pending further investigation) the website data should probably be first modelled relationally based on the given entities, then augmented with XML structures.

A College website I worked on used relational tables which are (I believe) generally more efficient at many-to-many relationships (many events to many audiences, many images to many news items: that is, images reused from a digital media asset database) using intermediate tables. We did use XML as well, for the XHTML content of articles, and all of our course information was extracted (from relational tables and XML sources) and stored on the website as an XML document, then rendered to web pages.

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

Sean Pearce (1/24/2013)
Terrible question. To have to make such a fundamental architecture decision with a one sentence spec means this project will be doomed from the start.

Which is why you don't make the decision based on that one sentence - therefore 'either' is the correct answer.

Also the explanation mentions the need for a platform independant solution (did Joe write that passage). Personally I don't give two hoots if my solution doesn't work on Oracle or MySQL. If you bring me in to design a SQL Server solution, that's exactly what you will get.

You don't know whether platform independence is important before finding out more about the requirements. The explanation doesn't say there's a need for platform independence, just that it's something to consider.

It's not a terrible question, the whole idea of these QOTDs is to make you think, provoke discussion and perhaps prompt you to research areas that otherwise you may not consider - isn't it? Personally I don't give two hoots if I get the answer right or not - as long as I learn something useful.