JUN 24, 2010 4:44am ET

Related Links

Innovative Organizations Likely to have More Pervasive BI and Data Governance
September 2, 2014
Revolutionize Your Business Intelligence with Lean, High-Performance Solutions
August 21, 2014
Should You Always Obey Orders from Your Executives?
August 7, 2014

Web Seminars

Essential Guide to Using Data Virtualization for Big Data Analytics
September 24, 2014
Integrating Relational Database Data with NoSQL Database Data
October 23, 2014

What SQL Cannot Do

Print
Reprints
Email

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?

Advertisement

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.
Twitter
Facebook
LinkedIn
Login  |  My Account  |  White Papers  |  Web Seminars  |  Events |  Newsletters |  eBooks
FOLLOW US
Please note you must now log in with your email address and password.