Lesson 7 Vocab (Terminology)

Structured quests language (SQL)

programming and query language common to many relational database management systems

database

data storage systems that organize electronic information into stud heed tables, allowing for the easy retrieval and interpretation of data

primary key

unique identifier for each record in a table

foreign key

a primary key from another table

structured data

divides information into clear, separate categories

non-structured data

information with no clear order or pattern

semi-structured data

data the falls between organized and unorganized, such as animal classifications

key-vaule database

type of non-relational database that uses a unique key

database administrators (DBAs)

IT role responsible for the configuration, management, and support of database applications

comma-separate value (CSV)

file type hiding commas and new lines to organize information into cells in a table format, and stored the table as a text file

eXtensible Markup Language (XML)

system for structuring documents so that they are human and machine readable

HyperText Markup Language (HTML)

system of coded tags the identify the structure of the documents files used for web pages

relational databases

structured database in which information is stored in tables where columns represent typed data fields and rows represent records

NoSQL

non-relational database for storing unstructured data, common with big data technologies

documents database

type of non-relational database, such as your computer’s file system

query

a request for in from a database

database schema

actual tables, columns, and relationships created in an RDBMS

schema

rules and structure of a particular database and its relations

database dump

one-time logical backup of a database