illuminate solutions

Data warehouses that don't compromise™

 

   
 
 iLuminate
 
   
   
   
   








Home Products iLuminate

iLuminate—Build uncompromised data warehouses in a fraction of the time.

Single layer data warehouse and data management tools for dynamic queries

The iLuminate correlation database engine is used by more than 40 customers and ready for building nearly any size enterprise data warehouse, data mart or data management project warehouse. It replaces the complex, highly structured three-layer analytics system design with elegant data warehouse technology that strips it down to a single-layer to build a fast, flexible, and completely unified system. Nothing compares to its value-based storage (VBS) structure for delivering analytics systems that handle ad hoc analysis and dynamic queries. Not data warehouse appliances. Not column oriented databases. Not in-memory tools or OLAP cubes.

The iLuminate database engine has all the necessary data management tools to build and manage a data warehouse or data mart—with automated database design and no need for upfront user requirements definition. In fact, during the loading process, the data itself creates its own data-generated schema and all the data values are 100% indexed. On the fly.

When requirements change (and they always do), with iLuminate, there's no need to re-architect, reload, recalculate, re-optimize. . . no "re" anything.

Our complete suite of desktop data management tools gives you the ability to:

  • Load raw data from any source;
  • Handle all administrative tasks;
  • Manage the metadata; and
  • Connect to all ODBC-compliant data access tools.

iLuminate dramatically shortens the analysis, design and build phases.

  • The user requirements phase is short. There's no need to anticipate dynamic queries and reports in advance.
  • e logical design phase is short. There's no need for building star schemas, snowflake schemas, cubes or other structures.
  • The physical design phase is eliminated. There's no optimization or clustered storage on disk.
  • The build phase is highly automated. All decomposition and indexing is done on-the-fly during load-time and, in spite of this, data loads are fast and efficient.

Special Data Management Highlights:

  • Generates on the fly data-generated schemas for 100% of the data during the loading process for fast data warehouse builds.
  • Eliminates redundant data and compresses storage for a small, fast data warehouse.
  • Provides a "vertical view" of the data, while maintaining the typical "horizontal view" on a logical level for unlimited flexibility.
  • Maintains value-added dictionary information automatically for maximum usability, power and flexibility.
  • Provides fast "time-to-answer"—not just fast query results—due to our unique data management technology, which allows for:
    • Incremental Queries;
    • Associative Queries;
    • Dynamic Queries;
    • Auto-navigation through the data model;
    • Dynamic categorical fields and expressions for fast segmentation and data aggregation; and
    • Data mining capabilities embedded in the database.
  • Offers flexibility to make changes to the data model if needed.