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
Comments
No comments have yet been made