Data warehouses that don't compromise™

 

 
 Overview
 
   
   
 
Incremental Queries  
 
 Associative Queries  
 
 Data Mining Compared  








Home Technology

Complex, highly structured analytics systems strangle ad hoc analysis.

Data warehouses started out as a good way to serve information needs with optimized reports. However, over the years, what has evolved is a complicated, three-layer information infrastructure of software, hardware, databases and all sorts of optimization techniques because people started demanding more than standardized reports.

Ironically, it's this complex hierarchy, which is inherently inflexible, that's killing users' ability to do ad hoc analysis. But for technology vendors that can't (or won't) think outside the box, it's a natural way to approach the problem—take something they know and evolve it. Add more layers. Create data warehouse appliances. Develop column oriented databases. Make it better, faster, cheaper.

Simplicity frees the data for 100% ad hoc analysis flexibility.

Unlike relational and column oriented databases; OLAP cubes and star schemas; and data warehouse appliances, illuminate's advanced data warehouse design using correlation database technology delivers all the capabilities and performance found in these highly structured three-layer infrastructures in a single layer. For complete ad hoc analysis and data analytics flexibility. All without the complications of figuring out in advance what relationships to keep or not. What data to include or not. Which queries are important or not. Everything is included. Everything is important. Unless the user says it's not.

With an automated database design and a fully indexed, compact database, users can explore and discover until they are satisfied. Our desktop tools give them powerful, unique query types to find what they want, in the way they think: Incremental queries and Associative queries.



three-layer information infrastructure

A single level analytics infrastructure is inherently fast and has total access flexibility.

single-layer information infrastructure