Term
| What are some DBMS Functions? |
|
Definition
(1) update and retrieval of data
(2) provide catalog services means to access metadata
(3) transaction support |
|
|
Term
| What is transaction support? |
|
Definition
| A sequence of operations that is perceived by a user as a single transactions |
|
|
Term
| What does it mean to support concurrent update? |
|
Definition
| Multiple users can update the system concurrently and the data remains correct |
|
|
Term
|
Definition
(1) Batch processing
(2) Locking |
|
|
Term
| What is batch processing? |
|
Definition
| keeping a separate fill of all changes to the data and these changes are executed at a given time |
|
|
Term
|
Definition
| a way of preventing other users from accessing a record while it is being used |
|
|
Term
|
Definition
(1) growing phase
(2) shrinking phase |
|
|
Term
| What is the growing phase in 2-phase locking? |
|
Definition
| records are locked as needed |
|
|
Term
| What is the shrinking phase in 2-phase locking? |
|
Definition
| records are all unlocked when transaction is complete (committed) |
|
|
Term
|
Definition
|
|
Term
| What are some issues with locks? |
|
Definition
(1) lock granularity
(2) types of locks |
|
|
Term
| What is lock granularity? |
|
Definition
| shit that deals with How much to Lock? |
|
|
Term
|
Definition
(1) shared lock
(2) exclusive lock |
|
|
Term
|
Definition
| allows multiple users to access for read only |
|
|
Term
| What is an exclusive lock? |
|
Definition
| allows only one user access |
|
|
Term
| What is time stamping sometimes called? |
|
Definition
|
|
Term
| How is time stamping the optimistic view? |
|
Definition
| it allows all users to access all records |
|
|
Term
| In time stamping, what would happen if a conflict occurs? |
|
Definition
|
|
Term
| What is the difference between security and privacy? |
|
Definition
| security is simply allowing different people to access different parts of the database and privacy is more ethical issue of who should view what |
|
|
Term
| What could be a privacy issue? |
|
Definition
| you can't look up someone else's grades |
|
|
Term
| What is an example of security? |
|
Definition
| how the computer doesn't allow you to look up somebody's grades |
|
|
Term
| What are some security services for database management systems? |
|
Definition
(1) encryption
(2) authorization |
|
|
Term
|
Definition
| all data is encoded and then de-coded when accessed properly |
|
|
Term
|
Definition
| makes sure the person viewing the data is the proper person |
|
|
