Is it the end of the line for SQL?

pwarren

 

For a couple of decades, businesses have been standardizing on SQL-based databases for dealing with large data sets. Recently a bunch of new databases have hit the scene which are more optimized for web-based viewing and analysis.

http://www.itworld.com/software/185393/nosql-standouts-new-databases-new...

 

Is this the end of the line for SQL? Or will there Microsoft, Oracle, and others come up with updates for their versions of SQL that can address its current shortcomings?

 

Topic: Software
Answer this Question

Answers

2 total
ncharles
Vote Up (20)

One of the big changes over the past few years is that servers now have much larger hard drives and faster processors; this has led to more data being captured for analysis. Where SQL falls short with data warehousing is making sense of the data that's captured and turning it into information. That's what's driving the move to study 'big data'. And there's little reason why a company couldn't run SQL the way they've been doing it, but then port out the data they want to manipulate into a tool like NOSQL and dig for nuggets of gold. 

lbloom
Vote Up (14)

Of course it's not the end of the line for SQL-type databases. Even though there are new analytics needs which require a database to be optimized in different ways than through traditional SQL databases, SQL is so widely-used that it will probably still be running on servers in 10 years. If one looks at the databases that have fallen into disfavor over the past couple of decades (dBase, FoxPro, 4D, etc.) they were all proprietary and tied to a single main vendor. Since DB2, Sybase, Oracle, and Microsoft all have versions of their own SQL-style database, that won't be the case for SQL. And even the new competitors to SQL have to contend with the fact that there are many more people using open sourced-versions, like PostgreSQL and MySQL that it's easier to find developers and DBA's with SQL skills than who are trained in these other databases who have a much smaller installed userbase.

Ask a question

Join Now or Sign In to ask a question.
The R programming language is quickly gaining popular ground against the traditional statistics packages such as SPSS, SAS and MATLAB, at least according to one data statistician who teaches the language.
Online test grants LFCS and LFCE certifications.
Samsung Electronics will demonstrate new games and Skype group calls for its smart TVs at next month's IFA trade show in Berlin.
Ryan Carmack, the 9 year-old son of the famed programmer and game designer, has released Pong-clone called Angry Face
China has approved the sale of 5 million Xbox One units, opening the way for Microsoft to make a big splash in the country's emerging console sector.
An analysis by security researchers of 48,000 extensions for Google's Chrome browser uncovered many that are used for fraud and data theft, actions that are mostly undetectable to regular users.
Fully 70% of federal agencies experienced downtime of 30 minutes or more in a recent one-month period.
University and vendor researchers are congregating in San Diego this week at USENIX Security '14 to share the latest findings in security and privacy, and here are 5 that jumped out to me as being particularly interesting.
It's not surprising that former Microsoft CEO Steve Ballmer abruptly gave up his board seat some six months after leaving the top job, and the move should help cement the regime and strategy of his successor Satya Nadella, according to several industry observers.
Steve Ballmer's decision to step down from Microsoft's board draws to a close a 34 year-long career that took him from business manager to CEO.