HiQube: Another Business Intelligence System

May 25, 2008

Data management, not database, issues now dominate discussions about extracting information from log files, finding ways to manipulate without delay data in financial transactions, and making sense of telemetry data flows.

HiQube is a new high-performance business intelligence (BI) software solution that quickly delivers in-depth business analysis capability and superior reporting, as a result of its unique HiQube technology. HiQube technology is easy to use and is the first to combine hierarchical, relational and multidimensional database technologies. In doing so, it delivers users with unparalleled decision-making power. HiQube BI software solutions are available and supported worldwide.

In January 2007, Altair Engineering (Ann Arbor, Michigan) purchased Hicare, renamed the company, and began marketing the company’s technology more aggressively. Altair is a privately-held firm with an estimated $140 million in revenue in 2007.

The company’s official Web site is here. I found the pre-acquisition Web site more useful. It is here. Don’t let the Italian descriptions throw you. Google Translate makes short work of the language barrier.

What I find interesting is that innovations are coming from specialist firms often based outside the United States. I wrote about the Canadian outfit Infobright last week, now I want to talk about the Italian company HiQube (formerly HiCare).

The company’s technology is a proprietary database that combines three data management technologies in one system. You can manipulate data in a traditional relational form. You also can implement hierarchical data management. The approach I find most interesting is the company’s multi dimensional (n-cube) data managemnet system. If you are not sure of the differences among these types, let me offer a greatly simplified comment about each type:

  • Relational–The Codd database. Think of a table in DB2, Oracle, or SQLServer. Data reside in columns and rows.
  • Hierarchical–This is a structure in which records are organized as a tree or parent child relationship. Each child type is related to only one parent type
  • Multidimensional–This is a data structure that has three or more independent dimensions; for instance, sales by region by product and by time.

HiQube developed what it called the Lilith Enterprise and Web Server business intelligence software, a decision-making support system with unparalleled graphing and reporting capabilities for interactive visualization of information. Lilith, which reminded me of a character on a popular US television show, provides the ability to view and analyze captured data from multiple perspectives and user profiles. The system is available for on premises installation. You can also use the technology as a Web service.

HiQube’s new tag line is “Elevating data to knowledge”. Instead of exporting relational data from a table, transforming it, and reimporting it into a hierarchical form, you can flip from data management approach to data management approach without these steps. The HiQube system implements what the company calls a “business intelligence supply chain”. The idea is that the system imposes a sequence of actions upon the analyst. The pipeline approach minimizes the chance for error when moving through an analytic process. The six stages are importing data, data staging, calculating, simulations, building dashboard, and broadcasting the outputs. These last two steps allow an analyst to create a point-and-click report and assembling multiple reports into a heads-up, graphical display.

The HiQube system is able to ingest files in different formats. HiQube 5, the current version, can accept sparse and dispersed data in different formats. The system’s import tools provide controls to import only the data required for the analysis. Formats supported include

  • Text
  • Spreadsheet data
  • Data from an open system
  • SAP R/3 data and Matlab files.

HiQube’s transformation tools are interesting. These can integrate and roll up data during the import process. Once you have your data in its system you can manipulate the data in hierarchies, relationships, and dimensions.

A typical process can manipulate large amounts of data. HiQube’s presentations reference 22 million cells of data. You can view the data in hierarchies; for example, months, cities, and products. You can define formulae on the fly. Calculations are performed in real time. The system permits interactive “what if” analyses.

Other features of the system include:

  • Support for multiple inter-connected qubes and virtual qubes
  • Automatic qube reshaping and resizing
  • Numeric and non-numeric data types
  • Unlimited multi-dimensional calculations and write back functions

Analysts can build their own applications on top of a HiQube data set. HiQube provides more than 25 original charts Each is connected to the data engine. Any graphical object is browseable and drillable. You can animate chaarts if additonal sizzle is requried for a senior management presentation. Taking a page from enterprise publishing systems such as InfoPrint, HiQube can publish reports to the Web or generate a file suitable for traditional printing.

You can obtain a price quote from the company, which is based in Ann Arbor. The engineering team is in Torino, Italy. The restaurants alone are worth a tire-kicking trip.

Stephen Arnold, May 25, 2008

Comments

9 Responses to “HiQube: Another Business Intelligence System”

  1. duvall carter on July 19th, 2008 9:33 am

    hi. it was interesting reading the features of this product. i am a masters student and doing a research about the implementation of this type of BIS to a medium sized biofuels company in order help in making strategic business decisions. it may also include information from the internet either using rss feeds or other to have information on external forces that may affect their decisions as well. do you think this programme will be useful to a relatively small company like the one i am researching? can it read and automatically grab text (news etc) from the internet using specific keywords? any help you can give will be great!! thanks

  2. Stephen E. Arnold on July 19th, 2008 2:52 pm

    In general, small organizations are candidate for light weight solutions. Data are often in need of clean up and normalization. Small companies lack the resources to perform these types of tasks over time. Therefore, a simpler approach is often the better approach. When an organization has resources and management commitment behind an intelligence initiative, a more robust solution is required. Most systems can perform certains automatically. Unfortunately most systems require a data wrangler to intervene, fix up, and tweak the system. You can use a news reader to acquire content, and there are freeware and open source tools you can use to filter the retrieved or pushed content. New Idea Engineering and I are collaborating on a listing of such tools. Watch for an announcement on July 21, 2008, on this Web log.

    Stephen Arnold, July 19, 2008

  3. Shawn on January 30th, 2009 11:09 am

    Do you have an email newsletter?

  4. Stephen E. Arnold on January 30th, 2009 11:26 am

    Shawn,

    My clients receive emails with info and inside news as part of the deal with me. You get “free” information from this Web log and from the updates to my archive Web site http://www.arnoldit.com.

    Stephen Arnold, January 30, 2009

  5. HiQube Update : Beyond Search on February 15th, 2009 12:04 am

    […] Search miniprofiled HiQube here in May 2008 when it was launched as a new company. HiQube emerged from Hicare Research (http://www.hicare.it or http://www.hicare.com), which had […]

  6. Abel Alterio on October 12th, 2009 5:31 am

    Hi, just to let you know that Hicare is alive

    http://www.hicare.com/news.html

    Regards

  7. Abel Alterio on December 30th, 2009 2:51 am
  8. Sarah Jovencee on March 29th, 2010 3:02 pm

    To my knowledge, after about two years of partnership with an American company, Hicare Research has returned fully Italian. And so Lilith, first designed in1996 by PhD Roberto Marchisio, and now in release 6.

    An Italian product, ready and localized for the worldwide market.

    Sarah

  9. Massimiliano Cavallo on July 27th, 2011 10:23 am

    Hicare Research is up and running! Is fully Italian again since year 2008 and nowadays is about to unveil a new major release of Lilith!
    Since two months ago Hicare technology was listed and certified by the Italian Government, as “Italian Innovation”. Hicare received several International awards,
    thanks to Lilith, th HCR database technology and the new analytic applications.
    The software is effectively localized for the worldwide market.

    Anybody willing to deepen the technology can visit our web site.
    A White paper of the HCR® database written by Phd. R. Marchisio President of Hicare Research is available at the following the link:

    http://www.hicare.com/documenti/WP_Lilith6_B4.pdf

    Please write or call, I will be more than glad to answer your questions.

    Massimiliano Cavallo
    VP Hicare Research

  • Archives

  • Recent Posts

  • Meta