Databases and Information Management Flashcards

1
Q

is a subset of a data warehouse in which a summarized or highly focused portion of the organization’s
data is placed in a separate database for a specific population of users.

A

Data mart

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

where the same attribute may have different values

A

Data Inconsistency

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

, events are linked over time.

A

Sequences

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

occurs when different groups in an organization independently
collect the same piece of data and store it independently of each other.

A

Data Redundancy

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

A group of related files makes up a

A

Database

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

deals with the policies and
processes for managing the availability, usability, integrity, and security of the
data employed in an enterprise, with special emphasis on promoting privacy,
security, data quality, and compliance with government regulations.

A

Data governance

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

These tools are
able to extract key elements from large unstructured data sets, discover
patterns and relationships, and summarize the information. Businesses might
turn to text mining to analyze transcripts of calls to customer service centers to
identify major service and repair issues.

A

Text mining tools

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

acts as an interface
between application programs and the physical data files.

A

DBMS

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

supports multidimensional data analysis, enabling users to
view the same data in different ways using multiple dimensions.

A

OLAP - Online analytical processing

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

Rows are commonly referred to as records, or in very technical terms, as

A

Tuples

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

is software that permits an
organization to centralize data, manage them efficiently, and provide access
to the stored data by application programs.

A

Database management system

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

is a person, place, thing, or event on
which we store and maintain information

A

Entity

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

capability to specify the structure of the content
of the database. It would be used to create database tables and to define the
characteristics of the fields in each table

A

Data definition

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

presents data as they would be
perceived by end users or business specialists,

A

Logic View

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

represents a single character, which can be a letter, a number, or another symbol.

A

Byte

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

Type of information obtained in data mining are

A

Association, sequences, classification, clustering, and forecasting.

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

stores the data and procedures that act on those data as objects that can be automatically retrieved and shared

A

Object-oriented DBMS

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

A group of related fields, such as the student’s name, the course taken,
the date, and the grade, comprises a

A

Record

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

represent data as two-dimensional tables (called relations). Tables may be referred to as files. Each table contains data on an
entity and its attributes.

A

Relational DBMS

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

is a database that stores current and historical data of
potential interest to decision makers throughout the company.

consolidates and standardizes
information from different operational databases so that the information can be
used across the enterprise for management analysis and decision making

A

Data warehouse

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

Problems with traditional file environment

A
  1. Data Redundancy and Inconsistency
  2. Program-Data Dependence
  3. Lack of Flexibility
  4. Poor Security
  5. Lack of data sharing and availability
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
22
Q

Data Hierarchy

A

bit
byte
field
record
file
database

23
Q

The process of creating small, stable, yet flexible and
adaptive data structures from complex groups of data

A

Normalization

24
Q

In a client/server environment, the DBMS resides on a
dedicated computer called

A

Database server

25
Q

has a rudimentary data dictionary capability that displays information about the size,
format, and other characteristics of each field in a database.

A

Microsoft access

26
Q

Three basic operation in Relational DBMS

A

Select, join and project

27
Q

use data mining techniques, historical data, and assumptions about future conditions to predict outcomes of events, such as the probability a customer will respond to an offer or purchase a specific product

A

Predictive analytics

28
Q

The design group
establishes the physical database, the logical relations among elements, and the
access rules and security procedures.

A

Database management

29
Q

The most prominent data manipulation language today is

A

Structured query language

30
Q

A grouping of characters into a word, a group of words, or a complete number

A

Field

31
Q

uses predictions in
a different way. It uses a series of existing values to forecast what other values
will be

A

Forecasting

32
Q

to ensure that relationships between coupled tables remain consistent.

A

Referential intergrity

33
Q

It is more discovery driven. It provides insights into corporate data that cannot be obtained with OLAP by finding hidden patterns and relationships in large databases and inferring rules from them to predict future behavior.

A

Data Mining

34
Q

is the presence of duplicate data in multiple data files so that the same data are stored in more than place or location.

A

Data Redundancy

35
Q

The discovery and analysis of useful patterns and information from the World
Wide Web

A

Web mining

36
Q

The field for Supplier_Number in the SUPPLIER table uniquely identifies
each record so that the record can be retrieved, updated, or sorted and it is

A

Key Field

37
Q

is the process of extracting
knowledge from the content of Web pages, which may include text, image, audio,
and video data.

A

Web mining

38
Q

a group of records of the same
type

A

File

39
Q

specifies the organization’s rules for sharing,
disseminating, acquiring, standardizing, classifying, and inventorying information.

lays out specific procedures and accountabilities,
identifying which users and organizational units can share information, where
information can be distributed, and who is responsible for updating and
maintaining the information.

A

Information policy

40
Q

is an automated or
manual file that stores definitions of data elements and their characteristics.

A

Data dictionary

41
Q

is responsible for the specific
policies and procedures through which data can be managed as an organizational
resource.

A

Data administration

42
Q

consists of activities for
detecting and correcting data in a database that are incorrect, incomplete,
improperly formatted, or redundant.

not only corrects errors
but also enforces consistency among different sets of data that originated in
separate information systems.

A

Data cleansing or data scrubbing

43
Q

is a collection of data
organized to serve many applications efficiently by centralizing the data and
controlling redundant data.

A

Database

44
Q

It refers to the coupling of data stored in files and the
specific programs required to update and maintain those files such that changes
in programs require changes to the data.

A

Program-data dependence

45
Q

shows how data are actually organized and structured on physical storage
media.

A

Physical View

46
Q

recognizes patterns that describe the group to which an item
belongs by examining existing items that have been classified and by
inferring a set of rules.

A

Classification

47
Q

DBMS includes tools for accessing and manipulating information in databases.
Most DBMS have a specialized language called a

A

data manipulation language

48
Q

works in a manner similar to classification when no groups have yet
been defined.

A

Clustering

49
Q

represents the smallest unit of data a computer can handle.

A

Bit

50
Q

Each characteristic or quality
describing a particular entity

A

Attribute

51
Q

which is a structured survey of the accuracy and level of
completeness of the data in an information system

can be
performed by surveying entire data files, surveying samples from data files, or
surveying end users for their perceptions of data quality

A

Data quality audit

52
Q

This key field is the unique identifier for all the information in any row of the table

A

Primary key

53
Q

are occurrences linked to a single event.

A

Associations

54
Q

Databases in the cloud

A

” Cloud computing
providers offer database management services, but these services typically
have less functionality than their on-premises counterparts.