|
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.
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 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.
|
A single level analytics infrastructure is inherently fast and has total access flexibility.
|
