Transcript Chapter 12 FAQ

Files and Databases
Chapter 12
Organizing and Maintaining Digital Data
© The McGraw-Hill Companies, Inc., 2000
Database Administration
• The DBA has an allencompassing 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
2 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
3 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
4 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
5 CCI
OODBMS
• Although Microsoft
Access has pictures,
such modified
databases are not
fully functional
OODBMSs
Ch 12 FAQ
© The McGraw-Hill Companies, Inc., 2000
6 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
7 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
8 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
9 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
10 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
11 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
12 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
Ch 12 FAQ
© The McGraw-Hill Companies, Inc., 2000
13 CCI