Data management

Question 1

Define Pivoting

Answer 1

Pivoting is changing the lens through which you view data…i.e. chaning a product data report with year and country to be by year instead of by product.

Question 2

Define Dicing

Answer 2

Dicing is breaking a large chunk of data up into smaller sections. Creates a subset of data by reducing the dimensions, but can still be more than 1D.

Question 3

OLTP

Answer 3

Online Transaction Processing system

Question 4

OLAP

Answer 4

Online analytical processing - Slicing, Dicing, Pivoting, Drilling - these are the analytical processes sitting above the data warehouse layer.

Question 5

Drilling

Answer 5

More or less detail of the same data

Question 6

Define Slicing

Answer 6

Creates a subset of data by reducing the dimensions to one (i.e. a table)

Question 7

Explain difference between bits and bytes

Answer 7

bits are individual 1s and zeros. A byte is a grouping of 8 bits. i.e. 64bit system is 8 bytes as the typical smallest addressable memory

Question 8

explain the dcimal, binary, octal, and hexadecimal numbering systems

Answer 8

decimal is our normal 1-10 system. binary is 1-0 (i.e. 0001 is 1). Octal uses a 0-7 system..(i.e. 1 = 1, 8 = 10).

Hexadecimal uses 0-9 and A-F to encode values (base 16) Hexadecimal 10 = A and 525 = 20D

Question 9

What are the common forms of character representation

Answer 9

ASCII and Unicode

Question 10

Define an algorithm

Answer 10

Formula or procedure for solving a problem - or a set of steps followed to complete a computer process.