Computing - A2 Database

HideShow resource information
  • Created by: Beth Dion
  • Created on: 23-09-13 21:26
What is Data Redundancy?
Reduces the amount of duplicated data in different files.
1 of 28
What is Data Inconsistency?
When data is stored in many files and each file has to be updated individually every time the data is changed.
2 of 28
What is a Database?
a collection og non-redundant data shareable between different applications.
3 of 28
What were problems before Databases were created?
Data Redundancy, Data Inconsitency, Program-data dependant, lack of flexibility, un-sharable data, unproductive maintenance and also Lack of security.
4 of 28
What is a DBMS?
Database Management systems are used to improve security and eliminate unproductive maintenance.
5 of 28
What is a DBMS?
It is software that is used to control access to the data.
6 of 28
What are two essential features of a DBMS?
1. Program-data independance; the storage structure is hidden from each user. 2.Restricted User Access; each user is given a limited view of the data, according to the need.
7 of 28
What is the Three Level architecture of a DBMS?
1. External/User Scheme 2. Conceptual or Logical Schema 3. Internal or Storage Schema
8 of 28
What is the External or User Schema?
Individuals view of the database
9 of 28
What is the Conceptual or Logical Schema?
Overall view wof the database, including entities, attributes and relationships.
10 of 28
What is Internal or Storage Schema?
Describes how the data will be stored.
11 of 28
What is Data storage, retrieval and update?
The DMBS must allow users to store, retrieve and update information as easily as possible. There is also Creation and Maintenance of the data dictionary
12 of 28
What is 'Managing the facilities for sharing the database'
Has to ensure that problems do not arise when two people access a record.
13 of 28
What is 'Back Up and Recovery'
Must provide ability to recover the database in event of system failures.
14 of 28
Security
Must handle password allocation and checking.
15 of 28
What is a Multi Access Database?
1. More than 1 person can use the program at the same time. 2. Users can work with databases which are stored on shared drives
16 of 28
What does 'Ensuring the integrity' mean?
Making sure that no data is accidentally lost or corrupted.
17 of 28
How does 'opening the entire database in exclusive mode' help?
It prohibits all simultaneous access. It is impractical when several users need to acess it, but will give the fastest performance because it doesnt have to search for potential confilcts.
18 of 28
How does 'Locking all the Records being modified' help?
the moment that a user opens, the software will prevent any other user opening the same table in any view that would allow updating.
19 of 28
How does 'Locking the record from being Edited' help?
The moment the user first starts typing, the record will automatically be locked so that noone else can update it
20 of 28
How does 'The user specifies no locks' help?
It is up to the software to ensure that the users are aware of the situatio, when it is being simultaneously updated by two computers.
21 of 28
How does 'Open a table in Read Only mode' help?
If you dont need to update a table, but look at a record, you can avoid conflict by opening it in Read Only mode.
22 of 28
What is Deadlock?
When two users attempt to update two related records in the same table. The DBMS must recognise this and abort one of the users tasks, to allow the other to proceed.
23 of 28
What are software protection techniques?
1. Name Identify 2. Each will have a password 3. Encryption
24 of 28
What are Open Systems?
Open systems provide a standard to which applications are written to allow portability to multiple systems. The portability is Key.
25 of 28
What is an ODBC (Open Database Community)
ODBC is a standard for accessing different database systems. It provides a means of accessing data help in one type of database. The ODBC translates requests into the correct format for aparticular source. It is extremely useful.
26 of 28
What is a Client Server Database?
DMBS client software runs on individual workstations. The advatanges of these are an expernsive resource can be available to large number of users , client stations can also update thedatabase, communication between client and server is minimised.
27 of 28
What are Object Orientated Databases?
They offer DBMS facilities with object-orientated programming. Data stored as objects can only be interpreted using the methods specified by its class.
28 of 28

Other cards in this set

Card 2

Front

What is Data Inconsistency?

Back

When data is stored in many files and each file has to be updated individually every time the data is changed.

Card 3

Front

What is a Database?

Back

Preview of the front of card 3

Card 4

Front

What were problems before Databases were created?

Back

Preview of the front of card 4

Card 5

Front

What is a DBMS?

Back

Preview of the front of card 5
View more cards

Comments

No comments have yet been made

Similar Computing resources:

See all Computing resources »See all Databases resources »