Advanced Database · Unit 4 · 12 hrs
Distributed Databases, NOSQL Systems, and BigData
Exam-focused notes for Distributed Databases, NOSQL Systems, and BigData (Advanced Database, CSC475): what the TU syllabus asks and how it has actually been tested, with 12 solved past questions from this unit.
What this unit covers
- Distributed Database Concepts and Advantages
- Data Fragmentation, Replication and Allocation Techniques for Distributed Database Design
- Types of Distributed Database Systems
- Distributed Database Architectures
- Introduction to NOSQL Systems
- The CAP Theorem
- Document-based, Key-value Stores, Column-based, and Graph-based Systems
- BigData
- MapReduce
- Hadoop
Distributed Database Architectures
Explain different distributed database architectures. What is data fragmentation?[10]
A distributed database system (DDBS) is a collection of logically interrelated databases distributed over a computer network, where data is stored across multiple nodes and managed as a single unified system. --- In a homogeneous distributed database system...
Full solved answer →The CAP Theorem
What is the CAP theorem? Explain. [5]
The CAP Theorem (also known as Brewer's Theorem) is a theoretical framework in distributed database systems. CAP stands for: - C - Consistency - A - Availability - P - Partition Tolerance The theorem states that a distributed database system can guarantee a...
Full solved answer →Write short notes on a. CAP Theorem b. Deductive database [5]
CAP Theorem is a theoretical framework in distributed database systems. CAP stands for: - C - Consistency - A - Availability - P - Partition Tolerance CAP Theorem states that a distributed database system can only guarantee at most two out of the following ...
Full solved answer →BigData
What is Big Data? What are its 3 V’s? [5]
--- Big Data refers to extremely large and complex datasets that cannot be processed, stored, or analyzed using traditional data management tools and conventional database systems within a reasonable amount of time. Big Data encompasses data that is generat...
Full solved answer →Write short notes on: a) Big data b) Information retrieval [5]
--- Big Data refers to extremely large and complex datasets that cannot be managed, processed, or analyzed using traditional database management tools and techniques within a reasonable time frame. Property Description ----------------------- Volume Massive...
Full solved answer →MapReduce
Write short notes on: a) Map Reduce b) Multimedia database [5]
--- MapReduce is a programming model and processing framework designed for processing and generating large datasets in a distributed computing environment. It allows parallel processing of massive amounts of data across a cluster of computers. MapReduce wor...
Full solved answer →Distributed Database Concepts and Advantages
Why distributed database is important? What is transparency? Explain different types of transparencies in distributed databases.[10]
--- A distributed database is a collection of multiple, logically interrelated databases distributed over a computer network. It is important for the following reasons: Organizations are naturally distributed over several geographic locations. A distributed...
Full solved answer →Define distributed database. What are the benefits of using distributed databases over centralized database? Explain availability, reliability, and scalability features of distributed databases.[10]
--- A distributed database is a collection of logically interrelated data that is physically stored and managed across multiple geographically dispersed locations (nodes/sites), connected through a computer network. Although the data resides at different ph...
Full solved answer →Data Fragmentation, Replication and Allocation Techniques for Distributed Database Design
Define fragmentation. Explain horizontal fragmentation with an example. [5]
Fragmentation is the process of dividing a database into smaller, manageable pieces called fragments, which can be stored at different physical locations in a distributed database system. Each fragment contains a subset of the data from the original relatio...
Full solved answer →Why fragmentation is carried out? Difference between horizontal and vertical fragmentation. [5]
Fragmentation is the process of dividing a relation (table) into smaller subsets called fragments, which are then distributed across different nodes in a distributed database system. It is carried out for the following reasons: - Improved Performance: Data ...
Full solved answer →Introduction to NOSQL Systems
What are the characteristics of NOSQL Systems? [5]
NoSQL (Not Only SQL) systems are alternatives to traditional relational databases designed to handle large-scale, flexible, and high-performance data management. The key characteristics of NoSQL systems are as follows: --- NoSQL systems do not require a fix...
Full solved answer →Why NOSQL system is essential? What are the different characteristics of this system? [5]
NoSQL (Not Only SQL) systems have become essential due to the limitations of traditional relational database systems (RDBMS) in handling modern data challenges. The key reasons are: 1. Handling Big Data: Modern applications (social media, e-commerce, IoT) g...
Full solved answer →Make Unit 4 stick
Practice CSC475 with flashcards & quizzes