Database Reference
In-Depth Information
Data record. Data in physical files is stored as records. One record contains fields
of information about one instance of an object set or entity type. A record in the
customer file contains data about one customer.
Data redundancy. Duplication of data in a database.
Data repository. Storage of the organization's data in databases. Stores all data
values that are part of the databases.
Data security. Protection of the database from unauthorized or fraudulent use.
Data striping. Distributing or striping data on separate physical devices for the
purpose of improving performance by accessing the various segments on sepa-
rate devices in parallel.
Data view. View of the database by a single user group. Therefore, a data view of
a particular user group includes only those parts of the database that the group
is concerned with. The collection of all data views of all the user groups consti-
tutes the total data model.
Data warehouse. A specialized database having a collection of transformed and
integrated data, stored for the purpose of providing strategic information to the
organization.
Database. Repository where an ordered, integrated, and related collection of the
organization's data is stored for the purpose of computer applications and infor-
mation sharing.
Database administration. Responsibility for the technical aspects of the organiza-
tion's database. Includes the physical design and handling of the technical details
such as database security, performance, day-to-day maintenance, backup, and
recovery. Database administration is more technical than managerial.
Database administrator (DBA). Specially trained technical person performing the
database administration functions in an organization.
Database engine. Heart or kernel of a DBMS. Coordinates the tasks performed by
the other components for storing, retrieving, and altering the data.
Database monitoring. Inspecting the performance and state of the database system.
Database monitoring provides information for tuning the database for improved
performance.
Database plan. Covers the activities to be performed in the various phases of
the database development life cycle. Sets the tone for the database project,
spells out the key activities, and provides a planning document to guide the
project.
Database practitioners. Includes the set of IT professionals such as analysts, data
modelers, designers, programmers, and database administrators who design,
build, deploy, and maintain database systems.
Database system. Includes all the components that help define, design, build, and
deploy databases. A database system not only includes hardware, systems soft-
ware, DBMS, and the database, but also includes people and procedures.
DBMS (database management system). Software system to store, access, maintain,
manage, and safeguard the data in databases.
DBTG (Database Task Group). A subgroup of CODASYL responsible for devel-
oping standards for DBMSs.
Search WWH ::




Custom Search