Chapter 5 Flashcards

1
Q

It is a managerial activity that applies information systems technologies like database management, data warehousing, and other data management tools to the task of managing an organization’s data resources to meet the information needs of their business stakeholders.

A

Data Resource Management

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

vital organizational resource that need to be managed like other important business assets.

A

Data

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

store detailed data needed to support the business processes and operations of a company

A

Operational Databases

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

are also called subject area databases (SADB), transaction databases, and production databases.

A

Operational Databases

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

Examples are a customer database, human resource database, inventory database, and other databases containing data generated by business operations.

A

Operational Databases

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

Many organizations replicate and distribute copies or parts of databases to network servers at a variety of sites.

A

Distributed Databases

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

These __________ can reside on network servers on the World Wide Web, on corporate intranets or extranets, or on other company networks.

A

distributed databases

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

may be copies of operational or analytical databases, hypermedia or discussion databases, or any other type of database.

A

Distributed databases

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

Replication and distribution of databases improve database performance at enduser worksites.

A

Distributed databases

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

Ensuring that the data in an organization’s distributed databases are consistently and concurrently updated is a major challenge of distributed database management.

A

Distributed databases

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

Advantages of Distributed Databases

A
  • Protection of valuable data
  • Storage requirements
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

Challenges of Distributed Databases

A
  • Maintenance of data accuracy
  • Replication
  • Duplication
  • extra computing power and bandwidth necessary to access multiple databases in multiple locations.
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

large database system may be distributed into smaller databases based on some logical relationship between the data and the location.

A

Storage Requirements

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

If a company distributes its database to multiple locations, any change to the data in one location must somehow be updated in all other locations. This updating can be accomplished in one of two ways: replication or duplication.

A

Maintenance of data accuracy

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

Involves using a specialized software application that looks at each distributed database and then finds the changes made to it.

A

Replication

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

Once these changes have been identified, the ______ makes all of the distributed databases look the same by making the appropriate changes to each one.

A

Replication process

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

The _____ is very complex and, depending on the number and size of the distributed databases, can consume a lot of time and computer resources.

A

Replication process

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

is much less complicated.

A

Duplication

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

identifies one database as a master and then duplicates that database at a prescribed time after hours so that each distributed location has the same data.

A

Duplication

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

One drawback to the duplication process is that no changes can ever be made to any database other than the master to avoid having local changes overwritten during the duplication process.

A

Duplication

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

Websites provide an endless variety of hyperlinked pages of multimedia documents in hypermedia databases for us to access.

A

External Databases

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

Data are available in the form of statistics on economic and demographic activity from statistical databanks, or we can view or download abstracts or complete copies of hundreds of newspapers, magazines, newsletters, research papers, and other published material and periodicals from bibliographic and full-text databases.

A

External Databases

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

The rapid growth of Web sites on the Internet and corporate intranets and extranets has dramatically increased the use of databases of hypertext and hypermedia documents.

A

Hypermedia Databases

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

A Website stores such information in a hypermedia database consisting of hyperlinked pages of multimedia (text, graphic and photographic images, video clips, audio segments, and so on).

A

Hypermedia Databases

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

from a database management point of view, the set of interconnected multimedia pages on a Website is a database of interrelated hypermedia page elements, rather than interrelated data records.

A

Hypermedia Databases

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

A _________ stores data that have been extracted from the various operational, external, and other databases of an organization.

A

Data warehouse

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

It is a central source of the data that have been cleaned, transformed, and cataloged so that they can be used by managers and other business professionals for data mining, online analytical processing, and other forms of business analysis, market research, and decision support.

A

Data Warehousing

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

______ may be subdivided into data marts , which hold subsets of data from the warehouse that focus on specific aspects of a company, such as a department or a business process.

A

Data warehousing

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

Data from various operational and external databases are captured, cleaned, and
transformed into data that can be better used for analysis.

A

Data Acquisition

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

This ______ might include activities like consolidating data from several
sources, filtering out unwanted data, correcting incorrect data, converting data to new data elements, or aggregating data into new data subsets.

A

acquisition process

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

These data are then stored in the _______________, from which they can be
moved into ________ or to an ___________ that holds data in a more useful form for certain types of analysis.

A
  • enterprise data warehouse
  • data marts
  • analytical data store
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
32
Q

