Which is the best way for keeping the data in XML or SQL
server..and why?
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
What is an object pool in .net?
I have a very important query in my mind. Please help me regarding this. I don't have any real time exp in .net. But I have a knowledge it .net. I got an offer from an MNC company as a software developer has I had kept 2 years of fake exp. Even though for this job I had worked hard to crack interview for about an year. So, I would like to know how difficult it will be for working in real time as I don't have real time exp. Please tell me as soon as possible bcoz I need to join by next month. Can i sustain over there for a longer time or not. And also let me know how to work pressure will be over there. Please help me regarding this. I'm getting tension thinking about it. Thank you.
What is tpl in c#?
What is keywords in c#?
How can we main a Class as base class,i.e not inherited further?{please Dont tell using Sealed class,any other way}
6 Answers ACB Group, IBM, Tech Mahindra,
What is the difference between ref and out in c#?
What are the different types of delegates?
3. Use layered architecture for coding. s.no name description 1 abc xxxxxxxxx 2 abc xxxxxxxxx 3 4 5 6 7 8 Select all Clear all Add Delete Name Description Save close
In .NET which is the smallest unit of execution?
From a versioning perspective, what are the drawbacks of extending an interface as opposed to extending a class?
What is the difference between console and windows application?
Why data types are important in c#?
Visual Basic (800)
C Sharp (3816)
ASP.NET (3180)
VB.NET (461)
COM+ (79)
ADO.NET (717)
IIS (369)
MTS (11)
Crystal Reports (81)
BizTalk (89)
Dot Net (2435)
Exchange Server (362)
SharePoint (720)
WCF (340)
MS Office Microsoft (6963)
LINQ Language-Integrated Query (317)
WPF (371)
TypeScript (144)
Microsoft Related AllOther (311)