利用 Aurora PostgreSQL 和 Babelfish 降低成本.pdf

1、 2025,Amazon Web Services,Inc.or its affiliates.All rights reserved.2025,Amazon Web Services,Inc.or its affiliates.All rights reserved.2025,Amazon Web Services,Inc.or its affiliates.All rights reserved.Sjors RobroekSnr.Solutions ArchitectAmazon Web Services Wafaa SultanSolutions ArchitectAmazon Web

2、ServicesCut Costs with Aurora PostgreSQL&BabelfishN T A 3 1 3 2025,Amazon Web Services,Inc.or its affiliates.All rights reserved.-Migrating off Commercial Databases Overview-Introduction to Amazon Aurora.-Modernizing with Babelfish for Aurora PostgreSQL.-High-Level Architecture&Cost Comparison.-Busi

3、ness Value and Outcomes.Agenda 2025,Amazon Web Services,Inc.or its affiliates.All rights reserved.Motivations for migrating B R E A K F R E E F R O M L E G A C Y D ATA B A S E SCostlyProprietaryLock-inPunitive licensingYouve got mailAudit 2025,Amazon Web Services,Inc.or its affiliates.All rights res

4、erved.5Overview of a typical migration effort 2025,Amazon Web Services,Inc.or its affiliates.All rights reserved.Challenges in migrating from commercial to open source 2025,Amazon Web Services,Inc.or its affiliates.All rights reserved.Application basics-example T-SQL application syntaxCREATE TABLE d

5、bo.Products(ProductID INT PRIMARY KEY NOT NULL,ProductName VARCHAR(25)NOT NULL,Price MONEY NULL)ProductIDProductNamePrice 2025,Amazon Web Services,Inc.or its affiliates.All rights reserved.Application basics-example T-SQL application syntaxINSERT dbo.Products(ProductID,ProductName,Price)VALUES(1,Cla

6、mp,12.8182)ProductIDProductNamePrice1Clamp12.8182 2025,Amazon Web Services,Inc.or its affiliates.All rights reserved.-example T-SQL application syntaxSELECT ProductID,ProductName,PriceFROM dbo.ProductsWHERE Price 30Application correctnessProductIDProductNamePrice1Clamp$12.8182ProductIDProductNamePri