Data that define the data in the data warehouse, are stored in a metadata repository and cataloged by a metadata directory.

A

Metadata

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

a variety of ___________can be provided to query, report, mine, and analyze the data for delivery via Internet and intranet Web systems to business end users

A

analytical software tools

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

One important characteristic about the data in a data warehouse is that, unlike a typical database in which ___________, data in a data warehouse are _________, which means that once the data are gathered up, formatted for storage, and stored in the data warehouse, they will never change.

A
  • changes can occur constantly
  • static
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
35
Q

the data in a data warehouse are analyzed to reveal hidden patterns and trends in historical business activity.

A

Data Mining

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

This analysis can be used to help managers make decisions about strategic changes in business operations to gain competitive advantages in the marketplace.

A

Data Mining

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

can discover new correlations, patterns, and trends in vast amounts of business data (frequently several terabytes of data) stored in data warehouses

A

Data mining

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

It uses advanced pattern recognition algorithms, as well as a variety of mathematical and statistical techniques, to sift through mountains of data to extract previously unknown strategic business information.

A

Data mining software

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

the process of reducing something’s strength or effectiveness through sustained attack
or pressure

A

attrition

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

Enumeration:

For example, many companies use data mining to:

A

● Perform market-basket analysis to identify new product bundles.
● Find root causes of quality or manufacturing problems.
● Prevent customer attrition and acquire new customers.
● Cross-sell to existing customers.
● Profile customers with more accuracy

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

consolidates data records, formerly held in separate files, into databases that can be accessed by many different application programs.

A

database management approach

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

serves as a software interface between users and databases, which helps users easily access the data in a database.

A

database management system (DBMS)

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

was conceived as the foundation of modern methods for managing organizational data.

A

database management approach

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

involves the use of database management software to control how databases are created, interrogated, and maintained to provide information that end users need.

A

database management

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

is the main software tool of the database
management approach because it controls the creation, maintenance, and use of the
databases of an organization and its end users

A

database management system (DBMS)

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

Enumeration:
Examples of popular DBMS software

A
  • IBM’s DB2 Universal Database
  • Oracle 10g by Oracle Corp.
  • MySQL (a popular open-source DBMS)
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
47
Q

Language and graphical to define entities, relationships, integrity constraints, and authorization rights.

A

Database Definition

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

Language and graphical tools to access data without complicated coding

A

Nonprocedural Access

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

Graphical tools to develop menus, data entry forms, and reports

A

Application Development

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

Language that combines nonprocedural access with full capabilities of a programming language

A

Procedural Language Interface

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

Control mechanisms to prevent interference from simultaneous users and recover lost data after a failure

A

Transaction Processing

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

Tools to monitor and improve database performance

A

Database Tuning

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

Enumeration:
The three major functions of a database management system are:

A
  1. to create new databases and database applications,
  2. to maintain the quality of the data in an organization’s databases, and
  3. to use the databases of an organization to provide the information that its end
    users need.
54
Q

It involves defining and organizing the content, relationships, and structure of the data needed to build a database.

A

Database development

55
Q

It involves using a DBMS to develop prototypes of queries, forms, reports, and Web pages for a proposed business application.

A

Database application development

56
Q

It involves using transaction processing systems and other tools to add, delete, update, and correct the data in a database.

A

Database maintenance

57
Q

The primary use of a ______________ involves employing the database interrogation capabilities of a DBMS to access the data in a database to selectively retrieve and display information and produce reports, forms, and other documents.

A
  • database by end users
58
Q

A _____________ is a major benefit of the database management approach.

A

Database Interrogation capability

59
Q

A database Interrogation capability is a major benefit of the database management approach.

A

database Interrogation

60
Q

End users can use a DBMS by asking for information from a database using a query
feature or a report generator.

A

Database Interrogation

61
Q

They can receive an immediate response in the form of video displays or printed reports.
No difficult programming is required.

A

Database Interrogation

62
Q

The _________ feature lets us easily obtain immediate responses to ad hoc data
requests: in a few short inquiries - in some cases, using common sentence structures just
like we would use to ask a question.

A

query language

63
Q

The ______________ feature allows us to specify a report format for information we want presented as a report

A

report generator

64
Q

is an international standard query language found in many DBMS packages.

A

Structured Query Language (SQL)

65
Q

