EXASOL Powerlytics – powerful in-database analytics for future-proof business intelligence applications

New programming interface feature simplifies big-data analytics

Nuremberg, Germany, June 12, 2012 –EXASOL AG present their new Powerlytics feature that gives customers the possibility to program their own analyses for their data with full flexibility. Powerlytics empowers the evaluation of polystructural social media data, the full integration of external data from Hadoop frameworks and the convenient implementation of Map/Reduce algorithms that allow for processing big data on distributed systems. Applications of the new feature include time series analysis and sample analysis, statistical analysis, text search, data transformation or data mining.

EXASOL customers who use Powerlytics benefit from the even faster access to relevant information and useful results. These serve as future-looking, evidence-based decision aids for business-critical processes, such as in risk, fraud, invoicing and customer management or marketing. Positive side effects: IT resources are saved, the data volume is reduced and sourcing is significantly accelerated.

The objective of In-Database Analytics is to directly move the analysis from external systems directly to the EXASolution database in order to avoid data replication and to tap the full power of the high-performance cluster. This eliminates the need to transfer the data into an analysis system, only the calculation results are used.

The Powerlytics algorithms can be conveniently stored in EXASolution as User Defined Scripts, where they can be directly integrated into the SQL execution. This way, scalar, analytical and aggregate functions, Map/Reduce algorithms or data import/export are integrated into the SQL processing. Users have the choice between R, Python or Lua programming languages, which allows them to program their own custom algorithms. EXASolution automatically executes these programs in parallel by means of the embedded scripting engine in the cluster, guaranteeing maximum scalability and performance.

Powerlytics overview:
• In-Database Analytics empowers new analyses directly in EXASolution where heritage SQL and BI tools reach their limits
• Designed for scalable, parallel computing by the embedded scripting engine of the EXASolution cluster
• Empowers Map/Reduce algorithms, Hadoop integration and computing unstructured data
• Includes numerous libraries for simplified development, e.g. computing unstructured data, integration of external data sources, statistical functions, text analysis and data transformation
• Seamless integration with native SQL features for creating customized analysis appli-cations with highest performance

For product details, please visit: http://www.exasol.com/en/exasolution/powerlytics.html

“Gaining information from social media, blogs and e-mails requires big data analytics and suitable data warehouse management solutions as a driver”, says Steffen Weissbarth, CEO of EXASOL AG. “With Powerlytics, we take our innovation strategy further, companies can adjust to constant change and achieve remarkable results in real time.“

”With EXASOL Powerlytics, comprehensive analysis that takes heritage SQL and BI tools to their limits, happen right in the database – this provides a fast and reliable basis for decisions in the company“, says Mathias Golombek, Head of R&D at EXASOL AG. “By using numerous auxiliary libraries we integrated into Powerlytics, it’s easy to process xml documents, integrate external http interfaces, compute statistical functions or run string manipulations.”

Nuremberg-based EXASOL AG develop and distribute the high-performance database EXASolution, which is based on in-memory technology and that has been specifically designed to meet the needs of enterprise warehouse applications and business intelligence solutions. It allows for the rapid analysis and evaluation of even very large data volumes. Thanks to its high performance and low administration effort, EXASolution not only help companies to derive valuable decisions bases from their data but also for reducing their total cost of ownership. In April 2011, Gartner recognized EXASOL AG as”„Cool Vendor“ in the data management category and integration, 2011. In 2012, the solution was added to the Magic Quadrant “Data Warehouse database Management Systems“.

EXASOL AG
EXASOL AG, based in Nuremberg in Germany, develops a data management system that enables the rapid analysis and evaluation of data. By implementing the solution from EXASOL, business processes are optimised and secure foundations for decision-making are generated, which give companies a sustainable competitive edge.
EXASolution is a relational high-performance database that was specifically developed for enterprise warehouse applications and business intelligence solutions. The database is utilised by companies of all industry sectors for time-critical analyses, comprehensive data research, planning or reporting. The integration of geodata introduces an additional analysis dimension that allows for even more efficient analyses. The database can be integrated easily into existing IT infrastructures and requires a minimal amount of administrative maintenance, while ensuring low investment and operation costs (TCO). EXASolution is available under the name EXACloud as well as data warehousing as a service. This highly efficient data management solution allows EXASOL customers to benefit from complete data access at any time and a transparent price model. Companies such as XING, Sony Music Entertainment, Olympus, IMS Health, Semikron, intelliAd, Ratepay, Webtrekk and xplosion rely on EXASOL's "made in Germany" technology. For further information, visit www.EXASOL.com, follow us on twitter or join us on facebook.

EXASOL AG
Monika Götzmann
Neumeyerstraße 48
90411 Nuremberg
Germany
Fon: 0049-911-23991-0
E-Mail: presse@exasol.com

This release was published on openPR.