Module 4 Flashcards
Data Management
tools for achieving consistent access to and delivery of data across the spectrum of data subject areas and data structure types in the enterprise.
Data
unorganized info
Information
processed, organized, and structured data
Data Governance
standards to govern business-critical data
Database Management System (DBMS)
An application software that is used to create a collection of related files that consist of records of data separated by fields that can be queired to produce populations of information.
Relational Databases
tables connected to tables
- Structured Query Language (SQL)
data mining software program
Primary Key
A field in a database table that uniquely identifies a record in the table
Foreign Key
A field in a database table that provides a link between two tables in a relational database.
Schema
The organization or layout of a databse that defines the tables, fields, and constraints of the database.
Query
tool that lets you ask your data questions which leads to answers.
Big Data
large and expansive collected data sets
Data Mining
Examination of huge sets of data to find patterns and connections and identify outliers and hidden relationships.
Volume
Amount of data
Variety
Form of the data (Structured or Unstructured)