olap
-
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..
-
OLTP, OLAP, and ETLDB/RDB 2019. 9. 11. 14:28
1. Overview 1.1 On-line Transaction Processing (OLTP) OLTP stands for On-line Transaction Processing. OLTP based systems (account, ticket booking, banking systems, money transfer system) are used to perform a large number of short transactions. Almost all of the database queries in OLTP system consist of commands insert, update, delete. Select queries are mainly designed to enable users to selec..