![]() ![]() Your client application interacts directly only with the leader node. If a cluster is provisioned with two or more compute nodes, an additional leader node coordinates the compute nodes and handles external communication. The core infrastructure component of an Amazon Redshift data warehouse is a cluster.Ī cluster is composed of one or more compute nodes. For more information, see Amazon Redshift and PostgreSQL JDBC and ODBC. For information about important differences between Amazon Redshift SQL and PostgreSQL, see Amazon Redshift and PostgreSQL.Īmazon Redshift communicates with client applications by using industry-standard PostgreSQL JDBC and ODBC drivers. Amazon Redshift is based on industry-standard PostgreSQL, so most existing SQL client applications will work with only minimal changes. ![]() This section introduces the elements of the Amazon Redshift data warehouse architecture as shown in the following figure.Īmazon Redshift integrates with various data loading and ETL (extract, transform, and load) tools and business intelligence (BI) reporting, data mining, and analytics tools. This section presents an introduction to the Amazon Redshift system architecture. When you execute analytic queries, you are retrieving, comparing, and evaluating large amounts of data in multiple-stage operations to produce a final result.Īmazon Redshift achieves efficient storage and optimum query performance through a combination of massively parallel processing, columnar data storage, and very efficient, targeted data compression encoding schemes. Using Amazon Redshift with Other ServicesĪn Amazon Redshift data warehouse is an enterprise-class relational database query and management system.Īmazon Redshift supports client connections with many types of applications, including business intelligence (BI), reporting, data, and analytics tools.Internal Architecture and System Operation. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |