Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
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?

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 the difference between func and action delegate?

913


What is a protected class c#?

866


What is meant by console programming?

873


Where static variables are stored?

909


How do you sort a list in c#?

822


What is the reason behind the invention of c#?

1072


What is the difference between finalize() and dispose() methods?

958


What is the symbol used for in c#?

916


Should I use double or float?

867


the c# keyword .int. Maps to which .net type?

1112


How many bytes is an int?

877


Why are strings immutable c#?

889


In a C# class we have a SortedList member m_addinProjects we want to provide an iterator to allow the consumer of this class access to the items in the collection. Please provide an iterator method for the AnalyzeAddinsDLL class below and an example of how it would be used. namespace AnalyzeAddinsDLL { public class AllAddInProjects { private SortedList m_addinProjects; public AllAddInProjects() { m_addinProjects = new SortedList(); } } }

2233


How do I do a case-insensitive string comparison?

993


How does split work in c#?

861