Which is the best way for keeping the data in XML or SQL
server..and why?

Answer Posted / sathish

LIke on of our friend said, there are different perspective
to look at,

How the data is stored & how frequently it is modified?

XML - High risk and low cost
SQL - Low risk and Moderate cost

Does the data contains any relationship? for e.g. customer -
transcation - Account.........

XML does not support any relationship between data or Keys
etc.
SQL contains relationship, Constraints etc.

Does the data is used for just reporting?

XML can support straight forward scenario like say, show
the data for particular Acccount etc.
SQL supports more complex & real time business scenario.

How big is the data and how complex it is to maintain?

XML has the limitation, and the flexiblity depends upon the
amount of data
SQL will be flexible as well as accomdate amount of data
greater than XML

What kinda applicaiton uses the data?

XML can be parsed by many languages & compatible with
different platform
SQL can be used with the limitation of platform used i.e.
Microsoft Framework

At the moment, these are the things that came my way,
please correct me if i am wrong.

Is This Answer Correct ?    3 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is dll hell, and how does .net solve it?

509


Which of these statements correctly declares a two-dimensional array in c#?

630


What is the difference between string keyword and system.string class?

492


What is ulong in c#?

545


What is thread life cycle in c#?

453






From a versioning perspective, what are the drawbacks of extending an interface as opposed to extending a class?

490


What does using system mean in c#?

478


What is difference between string and stringbuilder in c#?

449


Can we maintain state in webservice?

485


How we can create an array with non-default values?

492


Can you declare struct members as protected?

481


How is a string immutable?

471


Distinguish between continue and break statement?

538


what will be the output of the given below coding. using System; public class Exercise { static void OddNumbers(int a) { if (a >= 1) { Console.Write("{0}, ", a); a -= 2; OddNumbers(a); } } public static int Main() { const int Number = 9; Console.WriteLine("Odd Numbers"); OddNumbers(Number); Console.WriteLine(); return 0; } }

3257


In .NET which is the smallest unit of execution?

611