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 that were still in memory when the crash occurred. When the database is in a consistent and usable state, it has attained what is known […]
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 or corporate data. It is a means of putting in place the different form of information security controls to protect database against compromise of
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 and a registry removal, cleaner. Every PC should be installed with an anti virus, a spyware removal application back up and a registry cleanser. Some
MAINTENANCE OF COMPUTER II Read More »
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 information and most times, hardware breaks without notice. Excess heat accelerates the deterioration of the delicate circuits in the system. Dust and dirt are the
MAINTENANCE OF COMPUTER HARDWARE I Read More »
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. In a dense index, index record appears for every search key value in the file or table. That is every search key in the index
DENSE VERSUS SPARSE INDEXES Read More »
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 to the corresponding record of the actual table so that the fields not contained in the index can also be read. Index contains a value and
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 SIGNIFICANCE OF DATA MODEL (1) A well-developed data model can foster improved understanding of the organization (2) Data model helps in structuring and organizing
SS 3 Data Processing Revision Read More »