Introduction - Database Processing: Fundamentals, Design, and Implementation - page 20

Figure 1-22
Databases Originating
from Database redesign

Database
Design 2

Database 1

Migration

OR

Database 1

Database
Design 3

+

Database Integration

Database 2

What you Need to Learn

In your career, you may work with database technology as either a user or as a database admin-
istrator. As a user, you may be a knowledge worker who prepares reports, mines data, and does
other types of data analysis, or you may be a programmer who writes applications that process
the database. Alternatively, you might be a database administrator who designs, constructs,
and manages the database itself. Users are primarily concerned with constructing SQL state-
ments to get and put the data they want. Database administrators are primarily concerned with
the management of the database. The domains for each of these roles are shown in Figure 1-23.

By The Way The most exciting and interesting jobs in technology are always those on
the leading edge. If you live in the United States and are concerned about
outsourcing, a study by the Rand Corporation 2 indicates that the most secure jobs in the
United States involve the adaptation of new technology to solve business problems in
innovative ways. Working with databases will help you learn problem solving skills, and
3 of the top 10 jobs recently listed on the CNNMoney Web site use database knowledge
and related skills (See: http://money.cnn.com/magazines/moneymag/best-jobs/2011/
fast-growing-jobs/1.html ) .

Figure 1-23
Working Domains of
Knowledge Workers,
Programmers, and
Database administrators

Web Server
with PHP or
Java Applications

S
Q
L

Client
Applications
in C# or VB.NET

Database DBMS

Users

• Access Database Engine (ADE)
• SQL Server
• MySQL
• Oracle Database

Web Portal
with Reporting
Applications

Knowledge Worker
and Programmer

Database Administrator

2 Lynn A. Karoly and Constantijn W. A. Panis, The 21st Century at Work (Santa Monica, CA: The Rand
Corporation, 2004).