All technological notes.
Data Warehouse
Data warehouses generally perform aggregation.
Data warehouses are generally designed to be HOT
Data warehouse are infrequently accessed meaning they are not intended for real-time reporting but once or twice a day or once a week to generate business and user reports.
Data warehouse needs to consume data from a relational database on a regular basis.
Redshift - analytics, data warehousing, BINeptune - Graph, LatencyA popular graph dataset would be a social network
Build and run applications working with highly connected datasets–optimized for these complex and hard queries
Can store up to billions of relations and query the graph with milliseconds latency
Quantum Ledger Database (QLDB) - Financial regulation, Immutable, Centralizationledger is a book recording financial transactionsManaged Blockchain - DecentralizationElastic MapReduce (EMR) - Hadoop, Big DataElastic MapReduce (EMR)
Amazon Athena - S3, Serverless, analyzeAmazon QuickSight - Serverless,visualizations , BIAWS Glue - serverless, ETLGlue Data Catalog - DatasetsDatabase Migration Service (DMS) - MigrationHomogeneous migrations: ex Oracle to OracleHeterogeneous migrations: ex Microsoft SQL Server to Aurora