Data Warehouse
-
AWS RedshiftCloud/AWS 2022. 6. 5. 17:30
Overview Fully-managed, petabyte scale data warehouse service 10 times better performance than other DW’s Via machine learning, massively parallel query execution(MPP), columnar storage Designed for OLAP, not OLTP Cost effective SQL, ODBC, JDBC interfaces Scale up or down on demand Built-in replication & backups Monitoring via CloudWatch/CloudTrail Use Cases Accelerate analytics workloads Unifie..
-
Data Warehouse and Data LakeDB/Nosql 2020. 7. 10. 12:12
1. Overview 1.1 Data Warehouse A data warehouse is a blend of technologies and components which allows the strategic use of data. It is a technique for collecting and managing data from varied sources to provide meaningful business insights. It is the electronic storage of a large amount of information by a business that is designed for query and analysis instead of transaction processing. It is..