DATABASE SYSTEM CONCEPTS LCPO
7th Edition
ISBN: 9781265586577
Author: SILBERSCHATZ
Publisher: MCG
expand_more
expand_more
format_list_bulleted
Expert Solution & Answer
![Check Mark](/static/check-mark.png)
Want to see the full answer?
Check out a sample textbook solution![Blurred answer](/static/blurred-answer.jpg)
Students have asked these similar questions
Suppose you need to sort a relation of 50 gigabytes, with 4 kilobyte blocks, using a memory size of 40 megabytes. Suppose the cost of a seek is 4 milliseconds, while the disk transfer rate is 50 megabytes per second.
a. Find the cost of sorting the relation, in seconds, with bb = 100
b. How many merge passes are required?
Suppose you need to sort a relation of 40 gigabytes with 4-kilobyte blocks using a memory size of 40 megabytes. Suppose the cost of a seek is 5 milliseconds, while the disk transfer rate is 40 megabytes per second.
a. Find the cost, in seconds, of sorting the relation with bb = 1 and with bb = 100.
b. In each case, how many merge passes are required?
c. Suppose a flash storage device is used instead of a disk, and it has a seek time of 1 microsecond and a transfer rate of 40 megabytes per second. Recompute the cost, in seconds, of sorting the relation with bb = 1 and with bb = 100.
Suppose you need to sort a relation of 40 gigabytes, with 4-kilobyte blocks,using a memory size of 40 megabytes. Suppose the cost of a seek is 5 milliseconds, while the disk transfer rate is 40 megabytes per second. Suppose a flash storage device is used instead of a disk, and it has a latency of 20 microsecond and a transfer rate of 400 megabytes per second. Recompute the cost of sorting the relation, in seconds, with bb = 1 and with bb = 100, in this setting.
Chapter 15 Solutions
DATABASE SYSTEM CONCEPTS LCPO
Knowledge Booster
Similar questions
- Suppose you need to sort a relation of 40 gigabytes, with 4-kilobyte blocks,using a memory size of 40 megabytes. Suppose the cost of a seek is 5 milliseconds, while the disk transfer rate is 40 megabytes per second. Find the cost of sorting the relation, in seconds, with bb = 1 and with bb = 100.arrow_forwardConsider a file of 16384 records. Each record is 32 bytes long and its key field is of size 6 bytes. The file is ordered on a non-key field, and the file organization is unspanned. The file is stored in a file system with block size 1024 bytes, and the size of a block pointer is 10 bytes. If the secondary index is built on the key field of the file, and a multilevel index scheme is used to store the secondary index, the number of first-level and second-level blocks in the multilevel index are respectivelyarrow_forwardSuppose that one block in a disk can store either 8 records or 16 key pointers. If a database contains 1024 records, how many blocks do we need to store the data file and the dense index Parrow_forward
- We have a database file with ten million pages (N = 10,000,000 pages), and we want to sort it using external merge sort. Assume that the DBMS uses quicksort for in- memory sorting. Let B denote the number of buffers. What is the smallest number of buffers B that the DBMS can sort the target file using only four passes?arrow_forwardQ4. Suppose we have the following relations: R(A,B,C) and S(D,E,F). Assume that R uses 500 blocks on disk, and S uses 6,000 blocks. Assume that you got the best possible hash function and there are no overflows for the hash. Assuming that there are 102 blocks of memory space for query processing, what is the least cost (in terms of disk block IOs) for partition hash join for the query R JOINC=D S?arrow_forwardConsider a file with a secondary dense index structure on a non-ordering key field where 120,000 records stored on a disk with block size of 2048 bytes. Length of every record is of fixed and un-spanned. Record size is 150 bytes. Also consider, every record of index file is 20 bytes long. Now assume every block access requires 0.015 second. Can you measure the average improvement in time?arrow_forward
- Consider the block size (B) = 512 bytes for the student information table. A file has 40000 employee records of fixed length. Each record has the following fields:Name (50 bytes) SID (10 bytes) and address (41 bytes). Assume that unspanned organization is used to store records and SID takes block pointer 6 bytes. Suppose that the file is ordered by the key field SID and we want to construct a primary index ( sparse) on SID. Calculate the record size R in bytes and find the number of block access required to retrieve a record from the file using binary searcharrow_forwardGiven B+-tree with height of two (two levels of internal nodes plus a level of leaf nodes). The order of each internal node is 40 and the order of each leaf node is 36. On the average, each node is 75% full. How many disk blocks are currently used for the given B+-tree index? How many records are being stored in the data file which is covered by the given B+-tree?arrow_forwardSuppose a file with 65536 records is organized using multi-level indexing as the file is ordered on a non-key field. Each record is 48 bytes long and the size of its key field is 4 bytes. The indexing is built on the key field of the file. The size of the disk block is 2 KB, and the block pointer size is 12 bytes. The file organization is unspanned. How many blocks will be required for the inner and outer index respectively in a multi-level index? 512 and 2 b) 512 and 4 e) 1024 and 4 d) 1024 and 8arrow_forward
- For Heap File with a page directory, assume that a page can contain up to 100 directory entries and a page can contain 1000 records, for a file of 1,000,000 records, what is the number of pages to store these records, assuming that on average data pages are filled up 70%? With this data page utilization, what is the number of pages to store the directory, assuming that each directory page is full? Assuming both the directory and the file are stored on disk, what is the I/O cost to insert one record in worst case, and in the average case?arrow_forwardThe CSM Tech organization has a substantial web presence with several publicly accessible web and application servers. You have DNS servers that handle Internet queries for all your publicly accessible resources. However, after doing some statistics analysis on your public DNS servers, you find that your servers are handling recursive lookups for clients that are not within your organization. Your public DNS servers should handle recursive queries only for your internal clients, but the servers should handle iterative (nonrecursive) queries from external sources. What do you recommend? What are the commands needed to implement the solution?arrow_forwardProblem 7 1. Find a recurrence relation for the number of bit strings of length n that contain three consecutive Os. 2. What are the initial conditions? 3. How many bit strings of length seven contain three consecutive Os?arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Database System ConceptsComputer ScienceISBN:9780078022159Author:Abraham Silberschatz Professor, Henry F. Korth, S. SudarshanPublisher:McGraw-Hill EducationStarting Out with Python (4th Edition)Computer ScienceISBN:9780134444321Author:Tony GaddisPublisher:PEARSONDigital Fundamentals (11th Edition)Computer ScienceISBN:9780132737968Author:Thomas L. FloydPublisher:PEARSON
- C How to Program (8th Edition)Computer ScienceISBN:9780133976892Author:Paul J. Deitel, Harvey DeitelPublisher:PEARSONDatabase Systems: Design, Implementation, & Manag...Computer ScienceISBN:9781337627900Author:Carlos Coronel, Steven MorrisPublisher:Cengage LearningProgrammable Logic ControllersComputer ScienceISBN:9780073373843Author:Frank D. PetruzellaPublisher:McGraw-Hill Education
![Text book image](https://www.bartleby.com/isbn_cover_images/9780078022159/9780078022159_smallCoverImage.jpg)
Database System Concepts
Computer Science
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:McGraw-Hill Education
![Text book image](https://www.bartleby.com/isbn_cover_images/9780134444321/9780134444321_smallCoverImage.gif)
Starting Out with Python (4th Edition)
Computer Science
ISBN:9780134444321
Author:Tony Gaddis
Publisher:PEARSON
![Text book image](https://www.bartleby.com/isbn_cover_images/9780132737968/9780132737968_smallCoverImage.gif)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:9780132737968
Author:Thomas L. Floyd
Publisher:PEARSON
![Text book image](https://www.bartleby.com/isbn_cover_images/9780133976892/9780133976892_smallCoverImage.gif)
C How to Program (8th Edition)
Computer Science
ISBN:9780133976892
Author:Paul J. Deitel, Harvey Deitel
Publisher:PEARSON
![Text book image](https://www.bartleby.com/isbn_cover_images/9781337627900/9781337627900_smallCoverImage.gif)
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781337627900
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning
![Text book image](https://www.bartleby.com/isbn_cover_images/9780073373843/9780073373843_smallCoverImage.gif)
Programmable Logic Controllers
Computer Science
ISBN:9780073373843
Author:Frank D. Petruzella
Publisher:McGraw-Hill Education