Tag: Databases

AI Databases Generative AI Official Blog Partners Sept. 16, 2024

Brewing innovation: Google Cloud and Oracle powering AI-driven experiences - Coffee Nirvana, an AI-powered solution built on Oracle Database on Google Cloud, simplifies the search for the perfect coffee by understanding nuanced taste preferences and providing real-time inventory information. It leverages Retrieval Augmented Generation (RAG) to deliver personalized recommendations and integrates with Google Maps for visualizing stockists.

AlloyDB Databases GCP Experience Official Blog Web3 Sept. 9, 2024

Galxe migrates to Google Cloud AlloyDB for PostgreSQL, cutting costs by 40% - Galxe, a Web3 company, migrated from Amazon Aurora to Google Cloud's AlloyDB for PostgreSQL, cutting costs by 40%.

Cloud Memorystore Databases Official Blog Sept. 2, 2024

Google Cloud launches Memorystore for Valkey, a 100% open-source key-value service - Google Cloud launches Memorystore for Valkey, a fully-managed, open-source key-value service. It offers high performance, scalability, and adaptability, and is compatible with Redis 7.2 and popular Redis clients.

Cloud Bigtable Data Analytics Databases Official Blog Aug. 26, 2024

Distributed counting in Bigtable: why you need it, and how to get started - Bigtable, Google's NoSQL database, now offers powerful tools that simplify data aggregation and enhance analytics capabilities. By enabling calculations in the database at write-time, Bigtable saves time, reduces complexity, and provides instant access to critical insights. It offers aggregate types like SUM, MIN, MAX, and HyperLogLog (HLL) for approximate unique value counting.

Cloud Bigtable Cloud Memorystore Cloud Spanner Cloud SQL Databases Official Blog Aug. 26, 2024

Google Cloud database news roundup, August 2024 edition

Cloud Spanner Databases Official Blog Aug. 19, 2024

Farewell to overprovisioning: How to unlock cost-effective elasticity with Spanner - Explanation of Cloud Spanner auto-scaling functionality.

Cloud SQL Databases Official Blog Aug. 19, 2024

Query your data in seconds with Cloud SQL Studio - Cloud SQL Studio, a lightweight tool to query your database directly from the console, is now generally available for MySQL, PostgreSQL, and SQL Server. It offers a consistent and intuitive user interface, simplifies connectivity and security, and enhances productivity with features like an AI assistant for query writing.

Cloud Spanner Databases Official Blog Aug. 12, 2024

Introducing Approximate Nearest Neighbor (ANN) search to Spanner - Spanner now supports Approximate Nearest Neighbor (ANN) search, enabling fast and scalable vector search for large datasets. This capability is particularly useful for unstructured data like images, text, or audio, where traditional search methods may not be as effective. Spanner's ANN search leverages Google Research's ScaNN algorithm and offers optimizations such as tree-like structure clustering, quantized embeddings, and optimized distance calculation.

Cloud Bigtable Databases GCP Experience Official Blog Aug. 12, 2024

The Bigtable Advantage: How Flipkart gets the most out of every byte - Flipkart's transition to Bigtable has brought unprecedented efficiency and flexibility, ensuring a seamless shopping experience for their millions of customers. Scaling up or down is simplified with a single click in the user interface, enhancing the resource management experience — the platform scaled up 4X during its Big Billion Day event with no capacity concerns or performance impact.

AlloyDB Cloud SQL Databases Official Blog Vertex AI Aug. 12, 2024

Announcing LangChain on Vertex AI for AlloyDB and Cloud SQL for PostgreSQL - AlloyDB and Cloud SQL for PostgreSQL now support LangChain on Vertex AI, enabling developers to build, deploy, query, and manage AI agents and reasoning frameworks in a secure, scalable, and reliable way. This integration unlocks new database use cases such as querying databases, knowledge retrieval, chat bots, and tool use. It also provides fast knowledge retrieval, secure authentication and authorization, chat history context, and fast prototyping.

Cloud Bigtable Data Analytics Databases Official Blog Aug. 5, 2024

