The Database as a Networked Server - Implementing Database Security and Auditing - page 64

Figure 3.2
Data access
diagram showing
database
connection
endpoints.
Figure 3.2 is similar to a network diagram, in that it shows you which cli-
ents are connecting to which database server. However, because data access
diagrams are database-specific, they can also show you what application is
being used to access the database and what type of access it is doing (e.g.,
DML, SELECT, DDL). This type of network diagram is extremely useful
because it allows you to quickly verify that your database is being accessed
from appropriate applications and/or people.
Data access diagrams are useful for inspecting and verifying connection
endpoints for a few databases or when you choose to group many end-
points. For example, they are useful when inspecting a certain application
environment. They are also useful when you need to present information to
upper management. However, like network diagrams, they can become