LIS 505 - Database management

database management systems

keys

RDBMSs

Short for relational database management systems. A type of database management system that stores data in the form of related tables. The most common type of database management system.

object-oriented database management systems

OODBMS or ODBMS for short. Database management systems that support storing of data as objects, including some support for object classes and inheritance of class properties and methods by subclasses and their objects. whatis.com.

data integrity

Validity of data because it has not been corrupted by such causes as human error, errors in transmission, bugs or viruses in software, hardware malfunctions, or natural disasters.

referential integrity

A RDBMS feature that prevents the entry of data that are inconsistent between tables.

query languages

Specialized languages for requesting information from databases.

SQL

Short for structured query language. A standard query language used for retrieving data from a variety of databases.

query by example

QBE for short. A method of forming database queries in which spaces are displayed for fields and users can enter conditions for each field.

reports

Formatted and organized presentations of data. Usually distinguished from forms, which are designed to allow editing as well.

locking

Making a file or other unit of data inaccessible. Many database management systems support locking of both files and individual records.

read only

Readable, but not accessible for modification or deletion. GEEK.com

character fields

Fields for entering one or more characters. ComputerUser

numeric fields

Fields for entering numbers. ComputerUser

date fields

Fields for entering dates. ComputerUser

Other specialized types of field include logical (or Boolean).

design view

A view used in Microsoft Access for creating and modifying the design of objects such as tables, forms, and reports.

datasheet view

A simple view used in Microsoft Access for displaying and modifying the contents of tables.

data warehouses

Collections of data designed to support management decision making, often produced by combining several existing databases.

data mining

Looking for hidden patterns in groups of data.
Home

Last updated October 29, 2002.
This page maintained by Prof. Tim Craven
E-mail (text/plain only): craven@uwo.ca
Faculty of Information and Media Studies
University of Western Ontario,
London, Ontario
Canada, N6A 5B7