Woldia University, School of Computing: Advanced Database Systems Final Exam (40%)
Uploaded by
tesfa mikaelWoldia University, School of Computing: Advanced Database Systems Final Exam (40%)
Uploaded by
tesfa mikaelCommon questions
Powered by AIOperating system-level security measures provide a critical layer of protection by regulating access controls, encrypting file systems, and isolating processes to prevent unauthorized access. While these measures are effective in mitigating the risk of breaches, they must be complemented by additional security layers to address network and application-specific vulnerabilities .
The recovery manager is integral to restoring a database to its original state after a crash. It works in conjunction with other components like the buffer manager to ensure data is correctly saved and retrieved from memory. The recovery manager performs tasks such as logging changes and coordinating rollbacks to maintain data integrity .
Database security comprises multiple layers, including physical, operating system, and application-level security. Each layer addresses specific risks, like physical breaches, software vulnerabilities, and unauthorized data access. In combination, they form a comprehensive security posture that protects data from unauthorized access, theft, and disasters .
Advancements such as relational and object-oriented database management systems have driven the evolution of distributed database systems by providing robust frameworks that support complex data structures and network communication. This progress has led to enhanced data consistency, reliability, and performance across distributed environments, facilitating scalability and real-time data access .
Horizontal fragmentation can lead to improved query performance by storing only relevant rows at each site, reducing data transfer. However, it might complicate query processing. Vertical fragmentation stores subsets of columns, optimizing access patterns and storage space but potentially increasing complexity in query recombination. Both approaches improve manageability but require careful execution and monitoring for effective maintenance .
Query processing can result in inefficient strategies if the conversion from a high-level SQL query to execution plans does not optimize for performance, such as improperly handling join operations or indexing. This can lead to increased processing time and resource consumption, slowing down the database performance significantly .
Domain integrity ensures data reliability by enforcing that each attribute in a table has a set of allowed values, preventing any entries that do not conform to the specified domain. This prevents errors and maintains consistency across the database, crucial for accurate data analysis and reporting .
Distributed Database Management Systems (DDBMS) manage a distributed DB and make the distribution transparent to the user by handling the complex coordination required to keep data consistent, reliable, and easily accessible across multiple sites .
Password hashing involves transforming plain text passwords into a hash, often with added salts, making it difficult for attackers to reverse-engineer passwords if they access the database. These methods effectively enhance security by ensuring that even if data is compromised, sensitive information remains protected .
Mixed fragmentation, combining both horizontal and vertical strategies, enhances flexibility by allowing data retrieval to be tailored to specific application needs, improving efficiency. Efficient access paths are created through customization based on localized needs, which optimizes processing and reduces communication costs across distributed systems .