IT Vocab 9 Flashcards
The process of asking specific questions to help interpret big data
Big Data Analytics
A container in a relational database that is comprised of fields (columns) and records (rows)
Table
A person who is responsible for designing, maintaining, backing up, and securing an organization’s databases
Database Administrator
A person who focuses on data analysis, especially as it related to data mining and big data analytics. These positions require even more advanced programming and analytical skills
Data scientist
Data that doesn’t follow a clear pattern
Unstructured data
Data that can be divided into discrete categories
Structured Data
An easy-to-read listing of the results of a query
Report
A method of accessing a database using forms that allow users to interact with the database
User Interface Access
A person who designs and implements databases, usually by writing SQL code and conducting performance tests to ensure database optimization
Database developer
Data that has some discrete categories but also other information that doesn’t follow a clear pattern
Semi-Structured data
a single attribute of each record in a table
Field
Nonrelational databases that arise from big data
NoSQL
A broad and open-ended analysis of extracted big data
Data Mining
Database commands that change the structure, or schema, of the database
Data Definition language (DDL)
A method of accessing a database using a graphical user interface that allows users to select what actions they want to perform on a database
Query Builder
A graphical interface that allows users to query a database by filling in information on the form
Form
A method of asking questions about the data stored in a database
Query
A method of accessing a database using custom computer programs
Programmatic Access
A structured set of data held in a computer, usually in a way that is accessible in multiple ways
Database
A database that is structured to recognize the relationship between items of information
Relational Database
Software that allows users to define, manipulate, retrieve, and manage data stored in a database. Examples are Microsoft SQL Server, Oracle Database, MySQL, and Microsoft Access
Database Management System (DBMS)
A field in a second table that matches the primary key in another table
Foreign Key
A field in a table that uniquely identifies a row
Primary key
a single instance of an object stored in a database table
Record
A computer language used by most relational databases for creating queries
Structured Query Language (SQL)
Database commands that modify the records within the database and not the schema itself
Data manipulation language (DML)
