Data Warehouse

Data Warehouse

Major purpose of this lecture is to explain on Data Warehouse. Data warehouse is a collection of methods, techniques and tools used to support knowledge workers—senior managers,…
Parallel DBMS

Parallel DBMS

General objective of this lecture is to describe on Parallel DBMS. Parallel database systems combine database management and parallel processing in order to deliver high-performance and high-availability…
Distributed Deadlock Management

Distributed Deadlock Management

Prime objective of this lecture is to explain on Distributed Deadlock Management. In a database environment, a deadlock is a situation when transactions are endlessly waiting for…
Transparencies in DDBMS

Transparencies in DDBMS

Basic objective of this lecture is to describe on Transparencies in DDBMS.  Transparency refers to the separation of the high-level semantics of a system from lower-level…
Lecture on Database System Architectures

Lecture on Database System Architectures

Principle purpose of this lecture is to explain on Database System Architectures. Here briefly discuss on Centralized Systems, Client–Server Systems, Transaction Server System and Data-server systems. Centralized database systems are those…
FD and Normalization

FD and Normalization

General objective of this lecture is to present on FD (Functional Dependency) and Normalization. Here explain how to control the redundancy of data and how to preserve the…
Indexing and Hashing

Indexing and Hashing

Main objective of this lecture is to describe on Indexing and Hashing.  An index for a file in a database system works in much the same…
Network Security

Network Security

Principle purpose of this lecture is to explain on Network Security. Here briefly explain on introduction to Cryptography, Substitution Ciphers, Transposition Ciphers, One-Time Pads and Two Fundamental Cryptographic Principles. This…
The Application Layer

The Application Layer

Main objective of this lecture is to explain on the Application Layer. General portion of Application Layer is DNS –Domain Name System; here focus on the DNS…
The Transport Layer

The Transport Layer

Prime purpose of this lecture is to describe on the Transport Layer. Here major focus on to explain Services Provided to the Upper Layers, Transport Service Primitives…
Network Layer

Network Layer

Major purpose of this lecture is to present Network Layer Design Issues. These Design Issues are: Store-and-Forward Packet Switching, Services Provided to the Transport Layer, Implementation of Connection-Oriented Service…
The Medium Access Control Sublayer

The Medium Access Control Sublayer

Basic purpose of this lecture is to present Medium Access Control Sublayer. Here major focus on the Channel Allocation Problem: Static Channel Allocation in LANs and MANs…
Load More