is the language structure used to “ask a question” that the DBMS will retrieve the data to answer.

A

Structured Query Language (SQL)

66
Q

After _______, we list the data fields we want retrieved.

A

SELECT

67
Q

After _______, we list the files or tables from which the data must be retrieved.

A

FROM

68
Q

After ___________, we specify conditions that limit the search to only those data records
in which we are interested.

A

WHERE

69
Q

allows us to refine our searches for specific information such that only the desired information is obtained.

A

Boolean logic

70
Q

consists of three logical operators: (1) AND, (2) OR, and (3) NOT.

A

Boolean logic

71
Q

Using these operators in conjunction with the syntax of a SQL query, a database user can
refine a search to ensure that only the desired data are retrieved.

A

Boolean Logic

72
Q

Many end users (and IS professionals) have difficulty correctly phrasing SQL and other
database language search queries

A

Graphical and Natural Queries

73
Q

So most end-user database management packages offer GUI (graphical user interface)
point-and-click methods, which are easier to use and are translated by the software into
SQL commands.

A

Graphical and Natural Queries

74
Q

The database maintenance process is accomplished by transaction processing systems and other end-user applications, with the support of the DBMS.

A

Database Maintenance

75
Q

End users and information specialists can also employ various utilities provided by a
DBMS for database maintenance.

A

Database Maintenance

76
Q

The databases of an organization need to be updated continually to reflect new business
transactions (e.g., sales made, products produced, inventory shipped) and other events.

A

Database Maintenance

77
Q

Other miscellaneous changes also must be made to update and correct data (e.g.,
customer or employee name and address changes) to ensure the accuracy of the data in
the databases.

A

Database Maintenance

78
Q

DBMS packages play a major role in application development

A

Application Development

79
Q

End users, systems analysts, and other application developers can use the internal 4GL
programming language and built-in software development tools provided by many DBMS
packages to develop custom application programs.

A

Application Development

80
Q

A DBMS also makes the job of application software developers easier, because they do
not have to develop detailed data-handling procedures using conventional programming
languages every time they write a program

A

Application Development

81
Q

they can include features such as ___________ statements in their software that call on the DBMS to perform necessary data-handling activities

A

data manipulation language (DML)

82
Q

A ___________ also makes the job of application software developers easier, because they do
not have to develop detailed data-handling procedures using conventional programming
languages every time they write a program

A

DBMS

83
Q

These data are then stored in the enterprise data warehouse, from which they can be
moved into data marts or to an analytical data store that holds data in a more useful form
for certain types of analysis.

A

Data warehousing

84
Q

