InfiniDB Makes Big Data Simple and Clear With Windowing Functions in MySQL

Presentation at Percona Live: MySQL Conference and Expo 2014 showcases how InfiniDB is the first storage engine for MySQL that simplifies complex analytics by allowing analysts to run statistical calculations in-database.

  • Share on TwitterShare on FacebookShare on Google+Share on LinkedInShare on PinterestEmail a friend
InfiniDB Logo

InfiniDB Logo

The ability to run statistics in-database on InfiniDB, utilizing multiple cores and the processing power of multiple nodes, is a game-changer for Data Scientists and Business Intelligence analysts looking to do deep analytics on Big Data.

Frisco, TX (PRWEB) March 26, 2014

InfiniDB announced today its upcoming presentation at the Percona Live: MySQL Conference and Expo about how its high performance analytic database InfiniDB is the first storage engine for MySQL that allows windowing functions. InfiniDB combines MySQL ease of use with a scalable architecture that can run on-premise, in the cloud, or natively in Hadoop to deliver real time SQL in Hadoop.

InfiniDB is unique, because existing MySQL storage engines do not support this windowing function feature of ANSI SQL11. InfiniDB is the first storage engine for MySQL that has support for windowing functions and is a great add-on for MySQL environments that are expecting rampant data growth. InfiniDB is renowned for its scalability and window functions simplify complex analytics as organizations experience large growth in data volume without any performance degradation.

“Statistical windowing functions allow analysts to run statistical calculations in-database, without needing to use an external statistical processing environment such as R. Since most statistical processing platforms are limited to the memory of the single server on which they run, the ability to run statistics in-database on InfiniDB, utilizing multiple cores and the processing power of multiple nodes, is a game-changer for Data Scientists and Business Intelligence analysts looking to do deep analytics on Big Data,” said Dipti Joshi, a Data Architect at InfiniDB.

She will be sharing more about the new features in a presentation, “Windowing functions in MySQL with InfiniDB,” on April 2 at 4:50 p.m. in Ballroom G at the Santa Clara Convention Center. The presentation will discuss how windowing functions simplify complex analytics tasks for computing cumulative, moving, centered or reporting aggregates without requiring doing sub-queries or writing stored procedures.

The presentation will also discuss the benefits of column storage and InfiniDB’s analytic solutions for a number of different types of infrastructures. These include InfiniDB, InfiniDB for the Cloud, and InfiniDB for Apache Hadoop. A perfect fit for a number of growing Big Data challenges, InfiniDB’s core data platform was designed from the inception for large scale, high performance dimensional analytics, predictive analytics, and ad-hoc business intelligence.

More information on InfiniDB will be available in the company’s booth # Booth 204 and attendees can enter a drawing with a chance to win a Kindle Fire HDX.

More about the windowing functions of InfiniDB can be found on Dipti Joshi’s blog, Windowing Functions for Analytics or at http://www.infiniDB.com.

Tweet this: News: @InfiniDB Makes Big Data Simple and Clear With Windowing Functions in #MySQL Presents #PerconaLive w @dipti_smg

About InfiniDB
InfiniDB empowers organizations to solve problems and create new solutions with powerful Big Data analytics. The company’s platform is a fourth-generation massive parallel processing (MPP) column-oriented data technology that is known for its rapid implementation, simplicity and extraordinary value. InfiniDB, InfiniDB for the Cloud, and InfiniDB for Apache™ Hadoop® are built for today’s growing enterprise. These organizations demand speed, scale and efficiency in their analytics platforms where leveraging traditional and emerging data technologies, structures and architectures are required. InfiniDB products are licensed as GPL-2.0 with complementary consulting services, maintenance and support agreements.

For more information, to join the community, and download software, visit http://www.InfiniDB.co and follow @InfiniDB.


Contact

  • Mark Peterson
    Peterson Communications
    +1 (831) 626-4400
    Email

Attachments

InfiniDB Makes Big Data Simple and Clear With Windowing Functions in MySQL InfiniDB Makes Big Data Simple and Clear With Windowing Functions in MySQL

InfiniDB Makes Big Data Simple and Clear With Windowing Functions in MySQL