Life Beyond Relational Databases

Transcript

1. © 2019, Amazon Web Services, Inc. or its Affiliates. All rights reserved. Fatema AlMannaei | Applications Specialist, Tatweer Petroleum Hamad Alkhal | Associate Consultant, AWS Professional Services June 29th, 2019 Life Beyond Relational Databases AWS Bahrain User Group
2. © 2019, Amazon Web Services, Inc. or its Affiliates. All rights reserved. What we’ll have today • Introduction • 9 Databases • Hands-on: Create and Manage a Nonrelational Database
3. © 2019, Amazon Web Services, Inc. or its Affiliates. All rights reserved. “It's no longer just a battle between monolithic relational database vendors”
4. © 2019, Amazon Web Services, Inc. or its Affiliates. All rights reserved. What’s your database strategy ?!
5. © 2019, Amazon Web Services, Inc. or its Affiliates. All rights reserved. Serverless What’s your database strategy ?!
6. © 2019, Amazon Web Services, Inc. or its Affiliates. All rights reserved. “A one size fits all database doesn't fit anyone” – Dr. Werner Vogels, CTO Amazon
7. © 2019, Amazon Web Services, Inc. or its Affiliates. All rights reserved. Purpose-built Fully managed or Serverless Scalable Enterprise-class
8. © 2019, Amazon Web Services, Inc. or its Affiliates. All rights reserved. Relational Key-value Document In-memory Graph Ledger Time Series Search-engine Purpose-built databases
9. © 2019, Amazon Web Services, Inc. or its Affiliates. All rights reserved. READY ?!
10. © 2019, Amazon Web Services, Inc. or its Affiliates. All rights reserved. Key-value Document In-memory Graph Ledger Time Series Search-engine Relational Relational databases store data with pre- defined schema and relationships between them, designed for supporting ACID transactions, maintaining referential integrity, and data consistency. Traditional apps, ERP, CRM, e- commerce. RDS Aurora Redshift Purpose-built databases
11. © 2019, Amazon Web Services, Inc. or its Affiliates. All rights reserved. Relational databases ?!
12. © 2019, Amazon Web Services, Inc. or its Affiliates. All rights reserved. Amazon RDS 1 Relational
13. © 2019, Amazon Web Services, Inc. or its Affiliates. All rights reserved. Amazon RDS
14. © 2019, Amazon Web Services, Inc. or its Affiliates. All rights reserved. Amazon RDS Security
15. © 2019, Amazon Web Services, Inc. or its Affiliates. All rights reserved. Amazon RDS Availability, Durability, Scalability
16. © 2019, Amazon Web Services, Inc. or its Affiliates. All rights reserved. Amazon RDS Administration
17. © 2019, Amazon Web Services, Inc. or its Affiliates. All rights reserved. Amazon RDS Administration
18. © 2019, Amazon Web Services, Inc. or its Affiliates. All rights reserved. Amazon RDS Amazon RDS Use cases o Lift & shift o Traditional apps o ERP o CRM o e-commerce applications
19. © 2019, Amazon Web Services, Inc. or its Affiliates. All rights reserved. Amazon Redshift 2 Relational
20. © 2019, Amazon Web Services, Inc. or its Affiliates. All rights reserved. Warehouse ?!
21. © 2019, Amazon Web Services, Inc. or its Affiliates. All rights reserved. Amazon Redshift How it works
22. © 2019, Amazon Web Services, Inc. or its Affiliates. All rights reserved. Amazon Redshift Use cases o Business intelligence o Analytics workloads o Unified data warehouse o Data lake
23. © 2019, Amazon Web Services, Inc. or its Affiliates. All rights reserved. Next, non-relational ?
24. © 2019, Amazon Web Services, Inc. or its Affiliates. All rights reserved. Document In-memory Graph Ledger Time Series Search-engine Purpose-built databases Relational Key-value Key-value databases are optimized to store and retrieve key-value pairs in large volumes and in milliseconds, without the performance overhead and scale limitations of relational databases. Internet-scale applications, real-time bidding, shopping carts, & customer preferences. DynamoDB
25. © 2019, Amazon Web Services, Inc. or its Affiliates. All rights reserved. Key-value ??
26. © 2019, Amazon Web Services, Inc. or its Affiliates. All rights reserved. DynamoDB 3 Key-value
27. © 2019, Amazon Web Services, Inc. or its Affiliates. All rights reserved. Amazon DynamoDB Use cases o Internet-scale applications o real-time bidding o shopping carts o customer preferences o Mobile/Web Apps backends o Microservices
28. © 2019, Amazon Web Services, Inc. or its Affiliates. All rights reserved. In-memory Graph Ledger Time Series Search-engine Purpose-built databases Relational Key-value Document Document databases are designed to store semi-structured data as documents and are intuitive for developers to use because the data is typically represented as a readable document. Content management, personalization, and mobile applications. DocumentDB
29. © 2019, Amazon Web Services, Inc. or its Affiliates. All rights reserved. Document ?!
30. © 2019, Amazon Web Services, Inc. or its Affiliates. All rights reserved. DocumentDB 4 Document
31. © 2019, Amazon Web Services, Inc. or its Affiliates. All rights reserved. Amazon DynamoDB Use cases o Content management o Catalogs o Personalization o Mobile applications o Migrate MongoDB workloads
32. © 2019, Amazon Web Services, Inc. or its Affiliates. All rights reserved. In-memory Ledger Time Series Search-engine Purpose-built databases Document Relational Key-value Graph Graph databases are used for applications that need to enable millions of users to query and navigate relationships between highly connected, graph datasets with millisecond latency. Fraud detection, social networking, recommendati on engines Neptune
33. © 2019, Amazon Web Services, Inc. or its Affiliates. All rights reserved. Graph ?
34. © 2019, Amazon Web Services, Inc. or its Affiliates. All rights reserved. Neptune 5 Graph
35. © 2019, Amazon Web Services, Inc. or its Affiliates. All rights reserved. Amazon Neptune How it works
36. © 2019, Amazon Web Services, Inc. or its Affiliates. All rights reserved. Amazon Neptune Use cases o Fraud detection o Social networking o Recommendation engines o Knowledge Graphs o Life Sciences o Network/IT Operations
37. © 2019, Amazon Web Services, Inc. or its Affiliates. All rights reserved. Ledger Time Series Search-engine Purpose-built databases Graph Relational Key-value Document In-memory In-memory databases are used for applications that require real time access to data. By storing data directly in memory, these databases provide microsecond latency where millisecond latency is not enough. Caching, gaming leaderboards, and real-time analytics. ElastiCache
38. © 2019, Amazon Web Services, Inc. or its Affiliates. All rights reserved. In memory ?!
39. © 2019, Amazon Web Services, Inc. or its Affiliates. All rights reserved. ElastiCache 6 In-memory
40. © 2019, Amazon Web Services, Inc. or its Affiliates. All rights reserved. Amazon ElastiCache How it works Redis  Memcached →
41. © 2019, Amazon Web Services, Inc. or its Affiliates. All rights reserved. Amazon ElasticCache Use cases o Caching o Gaming leaderboards o Real-time analytics o Chat & Messaging o Geospatial o Machine Learning o Media Streaming
42. © 2019, Amazon Web Services, Inc. or its Affiliates. All rights reserved. Time Series Search-engine Purpose-built databases In-memory Relational Key-value Document Graph Ledger Ledger databases are used when you need a centralized, trusted authority to maintain a scalable, complete and cryptographically verifiable record of transactions. Systems of record, supply chain, registrations, and banking transactions. QLDB
43. © 2019, Amazon Web Services, Inc. or its Affiliates. All rights reserved. Ledger database ?!
44. © 2019, Amazon Web Services, Inc. or its Affiliates. All rights reserved. Amazon Quantum Ledger Database (QLDB) 7 Ledger
45. © 2019, Amazon Web Services, Inc. or its Affiliates. All rights reserved. Amazon QLDB How it works
46. © 2019, Amazon Web Services, Inc. or its Affiliates. All rights reserved. Amazon QLDB Use cases o HR & Payroll o Retail & Supply chain o Registrations o Banking transactions o Insurance o Manfacturing
47. © 2019, Amazon Web Services, Inc. or its Affiliates. All rights reserved. Search-engine Purpose-built databases Relational Key-value Document In-memory Graph Ledger Time Series Time series databases are used to efficiently collect, synthesize, and derive insights from enormous amounts of data that changes over time (known as time- series data). IoT applications, DevOps, industrial telemetry. Timestream
48. © 2019, Amazon Web Services, Inc. or its Affiliates. All rights reserved. Time Series ?
49. © 2019, Amazon Web Services, Inc. or its Affiliates. All rights reserved. Timestream 8 Time Series
50. © 2019, Amazon Web Services, Inc. or its Affiliates. All rights reserved. Amazon Timestream How it works
51. © 2019, Amazon Web Services, Inc. or its Affiliates. All rights reserved. Amazon Timestream Use cases o IoT applications o DevOps o Industrial Telemetry o Application Monitoring
52. © 2019, Amazon Web Services, Inc. or its Affiliates. All rights reserved. Purpose-built databases Relational Key-value Document In-memory Graph Ledger Time Series Search-engine A search-engine database is a type of nonrelational database that is dedicated to the search of data content. Text search, Logging, analytics, real- time monitoring Elasticsearch
53. © 2019, Amazon Web Services, Inc. or its Affiliates. All rights reserved. Search-engine ?
54. © 2019, Amazon Web Services, Inc. or its Affiliates. All rights reserved. ElasticSearch 9 Search
55. © 2019, Amazon Web Services, Inc. or its Affiliates. All rights reserved. Amazon ElasticSearch How it works
56. © 2019, Amazon Web Services, Inc. or its Affiliates. All rights reserved. Amazon ElasticSearch Use cases o Text search o Logging & analysis o Real-time application monitoring o Security analytics o Clickstream analytics
57. © 2019, Amazon Web Services, Inc. or its Affiliates. All rights reserved. Purpose-built databases Relational Relational databases store data with pre- defined schema and relationships between them, designed for supporting ACID transactions, maintaining referential integrity, and data consistency. Traditional apps, ERP, CRM, e- commerce. RDS Aurora Redshift Key-value Key-value databases are optimized to store and retrieve key-value pairs in large volumes and in milliseconds, without the performance overhead and scale limitations of relational databases. Internet-scale applications, real-time bidding, shopping carts, & customer preferences. DynamoDB Document Document databases are designed to store semi-structured data as documents and are intuitive for developers to use because the data is typically represented as a readable document. Content management, personalization, and mobile applications. DocumentDB Graph Graph databases are used for applications that need to enable millions of users to query and navigate relationships between highly connected, graph datasets with millisecond latency. Fraud detection, social networking, recommendati on engines Neptune In-memory In-memory databases are used for applications that require real time access to data. By storing data directly in memory, these databases provide microsecond latency where millisecond latency is not enough. Caching, gaming leaderboards, and real-time analytics. ElastiCache Ledger Ledger databases are used when you need a centralized, trusted authority to maintain a scalable, complete and cryptographically verifiable record of transactions. Systems of record, supply chain, registrations, and banking transactions. QLDB Time Series Time series databases are used to efficiently collect, synthesize, and derive insights from enormous amounts of data that changes over time (known as time- series data). IoT applications, DevOps, industrial telemetry. Timestream Search-engine A search-engine database is a type of nonrelational database that is dedicated to the search of data content. Text search, Logging, analytics, real- time monitoring Elasticsearch
58. © 2019, Amazon Web Services, Inc. or its Affiliates. All rights reserved. Any question ?!
59. © 2019, Amazon Web Services, Inc. or its Affiliates. All rights reserved. Let’s build one ..
60. © 2019, Amazon Web Services, Inc. or its Affiliates. All rights reserved. What is next ? o edX.org Amazon DynamoDB: Building NoSQL Database-Driven Applications https://www.edx.org/course/amazon-dynamodb-building-nosql-database-driven-applications o AWS Databases: Purpose-built databases for all your application needs https://aws.amazon.com/products/databases/