(data that define the data in the data warehouse

A

metadata

85
Q

a variety of analytical software tools can be provided to query, report, mine, and
analyze the data for delivery via Internet and intranet Web systems to business end users.

A

Data warehousing

86
Q

One important characteristic about the data in a data warehouse is that, unlike a typical
database in which changes can occur constantly, data in a data warehouse are__________,
which means that once the data are gathered up, formatted for storage, and stored in the
data warehouse, they will never change.

A

static

87
Q

, the data in a data warehouse are analyzed to reveal hidden patterns and
trends in historical business activity.

A

data mining

88
Q

This analysis can be used to help managers make decisions about strategic changes in
business operations to gain competitive advantages in the marketplace.

A

Data Mining

89
Q

________can discover new correlations, patterns, and trends in vast amounts of
business data (frequently several terabytes of data) stored in data warehouses.

A

Data mining

90
Q

________ uses advanced pattern recognition algorithms, as well as a variety
of mathematical and statistical techniques, to sift through mountains of data to extract
previously unknown strategic business information

A

Data mining software

91
Q

the process of reducing something’s strength or effectiveness through sustained attack or pressure.

A

attrition

92
Q

To solve the problems encountered with the file processing approach, the ______________________was conceived as the foundation of modern methods for
managing organizational data.

A

database management approach

93
Q

The _____________consolidates data records, formerly held in separate
files, into databases that can be accessed by many different application programs.

A

database management approach

94
Q

a____________ serves as a software interface between users and databases, which helps users easily access the data in a database.

A

database management system

95
Q

_____________ involves the use of database management software to control how databases are created, interrogated, and maintained to provide information
that end users need.

A

database management

96
Q

____________ is the main software tool of the database management approach because it controls the creation, maintenance, and use of the databases of an organization and its end users.

A

database management system (DBMS)

97
Q

language and graphical tools to define entities, relationships, integrity constraints, and authorization rights.

A

Database definition

98
Q

Language and graphical tools to access data without complicated coding

A

Nonprocedural access

99
Q

graphical tools to develop menus, data entry forms, and reports

A

Application development

100
Q

language combine non procedural access with full capabilities of a pro gamming language

A

procedural language interface

101
Q

control mechanism to prevent interface from simultaneous user and recover lost data after a failure.

A

transaction processing

102
Q

tools to monitor and improve data base performance.

A

Database tuning

103
Q

The three major functions of a database management system are

A
  1. to create new databases and database applications,
  2. to maintain the quality of the data in an organization’s databases, and
  3. to use the databases of an organization to provide the information that its end users need.
104
Q

involves defining and organizing the content, relationships, and
structure of the data needed to build a database.

A

Database development

105
Q

involves using a DBMS to develop prototypes of queries, forms, reports, and Web pages for a proposed business application.

A

Database application development

106
Q

involves using transaction processing systems and other tools to add, delete, update, and correct the data in a database.

A

Database maintenance

107
Q

The primary use of a database by end users involves employing the ____________of a DBMS to access the data in a database to selectively retrieve and display information and
produce reports, forms, and other documents.

A

database interrogation capabilities

108
Q

A ___________is a major benefit of the database management
approach

A

database interrogation capability

109
Q

End users can use a DBMS by asking for information from a database using a___________ or ______________

A

query feature or a report generator.

110
Q

They can receive an immediate response in the form of video displays or printed reports.
No difficult programming is required.

A

Database interrogation

111
Q

The____________ lets us easily obtain immediate responses to ad hoc data requests: in a few short inquiries - in some cases, using common sentence structures just like we would use to ask a question.

A

query language feature

112
Q

The ____________ feature allows us to specify a report format for information we want presented as a report.

A

report generator

113
Q

_______, is an international standard query language found in many DBMS packages. In most cases, SQL is the language structure used to “ask a question” that the DBMS will retrieve the data to answer.

A

Structured Query Language

114
Q

The basic form of a SQL query is:

A

SELECT . . . FROM . . . WHERE . . .

115
Q

After_______, we list the data fields we want retrieved.

A

SELECT

116
Q

After __, we list the files or tables from which the data must be retrieved.

A

FROM

117
Q

After ________, we specify conditions that limit the search to only those data records in which we are interested.

A

WHERE

118
Q

allows us to refine our searches for specific
information such that only the desired information is obtained.

A

Boolean logic

119
Q

consists of three logical operators: (1) AND, (2) OR, and (3) NOT.

A

Boolean logic

120
Q

Using these operators in conjunction with the syntax of a SQL query, a database user can
refine a search to ensure that only the desired data are retrieved.

A

Boolean Logic

121
Q

Many end users (and IS professionals) have difficulty correctly phrasing SQL and other
database language search queries.

A

Graphical and natural queries

122
Q

So most end-user database management packages offer GUI (graphical user interface) point-and-click methods, which are easier to use and are translated by the software into SQL commands

A

Graphical and natural queries

123
Q

The ______process is accomplished by transaction processing systems
and other end-user applications, with the support of the DBMS.

A

database maintenance

124
Q

End users and information specialists can also employ various utilities provided by a
__________for database maintenance.

A

database maintenance

125
Q

The databases of an organization need to be updated continually to reflect new business
transactions (e.g., sales made, products produced, inventory shipped) and other events.

A

Database Maintenance

126
Q

Other miscellaneous changes also must be made to update and correct data (e.g., customer or employee name and address changes) to ensure the accuracy of the data in the databases.

A

Database Maintenance

127
Q

DBMS packages play a major role in application development.

A

Application Development

128
Q

End users, systems analysts, and other application developers can use the _________ and _________provided by many DBMS packages to develop custom application programs.

A

internal 4GL programming language

built-in software development tools

129
Q

________also makes the job of application software developers easier, because they do not have to develop detailed data-handling procedures using conventional programming languages every time they write a program.

A

DBMS (Database Management)

130
Q

, they can include features such as ________statements in their software that call on the DBMS to perform necessary data-handling activities

A

data manipulation language (DML)