Chapter 5. Data Management

Question 1

what do all IT systems need?

Answer 1

data to work with

Question 2

What are some reasons managing data is hard?

Answer 2

1) data increases exponentially w time (metadata)
2) data is scatteered!
3) comes from too many sources

Question 3

does data stay current for long

Answer 3

no! there is data rot

Question 4

data rot

Answer 4

problems with the physical media that stores data

exposure to heat light, cold, dust can damage them

Question 5

what is clickstream data

Answer 5

data that visitors to a site produce when they visit a site and click on hyperliinks

Question 6

is clickstream data important

Answer 6

yes! it allows us to track a users behaviours and patterns

Question 7

bill 198

Answer 7

-complicates data management
-requires companies to state how data is being used
-auditors must approveo of it

Question 8

what is data governance??

Answer 8

-solution to data management problems
-set of rules the org follows that are about handling data
-goal is to make info avialbe transparent and useful

Question 9

how can we implement data governance

Answer 9

through using master data managemetn

Question 10

what is master data management

Answer 10

management of master data!

-management of the most important data that allows companies to organize one “single version of the truth”

Question 11

what is master data

Answer 11

the CORE data!!! that is in the entire info system

customer, product, employee, vendor, geographic location, and so on, that span the enterprise’s information systems.

Question 12

difference between master data and transactional data

Answer 12

master data: core data that spans multiple transactional data points

transactional data: generated/ captured during operationos, this is about TRANSACTIONS (this is the specific products data)

Question 13

ex: Mary jones purchase one Samsung 42-inch LCD television, part number 1234, from Bill Roberts at Best Buy, for $2,000, on April 20, 2020.

what is master data
what is transactional data

Answer 13

customer, product, part, location, date

samsung 42 inch, 1234 part number, bill roberts, best buy, 2000, april 20,2020

Question 14

sources of data

Answer 14

INTERNAL
PERSONAL
EXTERNAL
NEWS

Question 15

Data Governance

Answer 15

-tries to create a single source of truth
-procedures and policies for data management
-rules about creating, collecting. handling, protecting data

Question 16

can legislation affect data archiving requirements?

Answer 16

yes!! PIPEDA in 2004 and now the anti-spa legislation