L4: Understanding Data

Question 1

Comma-separated values (CSVs)

Answer 1

Delimited text files where the delimiter is a comma. Used to store structured data.

Question 2

Delimited text file formats

Answer 2

Text files are used to store data where each line or row has values separated by a delimiter. A delimiter is a sequence of one or more characters specifying the boundary between values. Common delimiters include comma, tab, colon, vertical bar, and space.

Question 3

NoSQL databases

Answer 3

Databases are designed to store and manage unstructured data and provide analysis tools for examining this type of data.

Question 4

Online Transaction Processing (OLTP) Systems

Answer 4

Systems that focus on handling business transactions and storing structured data.

Question 5

Relational databases

Answer 5

Databases are designed to store structured data with well-defined schemas and support standard data analysis methods and tools.

Question 6

Sensors

Answer 6

Devices such as Global Positioning Systems (GPS) and Radio Frequency Identification (RFID) tags generate structured data.

Question 7

Spreadsheets

Answer 7

Software applications like Excel and Google Spreadsheets are used for organizing and analyzing structured data.

Question 8

SQL Databases

Answer 8

Databases that use Structured Query Language (SQL) for defining, manipulating, and querying data in structured formats.

Question 9

Tab-separated values (TSVs)

Answer 9

Delimited text files where the delimiter is a tab. Used as an alternative to CSV when literal commas are present in text data.