Info Mgmt Quiz 2 - Data & Data Storage
Primary Key
A field (or group of fields) that uniquely identifies a given entity in a table.
Data Warehouse
A logical collection of data - gathered from many different operational databases - that supports business analysis activities and decision-making tasks.
Entity
A person, place, thing, transaction, or event about which data is stored. Described by a set of attributes.
Foreign Key
A primary key of one table that appears as an attribute in another table and acts to provide a logical relationship among the two tables.
Attribute Instance
A single value of an attribute for an instance of an entity.
Data Lake
A storage repository that holds a vast amount of raw data in its original format until the business needs it (may not have a current use).
5 Characteristics of High Quality Data
Accurate, Complete, Consistent, Timely, Unique
Data Base Management Systems (DBMS)
Allows users to create, read, update, and delete data in a relational database.
Relationship
An association among entities.
Data Aggregation
Collection of data from various sources for the purpose of data processing.
CSVs
Coma Separated Values
Flat File Database
Contains a single table of data.
Data Mart
Contains a subset of data warehouse data.
Relational Database
Contains many tables of data that relate to one another through special key fields.
Four Primary Traits of the Value of Data
Data Type, Data Timeliness, Data Quality, Data Governance
DRIP
Data rich, information poor
External Data
Data that is not collected by your organization (can be public or bought).
Internal Data
Data that is procured and consolidated from different branches within your organization.
Data Visualization
Describes technologies that allow users to "see" or visualize data to transform data into a business perspective•.
Access Control
Determines types of user access, such as read-only access.
Access Level
Determines who has access to the different types of data.
Transactional data
Encompasses all of the data contained within a single business process or unit of work, and its primary purpose is to support the performing of daily operational tasks.
Analytical data
Encompasses all organizational data, and its primary purpose is to support the performing of managerial analysis tasks.
ETL
Extract, Transform, Load
Real-Time Data
Immediate, up-to-date data.
Data Validation
Includes the tests and evaluations used to determine compliance with data governance polices to ensure correctness of data.
Data Base
Maintains data about various types of objects (inventory), events (transactions), people (employees), and places (warehouses) as well as data about data (metadata).
Data Visualization Tools
Move beyond Excel graphs and charts into sophisticated analysis techniques such as pie charts, controls, instruments, maps, time-series graphs, and more.
Data Integrity Issues
Occur when a system produces incorrect, inconsistent, or duplicate data. These issues can cause managers to consider the system reports invalid and make decisions based on other sources.
Data Inconsistency
Occurs when the same data element has different values.
Infographics
Present the results of data analysis, displaying the patterns, relationships, and trends in a graphical format.
Password
Provides authentication of the user.
Real-Time System
Provides real-time data in response to requests (always changing).
Data governance
Refers to the overall management of the availability, usability, integrity, and security of company data.
Data Cube
The common term for the representation of multidimensional data.
Attribute (field, column)
The data elements associated with an entity.
Master Data Management (MDM)
The practice of gathering data and ensuring that it is uniform, accurate, consistent, and complete, including such entities as customers, suppliers, products, sales, employees, and other critical entities that are commonly integrated across organizational systems.
