Chapter 5 Flashcards
The use of integrated collections of data records
and files for data storage and processing
Database management
approach
Data in independent files made it difficult to
provide answers to ad hoc requests and required
special computer programs to be written to
perform this task
Data integration (
A specialist in charge of the databases of an
organization.
Database administrator
(DBA)
A nonprocedural computer language used to
interrogate a database.
Structured Query Language
(SQL
Defines and catalogs the data elements and data
relationships in an organization’s database
Data dictionary
A feature of database systems that uses queries or
report generators to extract information.
Database interrogation
The main software package that supports a database
management approach.
Database management system
(DBMS) (2
Databases that are dispersed over the Internet and
corporate intranets and extranets.
Distributed
Databases that organize and store data as objects.
Object-oriented model
Databases of hyperlinked multimedia documents
on the Web.
Hypermedia
The management of all the data resources of an
organization.
Data resource management
Processing data in a data warehouse to discover
key business factors and trends.
Data mining (
Developing conceptual views of the relationships
among data in a database.
Data modeling
A customer’s name.
Field
. A customer’s name, address, and account balance.
Record
The names, addresses, and account balances of all
of your customers.
File
An integrated collection of all of the data about
your customers.
Database
Business application programs that use specialized
data files.
File processing
A treelike structure of records in a database.
Hierarchical structure (1
A tabular structure of records in a database.
Relational model
Records organized as cubes within cubes in a
database.
Multidimensional model
Databases that support the major business processes
of an organization
Operational (
A centralized and integrated database of current
and historical data about an organization.
Data warehouse
A problem in the file processing approach where
major components of a system are dependent on
each other to a large degree
Data dependence (
Databases available on the Internet or provided by
commercial information services
External (
Different approaches to the logical organization of
individual data elements stored in a database.
Database structures (
The most basic logical data element corresponding
to a single letter or number.
Character (
A feature of distributed databases that identifies
changes in one database and then makes appropriate changes in the others.
Replication
Data that describe the structure and characteristics
of databases.
Metadata
A characteristic of data that refers to their accuracy and completeness.
Data integrity
A characteristic or quality of some entity used to
describe that entity
attribute
Includes, among others, operational, distributed,
and hypermedia databases.
Types of database
The existence of duplicate data among different
files in an organization.
Data redundancy
An approach to distributed databases that copies
the complete content of a master database to others
at a prescribed time of the day.
Duplication
An object, person, place, event, and so on that is of
interest to an organization and thus included in a
database.
Entity
An approach to database structure that improves
on the hierarchical model by allowing many-tomany relationships.
network structure
Different levels of data groupings that exist in a
database.
Logical data element