Brainscape's Knowledge GenomeTM

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


See full index

Information Systems > G5 > Flashcards

G5 Flashcards

1
Q

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

A

Data Resource Management

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

Today’s business enterprises cannot survive or succeed without quality data about their
internal operations and external environment.

A

Data Resource Management

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

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
4
Q

Types of databases

A
  1. Operational Databases
  2. Distributed Databases
  3. External Databases
  4. Hypermedia Databases
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
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
6
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
7
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
8
Q

For example, a human resource database would include data identifying each
employee and his or her time worked, compensation, benefits, performance

A

Operational Databases

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
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
10
Q

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
11
Q

Distributed databases 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
12
Q

Replication and distribution of databases improve database performance at end-
user worksites.

A

Distributed Databases

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
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
14
Q

Often, a large database system may be distributed into
smaller databases based on some logical relationship between the data and the
location. For example, a company with several branch operations may distribute
its data so that each branch operation location is also the location of its branch
database. Because multiple databases in a distributed system can be joined
together, each location has control of its local data while all other locations can
access any database in the company if so desired.

A

Storage requirements:

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

a company distributes its database to multiple
locations, any change to the data in one location must somehow be updated in all
other locations.

A

Maintenance of data accuracy:

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

This updating can be accomplished in one of two ways:

A

replication or duplication.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
17
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
18
Q

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

A

replication

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

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

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

is much less complicated.

A

Duplication

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
21
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
22
Q

s 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
23
Q

can keep all
distributed locations current with the latest data.

A

Duplication

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

One additional challenge is the extra computing power and bandwidth necessary
to access multiple databases in multiple locations.

A

Duplication

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
25
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
26
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
27
Q

Whenever we use a search engine like Google or Yahoo to look up something on
the Internet, we are using an external database - a very, very large one!

A

External Databases

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
28
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
29
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

30
Q

That is, 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

31
Q

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

A

Data warehousing

32
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

33
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

34
Q

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

A

Data Mining

35
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

36
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

37
Q

software 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

38
Q

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.

39
Q

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

A

Database Management Approach

40
Q

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

A

Database Management Approach

41
Q

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

A

Database Management system

42
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

43
Q

For example, customer records and other common types of data are needed for several
different applications in banking, such as check processing, automated teller systems,
bank credit cards, savings accounts, and installment loan accounting. These data can be
consolidated into a common customer database, rather than being kept in separate files
for each of those applications.

A

Database Management Approach

44
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

45
Q

Examples of popular DBMS software are IBM’s DB2 Universal Database, Oracle 10g by
Oracle Corp., and MySQL, a popular open-source DBMS.

A

Database Management System

46
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.
47
Q

straints, and authorization rights.
Nonprocedural Access
Language and graphical tools to access data without complicated coding

A

Database Definition

48
Q

Language and graphical tools to access data without complicated coding

A

Nonprocedural Access

49
Q

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

A

Application Development

50
Q

Language that combine nonprocedural acces with full capabilitics of a pro-

A

Procedural Language Interface

51
Q

mechanisms to prevcnt interference from simultancous users and
recover lost data after a failure.

A

Transaction processing

52
Q

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

A

Database development

53
Q

Tools to monitor and improve database performance

A

Database tuning

54
Q

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

A

Database application development

55
Q

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

A

Database maintenance

56
Q

The primary use of a database by end users 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 maintenance

57
Q

capability is a major benefit of the database management
approach.

A

Database Interrogation

58
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

59
Q

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

A

Database Interrogation

60
Q

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

61
Q

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

A

Report generator

62
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 answe

A

SQL Queries

63
Q

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

A

After SELECT, we list the data fields we want retrieved.
- After FROM, we list the files or tables from which the data must be retrieved.
- After WHERE, we specify conditions that limit the search to only those data records
in which we are interested.

64
Q

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

A

Boolean Logic

65
Q

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

A

Database Maintenance

66
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

67
Q

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

A

Database Maintenance

68
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

69
Q

Instead, they can include features such as data manipulation language (DML) statements
in their software that call on the DBMS to perform necessary data-handling activities.

A

Application Development

70
Q

DBMS packages play a major role in application development.

A

Application Development

Information Systems (3 decks)

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