Connect with us

Tech

Google announces AlloyDB, a faster host version of PostgreSQL

Published

on

 


We are excited to bring Transform 2022 back in person from July 19th, effectively July 20th to 28th. Join an AI and data leader for insightful talk and exciting networking opportunities. Register today!

Data-intensive users will have access to new options for storing information in the cloud. Google Cloud Platform (GCP) today announced a new database option called AlloyDB, built around the PostgreSQL open source database that has been popular with developers for over 30 years.

The new database is designed to appeal to users with a code stack that relies on a full-featured database that offers options such as atomicity, consistency, isolation, durability (ACID) -compliant transactions, stored procedures, and triggers. increase. The Google team believes that by offering classic features in the latest cloud-native packages, it will compete directly with legacy products from companies such as Oracle, IBM, and Microsoft.

There are many customers, such as travel agencies, retailers, car makers, financial services, etc., who have purchased these very expensive proprietary databases and are free from them and trying to move to open source. Andi Gutmans, general manager and vice president of databases on Google Cloud, explained.

PostreSQL in the cloud

The PostgreSQL platform is a popular option due to its powerful performance, wide feature set, and large community of developers. Open source licenses are attractive because users feel less tied to one company. If contract terms or prices become high, you can move to another service provider that supports your product or form a team within your company.

According to Gutmans, you can guess why your customers want to move. The cost is certainly part, but there are many exorbitant license terms. They have an audit being done on them. There are many unfriendly practices.

The new version of Google will be hosted in the cloud and priced as a service. The new pricing model is simpler and designed to avoid hidden charges that often result in unexpectedly high billing. For example, their model does not charge I / O, which is a common surcharge for some other contracts from cloud providers such as Amazon Web Services (AWS).

Google’s new product has joined several other companies building database products around PostgreSQL. Some cloud providers such as DigitalOcean, Vultr and AWS are deploying managed versions of popular open source databases such as MySQL, Redis and PostgreSQL. These products provide a stock version of your database while handling many of the chores of installing software, configuring your server, and keeping your server up-to-date with the advent of new security patches.

Meanwhile, other companies are building more complex versions around open source databases, adding some new features that allow them to create new brands. Companies such as Yugabyte and Fly.io are creating versions of PostgreSQL that can be extended to support large datasets distributed around the world. They manage many of the chores of synchronizing data between different instances and shards. Something like Oracle or Planet Scale is doing something similar to another popular open source option, MySQL.

Google will set itself apart with faster performance and solid service level agreements. They have rewritten some core storage routines to speed up both transactional and analytic queries. Their first internal benchmarks suggest that their version will be four times faster than standard PostgreSQL and twice as fast as Amazons Aurora. This is another competitor that follows a similar path.

It also contains a column accelerator that stores the dataset in the column. This is an approach that can speed up complex searches and queries. Analytical tasks such as reporting and monitoring critical anomalies are often performed more efficiently in environments where data is stored in columns, but transactions are faster when data is stored in rows. Will be. AlloyDB provides users with the ability to configure storage to support their usage patterns.

Customers want to analyze their data in real time to make additional decisions very quickly, such as personalization and fraud detection, Gutmans explains. Since we actually added the analysis function, we have a hybrid system of transaction and analysis.They can perform analysis up to 100 times faster [stock] Open source PostgreSQL.

Integration and compatibility

Google has also integrated its database with Vertex AI. This is one of the options for building and deploying machine learning models. Developers will be able to work directly with these models using queries and stored procedures.

PostgreSQL is popular because the community has created a number of extensions that add functionality to specific applications. For example, map makers and developers working with location data rely on PostGIS, a version optimized for storing and retrieving a collection of points specified by latitude and longitude.

[Compatibility] In fact, it was our core design principle. Gutmans said. That’s why we decided to adopt and extend PostgreSQL instead of building a PostgreSQL compatible system. The spanner has a PostgreSQL API, right? However, you can’t build it to be 100% compatible, so what we’ve done here is to stay true to PostgreSQL.

Gutmans predicts that AlloyDB will start with support for more than 50 of the most popular extensions and add new extensions as customers request.

What executives have said so far

AlloyDB is fully compatible with PostgreSQL and can transparently extend columnar processing. Takuya Ogawa, lead product engineer at Plaid, who is testing the pre-release version of Google, said he has revamped PostgreSQL.

We believe that system design is a powerful new option with a unique technical approach that enables us to integrate isolated OLTP, OLAP, and HTAP workloads with minimal investment in new expertise. increase.

