A business intelligence application designed by Diester.
Every day, organizations create huge amounts of data related to their operations. However, even with all that data they don’t have a large amount of information. Axional Analytics is designed to convert data into usable information by allowing the aggregation of data and providing users with the information they need to make effective decisions about an organization’s strategic directions.
The Axional Analytics Suite comprises two tools: a Data Warehouse management tool and a ROLAP analytical tool for end users. With the combination of these tools, Axional Analytics can handle vast amounts of data, coming from multiple sources providing your company managers with a global insight to make timelier decisions.
With a Data warehouse your organizations will be able to answer “who” and “what” questions. The OLAP module take the next step by enabling answers to “what if” and “why” questions, enabling the decision making capabilities about future actions, and that is typically more complex than simply gathering data.
On the analytical world, queries can be a source of consuming time. Time lost waiting for answers is a productivity loss. As organizations amass more and more data, even basic queries can take a substantial amount of time. That’s why Axional Analytics is fully integrated with IBM Informix Warehouse Accelerator (aka IWA), the first columnar in-memory database that can scan tons of data in seconds.
Informix Warehouse Accelerator is a perfect system to implement datawarehouses. It provides extreme performance while removing most of the tuning required for traditional datawarehouse systems.
The Informix accelerator has this awesome key features:
Provide acceleration without manual tuning for each workload. No index to create, no index reorganization required, no statistics to collect, no partitioning, no tuning, no storage management.
Summary tables or materialized views are not needed, you can go directly with fact tables.
Scans billions of rows in milliseconds or seconds. the deep columnar data representation, query processing on compressed data voids the need of tuning.
Linear performance. The query performance depends on data volume not on query complexity.
Axional Analytics, also provides some key features that allow to work better and more integrated with Informix Warehouse System:
Automatic snapshot of ETL updated data to Warehouse Accelerator.
SQL Statement optimization to ensure IWA compatibility.
Warnings about queries with table or columns not present in datamart.
The purpose of the ROLAP Engine is to respond to queries from cube end users. The OLAP queries are performed in the server side using Java interface. To increase performance, Axional ROLAP Engine may runs on specially configured server computers.
With its specific architecture, Axional ROLAP engine includes the following features:
The Axional OLAP module uses a multidimensional view of aggregate data to provide quick access to strategic information for further analysis. Users can gain insight into data through fast, consistent, interactive access to a wide variety of possible views of information. This allows everyone in the organization to see the corporate data warehouse from their particular point of view.
This module also provides users with the information they need to make effective decisions about an organization’s strategic directions. Its features range from basic navigation and browsing, to complex calculations, to more serious analyses–such as time series. As decision-makers gain experience with OLAP capabilities, they move from data access to information to knowledge. The tool’s goal is to convert your business data into business intelligence. To achieve this objective, it uses a pre-configured datamart structure that at the same time offers a flexible configuration.
The Axional OLAP module insulates users from complex query syntax, modeling designs and elaborate joins. Its multidimensional view of data provides the foundation for analytical processing through flexible information access. Users are able to analyze data across any dimension, at different levels of aggregation, with equal functionality and ease.
The OLAP module works on facts and facts are numbers. A fact could be a count of sales, the sum of the sales amounts, or an average of sales amounts. Facts are also known as Measures and are organized into dimensions which are ways that the facts can be broken down. For instance, total sales might be able to be broken up by geography. Similarly, total sales might also be broken down by time. Dimensions have also hierarchies of levels.
The set of dimensions and measures is called a Cube. The cubes facilitate multifaceted data analysis in response to complex business queries. Because they can be made up of more than three dimensions (hypercube), in-depth analysis is enabled, allowing users to gain comprehensive and valuable business insights.
Axional Analytics allows for virtually unlimited numbers of dimensions to be added to the data structure (OLAP cube), allowing for detailed data analysis. Analysts can view data sets from different angels or pivots.
It uses a relational database which directly stores the information contained in the various cubes (ROLAP model). This approach translates native OLAP queries into the appropriate SQL statements. Thanks to the use of DB high performance tools, such as Informix IWA, this approach performs as well as a MOLAP database.
This approach also enables an easy implementation of In-memory analytics allowing for faster analysis, rapid insights and minimal IT involvement. The In-memory analytics approach eliminates the need to store pre-calculated data in the form of OLAP cubes or aggregate tables. It offers business-users faster analysis, and access to analysis of large data sets, with minimal data management requirements.
With the ETL process, several cubes can be created, each one with a specific set of dimensions and measures more fitted to the requirements of a particular group of users. With cubes, managers gain insight into data through fast, accurate, and flexible methods to various views of business metrics that have been transformed from raw data into meaningful information.
There are two different OLAP Clients providing an easy-to-use interface that will automatically retrieve and format data based on existing model definitions, for every query made by user:
ANALYTICS WEB CONSOLE: AXIONAL OLAP AXIONAL MOBILE OLAP
End users love Business Intelligence tools. They provide graphs, moving targets, drill-downs, and drill-through. But much of the work in an analytical environment involves getting the data from operational systems into the data warehouse so that business intelligence tools can display those pretty pictures.
The ETL module is a scalable enterprise data integration platform with exceptional extract, transform, and load (ETL) capabilities. The module is based on a Data Transformation Engine. It operates at a higher level of abstraction than many visual development tools. Generally, developers can accomplish much more with the engine in far fewer statements than they can with 3GLs:
This module consolidates data from different source systems, having different data organizations or formats. It has been specifically designed to move high data volumes and apply complex business rules to bring all the data together in a standardized and homogeneous environment. The key features of this tool are:
The XSQL language allows the definition of complex rules to transform the raw data. Some examples are:
The tool provides with connectors for extraction from multiple Data Sources, from plain text to Databases, to Excel, XML and others.
The data source is extracted by data streaming and can be loaded on-the-fly to the destination database with no intermediate data storage. Advanced loading functions allows in most cases to integrate all ETL phases in a single process, increasing security and reliability.
An intrinsic part of the extraction involves the parsing of extracted data, resulting in a check if the data meets an expected pattern or structure. If not, the data may be rejected entirely or in part:
The transform stage applies a series of rules or functions to the source’s extracted data to derive the end-data to be loaded into the target DB. To tool provides with the capability to:
Load data and anonymize in one step: Anonymization and normalization is performed on-the-fly, during the loading of external data from files. For each line of the source file, the following steps are executed:
The load phase stores the data into the end target, usually the data warehouse (DW) or a stage database.
Inserting new records or updating existing ones can be done searching the primary key columns. If the data loaded has a PK of an existing record, then the record is updated and if it’s a new PK, then the record is inserted. For optimizing performance, two different updating algorithms can be defined depending of the data type. For fact tables, first an insert is tried and if the PK exists then the update is done. For master tables, the first operation tried is the update and if no records are updated, then the insert is done.
The system provides with the capability to handle historical data as well. In this case, all changes in records are kept allowing to reproduce any previous report.
Target systems could be a database connected via JDBC, a file, or ever a streamed data seeded by posting to HTTP, by FTP or by TCP.
Integration with Informix IWA: After loading data in target Informix database, ETL process could automatically call the process for updating Warehouse Accelerator Datamart data.
The tool supports massive parallel processing (MPP) for large data volumes. In any case, one should consider than Simplicity is also performance, and the One Step “Extract, apply transformation functions & load” method is the faster algorithm for ETL procedures.
In our test systems, a file with 1 million records can be extracted, anonymized with whirlpool methods, normalized and loaded into Database table in less than 8 minutes, without using parallelization.
No reviews have been submitted. Do you use Axional Analytics Suite? Have you considered it as part of your software evaluation process? Share your perspective by writing a review, and help other organizations like yours make smarter, more informed software selection decisions!