January 23, 2013 at 8:47 pm
Comments posted to this topic are about the item Relational Model versus XML
_______________________________________________________________
"The best way to prepare for programming is to write programs, and
to study great programs that other people have written." – Bill Gates
January 23, 2013 at 11:44 pm
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 🙂
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
January 23, 2013 at 11:49 pm
Simply I guessed XML and got it wrong.
--
Dineshbabu
Desire to learn new things..
January 23, 2013 at 11:53 pm
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
(yes, performance was one thing came to my mind, OR considering the data is very less and and couple of users are accessing [not at the same time], but still... which (type of) university will be thinking to build a website in such a way? (its a question not rhetorical))
ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.
January 24, 2013 at 12:24 am
Hmm. I'm with Koen - I'd think you would know the schema to support your website.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
January 24, 2013 at 12:39 am
Raghavendra Mudugal (1/23/2013)
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
(yes, performance was one thing came to my mind, OR considering the data is very less and and couple of users are accessing [not at the same time], but still... which (type of) university will be thinking to build a website in such a way? (its a question not rhetorical))
+1
As the type of university I can imagine only "Shepherd University" from an old communist-time joke. Sorry, I'm not able to write the joke in english.
January 24, 2013 at 12:50 am
What a stupid question. How can you possibly answer it with the limited details provided?
...One of the symptoms of an approaching nervous breakdown is the belief that ones work is terribly important.... Bertrand Russell
January 24, 2013 at 12:53 am
GPO (1/24/2013)
What a stupid question. How can you possibly answer it with the limited details provided?
I first thought it was a joke 😀
"Pffft, who uses XML anyway?"
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
January 24, 2013 at 12:55 am
This was removed by the editor as SPAM
January 24, 2013 at 1:02 am
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
January 24, 2013 at 1:04 am
This was removed by the editor as SPAM
January 24, 2013 at 1:15 am
I think the correct answer should be worded slightly differently: "Either one can be appropriate" (italics used to emphasize changed part).
If forced to make a choice based on the limited information given, my second choice would be a relational design with some XML columns for the less- and un-structured data.
(My first choice would be to first read the documentation and conduct some interviews)
January 24, 2013 at 1:36 am
Hugo Kornelis (1/24/2013)
I think the correct answer should be worded slightly differently: "Either one can be appropriate" (italics used to emphasize changed part).If forced to make a choice based on the limited information given, my second choice would be a relational design with some XML columns for the less- and un-structured data.
(My first choice would be to first read the documentation and conduct some interviews)
+1
I think there is a missing answer "Both together is appropriate" which I feel is probably the correct answer based on the poor question. In reality you would probably have a mostly relational database with some XML as required for some of the unstructured content. As such I went for relational and got it wrong as I wouldn't choose a pure XML repository to drive a website. You need a fair bit of data stored relationally. I don't mind getting questions wrong as it helps you to learn, but this is a pretty bad question...
January 24, 2013 at 1:51 am
Got it right as I thought that "either" was the most probable answer.
Like most people are saying here I think the real answer is "it depends".
-------------------------------Posting Data Etiquette - Jeff Moden [/url]Smart way to ask a question
There are naive questions, tedious questions, ill-phrased questions, questions put after inadequate self-criticism. But every question is a cry to understand (the world). There is no such thing as a dumb question. ― Carl Sagan
I would never join a club that would allow me as a member - Groucho Marx
Viewing 15 posts - 1 through 15 (of 72 total)
You must be logged in to reply to this topic. Login to reply