Bigtable transforms the developer experience with SQL support - Bigtable, a fast and flexible NoSQL database used by Google services like Search and YouTube, now supports GoogleSQL, an ANSI-compliant SQL dialect. With over 100 SQL functions at launch, Bigtable SQL support makes it easier to analyze and process large amounts of data directly within Bigtable, unlocking its potential for a wider range of use cases. Key use cases include NoSQL migrations, interactive and ever-changing data, low-latency lookup of non-uniform data, BigQuery serving layer, SQL-based time-series solutions, and write-time aggregates.

Cloud SQL Database Migration Service Databases Official Blog Aug. 5, 2024

Accelerate PostgreSQL migrations to Google Cloud: move terabytes of data with Database Migration Service - Database Migration Service (DMS) offers a comprehensive way to migrate data to Google Cloud databases, including PostgreSQL to Cloud SQL and AlloyDB. To improve migration speeds, you can adjust settings for parallel initial load and change data capture (CDC), configure PostgreSQL database parameters, and optimize machine and network configurations. For example, setting the `max_wal_size` parameter on the destination instance to a range of 20GB-50GB can reduce checkpoint frequency and improve resource allocation for migration processes. Additionally, increasing the `shared_buffers` parameter on the source instance to 60% of RAM can enhance initial load performance.

Cloud SQL Databases Official Blog Aug. 5, 2024

Cloud SQL Enterprise Plus delivers enhanced performance, availability and disaster recovery for SQL Server - Cloud SQL Enterprise Plus for SQL Server is now generally available. It delivers enhanced performance with two new machine families, a data cache for improved read performance, advanced disaster recovery capabilities, and a 99.99% availability SLA. You can create a new instance of Cloud SQL Enterprise Plus using the Google Cloud console, CLI, or API. You can also upgrade your existing Cloud SQL for SQL Server instance in-place to the new Cloud SQL Enterprise Plus edition with minimal downtime.

Cloud Spanner Databases Official Blog Aug. 5, 2024

Introducing Spanner Graph: Graph databases reimagined - Spanner Graph reimagines graph data management by seamlessly integrating graph, relational, search, and AI capabilities with virtually unlimited scalability. It supports the ISO Graph Query Language (GQL) for intuitive graph pattern matching and traversal, and offers full interoperability between GQL and SQL, breaking down data silos and empowering developers to choose the optimal tool for each query. Spanner Graph also features built-in vector and full-text search capabilities, enabling efficient retrieval of graph data using semantic meaning and keywords.

Cloud Spanner Databases Official Blog Aug. 5, 2024

Unlock the potential of your data: Build reliable and intelligent applications with Spanner editions - Spanner, Google's globally consistent database, introduces new editions with enhanced capabilities like Spanner Graph, full-text search, and vector search. Spanner editions offer a tiered pricing model with Standard, Enterprise, and Enterprise Plus options, providing cost transparency and optimization. The Standard edition includes all current generally available features, while Enterprise edition adds multi-model capabilities and Enterprise Plus offers the highest availability and data sovereignty features. Spanner editions will be available starting September 24, 2024.

Cloud Bigtable Cloud Spanner Cloud SQL Databases Official Blog Aug. 5, 2024

Can’t stop, won’t stop: More innovations from the Google Cloud database portfolio - Google Cloud is introducing several new capabilities to make it easier for customers to build intelligent AI apps with Spanner, including Spanner Graph, vector search, and advanced full-text search. Bigtable SQL support and Bigtable distributed counters are also announced to transform the developer experience. Cloud SQL Enterprise Plus edition for SQL Server is launched, delivering improved read performance, higher availability, and advanced disaster recovery. A new strategic partnership with Oracle is formed to host Oracle database services within Google Cloud data centers, enabling easy migration of Oracle-based applications to Google Cloud.

Cloud SQL Data Analytics Databases Dataplex Official Blog Aug. 5, 2024

Unlocking the power of your Cloud SQL data with Dataplex Catalog - Cloud SQL customers can now easily catalog their Cloud SQL data within Dataplex Catalog, Google Cloud’s next-generation data asset inventory platform. This integration provides a centralized repository for all Cloud SQL assets, allowing users to easily search, browse, and explore their Cloud SQL data.

Cloud SQL Databases IAM Official Blog Aug. 5, 2024

Announcing IAM group authentication in Cloud SQL - Cloud SQL IAM group authentication allows customers to use Google Cloud Identity groups to manage access to Cloud SQL instances and databases.

