Database Reference
In-Depth Information
A data modeler is one who confirms and documents data requirements.
This role performs the data modeling process.
data modeler
Data modeling is the process of learning about the data, and regardless
of technology, this process must be performed for a successful applica-
tion.
data modeling
The DBA is the data professional role responsible for database admin-
istration and the function of managing the physical aspects of data re-
sources including database design and integrity, backup and recovery,
performance and tuning.
database ad-
ministrator
(DBA)
Denormalization is the process of selectively violating normalization
rules and reintroducing redundancy into the model (and therefore the
database). This extra redundancy can reduce data retrieval time, which is
the primary reason for denormalizing. We can also denormalize to create
a more user-friendly model.
denormalization
A developer is a person who designs, codes and/or tests software. Syn-
onymous with software developer, systems developer, application deve-
loper, software engineer, and application engineer.
developer
A dimension is a subject area whose purpose is to add meaning to the
measures. All of the different ways of filtering, sorting, and summing
measures make use of dimensions. Dimensions are often, but not exclus-
ively, hierarchies.
dimension
A dimensional model (also called “dimensional data model”) focuses on
easily answering business questions such as “What is our
Gross Sales
Amount
by day, product, and region?” Dimensional models are built for
the three S's of
Simplicity
,
Speed
, and
Security
.
dimensional
model
A set of somewhat related data often viewed together. The MongoDB
document is analogous to the concept of a record in a relational database.
document
