Google has updated two of its most popular cloud databases. These are the Google Cloud Spanner and Cloud BigTable databases. That’s what Silicon Angle reports.

Cloud Spanner is a relational database, just like PostgreSQL and MySQL. Virtually all enterprise, gaming and SaaS applications today run on such relational databases. The new update offers more functionalities for users who query in Cloud Spanner via the SQL data manipulation language, which is the standard way to communicate with the database.

Google added the INSERT, UPDATE and DELETE SQL statements. This should make it easier to read and add data in Cloud Spanner. Furthermore, the database has received a new version of the JDBC driver.

“This update makes it easier to reuse existing code and tool chains, so you can integrate with popular object-relational mappers,” says product managers Deepti Srivastava and Misha Brukman. “This reduces the learning curve for new users and makes porting of existing applications easier.”

Cloud BigTable

Cloud BigTable is Google’s fully managed NoSQL key value and wide-column database service. This service is especially useful for time-series, graph and IoT workloads. It offers higher throughput and lower latency than traditional databases.

The update brings BigTable a new Key Visualizer function. According to Srivastava and Brukman, this should provide a better insight into the behaviour of applications. The feature was requested by developers to enable better schema and performance optimization with BigTable.

The feature works by debugging performance issues in BigTable, and visualizing them through a heat map that allows administrators to quickly identify the cause of problems.

“Key Visualizer has helped many teams at Google and Google Cloud users by giving them insight into their database usage patterns, without impacting the capabilities of the database itself,” says Srivastava and Brukman. “This means that you can design and improve your data model to take full advantage of the horizontal scalability of our GCP services.”

This news article was automatically translated from Dutch to give Techzine.eu a head start. All news articles after September 1, 2019 are written in native English and NOT translated. All our background stories are written in native English as well. For more information read our launch article.