Data Resource Management Flashcards
the practices for achieving consistent access to and delivery of data across the spectrum of data subject areas and data structure types in the enterprise
data management
processed, organized, and structured data
information
often used to query tables
Structured Query Language (SQL)
concerned with data policies, data procedures, access control, backup and recovery, and data classification standards to govern business-critical data
data governance
looks for patterns and anomalies in data and then tries to discover meaningful patterns
Data discovery, or data mining
which is a broad range of tools and practices that endeavors to provide better business strategic decision-making and even claims to predict the future
business intelligence (BI)
store large amounts of unstructured data in their raw form and allow for flexible analysis
data lakes
well-thought-out collections of computer files that are storehouses of data for use by managers in making decisions
database
are where a database holds data
tables
rows
records
columns
fields
questioned
queried
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 queried to produce populations of information
Database Management Systems (DBMS)
A field in a database table that uniquely identifies a record in the table
Primary key
A field in a database table that provides a link between two tables in a relational database
Foreign key
The organization or layout of a database that defines the tables, fields and constraints, keys, and integrity of the database
Schema
data that is collected from all over the internet and other data sources
big data
4 Vs of Big Data
- volume
- variety
- veracity
- velocity
amount of data
Volume
form of the data
Variety
quality of data
Veracity
speed the data is created
Velocity
the examination of huge sets of data to find patterns, connections, outliers, and hidden relationships
data mining (data discovery)
resides in fixed formats
structured data
unorganized data that cannot be easily read or processed by a computer because it is not stored in rows and columns like traditional data tables
Unstructured data
