{"product_id":"parallel-database-techniques-hardback-9780818683985","title":"Parallel Database Techniques (Hardback) 9780818683985","description":"\u003cfont face=\"Georgia\"\u003e\r\n\u003cp\u003e\u003cfont size=\"6\"\u003eParallel Database Techniques\u003c\/font\u003e\u003cbr\u003e\r\n\r\n\r\n\r\n\r\n\r\n\u003c\/p\u003e\n\u003cp\u003e\u003cfont size=\"4\"\u003eMahdi Abdelguerfi (Author), Kam-Fai Wong (Author)\u003c\/font\u003e\u003c\/p\u003e\r\n\r\n\u003cp\u003e\u003cfont size=\"3\"\u003e9780818683985, Wiley\u003c\/font\u003e\u003c\/p\u003e\r\n\r\n\u003cp\u003e\u003cfont size=\"3\"\u003eHardback, published 30 July 1998\u003c\/font\u003e\u003c\/p\u003e\r\n\r\n\u003cp\u003e\u003cfont size=\"3\"\u003e240 pages\u003cbr\u003e26.3 x 18.2 x 1.9 cm, 0.583 kg\u003c\/font\u003e\u003c\/p\u003e\r\n\r\n\r\n\r\n\r\n\r\n\u003cp align=\"justify\"\u003e\u003cstrong\u003e\u003cfont size=\"3\"\u003eThe use of parallel processing technology in the next generation of Database Management Systems (DBMSs) makes it possible to meet new and challenging requirements. Database technology in rapidly expanding new application areas brings unique challenges such as increased functionality and efficient handling of very large heterogeneous databases.\u003cbr\u003e \u003cbr\u003e Abdelguerfi and Wong present the latest techniques in parallel relational databases illustrating high-performance achievements in parallel database systems. The text is structured according to the overall architecture of a parallel database system presenting various techniques that may be adopted to the design of parallel database software and hardware execution environments. These techniques can directly or indirectly lead to high-performance parallel database implementation.\u003cbr\u003e \u003cbr\u003e The book's main focus follows the authors' engineering model: A survey of parallel query optimization techniques for requests involving multi-way joins; A new technique for a join operation that can be adopted in the local optimization stage; A framework for recovery in parallel database systems using the ACTA formalism; The architectural details of NCR's new Petabyte multimedia database system; A description of the Super Database Computer (SDC-II); A case study for a shared-nothing parallel database server that analyzes and compares the effectiveness of five data placement techniques.\u003c\/font\u003e\u003c\/strong\u003e\u003c\/p\u003e\r\n\r\n\u003cp\u003e\u003cfont size=\"3\"\u003e1 Introduction.  \u003cp\u003e1.1 Background.\u003c\/p\u003e \u003cp\u003e1.2 Parallel Database Systems.\u003c\/p\u003e \u003cp\u003e1.2.1 Computation Model.\u003c\/p\u003e \u003cp\u003e1.2.2 Engineering Model.\u003c\/p\u003e \u003cp\u003e1.3 About this Manuscript.\u003c\/p\u003e \u003cp\u003eBibliography.\u003c\/p\u003e \u003cp\u003eI: Request Manager.\u003c\/p\u003e \u003cp\u003e2 Designing an Optimizer for Parallel Relational Systems.\u003c\/p\u003e \u003cp\u003e2.1 Introduction.\u003c\/p\u003e \u003cp\u003e2.2 Overall Design Issues.\u003c\/p\u003e \u003cp\u003e2.2.1 Design a Simple Parallel Execution Model.\u003c\/p\u003e \u003cp\u003e2.2.2 The Two-Phase Approach.\u003c\/p\u003e \u003cp\u003e2.2.3 Parallelizing is Adding Information!\u003c\/p\u003e \u003cp\u003e2.2.4 Two-Phase versus Parallel Approaches.\u003c\/p\u003e \u003cp\u003e2.3 Parallelization.\u003c\/p\u003e \u003cp\u003e2.3.1 Kinds of Parallelism.\u003c\/p\u003e \u003cp\u003e2.3.2 Specifying Parallel Execution.\u003c\/p\u003e \u003cp\u003e2.4 Search Space.\u003c\/p\u003e \u003cp\u003e2.4.1 Slicing Hash Join Trees.\u003c\/p\u003e \u003cp\u003e2.4.2 Search Space Size.\u003c\/p\u003e \u003cp\u003e2.4.3 Heuristics.\u003c\/p\u003e \u003cp\u003e2.4.4 The Two-Phase Heuristics.\u003c\/p\u003e \u003cp\u003e2.5 Cost Model.\u003c\/p\u003e \u003cp\u003e2.5.1 Exceptions to the Principle of Optimality.\u003c\/p\u003e \u003cp\u003e2.5.2 Resources.\u003c\/p\u003e \u003cp\u003e2.5.3 Skew and Size Model.\u003c\/p\u003e \u003cp\u003e2.5.4 The Cost Function.\u003c\/p\u003e \u003cp\u003e2.6 Search Strategies.\u003c\/p\u003e \u003cp\u003e2.6.1 Deterministic Search Strategies.\u003c\/p\u003e \u003cp\u003e2.6.2 Randomized Strategies.\u003c\/p\u003e \u003cp\u003e2.7 Conclusion.\u003c\/p\u003e \u003cp\u003eBibliography.\u003c\/p\u003e \u003cp\u003e3 New Approaches to Parallel Join Utilizing Page Connectivity Information.\u003c\/p\u003e \u003cp\u003e3.1 Introduction.\u003c\/p\u003e \u003cp\u003e3.2 The Environment and a Motivating Example.\u003c\/p\u003e \u003cp\u003e3.3 The Methodology.\u003c\/p\u003e \u003cp\u003e3.3.1 Definition of Parameters.\u003c\/p\u003e \u003cp\u003e3.3.2 The Balancing Algorithm.\u003c\/p\u003e \u003cp\u003e3.3.3 Schedules for Reading Join Components and Data Pages.\u003c\/p\u003e \u003cp\u003e3.4 Performance Analysis.\u003c\/p\u003e \u003cp\u003e3.4.1 The Evaluation Method.\u003c\/p\u003e \u003cp\u003e3.4.2 Evaluation Results.\u003c\/p\u003e \u003cp\u003e3.5 Concluding Remarks and Future Work.\u003c\/p\u003e \u003cp\u003eBibliography.\u003c\/p\u003e \u003cp\u003e4 A Performance Evaluation Tool for Parallel Database Systems.\u003c\/p\u003e \u003cp\u003e4.1 Introduction.\u003c\/p\u003e \u003cp\u003e4.2 Performance Evaluation Methods.\u003c\/p\u003e \u003cp\u003e4.2.1 Analytical Modeling.\u003c\/p\u003e \u003cp\u003e4.2.2 Benchmarks.\u003c\/p\u003e \u003cp\u003e4.2.3 Observations.\u003c\/p\u003e \u003cp\u003e4.3 The Software Testpilot.\u003c\/p\u003e \u003cp\u003e4.3.1 The Experiment Specification.\u003c\/p\u003e \u003cp\u003e4.3.2 The Performance Assessment Cycle.\u003c\/p\u003e \u003cp\u003e4.3.3 The System Interface.\u003c\/p\u003e \u003cp\u003e4.4 The Software Testpilot and Oracle\/Ncube.\u003c\/p\u003e \u003cp\u003e4.4.1 Database System Performance Assessment.\u003c\/p\u003e \u003cp\u003e4.4.2 The Oracle\/Ncube Interface.\u003c\/p\u003e \u003cp\u003e4.5 Preliminary Results.\u003c\/p\u003e \u003cp\u003e4.6 Conclusion.\u003c\/p\u003e \u003cp\u003eBibliography.\u003c\/p\u003e \u003cp\u003e5 Load Placement in Distributed High-Performance Database Systems.\u003c\/p\u003e \u003cp\u003e5.1 Introduction.\u003c\/p\u003e \u003cp\u003e5.2 Investigated System.\u003c\/p\u003e \u003cp\u003e5.2.1 System Architecture.\u003c\/p\u003e \u003cp\u003e5.2.2 Load Scenarios.\u003c\/p\u003e \u003cp\u003e5.2.3 Trace Analysis.\u003c\/p\u003e \u003cp\u003e5.2.4 Load Setup.\u003c\/p\u003e \u003cp\u003e5.3 Load Placement Strategies Investigated.\u003c\/p\u003e \u003cp\u003e5.4 Scheduling Strategies for Transactions.\u003c\/p\u003e \u003cp\u003e5.5 Simulation Results.\u003c\/p\u003e \u003cp\u003e5.5.1 Influence of Scheduling.\u003c\/p\u003e \u003cp\u003e5.5.2 Evaluation of the Load Placement Strategies.\u003c\/p\u003e \u003cp\u003e5.5.3 Lessons Learned.\u003c\/p\u003e \u003cp\u003e5.5.4 Decision Parameters Used.\u003c\/p\u003e \u003cp\u003e5.6 Conclusion and Open Issues.\u003c\/p\u003e \u003cp\u003eBibliography.\u003c\/p\u003e \u003cp\u003eII: Parallel Machine Architecture.\u003c\/p\u003e \u003cp\u003e6 Modeling Recovery in Client-Server Database Systems.\u003c\/p\u003e \u003cp\u003e6.1 Introduction.\u003c\/p\u003e \u003cp\u003e6.2 Uniprocessor Recovery and Formal.\u003c\/p\u003e \u003cp\u003eApproach to Modeling Recovery.\u003c\/p\u003e \u003cp\u003e6.2.1 Basic Formal Concepts.\u003c\/p\u003e \u003cp\u003e6.2.2 Logging Mechanisms.\u003c\/p\u003e \u003cp\u003e6.2.3 Runtime Policies for Ensuring Correctness.\u003c\/p\u003e \u003cp\u003e6.2.4 Data Structures Maintained for Efficient Recovery.\u003c\/p\u003e \u003cp\u003e6.2.5 Restart Recovery--The ARIES Approach.\u003c\/p\u003e \u003cp\u003e6.3 LSN Sequencing Techniques for Multinode Systems.\u003c\/p\u003e \u003cp\u003e6.4 Recovery in Client-Server Database Systems.\u003c\/p\u003e \u003cp\u003e6.4.1 Client-Server EXODUS (ESM-CS).\u003c\/p\u003e \u003cp\u003e6.4.2 Client-Server ARIES (ARIES\/CSA).\u003c\/p\u003e \u003cp\u003e6.4.3 Shared Nothing Clients with Disks (CD).\u003c\/p\u003e \u003cp\u003e6.4.4 Summary of Recovery Approaches in Client-Server Architectures.\u003c\/p\u003e \u003cp\u003e6.5 Conclusion.\u003c\/p\u003e \u003cp\u003eBibliography.\u003c\/p\u003e \u003cp\u003e7 Parallel Strategies for a Petabyte Multimedia Database Computer.\u003c\/p\u003e \u003cp\u003e7.1 Introduction.\u003c\/p\u003e \u003cp\u003e7.2 Multimedia Data Warehouse, Databases, and Applications.\u003c\/p\u003e \u003cp\u003e7.2.1 Three Waves of Multimedia Database Development.\u003c\/p\u003e \u003cp\u003e7.2.2 National Medical Practice Knowledge Bank Application.\u003c\/p\u003e \u003cp\u003e7.3 Massively Parallel Architecture, Infrastructure, and Technology.\u003c\/p\u003e \u003cp\u003e7.3.1 Parallelism.\u003c\/p\u003e \u003cp\u003e7.4 Teradata-MM Architecture, Framework, and New Concepts.\u003c\/p\u003e \u003cp\u003e7.4.1 Teradata-MM Architecture.\u003c\/p\u003e \u003cp\u003e7.4.2 Key New Concepts.\u003c\/p\u003e \u003cp\u003e7.4.3 SQL3.\u003c\/p\u003e \u003cp\u003e7.4.4 Federated Coordinator.\u003c\/p\u003e \u003cp\u003e7.4.5 Teradata Multimedia Object Server.\u003c\/p\u003e \u003cp\u003e7.5 Parallel UDF Execution Analysis.\u003c\/p\u003e \u003cp\u003e7.5.1 UDF Optimizations.\u003c\/p\u003e \u003cp\u003e7.5.2 PRAGMA Facility.\u003c\/p\u003e \u003cp\u003e7.5.3 UDF Value Persistence Facility.\u003c\/p\u003e \u003cp\u003e7.5.4 Spatial Indices for Content-Based Querying.\u003c\/p\u003e \u003cp\u003e7.6 Conclusion.\u003c\/p\u003e \u003cp\u003eBibliography.\u003c\/p\u003e \u003cp\u003e8 The MEDUSA Project.\u003c\/p\u003e \u003cp\u003e8.1 Introduction.\u003c\/p\u003e \u003cp\u003e8.2 Indexing and Data Partitioning.\u003c\/p\u003e \u003cp\u003e8.2.1 Standard Systems.\u003c\/p\u003e \u003cp\u003e8.2.2 Grid Files.\u003c\/p\u003e \u003cp\u003e8.3 Dynamic Load Balancing.\u003c\/p\u003e \u003cp\u003e8.3.1 Data Access Frequency.\u003c\/p\u003e \u003cp\u003e8.3.2 Data Distribution.\u003c\/p\u003e \u003cp\u003e8.3.3 Query Partitioning.\u003c\/p\u003e \u003cp\u003e8.4 The MEDUSA Project.\u003c\/p\u003e \u003cp\u003e8.4.1 The MEDUSA Architecture.\u003c\/p\u003e \u003cp\u003e8.4.2 Software.\u003c\/p\u003e \u003cp\u003e8.4.3 Grid File Implementation.\u003c\/p\u003e \u003cp\u003e8.4.4 Load Balancing Strategy.\u003c\/p\u003e \u003cp\u003e8.5 MEDUSA Performance Results.\u003c\/p\u003e \u003cp\u003e8.5.1 Test Configuration.\u003c\/p\u003e \u003cp\u003e8.5.2 Transaction Throughput.\u003c\/p\u003e \u003cp\u003e8.5.3 Speedup.\u003c\/p\u003e \u003cp\u003e8.5.4 Load Balancing Test Results.\u003c\/p\u003e \u003cp\u003e8.6 Conclusions.\u003c\/p\u003e \u003cp\u003eBibliography.\u003c\/p\u003e \u003cp\u003eIII: Partitioned Data Store.\u003c\/p\u003e \u003cp\u003e9 System Software of the Super Database Computer SDC-II.\u003c\/p\u003e \u003cp\u003e9.1 Introduction.\u003c\/p\u003e \u003cp\u003e9.2 Architectural Overview of the SDC-II.\u003c\/p\u003e \u003cp\u003e9.3 Design and Organization of the SDC-II System Software.\u003c\/p\u003e \u003cp\u003e9.3.1 Parallel Execution Model.\u003c\/p\u003e \u003cp\u003e9.3.2 I\/O Model and Buffer Management Strategy for Bulk Data Transfer.\u003c\/p\u003e \u003cp\u003e9.3.3 Process Model and Efficient Flow Control Mechanism.\u003c\/p\u003e \u003cp\u003e9.3.4 Structure of the System Software Components.\u003c\/p\u003e \u003cp\u003e9.4 Evaluation of the SDC-II System.\u003c\/p\u003e \u003cp\u003e9.4.1 Details of a Sample Query Processing.\u003c\/p\u003e \u003cp\u003e9.4.2 Comparison with Commercial Systems.\u003c\/p\u003e \u003cp\u003e9.5 Conclusion.\u003c\/p\u003e \u003cp\u003eBibliography.\u003c\/p\u003e \u003cp\u003e10 Data Placement in Parallel Database Systems.\u003c\/p\u003e \u003cp\u003e10.1 Introduction.\u003c\/p\u003e \u003cp\u003e10.2 Overview of Data Placement Strategies.\u003c\/p\u003e \u003cp\u003e10.2.1 Declustering and Redistribution.\u003c\/p\u003e \u003cp\u003e10.2.2 Placement.\u003c\/p\u003e \u003cp\u003e10.3 Effects of Data Placement.\u003c\/p\u003e \u003cp\u003e10.3.1 STEADY and TPC-C.\u003c\/p\u003e \u003cp\u003e10.3.2 Dependence on Number of Processing Elements.\u003c\/p\u003e \u003cp\u003e10.3.3 Dependence on Database Size.\u003c\/p\u003e \u003cp\u003e10.4 Conclusions.\u003c\/p\u003e \u003cp\u003eBibliography.\u003c\/p\u003e \u003cp\u003eContributors.\u003c\/p\u003e\u003c\/font\u003e\u003c\/p\u003e\r\n\r\n\u003cp\u003e\u003cfont size=\"3\"\u003eSubject Areas: Computer networking \u0026amp; communications [\u003ca title=\"See our other books on Computer networking \u0026amp; communications\" href=\"https:\/\/freshlyprintedbooks.co.uk\/search?q=%22Computer%20networking%20\u0026amp;%20communications%20%5BUT%5D%22\"\u003eUT\u003c\/a\u003e]\u003c\/font\u003e\u003c\/p\u003e\r\n\r\n\r\n\u003c\/font\u003e","brand":"Wiley-IEEE Computer Society Pr","offers":[{"title":"Brand New","offer_id":52410724122904,"sku":"9780818683985","price":72.39,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0730\/2037\/5320\/files\/9780818683985.jpg?v=1784250194","url":"https:\/\/freshlyprintedbooks.co.uk\/products\/parallel-database-techniques-hardback-9780818683985","provider":"Freshly Printed Books","version":"1.0","type":"link"}