BT
rss

Improving Azure SQL Database Performance Using In-Memory Technologies

by Kent Weare on  Jan 21, 2017 4

In late 2016, Microsoft announced the general availability of Azure SQL Database In-Memory technologies. In-Memory processing is only available in Azure Premium database tiers and provides performance improvements for On-line Analytical Processing (OLTP), Clustered Columnstore Indexes and Non-clustered Columnstore Indexes for Hybrid Transactional and Analytical Processing (HTAP) scenarios.

Olap4j 1.0: a Java API for OLAP Servers

by Charles Humble Jai Hirsch on  Jun 24, 2011

Business Intelligence vendor Pentaho has announced the release of olap4j 1.0, a new, common Java API for any online analytical processing (OLAP) server.

Column-based Storage in SQL Server 2011

by Jonathan Allen on  Mar 07, 2011 4

Imagine ad hock data mining queries against a single table with 1 TB of data and 1.44 billion rows coming back in roughly a second. This is the scenario Microsoft intends to support using 32-core machines and their new column-based storage engine.

BT