Amazon Aurora machine learning enables you to add ML-based predictions to applications via the familiar SQL programming language, so you don't need to learn separate tools or have prior machine learning experience. It provides simple, optimized, and secure integration between Aurora and AWS ML services without having to build custom integrations or move data around.
When you run an ML query, Aurora calls Amazon SageMaker for a wide variety of ML algorithms or Amazon Comprehend for sentiment analysis, so your application doesn't need to call these services directly. This makes Aurora machine learning suitable for low-latency, real-time use cases such as fraud detection, ad targeting, and product recommendations. For example, you can build product recommendation systems by writing SQL queries in Aurora that pass customer profile, shopping history, and product catalog data to a SageMaker model, and get product recommendations returned as query results.
Familiar SQL programming language
Aurora exposes ML models as SQL functions, allowing you to use standard SQL to build applications that call ML models, pass data to them, and return predictions as query results. There is no learning curve, development complexity, or any need to learn new programming languages, or tools.
Wide selection of ML algorithms
Run predictions using any ML model, including models that you trained in SageMaker or elsewhere, models offered by AWS, and models offered by AWS partners on the AWS Marketplace. You can also use Comprehend for sentiment analysis, without any training.
Aurora integrates directly with SageMaker and Comprehend, reducing the network delay. ML training and inferencing happen in SageMaker and Comprehend, so there is no performance impact on Aurora. The integration between Aurora and each AWS machine learning service is further optimized for latency and throughput, delivering up to 100X throughput improvements. Since the machine learning model is deployed separately from the database and the application, each can scale up or scale out independently of the others.
Security and governance
The integration between Aurora, SageMaker, and Comprehend ensures that data security and governance are maintained inside the database. Access to Aurora and each ML service can be controlled via AWS Identity and Access Management (IAM) and within your Aurora database. The integration uses end-to-end encryption between services, and no data is persisted outside the database.
You can use Aurora ML integration to build product recommendation systems that make personalized product purchase recommendations based on a customer’s profile, shopping history, and clickstream data. You can write SQL queries in Aurora that call ML models like linear learner and XGBoost, pass customer profile, shopping history, and product catalog data to these models, and get the product recommendations as query results. The query results can then be used in your application to improve the customer’s shopping experience.
Aurora ML integration can enhance your customer service applications like call center analytics and customer support ticket handling. You can write SQL queries in Aurora, pass customer interaction data like online feedback forms, support tickets, and product reviews to Comprehend, analyze this data to determine customer’s sentiment, and get the customer sentiments returned as query results. The query results can then be used in your applications to improve your customer relationships.
Aurora can help with fraud detection and prevention in applications like credit card and insurance claims processing. You can write SQL queries in Aurora that call ML models like K-means clustering and random cut forest, pass customer profile, transactions, merchant information, policy details, and claims data to these models, and get the transactions that require further review and analysis as query results. The query results can then be used in your applications for fraud identification and mitigation.
- There is no additional charge for the integration between Aurora and AWS machine learning services. You only pay for the underlying services.
- Comprehend is priced based on the amount of text processed. To minimize charges, pay attention to the size of your database queries.
- Note: The integration between Aurora and Comprehend is currently in preview.
How to get started
Aurora machine learning integration is available for Amazon Aurora with MySQL 5.7 compatibility, PostgreSQL 10 compatibility, and PostgreSQL 11 compatibility. You can get started with just a few clicks by upgrading to the latest version of Aurora and giving your Aurora database access to the AWS machine learning services in the Amazon RDS Management Console. You can read the Amazon Aurora documentation to learn more.
Select a features page to learn more about the MySQL- or PostgreSQL-compatible edition.
Instantly get access to the Amazon RDS Management Console.
Start building with simple Amazon Aurora tutorials.