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
2
Q
vital organizational resource that need to be managed like other important business assets.
A
Data
3
Q
store detailed data needed to support the business processes and operations of a company
A
Operational Databases
4
Q
are also called subject area databases (SADB), transaction databases, and production databases.
A
Operational Databases
5
Q
Examples are a customer database, human resource database, inventory database, and other databases containing data generated by business operations.
A
Operational Databases
6
Q
Many organizations replicate and distribute copies or parts of databases to network servers at a variety of sites.
A
Distributed Databases
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
8
Q
may be copies of operational or analytical databases, hypermedia or discussion databases, or any other type of database.
A
Distributed databases
9
Q
Replication and distribution of databases improve database performance at enduser worksites.
A
Distributed databases
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
11
Q
Advantages of Distributed Databases
A
- Protection of valuable data
- Storage requirements
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.
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
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
15
Q
Involves using a specialized software application that looks at each distributed database and then finds the changes made to it.
A
Replication
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
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
18
Q
is much less complicated.
A
Duplication
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
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
21
Q
Websites provide an endless variety of hyperlinked pages of multimedia documents in hypermedia databases for us to access.
A
External Databases
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
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
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
25
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.
Hypermedia Databases
26
A _________ stores data that have been extracted from the various operational, external, and other databases of an organization.
Data warehouse
27
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.
Data Warehousing
28
______ 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.
Data warehousing
29
Data from various operational and external databases are captured, cleaned, and
transformed into data that can be better used for analysis.
Data Acquisition
30
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.
acquisition process
31
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.
- enterprise data warehouse
- data marts
- analytical data store
32
Data that define the data in the data warehouse, are stored in a metadata repository and cataloged by a metadata directory.
Metadata
33
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
analytical software tools
34
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.
- changes can occur constantly
- static
35
the data in a data warehouse are analyzed to reveal hidden patterns and trends in historical business activity.
Data Mining
36
This analysis can be used to help managers make decisions about strategic changes in business operations to gain competitive advantages in the marketplace.
Data Mining
37
can discover new correlations, patterns, and trends in vast amounts of business data (frequently several terabytes of data) stored in data warehouses
Data mining
38
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.
Data mining software
39
the process of reducing something's strength or effectiveness through sustained attack
or pressure
attrition
40
Enumeration:
For example, many companies use data mining to:
● 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
41
consolidates data records, formerly held in separate files, into databases that can be accessed by many different application programs.
database management approach
42
serves as a software interface between users and databases, which helps users easily access the data in a database.
database management system (DBMS)
43
was conceived as the foundation of modern methods for managing organizational data.
database management approach
44
involves the use of database management software to control how databases are created, interrogated, and maintained to provide information that end users need.
database management
45
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
database management system (DBMS)
46
Enumeration:
Examples of popular DBMS software
- IBM’s DB2 Universal Database
- Oracle 10g by Oracle Corp.
- MySQL (a popular open-source DBMS)
47
Language and graphical to define entities, relationships, integrity constraints, and authorization rights.
Database Definition
48
Language and graphical tools to access data without complicated coding
Nonprocedural Access
49
Graphical tools to develop menus, data entry forms, and reports
Application Development
50
Language that combines nonprocedural access with full capabilities of a programming language
Procedural Language Interface
51
Control mechanisms to prevent interference from simultaneous users and recover lost data after a failure
Transaction Processing
52
Tools to monitor and improve database performance
Database Tuning
53
Enumeration:
The three major functions of a database management system are:
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
It involves defining and organizing the content, relationships, and structure of the data needed to build a database.
Database development
55
It involves using a DBMS to develop prototypes of queries, forms, reports, and Web pages for a proposed business application.
Database application development
56
It involves using transaction processing systems and other tools to add, delete, update, and correct the data in a database.
Database maintenance
57
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.
- database by end users
58
A _____________ is a major benefit of the database management approach.
Database Interrogation capability
59
A database Interrogation capability is a major benefit of the database management approach.
database Interrogation
60
End users can use a DBMS by asking for information from a database using a query
feature or a report generator.
Database Interrogation
61
They can receive an immediate response in the form of video displays or printed reports.
No difficult programming is required.
Database Interrogation
62
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.
query language
63
The ______________ feature allows us to specify a report format for information we want presented as a report
report generator
64
is an international standard query language found in many DBMS packages.
Structured Query Language (SQL)
65
is the language structure used to “ask a question” that the DBMS will retrieve the data to answer.
Structured Query Language (SQL)
66
After _______, we list the data fields we want retrieved.
SELECT
67
After _______, we list the files or tables from which the data must be retrieved.
FROM
68
After ___________, we specify conditions that limit the search to only those data records
in which we are interested.
WHERE
69
allows us to refine our searches for specific information such that only the desired information is obtained.
Boolean logic
70
consists of three logical operators: (1) AND, (2) OR, and (3) NOT.
Boolean logic
71
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.
Boolean Logic
72
Many end users (and IS professionals) have difficulty correctly phrasing SQL and other
database language search queries
Graphical and Natural Queries
73
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.
Graphical and Natural Queries
74
The database maintenance process is accomplished by transaction processing systems and other end-user applications, with the support of the DBMS.
Database Maintenance
75
End users and information specialists can also employ various utilities provided by a
DBMS for database maintenance.
Database Maintenance
76
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.
Database Maintenance
77
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.
Database Maintenance
78
DBMS packages play a major role in application development
Application Development
79
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.
Application Development
80
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
Application Development
81
they can include features such as ___________ statements in their software that call on the DBMS to perform necessary data-handling activities
data manipulation language (DML)
82
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
DBMS
83
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.
Data warehousing
84
(data that define the data in the data warehouse
metadata
85
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.
Data warehousing
86
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.
static
87
, the data in a data warehouse are analyzed to reveal hidden patterns and
trends in historical business activity.
data mining
88
This analysis can be used to help managers make decisions about strategic changes in
business operations to gain competitive advantages in the marketplace.
Data Mining
89
________can discover new correlations, patterns, and trends in vast amounts of
business data (frequently several terabytes of data) stored in data warehouses.
Data mining
90
________ 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
Data mining software
91
the process of reducing something's strength or effectiveness through sustained attack or pressure.
attrition
92
To solve the problems encountered with the file processing approach, the ______________________was conceived as the foundation of modern methods for
managing organizational data.
database management approach
93
The _____________consolidates data records, formerly held in separate
files, into databases that can be accessed by many different application programs.
database management approach
94
a____________ serves as a software interface between users and databases, which helps users easily access the data in a database.
database management system
95
_____________ involves the use of database management software to control how databases are created, interrogated, and maintained to provide information
that end users need.
database management
96
____________ 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.
database management system (DBMS)
97
language and graphical tools to define entities, relationships, integrity constraints, and authorization rights.
Database definition
98
Language and graphical tools to access data without complicated coding
Nonprocedural access
99
graphical tools to develop menus, data entry forms, and reports
Application development
100
language combine non procedural access with full capabilities of a pro gamming language
procedural language interface
101
control mechanism to prevent interface from simultaneous user and recover lost data after a failure.
transaction processing
102
tools to monitor and improve data base performance.
Database tuning
103
The three major functions of a database management system are
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
involves defining and organizing the content, relationships, and
structure of the data needed to build a database.
Database development
105
involves using a DBMS to develop prototypes of queries, forms, reports, and Web pages for a proposed business application.
Database application development
106
involves using transaction processing systems and other tools to add, delete, update, and correct the data in a database.
Database maintenance
107
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.
database interrogation capabilities
108
A ___________is a major benefit of the database management
approach
database interrogation capability
109
End users can use a DBMS by asking for information from a database using a___________ or ______________
query feature or a report generator.
110
They can receive an immediate response in the form of video displays or printed reports.
No difficult programming is required.
Database interrogation
111
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.
query language feature
112
The ____________ feature allows us to specify a report format for information we want presented as a report.
report generator
113
_______, 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.
Structured Query Language
114
The basic form of a SQL query is:
SELECT . . . FROM . . . WHERE . . .
115
After_______, we list the data fields we want retrieved.
SELECT
116
After __, we list the files or tables from which the data must be retrieved.
FROM
117
After ________, we specify conditions that limit the search to only those data records in which we are interested.
WHERE
118
allows us to refine our searches for specific
information such that only the desired information is obtained.
Boolean logic
119
consists of three logical operators: (1) AND, (2) OR, and (3) NOT.
Boolean logic
120
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.
Boolean Logic
121
Many end users (and IS professionals) have difficulty correctly phrasing SQL and other
database language search queries.
Graphical and natural queries
122
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
Graphical and natural queries
123
The ______process is accomplished by transaction processing systems
and other end-user applications, with the support of the DBMS.
database maintenance
124
End users and information specialists can also employ various utilities provided by a
__________for database maintenance.
database maintenance
125
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.
Database Maintenance
126
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.
Database Maintenance
127
DBMS packages play a major role in application development.
Application Development
128
End users, systems analysts, and other application developers can use the _________ and _________provided by many DBMS packages to develop custom application programs.
internal 4GL programming language
built-in software development tools
129
________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.
DBMS (Database Management)
130
, they can include features such as ________statements in their software that call on the DBMS to perform necessary data-handling activities
data manipulation language (DML)
