Communications of the ACM
Dbtoaster Breaks p Data Jams in Server Farms
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