- Mais recentes
- Mais votos
- Mais comentários
-
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.
Conteúdo relevante
- AWS OFICIALAtualizada há 2 anos
- AWS OFICIALAtualizada há 2 anos
- AWS OFICIALAtualizada há 2 anos
- AWS OFICIALAtualizada há 2 anos