in

A deep dive into Gemini in Databases


Yesterday, at Next ‘24, we announced a preview of Gemini in Databases — an AI powered database assistant that simplifies all aspects of database operations including assisted development, performance optimization, fleet management, governance, and migrations. With Gemini in Databases, companies no longer need to exclusively rely on people with specialized skills and custom resources to manage their databases — Google’s proactive AI assistant can help!

In most organizations, developers, database administrators, and platform engineers handle various aspects of database development and management. However, with the proliferation of databases to meet growing data processing demands, these experts are often overwhelmed by a myriad of database requirements, operational issues, and inefficiencies. Furthermore, with the rapid evolution in database technologies, developers are finding it hard to stay up-to-date with the latest development techniques, hampering both development quality and productivity. At the same time, “a majority (79%) of IT teams are now using more than one database platform, with 29% of respondents using more than five, and across a wide range of categories, IT professionals cite a lack of skills, knowledge gaps and a rapid need to upgrade and diversify their abilities at every level”.1Between developer productivity challenges, performance regressions, security and compliance vulnerability, and data migration difficulties, 82% of developers spend 30 minutes each day searching for solutions, according to a Stack Overflow survey.2

Gemini in Databases delivers an AI-powered assistant that helps across all stages of the database journey without development and operations teams needing to acquire specialized skills. With Database Studio, developers can build and deploy applications faster with the ability to generate, and summarize SQL code from simple natural language instructions. With Database Insights, operators can easily optimize performance by leveraging the insights and smart recommendations from the AI-powered assistant. With Database Center, platform engineers can manage entire fleets of diverse databases using the intelligent dashboards built with AI, proactively assessing availability, data protection, security, and compliance issues without any custom tools or processes. Finally, with Database Migration Service, database administrators can streamline and expedite their database migrations with automated code and database conversions. With Gemini in Databases, database professionals get all of these capabilities in a single offering supported by both visual and natural language interfaces, enabling them to simplify and de-risk database management. 

“As we are journeying into digital transformation, we are concerned about maintaining our pace of development due to the growing complexity of database environments that power our applications,” said Bogdan Capatina, Technical Expert in Database Technologies, Ford Motor Company. “We manage thousands of databases across hundreds of projects, which makes it extremely challenging to optimize performance and ensure security. Gemini in Databases is a game changer, bringing the power of assistive AI across the database journey. Now, we can get answers on fleet health in seconds instead of days and act on performance and security recommendations to proactively mitigate potential risks to our applications more swiftly than ever before.”

Accelerate application development 

With the increased focus on digital transformation and modernization of data platforms, developers who now frequently also perform the DevOps role are dealing with the increased burden to not only build, manage, and future-proof architectures, but also develop applications at a faster clip. 

Database Studio empowers developers to easily write and understand SQL with intelligent code assistance, code completion, and guidance directly in the editor. Developers can utilize the context-aware chat interface with natural language to build database applications faster using the SQL suggestions provided by the AI assistant. These assistive features can easily boost developer productivity especially in cases where developers are unfamiliar with a particular database dialect or are looking to optimize existing code for better performance and efficiency.

https://storage.googleapis.com/gweb-cloudblog-publish/images/Next24_Blog_blank_2-05.max-2500x2500.jpg

Accelerating AI Inference with Google Cloud TPUs and GPUs

https://storage.googleapis.com/gweb-cloudblog-publish/images/Next24_Blog_blank_2-05.max-2500x2500.jpg

Gemma on Google Kubernetes Engine deep dive