Already have an account? Get multiple benefits of using own account!
Login in your account..!
Remember me
Don't have an account? Create your account in less than a minutes,
Forgot password? how can I recover my password now!
Enter right registered email to receive password!
Question :
Object-Oriented Database (OODM) is defined as a logical data model that captures the semantics of objects supported in object-oriented programming. An Object-Oriented Database or OODB is defined as a persistent and sharable collection of objects defined by an OODM.
(i) OODBMSs were developed due to some of the inadequacies of the existing database technology. One of the inadequacies refers as Impedance mismatch problem. Explain what is meant by impedance mismatch, in the context of relational database system.
(ii) Give example of Four Advanced Database Applications and discuss their general characteristics. Explain why these applications are not suitable for a relational database.
(iii) Define each of the following concepts in the context of an object-oriented data model:
a. Abstraction. b. Objects and attributes. c. Methods and messages. d. Classes, subclasses and superclasses.
Two Phase Locking (2PL) The two-phase locking protocol having of two phases: Phase 1 : The lock acquisition phase : If a transaction T needs to read an object, it wants to
Saving Derived Attributes to Avoid Re-computation Data that is derived from other data should be stored in the computed form to avoid re-computation. For this, we could define
Representing complex relationship among data A database may contain varieties of data interrelated to each other in numerous ways. A DBMS must have the capability to represent
What is vertical fragmentation? Vertical fragmentation divides the relation by decomposing the scheme R of relation r.
What do you understand by RAID? Explain RAID Level 4 and Level5? RAID - It is stands for Redundant Array of Inexpensive Disks (as named by the inventor), or alternatively Re
Consider the following relational scheme: R (a,b,c,d,e,f) and its corresponding set of FDs {d→ a, be → c, ac → e, b → f, f → d, a → c}. a. Is the following decomposition i) non
Define average seek time. The average seek time is the average of the seek times, calculated over a sequence of random requests.
Explain cursors in SQL? Cursors in SQL - An object used to store the output of a query for row-through-row processing through the application programs. Cursors are constructs
Benefits of using heuristics
what are the reasons having variable length records
Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!
whatsapp: +91-977-207-8620
Phone: +91-977-207-8620
Email: [email protected]
All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd