Sign In

Communications of the ACM


SQL Databases v. NoSQL Databases


Recently, there has been a lot of buzz about NoSQL databases. In fact, there were at least two conferences on the topic in 2009, one on each coast.

The full text of this article is premium content



You seem to be giving a feeling that using a DBMS native code like a stored procedures can *always* give you better performance than accessing the Db via ODBC/JDBC kind of APIs. This can be true only for cases where the application is fetching a lot of records and ferrying them over the wire to "application server" tier where it applies some business logic to them to finally produce just a small dataset as a result. In such cases sure one could avoid the n/w overhead by doing all the business logic in a stored procedure, but other than such a scenario there's not a significant performance gain in using stored procedures.


Ralf Sattler

The topic itself and the article are interesting, but I really think that 15 Dollar are way too much for just 2 pages.

Displaying all 2 comments

Log in to Read the Full Article

Sign In

Sign in using your ACM Web Account username and password to access premium content if you are an ACM member, Communications subscriber or Digital Library subscriber.

Need Access?

Please select one of the options below for access to premium content and features.

Create a Web Account

If you are already an ACM member, Communications subscriber, or Digital Library subscriber, please set up a web account to access premium content on this site.

Join the ACM

Become a member to take full advantage of ACM's outstanding computing information resources, networking opportunities, and other benefits.

Subscribe to Communications of the ACM Magazine

Get full access to 50+ years of CACM content and receive the print version of the magazine monthly.

Purchase the Article

Non-members can purchase this article or a copy of the magazine in which it appears.