Midterm 2: Ch. 5, 6, 8, labs 3-6

Question 1

(not a question) Cards formatted as:

Answer 1

[Chapter #] | [Flashcard first side]

Question 2

5| What is a database?

Answer 2

An organized connection of data; a collection of integrated records.

Question 3

5| What is the purpose of databases?

Answer 3

To organize and keep track of multiple themes, such as grades or emails.

Question 4

5| When should data be stored in a spreadsheet versus a database?

Answer 4

Single theme - store in a spreadsheet; Multiple themes - store in a database.

Question 5

5| Why is it important to learn about databases?

Answer 5

Databases are ubiquitous in commerce and essential for turning data into useful information.

Question 6

5| What are the components of a database?

Answer 6

Hierarchy of data elements and relationships among rows.

Question 7

5| What is a Database Management System (DBMS)?

Answer 7

A system that creates, processes, and administers databases.

Question 8

5| What are the functions of a DBMS?

Answer 8

1. Creating the Database and its structures 2. Processing the database 3. Administering the database.

Question 9

5| What are some licensed DBMS vendors?

Answer 9

IBM, Microsoft, Oracle, and others.

Question 10

5| What is an example of an open-source DBMS?

Answer 10

MySQL: License-free for most applications.

Question 11

5| What are the DBMS process operations?

Answer 11

1. Read 2. Insert 3. Modify 4. Delete data.

Question 12

5| What is SQL?

Answer 12

Structured Query Language, an international standard language for creating and processing databases.

Question 13

5| What is an example SQL command?

Answer 13

INSERT INTO Student ([Student Number], [Student Name], H W1, H W2, MidTerm) VALUES (1000, ‘Franklin, Benjamin’, 90, 95, 100);

Question 14

5| What are the four elements of a database application?

Answer 14

Purposes, Forms, Reports, Queries, and Application programs.

Question 15

5| What do forms in a database application do?

Answer 15

View data; insert new, update existing, delete existing data.

Question 16

5| What are reports in a database application?

Answer 16

Structured presentation of data using sorting, grouping, filtering, and other operations.

Question 17

5| What are queries in a database application?

Answer 17

Search using values provided by the user.

Question 18

5| What are application programs in a database application?

Answer 18

Provide security, data consistency, and special purpose processing.

Question 19

5| What are nontraditional DBMS products?

Answer 19

DBMS that store new data differently, focusing on ACID transactions.

Question 20

5| What does ACID stand for?

Answer 20

Atomic, Consistent, Isolated, Durable transactions.

Question 21

5| What is Dynamo?

Answer 21

Amazon-developed nonrelational data store.

Question 22

5| What is Bigtable?

Answer 22

Google-developed nonrelational data store.

Question 23

5| What is Cassandra?

Answer 23

Facebook-developed nonrelational data store using concepts from both Dynamo and Bigtable.

Question 24

5| What is a Top-Level Project (TLP)?

Answer 24

Open-source Cassandra by Apache.

Question 25

5| What is New SQL DBMS?

Answer 25

Processes very high levels of transactions like NoSQL DBMS but provides ACID support.

Question 26

5| What are in-memory DBMS using SQL extension?

Answer 26

Examples include SAP HANA and Tableau.

Question 27

5| What is Slick Analytics?

Answer 27

A strategy for merging storage and analysis of cloud-based data.

Question 28

5| What was Laredo Petroleum’s old approach?

Answer 28

Used numerous spreadsheets and manual calculations, diminishing the value of data.

Question 29

5| What is Laredo Petroleum’s new approach?

Answer 29

Uses cloud storage and cloud analytics.