JUN 24, 2010 4:44am ET

Related Links

IBM Introduces Watson to Consumers in Service for USAA Clients
July 23, 2014
Majority of Organizations Claim ‘Advanced’ Data Environments, Practices
June 5, 2014
C-Suite Tweets about Profit Performance
June 4, 2014

Web Seminars

How Intelligent Digital Self-Service with Customer Analytics Can Lower Costs and Raise Revenue
Available On Demand
Improve Omni-channel Shopping Experience with Product Information Management
August 21, 2014

What SQL Cannot Do


I recently asked my Twitter followers if they had a good example of queries, business questions that SQL can't do. It turns out a better question is "what SQL can't do easily," so I thought I'd share with everyone what I heard and found.

Get access to this article and thousands more...

All Information Management articles are archived after 7 days. REGISTER NOW for unlimited access to all recently archived articles, as well as thousands of searchable stories. Registered Members also gain access to:

  • Full access to information-management.com including all searchable archived content
  • Exclusive E-Newsletters delivering the latest headlines to your inbox
  • Access to White Papers, Web Seminars, and Blog Discussions
  • Discounts to upcoming conferences & events
  • Uninterrupted access to all sponsored content, and MORE!

Already Registered?


Comments (12)
A new category of databases suitable for cloud, namely key value pair based scalable nosql databases, are apt for cloud kind of use cases, where SQL is not apt, and use of SQL would mean compromise on other desirable properties of scalable cloud databases courtesty the CAP theorem

so category of cloud databases is another area where SQL is not very suited.

Posted by Srinivas P | Monday, June 28 2010 at 1:29PM ET
Your column essestially makes the case for the rapid growth in Master Data Management (MDM) programs in so many organizations, coupled with the need for robust dimensional modeling programs and processes.

Dimensional Modeling and formal MDM are intrinsically associated and play a powerful role in resolving the parameter driven issues you raise in your column's remarks. Those issues are a function of gaps in parameters identified and captured (dimensional models) and their integration in a Federated Model using MDM as the means of integration.

Posted by Quincy L | Monday, June 28 2010 at 2:04PM ET
Add Your Comments:
You must be registered to post a comment.
Not Registered?
You must be registered to post a comment. Click here to register.
Already registered? Log in here
Please note you must now log in with your email address and password.
Login  |  My Account  |  White Papers  |  Web Seminars  |  Events |  Newsletters |  eBooks
Please note you must now log in with your email address and password.