BBIT 432 CISY 423 Advanced Database Systemsf (1).doc - KENYA METHODIST UNIVERSITY NAME Judith Kwamboka Makori TRIMESTER 3nd Trimester 2015 ADM NO

BBIT 432 CISY 423 Advanced Database Systemsf (1).doc -...

This preview shows page 1 - 4 out of 5 pages.

KENYA METHODIST UNIVERSITY NAME: Judith Kwamboka Makori TRIMESTER: 3 nd Trimester 2015 ADM NO: BIT-1705-1/2014 COURSE CODE: CISY 423/ BBIT 432 /BSIS 315 SYSTEMS Lecturer Email: [email protected] : Email a soft copy and H/Copy to Computer Science Department office 1
Image of page 1
1. Explain the following concepts ( 8marks) ACID (Atomicity, Consistency, Isolation, Durability) ACID properties are set of properties that ensure a dependable, mistake free and predictable database exchange. It implies a more secure exchange. Serial scheduling this is successive with no exchange cover in time Interleaved execution is the of a short exchange with a long exchange ordinarily permits the short exchange to finish rapidly. 2PL Two-Phase Locking All locks held by an exchange are discharged when the exchange is finished. 2. Define the term deadlock and outline the two main methods of dealing with a deadlock problem. (3 marks) Deadlock is a circumstance where two or more exchanges sitting tight for locks on some information things which are secured by different exchanges an incongruent mode. The routines for managing arrangement lock issue is to get one of the Transactions and move back the same and guaranteeing that guarantees that the framework never enters a stop state. 3. Explain the following concepts 8 Marks) a) Partial Transaction this an atomicity by fixing the activities of halfway recording of logs. b) RAID this is an innovation lets stockpiling professionals store the same information in better places on various circles. c) Crash Recovery this is a Start from a checkpoint (discovered by means of expert record). 2
Image of page 2
4. Describe Data Warehousing and Mining Architecture (8Marks). An information distribution center is a social database that is intended for question and investigation instead of for exchange preparing. It for the most part contains authentic information got from exchange information, yet can incorporate information from different sources. Information stockrooms separate examination workload from exchange workload and empower an association to unite information from a few sources. A typical method for acquainting information warehousing is with allude to the qualities of an information distribution center as put forward by William In mon`: Subject Oriented, Integrated, Nonvolatile and Time Variant. Information distribution centers and
Image of page 3
Image of page 4

You've reached the end of your free preview.

Want to read all 5 pages?

  • Summer '15

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern

Stuck? We have tutors online 24/7 who can help you get unstuck.
A+ icon
Ask Expert Tutors You can ask You can ask You can ask (will expire )
Answers in as fast as 15 minutes
A+ icon
Ask Expert Tutors