Files and Databases
Chapter 12
Organizing and Maintaining Digital Data
© The McGraw-Hill Companies, Inc., 2000
Ch 12 FAQ © The McGraw-Hill Companies, Inc., 2000 2 CCI
Database Administration
• The DBA has an all-encompassing job. Both the Network Administrator and the Database Administrator have the task of maintaining and maximizing systems while maintaining stable and quick access
Ch 12 FAQ © The McGraw-Hill Companies, Inc., 2000 3 CCI
Database Administration (continued)
• Therefore, it is often the very competent Administrator who is never noticed, because everything works.
Ch 12 FAQ © The McGraw-Hill Companies, Inc., 2000 4 CCI
Database Management Systems
• The accumulation of real, accurate, useable data is difficult
• Once a database is established, it is only as good as the above factors
Ch 12 FAQ © The McGraw-Hill Companies, Inc., 2000 5 CCI
Object-Oriented Database
• True object-oriented databases can handle the classification and storage of any objects.
• In an effort to become competitive, many relational databases have been modified to accept limited types of objects, such as Microsoft Access, which has pictures in its master example, Northwind
Ch 12 FAQ © The McGraw-Hill Companies, Inc., 2000 6 CCI
OODBMS
• Although Microsoft Access has pictures, such modified databases are not fully functional OODBMSs
Ch 12 FAQ © The McGraw-Hill Companies, Inc., 2000 7 CCI
Access Security
• Physical security is the easiest to provide and the easiest to break
• Using and changing good passwords should not be a difficult task for people
Ch 12 FAQ © The McGraw-Hill Companies, Inc., 2000 8 CCI
System Recovery• The number one problem
with system recovery is that businesses never really establish a test system to attempt recovery on. Once a year a full and partial recovery should be accomplished.
Ch 12 FAQ © The McGraw-Hill Companies, Inc., 2000 9 CCI
Mining, Warehouses, “Siftware”
• Data mart– is the classification of warehouse
into smaller, more numerous management segments
• Data must be verified and not assumed to be true just because it came from an extensive search
Ch 12 FAQ © The McGraw-Hill Companies, Inc., 2000 10 CCI
Privacy Enactment• Privacy Act of 1974, the
Freedom of Information Act, and Computer Matching and Privacy Protection Act– these all work, but it
generally takes long periods of time for individuals to obtain information
Ch 12 FAQ © The McGraw-Hill Companies, Inc., 2000 11 CCI
Finance Privacy
• If there is an inaccuracy, one avenue is to present your documentation to the company that posted the inaccuracy
Ch 12 FAQ © The McGraw-Hill Companies, Inc., 2000 12 CCI
Health Privacy
• Medical records can be lost– it is a good idea to
yearly put a backup copy of your updated medical records in a secure spot other than your home
Ch 12 FAQ © The McGraw-Hill Companies, Inc., 2000 13 CCI
Employment Privacy
• As employees, awareness of these laws are critical– do not assume that a telephone call
from an authorized business for employment information is, in fact, from them
– Verify the caller before giving out information