Main Memory Database Systems

Main Memory Database Systems

Author: Frans Faerber

Publisher: Foundations and Trends in Databases

Published: 2017-07-20

Total Pages: 144

ISBN-13: 9781680833249

DOWNLOAD EBOOK

With growing memory sizes and memory prices dropping by a factor of 10 every 5 years, data having a "primary home" in memory is now a reality. Main-memory databases eschew many of the traditional architectural pillars of relational database systems that optimized for disk-resident data. The result of these memory-optimized designs are systems that feature several innovative approaches to fundamental issues (e.g., concurrency control, query processing) that achieve orders of magnitude performance improvements over traditional designs. This monograph provides an overview of recent developments in main-memory database systems. It covers five main issues and architectural choices that need to be made when building a high performance main-memory optimized database: data organization and storage, indexing, concurrency control, durability and recovery techniques, and query processing and compilation. The monograph focuses on four commercial and research systems: H-Store/VoltDB, Hekaton, HyPer, and SAPHANA. These systems are diverse in their design choices and form a representative sample of the state of the art in main-memory database systems. It also covers other commercial and academic systems, along with current and future research trends.


Non-Volatile Memory Database Management Systems

Non-Volatile Memory Database Management Systems

Author: Joy Arulraj

Publisher: Springer Nature

Published: 2022-06-01

Total Pages: 173

ISBN-13: 3031018680

DOWNLOAD EBOOK

This book explores the implications of non-volatile memory (NVM) for database management systems (DBMSs). The advent of NVM will fundamentally change the dichotomy between volatile memory and durable storage in DBMSs. These new NVM devices are almost as fast as volatile memory, but all writes to them are persistent even after power loss. Existing DBMSs are unable to take full advantage of this technology because their internal architectures are predicated on the assumption that memory is volatile. With NVM, many of the components of legacy DBMSs are unnecessary and will degrade the performance of data-intensive applications. We present the design and implementation of DBMS architectures that are explicitly tailored for NVM. The book focuses on three aspects of a DBMS: (1) logging and recovery, (2) storage and buffer management, and (3) indexing. First, we present a logging and recovery protocol that enables the DBMS to support near-instantaneous recovery. Second, we propose a storage engine architecture and buffer management policy that leverages the durability and byte-addressability properties of NVM to reduce data duplication and data migration. Third, the book presents the design of a range index tailored for NVM that is latch-free yet simple to implement. All together, the work described in this book illustrates that rethinking the fundamental algorithms and data structures employed in a DBMS for NVM improves performance and availability, reduces operational cost, and simplifies software development.


Database and Expert Systems Applications

Database and Expert Systems Applications

Author: A Min Tjoa

Publisher: Springer Science & Business Media

Published: 2012-12-06

Total Pages: 566

ISBN-13: 3709175577

DOWNLOAD EBOOK

The Database and Expert Systems Application -DEXA - conferences are mainly oriented to establish a state-of-the art forum on Database and Expert System applications. But Practice without Theory has no sense, as Leonardo said five centuries ago. In this Conference we try a comprornise between these two complementary aspects. A total of 5 sessions are application-oriented, ranging from classical applications to more unusual ones in Software Engineering. Recent research aspects in Databases, such as activity, deductivity and/or Object Orientation are also present in DEXA 92, as weIl as the implication of the new "data models" such as OO-Model, Deductive Model, etc .. included in the Modelling sessions. Other areas of interest, such as Hyper-Text and Multimedia application, together with the classical field of Information Retrieval are also considered. FinaIly, Implementation Apects are reflected in very concrete fields. A total of of nearly 200 papers submitted from all over the world were sent to DEXA 92. Only 90 could be accepted. A Poster session has also been establishcd. DEXA 90 was held in Vienna, Austria; DEXA 91 in Berlin, Germany; and DEXA 92 will take place in Valencia, Spain, where we are celebrating the discovery of thc New World just five centurics ago, in Leonardo's age. Both the quality of the Conference and the compromise between Practice and Thcory are duc to the credit of all the DEXA 92 authors.


Performance Evaluation and Benchmarking

Performance Evaluation and Benchmarking

Author: Raghunath Nambiar

Publisher: Springer

Published: 2011-01-19

Total Pages: 244

ISBN-13: 3642182062

DOWNLOAD EBOOK

