UnlimitedAnalytics

Apache Kylin™ is an open source, distributed Analytical Data Warehouse for Big Data; it was designed to provide OLAP (Online Analytical Processing) capability in the big data era. By renovating the multi-dimensional cube and precalculation technology on Hadoop and Spark, Kylin is able to achieve near constant query speed regardless of the ever-growing data volume. Reducing query latency from minutes to sub-second, Kylin brings online analytics back to big data. Kylin can analyze 10+ billions of rows in less than a second. No more waiting on reports for critical decisions. Kylin connects data on Hadoop to BI tools like Tableau, PowerBI/Excel, MSTR, QlikSense, Hue and SuperSet, making the BI on Hadoop faster than ever. As an Analytical Data Warehouse, Kylin offers ANSI SQL on Hadoop/Spark and supports most ANSI SQL query functions. Kylin can support thousands of interactive queries at the same time, thanks to the low resource consumption of each query.

Nucleon BizApp Studio is a high-level application design and development software without or less coding. It supports data editor forms, user controls, reports, charts, tables, cross tables, scripting and other application components. Data Forms allow you to CRUD (create, edit, update, delete), search and view data using HTML-based editor forms. It provides a form designer and viewer where you can design data editor form with its data editor controls (textbox, datatime, numeric, image etc.) and edit the data using this form. It allows only RDBMS (MS Access, Oracle, MySQL, PostgreSQL, SQL-Server etc.) to create, read, update and delete data. NoSQL database systems currently are not supported. Nucleon BI provides OLAP Cross Table features for easy visual data mining and analysis: The Cross Table module provides MS Excel-like tables (Pivot Table), engineered for multi-dimensional data analysis and cross-tab report generation.