unit 4- Data Resource Management

Question 1

Database

Answer 1

set or collection of data, organized in tables and easily searchable

Question 2

DBMS

Answer 2

Data base Management System:
software program that organizes, manages, and accesses data. Enables users to create, manage, retrieve, and update data in database. (ex.healthcare system data)

Question 3

Database server

Answer 3

powerful computer that stores the databases and DBMS to access and administer database

Question 4

Relational Databases

Answer 4

most common based upon the relational model of data, relationships between tables in rows and columns

Question 5

Object databases

Answer 5

used when multimedia, computer aided design are required, not easily sorted by columns and rows.

Question 6

hierarchical database

Answer 6

early database style, inflexible data relationship, treelike structure

Question 7

Database administrator

Answer 7

• person responsible for the creation, management and integrity of the database
• monitors performance
• maps out the conceptual design for a planned database`

Question 8

Data administrator

Answer 8

person who is responsible for the securing access, privacy, security, retention of data within the database.

Question 9

entity

Answer 9

data components have various properties and relate to each other in various ways

Question 10

field

Answer 10

attribute of an entity (name, address, $amount) example; once cell or field

Question 11

record

Answer 11

single row occurrence or related field, separated by columns, example, customer record.

Question 12

table

Answer 12

collection of related records

Question 13

primary key

Answer 13

field that uniquely identifies a record (ex.Social security number)

Question 14

foreign key

Answer 14

field that is in a relational table, relates to a primary key of another table

Question 15

schema

Answer 15

the complete definition of the database, including fields, relationships, etc. -blue print on how the database is constructed

Question 16

zero to many

Answer 16

optional

0- advisor and instructor

Question 17

one or more

Answer 17

mandatory

I- student one or more courses

Question 18

One and only one

Answer 18

Mandatory

II- student has one adviser, course has one instructor

Question 19

flowcharting

Answer 19

during the design phase to avoid inconsistencies in database

Question 20

normalization

Answer 20

• database must go through normalization in design process to simplify complexity
• removes redundant or unnecessary duplication
• correctly defines keys, tables, columns and relationships

Question 21

Data Migration

Answer 21

• extract
• transform
• load
• validate

Question 22

ETL

Answer 22

Extracted transformed loaded.

Question 23

data warehouse

Answer 23

data vault- static data(same all day)

Question 24

dynamic data

Answer 24

operational systems(marketing, sales, ERP, SCM, etc.) -changes all day

Question 25

data warehouse and data marts

Answer 25

used for analytical purposes. | -a sub within warehouse for specific information out of the data warehouse. ex finance.

Question 26

data governance

Answer 26

policies and procedures are established that define the data governance program, such a who has access who has update capabilities

Question 27

1.recorded

Answer 27

how data are recorded may be critical to operation of a business. inputting consistently by using the same descriptions, standards, units of measurement and formats can mean the difference between success and failure

Question 28

2.Stored

Answer 28

where data are stored can have a lasting effect on an organizations success. Data stored on systems not controlled by the organization or in a way that inappropriate users have access, may contribute to heightened risk for loss or theft

Question 29

3.retrieved

Answer 29

how data are retrieves and who can retrieve them are questions central to design of a database

Question 30

4.Retained and destroyed

Answer 30

Even when data are no longer being used, there may be laws or policies that govern how long it should be kept

Question 31

Data mining

Answer 31

- query that mines for information - discovers patterns in large data sets such a data warehouse. - used in business strategies

Question 32

OLAP

Answer 32

Online analytical processing - is software for performing multidimensional analysis at high speeds on large volumes of data from a data warehouse, data mart, or some other unified, centralized data store. - containing data that are used for making decisions such as the many levels

Question 33

OLYP

Answer 33

online transaction processing | -ATM example

Question 34

Big Data

Answer 34

- unstructured - Variety- texts, emails, web mining. - Volume-great amount of transaction data - Velocity-batch streaming (for marketers)

Question 35

cloud database advantage:

Answer 35

- more flexible - available and scalable - data can be stored in multiple location

Question 36

cloud database disadvantage:

Answer 36

- more expensive to firms | - because web-based databases are connected to the internet, security is a significant issue.

Question 37

Software as a service SaaS:

Answer 37

it is sometimes referred to as in demand software- software licenses on a subscription basis. software not downloadable. ex: dropbox

Question 38

Platform as s Service PaaS:

Answer 38

hardware and software allowing customers to develop, run, create, and customized software without writing extensive code, easy to run focus on creative side. ex: amazon

Question 39

Infrastructure as a Service IaaS

Answer 39

storage, networking and virtualization, various low level details of underlying network infrastructure like physical computing resources, location, backup etc. Ex: data center

Question 40

Hypervisor

Answer 40

creates and runs virtual machines. a computer on which a hypervisor runs one or more virtual machine is called a host machine, and each virtual machine is called a guest machine

Question 41

CTO -Chief technology officer

Answer 41

responsible for implementing technology strategies | - responsible for identifying technology risks in the company