CPSC 4820 - DAY 5
FEBRUARY 6, 2018

================================================================================

SQL - standard query language
NoSQL - not only sql
+---------------------------------------+------------------------------------+
| SQL					|	NoSQL			     |
+---------------------------------------+------------------------------------+
| Data Storage - Rows and Columns       | Data Storage - Key-Value           |
| Schemas - Fixed			| Schemas - Dynamic		     |
| Querying - Using SQL			| Querying - Focused on collection   |
| Scalability - Vertical		| Scalability - Horizontal	     |
|					|				     |
+---------------------------------------+------------------------------------+


Data Storage Considerations 

Amazon Relational Database Service (RDS)

DB Instance are isolated database environment in the cloud.

They contain multiple user-created databases.

Cross-region snapshots - a copy of the database stored in a different AWS 
Region.

Provides a backup for disaster recovery.

Can be used as a base for migration to a different region.

Amazon RDS Security
	-IAM policies
	-Security groups
	-Use SSL connections with DB instances
	-Use Amazon RDS encryption to secure RDS
	
Multi-AZ RDS Deployment to automatically provision and maintain a synchronous
standby in a different availability zone.

enable automatic backups.

backup window to occur during the daily low in WriteIOPS

Relational (AMAZON RDS) 

	-Existing apps
	-Business process-centric apps

	-Relational data models, transactions
	-complex queries, joins and updates.

	-Scaling application or dba-architected

	-performance-depends on data model, indexing, query and storage
	optimization, reliability and availability, durability.

NoSQL (Amazon DynamoDB)

	-New web-scale applications
	-Large number of small writes and reads

	-Simple data models, transactions
	-Range queries, simple updates

	-Seamless, on-demand scaling based on application requirements

	-performance - automatically optimized by the system
	-reliability and availability
	-durability