Database Reference
In-Depth Information
The grain is the lowest level of detail available in the meter on a dimen-
sional data model.
grain
A graph database is a NoSQL database designed for data whose relations
are well represented as a set of nodes with an undetermined number
of connections between those nodes. Graph databases are ideal for cap-
turing social relations (where nodes are people), public transport links
(where nodes could be bus or train stations), or road maps (where nodes
could be street intersections or highway exits).
graph
An index is a pointer to something that needs to be retrieved. The index
points directly to the place on the disk where the data is stored, thus re-
ducing retrieval time. Indexes work best on attributes whose values are
requested frequently but rarely updated.
index
A key-value database is a NoSQL database that allows the application to
store its data in only two columns (“key” and “value”), with more com-
plex information sometimes stored within the “value” columns.
key-value
A logical data model (LDM) is the detailed business solution to a busi-
ness problem. It is how the modeler captures the business requirements
without complicating the model with implementation concerns such as
software and hardware.
logical data
model (LDM)
A measure is an attribute in a dimensional data model's meter that helps
answer one or more business questions.
measure
Metadata is text, voice, or image that describes what the audience wants
or needs to see or experience. The audience could be a person, group, or
software program.
metadata
meter
