A Java program to upload data to Amazon AWS S3 and Amazon AWS RDS (MySQL) instance and measure performance.
###Steps for AWS S3:
- Created an AWS account and registered for its Free Tier.
- Downloaded PCI and University data.
- Created an AWS S3 bucket with name
cse6331-bucket
. - Created an
ACCESS_KEY_ID
andSECRET_ACCESS_KEY
for S3. - Using S3Uploader class, uploaded both the files placed in
data/
directory.
###Steps for AWS RDS MySQL:
- Created an AWS RDS MySQL instance with default configuration (
cse6331.caf32xdtw87o.us-west-2.rds.amazonaws.com:3306/cse6331_db
). - Connected to AWS RDS MYSQL instance using local MySQL Workbench.
- Created two tables in
cse6331_db
. - Using LOAD DATA query in
RDBUploader
class, loaded both the csv files into these two tables.
###Steps for creating mapping between PCI and # of universities in a state
- Executed an inner join query in
SIERMapper
class on both the tables to get the mapping between PCI and # Universities of a state.