Pennsylvania State University 3 credits ETI
Today, most enterprise databases are no longer a centralized data store that is accessed by thousands of users from multiple locations which may be globally situated. These databases are typically web-based and distributed across multiple sites for availability, low latency and better reliability. This course exclusively focuses on the design and system issues related to such distributed database systems. An initial review of relational DBMS is required in the first week of the course. Students will learn the architectural options and design issues and choices for DDBMSs. Design considerations include fragmentation alternatives (vertical or horizontal), fragment allocation and the data directory. Database integration covers at schema matching, integration, and mapping. Data cleaning is also studied under database integration. Processing distributed queries is challenging, and this topic is studied next by first trying to understand the query processing problem followed by: the objectives for query processing, characterization of query processors and layers of query processing. Query decomposition and localization of distributed data is then studied. The next issue is the problem of optimizing distributed queries using various techniques such as centralized query optimization, join ordering in distributed queries and distributed query optimization using dynamic, static. Semi-join and hybrid approaches. The ACID properties of transactions are studied and different types of transactions, and this is followed by distributed concurrency control using techniques such as locking, timestamps, and optimistic concurrency control algorithms. Deadlock management which is a problem in concurrency control schemes is also studied. Distributed reliability to address failures in DDBMSs is addressed by studying local reliability protocols, distributed reliability protocols, dealing with site failures and network partitioning. Data replication is an important aspect of reliability and various replication update management strategies and replication protocols are studied. Modern databases are web-based and this topic is considered next. Topics studied include: web searches, web querying and distributed XML processing. Many databases have moved to the cloud and cloud data management covers: cloud deployment models, service models SQL data services, and so on.
Our subject experts help with essays, research papers, case studies, discussion posts, and capstone projects for these programs β written from scratch to your course requirements.
Program and course information is reproduced from each university's published academic catalog for informational purposes and may change. Always confirm current requirements with your university. We are an independent academic support service and are not affiliated with or endorsed by the universities listed.
Expert guides on essay writing, citation styles, study skills, and academic success.
View All Articles
Learn how to write a good research question for a paper. Narrow your topic, identify a research problem, and create a focused question with practical examples.
Learn how to choose a research topic you can actually research. Discover how to narrow broad ideas, find reliable sources, and develop a focused research question.
Learn how to cite sources in a research paper using APA, MLA, and Chicago styles, with in-text citation examples and reference-list tips.