RedShift

Question 1

What are the two different theories behind the name “RedShift”?

Answer 1

Either, named after Hubble’s law of determining the distance of stars, or “shifting” away from Oracle.

Question 2

Describe RedShift

Answer 2

Pedabite capable data warehouse.
fully managed service.
Extremely cost effective compared to teradata or neteesa.
Can work with almost every BI tool straight from the box (because it’s JDBC and ODBC compatible) and is PostgreSQL compatible.
Features Parallel Processing and Columnar data stores (optimized for complex queries).
New feature allows querying data directly from S3: RedShift Spectrum.

Question 3

JDBC

Answer 3

Java Database Connectivity: Java Database Connectivity is an API (application programming interface) for the programming language Java, which defines how a client may access a database. It is a Java-based data access technology used for Java database connectivity. It is part of the Java Standard Edition platform, from Oracle Corporation

Question 4

ODBC

Answer 4

Open Database Connectivity: Open Database Connectivity is a standard API (application programming interface) for accessing database management systems. The designers of ODBC aimed to make it independent of database systems and operating systems.

Question 5

Columnar Data Stores

Answer 5

A columnar database is optimized for fast retrieval of columns of data, typically in analytical applications. Column-oriented storage for database tables is an important factor in analytic query performance because it drastically reduces the overall disk I/O requirements and reduces the amount of data you need to load from disk.

Question 6

Data Lake

Answer 6

A large repository of data upon which you put a framework on top of to make sense/use of it.

Question 7

How does RedShift shorten the distance from collecting data to making sense of the data?

Answer 7

Query raw data without extensive pre-processing.
Lessen time from data collection to data value.
Identify correlations between disparate data sets.