Shared Flashcard Set

Details

CSC 321 April 21 Notes
CSC 321 April 21 Notes
24
Computer Science
Undergraduate 3
04/21/2009

Additional Computer Science Flashcards

 


 

Cards

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
What are some solutions?
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
What is locking?
Definition
a way of preventing other users from accessing a record while it is being used
Term
What is 2 phase locking?
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
What can happen?
Definition
deadlock
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
What are types of locks?
Definition
(1) shared lock
(2) exclusive lock
Term
What is a shared lock?
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
the optimistic view
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
transaction is aborted
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
What is encryption?
Definition
all data is encoded and then de-coded when accessed properly
Term
What is authorization?
Definition
makes sure the person viewing the data is the proper person
Supporting users have an ad free experience!