Consider a database system based on a client-server architecture, with the server acting as a data server. A. What is the effect of the speed of the interconnection between the client and the server on the choice between tuple and page shipping? B.. If page shipping is used, the cache of data at the client can be organized either as a tuple cache or a page cache. The page cache stores data in units of a page, while the tuple cache stores data in units of tuples. Assume tuples are smaller than pages. Describe one benefit of a tuple cache over a page cache.

Consider a database system based on a client-server architecture, with the server acting as a data server. A. What is the effect of the speed of the interconnection between the client and the server on the choice between tuple and page shipping? B.. If page shipping is used, the cache of data at the client can be organized either as a tuple cache or a page cache. The page cache stores data in units of a page, while the tuple cache stores data in units of tuples. Assume tuples are smaller than pages. Describe one benefit of a tuple cache over a page cache.

Systems Architecture

7th Edition

ISBN:9781305080195

Author:Stephen D. Burd

Publisher:Stephen D. Burd

Chapter12: Secondary Storage Management

Section: Chapter Questions

Problem 6RQ

See similar textbooks

Similar questions

In unit eight, we are introduced to advanced database topics. In typical client–server systems the server machine is much more powerful than the clients; that is, its processor is faster, it may have multiple processors, and it has more memory and disk capacity. Consider instead a scenario where client and server machines have exactly the same power. Would it make sense to build a client–server system in such a scenario? Why? Which scenario would be better suited to a data-server architecture? Database systems are in use everywhere in our society. Explain the advantages of cloud computing over the traditional IT model (Table 10.1) and reference 2 additional websites.
Consider a server with two clients running independent multi-threaded databases. Client 1 has paid for 75% of the available CPU resources, while Client 2 has paid for 25%. How would you ensure that each client got their requested (paid for) share of CPU resource?
Big Data Parallel database systems store replicas of each data item (or partition) onmore than one node.a. Why is it a good idea to distribute the copies of the data items allocatedto a node across multiple other nodes, instead of storing all the copiesin the same node (or set of nodes).b. What are the benefits and drawbacks of using RAID storage instead ofstoring an extra copy of each data item?
Assume that a database system is installed on a server with 3 core processors. You want your query to run on multiple processors so that each processor accesses in parallel a subset of the database. Or, you might set up your system in a way that partitions your query so that each part of the same query runs on a different processor. Explain, with an example, how a query might be broken apart so that each parallel processor handles a subset of the query
In the process of the creation of Elementary data connection protocols, what assumptions have been made?
Parallel database systems store replicas of each data item (or partition) onmore than one node.a. Why is it a good idea to distribute the copies of the data items allocatedto a node across multiple other nodes, instead of storing all the copiesin the same node (or set of nodes).b. What are the benefits and drawbacks of using RAID storage instead ofstoring an extra copy of each data item?
Think about a database architecture for an airline that uses snapshot isolation. Explain an instance of non serializable execution that the airline is willing to accept in the sake of increased performance.
Take, for example, a snapshot-isolated database management system like the one employed by an airline. I was wondering if you could provide me an example of a non-serializable execution that the airline is willing to endure in exchange for greater speed.
An airline database that takes advantage of "snapshot isolation" might serve as a good starting point for this illustration. Consider the possibility that a non-serializable execution improved the airline's performance instead of a serial one.
Consider 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 respectively
Consider an operating system that uses 48-bit virtual addresses and 16KB pages. The system uses a hierarchical page table design to store all the page table entries of a process, and each page table entry is 4 bytes in size. What is the total number of pages that are required to store the page table entries of a process, across all levels of the hierarchical page table?
With the emergence of more complex data structures, how are serialization techniques evolving to ensure depth-first or breadth-first traversal?