- 최신
- 최다 투표
- 가장 많은 댓글
-
Amazon Redshift does not natively provide cube/slice/dice capabilities, this is normally provided by software products that sit "on top" of a database. For example Microsrategy allows you to build ROLAP cubes on top on data marts sourced from Redshift tables.
-
Can you specify what is "our Approach"? The best way to move data into an OLAP RDBMS is in "bulk" to maximize the parallel ingestion. Redshift providers the COPY command to perform bulk load ingestion. Data has to be moved into an S3 bucket previous to the execution of a COPY command. ETL tools may hide the process but in the back this process still happens.
-
Query performance in an MPP solution like Redshift depends mainly on how the tables containing the data are "distributed" across the cluster and how the data in them is sorted. Distributing and Sorting is a simple mechanism, but we have created some "automated features" that may allow the developers not to be so concerned about it.
관련 콘텐츠
- AWS 공식업데이트됨 4달 전
- AWS 공식업데이트됨 일 년 전
- AWS 공식업데이트됨 일 년 전
- AWS 공식업데이트됨 9달 전