BOSTON--(BUSINESS WIRE)--Deep Information Sciences, the company that reimagined MySQL for the on-demand economy, today announced that Ruđer Bošković Institute (RBI) is using the free Community Edition of DeepSQL™ to accelerate its genomic research. DeepSQL, the world’s only self-tuning database engine, enables RBI to speed critical research processes by 400% while slashing the time required to ingest genomes from several days to just four hours. RBI also reduced its storage footprint by 40%, making it easy to scale to big data levels, and eliminated the need for manual database tuning.
“When you’re dealing with the massive and ever-growing amounts of data that RBI’s research requires, speed and scalability are crucial. Tuning the application and tweaking my MySQL configurations only get you so far—they consume a lot of time for not a lot of reward,” said Chad Jones, Chief Strategy Officer, Deep Information Sciences. “We’re thrilled that RBI is using DeepSQL to supercharge its research into biological evolution and that, even without a DBA, they’re able to achieve orders of magnitude better performance and scale from their MySQL environment.”
“To determine the evolutionary age of human genes, we need to pull genomes from a variety of public databases. With MySQL’s InnoDB engine, it took a week to load each batch of genomes and perform initial analyses. Our research slowed to a crawl, and with our database expected to double in size every year, we knew this lag time would only get worse,” said Dr. sc. Martin Sebastijan Šestak, a Post-doctoral researcher at RBI’s Department of Molecular Biology, Laboratory of Evolutionary Genetics. “We evaluated InnoDB alternatives and found DeepSQL was much easier to install and use. If you know MySQL, you’re all set—no training is needed. Loading and preprocessing 50GB of data with DeepSQL took just one day instead of InnoDB’s full week. And compared to TokuDB, DeepSQL loaded three times faster and ran queries five times faster, while delivering 40 percent compression. Now, instead of wasting time on database administration, we can accelerate our research and easily scale to handle massive amounts of gene sequences.”
DeepSQL is the world’s only adaptive database engine. It transforms MySQL into a perpetually self-tuning, massively scalable and highly performant database, across cloud, virtual and physical environments. Leveraging fundamentally new computer science and machine learning, and using the MySQL interface businesses know, DeepSQL delivers unprecedented speed and flexibility and scales to hundreds of billions of rows, without requiring application changes. The result is an adaptive MySQL that tunes to meet the demands of the application, enabling far greater performance without trial and error or even needing a DBA.
DeepSQL enables RBI to:
Accelerate key research by 400%
Instead of a week, it takes only one day to ingest, clean, query and preprocess genes. RBI also benefits from predictable performance. “We finally know how long loads and queries will take. And because DeepSQL is fully ACID compliant, we won’t lose anything if a server shuts down,” said Šestak.
Slash ingest and query times from days to hours
RBI ingests 50GB of genomes in just four hours—600 percent faster than with InnoDB, and 200 percent faster than TokuDB.
Queries are also much faster because DeepSQL uses parallelism when joining tables. A query that took 15 hours with TokuDB ran in just three hours with DeepSQL. It would have taken days with InnoDB,” Šestak said.
Easily scale and reduce storage footprint by 40 percent
RBI shrank its database size considerably without impacting performance. Šestak noted, “Now we can handle truly big data from massively growing genome repositories with the same infrastructure. It scales along with our research, no changes necessary.”
Reduces tedious MySQL administration
Researchers no longer have to focus on loading and preprocessing data. “We automate it and forget about it. Now, we spend that time on real research instead of MySQL administration,” said Šestak.
About Deep Information Sciences
Deep Information Sciences reimagined MySQL for the on-demand economy and built the world’s only adaptive storage engine. DeepSQL transforms MySQL into a perpetually self-tuning and highly performant database in cloud, physical and virtual environments. Leveraging new computer science and machine learning, and using the MySQL interface businesses know, DeepSQL delivers unprecedented speed and flexibility and scales to hundreds of billions of rows, without requiring application changes. Businesses are empowered to predictably meet current and future customer demands while lowing costs, and instantly respond to ever-changing market conditions. Deep is headquartered in Boston’s Innovation District. Learn more at www.deepis.com, or follow the company on Twitter @DeepInfoSci, LinkedIn, Google+ or Facebook. Download for free today at www.deepis.com/downloads.