Data Acquisition Flashcards Preview

Business Warehousing > Data Acquisition > Flashcards

Flashcards in Data Acquisition Deck (31):
1

process of providing users and systems with access to data is called as

data provisioning

2

During data provisioning _________ is performed to ensure the _________ remains intact

replication , source

3

structured data is in the human readable format
true/false

false computer-readable format

4

structured data does not contain inconsistencies, redundancies, ommissions and errors
True/false

false

5

structured data contains data models t/f

true

6

metadata is found in
a) structured data
b) unstructured data

a) structured data

7

values are _______in structured data

Proscribed. each cell contains values of a certain format and specific length a.The data is related to each other

8

VALUE ARE _________ in unstructured data

topical. no size ,unrelated ,varying length & content

9

spreadsheets are error-prone because multiple users can access it t/f

t

10

_______,__________& ____________ are forms of flat files

ASCII,CSV ,other delimited files (tab delimited )

11

Disadvantage of spreadsheets are -

error prone
no security(multiple access)

12

Example of using flat file

1. used to transfer data ,download data in flatfile format from DB and use it to upload in another DB
2. oracle db store scolumn as customer_name ,Mysql as cust_name .in order to map these values we can download db as flatfile ,correct them and load in the DB

13

Flat fie is an example of nonrelational db T/F

T

14

Disadvantage of flat file-multiple rows of same data.
advantage -easy for appendng and sorting

multiple rows of same data.

15

3 types of anaomalies

insert
uodatse
delete

16

Transactional systems are normalized up to _ NF

3

17

Tagged data examples :

XML,XLBR,HTML

18

XBLR ABBR

Extensible Business Reporting Language

19

which is used for financial stmts?
xml or xblr

xblr

20

Email ,social media ,recording is analyzed via NLP
T/F

T

21

WHAT IS JETPAC

Image recognition s/w.analyzes the instagram data to tag the locations in the pictures

22

______data is common source of data for business analysis

Transactional data

23

Characteristics of txn systems

txn systems
data shud be functionally oriented
should handle business processes
operational
small uniform txn
maintain level of detail
current
speed
can be updated
optimized for storage
shud be available all time (6 figure)
concurrent

24

integrated txn systems that connect to , updates all functional areas in business is called the ________

ERP system

25

ERP operates in functional areas such as

Procurement
inventory
Accounting/budgeting
billing
human resource
shipping
warehouse

26

A place where data is stored and prepared for analytical processes is called
informational/transactional system

informational

27

txn systems support managerial requirements
T/F

F supports operational requirements

28

webcrawlers are also called_______

info agents /spiders

29

click stream analysis

analysis of the data based on number of customer clicks,

30

clickstream analysis

analysis of the data based on the number of customer clicks,

31

clickstream data is stored as _________data

semistructured