Databases Reference
In-Depth Information
directory on the database server to keep them readily
accessible.
Periodic updates are run over weekends to keep them
from interferring with user activities.
3.
You want to be able to return the number of rows
updated by the monthly update. How could you
do this? How would this change your require-
ments for running the update?
4.
You need to ensure that periodic updates run as
quickly as possible so that they are finished over
one weekend. What change can you make to
the databases to optimize write performance
instead of read performance?
5.
What kind of database object can you create
that will reverse this change with minimal effort
on your part? Describe what it would need to do.
6.
What periodic changes might you need to make
to this object?
1.
You plan to create objects as necessary sepa-
rately on each database. What type of database
object would you create to perform the periodic
acitivities? Why should you create separate
objects for each activity?
2.
Rather than running monthy updates, you de-
cide to run them each quarter. When you do, you
need to identify the month and year for which
each monthly update is being run. How can you
do this?
