Distributed Database Systems
Book information
Description
Cover Distributed Database Systems Copyright Contents Preface Overview of Relational1 DBMS Concepts of Relational Databases Integrity Constraints Normalization Functional Dependencies Normal Forms Relational Algebra Selection Operation Projection Operation Union Operation Set Difference Operation Cartesian Product Operation Intersection Operation Join Operation Division Operation Relational Database Management System Chapter Summary Exercises Review of Database Systems Evolution of Distributed Database System Overview of Parallel Processing System Parallel Databases Benefits of Parallel Databases Parallel Database Architectures Parallel Database Design Data Partitioning Chapter Summary Exercises Distributed Database Concepts Fundamentals of Distributed Databases Features of a Distributed DBMS Advantages and Disadvantages of Distributed An Example of Distributed Homogeneous and Heterogeneous Distributed Functions of Distributed Components of a Distributed Date’s 12 Objectives for Distributed Database Systems Chapter Summary Exercises Overview of Computer Networking Introduction to Networking Types of Computer Networks Communication Schemes Network Topologies The OSI Model Network Protocols TCP/IP SPX/IPX NetBIOS APPC DEC net Apple Talk WAP The Internet and the World-Wide Web Chapter Summary Exercises Distributed Database Design Distributed Database Design Concepts Alternative Approaches for Distributed Database Design Objectives of Data Distribution Alternative Strategies for Data Allocation Data Fragmentation Benefits of Data Fragmentation Correctness Rules for Data Fragmentation Different Types of Fragmentation The Allocation of Fragments Measure of Costs and Benefits for Fragment Allocation Transparencies in Distributed Database Design Data Distribution Transparency Transaction Transparency Performance Transparency DBMS Transparency Chapter Summary Exercises Distributed DBMS Architecture Introduction Client/Server System Advantages and Disadvantages of Client/Server System Architecture of Client/Server Distributed Systems Architectural Alternatives for Client/Server Systems Peer-to-Peer Distributed System Reference Architecture of Distributed DBMSs Component Architecture of Distributed DBMSs Distributed Data Independence Multi-Database System Five-Level Schema Architecture of federated MDBS Chapter Summary Exercises Distributed Transaction Management Basic Concepts of Transaction Management ACID Properties of Transactions Objectives of Distributed Transaction Management A Model for Transaction Management in a Distributed System Classification of Transactions Chapter Summary Exercises Distributed Concurrency Control Objectives of Distributed Concurrency Control Concurrency Control Anomalies Distributed Serializability Classification of Concurrency Control Techniques Locking-based Concurrency Control Protocols Centralized 2PL Primary Copy 2PL Distributed 2PL Majority Locking Protocol Biased Protocol Quorum Consensus Protocol Timestamp-Based Concurrency Control Protocols Basic Timestamp Ordering Algorithm Conservative to Algorithm Multi-version to Algorithm Optimistic Concurrency Control Technique Chapter Summary Exercises Distributed Deadlock Management Introduction to Deadlock Distributed Deadlock Prevention Distributed Deadlock Avoidance Distributed Deadlock Detection and Recovery Centralized Deadlock Detection Hierarchical Deadlock Detection Distributed Deadlock Detection False Deadlocks Chapter Summary Exercises Distributed Recovery Management Introduction to Recovery Management Failures in a Distributed Database System Steps Followed after a Failure Local Recovery Protocols Immediate Modification Technique Shadow Paging Checkpointing and Cold Restart Distributed Recovery Protocols Two-Phase Commit Protocol Three-Phase Commit Protocol Network Partition Pessimistic Protocols Optimistic Protocols Chapter Summary Exercises Distributed Query Processing Concepts of Query Processing Objectives of Distributed Query Processing Phases in Distributed Query Processing Query Decomposition Query Fragmentation Global Query Optimization Join Strategies in Fragmented Relations Simple Join Strategy Semijoin Strategy Global Query Optimization Algorithms Distributed INGRES Algorithm Distributed R* Algorithm SDD-1 Algorithm Chapter Summary Exercises Distributed Database Security and Catalog Management Distributed Database Security View Management View Updatability Views in Distributed DBMS Authorization and Protection Centralized Authorization Control Distributed Authorization Control Semantic Integrity Constraints Global System Catalog Contents of Global System Catalog Catalog Management in Distributed Systems Chapter Summary Exercises Mobile Databases and Object-Oriented DBMS Mobile Databases Mobile DBMS Introduction to Object-Oriented Databases Object-Oriented Database Management Systems Features of OODBMS Benefits of OODBMS Disadvantages of OODBMS Chapter Summary Exercises Distributed Database Systems SDD-1 Distributed Database System General Architecture of SDD-1 Database System Distributed Concurrency Control in SDD-1 Distributed Query Processing in SDD-1 Distributed Reliability and Transaction Commitment in SDD-1 R* Distributed Database System Architecture of R* Query Processing in R* Transaction Management in R* The Presumed Abort Protocol The Presumed Commit Protocol Chapter Summary Exercises Data Warehousing and Data Mining Concepts of Data Warehousing Benefits of Data warehousing Problems in Data Warehousing Data Warehouses and OLTP Systems Data Warehousing Architecture Operational Data Source Load Manager Query Manager Warehouse Manager Detailed Data Summarized Data Archive/Backup Data Metadata End-User Access Tools Data Warehouse Background Processes Data Warehouse Schema Star Schema Snowflake Schema Fact Constellation Schema Data Marts Online Analytical Processing OLAP Tools Introduction to Data Mining Knowledge Discovery in Database Vs. Data Mining Data Mining Techniques Predictive Modeling Clustering Link Analysis Chapter Summary Exercises Appendix Bibliography Index
Similar books
MySQL® Notes for Professionals book
2018 · PDF
MrExcel 2022: Boosting Excel
2022 · PDF
MrExcel 2022: Boosting Excel
2022 · PDF
Session C11: Ancient Cultural Landscapes in South Europe – their Ecological Setting and Evolution, Session C22: Gardeners from South America, Session S04: Agro-Pastoralism and Early Metallurgy Sessions, Session WS29: The Idea of Enclosure in Recent Iberian Prehistory, Session C88: Rhytmes et causalites des dynamiques de l'anthropisation en Europe entre 6500 ET 500 BC: Hypotheses socio-culturelles et/ou climatiques: Proceedings of the XV UISPP World Congress (Lisbon 4-9 September 2006) / Actes du XV Congrès Mondial (Lisbonne 4-9 Septembre 2006) Vol.36
2010 · PDF
THE BRITISH ARMY IN INDIA: ITS PRESERVATION BY AN APPROPRIATE CLOTHING, HOUSING, LOCATING, RECREATIVE EMPLOYMENT, AND HOPEFUL ENCOURAGEMENT OF THE TROOPS. with AN APPENDIX ON INDIA : THE CLIMATE OP ITS HILLS ; THE DEVELOPMENT OF ITS RESODRCBS, INDUSTRY, AND ARTS ; THE ADMINISTRATION OF JUSTICE ; THE BLACK ACT ; THE PROGRESS OF CHRISTIANITY ; THE TRAFFIC IN OPIUM ; THE VALUE OF INDIA ; PERMANENT CAUSES OF DISAFFECTION, AND OF THE RECENT REBELLION ; THE TRADITIONARY POLICY; MISGOVERNMENT BY NATIVE RULERS ; ANNEXATIONS OF THEIR TERRITORY, ETC.
1858 · PDF
Idries Shah 27 Books Collection : A Perfumed Scorpion, A Veiled Gazelle, Caravan of Dreams, Darkest England, Destination Mecca, Evenings with Idries Shah, Knowing How to Know, Learning How to Learn, Letters and Lectures of Idries Shah, Neglected aspects of Sufi study, Observations, Oriental Magic, Reflections, Seeker after Truth, Special Illumination, Special Problems in the study of Sufi ideas, Sufi thought and action, Tales of the Dervishes, The Dermis Probe, The Elephant in the Dark, The Englishman Handbook, Idries Shah Antology, The Magic Monastery, The natives are restless, wisdom of the Idiots PDF.
2022 · PDF
The travels of Capts. Lewis and Clarke from St. Louis, by way of the Missouri and Columbia rivers, to the Pacific ocean; performed in the years 1804, 1805 & 1806, by order of the government of the United States. Containing delineations of the manners, customs, religion, &c. of the Indians, comp. from various authentic sources, and original documents, and a summary of the Statistical view of the Indian nations, from the official communication of Meriwether Lewis. Illustrated with a map of the country, inhabited by the western tribes of Indians
1809 · PDF
Professional Linux kernel architecture ''Wrox programmer to programmer''--Cover. - ''What you are reading right now is the result of an evolution over more than seven years: After two years of writing, the first edition was published in German by Carl Hanser Verlag in 2003. It then described kernel 2.6.0. The test was used as a basis for the low-level design documentation for the EAL4+ security evaluation of Red Hat Enterprise Linux 5, requiring to update it to kernel 2.6.18 (if the EAL acronym does not mean anything to you, then Wikipedia is once more your friend). Hewlett-Packard sponsored the translation into English and has, thankfully, granted the rights to publish the result. Updates to kernel 2.6.24 were then performed specifically for this book''--P. ix
2008 · PDF