Databases GCP Experience Official Blog Aug. 5, 2024

Maxxton improves app performance up to 60% with Bare Metal for Oracle on Google Cloud - Maxxton, a provider of property management systems for the hospitality industry, improved app performance by up to 60% by migrating to Bare Metal Solution for Oracle on Google Cloud.

Data Analytics Databases Datastream Official Blog Streaming July 29, 2024

Datastream’s SQL Server source is generally available - Datastream, a serverless change data capture (CDC) and replication service, now supports SQL Server as a source for replicating data to BigQuery, Cloud Storage, and other Google Cloud destinations. Key enhancements include change tables CDC, stream recovery, gcloud API and Terraform support, and server-side SSL/TLS encryption.

Cloud Spanner Databases Official Blog July 29, 2024

Introducing Spanner dual-region configurations that help maintain high availability and data residency - Spanner dual-region configurations are now available in Australia, Germany, India, and Japan. These configurations help maintain high availability and data residency by replicating data to two regions within the same country. In the event of a zone outage, Spanner still maintains a quorum of at least two replicas in each region, ensuring database availability. If an entire region goes down, Spanner automatically fails over to single-region mode to maintain availability.

Cloud Bigtable Data Analytics Databases Infrastructure Official Blog July 22, 2024

One database to rule them all with Bigtable hybrid transactional and analytical processing (HTAP) - Bigtable recently added distributed counters, request priorities, write flow control, and Data Boost features to make it easier to perform both OLAP and OLTP with a single database. These features can help you spread your batch jobs out over time with greater reliability and reduced operational management, use fewer resources, and avoid impacting your serving workload.

AlloyDB Databases GCP Experience Official Blog July 22, 2024

Endear seamlessly integrates vast data sources with AlloyDB - Endear, an omnichannel CRM platform, migrated from Cloud SQL to AlloyDB for PostgreSQL to handle increasing demand and provide real-time insights to clients.

AlloyDB Databases GCP Experience Official Blog July 22, 2024

SEEBURGER BIS on AlloyDB: A secure, scalable business-critical integration platform - SEEBURGER BIS Platform, a leading integration platform, has chosen AlloyDB for PostgreSQL as its cloud database of choice. AlloyDB's seamless PostgreSQL compatibility, enhanced scalability, reduced operational overhead, and deployment flexibility make it an ideal fit for SEEBURGER's needs.

Cloud Spanner Databases Official Blog July 22, 2024

New Spanner geo-partitioning improves performance and lowers costs - Spanner geo-partitioning improves performance and lowers costs by allowing you to partition your table data at the row-level, across the globe, to serve data closer to your users.

Cloud SQL Databases GCP Experience Official Blog July 15, 2024

Digital Manager Guru processes over 24M transactions with Cloud SQL Enterprise Plus - Digital Manager Guru, an online sales platform provider, processes over 24 million transactions using Cloud SQL Enterprise Plus. Cloud SQL for MySQL Enterprise Plus powers transactions, ensuring high performance and reduced latency.

AlloyDB Databases GCP Experience Official Blog July 15, 2024

How AlloyDB transformed Bayer’s data operations - Bayer Crop Science migrated to AlloyDB for PostgreSQL to handle a dramatic increase in traffic to its Field Answers data solution. AlloyDB's architecture significantly reduced the impact of scaling read traffic, improving performance and ensuring low replication delay. The migration allowed Bayer to meet growing demands and focus on innovation without being hindered by database limitations.

Cloud SQL Databases Official Blog July 15, 2024

New Cloud SQL upgrade tool for MySQL & PostgreSQL major versions and Enterprise Plus - Google Cloud has introduced a new automated Cloud SQL upgrade tool for major versions and Enterprise Plus. This tool simplifies the process of upgrading MySQL and PostgreSQL databases, reducing complexity, time, and errors.

AlloyDB Databases Official Blog July 15, 2024

Announcing AlloyDB free trial clusters: your playground for PostgreSQL innovation - AlloyDB free trial clusters provide you with the time and resources you need to perform a full-blown trial of AlloyDB, with a powerful 8 vCPU and 64 GB RAM primary instance and 1 TB of regional storage. sz.

Database Migration Service Databases Official Blog July 8, 2024

