Brainscape's Knowledge GenomeTM

Browse over 1 million classes created by top students, professors, publishers, and experts.


See full index

Warehouse > Overview and Concepts > Flashcards

Overview and Concepts Flashcards

1
Q

who needs strategic information in an enterprise?
-are responsible for keeping the enterprise competitive need information to make proper decisions.

A

executives and managers

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

-combined essential information needed to make decisions in the formulation and execution of business startegies and objectives
-is not for running the day-to-day operations of the business. It is not intended to produce an invoice, make a shipment, settle a chain, or post a withdrawal from a bank account.
-far more important for the continued health and survical of the operation
-critical business decisions depend on the availability of proper strategic inforation in an enterprise.

A

strategic information

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

(characterisitics of strategic information)
-must have a single, enterprise-wide view.

A

integrated

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

(chracteristics of strategic information)
-information must be accurate and must conform to business rules.

A

data integrity

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

(chracteristics of strategic information)
-easily accessible with intuitive access paths, and responsive for analysis.

A

accessible

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

(chracteristics of strategic information)
-every business factor must have one and only one value.

A

credible

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

(chracteristics of strategic information)
-information must be available within the stipulated time frame

A

timely

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

-user needs information
-iser requests reports from IT
-IT places request on backlog
-IT creates ad hoe queries
-IT sends requested reports
-User hopes to find the right answers.

A

The familiar merry-go-round
-inability to provide information (4-6weeks)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

-get the data in
-making the wheels of business turn
0take an order
-process a clain
-make a shipment
-generate an invoice
-receive cash
-reserve airline seat

A

operational systems

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

-get the information out
-watching the wheels of business turn
-show me the top-selling products
-show me the problems regions
-tell me why (drill down)
-let me see other data (drill actions)
-show me te hgihest margins
-alert me when a district sells below target

A

decision-support systems

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

-serve different purposes
-scopes are different
-data content is different
-the data usage patterns are different
-the data acess types are different

A

informational systems

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

-a physical repository where relational data (current and historical) are specially organized to provide enterprise-wide, cleansed data in a standardized format.
Operational systems -> Data Trnasformation -> Key Measurements/ Business Dimensions

A

data warehouse

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

(characteristics of Data Warehouse)
-data are organized by detailed subject containing only information relevant for decision support. It provides a more comprehensive view of the organization

A

subject oriented

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

(chracteristics of data warehouse)
-data warehouses must place data from different sources into a consistent format.

A

integrated

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

(chracteristics of data warehouse)
-it contains historical (daily, weekly and monthly) inc additions to current data (real-time).

A

time variant (time series)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

(chracteristics of data warehouse)
-data can not be changed or updated after it had been entered into data warehouse. Obsolete (old) data are discarded and changes are recorded as new data.

A

non-volatile

17
Q

(chracteristics of data warehouse)
-designed for web based applications

A

web based

18
Q

(chracteristics of data warehouse)
-its structure is either relational or multidimensional.

A

relational/multidimensional

19
Q

(chracteristics of data warehouse)
-to be easy to be accessed

A

uses client server

20
Q

(chracteristics of data warehouse)
-this a charcter for new data warehour

A

real-time

21
Q

(chracteristics of data warehouse)
-it is a data about data (about how data are organized and to use them)

A

include metadata

22
Q
  • a logical and physical subset of a data warehouse; in its most simplistic form, represents data from a single business process (e.g., retail sales, retail inventory, purchase orders). Basically, a departmental data warehouse.
A

data mart

23
Q

-a subset that is created directly form a data warehouse

A

dependent data mart

24
Q

-a small data warehouse designed for a strategic business unit (SBU) or a department and its source is not the EDW (Enterprise Data Warehouse)

A

independent data mart

25
Q

-a type of databaseoften used as an interim (temporal) area for a data warehose, especially for cutomer information files.

A

operational data stores (ODS)

26
Q

-an operational data mart
-is a small-scale data mart typically used by a single department or functional area in an organization when they need to analyze operational data.

A

oper marts

27
Q
  • a technology that provides a vehicle for pushing data from source systems into a data warehouse that is used across the eneterpise for decision support.
A

enterpise data warehouse (EDW)

28
Q

-data about data. In a data warehouse, describes the contents of a data warehouse and the manner of its use.

A

metadata

29
Q

-organizations continuously collect data, information,and knowledge at an increasingly accelerated rate and store them in compterized systems.
-the number of users needing to access the infomration continues to increase as a result of imporved reliability and availability of network access, especially the Internet.

A

data warehousing process overview

30
Q

-internal, external (data provider), OLAP, ERP, Web data

A

data sources

31
Q

-using custom-written or commerical software called (ETL)

A

data extraction

32
Q

-loaded into a staging area to be transformed and cleased, then loaded into the warehouse.

A

data loading

33
Q

-it is the EDW to support all decision analysis

A

comprehensive database

34
Q

to enable access to DW. It includes data mining tools, OLAP, reporting tools and data visualization tools

A

middleware tools

35
Q

-a datawarehouse is designed for analytics transactional models, while efficient for transaction processing, are not good for analytics.
–goal of transactiona system is to capture data quicly, Users use the system to do their jobs.
–transactional systems are not designed to minimize the time or complexity of retrieving large amount of data for analysis.

A

use a separate system

36
Q

-designed to extract and query data quickly
• Access speed is the main concern
• Hence, normalization which is widely used for transactional databases, is
generally not appropriate for data warehouse design
• Design should reflect multidimensional view

A

star schema/dimensional model

Warehouse (3 decks)

Brainscape helps you reach your goals faster, through stronger study habits.
© 2024 Bold Learning Solutions. Terms and Conditions