Database Modeling
Alternative way for referring to a table row in an RDBMS
Tuple
SQL query to list all databases available for a user
SHOW DATABASES;
Volume, Velocity, and Variety
What is the fundamental data access limitation of a data warehouse?
Data warehouses are read-only
Another way to call a databases
Schemas
Attribute(s) used in RDBMS to connect/join tables
Foreign key
SQL Command that allows the aggregation of data which can allow the calculation of sum, count, and other mathematical operations
GROUP BY
Name one danger that relying on big data can carry.
Social profiling, social manipulation, the trolley problem.
The latest evolution of data warehousing that is capable of storing different types of data
Naming a table with an alternative name (e.g., when doing joins) is an example of ...
Table alias
Process for reducing data redundancies in tables and improving data integrity by reducing data models to different normal forms
Database object (RDBMS extension) that is designed to be executed after an event in a database happens
Trigger
What kind of NoSQL is MongoDB built on?
Document
What is the name of the artifact for high-speed multidimensional analysis and reporting on large volumes of data?
Online analytical processing (OLAP)
This number refers to the minimum and the maximum number of associations an entity can have.
Cardinality
Students can register for many classes, and every class can have several students. What kind of relationship is this?
M-N relationship
Database object (RDBMS extension) that allows the execution of functional code in a database
Store procedures or PL/SQL Functions
What are the four major types of NoSQL technologies?
Document, key-value, column-oriented, and wide-column
List the five components of Business Intelligence
Data storage, querying and reporting, data analysis, data visualizations, data analytics and monitoring.
The two main functions that data visualizations can have
Exploratory and explanatory
A customer can have many invoices. However, invoices can have only one customer. What kind of relationship is this?
SQL Command to filter aggregated data from a GROUP BY command
HAVING
Why are NoSQL databases faster to implement compared to RDBMS?
NoSQL removes or minimizes the database design phase of the implementation.
What does ETL stands for?
What is Ben Schneiderman’s mantra for designing interactive data visualizations?
"Overview first, zoom and filter, then details-on-demand.”