Introduction to Modelling Flashcards Preview

Information Management > Introduction to Modelling > Flashcards

Flashcards in Introduction to Modelling Deck (42)
Loading flashcards...
1

what is metadata

data about data

2

what is data

unprocessed information

3

what is information

data associated together

4

what is knowledge

understanding information

5

what sort of software manages data

file formats for particular applications .xls .doc .mp4 .jpg

specialist data management applications eg covid tracker

group project last year

6

4 ways of adding structure to data files

delimited text field
fixed length field
length-based field
identified field

7

what is a delimeter text field

choosing a special character eg comma or question mark that will not appear as a legitimate character within the info field and this will separate the individual data entries eg. comma separated file csv

8

What is a fixed length field

use a fixed length for each information field eg 20 characters, padding out when length is less than fixed lenght

9

what is the disadvantage of delimeter text

the character cannot be used legitimately in the information

10

what is length based field

writing the length of the information field before the information so we know exactly how much space it takes up

11

what is identified field

write the name of the information field and then value both represented as delimited text fields

12

what are the two types of approaches of turning data into information

structured and unstructured

13

what is a structured way of turning data into information

deliberately associate data together into information eg excel, data bases, datawarehouses

14

examples of structured approaches of turning data into information

excel
databases
datawarehouses

15

what is an unstructured way of turning data into information

loosely managed data together to serve a specific information need eg search engine

16

example of an unstructured approach of turning data into information

search engines

17

example of structured querying

SQL eg select exact criteria about data types

18

What does SQL stand for

structured query language

19

example of unstructured querying

keyword based, phrase based, search engine

20

examples of structured results

exact, do need to estimate relevance, returns complete set of data that matches query criteria

21

example of unstructured results

unsure of relevance, we must estimate relevance ourselves egGoogle page

22

DBs stands for

databases

23

ACID stands for

atomic
consistent
isolated
durable

24

different type of data base models

relational
networked
hierarchal
onject-orientated

25

most popular type of data base model

relational

26

why didn't the other types of data base models take off

most investments made in relational

27

DWs stands for

datawarehouses

28

what is a datawarehouse

a subject orientated, nonvolatile, time-varients collection of data in support of management decisions

29

uses of datawarehouses

data mining
decision support
OLAP (online analytical processing)

30

what do data warehouses allow

trend view of data as timestamped