Sign In

Communications of the ACM

ACM TechNews

Dbtoaster Breaks ­p Data Jams in Server Farms


View as: Print Mobile App Share: Send by email Share on reddit Share on StumbleUpon Share on Hacker News Share on Tweeter Share on Facebook
server farm

Billions of database queries are made of gigantic server farms around the world every second.

Credit: I Know This Now

Ecole Polytechnique Federale de Lausanne (EPFL) researchers have developed DBToaster, a system designed to improve the flow of database queries into server farms by accelerating the pace of operations by a factor of 100. The researchers say their system was able to compile successive operators as one single operator, making it possible to store huge intermediate results and efficiently prevent data jams.

The technology also takes into account the fact that queries are often repetitive. Instead of recalculating everything each time, the system stores the preceding result in memory and combines it with new entries.

"The big innovation with DBToaster is its ability to generate efficient code that manages to figure out how previous queries should be changed in order to be updated," says EPFL professor Christoph Koch. He also notes that DBToaster "enables analytical processing in real time, which financial institutions need to perform automated trading or to enforce regulatory compliance — for instance to detect patterns of money laundering in their streams of financial transactions."

From Ecole Polytechnique Federale de Lausanne
View Full Article

 

Abstracts Copyright © 2012 Information Inc., Bethesda, Maryland, USA


 

No entries found

Sign In for Full Access
» Forgot Password? » Create an ACM Web Account