WEEK 10

Question 1

IN WHAT WAY IS A DW SUBJECT OREIENTED

Answer 1

it is roganized by a fact table and dimensional table

Question 2

which system is for daily oeprations & has high frequency of update operaitons

Answer 2

OLTP

Question 3

where is data not updated

Answer 3

olap

Question 4

what is the osurce of data for a depementa data mart

Answer 4

EDW

Question 5

WHICH Of thefollowing can be relational db

Answer 5

ods, edw, data mart, operational db

Question 6

what is a logical dm composed of

Answer 6

views

Question 7

which of the following is typically created for a specific project and can be rmouved if no longer eneeded

Answer 7

data mart

Question 8

what is data called one it is cleaned and loaded into EDW

Answer 8

RECONCLIED DDATA

Question 9

charactieristcis of big data: 5 V’s

Answer 9

volume: much larger quantitiy of data than typical for relaitonal db

variety: lots of differnt data types and formats

velocity: data comes at very fast rate! (mobile sensors, web click stream)

veracity: trad data quality methods dont apply, how to judge accuracy and relevance?

value: big data is menaingless if it does not provide value toward some meanignufl goal

Question 10

schema on read vs schema on write

Answer 10

schema on read (USING DATA FOR BANA)
- data model determiner later, depends on how you want to use it
- caputre and store the data and worry about how you want ot use it late
- DATA MARTS ARE LIKE THIS! you create scehma when you are doing a rpoject

schema on write (STORING DATA)
- preexsiting data model
-this is how tradiitonal db are designed (relaitonal db)

Question 11

data lake

Answer 11

a large integraated repositoray for internal and external data that does not follow a prediefned schema

capture everything ,dive in anywhere, flexbile access, use ai to pulldata that ou ened

Question 12

trad database design: schema on write

Answer 12

gather requrements and strcture > format data model > database schema > db use based on the predefined schemaa

Question 13

big data appraoch: schema on read

Answer 13

collect large amts of data witg locally defined structures (JSON/XML…) > store data on lake > analyze store data to identify ways to structure> structure or org data during analysis process

Question 14

NoSQL

Answer 14

not only swl

Question 15

what does noSql mean

Answer 15

caetgory of recently intrduced data stroe and retrevial rech not based on the rleiatonal model

SCALING OUT rather than SCALING UP

Question 16

NOSQL CHARCATERISITCS

Answer 16

NATURAL FOr cloud environeemnt (sacling out)

suports schema on read (big data is happy)

largely open source

not ACID complaint (atomicity, conssitency, isolations and durability ) this is transaction processing

BASE- bascially available, soft state, eventually consistent

Question 17

NoSQL: key value stores

Answer 17

this is a simple pair of a key associated colelction of values

key is usually a string! db has no knowledgee of hte sturcture or meaning of the values

REDIS

Question 18

Document stroes NOSQL

Answer 18

like a key-value stroe, but documetn goes further than value.

Doc is structued so specific elecments can be manipuated separelty

MONGODB

Question 19

Wide colymn stores NOSQL

Answer 19

rows and columns

distribution of data based on both key values (records) and columns, using column groups/families; key is two dimensional

APACHE CASSANDRA

Question 20

Graph oriented db NOSQL

Answer 20

maintain ingo regarding the relations between data items! nodes with properties

conenceiotns betwen nodes/ relationships can also have proeprties

Neo4j

Question 21

mongo db

Answer 21

document-store db

BSON based storage (binary json)

collections: equivalent to tables in relational db, set of docs intended to be stored togehter

documents :equivalent to rows in relational db, docs do not need to have the same structure (unliek rows), _id property fo runiquely identify a row

relationships: _id property serves as primary key, another doc can have a foreing key as anotehr JSON property

Question 22

MOngo db what is table and what is row

Answer 22

collection=table
document =row

Question 23

ask if mongo db will on final, if yes then from 2:30 onwards:

Answer 23

https://ucalgary.zoom.us/rec/play/w-ozhS2JaZaj3_CT0YRHmU70ROoJCYw8aSQNwS5lEft-EiBnhPEhojS-Uk9cxqV5BkH7ZijL-hmJRIDI._rRt0Z1vyrQzztMe

Question 24

what is a cluster on mongo db

Answer 24

cluster is the server

Question 25

WHAT ARE JSON FILES!!