Others have agreed and emphasized a combination of full compatibility with cloud availability.

AlloyDB offers attractive relational database options with full compatibility with PostgreSQL, excellent performance, availability, and cloud integration. We’re very excited about collaborative innovation with Google, and we’re now able to take advantage of enterprise-grade features while cost-effectively modernizing our own traditional database. Bala Natrajan, Senior Director of Data Infrastructure and Cloud Engineering at PayPal, said:

Some executives are attracted to the support and management provided by Google. Sales materials highlight service capabilities that handle many of the scaling, backup, and replication tasks. Google introduces machine learning-based models to learn from users and adapt to query patterns.

AlloyDB greatly increases throughput without changing your application to a PostgreSQL workload. And because it’s a managed service, our team can spend less time running databases and more time on value-added tasks, said Sofian Hadiwijaya, CTO and co-founder of Warung Pintar. It is.

Google believes that these customers form the basis of a strong customer base. It needs to be compatible with current legacy options at a low price with the flexibility of open source software.

The forecast is that 70% of new in-house applications will be developed in open source and 50% of existing proprietary databases will either move to open source or begin the conversion process. This is what we have heard from our customers over and over again.

VentureBeat’s mission is to become a Digital Town Square for technical decision makers to acquire knowledge about innovative enterprise technology and trading. See membership details.

Sources

1/ https://Google.com/

2/ https://venturebeat.com/2022/05/11/google-announces-alloydb-a-faster-hosted-version-of-postgresql/

The mention sources can contact us to remove/changing this article

What Are The Main Benefits Of Comparing Car Insurance Quotes Online

LOS ANGELES, CA / ACCESSWIRE / June 24, 2020, / Compare-autoinsurance.Org has launched a new blog post that presents the main benefits of comparing multiple car insurance quotes. For more info and free online quotes, please visit https://compare-autoinsurance.Org/the-advantages-of-comparing-prices-with-car-insurance-quotes-online/ The modern society has numerous technological advantages. One important advantage is the speed at which information is sent and received. With the help of the internet, the shopping habits of many persons have drastically changed. The car insurance industry hasn't remained untouched by these changes. On the internet, drivers can compare insurance prices and find out which sellers have the best offers. View photos The advantages of comparing online car insurance quotes are the following: Online quotes can be obtained from anywhere and at any time. Unlike physical insurance agencies, websites don't have a specific schedule and they are available at any time. Drivers that have busy working schedules, can compare quotes from anywhere and at any time, even at midnight. Multiple choices. Almost all insurance providers, no matter if they are well-known brands or just local insurers, have an online presence. Online quotes will allow policyholders the chance to discover multiple insurance companies and check their prices. Drivers are no longer required to get quotes from just a few known insurance companies. Also, local and regional insurers can provide lower insurance rates for the same services. Accurate insurance estimates. Online quotes can only be accurate if the customers provide accurate and real info about their car models and driving history. Lying about past driving incidents can make the price estimates to be lower, but when dealing with an insurance company lying to them is useless. Usually, insurance companies will do research about a potential customer before granting him coverage. Online quotes can be sorted easily. Although drivers are recommended to not choose a policy just based on its price, drivers can easily sort quotes by insurance price. Using brokerage websites will allow drivers to get quotes from multiple insurers, thus making the comparison faster and easier. For additional info, money-saving tips, and free car insurance quotes, visit https://compare-autoinsurance.Org/ Compare-autoinsurance.Org is an online provider of life, home, health, and auto insurance quotes. This website is unique because it does not simply stick to one kind of insurance provider, but brings the clients the best deals from many different online insurance carriers. In this way, clients have access to offers from multiple carriers all in one place: this website. On this site, customers have access to quotes for insurance plans from various agencies, such as local or nationwide agencies, brand names insurance companies, etc. "Online quotes can easily help drivers obtain better car insurance deals. All they have to do is to complete an online form with accurate and real info, then compare prices", said Russell Rabichev, Marketing Director of Internet Marketing Company. CONTACT: Company Name: Internet Marketing CompanyPerson for contact Name: Gurgu CPhone Number: (818) 359-3898Email: [email protected]: https://compare-autoinsurance.Org/ SOURCE: Compare-autoinsurance.Org View source version on accesswire.Com:https://www.Accesswire.Com/595055/What-Are-The-Main-Benefits-Of-Comparing-Car-Insurance-Quotes-Online View photos

ExBUlletin

to request, modification Contact us at Here or [email protected]