This book constitutes the proceedings of the Second Technology Conference on Performance Evaluation and Benchmarking, TPCTC 2010, held in conjunction with the 36th International Conference on Very Large Data Bases, VLDB 2010, in Singapore, September 13-17, 2010. The 14 full papers and two keynote papers were carefully selected and reviewed from numerous submissions. This book considers issues such as appliance; business intelligence; cloud computing; complex event processing; database optimizations; data compression; energy and space efficiency, green computing; hardware innovations; high speed data generation; hybrid workloads; very large memory systems; and virtualization.


Database Machines

Database Machines

Author: Haran Boral

Publisher: Springer Science & Business Media

Published: 1989

Total Pages: 404

ISBN-13: 9783540513247

DOWNLOAD EBOOK

This volume contains 24 papers presented at the Sixth International Workshop on Database Machines. The papers cover a wide spectrum of topics including: system architectures, storage structures, associative memory architectures, memory resident systems, deduction and retrospectives on maturing projects. The nature of the papers is highly technical and presumes knowledge of database management systems and familiarity with database machines. The book is representative of the dual trend in the field towards (1) search for new functionability and (2) attention to detail, completeness and performance of prototype implementations.


Selected Topics in Performance Evaluation and Benchmarking

Selected Topics in Performance Evaluation and Benchmarking

Author: Raghunath Nambiar

Publisher: Springer

Published: 2013-02-05

Total Pages: 222

ISBN-13: 3642367275

DOWNLOAD EBOOK

This book constitutes the refereed proceedings of the 4th TPC Technology Conference, TPCTC 2012, held in Istanbul, Turkey, in August 2012. It contains 10 selected peer-reviewed papers, 2 invited talks, a report from the TPC Public Relations Committee, and a report from the workshop on Big Data Benchmarking, WBDB 2012. The papers present novel ideas and methodologies in performance evaluation, measurement, and characterization.


ICDT '90

ICDT '90

Author: Serge Abiteboul

Publisher: Springer Science & Business Media

Published: 1990-12-03

Total Pages: 540

ISBN-13: 9783540535072

DOWNLOAD EBOOK

The emergence of new paradigms for data management raises a variety of exciting challenges. An important goal of database theory is to answer these challenges by providing sound foundations for the development of the field. This volume contains the papers selected for the third International Conference on Database Theory, ICDT'90. The conferences in this series are held biannually in beautiful European cities, Rome in 1986 and Bruges in 1988 with proceedings published as volumes 234 and 326 in the same series. ICDT'90 was organized in Paris by the Institut National de Recherche en Informatique et Automatique. The conference features 2 invited presentations and 31 papers selected from 129 submissions. The papers describe original ideas and new results on the foundations of databases, knowledge bases, object-oriented databases, relational theory, transaction management, data structures and deductive databases. The volume offers a good overview of the state of the art and the current trends in database theory. It should be a valuable source of information for researchers interested in the field.


Performance Evaluation: Origins and Directions

Performance Evaluation: Origins and Directions

Author: Günter Haring

Publisher: Springer

Published: 2003-06-29

Total Pages: 523

ISBN-13: 3540465065

DOWNLOAD EBOOK

This monograph-like state-of-the-art survey presents the history, the key ideas, the success stories, and future challenges of performance evaluation and demonstrates the impact of performance evaluation on a variety of different areas through case studies in a coherent and comprehensive way. Leading researchers in the field have contributed 19 cross-reviewed topical chapters competently covering the whole range of performance evaluation, from theoretical and methodological issues to applications in numerous other fields. Additionally, the book contains one contribution on the role of performance evaluation in industry and personal accounts of four pioneering researchers describing the genesis of breakthrough results. The book will become a valuable source of reference and indispensable reading for anybody active or interested in performance evaluation.


Database Systems For Advanced Applications '93 - Proceedings Of The 3rd International Symposium On Database Systems For Advanced Applications

Database Systems For Advanced Applications '93 - Proceedings Of The 3rd International Symposium On Database Systems For Advanced Applications

Author: S C Moon

Publisher: World Scientific

Published: 1993-03-18

Total Pages: 470

ISBN-13: 9814603767

DOWNLOAD EBOOK

This proceedings volume contains 52 technical research papers on multidatabases, distributed DB, multimedia DB, object-oriented DB, real-time DB, temporal DB, deductive DB, and intelligent user interface. Some industrial papers are also included.