Technology Flashcards
Master data
The data that provides context for business activity in the form of common and abstract concepts that relate to the activity.
Including: details, definitions and identifiers of internal and external objects involved within business transactions.
Reference Data
Data used to organise or categorise other data, or for relating data to information both within and beyond the boundaries of the enterprise. I.e. Codes, descriptions, or definitions.
Transactional data
Data that describes or records business events, which include an exchange of goods, money, and/or data describing the things that must be present for a transaction to occur.
Master Data Management
The ongoing reconciliation and maintenance of master data.
Involving, controls over master data values and identifiers to ensure consistent use across systems.
Ensuring consistency with a golden copy of data values.
Reference Data Management
Ensures an organisation has a complete set of accurate, consistent, up to date values for each concept represented. Represents control over definitions and domain values.
ISO8000
The global standard for data quality and enterprise master data.
Provides a description of the features and a definition if the requirements for the standard exchange of master data among business partners. (Data)
ISO9000
The global standard for quality management.
It specifies guidelines and procedures for documenting and managing business processes, providing a system for third party authentication. (management)
Lists
Lists code values matched to a description. This required an agreed description and promoted a uniform enterprise-wide vocabulary. Abbreviations must be agreed by both consumers and the technical capacity of the delivery system.
Taxonomy
A collection of controlled vocab terms organised into a parent child structure.
• Each term must have at least one relationship
• All of a parent’s children must be of the same type
Ontology
A sematic trading model defining structure and meaning, typically used to model non tabular data.
Internal Reference Data
Internal codes or descriptions of some business activities. They are formed when there is no external reference standard is available and must be made uniform across the organisation to prevent miss application/ data misuse.
Hierarchy
Classification structure arranged by level of detail into a parent child structure (not reference data)
Data Glossary
A data glossary is a repository of data and relevant information (ie. Relationships, origin, usage and format). An effective data glossary integrates the various business divisions usage of terminology and IT to form a uniform enterprise-wide approach.
Data Warehouse
- An integrated, centralised decision support database and the related software programs used to collect, cleanse, transform and store data from a variety of operational sources to support business intelligence.
- A subject oriented, integrated, time variant, non-volatile collection of summary and detailed historical data, used to support the strategic decision-making process for the corporation -Inmon
- A copy of transaction data specifically structured for query and analysis -Kimball
Business Intelligence
A set of concepts, methods and processes to improve business decision making, using information from multiple sources that could affect the business and applying experiences and assumptions to deliver accurate perspectives of business dynamics.