Using SQL for Deep AnalyticsHistorically, SQL has not been a viable option for large data analytics because databases have not been able to deliver required performance and scalability for ad hoc queries. Databases are designed for transaction-like business intelligence queries – relatively simple, short running queries. Implemented for pre-defined data access paths, databases are unable to support ad hoc, unconstrained data access.
To do SQL based deep analytics and data exploration, a database system must support:
|





