Database Reference
In-Depth Information
•
Grant or revoke database access privileges to users.
•
Arrange periodic backups of database content.
•
Manage storage allocation.
•
Install software upgrades.
•
Collect data access statistics and monitor usage.
•
Fine-tune the database as necessary.
•
Oversee data integrity provisions.
•
Recover database from hardware and software malfunctions.
Chapter 14 extensively discusses the administration functions in a database envi-
ronment. You will learn a great deal more about the functions of the data adminis-
trator and the database administrator in that chapter.
PLANNING FOR THE DB SYSTEM
Before we begin a database project, we have to assess how the management and
users understand data systems in the context of the organization. What do they think
about the utility of data systems to support the core business and the business
processes? If they are from a file-oriented environment, their views are likely to be
narrow and limited. The planning process broadens their views about data systems
and moves them forward to appreciate the benefits of information sharing. Plan-
ning involves senior management and therefore provides a means for them to
express their support and sponsorship.
Planning sets the direction and scope for the database project. The project will
be a new type of project for those organizations launching a database for the very
first time. Even for those companies that are expanding their database systems or
migrating from one commercial database system to another, the project may offer
new challenges. The planning process identifies the challenges; it also brings out the
opportunities afforded by database systems.
We can think of the planning process as containing two distinct subphases. In one
subphase, you study and interpret the impact of the organization's long-term plan
on the proposed database system. If the company is planning for expansion into
three new territories within the next two years, what types of data must be included
in the database? The other subphase of planning relates to the actual planning for
the database system based on the current requirements. The two subphases are
important to complete the planning because you must combine current and future
requirements in the design.
The planning process, naturally, is the first phase or step in DDLC. Although
some limited portion of the next phase may be started while planning is being com-
pleted, generally organizations tend to complete the planning phase before pro-
ceeding to the other phases. Planning sets the tone and direction of the entire
project, and this is important for the conduct of the other phases. How long should
planning last? It depends on the situation in each organization. If your organization
is one for which a database project is completely new, then the people doing the
planning must carefully review all relevant issues and take the time to complete the
Search WWH ::
Custom Search