Database management systems (DBMS) are 20 years out of date and should be completely rewritten to reflect modern use of computers.

That's according to a group of academics including DBMS pioneer Mike Stonebraker, Ingres founder and a Postgres architect taking his second controversial outing so far this year. Stonebraker upset many last month for his criticism of Google's MapReduce.

They have argued that DBMS designs such as Oracle and SQL Server come from an age when online transaction processing (OLTP) dominated and required techniques such as multi threading and transaction locking. They said that modern transactions - entered via web pages - do not need these expensive processing overheads and DBMS should, therefore, be re-designed without them. Persistent storage such as disks are also seen as unnecessary and could be replaced by geographically dispersed RAM storage.

Stonebraker and his group also advocate abandoning SQL because they see no need for a separate data manipulation language. Data manipulation, they said, can be performed with other tasks using languages such as Ruby. They describe a prototype DBMS called H-Store that embodies these ideas.

While there is certainly a point to be made about the way OLTP works in modern computer environments and the group has some persuasive arguments, it seems unlikely that mainstream DBMS builders will move away from tried-and-tested TP technologies in the near future. Banks and financial institutions in particular will want to hang on to the comfort and security provided by DBMS, which fully implement ACID properties.®

Related stories

• MySQL startup targets SSDs (30 July 2009)
• Ingres punts dev software bundle wrapped in Oracle fears (15 July 2009)
• Ingres and Red Hat unite to thwart Ellison's Sun love (27 May 2009)
• Time to reject traditional database techniques? (14 November 2008)
• Cold War comfort on software engineering’s birthday (7 October 2008)
• Google's MapReduce suddenly not so backward (27 August 2008)
• Microsoft, Facebook, Google box clever on really big systems (18 July 2008)
• Ruby flaws send security researchers into shock (23 June 2008)
• Ingres alumnus joins DBMS scrum (10 June 2008)
• Microsoft snags Google-thrashing data pioneer (28 April 2008)
• Developer leads buff the Ruby slippers (25 April 2008)
• IBM's EnterpriseDB stake: not what you think (7 April 2008)
• Hands on Build a directory service for web-based services (18 February 2008)
• Project Watch: Microsoft 2008 Back to basics for SQL Server 2008 (14 February 2008)
• NetBeans and Ruby, part 2 Ruby runs on Rails with NetBeans (13 February 2008)
• Betamax 2.0: the future of mashups? (11 February 2008)
• mSA high for Oracle embedded strategy (8 February 2008)
• Gurus answer MapReduce young turks (1 February 2008)
• Project Watch: Microsoft 2008 Experience overcomes Microsoft's broken promises (29 January 2008)
• Database gurus slammed for Google post (24 January 2008)
• Analysis Meet the world's premier open source vendor - Sun (16 January 2008)
• Mind your languages with Microsoft LINQ (10 December 2007)
• Hands on with MDX (23 October 2007)
• MDX: Why it will matter to application developers (22 October 2007)