Start Discovering Solved Questions and Your Course Assignments
TextBooks Included
Active Tutors
Asked Questions
Answered Questions
what is called a query evaluation plana sequence of primitive operations that can be used to assess a query is a query evaluation plan or a query
what is called an evaluation primitivea relational algebra operation annotated with instructions on how to evaluate is known as an evaluation
what is called query processingquery processing refers to the range of activities included in extracting data from a
what is a hash indexa hash index organizes the search keys with their associated pointers into a hash file
what is a b-tree indexa b-tree index takes the form of a balanced tree in which each path from the root of the root of the root of the tree to a leaf
what is b-treea b-tree eliminates the redundant storage of search-key values it permits search key values to appear only
what are called multilevel indicesindices with two or more levels are known as multilevel
what are the two types of indicesthe two types of indices are-a dense indexb sparse
what are called index-sequential filesthe files that are ordered sequentially with a primary index on the search key are known as index-sequential
what is a primary indexa primary index is an index whose search key also explains the sequential order of the
what is known as a search keyan attribute or set of attributes used to look up records in a file is known as a search
normal 0 false false false en-in x-none x-none microsoftinternetexplorer4
what is known as clustering file organizationin the clustering file organization records of several dissimilar relations are stored in the similar
what is hashing file organization in the hashing file organization a hash function is computed on some attribute of every record the result of the
what is known as sequential file organization in the sequential file organization the records are kept in sequential order according to the value of
what is known as heap file organizationin the heap file organization any record can be placed anywhere in the file where there is space for the
what are the two types of blocks in the fixed -length representation define themanchor block have the first record of a chainoverflow block have the
what is the use of a slotted-page structure and what is the information are there in the headerthe slotted-page structure is used for organizing
what are the ways in which the variable-length records arise in database systemsstorage of many record types in a filerecord types that permit
define hot swappinghot swapping permits the removal of faulty disks and changes it by new ones without turning power off hot swapping decreases the
what is meant by software and hardware raid systemsraid can be executed with no change at the hardware level using only software modification such
what are the factors to be taken into account when choosing a raid levela monetary cost of extra disk storage requirementsb performance requirements
what are the two main goals of parallelismload -balance multiple small accesses so that the throughput of such accesses enhances parallelize
what is called block-level stripingblock level striping stripes blocks across many disks it treats the array of disks as a large disk and provides