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 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 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 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 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 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 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 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 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 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 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 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…