Sep 23–26, 2019

From relational databases to cloud databases: Using the right tool for the right job

Gowrishankar Balasubramanian (Amazon Web Services), Rajeev Srinivasan (Amazon Web Services)
1:30pm5:00pm Tuesday, September 24, 2019
Location: 1E 09
Average rating: ****.
(4.50, 2 ratings)

Who is this presentation for?

  • Developers, data engineers, and database administrators

Level

Intermediate

Description

Enterprises adopt cloud platforms such as AWS for agility, elasticity, and cost savings. Database design and management requires a different mindset in AWS when compared to traditional relational database management system (RDBMS) design.

Gowrishankar Balasubramanian and Rajeev Srinivasan highlight the best practices in choosing the right data storage, data migration strategies, and tools used for data processing and storage on an AWS cloud platform. They also explore real-life case studies from various industries to illustrate these concepts. You’ll go hands-on to evaluate the application use cases, decide on the target data store, and migrate a sample relational schema into AWS cloud using AWS DMS. You’ll leverage the AWS services such as Amazon DynamoDB, Amazon S3, and Amazon relational database service (RDS).

Prerequisite knowledge

  • A working knowledge of AWS cloud (virtual private cloud [VPC], RDS, DynamoDB, CloudFormation, and S3) and relational databases

Materials or downloads needed in advance

  • A laptop with admin privileges and an AWS account with necessary IAM privileges to launch resources

Please download and install one of the below SQL Clients to connect to Oracle (12x) and PostgreSQL (10x) instances. Suggested tools are provided below.

What you'll learn

  • Learn the importance of choosing the right database technologies on AWS cloud based on application use case for better cost efficiency, performance, and availability
  • Discover the the tools available for database migration, monitoring, and management
Photo of Gowrishankar Balasubramanian

Gowrishankar Balasubramanian

Amazon Web Services

Gowri Balasubramanian is a senior solutions architect at Amazon Web Services. He works with AWS customers to provide guidance and technical assistance on both relational and NoSQL database services, helping them improve the value of their solutions when using AWS.

Photo of Rajeev Srinivasan

Rajeev Srinivasan

Amazon Web Services

Rajeev Srinivasan is a senior solutions architect for AWS. He works very closely with its customers to provide big data and NoSQL solution leveraging the AWS platform. He enjoys coding, and in his spare time, he enjoys riding his motorcycle and reading books.

Leave a Comment or Question

Help us make this conference the best it can be for you. Have questions you'd like this speaker to address? Suggestions for issues that deserve extra attention? Feedback that you'd like to share with the speaker and other attendees?

Join the conversation here (requires login)

Comments

Brian Gasser | Owner
09/20/2019 9:03am EDT

Hi again. Thanks for the info. I created a free 12 month account on AWS and ran some labs. Will the free account work for this tutorial? There are some limits on services available and also instances types, storage etc. I can spin up a EC2 instance, create an S3 bucket, use mechanical EBS within limits, use RDS for MySQL, PostgreSQL, MariaDB, Oracle BYOL, or SQL Server, use elastic cache within limits, etc…
This is the link to the free tier:
https://conferences.oreilly.com/strata/strata-ny/public/schedule/detail/77622

thanks
Brian

Picture of Gowrishankar Balasubramanian
Gowrishankar Balasubramanian | Senior Solutions Architect
08/23/2019 7:38am EDT

@Brian – Thanks for your interest in our session. Although prior knowledge is preferred, we will provide a self-paced lab instructions that you just need to follow in your AWS Account. if possible, please try a few 10 minute tutorials using the below link https://aws.amazon.com/getting-started/tutorials/?awsf.getting-started-content=use-case-tmt%23databases. Reg CloudFormation, we will provide a template that you will click and launch resources. so basic understanding of CloudFormation is sufficient. No development knowledge required.

Brian Gasser | Owner
08/16/2019 8:04am EDT

Wondering if this tutorial is a good fit. I have strong background relational technology and much data management experience, but limited AWS knowledge. Would like to take this tutorial but wondering if the hands-on component would be manageable. I am familiar with cloud concepts, know what S3, RDS and Dynamo DB are, but have not used them hands-on yet. Not familiar so much with Cloudformation.

    Contact us

    confreg@oreilly.com

    For conference registration information and customer service

    partners@oreilly.com

    For more information on community discounts and trade opportunities with O’Reilly conferences

    strataconf@oreilly.com

    For information on exhibiting or sponsoring a conference

    pr@oreilly.com

    For media/analyst press inquires