Databases Reference
In-Depth Information
●
Formats (i.e., Contract DateTime: 20-Nov-2012 18:00:00)
●
Business rules used to calculate or derive the data
●
Changes in business rules over time
●
Additional metadata:
●
Data owner
●
Data owner contact information
●
Typical uses
●
Level of summarization
●
Related fields/objects
●
Existing queries/reports using this field/object
Operational metadata
Operational metadata is information about application runs, including:
●
Frequency
●
Record counts
●
Usage
●
Processing time
●
Security
Business intelligence metadata
BI metadata contains information about how data is queried, filtered, analyzed, and displayed in busi-
ness intelligence and analytics software tools. This includes:
●
Data mining metadata—the descriptions and structures of data sets, algorithms, and queries.
●
OLAP metadata—the descriptions and structures of dimensions, cubes, measures (metrics),
hierarchies, levels, and drill paths.
●
Reporting metadata—the descriptions and structures of reports, charts, queries, data sets, filters,
variables, and expressions.
●
Business intelligence metadata can be combined with other metadata to create a strong auditing
and traceability matrix for data compliance management.
The impact of metadata in the Big Data environment is discussed in later sections. The next sec-
tion discusses master data management and its impact on the world of data management.
Master data management
Master data management (MDM) is the process of standardization of key business entities and its
associated data processing rules across multiple operational applications and data consumption
applications like a data warehouse and datamarts within an organization into a central data man-
agement platform referred to as an MDM database. MDM primarily focuses on processing “refer-
ence or dimensional” data for key business entities (e.g., customer, products, policy, agent, location,
employee) that have been agreed on by all stakeholders as a “corporate shared asset” and is shared
across an organization.
