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

Answers were Sorted based on User's Feedback



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

Answer / srinivas

FRIENDS THE ABOVE DISCUSSION ANSWER IS COMPLETELY WRONG .

THE BEST WAY TO USE IS SQL SERVER BECAUSE IF WE WANT ANY
MODIFICATIONS TO OUR DATA IT IS VERY EASY TO ORGANISE OUR
DATA AND RETRIVES EFFICIENTLY.


BUT COMING TO XML IT IS DIFFICULT TO HANDLE LARGE AMOUNT OF
DATA AND DIFFICULT TO MAINTAIN AND TO MODIFY HUGE DATA.

Is This Answer Correct ?    8 Yes 0 No

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

Answer / amit kumar

U shuld store ur data in Xml bcoz XML is harware and
software indepened language its used wide variety of
company

Is This Answer Correct ?    3 Yes 0 No

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

Answer / 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

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

Answer / manish

There are different point of view but under it there is a
catch ... SQL SERVER stores the data in XML format only.

Is This Answer Correct ?    2 Yes 0 No

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

Answer / nazrul

We can keep our data in both XML or SQL Server depend on
reqirement.
1)xml is good for small database where manipulation is not
frequent.data connection is also light in xml.
2)xml is good where we have to convert our data in diffrent
database like ms-Access.
Sql is good where we need manipualation frequently.and
data is big.

Is This Answer Correct ?    2 Yes 0 No

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

Answer / shaheen

To store the data, the best and appropriate way is SQL
SERVER as it is more compatible with any language and gud
database.
i think for a short term XML also plays vital role in
storing the data.

Is This Answer Correct ?    1 Yes 0 No

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

Answer / srinivas

we can store the data in both xml and sql server, but the difference is you can store the static data in xml file like error messages, captions or menu items. But its not good for storing application data(it should store in any RDBMS)

Is This Answer Correct ?    0 Yes 0 No

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

Answer / sharmin jose

This is a very tricky question. Is it for a long term use
or short term use? If its for a long term then SQL server
is the answer and XML for short term.

Is This Answer Correct ?    0 Yes 3 No

Post New Answer

More C Sharp Interview Questions

What are the boolean data types in c#?

0 Answers  


What is attribute and reflection in c#?

0 Answers  


One start and stop button is there and one textbox is there.when you click start button ,it will display 1,2,3......up to infinite in textbox.when you click stop button it will stop.

1 Answers  


What is signature c#?

0 Answers  


How does bitwise xor work?

0 Answers  






What is Reflection in .NET? Namespace? How will you load an assembly which is not referenced by current assembly?

0 Answers  


Can you declare the override method static while the original method is non-static?

2 Answers   Mind Tree,


Explain the difference between “system.array.clone()” and “system.array.copyto()” in c#?

0 Answers  


Asha buys 16 Chocolates for rs 12 and 24 chocolates for rs 20, if she sold them 30 chocolates for rs 30 then what is the Gain/Loss percentage? Gain(700/19 %) Loss(700/19 %) Gain(500/19 %) Loss(500/19 %) If one person ate 100 grapes in 5 days and 6 more each day from starting, what was the no of grapes he ate on first day? 6 8 10 7 If seven men P, Q, R, S, T, U, V parked his car, P and Q something like that. 6 student J, K, L, M, N, O went for picnic in 2 batches, K and L have to go together, M and O do't go together, if O and L go in one batch then which of these combination will be wrong. Jmnp Jklo klop JKLO a boat can go upstream and down stream, if it goes 5/2 times of downstream at the speed of 6 kmph then what will be the speed of upstream? 15 KMPH 12 KMPH 10 KMPH 11 KMPH A, B, C, D, E sitting on a table, A sits 2 seat left from B and C sits 2 seat right from B then what will not be the combination ACDE

0 Answers   Symphony,


What is private static in c#?

0 Answers  


How do I register my code for use by classic com clients?

0 Answers  


i want o/p 011242110 in c# code.

0 Answers   TCS,


Categories