#2: Application + Workload Fundamentals (Part 2)

Question 1

Concurrency

Answer 1

database can be accessed by multiple users at the same time

Question 2

Security

Answer 2

determines access rights of users

Question 3

Integrity

Answer 3

database structure and rules improve integrity of the data

Question 4

Data descriptions

Answer 4

a data dictionary provides a description

Question 5

Front End Applications…

Answer 5

generate, generate the workload

Question 6

Databases…

Answer 6

back end applications managing the data, organize/index/modify/access the data

Question 7

Storage…

Answer 7

storing and protecting the data, data is accessible to the end user through the apps

Question 8

A workload is…

Answer 8

the total requests made by users and apps of a system

Question 9

A data “write” or “input” is

Answer 9

new data that is being saved or existing data that is being changed

Question 10

A data “read” or “output” is

Answer 10

existing data that is being reviewed by a business user

Question 11

I/O (input/output)

Answer 11

combination of reads and writes

Question 12

IOPS (inputs/outputs per second)

Answer 12

measure of storage system workloads