InfoQ Homepage Columnar Databases Content on InfoQ
News
RSS Feed-
Google Spanner Unifies OLTP and OLAP with Columnar Engine
Google Spanner now features a columnar engine, allowing its distributed database to handle both OLTP and OLAP workloads on a single platform. This hybrid architecture eliminates the need for separate data warehouses and ETL pipelines. The engine's columnar storage and vectorized execution accelerate analytical queries up to 200x on live data, which is especially beneficial for AI applications.
-
Time Series Database QuestDB 8.0 Improves SQL Performance and Adds ZFS Compression
Version 8 of QuestDB, an open-source time series database designed for high-performance and efficient handling of time series data, has been released. This release includes a new VARCHAR data type as a default (over STRING) that aims to provide better compression and performance, a 50% improvement for SQL query performance, and data compression via system-level ZFS
-
InfluxData Releases Its New Database Engine in InfluxDB Cloud
InfluxData releases into general availability the new version of its database engine called Influx IOx. It is now available to be used in InfluxDB Cloud.
-
Amazon Announces the Open Preview of a Managed Apache Cassandra Service (MCS) on AWS
At the recent AWS re:Invent, Amazon announced a new way of managing Cassandra databases on AWS. With Amazon Managed Apache Cassandra Service (MCS), the public cloud vendor can offer Cassandra directly to customers instead of through third-party vendors.
-
Julien Le Dem on the Future of Column-Oriented Data Processing with Apache Arrow
Julien Le Dem, the PMC chair of the Apache Arrow project, presented on Data Eng Conf NY on the future of column-oriented data processing. Apache Arrow is an open-source standard for columnar in-memory execution. InfoQ interviewed Le Dem to find out the differences between Arrow and Parquet.
-
SQL Server 2016: Clustered Columnstore Index Enhancements
Clustered Columnstore Indexes were one of the two headline features for SQL Server 2014. Designed for tables with over 10 million rows, they allow for good performance on analytical queries without the need to explicitly specify indexes. With SQL Server 2016, they gain the ability to support secondary indexes.
-
SQL Server 2016: Updatable, Non-Clustered Columnstore Indexes
Non-clustered Columnstore Indexes are also getting some enhancements in SQL Server 2016. The most notable of these enhancements is the ability to be updated.
-
SQL Server 2016: In-Memory Columnstore Indexes
New for SQL Server 2016 is the ability to place a Columnstore Index on an In-Memory Table.
-
Oracle Database Gets In-Memory
Oracle Database 12c Release 1 (12.1.0.2) is now available and includes the much anticipated “In-memory” feature, along with several other improvements.
-
Precog: Big Data Analytics as a Service
Precog has recently announced a Big Data warehousing and analysis service which takes care of the data capture, storage, transformation, analysis and visualization process and the infrastructure on which it runs, but leaving open various access points throughout the service via RESTful APIs enabling developers and data scientists to control the entire process.