Storage Technologies

Question 1

Redis

Answer 1

Used as a database or caching layer. Resolves complex programming problems and reduces latency

Question 2

MongoDB

Answer 2

Stores in JSON-like formats. Store large formats of data with no structure.

Question 3

MySQL

Answer 3

Data warehousing, e-commerce, logging apps. Most common use is web database. PHP/Java based web apps requiring a DB backend.

Question 4

SQLite

Answer 4

Lite = lightweight in setup, db admin, and required resources. Self-contained, serverless, zero configuration. Highly transactional

Question 5

PostgreSQL

Answer 5

Store data in multiple lang. (C, C++ Java and is designed to be extensive

Question 6

Oracle SQL

Answer 6

Lang. structure and users access data in Oracle. Apps. tools, database, and allow users to access the database.

Question 7

MSFT SQL Server

Answer 7

Controls data storage, processing and security. Manages files, tables, pages, indexes, data, etc.

Question 8

SQL

Answer 8

Structured Query Language – statements used to generate queries from client to the database. SQL is the main language that allows your DB servers to store and edit the data.

Question 9

Memcached

Answer 9

Distributed memory cashing system speeding up websites by having large databasing in Dynamic Memory to reduce pressure on a server when it gets external requests

Question 10

Couchbase

Answer 10

Server, originally known as membase, multi-model NoSQL document oriented databage for interactive apps. Low latency data and manages large scale web, mobile, IoT apps.

Question 11

Hadoop

Answer 11

Runs apps on clusters of commodity hardware. Massive storage for any kind of data. Unstructured language and any type of tasks/jobs

Question 12

Bigquery

Answer 12

Enterprise data warehouse allows super fast SQL queries by using Google’s infrastructure. Completely managed solution, no servers or installation of software

Question 13

Hive

Answer 13

Translates input program in the hive SQL like language to Java map reduce jobs. Runs clusters to produce the answer. Functions analogously to a compiler and translates high level construct to lower level language for execution.

Question 14

Cassandra

Answer 14

Single logical database that divides nodes evenly across clusters

Question 15

Amazon Redshift

Answer 15

Collect and store RDBMS applications and programs

Question 16

Kafka

Answer 16

Streaming platform to subscribe to a stream of records, primarily in data analytics and “data lakes”

Question 17

Elasticsearch

Answer 17

Analytics engine for major scale. Manage/sort large amounts of data quickly. The underlying engine for powering apps.

Question 18

MEAN Stack

Answer 18

MongoDB as the database system, Express JS as the framework to build apps in Node, Angular JS as JS framework developed by google, Node.js is server side execution environment. MEAN is all javascript

Question 19

Spark

Answer 19

Apache Spark cluster-based framework for computing entire clusters with implicit data parallelism and fault tolerance

Question 20

Greenfield

Answer 20

Developing software from scratch. New project, so work that doesn’t follow work – opposite of Brownwork, which is upgrades off former work.