Spooling and buffering are the two ways by which I/O subsystems improve the performance and efficiency of the computer by using a storage space in main memory or on the disk. The basic difference between Spooling and Buffering is that Spooling overlaps the I/O of one job with the execution of another job while the buffering overlaps I/O of one job with the execution of the same job. Let us find some more differences between spooling and buffering with the help of comparison chart shown … [Read more...]
Difference Between Semaphore and Mutex
Process synchronization plays an important role in maintaining the consistency of shared data. Both the software and hardware solutions are present for handling critical section problem. But hardware solutions for critical section problem are quite difficult to implement. In today's article, we will discuss two software based solution to handle critical section problem i.e. Semaphore and Mutex. The basic difference between semaphore and mutex is that semaphore is a signalling mechanism i.e. … [Read more...]
Difference Between Microkernel and Monolithic Kernel
Kernel is the core part of an operating system; it manages the system resources. Kernel is like a bridge between application and hardware of the computer. The Kernel can be classified further into two categories, Microkernel and Monolithic Kernel. Microkernel is the one in which user services and kernel services are kept in separate address space. However, in Monolithic kernel user services and kernel services both are kept in the same address space. Let us discuss some more differences … [Read more...]
Difference Between Preemptive and Non-Preemptive Scheduling in OS
It is the responsibility of CPU scheduler to allot a process to CPU whenever the CPU is in the idle state. The CPU scheduler selects a process from ready queue and allocates the process to CPU. The scheduling which takes place when a process switches from running state to ready state or from waiting state to ready state is called Preemptive Scheduling. On the other hand, the scheduling which takes place when a process terminates or switches from running to waiting for state this kind of CPU … [Read more...]
Difference Between MySQL and PostgreSQL
In this article, we will discuss two open source database management system i.e. MySQL and PostgreSQL. Where MySQL is the product of Oracle Corporation and PostgreSQL is the product of Global Development Group. Which one is best to use? The answer to this question varies from programmer to programmer. This depends on the requirement of the application or website that a programmer is creating. Both MySQL and PostgreSQL differ in many aspects. Let us discuss the differences between MySQL and … [Read more...]
Difference Between View and Materialized View
So far, we have talked about original tables stored in the physical form in databases. In which we have access to all the attributes of the tables. What if we have to restrict a user from accessing some attributes of the table and let access the other attributes. Like, a clerk in an administrative department can search the name, address, designation, age and such other factors of an employee table. But he must not be authorized to view or access the salary of any employee. In such cases, … [Read more...]
Difference Between Strong and Weak Entity
Talking about the Strong and Weak entity, we must know what does an entity means. An entity is a unique object in the real world. It is described as the set of attributes. The collection of the same type of entities together forms the entity set. Here, we will discuss two types of entities Strong entity and Weak entity. The weak entity always depends on the strong entity for its existence. Let us discuss the differences between both, the Strong entity and weak entity with the help of … [Read more...]
Difference Between Super Key and Candidate Key
Keys are the essential elements of any relational database. It identifies each tuple in a relation uniquely. Keys are also used to establish the relationship among the tables in a schema. In this article, we will discuss two basic keys of any database that is super key and candidate key. Every candidate key is a super key but, every super key may or may not be a candidate key. There many other distinguishing factors between super key and candidate key, which I have briefly discussed in the … [Read more...]
Difference Between Relational Algebra and Relational Calculus
Relational Algebra and Relational Calculus are the formal query languages for a relational model. Both form the base for the SQL language which is used in most of the relational DBMSs. Relational Algebra is a procedural language. On the other hands, Relational Calculus is a declarative language. Relational Algebra and Relational Calculus can be further differentiated on many aspects, which I have discussed below with the help of comparison chart. Content: Relational Algebra Vs Relational … [Read more...]
Difference Between ROLAP and MOLAP
OLAP is a common term between ROLAP and MOLAP which stands for Online Analytical Processing. OLAP is a specialized tool that creates a multidimensional view of data for the user to do the analysis. ROLAP and MOLAP are two models of OLAP. Though they are different in many aspects, the most important difference between them is ROLAP provides data, directly from main data warehouse whereas, MOLAP provides data from the proprietary databases MDDBs. Let us view some more differences between … [Read more...]
- « Previous Page
- 1
- …
- 33
- 34
- 35
- 36
- 37
- …
- 48
- Next Page »