article thumbnail

How to Build a Performant Data Warehouse in Redshift

Sisense

Fundamentally they are different than transactional databases we’ve seen in the past, and before we jump into how to build your data warehouse, it’s important to understand that distinction. OLTP vs OLAP. First, we’ll dive into the two types of databases: OLAP (Online Analytical Processing) and OLTP (Online Transaction Processing).

article thumbnail

What Is Embedded Analytics?

Jet Global

Data Environment First off, the solutions you consider should be compatible with your current data architecture. We have outlined the requirements that most providers ask for: Data Sources Strategic Objective Use native connectivity optimized for the data source. Requirement ODBC/JDBC Used for connectivity.