Redshift enables organizations to store and query large volumes of data quickly. It provides a cost-effective solution for real-time data analytics and decision-making. The architecture is based on columnar storage and massively parallel processing.
Use this profile to understand the building block briefly, place it in the model, and open related building blocks.
Technical building block: can be automated, integrated, or operated.
Concrete cog in the system that works inside larger relationships.
Amazon Redshift is a managed, columnar data warehouse for analytical SQL queries over large datasets.
Amazon launched Redshift as an AWS service in 2012. Its architecture builds on parallel database technology from ParAccel and was developed further for scalable cloud analytics.
Redshift distributes analysis across compute nodes: columns are read in parallel and results are combined. This accelerates scans and aggregations; transactional row updates belong in another system.
Queries read required columns rather than complete rows.
Nodes process data partitions simultaneously.
Integrated data is provided for analysis.
Redshift supports reporting, BI, and large analytics in the AWS ecosystem. Good results require suitable sorting, loading, and cost control; the service is optimized for analytics.
Where this building block is located in the topic model.
Explore how this building block connects to concepts, methods, technologies, and tools.
These sources establish the term and its professional meaning.
All direct connections of the current building block in a compact text view.
This classification shows where the building block typically matters, how demanding it is, and what kind of impact it has in the model.
The level within the organization (enterprise, domain, team) at which the AssetBlock is applied.