Database Journal
MS SQL Oracle DB2 Access MySQL PostgreSQL Sybase PHP SQL Etc SQL Scripts & Samples Tips Database Forum

» Database Journal Home
» Database Articles
» Database Tutorials
MS Access
SQL Scripts & Samples
» Database Forum
» Slideshows
Free Newsletters:

News Via RSS Feed

Database Journal |DBA Support |SQLCourse |SQLCourse2

Featured Database Articles

Database News

Posted Oct 16, 2002

Complex Queries Defeat Top Databases

By DatabaseJournal.com Staff

[From vnunet.com]

Today's leading databases cannot handle many common queries and should only be used as a last resort, claims a Bloor Research report released this week. The analyst company identified a variety of increasingly common database queries that were particularly poorly handled, and recommended that users turn to specialist third-party products instead.

Philip Howard, author of Innovations in Data Warehousing - Answering Complex, Real-time and Dynamic Queries: An Evaluation and Comparison, argues that a conventional access approach as implemented in Oracle, IBM DB2 and Microsoft SQL Server should only be used as a last resort for at least three reasons.

First, when attempting to answer complex analytical queries, it typically takes either a very long time (certainly measured in hours and often in days) or requires an inordinate amount of processing power. This is especially true when the query cannot be predicted in advance. Secondly, traditional relational databases simply cannot cope with truly real-time environments. And, thirdly, standard approaches are not well-engineered to cope with large-scale queries whose business rules change on a regular basis.

A number of companies have worked to address these concerns and now offer products that can be used to supplement existing solutions (though some of them may also replace traditional approaches). Typically, these vendors report performance improvements of hundreds of times, frequently on considerably reduced hardware platforms. This report examines these claims, which might be thought to strain credulity (actually they are real).

Specifically, this report compares six of the vendors in this space, including Aleri, Alterian, Apama, Aruna, Sand Technology and Sybase. The report also investigates the technologies (including column-based relational databases, tokenisation, and vector processing and databases) that underpin their various solutions.

The complete article is available at http://www.vnunet.com/News/1135981.

An overview of the report itself is available at http://www.bloor-research.com/product/480/innovations_in_data_warehousing.html.

Back to Database Journal Home

Database News Archives

Latest Forum Threads
Database News Forum
Topic By Replies Updated
Efficient SQL Server Indexing by Design lcole 0 April 30th, 12:38 PM
Mine Oracle Database, SQL Server and Other Databases with Monarch Data Pump Pro V10.5 lcole 0 April 30th, 12:37 PM
Oracle Database and Oracle Fusion Middleware for Private Social Network Application lcole 0 April 30th, 12:31 PM
Oracle Database Maintains a Stronghold in the DBMS Market lcole 0 April 30th, 12:30 PM