After extracting, loading, and transforming the data in the HDFS data warehouse, and loading it onto the customer360
database in MySQL, we will present it using a web interface.
MySQL is a popular database suitable for fast interactive queries. It can perfectly serve as the backend database for web applications. When you create a 360-degree view, you might have to integrate it into an existing web application, or build a new application to present your 360-degree to the users. In this section, we will cover building an elementary web application, which can display the 360-degree view.
In order to build the web application, we assume that we get the user ID as the input field that will be used to query the customer360
database. This user ID is the same as the user ID stored in t_customers
. Using this user ID, we will present the brand names visited by the user and his latest tweets. Note that we do not have the web access log for all the users present in the customer master...