Thursday, December 12, 2013

We need to come up with a REST based web service implementation returning JSON from a Data Store that needs to be highly scalable. The primary design requirement is high scalability because this service is going to be hit by hundreds of thousands of client apps(C++) at a predefined polling interval.
We are asked to propose the technology stack for the Web Service and the Database.
Initially we thought about ASP.NET MVC 3 for the REST API and SQL Server 2008 for the database. But the client is asking us whether this is scalable enough.
Since we are a Microsoft group, we are more inclined towards MS technologies but we want to be unbiased and propose a couple of best fits in this scenario. If some other technology stack is better suited to handle the load and scale, then we would like to present that to the client rather than trying to bag the project for ourselves.
We are just not sure how to go about coming up with a comparison since there are so many frameworks and available technologies to implement REST. We were also trying to figure out if a NoSQL based solution would help the scalability as there is no real reason to use a relational data model as the database will just be used as a data store.
Does any body have any suggestions around the choice of technologies that is best suited to handle the above requirement.
share|improve this question
add comment
Any of the mature web technologies (.net, java, php, etc) can be used to create a scalable REST api. If you application is data intensive, then I would go on to say that more than the web technology, it is the data store that would matter more.
To decide on the data-store, you should first check if the app is read intensive or write intensive. If its read intensive, a RDBMS with a caching solution (EhCache, Memcache, etc) should serve you well.
If its write intensive, you may want some sort of write sharding - you may be better off using a NoSQL solution like Cassandra/ MongoDB, etc.
Also consider licensing costs. With SQL Server most of the scalability features (partitioning, etc) are Enterprise features. With MSSQL 2012, license is per logical core and not per physical processor. If this is an issue, you may seriously want to consider MySQL instead of MSSQL.
share|improve this answer
add comment

5 comments:

oakleyses said...

louis vuitton handbags, oakley sunglasses, louboutin, longchamp outlet, nike shoes, louis vuitton outlet stores, chanel handbags, burberry outlet, prada outlet, jordan shoes, tiffany and co, michael kors outlet, tory burch outlet, louis vuitton outlet, longchamp handbags, nike free, true religion jeans, michael kors outlet, kate spade outlet, polo ralph lauren outlet, tiffany and co, prada handbags, polo ralph lauren outlet, michael kors outlet, michael kors outlet, longchamp handbags, oakley sunglasses, ray ban sunglasses, kate spade handbags, burberry outlet, louis vuitton outlet, louboutin outlet, louboutin, coach factory outlet, air max, air max, coach outlet, gucci outlet, christian louboutin shoes, michael kors outlet, coach purses, ray ban sunglasses, michael kors outlet, louis vuitton, coach outlet store online, true religion jeans, oakley sunglasses cheap

oakleyses said...

ralph lauren, lululemon, air max, hollister, north face, nike air max, polo lacoste, vanessa bruno, timberland, vans pas cher, louboutin, louis vuitton, oakley pas cher, air max pas cher, nike roshe run, air max, true religion outlet, barbour, sac longchamp, air force, hollister, sac louis vuitton, nike free, polo ralph lauren, nike trainers, louis vuitton uk, nike roshe, sac hermes, longchamp, michael kors, sac burberry, sac guess, mulberry, new balance pas cher, converse pas cher, sac louis vuitton, hogan outlet, nike tn, north face, true religion outlet, ray ban pas cher, michael kors, air jordan, nike blazer, nike free pas cher, michael kors pas cher, abercrombie and fitch, ray ban sunglasses

oakleyses said...

mac cosmetics, mont blanc, marc jacobs, canada goose outlet, nike huarache, vans shoes, soccer jerseys, hollister, giuseppe zanotti, beats by dre, abercrombie and fitch, longchamp, insanity workout, celine handbags, bottega veneta, ghd, nfl jerseys, north face outlet, chi flat iron, ugg boots, birkin bag, ugg australia, canada goose, herve leger, ugg pas cher, rolex watches, valentino shoes, canada goose uk, canada goose, ferragamo shoes, canada goose, ugg boots, uggs outlet, north face jackets, soccer shoes, asics running shoes, new balance shoes, p90x, lululemon outlet, canada goose jackets, mcm handbags, instyler, babyliss pro, ugg, wedding dresses, jimmy choo outlet, reebok outlet, nike roshe run

oakleyses said...

parajumpers, karen millen, air max, converse, pandora charms, moncler, louboutin, moncler, links of london, lancel, juicy couture outlet, oakley, hollister, pandora charms, supra shoes, thomas sabo, canada goose, gucci, wedding dresses, timberland boots, swarovski crystal, air max, coach outlet store online, moncler, ray ban, canada goose, moncler, ugg, louis vuitton, swarovski, hollister, montre homme, moncler, hollister clothing store, ralph lauren, rolex watches, moncler outlet, moncler, iphone 6 cases, baseball bats, juicy couture outlet, toms shoes, vans, pandora jewelry, ugg, converse shoes

oakleyses said...

parajumpers, karen millen, air max, converse, pandora charms, moncler, louboutin, moncler, links of london, lancel, juicy couture outlet, oakley, hollister, pandora charms, supra shoes, thomas sabo, canada goose, gucci, wedding dresses, timberland boots, swarovski crystal, air max, coach outlet store online, moncler, ray ban, canada goose, moncler, ugg, louis vuitton, swarovski, hollister, montre homme, moncler, hollister clothing store, ralph lauren, rolex watches, moncler outlet, moncler, iphone 6 cases, baseball bats, juicy couture outlet, toms shoes, vans, pandora jewelry, ugg, converse shoes