StudentShare
Contact Us
Sign In / Sign Up for FREE
Search
Go to advanced search...

Database Systems Concepts - Essay Example

Cite this document
Summary
Disk scheduling algorithms are complex beasts. They include approaches like FCFS, SSTF, SCAN, LOOK, C-SCAN and C-LOOK, and numerous designs and permutations of these various approaches. A RAM disk and a hard-disk scheduling design will be totally different, as RAM itself needs almost no scheduling…
Download full paper File format: .doc, available for editing
GRAB THE BEST PAPER94.8% of users find it useful
Database Systems Concepts
Read Text Preview

Extract of sample "Database Systems Concepts"

Download file to see previous pages

In addition, RAM is usually much smaller in size, about two to three orders of magnitude being frequent. (A rig that I know of has 8 Gigs of RAM and 2 terabytes of hard drive space, and the owner has room to expand to over 5 terabytes, which is roughly a three order of magnitude difference). Scheduling is almost entirely unnecessary. There is a need to compare the RAM disk and the main memory disk-cache, but this doesn't affect the choice of a scheduling algorithm for the hard drive because they are totally different systems and because scheduling on the RAM disk is only looking for buffer cache misses not main memory requests.

Hard-disk scheduling considerations are totally different. Hard disks are much larger and they are not read constantly, and the head positioning must jump in order to handle different reads. The file system does store recently used blocks in a buffer cache in main memory, but this is only a partial time-saving maneuver. Caches have finite sizes and need to be purged constantly; in any respect, no one sticks to only a few things in cache. They are constantly opening up new pages, documents and programs, which requires accessing different parts of the disk.

This means that scheduling for hard-disk use is at a premium: Indeed, one of the main slowing forces in Moore's Law exponentiation is the relatively anemic growth of hard-drive scanning speeds versus the memory size of hard drives. Different hard disk scheduling regimes have different benefits. When designing a scheduling algorithm, it is important to bear in mind parameters of functionality. These include power consumption, throughput, response time, flexibility for the end-user, and other factors.

Again, the cache can only do so much in mitigating these problems, so the choice of how to approach hard disk scheduling has many inherent tradeoffs. One approach is FCFS, or First Come First Served. In this algorithm, operations are conducted in the order requested. This is very simple and elegant in many ways. However, the problem is that not all functions are made equal: Some functions, like Ctrl-Alt-Delete on a Windows computer or dealing with security threats, need to be scanned first. FCFS therefore doesn't have the costs of reordering the work queue, but it doesn't have the benefits either.

FCFS cannot have starvation: Every request is serviced. But the performance is poor: It doesn't distinguish between the importance of needs, nor does it have any smart geography. If a end user wants to run six programs from every different side of the disk, FCFS will go in order, crossing immense redundant space and thus leading to slowdown. SSTF, on the other hand, prioritizes geography of the desk. It goes to the closest location on the disk first, no matter what. Again, this has the problem that there is no discrimination for important tasks.

Scan time is reduced, but starvation is possible: The head could stay in one sector of the disk for too long if too many requests come in. Direction switches also slow things down. SCAN goes from the outside to inside then the inside to outside. This has the advantage of being a uniform pattern and reducing variance, but it does lead to a lot of unnecessary scans (though not more scan time) which can be a power consumption issue. LOOK is a bit smarter: It stops going a direction where no requests exist.

C-SCAN and C-LOOK use cylinders instead of a simple directional approach. This has the adv

...Download file to see next pages Read More
Cite this document
  • APA
  • MLA
  • CHICAGO
(“Database Systems Concepts Essay Example | Topics and Well Written Essays - 750 words - 2”, n.d.)
Retrieved from https://studentshare.org/environmental-studies/1408212-database-systems-concepts
(Database Systems Concepts Essay Example | Topics and Well Written Essays - 750 Words - 2)
https://studentshare.org/environmental-studies/1408212-database-systems-concepts.
“Database Systems Concepts Essay Example | Topics and Well Written Essays - 750 Words - 2”, n.d. https://studentshare.org/environmental-studies/1408212-database-systems-concepts.
  • Cited: 0 times

CHECK THESE SAMPLES OF Database Systems Concepts

Object Database Management System

Object database management systems added the notion of persistence to object programming languages.... This is essentially a way of understanding a system in terms of those components and characteristics that are common to all systems.... We use the term system here in a very specific sense; although one that has much broader application than just computer systems.... But in general systems theory, a system is rather more than just anything that shows a degree of organization....
8 Pages (2000 words) Essay

Database Design Proposal

This proposal aims at designing a database for a health organization.... Therefore, a database system that keeps proper track of all the activities of the facility is necessary.... The tool used for the database management will be SQL.... From this scenario, it is obvious that the database needed to safeguard information of the health center must be efficient.... This means that the same data could be stored severally in different platforms of the organization's database....
3 Pages (750 words) Article

Database Security

The paper "database Security" states that generally, database security needs stem from the requirement to protect data.... The DBMSs provide an interface that enables users to interact with the database itself, other applications for capturing and analyzing data (Oppel, 2004).... database security is concerned with aspects aimed at protecting the contents of the database, users and owners.... The protection ranges from system protection against software and hardware malfunction to intentional and unauthorized use of the database and unintentional access by entities not authorized....
12 Pages (3000 words) Coursework

Management Decision Support Systems

It further aims to reflect on the development of models and analytical concepts for use of DSS in e-commerce platform.... Decision Support systems (DSS) have gradually developed as computer based interactive systems that help users in effectively communicating, sharing of data and essential documents and also the needed knowledge to help in solving potential problems.... The Decision Support systems… DSS are required to be considered as essential support systems in decision making activities....
15 Pages (3750 words) Essay

How Are Program Libraries Concatenated

In the paper “How Are Program Libraries Concatenated?... rdquo; the author analyzes a definition for ISF panels that are stored in the PDS.... The program libraries are concatenated using different types of statements, which comprise of three forms of statements, that is, DD, JOB, and EXEC....
8 Pages (2000 words) Assignment

The Concept and Benefits of the Database System

The concept and benefits of the database system are explained with a detailed analysis of the commercial and non-commercial purposes … Exposure to a case study has finalized the database concepts that are required in a business scenario to capture the information and make good of all the aligning features and technologies provided by the database management systems in order to learn and master the concepts for future benefits to emerge as a database designer   Optimization of queries is done to access multi-dimensional data....
20 Pages (5000 words) Essay

Managing Information for Competitive Advantages

In order to manage these information organizations have developed information systems.... Today there are several information systems such as MIS, DSS, and ESS which help managers to make more appropriate and efficient decisions for their organizations.... In organizational context information system refers to the systems of keeping a record of all the data, computer technologies for processing those data and people involved in the whole process....
8 Pages (2000 words) Research Paper

Advanced Database Systems

This paper "Advanced database systems" discusses some legal and ethical issues that need to be considered when introducing a distributed database system.... Moreover, the term of the distributed database system (DDBS) is normally utilized to state both distributed database systems as well as distributed database management system.... Normally, a distributed database is a group of data divided into the different divisions under the management of disconnected database management systems (DBMSs) executing on autonomous computer platforms or systems....
10 Pages (2500 words) Research Paper
sponsored ads
We use cookies to create the best experience for you. Keep on browsing if you are OK with that, or find out how to manage cookies.
Contact Us