Migrate specific MySQL databases using Database Migration Service - Learn how to migrate a subset of databases and tables from different sources, including on-premises MySQL, Cloud SQL for MySQL, and Amazon RDS for MySQL.

AlloyDB Databases GCP Experience Official Blog July 8, 2024

Harnessing the potential of massive NeuroPace brain data sets with AlloyDB Omni - NeuroPace, a medical device company, collaborated with Google Cloud engineers to explore the potential of AlloyDB Omni, a vector database, for efficient analysis of massive iEEG data sets. By converting iEEG data into vectors and storing them in AlloyDB, they achieved fast and scalable similarity searches, enabling physicians to find similar patient profiles for optimizing stimulation settings.

Databases Networking Official Blog Partners July 8, 2024

Expanding the Cross-Cloud Network: the Google Cloud partnership with Oracle Cloud Infrastructure - Google Cloud and Oracle have partnered to provide private, secure, flexible, reliable, and low-latency connections between their respective cloud platforms. This partnership enables customers to build distributed applications, deliver global front-ends, and secure access for the hybrid workforce across Google Cloud and Oracle Cloud Infrastructure (OCI).

Databases GCP Experience Official Blog July 8, 2024

Loyal Guru slashes query latency by 40-50% with AlloyDB for PostgreSQL - Loyal Guru, a loyalty and offer personalization platform, uses Google Cloud's scalable and secure architecture to help its retail customers deliver highly personalized experiences in real time. By leveraging Google Cloud databases like AlloyDB for PostgreSQL, the company overcame performance bottlenecks and reduced query latency by 40-50%.

AlloyDB Cloud Logging Cloud SQL Databases Official Blog July 1, 2024

Create custom metrics for Cloud SQL for PostgreSQL and AlloyDB using Logs Explorer - Custom log-based metrics allow you to monitor specific conditions or errors in your PostgreSQL database running on Cloud SQL or AlloyDB. You can create custom metrics using Logs Explorer by defining a metric name, type, and expression that filters the logs for the desired information. This enables you to track and analyze specific events, such as duplicate key violations, long-running queries, or data access-related metrics. You can also set up alerts based on these custom metrics to receive notifications when certain conditions are met.

Cloud Memorystore Databases GCP Experience Official Blog July 1, 2024

Character.AI's storybook ending with Memorystore for Redis Cluster - Character.AI, a leader in personalized AI, shares its journey of optimizing its caching layer using Google Cloud's Memorystore for Redis Cluster. The company's mission is to create empathetic and personalized AI-powered Characters, ranging from historical figures to user-generated personas. To enhance user engagement and application responsiveness, Character.AI transitioned from a single Memorystore instance to a sharding proxy and eventually implemented ring hashing in the application layer. The migration to Memorystore for Redis Cluster simplified their architecture, eliminated the need for external sharding mechanisms, and ensured predictable low latencies and zero-downtime scalability.

AlloyDB Cloud Firestore Cloud Memorystore Databases Official Blog June 24, 2024

What’s new with Google Cloud databases — June 2024 edition - Google Cloud has released several updates to its database services, including vector search support across AlloyDB, Spanner, Cloud SQL, Memorystore for Redis, and Firestore. Gemini in Databases, an AI assistant, simplifies database management and development.

Cloud SQL Databases Official Blog June 17, 2024

What’s new with Cloud SQL for MySQL: Vector search, Gemini support, and more - Cloud SQL for MySQL now offers integrated support for vector embedding search, allowing you to build innovative generative AI applications and AI-assistive tools. It also introduces Gemini, a comprehensive database management tool that helps you optimize, manage, and debug your MySQL database.

Cloud SQL Databases GCP Experience Official Blog June 17, 2024

Lightricks boosts search retrieval rates by 40% with vector support in Cloud SQL - Lightricks, a company that develops photo and video creation apps, enhanced its search functionality using Cloud SQL for PostgreSQL with pgvector support. By leveraging vector embeddings, Videoleap, Lightricks' video editor, improved its search capabilities and boosted retrieval rates by 40%.

Cloud SQL Databases GCP Experience Official Blog June 17, 2024

