Data Overview

Question 1

Data

Answer 1

units of information

Question 2

Data Documents

Answer 2

collections of data
datasets, databases, datastores, warehouses, notebooks

Question 3

Data Sets

Answer 3

logical grouping of data
generally related or same data is grouped

Question 4

Data Types

Answer 4

numeric, integer, float (decimal)
text, character, boolean
composite, binary

Question 5

Schema

Answer 5

blueprint of database
formal language which describes the structure of data

Question 6

schemaless

Answer 6

primary cell of database can accept many types of data

Question 7

query (2 types)

Answer 7

requests for data results (reads) or data performing operations (writes)

Question 8

relational data

Answer 8

structured info that reflects relationships between data in tabular form

Question 9

database index

Answer 9

improves speed of reads from database
assigning things an ID and referencing ID for simplicity

Question 10

pivot table

Answer 10

table of stats that summarize data

Question 11

non relational data

Answer 11

key/value
document
graphs
columnar

Question 12

data warehouse

Answer 12

column oriented data
aggregation
hot! queries fast
infrequent, not for real-time

Question 13

data mart

Answer 13

subset of data warehouse
sales, marketing, supply chains, etc.
more frequent