Posts by tag

Database

20 posts
View Post
  • 8 min

What’s New In Azure Data & AI: Azure Is Built For Generative AI Apps

OpenAI launched ChatGPT in December 2022, immediately inspiring people and companies to pioneer novel use cases for large language models. It’s no wonder that ChatGPT reached 1 million users within a week of launch and 100 million users within two months, making it the fastest-growing consumer application in history.1 It’s likely several use cases could transform industries across the globe. As you may know, ChatGPT and similar generative AI capabilities found in Microsoft products like Microsoft 365, Microsoft Bing, and Microsoft Power Platform are powered by Azure. Now, with the recent addition of ChatGPT to Azure OpenAI Service as well as the preview of GPT-4,…
View Post
Share
View Post
  • 4 min

Rapidly Expand The Reach Of Spanner Databases With Read-Only Replicas And Zero-Downtime Moves

As Google Cloud’s fully managed relational database that offers near unlimited scale, strong consistency, and availability up to 99.999%, Cloud Spanner powers applications at any scale in industries such as financial services, games, retail, and healthcare. When you set up a Spanner instance, you can choose from two different kinds of configurations: regional and multi-regional. Both configuration types offer high availability, near unlimited scale, and strong consistency. Regional configurations offer 99.99% availability and can survive zone outages. Multi-regional configurations offer 99.999% availability and can survive two zone outages and entire regional outages. Today, we’re announcing a number of significant enhancements…
View Post
Share
View Post
  • 2 min

Privacera Connects To Dremio’s Data Lakehouse To Aid Data Governance

The integration of open-source based Privacera into Dremio’s data lakehouse is designed to allow joint customer enterprises to manage and organize secure data access. Open-source based data governance and security SaaS provider Privacera on Tuesday said that it was integrating with Dremio’s open lakehouse to aid enterprise customers with data governance and data security. A data lakehouse is a data architecture that offers both storage and analytics capabilities, in contrast to data lakes, which store data in native format, and data warehouses, which store structured data (often in SQL format). The native integration between Privacera and Dremio, which comes at a time when lakehouses are gaining popularity, is designed…
View Post
Share
View Post
  • 2 min

Why Developers Choose Open Source In The Hybrid Cloud

Open source technology provides greater flexibility in hybrid and multi-cloud environments so that developers can focus on what’s most important—building with greater speed and innovation, all while using a tool they enjoy. The biggest barrier to growth and innovation is a stagnant data platform. Legacy proprietary systems aren’t technically viable for most enterprises anymore. The enhanced capabilities of adopting a cloud-centric, open source approach to database management systems are critical to thriving in today’s business landscape. I expect to see fully managed databases in the cloud, known as Database as a Service (DBaaS), become the standard in the next few…
View Post
Share
View Post
  • 6 min

Introducing Lock Insights And Transaction Insights For Spanner: Troubleshoot Lock Contentions With Pre-Built Dashboards

As a developer, DevOps engineer or a database administrator, you have to typically deal with database lock issues. Often, rows locked by queries cause lags and can slow down applications resulting in poor user experience. Today, we are excited to announce the launch of lock insights and transaction insights for Cloud Spanner that provide a set of new visualization tools for developers and database administrators to quickly diagnose lock contention issues on Spanner.If you observe application slowness, a common issue could be lock contentions, which happen when multiple transactions are trying to modify the same row. Debugging lock contentions is…
View Post
Share
View Post
  • 11 min

How To Build A Dynamic Distributed Database With DistSQL

Take a look at a data sharding scenario in which DistSQL’s flexibility allows you to create a distributed database. Distributed databases are common for many reasons. They increase reliability, redundancy, and performance. Apache ShardingSphere is an open source framework that enables you to transform any database into a distributed database. Since the release of ShardingSphere 5.0.0, DistSQL (Distributed SQL) has provided dynamic management for the ShardingSphere ecosystem. In this article, I demonstrate a data sharding scenario in which DistSQL’s flexibility allows you to create a distributed database. At the same time, I show some syntax sugar to simplify operating procedures,…
View Post
Share
View Post
  • 1 min

6 Database Trends To Watch

In a data-driven, global, always-on world, databases are the engines that let businesses innovate and transform. As databases get more sophisticated and more organizations look for managed database services to handle infrastructure needs, there are a few key trends we’re seeing. Here’s what to watch.   Source Google Cloud Blog
View Post
Share
View Post
  • 6 min

Are NoSQL Databases Relevant For Data Engineering?

SQL is great, but sometimes you may need something else. By and large, the prevalent type of data that data engineers deal with on a regular basis is relational. Tables in a data warehouse, transactional data in Online Transactional Processing (OLTP) databases — they can all be queried and accessed using SQL. But does it mean that NoSQL is irrelevant for data engineering? In this article, we’ll investigate use cases for which data engineers may need to interact with NoSQL data stores.   The reasons behind NoSQL These days, data is stored at such a velocity, volume, and variety (in short: Big…
View Post
Share
View Post
  • 3 min

Architecting Multi-region Database Disaster Recovery For MySQL

Enterprises expect extreme reliability of the database infrastructure that’s accessed by their applications. Despite your best intentions and careful engineering, database errors happen, whether that’s machine crashes or network partitioning. Good planning can help you stay ahead of problems and recover more quickly when issues do occur. This blog shows one approach of deploying a database architecture that implements high availability and disaster recovery for MySQL on Compute Engine, using regional disks as well as load balancers. Any database architecture must provide approaches to tolerate errors and recover from those errors quickly without losing data. These approaches are expressed in RTO (recovery…
View Post
Share
View Post
  • 2 min

InfluxData Announces Availability Of The Leading Time Series Platform On Google Cloud

InfluxData, creator of the time series database InfluxDB, announced the availability of InfluxDB Cloud on Google Cloud. The strategic collaboration, originally announced in April 2019, is part of a major Google Cloud initiative to make the most powerful open source technologies more accessible to its customer base. InfluxDB Cloud on Google Cloud delivers the leading time series platform to developers and businesses, with unified billing, support and integration with other Google Cloud services, such as BigTable, PubSub and Stackdriver. InfluxDB Cloud on Google Cloud is a serverless, purpose-built time series database-as-a-service with advanced analytics that provide real-time observability into IoT…
View Post
Share