Data Warehouse Application

A Data Warehouse Application is a software-based application that ...

• See: OLAP Application, OLTP Application, Data Warehouse Instance, Data Warehouse Service.

---

---

References

2015

• http://docs.aws.amazon.com/redshift/latest/dg/c_redshift-and-postgres-sql.html
  • QUOTE: Amazon Redshift is based on PostgreSQL 8.0.2. Amazon Redshift and PostgreSQL have a number of very important differences that you must be aware of as you design and develop your data warehouse applications. Amazon Redshift is specifically designed for online analytic processing (OLAP) and business intelligence (BI) applications, which require complex queries against large datasets. Because it addresses very different requirements, the specialized data storage schema and query execution engine … For example, where online transaction processing (OLTP) applications typically store data in rows, Amazon Redshift stores data in columns, …

---