Project Plan

Minimal Viable Product

Due Date: Sept 25th

This application must be available for the MapR 6.0 Launch, so for September 25th we need to have the following features implemented and documented:

Web Application

Home Page

• List and view Albums
  • Create a similar view of the main section of DiscOgs
  • When clicking on the Album in the list go to the Detail Page

In this part of the tutorial

• Basic query with sort and limit
• Use projection to reduce the data transmitted on the network
• Use Indexing & covered index query to improve performance of queries on sort & limit
• Document how to write a query and improve it using indexing

Detail Page

• Album Detail View
  • Create a similar view of the main section of DiscOgs Album View

In this part of the tutorial

• basic find by ID

Album Operations

• Allow user to create a new Album

  • Main data
  • Add songs

• Allow user to update an existing Album

• Allow people to delete an Album and related data

  • this could be done using a microservice call based on CDC

In this part of the tutorial

• Show how to use Insert/Update/Delete operations
• Explain and implement the need for "read your own write" feature to use index after insert/update or delete

Artists Operations

• Allow people to create a new Artist

• Allow user to update an existing Artists

• Allow people to delete an Artists and related data

  • this could be done using a microservice call based on CDC

Similar to Album

Analytics

This task is to show that it is possible to use Apache Drill to run SQL Queries on MapR-DB JSON.

• Create Tableau/Cliqview report using SQL
  • Number of Artist by Country on a Map
  • Top 10 Artist based on number of album
  • Number of new Artist by Year/Month
  • Number of Album published by year/month

In this part of the tutorial we should explain how to use indices to improve query response time.

Machine Learning

Streaming

Full text search integration