Build gen AI apps quickly with LangChain VectorStore in Cloud SQL for PostgreSQL - The Cloud SQL for PostgreSQL LangChain package makes it easy to build generative AI applications with VectorStore, Document Loaders, and Chat Message Memory. It offers secure connections with IAM authorization, convenience with just instance name connection, connection pooling by default, and schema flexibility with table per collection and support for indexing.

Databases Infrastructure Official Blog Partners June 17, 2024

Accelerating cloud transformation with Google Cloud and Oracle - Google Cloud and Oracle have announced a new strategic cloud partnership that enables customers to seamlessly migrate and run mission-critical enterprise workloads across Google Cloud and Oracle Cloud Infrastructure (OCI). This partnership includes the Oracle Database@Google Cloud, where Oracle will directly host, operate, and manage Oracle database services natively within and from Google Cloud data centers. Customers can also interconnect Oracle Cloud Infrastructure (OCI) and Google Cloud without any cross-cloud data transfer charges and run Oracle Applications on Google Cloud such as Oracle E-Business Suite.

Cloud SQL Databases Official Blog June 10, 2024

What’s new in PostgreSQL 16: New features available in Cloud SQL today - PostgreSQL 16 is now available in Cloud SQL, bringing new features for deeper insights into database operations and enhanced usability. Improvements include observability enhancements such as the pg_stat_io view for Input/Output (IO) behavior, last_seq_scan and last_idx_scan columns in pg_stat_*_tables for tracking sequential and index scans, and n_tup_newpage_upd column in pg_stat_*_tables for monitoring updates.

Cloud SQL Databases Official Blog June 10, 2024

Enhance business continuity for your on-premises SQL Server instance with Cloud SQL for SQL Server - Cloud SQL for SQL Server can be used as a disaster recovery (DR) instance for on-premises SQL Server instances. This can be achieved by setting up replication of regular backups to Cloud SQL for SQL Server.

Cloud SQL Databases Official Blog June 3, 2024

Introducing Cloud SQL extended support for MySQL and PostgreSQL end-of-life versions - Cloud SQL now offers extended support for end-of-life MySQL and PostgreSQL versions, ensuring business continuity and security while organizations prepare for major version upgrades. Starting February 1, 2025, Cloud SQL instances running unsupported versions will automatically enter extended support, receiving security fixes, bug fixes, and SLA coverage for three years. Extended support is a paid service with pricing details to be announced by August 15, 2024. Customers can opt out of extended support at any time and upgrade to a supported version.

Cloud SQL Databases Official Blog Vertex AI May 27, 2024

Cloud SQL: Rapid prototyping of AI-powered apps with Vertex AI - The Google-ml-intergration extension for Cloud SQL for PostgreSQL allows developers to easily generate vectors from textual data, perform efficient search over a large corpus of vectors, and fetch real-time predictions directly within their SQL queries.

Cloud Firestore Databases Eventarc Official Blog Serverless May 20, 2024

Firestore integration with Eventarc reaches GA with Auth Context

AlloyDB Cloud SQL Databases Official Blog May 13, 2024

AlloyDB vs. self-managed PostgreSQL: a price-performance comparison

BigQuery Cloud Data Fusion Cloud SQL Databases Official Blog May 13, 2024

Building a Cloud Data Fusion pipeline to upload audit records generated by Cloud SQL for SQL Server to BigQuery - Data Fusion pipeline the steps to output audit records to internal or external sinks with minimal coding.

Cloud Spanner Databases Official Blog May 13, 2024

How chaos testing adds extra reliability to Spanner’s fault-tolerant design

Cloud SQL Databases Official Blog May 13, 2024

Cloud SQL for PostgreSQL data cache under the hood

Active Assist Databases Official Blog May 13, 2024

What’s new with Active Assist: New Hub UI and four new recommendations

Cloud Spanner Databases Official Blog May 6, 2024

Uncomplicating the complex: How Spanner simplifies microservices-based architectures

Databases GCP Experience Official Blog May 6, 2024

Enhancing iEEG seizure identification and similarity search with Google Cloud

Databases Migration Official Blog April 29, 2024

Modernization vs. migration for data workloads - Migrating data to the cloud (lift-and-shift) is an option, but modernizing your data workloads with cloud-native technologies offers greater benefits. Modernization improves scalability, security, and performance while reducing costs through serverless technology. Google's Database Modernization program can help you with the process.