Google Announces Downloadable AlloyDB
Written by Kay Ewbank   
Monday, 03 April 2023

Google has announced a preview of AlloyDB Omni, a downloadable edition of AlloyDB designed to run on premises, or in the cloud. The developers say AlloyDB Omni offers similar benefits to AlloyDB, including high performance, PostgreSQL-compatibility, and Google Cloud support.

AlloyDB was developed by taking the PostgreSQL API and extending it with Google's own machine learning, AI and storage features. It automates administrative tasks such as backups, replication, patching, and capacity management and uses adaptive algorithms and machine learning for PostgreSQL vacuum management, storage and memory management, data tiering, and analytics acceleration.

 googlecloudlogo

 

AlloyDB Omni is based on the same engine as the cloud-based AlloyDB service, and Google says in its tests AlloyDB Omni is more than two times faster than standard PostgreSQL for transactional workloads, and delivers up to one hundred times faster analytical queries than standard PostgreSQL.

The AlloyDB team says that like the AlloyDB managed service, Omni provides improved transactional performance compared to standard PostgreSQL, accelerated analytical processing, automatic vacuum and memory management, and an index advisor that helps optimize frequently run queries.

The index advisor is designed to take the guesswork out of tuning query performance. It does this by analyzing the different parts of a query including subqueries, joins, and filters. It periodically analyzes the database workload, identifies queries that can benefit from indexes, and recommends new indexes that can increase query performance.

AlloyDB Omni also includes the AlloyDB columnar engine, which keeps frequently queried data in an in-memory columnar format for faster scans, joins, and aggregations.

Omni uses machine learning to automatically organize data between row-based and columnar formats, converting the data when needed, and to choose between columnar and row-based execution plans.

There's a free developer edition of AlloyDB Omni that's available for download now.

 
 googlecloudlogo

More Information

AlloyDB

AlloyDB Omni

Related Articles

AlloyDB For PostgreSQL Now Generally Available

Google Announces AlloyDB To Free Users From Legacy Databases

 

To be informed about new articles on I Programmer, sign up for our weekly newsletter, subscribe to the RSS feed and follow us on Twitter, Facebook or Linkedin.

Banner


Apache Superset 4 Updates Reports
15/04/2024

Apache Superset 4 has been released with improvements to the reporting module and redesigned alerts. Superset is a business intelligence web application. It is open source, provides data exploration a [ ... ]



Redis Changes License, Rival Fork Launched
03/04/2024

The developers of Redis have announced that they are changing the licensing model for the database. From now on, all future versions of Redis will be released with source-available licenses rather tha [ ... ]


More News

raspberry pi books

 

Comments




or email your comment to: comments@i-programmer.info

Last Updated ( Monday, 03 April 2023 )