JUN 24, 2010 4:44am ET

Related Links

Analytics: Needing to Know or Wanting to Know?
April 9, 2014
Many Utilities Yet to Understand Full Potential for Big Data Analytics
April 7, 2014
Majority of Health Organizations Have Not Implemented BI System
March 6, 2014

Web Seminars

Looking for speed and accuracy in your financial planning and budgeting?
Available On Demand

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.

Are you actively evaluating master data management technologies and their ability to scale and support emerging trends around big data, social and mobile?

Yes 61%
No 23%
Don't Know 9%
Not Applicable 6%

 

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.