ite ch.11

Database

integrated collection of logically related tables

Data mining

used to search data warehouses

Record

A collection of related fields such as a person's name, address, and age.

Attribute

A data field that represents a description or characteristic of some entity.

primary key

A field that uniquely identifies each record.

Pointers

A network database utilizes these special connections between nodes that allow multiple connections between records.

SQL

Analysis tools that support viewing all or selected parts of data, querying the database, and generating reports include query-by-example as well as specialized programming language called _______.

network database

Each child node may have more than one parent node

redundancy

Having several instances of the same data is called data _______.

integrity

If Mr. Smith's bike has been sent to his new address, but the bill to his old one, it can most likely be attributed to a lack of data _______.

real-time processing

In _______, data is processed at the same time the transaction occurs.

batch processing

In _______, transactions are collected over time and then processed all at once.

Hierarchical

In this database model, the fields or records are structured in nodes.

Database Management System (DBMS)

Software that enables users to create, modify, and gain access to data

Company

The combined information presents on this type of database can be used to change the whole merchandising strategy of a store.

Individual

The data and the DBMS are stored either on the user's hard-disk drive or on a LAN file server in these databases.

Object-oriented databases

These databases store not only data but also instructions to manipulate the data.

Commerical

These types of databases are also called information utilities or data banks.

Relational

This type of database is organized into many tables with common data items (key fields) linking the tables to one another.

Physical view

Which view of data deals with how the data is actually formatted and located?

Table

collection of related records

Logic view

data is organized into groups or categories

Data warehouse

databases is stored in this special type of database.

Field

group of related characters