# Data management Flashcards Preview

## Introduction to IT > Data management > Flashcards

Flashcards in Data management Deck (10)
1
Q

Define Pivoting

A

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.

2
Q

Define Dicing

A

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.

3
Q

OLTP

A

Online Transaction Processing system

4
Q

OLAP

A

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

5
Q

Drilling

A

More or less detail of the same data

6
Q

Define Slicing

A

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

7
Q

Explain difference between bits and bytes

A

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

8
Q

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

A

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

9
Q

What are the common forms of character representation

A

ASCII and Unicode

10
Q

Define an algorithm

A

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