Experiencing MIS
Experiencing MIS
7th Edition
ISBN: 9780134380421
Author: KROENKE
Publisher: PEARSON
Expert Solution & Answer
Book Icon
Chapter 5, Problem 19MLM

Explanation of Solution

List of AWS database offering:

The below are the list of AWS database offerings:

  • Amazon Aurora
    • It is a type of relational database used for transactional applications.
  • Amazon RDS
    • It is a type of relational database used for transactional applications.
  • Amazon Dynamo DB
    • It is a type of non-relational database used for internet scaling applications.
    • It is server less NoSQL database.
  • Amazon Redshift
    • It is a data warehouse used for data analytics.
  • Amazon ElastiCache
    • It is a type of in-memory data store used in caching the data and process real-time workloads.
  • Amazon Neptune
    • A Highly connected data can be build using the Graph database.

Difference among the Amazon’s RDS, DynamoDB, ElastiCache and Redshift services:

Amazon’s RDSAmazon’s DynamoDBAmazon’s ElastiCacheAmazon’s Redshift
It is a managed Relational database.It is NoSQL database.It is an in-memory data store.It is a data warehouse.
Provides service with easy setup. It is easy to operate and could be scaled in the cloud.It is fast and flexible that provides a NoSQL database service for the application in a consistent and single millisecond latency at required scale.It could be deployed, operated and scaled effortlessly operated in an open source compatible in memory data store.It is simple, fast and cost effective fully managed data warehouse to manage the data using the SQL and existing Business Intelligence tools.
It is used in OLTP (Online Transaction Processing) systems.It can be used in the system that requires millisecond read latency at required scale.It can be used in the system that requires sub- millisecond response time.It is used for the OLAP(OnLine Analytical Processing) systems.
It supports read replicas across regions and gets backup at Amazon S3.It uses streams to replicate the data to a table and to another table and does not require any backup.Replicas are provided based on the read scaling and gets backup automatically.Data gets replicated automatically and gets backup in Amazon S3...

Blurred answer
Students have asked these similar questions
What does the term NoSQL mean? What is the connection between NoSQL and NoSQL database management systems?
NoSQL databases are those that don't rely on relational models. Describe the pluses and minuses of using a NoSQL service. To the best of your abilities, please include as much detail as possible. For your consideration, please accept my deepest appreciation.
Do you have any specific examples to back up your assertion that many-to-many links cannot be stored in a relational database? If you have, we'd appreciate it if you'd tell us about them.
Knowledge Booster
Background pattern image
Similar questions
SEE MORE QUESTIONS
Recommended textbooks for you
Text book image
Database System Concepts
Computer Science
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:McGraw-Hill Education
Text book image
Starting Out with Python (4th Edition)
Computer Science
ISBN:9780134444321
Author:Tony Gaddis
Publisher:PEARSON
Text book image
Digital Fundamentals (11th Edition)
Computer Science
ISBN:9780132737968
Author:Thomas L. Floyd
Publisher:PEARSON
Text book image
C How to Program (8th Edition)
Computer Science
ISBN:9780133976892
Author:Paul J. Deitel, Harvey Deitel
Publisher:PEARSON
Text book image
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781337627900
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning
Text book image
Programmable Logic Controllers
Computer Science
ISBN:9780073373843
Author:Frank D. Petruzella
Publisher:McGraw-Hill Education