CRASH RECOVERY
Crash recovery is the process by which the database is moved back to a consistent and usable state. This is done by rolling back incomplete transactions and completing committed transactions… Read More »CRASH RECOVERY
SS 3 Data Processing (1st Term)
DATABASE SECURITY
DEFINITION OF DATA SECURITY Data security is the practice of keeping data protected from corruption and unauthorized access. The focus behind data security is to ensure privacy while protecting personal… Read More »DATABASE SECURITY
MAINTENANCE OF COMPUTER II
Maintenance is highly essential in order to prolong its contributing functionality. SOFTWARE MAINTENANCE The maintenance of programs inside the computer system such as virus, a spyware removal, back up software… Read More »MAINTENANCE OF COMPUTER II
MAINTENANCE OF COMPUTER HARDWARE I
Maintenance of computer hardware is a way of taking care, repairing and replacing broken and failing computer hardware. Maintenance is necessary on computer to avoid hardware failure or loosing valuable… Read More »MAINTENANCE OF COMPUTER HARDWARE I
DENSE VERSUS SPARSE INDEXES
DENSE INDEX This is said to be dense if it contains (at least) one data entry for every search key value that appears in a record in the indexed file.… Read More »DENSE VERSUS SPARSE INDEXES
INDEXES
INDEXES An Index is a copy of database table that has been reduced to certain fields and the copy is always in sorted form. The index also contains a pointer… Read More »INDEXES
SS 3 Data Processing Revision
DEFINITION OF DATA MODEL Is the process of structuring and organizing data. TYPES OF DATA MODELS (1) Flat (2) Hierarchical (3) Network (4) Relational (5) Object-Relational and (6)Star Schema… Read More »SS 3 Data Processing Revision