Database terminology

database terminology

?
  • Created by: Vicky
  • Created on: 27-12-12 16:08

Database

A database is the term to describe the storage of data

1 of 15

Flat file database

This is the most basic/ simplistic way of storing data,a flat file database is a single table with data in it.

2 of 15

Relational database

A relational database is a large collection of data items with links between them. It is structured in a way that allows it to be accessed by a number of different application programs.

3 of 15

Distributed database

A distrubuted database is a singular database that is under the control of a DBMS where the storage devices are not all attached to a common processor. Instead the data is stored in storage devices attached to multiple computers located across a network.

4 of 15

Database management systen (DBMS)

Software that accesses data within a database

5 of 15

Nomalisation

A staged (mathimatical) process, which removes repeated groups of data and inconsistencies.

6 of 15

Data independence

This means that data and programs are stored seperately from each other.

7 of 15

Data integrity

The data that is stored in the database is reasonable as it has not been accidently or maliciously altered. (in other words, the extent to which the data is truthful in representing the original information presented)

8 of 15

Data redundancy

This means that the data is duplicated unnecessarily

9 of 15

An entity

This is an object, person or thing that is represented in a database, e.g. customer, order, product

10 of 15

An attribute

This is information that is held about an entity, this is known as an attribute.

11 of 15

Entity relationship diagrams

This type of diagram is used to show how entities are related to each other

12 of 15

Data consistency

When data is held in more than one file, when it should be stored in a consistent way

13 of 15

Data mining

This is the process in which you interrogate large amounts of data, looking for potential patterns.

14 of 15

Data warehousing

Data warehousing refers to large amounts of data that are stored together, usually in a single location for further processing

15 of 15

Comments

No comments have yet been made

Similar ICT resources:

See all ICT resources »See all Databases resources »