Business Intelligence Compared to Analytic Queries?

Business intelligence systems are designed for predictable query profiles

• Well-defined data access needs
• Implementing query-aware data models
• Carefully constraining query workloads, complexities and schedules
• Co-locating data partitions for the “most important” joins

Analytical systems on the other hand need unconstrained, ad hoc access to data

• Data access paths are not known in advance
• Sympathetic data placement and organization is not possible
• Analysis requires wider and deeper access to data
• Query complexity is usually high

If you are struggling to get performance on your ad hoc analytical queries, then dbX is the solution for you.