Lab - Data Modeling for Amazon Neptune

In this lab you learn to model your source data from relational databases and document stores to Amazon Neptune in order to meet this business need. You will use a sample customer order database to build a product recommendation system which is used to send real-time product recommendations as customers are browsing the products portal.

Objectives

By the end of this lab you should be able to do the following:

• Model source data from relational databases into vertices and edges.
• Extract embedded entities from source data.
• Use additional datasets to support new use cases or to improve the quality of results.

Prerequisites

   •   A functional understanding of relational databases, Database structures and data query language

   •   A basic competency with the AWS Management Console

Outline

Task 1: Setup Neptune utilities

Task 2: Store Rows as vertices ( Customers, Orders, Products, Product Packages )

Task 3: Store relationships as edges

Task 4: Extract embedded entities and identify households

Task 5: Use additional data sources to improve recommendations