Database Reference
In-Depth Information
A meter is an entity containing a related set of measures. It is a bucket
of common measures. As a group, common measures address a business
concern such as
Profitability
,
Employee Satisfaction
, or
Sales
.
Also known as a business key, a natural key is what the business sees as
the unique identifier for an entity.
natural key
NoSQL is a name for the category of databases built on non-relational
technology. NoSQL is not a good name for what it represents as it is less
about how to query the database (which is where SQL comes in) and
more about how the data is stored (which is where relational structures
comes in).
NoSQL
Normalization is the process of applying a set of rules with the goal of
organizing
something
. With respect to attributes, normalization ensures
that every attribute is single valued and provides a fact completely and
only about its primary key.
normalization
Object includes any data model component such as entities, attributes,
and relationships. Objects also include any MongoDB component such
as fields, documents, and collections.
object
Also known as sharding in MongoDB, a partition is a structure that di-
vides or separates. Specific to the physical design, partitioning is used to
break a table into rows, columns or both. There are two types of parti-
tioning - vertical and horizontal. Vertical partitioning means separating
the columns (the attributes) into separate tables. Horizontal means sep-
arating rows (the entity instances) into separate tables.
partition
The physical data model (PDM) represents the detailed technical solu-
tion. The PDM is the logical data model modified for a specific set of
software or hardware. The PDM often gives up perfection for practical-
ity, factoring in real concerns such as speed, space, and security.
physical data
model (PDM)
primary key
