SAP IQ is a column-based, petabyte scale, relational database software system used for business intelligence, data warehousing, and data marts.
| FactSnippet No. 1,665,815 |
18 Facts About SAP IQ
1.
2.
SAP IQ is often credited with pioneering the commercialization of column-store technology.
| FactSnippet No. 1,665,816 |
3.
SAP IQ has an open interface approach towards its ecosystem.
| FactSnippet No. 1,665,817 |
4.
SAP IQ is integrated with SAP's Business Intelligence portfolio of products to form an end-to-end business analytics software stack, and is an integral component of SAP's In-Memory Data Fabric Architecture and Data Management Platform.
| FactSnippet No. 1,665,818 |
5.
When SAP IQ is used as an EDW, it can be augmented with HANA's in-memory technology.
| FactSnippet No. 1,665,819 |
6.
SAP IQ applies Lempel-Ziv-Welch compression algorithms to each data page when it is written to disk, to significantly reduce data volume.
| FactSnippet No. 1,665,820 |
7.
SAP IQ has a massively parallel processing framework based on a shared-everything environment that supports distributed query processing.
| FactSnippet No. 1,665,821 |
8.
However, the aforementioned storage architecture of SAP IQ allows compute and storage layers to scale out independently of each other and allows these resources to be provisioned on-demand for better utilization without restructuring the underlying database.
| FactSnippet No. 1,665,822 |
9.
SAP IQ uses a clustered grid architecture, which is made up of clusters of SAP IQ servers, or Multiplex.
| FactSnippet No. 1,665,823 |
10.
SAP IQ Loading Engine can be used for incremental batch, low latency, concurrent loading, and bulk loading.
| FactSnippet No. 1,665,824 |
11.
Lastly, SAP IQ introduces a write-optimized, Row Level Versioned Delta store which enables high-velocity data loads and fast availability of data to users.
| FactSnippet No. 1,665,825 |
13.
SAP IQ is an analytics engine that can query both structured and unstructured data and join the results together.
| FactSnippet No. 1,665,827 |
14.
The extensibility framework, called “in-database analytics” enables embedding of analytic functions inside the database engine of SAP IQ, moving analytics into the database, instead of to a specialized environment out of the database, a process which is error prone and slower.
| FactSnippet No. 1,665,828 |
15.
Pre-built functions are available natively and via partners of SAP IQ providing specialized statistical and data mining libraries that plug into SAP IQ.
| FactSnippet No. 1,665,829 |
16.
SAP IQ provides several features, both included in the base product and licensable separately, to help protect the security of the user's data.
| FactSnippet No. 1,665,830 |
18.
SAP IQ comes with web-enabled application drivers facilitating access to SAP IQ from a variety of Web 2.
| FactSnippet No. 1,665,832 |