Interested to Buy Any Domain ? << Click Here >> for more details...
Which is the best way for keeping the data in XML or SQL
server..and why?
- 8 Answers
- 15057 Views
- Infosys, Satyam, I also Faced
- E-Mail Answers
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
Can you use all access modifiers for all types?
Are c# destructors the same as c++ destructors?
What is view state c#?
Can I define a type that is an alias of another type (like typedef in c++)?
What are the 2 broad classifications of data types available in c#?
What is an assembly qualified name
how to compare numbers and dispaly the largest ? *first thing I wanted to do is to input how many numbers to be compared *and then analyzed the largest then display it.
Define interface class in c#?
Is c# code is unmanaged or managed code?
What is the advantage of singleton class?
How do I enforce const correctness in c#?
What is serialization in dot net?
How to find the current application file path while runtime?
Does the system.exception class have any cool features?
How to install or uninstall a windows service?
