Title: Theory / Unimportant / CS / Cloud / AWS / Database / Redshift / General

Name: Incremental refresh
Definition: Refreshing a materialized view by using the current view and the changes since it was computed
Page: https://docs.aws.amazon.com/redshift/latest/dg/materialized-view-refresh.html
Context: Materialized view

Name: full refresh
Definition: Refreshing a materialized view by recomputing it entirely
Page: https://docs.aws.amazon.com/redshift/latest/dg/materialized-view-refresh.html
Context: Materialized view

Question: Query compatible with incremental refresh
Answer: Select from
Page: https://docs.aws.amazon.com/redshift/latest/dg/materialized-view-refresh.html
Context: Materialized view
Answer2: inner join
Answer3: where
Answer4: group by
Answer5: having
Answer6: sum, count
Answer7: built-in sql function without side-effect

Question: What should be taken into account when refreshing a view
Answer: If it depends on another view, it should be refreshed first
Page: https://docs.aws.amazon.com/redshift/latest/dg/materialized-view-refresh.html
Context: Materialized view

Question: How does RedShift decide whether it uses a materialized view in rewritting?
Answer: It uses it only if the view is up to date
Page: https://docs.aws.amazon.com/redshift/latest/dg/materialized-view-auto-rewrite.html
Context: Materialized view

Instruction: create materialized view name as query;
Page: https://docs.aws.amazon.com/redshift/latest/dg/materialized-view-auto-rewrite.html
Effect: Add a materialized vue, named name with query query and as content the current result of executing this command
Context: Materialized view

Instruction: refresh materialized view name;
Page: https://docs.aws.amazon.com/redshift/latest/dg/materialized-view-auto-rewrite.html
Effect: Recompute name's query and update the content of the view with the new result
Context: Materialized view

Name: Spectrum pricing
Definition: enables you to run SQL queries directly against the data in your S3 data lake, out to exabytes - you simply pay for the number of bytes scanned.
Page: https://aws.amazon.com/redshift/pricing/
Context: redshift

Name: Managed storage pricing
Definition: gives you the flexibility to pay only for the data that you store in RA3 clusters independent of number of compute nodes provisioned. You simply pay hourly for the total amount of data in managed storage.
Page: https://aws.amazon.com/redshift/pricing/
Context: redshift

Name: ML
Definition: enables you to use SQL to create, train, and deploy machine learning (ML) models. After you exhaust the free tier for Amazon SageMaker, you will incur costs for the creating your model and storage
Page: https://aws.amazon.com/redshift/pricing/
Context: redshift

Question: What is redshift spectrum pricing
Answer: N$/terabyte scanned
Page: https://aws.amazon.com/redshift/pricing/
Context: redshift
Answer2: with 10 megabyte minimal by query
Answer3: rounded to megabyte,
Answer4: Plus data access price (e.g. s3, glue, KMS)

Name: Advanced Query Accelerator
Definition: distributed and hardware-accelerated cache that enables Amazon Redshift to run up to 10x faster than other enterprise cloud data warehouses by automatically boosting certain types of queries.
Page: https://aws.amazon.com/redshift/pricing/
Context: redshift
Abbreviation: AQUA

Name: Concurrency scaling
Definition: can easily support thousands of concurrent users and concurrent queries, with consistently fast query performance, scaling up and down as needed
Page: https://aws.amazon.com/redshift/pricing/
Context: redshift

Name: Redshift
Definition: fully managed, petabyte-scale data warehouse service in the cloud
Page: https://docs.aws.amazon.com/redshift/latest/mgmt/welcome.html

Name: System table
Definition: tables contain information about your installation and about the various queries and processes that are running on the system
Page: https://docs.aws.amazon.com/redshift/latest/gsg/t_querying_redshift_system_tables.html
Context: Redshift

Name: Process id of Q
Definition: An id associated to the query Q
Page: https://docs.aws.amazon.com/redshift/latest/gsg/t_querying_redshift_system_tables.html
Variables: Q a query
Context: Redshift
Assuming: Q is received by redshift

Question: How to cancel a query
Answer: open a new connection/session to the database and uses CANCEL query_id
Page: https://docs.aws.amazon.com/redshift/latest/gsg/cancel_query.html
Context: Redshift

Question: How to find a query id
Answer: Look for queries in the system table stv_recents
Page: https://docs.aws.amazon.com/redshift/latest/gsg/cancel_query.html
Context: Redshift

Name: Business intelligence
Page: https://docs.aws.amazon.com/redshift/latest/dg/c_redshift-and-postgres-sql.html
Context: database
Abbreviation: BI

Name: online transaction processing
Page: https://docs.aws.amazon.com/redshift/latest/dg/c_redshift-and-postgres-sql.html
Context: database
Abbreviation: OLTP